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` = '2' and `BedroomsTotal` = '2' and ListingID!=27573824 having distance <= 11 order by distance limit 3

102 15130 PROSPECT AVENUE For Sale

white rock, British Columbia V6B2R9
$ 679,900
$ 510 / Sq. Ft.
  • ©MLS R2938332
  • Area 1332 sq ft
  • Bedrooms 2
  • Bathrooms 2
  • Parkings 1

Description

OCEAN VIEW 2 bedroom/2 bath condo w/huge, wrap around patio perfect for gardening & entertaining. Spacious open plan living space w/cozy glass fireplace extends to your sunny, private patio. Bright & airy south facing living room & dining room features 180 degree southern exposure. Kitchen opens to expansive family room. Primary bedroom w/ensuite bathroom & large glass shower, walk-in closet & covered patio. 2nd bedroom w/murphy bed. 2nd bathroom w/shower. Radiant h/w in-floor heat. Laminate & tile floors. Stacking in suite w/d. Some photos virtually staged. Well maintained, boutique building w/2 units per floor. Common area room w/pool table/fitness area. Common workshop/garden shed. 1 large parking stall, huge storage locker included. Perfect location, ideal for 55+. Walk to 5 Corners, shopping, bus & beach. OPEN HOUSE Saturday, Nov 16th 1-4pm (id:48970) Show More

Details

  • Age: 34 Years
  • Property Type: Single Family
  • Type: Apartment
  • Architectural Style: Other
  • Maintenance Fee: 555.84/Monthly

Ammenities + Nearby

  • Laundry - In Suite
  • Storage - Locker

Features

  • No Smoking Home
  • Age Restrictions
  • Pets not Allowed
  • Rent With Restrictions
  • Workshop
  • Ocean view
  • View of water
  • Washer
  • Dryer
  • Refrigerator
  • Stove
  • Dishwasher
  • Garage door opener
  • Microwave
  • Alarm System - Roughed In
  • Unknown
  • Smoke Detectors
  • Hot Water
  • Radiant heat
  • Storage

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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)