array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29848841 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1492019"
+post_author: 1
+"ListingKey": "29848841"
+"ListingId": "X13235920"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T02:55:28Z"
+"RFModificationTimestamp": "2026-06-10T02:56:39Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Industrial Sector)"
+"PostalCode": "L8L6A2"
+"UnparsedAddress": "14 NIAGARA STREET, Hamilton (Industrial Sector), Ontario L8L6A2"
+"Coordinates": array:2 [
0 => -79.841979
1 => 43.264649
]
+"Latitude": 43.264649
+"Longitude": -79.841979
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Finding enough space for everyone under one roof isn't easy, especially at this price point. Offering 5 bedrooms, 2 full kitchens, a separate entrance, and nearly 2,300 square feet of finished living space, this rare and versatile home presents an exceptional opportunity for large families, multi-generational living, or buyers simply looking for room to grow. Filled with character and thoughtfully maintained throughout, the bright main level features hardwood flooring, large bay windows, a welcoming living and dining area, a spacious custom kitchen with stainless steel appliances, and a full bathroom. Upstairs, the flexible layout continues with a second full kitchen, two generous bedrooms, and an additional full bathroom, creating the perfect setup for extended family, adult children, guests, or a private living space of their own. The third level offers two more spacious bedrooms, while the fully finished basement with a separate entrance adds even greater flexibility with a large recreation room and fifth bedroom. Step outside to a private backyard retreat complete with mature trees, a tranquil pond, a large deck for entertaining, and a storage shed, while the oversized concrete driveway provides parking for up to three vehicles. Conveniently located close to schools, parks, shopping, public transit, and highway access, this is the kind of home that offers the space, flexibility, and value that are becoming increasingly difficult to find. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T23:20:10.827963+00:00"
+"Directions": "Cross Streets: Barton St E to Wentworth St N. ** Directions: Barton St E to Wentworth St N, East on Monroe St, North on Niagara St."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238085"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "39 x 70 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T19:54:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T02:46:33Z"
+"Stories": "2.5"
+"StreetName": "Niagara"
+"StreetNumber": "14"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2844.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1656084759"
"RoomType" => "Bathroom"
"ListingId" => "X13235920"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "29848841"
"RoomLength" => 1.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
1 => array:11 [
"RoomKey" => "1656084760"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13235920"
"RoomLevel" => "Basement"
"RoomWidth" => 7.14
"ListingKey" => "29848841"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
2 => array:11 [
"RoomKey" => "1656084761"
"RoomType" => "Bedroom"
"ListingId" => "X13235920"
"RoomLevel" => "Basement"
"RoomWidth" => 2.57
"ListingKey" => "29848841"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
3 => array:11 [
"RoomKey" => "1656084762"
"RoomType" => "Living room"
"ListingId" => "X13235920"
"RoomLevel" => "Main level"
"RoomWidth" => 4.34
"ListingKey" => "29848841"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
4 => array:11 [
"RoomKey" => "1656084763"
"RoomType" => "Dining room"
"ListingId" => "X13235920"
"RoomLevel" => "Main level"
"RoomWidth" => 3.84
"ListingKey" => "29848841"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
5 => array:11 [
"RoomKey" => "1656084764"
"RoomType" => "Kitchen"
"ListingId" => "X13235920"
"RoomLevel" => "Main level"
"RoomWidth" => 3.84
"ListingKey" => "29848841"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
6 => array:11 [
"RoomKey" => "1656084765"
"RoomType" => "Bathroom"
"ListingId" => "X13235920"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29848841"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
7 => array:11 [
"RoomKey" => "1656084766"
"RoomType" => "Kitchen"
"ListingId" => "X13235920"
"RoomLevel" => "Second level"
"RoomWidth" => 3.33
"ListingKey" => "29848841"
"RoomLength" => 4.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
8 => array:11 [
"RoomKey" => "1656084767"
"RoomType" => "Bedroom"
"ListingId" => "X13235920"
"RoomLevel" => "Second level"
"RoomWidth" => 3.51
"ListingKey" => "29848841"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
9 => array:11 [
"RoomKey" => "1656084768"
"RoomType" => "Bedroom"
"ListingId" => "X13235920"
"RoomLevel" => "Second level"
"RoomWidth" => 2.72
"ListingKey" => "29848841"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.52Z"
]
10 => array:11 [
"RoomKey" => "1656084769"
"RoomType" => "Bedroom"
"ListingId" => "X13235920"
"RoomLevel" => "Third level"
"RoomWidth" => 2.97
"ListingKey" => "29848841"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.53Z"
]
11 => array:11 [
"RoomKey" => "1656084770"
"RoomType" => "Bedroom"
"ListingId" => "X13235920"
"RoomLevel" => "Third level"
"RoomWidth" => 3.4
"ListingKey" => "29848841"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T02:46:33.53Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Industrial Sector"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29848841/14-niagara-street-hamilton-industrial-sector-industrial-sector"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.0
+"OriginalEntryTimestamp": "2026-06-03T19:54:18.09Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475992"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29848841_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/c54aa54d04ed64ec74daae8e819b30a8.webp"
"MediaSize" => 381836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-c54aa54d04ed64ec74daae8e819b30a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29848841_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/fcc46cfac67d72444379e7cfa957b5fa.webp"
"MediaSize" => 241037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-fcc46cfac67d72444379e7cfa957b5fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29848841_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/ea5775a25fdcf52053a71ac4f3e34247.webp"
"MediaSize" => 221455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-ea5775a25fdcf52053a71ac4f3e34247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29848841_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/138dcbbcee31a6a41456871f19c86a6c.webp"
"MediaSize" => 93881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-138dcbbcee31a6a41456871f19c86a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29848841_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/86fee0168d7d17954bd801e16191b82a.webp"
"MediaSize" => 73056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-86fee0168d7d17954bd801e16191b82a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29848841_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/ec1ed633eb378dc343d4e2b11c93c4a7.webp"
"MediaSize" => 121016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-ec1ed633eb378dc343d4e2b11c93c4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29848841_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/1c3f39464ec8aca82467ad55ddc7f3cc.webp"
"MediaSize" => 116022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-1c3f39464ec8aca82467ad55ddc7f3cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29848841_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/f6881101b24761bcaf2542a49a1531fe.webp"
"MediaSize" => 129554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-f6881101b24761bcaf2542a49a1531fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29848841_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/1564165891b749edc471ff764df9dce5.webp"
"MediaSize" => 117189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-1564165891b749edc471ff764df9dce5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29848841_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/f3189d1a3b5b16f8bb1497408e135cdb.webp"
"MediaSize" => 124031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-f3189d1a3b5b16f8bb1497408e135cdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29848841_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/bed2844ad6d002f6d87d6dc8364698eb.webp"
"MediaSize" => 122438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-bed2844ad6d002f6d87d6dc8364698eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29848841_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/baaa801c0b710d79488b1a58863ad388.webp"
"MediaSize" => 139698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-baaa801c0b710d79488b1a58863ad388.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29848841_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/8b157f3e31ae0b95b7081c8b2895a380.webp"
"MediaSize" => 129720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-8b157f3e31ae0b95b7081c8b2895a380.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29848841_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/18da68fa1e0aab9627e6bc9cbcb42722.webp"
"MediaSize" => 149410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-18da68fa1e0aab9627e6bc9cbcb42722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29848841_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/d7c59adfae2fc95c9bb2f8dbbf464bba.webp"
"MediaSize" => 176070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-d7c59adfae2fc95c9bb2f8dbbf464bba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29848841_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/6b8fe1a36b20546473702476e915bc6e.webp"
"MediaSize" => 102988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-6b8fe1a36b20546473702476e915bc6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29848841_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/4cc20ebf5b01c2162d6771eaa309c172.webp"
"MediaSize" => 142483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-4cc20ebf5b01c2162d6771eaa309c172.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29848841_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/60f8db223dc296cdba3966b944dc3985.webp"
"MediaSize" => 141829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-60f8db223dc296cdba3966b944dc3985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29848841_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/35c13fa8cfac4a8e05ddf6487d369cf4.webp"
"MediaSize" => 94577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-35c13fa8cfac4a8e05ddf6487d369cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29848841_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/2ab35b5feff9db6699ed6235d54eb24a.webp"
"MediaSize" => 107392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-2ab35b5feff9db6699ed6235d54eb24a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29848841_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/56b9b1c94f6500465b6ddb47af192758.webp"
"MediaSize" => 96041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-56b9b1c94f6500465b6ddb47af192758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29848841_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/5ece5c3b9cc7e9bdb28192108b23f827.webp"
"MediaSize" => 109034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-5ece5c3b9cc7e9bdb28192108b23f827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29848841_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/80da7470e774cd4967ae5f6cc5585e51.webp"
"MediaSize" => 79568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-80da7470e774cd4967ae5f6cc5585e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29848841_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/32df67d2fd149fdbbc85d7f750b27959.webp"
"MediaSize" => 149037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-32df67d2fd149fdbbc85d7f750b27959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29848841_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/db198a6444fe8ed6dcdc67fd1bb19071.webp"
"MediaSize" => 111680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-db198a6444fe8ed6dcdc67fd1bb19071.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29848841_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/1f62892c04261cae97409efa4b030751.webp"
"MediaSize" => 92481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-1f62892c04261cae97409efa4b030751.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29848841_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/57b9d9ce2fa1637320fd2e2eb67ffda7.webp"
"MediaSize" => 81509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-57b9d9ce2fa1637320fd2e2eb67ffda7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29848841_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/ec587e0a92c068a4d11d5920a001050d.webp"
"MediaSize" => 99759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-ec587e0a92c068a4d11d5920a001050d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29848841_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/822c864fa7cd17dd7ede89f1fc7bd446.webp"
"MediaSize" => 94940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-822c864fa7cd17dd7ede89f1fc7bd446.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29848841_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/9302b9ed9367dc195862ceaa3f4338e4.webp"
"MediaSize" => 126767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-9302b9ed9367dc195862ceaa3f4338e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29848841_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/da9c7c5a5134bd52bca30f91f9e53bc6.webp"
"MediaSize" => 93881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-da9c7c5a5134bd52bca30f91f9e53bc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29848841_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/189fd25d39292324e78279db96bcc88b.webp"
"MediaSize" => 75703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-189fd25d39292324e78279db96bcc88b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29848841_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/a5b523e37eb8f4c86da335971786b30e.webp"
"MediaSize" => 67229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-a5b523e37eb8f4c86da335971786b30e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29848841_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/b3063d0bd60d590b47aa9885aaafd24a.webp"
"MediaSize" => 74865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-b3063d0bd60d590b47aa9885aaafd24a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29848841_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/c500a1ceaa398d29637866f6bd67e88c.webp"
"MediaSize" => 137945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-c500a1ceaa398d29637866f6bd67e88c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29848841_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/8533a9418c6cca407cf195e87919208e.webp"
"MediaSize" => 129932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-8533a9418c6cca407cf195e87919208e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29848841_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/460c7d2328e4dc4b7a4e8720f477c08d.webp"
"MediaSize" => 142854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-460c7d2328e4dc4b7a4e8720f477c08d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29848841_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/fdf258959bfeda56225c43ca24a0e4ed.webp"
"MediaSize" => 130135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-fdf258959bfeda56225c43ca24a0e4ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29848841_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/c82042733b4eca28d3349226cb812ef6.webp"
"MediaSize" => 131739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-c82042733b4eca28d3349226cb812ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29848841_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/2590079c5a9d01c74cc2e0a54cb721c5.webp"
"MediaSize" => 143059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-2590079c5a9d01c74cc2e0a54cb721c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29848841_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/66da578c55339942f47711bf12ed4240.webp"
"MediaSize" => 148897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-66da578c55339942f47711bf12ed4240.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29848841_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/4db8030145303e1158bfc89a9990e956.webp"
"MediaSize" => 207691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-4db8030145303e1158bfc89a9990e956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29848841_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/67d23919ac9529c02b764765a11cb153.webp"
"MediaSize" => 136207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-67d23919ac9529c02b764765a11cb153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29848841_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/2071396b42d5821eef8e6bd359964eff.webp"
"MediaSize" => 279458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-2071396b42d5821eef8e6bd359964eff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29848841_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/a2586ed72d395262b32227ff09dd514b.webp"
"MediaSize" => 287447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-a2586ed72d395262b32227ff09dd514b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29848841_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/57a62aeda63377f3fb660794035f20d9.webp"
"MediaSize" => 305331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-57a62aeda63377f3fb660794035f20d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29848841_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/f69a56cd073d478f99157028f90706db.webp"
"MediaSize" => 271747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-f69a56cd073d478f99157028f90706db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29848841_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/efc3f2e95debf4b15d541da33f6640d2.webp"
"MediaSize" => 247246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-efc3f2e95debf4b15d541da33f6640d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29848841_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/7797c96d62b58271bcd698cbc787703c.webp"
"MediaSize" => 239148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-7797c96d62b58271bcd698cbc787703c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29848841_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848841/283f304aed9dfffa9e76fc037525ffc6.webp"
"MediaSize" => 280203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848841/thumbnail-283f304aed9dfffa9e76fc037525ffc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235920"
"ResourceRecordKey" => "29848841"
"ModificationTimestamp" => "2026-06-03T19:54:18.1Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29848841')"
+"ID": "1492019"
}
]
+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 284792" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2238085" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24802
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24854
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2238085"
+"ModificationTimestamp": "2025-02-04T16:24:21Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2238085"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2238085')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29848841'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25204
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29848841'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25222
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31318511"
+"ListingKey": "29848841"
+"ListingId": "X13235920"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T05:18:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31318511')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29848841' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.841979 43.264649)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25295
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1544290"
+post_author: 1
+"ListingKey": "29923615"
+"ListingId": "X13462614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:20Z"
+"RFModificationTimestamp": "2026-06-18T19:31:40Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN AVENUE N, Hamilton (Gibson), Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.836845
1 => 43.254071
]
+"Latitude": 43.254071
+"Longitude": -79.836845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12" baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:30.958383+00:00"
+"Directions": "Cross Streets: Cannon St. E. ** Directions: West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036043"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "32 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:33:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Sherman"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1662307993"
"RoomType" => "Bathroom"
"ListingId" => "X13462614"
"RoomLevel" => "Second level"
"RoomWidth" => 4.42
"ListingKey" => "29923615"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
1 => array:11 [
"RoomKey" => "1662307994"
"RoomType" => "Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Third level"
"RoomWidth" => 4.32
"ListingKey" => "29923615"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
2 => array:11 [
"RoomKey" => "1662307995"
"RoomType" => "Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Third level"
"RoomWidth" => 3.38
"ListingKey" => "29923615"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
3 => array:11 [
"RoomKey" => "1662307996"
"RoomType" => "Loft"
"ListingId" => "X13462614"
"RoomLevel" => "Third level"
"RoomWidth" => 6.38
"ListingKey" => "29923615"
"RoomLength" => 5.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
4 => array:11 [
"RoomKey" => "1662307997"
"RoomType" => "Other"
"ListingId" => "X13462614"
"RoomLevel" => "Basement"
"RoomWidth" => 11.15
"ListingKey" => "29923615"
"RoomLength" => 7.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
5 => array:11 [
"RoomKey" => "1662307998"
"RoomType" => "Foyer"
"ListingId" => "X13462614"
"RoomLevel" => "Main level"
"RoomWidth" => 4.06
"ListingKey" => "29923615"
"RoomLength" => 2.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
6 => array:11 [
"RoomKey" => "1662307999"
"RoomType" => "Living room"
"ListingId" => "X13462614"
"RoomLevel" => "Main level"
"RoomWidth" => 4.8
"ListingKey" => "29923615"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
7 => array:11 [
"RoomKey" => "1662308000"
"RoomType" => "Bathroom"
"ListingId" => "X13462614"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29923615"
"RoomLength" => 1.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
8 => array:11 [
"RoomKey" => "1662308001"
"RoomType" => "Kitchen"
"ListingId" => "X13462614"
"RoomLevel" => "Main level"
"RoomWidth" => 5.28
"ListingKey" => "29923615"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
9 => array:11 [
"RoomKey" => "1662308002"
"RoomType" => "Dining room"
"ListingId" => "X13462614"
"RoomLevel" => "Main level"
"RoomWidth" => 4.78
"ListingKey" => "29923615"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.79Z"
]
10 => array:11 [
"RoomKey" => "1662308003"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Second level"
"RoomWidth" => 4.7
"ListingKey" => "29923615"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.79Z"
]
11 => array:11 [
"RoomKey" => "1662308004"
"RoomType" => "Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Second level"
"RoomWidth" => 3.89
"ListingKey" => "29923615"
"RoomLength" => 2.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.79Z"
]
12 => array:11 [
"RoomKey" => "1662308005"
"RoomType" => "Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Second level"
"RoomWidth" => 2.72
"ListingKey" => "29923615"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.79Z"
]
13 => array:11 [
"RoomKey" => "1662308006"
"RoomType" => "Bedroom"
…9
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923615/86-sherman-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-18T18:33:09.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1312659"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923615')"
+"ID": "1544290"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1543934"
+post_author: 1
+"ListingKey": "29923022"
+"ListingId": "40840784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:07:59Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2657.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN Avenue N, Hamilton, Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.8370126
1 => 43.2541
]
+"Latitude": 43.2541
+"Longitude": -79.8370126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12 baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:07:21.652135+00:00"
+"Directions": "West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562180"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T17:32:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:33Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"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/29923022/86-sherman-avenue-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2657
+"OriginalEntryTimestamp": "2026-06-18T17:32:47.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1148101"
+"ListOfficeNationalAssociationId": "1398404"
+"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('29923022')"
+"ID": "1543934"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1543076"
+post_author: 1
+"ListingKey": "29921729"
+"ListingId": "40839562"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:40:11Z"
+"RFModificationTimestamp": "2026-06-18T19:51:58Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1770.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR Avenue, Hamilton, Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396012
1 => 43.2502561
]
+"Latitude": 43.2502561
+"Longitude": -79.8396012
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly “secret” treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:46:40.695416+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235618"
+"ListOfficeKey": "106156"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T15:32:20Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:31:32Z"
+"Stories": "2.5"
+"StreetName": "SAINT CLAIR"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921729/33-saint-clair-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1770
+"OriginalEntryTimestamp": "2026-06-18T15:32:20.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1473446"
+"ListOfficeNationalAssociationId": "1223962"
+"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('29921729')"
+"ID": "1543076"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1542891"
+post_author: 1
+"ListingKey": "29922111"
+"ListingId": "X13461424"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:05Z"
+"RFModificationTimestamp": "2026-06-18T21:10:54Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR AVENUE, Hamilton (Gibson), Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396496
1 => 43.250259
]
+"Latitude": 43.250259
+"Longitude": -79.8396496
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly "secret" treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:42:11.953852+00:00"
+"Directions": "King St E & Sherman Ave S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1980677"
+"ListOfficeKey": "290193"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "29 x 88.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T16:05:42Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:17Z"
+"Stories": "2.5"
+"StreetName": "Saint Clair"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922111/33-saint-clair-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-18T16:05:42.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1266299"
+"ListOfficeNationalAssociationId": "1384630"
+"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('29922111')"
+"ID": "1542891"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1540942"
+post_author: 1
+"ListingKey": "29918407"
+"ListingId": "40840466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:00:07Z"
+"RFModificationTimestamp": "2026-06-18T17:47:06Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1164.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7A3"
+"UnparsedAddress": "153 GAGE Avenue N, Hamilton, Ontario L8L7A3"
+"Coordinates": array:2 [
0 => -79.8268597
1 => 43.2528588
]
+"Latitude": 43.2528588
+"Longitude": -79.8268597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity knocks at 153 Gage Ave N! This beautifully updated 3-bedroom home offers the perfect blend of timeless character, modern comfort, and unbeatable convenience in Hamilton's vibrant Central East neighbourhood. Walk to Tim Hortons Field, explore the trendy shops, cafés, restaurants, and local markets of the Ottawa Street North shopping district, or enjoy the gardens, trails, and year-round community events at nearby Gage Park. With quick access to the Red Hill Valley Parkway, Nikola Tesla Boulevard, the QEW, and public transit, commuting throughout Hamilton and the GTA is a breeze. Freshly painted from top to bottom, this move-in-ready home welcomes you with new tile flooring through the foyer, kitchen, and main floor powder room. The updated kitchen flows seamlessly into bright and inviting living and dining spaces, where original inlaid hardwood flooring, elegant coved ceilings, and beautiful stained-glass accents showcase the home's classic charm. The second floor has been completely refreshed with new luxury vinyl plank flooring throughout and features a spacious primary bedroom, two additional generously sized bedrooms, and a stunning brand-new 4-piece bathroom with a subway tile surround. Outside, you'll find a private backyard, detached single garage, and driveway parking for two additional vehicles. As an added bonus, the quiet church next door creates a uniquely peaceful setting rarely found in the city. Whether you're a first-time buyer, young family, or investor, this is an exceptional opportunity to own a beautifully updated home in one of Hamilton's most sought-after urban neighbourhoods. Don't miss your chance—schedule your private showing today and discover everything 153 Gage Ave N has to offer. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:50:13.575507+00:00"
+"Directions": "BEECHWOOD & GAGE"
+"ExteriorFeatures": array:5 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
3 => "Metal"
4 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:39:46Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:52:01Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "GAGE"
+"StreetNumber": "153"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "2934.38"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/153_gage_ave_n_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918407/153-gage-avenue-n-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1164
+"OriginalEntryTimestamp": "2026-06-17T20:39:46.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"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('29918407')"
+"ID": "1540942"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1540758"
+post_author: 1
+"ListingKey": "29918518"
+"ListingId": "X13458494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:05:21Z"
+"RFModificationTimestamp": "2026-06-18T19:01:10Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stipley)"
+"PostalCode": "L8L7A3"
+"UnparsedAddress": "153 GAGE AVENUE N, Hamilton (Stipley), Ontario L8L7A3"
+"Coordinates": array:2 [
0 => -79.826894
1 => 43.252865
]
+"Latitude": 43.252865
+"Longitude": -79.826894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 153 Gage Ave N! This beautifully updated 3-bedroom home offers the perfect blend of timeless character, modern comfort, and unbeatable convenience in Hamilton's vibrant Central East neighbourhood. Walk to Tim Hortons Field, explore the trendy shops, cafés, restaurants, and local markets of the Ottawa Street North shopping district, or enjoy the gardens, trails, and year-round community events at nearby Gage Park. With quick access to the Red Hill Valley Parkway, Nikola Tesla Boulevard, the QEW, and public transit, commuting throughout Hamilton and the GTA is a breeze.Freshly painted from top to bottom, this move-in-ready home welcomes you with new tile flooring through the foyer, kitchen, and main floor powder room. The updated kitchen flows seamlessly into bright and inviting living and dining spaces, where original inlaid hardwood flooring, elegant coved ceilings, and beautiful stained-glass accents showcase the home's classic charm.The second floor has been completely refreshed with new luxury vinyl plank flooring throughout and features a spacious primary bedroom, two additional generously sized bedrooms, and a stunning brand-new 4-piece bathroom with a subway tile surround. Outside, you'll find a private backyard, detached single garage, and driveway parking for two additional vehicles. As an added bonus, the quiet church next door creates a uniquely peaceful setting rarely found in the city.Whether you're a first-time buyer, young family, or investor, this is an exceptional opportunity to own a beautifully updated home in one of Hamilton's most sought-after urban neighbourhoods. Don't miss your chance-schedule your private showing today and discover everything 153 Gage Ave N has to offer. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:32:17.282341+00:00"
+"Directions": "Cross Streets: Barton & Gage. ** Directions: Beechwood & Gage."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156692"
+"ListOfficeKey": "289818"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "25 x 83.5 FT ; + 25' X 9' Private Drive"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:43:04Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:56:16Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "Gage"
+"StreetNumber": "153"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2934.38"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/153_gage_ave_n_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Stipley"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29918518/153-gage-avenue-n-hamilton-stipley-stipley"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1899457"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "293196"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-06-17T20:56:55.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1408090"
+"ListOfficeNationalAssociationId": "1381541"
+"CoListAgentNationalAssociationId": "1216506"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1408169"
+"CoListOfficeNationalAssociationId2": "1423680"
+"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('29918518')"
+"ID": "1540758"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1540035"
+post_author: 1
+"ListingKey": "29916475"
+"ListingId": "40840660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:00:07Z"
+"RFModificationTimestamp": "2026-06-18T14:04:40Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.04
+"LivingArea": 1208.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R8"
+"UnparsedAddress": "520 N JOHN Street N, Hamilton, Ontario L8L4R8"
+"Coordinates": array:2 [
0 => -79.8593059
1 => 43.2719099
]
+"Latitude": 43.2719099
+"Longitude": -79.8593059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This solid brick two-storey home offers exceptional value in one of Hamilton’s most exciting and evolving neighbourhoods. Located on John Street North, just steps from the rapidly transforming West Harbour waterfront, you’ll enjoy easy access to marinas, waterfront trails, parks, boardwalks, yacht clubs, outdoor skating/roller skating, and all the energy of Hamilton’s growing north end. A fantastic option for first-time buyers, young families, couples, or investors alike. Inside, the home features classic thin-strip hardwood flooring throughout, a traditional main floor layout with separate living and dining spaces, and a functional kitchen at the rear. Upstairs offers three bedrooms and a full 4-piece bathroom. A high, dry basement with rear walkout presents additional potential, while the unfinished attic with existing window may offer future possibilities for added living space, studio space, or storage. The fully fenced rear yard provides outdoor space for kids, pets, or entertaining. Conveniently located near schools, parks, the Bennetto Community Centre, public transit, and downtown amenities, this is a great opportunity to own a well-built home in a neighbourhood with tremendous long-term upside. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:56:52.121167+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235636"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.04"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T16:53:37Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T13:50:38Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "JOHN"
+"StreetNumber": "520"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "3398.51"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29916475/520-john-street-n-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1208
+"OriginalEntryTimestamp": "2026-06-17T16:51:30.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1473518"
+"ListOfficeNationalAssociationId": "1486985"
+"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('29916475')"
+"ID": "1540035"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1539329"
+post_author: 1
+"ListingKey": "29916764"
+"ListingId": "X13457038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:35:32Z"
+"RFModificationTimestamp": "2026-06-17T17:56:46Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L4R8"
+"UnparsedAddress": "520 JOHN STREET N, Hamilton (North End), Ontario L8L4R8"
+"Coordinates": array:2 [
0 => -79.859311
1 => 43.27191
]
+"Latitude": 43.27191
+"Longitude": -79.859311
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "This solid brick two-storey home offers exceptional value in one of Hamilton's most exciting and evolving neighbourhoods. Located on John Street North, just steps from the rapidly transforming West Harbour waterfront, you'll enjoy easy access to marinas, waterfront trails, parks, boardwalks, yacht clubs, outdoor skating/roller skating, and all the energy of Hamilton's growing north end. A fantastic option for first-time buyers, young families, couples, or investors alike. Inside, the home features classic thin-strip hardwood flooring throughout, a traditional main floor layout with separate living and dining spaces, and a functional kitchen at the rear. Upstairs offers three bedrooms and a full 4-piece bathroom. A high, dry basement with rear walkout presents additional potential, while the unfinished attic with existing window may offer future possibilities for added living space, studio space, or storage. The fully fenced rear yard provides outdoor space for kids, pets, or entertaining. Conveniently located near schools, parks, the Bennetto Community Centre, public transit, and downtown amenities, this is a great opportunity to own a well-built home in a neighbourhood with tremendous long-term upside. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:3 [
0 => "Full"
1 => "Walk out"
2 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:56:32.527652+00:00"
+"Directions": "Cross Streets: John and Burlington. ** Directions: Adjacent to the intersection of John St N and Burlington St E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.9 x 90 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T17:25:40Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:25:40Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "John"
+"StreetNumber": "520"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3398.51"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "North End"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29916764/520-john-street-n-hamilton-north-end-north-end"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.1
+"OriginalEntryTimestamp": "2026-06-17T17:25:40.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"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('29916764')"
+"ID": "1539329"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1536803"
+post_author: 1
+"ListingKey": "29911530"
+"ListingId": "X13451952"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:06Z"
+"RFModificationTimestamp": "2026-06-16T19:43:47Z"
+"ListPrice": 588900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6H2"
+"UnparsedAddress": "10 FAIRLEIGH AVENUE N, Hamilton (Gibson), Ontario L8L6H2"
+"Coordinates": array:2 [
0 => -79.84248
1 => 43.251688
]
+"Latitude": 43.251688
+"Longitude": -79.84248
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional opportunity to own a legal duplex with a separate basement apartment, offering strong income potential and immediate upside. This well-maintained multi-unit property features three self-contained residential units, with two units currently vacant, allowing the new owner to secure market rents immediately or occupy one unit while generating income from the others. Unit 1 (Main Floor): Bright and spacious 1-bedroom apartment. Unit 2 (Upper Level): Large 3-bedroom apartment featuring an expansive finished attic space, ideal for a home office, recreation room, additional living area, or storage. Unit 3 (Basement): Renovated 1-bedroom apartment, updated approximately one year ago. The property previously generated approximately $4,700/month in gross rental income, with rents of approximately $1,400/month (Unit 1), $2,100/month (Unit 2), and $1,250/month (Unit 3). Tenants pay their own utilities, helping minimize operating expenses, and the property benefits from two separate hydro meters. Ideal for investors seeking strong cash flow and long-term appreciation or owner-occupants looking for a mortgage helper, this property offers exceptional flexibility and income-generating potential. The vacant units provide an immediate opportunity to maximize returns based on current market conditions. Conveniently located just minutes from Hamilton General Hospital, the future LRT corridor along Highway 8/Main Street East, West Harbour GO Station, Downtown Hamilton, schools, parks, shopping, public transit, and major commuter routes. This central location provides excellent connectivity and access to Hamilton's growing employment, healthcare, and transportation hubs. A rare opportunity to acquire a versatile income-producing property with immediate leasing flexibility, strong rental demand, and outstanding long-term investment potential. (id:62783)"
+"Appliances": array:5 [
0 => "All"
1 => "Refrigerator"
2 => "Stove"
3 => "Range"
4 => "Dryer"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Apartment in basement"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T19:42:25.009441+00:00"
+"Directions": "King St E & Sherman Ave S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006993"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "21 x 44.7 FT ; 21.04 X 42.58 X 29.06 X 44.80"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T18:59:00Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:59:00Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Fairleigh"
+"StreetNumber": "10"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3526.38"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29911530/10-fairleigh-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1982306"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296729"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Toc-3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 21.0
+"OriginalEntryTimestamp": "2026-06-16T18:59:00.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289122"
+"ListOfficeNationalAssociationId": "1461559"
+"CoListAgentNationalAssociationId": "1267485"
+"CoListOfficeNationalAssociationId": "1461559"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911530')"
+"ID": "1536803"
}
]
+success: true
+page_size: 9
+page_count: 28
+count: 251
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]