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!=27718932 having distance <= 11 order by distance limit 3
- ©MLS R2949176
- Area 569 sq ft
- Bedrooms 1
- Bathrooms 1
- Parkings 1
Description
This property is unfortunately not available anymore. It may be sold, expired, withdrawn, terminated, or out of market. To know more about this property and what happened to that, or to see other available options, please feel free to contact us by using the message box on right side.
Show More
Details
- Age: 9 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Ranch
- Maintenance Fee: 276.35/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Recreation Centre
Features
- No Smoking Home
- Pets Allowed With Restrictions
- Baseboard heaters
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
