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` = '3' and `BedroomsTotal` = '2' and ListingID!=27461321 having distance <= 11 order by distance limit 3
- ©MLS 10324885
- Area 1382 sq ft
- Bedrooms 3
- Bathrooms 2
- 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
- Constructed Date: 2018
- Property Type: Single Family
- Type: Apartment
- Community: Stonegate
- Neighbourhood: Big White
- Pool Type: Outdoor pool
- Maintenance Fee: 1647.40/Monthly
Ammenities + Nearby
- Cable TV
- Whirlpool
- Storage - Locker
Features
- One Balcony
- Mountain view
- Valley view
- View (panoramic)
- Storage, Locker
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
