REALTY2U, INC
ACTIVE
$1,599,990
6 bd   
6 ba  
1 half ba
   6,530 SQFT
23754 GREAT BEND LN
ALDIE, VA 20105
ACTIVE
$1,594,990
4 bd   
4 ba  
1 half ba
   4,820 SQFT
23303 LANSING WOODS LN #H
ALDIE, VA 20105
ACTIVE
$1,629,990
4 bd   
4 ba  
1 half ba
   4,504 SQFT
23303 LANSING WOODS LN #D
ALDIE, VA 20105
ACTIVE
$1,699,990
4 bd   
4 ba  
1 half ba
   4,290 SQFT
23307 LANSING WOODS LN #C
ALDIE, VA 20105
ACTIVE
$1,799,990
4 bd   
4 ba  
1 half ba
   4,820 SQFT
23307 LANSING WOODS LN #H
ALDIE, VA 20105
ACTIVE
$1,419,990
5 bd   
4 ba  
1 half ba
   4,549 SQFT
46 WALKING WOODS LN #BARLEAU
ALDIE, VA 20105
ACTIVE
$1,349,990
4 bd   
3 ba  
1 half ba
   3,729 SQFT
44 WALKING WOODS LN #BELMONT II
ALDIE, VA 20105
ACTIVE
$2,054,467
6 bd   
5 ba  
1 half ba
   5,376 SQFT
23385 WALKING WOODS LN
ALDIE, VA 20105
ACTIVE
$2,199,467
6 bd   
5 ba  
1 half ba
   5,376 SQFT
23385 WALKING WOODS LN
ALDIE, VA 20105
ACTIVE
$1,210,950
5 bd   
6 ba  
1 half ba
   3,646 SQFT
23436 SWEET MAGNOLIA CT
ALDIE, VA 20105
ACTIVE
$1,009,995
5 bd   
3 ba  
1 half ba
   3,110 SQFT
23475 PARKSIDE VILLAGE CIR
ALDIE, VA 20105
ACTIVE
$1,065,870
5 bd   
4 ba  
1 half ba
   3,516 SQFT
41817 MENHADEN WAY
BRAMBLETON, VA 20148
ACTIVE
$959,990
4 bd   
3 ba  
1 half ba
   3,008 SQFT
408 ORCHARD GROVE DR #CALEDON
BRAMBLETON, VA 20148
ACTIVE
$1,244,990
5 bd   
4 ba  
1 half ba
   4,235 SQFT
412 ORCHARD GROVE DR #GRAYSON
BRAMBLETON, VA 20148
ACTIVE
$1,174,990
4 bd   
3 ba  
1 half ba
   3,263 SQFT
410 ORCHARD GROVE DR #STONE
BRAMBLETON, VA 20148
Database last updated  09/11/2024 07:29 PM
 
For Sale Listings
Rental Search
Find a Home
Minimum Sale Price
Maximum Sale Price
ADVANCED SEARCH OPTIONS
New Search
Search powered by
© Bright MLS. All rights reserved.
Listings provided by Bright MLS from various brokers who participate in IDX (Internet Data Exchange). Information deemed reliable but not guaranteed.

Mayura Gupte, Principal Broker®
REALTY2U, INC.
24805 Pinebrook Road, #209
Chantilly, VA 20152
mayura@realty2u.com
 
Powered by ListingsToGo™
set @lat=38.9781200;set @lon = -77.5680600;set @dist = .7;set @rlon1 = @lon-@dist/abs(cos(radians(@lat))*69);set @rlon2 = @lon+@dist/abs(cos(radians(@lat))*69);set @rlat1 = @lat-(@dist/69);set @rlat2 = @lat+(@dist/69);select st_distance(point(@lon, @lat), thePoint) as distance, ListingID, ListingStatus, LotAreaAcre, LivingArea, ForSale, Longitude, ModificationTimestamp, YearBuilt, Latitude, Subdivision, VirtualTourURL, ListOfficeName, ListingKey, ZipCode, ListPictureURL,ListPicture3URL, FullStreetAddress, StreetName, Beds, BathsFull,BathsHalf, CityName, State, ZipCode, ListPrice, ClosePrice, InternetRemarks, LotAreaAcre from `searchALL` where st_within(thePoint, envelope(linestring(point(@rlon1, @rlat1), point(@rlon2, @rlat2)))) and (ListingStatus LIKE "Active%" or ListingStatus ='COMING SOON') and ForSale='Y' order by distance ASC, st_distance(point(@lon, @lat), thePoint) limit 50;