array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29744396 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23471
+post_id: "1418292"
+post_author: 1
+"ListingKey": "29744396"
+"ListingId": "X13120872"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T16:51:07Z"
+"RFModificationTimestamp": "2026-06-04T17:08:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3221.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Thorner)"
+"PostalCode": "L8V5B9"
+"UnparsedAddress": "1C - 66 MALL ROAD, Hamilton (Thorner), Ontario L8V5B9"
+"Coordinates": array:2 [
0 => -79.861336
1 => 43.221307
]
+"Latitude": 43.221307
+"Longitude": -79.861336
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional leasing opportunity in a prime Hamilton Mountain location at 66 Mall Rd. Situated beside busy Limeridge Mall and fronting Upper Wentworth, this unit offers outstanding exposure, signage potential, and easy access in one of Hamilton's most established commercial hubs. Share a very high traffic plaza with major national tenants including LCBO, Tim Hortons, and Scotiabank, drawing consistent daily customer traffic to the area. Ideal for a wide range of uses including restaurant, retail, medical, financial, professional office, and service-based businesses. Exceptional visibility, strong surrounding demographics, parking, and convenient access make this an excellent opportunity for businesses looking to establish or expand their presence in a thriving location. (id:62650)"
+"BusinessType": "Service"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-13T20:22:04.777445+00:00"
+"Directions": "Upper Wentworth St & Mohawk Rd"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156272"
+"ListOfficeKey": "285351"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-13T14:17:06Z"
+"PhotosCount": 8
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T16:38:33Z"
+"StreetName": "Mall"
+"StreetNumber": "66"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Thorner"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29744396/1c-66-mall-road-hamilton-thorner-thorner"
+"GeocodeManualYN": false
+"TotalActualRent": 12000
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "Hh/S701A"
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-13T14:17:06.59Z"
+"ListAgentNationalAssociationId": "1407715"
+"ListOfficeNationalAssociationId": "1350793"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29744396_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/6fbc70281e46a8f243fd9f348de3637e.webp"
"MediaSize" => 147034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-6fbc70281e46a8f243fd9f348de3637e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29744396_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/2f91798ff9297bf53da75b8b132e113f.webp"
"MediaSize" => 153400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-2f91798ff9297bf53da75b8b132e113f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29744396_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/d48f682554a8575ea429ecab377f62d1.webp"
"MediaSize" => 171571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-d48f682554a8575ea429ecab377f62d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29744396_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/5720188487d3e5db317b27fe9606aa2c.webp"
"MediaSize" => 203677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-5720188487d3e5db317b27fe9606aa2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29744396_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/9d9286687f1351cb23759f9e4db318a0.webp"
"MediaSize" => 136705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-9d9286687f1351cb23759f9e4db318a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29744396_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/655c1c16c47eb6d91427d3dc9ebd81cb.webp"
"MediaSize" => 162225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-655c1c16c47eb6d91427d3dc9ebd81cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29744396_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/11a589cd48d1e60333a95639e0353db0.webp"
"MediaSize" => 189022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-11a589cd48d1e60333a95639e0353db0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29744396_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29744396/928c4d547369b1a7fc62a36a1246569d.webp"
"MediaSize" => 204403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29744396/thumbnail-928c4d547369b1a7fc62a36a1246569d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13120872"
"ResourceRecordKey" => "29744396"
"ModificationTimestamp" => "2026-05-13T14:17:06.59Z"
]
]
+"DaysOnMarket": 60
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29744396')"
+"ID": "1418292"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 285351" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24857
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "UNION CAPITAL REALTY"
+"OfficeEmail": null
+"OfficePhone": "289-317-1288"
+"OfficeMlsId": "337000"
+"ModificationTimestamp": "2025-06-10T15:18:00Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285351"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "245 WEST BEAVER CREEK RD #9B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "RICHMOND HILL"
+"OfficePostalCode": "L4B1L"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1350793"
+"OriginalEntryTimestamp": "2019-06-21T22:57:00Z"
+"OfficeFax": "289-317-1289"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "10883"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "285351"
"SocialMediaUrlOrId" => "HTTP://www.unioncapitalrealty.com"
"ModificationTimestamp" => "2025-06-10T15:06:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1116952"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('285351')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2156272" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24867
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29744396'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25181
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29744396' AND OpenHouseDate ge '2026-07-11'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25197
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29744396' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial+Lease' AND geo.distance(Coordinates, POINT(-79.861336 43.221307)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1560673"
+post_author: 1
+"ListingKey": "29945452"
+"ListingId": "40842571"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:45:07Z"
+"RFModificationTimestamp": "2026-07-02T16:50:26Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.28
+"LivingArea": 460.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V1V1"
+"UnparsedAddress": "662 E FENNELL Avenue E Unit# 7, Hamilton, Ontario L8V1V1"
+"Coordinates": array:2 [
0 => -79.8508008
1 => 43.2306087
]
+"Latitude": 43.2306087
+"Longitude": -79.8508008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Second floor office space in a high traffic location. The unit is a blank slate with 2 storage closets. There are no windows. The building offers 2 common area washrooms, parking for 1 car in rear parking lot. There is ample street parking. This is an all inclusive lease!!! Signage on the front window of the building and on the directory. (id:62650)"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Heat"
3 => "Electricity"
4 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-24T06:22:10.696324+00:00"
+"Directions": "West of Upper Sherman"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1663135"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.28"
+"PhotosChangeTimestamp": "2026-06-24T04:39:25Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:33:35Z"
+"Stories": "2.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "FENNELL"
+"StreetNumber": "662"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "177 - Burkhome"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945452/662-e-fennell-avenue-e-unit-7-hamilton"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "1524865"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262664"
+"GeocodeManualYN": true
+"TotalActualRent": 999
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "C2"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 86.0
+"OriginalEntryTimestamp": "2026-06-24T04:39:25.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1168385"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1063707"
+"CoListOfficeNationalAssociationId": "1223042"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29945452_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945452/d03e58ca944ed4da8c58235584a99cf7.webp"
"MediaSize" => 129445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945452/thumbnail-d03e58ca944ed4da8c58235584a99cf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842571"
"ResourceRecordKey" => "29945452"
"ModificationTimestamp" => "2026-06-24T04:39:25.81Z"
]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945452')"
+"ID": "1560673"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1491648"
+post_author: 1
+"ListingKey": "29849128"
+"ListingId": "40836456"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:40:08Z"
+"RFModificationTimestamp": "2026-06-28T19:44:29Z"
+"ListPrice": 24.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 703.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C6X6"
+"UnparsedAddress": "1030 UPPER JAMES Street Unit# 304, Hamilton, Ontario L9C6X6"
+"Coordinates": array:2 [
0 => -79.8850961
1 => 43.2218227
]
+"Latitude": 43.2218227
+"Longitude": -79.8850961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Professional Office space located on one of the most desirable Business streets of Hamilton. Third floor Unit includes reception area, 2 spacious Offices, a large working area, and a private bathroom. Elevator and Public Washrooms are available (Men, Women, & Handicap). Excellent exposure and Highway access. Building signage available. Utilities included. High traffic area with Bus Route stop right in front of the building. 703 Sq Ft. August 1st possession available. (id:62650)"
+"AssociationFeeIncludes": array:8 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Heat"
5 => "Electricity"
6 => "Water"
7 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-06-03T23:05:01.389324+00:00"
+"Directions": "Between Aldridge St & Jameston Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967871"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Elevator"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-28T19:21:31Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T19:32:54Z"
+"Stories": "4.0"
+"StreetName": "UPPER JAMES"
+"StreetNumber": "1030"
+"StreetSuffix": "Street"
+"SubdivisionName": "162 - Rolston/Yeoville"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29849128/1030-upper-james-street-unit-304-hamilton"
+"LeaseAmount": 24
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Offices"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C5"
+"FrontageLengthNumeric": 125.0
+"OriginalEntryTimestamp": "2026-06-03T20:31:09.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1255709"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29849128_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/23d0b7a144aa8a9f080a8af438f20743.webp"
"MediaSize" => 103249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-23d0b7a144aa8a9f080a8af438f20743.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29849128_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/9ad7061415055588dcddb2ab6b62f7e8.webp"
"MediaSize" => 136743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-9ad7061415055588dcddb2ab6b62f7e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-28T19:21:30.94Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29849128_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/8b7f50e3482cf06db9902242819fef5f.webp"
"MediaSize" => 76298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-8b7f50e3482cf06db9902242819fef5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29849128_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/523f2ed8948e956f990f4354eba519ce.webp"
"MediaSize" => 91588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-523f2ed8948e956f990f4354eba519ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29849128_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/0cc86d218511ff0155c3df46c7ce9191.webp"
"MediaSize" => 104312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-0cc86d218511ff0155c3df46c7ce9191.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29849128_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/64eb695d521622150436fa519c254e34.webp"
"MediaSize" => 44875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-64eb695d521622150436fa519c254e34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29849128_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/76e277b7642ea0873fb49ebddc3c6029.webp"
"MediaSize" => 82465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-76e277b7642ea0873fb49ebddc3c6029.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29849128_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/2d4bf9b505cb8f6f894b1763926b1f76.webp"
"MediaSize" => 49355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-2d4bf9b505cb8f6f894b1763926b1f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29849128_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/8123b54912cfc35cff9a7b68f8863a19.webp"
"MediaSize" => 71612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-8123b54912cfc35cff9a7b68f8863a19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29849128_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/08993481f64db003b2e902eb12bec51f.webp"
"MediaSize" => 51166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-08993481f64db003b2e902eb12bec51f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29849128_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/b1f342eba37d04fee3683032657c596c.webp"
"MediaSize" => 105498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-b1f342eba37d04fee3683032657c596c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29849128_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/a6f9c83f1833a31b278c31217546c915.webp"
"MediaSize" => 116477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-a6f9c83f1833a31b278c31217546c915.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29849128_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/811617084e8ba9c3f85f0fd436b76c80.webp"
"MediaSize" => 89699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-811617084e8ba9c3f85f0fd436b76c80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29849128_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/b75510fdbeb5bbd1e5e9a26f1504398e.webp"
"MediaSize" => 89982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-b75510fdbeb5bbd1e5e9a26f1504398e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29849128_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/6b91717742b2bc85581cee24d95465ed.webp"
"MediaSize" => 65515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-6b91717742b2bc85581cee24d95465ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29849128_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/c42252ab72e8d6a9c640c5b5c7a45d31.webp"
"MediaSize" => 90732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-c42252ab72e8d6a9c640c5b5c7a45d31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29849128_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/a31e49a0852d68c66077b481206e1866.webp"
"MediaSize" => 84386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-a31e49a0852d68c66077b481206e1866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29849128_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/18523bc16f9dece6ad78fd88e4164ff3.webp"
"MediaSize" => 72970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-18523bc16f9dece6ad78fd88e4164ff3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29849128_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/e5bd7493a8ff546345a81fe3823c0356.webp"
"MediaSize" => 112378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-e5bd7493a8ff546345a81fe3823c0356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29849128_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/38839cc7442132f8f45c9760327a5137.webp"
"MediaSize" => 92961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-38839cc7442132f8f45c9760327a5137.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29849128_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/d05aa25a5c6cbe8b8dffcd9c128c37ef.webp"
"MediaSize" => 106978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-d05aa25a5c6cbe8b8dffcd9c128c37ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29849128_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/b31d833826f51a6011dfa6be7742bcb2.webp"
"MediaSize" => 36811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-b31d833826f51a6011dfa6be7742bcb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29849128_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/01e36ef0d72c1d2252106b4bd9f9f442.webp"
"MediaSize" => 107623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-01e36ef0d72c1d2252106b4bd9f9f442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29849128_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29849128/05e2e62fab0ab23a2d80de56228ac28d.webp"
"MediaSize" => 94707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29849128/thumbnail-05e2e62fab0ab23a2d80de56228ac28d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836456"
"ResourceRecordKey" => "29849128"
"ModificationTimestamp" => "2026-06-03T20:31:09.06Z"
]
]
+"DaysOnMarket": 39
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29849128')"
+"ID": "1491648"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1304097"
+post_author: 1
+"ListingKey": "29586169"
+"ListingId": "40819504"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:09Z"
+"RFModificationTimestamp": "2026-06-02T17:45:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.12
+"LivingArea": 720.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3L7"
+"UnparsedAddress": "517 UPPER SHERMAN Avenue Unit# 2nd Floor, Hamilton, Ontario L8V3L7"
+"Coordinates": array:2 [
0 => -79.846861
1 => 43.2323189
]
+"Latitude": 43.2323189
+"Longitude": -79.846861
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover office space in one of Hamilton's most strategic locations. This well-appointed second floor office space at 517 Upper Sherman Avenue combines modern functionality with prime positioning for businesses seeking growth and visibility. This updated office suite features its own private entrance, ensuring convenient access for both staff and clients. The space has been thoughtfully designed with plumbing infrastructure, making it particularly well-suited for medical practices, aesthetic clinics, or wellness-focused businesses. The bright, open floor plan maximizes natural light throughout, creating an inviting professional environment that enhances both productivity and client experience. The property includes access to common area bathrooms and a shared kitchen facility, providing essential amenities while maintaining cost efficiency. Building signage opportunities are available, offering excellent brand visibility along this high-traffic corridor. Street parking provides convenient access for clients and staff. (id:62783)"
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"CreationDate": "2026-04-10T18:05:17.455279+00:00"
+"Directions": "N/E Corner Brucedale & U. Sherman"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025166"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.12"
+"PhotosChangeTimestamp": "2026-04-10T15:39:28Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:43:25Z"
+"Stories": "2.0"
+"StreetName": "UPPER SHERMAN"
+"StreetNumber": "517"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "174 - Raleigh"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29586169/517-upper-sherman-avenue-unit-2nd-floor-hamilton"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "2139701"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"TotalActualRent": 1600
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "C5"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-04-10T15:39:28.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304838"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1391481"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6583993673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/f6f813ebefa7430d16216106fce4f03f.webp"
"MediaSize" => 74173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-f6f813ebefa7430d16216106fce4f03f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6583993736"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/97e5b0860b4f5b0f73fe4f76ec1db605.webp"
"MediaSize" => 100965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-97e5b0860b4f5b0f73fe4f76ec1db605.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6583993786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/da6b0ecccc71367e6aa0cc7ce81d5979.webp"
"MediaSize" => 73964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-da6b0ecccc71367e6aa0cc7ce81d5979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6583993805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/85ab5c239f43c90cc1e6e557af82c243.webp"
"MediaSize" => 84996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-85ab5c239f43c90cc1e6e557af82c243.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Reception with a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6583993854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/4b598f35b21322c3c3e965dc27e43d58.webp"
"MediaSize" => 88440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-4b598f35b21322c3c3e965dc27e43d58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6583993870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/a00741bc377cbb15c71e9df06ea03fe9.webp"
"MediaSize" => 129167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-a00741bc377cbb15c71e9df06ea03fe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Misc room with a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6583993949"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/47a767a005837715ba23cfbb4177f053.webp"
"MediaSize" => 85548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-47a767a005837715ba23cfbb4177f053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6583994022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/0eb3e5ee8999556fe6be4395cdc2431a.webp"
"MediaSize" => 138477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-0eb3e5ee8999556fe6be4395cdc2431a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Misc room featuring a paneled ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6583994071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/f63a8a997f8c48d2fd6f68ca97282c1d.webp"
"MediaSize" => 91932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-f63a8a997f8c48d2fd6f68ca97282c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office featuring a paneled ceiling and dark carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6583994107"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/a97a5e9fd1752ddade50caf4b5a101eb.webp"
"MediaSize" => 25855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-a97a5e9fd1752ddade50caf4b5a101eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairway with baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6583994191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/24e06a80850562e888141e12ac1ee7c0.webp"
"MediaSize" => 137406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-24e06a80850562e888141e12ac1ee7c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6583994221"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586169/11d582a7c456b10a64409a43736249d8.webp"
"MediaSize" => 96021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586169/thumbnail-11d582a7c456b10a64409a43736249d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of commercial property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819504"
"ResourceRecordKey" => "29586169"
"ModificationTimestamp" => "2026-04-10T15:39:28.7Z"
]
]
+"DaysOnMarket": 93
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29586169')"
+"ID": "1304097"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1159498"
+post_author: 1
+"ListingKey": "29372812"
+"ListingId": "40805992"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:36:12Z"
+"RFModificationTimestamp": "2026-06-02T18:09:54Z"
+"ListPrice": 19.5
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C2Z9"
+"UnparsedAddress": "720 UPPER JAMES Street Unit# 2, Hamilton, Ontario L9C2Z9"
+"Coordinates": array:2 [
0 => -79.8807586
1 => 43.2314112
]
+"Latitude": 43.2314112
+"Longitude": -79.8807586
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "1,300 sq. ft. Retail/Office Opportunity in well exposed Upper James plaza. Bright open space. Pylon signage and fascia signage above unit. Rear driveway loading if required via overhead door. Note: Landlord prefers no food related uses in the plaza. (id:62650)"
+"AssociationFeeIncludes": array:7 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Electricity"
5 => "Insurance"
6 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"CreationDate": "2026-02-18T18:44:35.787020+00:00"
+"Directions": "Corner of Upper James St., at South Bend Rd. Two blocks north of Mohawk Rd."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523853"
+"ListOfficeKey": "54871"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-02-23T14:51:48Z"
+"PhotosCount": 5
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:55:23Z"
+"Stories": "1.0"
+"StreetName": "UPPER JAMES"
+"StreetNumber": "720"
+"StreetSuffix": "Street"
+"SubdivisionName": "153 - Southam/Donnington"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29372812/720-upper-james-street-unit-2-hamilton"
+"LeaseAmount": 19.5
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C2"
+"FrontageLengthNumeric": 148.0
+"OriginalEntryTimestamp": "2026-02-18T17:49:26.14Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1063016"
+"ListOfficeNationalAssociationId": "1003484"
+"Media": array:5 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6460157961"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29372812/19c9bf8a0a573bc8218ad47039b07eda.webp"
"MediaSize" => 77291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29372812/thumbnail-19c9bf8a0a573bc8218ad47039b07eda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40805992"
"ResourceRecordKey" => "29372812"
"ModificationTimestamp" => "2026-02-18T17:53:35.19Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6460158002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29372812/377e2653f681f1faa556e34eba121335.webp"
"MediaSize" => 24226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29372812/thumbnail-377e2653f681f1faa556e34eba121335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40805992"
"ResourceRecordKey" => "29372812"
"ModificationTimestamp" => "2026-02-18T17:53:35.19Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6470099883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29372812/3b797d07b33fe098998c75aae697ea49.webp"
"MediaSize" => 14415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29372812/thumbnail-3b797d07b33fe098998c75aae697ea49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40805992"
"ResourceRecordKey" => "29372812"
"ModificationTimestamp" => "2026-02-23T14:51:48.71Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6470099916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29372812/90f24dd53d9fd32e2bfece97777d8386.webp"
"MediaSize" => 14151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29372812/thumbnail-90f24dd53d9fd32e2bfece97777d8386.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40805992"
"ResourceRecordKey" => "29372812"
"ModificationTimestamp" => "2026-02-23T14:51:48.71Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6470099934"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29372812/4cbba6492f3e7ef3a40186dfef393f04.webp"
"MediaSize" => 13608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29372812/thumbnail-4cbba6492f3e7ef3a40186dfef393f04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40805992"
"ResourceRecordKey" => "29372812"
"ModificationTimestamp" => "2026-02-23T14:51:48.73Z"
]
]
+"DaysOnMarket": 144
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29372812')"
+"ID": "1159498"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]