Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Flanagan Realty
Property view

42104 Fremont Preserve Sq, 
Aldie, VA 20105

$724,900


3

Beds


4

Baths


2,758

Sq Ft


Townhouse

Coming Soon

Listed by

Bishal Karki

Ikon Realty

Last updated:

September 27, 2025, 01:40 PM

MLS#

VALO2107290

Source:

BRIGHTMLS

About This Home

42104 Fremont Preserve Sq

Stunning 3-Level Brick Front Townhome with 2-Car Garage in a Prime Location This beautifully maintained freshly painted brick-front townhome offers three spacious levels of comfort and modern upgrades. Featuring hardwood floors in the living and dining rooms, a charming front bay window, and an updated kitchen with granite countertops, tile backsplash, and tile flooring. French doors open to a deck with stairs leading to a fully fenced backyard—perfect for outdoor entertaining. The light-filled living room is enhanced by oversized windows and smart-home features, including a Nest thermostat, Ring doorbell, smart ceiling fans, and a smart door lock system. Upstairs, the expansive primary suite boasts an attached office/sunroom, walk-in closet, and a luxurious bath with a soaking tub, double vanities, and a separate shower. The sitting area off the primary bedroom offers even more space to relax. Built-in speakers throughout create a seamless audio experience. Laundry is conveniently located on the bedroom level, and each room is equipped with ceiling fans with remote controls. The fully finished walkout lower level includes a large family room, gas fireplace with a beautiful mantle, recessed lighting, and a dedicated home theater setup with built-in speakers and discreet wiring—ideal for movie nights. Living in Stone Ridge North means enjoying far more than just a beautiful home. The neighborhood features playgrounds—one right outside your door and two more within walking distance—along with the Gum Spring Library and nearby medical offices, including pediatric care. Residents also have access to Stone Ridge’s outstanding amenities, including three community pools, a clubhouse, and a fully equipped gym, all designed to foster a vibrant, welcoming, and family-friendly atmosphere. This home blends modern convenience with community living—schedule your tour today!

Home Facts

Townhouse

4 Baths

3 Bedrooms

Built in 2004

Price Summary

724,900

$262 per Sq. Ft.

MLS #:

VALO2107290

Last Updated:

September 27, 2025, 01:40 PM

Added:

9 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

4

Full Bathrooms:

2

Interior

Living Area:

2,758 Sq. Ft.


Structure

Structure

Building Area:

2,758 Sq. Ft.

Year Built:

2004


Lot

Lot Size (Sq. Ft):

2,613


Finances & Disclosures

Finances

Price:

$724,900

Price per Sq. Ft:

$262 per Sq. Ft.

Source:BRIGHTMLS
The information being provided by Bright MLS is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2025 Bright MLS All rights reserved.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.