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` = '2' and `BedroomsTotal` = '2' and ListingID!=27435739 having distance <= 11 order by distance limit 3
- ©MLS 10324385
- Area 1316 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 2
Description
Great value at Desert Cove. Estate sale and priced to go. Desirable and unique plan with huge carport and an an abundance of parking. Affordable adult living with an active resort lifestyle. Great, amenities including indoor pool, RV parking, outdoor social and recreation areas, spacious clubhouse with full function kitchen, hobby room, library, gym and lots more. Lease is pre-paid to 2055. Vacant and quick possession available. (id:48970) Show More
Details
- Constructed Date: 1989
- Property Type: Single Family
- Type: House
- Community: Desert Cove
- Neighbourhood: Swan Lake West
Features
- Level lot
- Seniors Oriented
- Central air conditioning
- Forced air
- See remarks
Rooms Details For 211 2nd Street
Type | Level | Dimension |
---|---|---|
Other | Main level | 8'0'' x 8'0'' |
Other | Main level | 22'0'' x 13'6'' |
Other | Main level | 28'0'' x 15'0'' |
Foyer | Main level | 12'3'' x 11'4'' |
Laundry room | Main level | 8'0'' x 13'4'' |
Full bathroom | Main level | 5'0'' x 8'0'' |
3pc Ensuite bath | Main level | 5'0'' x 11'0'' |
Bedroom | Main level | 8'9'' x 11'4'' |
Primary Bedroom | Main level | 11'10'' x 13'3'' |
Kitchen | Main level | 910'0'' x 8'0'' |
Dining room | Main level | 9'0'' x 8'4'' |
Living room | Main level | 18'5'' x 16'8'' |
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