Listing Tools

ONCE in a LIFETIME OPPORTUNITY! The Estates of Piedmont's ICONIC and COVETED 5900 Flynnsbrooke Terrace in Haymarket's Award-Winning Gated Golf Resort Community. This STATELY 6BR/8 Bath nearly 9000 sq.ft., ALL BRICK Home on 1.37 LUSH PREMIUM Acres is situated on one of the communities most DESIRABLE & COVETED lots. LOADED with EXTRAS and UPGRADES! These SELLER's have invested over $500K from the Covered Pavilion with Stacked STONE Wood Burning Fireplace and Outdoor TV Hookup, to the LUXURIOUS Ritz Carlton Inspired WET Bar in the basement that includes a Sub Zero 86 Bottle Temperature Controlled Wine Fridge and Dual REFRIGERATOR Drawers, Additional Beverage Fridge, Dedicated Ice Maker, Dishwasher, Built-In TV and Soft Close UPGRADED Cherry Cabinetry! Down to the CUSTOM GARAGE Flooring and Cabinetry System this ESTATE HOMES features are UNMATCHED! The 9+ Foot Ceilings throughout all levels make this SWEEPING OPEN Floor Plan an absolute DIME. The Light Filled and EXPANSIVE Great Room has been extended 4-Feet which extends all 3 levels includes COFFERED Ceiling, Gas Fireplace, GRANDIOSE Chandelier, Built-In Home Media Console Center, and Rear Owner's Staircase. The Great Room is OPEN to the Chef's GOURMET Kitchen w/ Maple Decora Cabinetry and COMMERCIAL GRADE Appliances like Sub Zero and Thermador. The SOLARIUM off the kitchen includes heated floors and direct access to the IMPRESSIVE Outdoor Living, Covered Patios and Water Features. The Main Level includes 2 Half Baths, Arrival Room with Heated Floors, Main Level Study, Parlor, Embassy Sized Formal Dining Room w/ Rear Foyer and Butler's Pantry w/ Additional Beverage Fridge and Granite Wet Bar. A light filled Side Conservatory on the NORTH WING is perfect to COZY up to READ or RELAX After Dining. All SPACIOUS UPPER Level Bedrooms include Walk-In-Closets and EN-SUITE Full Baths. The Primary Suite includes TRAY Ceiling, Sitting Room, Outdoor Covered Balcony, Custom Walk-in Closet, Dual Granite Vanities, Heated Floors, Soaking Tub and Shower w/ Dual Shower Heads. You will surely be pleased with the CONVENIENCE of the EXPANDED UPPER LEVEL Laundry Suite with New Washer/Dryers (2019). The 3,000 sq. Ft. Finished DREAM Basement includes a Large Media/TV Room, Billiards Area, 6th Bedroom, Wine Tasting Room, Home Gym/Hobby Rooms and 2 Full Baths. EXCEPTIONAL outdoor living with METICULOUS Landscaping, 19 zone Irrigation System, Covered Walk-Up, Multiple Patios, Pavilion, and ORNAMENTAL Exterior Home and Landscaping Lighting in front and back. Complete Interior/Exterior Audio System. Buyer Peace-of-Mind w/ 4-Zone HVAC (2012/2015) . Added insulation on all 3 levels. New Roof (2016), Water Heater (2013), pre-wired for BACKUP Generator, Multiple Redundant Sump Pumps w/ Battery Backup. If you believe you deserve the finest, then this OPPORTUNITY is for you!

Property Details of 5900 Flynnsbrooke Terrace

Property Details

Interior Features

Exterior Features

Community

Finance

Other Details

Map Location

Driving Directions

Listed by John E Grzejka of Pearson Smith Realty,LLC

Listing Sold by RE/MAX Gateway

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.