WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/18...' at line 1]SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( - Latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/180 / 2), 2) ))) as distance from wp_phl_property where `property_id`>0 and `Sold` != '1' and `TransactionType` = 'For sale' and ListingID!=25109235 having distance <= 11 order by distance limit 3
- ©MLS 197161
Description
Beautiful view lots located in the Elk Ridge Subdivision just 2 minutes from the city limits of Dawson Creek! Every one of these lots offers views of the city and rolling hills with the convenience of paved roads to your driveway. All of these lots are approximately 4.5 acres and are protected with a proper building scheme. This subdivision is private and will provide your family a peaceful place to call home. Call today to view! (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Neighbourhood: Dawson Creek Rural
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board