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 ListingID!=27038736 having distance <= 11 order by distance limit 3
Very special property. 4 unit lodge with larger owners suite. Each lodge suite is one bedroom with queen bed and fold out sofa . Small kitchen area with fridge and microwave. Full internet and TV. Full shower, Laundry and extra fridge/storage space for longer term rentals. Each room is ultra insulated and sound proofed. There is a large BBQ and games area for the guests at the east end of the building . Snowmobile and ATV right from the parking lot into the Pasayton Valley. The entire building is wired to WiFi - you can control all electronic door locks, power, hot water tanks ect, cameras, lights from your phone . There is propane powered Generac back up power system. Great water from the well onsite. Owners suite is 1 bedroom with a full kitchen and bath and separate laundry and a good sized living room. Owners space at west end of building is private and has a firepit , bbq area, 2 sea cans for storage and a wood storage area. Building has metal roof and finished with Hardy board. (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®)