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!=27092654 having distance <= 11 order by distance limit 3
- ©MLS 179488
Description
Welcome to a once-in-a-lifetime opportunity to own a piece of paradise on the pristine shores of the South Thompson River at the mouth of Little Shuswap Lake. Located in Chase B.C. this 20.337 acre property has over 2600 ft of breathtaking water frontage along the South Thompson River and Chase Creek. Imagine waking up to the serene sounds of the river, surrounded by natural beauty and tranquility. This unique property offers endless possibilities for building your dream waterfront escape, a luxurious lakeside retreat, or an expansive family estate. With its generous size and extensive frontage, you'll have ample space for privacy, outdoor activities, and breathtaking views from every angle. This fabulous property is within the Village of Chase, has servicing at the lot line and a storm sewer system in place. Embrace the beauty of nature and create the ultimate waterfront lifestyle you've always dreamed of. (id:48970) Show More
Details
- Property Type: Vacant Land
- Community: Chase
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