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` = '4' and ListingID!=27494367 having distance <= 11 order by distance limit 3
- ©MLS 10325433
- Area 2019 sq ft
- Bedrooms 3
- Bathrooms 4
- Parkings 5
Description
Ready to move in now! You're getting a brand new, professionally designed, semi detached, fully warranted, 2,000+ sq ft. home with Mountain vistas. Easy ski in/ski out access to the SERWA Run nearby, a short 12 minute walk to all the Village amenities. The main floor of the home features an open, entertainer's floor plan, a beautiful kitchen boasting 5 piece upgraded stainless steel appliances and granite countertops, with an impressive stone fireplace in the living room. Off the kitchen is a large, covered balcony, the perfect spot to add a hot tub for those long post-ski soaks!. There are 3 spacious bedrooms, 3 full & 1 half bathrooms. The master suite features a walk-in closet and full 5 piece ensuite bathroom. If extra storage is on your wish list, we have that too! This unit has a triple car garage, so lots of room for all of your toys, and your driveway shoveling is all taken care of! 2 pets allowed, and no rental restrictions here, low strata fees, all appliances and Central Vac included! Check out the 360 Tour to see a similar unit. Fully Finished and Ready for Immediate Possession!! New Property Transfer Tax rules may allow you to avoid the tax, and there are no short term rental restrictions, speculation tax, or foreign buyer bans here!! (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Duplex
- Community: Grizzly Ridge Estates
- Neighbourhood: Big White
- Maintenance Fee: 73.84/Monthly
Features
- Rentals Allowed
- Mountain view
- Refrigerator
- Dishwasher
- Dryer
- Range - Gas
- Microwave
- Washer
- Central air conditioning
- Smoke Detector Only
- Baseboard heaters
Rooms Details For 280A Grizzly Ridge Trail
Type | Level | Dimension |
---|---|---|
4pc Bathroom | Second level | Measurements not available |
Bedroom | Second level | 9'4'' x 12'0'' |
Bedroom | Second level | 9'0'' x 12'0'' |
5pc Ensuite bath | Second level | Measurements not available |
Primary Bedroom | Second level | 16'0'' x 12'0'' |
3pc Bathroom | Basement | Measurements not available |
Mud room | Basement | 6'0'' x 5'6'' |
2pc Bathroom | Main level | Measurements not available |
Living room | Main level | 21'0'' x 15'0'' |
Kitchen | Main level | 10'6'' x 10'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