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 = 2874 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 2874 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 2874 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

5501 Wyndemere Circle
Mineral, VA 23117

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3427
Agency: Lake Anna Island Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Envision your new lifestyle in this stunning quality built, Lake Anna water access retreat with Xfinity Comcast High Speed Internet. Located on the public side of the lake, in the coveted Wyndemere Subdivision and within walking distance to one of the common areas. Boat slips are available for lease in the neighborhood so be sure to bring your boat for sunny lake days ahead and lots of memories! This spacious 4 bedroom, 3.5 bath home with a hobby room (could be used as a 5th bedroom) offers over 3,600 square feet with beautiful hardwood floors, a gorgeous covered side porch, exquisite stone patio, 6 person hot tub and a fenced in back yard! New HVAC August 2023. On the main level experience the family room with hardwood flooring, crown molding, gas fireplace and a Rinnai gas wall heater for those chilly days. The kitchen features SS appliances and a breakfast bar that is open to the dining area. A laundry room and half bath complete the main level (washer and dryer convey)! Upstairs you'll find french doors to the spacious primary ensuite that showcases vaulted ceilings, a gas fireplace, a brand new Mr Cool split unit, new carpet, a large walk thru closet, jetted tub, tile shower and double vanity. There are two additional bedrooms, a large loft and full bath on the second level. The finished basement offers a family room/rec room, 4th bedroom, full bath, utility room and an additional room that could be used as a 5th bedroom or hobby room (3 bedroom septic). Unwind in the evenings on the expansive covered side porch that has a TV that conveys, ceiling fan and retractable shades. Gather around the FIRE PIT or relax in the HOT TUB! The fenced in back yard is perfect for kids and pets! There is also a shed with electric that conveys! Paved driveway and two car finished garage. Wyndemere offers three common areas where you'll enjoy basketball, tennis, a boat ramp and boat slips are available for lease on a yearly basis. Come see for yourself and fall in love. Golf cart friendly community! This home has SO MANY RECENT UPGRADES and IMPROVEMENTS. INVESTORS: Lake Anna was recently named the nation's TOP short term vacation "beach" rental location, and this property would make a fantastic investment asset. Wyndemere Subdivision on Lake Anna does allow short term rentals! **See MLS documents for full list of improvements and items that can convey** Septic was just recently inspected!
MlsNumber: VASP2019588


Listing Provided By: Lake Anna Island Realty, original listing
Name: Lake Anna Island Realty
Phone: (540) 894-4400
Office Name: Lake Anna Island Realty
Office Phone: (540) 894-4400
Agent Name: Ashley Hoffman
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 = 2874 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Londie Blesi
Londie Blesi
ASCIIColdwell Banker Elite
Call Today!: (804) 433-9989

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App