867 UPPER SHERMAN Avenue, Hamilton

$759,900
867 UPPER SHERMAN Avenue

$759,900

Price Change
37d
DetachedBungalow

867 UPPER SHERMAN Avenue, Hamilton

Total Monthly Obligation $3,862

Beds
4
Baths
2
Park
6
Sqft
1100-1500
DOM
37d
Score
21
Yield
5.5%
Cash on Cash
-0.6%
Cap Rate
4.5%
5Y IRR
15.1%
10Y IRR
14.2%
Property Type-Detached
MLS® Number-X13794596
Beds-4
Bathrooms-2
Size-1100-1500 sqft
Lot Size-50 × 100 ft
Listed on site-Sep 16, 2026
Style-Bungalow
Building Type-Detached
Age-51-99
Taxes-$5,061.01 (2026)
Parking-6 - None
Basement-Apartment, Finished, Full, Separate Entrance
Heating-Forced Air (Gas)
Brokerage-ROCK STAR REAL ESTATE INC.
Cooling-Central Air
Laundry-No
Fireplace-No
Pool-None
Facing-East
Exterior-Brick
Roof-Asphalt Shingle
Foundation-Concrete Block
Sewer-Sewer
Possession-Flexible
Neighbourhood-Thorner
Title-Residential Freehold

No agent assigned

Turnkey legal duplex on the desirable Hamilton Mountain! Main floor 2 bedroom unit can be easily be turned back into 3 bedrooms. With approximately 1,100 sq.ft. even the basement unit is very spacious. The main floor features a large kitchen, solid oak cabinetry, hardwood flooring throughout, 4-piece bath, and a spacious primary bedroom with gas fireplace. The open concept basement unit is approx 5 years old. Two hydro meters and two water meters allow each unit to pay 100% of their own utilities. Recent major updates include a newer A/C, roof and basement waterproofing. A+ tenants paying market rent, making this a turnkey investment, or live in one unit and have the other help offset your mortgage. Double-wide driveway to complete the package!

$
$
%
%
$
$
$
(utilities, internet...)
$
%
%

Closing Costs

Mortgage Amount
$607,920
Land Transfer Taxes$11,673
Legal Fees (Est.)
$
Total cash required for closing$165,153

Total Monthly Obligation

$3,862/mo
Mortgage $3,065
Monthly Loss $3,055
Principal$807
Interest$2,259
Property Tax$422
Home Insurance$125
Variable Costs$250
Returns
Weight: 25%
Cap Rate
3.7%24
Cash-on-Cash
-5.4%2
5-Year IRR
11.3%45
10-Year IRR
11.6%
Returns Index
23.6/ 100
Growth Sentiment
Weight: 20%
%/yr
Score+50
%/yr
Score+50
%
%
Growth Index
50.0/ 100
GradeD
21/ 100
Avoid•Pass

Strategy: Buy & Hold — Weights: CFI 35% · RI 25%
RKI 20% · GI 20%

Assumptions & Inputs
$/mo
%
$
yr
%
Cash Flow
Weight: 35%
Gross Rent
$41,640/yr
NOI
$27,915/yr
Net Cash Flow
-$739/mo
Cash Margin
-21.3%0
Cash Flow Index
0.1/ 100
Risk Profile
Weight: 20%
DSCR
0.7612
LTV Ratio
80.0%18
Vacancy Buffer
2.5 mo40
Risk Index
23.4/ 100

*This analysis is independently generated NOT provided by TREB or CREA.

Comparables

Properties near 867 UPPER SHERMAN Avenue

Time

Comparables are calculated within a 3km radius based on properties sold or leased within the past 6 months. This helps you understand the current market value and potential rental yield with high precision.

Data is provided courtesy of PropTx.

The information provided herein must only be used by consumers who have a bona fide interest in the purchase, sale, or lease of real estate and may not be used for any commercial or other purpose.

Listing information is deemed reliable but not guaranteed accurate by PropTx or TRREB.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks owned by REALTOR® Canada Inc. and licensed exclusively to the Canadian Real Estate Association (CREA).

The MLS® trademark and MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

Data last updated within the past 24 hours.