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 `BedroomsTotal` = '2' and `BedroomsTotal` = '3' and ListingID!=26923549 having distance <= 11 order by distance limit 3
Welcome to Mac's Landing, at Marnie's Bay seasonal Resort on Adams Lake. This cottage has been constructed with purpose & designed with efficiency in mind, built net-zero. Only 1.25 hrs from Kamloops. Sweeping views of the lake on 1 acre of land, this 2500sqft true rancher w/ 500sqft garage will impress from the moment you step onto the property. Metal roofing, w/ solar panels, corrugated black metal siding & wood accents highlight the exterior of the cottage. Inside you will find the bright, main living space w/ custom kitchen, wood burning stove, engineered hardwood floors & access to large patio. Fully finished w/ 2 beds & office, 2 full bathrooms & flex room. Fully serviced w/ community septic, community water & access to marina & boat launch. This community offers flexibility & space for your family to enjoy all the recreational possibilities. Contact us for the information package on the community, seasonal operation & rental requirements. Exempt from Foreign Buyers Ban. (id:48970) Show More
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
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®)
