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!=25504600 having distance <= 11 order by distance limit 3
- ©MLS 2470237
Description
Here's your chance to own a lot at the coveted Twin Bays Village. The beach is a 1 minute walk away. Build your dream house here! Private marina, lot is fully serviced, great recreational location for moating, swimming. fishing, or just chilling. The property is part of a low monthly strata which includes water and sewer. Build your dream lake property here. There is a building scheme. Twin Bays boasts a rare sandy beach just 25 minutes north of Creston so you are never far from all amenities. Call your agent today (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Vacant Land
- Construction Material: Unknown
- Access Type: Highway access, Easy access
- Community: East Shore
- Maintenance Fee: 119.75/Monthly
Ammenities + Nearby
- Highway
- Recreation Nearby
- Recreation
- Highway
- Recreation Nearby
- Recreation
Features
- Rural Setting
- Pets Allowed With Restrictions
- Unknown
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
