©2023 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of HomeServices of America, Inc. ® Equal Housing Opportunity.
ACTIVE UNDER CONTRACT
$275,000
3 bd   
1 ba
   1,500 SQFT
120 RIVERVIEW SHORES DR
FRONT ROYAL, VA 22630
ACTIVE
$420,000
4 bd   
3 ba
   1,463 SQFT
63 OAKWOOD DR
FRONT ROYAL, VA 22630
ACTIVE
$29,900
PIN OAK RD
FRONT ROYAL, VA 22630
ACTIVE UNDER CONTRACT
$25,000
LOT 529 CHERRYWOOD RD
FRONT ROYAL, VA 22630
ACTIVE
$379,900
3 bd   
2 ba
   1,664 SQFT
205 LOCUST GROVE RD
FRONT ROYAL, VA 22630
ACTIVE
$55,000
WOODWARD LN
FRONT ROYAL, VA 22630
ACTIVE
$1,475,000
4 bd   
4 ba
   4,108 SQFT
161 BENNYS BEACH RD
FRONT ROYAL, VA 22630
Database last updated  09/20/2024 09:56 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.

Wiles Group Real Estate
Berkshire Hathaway Home Services
PenFed Realty
1886 Metro Center Drive
Suite 200
Reston, VA 20190
Office:
703-716-2900
Mobile:
703-868-1571
Fax:
703-716-0017
jamie.wiles@penfedrealty.com
©2023 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of HomeServices of America, Inc. ® Equal Housing Opportunity.
©2023 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of HomeServices of America, Inc. ® Equal Housing Opportunity.
 
Powered by ListingsToGo™
set @lat=38.9680600;set @lon = -78.1560700;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;