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

Lot 30 ASHCROFT ROAD For Sale

kamloops, British Columbia
$ 219,000
  • ©MLS 179663

Description

Large lot 10.98 acres. Be the first to pick up one of these great lots with southern exposure, and stunning mountain views! Zoned Rl-1 you can build your dream home, or purchase a custom double wide and have it set up just how you like. A short drive to Kamloops Lake to spend the day on the boat, or only 35 minutes to Costco in Kamloops. There is a building Scheme in place : - No single wide mobile homes, new or used, will be allowed.- Home builders are encouraged to use to use muted colours that will blend in with the landscape, rather that bright colours that will stand out, as the Thompson River Valley is an area of great natural beauty. Tobiano, a development 15 minutes west of Kamloops, is a good example of colours that are easy on the eyes. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Community: Cherry Creek/Savona

Features

  • Sloping

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kamloops & District Real Estate Association

©️ 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®)