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` = '3' and ListingID!=27735635 having distance <= 11 order by distance limit 3
- ©MLS 10330341
- Area 1321 sq ft
- Bedrooms 3
- Bathrooms 3
- Parkings 2
Description
This property is unfortunately not available anymore. It may be sold, expired, withdrawn, terminated, or out of market. To know more about this property and what happened to that, or to see other available options, please feel free to contact us by using the message box on right side.
Show More
Details
- Constructed Date: 1982
- Property Type: Single Family
- Type: Row / Townhouse
- Neighbourhood: Penticton Apex
- Maintenance Fee: 714.83/Monthly
Ammenities + Nearby
- Recreation
- Ski area
- Recreation
- Ski area
Features
- Private setting
- Pets Allowed
- Pets Allowed With Restrictions
- Mountain view
- View (panoramic)
- Range
- Refrigerator
- Dishwasher
- Dryer
- Washer
- Baseboard heaters
- Storage, Locker
Rooms Details For 225 CLEARVIEW Road Unit# 911
Type | Level | Dimension |
---|---|---|
Primary Bedroom | Second level | 10'5'' x 15'2'' |
3pc Ensuite bath | Second level | 5' x 7' |
4pc Bathroom | Second level | 4'11'' x 7'5'' |
Bedroom | Second level | 9'11'' x 8'3'' |
Bedroom | Second level | 10'5'' x 12'6'' |
3pc Bathroom | Main level | 6'11'' x 4'10'' |
Dining room | Main level | 10'11'' x 11'11'' |
Kitchen | Main level | 10'3'' x 15'1'' |
Living room | Main level | 10'4'' x 14'10'' |
Utility room | Main level | 3'9'' x 2'10'' |
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