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` = '4' and `BedroomsTotal` = '4' and ListingID!=27520782 having distance <= 11 order by distance limit 3
- ©MLS R2932705
- Area 2218 sq ft
- Bedrooms 4
- Bathrooms 4
- Parkings 2
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: 24 Years
- Property Type: Single Family
- Type: House
- Architectural Style: 2 Level
- Maintenance Fee: 150.00/Monthly
Features
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Garage door opener
- Forced air
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
