Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2911 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2911 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2911 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

10513 Wildbrooke
Spotsylvania, VA 22551

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 6
Baths: 4
Status: Active
SqFt: 4560
Agency: Century 21 New Millennium

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Exquisite Custom Energy Efficient Fawn Lake Home Sited on a Premium 16th Arnold Palmer Golf Hole! This Meticulously Maintained Home Boasts 6 bedrooms, 4 full bathrooms with Over 7,500 sq ft on 3 levels and Dual Staircases to the Upper Level. This Property Has Over $200k in Upgrades in the Last 12 Months! With Gleaming Hardwood Floors Throughout the Entire 2 Floors! A Grand Foyer Welcomes You with 2-Story Tiled Entry Leading into the Cozy Living Room and the Grand 2-Story Family Room Which Features a Gas Fireplace and French Doors to Your Very Own Backyard Oasis! The Gourmet Kitchen/Dining Area Features a Fireplace , Large Breakfast Bar Island and Top-of-The-Line Energy Efficient Stainless Steel Appliances Including a Mini Wine Fridge and a Pantry! The Main Level Primary Suite Offers a Walk-in Closet, Dual Custom Sinks, and Luxurious Spa-Like Bath with a Separate Glass Enclosed Shower and Separate Soaking Tub. Additionally, The Main Level Also Boasts Your Choice of a Home Office or a 2nd To Code Bedroom With a Full Bathroom and the Laundry Room! Four more Upper Level Spacious Bedrooms with 2 Full Baths. Then, the Potential is Endless with the Walk-Up Unfinished Over 3,000Sqft Lower Level, Perfect for Movie Nights or Game Days. You Can Finish the Lower Level as You Wish, This Level also Features a Rough-in For a Full Bath. Beyond the Stunning Interior, This Expansive Property Boasts a Private Fenced Backyard with A huge Custom Covered Deck with Two Outdoor Wood Faux Ceiling Fans and Screened in Porch Overlooking the 16th Hole Golf Course. **Major Upgrades Done for You in the Last 12 Months Costing Over $200k to Include **GAF Ultra HD Architectural Roof 50 year GAF Golden Pledge For Labor and Material and a 25 year of Workmanship (Transferable), **Carrier 4 Ton GreenSpeed Dual Fuel System For the Main/Lower Level and **Upper Level has Carrier 2 Ton GreenSpeed Dual Fuel System, **75 Gallon Power Vent/ Direct vent Water Heater. **Full house 26kW Guardian Air-Cooled Generator with Three Automatic Smart 200 amp Transfer Switches and Two Power Surge Protectors. **Entire House Painted. **Kitchen has New Samsung with WiFi Hub/Tv Refrigerator, Samsung Dual Oven/Microwave, Samsung Range and a Duel zone wine cooler! **GE Profile washer and dryer. **Maytag Industrial Dishwasher. **Full security system with Outdoor Cameras and Door Ring bell. Full List of Other Upgrades in MLS Docs!
MlsNumber: VASP2023914


Listing Provided By: Century 21 New Millennium, original listing
Name: Century 21 New Millennium
Phone: (703) 753-7910
Office Name: CENTURY 21 New Millennium
Office Phone: (540) 373-2000
Agent Name: Ali Nawaz
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2911 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Anette Ellis
Anette Ellis
ASCIICTI Real Estate
Call Today!: (571) 212-9406

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App