array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29948383 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1564774"
+post_author: 1
+"ListingKey": "29948383"
+"ListingId": "X13484774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:48:38Z"
+"ListPrice": 519999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Strathcona)"
+"PostalCode": "L8R2T4"
+"UnparsedAddress": "188 HESS STREET N, Hamilton (Strathcona), Ontario L8R2T4"
+"Coordinates": array:2 [
0 => -79.87434
1 => 43.265026
]
+"Latitude": 43.265026
+"Longitude": -79.87434
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 188 Hess Street North, a bright corner-unit home in Hamilton's sought-after Strathcona neighbourhood. This versatile property features 3+1 bedrooms and 2 bathrooms, makingit ideal for families, investors, or anyone looking for additional income potential.One of the standout features is the two separate living spaces, each with its own laundry facilities, offering convenience and privacy for occupants. The finished lower level includes a kitchen, bedroom, bathroom, living area, and dedicated laundry, creating a flexible setup for extended family or potential rental use.Step outside to the backyard, where you'll find a solid concrete shed with alley access andexciting future ADU potential, subject to city approvals. Located just minutes from down town Hamilton, GO Transit, and Highway 403, this property offers flexibility, convenience, and long-term value. Don't miss your chance to own this unique opportunity in one of Hamilton's growing neighbourhoods. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:11.171844+00:00"
+"Directions": "York Blvd and Hess St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252230"
+"ListOfficeKey": "293109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "28.6 x 105.5 FT ; 28.58 ft x 105.45 ft x 27.43 ft x43.60"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:06Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "Hess"
+"StreetNumber": "188"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3752"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1667101279"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 3.9
"ListingKey" => "29948383"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.16Z"
]
1 => array:11 [
"RoomKey" => "1667101280"
"RoomType" => "Other"
"ListingId" => "X13484774"
"RoomLevel" => "Basement"
"RoomWidth" => 2.11
"ListingKey" => "29948383"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
2 => array:11 [
"RoomKey" => "1667101281"
"RoomType" => "Bedroom"
"ListingId" => "X13484774"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "29948383"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
3 => array:11 [
"RoomKey" => "1667101282"
"RoomType" => "Bedroom 2"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29948383"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
4 => array:11 [
"RoomKey" => "1667101283"
"RoomType" => "Bedroom 3"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 2.25
"ListingKey" => "29948383"
"RoomLength" => 2.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
5 => array:11 [
"RoomKey" => "1667101284"
"RoomType" => "Kitchen"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29948383"
"RoomLength" => 4.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
6 => array:11 [
"RoomKey" => "1667101285"
"RoomType" => "Living room"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 4.5
"ListingKey" => "29948383"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
7 => array:11 [
"RoomKey" => "1667101286"
"RoomType" => "Bathroom"
"ListingId" => "X13484774"
"RoomLevel" => "Main level"
"RoomWidth" => 1.25
"ListingKey" => "29948383"
"RoomLength" => 2.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
8 => array:11 [
"RoomKey" => "1667101287"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13484774"
"RoomLevel" => "Basement"
"RoomWidth" => 2.7
"ListingKey" => "29948383"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
9 => array:11 [
"RoomKey" => "1667101288"
"RoomType" => "Kitchen"
"ListingId" => "X13484774"
"RoomLevel" => "Basement"
"RoomWidth" => 2.5
"ListingKey" => "29948383"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
10 => array:11 [
"RoomKey" => "1667101289"
"RoomType" => "Bedroom"
"ListingId" => "X13484774"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "29948383"
"RoomLength" => 5.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:06.17Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Strathcona"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948383/188-hess-street-n-hamilton-strathcona-strathcona"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2214392"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293109"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 28.7
+"OriginalEntryTimestamp": "2026-06-24T18:56:17.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1491160"
+"ListOfficeNationalAssociationId": "1422605"
+"CoListAgentNationalAssociationId": "1460126"
+"CoListOfficeNationalAssociationId": "1422605"
+"Media": array:13 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29948383_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/72f56927c9461cce62ef7f10ecaf1d13.webp"
"MediaSize" => 331793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-72f56927c9461cce62ef7f10ecaf1d13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29948383_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/2302977c2c8ea109b500a391f1d3f731.webp"
"MediaSize" => 140359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-2302977c2c8ea109b500a391f1d3f731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29948383_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/d47591bcd08d244bc31f96882153d210.webp"
"MediaSize" => 273516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-d47591bcd08d244bc31f96882153d210.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29948383_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/f5886738a6a2812f43db07c21e7a370f.webp"
"MediaSize" => 176183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-f5886738a6a2812f43db07c21e7a370f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29948383_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/613725f870d4095220e27dd214faa669.webp"
"MediaSize" => 225079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-613725f870d4095220e27dd214faa669.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29948383_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/741706fe131a25061a748333cc046291.webp"
"MediaSize" => 329870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-741706fe131a25061a748333cc046291.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29948383_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/89db6ffed009cf20fbd0e33b6e21168e.webp"
"MediaSize" => 157338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-89db6ffed009cf20fbd0e33b6e21168e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29948383_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/242324d40bf34440c46fdb8f5633287f.webp"
"MediaSize" => 158504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-242324d40bf34440c46fdb8f5633287f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29948383_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/a25d465a638c85a40277846d9f402e7f.webp"
"MediaSize" => 163459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-a25d465a638c85a40277846d9f402e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29948383_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/7658c835f675b2dfd5a091629b324b5c.webp"
"MediaSize" => 114222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-7658c835f675b2dfd5a091629b324b5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29948383_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/496a584cd5707984911c857448bc5377.webp"
"MediaSize" => 186910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-496a584cd5707984911c857448bc5377.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29948383_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/85f6a0791e9150e80fea70319b8fb3d6.webp"
"MediaSize" => 78696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-85f6a0791e9150e80fea70319b8fb3d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29948383_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948383/700c53b390a04174a29e42c27136173c.webp"
"MediaSize" => 85793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948383/thumbnail-700c53b390a04174a29e42c27136173c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484774"
"ResourceRecordKey" => "29948383"
"ModificationTimestamp" => "2026-06-24T18:56:17.4Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948383')"
+"ID": "1564774"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293109" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24775
+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 2252230" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24867
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24774
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2252230"
+"ModificationTimestamp": "2026-02-18T01:57:15Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2252230"
+"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('2252230')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29948383'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25146
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29948383'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25162
+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 '29948383' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.87434 43.265026)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25215
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1566960"
+post_author: 1
+"ListingKey": "29946415"
+"ListingId": "40842274"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:00:19Z"
+"RFModificationTimestamp": "2026-06-26T03:21:25Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 777.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P2C3"
+"UnparsedAddress": "90 CHARLTON Avenue W Unit# 502, Hamilton, Ontario L8P2C3"
+"Coordinates": array:2 [
0 => -79.8758512
1 => 43.2509009
]
+"Latitude": 43.2509009
+"Longitude": -79.8758512
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to City Square at 90 Charlton Avenue West! Ideally situated in the heart of the prestigious Durand North, this exceptional condominium offers an unbeatable location just steps from St. Joseph’s Hospital, vibrant James Street North, charming cafés, boutique shops along Locke Street, and only minutes from GO Transit. Enjoy the character and historic architecture that define the surrounding neighbourhood as you stroll or bike through one of Hamilton’s most sought-after communities. Perfect for commuters and professionals alike, this prime location provides convenient access both in and out of the city. This spacious and modern 777 sq. ft. corner suite features 9-foot ceilings and an open-concept layout designed for comfortable living and entertaining. The bright living area walks out to a large private balcony showcasing beautiful escarpment views. The unit is finished with contemporary touches throughout, including floor-to-ceiling glass walls in the bedroom, a stylish kitchen with a center island, stainless steel appliances, in-suite laundry, and an abundance of natural light. Residents enjoy an impressive selection of amenities, including a fitness center, large party room, meeting room, bicycle storage, owned locker, and underground parking space. Condo fees include heating, cooling, and water for added convenience. Whether you're a medical professional, business professional, or first-time home buyer, this beautifully appointed one-bedroom plus den suite offers an outstanding opportunity to own in a highly desirable location. A must-see! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "852.25"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:21:13.294525+00:00"
+"Directions": "CHARLTON WEST OF JAMES AND BAY STREET SOUTH"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524512"
+"ListOfficeKey": "283362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Shared Driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-24T14:52:55Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:52:55Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "CHARLTON"
+"StreetNumber": "90"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "122 - Durand North"
+"TaxAnnualAmount": "4725"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1666887683"
"RoomType" => "Den"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
1 => array:11 [
"RoomKey" => "1666887684"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
2 => array:11 [
"RoomKey" => "1666887685"
"RoomType" => "Laundry room"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
3 => array:11 [
"RoomKey" => "1666887686"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
4 => array:11 [
"RoomKey" => "1666887687"
"RoomType" => "Kitchen"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.8Z"
]
5 => array:11 [
"RoomKey" => "1666887688"
"RoomType" => "Living room"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946415/90-charlton-avenue-w-unit-502-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "Condo"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 777
+"OriginalEntryTimestamp": "2026-06-24T14:51:25.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1134819"
+"ListOfficeNationalAssociationId": "1328262"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946415_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3ff5b4584468c77af9ce296851017226.webp"
"MediaSize" => 144473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3ff5b4584468c77af9ce296851017226.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building featuring a stone and stucco facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946415_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7f5b1baa59908ead0903e13d8e10c868.webp"
"MediaSize" => 136999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7f5b1baa59908ead0903e13d8e10c868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a light-colored facade with contrasting stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946415_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/49e7003ea5c589effadb950d14a866b7.webp"
"MediaSize" => 136999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-49e7003ea5c589effadb950d14a866b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a light-colored facade with contrasting stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946415_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/5ee93ed9333280dbe4472ada30291911.webp"
"MediaSize" => 135001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-5ee93ed9333280dbe4472ada30291911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story building featuring stacked balconies and a stone facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946415_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/916b441c7939baa86e07e95d6d7eecf4.webp"
"MediaSize" => 61609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-916b441c7939baa86e07e95d6d7eecf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby area featuring large format floor tiles, a built-in fireplace with a stone-finish facade, recessed lighting, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946415_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/99b6fd07c11b19bfdcd5e1b1461710d7.webp"
"MediaSize" => 67351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-99b6fd07c11b19bfdcd5e1b1461710d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring large format tile flooring, a built-in fireplace with a stone mantel, a textured wall accent, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946415_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/88c0f6545bd6100e08d3cd12d1fb47fa.webp"
"MediaSize" => 66790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-88c0f6545bd6100e08d3cd12d1fb47fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.07Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946415_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/6020c465e26af0ba277d8b77f5a0eba8.webp"
"MediaSize" => 40404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-6020c465e26af0ba277d8b77f5a0eba8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry door featuring a peephole, chrome hardware, and panel detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946415_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/ad6f745433729cce4539531b7630c2ee.webp"
"MediaSize" => 39982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-ad6f745433729cce4539531b7630c2ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946415_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7ddab6092b93fe4b62ffdc194aa99b64.webp"
"MediaSize" => 42070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7ddab6092b93fe4b62ffdc194aa99b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub and shower combination featuring neutral-toned wall tiles, a wall-mounted showerhead, and a white porcelain toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.04Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946415_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/cfc8c89d0f1c409f76489bc9517ffc52.webp"
"MediaSize" => 30105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-cfc8c89d0f1c409f76489bc9517ffc52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a light wood-finish cabinet with brushed nickel pulls, a white oval sink, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.03Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29946415_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/d83a5c208140faa41525112f8eb962bc.webp"
"MediaSize" => 55335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-d83a5c208140faa41525112f8eb962bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring with a full-height window and neutral wall finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29946415_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7cfe0f3aeb392d9dbe6c832ab36d06e0.webp"
"MediaSize" => 38987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7cfe0f3aeb392d9dbe6c832ab36d06e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a built-in sliding door closet, recessed ceiling, light gray walls, and wood-finish flooring visible at the doorway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29946415_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3e31bc4db62a4555044a505a7afab12d.webp"
"MediaSize" => 37714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3e31bc4db62a4555044a505a7afab12d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom space featuring light gray walls and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29946415_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/49bc368fad8413870f543ab4731dff90.webp"
"MediaSize" => 65498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-49bc368fad8413870f543ab4731dff90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, light grey painted walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29946415_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/af9cae67a477457e4c0e65b73401d9f3.webp"
"MediaSize" => 68803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-af9cae67a477457e4c0e65b73401d9f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring and a full-height glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29946415_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/c9c4fb558c87cfe4341ef4f139939b58.webp"
"MediaSize" => 73599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-c9c4fb558c87cfe4341ef4f139939b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a dark-toned kitchen island with storage, multiple large windows, and a combination of recessed and pendant lighting fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29946415_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/502e00b57c2b7dbe6dcde60b2d0636e1.webp"
"MediaSize" => 54977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-502e00b57c2b7dbe6dcde60b2d0636e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette area with stainless steel refrigerator, dark wood-finish cabinetry, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29946415_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/8d75b957a922dcf8b35790a9d532d6f5.webp"
"MediaSize" => 69025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-8d75b957a922dcf8b35790a9d532d6f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring expansive floor-to-ceiling windows, wood-finish flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29946415_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/da076fa151e9c3941132fea15cc2e3fa.webp"
"MediaSize" => 68295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-da076fa151e9c3941132fea15cc2e3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, a kitchen with dark cabinetry and stainless steel appliances, a central island with an extended countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.04Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29946415_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/f3b7b2af20d6efcd8723c896dd1427da.webp"
"MediaSize" => 73721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-f3b7b2af20d6efcd8723c896dd1427da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a center island with a dark countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.71Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29946415_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/4f20f062c38f93b5bc6999364faa045f.webp"
"MediaSize" => 72063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-4f20f062c38f93b5bc6999364faa045f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a center island with a dark countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.65Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29946415_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/d54482e799f4f1812b2688f73ee1f5c3.webp"
"MediaSize" => 79083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-d54482e799f4f1812b2688f73ee1f5c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood-finish cabinetry, stainless steel appliances, and a tile floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.71Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29946415_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/56e642b11dd43ffa4318bba9506af937.webp"
"MediaSize" => 79535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-56e642b11dd43ffa4318bba9506af937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring dark wood-finish cabinetry, stainless steel appliances, a double basin sink with a gooseneck faucet, and a dark countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.65Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29946415_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/c04622e4364642d0a6571343e98b17d3.webp"
"MediaSize" => 34279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-c04622e4364642d0a6571343e98b17d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a stacked washer and dryer unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.05Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29946415_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/688ba5735167c823d833040678d79adb.webp"
"MediaSize" => 102416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-688ba5735167c823d833040678d79adb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious private balcony featuring a concrete floor, glass railings, and black metal handrails"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29946415_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3e07962f84c6faf2a15df0ed66629371.webp"
"MediaSize" => 125584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3e07962f84c6faf2a15df0ed66629371.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29946415_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/90d843eb79e88f8b56d1fbb3802ca77a.webp"
"MediaSize" => 115268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-90d843eb79e88f8b56d1fbb3802ca77a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony featuring a glass railing and metal frame, overlooking a multi-story building with multiple balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29946415_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/b61249a9322508736ca78381c3ed18c1.webp"
"MediaSize" => 102114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-b61249a9322508736ca78381c3ed18c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony railing with glass panels overlooking an urban landscape"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.08Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29946415_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/1e8c9029a915fa9eeac0a8e0ca25699a.webp"
"MediaSize" => 105181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-1e8c9029a915fa9eeac0a8e0ca25699a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private balcony featuring a concrete surface and a glass railing with dark metal posts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.06Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29946415_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/6a50006353d50e76d37efe0e2f647151.webp"
"MediaSize" => 85523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-6a50006353d50e76d37efe0e2f647151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring a full kitchen with dark cabinetry, an extended island with seating, large windows, recessed lighting, and patterned carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29946415_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/39c182daaa6194535c5f268f52ab34aa.webp"
"MediaSize" => 63398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-39c182daaa6194535c5f268f52ab34aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive kitchen island with seating for six, complemented by pendant lighting fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29946415_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7903a73dace9775a80bfaf99081c3d53.webp"
"MediaSize" => 98379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7903a73dace9775a80bfaf99081c3d53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark wood-finish cabinetry, light-toned countertops, a mosaic tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29946415_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/18e711d20410231f303a141b069d6b6f.webp"
"MediaSize" => 69947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-18e711d20410231f303a141b069d6b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious communal area featuring a large kitchen island with integrated stainless steel appliances, recessed lighting, and pendant fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29946415_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/8b84f1a32bed2bc3e47a76d93b8fe49c.webp"
"MediaSize" => 99889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-8b84f1a32bed2bc3e47a76d93b8fe49c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29946415_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/a7ca70a939ca36573912101ce9eefc78.webp"
"MediaSize" => 98569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-a7ca70a939ca36573912101ce9eefc78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated fitness center featuring rubber flooring and mirrored walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.66Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29946415_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/fd70e38be4b8314e39ff2d3e70a04ca6.webp"
"MediaSize" => 73982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-fd70e38be4b8314e39ff2d3e70a04ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated bike storage room featuring multiple rack systems, fluorescent lighting, a light gray floor, and white painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29946415_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/f79f22023c227546c3f72f9b6fc80442.webp"
"MediaSize" => 99007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-f79f22023c227546c3f72f9b6fc80442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated bike storage room featuring wall-mounted racks and ample floor space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29946415_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/9bb9c10059b430d5d9c4ebaa7dbc34e5.webp"
"MediaSize" => 65152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-9bb9c10059b430d5d9c4ebaa7dbc34e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Underground parking facility featuring concrete flooring and white support columns"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946415')"
+"ID": "1566960"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1566980"
+post_author: 1
+"ListingKey": "29946674"
+"ListingId": "40842631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:15Z"
+"RFModificationTimestamp": "2026-06-26T02:58:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.8609361
1 => 43.2685538
]
+"Latitude": 43.2685538
+"Longitude": -79.8609361
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:57:56.622055+00:00"
+"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738902"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:08Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "9087"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1666920280"
"RoomType" => "Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
1 => array:11 [
"RoomKey" => "1666920281"
"RoomType" => "Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
2 => array:11 [
"RoomKey" => "1666920283"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
3 => array:11 [
"RoomKey" => "1666920285"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
4 => array:11 [
"RoomKey" => "1666920287"
"RoomType" => "Laundry room"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 7'3''"
"RoomDescription" => null
…2
]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946674/414-john-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 3200
+"OriginalEntryTimestamp": "2026-06-24T15:32:08.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1179053"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946674')"
+"ID": "1566980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1566335"
+post_author: 1
+"ListingKey": "29946910"
+"ListingId": "X13483558"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:34:16Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P2C3"
+"UnparsedAddress": "502 - 90 CHARLTON AVENUE W, Hamilton (Durand), Ontario L8P2C3"
+"Coordinates": array:2 [
0 => -79.876087
1 => 43.250963
]
+"Latitude": 43.250963
+"Longitude": -79.876087
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to City Square at 90 Charlton Avenue West! Ideally situated in the heart of the prestigious Durand North, this exceptional condominium offers an unbeatable location just steps from St. Joseph's Hospital, vibrant James Street North, charming cafés, boutique shops along Locke Street, and only minutes from GO Transit. Enjoy the character and historic architecture that define the surrounding neighbourhood as you stroll or bike through one of Hamilton's most sought-after communities. Perfect for commuters and professionals alike, this prime location provides convenient access both in and out of the city. This spacious and modern 777 sq. ft. corner suite features 9-foot ceilings and an open-concept layout designed for comfortable living and entertaining. The bright living area walks out to a large private balcony showcasing beautiful escarpment views. The unit is finished with contemporary touches throughout, including floor-to-ceiling glass walls in the bedroom, a stylish kitchen with a center island, stainless steel appliances, in-suite laundry, and an abundance of natural light. Residents enjoy an impressive selection of amenities, including a fitness center, large party room, meeting room, bicycle storage, owned locker, and underground parking space. Condo fees include heating, cooling, and water for added convenience. Whether you're a medical professional, business professional, or first-time home buyer, this beautifully appointed one-bedroom plus den suite offers an outstanding opportunity to own in a highly desirable location. A must-see! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "852.25"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:32:59.986605+00:00"
+"Directions": "Cross Streets: Charlton Ave W & Bay St S. ** Directions: CHARLTON WEST OF JAMES AND BAY STREET SOUTH."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139632"
+"ListOfficeKey": "283372"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:45Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:45Z"
+"StreetDirSuffix": "West"
+"StreetName": "Charlton"
+"StreetNumber": "90"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4725"
+"View": "City view"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Durand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946910/502-90-charlton-avenue-w-hamilton-durand-durand"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "E/S-1600a"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-24T15:58:53.14Z"
+"ListAgentNationalAssociationId": "1391439"
+"ListOfficeNationalAssociationId": "1328417"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946910')"
+"ID": "1566335"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1566342"
+post_author: 1
+"ListingKey": "29947057"
+"ListingId": "X13483750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:33:22Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN STREET, Hamilton (North End), Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.860699
1 => 43.268509
]
+"Latitude": 43.268509
+"Longitude": -79.860699
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton's premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater - Tankless"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:31:57.326242+00:00"
+"Directions": "Cross Streets: FERRIE ST. ** Directions: John St N, between Ferrie and Picton."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240345"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level"
1 => "Carpet Free"
]
+"LotSizeDimensions": "27.6 x 106.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:48Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9087"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/414-john-st-n-hamilton-on-l8l-4r3-22876084/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "North End"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29947057/414-john-street-hamilton-north-end-north-end"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.7
+"OriginalEntryTimestamp": "2026-06-24T16:17:48.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1478315"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947057')"
+"ID": "1566342"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1563999"
+post_author: 1
+"ListingKey": "29954924"
+"ListingId": "40842610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:40:04Z"
+"ListPrice": 719900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2J6"
+"UnparsedAddress": "135 CATHARINE Street S, Hamilton, Ontario L8N2J6"
+"Coordinates": array:2 [
0 => -79.8669616
1 => 43.2510787
]
+"Latitude": 43.2510787
+"Longitude": -79.8669616
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully enhanced 4 bdrm, 1.5 bath, 2.5-stry Victorian brick residence offering an exceptional blend of historic character and modern updates in one of Hamilton's most walkable urban neighbourhoods. Situated in the heart of the Corktown neighbourhood w/ surfaced parking for 1 vehicle on an attractive interlock driveway, this stunning home showcases exposed brick, soaring ceilings, hardwood flrs, upgraded lighting, & thoughtfully preserved architectural details throughout. The main lvl feat a welcoming foyer w/ a transom window, an inviting liv rm w/ a natural gas FP, custom built-ins, & a beautiful front bay window. A stunning ornamental archway w/ decorative fretwork connects the liv & din rms, while extensive wall mouldings add elegance to the formal dining space. The updated kitchen offers custom cabinetry, exposed brick, quality appliances, and a versatile built-in enclosure currently used as a dog retreat that could easily function as a desk or additional storage. A stylish powder room completes the level. The second floor offers 3 bedrooms and an updated 4-piece bathroom featuring a clawfoot tub. The spacious primary bedroom includes a front bay window and bonus dressing area. The finished third floor provides incredible flexibility as a 4th bedroom, office, studio, recreation room, or family retreat, with impressive ceiling height and abundant character. Outdoor features include a multi-level deck, terrace area, mature landscaping, detached storage shed, and a private backyard setting ideal for entertaining. Notable updates include furnace ('14), central air ('14), windows ('16), electrical panel ('23), wiring ('23), roof shingles ('26), and refrigerator, stove, washer & dryer ('25). Ideally located near downtown Hamilton, GO Transit, St. Joseph's Hospital, trail systems, restaurants, cafés, parks, shopping, and major commuter routes. A rare opportunity to own a beautifully updated character home in one of the city's most vibrant neighbourhoods. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:39:56.370040+00:00"
+"Directions": "From John S/Augusta, E on Augusta, S on Catharine S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1900653"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T21:11:01Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:11:01Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "CATHARINE"
+"StreetNumber": "135"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "4177.82"
+"VirtualTourURLUnbranded": "https://youtu.be/vnsVvAhr_7E"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954924/135-catharine-street-s-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1793
+"OriginalEntryTimestamp": "2026-06-25T21:11:01.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1217131"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954924')"
+"ID": "1563999"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1564000"
+post_author: 1
+"ListingKey": "29954372"
+"ListingId": "X13490436"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:30:12Z"
+"RFModificationTimestamp": "2026-06-25T23:30:27Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Strathcona)"
+"PostalCode": "L8P4C8"
+"UnparsedAddress": "21 - 36 MARGARET STREET, Hamilton (Strathcona), Ontario L8P4C8"
+"Coordinates": array:2 [
0 => -79.8852998
1 => 43.2602438
]
+"Latitude": 43.2602438
+"Longitude": -79.8852998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome home at the Margaret Street Lofts in the beloved Strathcona neighbourhood! This inviting 2nd floor 1-bedroom + den loft is located in a beautifully converted factory building, offering authentic character and a warm, homey feel. Soaring 12+ ft ceilings, exposed brick walls, large windows, carpet-free unit and a desirable north-east corner exposure creates a bright yet cozy home to relax in, entertain, cook, or work from home. The open-concept layout features a kitchen with new stainless steel appliances, refinished cabinetry, and a 3-seat island, flowing into a dining area large enough for a full-sized dining set. A unique loft-style den is perfect as a home office, reading nook, kids' play area, creative retreat or storage. Enjoy the comfort and convenience of a gas fireplace, in-suite laundry, room for full-sized furniture, oversized closets, a storage locker, and one surface parking space. Walk to Victoria Park, Locke Street's popular shops and restaurants, Fortinos, and downtown Hamilton. Quiet, welcoming, and full of character, this loft (1 of only 14 units) is ideal for young professionals, small families, down sizers, or savvy investors seeking something truly special. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "880"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:30:21.018768+00:00"
+"Directions": "Cross Streets: Main St W. ** Directions: Main St W to Margaret."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093102"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Rolling"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:14Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:21:58Z"
+"StreetName": "Margaret"
+"StreetNumber": "36"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4157.82"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/ekpgvpnm/unbranded"
+"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": "Strathcona"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954372/21-36-margaret-street-hamilton-strathcona-strathcona"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Lion heart Property Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "D/S-1402a"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-25T19:50:14.23Z"
+"ListAgentNationalAssociationId": "1365580"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954372')"
+"ID": "1564000"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1566025"
+post_author: 1
+"ListingKey": "29955284"
+"ListingId": "X13491158"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:55:04Z"
+"RFModificationTimestamp": "2026-06-25T23:08:29Z"
+"ListPrice": 719900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Corktown)"
+"PostalCode": "L8N2J6"
+"UnparsedAddress": "135 CATHARINE STREET S, Hamilton (Corktown), Ontario L8N2J6"
+"Coordinates": array:2 [
0 => -79.866908
1 => 43.251034
]
+"Latitude": 43.251034
+"Longitude": -79.866908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully enhanced 4 bdrm, 1.5 bath, 2.5-stry Victorian brick residence offering an exceptional blend of historic character and modern updates in one of Hamilton's most walkable urban neighbourhoods. Situated in the heart of the Corktown neighbourhood w/ surfaced parking for 1 vehicle on an attractive interlock driveway, this stunning home showcases exposed brick, soaring ceilings, hardwood flrs, upgraded lighting, & thoughtfully preserved architectural details throughout. The main lvl feat a welcoming foyer w/ a transom window, an inviting liv rm w/ a natural gas FP, custom built-ins, & a beautiful front bay window. A stunning ornamental archway w/ decorative fretwork connects the liv & din rms, while extensive wall mouldings add elegance to the formal dining space. The updated kitchen offers custom cabinetry, exposed brick, quality appliances, and a versatile built-in enclosure currently used as a dog retreat that could easily function as a desk or additional storage. A stylish powder room completes the level. The second floor offers 3 bedrooms and an updated 4-piece bathroom featuring a clawfoot tub. The spacious primary bedroom includes a front bay window and bonus dressing area. The finished third floor provides incredible flexibility as a 4th bedroom, office, studio, recreation room, or family retreat, with impressive ceiling height and abundant character. Outdoor features include a multi-level deck, terrace area, mature landscaping, detached storage shed, and a private backyard setting ideal for entertaining. Notable updates include furnace ('14), central air ('14), windows ('16), electrical panel ('23), wiring ('23), roof shingles ('26), and refrigerator, stove, washer & dryer ('25). Ideally located near downtown Hamilton, GO Transit, St. Joseph's Hospital, trail systems, restaurants, cafés, parks, shopping, and major commuter routes. A rare opportunity to own a beautifully updated character home in one of the city's most vibrant neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:03:13.498036+00:00"
+"Directions": "Cross Streets: Augusta Street. ** Directions: From John S/Augusta, E on Augusta, S on Catharine S."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093000"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.7 x 83 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:47:48Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:47:48Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Catharine"
+"StreetNumber": "135"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4177.82"
+"VirtualTourURLUnbranded": "https://youtu.be/vnsVvAhr_7Ehttps://youtu.be/vnsVvAhr_7E"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Corktown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29955284/135-catharine-street-s-hamilton-corktown-corktown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-25T21:47:48.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365456"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955284')"
+"ID": "1566025"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1567618"
+post_author: 1
+"ListingKey": "29949468"
+"ListingId": "X13485918"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T23:20:12Z"
+"RFModificationTimestamp": "2026-06-25T23:08:03Z"
+"ListPrice": 449999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Central)"
+"PostalCode": "L8P0C6"
+"UnparsedAddress": "1909 - 15 QUEEN STREET S, Hamilton (Central), Ontario L8P0C6"
+"Coordinates": array:2 [
0 => -79.881744
1 => 43.251956
]
+"Latitude": 43.251956
+"Longitude": -79.881744
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience upscale living on the 19th floor at Platinum, a standout building in downtown Hamilton. This Paris suite features 02 bedrooms, 02 bathrooms, and a balcony, offering a blend of elegance and functionality with quartz countertops, wood laminate flooring, and 9-foot ceilings. The open layout maximizes light, ideal for entertaining and relaxation. The kitchen includes ample cabinetry, stainless steel appliances, quartz counters, and an island seating four, leading to a spacious living room with a balcony. The primary bedroom boasts a luxurious ensuite with a large shower, while the second bedroom has ample closet space near a full bathroom. Located in the bustling downtown area, you are just steps from pubs, cafes, restaurants, and essential services, as well as the Hamilton GO Centre and the upcoming LRT. The location is also minutes from McMaster University, Mohawk College, St. Josephs Health Centre, and the 403 highway. (id:62783)"
+"Appliances": array:1 [
0 => "Oven - Built-In"
]
+"AssociationFee": "443.22"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:01:36.948218+00:00"
+"Directions": "Cross Streets: Queen St S. ** Directions: Queen St S & King St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1500350"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:53:10Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T23:13:05Z"
+"StreetDirPrefix": "South"
+"StreetDirSuffix": "South"
+"StreetName": "Queen"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3922.49"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Central"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949468/1909-15-queen-street-s-hamilton-central-central"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "North Star Management Inc"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-24T21:53:10.68Z"
+"ListAgentNationalAssociationId": "1135499"
+"ListOfficeNationalAssociationId": "1316438"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949468')"
+"ID": "1567618"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1563424"
+post_author: 1
+"ListingKey": "29950227"
+"ListingId": "X13486450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T00:50:06Z"
+"RFModificationTimestamp": "2026-06-25T22:32:58Z"
+"ListPrice": 319000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Beasley)"
+"PostalCode": "L6R0A7"
+"UnparsedAddress": "608 - 212 KING WILLIAM STREET, Hamilton (Beasley), Ontario L6R0A7"
+"Coordinates": array:2 [
0 => -79.860814
1 => 43.255095
]
+"Latitude": 43.255095
+"Longitude": -79.860814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Almost brand new unit in a modern building featuring outstanding amenities, including a rooftop BBQ area, party room, TV lounge, and fully equipped gym. Conveniently located within walking distance to downtown Hamilton, shopping, restaurants, public transit, and everyday amenities. Close to the police station and offering easy access to everything the city has to offer. A great opportunity for comfortable urban living. (id:62650)"
+"AssociationFee": "371.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:32:44.903458+00:00"
+"Directions": "King William And Ferguson Ave"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2142481"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T00:44:12Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T00:44:12Z"
+"StreetName": "King William"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3659.5"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Beasley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950227/608-212-king-william-street-hamilton-beasley-beasley"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-25T00:44:12.27Z"
+"ListAgentNationalAssociationId": "1394210"
+"ListOfficeNationalAssociationId": "1254684"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950227')"
+"ID": "1563424"
}
]
+success: true
+page_size: 9
+page_count: 46
+count: 412
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]