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` = '2' and ListingID!=27435280 having distance <= 11 order by distance limit 3
- ©MLS R2926233
- Area 2302 sq ft
- Bedrooms 4
- Bathrooms 2
Description
This 9600 sq ft corner lot in WEST WHITEROCK presents an exceptional development opportunity. Situated within the Ray Shepherd Elementary & Elgin Park Secondary Catchment, this rare large lot offers great potential for development. The existing character home, featuring 4 bedrooms and 2 bathrooms, is in good condition. With its prime location and substantial size, this property holds significant development potential for duplex, triplex or two single family lots. This property offers a promising investment opportunity in a sought-after neighborhood of West White Rock. (id:48970) Show More
Details
- Age: 60 Years
- Property Type: Single Family
- Type: House
- Architectural Style: 2 Level, Other
Ammenities + Nearby
- Laundry - In Suite
Features
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Forced air
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board
