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!=27333347 having distance <= 11 order by distance limit 3
- ©MLS 10322714
- Area 1425 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 2
Description
Experience luxurious living in this upscale, level entry, lakeview condo with a spacious deck featuring patio heaters and a TV mount, perfect for year-round enjoyment. Inside, find 2 generous bedrooms for comfort, along with a versatile den ideal for a home office, reading nook, or guest room. The open design allows you to glimpse the outstanding Okanagan views from all areas of your home. Features 9ft ceilings, European windows and sliding door, an individual garage with ample storage and 1 additional outdoor parking space. Pet friendly, no age restrictions and rentals allowed! The condo is part of Skaha Hills, offering fantastic amenities such as pickleball courts, a pool, hot tub, gym, dog parks, and more. (id:48970) Show More
Details
- Constructed Date: 2021
- Property Type: Single Family
- Type: Apartment
- Community: THE VISTAS
- Neighbourhood: Main South
- Pool Type: Outdoor pool
- Maintenance Fee: 538.00/Monthly
Ammenities + Nearby
- Airport
- Airport
Features
- Central island
- Balcony
- Pets Allowed
- Lake view
- Mountain view
- Valley view
- View (panoramic)
- Refrigerator
- Dishwasher
- Dryer
- Range - Gas
- Microwave
- Washer
- Central air conditioning
- Forced air
- See remarks
Rooms Details For 800 VISTA Park Unit# 822
Type | Level | Dimension |
---|---|---|
Other | Main level | 4'11'' x 10'2'' |
Primary Bedroom | Main level | 13'1'' x 15'1'' |
Living room | Main level | 15' x 13'9'' |
Laundry room | Main level | 8'9'' x 5'5'' |
Kitchen | Main level | 12'5'' x 8'9'' |
Foyer | Main level | 10'11'' x 5'3'' |
4pc Ensuite bath | Main level | 11'8'' x 14'1'' |
Dining room | Main level | 12'5'' x 11'10'' |
Den | Main level | 8'7'' x 8'5'' |
Bedroom | Main level | 12'2'' x 10'4'' |
4pc Bathroom | Main level | 8'2'' x 5'4'' |
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