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!=27494055 having distance <= 11 order by distance limit 3
- ©MLS 2479840
Description
Welcome to Lot 4 at Crooked Tree Place, a small, private, 22 lot gated community located between Windermere and Fairmont Hot Springs BC. This amazing piece of property faces southwest and is just over a third of an acre featuring spectacular mountain views with lots of sun! There is a large community water system and no building time commitment. (id:48970) Show More
Details
- Property Type: Vacant Land
- Community: Fairmont/Columbia Lake
Ammenities + Nearby
- Ski area
- Golf Nearby
- Recreation Nearby
- Ski area
- Golf Nearby
- Recreation Nearby
Features
- Cul-de-sac
- Private setting
- Treed Lot
- Quiet Area
- Rural Setting
- Mountain view
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay Real Estate Board
