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!=27577744 having distance <= 11 order by distance limit 3
NO PROPERTY TRANSFER TAX ON NEW CONSTRUCTION* Welcome to Wood Lane, a brand new 4-unit Strata across from the Riverwalk and Shuswap River in the beautiful Little City of Enderby is now ready for immediate possession. Monthly strata fee is just $198.80. Retiring, downsizing or just starting out, this efficient design offers 3 bedrooms PLUS a den, an easily accessible crawl space for storage & best of all a ROOFTOP deck to expand your living space. The rooftop faces East for the morning sunrises and where you can see The Cliffs light up in the evening, reflecting the setting sun. Completely private, there's two accesses; one is off the Den which could also be the 4th bedroom or from the hallway. The main level has as an open kitchen / living area with vinyl plank flooring, lots of natural light, an island with Quartz counters and chic light fixtures. The main level also has a bedroom and full bathroom as well as a backdoor to a concrete patio offering space for your BBQ and a spot to enjoy dinner in the summer. Upstairs is the primary bedroom (although the main floor bedroom could be the primary bedroom as well), walk-in closet & a barn door into the main bathroom. There is the third bedroom on this level and a laundry room as well as the Den / 4th bedroom. *THERE IS NO PROPERTY TRANSFER TAX on this newly constructed townhome (based on use, price & residency criteria) saving you $9,940. (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®)
