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` = '3' and `BedroomsTotal` = '3' and ListingID!=27267676 having distance <= 11 order by distance limit 3
Beautiful stand-alone Craftsman style chalet in the upscale Forest development. Perfect for families or hosting friends for a ski weekend, can easily sleep 12 or more people. Awesome investment opportunity. Enter the Chalet into a large boot room with heated floors, walk out to private Hot Tub that overlooks the Monashee Mountains. Two full bedrooms and full bath downstairs. Main Floor has hardwood floors, large kitchen with gas range and island. Very warm and inviting living room featuring a cozy, gas fireplace and 30 foot vaulted ceiling with open beam accents. The view of the Monashees is majestic. Up half a floor and there is a full laundry area. Main bathroom includes soaker tub and shower. Primary Bedroom on top Floor has a king size bed along with pull out sofa. The primary is oversized and interior windows bring in the light from the living room windows. Newly painted Exterior. The setting of this property allows for great ski/in, ski/out access off of Serwa ski run. GST paid. 2 parking spots. (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®)
