array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29800479 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1457398"
+post_author: 1
+"ListingKey": "29800479"
+"ListingId": "40833239"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T22:40:01Z"
+"RFModificationTimestamp": "2026-07-02T22:43:36Z"
+"ListPrice": 439990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1088.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4L2"
+"UnparsedAddress": "1025 UPPER GAGE Avenue Unit# 1, Hamilton, Ontario L8V4L2"
+"Coordinates": array:2 [
0 => -79.8447512
1 => 43.2132125
]
+"Latitude": 43.2132125
+"Longitude": -79.8447512
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this renovated and well-maintained end-unit townhome in a desirable and family friendly neighbourhood. The open-concept main level features brand new laminate flooring throughout, a spacious living room with a stylish electric fireplace wall, full dining area and large eat-in kitchen. The second floor features three generously sized, carpet-free bedrooms and a four-piece bathroom. Perfectly situated close to all major amenities-including schools, parks, restaurants, shopping, public transit, and highway access-this home truly has it all. There's nothing left to do but move in! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "551"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T18:04:43.027312+00:00"
+"Directions": "Upper Gage Ave to Beryl St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2083034"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-25T16:59:51Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T22:33:25Z"
+"Stories": "2.0"
+"StreetName": "UPPER GAGE"
+"StreetNumber": "1025"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "260 - Berrisfield"
+"TaxAnnualAmount": "2649.93"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1673682067"
"RoomType" => "Utility room"
"ListingId" => "40833239"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
1 => array:11 [
"RoomKey" => "1673682068"
"RoomType" => "Mud room"
"ListingId" => "40833239"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
2 => array:11 [
"RoomKey" => "1673682069"
"RoomType" => "Laundry room"
"ListingId" => "40833239"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
3 => array:11 [
"RoomKey" => "1673682070"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833239"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
4 => array:11 [
"RoomKey" => "1673682071"
"RoomType" => "Bedroom"
"ListingId" => "40833239"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
5 => array:11 [
"RoomKey" => "1673682072"
"RoomType" => "Bedroom"
"ListingId" => "40833239"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
6 => array:11 [
"RoomKey" => "1673682073"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833239"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
7 => array:11 [
"RoomKey" => "1673682074"
"RoomType" => "Kitchen"
"ListingId" => "40833239"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
8 => array:11 [
"RoomKey" => "1673682075"
"RoomType" => "Dining room"
"ListingId" => "40833239"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.67Z"
]
9 => array:11 [
"RoomKey" => "1673682076"
"RoomType" => "Living room"
"ListingId" => "40833239"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29800479"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:33:25.68Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29800479/1025-upper-gage-avenue-unit-1-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "DE/S-236"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1088
+"OriginalEntryTimestamp": "2026-05-25T16:59:51.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1357800"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29800479_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/0aba1e9b8e8f255740392c2622df7453.webp"
"MediaSize" => 159336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-0aba1e9b8e8f255740392c2622df7453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29800479_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/94a5fcd2ef8d02c70e4f09171c3ebb74.webp"
"MediaSize" => 125167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-94a5fcd2ef8d02c70e4f09171c3ebb74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29800479_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/262112439745af1659f57a9db133e1db.webp"
"MediaSize" => 51468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-262112439745af1659f57a9db133e1db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29800479_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/503f54ff06a269ce046b15bca153813b.webp"
"MediaSize" => 60373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-503f54ff06a269ce046b15bca153813b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29800479_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/a57982510d5fc8b7da613637f8a36f0a.webp"
"MediaSize" => 72306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-a57982510d5fc8b7da613637f8a36f0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29800479_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/0b9846298c68b1665944b625ca9c3b8d.webp"
"MediaSize" => 83089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-0b9846298c68b1665944b625ca9c3b8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29800479_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/c3f4455ecc9c37803d27f26232289d28.webp"
"MediaSize" => 74299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-c3f4455ecc9c37803d27f26232289d28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29800479_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/bab109c8a2b597e34fe623b455fa02a2.webp"
"MediaSize" => 72463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-bab109c8a2b597e34fe623b455fa02a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29800479_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/f2e2583214595750e225b30f80a8c640.webp"
"MediaSize" => 69354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-f2e2583214595750e225b30f80a8c640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29800479_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/e13a54f385a98f35d900952b03712ae4.webp"
"MediaSize" => 83163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-e13a54f385a98f35d900952b03712ae4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29800479_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/102cd1c87ae05a8567e11a7eaa342f3b.webp"
"MediaSize" => 82824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-102cd1c87ae05a8567e11a7eaa342f3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29800479_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/85306a2cea4e1f27c847e4a7e6b149eb.webp"
"MediaSize" => 73248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-85306a2cea4e1f27c847e4a7e6b149eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29800479_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/2e6454ab5e4fdeff2ff47b0fa35f1b7b.webp"
"MediaSize" => 71011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-2e6454ab5e4fdeff2ff47b0fa35f1b7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29800479_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/f8414c15cdcc3e016719739bae403032.webp"
"MediaSize" => 85847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-f8414c15cdcc3e016719739bae403032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29800479_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/8bce7af99454b238b315683166006966.webp"
"MediaSize" => 68204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-8bce7af99454b238b315683166006966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29800479_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/fe235eec3168aea5bf91fe7eb9adbd8f.webp"
"MediaSize" => 75647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-fe235eec3168aea5bf91fe7eb9adbd8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29800479_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/a7fa90eb7d83274cf18f8f23b6dad7d7.webp"
"MediaSize" => 76162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-a7fa90eb7d83274cf18f8f23b6dad7d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29800479_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/757b492816df607a900d520878c39109.webp"
"MediaSize" => 89473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-757b492816df607a900d520878c39109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29800479_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/705aa6ef1b15162f449e857eca112dd4.webp"
"MediaSize" => 94962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-705aa6ef1b15162f449e857eca112dd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29800479_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/fbbca14275a5276c161b23cdfb9d8d74.webp"
"MediaSize" => 66613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-fbbca14275a5276c161b23cdfb9d8d74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29800479_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/83d4d68c8bfc1263a0234311aba9ab5f.webp"
"MediaSize" => 152343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-83d4d68c8bfc1263a0234311aba9ab5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29800479_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/b8df363e0ff7a4450fd460d5137aff23.webp"
"MediaSize" => 163046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-b8df363e0ff7a4450fd460d5137aff23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29800479_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29800479/917222bb5db62c979036f2e8390dd013.webp"
"MediaSize" => 157183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29800479/thumbnail-917222bb5db62c979036f2e8390dd013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833239"
"ResourceRecordKey" => "29800479"
"ModificationTimestamp" => "2026-05-25T16:59:51.74Z"
]
]
+"DaysOnMarket": 41
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29800479')"
+"ID": "1457398"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 54949" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24845
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2083034" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24848
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29800479'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25223
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29800479'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25239
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29800479' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8447512 43.2132125)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25292
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1593558"
+post_author: 1
+"ListingKey": "29989512"
+"ListingId": "X13522770"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:15:03Z"
+"RFModificationTimestamp": "2026-07-04T19:00:18Z"
+"ListPrice": 1.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Trenholme)"
+"PostalCode": "L8W2L4"
+"UnparsedAddress": "35 TRENHOLME CRESCENT, Hamilton (Trenholme), Ontario L8W2L4"
+"Coordinates": array:2 [
0 => -79.825281
1 => 43.203435
]
+"Latitude": 43.203435
+"Longitude": -79.825281
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare find: a home that works as hard as you do. Set on a premium 42 x 110 ft lot, this 4+2 bedroom, 4-bath residence delivers over 3,156 sq. ft. of purposefully designed space, anchored by one of the most versatile layouts on the market at this price point. Extended family, rental income, or room to grow - this home is built to move with your life, not against it. The main level opens with a fully refinished white chef's kitchen - quartz counters, stainless appliances, porcelain tile and crown moulding - flowing into an open-concept living and dining space designed for entertaining, complemented by a separate family room for everyday living and privacy. A main-floor bedroom with a private full bath with standing tub, solves what most homes can't: multigenerational living, guest privacy, disabled friendly living, or a dedicated home office. Upstairs, the primary suite commands the full width of the home, featuring his-and-hers closets, a newly updated ensuite, and space for a private sitting area. The remaining bedrooms are generously sized and filled with natural light. The fully finished basement, with its own private side entrance, houses a complete in-law suite: two bedrooms, a full bath, kitchen, spacious rec room, and in-suite laundry. Live up and rent down, house extended family, or claim the entire home - the flexibility is yours. Extensively upgraded and move-in ready: hardwood flooring on the main level, refreshed bathrooms (2025), roof (2022), concrete driveway (2022), most windows (2023), fresh paint throughout (2025), and a new garage door (2026). Smoke-free, pet-free interior. Located in a quiet, established neighbourhood minutes from parks, schools, shopping, transit, and major highways - this is the kind of home buyers are actively searching for and rarely find. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T19:00:09.544934+00:00"
+"Directions": "Upper Kenilworth"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2075003"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "41 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T16:08:56Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:08:56Z"
+"Stories": "2.0"
+"StreetName": "Trenholme"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6647"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1675033539"
"RoomType" => "Living room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29989512"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.23Z"
]
1 => array:11 [
"RoomKey" => "1675033540"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 2.16
"ListingKey" => "29989512"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.23Z"
]
2 => array:11 [
"RoomKey" => "1675033541"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.11
"ListingKey" => "29989512"
"RoomLength" => 8.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
3 => array:11 [
"RoomKey" => "1675033542"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.38
"ListingKey" => "29989512"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
4 => array:11 [
"RoomKey" => "1675033543"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 6.09
"ListingKey" => "29989512"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
5 => array:11 [
"RoomKey" => "1675033544"
"RoomType" => "Kitchen"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.07
"ListingKey" => "29989512"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
6 => array:11 [
"RoomKey" => "1675033545"
"RoomType" => "Laundry room"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29989512"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
7 => array:11 [
"RoomKey" => "1675033546"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29989512"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
8 => array:11 [
"RoomKey" => "1675033547"
"RoomType" => "Dining room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.32
"ListingKey" => "29989512"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
9 => array:11 [
"RoomKey" => "1675033548"
"RoomType" => "Kitchen"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29989512"
"RoomLength" => 4.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
10 => array:11 [
"RoomKey" => "1675033549"
"RoomType" => "Family room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 6.58
"ListingKey" => "29989512"
"RoomLength" => 5.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
11 => array:11 [
"RoomKey" => "1675033550"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
12 => array:11 [
"RoomKey" => "1675033551"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 1.9
"ListingKey" => "29989512"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
13 => array:11 [
"RoomKey" => "1675033552"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.74
"ListingKey" => "29989512"
"RoomLength" => 7.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
14 => array:11 [
"RoomKey" => "1675033553"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
15 => array:11 [
"RoomKey" => "1675033554"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
16 => array:11 [
"RoomKey" => "1675033555"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 1.86
"ListingKey" => "29989512"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Trenholme"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989512/35-trenholme-crescent-hamilton-trenholme-trenholme"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-07-04T16:08:56.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1350157"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29989512_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d8bd332a781b1f968b973fa88b4ae992.webp"
"MediaSize" => 150756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d8bd332a781b1f968b973fa88b4ae992.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29989512_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d9a38c9769475c9490f1a5b8b1e2fe9e.webp"
"MediaSize" => 176738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d9a38c9769475c9490f1a5b8b1e2fe9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29989512_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/36494c68d3b4e634a0d5bc1363d14b6f.webp"
"MediaSize" => 147612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-36494c68d3b4e634a0d5bc1363d14b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29989512_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/f6d0b4499a4c414faba48bd728dae361.webp"
"MediaSize" => 192686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-f6d0b4499a4c414faba48bd728dae361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29989512_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/9887770def58db66e3f2bb9b56585235.webp"
"MediaSize" => 165835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-9887770def58db66e3f2bb9b56585235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29989512_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2908841c0f4a015d8c4b791654ab5eda.webp"
"MediaSize" => 104262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2908841c0f4a015d8c4b791654ab5eda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29989512_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/a0fa5785f5a0a508f8d61be4c668970d.webp"
"MediaSize" => 101412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-a0fa5785f5a0a508f8d61be4c668970d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29989512_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5c3974d3ac7ae3e538272f7b52abbb28.webp"
"MediaSize" => 98368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5c3974d3ac7ae3e538272f7b52abbb28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29989512_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1bc28446e95f36cc3095c42043333fee.webp"
"MediaSize" => 86519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1bc28446e95f36cc3095c42043333fee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29989512_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/6aeb2f722111e8ba50634ea40c8ef699.webp"
"MediaSize" => 77076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-6aeb2f722111e8ba50634ea40c8ef699.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29989512_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/a842c0e135d8cc895f4b2d718f71540a.webp"
"MediaSize" => 102749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-a842c0e135d8cc895f4b2d718f71540a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29989512_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2df360b9a12b88adc7032390af561ff4.webp"
"MediaSize" => 106590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2df360b9a12b88adc7032390af561ff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29989512_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/cf030ff29029ec6b605707f39acae02e.webp"
"MediaSize" => 81457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-cf030ff29029ec6b605707f39acae02e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29989512_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1283c91e01949b88c0036cf357a95a4f.webp"
"MediaSize" => 95361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1283c91e01949b88c0036cf357a95a4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29989512_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/935c550b9620a6d7456b1951439aea5e.webp"
"MediaSize" => 100956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-935c550b9620a6d7456b1951439aea5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29989512_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d83f0953273e69e89b4504969acf695d.webp"
"MediaSize" => 107022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d83f0953273e69e89b4504969acf695d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29989512_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/010f0e2441e828cf1829fbdb56d2dfec.webp"
"MediaSize" => 97759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-010f0e2441e828cf1829fbdb56d2dfec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29989512_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/aa461696cb37262c23377d498e5c5453.webp"
"MediaSize" => 102628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-aa461696cb37262c23377d498e5c5453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29989512_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/dc36beb255601b3754ba8e1c4112b94a.webp"
"MediaSize" => 91246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-dc36beb255601b3754ba8e1c4112b94a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29989512_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/7b680300ea9363fa20f00e563e477802.webp"
"MediaSize" => 83381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-7b680300ea9363fa20f00e563e477802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29989512_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/038f475a74f2f33c11bb21ce4e6a2e03.webp"
"MediaSize" => 76519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-038f475a74f2f33c11bb21ce4e6a2e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29989512_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1932857e1d444e09c0dc7b7e9ab4cbca.webp"
"MediaSize" => 85433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1932857e1d444e09c0dc7b7e9ab4cbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29989512_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/25b338d233b1302678b72a314cf36137.webp"
"MediaSize" => 84144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-25b338d233b1302678b72a314cf36137.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29989512_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/31cac25ac94abd4b6374fcb79bd1f0af.webp"
"MediaSize" => 100794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-31cac25ac94abd4b6374fcb79bd1f0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29989512_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/eda2b1b27b3705790c03bcf97dad5a22.webp"
"MediaSize" => 89689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-eda2b1b27b3705790c03bcf97dad5a22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29989512_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5911af84b2e7b32ee9be02d5fc7c16c7.webp"
"MediaSize" => 63087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5911af84b2e7b32ee9be02d5fc7c16c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29989512_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5a02b6f7f3cdb621aef4f2c920926b0d.webp"
"MediaSize" => 60959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5a02b6f7f3cdb621aef4f2c920926b0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29989512_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/0be8a3fbf10b0d0c553c1dfccf00705a.webp"
"MediaSize" => 206934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-0be8a3fbf10b0d0c553c1dfccf00705a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29989512_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5e760bf313dd77ff0627c1ce3c29feaf.webp"
"MediaSize" => 219774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5e760bf313dd77ff0627c1ce3c29feaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29989512_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/3f83996c51306f6f348d626b3a6be1ab.webp"
"MediaSize" => 63673
…9
]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989512')"
+"ID": "1593558"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1593119"
+post_author: 1
+"ListingKey": "29989226"
+"ListingId": "40845052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T14:05:24Z"
+"RFModificationTimestamp": "2026-07-04T16:47:45Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3K5"
+"UnparsedAddress": "151 WINCHESTER Boulevard, Hamilton, Ontario L8V3K5"
+"Coordinates": array:2 [
0 => -79.8373146
1 => 43.2184493
]
+"Latitude": 43.2184493
+"Longitude": -79.8373146
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity, potential, and an incredible backyard!! This is your chance to make a great home your own in one of Hamilton East Mountain's most sought-after neighbourhoods. Whether you're a first-time buyer looking to build equity, an investor searching for your next project, a handyman ready to add value, or a downsizer wanting the convenience of bungalow living, this 3+1 bedroom home offers endless possibilities. The bright and functional main floor provides a practical layout with three bedrooms and a kitchen that's ready for your personal vision. One of the home's biggest advantages is that all windows have already been replaced, allowing you to focus your investment where it matters most while enjoying improved comfort and energy efficiency. The partially finished basement features a fourth bedroom and an abundance of untapped space, offering the flexibility to create a spacious family room, home office, gym, hobby area, or additional living space to suit your lifestyle. Step outside and fall in love with the backyard! Beautifully designed for making memories, this private outdoor retreat features an above-ground pool, hot tub and plenty of room to entertain, and space for family gatherings, summer barbecues, or simply relaxing at the end of the day. It's the kind of backyard that's becoming increasingly difficult to find. Adding even more value is the detached 2-car garage, offering the perfect space for a workshop, hobbyist, extra storage, or the ultimate man cave. Situated in a quiet, family-friendly East Mountain neighbourhood close to parks, schools, shopping, transit, and major commuter routes, this property is full of potential in a location you'll love. Homes with this combination of solid bones, endless possibilities, and a backyard this exceptional don't come along often. Don't miss your chance to unlock the full potential of this fantastic property. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T16:47:40.788584+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126582"
+"ListOfficeKey": "282362"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T13:59:10Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T13:59:10Z"
+"Stories": "1.0"
+"StreetName": "WINCHESTER"
+"StreetNumber": "151"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "150 - Mountview"
+"TaxAnnualAmount": "4835.75"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29989226/151-winchester-boulevard-hamilton"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-04T13:59:10.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1379908"
+"ListOfficeNationalAssociationId": "1320359"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989226')"
+"ID": "1593119"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1590475"
+post_author: 1
+"ListingKey": "29986043"
+"ListingId": "40844791"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:52:22Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2059.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND Street, Hamilton, Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8409617
1 => 43.220058
]
+"Latitude": 43.220058
+"Longitude": -79.8409617
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3 x 38'0, ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:52:17.499869+00:00"
+"Directions": "Mohawk Rd East to East 42nd St"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:25Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:25Z"
+"Stories": "1.0"
+"StreetName": "EAST 42ND"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"SubdivisionName": "252 - Hampton Heights"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986043/456-east-42nd-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1157
+"BelowGradeFinishedArea": 902
+"OriginalEntryTimestamp": "2026-07-03T18:18:25.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986043')"
+"ID": "1590475"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1590193"
+post_author: 1
+"ListingKey": "29985357"
+"ListingId": "X13518854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:15:03Z"
+"RFModificationTimestamp": "2026-07-04T16:17:02Z"
+"ListPrice": 639000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Huntington)"
+"PostalCode": "L8T1W3"
+"UnparsedAddress": "3 KENWOOD CRESCENT, Hamilton (Huntington), Ontario L8T1W3"
+"Coordinates": array:2 [
0 => -79.825516
1 => 43.223114
]
+"Latitude": 43.223114
+"Longitude": -79.825516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained home on a quiet dead-end street in the highly desirable Huntington neighbourhood. Proudly owned by the same family for 26 years, this move-in-ready property has been extensively renovated inside and out, offering exceptional quality, comfort, and outdoor living.The stunning interior was completely rebuilt in 2009 and features solid maple cabinetry with granite countertops in the kitchen and bathrooms, beautifully updated spa-inspired bathrooms with glass-enclosed showers, jetted tubs, and whisper-quiet timer exhaust fans, solid oak staircase, custom blinds throughout, luxury vinyl flooring (2024), and premium 100 oz carpet in the finished lower level (2021). The kitchen is equipped with high-end KitchenAid appliances, a gas stove, new Whirlpool microwave (2023), and matching Whirlpool washer and dryer (2023). Entertain with ease thanks to the custom maple wet bar with granite counters.Step outside to your private backyard retreat featuring approximately 1,900 sq. ft. of stamped coloured concrete, an inground pool with new liner, coping and natural gas heater (2023), aluminum Sojag gazebo, separate BBQ gazebo with included gas Weber BBQ, large storage shed (2023), pool shed, and professionally refreshed fencing (2023). Additional updates include windows and roof (2016), steel entry doors, and Anderson front screen door.Perfectly situated within walking distance to public, Catholic, and French Immersion schools (JK-Grade 8), high school, parks, recreation centre, shopping, pharmacies, and public transit. Enjoy the charm of an established, family-friendly neighbourhood where great neighbours and a true sense of community make this an exceptional place to call home. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:27:06.898437+00:00"
+"Directions": "Fennell Ave E & Upper Ottawa St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1477197"
+"ListOfficeKey": "279771"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40.2 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:41:35Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:08:53Z"
+"Stories": "1.0"
+"StreetName": "Kenwood"
+"StreetNumber": "3"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4687.28"
+"VirtualTourURLUnbranded": "https://youtu.be/_929Nl9ZQLk?si=F4i6GPdyOOmiif8Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Huntington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985357/3-kenwood-crescent-hamilton-huntington-huntington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-07-03T16:41:35.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1131407"
+"ListOfficeNationalAssociationId": "1308754"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985357')"
+"ID": "1590193"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1590476"
+post_author: 1
+"ListingKey": "29986345"
+"ListingId": "X13519910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:50:06Z"
+"RFModificationTimestamp": "2026-07-03T19:33:44Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Hampton Heights)"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND STREET, Hamilton (Hampton Heights), Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8408989
1 => 43.2200445
]
+"Latitude": 43.2200445
+"Longitude": -79.8408989
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3" x 38'0", ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:17:40.045093+00:00"
+"Directions": "Cross Streets: Mohawk Rd. East. ** Directions: Mohawk Rd East to East 42nd St."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "50 x 149.3 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:41:49Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:41:49Z"
+"Stories": "1.0"
+"StreetName": "East 42nd"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Hampton Heights"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29986345/456-east-42nd-street-hamilton-hampton-heights-hampton-heights"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-03T18:41:49.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986345')"
+"ID": "1590476"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1589185"
+post_author: 1
+"ListingKey": "29984607"
+"ListingId": "40844731"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:35:13Z"
+"RFModificationTimestamp": "2026-07-03T17:03:50Z"
+"ListPrice": 629000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4G3"
+"UnparsedAddress": "282 EAST 38TH Street, Hamilton, Ontario L8V4G3"
+"Coordinates": array:2 [
0 => -79.840836
1 => 43.2291001
]
+"Latitude": 43.2291001
+"Longitude": -79.840836
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Wonderful opportunity to own this 3+2 bedroom, 2 bath all brick bungalow with a full in-law suite with its own entrance. Both kitchens have SS appliances and have been updated as well as both bathrooms. Laminate flooring has just gone in throughout. Other features: upgraded electrical, heated lower bath floor, gas fp, upgraded heating system, 5 ceiling fans, lovely private yard, garage (as is) & inside steps all recently redone as well as a freshly paved driveway. and all this in a family friendly neighbourhood close to all amenities. This is a fabulous opportunity for home ownership!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:03:44.199235+00:00"
+"Directions": "Exit Upper Gage, North on Upper Gage, West on Fennell, Turn Right East 38th"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Radiant heat"
2 => "Forced air"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981578"
+"ListOfficeKey": "55005"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:29:47Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:29:46Z"
+"Stories": "1.0"
+"StreetName": "EAST 38TH"
+"StreetNumber": "282"
+"StreetSuffix": "Street"
+"SubdivisionName": "174 - Raleigh"
+"TaxAnnualAmount": "4391"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70393"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984607/282-east-38th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524265"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55005"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1010
+"BelowGradeFinishedArea": 831
+"OriginalEntryTimestamp": "2026-07-03T15:29:46.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267003"
+"ListOfficeNationalAssociationId": "1003711"
+"CoListAgentNationalAssociationId": "1064115"
+"CoListOfficeNationalAssociationId": "1003711"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984607')"
+"ID": "1589185"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1587666"
+post_author: 1
+"ListingKey": "29982354"
+"ListingId": "X13516072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:20:10Z"
+"RFModificationTimestamp": "2026-07-03T20:23:44Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Quinndale)"
+"PostalCode": "L8W1R1"
+"UnparsedAddress": "27 - 1396 UPPER OTTAWA STREET, Hamilton (Quinndale), Ontario L8W1R1"
+"Coordinates": array:2 [
0 => -79.841643
1 => 43.20013
]
+"Latitude": 43.20013
+"Longitude": -79.841643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This fabulous end-unit townhouse is conveniently located close to schools, parks, shopping, and all amenities. The main floor features an updated kitchen, and a living and dining room with a walkout to the fenced backyard patio. Upstairs, you'll find three spacious bedrooms and a beautifully updated 4-piece bathroom. The finished basement offers additional living space with a versatile recreation room, a 2-piece bathroom, and a separate laundry room. Recent updatesinclude fresh paint throughout, new carpeting (2026), AC (2026), furnace (2026), kitchencountertops (2026), and renovated upstairs bathroom (2026). (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "511.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:08:17.118105+00:00"
+"Directions": "STONE CHURCH RD E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160208"
+"ListOfficeKey": "290165"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T22:44:47Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:06:28Z"
+"Stories": "2.0"
+"StreetName": "UPPER OTTAWA"
+"StreetNumber": "1396"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3192"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Quinndale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29982354/27-1396-upper-ottawa-street-hamilton-quinndale-quinndale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "PROPERTY MANAGEMENT GUILD"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "E2"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-02T22:44:47.77Z"
+"ListAgentNationalAssociationId": "1411366"
+"ListOfficeNationalAssociationId": "1384282"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982354')"
+"ID": "1587666"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1586616"
+post_author: 1
+"ListingKey": "29981552"
+"ListingId": "40842992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:05:14Z"
+"RFModificationTimestamp": "2026-07-03T21:08:21Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1332.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8W1R1"
+"UnparsedAddress": "1396 UPPER OTTAWA Street Unit# 27, Hamilton, Ontario L8W1R1"
+"Coordinates": array:2 [
0 => -79.841485
1 => 43.2000594
]
+"Latitude": 43.2000594
+"Longitude": -79.841485
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This fabulous end-unit townhouse is conveniently located close to schools, parks, shopping, and all amenities. The main floor features an updated kitchen, and a living and dining room with a walkout to the fenced backyard patio. Upstairs, you'll find three spacious bedrooms and a beautifully updated 4-piece bathroom. The finished basement offers additional living space with a versatile recreation room, a 2-piece bathroom, and a separate laundry room. Recent updates include fresh paint throughout, new carpeting (2026), AC (2026), furnace (2026), kitchen countertops (2026), and renovated upstairs bathroom (2026). (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "511.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:59:13.073262+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1734276"
+"ListOfficeKey": "290163"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:12:18Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:59:11Z"
+"Stories": "2.0"
+"StreetName": "UPPER OTTAWA"
+"StreetNumber": "1396"
+"StreetSuffix": "Street"
+"SubdivisionName": "262 - Quinndale"
+"TaxAnnualAmount": "3192"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29981552/1396-upper-ottawa-street-unit-27-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "E2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 961
+"BelowGradeFinishedArea": 371
+"OriginalEntryTimestamp": "2026-07-02T21:12:18.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1177451"
+"ListOfficeNationalAssociationId": "1384185"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981552')"
+"ID": "1586616"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1585136"
+post_author: 1
+"ListingKey": "29979885"
+"ListingId": "40844674"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:20:15Z"
+"RFModificationTimestamp": "2026-07-02T19:25:13Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3M4"
+"UnparsedAddress": "627 UPPER SHERMAN Avenue, Hamilton, Ontario L8V3M4"
+"Coordinates": array:2 [
0 => -79.8485166
1 => 43.2286319
]
+"Latitude": 43.2286319
+"Longitude": -79.8485166
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this extensively renovated and move-in-ready home located in a desirable Hamilton Mountain neighbourhood. Offering 3+2 bedrooms, 2 full bathrooms, 2 kitchens, a separate entrance to the finished lower level, excellent parking, and a highly functional backyard setup, this property is ideal for families, multi-generational living, and investors alike. The bright main level features 3 spacious bedrooms, a stylish renovated bathroom with modern tub, upgraded fixtures and faucets, an updated kitchen with modern cabinetry, countertops and backsplash, and an inviting living area highlighted by a modern fireplace and pot lights throughout. The fully finished lower level offers excellent flexibility with 2 additional bedrooms, a separate entrance, kitchen, and renovated bathroom with modern shower and upgraded fixtures, making it perfect for extended family, guests, or additional living space. Recent upgrades include new flooring throughout, fresh paint, new doors and modern hardware, updated windows, renovated kitchens and bathrooms, new pot lights, updated electrical wiring and outlets where required, ESA-certified electrical work with certificate available, and modern finishes throughout. The property offers parking for up to 5 vehicles, including a large driveway and secure gated rear parking area. The spacious backyard offers incredible versatility with a detached serviced garage/workshop equipped with electrical service, water supply, drainage, heating and HVAC connections, plus an additional shed with electrical service, a second storage shed, landscape lighting with timers throughout the front and rear yards, and a sprinkler system ready for connection. Conveniently located close to schools, parks, shopping, transit, amenities, and major highway access, this extensively upgraded Hamilton Mountain home offers a rare combination of modern living, flexible space, exceptional parking, functional outdoor features, and future potential. Move in and enjoy! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:25:08.116582+00:00"
+"Directions": "Fennell to Upper Sherman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2226340"
+"ListOfficeKey": "291669"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-02T18:11:07Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:11:07Z"
+"Stories": "1.0"
+"StreetName": "UPPER SHERMAN"
+"StreetNumber": "627"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "3982"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29979885/627-upper-sherman-avenue-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2026-07-02T18:11:07.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1469738"
+"ListOfficeNationalAssociationId": "1401824"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979885')"
+"ID": "1585136"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 153
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]