Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

2002 Mustang Ct , Frederick, MD 21702
$775,000
Est. Payment: $4,255.60/mo
4 Bed
5 Bath
4448 Sqft
0.16 Acres
Status: pending | Days on site: 9
Get Pre-Qualified
LNG276 - 88853
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

OPEN HOUSE CANCELLED Why wait for new construction when you can quickly move into this home built last year? Discover a luxurious lifestyle in this stunning Colonial home nestled in the desirable Tuscarora Creek community. This residence boasts four spacious bedrooms and five elegantly designed bathrooms. The gourmet kitchen, complete with upgraded countertops, a walk-in pantry and a large island, seamlessly flows into the inviting two-story great room, perfect for entertaining. Enjoy cozy evenings by the gas fireplace or unwind on the charming maintenance free porch overlooking beautifully landscaped surroundings. The partially finished basement features a huge family room with walk-out access to the back yard and has a full bath and two large storage areas so you can ditch your expensive storage units! Community amenities include a sparkling outdoor pool, a club house, playgrounds, and scenic walking paths, enhancing your everyday living experience. With modern appliances including gas cooking and thoughtful security features, this home combines comfort and sophistication, making it the perfect sanctuary for those seeking an exclusive lifestyle.

Highlights

Listed by Christine R Reeder , 3016068611 Long & Foster Real Estate, Inc. , 3016441086. Bright MLS

Property Type

Residential

Lot/Acreage
0.16

HOA Fee

89 Monthly

Year Built

2025

County

Frederick

Neighborhood

Tuscarora Creek

School District

Frederick County Public Schools

Listing ID

MDFR2089000

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:5
Appliances:Built-In Microwave, Dishwasher, Disposal, Dryer, Exhaust Fan
Air Cond:Ceiling Fan(s),Central A/C
Fireplaces:Gas/Propane,1 Fireplace
Floor:Carpet,Ceramic Tile,Luxury Vinyl Plank
Above Ground Sq Ft:3502
Below Ground Sq Ft:946
Basement:Connecting Stairway,Daylight,Partial,Full,Heated,Improved,Interior Access,Outside Entrance,Partially Finished,Rear Entrance,Walkout Stairs
Other:
  • ▪ Additional:Attic, Bathroom - Stall Shower, Bathroom - Tub Shower, Bathroom - Walk-In Shower, Breakfast Area, Carpet, Ceiling Fan(s), Combination Kitchen/Dining, Dining Area, Family Room Off Kitchen, Floor Plan - Open, Formal/Separate Dining Room, Kitchen - Eat-In, Kitchen - Gourmet, Kitchen - Island, Pantry, Primary Bath(s), Recessed Lighting, Sprinkler System, Upgraded Countertops, Walk-in Closet(s)
Water:Public

Exterior Features

Lot:Not New Construction,Horse Property: No,In City Limits
Garage Capacity:6
Zoning:R
Roof:Architectural Shingle
Others:
  • ▪ Additional:Exterior Lighting, Sidewalks, Excellent, Pool - Outdoor, Tot Lots/Playground, Jog/Walk Path, Common Area Maintenance, Pool(s), Recreation Facility
Sewer:Public Sewer
Parking Features:Asphalt Driveway,Paved Driveway,Secure Parking,Garage - Front Entry,Garage Door Opener,Inside Access,Attached Garage,Driveway,Off Street,On Street,4+ Spaces,3+ Spaces,2+ Spaces,1+ Spaces
Principal Interest
$4,256
Taxes
$1,255
HOA
$89

Home Price

$775,000

Loan Details

30 yrs
7.312%

Down Payment

20%
$155,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$4,255.60

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $4,255.60 $1,254.67 $89.00 $5,599.26
Yearly $51,067.16 $15,056.00 $1,068.00 $67,191.16
Total $1,532,014.93 $451,680.00 $32,040.00 $2,015,734.93
Lender profile image
Chico Gordy
Test
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Frederick, MD).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Bright MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-11-14T07:10:58.000Z

© 2026 Bright MLS