array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29455012 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1215386"
+post_author: 1
+"ListingKey": "29455012"
+"ListingId": "X12869352"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-06T23:15:41Z"
+"RFModificationTimestamp": "2026-05-06T23:27:49Z"
+"ListPrice": 13.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Central)"
+"PostalCode": "L8R2R1"
+"UnparsedAddress": "A - 231 BAY STREET N, Hamilton (Central), Ontario L8R2R1"
+"Coordinates": array:2 [
0 => -79.870442
1 => 43.26512
]
+"Latitude": 43.26512
+"Longitude": -79.870442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "You could wait for West Harbour to arrive, or you could build the bridge. Located in the former Bridge Works offices, 231 Bay Street North Unit A offers 1,500 SF of character-rich commercial space inside a heritage building undergoing major renewal. Just over 10-foot clear height in the main area, a wide-open footprint, brand new black-framed windows and the chance to demise and design your new space. Above, three storeys of newly developed purpose-built rental residences provide built-in daily presence. Nearby, the established Bridgeworks event venue adds destination traffic and evening energy, while West Harbour GO and the creative pulse of James Street North sit just steps away. This pocket is still emerging, which means the right cafe, cocktail bar, gallery, studio, creative office or neighbourhood-serving concept has the opportunity to define it rather than follow it (subject to municipal approvals). Asking $13.00 PSF net plus estimated TMI of $3.57 PSF (subject to change). Longer terms preferred. Some businesses wait for momentum. Others create it. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-03-11T06:43:51.264784+00:00"
+"Directions": "Cross Streets: Barton and Bay. ** Directions: South-west corner of Barton and Bay."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959038"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "142.41 x 131.2 FT"
+"PhotosChangeTimestamp": "2026-05-06T22:46:24Z"
+"PhotosCount": 23
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-06T23:08:28Z"
+"StreetDirSuffix": "North"
+"StreetName": "Bay"
+"StreetNumber": "231"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3.57"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Central"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29455012/a-231-bay-street-n-hamilton-central-central"
+"LeaseAmount": 13
+"LeasePerUnit": "square feet"
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D/S-699"
+"FrontageLengthNumeric": 142.4
+"OriginalEntryTimestamp": "2026-03-11T05:40:48.78Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249687"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:23 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6510134552"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/637c838729191ac99730607a35cb9c1d.webp"
"MediaSize" => 305919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-637c838729191ac99730607a35cb9c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bay corner render"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6510134553"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/7c80104cb9a2fadf63317e3a3258b9db.webp"
"MediaSize" => 381016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-7c80104cb9a2fadf63317e3a3258b9db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Barton side render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6510134554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/033ee9843f2b135b14d267d402e05619.webp"
"MediaSize" => 154355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-033ee9843f2b135b14d267d402e05619.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Coffee shop render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6510134555"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/c916bfc6e051ff7db59db774c1f01db5.webp"
"MediaSize" => 157803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-c916bfc6e051ff7db59db774c1f01db5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office reception render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6510134556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/ab71c42532a7981ece6927235d12d84c.webp"
"MediaSize" => 225964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-ab71c42532a7981ece6927235d12d84c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Coffee shop render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6510134557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/b9fdd52e9c34348b830f10815331ce9e.webp"
"MediaSize" => 209349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-b9fdd52e9c34348b830f10815331ce9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Co-working render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6510134559"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/aef48375cb006ec4c2ca410820a0f144.webp"
"MediaSize" => 193298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-aef48375cb006ec4c2ca410820a0f144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-03-11T05:40:48.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6658741728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/977ff12d0dd1dbe7b525cf246e59e8ba.webp"
"MediaSize" => 105486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-977ff12d0dd1dbe7b525cf246e59e8ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:03:35.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6658860132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/1d3f3aa0df44a6ccf2cf1ae08cccda6e.webp"
"MediaSize" => 100161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-1d3f3aa0df44a6ccf2cf1ae08cccda6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Barton St. Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:23.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6658860139"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/6e15841fca56db15252a66a7f358dc95.webp"
"MediaSize" => 142353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-6e15841fca56db15252a66a7f358dc95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vault Wine Room Render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:22.03Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6658860147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/ee2e822925535dcbbac1333d4c5e18de.webp"
"MediaSize" => 151955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-ee2e822925535dcbbac1333d4c5e18de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior rear of unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:22.29Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6658860153"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/12a98cfa91a5c2ad62d98a493aac2a42.webp"
"MediaSize" => 140432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-12a98cfa91a5c2ad62d98a493aac2a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vault interior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:23.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6658860160"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/f5f7a082c9b60766d4f1589869f962d0.webp"
"MediaSize" => 300424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-f5f7a082c9b60766d4f1589869f962d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vault Wine Room Interior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:22.52Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6658860167"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/2a1aea4a6de95b20591e783462ee5eaf.webp"
"MediaSize" => 489736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-2a1aea4a6de95b20591e783462ee5eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bay and Barton Corner elevation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:24.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6658860171"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/e1e41487ed94774acab93e33b8b4949a.webp"
"MediaSize" => 259692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-e1e41487ed94774acab93e33b8b4949a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:46:22.13Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6658860176"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/ecabf5495af3a9fc13eac912696cc465.webp"
"MediaSize" => 300678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-ecabf5495af3a9fc13eac912696cc465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Barton Elevation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:03:38.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6658860182"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/077fa7e9650deaab3a8237ef47b78a28.webp"
"MediaSize" => 367700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-077fa7e9650deaab3a8237ef47b78a28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Parking Lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:03:44.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6658860188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/87c706ae05be720993795779426391df.webp"
"MediaSize" => 292414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-87c706ae05be720993795779426391df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio outside unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:03:48.73Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6658860194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/839208cb05fc2ab6bb4ccd9c4ed4b73a.webp"
"MediaSize" => 276909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-839208cb05fc2ab6bb4ccd9c4ed4b73a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio render night"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:03:53.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6658860200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/55e8ad241c1fc474a89abd22c2bcde3c.webp"
"MediaSize" => 404069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-55e8ad241c1fc474a89abd22c2bcde3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio render night"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:04:00.92Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6658860205"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/00aa517538a7bd0c4f35e21713d24434.webp"
"MediaSize" => 433040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-00aa517538a7bd0c4f35e21713d24434.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper deck and stairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:04:08.03Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6658860212"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/75e82fb8b05d4bf32915d0a0e229be8c.webp"
"MediaSize" => 356421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-75e82fb8b05d4bf32915d0a0e229be8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper deck and stairs render"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:04:15.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6658860217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29455012/3acb2b71424932da1d98ecc21c065787.webp"
"MediaSize" => 468528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29455012/thumbnail-3acb2b71424932da1d98ecc21c065787.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio render, day"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12869352"
"ResourceRecordKey" => "29455012"
"ModificationTimestamp" => "2026-05-06T22:04:19.21Z"
]
]
+"DaysOnMarket": 113
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29455012')"
+"ID": "1215386"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1959038" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29455012'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25208
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29455012'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25224
+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 '29455012' 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.870442 43.26512)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25277
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1576512"
+post_author: 1
+"ListingKey": "29967538"
+"ListingId": "40836223"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Institutional - Special Purpose"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T20:00:16Z"
+"RFModificationTimestamp": "2026-06-29T21:05:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1962.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P3B3"
+"UnparsedAddress": "242 JAMES Street S Unit# Main Floor, Hamilton, Ontario L8P3B3"
+"Coordinates": array:2 [
0 => -79.8724336
1 => 43.2495335
]
+"Latitude": 43.2495335
+"Longitude": -79.8724336
+"YearBuilt": 1850
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Historic Gem Across from St. Joe’s – 242 James St S, in the heart of Hamilton’s vibrant downtown core, this stately mid-19th century building (circa 1850) offers timeless Victorian charm blended with flexible functionality. Featuring classic brickwork, tall arched windows, steep gables, and heritage detailing, this three-storey property stands out as a remarkable investment and ownership opportunity. Zoning allows for mixed, retail, office and medical uses. Main floor consists of 1962 sq ft of well-designed commercial space: three offices, a reception area, full kitchen, full bath, and a feature brick fireplace. Access to a large unfinished basement adds expansion or storage potential. A rear stairwell offers emergency egress and access to the private parking area. Enjoy 4 total parking spots—3 rear via private drive and 1 front boulevard. A separate below-grade basement walk up entrance allows for possible future independent use or rental. Nestled between many similar Victorian era properties of the Durand and Stinson School areas, multi unit remarkably stellar multi-million-dollar properties nearby. Steps to shopping, dining, medical offices, hospitals, GO transit, the escarpment, and major highways. Quick access to Hamilton International Airport and Porter Airlines. (id:62783)"
+"AssociationFeeIncludes": array:4 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-29T21:05:46.075581+00:00"
+"Directions": "South on James, 3rd drive west side after Charlton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524805"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-29T19:52:30Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:52:30Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "JAMES"
+"StreetNumber": "242"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Durand North"
+"TaxAnnualAmount": "15582.57"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=69240"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967538/242-james-street-s-unit-main-floor-hamilton"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "1525223"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "288925"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "C5a"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-06-29T19:52:30.19Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1123403"
+"ListOfficeNationalAssociationId": "1223042"
+"CoListAgentNationalAssociationId": "1096355"
+"CoListOfficeNationalAssociationId": "1372539"
+"Media": array:11 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29967538_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/c184ed5720d7236790d76989bf3022e5.webp"
"MediaSize" => 156285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-c184ed5720d7236790d76989bf3022e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade building featuring a covered entryway, paved driveway, and stone retaining wall"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29967538_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/9f76e3bfbed1ae9501d95a2946b5fd1e.webp"
"MediaSize" => 139843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-9f76e3bfbed1ae9501d95a2946b5fd1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29967538_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/7360531524a851f07f5ddb129c9024b6.webp"
"MediaSize" => 68453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-7360531524a851f07f5ddb129c9024b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact kitchen area featuring dark wood-finish flooring and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29967538_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/67dd37554a0c92000f684e414832aa25.webp"
"MediaSize" => 96896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-67dd37554a0c92000f684e414832aa25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29967538_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/7fb7b145e98e48f38a7b0fa526acfd83.webp"
"MediaSize" => 87686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-7fb7b145e98e48f38a7b0fa526acfd83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exposed brick accent wall featuring a decorative fireplace with a white mantel, wood-finish flooring, recessed lighting, and bay windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29967538_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/695d81dc76045b1b83c0ce2e04cbaf13.webp"
"MediaSize" => 60949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-695d81dc76045b1b83c0ce2e04cbaf13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed lighting illuminates the room featuring wood-finish flooring, a large window with blinds, and white window trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29967538_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/51e7861e1763883417128dfca308be6e.webp"
"MediaSize" => 105236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-51e7861e1763883417128dfca308be6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exposed brick wall featuring a decorative fireplace with a white mantel, complemented by wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29967538_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/811baa41a76dea6db7e5372d9e1933e9.webp"
"MediaSize" => 108619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-811baa41a76dea6db7e5372d9e1933e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring wood-finish flooring, recessed lighting, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29967538_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/f3a3615abf9b4750c4046145109c2938.webp"
"MediaSize" => 59631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-f3a3615abf9b4750c4046145109c2938.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact interior room featuring wood-finish flooring, light neutral wall paint, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29967538_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/e4cf9296881fb1c02f956f26aea13a40.webp"
"MediaSize" => 60415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-e4cf9296881fb1c02f956f26aea13a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29967538_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967538/dab16e140db8b2bc4a09a096a6dfa024.webp"
"MediaSize" => 21223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967538/thumbnail-dab16e140db8b2bc4a09a096a6dfa024.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836223"
"ResourceRecordKey" => "29967538"
"ModificationTimestamp" => "2026-06-29T19:52:30.2Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967538')"
+"ID": "1576512"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1566992"
+post_author: 1
+"ListingKey": "29946637"
+"ListingId": "X13483320"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:35:12Z"
+"RFModificationTimestamp": "2026-06-26T02:59:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Corktown)"
+"PostalCode": "L8N2C1"
+"UnparsedAddress": "MAIN - 84 JOHN STREET S, Hamilton (Corktown), Ontario L8N2C1"
+"Coordinates": array:2 [
0 => -79.867696
1 => 43.253639
]
+"Latitude": 43.253639
+"Longitude": -79.867696
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "A rare chance to plant your flag in the heart of downtown Hamilton! This fully renovated 900 sq ft commercial/retail unit offers prime D3-zoned space with additional basement storage. Whether you're looking to open a restaurant, launch a catering concept, start a beverage production operation, salon, barbershop, or tattoo shop, the zoning here gives you flexibility needed to operate what works best for you. The space is currently configured for café use, complete with new partitions, custom millwork, structural reinforcements, and fully renovated washrooms on both the main floor and basement level. Plumbing, electrical, HVAC, and gas have all been recently upgraded. Landlord covers building insurance, and maintenance. Tenant responsible for proportionate share of property tax at $500 per month, as well as separately metered or charged back utility usage. Square footage provided by landlord. (id:62783)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-26T02:59:18.823932+00:00"
+"Directions": "Jackson St E & John St S"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16.41 x 90.01 FT"
+"ParkingFeatures": array:1 [
0 => "Other"
]
+"PhotosChangeTimestamp": "2026-06-24T15:26:49Z"
+"PhotosCount": 20
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:26:49Z"
+"StreetDirSuffix": "South"
+"StreetName": "John"
+"StreetNumber": "84"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "500"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Corktown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29946637/main-84-john-street-s-hamilton-corktown-corktown"
+"GeocodeManualYN": false
+"TotalActualRent": 1500
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D1 - Downtown Central Business District"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 16.4
+"OriginalEntryTimestamp": "2026-06-24T15:26:49.24Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946637_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/c4be8ff1ed8a42079ad1ba81f6965ad9.webp"
"MediaSize" => 126707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-c4be8ff1ed8a42079ad1ba81f6965ad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946637_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/952287c01e8f126d0c9c0616f26c6bd4.webp"
"MediaSize" => 171443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-952287c01e8f126d0c9c0616f26c6bd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946637_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/d0009cd0fca97149de30c9bd1e886849.webp"
"MediaSize" => 153288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-d0009cd0fca97149de30c9bd1e886849.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946637_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/2f8fc005c537d59cb6e6a535ad1501e1.webp"
"MediaSize" => 81019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-2f8fc005c537d59cb6e6a535ad1501e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946637_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/953a3ca52b253c72806c55d2d55338f4.webp"
"MediaSize" => 82360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-953a3ca52b253c72806c55d2d55338f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946637_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/001678df474a37422d2aa2b71c19b7ab.webp"
"MediaSize" => 69805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-001678df474a37422d2aa2b71c19b7ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946637_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/ae3a4c20fa01b64e4b376f7d765c8eb3.webp"
"MediaSize" => 69198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-ae3a4c20fa01b64e4b376f7d765c8eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946637_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/f357e9f4696bdabfedde658cd0c0aefd.webp"
"MediaSize" => 83639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-f357e9f4696bdabfedde658cd0c0aefd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946637_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/384edc2f9326129f1fd2b01f36ac5fc0.webp"
"MediaSize" => 72261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-384edc2f9326129f1fd2b01f36ac5fc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946637_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/00982842cb82e3b1febd0a12635b4b77.webp"
"MediaSize" => 71354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-00982842cb82e3b1febd0a12635b4b77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946637_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/8804fc6f3670a54168f8dd6e8b75c924.webp"
"MediaSize" => 55536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-8804fc6f3670a54168f8dd6e8b75c924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29946637_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/0cac1917a34b277ac56ec9889649bd62.webp"
"MediaSize" => 63889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-0cac1917a34b277ac56ec9889649bd62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29946637_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/169e52bfba5d6c5304c48adf4deae075.webp"
"MediaSize" => 57737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-169e52bfba5d6c5304c48adf4deae075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29946637_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/a873340b252a788c90a7a5214702d4fb.webp"
"MediaSize" => 54953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-a873340b252a788c90a7a5214702d4fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29946637_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/34231701af234fae8e68244b48024818.webp"
"MediaSize" => 57057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-34231701af234fae8e68244b48024818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29946637_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/6afe171dfe1e4085089e51dcc5eec715.webp"
"MediaSize" => 49864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-6afe171dfe1e4085089e51dcc5eec715.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29946637_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/c2cfdc0447bf93180c69b32f4b524d72.webp"
"MediaSize" => 149885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-c2cfdc0447bf93180c69b32f4b524d72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29946637_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/6c7c769ad00af3cddee6086fbd8c37a6.webp"
"MediaSize" => 139699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-6c7c769ad00af3cddee6086fbd8c37a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29946637_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/2bbc2596a4a536bcc1a8b62304f91bb3.webp"
"MediaSize" => 155547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-2bbc2596a4a536bcc1a8b62304f91bb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29946637_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946637/7be67b299d6e7acdfc6f0c2d8bc81824.webp"
"MediaSize" => 156438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946637/thumbnail-7be67b299d6e7acdfc6f0c2d8bc81824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13483320"
"ResourceRecordKey" => "29946637"
"ModificationTimestamp" => "2026-06-24T15:26:49.24Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946637')"
+"ID": "1566992"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1566354"
+post_author: 1
+"ListingKey": "29947136"
+"ListingId": "40842653"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:40:12Z"
+"RFModificationTimestamp": "2026-06-26T02:24:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P3T1"
+"UnparsedAddress": "235 QUEEN Street S, Hamilton, Ontario L8P3T1"
+"Coordinates": array:2 [
0 => -79.8815076
1 => 43.2518722
]
+"Latitude": 43.2518722
+"Longitude": -79.8815076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully turn-key office space in Hamilton’s desirable Durand neighbourhood with historic character and modern functionality. This bright and spacious ground-floor unit boasts 1,218 square feet with high ceilings, updated finishes, and an inviting layout that includes large private offices, a dedicated boardroom, a kitchenette, and two bathrooms. The unit has private access from Queen Street South as well as from the rear parking lot. There’s also access to a private outdoor deck. With easy access to downtown Hamilton, Hwy 403, and public transit, this location offers exceptional convenience and accessibility. The gross lease includes natural gas, property taxes, building insurance, property maintenance, and up to three on-site parking spaces, providing simplicity and cost certainty. Hydro and water are separately metered and in addition to the rent. Ideal for professional offices in a vibrant, well-connected location. (id:62783)"
+"AssociationFeeIncludes": array:2 [
0 => "Electricity"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-26T02:23:55.953325+00:00"
+"Directions": "Corner of Queen St S and Charlton Ave W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952016"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-24T16:32:46Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:32:46Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "QUEEN"
+"StreetNumber": "235"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Durand North"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvt/359196"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947136/235-queen-street-s-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Offices"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2950
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "DE-3"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-06-24T16:32:46.15Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245678"
+"ListOfficeNationalAssociationId": "1344650"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29947136_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/dbedd56bd85fef9c29cae0d2dbb149ad.webp"
"MediaSize" => 148345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-dbedd56bd85fef9c29cae0d2dbb149ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29947136_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/d512f1f2d405b81eede0ddb7ef82e63a.webp"
"MediaSize" => 190607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-d512f1f2d405b81eede0ddb7ef82e63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29947136_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/da23a4d227ed48f9e2b81a3281285ff4.webp"
"MediaSize" => 175218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-da23a4d227ed48f9e2b81a3281285ff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29947136_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/e912c5c1c1167e44eb6eb34416b4da9a.webp"
"MediaSize" => 122057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-e912c5c1c1167e44eb6eb34416b4da9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29947136_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/51fe03e50dbed045034165142634983f.webp"
"MediaSize" => 82202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-51fe03e50dbed045034165142634983f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29947136_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/7f86103e0ad6418c2e7c971e47293444.webp"
"MediaSize" => 94672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-7f86103e0ad6418c2e7c971e47293444.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29947136_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/f52433fee0e43223e792ba18b93010ca.webp"
"MediaSize" => 92987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-f52433fee0e43223e792ba18b93010ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29947136_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/c5ae8aa71164bc75e89b833167077dc1.webp"
"MediaSize" => 85015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-c5ae8aa71164bc75e89b833167077dc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29947136_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/ec779fe4b155f248a2253a01f5767a32.webp"
"MediaSize" => 94406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-ec779fe4b155f248a2253a01f5767a32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29947136_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/1a3543d5c65c714befebe5c5d67d746e.webp"
"MediaSize" => 72077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-1a3543d5c65c714befebe5c5d67d746e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29947136_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/51f4642b924e8d50219cb4f0e55f487f.webp"
"MediaSize" => 84566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-51f4642b924e8d50219cb4f0e55f487f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29947136_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/b498279ae9de3c3c99d880aba31f3636.webp"
"MediaSize" => 84049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-b498279ae9de3c3c99d880aba31f3636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29947136_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/09a78f3adbcf5d0bfd968302f83281ed.webp"
"MediaSize" => 71635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-09a78f3adbcf5d0bfd968302f83281ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29947136_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/0ea523b897b931ae6e2b059337217d77.webp"
"MediaSize" => 63465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-0ea523b897b931ae6e2b059337217d77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29947136_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/5480536878eaf06be695f567982c6e96.webp"
"MediaSize" => 91543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-5480536878eaf06be695f567982c6e96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29947136_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/80e15ea9db1a1b0eb79937ae3e519884.webp"
"MediaSize" => 37087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-80e15ea9db1a1b0eb79937ae3e519884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29947136_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/4490e6678aff6549fe5b1dbb763bccce.webp"
"MediaSize" => 85166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-4490e6678aff6549fe5b1dbb763bccce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29947136_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/93037e9d937427245886df504b1fb9bd.webp"
"MediaSize" => 58796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-93037e9d937427245886df504b1fb9bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29947136_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/a9bd731948e7097b410a660342561a3b.webp"
"MediaSize" => 82443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-a9bd731948e7097b410a660342561a3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29947136_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/3f6cdf0571ed849c000eab4b4b68d220.webp"
"MediaSize" => 78907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-3f6cdf0571ed849c000eab4b4b68d220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29947136_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/5db4e2beff55d37ca607dc597a300d97.webp"
"MediaSize" => 78504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-5db4e2beff55d37ca607dc597a300d97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29947136_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/7ba0cd8b6e9b78fba47192cc4fdab041.webp"
"MediaSize" => 100802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-7ba0cd8b6e9b78fba47192cc4fdab041.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29947136_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/87696a702e83039ea62b5cf9f97c2555.webp"
"MediaSize" => 88164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-87696a702e83039ea62b5cf9f97c2555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29947136_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/bf4ab1d62f3880597eda1c0b0aa98552.webp"
"MediaSize" => 86996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-bf4ab1d62f3880597eda1c0b0aa98552.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29947136_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/34c5d2a5fea6317babb22e3bb712854c.webp"
"MediaSize" => 148941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-34c5d2a5fea6317babb22e3bb712854c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29947136_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/f1235e32efcc005fb65e7f5ef561e539.webp"
"MediaSize" => 160017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-f1235e32efcc005fb65e7f5ef561e539.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29947136_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/9543f76f5edc8faeb530fe84549e51ba.webp"
"MediaSize" => 138304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-9543f76f5edc8faeb530fe84549e51ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29947136_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/671e9a300acb25a199af8b6f5bdd2602.webp"
"MediaSize" => 172147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-671e9a300acb25a199af8b6f5bdd2602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29947136_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/82ba64da00183d2c0762d77e07880b1b.webp"
"MediaSize" => 127793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-82ba64da00183d2c0762d77e07880b1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29947136_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/0a10baf0792280f0fde050de0f8960a3.webp"
"MediaSize" => 148345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-0a10baf0792280f0fde050de0f8960a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29947136_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/899d72a0c9ff33627cc76af1ad9af4d5.webp"
"MediaSize" => 192332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-899d72a0c9ff33627cc76af1ad9af4d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29947136_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/2ecd493250d2cb1c9cf542168ba6558b.webp"
"MediaSize" => 212954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-2ecd493250d2cb1c9cf542168ba6558b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29947136_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/d1ae248de27acb56ef12713d1773aa50.webp"
"MediaSize" => 197068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-d1ae248de27acb56ef12713d1773aa50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29947136_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/4546b196900a2a919048f5659db2763f.webp"
"MediaSize" => 202977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-4546b196900a2a919048f5659db2763f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29947136_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/af84db760f19aac45b13af4e0626c52b.webp"
"MediaSize" => 200627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-af84db760f19aac45b13af4e0626c52b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29947136_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/161dad99ac5496644a2d61b333dc4621.webp"
"MediaSize" => 163206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-161dad99ac5496644a2d61b333dc4621.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29947136_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947136/c9288036f04dbe0652ad95870b66718d.webp"
"MediaSize" => 153429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947136/thumbnail-c9288036f04dbe0652ad95870b66718d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842653"
"ResourceRecordKey" => "29947136"
"ModificationTimestamp" => "2026-06-24T16:32:46.16Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947136')"
+"ID": "1566354"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1565496"
+post_author: 1
+"ListingKey": "29953944"
+"ListingId": "X13489818"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:30:14Z"
+"RFModificationTimestamp": "2026-06-26T01:34:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1036.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L1J1"
+"UnparsedAddress": "486 JAMES STREET N, Hamilton (North End), Ontario L8L1J1"
+"Coordinates": array:2 [
0 => -79.8631912
1 => 43.2692517
]
+"Latitude": 43.2692517
+"Longitude": -79.8631912
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An amazing opportunity to bring your business vision to one of Hamilton's most vibrant and sought-after corridors. Located at 486 James St. N, this turnkey space is ideal for a QSR, sit-down restaurant, café, coffee shop, or other creative food concept. Situated in the heart of James Street North, Hamilton's destination for independent restaurants, boutique shopping, galleries, and the arts, this location offers excellent exposure in a high-traffic, walkable neighbourhood. Just a short walk to West Harbour GO Station, Pier 4 Park, the Hamilton Harbour Waterfront Trail, and Pier 8, the area continues to see major growth and investment. With thousands of new condos, apartments, housing units, and a new retail boardwalk planned nearby, this is a rare chance to secure a highly visible location in a rapidly expanding waterfront district. Bring your concept to life in one of Hamilton's most exciting neighbourhoods. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-26T01:34:09.382224+00:00"
+"Directions": "Cross Streets: JAMES ST. N. & PICTON ST. E. ** Directions: JAMES ST. N., SOUTH OF PICTON, EAST SIDE."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128850"
+"ListOfficeKey": "286948"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Unit=23 x 45 FT"
+"PhotosChangeTimestamp": "2026-06-25T18:58:52Z"
+"PhotosCount": 10
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:21:25Z"
+"StreetDirSuffix": "North"
+"StreetName": "James"
+"StreetNumber": "486"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "806.3"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "North End"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953944/486-james-street-n-hamilton-north-end-north-end"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "G/S-276 - RETAIL"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 23.0
+"OriginalEntryTimestamp": "2026-06-25T18:58:51.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381962"
+"ListOfficeNationalAssociationId": "1365211"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29953944_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/ea6839c11686d68ccc48c1020af7c321.webp"
"MediaSize" => 474641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-ea6839c11686d68ccc48c1020af7c321.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29953944_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/a5d0756bf39faa71ac71fba4288827bd.webp"
"MediaSize" => 283690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-a5d0756bf39faa71ac71fba4288827bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29953944_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/6649f4e55a27a869cfba7aa0c4b94dbf.webp"
"MediaSize" => 309660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-6649f4e55a27a869cfba7aa0c4b94dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29953944_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/d53959c9a8002fa21cc40db1633980b6.webp"
"MediaSize" => 303692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-d53959c9a8002fa21cc40db1633980b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29953944_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/f137c1898301df1af6be933373f48c7f.webp"
"MediaSize" => 281064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-f137c1898301df1af6be933373f48c7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29953944_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/599387bd0197c200a06b8cb0f996c2d9.webp"
"MediaSize" => 253097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-599387bd0197c200a06b8cb0f996c2d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29953944_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/b5cdae34c522ade0fc36c59583e9398c.webp"
"MediaSize" => 250426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-b5cdae34c522ade0fc36c59583e9398c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29953944_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/2b8c02875b37e8e64f94f336f4b1c921.webp"
"MediaSize" => 221298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-2b8c02875b37e8e64f94f336f4b1c921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29953944_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/8b575cb5035157413ab46f5d4d98b2be.webp"
"MediaSize" => 230711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-8b575cb5035157413ab46f5d4d98b2be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29953944_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953944/fb08cf72c67e0afa9d5106d80e3dd4b1.webp"
"MediaSize" => 205379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953944/thumbnail-fb08cf72c67e0afa9d5106d80e3dd4b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13489818"
"ResourceRecordKey" => "29953944"
"ModificationTimestamp" => "2026-06-25T18:58:51.88Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953944')"
+"ID": "1565496"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1567461"
+post_author: 1
+"ListingKey": "29948037"
+"ListingId": "X13484598"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T18:25:07Z"
+"RFModificationTimestamp": "2026-06-26T01:21:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P3T1"
+"UnparsedAddress": "235 QUEEN STREET S, Hamilton (Durand), Ontario L8P3T1"
+"Coordinates": array:2 [
0 => -79.881586
1 => 43.25178
]
+"Latitude": 43.25178
+"Longitude": -79.881586
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Turn-key ground-floor office in Hamilton's Durand neighbourhood. Bright unit with high ceilings, private offices, boardroom, kitchenette, 2 baths, and private access from Queen St S and rear lot. Includes outdoor deck, up to 3 parking spaces, and a gross lease covering gas, taxes, insurance & maintenance. Hydro and water extra. Convenient to downtown, Hwy 403 & transit. (id:62783)"
+"BusinessType": "Other"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-26T01:21:17.192932+00:00"
+"Directions": "Corner of Queen Street South and Charlton Avenue West"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110196"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Unit=80 x 130 FT"
+"PhotosChangeTimestamp": "2026-06-24T18:15:55Z"
+"PhotosCount": 37
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:15:55Z"
+"StreetDirSuffix": "South"
+"StreetName": "QUEEN"
+"StreetNumber": "235"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Durand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948037/235-queen-street-s-hamilton-durand-durand"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Offices"
]
+"GeocodeManualYN": false
+"TotalActualRent": 2950
+"ZoningDescription": "DE-3"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-06-24T18:15:55.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1378837"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29948037_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/c7d16ceb51d6dfde06598f459300f52c.webp"
"MediaSize" => 395092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-c7d16ceb51d6dfde06598f459300f52c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29948037_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/f76fdf60e350151abfb2933918fba123.webp"
"MediaSize" => 487721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-f76fdf60e350151abfb2933918fba123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29948037_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/c57591babd9a0fca00a8a5053eda3281.webp"
"MediaSize" => 458571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-c57591babd9a0fca00a8a5053eda3281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29948037_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/ad1e0de28d501cb8be4701702f124698.webp"
"MediaSize" => 293523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-ad1e0de28d501cb8be4701702f124698.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29948037_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/012d1c175d1cfcc9c737578abf7f4bb9.webp"
"MediaSize" => 222231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-012d1c175d1cfcc9c737578abf7f4bb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29948037_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/38eebd1fd4a87fd1712ce760ab7d0455.webp"
"MediaSize" => 267936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-38eebd1fd4a87fd1712ce760ab7d0455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29948037_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/f6498f12a1192ee5b9659f1a1ef36942.webp"
"MediaSize" => 255147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-f6498f12a1192ee5b9659f1a1ef36942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29948037_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/539368ca8970b88a17e19c168de68c38.webp"
"MediaSize" => 230162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-539368ca8970b88a17e19c168de68c38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29948037_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/c6cafd0fa5436550be936ba7dc198b90.webp"
"MediaSize" => 251478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-c6cafd0fa5436550be936ba7dc198b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29948037_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/52f480cbe2a450e942550580809da61b.webp"
"MediaSize" => 182759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-52f480cbe2a450e942550580809da61b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29948037_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/fae1c0403d41c6cc0cd6a4d8c7b9eb41.webp"
"MediaSize" => 231771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-fae1c0403d41c6cc0cd6a4d8c7b9eb41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29948037_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/f087be85c93e8c70f86b4be8859f80b8.webp"
"MediaSize" => 216732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-f087be85c93e8c70f86b4be8859f80b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29948037_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/81e8fdb9eac1e50f433e8c8304dbd9f2.webp"
"MediaSize" => 205531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-81e8fdb9eac1e50f433e8c8304dbd9f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948037')"
+"ID": "1567461"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1561949"
+post_author: 1
+"ListingKey": "29951782"
+"ListingId": "40842829"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:15Z"
+"RFModificationTimestamp": "2026-06-25T20:02:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 435.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R1A2"
+"UnparsedAddress": "41 KING WILLIAM Street Unit# 205, Hamilton, Ontario L8R1A2"
+"Coordinates": array:2 [
0 => -79.8670915
1 => 43.2572705
]
+"Latitude": 43.2572705
+"Longitude": -79.8670915
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An exceptional turnkey office opportunity in the highly sought-after Empire Times building, ideally situated in the heart of the King William restaurant district. Surrounded by vibrant new developments and renowned local destinations, including The Mule, The French, The Diplomat, Conversate, and Undefined, this prime location offers outstanding visibility and an unmatched urban atmosphere. Through the thoughtful integration of two historic buildings, owner and developer Core Urban has created one of Hamilton's leading hubs for professional and hospitality spaces. This signature location offers immediate access to the newly-renovated TD Coliseum, restaurants, financial institutions, courthouses, public transit, and a wide array of downtown amenities. Available today in one of Hamilton's most distinguished commercial buildings. Note: furniture shown in photography belongs to existing tenant and not available for use. Square footage provided by landlord. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-25T20:02:41.459657+00:00"
+"Directions": "NE corner of King William St & Hughson St N"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005524"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Visual exposure"
1 => "Elevator"
2 => "Passenger elevator"
]
+"PhotosChangeTimestamp": "2026-06-25T15:50:45Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:45Z"
+"Stories": "4.0"
+"StreetName": "KING WILLIAM"
+"StreetNumber": "41"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951782/41-king-william-street-unit-205-hamilton"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "2235636"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300344"
+"GeocodeManualYN": true
+"TotalActualRent": 950
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D2 - Downtown Mixed Use - Pedestrian Focus"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"OriginalEntryTimestamp": "2026-06-25T15:50:45.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287890"
+"ListOfficeNationalAssociationId": "1486985"
+"CoListAgentNationalAssociationId": "1473518"
+"CoListOfficeNationalAssociationId": "1486985"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951782')"
+"ID": "1561949"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1561950"
+post_author: 1
+"ListingKey": "29951784"
+"ListingId": "40842802"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:15Z"
+"RFModificationTimestamp": "2026-06-25T20:02:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 790.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R1A2"
+"UnparsedAddress": "41 KING WILLIAM Street Unit# 204, Hamilton, Ontario L8R1A2"
+"Coordinates": array:2 [
0 => -79.8671712
1 => 43.2572865
]
+"Latitude": 43.2572865
+"Longitude": -79.8671712
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An exceptional turnkey office opportunity in the highly sought-after Empire Times building, ideally situated in the heart of the King William restaurant district. Surrounded by vibrant new developments and renowned local destinations, including The Mule, The French, The Diplomat, Conversate, and Undefined, this prime location offers outstanding visibility and an unmatched urban atmosphere. Through the thoughtful integration of two historic buildings, owner and developer Core Urban has created one of Hamilton's leading hubs for professional and hospitality spaces. This signature location offers immediate access to the newly-renovated TD Coliseum, restaurants, financial institutions, courthouses, public transit, and a wide array of downtown amenities. Available today in one of Hamilton's most distinguished commercial buildings. Note: furniture shown in photography belongs to existing tenant and not available for use. Square footage provided by landlord. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-25T20:02:18.855392+00:00"
+"Directions": "NE corner of King William St & Hughson St N"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005524"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Visual exposure"
1 => "Elevator"
2 => "Passenger elevator"
]
+"PhotosChangeTimestamp": "2026-06-25T15:50:46Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:46Z"
+"Stories": "4.0"
+"StreetName": "KING WILLIAM"
+"StreetNumber": "41"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951784/41-king-william-street-unit-204-hamilton"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "2235636"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300344"
+"GeocodeManualYN": true
+"TotalActualRent": 1500
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D2 - Downtown Mixed Use - Pedestrian Focus"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"OriginalEntryTimestamp": "2026-06-25T15:50:46.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287890"
+"ListOfficeNationalAssociationId": "1486985"
+"CoListAgentNationalAssociationId": "1473518"
+"CoListOfficeNationalAssociationId": "1486985"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951784')"
+"ID": "1561950"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1561951"
+post_author: 1
+"ListingKey": "29952258"
+"ListingId": "40843018"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:20:07Z"
+"RFModificationTimestamp": "2026-06-25T19:47:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1036.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L1J1"
+"UnparsedAddress": "486 N JAMES Street N, Hamilton, Ontario L8L1J1"
+"Coordinates": array:2 [
0 => -79.8631283
1 => 43.2695069
]
+"Latitude": 43.2695069
+"Longitude": -79.8631283
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An amazing opportunity to bring your business vision to one of Hamilton’s most vibrant and sought-after corridors. Located at 486 James St. N, this turnkey space is ideal for a QSR, sit-down restaurant, café, coffee shop, or other creative food concept. Situated in the heart of James Street North, Hamilton’s destination for independent restaurants, boutique shopping, galleries, and the arts, this location offers excellent exposure in a high-traffic, walkable neighbourhood. Just a short walk to West Harbour GO Station, Pier 4 Park, the Hamilton Harbour Waterfront Trail, and Pier 8, the area continues to see major growth and investment. With thousands of new condos, apartments, housing units, and a new retail boardwalk planned nearby, this is a rare chance to secure a highly visible location in a rapidly expanding waterfront district. Bring your concept to life in one of Hamilton’s most exciting neighbourhoods. (id:62650)"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-25T19:20:14.992600+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529036"
+"ListOfficeKey": "289605"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T17:11:51Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:10:55Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "JAMES"
+"StreetNumber": "486"
+"StreetSuffix": "Street"
+"SubdivisionName": "100 - North End West"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29952258/486-james-street-n-hamilton"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "1524923"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54876"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "G/S - 276"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.0
+"OriginalEntryTimestamp": "2026-06-25T17:11:50.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140665"
+"ListOfficeNationalAssociationId": "1379433"
+"CoListAgentNationalAssociationId": "1063150"
+"CoListOfficeNationalAssociationId": "1003493"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952258')"
+"ID": "1561951"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1561197"
+post_author: 1
+"ListingKey": "29952589"
+"ListingId": "X13489416"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T17:45:10Z"
+"RFModificationTimestamp": "2026-06-25T18:35:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 790.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Beasley)"
+"PostalCode": "L8R1A2"
+"UnparsedAddress": "204 - 41 KING WILLIAM STREET, Hamilton (Beasley), Ontario L8R1A2"
+"Coordinates": array:2 [
0 => -79.867164
1 => 43.257267
]
+"Latitude": 43.257267
+"Longitude": -79.867164
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "An exceptional turnkey office opportunity in the highly sought-after Empire Times building, ideally situated in the heart of the King William restaurant district. Surrounded by vibrant new developments and renowned local destinations, including The Mule, The French, The Diplomat, Conversate, and Undefined, this prime location offers outstanding visibility and an unmatched urban atmosphere. Through the thoughtful integration of two historic buildings, owner and developer Core Urban has created one of Hamilton's leading hubs for professional and hospitality spaces. This signature location offers immediate access to the newly-renovated TD Coliseum, restaurants, financial institutions, courthouses, public transit, and a wide array of downtown amenities. Available today in one of Hamilton's most distinguished commercial buildings. Note: furniture shown in photography belongs to existing tenant and not available for use. Square footage provided by landlord. (id:62650)"
+"BusinessType": "Other"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-25T18:34:59.592099+00:00"
+"Directions": "Cross Streets: King William St & Hughson St N. ** Directions: NE corner of King William St & Hughson St N."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Elevator"
]
+"PhotosChangeTimestamp": "2026-06-25T17:42:28Z"
+"PhotosCount": 10
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T17:42:28Z"
+"StreetName": "KING WILLIAM"
+"StreetNumber": "41"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "300"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Beasley"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29952589/204-41-king-william-street-hamilton-beasley-beasley"
+"StructureType": array:1 [
0 => "Offices"
]
+"GeocodeManualYN": false
+"TotalActualRent": 1500
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D2 - Downtown Mixed Use - Pedestrian Focus"
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-25T17:36:32.8Z"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952589')"
+"ID": "1561197"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 66
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]