array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29958971 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1570206"
+post_author: 1
+"ListingKey": "29958971"
+"ListingId": "40843378"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:40:34Z"
+"RFModificationTimestamp": "2026-06-26T18:46:10Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 952.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N4E7"
+"UnparsedAddress": "175 E HUNTER Street E Unit# 401, Hamilton, Ontario L8N4E7"
+"Coordinates": array:2 [
0 => -79.8633465
1 => 43.2521124
]
+"Latitude": 43.2521124
+"Longitude": -79.8633465
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and spacious corner-unit condo in Hamilton's Corktown neighbourhood. This two-bedroom, one-bath suite is one of the larger units in the building and offers a functional layout with good natural light. Walk-in closet in the primary bedroom. Located steps from the James Street GO Station and downtown, providing convenient access for commuting. Includes one underground parking space and one storage locker. Condo fees cover Bell high-speed internet, cable TV, and an HBO Crave subscription. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "836.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-26T18:46:05.252839+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078559"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-26T17:31:13Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:31:13Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "HUNTER"
+"StreetNumber": "175"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "2339"
+"VirtualTourURLUnbranded": "https://youriguide.com/401_175_hunter_st_e_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1668686792"
"RoomType" => "Utility room"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "3'8'' x 2'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.89Z"
]
1 => array:11 [
"RoomKey" => "1668686793"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.89Z"
]
2 => array:11 [
"RoomKey" => "1668686794"
"RoomType" => "Living room"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
3 => array:11 [
"RoomKey" => "1668686795"
"RoomType" => "Kitchen"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
4 => array:11 [
"RoomKey" => "1668686796"
"RoomType" => "Foyer"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
5 => array:11 [
"RoomKey" => "1668686797"
"RoomType" => "Dining room"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
6 => array:11 [
"RoomKey" => "1668686798"
"RoomType" => "Bedroom"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
7 => array:11 [
"RoomKey" => "1668686799"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843378"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29958971"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:31:13.9Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29958971/175-e-hunter-street-e-unit-401-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "E3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 952
+"OriginalEntryTimestamp": "2026-06-26T17:31:13.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1353398"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29958971_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/3f5b40afd167fc1f453ca4f4539c4e7a.webp"
"MediaSize" => 132073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-3f5b40afd167fc1f453ca4f4539c4e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story building featuring multiple balconies, numerous windows, and exterior lighting"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29958971_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/bea239ddc4366db368e814f94440a440.webp"
"MediaSize" => 208616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-bea239ddc4366db368e814f94440a440.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Paved driveway entrance with mature trees and landscaped garden beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29958971_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/05316ce884c4c6d96b4c530782d0b09a.webp"
"MediaSize" => 87495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-05316ce884c4c6d96b4c530782d0b09a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting lobby area featuring a stone accent wall, decorative fireplace with white mantel, recessed lighting, and a glass-paneled entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29958971_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/f7acf346d43dd6fa9857b46c3c832885.webp"
"MediaSize" => 78986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-f7acf346d43dd6fa9857b46c3c832885.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring two elevators with green tile surrounds, flush-mounted lighting, white walls, and pink carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29958971_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/b9ab216e742e62b91cefc62372e984d5.webp"
"MediaSize" => 49630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-b9ab216e742e62b91cefc62372e984d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29958971_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/21cd48cd9ae2e0897b2e7c1affddd9df.webp"
"MediaSize" => 48705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-21cd48cd9ae2e0897b2e7c1affddd9df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29958971_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/048d2f266ebd509a914bea77edaee693.webp"
"MediaSize" => 38477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-048d2f266ebd509a914bea77edaee693.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior featuring light wood-finish flooring, white painted walls, and an acoustic ceiling finish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29958971_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/03ac2be701ddc3ee76f5a49df5795960.webp"
"MediaSize" => 48044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-03ac2be701ddc3ee76f5a49df5795960.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring light wood-finish flooring, white walls, and multiple windows with white drapery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29958971_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/502bf431c205a1cc1aa77492fa78aee2.webp"
"MediaSize" => 51077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-502bf431c205a1cc1aa77492fa78aee2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring wood-finish flooring, white walls, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29958971_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/073979a3a2d03a4220bf28c3fef26173.webp"
"MediaSize" => 81244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-073979a3a2d03a4220bf28c3fef26173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring light wood-finish flooring, white wall finishes, and abundant natural light from multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29958971_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/7a4a1105a1603ddd124a3708ac746eaf.webp"
"MediaSize" => 36320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-7a4a1105a1603ddd124a3708ac746eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring light wood-finish flooring, white walls, and a large window with sheer white curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29958971_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29958971/1a0979cca53c3bd15054ab3e53e6a63b.webp"
"MediaSize" => 36748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29958971/thumbnail-1a0979cca53c3bd15054ab3e53e6a63b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843378"
"ResourceRecordKey" => "29958971"
"ModificationTimestamp" => "2026-06-26T17:31:13.86Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958971')"
+"ID": "1570206"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285135" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24816
+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 2078559" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24819
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29958971'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25183
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29958971'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25199
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29958971' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8633465 43.2521124)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25252
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1566960"
+post_author: 1
+"ListingKey": "29946415"
+"ListingId": "40842274"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:00:19Z"
+"RFModificationTimestamp": "2026-06-26T03:21:25Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 777.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P2C3"
+"UnparsedAddress": "90 CHARLTON Avenue W Unit# 502, Hamilton, Ontario L8P2C3"
+"Coordinates": array:2 [
0 => -79.8758512
1 => 43.2509009
]
+"Latitude": 43.2509009
+"Longitude": -79.8758512
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to City Square at 90 Charlton Avenue West! Ideally situated in the heart of the prestigious Durand North, this exceptional condominium offers an unbeatable location just steps from St. Joseph’s Hospital, vibrant James Street North, charming cafés, boutique shops along Locke Street, and only minutes from GO Transit. Enjoy the character and historic architecture that define the surrounding neighbourhood as you stroll or bike through one of Hamilton’s most sought-after communities. Perfect for commuters and professionals alike, this prime location provides convenient access both in and out of the city. This spacious and modern 777 sq. ft. corner suite features 9-foot ceilings and an open-concept layout designed for comfortable living and entertaining. The bright living area walks out to a large private balcony showcasing beautiful escarpment views. The unit is finished with contemporary touches throughout, including floor-to-ceiling glass walls in the bedroom, a stylish kitchen with a center island, stainless steel appliances, in-suite laundry, and an abundance of natural light. Residents enjoy an impressive selection of amenities, including a fitness center, large party room, meeting room, bicycle storage, owned locker, and underground parking space. Condo fees include heating, cooling, and water for added convenience. Whether you're a medical professional, business professional, or first-time home buyer, this beautifully appointed one-bedroom plus den suite offers an outstanding opportunity to own in a highly desirable location. A must-see! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "852.25"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:21:13.294525+00:00"
+"Directions": "CHARLTON WEST OF JAMES AND BAY STREET SOUTH"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524512"
+"ListOfficeKey": "283362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Shared Driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-24T14:52:55Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:52:55Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "CHARLTON"
+"StreetNumber": "90"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "122 - Durand North"
+"TaxAnnualAmount": "4725"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1666887683"
"RoomType" => "Den"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
1 => array:11 [
"RoomKey" => "1666887684"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
2 => array:11 [
"RoomKey" => "1666887685"
"RoomType" => "Laundry room"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
3 => array:11 [
"RoomKey" => "1666887686"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.79Z"
]
4 => array:11 [
"RoomKey" => "1666887687"
"RoomType" => "Kitchen"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.8Z"
]
5 => array:11 [
"RoomKey" => "1666887688"
"RoomType" => "Living room"
"ListingId" => "40842274"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946415"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:25.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946415/90-charlton-avenue-w-unit-502-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "Condo"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 777
+"OriginalEntryTimestamp": "2026-06-24T14:51:25.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1134819"
+"ListOfficeNationalAssociationId": "1328262"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946415_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3ff5b4584468c77af9ce296851017226.webp"
"MediaSize" => 144473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3ff5b4584468c77af9ce296851017226.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building featuring a stone and stucco facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946415_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7f5b1baa59908ead0903e13d8e10c868.webp"
"MediaSize" => 136999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7f5b1baa59908ead0903e13d8e10c868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a light-colored facade with contrasting stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946415_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/49e7003ea5c589effadb950d14a866b7.webp"
"MediaSize" => 136999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-49e7003ea5c589effadb950d14a866b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a light-colored facade with contrasting stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946415_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/5ee93ed9333280dbe4472ada30291911.webp"
"MediaSize" => 135001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-5ee93ed9333280dbe4472ada30291911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story building featuring stacked balconies and a stone facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946415_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/916b441c7939baa86e07e95d6d7eecf4.webp"
"MediaSize" => 61609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-916b441c7939baa86e07e95d6d7eecf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby area featuring large format floor tiles, a built-in fireplace with a stone-finish facade, recessed lighting, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946415_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/99b6fd07c11b19bfdcd5e1b1461710d7.webp"
"MediaSize" => 67351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-99b6fd07c11b19bfdcd5e1b1461710d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring large format tile flooring, a built-in fireplace with a stone mantel, a textured wall accent, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946415_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/88c0f6545bd6100e08d3cd12d1fb47fa.webp"
"MediaSize" => 66790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-88c0f6545bd6100e08d3cd12d1fb47fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.07Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946415_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/6020c465e26af0ba277d8b77f5a0eba8.webp"
"MediaSize" => 40404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-6020c465e26af0ba277d8b77f5a0eba8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry door featuring a peephole, chrome hardware, and panel detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946415_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/ad6f745433729cce4539531b7630c2ee.webp"
"MediaSize" => 39982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-ad6f745433729cce4539531b7630c2ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946415_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7ddab6092b93fe4b62ffdc194aa99b64.webp"
"MediaSize" => 42070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7ddab6092b93fe4b62ffdc194aa99b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub and shower combination featuring neutral-toned wall tiles, a wall-mounted showerhead, and a white porcelain toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.04Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946415_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/cfc8c89d0f1c409f76489bc9517ffc52.webp"
"MediaSize" => 30105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-cfc8c89d0f1c409f76489bc9517ffc52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a light wood-finish cabinet with brushed nickel pulls, a white oval sink, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.03Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29946415_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/d83a5c208140faa41525112f8eb962bc.webp"
"MediaSize" => 55335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-d83a5c208140faa41525112f8eb962bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring with a full-height window and neutral wall finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29946415_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7cfe0f3aeb392d9dbe6c832ab36d06e0.webp"
"MediaSize" => 38987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7cfe0f3aeb392d9dbe6c832ab36d06e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a built-in sliding door closet, recessed ceiling, light gray walls, and wood-finish flooring visible at the doorway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29946415_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3e31bc4db62a4555044a505a7afab12d.webp"
"MediaSize" => 37714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3e31bc4db62a4555044a505a7afab12d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom space featuring light gray walls and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29946415_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/49bc368fad8413870f543ab4731dff90.webp"
"MediaSize" => 65498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-49bc368fad8413870f543ab4731dff90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, light grey painted walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29946415_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/af9cae67a477457e4c0e65b73401d9f3.webp"
"MediaSize" => 68803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-af9cae67a477457e4c0e65b73401d9f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring and a full-height glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29946415_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/c9c4fb558c87cfe4341ef4f139939b58.webp"
"MediaSize" => 73599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-c9c4fb558c87cfe4341ef4f139939b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a dark-toned kitchen island with storage, multiple large windows, and a combination of recessed and pendant lighting fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29946415_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/502e00b57c2b7dbe6dcde60b2d0636e1.webp"
"MediaSize" => 54977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-502e00b57c2b7dbe6dcde60b2d0636e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette area with stainless steel refrigerator, dark wood-finish cabinetry, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29946415_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/8d75b957a922dcf8b35790a9d532d6f5.webp"
"MediaSize" => 69025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-8d75b957a922dcf8b35790a9d532d6f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring expansive floor-to-ceiling windows, wood-finish flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29946415_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/da076fa151e9c3941132fea15cc2e3fa.webp"
"MediaSize" => 68295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-da076fa151e9c3941132fea15cc2e3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, a kitchen with dark cabinetry and stainless steel appliances, a central island with an extended countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.04Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29946415_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/f3b7b2af20d6efcd8723c896dd1427da.webp"
"MediaSize" => 73721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-f3b7b2af20d6efcd8723c896dd1427da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a center island with a dark countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.71Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29946415_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/4f20f062c38f93b5bc6999364faa045f.webp"
"MediaSize" => 72063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-4f20f062c38f93b5bc6999364faa045f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a center island with a dark countertop, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.65Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29946415_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/d54482e799f4f1812b2688f73ee1f5c3.webp"
"MediaSize" => 79083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-d54482e799f4f1812b2688f73ee1f5c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood-finish cabinetry, stainless steel appliances, and a tile floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.71Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29946415_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/56e642b11dd43ffa4318bba9506af937.webp"
"MediaSize" => 79535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-56e642b11dd43ffa4318bba9506af937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring dark wood-finish cabinetry, stainless steel appliances, a double basin sink with a gooseneck faucet, and a dark countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.65Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29946415_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/c04622e4364642d0a6571343e98b17d3.webp"
"MediaSize" => 34279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-c04622e4364642d0a6571343e98b17d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a stacked washer and dryer unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.05Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29946415_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/688ba5735167c823d833040678d79adb.webp"
"MediaSize" => 102416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-688ba5735167c823d833040678d79adb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious private balcony featuring a concrete floor, glass railings, and black metal handrails"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.68Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29946415_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/3e07962f84c6faf2a15df0ed66629371.webp"
"MediaSize" => 125584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-3e07962f84c6faf2a15df0ed66629371.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29946415_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/90d843eb79e88f8b56d1fbb3802ca77a.webp"
"MediaSize" => 115268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-90d843eb79e88f8b56d1fbb3802ca77a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony featuring a glass railing and metal frame, overlooking a multi-story building with multiple balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29946415_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/b61249a9322508736ca78381c3ed18c1.webp"
"MediaSize" => 102114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-b61249a9322508736ca78381c3ed18c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony railing with glass panels overlooking an urban landscape"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.08Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29946415_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/1e8c9029a915fa9eeac0a8e0ca25699a.webp"
"MediaSize" => 105181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-1e8c9029a915fa9eeac0a8e0ca25699a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private balcony featuring a concrete surface and a glass railing with dark metal posts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.06Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29946415_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/6a50006353d50e76d37efe0e2f647151.webp"
"MediaSize" => 85523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-6a50006353d50e76d37efe0e2f647151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring a full kitchen with dark cabinetry, an extended island with seating, large windows, recessed lighting, and patterned carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29946415_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/39c182daaa6194535c5f268f52ab34aa.webp"
"MediaSize" => 63398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-39c182daaa6194535c5f268f52ab34aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive kitchen island with seating for six, complemented by pendant lighting fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.07Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29946415_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/7903a73dace9775a80bfaf99081c3d53.webp"
"MediaSize" => 98379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-7903a73dace9775a80bfaf99081c3d53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark wood-finish cabinetry, light-toned countertops, a mosaic tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29946415_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/18e711d20410231f303a141b069d6b6f.webp"
"MediaSize" => 69947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-18e711d20410231f303a141b069d6b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious communal area featuring a large kitchen island with integrated stainless steel appliances, recessed lighting, and pendant fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.02Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29946415_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/8b84f1a32bed2bc3e47a76d93b8fe49c.webp"
"MediaSize" => 99889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-8b84f1a32bed2bc3e47a76d93b8fe49c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29946415_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/a7ca70a939ca36573912101ce9eefc78.webp"
"MediaSize" => 98569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-a7ca70a939ca36573912101ce9eefc78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated fitness center featuring rubber flooring and mirrored walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.66Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29946415_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/fd70e38be4b8314e39ff2d3e70a04ca6.webp"
"MediaSize" => 73982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-fd70e38be4b8314e39ff2d3e70a04ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated bike storage room featuring multiple rack systems, fluorescent lighting, a light gray floor, and white painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.69Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29946415_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/f79f22023c227546c3f72f9b6fc80442.webp"
"MediaSize" => 99007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-f79f22023c227546c3f72f9b6fc80442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated bike storage room featuring wall-mounted racks and ample floor space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:54.01Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29946415_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946415/9bb9c10059b430d5d9c4ebaa7dbc34e5.webp"
"MediaSize" => 65152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946415/thumbnail-9bb9c10059b430d5d9c4ebaa7dbc34e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Underground parking facility featuring concrete flooring and white support columns"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842274"
"ResourceRecordKey" => "29946415"
"ModificationTimestamp" => "2026-06-24T14:52:55.06Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946415')"
+"ID": "1566960"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1566980"
+post_author: 1
+"ListingKey": "29946674"
+"ListingId": "40842631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:15Z"
+"RFModificationTimestamp": "2026-06-26T02:58:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.8609361
1 => 43.2685538
]
+"Latitude": 43.2685538
+"Longitude": -79.8609361
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:57:56.622055+00:00"
+"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738902"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:08Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "9087"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1666920280"
"RoomType" => "Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
1 => array:11 [
"RoomKey" => "1666920281"
"RoomType" => "Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
2 => array:11 [
"RoomKey" => "1666920283"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
3 => array:11 [
"RoomKey" => "1666920285"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842631"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
4 => array:11 [
"RoomKey" => "1666920287"
"RoomType" => "Laundry room"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
5 => array:11 [
"RoomKey" => "1666920289"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
6 => array:11 [
"RoomKey" => "1666920291"
"RoomType" => "Dining room"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "98'0'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
7 => array:11 [
"RoomKey" => "1666920293"
"RoomType" => "Kitchen"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.9Z"
]
8 => array:11 [
"RoomKey" => "1666920295"
"RoomType" => "Living room"
"ListingId" => "40842631"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.91Z"
]
9 => array:11 [
"RoomKey" => "1666920296"
"RoomType" => "Exercise room"
"ListingId" => "40842631"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.91Z"
]
10 => array:11 [
"RoomKey" => "1666920298"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842631"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29946674"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:32:08.91Z"
]
11 => array:11 [
"RoomKey" => "1666920301"
"RoomType" => "Foyer"
…9
]
]
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946674')"
+"ID": "1566980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946910')"
+"ID": "1566335"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947057')"
+"ID": "1566342"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1565833"
+post_author: 1
+"ListingKey": "29955723"
+"ListingId": "40843253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:10:29Z"
+"RFModificationTimestamp": "2026-06-26T01:50:25Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2886.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2P8"
+"UnparsedAddress": "103 SHERMAN Avenue S, Hamilton, Ontario L8M2P8"
+"Coordinates": array:2 [
0 => -79.8393806
1 => 43.2481979
]
+"Latitude": 43.2481979
+"Longitude": -79.8393806
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Victorian residence seamlessly blends timeless character with modern upgrades, offering over 3,000 sq ft of beautifully finished living space. Featuring 6 bedrooms, 2 kitchens, 3 bathrooms, and multiple private entrances, this property is ideal for large families, multi-generational living, or savvy investors. The fully renovated main floor kitchen is a true showpiece-bright and modern with crisp white cabinetry, stainless steel appliances & gas range. Original architectural details add warmth and charm throughout, including hardwood floors, pocket doors, leaded glass windows, natural slate, Carrera marble countertops and vaulted ceilings. Step outside to a low maintenance backyard filled with perennials. A rare opportunity to own a truly stately home. Parking for up to 5 cars. Excellent location close to all amenities and bus route. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:50:14.363178+00:00"
+"Directions": "Main St E & North on Sherman Ave S"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976293"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T23:02:07Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:02:07Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "SHERMAN"
+"StreetNumber": "103"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "11336.99"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29955723/103-sherman-avenue-s-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2886
+"OriginalEntryTimestamp": "2026-06-25T23:02:07.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1262753"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955723')"
+"ID": "1565833"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1564000"
+post_author: 1
+"ListingKey": "29954372"
+"ListingId": "X13490436"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:30:12Z"
+"RFModificationTimestamp": "2026-06-25T23:30:27Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Strathcona)"
+"PostalCode": "L8P4C8"
+"UnparsedAddress": "21 - 36 MARGARET STREET, Hamilton (Strathcona), Ontario L8P4C8"
+"Coordinates": array:2 [
0 => -79.8852998
1 => 43.2602438
]
+"Latitude": 43.2602438
+"Longitude": -79.8852998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome home at the Margaret Street Lofts in the beloved Strathcona neighbourhood! This inviting 2nd floor 1-bedroom + den loft is located in a beautifully converted factory building, offering authentic character and a warm, homey feel. Soaring 12+ ft ceilings, exposed brick walls, large windows, carpet-free unit and a desirable north-east corner exposure creates a bright yet cozy home to relax in, entertain, cook, or work from home. The open-concept layout features a kitchen with new stainless steel appliances, refinished cabinetry, and a 3-seat island, flowing into a dining area large enough for a full-sized dining set. A unique loft-style den is perfect as a home office, reading nook, kids' play area, creative retreat or storage. Enjoy the comfort and convenience of a gas fireplace, in-suite laundry, room for full-sized furniture, oversized closets, a storage locker, and one surface parking space. Walk to Victoria Park, Locke Street's popular shops and restaurants, Fortinos, and downtown Hamilton. Quiet, welcoming, and full of character, this loft (1 of only 14 units) is ideal for young professionals, small families, down sizers, or savvy investors seeking something truly special. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "880"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:30:21.018768+00:00"
+"Directions": "Cross Streets: Main St W. ** Directions: Main St W to Margaret."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093102"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Rolling"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:14Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:21:58Z"
+"StreetName": "Margaret"
+"StreetNumber": "36"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4157.82"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/ekpgvpnm/unbranded"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Strathcona"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954372/21-36-margaret-street-hamilton-strathcona-strathcona"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Lion heart Property Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "D/S-1402a"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-25T19:50:14.23Z"
+"ListAgentNationalAssociationId": "1365580"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954372')"
+"ID": "1564000"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
+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: 569
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]