array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29251275/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251275&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251275/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251275&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "534197"
+post_author: 1
+"ListingKey": "29251275"
+"ListingId": "40798385"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:50:11Z"
+"RFModificationTimestamp": "2026-01-14T20:50:36Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.05
+"LivingArea": 1324.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5K8"
+"UnparsedAddress": "220 N EMERALD Street N, Hamilton, Ontario L8L5K8"
+"Coordinates": array:2 [
0 => -79.8513945
1 => 43.2590195
]
+"Latitude": 43.2590195
+"Longitude": -79.8513945
+"YearBuilt": 1891
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "You really can't miss this value added 3-unit investment that not only makes a strong statement on the street, but is a strong investment too! Not only a bold facade, but a bold 8% potential cap rate make this solid triplex an ideal mix of immediate income and plenty of opportunity to be realized. The fully renovated rear one-bedroom unit is tenanted, while the front studio and second-floor one-bedroom are vacant and ready for updates, allowing you to set market rents and select tenants. The main floor could be consolidated back into one unit for the owner who may want to live in and rent the upper unit. Recent improvements include a complete frame-in renovation of the rear unit, as well as new furnace and hot water tank (2021), updated wiring with 200-amp breaker panel and some exterior brick repointing with the front and side painted (2022), rear stairs replaced (2019),. Two rear parking spaces on a concrete driveway with paved alley access, plus proximity to downtown and public transit routes makes it a very attractive prospect to tenants. A practical & profitable opportunity for investors to build long-term equity in an improving Lansdale neighbourhood. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-01-14T20:33:45.863911+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "Space Heater"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1570568"
+"ListOfficeKey": "55078"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.05"
+"PhotosChangeTimestamp": "2026-01-14T20:10:47Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:48:58Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "EMERALD"
+"StreetNumber": "220"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Lansdale"
+"TaxAnnualAmount": "2490"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1560391814"
"RoomType" => "Storage"
"ListingId" => "40798385"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
1 => array:11 [
"RoomKey" => "1560391815"
"RoomType" => "Utility room"
"ListingId" => "40798385"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
2 => array:11 [
"RoomKey" => "1560391816"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
3 => array:11 [
"RoomKey" => "1560391817"
"RoomType" => "Bedroom"
"ListingId" => "40798385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
4 => array:11 [
"RoomKey" => "1560391818"
"RoomType" => "Eat in kitchen"
"ListingId" => "40798385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
5 => array:11 [
"RoomKey" => "1560391819"
"RoomType" => "Living room"
"ListingId" => "40798385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.45Z"
]
6 => array:11 [
"RoomKey" => "1560391820"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
7 => array:11 [
"RoomKey" => "1560391821"
"RoomType" => "Living room"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
8 => array:11 [
"RoomKey" => "1560391822"
"RoomType" => "Kitchen"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
9 => array:11 [
"RoomKey" => "1560391823"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
10 => array:11 [
"RoomKey" => "1560391824"
"RoomType" => "Bedroom"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
11 => array:11 [
"RoomKey" => "1560391825"
"RoomType" => "Living room"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
12 => array:11 [
"RoomKey" => "1560391826"
"RoomType" => "Eat in kitchen"
"ListingId" => "40798385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251275"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T20:48:58.46Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29251275/220-emerald-street-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1525353"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55078"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1324
+"OriginalEntryTimestamp": "2026-01-14T20:10:47.39Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404626418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/bf01bdfa559058a155823a84b08ad1dc.webp"
"MediaSize" => 200848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-bf01bdfa559058a155823a84b08ad1dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404626459"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/79ce309bcbfb14020c881e5c6bb2d53f.webp"
"MediaSize" => 208943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-79ce309bcbfb14020c881e5c6bb2d53f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404626492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/010d88981d620bc96e34ecfb5d2526e3.webp"
"MediaSize" => 117558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-010d88981d620bc96e34ecfb5d2526e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404626515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/63f4b6889d5ead33cb2fa9daf7b2b9a8.webp"
"MediaSize" => 95708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-63f4b6889d5ead33cb2fa9daf7b2b9a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404626522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/48a8c2272c6810cae94d99c5886cd1b7.webp"
"MediaSize" => 99630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-48a8c2272c6810cae94d99c5886cd1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404626530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/4889a8f71c4758307d6af832ceb89bfe.webp"
"MediaSize" => 73978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-4889a8f71c4758307d6af832ceb89bfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404626537"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/d86c1714cf1934a653768e734ec6c038.webp"
"MediaSize" => 88301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-d86c1714cf1934a653768e734ec6c038.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404626546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/a6cfcaee0ff160a37facd105ba34fca1.webp"
"MediaSize" => 113982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-a6cfcaee0ff160a37facd105ba34fca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404626567"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/930a0b3940725e26e97482f5a5522951.webp"
"MediaSize" => 95333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-930a0b3940725e26e97482f5a5522951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404626616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/9495890e6a9309c999b191966ea80056.webp"
"MediaSize" => 65539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-9495890e6a9309c999b191966ea80056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404626681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/aaf6a84ef77dc7b921615c1c783f6b60.webp"
"MediaSize" => 113371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-aaf6a84ef77dc7b921615c1c783f6b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404626752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/7a64d3027a292d6a6409ec1fad23fdb7.webp"
"MediaSize" => 72612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-7a64d3027a292d6a6409ec1fad23fdb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404626798"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/16f075a842241c5f36e73edfd785bf2a.webp"
"MediaSize" => 83652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-16f075a842241c5f36e73edfd785bf2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404626851"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/001d1f75e966e45bf9705eaa2b6ce1d2.webp"
"MediaSize" => 87775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-001d1f75e966e45bf9705eaa2b6ce1d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404626923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/dc8ce057d7be4fdaa866f780db357953.webp"
"MediaSize" => 65182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-dc8ce057d7be4fdaa866f780db357953.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6404626947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/cb34191f6bd9d165785c3b335edf9437.webp"
"MediaSize" => 95084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-cb34191f6bd9d165785c3b335edf9437.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6404626955"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/42abd0a53a8fbf25fef4ced439d046ef.webp"
"MediaSize" => 138279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-42abd0a53a8fbf25fef4ced439d046ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6404627042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/fc4c2c4c92aef4c0dc8e53d3fa041fc9.webp"
"MediaSize" => 184490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-fc4c2c4c92aef4c0dc8e53d3fa041fc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6404627061"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/9615744c84f614b41a729020ab857094.webp"
"MediaSize" => 203556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-9615744c84f614b41a729020ab857094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6404627084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251275/7508e4c0ace09bce553562331f90909f.webp"
"MediaSize" => 148864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251275/thumbnail-7508e4c0ace09bce553562331f90909f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798385"
"ResourceRecordKey" => "29251275"
"ModificationTimestamp" => "2026-01-14T20:10:47.4Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Deanna Brown"
"MemberFirstName" => "Deanna"
"MemberLastName" => "Brown"
"MemberMlsId" => "HBBROWNDE"
"OriginatingSystemName" => 26
"MemberKey" => "1570568"
"ModificationTimestamp" => "2025-12-10T05:14:21Z"
"MemberMiddleName" => "L."
"MemberStatus" => "Active"
"OfficeKey" => "55078"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Grimsby"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-971-4023"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1089310"
"OfficeNationalAssociationId" => "1003665"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage NRC Realty Inc."
"OfficePhone" => "905-945-1234"
"OfficeMlsId" => "HBRLPNRCRLTY"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "55078"
"ModificationTimestamp" => "2025-12-09T16:07:06Z"
"OfficeAddress1" => "41 Main Street West"
"OfficeCity" => "Grimsby"
"OfficePostalCode" => "L3R1R"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1003665"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1245523"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251275')"
+"ID": "534197"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 1b746a38ab10b239c948858283ebfcb4cd691799e9319c8542fce567f9e7c1d2" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23792
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage NRC Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-945-1234"
+"OfficeMlsId": "HBRLPNRCRLTY"
+"ModificationTimestamp": "2025-12-09T16:07:06Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55078"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "41 Main Street West"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Grimsby"
+"OfficePostalCode": "L3R1R"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003665"
+"OriginalEntryTimestamp": null
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "452697"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55078"
"SocialMediaUrlOrId" => "https://www.nrcrealty.ca/"
"ModificationTimestamp" => "2025-12-09T15:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1245523"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('55078')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1570568/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1570568&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1570568/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1570568&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25285
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29251275" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24947
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251275/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251275&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251275/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251275&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24929
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251275 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8513945 43.2590195)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251275 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8513945 43.2590195)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251275 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8513945 43.2590195)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251275 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8513945 43.2590195)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24817
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24823
+post_id: "534854"
+post_author: 1
+"ListingKey": "29252028"
+"ListingId": "X12696980"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:51:43Z"
+"ListPrice": 619900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6J8"
+"UnparsedAddress": "134 GIBSON AVENUE, Hamilton (Gibson), Ontario L8L6J8"
+"Coordinates": array:2 [
0 => -79.8392913
1 => 43.2554479
]
+"Latitude": 43.2554479
+"Longitude": -79.8392913
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic opportunity in vibrant Gibson neighbourhood. Newly built in 2022, this 2 storey detached home offers 3+1 bed, 2+1 bath and provides many conveniences of modern living missing from its older neighbours. The front door opens to a large open foyer with motion lit closet. You will pass the convenient main floor laundry and a modern powder room on your way to the state of the art kitchen. You name it, it's got it - SS appliances, hood fan, under counter microwave, tile backsplash, granite countertops, white shaker cabinets and drawers, large double SS sink. Completely open to the bright living/dining area with coffered ceiling, this is the open concept layout you want. Large French doors open to the fenced backyard with laneway access behind offering options for additional parking or possible garage/ADU. Upstairs there are 3 bedrooms - each with ample closet space - and a modern full bath with double floating vanity. The basement offers many fantastic opportunities to rent out to supplement your mortgage, or use as an in-law suite for an older relative, or young adult in your life. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:51:25.985263+00:00"
+"Directions": "Barton/Gibson"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2229874"
+"ListOfficeKey": "50984"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "19.2 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"Stories": "2.0"
+"StreetName": "Gibson"
+"StreetNumber": "134"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3847"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/145996851"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1560412651"
"RoomType" => "Bathroom"
"ListingId" => "X12696980"
"RoomLevel" => "Main level"
"RoomWidth" => 1.96
"ListingKey" => "29252028"
"RoomLength" => 1.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.62Z"
]
1 => array:11 [
"RoomKey" => "1560412652"
"RoomType" => "Bathroom"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 2.69
"ListingKey" => "29252028"
"RoomLength" => 1.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.62Z"
]
2 => array:11 [
"RoomKey" => "1560412653"
"RoomType" => "Utility room"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 3.72
"ListingKey" => "29252028"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.62Z"
]
3 => array:11 [
"RoomKey" => "1560412654"
"RoomType" => "Bathroom"
"ListingId" => "X12696980"
"RoomLevel" => "Second level"
"RoomWidth" => 3.6
"ListingKey" => "29252028"
"RoomLength" => 1.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.62Z"
]
4 => array:11 [
"RoomKey" => "1560412655"
"RoomType" => "Utility room"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 2.4
"ListingKey" => "29252028"
"RoomLength" => 1.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.62Z"
]
5 => array:11 [
"RoomKey" => "1560412656"
"RoomType" => "Pantry"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 2.84
"ListingKey" => "29252028"
"RoomLength" => 1.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
6 => array:11 [
"RoomKey" => "1560412657"
"RoomType" => "Pantry"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 0.65
"ListingKey" => "29252028"
"RoomLength" => 0.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
7 => array:11 [
"RoomKey" => "1560412658"
"RoomType" => "Kitchen"
"ListingId" => "X12696980"
"RoomLevel" => "Main level"
"RoomWidth" => 4.88
"ListingKey" => "29252028"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
8 => array:11 [
"RoomKey" => "1560412659"
"RoomType" => "Laundry room"
"ListingId" => "X12696980"
"RoomLevel" => "Main level"
"RoomWidth" => 1.96
"ListingKey" => "29252028"
"RoomLength" => 1.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
9 => array:11 [
"RoomKey" => "1560412660"
"RoomType" => "Living room"
"ListingId" => "X12696980"
"RoomLevel" => "Main level"
"RoomWidth" => 2.94
"ListingKey" => "29252028"
"RoomLength" => 3.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
10 => array:11 [
"RoomKey" => "1560412661"
"RoomType" => "Foyer"
"ListingId" => "X12696980"
"RoomLevel" => "Main level"
"RoomWidth" => 1.34
"ListingKey" => "29252028"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
11 => array:11 [
"RoomKey" => "1560412662"
"RoomType" => "Bedroom"
"ListingId" => "X12696980"
"RoomLevel" => "Second level"
"RoomWidth" => 5.41
"ListingKey" => "29252028"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
12 => array:11 [
"RoomKey" => "1560412663"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696980"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29252028"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
13 => array:11 [
"RoomKey" => "1560412664"
"RoomType" => "Bedroom 3"
"ListingId" => "X12696980"
"RoomLevel" => "Second level"
"RoomWidth" => 3.27
"ListingKey" => "29252028"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
14 => array:11 [
"RoomKey" => "1560412665"
"RoomType" => "Bedroom"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 3.1
"ListingKey" => "29252028"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
15 => array:11 [
"RoomKey" => "1560412666"
"RoomType" => "Kitchen"
"ListingId" => "X12696980"
"RoomLevel" => "Basement"
"RoomWidth" => 6.29
"ListingKey" => "29252028"
"RoomLength" => 2.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.63Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252028/134-gibson-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 19.2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.6Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404776203"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/5fd5d8761e642de735cf8510d525bab5.webp"
"MediaSize" => 146551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-5fd5d8761e642de735cf8510d525bab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404776236"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/e80743d510c4a2082026f759223b6422.webp"
"MediaSize" => 175885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-e80743d510c4a2082026f759223b6422.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404776250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/dc0d2ef9cc8fe9542acf72dc8eb0a832.webp"
"MediaSize" => 153273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-dc0d2ef9cc8fe9542acf72dc8eb0a832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404776278"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/25d23c4a7c2278c4da8c0186ab3c7516.webp"
"MediaSize" => 59093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-25d23c4a7c2278c4da8c0186ab3c7516.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404776305"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/9ed66dd5962b41c9d9f41f4f723e2dc5.webp"
"MediaSize" => 90571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-9ed66dd5962b41c9d9f41f4f723e2dc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404776363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/0fe56f9ff42702e9290c1498a2a297b4.webp"
"MediaSize" => 83466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-0fe56f9ff42702e9290c1498a2a297b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404776411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/5e4588485368907df8d0713ecc4ed716.webp"
"MediaSize" => 77745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-5e4588485368907df8d0713ecc4ed716.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404776467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/22a71b1e51a088b956e3577cdf341206.webp"
"MediaSize" => 74803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-22a71b1e51a088b956e3577cdf341206.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404776514"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/d959f03db5b07df74a5a4d96d619925d.webp"
"MediaSize" => 96029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-d959f03db5b07df74a5a4d96d619925d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404776554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/6eeaba81fecd4fac55afcf9be87d7075.webp"
"MediaSize" => 94573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-6eeaba81fecd4fac55afcf9be87d7075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404776602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/21c0b300c14775b0ac3da2dec5a12362.webp"
"MediaSize" => 95516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-21c0b300c14775b0ac3da2dec5a12362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404776663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/a64e80d1fb6e1de95976af65d045b988.webp"
"MediaSize" => 128324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-a64e80d1fb6e1de95976af65d045b988.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404776727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/fa1ddcb81f6cf1e4c4a12b41b5b85442.webp"
"MediaSize" => 100503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-fa1ddcb81f6cf1e4c4a12b41b5b85442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404776773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/c46cab6505f6e8969c134e0aa6c7130c.webp"
"MediaSize" => 102376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-c46cab6505f6e8969c134e0aa6c7130c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404776813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/a4e9f2365ad3bcdf64809292a7c460e0.webp"
"MediaSize" => 74313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-a4e9f2365ad3bcdf64809292a7c460e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6404776830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/c0b72da222d208626fc25282bf94b4bc.webp"
"MediaSize" => 80801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-c0b72da222d208626fc25282bf94b4bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6404776873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/2f5fa5dfc00abd471feec071c65c792c.webp"
"MediaSize" => 125200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-2f5fa5dfc00abd471feec071c65c792c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6404776907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/571c56286868a140aa3908b4165efe2f.webp"
"MediaSize" => 70443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-571c56286868a140aa3908b4165efe2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6404776932"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/81a91bff325ea84557b97bf21b4d02b8.webp"
"MediaSize" => 67107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-81a91bff325ea84557b97bf21b4d02b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6404776959"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/dbf6d717229b335da8f01e9ba1cd9548.webp"
"MediaSize" => 70352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-dbf6d717229b335da8f01e9ba1cd9548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6404776981"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/b063fe23c29ab1f39c7b46cc3602812d.webp"
"MediaSize" => 54998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-b063fe23c29ab1f39c7b46cc3602812d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6404776999"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/d474cb6ed200866017d56dcc6085acff.webp"
"MediaSize" => 76215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-d474cb6ed200866017d56dcc6085acff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6404777027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/4f5e6c791ae045d222a98c9d488d0d26.webp"
"MediaSize" => 78322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-4f5e6c791ae045d222a98c9d488d0d26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6404777041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252028/75cd691c8ba6b802ebfd4f77d344abc0.webp"
"MediaSize" => 68411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252028/thumbnail-75cd691c8ba6b802ebfd4f77d344abc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696980"
"ResourceRecordKey" => "29252028"
"ModificationTimestamp" => "2026-01-14T21:45:59.6Z"
]
24 => array:13 [
"Order" => 24
…12
]
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252028')"
+"ID": "534854"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24769
+post_id: "534335"
+post_author: 1
+"ListingKey": "29251000"
+"ListingId": "X12696158"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:40:47Z"
+"RFModificationTimestamp": "2026-01-14T20:47:21Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1C4"
+"UnparsedAddress": "1 - 57 12TH CONCESSION ROAD E, Hamilton, Ontario L8B1C4"
+"Coordinates": array:2 [
0 => -79.8728583
1 => 43.2560802
]
+"Latitude": 43.2560802
+"Longitude": -79.8728583
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Introducing your dream 4 Season Retreat in a charming resort community for homeowners AGED 50 plus. Fernbrook Resort is a LAND LEASE community. Nestled within the serene area of Freelton lies a delightful haven that is waiting to welcome you home. This immaculate 1,700 sq ft residence has recently undergone a stunning transformation, ensuring that it's not just a house; it's a lifestyle upgrade! LOW Monthly fees and an array of amenities, makes this offering both luxurious and affordable with an indoor/outdoor pool, library, sauna, tiki bar, picturesque pond, & scenic walking trails. Every day feels like a vacation! This 1.5 storey gem boasts 3 generously sized bedrooms, 2 bathrooms, balconies off the second floor perfect for relaxation & rejuvenation. The upper sunroom/walk-in closet room is bathed in natural light & brook views, offering a tranquil space for reflection. UPDATED Main Lvl washroom with new tub/shower & Luxurious Heated Floors! NEW flooring & freshly painted walls & ceilings. Sleek open riser stairwell with plush Berber stairs. Modern charm meets functionality with new kitchen appliances, updated lighting fixtures, Main Lvl Laundry, Forced air GAS & BBQ gas line & central A/C. This home exudes an inviting and cozy ambiance, making you feel instantly at ease. Rarely offered Attached GARAGE with convenient Inside Entry provides added storage space. Stay connected with cable, internet, & Wi-Fi services. LOW $466 Monthly fees incl. spring fed well water, water testing, septic system, road maint, upkeep of Pools & more - streamlining your life! You'll be part of a welcoming & vibrant community, where making friends is effortless. Pets are permitted. Host bonfires & BBQs, creating unforgettable moments with loved ones. Relax & unwind on your Oversized Front Porch. Year Round living. Premium property located across from the Clubhouse & Pools with tranquil Brook Views from your backyard & sunroom! Only 15 mins to Waterdown shops! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T20:47:02.035089+00:00"
+"Directions": "Cross Streets: Hwy 6 in Freelton. ** Directions: Off Hwy 6 in Freelton. Take 12th Concession Rd E to the End and turn Left into Fernbrook Resort. Unit 1 is House across from clubhouse."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2158644"
+"ListOfficeKey": "292248"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Country residential"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-14T19:18:46Z"
+"PhotosCount": 38
+"PoolFeatures": array:3 [
0 => "Inground pool"
1 => "Indoor pool"
2 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:27:57Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "12th Concession"
+"StreetNumber": "57"
+"StreetSuffix": "Road"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/B6uURuHaozw?feature=share"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"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"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251000/1-57-12th-concession-road-e-hamilton-rural-flamborough"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-01-14T19:18:46.1Z"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251000')"
+"ID": "534335"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24826
+post_id: "534198"
+post_author: 1
+"ListingKey": "29250452"
+"ListingId": "X12695814"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:00:50Z"
+"RFModificationTimestamp": "2026-01-14T21:05:59Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L4S2"
+"UnparsedAddress": "581 JOHN STREET N, Hamilton (North End), Ontario L8L4S2"
+"Coordinates": array:2 [
0 => -79.858917
1 => 43.273765
]
+"Latitude": 43.273765
+"Longitude": -79.858917
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 581 John Street North in the City of Hamilton. This beautifully updated 3-bedroom, 2-bathroom, 2.5-storey home is perfectly positioned for outdoor enthusiasts-just steps from Lake Ontario, Pier 8, Bayfront Park, the marina, the Royal Hamilton Yacht Club, and miles of stunning waterfront walking and biking trails. Completely updated and move-in ready, the main floor offers a bright, open-concept design featuring a modern kitchen with a breakfast peninsula overlooking the spacious living and dining areas. A separate, conveniently located main-floor laundry room enhances everyday comfort. The second floor includes several generous bedrooms and a modern full bathroom, while the expansive third-floor loft provides a versatile bonus space ideal for an additional bedroom, home office, or family room. The full, unfinished basement with a separate side entrance presents excellent potential for future living space or perhaps even an in-law setup; the sky is the limit! Outside, enjoy a private deck overlooking the fully fenced backyard-perfect for entertaining or relaxing on warm summer evenings. Centrally located, this home is close to all major amenities including grocery stores, schools, and is within walking distance to the vibrant restaurants, cafés, and boutiques along James Street North. Easy access to HWY 403 and the QEW adds to the convenience. Don't miss your opportunity to view this exceptional property-book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-14T20:03:47.197713+00:00"
+"Directions": "John Street N and Guise Street"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156606"
+"ListOfficeKey": "289810"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "17 x 76.5 Acre"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T20:47:43Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:47:43Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "John"
+"StreetNumber": "581"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2699"
+"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"
+"CityRegion": "North End"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250452/581-john-street-n-hamilton-north-end-north-end"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-01-14T18:22:39.6Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:26 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250452')"
+"ID": "534198"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24816
+post_id: "533671"
+post_author: 1
+"ListingKey": "29250303"
+"ListingId": "X12695660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:55:10Z"
+"RFModificationTimestamp": "2026-01-14T18:46:24Z"
+"ListPrice": 524888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Industrial Sector)"
+"PostalCode": "L8L5X2"
+"UnparsedAddress": "529 WENTWORTH STREET N, Hamilton (Industrial Sector), Ontario L8L5X2"
+"Coordinates": array:2 [
0 => -79.842571
1 => 43.267626
]
+"Latitude": 43.267626
+"Longitude": -79.842571
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "***Shows a 10***Move in condition***Nicely Landscaped**Fenced in yard***Brand new Roof done in 2025***Curb Appeal***Brick***Private Drive Can Park 2 Cars *** 3 Washrooms*** 4 Floors Of Finished Living Space*** Modern Open Concept*** (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-01-14T18:46:20.510816+00:00"
+"Directions": "Cross Streets: Burlington & Wentworth St. ** Directions: Burlington St.- Wentworth South."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1468655"
+"ListOfficeKey": "51257"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Carpet Free"
]
+"LotSizeDimensions": "27.5 x 87 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T17:46:48Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:46:48Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Wentworth"
+"StreetNumber": "529"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2855.58"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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": "Industrial Sector"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250303/529-wentworth-street-n-hamilton-industrial-sector-industrial-sector"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "M6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 27.6
+"OriginalEntryTimestamp": "2026-01-14T17:46:48.65Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250303')"
+"ID": "533671"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24807
+post_id: "533474"
+post_author: 1
+"ListingKey": "29248989"
+"ListingId": "40798329"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T18:55:37Z"
+"RFModificationTimestamp": "2026-01-14T18:58:09Z"
+"ListPrice": 389888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 547.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "479 CHARLTON Avenue E Unit# 209, Hamilton, Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.8534455
1 => 43.2454796
]
+"Latitude": 43.2454796
+"Longitude": -79.8534455
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Where the love of nature and city living meet in perfect balance. This freshly painted, thoughtfully designed space offers an open-concept layout filled with natural light, a sleek modern kitchen, and a cozy living area that flows effortlessly into your private retreat with views of the trees. Perfect for young professionals, medical staff, or anyone who values comfort and convenience. What makes this location so special? 479 Charlton sits at the base of the Niagara Escarpment, giving you front-row access to the city's best hiking trails, waterfalls, and green spaces, all just steps from your door. Yet you're still minutes away from downtown Hamilton's cafés, shops, St. Joseph's Hospital, and vibrant arts scene, as well as the GO Station for commuters. It's the best of both worlds: urban energy paired with tranquil surroundings. Highlights you'll love: Modern one-bedroom layout with contemporary finishes . Bright, open living space with oversized windows Easy access to trails, parks, and scenic lookout points . Close to hospitals, restaurants, shops, and transit · Secure, well-maintained building in a highly desirable area. Comes with 1 underground parking spot, and locker. Don't miss your chance to call this Hamilton gem your new home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "470.38"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T17:28:37.347542+00:00"
+"Directions": "Main Street to Wentworth to Charlton"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Stone"
2 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078913"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-14T18:41:43Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T18:41:43Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CHARLTON"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "143 - Stinson"
+"TaxAnnualAmount": "3488.33"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/209_479_charlton_ave_e_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29248989/479-charlton-avenue-e-unit-209-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "P5, E/S-1710"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 547
+"OriginalEntryTimestamp": "2026-01-14T14:18:39.15Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29248989')"
+"ID": "533474"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24825
+post_id: "533483"
+post_author: 1
+"ListingKey": "29249771"
+"ListingId": "40798376"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:02:43Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2057.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4S2"
+"UnparsedAddress": "581 JOHN Street N, Hamilton, Ontario L8L4S2"
+"Coordinates": array:2 [
0 => -79.858808
1 => 43.273763
]
+"Latitude": 43.273763
+"Longitude": -79.858808
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to 581 John Street North in the City of Hamilton. This beautifully updated 3-bedroom, 2-bathroom, 2.5-storey home is perfectly positioned for outdoor enthusiasts—just steps from Lake Ontario, Pier 8, Bayfront Park, the marina, the Royal Hamilton Yacht Club, and miles of stunning waterfront walking and biking trails. Completely updated and move-in ready, the main floor offers a bright, open-concept design featuring a modern kitchen with a breakfast peninsula overlooking the spacious living and dining areas. A separate, conveniently located main-floor laundry room enhances everyday comfort. The second floor includes several generous bedrooms and a modern full bathroom, while the expansive third-floor loft provides a versatile bonus space ideal for an additional bedroom, home office, or family room. The full, unfinished basement with a separate side entrance presents excellent potential for future living space or perhaps even an in-law setup; the sky is the limit! Outside, enjoy a private deck overlooking the fully fenced backyard—perfect for entertaining or relaxing on warm summer evenings. Centrally located, this home is close to all major amenities including grocery stores, schools, and is within walking distance to the vibrant restaurants, cafés, and boutiques along James Street North. Easy access to HWY 403 and the QEW adds to the convenience. Don’t miss your opportunity to view this exceptional property—book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"CreationDate": "2026-01-14T17:23:08.771837+00:00"
+"Directions": "John Street N and Guise Street"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049035"
+"ListOfficeKey": "289711"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-01-14T20:15:07Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:44:18Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "JOHN"
+"StreetNumber": "581"
+"StreetSuffix": "Street"
+"SubdivisionName": "130 - North End East"
+"TaxAnnualAmount": "2699"
+"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": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29249771/581-john-street-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 17.0
+"AboveGradeFinishedArea": 1504
+"BelowGradeFinishedArea": 553
+"OriginalEntryTimestamp": "2026-01-14T16:44:08.57Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:26 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249771')"
+"ID": "533483"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "533475"
+post_author: 1
+"ListingKey": "29249239"
+"ListingId": "40798381"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T15:46:01Z"
+"RFModificationTimestamp": "2026-01-14T17:19:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2J6"
+"UnparsedAddress": "89 BURRIS Street Unit# B, Hamilton, Ontario L8M2J6"
+"Coordinates": array:2 [
0 => -79.8450409
1 => 43.2483473
]
+"Latitude": 43.2483473
+"Longitude": -79.8450409
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 89 Burris Street, a 2-bed, 1 bath second floor unit with over 900sqft of living space nestled in Hamilton’s St. Clair area. This spacious unit features neutral broadloom throughout with ceramic tiles in the eat-in kitchen. Large living room with neutral décor, large bright windows & access to your balcony for entertaining! Two large bedrooms feature neutral grey walls, broadloom & closets. All Utilities included! Tenant refused access for room measurements. Rental App, Credit report and Employment letter required. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Electricity"
2 => "Water"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-01-14T17:19:02.397456+00:00"
+"Directions": "Main to Burris St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897237"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"PhotosChangeTimestamp": "2026-01-14T15:38:17Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T15:38:17Z"
+"Stories": "2.5"
+"StreetName": "BURRIS"
+"StreetNumber": "89"
+"StreetSuffix": "Street"
+"SubdivisionName": "220 - St. Clair/Blakeley"
+"TaxAnnualAmount": "4433"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249239/89-burris-street-unit-b-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-01-14T15:38:17.2Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:10 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249239')"
+"ID": "533475"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24820
+post_id: "533349"
+post_author: 1
+"ListingKey": "29249404"
+"ListingId": "40798456"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:20:09Z"
+"RFModificationTimestamp": "2026-01-14T17:22:49Z"
+"ListPrice": 550000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 1350.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2S3"
+"UnparsedAddress": "73 GARFIELD Avenue S Unit# 1B, Hamilton, Ontario L8M2S3"
+"Coordinates": array:2 [
0 => -79.8380985
1 => 43.2489477
]
+"Latitude": 43.2489477
+"Longitude": -79.8380985
+"YearBuilt": 1913
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-level loft-style condo in the heart of Hamilton Centre! Step through your private main-floor entrance into a bright and spacious 1-bedroom, 1-bath suite featuring soaring vaulted ceilings and an open-concept layout that’s perfect for entertaining. Transformed into boutique lofts in 2001, this historic building beautifully combines heritage character with modern design. The kitchen showcases stainless steel appliances, a breakfast bar, and a seamless flow into the living and dining area. Automatic blinds add modern convenience and a touch of luxury to your living space. Upstairs, retreat to your generous primary bedroom, offering the perfect balance of comfort and privacy. Enjoy being just minutes from Gage Park, local shops, restaurants, transit, and all the amenities that make Hamilton living so convenient. Experience urban living with a touch of history! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "627.56"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T16:53:42.150827+00:00"
+"Directions": "Follow ON-403 W to Hamilton. Take the Main St exit from ON-403 W, Take the Main St exit toward ON-8 E,Follow Hwy 8/Main St W/ON-8 to Garfield Ave S, Turn left onto Garfield Ave S, building located on the right."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061437"
+"ListOfficeKey": "275238"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-01-14T15:49:51Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:08:43Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "GARFIELD"
+"StreetNumber": "73"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "6342.72"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/9d75fe1c677a99db4d4279a30210d9e4"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249404/73-garfield-avenue-s-unit-1b-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "C/S-1376 C/S-1822"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1350
+"OriginalEntryTimestamp": "2026-01-14T15:49:51.03Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:31 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249404')"
+"ID": "533349"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24818
+post_id: "532527"
+post_author: 1
+"ListingKey": "29248314"
+"ListingId": "X12693632"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T01:20:46Z"
+"RFModificationTimestamp": "2026-01-14T01:30:51Z"
+"ListPrice": 389888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stinson)"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "209 - 479 CHARLTON AVENUE E, Hamilton (Stinson), Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.853404
1 => 43.245461
]
+"Latitude": 43.245461
+"Longitude": -79.853404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Where the love of nature and city living meet in perfect balance. This freshly painted, thoughtfully designed space offers an open-concept layout filled with natural light, a sleek modern kitchen, and a cozy living area that flows effortlessly into your private retreat with views of the trees. Perfect for young professionals, medical staff, or anyone who values comfort and convenience. What makes this location so special? 479 Charlton sits at the base of the Niagara Escarpment, giving you front-row access to the city's best hiking trails, waterfalls, and green spaces, all just steps from your door. Yet you're still minutes away from downtown Hamilton's cafés, shops, St. Joseph's Hospital, and vibrant arts scene, as well as the GO Station for commuters. It's the best of both worlds: urban energy paired with tranquil surroundings. Highlights you'll love: . Modern one-bedroom layout with contemporary finishes Bright, open living space with oversized windows . Easy access to trails, parks, and scenic lookout points Close to hospitals, restaurants, shops, and transit . Secure, well-maintained building in a highly desirable area. Comes with 1underground parking spot, and locker. Don't miss your chance to call this Hamilton gem your new home. (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
]
+"AssociationFee": "470.38"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T01:30:39.565073+00:00"
+"Directions": "Cross Streets: Charlton Ave E & Wentworth. ** Directions: Main Street to Wentworth to Charlton."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092232"
+"ListOfficeKey": "284773"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Wooded area"
1 => "Ravine"
2 => "Conservation/green belt"
3 => "Elevator"
4 => "Lighting"
5 => "Balcony"
6 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T01:12:56Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T01:12:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Charlton"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3488.33"
+"View": "Mountain view"
+"VirtualTourURLUnbranded": "https://youriguide.com/209_479_charlton_ave_e_hamilton_on/"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stinson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29248314/209-479-charlton-avenue-e-hamilton-stinson-stinson"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-14T01:12:55.99Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29248314')"
+"ID": "532527"
}
]
+success: true
+page_size: 9
+page_count: 65
+count: 585
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]