array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29935970 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23091
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23093
+post_id: "1556294"
+post_author: 1
+"ListingKey": "29935970"
+"ListingId": "40841854"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Industrial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T15:40:13Z"
+"RFModificationTimestamp": "2026-06-22T16:45:53Z"
+"ListPrice": 13.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 2.0
+"LivingArea": 10178.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P2B6"
+"UnparsedAddress": "144 CHATHAM Street Unit# 2A, Hamilton, Ontario L8P2B6"
+"Coordinates": array:2 [
0 => -79.8943387
1 => 43.2566501
]
+"Latitude": 43.2566501
+"Longitude": -79.8943387
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 144 Chatham! This stunning 10,000 SF second-floor space is loaded with industrial charm and a landlord that is ready to work with a visionary tenant. Located in the Frid/Chatham business park among such reputable neighbours as Soccer World, Gravity Climbing Gym, Steel Town Cider, Mel's Deli, and Alchemy Fitness, this location is well-positioned for your business's next venture. Includes abundant natural lighting, high ceilings, on-site parking, and a landlord that is prepared to invest in the premises, including new HVAC, bathrooms, and more. Ideally situated for Highway 403 and HSR transit access. Available as both 10,000 SF and 5,000 SF options. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-06-22T16:45:41.478386+00:00"
+"Directions": "Dundurn to Chatham"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005524"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "2"
+"PhotosChangeTimestamp": "2026-06-22T15:32:04Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T15:32:04Z"
+"Stories": "3.0"
+"StreetName": "CHATHAM"
+"StreetNumber": "144"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Kirkendall West"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935970/144-chatham-street-unit-2a-hamilton"
+"LeaseAmount": 13
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "2235636"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300344"
+"GeocodeManualYN": true
+"ZoningDescription": "M1 - Research & Development"
+"FrontageLengthNumeric": 514.0
+"OriginalEntryTimestamp": "2026-06-22T15:32:04.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287890"
+"ListOfficeNationalAssociationId": "1486985"
+"CoListAgentNationalAssociationId": "1473518"
+"CoListOfficeNationalAssociationId": "1486985"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935970_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/1fabd611a99a4d0a07e1d703294d8a27.webp"
"MediaSize" => 116412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-1fabd611a99a4d0a07e1d703294d8a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935970_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/2cea4450acbe5b5a1961c2c8b4f62e80.webp"
"MediaSize" => 130559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-2cea4450acbe5b5a1961c2c8b4f62e80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935970_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/ed7ad260c2c5a7387c8deaada299ebbe.webp"
"MediaSize" => 84872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-ed7ad260c2c5a7387c8deaada299ebbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935970_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/bcb44a9ede4643ca7d71b8596ce65624.webp"
"MediaSize" => 130652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-bcb44a9ede4643ca7d71b8596ce65624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935970_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/82c8f15363707ff56436bcee95d63902.webp"
"MediaSize" => 139925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-82c8f15363707ff56436bcee95d63902.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935970_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/0f9e6d9d33791ec7be747069b8ad1f93.webp"
"MediaSize" => 139074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-0f9e6d9d33791ec7be747069b8ad1f93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935970_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/688cd816861e8389c08c90a79de9401c.webp"
"MediaSize" => 134297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-688cd816861e8389c08c90a79de9401c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935970_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/19813eb21167e8c1c7764b388fd113ba.webp"
"MediaSize" => 138639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-19813eb21167e8c1c7764b388fd113ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935970_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/270e3ae131a817157b369acaf2c9a416.webp"
"MediaSize" => 137693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-270e3ae131a817157b369acaf2c9a416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935970_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/3892fafa395b67bfa5429de5d55c809e.webp"
"MediaSize" => 136337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-3892fafa395b67bfa5429de5d55c809e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935970_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/2e488a5e41d7c009c6b784d46b6e5935.webp"
"MediaSize" => 149400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-2e488a5e41d7c009c6b784d46b6e5935.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935970_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/9093cece3076d23e6bf2c2eb60136b9e.webp"
"MediaSize" => 159416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-9093cece3076d23e6bf2c2eb60136b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935970_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/8224cabc6ac9d3ad810d5c1e0d823d59.webp"
"MediaSize" => 139684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-8224cabc6ac9d3ad810d5c1e0d823d59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935970_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/eaa35b8ef265fcef5072f24f8405b9b3.webp"
"MediaSize" => 133564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-eaa35b8ef265fcef5072f24f8405b9b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935970_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/1da8a3db25656444b2b344899419b1cd.webp"
"MediaSize" => 127537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-1da8a3db25656444b2b344899419b1cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935970_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/54451a64a58d64a0b7e92decbdf65b11.webp"
"MediaSize" => 131875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-54451a64a58d64a0b7e92decbdf65b11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935970_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/72c8bcf7f6b606aa0a5101498a3a311a.webp"
"MediaSize" => 129408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-72c8bcf7f6b606aa0a5101498a3a311a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935970_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/a4374723b4c90cd49d953c6f3735578c.webp"
"MediaSize" => 140759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-a4374723b4c90cd49d953c6f3735578c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935970_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/88b9efe9b9e5e6a0a6b03155be69a5e1.webp"
"MediaSize" => 140763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-88b9efe9b9e5e6a0a6b03155be69a5e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935970_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/a734571d565421f69f4bb3040185c769.webp"
"MediaSize" => 108973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-a734571d565421f69f4bb3040185c769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935970_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/77e039eaf3bed1218c10e4fbffbe6f03.webp"
"MediaSize" => 127749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-77e039eaf3bed1218c10e4fbffbe6f03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29935970_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/1c94f814deafc91bdc118b03e695cc36.webp"
"MediaSize" => 64764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-1c94f814deafc91bdc118b03e695cc36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29935970_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/5b51361764ba0c8f6578684c56f972c9.webp"
"MediaSize" => 128999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-5b51361764ba0c8f6578684c56f972c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29935970_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/39c63e164c04caaa68395102ef938423.webp"
"MediaSize" => 115327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-39c63e164c04caaa68395102ef938423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29935970_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/3f4eaddfa738d76ff3142fe475d32ef2.webp"
"MediaSize" => 114634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-3f4eaddfa738d76ff3142fe475d32ef2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29935970_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/82504cbaba9bb2e8a23fce0e69432a7f.webp"
"MediaSize" => 123771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-82504cbaba9bb2e8a23fce0e69432a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29935970_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/65464bf15835201500ca9f76232253ce.webp"
"MediaSize" => 149386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-65464bf15835201500ca9f76232253ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29935970_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/c9e76e31e41551f67a0e4a24f685b69e.webp"
"MediaSize" => 84919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-c9e76e31e41551f67a0e4a24f685b69e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29935970_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/5613d8d17e836be50e0edf93e27d0f51.webp"
"MediaSize" => 88060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-5613d8d17e836be50e0edf93e27d0f51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29935970_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/e7f4378f224ab7aa748cd91d6a46b060.webp"
"MediaSize" => 128169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-e7f4378f224ab7aa748cd91d6a46b060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29935970_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/f0055602eeb55969feb90de52d768eea.webp"
"MediaSize" => 156692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-f0055602eeb55969feb90de52d768eea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29935970_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935970/e3d1de6b25adb49c7ae4e67c8e772741.webp"
"MediaSize" => 134576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935970/thumbnail-e3d1de6b25adb49c7ae4e67c8e772741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841854"
"ResourceRecordKey" => "29935970"
"ModificationTimestamp" => "2026-06-22T15:32:04.47Z"
]
]
+"DaysOnMarket": 29
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935970')"
+"ID": "1556294"
}
]
+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=OfficeKey eq 300344" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24563
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24479
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Corcoran Horizon Realty"
+"OfficeEmail": null
+"OfficePhone": "647-873-3999"
+"OfficeMlsId": "HBCORCORANHR"
+"ModificationTimestamp": "2026-04-13T14:34:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "300344"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "183 James St South Unit 1"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Hamilton"
+"OfficePostalCode": "L8P3A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1486985"
+"OriginalEntryTimestamp": "2025-08-13T17:51:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1473518"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('300344')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2005524" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24507
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29935970'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24867
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29935970' AND OpenHouseDate ge '2026-07-20'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24883
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29935970' 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.8943387 43.2566501)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24956
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24949
+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": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967538')"
+"ID": "1576512"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24952
+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": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947136')"
+"ID": "1566354"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24929
+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"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29948037_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/dc2af426e28ca13cdad78a91c031e1df.webp"
"MediaSize" => 166536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-dc2af426e28ca13cdad78a91c031e1df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29948037_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/9ffaec8719c9c46d1083663ab8afcfac.webp"
"MediaSize" => 249494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-9ffaec8719c9c46d1083663ab8afcfac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29948037_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/2f4584545fb0f8cd10c13a683064ce87.webp"
"MediaSize" => 88646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-2f4584545fb0f8cd10c13a683064ce87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29948037_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/7e8516807ca122205fb99a7787d71ee9.webp"
"MediaSize" => 228309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-7e8516807ca122205fb99a7787d71ee9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29948037_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/3c614850b76e403b08607a81cf913666.webp"
"MediaSize" => 155573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-3c614850b76e403b08607a81cf913666.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29948037_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/2ccaff2293ec9f3ae26375000abb109d.webp"
"MediaSize" => 202233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-2ccaff2293ec9f3ae26375000abb109d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29948037_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/8a5d636148301f22bd3e972faaca14a4.webp"
"MediaSize" => 194201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-8a5d636148301f22bd3e972faaca14a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29948037_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/dd9dde04d8d2cef8f885eefdba076c46.webp"
"MediaSize" => 190667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-dd9dde04d8d2cef8f885eefdba076c46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29948037_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/16c4988e6a2786abf8bde38235d4ec36.webp"
"MediaSize" => 257119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-16c4988e6a2786abf8bde38235d4ec36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29948037_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/5877b23e98188b367d07b6887fc0c520.webp"
"MediaSize" => 208347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-5877b23e98188b367d07b6887fc0c520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29948037_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/7f634be5fc0072629c6a6713b9f6d24e.webp"
"MediaSize" => 210222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-7f634be5fc0072629c6a6713b9f6d24e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29948037_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/c33ffd3226eeee61ad9e699033ce99cc.webp"
"MediaSize" => 361201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-c33ffd3226eeee61ad9e699033ce99cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
"ModificationTimestamp" => "2026-06-24T18:15:55.02Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29948037_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29948037/9a49ba717b33c164e621c9f830abf036.webp"
"MediaSize" => 419929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29948037/thumbnail-9a49ba717b33c164e621c9f830abf036.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13484598"
"ResourceRecordKey" => "29948037"
…1
]
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": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948037')"
+"ID": "1567461"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24953
+post_id: "1556293"
+post_author: 1
+"ListingKey": "29936202"
+"ListingId": "X13474054"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Industrial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:00:12Z"
+"RFModificationTimestamp": "2026-06-23T14:05:35Z"
+"ListPrice": 13.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 10178.0
+"LivingArea": 10178.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Kirkendall)"
+"PostalCode": "L8P2B6"
+"UnparsedAddress": "2A - 144 CHATHAM STREET, Hamilton (Kirkendall), Ontario L8P2B6"
+"Coordinates": array:2 [
0 => -79.894653
1 => 43.256546
]
+"Latitude": 43.256546
+"Longitude": -79.894653
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 144 Chatham! This stunning 10,000 SF second-floor space is loaded with industrial charm and a landlord that is ready to work with a visionary tenant. Located in the Frid/Chatham business park among such reputable neighbours as Soccer World, Gravity Climbing Gym, Steel Town Cider, Mel's Deli, and Alchemy Fitness, this location is well-positioned for your business's next venture. Includes abundant natural lighting, high ceilings, on-site parking, and a landlord that is prepared to invest in the premises, including new HVAC, bathrooms, and more. Ideally situated for Highway 403 and HSR transit access. Available as both 10,000 SF and 5,000 SF options. (id:62650)"
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-22T17:20:17.126144+00:00"
+"Directions": "Cross Streets: Frid & Chatham. ** Directions: At the corner of Frid and Chatham, accessible via Main Street or Dundurn Street."
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "10178"
+"PhotosChangeTimestamp": "2026-06-23T13:53:04Z"
+"PhotosCount": 32
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T13:53:04Z"
+"StreetName": "Chatham"
+"StreetNumber": "144"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Kirkendall"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29936202/2a-144-chatham-street-hamilton-kirkendall-kirkendall"
+"LeaseAmount": 13
+"LeasePerUnit": "square feet"
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "M1 - Research & Development"
+"FrontageLengthNumeric": 514.5
+"OriginalEntryTimestamp": "2026-06-22T15:56:16.47Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 29
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936202')"
+"ID": "1556293"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24951
+post_id: "1546029"
+post_author: 1
+"ListingKey": "29925511"
+"ListingId": "X13464200"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:05:39Z"
+"RFModificationTimestamp": "2026-06-19T15:10:41Z"
+"ListPrice": 24.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 8171.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Central)"
+"PostalCode": "L8P1H8"
+"UnparsedAddress": "1 LL - 150 MAIN STREET W, Hamilton (Central), Ontario L8P1H8"
+"Coordinates": array:2 [
0 => -79.875982
1 => 43.25715
]
+"Latitude": 43.25715
+"Longitude": -79.875982
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional leasing opportunity in the heart of Downtown Hamilton. Located at 150 Main Street West, this spacious lower-level commercial unit offers excellent potential for a variety of professional and service-based businesses. Currently operating as a physiotherapy clinic, the space is fully turnkey and well-suited for healthcare practitioners, wellness services, counselling, massage therapy, chiropractic care, personal services, or other synergistic business uses. The functional layout provides flexibility to accommodate a range of operational needs while offering a comfortable and professional environment for clients and staff alike. Benefit from ample on-site parking for both staff and clients, a rare advantage in the downtown core. The space is also located within an established and successful medical clinic featuring family medicine, orthopedic surgery, and pain management physicians on-site, creating excellent opportunities for complementary healthcare and wellness professionals. Situated in a high-traffic downtown location with convenient access to public transit, major roadways, nearby amenities, and a growing residential and commercial population, this is an ideal opportunity to establish or expand your business in one of Hamilton's most vibrant urban corridors. Bring your vision and take advantage of this versatile, move-in-ready space in a prime downtown location. (id:62650)"
+"BusinessType": "Other"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-18T22:48:44.428904+00:00"
+"Directions": "Caroline Street South & Main Street West"
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T21:59:14Z"
+"PhotosCount": 46
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T14:33:20Z"
+"StreetDirSuffix": "West"
+"StreetName": "Main"
+"StreetNumber": "150"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Central"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925511/1-ll-150-main-street-w-hamilton-central-central"
+"LeaseAmount": 24
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Offices"
]
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D3"
+"OriginalEntryTimestamp": "2026-06-18T21:59:14.29Z"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 32
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925511')"
+"ID": "1546029"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24926
+post_id: "1486592"
+post_author: 1
+"ListingKey": "29842075"
+"ListingId": "X13230092"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T20:05:57Z"
+"RFModificationTimestamp": "2026-06-02T20:23:21Z"
+"ListPrice": 15.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2048.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P4V1"
+"UnparsedAddress": "200 - 180 JAMES STREET S, Hamilton (Durand), Ontario L8P4V1"
+"Coordinates": array:2 [
0 => -79.871696
1 => 43.25139
]
+"Latitude": 43.25139
+"Longitude": -79.871696
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Turn-key professional office space in Hamilton's sought-after Durand neighbourhood, prominently located on James Street South. Surrounded by new residential developments, established office buildings, and a strong mix of restaurants and cafés, this location offers excellent exposure and everyday convenience for both staff and clients. Just one block from St. Joseph's Hospital and minutes to the heart of Downtown Hamilton. Public transit is at your doorstep, with the GO Station only two blocks away. Recently renovated common areas throughout the building. Occupancy costs are structured through a TI model of $4.20/SqFt, providing tenants with greater stability and predictability in annual operating expenses. (id:62783)"
+"BusinessType": "Other"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-02T20:23:14.681669+00:00"
+"Directions": "Cross Streets: Duke St & James St S. ** Directions: Southwest corner of James Street South and Duke Street."
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2030610"
+"ListOfficeKey": "205041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Elevator"
]
+"LotSizeDimensions": "197.12 x 90.2 FT"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-02T19:56:45Z"
+"PhotosCount": 20
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T19:56:45Z"
+"StreetDirSuffix": "South"
+"StreetName": "James"
+"StreetNumber": "180"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4.2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Durand"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29842075/200-180-james-street-s-hamilton-durand-durand"
+"LeaseAmount": 15
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "1980564"
+"CoListOfficeKey": "205041"
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "D1"
+"FrontageLengthNumeric": 197.1
+"OriginalEntryTimestamp": "2026-06-02T19:56:45.58Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1308184"
+"ListOfficeNationalAssociationId": "1192170"
+"CoListAgentNationalAssociationId": "1266246"
+"CoListOfficeNationalAssociationId": "1192170"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 48
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29842075')"
+"ID": "1486592"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23105
+post_id: "1455408"
+post_author: 1
+"ListingKey": "29481280"
+"ListingId": "X12892042"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Industrial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-25T00:00:55Z"
+"RFModificationTimestamp": "2026-05-25T00:01:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 26900.0
+"LivingArea": 26900.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Strathcona)"
+"PostalCode": "L8R3N6"
+"UnparsedAddress": "243 QUEEN STREET N, Hamilton (Strathcona), Ontario L8R3N6"
+"Coordinates": array:2 [
0 => -79.8760408
1 => 43.2674568
]
+"Latitude": 43.2674568
+"Longitude": -79.8760408
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic industrial space right of the 403 with oversized drive in doors and 25 ton crane. Clear height well over 20ft and immediate possession available. Ideal for short/long term storage or manufacturing. TMI is $4.50 for 2026. Minimum term 12 months. (id:62650)"
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-25T00:01:03.435833+00:00"
+"Directions": "Cross Streets: Barton St W. ** Directions: Turn Off Barton onto Queen."
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092503"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "26900"
+"PhotosChangeTimestamp": "2026-03-17T18:15:44Z"
+"PhotosCount": 4
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T23:47:58Z"
+"StreetDirSuffix": "North"
+"StreetName": "Queen"
+"StreetNumber": "243"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "190000"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Strathcona"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29481280/243-queen-street-n-hamilton-strathcona-strathcona"
+"ParkingTotal": 200
+"StructureType": array:1 [
0 => "Multi-Tenant Industrial"
]
+"GeocodeManualYN": true
+"TotalActualRent": 9
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "Industrial"
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-03-17T18:15:44.84Z"
+"ListAgentNationalAssociationId": "1365212"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"DaysOnMarket": 125
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29481280')"
+"ID": "1455408"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24954
+post_id: "1418046"
+post_author: 1
+"ListingKey": "29746369"
+"ListingId": "X13123172"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T23:26:08Z"
+"RFModificationTimestamp": "2026-05-24T23:42:58Z"
+"ListPrice": 31.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 2363.0
+"LivingArea": 2363.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P1X1"
+"UnparsedAddress": "14 DUKE STREET, Hamilton (Durand), Ontario L8P1X1"
+"Coordinates": array:2 [
0 => -79.8718887
1 => 43.2519766
]
+"Latitude": 43.2519766
+"Longitude": -79.8718887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Turnkey medical clinic available for sublease! Existing headlease runs until August 2030. Fully equipped and ready for immediate practice. Ideal for medical or paramedical users such as RMT, physio, dentist, or cosmetic surgery. Includes surgery-approved suite (formerly operated by plastic surgeon), available for recertification for clinical use. Complete medical equipment includes exam tables, instrument trays, suture kits, bandages, chairs and more. Walk in Monday, see patients Monday! Physical elements of the complex include wheelchair ramp for accessible ground floor entry and 12 on-site parking spaces downtown - a rarity in Hamilton's medical corridor. Being 450 metres from St. Joseph's Hospital, 220 metres from Hamilton GO Station, 440 metres from Hamilton City Hall, and 400 metres from the core of the city's King and James intersections, the property is immediately accessible to and from many of Hamilton's major nexus points of healthcare, commerce, and civic government. With the property's ample parking, downtown walkability, and proximity to numerous transit stops and Frank Cooke Transit Terminal, the property is immediately accessible for all users, whether pedestrians, drivers, or transit-riders. Fully equipped with Fibre optic, backup generator, full security system, video surveillance ready for a new user. Note purchase opportunity also available for entire building with established income streams. (id:62650)"
+"BusinessType": "Personal Services"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-13T19:26:03.140872+00:00"
+"Directions": "Cross Streets: Duke St & James St S. ** Directions: Located on Duke Street just west of James Street South."
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "2363"
+"PhotosChangeTimestamp": "2026-05-13T17:25:40Z"
+"PhotosCount": 27
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T23:17:10Z"
+"StreetName": "Duke"
+"StreetNumber": "14"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/14dukestl8p1x1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Durand"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29746369/14-duke-street-hamilton-durand-durand"
+"LeaseAmount": 31
+"LeasePerUnit": "square feet"
+"ParkingTotal": 12
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "E-1/S-704"
+"FrontageLengthNumeric": 49.9
+"OriginalEntryTimestamp": "2026-05-13T17:25:40.14Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 68
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29746369')"
+"ID": "1418046"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24955
+post_id: "1418047"
+post_author: 1
+"ListingKey": "29746053"
+"ListingId": "X13122802"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T23:26:08Z"
+"RFModificationTimestamp": "2026-05-24T23:42:58Z"
+"ListPrice": 31.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 2363.0
+"LivingArea": 2363.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P1X1"
+"UnparsedAddress": "14 DUKE STREET, Hamilton (Durand), Ontario L8P1X1"
+"Coordinates": array:2 [
0 => -79.8718887
1 => 43.2519766
]
+"Latitude": 43.2519766
+"Longitude": -79.8718887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Turnkey medical clinic available for sublease! Existing headlease runs until August 2030. Fully equipped and ready for immediate practice. Ideal for medical or paramedical users such as RMT, physio, dentist, or cosmetic surgery. Includes surgery-approved suite (formerly operated by plastic surgeon), available for recertification for clinical use. Complete medical equipment includes exam tables, instrument trays, suture kits, bandages, chairs and more. Walk in Monday, see patients Monday! Physical elements of the complex include wheelchair ramp for accessible ground floor entry and 12 on-site parking spaces downtown - a rarity in Hamilton's medical corridor. Being 450 metres from St. Joseph's Hospital, 220 metres from Hamilton GO Station, 440 metres from Hamilton City Hall, and 400 metres from the core of the city's King and James intersections, the property is immediately accessible to and from many of Hamilton's major nexus points of healthcare, commerce, and civic government. With the property's ample parking, downtown walkability, and proximity to numerous transit stops and Frank Cooke Transit Terminal, the property is immediately accessible for all users, whether pedestrians, drivers, or transit-riders. Fully equipped with Fibre optic, backup generator, full security system, video surveillance ready for a new user. Note purchase opportunity also available for entire building with established income streams. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-13T19:24:43.012660+00:00"
+"Directions": "Cross Streets: Duke St & James St S. ** Directions: Located on Duke Street just west of James Street South."
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "2363"
+"PhotosChangeTimestamp": "2026-05-13T16:56:13Z"
+"PhotosCount": 27
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T23:17:09Z"
+"StreetName": "Duke"
+"StreetNumber": "14"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/14dukestl8p1x1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Durand"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29746053/14-duke-street-hamilton-durand-durand"
+"LeaseAmount": 31
+"LeasePerUnit": "square feet"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "Offices"
]
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "E-1/S-704"
+"FrontageLengthNumeric": 49.9
+"OriginalEntryTimestamp": "2026-05-13T16:56:13.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 68
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29746053')"
+"ID": "1418047"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 20
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]