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` = '2' and ListingID!=27736109 having distance <= 11 order by distance limit 3
Gated Community with Views of the Bay on this Semi-Waterfront - 2 undivided shares property - with B44 Boat Slip all located on the serene sandy shores of Adams Lake (area known as Agate Bay). This home was built for full time living or recreational. Agate Bay Resort is the place you need to be. Property is freehold and each owner has exclusive use of their own lot with a undivided shared interest in the resort. Log home with 4 bedrooms and two 4 piece baths. (1 bdrm down-1 bath down; 3 bdrm up-1 bath up). Boat launch just steps away from the cottage with newer boat slip docks making easy access to your boat slip. Back yard with double tier decks in the back yard has privacy while you listen to Sinmax Creek go by. Main floor is large living space with wood heating stove, open to the dining & into the well equipped kitchen. Main floor bedroom opens to a deck to take in the view of the Bay with beverage of your choice in hand - Dock Fee $250/year (id:48970) Show More
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®)
