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
- ©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