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` = '1' and ListingID!=27382585 having distance <= 11 order by distance limit 3
For more information, click the Brochure button below. Sunny view property located on Pineridge Drive – beautiful views of Noel, Sloan, and Green Mountains Built 2019 by Norwood Log Homes. This cabin is a perfect place to base your outdoor activities out of. The road is cleared year round for easy access but also allows for winter snowmobile access via trail. Close to Kingdom Lake for a scenic swim or fishing. Wired with plugs, lights, appliances; solar powered with lithium ion battery bank and generator back up. New propane stove/oven, and fridge. Shop with garage door for toys (easily converted to bunkie). Generator/ fuel shed. Shower hut. Outhouse. Stream at back of the property with bridge to trail network. Outhouse bathroom on property. Direct access from yard to mountain! (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®)
