array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29985357 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1590193"
+post_author: 1
+"ListingKey": "29985357"
+"ListingId": "X13518854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:50:10Z"
+"RFModificationTimestamp": "2026-07-03T19:35:13Z"
+"ListPrice": 639000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.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-03T16:41:35Z"
+"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 [
"RoomKey" => "1674223971"
"RoomType" => "Kitchen"
"ListingId" => "X13518854"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29985357"
"RoomLength" => 3.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
1 => array:11 [
"RoomKey" => "1674223972"
"RoomType" => "Living room"
"ListingId" => "X13518854"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29985357"
"RoomLength" => 5.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
2 => array:11 [
"RoomKey" => "1674223973"
"RoomType" => "Dining room"
"ListingId" => "X13518854"
"RoomLevel" => "Main level"
"RoomWidth" => 2.82
"ListingKey" => "29985357"
"RoomLength" => 3.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
3 => array:11 [
"RoomKey" => "1674223974"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13518854"
"RoomLevel" => "Main level"
"RoomWidth" => 3.91
"ListingKey" => "29985357"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
4 => array:11 [
"RoomKey" => "1674223975"
"RoomType" => "Bedroom"
"ListingId" => "X13518854"
"RoomLevel" => "Main level"
"RoomWidth" => 2.76
"ListingKey" => "29985357"
"RoomLength" => 3.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
5 => array:11 [
"RoomKey" => "1674223976"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13518854"
"RoomLevel" => "Lower level"
"RoomWidth" => 5.59
"ListingKey" => "29985357"
"RoomLength" => 3.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
6 => array:11 [
"RoomKey" => "1674223977"
"RoomType" => "Kitchen"
"ListingId" => "X13518854"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.3
"ListingKey" => "29985357"
"RoomLength" => 4.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
7 => array:11 [
"RoomKey" => "1674223978"
"RoomType" => "Office"
"ListingId" => "X13518854"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.04
"ListingKey" => "29985357"
"RoomLength" => 3.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.54Z"
]
8 => array:11 [
"RoomKey" => "1674223979"
"RoomType" => "Utility room"
"ListingId" => "X13518854"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.8
"ListingKey" => "29985357"
"RoomLength" => 3.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.55Z"
]
9 => array:11 [
"RoomKey" => "1674223980"
"RoomType" => "Laundry room"
"ListingId" => "X13518854"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.67
"ListingKey" => "29985357"
"RoomLength" => 4.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:41:35.55Z"
]
]
+"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
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-07-03T16:41:35.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1131407"
+"ListOfficeNationalAssociationId": "1308754"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29985357_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/81d0d8fd86b10fa7725e3a7500d5bd44.webp"
"MediaSize" => 269028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-81d0d8fd86b10fa7725e3a7500d5bd44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29985357_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/4ed7e1680db7d2d6264969e56791f235.webp"
"MediaSize" => 271818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-4ed7e1680db7d2d6264969e56791f235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29985357_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/9165acfdf0712b540717fcaa851ddb85.webp"
"MediaSize" => 283467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-9165acfdf0712b540717fcaa851ddb85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29985357_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/7997125497567def0ce1a4659228832b.webp"
"MediaSize" => 257941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-7997125497567def0ce1a4659228832b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29985357_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/4c78bf0b73eb57c827cdbd7588d3357c.webp"
"MediaSize" => 204738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-4c78bf0b73eb57c827cdbd7588d3357c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29985357_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/4c15b36e11aef0b23b4b00ecf45d1b25.webp"
"MediaSize" => 177322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-4c15b36e11aef0b23b4b00ecf45d1b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29985357_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/6955adbf20496b85fea5e03933a158b6.webp"
"MediaSize" => 186583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-6955adbf20496b85fea5e03933a158b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29985357_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/f7bf69974faa2f54ea52eb5795020039.webp"
"MediaSize" => 195081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-f7bf69974faa2f54ea52eb5795020039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29985357_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/52dc0475d3a58e8214fc581f82d8e636.webp"
"MediaSize" => 188969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-52dc0475d3a58e8214fc581f82d8e636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29985357_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/d96b0632beb5fd7b98d2415031375f2f.webp"
"MediaSize" => 185194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-d96b0632beb5fd7b98d2415031375f2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29985357_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/fcfed5f7432ec84e58a3eb906a6f5aa3.webp"
"MediaSize" => 172574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-fcfed5f7432ec84e58a3eb906a6f5aa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29985357_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/3c0ed819c6e76b6c7c0a6b21236e65cf.webp"
"MediaSize" => 204889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-3c0ed819c6e76b6c7c0a6b21236e65cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29985357_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/26eb242f62fa571cef59db197eff1fbb.webp"
"MediaSize" => 193972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-26eb242f62fa571cef59db197eff1fbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29985357_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/7a8c34e576111771f81016908c2fb02b.webp"
"MediaSize" => 231078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-7a8c34e576111771f81016908c2fb02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29985357_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/5d1786907fd4aaf5b10cbb203c6ab26e.webp"
"MediaSize" => 208448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-5d1786907fd4aaf5b10cbb203c6ab26e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29985357_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/be4b4964eb74bf9b8f7caacc79ac80b6.webp"
"MediaSize" => 194547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-be4b4964eb74bf9b8f7caacc79ac80b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29985357_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/9b535602bd478f8dd0e9d9219f4c6c31.webp"
"MediaSize" => 225615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-9b535602bd478f8dd0e9d9219f4c6c31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29985357_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/f120c128c30d47cd679939d536a51fa3.webp"
"MediaSize" => 168520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-f120c128c30d47cd679939d536a51fa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29985357_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/09c566834eee0a10de16602a7d582fa5.webp"
"MediaSize" => 240669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-09c566834eee0a10de16602a7d582fa5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29985357_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/8a386ecb2f0228b909b673ca077c2883.webp"
"MediaSize" => 166445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-8a386ecb2f0228b909b673ca077c2883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29985357_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/a417ce7ce7e7ce8b09d8c4fb9617e95f.webp"
"MediaSize" => 159628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-a417ce7ce7e7ce8b09d8c4fb9617e95f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29985357_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/1c261c162aab185b33718b9c30b596fe.webp"
"MediaSize" => 180360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-1c261c162aab185b33718b9c30b596fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29985357_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/948fcae60e7daddb2c9b6481518a303b.webp"
"MediaSize" => 176841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-948fcae60e7daddb2c9b6481518a303b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29985357_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/2cc4772d64385e48c3259da18d19c5c0.webp"
"MediaSize" => 171468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-2cc4772d64385e48c3259da18d19c5c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29985357_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/90b092da720f248b7280311b4c80c5e6.webp"
"MediaSize" => 205070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-90b092da720f248b7280311b4c80c5e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29985357_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/42ea22157e87f91feb67a3f665d55f81.webp"
"MediaSize" => 190743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-42ea22157e87f91feb67a3f665d55f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29985357_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/629b862e4f5686b2076d4f8871140db1.webp"
"MediaSize" => 166432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-629b862e4f5686b2076d4f8871140db1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29985357_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/6b7b19ee7cf97bca78bcc03268515f3c.webp"
"MediaSize" => 271453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-6b7b19ee7cf97bca78bcc03268515f3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29985357_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/2036b18e46b2ed0246689295493653f5.webp"
"MediaSize" => 181323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-2036b18e46b2ed0246689295493653f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29985357_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/9033c939b989c5c8fd76e84d54b49dba.webp"
"MediaSize" => 231877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-9033c939b989c5c8fd76e84d54b49dba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29985357_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/712a4fa53230fcabc4293fded004803c.webp"
"MediaSize" => 274768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-712a4fa53230fcabc4293fded004803c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29985357_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/9f3602a74354885b6526f1d95ba825b3.webp"
"MediaSize" => 264014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-9f3602a74354885b6526f1d95ba825b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29985357_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/c957a26447f627978a7cd259e1a7e394.webp"
"MediaSize" => 249280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-c957a26447f627978a7cd259e1a7e394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29985357_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/a9df80cb8e0a38a7bf4fb183d9378e67.webp"
"MediaSize" => 317571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-a9df80cb8e0a38a7bf4fb183d9378e67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29985357_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/46062827b6793fcd20ccfb5e20aa0643.webp"
"MediaSize" => 230155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-46062827b6793fcd20ccfb5e20aa0643.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29985357_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/5e109def4e4bd90d438a64def7f942c7.webp"
"MediaSize" => 319733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-5e109def4e4bd90d438a64def7f942c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29985357_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985357/a70f6cb5401d01b0e73d143007ab0c9b.webp"
"MediaSize" => 321469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985357/thumbnail-a70f6cb5401d01b0e73d143007ab0c9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518854"
"ResourceRecordKey" => "29985357"
"ModificationTimestamp" => "2026-07-03T16:41:35.51Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985357')"
+"ID": "1590193"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 279771" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24896
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1477197" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24854
+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 '29985357'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25248
+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 '29985357'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+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 '29985357' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.825516 43.223114)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25317
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+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 [
"RoomKey" => "1674297171"
"RoomType" => "Utility room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
1 => array:11 [
"RoomKey" => "1674297172"
"RoomType" => "Other"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
2 => array:11 [
"RoomKey" => "1674297173"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
3 => array:11 [
"RoomKey" => "1674297174"
"RoomType" => "Laundry room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
4 => array:11 [
"RoomKey" => "1674297175"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
5 => array:11 [
"RoomKey" => "1674297176"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
6 => array:11 [
"RoomKey" => "1674297177"
"RoomType" => "Family room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "22'3'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
7 => array:11 [
"RoomKey" => "1674297178"
"RoomType" => "Storage"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
8 => array:11 [
"RoomKey" => "1674297179"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
9 => array:11 [
"RoomKey" => "1674297180"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
10 => array:11 [
"RoomKey" => "1674297181"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
11 => array:11 [
"RoomKey" => "1674297182"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
12 => array:11 [
"RoomKey" => "1674297183"
"RoomType" => "Foyer"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "25'3'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
13 => array:11 [
"RoomKey" => "1674297184"
"RoomType" => "Kitchen"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.33Z"
]
14 => array:11 [
"RoomKey" => "1674297185"
"RoomType" => "Living room"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "19'9'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.33Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29986043_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/49cf9b2568bb9da76b89336110fb3164.webp"
"MediaSize" => 144041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-49cf9b2568bb9da76b89336110fb3164.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986043_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/4130f562038bd07cae7d4cf1c1683aaa.webp"
"MediaSize" => 165950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-4130f562038bd07cae7d4cf1c1683aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986043_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/b82115413482c0f0f4a3d5eeaede75e9.webp"
"MediaSize" => 165721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-b82115413482c0f0f4a3d5eeaede75e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986043_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/fc55025c8dedf93c5033dca038d6e33f.webp"
"MediaSize" => 60040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-fc55025c8dedf93c5033dca038d6e33f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986043_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/ce477e71adec071ae36aa05b04eb0165.webp"
"MediaSize" => 51738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-ce477e71adec071ae36aa05b04eb0165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986043_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/117949ee787ac8e962f663d9dddacbf1.webp"
"MediaSize" => 93362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-117949ee787ac8e962f663d9dddacbf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986043_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/1c5aef4144441cb2112e0d958a43512a.webp"
"MediaSize" => 89820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-1c5aef4144441cb2112e0d958a43512a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986043_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/77f55931eb315a0cde9fdefcdcbf280c.webp"
"MediaSize" => 77919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-77f55931eb315a0cde9fdefcdcbf280c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
8 => array:13 [
"Order" => 9
…12
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986043')"
+"ID": "1590475"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1590192"
+post_author: 1
+"ListingKey": "29986499"
+"ListingId": "40844902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:10:09Z"
+"RFModificationTimestamp": "2026-07-03T20:20:20Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2011.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M3G1"
+"UnparsedAddress": "88 ROTHSAY Avenue, Hamilton, Ontario L8M3G1"
+"Coordinates": array:2 [
0 => -79.8264647
1 => 43.2409733
]
+"Latitude": 43.2409733
+"Longitude": -79.8264647
+"YearBuilt": 1939
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 88 Rothsay Avenue, a beautiful character home nestled on one of Hamilton’s most sought-after streets, backing onto the iconic Gage Park. From the street to the backyard oasis with an expansive vista of the historic park, this charming property blends timeless character with modern updates, offering a warm and inviting place to call home. Inside, you’ll find bright, spacious living areas filled with original charm. The sun-filled living room features a stunning bay window and a cozy wood-burning fireplace, creating the perfect space to relax or gather. The updated kitchen is designed for the serious chef, featuring a 36” Vulcan gas stove and double doors leading to a private deck and landscaped sitting area overlooking the park — ideal for entertaining or quiet mornings. A spacious dining/family room complete the well-designed main floor. The lower level offers a large rec-room with a second wood-burning fireplace, along with an updated 3-piece bathroom, adding great additional living space. Upstairs, you’ll find 3 bedrooms, including a generous primary suite with a walk-in closet. The main bathroom ('23) creates the perfect retreat with a relaxing soaker tub overlooking the mature tree-lined street. The refinished upper-level flooring ('23) adds warmth and continuity throughout. Step outside and discover a backyard designed for both entertaining, family fun and relaxing. Enjoy the custom wet bar ('19), stone walkway, and an unreal treehouse ('21) that’s sure to become a favourite for the kids, all within a fenced yard in an unmatched park-side setting. Major updates include furnace ('24), siding/soffits/fascia/eaves ('22). Located in a fantastic, family-friendly neighbourhood literally steps to parks, schools, Children's Museum, Tropical Greenhouse, shopping, hiking and walking trails, Ottawa Street shops and cafés and easy access to the LINC, QEW, and future LRT. This is a rare opportunity to own a move-in-ready character home in an exceptional location. (id:62650)"
+"Appliances": array:1 [
0 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:34:16.820324+00:00"
+"Directions": "SOUTH OF KING ST E. (ROTHSAY & CENTRAL AVE)"
+"ExteriorFeatures": array:4 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
3 => "Metal"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1904345"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:59:25Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:58:59Z"
+"Stories": "2.0"
+"StreetName": "ROTHSAY"
+"StreetNumber": "88"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "221 - Gage Park"
+"TaxAnnualAmount": "4907"
+"VirtualTourURLUnbranded": "https://view.wayziemedia.com/88_rothsay_ave-597"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986499/88-rothsay-avenue-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 645
+"OriginalEntryTimestamp": "2026-07-03T18:59:25.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1219284"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:50 [
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]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986499')"
+"ID": "1590192"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986345')"
+"ID": "1590476"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984607')"
+"ID": "1589185"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1587578"
+post_author: 1
+"ListingKey": "29982826"
+"ListingId": "X13516482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:50:03Z"
+"RFModificationTimestamp": "2026-07-03T20:52:33Z"
+"ListPrice": 2288888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Sherwood)"
+"PostalCode": "L8T1A6"
+"UnparsedAddress": "274 MOUNTAIN BROW BOULEVARD, Hamilton (Sherwood), Ontario L8T1A6"
+"Coordinates": array:2 [
0 => -79.819477
1 => 43.229595
]
+"Latitude": 43.229595
+"Longitude": -79.819477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An Absolute Masterpiece of Mid-Century Inspired Luxury Living. Prepare to be captivated. Reimagined and carefully crafted by the elite team at Exquisite Living Homes, this mid-century gem marries sleek modern luxury with an unbeatable location at the peak of the Hamilton Escarpment. Picture starting your mornings with a coffee on the front porch, watching the sun rise over the Hamilton skyline and Lake Ontario on your massive, half-acre property. Pulling up the grand circular driveway, you'll immediately sense the scale of this unique custom sidesplit. Inside, the home unfolds beautifully, anchored by a jaw-dropping bookmatched marble gas fireplace. The kitchen is the true heart of the home-outfitted with gorgeous two-toned cabinets, endless quartz counters, a sprawling island, and high-end built-in appliances. Whether you're hosting intimate family dinners or grand celebrations, the main floor flows effortlessly with two distinct living areas, rich hardwood floors, and a gorgeous powder room. Your primary suite serves as a daily escape, boasting two walk-in closets and a deep, spa-like bath. The jaw-dropping great room steals the show with its vaulted ceilings and massive windows that flood the space with natural light. Upstairs, you'll find two additional cozy bedrooms and a full bath, while the lower level features a super-sized mudroom-perfect for busy families coming in from the double garage. Outside, the backyard is your own private resort, complete with a covered porch, outdoor wood-ceiling fireplace, and lush, irrigated gardens. Steps from local trails, great schools, and easy highway access, this is the forever home you've been waiting for. Don't miss out on this rare opportunity! Luxury Certified. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Freezer"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Crawl space"
2 => "None"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:34:57.073299+00:00"
+"Directions": "Cross Streets: Oakcrest Dr. ** Directions: Kenilworth or Sherman Access, up Kenilworth Access, East on Mountain Brow Blvd."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109882"
+"ListOfficeKey": "284773"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Dry"
2 => "Level"
]
+"LotSizeDimensions": "100 x 250 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-03T00:42:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:40:28Z"
+"StreetName": "Mountain Brow"
+"StreetNumber": "274"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "10573.62"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view,View"
+"VirtualTourURLUnbranded": "https://360.api360.ca/tours/8qea7gScB"
+"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": "Toronto"
+"CityRegion": "Sherwood"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29982826/274-mountain-brow-boulevard-hamilton-sherwood-sherwood"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"ZoningDescription": "B/S-1669"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-07-03T00:42:11.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1378640"
+"ListOfficeNationalAssociationId": "1344627"
+"Media": array:50 [
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]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982826')"
+"ID": "1587578"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1587579"
+post_author: 1
+"ListingKey": "29982468"
+"ListingId": "40844756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T23:20:15Z"
+"RFModificationTimestamp": "2026-07-03T01:13:56Z"
+"ListPrice": 2288888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.576
+"LivingArea": 3360.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T1A6"
+"UnparsedAddress": "274 MOUNTAIN BROW Boulevard, Hamilton, Ontario L8T1A6"
+"Coordinates": array:2 [
0 => -79.8195323
1 => 43.2295512
]
+"Latitude": 43.2295512
+"Longitude": -79.8195323
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An Absolute Masterpiece of Mid-Century Inspired Luxury Living. Prepare to be captivated. Reimagined and carefully crafted by the elite team at Exquisite Living Homes, this mid-century gem marries sleek modern luxury with an unbeatable location at the peak of the Hamilton Escarpment. Picture starting your mornings with a coffee on the front porch, watching the sun rise over the Hamilton skyline and Lake Ontario on your massive, half-acre property. Pulling up the grand circular driveway, you'll immediately sense the scale of this unique custom sidesplit. Inside, the home unfolds beautifully, anchored by a jaw-dropping bookmatched marble gas fireplace. The kitchen is the true heart of the home-outfitted with gorgeous two-toned cabinets, endless quartz counters, a sprawling island, and high-end built-in appliances. Whether you're hosting intimate family dinners or grand celebrations, the main floor flows effortlessly with two distinct living areas, rich hardwood floors, and a gorgeous powder room. Your primary suite serves as a daily escape, boasting two walk-in closets and a deep, spa-like bath. The jaw-dropping great room steals the show with its vaulted ceilings and massive windows that flood the space with natural light. Upstairs, you'll find two additional cozy bedrooms and a full bath, while the lower level features a super-sized mudroom-perfect for busy families coming in from the double garage. Outside, the backyard is your own private resort, complete with a covered porch, outdoor wood-ceiling fireplace, and lush, irrigated gardens. Steps from local trails, great schools, and easy highway access, this is the forever home you've been waiting for. Don't miss out on this rare opportunity! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Dryer"
6 => "Freezer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:53.340617+00:00"
+"Directions": "From Kenilworth or Sherman Access continue upwards on Kenilworth Access and East onto Mountain Brow Blvd. 2nd house after Oakcrest Dr."
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Brick"
2 => "Stucco"
]
+"FireplaceFeatures": array:3 [
0 => "Electric"
1 => "Other - See remarks"
2 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525446"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.576"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T23:10:17Z"
+"Stories": "2.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "274"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "251 - Sherwood"
+"TaxAnnualAmount": "10144"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"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/29982468/274-mountain-brow-boulevard-hamilton"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1858916"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55061"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "B/S-1669"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 3360
+"OriginalEntryTimestamp": "2026-07-02T23:10:17.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063105"
+"ListOfficeNationalAssociationId": "1344654"
+"CoListAgentNationalAssociationId": "1200489"
+"CoListOfficeNationalAssociationId": "1003659"
+"Media": array:50 [
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]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982468')"
+"ID": "1587579"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979885')"
+"ID": "1585136"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1584913"
+post_author: 1
+"ListingKey": "29980085"
+"ListingId": "X13514156"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:50:05Z"
+"RFModificationTimestamp": "2026-07-03T15:55:16Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V3M4"
+"UnparsedAddress": "627 UPPER SHERMAN AVENUE, Hamilton (Macassa), Ontario L8V3M4"
+"Coordinates": array:2 [
0 => -79.848469
1 => 43.228597
]
+"Latitude": 43.228597
+"Longitude": -79.848469
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Full"
1 => "Separate entrance"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:12:47.186538+00:00"
+"Directions": "Fennell Ave E/Upper Sherman Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993784"
+"ListOfficeKey": "294997"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:40:14Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:40:14Z"
+"Stories": "1.0"
+"StreetName": "Upper Sherman"
+"StreetNumber": "627"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3982"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980085/627-upper-sherman-avenue-hamilton-macassa-macassa"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 46.0
+"OriginalEntryTimestamp": "2026-07-02T18:32:28.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276930"
+"ListOfficeNationalAssociationId": "1451359"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980085')"
+"ID": "1584913"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1584085"
+post_author: 1
+"ListingKey": "29977955"
+"ListingId": "X13512102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:17Z"
+"RFModificationTimestamp": "2026-07-02T17:25:16Z"
+"ListPrice": 658000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Delta)"
+"PostalCode": "L8K2E8"
+"UnparsedAddress": "226 OTTAWA STREET S, Hamilton (Delta), Ontario L8K2E8"
+"Coordinates": array:2 [
0 => -79.822479
1 => 43.23659
]
+"Latitude": 43.23659
+"Longitude": -79.822479
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Just steps from the cafes, restaurants, boutiques, and local favourites that make Ottawa Street one of Hamilton's most vibrant neighbourhoods, this well-maintained 4-bedroom, 2-bathroom home offers the perfect balance of character, space, and convenience. Set on a generous 30 x 115 ft lot with private parking, it's an ideal opportunity for families, professionals, or anyone looking to enjoy a walkable, community-focused lifestyle.Inside, bright and inviting living spaces are complemented by a functional layout with room for family, guests, or a home office. Outside, the deep backyard provides plenty of space to relax, entertain, or garden throughout the warmer months.With parks, schools, transit, and everyday amenities all nearby, this is more than just a home-it's a chance to be part of one of Hamilton's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater - Tankless"
7 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:25:14.598404+00:00"
+"Directions": "Ottawa St & Lawrence Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104132"
+"ListOfficeKey": "283551"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30 x 115.8 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:51:10Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:51:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Ottawa"
+"StreetNumber": "226"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3558"
+"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": "Toronto"
+"CityRegion": "Delta"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977955/226-ottawa-street-s-hamilton-delta-delta"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-07-02T14:51:09.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373610"
+"ListOfficeNationalAssociationId": "1331582"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977955')"
+"ID": "1584085"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 157
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]