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` = '1' and ListingID!=27527705 having distance <= 11 order by distance limit 3
Your own cabin; just footsteps from Swan Lake! This very cute 2 bedroom home is located in Swan Lake Subdivision surrounded by trees for privacy and wind block yet you can be on the water in just 5 minutes. The home offers a full kitchen with a fridge and stove, a living room with a wood stove, 2 bedrooms and a 3 pc bathroom with a shower. There is full power and a N/G furnace so no worries there, as well as a cistern for water and a septic system for sewer. Outside there is a wrap around deck, secondary deck, room for an RV with a firepit and ample storage with a couple outbuildings. The property can also come fully furnished! Don't wait to be out by the lake and come view this property. (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®)