array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29890466 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1520845"
+post_author: 1
+"ListingKey": "29890466"
+"ListingId": "X13432866"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:30:22Z"
+"RFModificationTimestamp": "2026-06-18T14:33:47Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Industrial Sector)"
+"PostalCode": "L8L3V9"
+"UnparsedAddress": "66 MARS AVENUE, Hamilton (Industrial Sector), Ontario L8L3V9"
+"Coordinates": array:2 [
0 => -79.845446
1 => 43.265467
]
+"Latitude": 43.265467
+"Longitude": -79.845446
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 66 Mars Avenue, a beautifully renovated detached 2-storey home offering modern updates in a convenient Hamilton location. Recently refreshed throughout, this 3-bedroom, 1.5-bathroom home features a brand new kitchen complete with quartz countertops, new appliances, and contemporary finishes that create a bright and inviting space for everyday living. The functional layout offers comfortable principal rooms, well-sized bedrooms, and tasteful updates that make the home move-in ready. A large green space and park directly across the street provide the perfect setting for family fun, outdoor play, and everyday enjoyment. Ideally situated close to Hamilton General Hospital, downtown Hamilton, shopping, restaurants, public transit, and everyday amenities, with the Hamilton waterfront just a short drive away. A fantastic opportunity for first-time buyers, families, or investors looking for a stylish updated home in a central and accessible neighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T19:16:16.794024+00:00"
+"Directions": "Cross Streets: Cheever St. ** Directions: Go west on Mars Ave. from Wentworth St. N."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2108302"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20 x 81.3 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T18:21:25Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:19:22Z"
+"Stories": "2.0"
+"StreetName": "Mars"
+"StreetNumber": "66"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2522.73"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/66-mars-ave-hamilton-on-l8l-3v9-25725364/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1662070821"
"RoomType" => "Kitchen"
"ListingId" => "X13432866"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29890466"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
1 => array:11 [
"RoomKey" => "1662070822"
"RoomType" => "Dining room"
"ListingId" => "X13432866"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29890466"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
2 => array:11 [
"RoomKey" => "1662070823"
"RoomType" => "Living room"
"ListingId" => "X13432866"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "29890466"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
3 => array:11 [
"RoomKey" => "1662070824"
"RoomType" => "Bathroom"
"ListingId" => "X13432866"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29890466"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
4 => array:11 [
"RoomKey" => "1662070825"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13432866"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29890466"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
5 => array:11 [
"RoomKey" => "1662070826"
"RoomType" => "Bedroom"
"ListingId" => "X13432866"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29890466"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
6 => array:11 [
"RoomKey" => "1662070827"
"RoomType" => "Bedroom 2"
"ListingId" => "X13432866"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29890466"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.87Z"
]
7 => array:11 [
"RoomKey" => "1662070828"
"RoomType" => "Bathroom"
"ListingId" => "X13432866"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29890466"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T14:19:22.88Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Industrial Sector"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29890466/66-mars-avenue-hamilton-industrial-sector-industrial-sector"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2026-06-11T18:21:25.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1377252"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29890466_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/4dd4b9d3bc7ae4da65825d52dd6c90ee.webp"
"MediaSize" => 403677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-4dd4b9d3bc7ae4da65825d52dd6c90ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29890466_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/dbbd4116cec7a17470ab6cd5a37bc7c2.webp"
"MediaSize" => 414631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-dbbd4116cec7a17470ab6cd5a37bc7c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29890466_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/341f8a293e855b30e234db08220b37e3.webp"
"MediaSize" => 91221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-341f8a293e855b30e234db08220b37e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29890466_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/d26a7400745051eb00fc14ad58b30891.webp"
"MediaSize" => 99240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-d26a7400745051eb00fc14ad58b30891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29890466_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/8a9372d18baa31506763a770e36a0868.webp"
"MediaSize" => 164900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-8a9372d18baa31506763a770e36a0868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29890466_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/11b2894cf5f6b7a6e7ca93c94b32c209.webp"
"MediaSize" => 158994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-11b2894cf5f6b7a6e7ca93c94b32c209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29890466_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/994f45cd4be634e7ee1669d125388d73.webp"
"MediaSize" => 142699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-994f45cd4be634e7ee1669d125388d73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29890466_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/428cce106c10ae54497aa6d331b00b6e.webp"
"MediaSize" => 146475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-428cce106c10ae54497aa6d331b00b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29890466_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/18e95d2cf9852484fe13904f8f2be8de.webp"
"MediaSize" => 175042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-18e95d2cf9852484fe13904f8f2be8de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29890466_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/6c73fc97a0fb9a88f4c3a67f2e202cce.webp"
"MediaSize" => 126609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-6c73fc97a0fb9a88f4c3a67f2e202cce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29890466_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/d1826a153a873dd3fa925f15723e2075.webp"
"MediaSize" => 152042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-d1826a153a873dd3fa925f15723e2075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29890466_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/f77db604b9c4aa960adc34535fafac89.webp"
"MediaSize" => 143450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-f77db604b9c4aa960adc34535fafac89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29890466_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/ba407d5b868ca1666a5621d21c825ec3.webp"
"MediaSize" => 156363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-ba407d5b868ca1666a5621d21c825ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29890466_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/a7ee6fa330c184323d93ccd8caae1362.webp"
"MediaSize" => 150761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-a7ee6fa330c184323d93ccd8caae1362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29890466_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/86ecd51ec12d2759c1afedc6cbe403ca.webp"
"MediaSize" => 90794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-86ecd51ec12d2759c1afedc6cbe403ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29890466_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/879e989cba4e2c8f68d0c54f0905a7b3.webp"
"MediaSize" => 142180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-879e989cba4e2c8f68d0c54f0905a7b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29890466_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/fb319d038b9f101e7e71c69ead1df124.webp"
"MediaSize" => 107888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-fb319d038b9f101e7e71c69ead1df124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29890466_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/46303c5df6b5f5c975de657c7d94b755.webp"
"MediaSize" => 149264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-46303c5df6b5f5c975de657c7d94b755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29890466_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/9b8555d9f8301db3ed9073e48821880f.webp"
"MediaSize" => 132278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-9b8555d9f8301db3ed9073e48821880f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29890466_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/f2451726e6196a23addb5b50b045ef6e.webp"
"MediaSize" => 134920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-f2451726e6196a23addb5b50b045ef6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29890466_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/54b530930434a0bf71e8dd051ae659ad.webp"
"MediaSize" => 125784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-54b530930434a0bf71e8dd051ae659ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29890466_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/9c9dfe74804a47355f079949f95a9f2b.webp"
"MediaSize" => 172656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-9c9dfe74804a47355f079949f95a9f2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29890466_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/7f7aa2488ed5876ccf6248c10a22a78b.webp"
"MediaSize" => 137638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-7f7aa2488ed5876ccf6248c10a22a78b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29890466_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/6092fb68cb1ed0048c171f2fafb43198.webp"
"MediaSize" => 160509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-6092fb68cb1ed0048c171f2fafb43198.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29890466_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/1bad4fb9567a4d0f85323df2ba821cc7.webp"
"MediaSize" => 190490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-1bad4fb9567a4d0f85323df2ba821cc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29890466_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/33a5837a9f480f75dee17e38d4121317.webp"
"MediaSize" => 352085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-33a5837a9f480f75dee17e38d4121317.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29890466_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/bd000ee0af05470f695d8af6e16d11c0.webp"
"MediaSize" => 430588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-bd000ee0af05470f695d8af6e16d11c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29890466_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/e149f1ccf6ad082d66b0e6308a164140.webp"
"MediaSize" => 469444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-e149f1ccf6ad082d66b0e6308a164140.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29890466_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/143c08bd8294d77cf0de1a32c60c1f2c.webp"
"MediaSize" => 464452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-143c08bd8294d77cf0de1a32c60c1f2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29890466_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890466/dc1d306d2c7bc80b72dddf27385e430c.webp"
"MediaSize" => 420874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890466/thumbnail-dc1d306d2c7bc80b72dddf27385e430c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13432866"
"ResourceRecordKey" => "29890466"
"ModificationTimestamp" => "2026-06-11T18:21:25.06Z"
]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890466')"
+"ID": "1520845"
}
]
+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 290358" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24808
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2108302" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24807
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29890466'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25195
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29890466'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25211
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29890466' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.845446 43.265467)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1566963"
+post_author: 1
+"ListingKey": "29946528"
+"ListingId": "40842299"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:20:12Z"
+"RFModificationTimestamp": "2026-06-26T03:11:20Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0.05
+"LivingArea": 2510.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L1Z3"
+"UnparsedAddress": "9 SENATOR Avenue, Hamilton, Ontario L8L1Z3"
+"Coordinates": array:2 [
0 => -79.8344115
1 => 43.2518194
]
+"Latitude": 43.2518194
+"Longitude": -79.8344115
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Investors, this one is for you! Incredible opportunity to live in the home and have one or more tenants help with the mortgage. This house was once a full triplex and could be easily converted back. Pride of ownership is beaming here! Step inside to the cozy enclosed front porch. On the main floor you will find the living room (with original pocket doors), kitchen and separate large dining room. There is a lively back deck and steps down to the fenced rear yard with shed. The second level offers 3 bedrooms and the second kitchen and a full bath. The very top level features 2 more bedrooms. The basement has been finished with a second bathroom and 2 additional rooms (possible bedrooms/office etc). Amazing opportunity to live in a very central location (steps to Tim Hortons Field). Electrical and plumbing have been updated. Furnace, new in 2026, is currently a rental and will be paid out in full on closing. Air conditioner approx. 5 years old. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:10:56.781890+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524280"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"LotSizeDimensions": "0.05"
+"PhotosChangeTimestamp": "2026-06-24T15:10:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:10:51Z"
+"Stories": "2.5"
+"StreetName": "SENATOR"
+"StreetNumber": "9"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "3643.93"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70328"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1666904162"
"RoomType" => "Utility room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.5Z"
]
1 => array:11 [
"RoomKey" => "1666904163"
"RoomType" => "Laundry room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.5Z"
]
2 => array:11 [
"RoomKey" => "1666904164"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
3 => array:11 [
"RoomKey" => "1666904165"
"RoomType" => "Recreation room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
4 => array:11 [
"RoomKey" => "1666904166"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
5 => array:11 [
"RoomKey" => "1666904167"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
6 => array:11 [
"RoomKey" => "1666904168"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
7 => array:11 [
"RoomKey" => "1666904169"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
8 => array:11 [
"RoomKey" => "1666904170"
"RoomType" => "Kitchen"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
9 => array:11 [
"RoomKey" => "1666904171"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
10 => array:11 [
"RoomKey" => "1666904172"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
11 => array:11 [
"RoomKey" => "1666904173"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
12 => array:11 [
"RoomKey" => "1666904174"
"RoomType" => "Kitchen"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "14'10'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
13 => array:11 [
"RoomKey" => "1666904175"
"RoomType" => "Dining room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
14 => array:11 [
"RoomKey" => "1666904176"
"RoomType" => "Living room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
15 => array:11 [
"RoomKey" => "1666904177"
"RoomType" => "Foyer"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
16 => array:11 [
"RoomKey" => "1666904178"
"RoomType" => "Mud room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946528/9-senator-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2006
+"BelowGradeFinishedArea": 504
+"OriginalEntryTimestamp": "2026-06-24T15:10:51.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1129172"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946528_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/c331b60da761644a208e92976ea1df5a.webp"
"MediaSize" => 105439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-c331b60da761644a208e92976ea1df5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946528_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/c6cfeb9335c1155807f223b6e867bea1.webp"
"MediaSize" => 115707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-c6cfeb9335c1155807f223b6e867bea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946528_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/b3f748f3a9f1bd2177da2cbce6bdc43f.webp"
"MediaSize" => 123341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-b3f748f3a9f1bd2177da2cbce6bdc43f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946528_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/cc393639474eced7243552d6c8f73514.webp"
"MediaSize" => 87070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-cc393639474eced7243552d6c8f73514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946528_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/63aa28f6e24bc0382d228937b379f9e9.webp"
"MediaSize" => 87213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-63aa28f6e24bc0382d228937b379f9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946528_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/a9de763b4c418dd33fd648791d320ac7.webp"
"MediaSize" => 81554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-a9de763b4c418dd33fd648791d320ac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946528_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/bd4733bf48770078bd3a6cee537c025a.webp"
"MediaSize" => 74059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-bd4733bf48770078bd3a6cee537c025a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946528_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/b52cbc7b48c690f924bfbe92ce9a98d4.webp"
"MediaSize" => 80745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-b52cbc7b48c690f924bfbe92ce9a98d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946528_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/479bf0e6a5ddf9071ba55a0f04181a93.webp"
"MediaSize" => 77266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-479bf0e6a5ddf9071ba55a0f04181a93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946528_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/d91ab32bba13308be64535f3723f0e78.webp"
"MediaSize" => 82408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-d91ab32bba13308be64535f3723f0e78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946528_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/eb5ae1f2292ae59843cad3141e6ec124.webp"
"MediaSize" => 63832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-eb5ae1f2292ae59843cad3141e6ec124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29946528_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/d8c2521cc461b6c8ebfd4e716422e786.webp"
"MediaSize" => 72287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-d8c2521cc461b6c8ebfd4e716422e786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29946528_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/3a351fd0897995eec792ec53e70381b3.webp"
"MediaSize" => 60586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-3a351fd0897995eec792ec53e70381b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29946528_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/e5a78462662bb44d9fdc534253683d54.webp"
"MediaSize" => 72748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-e5a78462662bb44d9fdc534253683d54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29946528_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/901a1f305e9f37ea04eaa82120e11698.webp"
"MediaSize" => 100048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-901a1f305e9f37ea04eaa82120e11698.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29946528_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/e7d9199ea1ceee4668619b7bb0a10cad.webp"
"MediaSize" => 74586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-e7d9199ea1ceee4668619b7bb0a10cad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29946528_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/493321701933e058bc5a440913ded7c9.webp"
"MediaSize" => 90759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-493321701933e058bc5a440913ded7c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29946528_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/ae828c3872b8e7d5cf4b3e1e6bdf9299.webp"
"MediaSize" => 87641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-ae828c3872b8e7d5cf4b3e1e6bdf9299.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29946528_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/e86de30a96dfaf704869bae1cf91f3cd.webp"
"MediaSize" => 65321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-e86de30a96dfaf704869bae1cf91f3cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29946528_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/b85e0dcd9327b5485c51f08143e30f88.webp"
"MediaSize" => 59583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-b85e0dcd9327b5485c51f08143e30f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29946528_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/0755b5eb6b1cf0dc487826c388383e1a.webp"
"MediaSize" => 64873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-0755b5eb6b1cf0dc487826c388383e1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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('29946528')"
+"ID": "1566963"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+post_id: "1566980"
+post_author: 1
+"ListingKey": "29946674"
+"ListingId": "40842631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:15Z"
+"RFModificationTimestamp": "2026-06-26T02:58:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.8609361
1 => 43.2685538
]
+"Latitude": 43.2685538
+"Longitude": -79.8609361
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:57:56.622055+00:00"
+"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738902"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:08Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "9087"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656"
+"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/29946674/414-john-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 3200
+"OriginalEntryTimestamp": "2026-06-24T15:32:08.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1179053"
+"ListOfficeNationalAssociationId": "1344652"
+"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('29946674')"
+"ID": "1566980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1566342"
+post_author: 1
+"ListingKey": "29947057"
+"ListingId": "X13483750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:33:22Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN STREET, Hamilton (North End), Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.860699
1 => 43.268509
]
+"Latitude": 43.268509
+"Longitude": -79.860699
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton's premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater - Tankless"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:31:57.326242+00:00"
+"Directions": "Cross Streets: FERRIE ST. ** Directions: John St N, between Ferrie and Picton."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240345"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level"
1 => "Carpet Free"
]
+"LotSizeDimensions": "27.6 x 106.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:48Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9087"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/414-john-st-n-hamilton-on-l8l-4r3-22876084/unbranded"
+"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"
+"CityRegion": "North End"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29947057/414-john-street-hamilton-north-end-north-end"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.7
+"OriginalEntryTimestamp": "2026-06-24T16:17:48.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1478315"
+"ListOfficeNationalAssociationId": "1344891"
+"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('29947057')"
+"ID": "1566342"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1566053"
+post_author: 1
+"ListingKey": "29947138"
+"ListingId": "40842598"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:40:12Z"
+"RFModificationTimestamp": "2026-06-26T02:24:39Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1238.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6L9"
+"UnparsedAddress": "35 SHERMAN Avenue N, Hamilton, Ontario L8L6L9"
+"Coordinates": array:2 [
0 => -79.8380841
1 => 43.252454
]
+"Latitude": 43.252454
+"Longitude": -79.8380841
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the charm of this solid brick 2.5 brick home built in 1911, brimming with character and ready for your personal touch. The enclosed front porch features a warm welcome and showcases the home's timeless appeal. Inside, you'll find a spacious layout with generous bedrooms on the second floor and a bright 4-piece bathroom. The third floor adds two additional bedrooms, perfect for guests, a home office, or creative space. The kitchen opens to a private backyard, providing the ideal setting for future gardens or outdoor entertaining. A separate side entrance leads to the unfinished basement, which includes an existing bathroom-offering excellent potential for additional living space. ich in history and full of opportunity, this home is waiting for someone with vision to restore its original beauty and make it shine once again (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:23:46.069204+00:00"
+"Directions": "Wilson St N on Sherman Ave N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803927"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-24T16:32:47Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:32:46Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "35"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "210 - North Sherman"
+"TaxAnnualAmount": "2590.04"
+"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/29947138/35-sherman-avenue-n-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1238
+"OriginalEntryTimestamp": "2026-06-24T16:32:46.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1190947"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947138')"
+"ID": "1566053"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1565833"
+post_author: 1
+"ListingKey": "29955723"
+"ListingId": "40843253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:10:29Z"
+"RFModificationTimestamp": "2026-06-26T01:50:25Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2886.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2P8"
+"UnparsedAddress": "103 SHERMAN Avenue S, Hamilton, Ontario L8M2P8"
+"Coordinates": array:2 [
0 => -79.8393806
1 => 43.2481979
]
+"Latitude": 43.2481979
+"Longitude": -79.8393806
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Victorian residence seamlessly blends timeless character with modern upgrades, offering over 3,000 sq ft of beautifully finished living space. Featuring 6 bedrooms, 2 kitchens, 3 bathrooms, and multiple private entrances, this property is ideal for large families, multi-generational living, or savvy investors. The fully renovated main floor kitchen is a true showpiece-bright and modern with crisp white cabinetry, stainless steel appliances & gas range. Original architectural details add warmth and charm throughout, including hardwood floors, pocket doors, leaded glass windows, natural slate, Carrera marble countertops and vaulted ceilings. Step outside to a low maintenance backyard filled with perennials. A rare opportunity to own a truly stately home. Parking for up to 5 cars. Excellent location close to all amenities and bus route. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:50:14.363178+00:00"
+"Directions": "Main St E & North on Sherman Ave S"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976293"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T23:02:07Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:02:07Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "SHERMAN"
+"StreetNumber": "103"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "11336.99"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29955723/103-sherman-avenue-s-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2886
+"OriginalEntryTimestamp": "2026-06-25T23:02:07.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1262753"
+"ListOfficeNationalAssociationId": "1344654"
+"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('29955723')"
+"ID": "1565833"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1563424"
+post_author: 1
+"ListingKey": "29950227"
+"ListingId": "X13486450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T00:50:06Z"
+"RFModificationTimestamp": "2026-06-25T22:32:58Z"
+"ListPrice": 319000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Beasley)"
+"PostalCode": "L6R0A7"
+"UnparsedAddress": "608 - 212 KING WILLIAM STREET, Hamilton (Beasley), Ontario L6R0A7"
+"Coordinates": array:2 [
0 => -79.860814
1 => 43.255095
]
+"Latitude": 43.255095
+"Longitude": -79.860814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Almost brand new unit in a modern building featuring outstanding amenities, including a rooftop BBQ area, party room, TV lounge, and fully equipped gym. Conveniently located within walking distance to downtown Hamilton, shopping, restaurants, public transit, and everyday amenities. Close to the police station and offering easy access to everything the city has to offer. A great opportunity for comfortable urban living. (id:62650)"
+"AssociationFee": "371.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:32:44.903458+00:00"
+"Directions": "King William And Ferguson Ave"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2142481"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T00:44:12Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T00:44:12Z"
+"StreetName": "King William"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3659.5"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Beasley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950227/608-212-king-william-street-hamilton-beasley-beasley"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-25T00:44:12.27Z"
+"ListAgentNationalAssociationId": "1394210"
+"ListOfficeNationalAssociationId": "1254684"
+"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('29950227')"
+"ID": "1563424"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1563191"
+post_author: 1
+"ListingKey": "29949664"
+"ListingId": "40840332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T02:40:03Z"
+"RFModificationTimestamp": "2026-06-25T22:12:16Z"
+"ListPrice": 459000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4B5"
+"UnparsedAddress": "43 WHITFIELD Avenue, Hamilton, Ontario L8L4B5"
+"Coordinates": array:2 [
0 => -79.824568
1 => 43.259612
]
+"Latitude": 43.259612
+"Longitude": -79.824568
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 43 Whitfield Ave, a charming and versatile bungalow situated on a spacious lot in a desirable neighbourhood. This well-maintained home features 2 bedrooms, 1 bathroom, and a functional kitchen with ample cabinetry and storage space. The property offers ample driveway parking and a separate side entrance for added convenience. The large backyard provides plenty of space for outdoor entertaining, gardening, family activities, or future expansion possibilities. Ideal for first-time homebuyers, downsizers, investors, or those seeking a property with great potential. Conveniently located close to amenities, schools, parks, shopping, and major transportation routes. Easy to show. A fantastic opportunity you don't want to miss—must see! (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:11:11.093775+00:00"
+"Directions": "QEW to Burlington St E, South on Gage Ave N, West on Whitfield Ave to Property."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236557"
+"ListOfficeKey": "283383"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-24T22:32:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T02:32:19Z"
+"Stories": "1.0"
+"StreetName": "WHITFIELD"
+"StreetNumber": "43"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "210 - North Sherman"
+"TaxAnnualAmount": "2335.84"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/public/photos/252873081"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29949664/43-whitfield-avenue-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "M5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-24T22:32:30.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1474358"
+"ListOfficeNationalAssociationId": "1328451"
+"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('29949664')"
+"ID": "1563191"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1563091"
+post_author: 1
+"ListingKey": "29950026"
+"ListingId": "X13486366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T03:50:02Z"
+"RFModificationTimestamp": "2026-06-25T22:05:29Z"
+"ListPrice": 459000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Industrial Sector)"
+"PostalCode": "L8L4B5"
+"UnparsedAddress": "43 WHITFIELD AVENUE, Hamilton (Industrial Sector), Ontario L8L4B5"
+"Coordinates": array:2 [
0 => -79.8245926
1 => 43.2595451
]
+"Latitude": 43.2595451
+"Longitude": -79.8245926
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 43 Whitfield Ave, a charming and versatile bungalow situated on a spacious lot in adesirable neighbourhood. This well-maintained home features 2 bedrooms, 1 bathroom, and afunctional kitchen with ample cabinetry and storage space. The property offers ample drivewayparking and a separate side entrance for added convenience. The large backyard provides plentyof space for outdoor entertaining, gardening, family activities, or future expansionpossibilities. Ideal for first-time homebuyers, downsizers, investors, or those seeking aproperty with great potential. Conveniently located close to amenities, schools, parks,shopping, and major transportation routes. Easy to show. A fantastic opportunity you don'twant to miss-must see! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:04:20.824549+00:00"
+"Directions": "Cross Streets: Gage Ave N / Beach Rd. ** Directions: QEW to Burlington St E, South on Gage Ave N,West on Whitfield Ave to Property."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2013878"
+"ListOfficeKey": "290346"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 204.5 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:45:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T03:41:45Z"
+"Stories": "1.0"
+"StreetName": "Whitfield"
+"StreetNumber": "43"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2335.84"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/public/photos/252873081"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Industrial Sector"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950026/43-whitfield-avenue-hamilton-industrial-sector-industrial-sector"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "M5"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-06-24T23:45:36.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1296571"
+"ListOfficeNationalAssociationId": "1386100"
+"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('29950026')"
+"ID": "1563091"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1562138"
+post_author: 1
+"ListingKey": "29947003"
+"ListingId": "40842443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:00:05Z"
+"RFModificationTimestamp": "2026-06-25T20:44:59Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1230.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5X8"
+"UnparsedAddress": "19 HUNTLEY Street, Hamilton, Ontario L8L5X8"
+"Coordinates": array:2 [
0 => -79.8465163
1 => 43.2563063
]
+"Latitude": 43.2563063
+"Longitude": -79.8465163
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked at the end of a quiet cul-de-sac, This super clean, move in ready, All brick 2.5 storey 3 bed 2 bath home is 90% carpet free. It features a rare double wide front driveway, and a waterproofed basement. The kind of home that instantly feels warm, welcoming, and well cared for. Hardwood flooring runs throughout most of the interior, The main floor includes an open living room and dinning area. Stainless Steel appliances in the kitchen there is space here to grow, gather, work from home, or simply settle into a home that feels established and welcoming. The second floor features two freshly painted good sized rooms and a 4 piece bathroom with a tiled shower. Up top you will find the third bedroom a large finished loft with vinyl plank flooring and a ton storage The unfinished basement, mainly for storage is super dry and completely waterproofed with an extra 2 piece bathroom Beyond the front door, the lifestyle this location offers is just as compelling. Cathy Wever Elementary School is only steps away, while Pinky Lewis Recreation Centre & Pool, Bayfront Park, the GO Station, downtown restaurants, shops, and convenient highway access are all close at hand. It’s a setting that makes day-to-day living easier while keeping you connected to some of Hamilton’s best amenities, green spaces, and community attractions. Significant updates over the years add lasting value and peace of mind, including windows and doors, backflow valve, furnace, central air and hot water heater (2018), along with bathroom updates and stair carpeting (2021). With parking for 2 cars in the front drive and a home that has been genuinely cherished over time, 19 Huntley Street offers something buyers are always searching for but rarely find: character, care, and a location that truly works for real life. A home with soul, substance, and a setting to match. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:44:36.156003+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-06-24T16:11:06Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:51:31Z"
+"Stories": "2.5"
+"StreetName": "HUNTLEY"
+"StreetNumber": "19"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "2560.28"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947003/19-huntley-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1230
+"OriginalEntryTimestamp": "2026-06-24T16:11:05.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1161082"
+"ListOfficeNationalAssociationId": "1262401"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947003')"
+"ID": "1562138"
}
]
+success: true
+page_size: 9
+page_count: 29
+count: 259
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]