array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29134573/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134573&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134573/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134573&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23278
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23280
+post_id: "443010"
+post_author: 1
+"ListingKey": "29134573"
+"ListingId": "40790302"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T15:40:31Z"
+"RFModificationTimestamp": "2025-11-25T17:09:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 748.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P1H9"
+"UnparsedAddress": "149 MAIN Street W Unit# 101, Hamilton, Ontario L8P1H9"
+"Coordinates": array:2 [
0 => -79.8757958
1 => 43.256692
]
+"Latitude": 43.256692
+"Longitude": -79.8757958
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This bright two-bedroom, 1 bathroom apartment offers convenience and lifestyle in downtown Hamilton. The unit features stainless steel appliances and tasteful finishes. Just a short walk to McMaster’s Downtown Centre, the Farmers’ Market, the TD Coliseum, and endless dining options. Transit and the GO Station are very close by; ideal for students and professionals looking to stay connected to school, food, entertainment, and Hamilton’s vibrant core. Paid parking available. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-11-25T17:09:34.162002+00:00"
+"Directions": "King St W to Caroline to Main St W"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"PhotosChangeTimestamp": "2025-11-25T15:30:57Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T15:30:57Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "MAIN"
+"StreetNumber": "149"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Durand North"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1539898311"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790302"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134573"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T15:30:57.45Z"
]
1 => array:11 [
"RoomKey" => "1539898312"
"RoomType" => "Bedroom"
"ListingId" => "40790302"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134573"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T15:30:57.45Z"
]
2 => array:11 [
"RoomKey" => "1539898313"
"RoomType" => "Bedroom"
"ListingId" => "40790302"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134573"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T15:30:57.45Z"
]
3 => array:11 [
"RoomKey" => "1539898314"
"RoomType" => "Living room"
"ListingId" => "40790302"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134573"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 22'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T15:30:57.45Z"
]
4 => array:11 [
"RoomKey" => "1539898315"
"RoomType" => "Kitchen"
"ListingId" => "40790302"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134573"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T15:30:57.46Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29134573/149-main-street-w-unit-101-hamilton"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 1950
+"ZoningDescription": "D3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 162.0
+"AboveGradeFinishedArea": 748
+"OriginalEntryTimestamp": "2025-11-25T15:30:57.39Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6339148958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/e3cb2257cc92b5c31a0445ff9e1ff0d1.webp"
"MediaSize" => 55553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-e3cb2257cc92b5c31a0445ff9e1ff0d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6339148996"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/572638295d2a253f2d704e46155a39b8.webp"
"MediaSize" => 35905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-572638295d2a253f2d704e46155a39b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6339149105"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/f0151e8a3e0b733e104131c23594b34a.webp"
"MediaSize" => 90136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-f0151e8a3e0b733e104131c23594b34a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6339149188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/37d52ad00aed40a64d3066f5301c01d0.webp"
"MediaSize" => 56745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-37d52ad00aed40a64d3066f5301c01d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6339149294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/ba99d34987e7af82f5963e0951d0e688.webp"
"MediaSize" => 107142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-ba99d34987e7af82f5963e0951d0e688.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6339149346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/19d27da5fe7847295352dff856e3d33c.webp"
"MediaSize" => 92268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-19d27da5fe7847295352dff856e3d33c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6339149413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/219d2f215108582beae2ef8363cc706d.webp"
"MediaSize" => 45709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-219d2f215108582beae2ef8363cc706d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6339149452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/fd6a7e69a6fae2e730c00abb4a74574e.webp"
"MediaSize" => 105727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-fd6a7e69a6fae2e730c00abb4a74574e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6339149512"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/8c0868206434128a38bd4c7c3205d3af.webp"
"MediaSize" => 54599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-8c0868206434128a38bd4c7c3205d3af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6339149530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/7ed64dc3455c4036ccdca5b97b1a3dd6.webp"
"MediaSize" => 116248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-7ed64dc3455c4036ccdca5b97b1a3dd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6339149595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/424f6907a2b8ef666184c86fc83a9b51.webp"
"MediaSize" => 60219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-424f6907a2b8ef666184c86fc83a9b51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6339149643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/23d1e34493deedde6200e2567d55fa46.webp"
"MediaSize" => 48319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-23d1e34493deedde6200e2567d55fa46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6339149656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/b049770514ceaf094409c05a98afa373.webp"
"MediaSize" => 45681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-b049770514ceaf094409c05a98afa373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6339149773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/ac4268ae9e18b22ce28428fdfad654ab.webp"
"MediaSize" => 52320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-ac4268ae9e18b22ce28428fdfad654ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6339149809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/b9d556990790f92715cbaa38485159f2.webp"
"MediaSize" => 45206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-b9d556990790f92715cbaa38485159f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6339149858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/3a49101b2ac9c11473cd24f00d6c6d43.webp"
"MediaSize" => 59871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-3a49101b2ac9c11473cd24f00d6c6d43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6339149863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/9544334220d788d93c4a176ee8e9c3d5.webp"
"MediaSize" => 42222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-9544334220d788d93c4a176ee8e9c3d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6339149924"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/b79c6fb5baed5090139c587d7074e59b.webp"
"MediaSize" => 49242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-b79c6fb5baed5090139c587d7074e59b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6339149933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/db428bf2bca32010a6d802d32920d3ba.webp"
"MediaSize" => 88988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-db428bf2bca32010a6d802d32920d3ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6339149983"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/1bbd9b36466ed44a2a0b6214f853b448.webp"
"MediaSize" => 52551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-1bbd9b36466ed44a2a0b6214f853b448.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6339150001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/28b07a203fa95f4e60a4b4f4145496dc.webp"
"MediaSize" => 61827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-28b07a203fa95f4e60a4b4f4145496dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6339150046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/2c79b52b58da4c62fabc3fc281aadf93.webp"
"MediaSize" => 38092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-2c79b52b58da4c62fabc3fc281aadf93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6339150062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134573/e4b0cf499453f2736659ecd7933584d0.webp"
"MediaSize" => 44168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134573/thumbnail-e4b0cf499453f2736659ecd7933584d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790302"
"ResourceRecordKey" => "29134573"
"ModificationTimestamp" => "2025-11-25T15:30:57.4Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134573')"
+"ID": "443010"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 9c631b25adf24003ae672d0fc2ebf68ad70f6e385abe2a307dbb073ea9f44bf3" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25109
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25101
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-689-9223"
+"OfficeMlsId": "HBRMXESCDUND"
+"ModificationTimestamp": "2025-07-09T18:36:53Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293261"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#1B-493 Dundas Street E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterdown"
+"OfficePostalCode": "L0R2H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1424570"
+"OriginalEntryTimestamp": "2022-09-12T18:20:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439666"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "293261"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-07-09T18:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293261')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: 23ea6064e5a5f399938e89fef4f09f99c5e7149c170ba01c52b6a613615a1d6e" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25106
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29134573" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24706
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134573/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134573&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134573/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134573&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24686
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134573 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8757958 43.256692)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134573 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8757958 43.256692)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134573 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8757958 43.256692)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134573 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8757958 43.256692)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24539
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24958
+post_id: "447708"
+post_author: 1
+"ListingKey": "29141278"
+"ListingId": "X12580684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T03:55:10Z"
+"RFModificationTimestamp": "2025-11-27T04:32:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L5K3"
+"UnparsedAddress": "40 EMERALD STREET N, Hamilton (Landsdale), Ontario L8L5K3"
+"Coordinates": array:2 [
0 => -79.85364
1 => 43.253905
]
+"Latitude": 43.253905
+"Longitude": -79.85364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "From the moment you step through the front door of 40 Emerald Street North, you're greeted by timeless elegance and modern comfort in perfect harmony. The spacious foyer welcomes you with a full closet, solid wood Victorian doors adorned with vintage hardware, and recently refinished original pine floors that flow throughout the home. High ceilings crowned with ornate medallions, lofty baseboards, and exposed brick create a warm, historic backdrop. The kitchen is a showpiece. Bright white cabinetry, stainless steel appliances, polished wood island, farmer's sink, herringbone backsplash, wainscoting, and a striking exposed brick wall blend beautifully with the home's century-old soul. Spacious principal rooms and tall windows fill the main level with light. Convenient powder room finishes the main floor. Wood stairs lead you up to three bedrooms, each with original doors, trim, hardware, and floors, along with a modern, sparkling bath. Everywhere you look, the best of old-world craftsmanship and thoughtful updates unite in style. The fully finished basement offers incredible flexibility. A private in-law suite, teenage retreat, or guest space featuring a living area that can double as a bedroom, a sleek 3-piece bath, kitchenette, and direct laundry access. Step outside to a fully fenced backyard, perfect for relaxing or entertaining, and a rare detached garage for parking or storage. Updates incl. all wiring and plumbing (2019), 50 year shingles on main roof (2020), all new windows and limestone sills (2019), furnace (2019), water heater (2020). All of this in a walkable downtown location, just steps to shops, restaurants, parks, and transit. 40 Emerald Street North delivers heritage charm, modern updates, and unbeatable convenience. It's a real gem in the heart of the city. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T04:32:25.327782+00:00"
+"Directions": "Cross Streets: King William Street. ** Directions: King William St or Wilson St E to Emerald St N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040128"
+"ListOfficeKey": "280718"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.6 x 126 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T03:49:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T03:49:21Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Emerald"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/1062e3ee8bd60eacd4935afe1b02c953"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1540721285"
"RoomType" => "Foyer"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 1.22
"ListingKey" => "29141278"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
1 => array:11 [
"RoomKey" => "1540721286"
"RoomType" => "Kitchen"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 2.24
"ListingKey" => "29141278"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
2 => array:11 [
"RoomKey" => "1540721287"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 2.24
"ListingKey" => "29141278"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
3 => array:11 [
"RoomKey" => "1540721288"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 3.07
"ListingKey" => "29141278"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
4 => array:11 [
"RoomKey" => "1540721289"
"RoomType" => "Office"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 1.45
"ListingKey" => "29141278"
"RoomLength" => 1.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
5 => array:11 [
"RoomKey" => "1540721290"
"RoomType" => "Laundry room"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 1.7
"ListingKey" => "29141278"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
6 => array:11 [
"RoomKey" => "1540721291"
"RoomType" => "Living room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.71
"ListingKey" => "29141278"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
7 => array:11 [
"RoomKey" => "1540721292"
"RoomType" => "Dining room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29141278"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
8 => array:11 [
"RoomKey" => "1540721293"
"RoomType" => "Kitchen"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29141278"
"RoomLength" => 4.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
9 => array:11 [
"RoomKey" => "1540721294"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 0.94
"ListingKey" => "29141278"
"RoomLength" => 1.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
10 => array:11 [
"RoomKey" => "1540721295"
"RoomType" => "Mud room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 2.18
"ListingKey" => "29141278"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
11 => array:11 [
"RoomKey" => "1540721296"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29141278"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
12 => array:11 [
"RoomKey" => "1540721297"
"RoomType" => "Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29141278"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
13 => array:11 [
"RoomKey" => "1540721298"
"RoomType" => "Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 2.08
"ListingKey" => "29141278"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
14 => array:11 [
"RoomKey" => "1540721299"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 1.85
"ListingKey" => "29141278"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29141278/40-emerald-street-n-hamilton-landsdale-landsdale"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.7
+"OriginalEntryTimestamp": "2025-11-27T03:49:21.21Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342024352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/65774644ae95d8ae67b5f5543a9683c0.webp"
"MediaSize" => 141524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-65774644ae95d8ae67b5f5543a9683c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342024356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/283d98421f3eb553107abc031038060c.webp"
"MediaSize" => 140777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-283d98421f3eb553107abc031038060c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342024394"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/2781064f8d783f2315f92aa930ebfd87.webp"
"MediaSize" => 155096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-2781064f8d783f2315f92aa930ebfd87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342024409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/809379e5a6a40c54880d44e96fe67cd0.webp"
"MediaSize" => 118716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-809379e5a6a40c54880d44e96fe67cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342024417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/21441951a517b33056d50c89e93417b9.webp"
"MediaSize" => 150307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-21441951a517b33056d50c89e93417b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342024470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/4bf317307eb06ffb08a2bffef55ea590.webp"
"MediaSize" => 114870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-4bf317307eb06ffb08a2bffef55ea590.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342024482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/8b862ce14b5e1c5f6b4e307e3735832d.webp"
"MediaSize" => 138993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-8b862ce14b5e1c5f6b4e307e3735832d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342024490"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/b0f372a268687fb02b347d5ecd445f56.webp"
"MediaSize" => 128209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-b0f372a268687fb02b347d5ecd445f56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342024493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/9ee95251b9478c449343813b3b9b87d4.webp"
"MediaSize" => 96358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-9ee95251b9478c449343813b3b9b87d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342024496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/418b67c94c5e9796e6e5ca3fd7d0430b.webp"
"MediaSize" => 136923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-418b67c94c5e9796e6e5ca3fd7d0430b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342024502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/afa4f721005da19fa01606bb66ba02ca.webp"
"MediaSize" => 137292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-afa4f721005da19fa01606bb66ba02ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342024531"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/b4d88d2f0b750dfd57a859a9c000bf56.webp"
"MediaSize" => 122244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-b4d88d2f0b750dfd57a859a9c000bf56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342024535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/af0f7bf8630373d63f1009deb1dc7820.webp"
"MediaSize" => 135427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-af0f7bf8630373d63f1009deb1dc7820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342024544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/e1fec181a75b74401dee380f798a9d12.webp"
"MediaSize" => 130242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-e1fec181a75b74401dee380f798a9d12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342024574"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/1882637a4b80e77a33f71486081a0f17.webp"
"MediaSize" => 122370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-1882637a4b80e77a33f71486081a0f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6342024588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/174a29ce03d94449fe5519a1067abb20.webp"
"MediaSize" => 59778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-174a29ce03d94449fe5519a1067abb20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6342024606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/49c4ab2d25f172a03cf2b522b7a6560f.webp"
"MediaSize" => 109344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-49c4ab2d25f172a03cf2b522b7a6560f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6342024614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/a13278acfe5fa2f516c65664024dcd1f.webp"
"MediaSize" => 103604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-a13278acfe5fa2f516c65664024dcd1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6342024656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/1e1bb84bc2ee97c298e6659cf2c32201.webp"
"MediaSize" => 92621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-1e1bb84bc2ee97c298e6659cf2c32201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6342024670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/2bc9dc75c7c6df02cf9386354d8ecdd9.webp"
"MediaSize" => 118264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-2bc9dc75c7c6df02cf9386354d8ecdd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6342024780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/e5cb7a01e3eef04aa8ad3b3d57731cba.webp"
"MediaSize" => 91718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-e5cb7a01e3eef04aa8ad3b3d57731cba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6342024798"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/fcfdd9129ea802e99345c979600a0549.webp"
"MediaSize" => 93453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-fcfdd9129ea802e99345c979600a0549.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6342024810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/4f53669ba643ea732d2bfaa5905b1251.webp"
"MediaSize" => 111962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-4f53669ba643ea732d2bfaa5905b1251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6342024946"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/ec29ad93e8836fecf7516bb18c1f4c7d.webp"
"MediaSize" => 93004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-ec29ad93e8836fecf7516bb18c1f4c7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6342024963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/6b4a86d820b31d6d0f4eeb9d969ec80e.webp"
"MediaSize" => 79558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-6b4a86d820b31d6d0f4eeb9d969ec80e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6342024974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/ba3fc2a3fbc951fe799caf00072d16fa.webp"
"MediaSize" => 110427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-ba3fc2a3fbc951fe799caf00072d16fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6342024985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/39e295a15cdd154357c89f1711428c55.webp"
"MediaSize" => 83587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-39e295a15cdd154357c89f1711428c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6342024998"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/b50390036c4f9a0dd28c268fa5b5e5a2.webp"
"MediaSize" => 92411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-b50390036c4f9a0dd28c268fa5b5e5a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6342025090"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/47ce3ecc6a07f05f3ef73bf624618c55.webp"
"MediaSize" => 85720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-47ce3ecc6a07f05f3ef73bf624618c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6342025103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/a0ce6dd634ebbffd201bb0ac36d7f17e.webp"
"MediaSize" => 111909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-a0ce6dd634ebbffd201bb0ac36d7f17e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6342025111"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/dcce7c85a4de167171d12dab6f43e4f4.webp"
"MediaSize" => 89592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-dcce7c85a4de167171d12dab6f43e4f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6342025120"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/876d8515dc648b33a26a663e27f79b40.webp"
"MediaSize" => 117276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-876d8515dc648b33a26a663e27f79b40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6342025178"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/95abd997db89157f662fcff50ef76e9e.webp"
"MediaSize" => 85351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-95abd997db89157f662fcff50ef76e9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6342025183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/6e91ecaf5494de43e046facd830c56b9.webp"
"MediaSize" => 112264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-6e91ecaf5494de43e046facd830c56b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6342025187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/3cc3223282b4a253fcba847b970fc193.webp"
"MediaSize" => 185339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-3cc3223282b4a253fcba847b970fc193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6342025191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/3ef01788a762a4d12a186206efc6cc42.webp"
"MediaSize" => 86529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-3ef01788a762a4d12a186206efc6cc42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6342025194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/05911f7a5b35510ab31955784b206867.webp"
"MediaSize" => 61145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-05911f7a5b35510ab31955784b206867.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141278')"
+"ID": "447708"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24564
+post_id: "447517"
+post_author: 1
+"ListingKey": "29141197"
+"ListingId": "40790853"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T03:06:03Z"
+"RFModificationTimestamp": "2025-11-27T03:10:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1746.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5K3"
+"UnparsedAddress": "40 EMERALD Street N, Hamilton, Ontario L8L5K3"
+"Coordinates": array:2 [
0 => -79.8536711
1 => 43.2539122
]
+"Latitude": 43.2539122
+"Longitude": -79.8536711
+"YearBuilt": 1890
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "From the moment you step through the front door of 40 Emerald Street North, you’re greeted by timeless elegance and modern comfort in perfect harmony. The spacious foyer welcomes you with a full closet, solid wood Victorian doors adorned with vintage hardware, and recently refinished original pine floors that flow throughout the home. High ceilings crowned with ornate medallions, lofty baseboards, and exposed brick create a warm, historic backdrop. The kitchen is a showpiece. Bright white cabinetry, stainless steel appliances, polished wood island, farmer’s sink, herringbone backsplash, wainscoting, and a striking exposed brick wall blend beautifully with the home’s century-old soul. Spacious principal rooms and tall windows fill the main level with light. Convenient powder room finishes the main floor. Wood stairs lead you up to three bedrooms, each with original doors, trim, hardware, and floors, along with a modern, sparkling bath. Everywhere you look, the best of old-world craftsmanship and thoughtful updates unite in style. The fully finished basement offers incredible flexibility. A private in-law suite, teenage retreat, or guest space featuring a living area that can double as a bedroom, a sleek 3-piece bath, kitchenette, and direct laundry access. Step outside to a fully fenced backyard, perfect for relaxing or entertaining, and a rare detached garage for parking or storage. Updates incl. all wiring and plumbing (2019), 50 year shingles on main roof (2020), all new windows and limestone sills (2019), furnace (2019), water heater (2020). All of this in a walkable downtown location, just steps to shops, restaurants, parks, and transit. 40 Emerald Street North delivers heritage charm, modern updates, and unbeatable convenience. It’s a real gem in the heart of the city. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T03:10:14.108344+00:00"
+"Directions": "Wilson St. E. or King William St. to Emerald St. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533669"
+"ListOfficeKey": "229734"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T02:50:44Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T02:50:44Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "EMERALD"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Lansdale"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/1062e3ee8bd60eacd4935afe1b02c953"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141197/40-emerald-street-n-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2700
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1183
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2025-11-27T02:30:16.14Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141197')"
+"ID": "447517"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24965
+post_id: "447143"
+post_author: 1
+"ListingKey": "29140564"
+"ListingId": "X12580124"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T23:06:04Z"
+"RFModificationTimestamp": "2025-11-27T01:06:40Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Kirkendall)"
+"PostalCode": "L8P2R9"
+"UnparsedAddress": "407 ABERDEEN AVENUE, Hamilton (Kirkendall), Ontario L8P2R9"
+"Coordinates": array:2 [
0 => -79.8919081
1 => 43.2505642
]
+"Latitude": 43.2505642
+"Longitude": -79.8919081
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Home Sweet Home. You've heard it before. Youll hear it again. This is the real deal. Lived in. Loved in. Family created. Memories made. Built in 1908, this old gal provides ample light with a flexible modern design, crown mouldings, custom kitchen, main floor bath tucked out of site and a generous pantry that is laundry ready. A convenient mud room off the kitchen, cozy yard with sun & shaded overhang that doubles as a carport, low maintenance garden and three-car private driveway completes the picture. Step outside your own piece of paradise and explore all that this sought-after neighbourhood has to offer with the Dundurn Market, Aberdeen Tavern, the shops of LockeSt., Chedoke Golf Club, Beulah Park & The Reservoir all steps away. Transit is at your door, downtown is a quick trip, and the highway is minutes away. Not that you'd ever want to leave. Start your own story here. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:06:26.848036+00:00"
+"Directions": "Cross Streets: Dundurn/Aberdeen. ** Directions: One block east of Dundurn, south side of Abderdeen at Mt. Royal."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:6 [
0 => "Concrete"
1 => "Hardwood"
2 => "Laminate"
3 => "Carpeted"
4 => "Ceramic"
5 => "Wood"
]
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417551"
+"ListOfficeKey": "50730"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Sump Pump"
]
+"LotSizeDimensions": "41.8 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2025-11-26T22:58:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:58:52Z"
+"Stories": "2.0"
+"StreetName": "Aberdeen"
+"StreetNumber": "407"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "8054.58"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Kirkendall"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140564/407-aberdeen-avenue-hamilton-kirkendall-kirkendall"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1977408"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50730"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Canopy"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 41.9
+"OriginalEntryTimestamp": "2025-11-26T22:58:52.44Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140564')"
+"ID": "447143"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24957
+post_id: "446699"
+post_author: 1
+"ListingKey": "29140266"
+"ListingId": "40790702"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T21:45:39Z"
+"RFModificationTimestamp": "2025-11-26T22:47:45Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2253.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P2E3"
+"UnparsedAddress": "219 CHARLTON Avenue W, Hamilton, Ontario L8P2E3"
+"Coordinates": array:2 [
0 => -79.882772
1 => 43.2522177
]
+"Latitude": 43.2522177
+"Longitude": -79.882772
+"YearBuilt": 1908
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Character filled family home in sought after Kirkendall Neighborhood. Charming, spacious c. 1908 home filled with original details. Offering 2250 sq. ft.+ full basement with walk up. The main floor enjoys separate living and dining rooms with pocket doors, original wood baseboards and trim, leaded glass, fireplace mantle & unique bifold wooden French doors. The home enjoys 4 bedrooms upstairs including the 500 sq. ft. attic bedroom plus a second floor kitchenette and renovated 3 pc. bath. Off street parking for 2 cars is found via laneway. Situated steps to HAAA Park, a short walk to schools and Locke Street South make this a superb location for families. Make this beloved house your home. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T22:47:35.042782+00:00"
+"Directions": "Between Queen and Kent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1561262"
+"ListOfficeKey": "293148"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"PhotosChangeTimestamp": "2025-11-26T21:42:23Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T21:42:23Z"
+"Stories": "2.5"
+"StreetDirSuffix": "West"
+"StreetName": "CHARLTON"
+"StreetNumber": "219"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "121 - Kirkendall"
+"TaxAnnualAmount": "6167.6"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29140266/219-charlton-avenue-w-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2208769"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54881"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 2253
+"OriginalEntryTimestamp": "2025-11-26T21:38:45.78Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:44 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140266')"
+"ID": "446699"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24576
+post_id: "446473"
+post_author: 1
+"ListingKey": "29139591"
+"ListingId": "40790720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T21:25:40Z"
+"RFModificationTimestamp": "2025-11-26T21:30:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.07
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5G1"
+"UnparsedAddress": "202 VICTORIA Avenue N Unit# Main, Hamilton, Ontario L8L5G1"
+"Coordinates": array:2 [
0 => -79.8540272
1 => 43.2589928
]
+"Latitude": 43.2589928
+"Longitude": -79.8540272
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Check out this awesome main floor two-bedroom apartment! Recently renovated, carpet-free and ready to move in. Located near the heart of downtown Hamilton, there is tons to discover in the neighbourhood - parks, the famous Comma Cafe, popular restaurants, and convenient grocery stores. The kitchen has stainless steel appliances and beautiful stone countertops. The large four-piece bathroom is tastefully updated. Two spacious bedrooms, a great family space, and a separate laundry area round out this awesome unit. Did I mention there is a TON of storage space in the unfinished basement? Steps from public transit with street parking, this unit is ideal for commuters. Walking distance to Hamilton General Hospital, Ron Joyce Children's Health Centre, Theatre Aquarius, Hamilton GO Centre, and vibrant Central Hamilton. Welcome home! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T21:30:44.635611+00:00"
+"Directions": "Victoria Ave N between Cannon St E and Barton St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.07"
+"PhotosChangeTimestamp": "2025-11-26T21:12:24Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T21:12:24Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "VICTORIA"
+"StreetNumber": "202"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "141 - Lansdale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139591/202-victoria-avenue-n-unit-main-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2025-11-26T19:30:29.03Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:21 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139591')"
+"ID": "446473"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24968
+post_id: "445595"
+post_author: 1
+"ListingKey": "29138735"
+"ListingId": "40790676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:15:07Z"
+"RFModificationTimestamp": "2025-11-26T17:35:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 580.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R1J5"
+"UnparsedAddress": "113 CATHARINE Street N Unit# 3, Hamilton, Ontario L8R1J5"
+"Coordinates": array:2 [
0 => -79.8640445
1 => 43.259752
]
+"Latitude": 43.259752
+"Longitude": -79.8640445
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Quiet and Clean top level unit in Beasley Neighbourhood. This 1 bedroom 1 bathroom unit has wonderful exposed brick in the living room area and bedroom. Soaring ceilings and plenty of light in both the living room and bedroom. Plenty of space to grow your herbs and plants! Well sized galley kitchen with plenty of storage, stainless steel appliances including a dishwasher and gas range! The bathroom is modern and updated with well sized shower, and this unit has in suite laundry. Enjoy your own private entrance and no neighbours above you. Sitting on the transit line in both directions, this unit is less than 10 minutes to Mcmaster University, less than 10 minutes walk to Hamilton General and 5 minute walk to the trendy shops and restaurants on James St N. Enjoy Coffee at one of the many beautiful cafes, explore amazing clothing stores and shops! Walk a little bit further and you can shop for your groceries at Nations grocery store or the Hamilton Farmers Market. Beautifully maintained building, no outdoor winter or summer maintenance required by tenant. Gas included in the lease. Water and Hydro Separately metered. Available Starting January 15th! A Perfect place to start 2026! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:35:03.601628+00:00"
+"Directions": "Cannon St E to Catharine St N, Left on Catharine St N - building is on the right hand side."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2201853"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "No Pet Home"
]
+"PhotosChangeTimestamp": "2025-11-26T17:00:32Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:00:32Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "CATHARINE"
+"StreetNumber": "113"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138735/113-catharine-street-n-unit-3-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2133853"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283153"
+"GeocodeManualYN": true
+"TotalActualRent": 1900
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "D4"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 580
+"OriginalEntryTimestamp": "2025-11-26T17:00:32.06Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:18 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138735')"
+"ID": "445595"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23292
+post_id: "445596"
+post_author: 1
+"ListingKey": "29138750"
+"ListingId": "X12578290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:15:08Z"
+"RFModificationTimestamp": "2025-11-26T17:34:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Central)"
+"PostalCode": "L8P0C6"
+"UnparsedAddress": "1907 - 15 QUEEN STREET S, Hamilton (Central), Ontario L8P0C6"
+"Coordinates": array:2 [
0 => -79.878614
1 => 43.259054
]
+"Latitude": 43.259054
+"Longitude": -79.878614
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Largest 2 bed plus den non penthouse unit in the building. Located at the intersection of King and Queen in Downtown Hamilton.Stunning, bright, sun-filled, open concept 2 Bed, 2 bath Plus Den, with locker and parking. 9 foot high ceilings, laminate flooring throughout, extendedheight kitchen cabinets with upgraded S/S Appliances, backsplash and Quartz Countertops, full-size in-suite laundry, Private Large Balcony withescarpment / city views. Walk to everything, Hess Village, Breweries, Shops, Restaurants & Cafes. Minutes to Hamilton GO, West Harbour GO, Busroutes. McMaster University is just minutes away by bus, minutes From Hwy 403. Amenities Include a State-Of-The-Art Gym, Yoga Deck, Party Roomand Rooftop Terrace. Tenant pays all utilities and internet. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:34:29.914307+00:00"
+"Directions": "Queen St S & King St W"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803415"
+"ListOfficeKey": "278308"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-26T17:01:47Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:01:47Z"
+"StreetDirSuffix": "South"
+"StreetName": "Queen"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"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": "Central"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29138750/1907-15-queen-street-s-hamilton-central-central"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "North Star Management Inc"
+"GeocodeManualYN": false
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T17:01:47.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138750')"
+"ID": "445596"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24565
+post_id: "445597"
+post_author: 1
+"ListingKey": "29138242"
+"ListingId": "40790502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T15:45:27Z"
+"RFModificationTimestamp": "2025-11-26T17:07:42Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R3P3"
+"UnparsedAddress": "290 BARTON Street W Unit# 17, Hamilton, Ontario L8R3P3"
+"Coordinates": array:2 [
0 => -79.8788996
1 => 43.2677834
]
+"Latitude": 43.2677834
+"Longitude": -79.8788996
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This move-in-ready home is your opportunity to live in a location that's close to just about everything while offering unobstructed views of green space and the lake! Features of this three bed, 2.5 bath home include an open concept design with 9' ceilings and wide plank flooring on the main level. The spacious eat-in kitchen features an island with breakfast bar, s/s appliances and lots of natural light! A combined living/dining room and powder room complete this level. With new carpeting in all bedrooms, the primary bedroom has an ensuite, walk-in closet and solarium with juliette balcony! Two additional bedrooms, 4-piece bath and laundry complete the upper level. You will love entertaining on the spacious rooftop terrace with lake view or simply enjoying some quiet time while soaking it in. With your own private parking right outside your front door and separate bike storage this home is the complete package! Located in close proximity to great restaurants, shopping, Bayfront Park, Dundurn Castle, Hess Village and more. This prime location is also perfect for commuters - situated within minutes of the West Harbour GO station and offering easy access to the 403! Make your move to make this great property yours! NB: some photos have been virtually staged. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "509.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:07:26.255288+00:00"
+"Directions": "York to Locke N to Barton W"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1923201"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2025-11-26T15:38:41Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T15:38:41Z"
+"StreetDirSuffix": "West"
+"StreetName": "BARTON"
+"StreetNumber": "290"
+"StreetSuffix": "Street"
+"SubdivisionName": "101 - Strathcona Central North"
+"TaxAnnualAmount": "6018.49"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fi/of2vcjaatxiczcbhwfbo9/17-290-Barton-Street-W-Hamilton.m4v?rlkey=jzweb136qeo7kefhirbrbmuy6&st=y44drlmo&dl=0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138242/290-barton-street-w-unit-17-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RT-20/S-1478"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1596
+"OriginalEntryTimestamp": "2025-11-26T15:38:41.15Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138242')"
+"ID": "445597"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24552
+post_id: "444895"
+post_author: 1
+"ListingKey": "29137646"
+"ListingId": "X12577252"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T03:05:26Z"
+"RFModificationTimestamp": "2025-11-26T03:22:24Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L2R2"
+"UnparsedAddress": "247 ROBERT STREET, Hamilton (Landsdale), Ontario L8L2R2"
+"Coordinates": array:2 [
0 => -79.8557407
1 => 43.2599349
]
+"Latitude": 43.2599349
+"Longitude": -79.8557407
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This unique and versatile detached home functions like a duplex, offering two completely separate units with private front entrances ideal for multifamily living or a turn-key investment. The main floor features a sun-filled, open-concept living and dining area with soaring ceilings, a brand-new kitchen with quartz countertops, walk-out to a large fully fenced backyard, a spacious master bedroom, en-suite laundry, and a fully renovated shower. The upper unit includes an oversized master bedroom with office space, a second bedroom, a renovated kitchen, a bright, lounge-like living area, en-suite laundry, and an updated shower. With two-car parking and income already being generated, this property provides flexibility, space, and value in one. Whether you're looking to live in one unit and rent the other or invest in a fully rented property, this opportunity checks every box. Don't miss your chance with this one. (id:62650)"
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2025-11-26T03:22:21.950871+00:00"
+"Directions": "Victoria Ave / Wilson St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967759"
+"ListOfficeKey": "282886"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Carpet Free"
1 => "Gazebo"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "22 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:53:40Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T02:53:40Z"
+"Stories": "2.0"
+"StreetName": "Robert"
+"StreetNumber": "247"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3228.04"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137646/247-robert-street-hamilton-landsdale-landsdale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2025-11-26T02:53:39.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137646')"
+"ID": "444895"
}
]
+success: true
+page_size: 9
+page_count: 76
+count: 684
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]