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` = '4' and `BedroomsTotal` = '1' and ListingID!=27196232 having distance <= 11 order by distance limit 3
Welcoming 5.2 acre well-protected, deep water oceanfront property, encompassing two coves, bluffs and forested areas. An idyllic off-grid coastal retreat, with a main cabin, sleeping cabins, gazebos to bring living space to the outdoors, moorage, and numerous viewpoints along the oceanfront. Curated and nurtured by the current owner for over 40+ years, this special property has been developed to professional standards using quality products. Furnishings, equipment and other sundry items are included - this property is ready to enjoy! St. Vincent Bay sits at the entrance to Jervis Inlet, located between Sechelt and Powell River. The Sunshine Coast offers laid-back west coast living in close proximity to the major metropolis of Vancouver. St. Vincent Bay is a recreational community of 172 acres with 24 interests held in individual titles plus an additional 32 acres of shared inland common property and governed by an owners' association. Foreign buyers welcome. (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®)
