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` = '5' and `BedroomsTotal` = '2' and ListingID!=25491902 having distance <= 11 order by distance limit 3
- ©MLS 10272359
- Area 2088 sq ft
- Bedrooms 5
- Bathrooms 2
- Parkings 6
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
- Constructed Date: 1977
- Property Type: Single Family
- Type: House
- Access Type: Easy access
- Neighbourhood: Lavington
Ammenities + Nearby
- Recreation
- Schools
- Park
- Recreation
- Schools
- Park
Features
- Central location
- Flat site
- Level
- Family Oriented
- Patio(s)
- Deck
- Shed
- Mountain view
- Hot Tub
- Smoke Detectors
- Baseboard heaters
- Storage Shed
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board