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!=27092958 having distance <= 11 order by distance limit 3
- ©MLS 10318063
Description
Build your dream home in Park Hill Estates! LOT 8 - Amazing opportunity in one of Salmon Arm’s newest subdivisions, located in one of the fastest-growing communities in BC. This prime location is just a short walk to the only public beach in Salmon Arm. These freehold proposed lots are zoned R1 and each lot varies in size, offering amazing views. This non-stratified property is situated in a desirable area with many lots bordering the Shuswap golf course, city park, and four-season trails. The Shuswap is renowned for its abundance of recreational opportunities. Additionally, there is a public boat launch and full-service marina within minutes, as well as a baseball diamond and great potential in the rapidly expanding Canoe area. Shopping, restaurants, and amenities are conveniently located within a 10-minute drive. This is an exciting opportunity to get in on the first phase, with GST applicable and a design guideline that will be required upon sale. (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Road: Paved road
- Neighbourhood: NE Salmon Arm
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
