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` = '4' and `BedroomsTotal` = '5' and ListingID!=27066028 having distance <= 11 order by distance limit 3
- ©MLS 10317307
- Area 2943 sq ft
- Bedrooms 4
- Bathrooms 5
- Parkings 4
Description
Luxury at Grizzly Ridge Estates! You will absolutely fall in love with this home; from the beautiful finishes throughout, the thoughtfully designed floor plan, to the breathtaking, unobstructed, panoramic views of the Monashee Mountains - this brand new home has it all! The main level features a professionally designed gourmet kitchen, large living room with stone fireplace and vaulted ceilings, spacious dining room, plus access to the covered deck, which is an ideal place to soak in the views from the included hot tub after a long day on the slopes. Down one level you will find 3 bedrooms including the master suite with 4 piece ensuite bath and walk in closet, an additional full bathroom for your kids or guests, plus laundry room. Below this level is a walkout sub-basement with another master suite with ensuite, plus large rec room with wet bar and another fireplace, an additional full bathroom, and small patio. You're getting a brand new, professionally designed, fully warrantied home with over 2,900 finished square feet, 4 bedrooms, 4.5 bathrooms, a 480 sqft double garage, additional driveway parking, and some of the most stunning panoramic views to be had at Big White! 2 pets allowed, no rental restrictions, low strata fees, all appliances, and a private hot tub!! (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Row / Townhouse
- Community: Grizzly Ridge Estates
- Neighbourhood: Big White
- Maintenance Fee: 101.71/Monthly
Features
- Central island
- Mountain view
- Refrigerator
- Dishwasher
- Dryer
- Range - Gas
- Microwave
- Washer
- Sprinkler System-Fire
- Baseboard heaters
Rooms Details For 255B Grizzly Ridge Trail
Type | Level | Dimension |
---|---|---|
2pc Bathroom | Second level | Measurements not available |
Dining room | Second level | 12'0'' x 14'0'' |
Kitchen | Second level | 10'0'' x 11'4'' |
Great room | Second level | 16'0'' x 17'0'' |
4pc Bathroom | Basement | Measurements not available |
Recreation room | Basement | 13'6'' x 17'0'' |
4pc Ensuite bath | Basement | Measurements not available |
Primary Bedroom | Basement | 12'0'' x 16'0'' |
Laundry room | Main level | '0'' x '0'' |
4pc Bathroom | Main level | Measurements not available |
4pc Ensuite bath | Main level | Measurements not available |
Bedroom | Main level | 10'0'' x 10'0'' |
Bedroom | Main level | 11'2'' x 11'6'' |
Primary Bedroom | Main level | 12'0'' x 16'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