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!=27364989 having distance <= 11 order by distance limit 3
- ©MLS 10323195
- Area 1216 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 1
Description
Incredible 3 bedroom 2 bathroom corner unit in the sought after Stonegate complex! This stunning condo features lavish finishings including a gourmet kitchen with granite counters, SS appliances, and eat-up bar. Fabulous for entertaining and family time with a spacious and bright living area with cozy fireplace to relax by. Or take it up a notch and relax in the private hot tub boasting views of the Monashee Mountains. This is a completely turn key residence including electronics, artwork, lines and more. Stonegate offers fitness centre, heated pool and hot tub, movie theater, game lounge and kids play center. Take advantage of the newly expanded accessibility to Big White, with direct flights from Los Angeles, Toronto, and Montreal via Alaska Airlines. Just an hour from YLW, immerse yourself in a winter wonderland renowned for the best snow in North America. Whether you’re looking for a personal getaway or a lucrative investment, this condo is an exceptional choice, fully exempt from the Foreign Buyer Ban, Foreign Buyers Tax, Speculation Tax, Empty Home Tax, and Short-Term Rental Ban. LIVE WHERE YOU PLAY! (id:48970) Show More
Details
- Constructed Date: 2008
- Property Type: Single Family
- Type: Apartment
- Community: Stonegate
- Neighbourhood: Big White
- Pool Type: Outdoor pool
- Maintenance Fee: 642.98/Monthly
Ammenities + Nearby
- Cable TV
- Whirlpool
- Storage - Locker
Features
- One Balcony
- Mountain view
- Valley view
- View (panoramic)
- Storage, Locker
Rooms Details For 375 Raven Ridge Road Unit# 301
Type | Level | Dimension |
---|---|---|
Laundry room | Main level | 4'0'' x 3'6'' |
Foyer | Main level | 11'0'' x 6'6'' |
3pc Bathroom | Main level | Measurements not available |
4pc Ensuite bath | Main level | Measurements not available |
Bedroom | Main level | 15'3'' x 10'9'' |
Bedroom | Main level | 12'0'' x 11'0'' |
Primary Bedroom | Main level | 13'9'' x 11'9'' |
Kitchen | Main level | 9'6'' x 9'0'' |
Dining room | Main level | 9'0'' x 7'5'' |
Living room | Main level | 17'8'' x 11'0'' |
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