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!=25109427 having distance <= 11 order by distance limit 3

Lot 24 ELK RIDGE Trail For Sale

dawson creek, British Columbia V1G4H4
$ 159,900
  • ©MLS 197165

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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)