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

19370 Magnolia Grove Square
Leesburg, VA 20176

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,888
Beds: 2
Baths: 2
Status: Active
SqFt: 1180
Agency: Dulles North Ventures, LLC, dba Keller Williams Re

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2002
Notes: Have you been waiting for a comfortably cozy condo in the premier resort style community of Lansdowne Woods but are tired of paying for other people's personalized decor and updates that are not to your liking? Welcome home to 19370 Magnolia Grove Sq 203! Priced to allow you to change flooring, paint the walls and add your special touches while the original timeless upgrades of this impeccably maintained condo provide the perfect backdrop. Step into this 1180 sq ft home and notice the inviting Ashby floor plan. The white on white kitchen features Corian counters, 42 inch cabinets, ceramic cooktop, microwave, single wall oven, range hood, side by side refrigerator , and black and white motif vinyl flooring. The open bar allows you to visit with family and friends in the adjoining living and dining rooms while enjoying the treed view beyond the glass enclosed balcony. Down the hall, a pocket door hides the large walk in laundry/storage room. The main bedroom at the end of the hall has a dressing area, 2 fantastic walk in closets and a large ensuite bathroom. The 2nd bedroom offers flexibility to be whatever you wish. Remember in this Magnolias South building, there is a rentable guest suite so you can have company stay there. This home comes with an additional storage room in the building because we know you have stuff! Schedule your tour today! Lansdowne Woods is truly a one of a kind 55+ community in Loudoun County with a restaurant, vibrant clubhouse full of activities, recreation and fitness areas. The proximity to INOVA Loudoun hospital, shopping, dining, metro, and Dulles Airport are just icing on the cake!
MlsNumber: VALO2064912


Listing Provided By: Dulles North Ventures, LLC, dba Keller Williams Re, original listing
Name: Dulles North Ventures, LLC, dba Keller Williams Re
Phone: (703) 430-9008
Office Name: Keller Williams Realty
Office Phone: (703) 430-9008
Agent Name: Kim Spear
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App