BSMT 13520 55 A AVENUE, surrey, British Columbia V3X3B5

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 rent' and `BedroomsTotal` = '2' and `BedroomsTotal` = '1' and ListingID!=27781254 having distance <= 11 order by distance limit 3

BSMT 13520 55 A AVENUE For Rent

surrey, British Columbia V3X3B5

$ 1,995

/ Month

©MLS R2954239
Area 750 sq ft
Bedrooms 2
Bathrooms 1

Description

Welcome to our Executive 2 Bedroom Suite - Rent is all inclusive. All utilities and internet are included. Nestled in the charming Panorama Ridge neighborhood of Surrey, British Columbia. This basement property offers a tranquil retreat for couples, retirees, and young professionals seeking a comfortable and hassle-free living experience. Located in a quiet and safe community, this suite provides the perfect blend of convenience and relaxation for those looking to call Panorama Ridge home. For information please view https://coronetrealtyltd.com/properties-for-rent/. To book a showing call 604-298-3235 ext1. or email admin@coronetrealtyltd.com. (id:48970) Show More

Details

Property Type: Single Family
Type: House

Features

Refrigerator
Stove

Location

This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board

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®)