5174 Aberdeen St, Vancouver BC - Single Family Residence for Sale - MLS# R3135384

$2,098,000
Est. Mortgage $9,282/mo
7 Beds
4 Baths
2392 sqft
877 $ /sqft
2002 built
$2,098,000
Est. $9,282/mo with 20% down
Dan Marusin
Dan Marusin
Renanza Realty
778-918-5990
Award-Winning REALTOR® with 11+ Years of Experience Serving Greater Vancouver
Go See This Home Now

Photos

Property Details for 5174 Aberdeen Street

Exceptional opportunity in the desirable Collingwood area! This fully renovated family home offers strong future upside with approval for 12-storey zoning, presenting incredible investment potential over the next 5 years. Currently generating approx. $4,000/month from two self-contained 2-bedroom suites, with the upper level also rentable for around $4,000/month. The bright and modern main living space features stylish finishes, spacious living and dining areas, a sleek contemporary kitchen, generous bedrooms, and updated bathrooms. Situated on a quiet street with ample parking and private yard, just a 5-minute walk to Joyce–Collingwood Station, schools, parks, shopping, and community centre. A rare turn-key investment with excellent rental income and redevelopment potential.

Interior Features

Basement Finished Area (sqft) 0
Basement Features Finished, Exterior Entry
Appliances Included Washer/Dryer, Dishwasher, Refrigerator, Stove
Fireplace 1
Heating Type Radiant
# of Kitchens 3
Flooring Laminate, Tile
Foundation Concrete Perimeter

Exterior Features

Exterior Features Balcony
Roof Asphalt
Structures Residential Detached

Building Details

Price $2,098,000
Total Bedrooms 7
Total Bathrooms 4
Full Bathrooms 4
Half Bathrooms 0
Floor Area Total (sqft) 2392
Year Built 2002
Age Of Building 24
Building Type Single Family Residence
Property Type Residential
Stories 2
Ownership Type Freehold NonStrata
Community Features Shopping Nearby
Utility Type Electricity Connected, Natural Gas Connected, Water Connected
Utility Sewer Community, Sanitary Sewer, Storm Sewer
Water (WaterSource) Public
Parking Type Open, Front Access
Total Parking Spaces 2
Rental Suites Unauthorized Suite

Lot & Land

Lot Size 3927.54
Lot Size Depth Feet
Lot Size Frontage 40
MLS® # R3135384
Area Vancouver East
Neighbourhood Collingwood VE
City Vancouver
Postal Code V5R 4M3
Gross Taxes $9,554.83
Zoning R1-1

Property Timeline

Status Date Price
R3135384 / Active 06-10-2026 $2,098,000
R3109606 / Terminated 04-09-2026 $2,199,000
R3048838 / Terminated 09-15-2025 $2,299,000
R2936901 / Expired 10-15-2024 $2,418,000
R2901506 / Sold 07-30-2024 $2,098,000
Rooms
Floor Type Dimensions
Main Level Living Room 12'2 x 12'2 ft
Main Level Dining Room 12'2 x 12'2 ft
Main Level Kitchen 12'2 x 12'2 ft
Main Level Primary Bedroom 13'0 x 13'0 ft
Main Level Bedroom 9'5 x 9'5 ft
Main Level Bedroom 12'10 x 12'10 ft
Main Level Walk-In Closet 4'9 x 4'9 ft
Below Living Room 9'10 x 9'10 ft
Below Kitchen 10'0 x 10'0 ft
Below Bedroom 9'10 x 9'10 ft
Below Bedroom 9'10 x 9'10 ft
Below Living Room 12'1 x 12'1 ft
Below Kitchen 12'1 x 12'1 ft
Below Bedroom 8'6 x 8'6 ft
Below Bedroom 10'1 x 10'1 ft
Bathrooms
Floor Ensuite Pieces
Main Level Yes #3
Main Level No #4
Below No #3
Below No #3

Listed by: Sutton Group-West Coast Realty

NOTE: This representation is based in whole or in part on data generated by the Chilliwack & District Real Estate Board, Fraser Valley Real Estate Board or Greater Vancouver REALTORS® which assumes no responsibility for its accuracy.

Map & Neighbourhood

Public Schools

Elementary
Graham Bruce Community Elementary School
Average
0.54 km
6.1/10
Secondary
Windermere Community Secondary School
Average
1.36 km
6.3/10

Information includes BC Government Open License data; school details change often and are offered solely as general guidance.

Private Schools

Elementary
Vancouver Christian
Above Average
1.91 km
9.1/10
Secondary
Whytecliff Agile Learning Centre-Burnaby
Above Average
1.8 km
10/10

Closest Transit

Bus Stop
Westbound Vanness Ave @ Melbourne St
0.16 km
Skytrain
Skytrain @ Joyce Stn
0.40 km

Crime Rate

Total Crime Rate
Average
Violent Crime Rate
Below Average
Property Crime Rate
Above Average

Demographics

Post-Secondary Education
Below Average
22.5%
No Certificate/Degree
Above Average
20.2%
Owner Occupied
Below Average
58.6%
Employment Rate
Above Average
70.3%

Noise/ Power Lines

Road/Hwy Noise
Possible
Railway/Sky train Noise
Unlikely
Airport/Port Noise
Unlikely
Close to major Power Lines
Unlikely

Other

Agricultural Land Reserve (ALR)
Unlikely
Flood Area
Unlikely
Close to Cemeteries
Unlikely

Sell Speed & Competition

No data
Overall sell-speed score
Moderate pace expected
Price competition grade
No comparable data
Market conditions
Market conditions unavailable
Flood Risk (FEMA/BC)
Unlikely — not in floodplain
Railway / Skytrain noise
Unlikely — 0.40 km from station
Road / Highway noise
Possible — major road nearby
Airport noise (YVR)
Unlikely
Power lines proximity
Unlikely
ALR (Agricultural Land Reserve)
No — not in ALR
How COLLINGWOOD VE compares
This property
30 DOM
Listed
Collingwood VE avg
Vancouver avg

5174 Aberdeen Street has a sell-speed score of 50/100, placing it in the "Expected to sell at a moderate pace" band. The listing is has limited comparable pricing data available. Based on these signals, EstateBlock predicts this listing is may take several weeks to attract serious offers.

Climate Risk for V5R 4M3

Natural hazards vary by location and can change over time. The following provides a summary of potential impacts to this area, postal code V5R 4M3, over the next 30 years. Projections use the 2041–2070 period (2050s) under a moderate emissions scenario (SSP2-4.5).

Flood Lower Risk

Outside of designated flood hazard zones. Under 10% of buildings in this area have flood risk over the next 30 years.

Fire Low

Located within the "Vancouver" WUI zone (Risk Class 5 — Low). Based on BC Wildfire Service provincial WUI Risk Class mapping; not a site-specific assessment.

Air Quality A / Excellent

Annual avg PM2.5 4.4 µg/m³ — meets WHO 2021 guideline (BC ENV 2024). Nearest station: Burnaby South, Burnaby (~3.9 km). Annual avg AQHI 2.2 — Low Risk.

Heat Low

Vancouver currently sees ~1 days above 30 °C per year (1981–2010 baseline), projected to rise to ~6 by the 2050s (SSP2-4.5 moderate emissions). Hottest day of the year: ~29.7 °C baseline, ~32 °C projected. Tropical nights (>18 °C): ~0 baseline, ~4 projected.

Precipitation Increasing

Annual precipitation ~1515 mm (1981–2010 baseline), projected ~1575 mm by the 2050s. Extreme 1-day rainfall: ~50.5 mm baseline, ~57 mm projected. Values vary modestly across the Lower Mainland.

Drought Stable

Longest annual dry spell (consecutive dry days): ~22 days baseline, ~24 days projected for the 2050s. CDD is used as a regional drought proxy; drought risk varies modestly across the Lower Mainland.

Nearby Restaurants, Cafes & Shops

Schools NearBy

School Type Grades Served Catchment Info Rating Distance
Schools Near 5174 Aberdeen Street

Pre-computed routes from 5174 Aberdeen St, Vancouver, BC

By transit (Skytrain)

  • Downtown Vancouver via Joyce → Waterfront
    23 min
  • Metrotown, Burnaby via Joyce → Metrotown
    11 min
  • SFU Burnaby via Joyce → Production Way
    30 min
  • Richmond Centre via Joyce → Brighouse
    48 min
  • YVR Airport via Joyce → YVR-Airport
    49 min

By car (off-peak)

  • Downtown Vancouver via HWY 1 / Grandview
    10 min
  • Metrotown, Burnaby via Lougheed Hwy
    3 min
  • SFU Burnaby via Gaglardi Way
    10 min
  • Richmond Centre via No. 3 Rd
    13 min
  • YVR Airport via Bridgeport / Sea Island
    15 min

Calculate your commute

5174 Aberdeen St, Vancouver, BC is ideally located for commuters. The property is 0.4 km from Joyce, with a 23 min SkyTrain ride to Downtown Vancouver (Waterfront Station). The closest bus stop is Westbound Vanness Ave @ Melbourne St (0.16 km). Walk Score Transit rating: Excellent Transit (83/100).

Walkability & Transit Near 5174 Aberdeen Street

Walk Score Badge
Car-Dependent 88

Walk Score - Very Walkable

Most errands can be accomplished on foot
Transit Score Badge
Some Transit 83

Transit Score - Excellent Transit

Transit is convenient for most trips
Bike Score Badge
Somewhat
Bikeable
74

Bike Score - Very Bikeable

Biking is convenient for most trips

BC Assessment Value — 5174 Aberdeen Street

2026 assessed value, sourced from City of Vancouver open data (PID 014-792-966).
Total Assessed Value (2026)
$1,931,000
-4.0% YoY
+3.9%/yr over 4 yr
2022 Value Trend 2026
Land
$1,472,000
Buildings
$459,000
Year Built
2002
Class
Residential Inclusive
Zoning
R1-1
Property Tax
$9,869
Year Land Improvements Total Assessed YOY Change
2026 $1,472,000 $459,000 $1,931,000
-4.0%
2025 $1,557,000 $454,000 $2,011,000
+5.7%
2024 $1,560,000 $343,000 $1,903,000
+8.1%
2023 $1,430,000 $330,000 $1,760,000
+6.4%
2022 $1,338,000 $316,000 $1,654,000

Mortgage Calculator for 5174 Aberdeen Street

/month
Principal & Interest
Property Taxes $796
Maintenance fee 0
A 20% down payment of $419,600 on this $2,098,000 listing yields an estimated mortgage of $8,013/month (30-year fixed, 4%). Total estimated housing cost: $8,809/month, $796 property tax.
or Call 778-918-5990
All figures are informational estimates by EstateBlock.com; actual mortgage payments and insurance rates vary by many factors.
Listing data last synced:

Investment Cashflow Calculator

/month
Mortgage Payment
Monthly Payment
Break Even Down Payment 0%
Cap Rate
Cash on Cash
With $7,263/month in estimated rental income against $8,997/month in mortgage payments, the monthly cashflow is -$1,734/month. A 38% down payment would reach break-even.
All figures are informational estimates by EstateBlock.com; actual mortgage payments and insurance rates vary by many factors.

Price vs Neighbourhood Average — Collingwood VE, Vancouver

Beds Home Types Square Feet Lot Size Year Built
This Home $2,098,000
Vancouver Loading...
Collingwood VE Loading...

Based on 2 comparable active Single Family Residences in Collingwood VE, the average asking price is $1,966,000. This listing is priced 6.7% above the neighbourhood average.

Data is based on list prices of similar active listings. This representation is based in whole or in part on data generated by the Chilliwack & District Real Estate Board, Fraser Valley Real Estate Board or Real Estate Board of Greater Vancouver which assumes no responsibility for its accuracy

Listing Agent & Brokerage

Dan Marusin
Dan Marusin
Renanza Realty
778-918-5990
Award-Winning REALTOR® with 11+ Years of Experience Serving Greater Vancouver

Earn Cashback on Your Purchase

Potential Cashback for this listing if you buy with us

$0
out of $13,089
0 of 38 missions

Sign up on Estateblock.com

$654 / 5.00%

Sign up on EstateBlock.com

$262 / 2.00%

Buy with us & save on this property

Walkability & Transit Near 5174 Aberdeen Street

Walk Score Badge
Car-Dependent 88

Walk Score - Very Walkable

Most errands can be accomplished on foot
Transit Score Badge
Some Transit 83

Transit Score - Excellent Transit

Transit is convenient for most trips
Bike Score Badge
Somewhat
Bikeable
74

Bike Score - Very Bikeable

Biking is convenient for most trips

Similar Single Family Residences for Sale in Collingwood VE

Recently Sold Homes Near 5174 Aberdeen Street