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!=27757533 having distance <= 11 order by distance limit 3
- ©MLS 10330780
Description
FLAT VIEW LOT, in a Gated Community, Backing onto R/S Golf, with an EXCEPTIONAL ROCKY MOUNTAIN and GOLF COURSE VIEWS... Fairmont Hot Springs is a ..PARADISE FOR OUTDOOR PEOPLE...Golfing, Skiing, Hiking, Biking, Fishing, Tennis PICKLEBALL,.Rafting, Zip Lining, Boating (2 Lakes close) and NATURAL HOT SPRINGS. Also Dining & Shopping. No building (time) commitment. (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Road: Paved road
- Community: Riverside Golf Estates
- Neighbourhood: Fairmont/Columbia Lake
- Maintenance Fee: 400.00/Yearly
Ammenities + Nearby
- Airport
- Airport
Features
- Family Oriented
- River view
- Mountain view
- Valley view
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
