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!=27556665 having distance <= 11 order by distance limit 3
- ©MLS 10326414
- Area 709 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 1
Description
Exceptional 2-bedroom, 2-bathroom condo boasting an open concept layout highlighting a great kitchen with new SS appliances and eat-up counter bar and an inviting ambiance of a convenient gas fireplace. New lighting, furniture, bedding! Good-sized primary bedroom with 4pc en-suite and second bedroom with a double/twin bunk. Grizzly Lodge offers great ski-in/ski-out access, shared laundry, and desirable amenities such as a hot tub, sauna, pool table and offers storage locker and secure parking. Situated a short walk from the Village Centre, this unit offers comfort and convenience for an investor or to use as a personal getaway. Comes completely turn-key! NO rental restrictions and NO GST! With direct flights from cities like Los Angeles, Toronto, and Montreal, and just an hour from YLW, Big White is more accessible than ever. Known for some of the best snow in North America, this resort offers a winter wonderland experience. Best of all, this property is fully exempt from the Foreign Buyer Ban, Foreign Buyers Tax, Speculation Tax, Empty Home Tax, and Short-Term Rental Ban, providing a rare opportunity for international buyers. LIVE WHERE YOU PLAY! (id:48970) Show More
Details
- Constructed Date: 2001
- Property Type: Single Family
- Type: Apartment
- Community: Grizzly Lodge
- Neighbourhood: Big White
- Maintenance Fee: 389.00/Monthly
Features
- One Balcony
- Mountain view
- View (panoramic)
- Smoke Detector Only
- Baseboard heaters
- Storage, Locker
Rooms Details For 295 Raven Ridge Road Unit# 204
Type | Level | Dimension |
---|---|---|
Full bathroom | Basement | 8' x 5'2'' |
4pc Ensuite bath | Basement | 8'3'' x 5'1'' |
Bedroom | Basement | 11' x 8'10'' |
Primary Bedroom | Basement | 12'2'' x 11'1'' |
Dining room | Basement | 12'2'' x 11'6'' |
Kitchen | Basement | 12'7'' x 7'4'' |
Living room | Basement | 15'3'' x 12'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