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!=27348446 having distance <= 11 order by distance limit 3
- ©MLS 10323081
- Area 1414 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 2
Description
Step into modern living with this beautiful 2-bedroom plus den condo in the desirable Skaha Hills community. Built by Greyback Construction in 2019, this home offers quality craftsmanship with 5 years remaining on the structural warranty. Enjoy breathtaking lake and mountain views from every principal room, and relax on the spacious covered patio equipped with a gas BBQ connection, perfect for entertaining or simply unwinding outdoors. With over $27,000 in upgrades, this home combines style and convenience—details available through your agent. Skaha Hills provides an array of amenities including pickleball and tennis courts, an outdoor pool and hot tub, a fully equipped gym, a clubhouse, a dog park, and numerous walking trails. Plus, enjoy the financial benefits of no property transfer tax, no GST, and no vacancy or speculation tax. This newer development is ideal for working professionals and retirees seeking a low-maintenance lifestyle. With a detached garage and an additional surface parking spot, you’ll have all the space you need. Discover the perfect blend of luxury and convenience at Skaha Hills—where you can truly lock up and leave without a worry! (id:48970) Show More
Details
- Constructed Date: 2019
- Property Type: Single Family
- Type: Apartment
- Neighbourhood: Main South
- Maintenance Fee: 538.00/Monthly
Features
- Pets Allowed
- Lake view
- Mountain view
- View of water
- View (panoramic)
- Refrigerator
- Dishwasher
- Microwave
- See remarks
- Washer & Dryer
- Oven - Built-In
- Heat Pump
- Sprinkler System-Fire
- Controlled entry
- Smoke Detector Only
- Forced air
- Heat Pump
- See remarks
Rooms Details For 400 VISTA Park Unit# 412
Type | Level | Dimension |
---|---|---|
4pc Ensuite bath | Main level | Measurements not available |
Other | Main level | 10'1'' x 5' |
Laundry room | Main level | 5'2'' x 9' |
Office | Main level | 8'5'' x 8'7'' |
Bedroom | Main level | 10'5'' x 12'3'' |
4pc Bathroom | Main level | Measurements not available |
Kitchen | Main level | 9' x 12'9'' |
Dining room | Main level | 11'11'' x 12'9'' |
Living room | Main level | 15'3'' x 13'8'' |
Utility room | Main level | 12'7'' x 3'2'' |
Primary Bedroom | Main level | 15'3'' x 13'2'' |
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