Sep 16, 2026
04:00 PM
-
07:00 PM
EDT
870 QUEENSTON Road Unit# 604
Stoney Creek
L8G 0B9
$2,499 /mth
Single Family
beds: 2
baths: 2.0
956 sq. ft.
Open House
-
Sep 16, 2026
04:00 PM
-
07:00 PM
EDT
NOTES: Open House on Wednesday, September 16, 2026 4:00PM - 7:00PM
- Status:
- For Rent
- Prop. Type:
- Single Family
- MLS® Num:
- 40848183
- Bedrooms:
- 2
- Bathrooms:
- 2
- Photos (45)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
Experience elevated rental living in this brand new, condo-inspired apartment building, ideally located in the heart of it all. Enjoy unmatched convenience with quick access to major highways (both East & West), plus close proximity to shopping, dining, and everyday amenities. Thoughtfully designed and expertly crafted by a trusted local builder, this boutique building offers a level of space and functionality rarely found in rental living. No other building in the area delivers this combination of size, layout, and design-forward finishes. This expansive 2-bedroom + den/flex suite is perfectly suited for modern living, offering incredible versatility — ideal as a home office, formal dining area, entertainment space, or even a third bedroom. Open-concept layouts, high-quality finishes, and oversized windows create a bright and welcoming atmosphere throughout. Residents also enjoy access to a communal gym located on the fourth floor, pet wash station and nearby scenic walking trails for an active lifestyle. Parking and locker available for an additional monthly fee. Parking $100,Lockers $50. A rare opportunity to lease a truly elevated space that blends the comfort of condo living with the ease of purpose-built rental. (id:2493)
- Property Type:
- Single Family
- Common Interest:
- Freehold
- Property Attached:
- Yes
- Total Living Area:
- 956 sq. ft.
- Finished Area Above Grade:
- 956 sq. ft.
- Rental Price Per Month:
- $2,499
- Zoning:
- P5, RM5-11
- Association Fee Includes:
- Exterior Maintenance, Heat
- Community:
- 273 - Riverdale
- Features:
- Exercise Centre
- Exterior Features:
- Stone, Other
- Structure Type:
- Apartment
- Appliances Included:
- Washer, Refrigerator, Dishwasher, Stove, Dryer
- Home Style:
- Other
- Bedrooms:
- 2
- Bedrooms Above Grade:
- 2
- Bedrooms Below Grade:
- 0
- Bathrooms:
- 2.0
- Fireplace:
- No
- Heating:
- Geo Thermal
- # Storeys:
- 12.0
- Water:
- Municipal water
- Sewer:
- Municipal sewage system
- Basement:
- None
- Lot Frontage:
- 235'
- Lot Size:
- 2.41 acre(s)
- Lot Details:
- 2.41
- Lot Features:
- Balcony
- Parking:
- Underground, Visitor Parking
- Total Parking Spaces:
- 1
- Floor
- Type
- Size
- Other
- Main level
- Bedroom
- 12'8" × 8'11"
- -
- Main level
- Primary Bedroom
- 15'8" × 9'3"
- -
- Main level
- Den
- 10' × 7'7"
- -
- Main level
- Kitchen
- 8'4" × 7'3"
- -
- Main level
- Great room
- 16'7" × 9'9"
- -
- Floor
- Ensuite
- Pieces
- Other
- Main level
- No
- 4
- Main level
- No
- 3
-
View of building exterior with uncovered parking -
Floor plan
-
Photo 3 of 45
-
Photo 4 of 45
-
Photo 5 of 45
-
Photo 6 of 45
-
Photo 7 of 45
-
Photo 8 of 45
-
Photo 9 of 45
-
Photo 10 of 45
-
Photo 11 of 45
-
Photo 12 of 45
-
Photo 13 of 45
-
Photo 14 of 45
-
Photo 15 of 45
-
Photo 16 of 45
-
Photo 17 of 45
-
Photo 18 of 45
-
Photo 19 of 45
-
Photo 20 of 45
-
Photo 21 of 45
-
Photo 22 of 45
-
Photo 23 of 45
-
Photo 24 of 45
-
Photo 25 of 45
-
Photo 26 of 45
-
Photo 27 of 45
-
Photo 28 of 45
-
Photo 29 of 45
-
Photo 30 of 45
-
Photo 31 of 45
-
Photo 32 of 45
-
Photo 33 of 45
-
Photo 34 of 45
-
Photo 35 of 45
-
Photo 36 of 45
-
Photo 37 of 45
-
Photo 38 of 45
-
Photo 39 of 45
-
Photo 40 of 45
-
Photo 41 of 45
-
Photo 42 of 45
-
Photo 43 of 45
-
Photo 44 of 45
-
View of urban area
Listed by RE/MAX Escarpment Realty Inc.
Data was last updated September 16, 2026 at 06:15 PM (UTC)
Area Statistics
- Listings on market:
- 26
- Avg list price:
- $512,450
- Min list price:
- $260,000
- Max list price:
- $849,990
- Avg days on market:
- 55
- Min days on market:
- 1
- Max days on market:
- 148
- Avg price per sq.ft.:
- $415.14
These statistics are generated based on the current listing's property type
and located in
273 - Riverdale. Average values are
derived using median calculations. This data is not produced by
the MLS® system.
- SCOTT FOSTER
- 208 OTTAWA ST N
- 1 (905) 9733348
- Contact by Email
FOSTER Living
Selling Your Lifestyle
Office Address:
208 Ottawa St. N
Hamilton, ON, L8H 3Z6