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

Forgot password Extend Verify Contact

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

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

Bungalow featuring brick siding, roof with shingles, and a chimney
Photo 1: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 2: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 3: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 4: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 5: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 6: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 7: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 8: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 9: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 10: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 11: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 12: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 13: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 14: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 15: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 16: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 17: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 18: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 19: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 20: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 21: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 22: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 23: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 24: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 25: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 26: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 27: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 28: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 29: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 30: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 31: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 32: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 33: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 34: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 35: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 36: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 37: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 38: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 39: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 40: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 41: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 42: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 43: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 44: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 45: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 46: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Photo 47: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
Status:
Active
Prop. Type:
Residential
MLS® Num:
40798756
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. 3 bedroom unit on the main floor and 2 bedroom plus a den which can be used for various purposes in the 2nd unit, that makes 2nd unit with three rooms plus Living room, Kitchen, bathroom and its own separate laundry and cold room. 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
Water Heater, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
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:
Jan 23, 2026
  • Photo 1: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bungalow featuring brick siding, roof with shingles, and a chimney
  • Photo 2: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    View of side of property featuring brick siding, a chimney, and a porch
  • Photo 3: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bungalow-style home featuring a front lawn, a porch, a chimney, stone siding, and a shingled roof
  • Photo 4: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Doorway to property with brick siding and covered porch
  • Photo 5: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring white cabinetry, stainless steel appliances, light countertops, wall chimney exhaust hood, and recessed lighting
  • Photo 6: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring white cabinetry, stainless steel appliances, light countertops, wall chimney exhaust hood, and recessed lighting
  • Photo 7: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen with appliances with stainless steel finishes, wall chimney range hood, white cabinetry, light wood-style floors, and decorative backsplash
  • Photo 8: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen with appliances with stainless steel finishes, wall chimney range hood, white cabinetry, light wood-style floors, and decorative backsplash
  • Photo 9: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring white cabinets, decorative backsplash, light stone countertops, and dishwasher
  • Photo 10: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring stainless steel appliances, white cabinets, light wood-type flooring, wall chimney range hood, and open floor plan
  • Photo 11: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring white cabinets, stainless steel appliances, wall chimney range hood, recessed lighting, and light wood finished floors
  • Photo 12: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring white cabinets, stainless steel appliances, wall chimney range hood, recessed lighting, and light wood finished floors
  • Photo 13: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living area with light wood-style floors and recessed lighting
  • Photo 14: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living area with light wood-style floors and recessed lighting
  • Photo 15: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living room with light wood finished floors and recessed lighting
  • Photo 16: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living room with light wood finished floors and recessed lighting
  • Photo 17: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living room with recessed lighting and light wood-style floors
  • Photo 18: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    View of hallway
  • Photo 19: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom with light wood-style flooring and baseboards
  • Photo 20: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom with light wood-style flooring and baseboards
  • Photo 21: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom featuring baseboards and wood finished floors
  • Photo 22: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom featuring baseboards and wood finished floors
  • Photo 23: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bathroom with light marble finish flooring, vanity, a combined bath / shower with marble appearance, and stacked washer / dryer
  • Photo 24: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Full bathroom featuring vanity, light marble finish flooring, and a combined bath / shower with marble appearance
  • Photo 25: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom with light wood finished floors
  • Photo 26: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Staircase featuring wood finished floors
  • Photo 27: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living area with light wood-style flooring and recessed lighting
  • Photo 28: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living area with light wood-style floors and recessed lighting
  • Photo 29: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living room with a glass covered fireplace, wood finished floors, and recessed lighting
  • Photo 30: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Living room featuring wood finished floors, a glass covered fireplace, and recessed lighting
  • Photo 31: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen with white cabinets, light countertops, a peninsula, a kitchen bar, and stainless steel appliances
  • Photo 32: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring appliances with stainless steel finishes, white cabinetry, light wood-style flooring, recessed lighting, and under cabinet range hood
  • Photo 33: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen featuring a peninsula, appliances with stainless steel finishes, white cabinetry, recessed lighting, and a glass covered fireplace
  • Photo 34: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Kitchen with white cabinets, appliances with stainless steel finishes, and tasteful backsplash
  • Photo 35: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom featuring light wood-type flooring and baseboards
  • Photo 36: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom featuring light wood-type flooring
  • Photo 37: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bedroom with light wood finished floors
  • Photo 38: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Bathroom with light marble finish floors, vanity, and shower / bath combination with curtain
  • Photo 39: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Fenced backyard featuring a residential view, a storage unit, and a patio area
  • Photo 40: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Fenced backyard featuring a shed and a residential view
  • Photo 41: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Fenced backyard featuring a residential view
  • Photo 42: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Fenced backyard featuring a patio and a residential view
  • Photo 43: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Rear view of house featuring brick siding, a shed, a chimney, a patio area, and roof with shingles
  • Photo 44: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    View of front of home featuring roof with shingles, brick siding, a front yard, and driveway
  • Photo 45: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Aerial view of residential area featuring a tree filled landscape
  • Photo 46: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Aerial perspective of suburban area
  • Photo 47: 174 East 34th Street in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40798756
    Aerial perspective of suburban area

Virtual Tour

Listed by Right at Home Realty
Data was last updated January 24, 2026 at 05:50 AM (UTC)
Area Statistics
Listings on market:
52
Avg list price:
$672,450
Min list price:
$234,900
Max list price:
$1,599,900
Avg days on market:
42
Min days on market:
1
Max days on market:
291
Avg price per sq.ft.:
$450.26
These statistics are generated based on the current listing's property type and located in 17 - Hamilton Mountain. Average values are derived using median calculations. This data is not produced by the MLS® system.
powered by myRealPage.com