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

Lot A AYLMER ROAD For Sale

chase, British Columbia
$ 2,875,000
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)