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` = '2' and ListingID!=27744848 having distance <= 11 order by distance limit 3
Don’t miss out on this beautiful 3 bed / 2 bath home with an attached garage in the desirable 18+ section of the popular Westview Village, one of the most sought after MHP because of its central location, minutes from school, transit, golf, restaurants, shops, beaches & wineries. Built in 2020, this home features open concept living, white shaker kitchen cabinets, stainless steel appliances, vinyl plank flooring, modern colors throughout, a master ensuite, laundry room with access to a single garage (362sqft), air conditioning, fenced yard with a magnificent view of mount Boucherie and spacious covered deck with metal patio awning make this private outdoor living oasis perfect for entertaining! The home is situated on a nicely landscaped corner lot with parking for 2 vehicles out front. Financing is available and pets are allowed, with no height or weight restrictions and no vicious breeds. Must be 18+. Gross Taxes are $1846.00, Water /Sewer Quarterly is $178.14, and Pad Rent is $651.00. Don't wait to view this one-of-a-kind home. Know your credit score before requesting a showing. Buyers must have a good credit score. (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®)
