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 `BedroomsTotal` = '1' and ListingID!=27725283 having distance <= 11 order by distance limit 3
Discover the perfect fusion of style and functionality in this stunning corner unit. The interior is a masterpiece, featuring an eye-catching kitchen and a breathtaking bathroom equipped with ultra-quiet appliances and elegant quartz countertops, accented by a mix of chrome and black fixtures. Enjoy this luxurious one bed one bath unit featuring living spaces with custom closets and impressive 9-ft ceilings expanding over 721 sqft. Situated at Icon, this residence combines the vibrancy of downtown with the charm of Historic Langley. You'll be just steps from nature trails, parks, schools, shopping, and entertainment, along with the convenience of an upcoming transit line. Don't miss your opportunity to make this exquisite property your home! PRICE INCLUDES GST (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®)
