174 East 34th Street in Hamilton: 174 – Raleigh Single Family Residence for sale (17 – Hamilton Mountain) : MLS®# 40761114

Forgot password Extend Verify Contact

174 East 34th Street
174 - Raleigh Hamilton L8V 3W6

$859,900
Residential beds: 5 baths: 2.0 1,800 sq. ft.

View of front of home featuring brick siding, a chimney, and roof with shingles
Photo 1: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 2: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 3: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 4: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 5: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 6: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 7: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 8: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 9: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 10: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 11: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 12: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 13: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 14: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 15: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 16: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 17: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 18: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 19: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 20: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 21: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 22: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 23: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 24: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 25: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 26: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 27: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 28: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 29: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 30: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 31: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 32: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 33: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 34: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 35: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 36: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 37: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 38: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 39: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Photo 40: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
Status:
Active
Prop. Type:
Residential
MLS® Num:
40761114
Bedrooms:
5
Bathrooms:
2
LEGAL TWO FAMILY HOME, SELF CONTAINED 2 RESIDENTIAL UNITS HOME WITH GROUND LEVEL SEPARATE ENTRANCE TO BOTH UNITS, 2nd LEGAL UNIT ADDED WITH CITY BUILDING PERMIT. EXCEPTIONALLY STUNNING. GREAT INVESTMENT OPPORTUNITY to rent both or live in one and rent the other one out of two units. Both units have access to each other from inside which is ideal for a large family. Desirable Mountain Location, Professionally renovated from top to bottom. Very modern Open concept in both units, New Plumbing, Separate hydro meters with Newly upgraded 200 amp service and upgraded wiring. Fire separation between two units, resilient channels, safe & sound insulation in basement ceiling. Hardwired Interconnected smoke and CO detectors, New Furnace with smoke detector for added fire safety, New CENTRAL A/C, New Modern Fireplace. 2 Custom New Kitchens, Quartz countertop, back splash and All new Appliances. 2 Laundries with washers and dryers. 2 New Bathrooms with modern vanities, lights & Porcelain tiles. Newer roof, New pot lights, New plumbing, New flooring, New baseboard, New trims, New doors interior and exterior, thermal windows, Newly paved double 5 cars driveway. Storage shed. Big Patio in the backyard with mature trees for cool summer entertainment. Mature quiet neighborhood. Walking distance to shopping malls, Restaurants and Public Transit. Minutes to highway. RSA
Property Type:
Residential
Property SubType:
Single Family Residence
Listing General Location:
174 - Raleigh, 17 - Hamilton Mountain
Bedrooms:
5
Bathrooms:
2.0 (Full:2/Half:0)
Lot Details:
40 x 100
Lot Depth:
100'
Lot Frontage:
40'
Frontage Type:
West
Kitchens:
2
Home Style:
Bungalow
Elementary School:
Blessed Sacrament, Highview Public
High School:
Sherwood, St. Jean De Brebeuf
County Or Parish:
Hamilton
Taxes:
Property Attached:
Detached
Features:
Attached Garage: No, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Construction:
Brick
Basement:
Separate Entrance, Full, Finished
Foundation:
Poured Concrete
Roof:
Asphalt Shing
Number of Buildings:
1
Other Structures:
Shed(s)
Total Floor Area:
1,800 sq. ft.
# Main Level Bedrooms:
3
# Main Level Bathrooms:
1
Finished Area Above Grade:
900 sq. ft.
Finished Area Below Grade:
900 sq. ft.
Fireplace:
true
Fireplaces:
1
Fireplace Details:
Electric
Laundry Features:
In-Suite
Water Supply:
Municipal
Water Meter:
Yes
Sewer:
Sewer (Municipal)
Cooling:
Central Air
Heating:
Forced Air
Dishwasher,Dryer,Range Hood,Refrigerator,Smoke Detector,Stove,Washer,All New 2 Fridges, 2 Stoves, 2 Dishwashers, 2 Range Hoods, 2 Washers, 2 Dryers, Fireplace
Water Heater, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
All Staging Furniture And Matterial
Separate Hydro Meters, Water Meter
Patio, Porch
false
No
Upper Gage to Brucedale to East 34th - west side of road
No
Smoke Detector
Floor
Type
Size
Other
Main Floor
Main Floor
Main Floor
Main Floor
Main Floor
Basement
Basement
Basement
Basement
Basement
Basement
Floor
Ensuite
Pieces
Other
Main Floor
Basement
HST Applicable To Sale Price:
Included
Association Fee:
Association Fee Frequency:
Association Fee 2:
Association Fee 2 Frequency:
Administrative Fee:
Features:
Attached Garage: No, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Road Access Fee:
Condo Corporation:
No
Zoning:
R1
Topography:
Flat
Lot Site Features:
Urban, Rectangular, Ample Parking, Hospital, Major Highway, Public Transit, School Bus Route, Shopping Nearby
Features:
Attached Garage: No, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Garage Spaces:
0.0
Parking Places Covered:
0.0
Parking:
Asphalt
# Of Total Parking Spaces:
5.0
# Of Open Parking Spaces:
5.0
Driveway Parking:
Private Drive Double Wide
Num Other Units:
0
Total Units:
Listed Date:
Aug 20, 2025
  • Photo 1: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    View of front of home featuring brick siding, a chimney, and roof with shingles
  • Photo 2: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bungalow-style home featuring brick siding, a front lawn, covered porch, and a chimney
  • Photo 3: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    View of exterior entry featuring brick siding and covered porch
  • Photo 4: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    View of subject property
  • Photo 5: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    View of front of property with a shingled roof, asphalt driveway, brick siding, stairs, and a chimney
  • Photo 6: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    View of front of house featuring brick siding and a front lawn
  • Photo 7: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Photo 7 of 40
  • Photo 8: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen featuring appliances with stainless steel finishes, white cabinets, light wood finished floors, light countertops, and recessed lighting
  • Photo 9: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen featuring stainless steel appliances, wall chimney range hood, white cabinetry, light wood finished floors, and recessed lighting
  • Photo 10: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen featuring white cabinets, light stone countertops, and tasteful backsplash
  • Photo 11: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen with white cabinets, appliances with stainless steel finishes, wall chimney range hood, light wood-type flooring, and recessed lighting
  • Photo 12: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living room featuring light wood-style floors and recessed lighting
  • Photo 13: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living area featuring light wood finished floors and recessed lighting
  • Photo 14: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living room with recessed lighting and light wood-style floors
  • Photo 15: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom featuring light wood-type flooring
  • Photo 16: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom with baseboards and wood finished floors
  • Photo 17: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bathroom featuring light marble finish floors, shower / bath combination with curtain, vanity, and stacked washer / dryer
  • Photo 18: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Full bathroom featuring shower / tub combo with curtain and vanity
  • Photo 19: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom featuring light wood-type flooring and baseboards
  • Photo 20: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living room featuring light wood-style floors and recessed lighting
  • Photo 21: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living area featuring light wood-style flooring and recessed lighting
  • Photo 22: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living area with wood finished floors, a glass covered fireplace, and recessed lighting
  • Photo 23: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Living area with wood finished floors, recessed lighting, and a glass covered fireplace
  • Photo 24: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen with white cabinets, light wood finished floors, light countertops, a peninsula, and a breakfast bar
  • Photo 25: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen featuring white cabinetry, appliances with stainless steel finishes, recessed lighting, light wood-style flooring, and under cabinet range hood
  • Photo 26: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Kitchen featuring a peninsula, appliances with stainless steel finishes, white cabinets, recessed lighting, and under cabinet range hood
  • Photo 27: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom featuring light wood-style flooring and baseboards
  • Photo 28: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom with light wood-style flooring and baseboards
  • Photo 29: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bedroom featuring light wood-type flooring
  • Photo 30: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bathroom featuring shower / bath combo with shower curtain and vanity
  • Photo 31: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Fenced backyard with a storage unit
  • Photo 32: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Fenced yard featuring a patio area
  • Photo 33: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Bird's eye view
  • Photo 34: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial perspective of suburban area
  • Photo 35: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial view of residential area
  • Photo 36: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial perspective of suburban area
  • Photo 37: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial perspective of suburban area with a large body of water
  • Photo 38: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial view of residential area with a large body of water
  • Photo 39: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial view of residential area
  • Photo 40: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40761114
    Aerial view of residential area

Virtual Tour

Listed by Right at Home Realty
Data was last updated August 25, 2025 at 05:50 PM (UTC)
Area Statistics
Listings on market:
13
Avg list price:
$599,111
Min list price:
$274,900
Max list price:
$859,900
Avg days on market:
25
Min days on market:
3
Max days on market:
203
Avg price per sq.ft.:
$502.28
These statistics are generated based on the current listing's property type and located in 174 - Raleigh. Average values are derived using median calculations. This data is not produced by the MLS® system.
powered by myRealPage.com