823 Queensdale Avenue E in Hamilton: 174 – Raleigh Single Family Residence for sale (17 – Hamilton Mountain) : MLS®# 40816624

Forgot password Extend Verify Contact

823 Queensdale Avenue E
174 - Raleigh Hamilton L8V 1M7

$549,786
Residential beds: 4 baths: 2.0 900 sq. ft.

Stone veneer and siding exterior with a single-car garage and asphalt driveway
Photo 1: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 2: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 3: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 4: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 5: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 6: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 7: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 8: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 9: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 10: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 11: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 12: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 13: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 14: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 15: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 16: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 17: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 18: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 19: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 20: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 21: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 22: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 23: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 24: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 25: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 26: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 27: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 28: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 29: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 30: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 31: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 32: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 33: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 34: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 35: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 36: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Photo 37: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
Status:
Active
Prop. Type:
Residential
MLS® Num:
40816624
Bedrooms:
4
Bathrooms:
2
Brightly renovated 3-bed home with open-concept living, upgraded kitchen, updated hardwood floors and modern finishes. Generous bedrooms, updated bath and large private backyard — ideal for families or investors; lower-level side entrance offers easy in-law or rental setup. Roof solar lease currently generates approx. $400/yr (ownership transfers later). Minutes to schools, parks, transit and shopping — move-in ready with strong rental/ resale potential. (Recent Upgrades & Improvements) - Brand New Insulated front Garage Door with Remote Control, Concrete work at the front , Driveway sealing , Front porch improvements - repaired/painted decking and trim, Concrete Steps and freshly Painted Railings, Landscaping touch-ups, exterior paint touch-ups, and general clean-up to present a move-in ready exterior.
Property Type:
Residential
Property SubType:
Single Family Residence
Listing General Location:
174 - Raleigh, 17 - Hamilton Mountain
Bedrooms:
4
Bathrooms:
2.0 (Full:2/Half:0)
Lot Size:
4,356 sq. ft.
Lot Details:
45 x 93.37
Lot Depth:
93'4½"
Lot Frontage:
45'
Frontage Type:
East
Kitchens:
1
Home Style:
Bungalow
County Or Parish:
Hamilton
Taxes:
Property Attached:
Detached
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Construction:
Aluminum Siding, Brick, Block, Stone, Vinyl Siding
Basement:
Full, Finished
Linked Foundation:
No
Roof:
Asphalt Shing
Number of Buildings:
0
Total Floor Area:
900 sq. ft.
# Main Level Bedrooms:
2
# Main Level Bathrooms:
1
Finished Area Above Grade:
900 sq. ft.
Fireplace:
false
Water Supply:
Municipal
Sewer:
Sewer (Municipal)
Cooling:
Central Air
Heating:
Forced Air
Built-in Microwave,Dishwasher,Dryer,Refrigerator,Stove,Washer,Window Coverings
Oven, Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer
Seller Personal Belongings
Solar Owned
Window Coverings
false
No
No
Floor
Type
Size
Other
Main Floor
Main Floor
Main Floor
Main Floor
Lower Level
Lower Level
Floor
Ensuite
Pieces
Other
Main Floor
Lower Level
HST Applicable To Sale Price:
Included
Association Fee:
Association Fee Frequency:
Association Fee 2:
Association Fee 2 Frequency:
Administrative Fee:
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Road Access Fee:
Condo Corporation:
No
Lease to Own Equipment:
Solar Panels
Zoning:
R1
Total Acres:
0.1
Lot Site Features:
Urban, Place of Worship, Public Transit, Quiet Area, Schools
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Garage Spaces:
1.0
Parking Places Covered:
1.0
Parking:
Attached Garage
# Of Total Parking Spaces:
3.0
# Of Open Parking Spaces:
2.0
Driveway Parking:
Front Yard Parking
Num Other Units:
0
Total Units:
Listed Date:
Mar 31, 2026
  • Photo 1: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Stone veneer and siding exterior with a single-car garage and asphalt driveway
  • Photo 2: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Kitchen featuring white cabinetry, stainless steel appliances, a tile backsplash, and recessed lighting
  • Photo 3: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Kitchen featuring white cabinetry, stainless steel appliances, recessed lighting, wood-finish flooring, and a white paneled door with frosted glass
  • Photo 4: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Modern kitchen featuring white shaker-style cabinetry with gold-tone hardware, stainless steel appliances, a gas range with an overhead microwave, and light-toned countertops
  • Photo 5: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Modern kitchen featuring white shaker cabinetry with gold-tone hardware, light-toned countertops, and wood-finish flooring
  • Photo 6: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Open-concept living space featuring wood-finish flooring, recessed lighting, and a ceiling fan
  • Photo 7: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Contemporary kitchen featuring white cabinetry, a white countertop island, stainless steel appliances, and wood-finish flooring
  • Photo 8: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Kitchen featuring wood-finish flooring, white cabinetry, a central island with countertop seating, stainless steel appliances, and recessed lighting
  • Photo 9: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Living space featuring wood-finish flooring, recessed lighting, crown molding, and a ceiling fan
  • Photo 10: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Spacious interior room featuring wood-finish flooring, crown molding, and recessed lighting
  • Photo 11: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bright living area featuring wood-finish flooring, recessed lighting, a ceiling fan, and crown molding
  • Photo 12: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Dining area featuring wood-finish flooring, recessed lighting, crown molding, and a large window with privacy sheers and drapes
  • Photo 13: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Living area featuring recessed lighting, crown molding, wood-finish flooring, and white baseboards
  • Photo 14: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Kitchen featuring white cabinetry, wood-finish flooring, recessed lighting, a built-in stainless steel microwave, and a central island with a solid surface countertop
  • Photo 15: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Hallway with wood-finish flooring, white walls, and recessed lighting
  • Photo 16: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Spacious room featuring wood-finish flooring, recessed lighting, and a ceiling fan
  • Photo 17: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bedroom featuring wood-finish flooring, recessed lighting, and a ceiling fan
  • Photo 18: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bathroom featuring a vanity with an integrated sink, a rectangular mirror with integrated lighting, tiled walls, wood-finish flooring, and a single window
  • Photo 19: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bathroom featuring a framed mirror, a vanity with an integrated sink, a window with white trim, a toilet, and full-height wall tiling
  • Photo 20: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Shower enclosure featuring a sliding glass door and white marble-look wall tiling
  • Photo 21: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bright room featuring recessed lighting and a ceiling fan
  • Photo 22: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bright interior space featuring light-colored walls, wood-finish flooring, a rectangular window with white trim, and a second narrow vertical window
  • Photo 23: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    White paneled door with frosted glass window and wood-finish flooring
  • Photo 24: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Wood-finish staircase with white risers and light-colored walls
  • Photo 25: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Interior space featuring wood-finish flooring and light-toned walls
  • Photo 26: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Finished lower level with wood-finish flooring, recessed lighting, and a window for natural light
  • Photo 27: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Recessed ceiling lighting illuminates the room with gray carpeting and white walls
  • Photo 28: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Room featuring recessed lighting, a built-in air vent, and light-colored walls
  • Photo 29: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Carpeted room featuring a wooden headboard, recessed lighting, and white walls
  • Photo 30: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Spacious room featuring wood-finish flooring, light blue walls, and white baseboards
  • Photo 31: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bedroom featuring light blue walls and wood-finish flooring
  • Photo 32: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Room featuring light blue walls, recessed lighting, wood-finish flooring, and a white interior door
  • Photo 33: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Dedicated laundry area featuring stacked front-load machines, wood-finish flooring, and a paneled interior door
  • Photo 34: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Bathroom featuring a corner shower enclosure with frosted glass, a white vanity with cabinet storage, and a white toilet
  • Photo 35: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Corner shower enclosure with frosted glass panels, white beadboard vanity with integrated sink, and light blue wall finish
  • Photo 36: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Expansive rear yard featuring a sloped lawn, mature perimeter trees, and two storage sheds
  • Photo 37: 823 Queensdale Avenue E in Hamilton: 174 - Raleigh Single Family Residence for sale (17 - Hamilton Mountain)  : MLS®# 40816624
    Expansive backyard featuring a natural grass lawn, a dedicated storage shed, and mature perimeter trees
Listed by ROYAL LEPAGE FLOWER CITY REALTY
Data was last updated June 1, 2026 at 03:50 AM (UTC)
Area Statistics
Listings on market:
11
Avg list price:
$549,786
Min list price:
$349,777
Max list price:
$769,900
Avg days on market:
39
Min days on market:
2
Max days on market:
89
Avg price per sq.ft.:
$564.16
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