Listing Tools

EXCEPTIONAL OPPORTUNITY to BUY UPDATED CUSTOM ESTATE HOME & EQUESTRIAN Property on 25 ACRES in DESIRABLE HAYMARKET! STUNNING & DIVINE Grounds!! RARE .25mile paved and private tree lined driveway. Southern Living CHARM at its FINEST with the 10 x 40 ft HIGH PERFORMANCE maintenance free decking to watch the sunset over the Bull Run Mountains. Main House includes 5BR/3.5 Baths loaded with UPSCALE finishes. Travertine marble and PRISTINE hardwood floors throughout. Guest suite over garage w/kitchenette rough-in. INSPIRING outdoor living includes in-ground heated black gunite POOL and JACUZZI, custom hand stacked stone and brick patios surrounded by ENCHANTING gardens. Kitchen RENOVATION includes updated cabinets, new SS appliances including WOLF convection double ovens, induction cooktop, and popular light granite. TRANQUIL Master Retreat includes hardwood floors, large walk-in closet and GRAND master spa bath w/ Frameless Shower, stone slipper tub, new vanity w/ granite countertops and lighting. EQUESTRIAN LOVERS DREAM includes 8-Stall barn, lighted dressage riding ring, 8000+ft of fencing, 3-run-in sheds, chicken coups, fire-pit and SO MUCH MORE. RURAL CRESCENT 10ACRE Site Work and BUILD OPP*DON T MISS OUT OF THIS GREAT INVESTMENT OPPORTUNITY. Schedule your SHOWING today!!

Property Details of 3209 Ingram Drive

Property Details

Interior Features

Exterior Features

Community

Finance

Other Details

Map Location

Driving Directions

Listed by Kerri Bryn Ralston of Pearson Smith Realty,LLC

Listing Sold by Corcoran McEnearney

Copyright 2026 BRIGHT, All Rights Reserved.  Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Funkhouser Real Estate Group participates, and is provided by BRIGHT through a licensing agreement. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.Data last updated June 10, 2026. Some properties which appear for sale on this website may no longer be available because they are under contract, have Closed or are no longer being offered for sale.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Funkhouser Real Estate Group. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.