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` = '3' and ListingID!=27140416 having distance <= 11 order by distance limit 3
- ©MLS 179723
- Area 3583 sq ft
- Bedrooms 4
- Bathrooms 3
Description
All measurements are approximate and buyer to confirm if deemed important. (id:48970) Show More
Details
- Property Type: Single Family
- Type: House
- Construction Material: Wood frame
- Road: No thru road
- Community: Merritt
Ammenities + Nearby
- Recreation
- Recreation
Features
- Quiet Area
- Mountain view
- Refrigerator
- Washer & Dryer
- Dishwasher
- Window Coverings
- Stove
- Microwave
- Central air conditioning
- Forced air
- Furnace
Rooms Details For 609 WILD ROSE DRIVE
Type | Level | Dimension |
---|---|---|
4pc Bathroom | Above | Measurements not available |
Bedroom | Above | 10 ft ,9 in x 12 ft ,9 in |
Bedroom | Above | 10 ft ,9 in x 12 ft ,9 in |
Other | Above | 9 ft ,9 in x 17 ft ,8 in |
3pc Bathroom | Basement | Measurements not available |
Bedroom | Basement | 10 ft ,3 in x 11 ft ,3 in |
Utility room | Basement | 8 ft ,9 in x 6 ft ,7 in |
Hobby room | Basement | 26 ft ,9 in x 31 ft ,9 in |
Storage | Basement | 8 ft ,9 in x 10 ft ,3 in |
4pc Ensuite bath | Main level | Measurements not available |
Kitchen | Main level | 11 ft ,3 in x 12 ft ,5 in |
Other | Main level | 18 ft ,2 in x 21 ft |
Dining room | Main level | 17 ft ,8 in x 9 ft |
Other | Main level | 4 ft ,6 in x 6 ft ,7 in |
Laundry room | Main level | 10 ft ,9 in x 6 ft ,9 in |
Foyer | Main level | 6 ft ,9 in x 9 ft ,9 in |
Primary Bedroom | Main level | 15 ft x 14 ft |
Office | Main level | 10 ft ,9 in x 11 ft ,4 in |
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kamloops & District Real Estate Association