array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29646559 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1349139"
+post_author: 1
+"ListingKey": "29646559"
+"ListingId": "40821142"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:41Z"
+"RFModificationTimestamp": "2026-06-02T17:42:30Z"
+"ListPrice": 998000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.1
+"LivingArea": 5656.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N1E4"
+"UnparsedAddress": "593 & 595 E KING Street E, Hamilton, Ontario L8N1E4"
+"Coordinates": array:2 [
0 => -79.8514061
1 => 43.2524895
]
+"Latitude": 43.2524895
+"Longitude": -79.8514061
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional mixed-use opportunity in one of Hamilton’s most sought-after neighbourhoods, perfectly positioned along the upcoming LRT line. This versatile property offers both commercial and residential potential, currently generating steady income from a main-floor commercial unit (Barbershop for 16yrs) and a tenanted upper-level apartment. Situated on a generous lot with a separate rear apartment, the property also features a massive deck, ideal for outdoor living or entertaining, along with private laneway parking. Fronting onto King Street East, this is a rare chance to invest in a high-visibility corridor surrounded by excellent highway access and a vibrant, ever-growing restaurant scene. Whether you’re an investor or looking to live in style, this property is a must see and truly one of a kind! (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-04-23T16:39:26.061749+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999167"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.1"
+"PhotosChangeTimestamp": "2026-04-23T16:00:57Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:41:30Z"
+"Stories": "2.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "593"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Landsdale"
+"TaxAnnualAmount": "4498.21"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=YLQQhp27L8S"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29646559/593-595-e-king-street-e-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CoListAgentKey": "2177968"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2204592"
+"CoListOfficeKey": "284639"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "279638"
+"ZoningDescription": "TOC1"
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-04-23T16:00:57.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281468"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1429749"
+"CoListAgentNationalAssociationId2": "1453188"
+"CoListOfficeNationalAssociationId": "1344653"
+"CoListOfficeNationalAssociationId2": "1306586"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6621652450"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/793bd5813b2103976dbcec25c0ca1b3d.webp"
"MediaSize" => 137715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-793bd5813b2103976dbcec25c0ca1b3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6621652511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/f7b7ca0832b1972e859312bcc8d9ae7c.webp"
"MediaSize" => 134742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-f7b7ca0832b1972e859312bcc8d9ae7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6621652517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/d4101d9fd9f367b13d58ed271e3190c0.webp"
"MediaSize" => 96322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-d4101d9fd9f367b13d58ed271e3190c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6621652529"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/3ae2bf7093d63dad9a0dd430877cfff8.webp"
"MediaSize" => 113929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-3ae2bf7093d63dad9a0dd430877cfff8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6621652549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/4a0778cb3167baea94bc8150362b15a9.webp"
"MediaSize" => 139630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-4a0778cb3167baea94bc8150362b15a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6621652601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/692082004e601a5f2d7091fd22448e41.webp"
"MediaSize" => 140259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-692082004e601a5f2d7091fd22448e41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6621652610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/83f28fc6004b80b23794c10ea670e3d2.webp"
"MediaSize" => 108754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-83f28fc6004b80b23794c10ea670e3d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6621652683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/f1f803fc1b1530578ac6641e2623208b.webp"
"MediaSize" => 122441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-f1f803fc1b1530578ac6641e2623208b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6621652737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/a11a58c2923f66076b14b04e19d0bdf9.webp"
"MediaSize" => 137269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-a11a58c2923f66076b14b04e19d0bdf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6621652794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/73640a764fc0711b56b14bbc26dd149d.webp"
"MediaSize" => 115083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-73640a764fc0711b56b14bbc26dd149d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6621652837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/140793d2adf458b34bc608a0ba31a78a.webp"
"MediaSize" => 153470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-140793d2adf458b34bc608a0ba31a78a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6621652869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/e277e660aeddefeca47fdb260370f9ff.webp"
"MediaSize" => 127108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-e277e660aeddefeca47fdb260370f9ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6621652941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/6447f69f2237cb32f579fd52f1148e65.webp"
"MediaSize" => 135574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-6447f69f2237cb32f579fd52f1148e65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6621652966"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/72a02901b89f3e4c082a451bcc948ddf.webp"
"MediaSize" => 106992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-72a02901b89f3e4c082a451bcc948ddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6621652991"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/37d276a03b24844408d24f2c3e421486.webp"
"MediaSize" => 136369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-37d276a03b24844408d24f2c3e421486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6621653034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/835fab5b911ed92db3b36cd4fb5518d1.webp"
"MediaSize" => 85278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-835fab5b911ed92db3b36cd4fb5518d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6621653100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/44659db26ae095e42dc6338bc3c9361b.webp"
"MediaSize" => 98343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-44659db26ae095e42dc6338bc3c9361b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6621653164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/db002489692db6352cf11d8001d6cd56.webp"
"MediaSize" => 132759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-db002489692db6352cf11d8001d6cd56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6621653195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/d516a754cd66fbe48f271b2141dfbcea.webp"
"MediaSize" => 144700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-d516a754cd66fbe48f271b2141dfbcea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6621653231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/533135132ede6d34bfadcc3c7d7ea4a1.webp"
"MediaSize" => 155698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-533135132ede6d34bfadcc3c7d7ea4a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6621653290"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/a6b786f3ec2087dbeb8c7841dd53f10f.webp"
"MediaSize" => 175617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-a6b786f3ec2087dbeb8c7841dd53f10f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6621653312"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/314d0bb6ec4d4d8fc0284b315dbc85f7.webp"
"MediaSize" => 109908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-314d0bb6ec4d4d8fc0284b315dbc85f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6621653345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/2609648e19a70095e48bee7a8191c84c.webp"
"MediaSize" => 99601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-2609648e19a70095e48bee7a8191c84c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6621653422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/fd8656dcf4288053702007cf7e68b229.webp"
"MediaSize" => 104979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-fd8656dcf4288053702007cf7e68b229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6621653480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/ff6f87ab8995092d001fc8d2c9ef070b.webp"
"MediaSize" => 117112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-ff6f87ab8995092d001fc8d2c9ef070b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6621653549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/c237789b2ad01eb2ce5c22de7be65af2.webp"
"MediaSize" => 75451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-c237789b2ad01eb2ce5c22de7be65af2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6621653609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/2e0923190889337f598961b528cb5286.webp"
"MediaSize" => 87354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-2e0923190889337f598961b528cb5286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6621653668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/4b263a5cdf991ae678b1eb983efdd53e.webp"
"MediaSize" => 79689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-4b263a5cdf991ae678b1eb983efdd53e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6621653702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/42196d59a2639f030cdc007cc6db18c0.webp"
"MediaSize" => 98541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-42196d59a2639f030cdc007cc6db18c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6621653730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/df0e5adeb90a1f28b708dcc3128155bf.webp"
"MediaSize" => 70174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-df0e5adeb90a1f28b708dcc3128155bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6621653781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/555fa6e30c7a51088235bc811b159c51.webp"
"MediaSize" => 136663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-555fa6e30c7a51088235bc811b159c51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6621653809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/74933d51e3d0785701da6efadca25fff.webp"
"MediaSize" => 138705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-74933d51e3d0785701da6efadca25fff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6621653821"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/c943697fc6e7cbf5b9d41fbb92df4c73.webp"
"MediaSize" => 96003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-c943697fc6e7cbf5b9d41fbb92df4c73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6621653892"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/70e83ec1482aee83d2e30c02f401aab4.webp"
"MediaSize" => 151864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-70e83ec1482aee83d2e30c02f401aab4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6621653937"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/92114f1ad34855998c7f5ba03bccf20f.webp"
"MediaSize" => 128002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-92114f1ad34855998c7f5ba03bccf20f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6621653985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/d594ddd60d6114e4414c01ec0a562bf5.webp"
"MediaSize" => 102893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-d594ddd60d6114e4414c01ec0a562bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6621654025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/216c82a5ede8bf3978b99d93eb76e8c8.webp"
"MediaSize" => 105328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-216c82a5ede8bf3978b99d93eb76e8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6621654034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/bfa6f8c979a14826adfd30b2727fc216.webp"
"MediaSize" => 152389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-bfa6f8c979a14826adfd30b2727fc216.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6621654076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/29ebd6968fad0d55cd4b59631f6d4323.webp"
"MediaSize" => 119708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-29ebd6968fad0d55cd4b59631f6d4323.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6621654085"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/b1b7feba8f84bf51c142d59b027bcc13.webp"
"MediaSize" => 111517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-b1b7feba8f84bf51c142d59b027bcc13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6621654140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/d1a20544bac89d8f22d157d66a477609.webp"
"MediaSize" => 129922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-d1a20544bac89d8f22d157d66a477609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6621654169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/30adcc6e269f4a8bf477d7600499174e.webp"
"MediaSize" => 129424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-30adcc6e269f4a8bf477d7600499174e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "6621654189"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/eba68bb4a9d500cf85ab0a8b74808649.webp"
"MediaSize" => 142321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-eba68bb4a9d500cf85ab0a8b74808649.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "6621654213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/cdd4504dd568e265202fc7b3ba367093.webp"
"MediaSize" => 144778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-cdd4504dd568e265202fc7b3ba367093.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "6621654239"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/6ea453d1673c4d9bc4468322419fa1d2.webp"
"MediaSize" => 184430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-6ea453d1673c4d9bc4468322419fa1d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "6621654269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/52fa449b8fa5a4c5b91b608120231f60.webp"
"MediaSize" => 166018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-52fa449b8fa5a4c5b91b608120231f60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "6621654286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/187a4d1170934260a808214cd62e520c.webp"
"MediaSize" => 161032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-187a4d1170934260a808214cd62e520c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "6621654315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/fa305e59bffa6bc02c69cea7c60e9871.webp"
"MediaSize" => 198328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-fa305e59bffa6bc02c69cea7c60e9871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "6621654344"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/0415bf8b0cb725932d69479ee0ffaaf6.webp"
"MediaSize" => 194065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-0415bf8b0cb725932d69479ee0ffaaf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "6621654378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29646559/35afb1ae2c231dc81be0c960538cf668.webp"
"MediaSize" => 168515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29646559/thumbnail-35afb1ae2c231dc81be0c960538cf668.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40821142"
"ResourceRecordKey" => "29646559"
"ModificationTimestamp" => "2026-04-23T16:00:57.2Z"
]
]
+"DaysOnMarket": 89
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29646559')"
+"ID": "1349139"
}
]
+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 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25038
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24982
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "HBREMAESBR1A"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284639"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "502 Brant Street Unit 1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7R2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344653"
+"OriginalEntryTimestamp": "2019-01-30T21:05:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439642"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "284639"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284639')"
}
]
+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 1999167" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24976
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29646559'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25380
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29646559' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25396
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29646559' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.8514061 43.2524895)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25486
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25463
+post_id: "1642675"
+post_author: 1
+"ListingKey": "30056142"
+"ListingId": "40849608"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T18:05:33Z"
+"RFModificationTimestamp": "2026-07-20T18:54:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 580.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L2V8"
+"UnparsedAddress": "52 BARTON Street E Unit# 1, Hamilton, Ontario L8L2V8"
+"Coordinates": array:2 [
0 => -79.8638194
1 => 43.2633587
]
+"Latitude": 43.2633587
+"Longitude": -79.8638194
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully renovated commercial storefront just steps from James St N. Retail showroom and an additional private office with good natural light is located at the back of the unit. Located on Barton St just east of James St. N. Available September 1st, 2026. Perfect for small retail, professional office use or service commercial uses. This building and space has undergone a terrific revitalization making this a great spot for your business. Rent includes TMI and tenant pays separately metered Gas and Hydro. (id:62650)"
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-20T18:54:14.785685+00:00"
+"Directions": "On Barton St E, just East of John St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007886"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-07-20T17:59:22Z"
+"PhotosCount": 7
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T17:59:22Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BARTON"
+"StreetNumber": "52"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30056142/52-barton-street-e-unit-1-hamilton"
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CoListAgentKey": "1880620"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"TotalActualRent": 1690
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "H"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-20T17:59:22.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289860"
+"ListOfficeNationalAssociationId": "1114492"
+"CoListAgentNationalAssociationId": "1206303"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:7 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30056142_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/ee675e40295fd13e75c5bcea9ffb468d.webp"
"MediaSize" => 119932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-ee675e40295fd13e75c5bcea9ffb468d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30056142_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/d0a302de8180c683555043bfa8b8a9df.webp"
"MediaSize" => 97076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-d0a302de8180c683555043bfa8b8a9df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated treatment room featuring wood-finish flooring and soft-hued walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30056142_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/ae23eada72ad7db656715868920a54e6.webp"
"MediaSize" => 89771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-ae23eada72ad7db656715868920a54e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30056142_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/81633bfa4163ef2bcf55f47141b5a726.webp"
"MediaSize" => 78478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-81633bfa4163ef2bcf55f47141b5a726.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a wood-finish vanity with dark hardware, granite-style countertop, and an undermount sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30056142_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/250e06d8c103486ab0cca5bdd173ac4a.webp"
"MediaSize" => 121877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-250e06d8c103486ab0cca5bdd173ac4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30056142_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/a2ed6875aa57e5e7b914ad899d35d1e9.webp"
"MediaSize" => 110049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-a2ed6875aa57e5e7b914ad899d35d1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial space featuring wood-finish flooring, exposed ceiling ductwork, and a reception desk with light wood-finish paneling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30056142_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30056142/cf70ef41ee022f9a9df3230b0ba60389.webp"
"MediaSize" => 124709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30056142/thumbnail-cf70ef41ee022f9a9df3230b0ba60389.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849608"
"ResourceRecordKey" => "30056142"
"ModificationTimestamp" => "2026-07-20T17:59:22.9Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30056142')"
+"ID": "1642675"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25465
+post_id: "1638664"
+post_author: 1
+"ListingKey": "30034575"
+"ListingId": "40848301"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:07Z"
+"RFModificationTimestamp": "2026-07-17T23:38:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L3A9"
+"UnparsedAddress": "749 BARTON Street E Unit# A, Hamilton, Ontario L8L3A9"
+"Coordinates": array:2 [
0 => -79.8321785
1 => 43.2553582
]
+"Latitude": 43.2553582
+"Longitude": -79.8321785
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to a busy area of Barton St E near Lottridge St! With street parking and parking lots within a block, this property is easy to locate as it is on one of the busiest transit corridors of Hamilton. This unit has easy signage possibilities & floor to ceiling windows to utilize additional signage and allow lots of natural light in. The storefront has endless possibilities for usage as a furniture store, restaurant, clothing store, or divide the space for exceptional office space. 2-piece bath on main level & two 3-piece baths in basement, partial use of basement. Approx 4200 square feet /$0.95 per sq ft -390sq meters/$10.95 sq meter. Kitchen in back-room w/ stove, microwave. back doors for loading and unloading. continuously leased since 2014, vacant for immediate possession. Close to Tim Horton’s Field Stadium, on public transit and close to Highway access. (id:62650)"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Electricity"
2 => "Water"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-17T23:38:32.684202+00:00"
+"Directions": "On Barton St E between Barnesdale Ave N and Lottridge St , east of Sherman Ave N and west of Gage Ave N, on north side of street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523585"
+"ListOfficeKey": "275238"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-07-15T11:49:35Z"
+"PhotosCount": 16
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:35Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BARTON"
+"StreetNumber": "749"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/itso/40848301"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034575/749-barton-street-e-unit-a-hamilton"
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 4830
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "C2"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-07-15T11:49:34.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1063694"
+"ListOfficeNationalAssociationId": "1263001"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30034575_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/2b23d6d7e9d34e689e4f2cfaf92bcf42.webp"
"MediaSize" => 117135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-2b23d6d7e9d34e689e4f2cfaf92bcf42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30034575_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/f2cf8b8711e4e1ea874d1ee6245884c2.webp"
"MediaSize" => 100966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-f2cf8b8711e4e1ea874d1ee6245884c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30034575_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/f9c579193f5eb324b19e9d2975f3c072.webp"
"MediaSize" => 47300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-f9c579193f5eb324b19e9d2975f3c072.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30034575_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/954ed6c16aac911129c7933572dbd77c.webp"
"MediaSize" => 56579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-954ed6c16aac911129c7933572dbd77c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30034575_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/73b78855da54854d8e6f7f8f8cf3aa98.webp"
"MediaSize" => 63016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-73b78855da54854d8e6f7f8f8cf3aa98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30034575_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/2a8fd3e0cb4e646183dfa37074394fe6.webp"
"MediaSize" => 66596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-2a8fd3e0cb4e646183dfa37074394fe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "elevated platform"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30034575_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/ba401923d0ae2bebce3aea833eb730ee.webp"
"MediaSize" => 60889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-ba401923d0ae2bebce3aea833eb730ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30034575_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/89fc0c4700a27d17a163411d94ab3381.webp"
"MediaSize" => 63207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-89fc0c4700a27d17a163411d94ab3381.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30034575_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/a1cf0be36dc1b6ed6bf2301616d7d9bc.webp"
"MediaSize" => 60895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-a1cf0be36dc1b6ed6bf2301616d7d9bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30034575_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/54af6ecf15204af23e264abca29168c6.webp"
"MediaSize" => 50822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-54af6ecf15204af23e264abca29168c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30034575_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/ce5492608c4356a255a67a0dcaaa64d0.webp"
"MediaSize" => 73673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-ce5492608c4356a255a67a0dcaaa64d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30034575_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/47cde68650193348d0c998184c0b6d77.webp"
"MediaSize" => 58845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-47cde68650193348d0c998184c0b6d77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30034575_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/db0198c1df0a6a7ed4c6e8daf521418e.webp"
"MediaSize" => 52648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-db0198c1df0a6a7ed4c6e8daf521418e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30034575_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/4b964283e0c34d8ff412f42db57fb047.webp"
"MediaSize" => 55194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-4b964283e0c34d8ff412f42db57fb047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30034575_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/4099b356d9ad431511bc03fb994104af.webp"
"MediaSize" => 56426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-4099b356d9ad431511bc03fb994104af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30034575_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034575/9c7255320b67fa75776dd947821c4950.webp"
"MediaSize" => 63145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034575/thumbnail-9c7255320b67fa75776dd947821c4950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848301"
"ResourceRecordKey" => "30034575"
"ModificationTimestamp" => "2026-07-15T11:49:34.97Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034575')"
+"ID": "1638664"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25462
+post_id: "1637181"
+post_author: 1
+"ListingKey": "30033815"
+"ListingId": "40848305"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:07Z"
+"RFModificationTimestamp": "2026-07-17T21:01:33Z"
+"ListPrice": 2999990.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 9774.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R2L2"
+"UnparsedAddress": "197 JAMES Street N, Hamilton, Ontario L8R2L2"
+"Coordinates": array:2 [
0 => -79.8668786
1 => 43.2620376
]
+"Latitude": 43.2620376
+"Longitude": -79.8668786
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Presenting 193-197 James Street North, on one of the most prestigious streets Hamilton has to offer. Steps to public transit, West Harbour Go Station, Acclamation Condos & other thriving businesses & future developments- this infamous building originally the Armoury Hotel has evolved to what is now a 21 unit office/retail asset. Set on the corner of James St N & Mulberry, this ~ 9700 square foot (as per MPAC) all brick building features a long time anchor tenant, Snafu Studios (both at street level) with 19 studio/office spaces across the second and third floors stable with young professional tenants & low vacancy producing ~$300,000 in annual gross income (before recoverable). The property also features forced air (dual system), central air (multiple units), high speed internet, hardwood floors while the office floors are equipped with 4 bathrooms (3 w/showers) and a shared kitchenette. Huge upside in converting office leases to a net structure (6/19 converted) and driving up NOI. All office tenants can also enjoy secured entry! An incredible opportunity to add to any commercial portfolio! Phase 1 & 2 ESA reports available. BUSINESSES NOT FOR SALE (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-07-17T21:01:27.155947+00:00"
+"Directions": "Corner of James St N & Mulberry St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007029"
+"ListOfficeKey": "292302"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-15T17:42:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:35Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "JAMES"
+"StreetNumber": "197"
+"StreetSuffix": "Street"
+"SubdivisionName": "102 - Strathcona"
+"TaxAnnualAmount": "28585"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30033815/197-james-street-n-hamilton"
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CoListAgentKey": "2174420"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292301"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "H"
+"FrontageLengthNumeric": 43.0
+"OriginalEntryTimestamp": "2026-07-14T23:48:10.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289164"
+"ListOfficeNationalAssociationId": "1410383"
+"CoListAgentNationalAssociationId": "1424753"
+"CoListOfficeNationalAssociationId": "1410382"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30033815_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/8ceba3e5f93560c6ce28a016dc786a53.webp"
"MediaSize" => 137035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-8ceba3e5f93560c6ce28a016dc786a53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30033815_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/c0daad25b875310382840aa3ade992f1.webp"
"MediaSize" => 139095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-c0daad25b875310382840aa3ade992f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.25Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30033815_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/3fd666df3f122686fdd28f55ffc980cb.webp"
"MediaSize" => 159110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-3fd666df3f122686fdd28f55ffc980cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.3Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30033815_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/5a4bcfb5a4a46aa2ae9895c0bada009e.webp"
"MediaSize" => 152978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-5a4bcfb5a4a46aa2ae9895c0bada009e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30033815_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/1b007d4e7a0d491450d1e985d1fbf9df.webp"
"MediaSize" => 125059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-1b007d4e7a0d491450d1e985d1fbf9df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30033815_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/0a1f128a70b10341f821d6e5d9f274c7.webp"
"MediaSize" => 67933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-0a1f128a70b10341f821d6e5d9f274c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of staircase"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30033815_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/01433a937ef88b158e400ba4b403f8c9.webp"
"MediaSize" => 75693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-01433a937ef88b158e400ba4b403f8c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30033815_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/4cf7f9258948d64a46856b68a26550d4.webp"
"MediaSize" => 50746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-4cf7f9258948d64a46856b68a26550d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of entrance to property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30033815_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/bfe28fafddb223d3cbb9d912f49f3c87.webp"
"MediaSize" => 99643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-bfe28fafddb223d3cbb9d912f49f3c87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with light wood-type flooring, brick wall, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.3Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30033815_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/044f74fb60c056601e08fb4570182221.webp"
"MediaSize" => 93619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-044f74fb60c056601e08fb4570182221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer with rail lighting, light hardwood / wood-style floors, and brick wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.34Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30033815_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/0f9da54093485b5c2046e17e17e0d7b8.webp"
"MediaSize" => 101043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-0f9da54093485b5c2046e17e17e0d7b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room featuring light wood-type flooring, brick wall, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30033815_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/0f406b0bd73817d1af183994080645ce.webp"
"MediaSize" => 103809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-0f406b0bd73817d1af183994080645ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring brick wall, track lighting, and light wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30033815_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/dc63f0d3bb9a1c6dcd1305e0427cc2c7.webp"
"MediaSize" => 54113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-dc63f0d3bb9a1c6dcd1305e0427cc2c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of entrance to property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30033815_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/15f4bd2d03880f7940fee064bbc74196.webp"
"MediaSize" => 69055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-15f4bd2d03880f7940fee064bbc74196.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room with ceiling fan and light hardwood / wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30033815_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/fe7d17bc22b07ace8408f14a79909ad9.webp"
"MediaSize" => 107430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-fe7d17bc22b07ace8408f14a79909ad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring light hardwood / wood-style flooring, ceiling fan, and brick wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30033815_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/4d371341beba84477e0b665034b5dc88.webp"
"MediaSize" => 103832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-4d371341beba84477e0b665034b5dc88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room with ceiling fan, brick wall, and light hardwood / wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30033815_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/c4a2c5a7c5fb425bf094bb243324f942.webp"
"MediaSize" => 82043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-c4a2c5a7c5fb425bf094bb243324f942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring light hardwood / wood-style floors and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.31Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30033815_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/a787d25d64dbed7f685d69d879f9b565.webp"
"MediaSize" => 70457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-a787d25d64dbed7f685d69d879f9b565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with tile patterned flooring, vanity, tile walls, and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30033815_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/be372d61b8162bd7c526807c604f715b.webp"
"MediaSize" => 56689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-be372d61b8162bd7c526807c604f715b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with tile patterned flooring, tile walls, and curtained shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30033815_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/00e22e9d89ad5e311b0338ffe0a4572d.webp"
"MediaSize" => 63875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-00e22e9d89ad5e311b0338ffe0a4572d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall featuring light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.25Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30033815_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/da02264ea4acfbc39ffbc30aad912696.webp"
"MediaSize" => 64037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-da02264ea4acfbc39ffbc30aad912696.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with sink, light tile patterned floors, and white refrigerator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.45Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30033815_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/7ccadfc76c4f4f81b9bf04d850e9d0b1.webp"
"MediaSize" => 58839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-7ccadfc76c4f4f81b9bf04d850e9d0b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a shower with curtain, vanity, tile walls, and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.25Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30033815_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/a9f03df4968eb0cad776d46493e6ff2e.webp"
"MediaSize" => 124884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-a9f03df4968eb0cad776d46493e6ff2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bar with wine cooler, a raised ceiling, hanging light fixtures, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.27Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30033815_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/faed8c404f92a8724bb36c2331ff267e.webp"
"MediaSize" => 123037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-faed8c404f92a8724bb36c2331ff267e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30033815_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/7fcdf0fc693aef908c34102719e7c750.webp"
"MediaSize" => 140588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-7fcdf0fc693aef908c34102719e7c750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.45Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30033815_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/41caf931ade819b5d384c32c3349a93d.webp"
"MediaSize" => 139239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-41caf931ade819b5d384c32c3349a93d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.25Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30033815_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/14dda9d730a968fb8730dc628c118697.webp"
"MediaSize" => 136116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-14dda9d730a968fb8730dc628c118697.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Miscellaneous room with ornamental molding, brick wall, and a tray ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.7Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30033815_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/9e05c91d570fb16074ad5fb665896e33.webp"
"MediaSize" => 139994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-9e05c91d570fb16074ad5fb665896e33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Miscellaneous room with a tray ceiling and ornamental molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.35Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30033815_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/3eca07161a19dbc131dbcdfe21e1351e.webp"
"MediaSize" => 145104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-3eca07161a19dbc131dbcdfe21e1351e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a towering ceiling and brick wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.3Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30033815_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/0a8079325939b9e37146f26f8b1be068.webp"
"MediaSize" => 120178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-0a8079325939b9e37146f26f8b1be068.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.3Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30033815_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/e8009964741eb2e9adeb9f1750e5e362.webp"
"MediaSize" => 116364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-e8009964741eb2e9adeb9f1750e5e362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wooden walls, dark wood-type flooring, and an inviting chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848305"
"ResourceRecordKey" => "30033815"
"ModificationTimestamp" => "2026-07-15T17:42:08.93Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30033815_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033815/e4b46cacf596f180e04df72235cc9127.webp"
"MediaSize" => 118028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033815/thumbnail-e4b46cacf596f180e04df72235cc9127.webp"
…7
]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30033815')"
+"ID": "1637181"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25466
+post_id: "1636981"
+post_author: 1
+"ListingKey": "30041573"
+"ListingId": "40848725"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T14:30:03Z"
+"RFModificationTimestamp": "2026-07-21T14:35:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3132.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M1B1"
+"UnparsedAddress": "817 KING Street E, Hamilton, Ontario L8M1B1"
+"Coordinates": array:2 [
0 => -79.8423062
1 => 43.251504
]
+"Latitude": 43.251504
+"Longitude": -79.8423062
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Mixed-use building on Hamilton's King St E corridor, directly along the route of the future 14 km Hamilton LRT with planned stops nearby at Sherman and Gage Park. Ground-floor commercial space plus full basement storage, with a 4-bedroom apartment spanning the 2nd and 3rd levels; operate your business at street level and rent the residence above, or lease both units. TOC3 (Transit Oriented Corridor) zoning supports a broad mix of commercial and residential uses. Recent mechanical updates include a newer boiler and hot water tank. Steps to Gage Park, a few blocks to Tim Hortons Field, and surrounded by the established shops and eateries of the King, Barton and Main corridors, with HSR Route 1 service at the door and a quick ride to downtown Hamilton and the GO Centre. A flexible commercial-plus-residential holding positioned on one of the city's major transit corridors. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-17T20:57:23.765759+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049810"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-21T14:29:29Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T14:29:29Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "817"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "5426.93"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/364930"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30041573/817-king-street-e-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "TOC3"
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-07-16T15:18:32.21Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1325188"
+"ListOfficeNationalAssociationId": "1344651"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30041573')"
+"ID": "1636981"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25464
+post_id: "1592048"
+post_author: 1
+"ListingKey": "29983415"
+"ListingId": "40844891"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:00:03Z"
+"RFModificationTimestamp": "2026-07-03T19:57:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1248.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N1B5"
+"UnparsedAddress": "208 KING Street E Unit# 2, Hamilton, Ontario L8N1B5"
+"Coordinates": array:2 [
0 => -79.8631082
1 => 43.2546139
]
+"Latitude": 43.2546139
+"Longitude": -79.8631082
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional opportunity to lease approximately 1,248 SF of premium commercial space in a highly attractive downtown location with residential units above and a strong street-level presence. Pre-prepped for a tenant buildout, this upgraded modern shell offers approximately 22-ft clear height and an appealing combination of scale, flexibility, and character. The building includes brand new wiring, new gas furnace, new A/C rough-ins, new 100 amp sub panel, separate gas meter, fire, and attractive exposed brick, providing a polished and functional starting point for a customized interior finish. With significant improvements already completed, the unit offers a major head start over typical shell space while preserving flexibility for a high-quality tenant-specific buildout. An excellent opportunity for coffee shop, cafe, retail, service commercial, creative studio, boutique office, and similar uses Zoned D2 seeking a high-visibility downtown location with strong fundamentals and urban character (id:62650)"
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "Partial"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-07-03T19:56:52.175539+00:00"
+"Directions": "Walnut Street South"
+"ExteriorFeatures": array:4 [
0 => "Steel"
1 => "Brick"
2 => "Hardboard"
3 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147676"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-03T11:50:13Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T11:50:13Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "208"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983415/208-king-street-e-unit-2-hamilton"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2995
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "D2"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-03T11:50:13.04Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1398741"
+"ListOfficeNationalAssociationId": "1486985"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983415')"
+"ID": "1592048"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25459
+post_id: "1592049"
+post_author: 1
+"ListingKey": "29983416"
+"ListingId": "40844890"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:00:03Z"
+"RFModificationTimestamp": "2026-07-03T19:56:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1315.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8R1C5"
+"UnparsedAddress": "22 WILSON Street Unit# 2, Hamilton, Ontario L8R1C5"
+"Coordinates": array:2 [
0 => -79.8671661
1 => 43.2590673
]
+"Latitude": 43.2590673
+"Longitude": -79.8671661
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bring your concept to 22 Wilson Street with a main-floor commercial lease space designed for visibility, adaptability and downtown presence. Unit 2 provides a generous street-level footprint with prominent frontage, tall ceilings, oversized windows and an open, light-filled atmosphere that can be shaped around a wide range of business models. The space carries a modern industrial character that suits boutique retail, wellness, clinic-style services, showroom, studio, creative office or professional service uses. Located opposite the Design District condominium development, the property is positioned in a walkable downtown setting with nearby residential density, restaurants, transit and core-area amenities. Eight residential units above the commercial floor contribute on-site activity and reinforce the building's mixed-use nature. D3 Downtown Mixed Use zoning supports many commercial uses, with final occupancy and business operation subject to applicable municipal, licensing and building approvals. High-quality base-building rough-ins are in place to assist with future layout planning, whether the tenant requires reception, display areas, treatment rooms, workstations, storage or back-of-house support. Street exposure provides an opportunity for a visible brand presence and signage, subject to building and municipal requirements. A versatile option for a tenant looking for scale, character and strong urban positioning within one of downtown Hamilton's active redevelopment corridors. (id:62650)"
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "Partial"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-07-03T19:56:41.742039+00:00"
+"ExteriorFeatures": array:5 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
3 => "Shingles"
4 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147676"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-07-03T11:50:13Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T11:50:13Z"
+"Stories": "1.0"
+"StreetName": "WILSON"
+"StreetNumber": "22"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983416/22-wilson-street-unit-2-hamilton"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 4275
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "D3"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.0
+"OriginalEntryTimestamp": "2026-07-03T11:50:13.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1398741"
+"ListOfficeNationalAssociationId": "1486985"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983416')"
+"ID": "1592049"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1592713"
+post_author: 1
+"ListingKey": "29985573"
+"ListingId": "40844120"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T15:10:39Z"
+"RFModificationTimestamp": "2026-07-06T15:11:58Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.03
+"LivingArea": 2760.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2Y2"
+"UnparsedAddress": "196 GRANT Avenue, Hamilton, Ontario L8N2Y2"
+"Coordinates": array:2 [
0 => -79.8528273
1 => 43.2459433
]
+"Latitude": 43.2459433
+"Longitude": -79.8528273
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional mixed-use property featuring a fully equipped commercial kitchen with residential living quarters above. Rare opportunity to acquire a turnkey commercial food production facility with an updated residential apartment, offering outstanding flexibility for owner-operators, catering companies, commissary kitchens, meal preparation businesses, bakeries, specialty food producers and numerous other permitted commercial uses. The commercial kitchen is extensively equipped with multiple commercial six-burner ranges with ovens, a large convection oven, three commercial double-door refrigerators, stainless steel triple sink, additional prep sink, real maple butcher block workstations, commercial freezers, extensive industrial shelving, abundant catering equipment, office space, workshop area and built-in two-car garage. Above the commercial space is a beautifully updated residential unit featuring two bedrooms, 1.5 bathrooms, renovated kitchen with granite countertops and Wolf cooktop, updated bathroom with walk-in shower and custom vanity, updated plumbing and comfortable living space—ideal for an owner/operator or additional residential use. The property also offers updated windows, Carrier central air conditioning, copper wiring, significant roof improvements and excellent live/work potential in one of Hamilton's most unique mixed-use offerings. An exceptional opportunity to own a property that combines commercial functionality with residential convenience under one roof. (id:62650)"
+"Basement": array:1 [
0 => "Partial"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-07-03T19:12:49.747283+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525301"
+"ListOfficeKey": "55069"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.03"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:18:55Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T14:59:28Z"
+"Stories": "2.0"
+"StreetName": "GRANT"
+"StreetNumber": "196"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "143 - Stinson"
+"TaxAnnualAmount": "4400"
+"VirtualTourURLUnbranded": "https://real.vision/196-grant-avenue?o=u"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985573/196-grant-avenue-hamilton"
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CoListAgentKey": "1664888"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55069"
+"GeocodeManualYN": true
+"ZoningDescription": "D/S-1006, JJ"
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-07-03T17:18:55.57Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1101521"
+"ListOfficeNationalAssociationId": "1003669"
+"CoListAgentNationalAssociationId": "1168820"
+"CoListOfficeNationalAssociationId": "1003669"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985573')"
+"ID": "1592713"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25484
+post_id: "1587006"
+post_author: 1
+"ListingKey": "29980544"
+"ListingId": "40844755"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T14:55:13Z"
+"RFModificationTimestamp": "2026-07-03T17:30:58Z"
+"ListPrice": 1900000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3000.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N1B5"
+"UnparsedAddress": "216-218 KING Street E, Hamilton, Ontario L8N1B5"
+"Coordinates": array:2 [
0 => -79.8626057
1 => 43.2547225
]
+"Latitude": 43.2547225
+"Longitude": -79.8626057
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Excellent mixed-use investment opportunity in the heart of downtown Hamilton. This income-producing property features 2 fully leased ground-floor retail units generating a combined $4,300/month, plus 2 vacant 1-bed, 1-bath loft-style residential units, each with a private balcony overlooking vibrant King St. E, ready to be leased at today's market rents. An additional third residential unit offers excellent value-add potential and awaits restoration, providing an opportunity to further increase income through renovation. All 4 existing units are separately metered, allowing for efficient utility management. The property also offers rear parking and is ideally located close to public transit, shopping, restaurants, and the ongoing growth and revitalization of Hamilton's downtown core. A rare opportunity to acquire a well-located mixed-use asset with immediate commercial income, vacant residential units ready for lease-up, and future upside through renovation and increased rental potential. (id:62650)"
+"Basement": array:1 [
0 => "Partial"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-02T23:45:55.336122+00:00"
+"Directions": "Between Walnut Street S & Ferguson Avenue S on King Street E."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-03T14:48:31Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T14:48:31Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "216"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"TaxAnnualAmount": "22840"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980544/216-218-king-street-e-hamilton"
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"ZoningDescription": "D2"
+"FrontageLengthNumeric": 37.0
+"OriginalEntryTimestamp": "2026-07-02T19:11:04.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980544')"
+"ID": "1587006"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25485
+post_id: "1581915"
+post_author: 1
+"ListingKey": "29974252"
+"ListingId": "40843989"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T21:25:15Z"
+"RFModificationTimestamp": "2026-07-08T22:55:07Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3300.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2K8"
+"UnparsedAddress": "11 WALNUT Street S, Hamilton, Ontario L8N2K8"
+"Coordinates": array:2 [
0 => -79.8631403
1 => 43.2543207
]
+"Latitude": 43.2543207
+"Longitude": -79.8631403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity to own a freestanding, solid commercial building in the heart of downtown Hamilton. 11 Walnut Street South offers approx. 3,300 sq. ft. across two floors plus additional 1,600 sq. ft. basement, providing flexible space ideal for retail, office, or mixed-use applications. Recent upgrades include new Furnace (2026), new Hot Water Tank (2026), Electricity Panel (2026), flat roof (2019), three new windows (2019). Surrounded by thriving businesses and ample public parking, this high-exposure location provides strong potential for investors and owner-users alike. Property Being Sold in AS IS WHERE IS condition. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-07-01T04:16:45.126249+00:00"
+"Directions": "MAIN ST.E.TURN LEFT(NORTH) ON WALNUT ST.S."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1945468"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-08T21:01:28Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T21:18:37Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "WALNUT"
+"StreetNumber": "11"
+"StreetSuffix": "Street"
+"SubdivisionName": "140 - Beasley"
+"TaxAnnualAmount": "16167.46"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974252/11-walnut-street-s-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D3"
+"FrontageLengthNumeric": 21.0
+"OriginalEntryTimestamp": "2026-07-01T01:50:03.15Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1240844"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974252')"
+"ID": "1581915"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 42
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]