array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29950227 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: "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 [
"RoomKey" => "1667338721"
"RoomType" => "Living room"
"ListingId" => "X13486450"
"RoomLevel" => "Main level"
"RoomWidth" => 3.74
"ListingKey" => "29950227"
"RoomLength" => 3.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T00:44:12.3Z"
]
1 => array:11 [
"RoomKey" => "1667338722"
"RoomType" => "Kitchen"
"ListingId" => "X13486450"
"RoomLevel" => "Main level"
"RoomWidth" => 3.57
"ListingKey" => "29950227"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T00:44:12.3Z"
]
2 => array:11 [
"RoomKey" => "1667338723"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13486450"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29950227"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T00:44:12.3Z"
]
3 => array:11 [
"RoomKey" => "1667338724"
"RoomType" => "Bathroom"
"ListingId" => "X13486450"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29950227"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T00:44:12.3Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29950227_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/cb03071eee3cedd594e4a19932115ce5.webp"
"MediaSize" => 425739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-cb03071eee3cedd594e4a19932115ce5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29950227_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/f07a8418b0b6210de5897b14fb2aa9ef.webp"
"MediaSize" => 128784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-f07a8418b0b6210de5897b14fb2aa9ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29950227_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/cee9c125b8897398201aa2bf21a638ea.webp"
"MediaSize" => 113606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-cee9c125b8897398201aa2bf21a638ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29950227_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/2aba41f8ae5fa271673474dc0a44e6a7.webp"
"MediaSize" => 197999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-2aba41f8ae5fa271673474dc0a44e6a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29950227_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/ba37872e1f7fb8ae30ad0cb7fa0df2f0.webp"
"MediaSize" => 169821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-ba37872e1f7fb8ae30ad0cb7fa0df2f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29950227_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/195a62f56b3b51e0bdda7b05af9f1ae8.webp"
"MediaSize" => 133545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-195a62f56b3b51e0bdda7b05af9f1ae8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29950227_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/43b9fa48289b515f34ffaa86bad763d6.webp"
"MediaSize" => 92260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-43b9fa48289b515f34ffaa86bad763d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29950227_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/0f0568d39183449e9598f7e43d955fca.webp"
"MediaSize" => 113966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-0f0568d39183449e9598f7e43d955fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29950227_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/969d96a4ccbfcb7f0804bd26799fb74d.webp"
"MediaSize" => 115282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-969d96a4ccbfcb7f0804bd26799fb74d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29950227_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/ab7d8e72e5eeb2339ad32b6cf8297c29.webp"
"MediaSize" => 100662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-ab7d8e72e5eeb2339ad32b6cf8297c29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29950227_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/57afe83950345a807e838ffa5fceeaec.webp"
"MediaSize" => 95586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-57afe83950345a807e838ffa5fceeaec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29950227_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/d2c46a0710a00abd22c87561e9af7af2.webp"
"MediaSize" => 161831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-d2c46a0710a00abd22c87561e9af7af2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29950227_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/90a4893bb17bb8d5b386130a0ba9ea0c.webp"
"MediaSize" => 158159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-90a4893bb17bb8d5b386130a0ba9ea0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29950227_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/a1194257af353e13df23084823b83885.webp"
"MediaSize" => 162070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-a1194257af353e13df23084823b83885.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29950227_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/508b6e61e3a5db3de4f70d90dab7fe90.webp"
"MediaSize" => 160378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-508b6e61e3a5db3de4f70d90dab7fe90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29950227_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/2075be1365a1819291bfd0f105b52111.webp"
"MediaSize" => 152649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-2075be1365a1819291bfd0f105b52111.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29950227_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/56dc8ead0f24a586bcbbe2ca6e6c8785.webp"
"MediaSize" => 202762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-56dc8ead0f24a586bcbbe2ca6e6c8785.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29950227_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/5797615d4b6d007389ad5b2f47d01d0f.webp"
"MediaSize" => 201046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-5797615d4b6d007389ad5b2f47d01d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29950227_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/d6d84d31f5a3128312fc3e7d1a6e518c.webp"
"MediaSize" => 153070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-d6d84d31f5a3128312fc3e7d1a6e518c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29950227_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/1024891f041905112cf999e622fc24ea.webp"
"MediaSize" => 230153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-1024891f041905112cf999e622fc24ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29950227_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/9278aaaf7745fb9756e641a9ee1e44ed.webp"
"MediaSize" => 216856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-9278aaaf7745fb9756e641a9ee1e44ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29950227_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/a1a6cadeb8b2d123a11ef0cf3211c880.webp"
"MediaSize" => 158865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-a1a6cadeb8b2d123a11ef0cf3211c880.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29950227_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/b08be641b46d6fb933487aadf0147b35.webp"
"MediaSize" => 147239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-b08be641b46d6fb933487aadf0147b35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29950227_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/96c5511dac4214e918d12faf6af20d27.webp"
"MediaSize" => 146102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-96c5511dac4214e918d12faf6af20d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29950227_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/11cf7cbbdb3a503ad427bf42e69675b9.webp"
"MediaSize" => 284372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-11cf7cbbdb3a503ad427bf42e69675b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29950227_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/13557d3d852c017f096b9311faa8ef1b.webp"
"MediaSize" => 202248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-13557d3d852c017f096b9311faa8ef1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29950227_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/eeb74b6ca0931ea33c948410440dd04c.webp"
"MediaSize" => 188706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-eeb74b6ca0931ea33c948410440dd04c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29950227_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/c02269ea1d14fb96b8fa0999fc3162aa.webp"
"MediaSize" => 125996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-c02269ea1d14fb96b8fa0999fc3162aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29950227_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/6dbd58c215c2592a1d0e62fc524d9297.webp"
"MediaSize" => 137070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-6dbd58c215c2592a1d0e62fc524d9297.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29950227_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/17853c86933006f3c46d182390f06fe8.webp"
"MediaSize" => 114605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-17853c86933006f3c46d182390f06fe8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29950227_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/adcddb4d0dc0e12db00a68bd1f811840.webp"
"MediaSize" => 117472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-adcddb4d0dc0e12db00a68bd1f811840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29950227_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/243a29df6724a25b04bdb613e0724e0c.webp"
"MediaSize" => 295460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-243a29df6724a25b04bdb613e0724e0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29950227_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/129d332de1e491e94305b168d2ff6354.webp"
"MediaSize" => 344273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-129d332de1e491e94305b168d2ff6354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29950227_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/dcebbe50d68743536c4072cc2032396c.webp"
"MediaSize" => 213977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-dcebbe50d68743536c4072cc2032396c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29950227_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/5cbf5a8593c4fad4998748eb56b70452.webp"
"MediaSize" => 281354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-5cbf5a8593c4fad4998748eb56b70452.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29950227_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/66b98e50a8945a5e22608e2895248053.webp"
"MediaSize" => 247289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-66b98e50a8945a5e22608e2895248053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29950227_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/0a5813c62d12b84427da1fc8870fcd2e.webp"
"MediaSize" => 321805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-0a5813c62d12b84427da1fc8870fcd2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29950227_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/a81da71719b4bab2a41f1fbda80427f0.webp"
"MediaSize" => 130967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-a81da71719b4bab2a41f1fbda80427f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29950227_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/c2698d6dc8da1a327560d733ac46c693.webp"
"MediaSize" => 237361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-c2698d6dc8da1a327560d733ac46c693.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29950227_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/b5d70467b1440f593528abb68f52a9b8.webp"
"MediaSize" => 166897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-b5d70467b1440f593528abb68f52a9b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29950227_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/ff4b6b7017f13678d1c4afd8e80802b4.webp"
"MediaSize" => 255387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-ff4b6b7017f13678d1c4afd8e80802b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29950227_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/70ea73f5ae4c9b75e59cf29ada0935af.webp"
"MediaSize" => 248536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-70ea73f5ae4c9b75e59cf29ada0935af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29950227_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/d68255846c0185446933397d7ce5b556.webp"
"MediaSize" => 207643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-d68255846c0185446933397d7ce5b556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29950227_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/9043ab762b999f900c521255861e8608.webp"
"MediaSize" => 317651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-9043ab762b999f900c521255861e8608.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29950227_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/1cd65a01dd18c18dcda14f2f66475541.webp"
"MediaSize" => 97997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-1cd65a01dd18c18dcda14f2f66475541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29950227_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/8feda90881fd810bdbfb4cb421fcf558.webp"
"MediaSize" => 115282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-8feda90881fd810bdbfb4cb421fcf558.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29950227_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/5ef90e14b7efc1df1cd38d2204c1ea23.webp"
"MediaSize" => 113966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-5ef90e14b7efc1df1cd38d2204c1ea23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29950227_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/3dcf81b48de456d00997140ded8fe608.webp"
"MediaSize" => 169821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-3dcf81b48de456d00997140ded8fe608.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29950227_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/2de5a2c4e74f25dd209417dde41dcff7.webp"
"MediaSize" => 113606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-2de5a2c4e74f25dd209417dde41dcff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29950227_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950227/41baee51a983afa70658f1dc00e5dc3a.webp"
"MediaSize" => 128784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950227/thumbnail-41baee51a983afa70658f1dc00e5dc3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13486450"
"ResourceRecordKey" => "29950227"
"ModificationTimestamp" => "2026-06-25T00:44:12.28Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950227')"
+"ID": "1563424"
}
]
+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 274354" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24848
+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 2142481" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24847
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29950227'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25255
+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 '29950227'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29950227' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.860814 43.255095)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25344
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+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"
…5
]
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('29946415')"
+"ID": "1566960"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1566980"
+post_author: 1
+"ListingKey": "29946674"
+"ListingId": "40842631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:15Z"
+"RFModificationTimestamp": "2026-06-26T02:58:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.8609361
1 => 43.2685538
]
+"Latitude": 43.2685538
+"Longitude": -79.8609361
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:57:56.622055+00:00"
+"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738902"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:08Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "9087"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946674/414-john-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 3200
+"OriginalEntryTimestamp": "2026-06-24T15:32:08.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1179053"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946674')"
+"ID": "1566980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+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 {#25341
+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 {#25339
+post_id: "1566053"
+post_author: 1
+"ListingKey": "29947138"
+"ListingId": "40842598"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:40:12Z"
+"RFModificationTimestamp": "2026-06-26T02:24:39Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1238.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6L9"
+"UnparsedAddress": "35 SHERMAN Avenue N, Hamilton, Ontario L8L6L9"
+"Coordinates": array:2 [
0 => -79.8380841
1 => 43.252454
]
+"Latitude": 43.252454
+"Longitude": -79.8380841
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the charm of this solid brick 2.5 brick home built in 1911, brimming with character and ready for your personal touch. The enclosed front porch features a warm welcome and showcases the home's timeless appeal. Inside, you'll find a spacious layout with generous bedrooms on the second floor and a bright 4-piece bathroom. The third floor adds two additional bedrooms, perfect for guests, a home office, or creative space. The kitchen opens to a private backyard, providing the ideal setting for future gardens or outdoor entertaining. A separate side entrance leads to the unfinished basement, which includes an existing bathroom-offering excellent potential for additional living space. ich in history and full of opportunity, this home is waiting for someone with vision to restore its original beauty and make it shine once again (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:23:46.069204+00:00"
+"Directions": "Wilson St N on Sherman Ave N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803927"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-24T16:32:47Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:32:46Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "35"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "210 - North Sherman"
+"TaxAnnualAmount": "2590.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947138/35-sherman-avenue-n-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1238
+"OriginalEntryTimestamp": "2026-06-24T16:32:46.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1190947"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947138')"
+"ID": "1566053"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1565833"
+post_author: 1
+"ListingKey": "29955723"
+"ListingId": "40843253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:10:29Z"
+"RFModificationTimestamp": "2026-06-26T01:50:25Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2886.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2P8"
+"UnparsedAddress": "103 SHERMAN Avenue S, Hamilton, Ontario L8M2P8"
+"Coordinates": array:2 [
0 => -79.8393806
1 => 43.2481979
]
+"Latitude": 43.2481979
+"Longitude": -79.8393806
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Victorian residence seamlessly blends timeless character with modern upgrades, offering over 3,000 sq ft of beautifully finished living space. Featuring 6 bedrooms, 2 kitchens, 3 bathrooms, and multiple private entrances, this property is ideal for large families, multi-generational living, or savvy investors. The fully renovated main floor kitchen is a true showpiece-bright and modern with crisp white cabinetry, stainless steel appliances & gas range. Original architectural details add warmth and charm throughout, including hardwood floors, pocket doors, leaded glass windows, natural slate, Carrera marble countertops and vaulted ceilings. Step outside to a low maintenance backyard filled with perennials. A rare opportunity to own a truly stately home. Parking for up to 5 cars. Excellent location close to all amenities and bus route. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:50:14.363178+00:00"
+"Directions": "Main St E & North on Sherman Ave S"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976293"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T23:02:07Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:02:07Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "SHERMAN"
+"StreetNumber": "103"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "11336.99"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29955723/103-sherman-avenue-s-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2886
+"OriginalEntryTimestamp": "2026-06-25T23:02:07.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1262753"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955723')"
+"ID": "1565833"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "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 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948383')"
+"ID": "1564774"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1564213"
+post_author: 1
+"ListingKey": "29954993"
+"ListingId": "X13490992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:30:12Z"
+"RFModificationTimestamp": "2026-06-25T23:29:17Z"
+"ListPrice": 649850.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (St. Clair)"
+"PostalCode": "L8M2P9"
+"UnparsedAddress": "172 SHERMAN AVENUE S, Hamilton (St. Clair), Ontario L8M2P9"
+"Coordinates": array:2 [
0 => -79.8405998
1 => 43.2462506
]
+"Latitude": 43.2462506
+"Longitude": -79.8405998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Sherman Avenue South, a spacious and beautifully updated 2.5-storey brick home in Hamilton's sought-after St. Clairneighbourhood. Surrounded by charming character homes and just minutes from Gage Park, the Bernie Morelli Recreation Centre, schools,shopping, downtown amenities and major highway access, this home offers the perfect blend of location, space and flexibility. Step inside to abright and inviting main floor featuring a generous foyer, formal living room with decorative fireplace, separate dining room and an open-concepteat-in kitchen designed for everyday living and easy entertaining. A covered rear porch/mudroom provides convenient access to the backyardand adds practical storage space. The second level offers three well-sized bedrooms with ample closet space, along with a beautifully updatedthree-piece bathroom featuring an oversized walk-in shower. The third level extends the living space even further with two additional bedroomsand a second three-piece bathroom, making it ideal for a growing family, guest accommodations, a teen retreat, playroom or home office setup.Outside, enjoy a private rear yard, shared side driveway and detached garage. Notable updates include electrical and plumbing improvements,select window replacements, roof stripped and re-shingled in 2021, soffits, eaves and downspouts in 2021, new gas boiler in 2023, owned hotwater heater in 2023 and new flooring throughout. With five bedrooms, multiple living areas and thoughtful updates throughout, this St. Clairhome delivers exceptional space, character and versatility in one of Hamilton's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-25T23:29:07.559095+00:00"
+"Directions": "Cross Streets: Main St E. ** Directions: Sherman Av S at Maplewood Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Block"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2166044"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "26.7 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:21:59Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:21:59Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Sherman"
+"StreetNumber": "172"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4242"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/358249"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "St. Clair"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954993/172-sherman-avenue-s-hamilton-st-clair-st-clair"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 26.8
+"OriginalEntryTimestamp": "2026-06-25T21:21:59.29Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1416991"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954993')"
+"ID": "1564213"
}
]
+success: true
+page_size: 9
+page_count: 64
+count: 574
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]