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` = '2' and ListingID!=27348446 having distance <= 11 order by distance limit 3
Step into modern living with this beautiful 2-bedroom plus den condo in the desirable Skaha Hills community. Built by Greyback Construction in 2019, this home offers quality craftsmanship with 5 years remaining on the structural warranty. Enjoy breathtaking lake and mountain views from every principal room, and relax on the spacious covered patio equipped with a gas BBQ connection, perfect for entertaining or simply unwinding outdoors. With over $27,000 in upgrades, this home combines style and convenience—details available through your agent. Skaha Hills provides an array of amenities including pickleball and tennis courts, an outdoor pool and hot tub, a fully equipped gym, a clubhouse, a dog park, and numerous walking trails. Plus, enjoy the financial benefits of no property transfer tax, no GST, and no vacancy or speculation tax. This newer development is ideal for working professionals and retirees seeking a low-maintenance lifestyle. With a detached garage and an additional surface parking spot, you’ll have all the space you need. Discover the perfect blend of luxury and convenience at Skaha Hills—where you can truly lock up and leave without a worry! (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®)
