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` = '3' and `BedroomsTotal` = '1' and ListingID!=27682716 having distance <= 11 order by distance limit 3
This is the perfect family cabin! Truly turnkey and ready for you to start your vacation the moment you get the keys! It features modern amenities like a drilled well, a modern electric power system, including electric fridge, and a registered septic system. Great floor plan with a functional kitchen and bedroom and 3pc bath on the main floor and 2 additions beds upstairs as well as games and reading area up and kitchen / living room down, perfect for your family to spread out. Lots of room inside and out, on the large deck and lawn area, ideal for entertaining. Additionally, the cabin boasts a new king-size bed and new trundle bed upstairs. The cabin can sleep 10 guests. For outdoor adventures, the property comes with a couple of Savary bikes and kayaks. Sutherland Beach is just steps away and Mermaid Beach is a short walk and has a mooring buoy ready to go, this cottage offers everything you need for a comfortable and enjoyable getaway. Bathroom upgrade in progress, (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: Powell River Sunshine Coast Real Estate Board
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®)
