array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29641042 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1344645"
+post_author: 1
+"ListingKey": "29641042"
+"ListingId": "40823196"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:45:02Z"
+"RFModificationTimestamp": "2026-06-18T19:27:32Z"
+"ListPrice": 1319900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4236.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1H1"
+"UnparsedAddress": "19 KING Street W, Stoney Creek, Ontario L8G1H1"
+"Coordinates": array:2 [
0 => -79.7603468
1 => 43.217798
]
+"Latitude": 43.217798
+"Longitude": -79.7603468
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime Mixed-Use Opportunity in Downtown Stoney Creek! Fully updated within the last 10 years, this newer building features one main-floor retail/office space and two residential units above. Zoned C5A, it offers incredible flexibility—perfect for medical, professional, or service-based businesses. High-visibility location with ample parking. Run your business on the main level and generate strong rental income upstairs. Bonus: all three units have separate hydro and gas meters. Own it. Operate it. Profit from it. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2026-04-22T20:35:18.208454+00:00"
+"Directions": "King St W between Battlefield Drive & Lake Ave Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-04-22T17:17:29Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:35:31Z"
+"Stories": "3.0"
+"StreetDirSuffix": "West"
+"StreetName": "KING"
+"StreetNumber": "19"
+"StreetSuffix": "Street"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "15180.2"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29641042/19-king-street-w-stoney-creek"
+"StructureType": array:1 [
0 => "Offices"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C5A"
+"FrontageLengthNumeric": 52.0
+"OriginalEntryTimestamp": "2026-04-22T17:09:30.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:25 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6619933930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/b761a86b4592767963eb0ee8a6d67708.webp"
"MediaSize" => 124135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-b761a86b4592767963eb0ee8a6d67708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6619933957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/e9e70bdbfebf539a7ffeb64c299c3605.webp"
"MediaSize" => 85206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-e9e70bdbfebf539a7ffeb64c299c3605.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.53Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6619933976"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/4c27debf6257b5f14b47df2ecea327f8.webp"
"MediaSize" => 91301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-4c27debf6257b5f14b47df2ecea327f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6619933998"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/68ec466fb6bed0fe1142af4f36e578f1.webp"
"MediaSize" => 88440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-68ec466fb6bed0fe1142af4f36e578f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6619934039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/7394811782220155fb490a2881fb0b19.webp"
"MediaSize" => 79621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-7394811782220155fb490a2881fb0b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6619934044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/c9c2c48a14b4883e0f16bde9b249a2e5.webp"
"MediaSize" => 78996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-c9c2c48a14b4883e0f16bde9b249a2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6619934106"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/5657e566f3cad7fbd1ef83efd935decd.webp"
"MediaSize" => 86942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-5657e566f3cad7fbd1ef83efd935decd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6619934140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/027ae42d4d35af9748ae9fc962c95bfb.webp"
"MediaSize" => 73380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-027ae42d4d35af9748ae9fc962c95bfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6619934177"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/31c8fe0ad900de3c2e1088faf0b2de6c.webp"
"MediaSize" => 75087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-31c8fe0ad900de3c2e1088faf0b2de6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6619934212"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/dc63d84f4be655c5b841c18bf002a6a0.webp"
"MediaSize" => 86300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-dc63d84f4be655c5b841c18bf002a6a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6619934257"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/a5850e0b71815f52d45829a015635c32.webp"
"MediaSize" => 86842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-a5850e0b71815f52d45829a015635c32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6619934264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/9e6cfb9c1ca7fd4cf287287719d9cf04.webp"
"MediaSize" => 69757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-9e6cfb9c1ca7fd4cf287287719d9cf04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6619934291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/a448a535f70c44088006be0b3939e46d.webp"
"MediaSize" => 87896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-a448a535f70c44088006be0b3939e46d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6619934338"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/dd4287b0d0f98f3ec51835280a90cb57.webp"
"MediaSize" => 96617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-dd4287b0d0f98f3ec51835280a90cb57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6619934365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/5fb16a330e017616394bd2487e5e1929.webp"
"MediaSize" => 57378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-5fb16a330e017616394bd2487e5e1929.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6619934391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/27336ed64d9a75779df82b4fb6b46ce3.webp"
"MediaSize" => 51379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-27336ed64d9a75779df82b4fb6b46ce3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.58Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6619934424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/829819ece9e09ab721ddca3f306f10e2.webp"
"MediaSize" => 114376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-829819ece9e09ab721ddca3f306f10e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6619934450"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/7657f0b8d4dd7e27a48f9e5dd723a919.webp"
"MediaSize" => 60549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-7657f0b8d4dd7e27a48f9e5dd723a919.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VS Photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6619934460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/917eb25149b6d91b08ad3224b7c77e38.webp"
"MediaSize" => 64219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-917eb25149b6d91b08ad3224b7c77e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VS Photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6619934513"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/e3b5d66f7d552b727e9bef04e5775c4e.webp"
"MediaSize" => 71758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-e3b5d66f7d552b727e9bef04e5775c4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VS Photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6619934548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/3bda0ac6e63552c1da0cbbd9dda29277.webp"
"MediaSize" => 62432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-3bda0ac6e63552c1da0cbbd9dda29277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VS Photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6619934591"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/cbc9b207c175e7dde27422fdb3a89c17.webp"
"MediaSize" => 98806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-cbc9b207c175e7dde27422fdb3a89c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6619934636"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/04163ef22a96d24f2702426f113a64e3.webp"
"MediaSize" => 117335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-04163ef22a96d24f2702426f113a64e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:28.18Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6619934660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/fef0c994dca0a0752883610b4e428666.webp"
"MediaSize" => 123111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-fef0c994dca0a0752883610b4e428666.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6619934677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641042/a79ad6ee6fa5d671faf476e6ab741048.webp"
"MediaSize" => 105260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641042/thumbnail-a79ad6ee6fa5d671faf476e6ab741048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823196"
"ResourceRecordKey" => "29641042"
"ModificationTimestamp" => "2026-04-22T17:17:29.52Z"
]
]
+"DaysOnMarket": 60
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29641042')"
+"ID": "1344645"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 275989" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24873
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524224" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24846
+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 '29641042'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25170
+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 '29641042'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25186
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29641042' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-79.7603468 43.217798)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25239
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1552654"
+post_author: 1
+"ListingKey": "29934310"
+"ListingId": "X13472070"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T15:20:09Z"
+"RFModificationTimestamp": "2026-06-21T16:40:32Z"
+"ListPrice": 199000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1C2"
+"UnparsedAddress": "10C - 140 8 HIGHWAY, Hamilton (Stoney Creek), Ontario L8G1C2"
+"Coordinates": array:2 [
0 => -79.746086
1 => 43.223796
]
+"Latitude": 43.223796
+"Longitude": -79.746086
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional opportunity to own a well-established Maverick's Donuts franchise in Stoney Creek,located in a high footfall plaza. This strategically positioned unit sits next to a busy secondary school, ensuring consistent daily lunch traffic and strong walk-in demand.Surrounded by major food brands and anchored by a Shoppers Drug Mart, the location offers excellent visibility and steady customer flow. The business features a fully equipped kitchen with all chattels included, thoughtfully designed to support multiple food concepts. Turnkey operation-no renovations required. Ideal for an owner-operator or investor ready to generateincome from day one. Do not go direct. Option to continue with existing franchise orrebrand/change cuisine subject to landlord approval. (id:62650)"
+"BusinessType": "Food Services and Beverage"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-21T16:40:21.034324+00:00"
+"Directions": "Highway 8 & Gray Road"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2204598"
+"ListOfficeKey": "293109"
+"PhotosChangeTimestamp": "2026-06-21T15:13:39Z"
+"PhotosCount": 5
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T15:13:39Z"
+"StreetName": "8"
+"StreetNumber": "140"
+"StreetSuffix": "Highway"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29934310/10c-140-8-highway-hamilton-stoney-creek-stoney-creek"
+"GeocodeManualYN": false
+"ZoningDescription": "C2"
+"OriginalEntryTimestamp": "2026-06-21T15:13:39.27Z"
+"ListAgentNationalAssociationId": "1453261"
+"ListOfficeNationalAssociationId": "1422605"
+"Media": array:5 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29934310_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29934310/729d47db10375c640c5f5d277c518714.webp"
"MediaSize" => 136070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29934310/thumbnail-729d47db10375c640c5f5d277c518714.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13472070"
"ResourceRecordKey" => "29934310"
"ModificationTimestamp" => "2026-06-21T15:13:39.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29934310_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29934310/b3490b9dd75b64ab0c63cdbf040d443a.webp"
"MediaSize" => 218019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29934310/thumbnail-b3490b9dd75b64ab0c63cdbf040d443a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13472070"
"ResourceRecordKey" => "29934310"
"ModificationTimestamp" => "2026-06-21T15:13:39.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29934310_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29934310/a2250a67ffdee1c2e37522b920a1039e.webp"
"MediaSize" => 175762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29934310/thumbnail-a2250a67ffdee1c2e37522b920a1039e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13472070"
"ResourceRecordKey" => "29934310"
"ModificationTimestamp" => "2026-06-21T15:13:39.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29934310_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29934310/d08282ddd104362e4a9b7e50c9f46592.webp"
"MediaSize" => 164063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29934310/thumbnail-d08282ddd104362e4a9b7e50c9f46592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13472070"
"ResourceRecordKey" => "29934310"
"ModificationTimestamp" => "2026-06-21T15:13:39.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29934310_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29934310/be61b7d9b97886cda273bd6251f38b28.webp"
"MediaSize" => 269496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29934310/thumbnail-be61b7d9b97886cda273bd6251f38b28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13472070"
"ResourceRecordKey" => "29934310"
"ModificationTimestamp" => "2026-06-21T15:13:39.28Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934310')"
+"ID": "1552654"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1539208"
+post_author: 1
+"ListingKey": "29338030"
+"ListingId": "X12769802"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:45:03Z"
+"RFModificationTimestamp": "2026-06-17T16:52:35Z"
+"ListPrice": 159000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Corman)"
+"PostalCode": "L9B0K1"
+"UnparsedAddress": "3 - 125 GAILMONT DRIVE, Hamilton (Corman), Ontario L9B0K1"
+"Coordinates": array:2 [
0 => -79.783245
1 => 43.224112
]
+"Latitude": 43.224112
+"Longitude": -79.783245
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent opportunity to own a well-established pizzeria in Hamilton, Ontario. Winners Pizza & Wings is a popular local favourite with strong sales, low labour costs, and exceptionally low rent, making this a true money-maker for an owner-operator.This profitable business offers great income for ownership and comes with training and goodwill, ideal for a hands-on buyer looking to take over a proven, turnkey operation.Lease details are outstanding: only $2,200 gross rent including TMI, secured until October 2029 with an additional 5-year renewal option. All appliances are almost new, including a commercial hood, minimizing future capital expenses.There is significant upside potential to expand the menu, extend operating hours, boost delivery sales, or rebrand with your own concept and take the business to the next level. Please do not go direct or speak with staff. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-17T16:52:26.529911+00:00"
+"Directions": "Cross Streets: Red Hl Way Pkwy & King St E. ** Directions: King St E to Gailmont Dr."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243248"
+"ListOfficeKey": "300580"
+"LotSizeDimensions": "Unit=13 x 42 FT"
+"PhotosChangeTimestamp": "2026-02-08T17:40:51Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:35:19Z"
+"StreetName": "Gailmont"
+"StreetNumber": "125"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Corman"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29338030/3-125-gailmont-drive-hamilton-corman-corman"
+"GeocodeManualYN": false
+"ZoningDescription": "C2"
+"FrontageLengthNumeric": 13.0
+"OriginalEntryTimestamp": "2026-02-08T17:40:51.47Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1481403"
+"ListOfficeNationalAssociationId": "1490337"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29338030_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/265436b13799af31f0e804fd592d2060.webp"
"MediaSize" => 181257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-265436b13799af31f0e804fd592d2060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29338030_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/7b94d72b99d2485e6799080aa24f58cb.webp"
"MediaSize" => 206947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-7b94d72b99d2485e6799080aa24f58cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29338030_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/9bd0ff4552ab5db89c95ef66f1c6166e.webp"
"MediaSize" => 176166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-9bd0ff4552ab5db89c95ef66f1c6166e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29338030_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/e0a6e4a3b76faced9ab08cadc7a17312.webp"
"MediaSize" => 147904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-e0a6e4a3b76faced9ab08cadc7a17312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29338030_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/417d4c439a5eb1d886bf371464da0d46.webp"
"MediaSize" => 154066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-417d4c439a5eb1d886bf371464da0d46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29338030_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/1d14bf621390dca4629351dd9112a914.webp"
"MediaSize" => 160930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-1d14bf621390dca4629351dd9112a914.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29338030_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/3e377327168b1c28f42179252facfcb7.webp"
"MediaSize" => 142219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-3e377327168b1c28f42179252facfcb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29338030_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/6ee6e1b7bab01c6dde808fa4a887edc8.webp"
"MediaSize" => 128421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-6ee6e1b7bab01c6dde808fa4a887edc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29338030_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/a8c0420c408678e3b5ebf5fcb283e0a0.webp"
"MediaSize" => 154034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-a8c0420c408678e3b5ebf5fcb283e0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29338030_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/34dff0c9a105f6e8978dc605b06fe78e.webp"
"MediaSize" => 171385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-34dff0c9a105f6e8978dc605b06fe78e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29338030_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/22795f815e80d3cb7555d9d7035fcc60.webp"
"MediaSize" => 146420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-22795f815e80d3cb7555d9d7035fcc60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29338030_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29338030/4c40432440f73ecdaa58780b2d91e388.webp"
"MediaSize" => 157702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29338030/thumbnail-4c40432440f73ecdaa58780b2d91e388.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12769802"
"ResourceRecordKey" => "29338030"
"ModificationTimestamp" => "2026-02-08T17:40:51.48Z"
]
]
+"DaysOnMarket": 133
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29338030')"
+"ID": "1539208"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1505856"
+post_author: 1
+"ListingKey": "29869737"
+"ListingId": "X13413874"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T16:06:09Z"
+"RFModificationTimestamp": "2026-06-08T16:18:24Z"
+"ListPrice": 139900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1B8"
+"UnparsedAddress": "931 QUEENSTON ROAD, Hamilton (Stoney Creek), Ontario L8G1B8"
+"Coordinates": array:2 [
0 => -79.753373
1 => 43.226001
]
+"Latitude": 43.226001
+"Longitude": -79.753373
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is a well-known restaurant located on a busy street, enjoying high visibility and a steady flow of customers, Maria's Fifty's Diner Is Awaiting A Motivated Restauranteur To Take Over And Fulfill Their Dream of owning A Restaurant. With 4500 Sqft, with LLBO License. The Potential Is Endless. Fully Equipped Kitchen. Seating For 148 Customers At Full Capacity. A Comfortable And Relaxed Atmosphere Serving Delicious Breakfast And Lunch From 8:30Am-4:00Pm. The Perfect Work Life Balance. The restaurant comes with a liquor license already in place. Presently serving only breakfast and lunch, the business offers tremendous growth potential if dinner service is introduced, as evening dining and alcohol sales can substantially increase revenue. Most Chattels and Equipment included in the Sale Price. Affordable Lease. With extended lease term. Do Not Go Direct and Speak With Employees Regarding Listing Details. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-08T16:18:20.576932+00:00"
+"Directions": "Lake Avenue Dr/Queenston Rd"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1408335"
+"ListOfficeKey": "50934"
+"PhotosChangeTimestamp": "2026-06-08T15:35:31Z"
+"PhotosCount": 6
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T15:55:33Z"
+"StreetName": "Queenston"
+"StreetNumber": "931"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5600"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29869737/931-queenston-road-hamilton-stoney-creek-stoney-creek"
+"GeocodeManualYN": false
+"ZoningDescription": "N/A"
+"OriginalEntryTimestamp": "2026-06-08T15:35:31.69Z"
+"ListAgentNationalAssociationId": "1113405"
+"ListOfficeNationalAssociationId": "1002983"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29869737_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/09dc868bb6632b64c6de9917403ee564.webp"
"MediaSize" => 106106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-09dc868bb6632b64c6de9917403ee564.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29869737_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/8307f7b61c218a1f3ef85c4403c2b3bb.webp"
"MediaSize" => 71158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-8307f7b61c218a1f3ef85c4403c2b3bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29869737_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/114ea96bd38c68ba51986c1df5edeff2.webp"
"MediaSize" => 113303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-114ea96bd38c68ba51986c1df5edeff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29869737_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/fc429b3ac0695f85b3996aa52fa906eb.webp"
"MediaSize" => 120819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-fc429b3ac0695f85b3996aa52fa906eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29869737_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/4c556198c4eb8351cf2b5ddf52671898.webp"
"MediaSize" => 127384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-4c556198c4eb8351cf2b5ddf52671898.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29869737_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29869737/e0ff2feb988782870f5a1bafdd95e2fc.webp"
"MediaSize" => 123316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29869737/thumbnail-e0ff2feb988782870f5a1bafdd95e2fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13413874"
"ResourceRecordKey" => "29869737"
"ModificationTimestamp" => "2026-06-08T15:35:31.69Z"
]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869737')"
+"ID": "1505856"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1381231"
+post_author: 1
+"ListingKey": "29693163"
+"ListingId": "40825665"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T21:20:51Z"
+"RFModificationTimestamp": "2026-06-08T21:25:59Z"
+"ListPrice": 2599999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.34
+"LivingArea": 9746.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K4B8"
+"UnparsedAddress": "125 GAILMONT Drive, Hamilton, Ontario L8K4B8"
+"Coordinates": array:2 [
0 => -79.7831824
1 => 43.2243378
]
+"Latitude": 43.2243378
+"Longitude": -79.7831824
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare Investment Opportunity - Established Mixed-Use Retail Plaza in Hamilton's East End. A rare opportunity to acquire a highly visible, established mixed-use retail plaza in prime East Hamilton. Situated on a high-traffic arterial road with outstanding visibility, just one minute from the Red Hill Valley Parkway and directly on a major bus route, this property offers extreme retail exposure and unbeatable convenience for commuters and local shoppers alike. The plaza features 20+ on-site parking spaces plus ample free street parking. With main floor and lower-level units occupied primarily by long-term, solid tenants and nearly fully leased, the asset delivers stable, immediate cash flow from day one.Strong Upside Potential: Take advantage of Hamilton's ongoing growth with opportunities to expand the existing footprint or redevelop in height. Whether you're an investor seeking value-add or a developer looking for intensification, this is a compelling opportunity. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-04T04:35:51.642369+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224388"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"LotSizeDimensions": "0.34"
+"PhotosChangeTimestamp": "2026-06-08T21:10:57Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T21:10:57Z"
+"StreetName": "GAILMONT"
+"StreetNumber": "125"
+"StreetSuffix": "Drive"
+"SubdivisionName": "280 - Corman/Greenford"
+"TaxAnnualAmount": "33813.03"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29693163/125-gailmont-drive-hamilton"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C2"
+"FrontageLengthNumeric": 110.0
+"OriginalEntryTimestamp": "2026-05-04T02:09:33.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1467734"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6649828914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/c989c8b04514236a7ca6d7cd03d3bc77.webp"
"MediaSize" => 135305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-c989c8b04514236a7ca6d7cd03d3bc77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6649829022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/bd4941a05c877bfbab3c8721232ce2d2.webp"
"MediaSize" => 139313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-bd4941a05c877bfbab3c8721232ce2d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6649829108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/3ff0cf6ecdd84412f6d879e7358e5124.webp"
"MediaSize" => 86109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-3ff0cf6ecdd84412f6d879e7358e5124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6649829195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/17c2dbf53f6586da0dcd75ed1a5c63d8.webp"
"MediaSize" => 104800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-17c2dbf53f6586da0dcd75ed1a5c63d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6649829244"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/e786b08d6130b3cecd60af99afb8867c.webp"
"MediaSize" => 111347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-e786b08d6130b3cecd60af99afb8867c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6649829378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/ad936de6eb24cd5339ec6741e9494876.webp"
"MediaSize" => 111578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-ad936de6eb24cd5339ec6741e9494876.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6649829480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/6452995fb8e39167391a00cc7ede2291.webp"
"MediaSize" => 112982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-6452995fb8e39167391a00cc7ede2291.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6649829598"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/f3035c54536dcdda6f6d74c293029e0f.webp"
"MediaSize" => 139313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-f3035c54536dcdda6f6d74c293029e0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6649829633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/bbd338a219a142fd34145df8ef1082a7.webp"
"MediaSize" => 129398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-bbd338a219a142fd34145df8ef1082a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6649829648"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/6b3d2815c20d82042ba0a1cdfd663583.webp"
"MediaSize" => 147385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-6b3d2815c20d82042ba0a1cdfd663583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6649829767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/2442b7bbdf4c898c866a382e65bde358.webp"
"MediaSize" => 147904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-2442b7bbdf4c898c866a382e65bde358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6649829872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/c948ee9ce5a1a549cf216f3187961dce.webp"
"MediaSize" => 151819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-c948ee9ce5a1a549cf216f3187961dce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6649829963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/c6ffadbba83c07cf5a0eb6d696508ead.webp"
"MediaSize" => 144611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-c6ffadbba83c07cf5a0eb6d696508ead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6649830056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/8f65c39038440751b7388a8c483425f4.webp"
"MediaSize" => 139027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-8f65c39038440751b7388a8c483425f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6649830156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/8a221d0e98e2625236b569bbcb0603e0.webp"
"MediaSize" => 143748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-8a221d0e98e2625236b569bbcb0603e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6649830241"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/cad42c275a160f5b4c4cfa49e750c1ce.webp"
"MediaSize" => 142989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-cad42c275a160f5b4c4cfa49e750c1ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6649830304"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693163/b676dc0e6ba2904f62751f3100d31cc1.webp"
"MediaSize" => 142201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693163/thumbnail-b676dc0e6ba2904f62751f3100d31cc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825665"
"ResourceRecordKey" => "29693163"
"ModificationTimestamp" => "2026-05-04T02:09:33.55Z"
]
]
+"DaysOnMarket": 48
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29693163')"
+"ID": "1381231"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1381238"
+post_author: 1
+"ListingKey": "29693193"
+"ListingId": "X13076232"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-04T14:25:19Z"
+"RFModificationTimestamp": "2026-05-04T20:42:38Z"
+"ListPrice": 2599999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.34
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Corman)"
+"PostalCode": "L8K4B8"
+"UnparsedAddress": "125 GAILMONT DRIVE, Hamilton (Corman), Ontario L8K4B8"
+"Coordinates": array:2 [
0 => -79.7833288
1 => 43.2241926
]
+"Latitude": 43.2241926
+"Longitude": -79.7833288
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Investment Opportunity - Established Mixed-Use Retail Plaza in Hamilton's East End. A rare opportunity to acquire a highly visible, established mixed-use retail plaza in prime East Hamilton. Situated on a high-traffic arterial road with outstanding visibility, just one minute from the Red Hill Valley Parkway and directly on a major bus route, this property offers extreme retail exposure and unbeatable convenience for commuters and local shoppers alike.The plaza features 20+ on-site parking spaces plus ample free street parking. With main floor and lower-level units occupied primarily by long-term, solid tenants and nearly fully leased, the asset delivers stable, immediate cash flow from day one.Strong Upside Potential: Take advantage of Hamilton's ongoing growth with opportunities to expand the existing footprint or redevelop in height. Whether you're an investor seeking value-add or a developer looking for intensification, this is a compelling opportunity. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-04T04:33:55.582442+00:00"
+"Directions": "Cross Streets: King St E & Gailmont Dr. ** Directions: King St E, Turn onto Gailmont Dr, on your right-hand side."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224388"
+"ListOfficeKey": "286883"
+"LotSizeDimensions": "0.34"
+"PhotosChangeTimestamp": "2026-05-04T02:43:23Z"
+"PhotosCount": 16
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-04T14:15:52Z"
+"StreetName": "Gailmont"
+"StreetNumber": "125"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "33813.03"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Corman"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29693193/125-gailmont-drive-hamilton-corman-corman"
+"GeocodeManualYN": true
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-05-04T02:43:23.33Z"
+"ListAgentNationalAssociationId": "1467734"
+"ListOfficeNationalAssociationId": "1364605"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6649874172"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/d76380432f9501dc2a16d7984fa3ea4a.webp"
"MediaSize" => 323613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-d76380432f9501dc2a16d7984fa3ea4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6649874176"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/d093e00b03595e6f8bbd2447235aeaf3.webp"
"MediaSize" => 331401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-d093e00b03595e6f8bbd2447235aeaf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6649874179"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/b2ce2401b68d52a87dd58afab7e760c8.webp"
"MediaSize" => 205132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-b2ce2401b68d52a87dd58afab7e760c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6649874183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/2ba161d1b6b0ed5c1acc6a10f3f9d502.webp"
"MediaSize" => 244676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-2ba161d1b6b0ed5c1acc6a10f3f9d502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6649874188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/3a72c67f5f8d29f9d68afd1e620a5851.webp"
"MediaSize" => 293412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-3a72c67f5f8d29f9d68afd1e620a5851.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6649874192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/a2dccf58904e8f74fa9e34309e4ab75e.webp"
"MediaSize" => 289366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-a2dccf58904e8f74fa9e34309e4ab75e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6649874193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/ff26aec5c6414d14491e633d4eceb49a.webp"
"MediaSize" => 301226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-ff26aec5c6414d14491e633d4eceb49a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6649874195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/353ae70107905b10a84ec8eaaf3e3e42.webp"
"MediaSize" => 306080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-353ae70107905b10a84ec8eaaf3e3e42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6649874197"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/e27009abfee86726e9e7cda0717ec1b5.webp"
"MediaSize" => 350733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-e27009abfee86726e9e7cda0717ec1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6649874199"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/f2e001a3e59f5306acda160b82267966.webp"
"MediaSize" => 348433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-f2e001a3e59f5306acda160b82267966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6649874202"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/a7a6aa5106bb43b92afdcd9084483574.webp"
"MediaSize" => 352894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-a7a6aa5106bb43b92afdcd9084483574.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6649874204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/df916d96a1f5200757f56b63e01728c4.webp"
"MediaSize" => 337782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-df916d96a1f5200757f56b63e01728c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6649874206"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/fa409519426868c6c644d884bbc89445.webp"
"MediaSize" => 326252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-fa409519426868c6c644d884bbc89445.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6649874210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/20d683002f67e7d2a2b06bf9ffa4cd7a.webp"
"MediaSize" => 338313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-20d683002f67e7d2a2b06bf9ffa4cd7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6649874213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/0351dd29c1ebdcdba9aaf5b8fd59dd2f.webp"
"MediaSize" => 337328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-0351dd29c1ebdcdba9aaf5b8fd59dd2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6649874218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29693193/2f8bdddd306bfe245a291bd90083cc65.webp"
"MediaSize" => 336059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29693193/thumbnail-2f8bdddd306bfe245a291bd90083cc65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13076232"
"ResourceRecordKey" => "29693193"
"ModificationTimestamp" => "2026-05-04T02:43:23.34Z"
]
]
+"DaysOnMarket": 48
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29693193')"
+"ID": "1381238"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1187626"
+post_author: 1
+"ListingKey": "29413238"
+"ListingId": "40808391"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T15:56:09Z"
+"RFModificationTimestamp": "2026-06-02T16:18:06Z"
+"ListPrice": 180000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8G4A8"
+"UnparsedAddress": "826 QUEENSTON Road Unit# 1, Hamilton, Ontario L8G4A8"
+"Coordinates": array:2 [
0 => -79.762904
1 => 43.2274806
]
+"Latitude": 43.2274806
+"Longitude": -79.762904
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sale of Business on Leased Property (id:62783)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Freezer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-03-02T19:41:23.833128+00:00"
+"Directions": "Queenston Road and Centennial Parkway"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060012"
+"ListOfficeKey": "283890"
+"LotFeatures": array:1 [
0 => "Corner Site"
]
+"PhotosChangeTimestamp": "2026-03-02T14:21:40Z"
+"PhotosCount": 25
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T15:45:58Z"
+"StreetName": "QUEENSTON"
+"StreetNumber": "826"
+"StreetSuffix": "Road"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29413238/826-queenston-road-unit-1-hamilton"
+"GeocodeManualYN": true
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-03-02T14:19:25.93Z"
+"ListAgentNationalAssociationId": "1335163"
+"ListOfficeNationalAssociationId": "1336415"
+"Media": array:25 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6488174666"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/f852532c715fb360b6ae14402a439463.webp"
"MediaSize" => 92245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-f852532c715fb360b6ae14402a439463.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.52Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6488174769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/165246c1bb0a6fe5f1c9c8920a205167.webp"
"MediaSize" => 96559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-165246c1bb0a6fe5f1c9c8920a205167.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.68Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6488174788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/7a6b78641bcf3e00ee6ed012be69d54c.webp"
"MediaSize" => 93476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-7a6b78641bcf3e00ee6ed012be69d54c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.1Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6488174877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/d89e4fc753837c7cd1ee3885ddff109c.webp"
"MediaSize" => 107405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-d89e4fc753837c7cd1ee3885ddff109c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.68Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6488174958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/13a8970d929f26f5b7b01bf967a14431.webp"
"MediaSize" => 96514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-13a8970d929f26f5b7b01bf967a14431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6488175036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/19896b77eb6bf47c321f1478618d559c.webp"
"MediaSize" => 107888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-19896b77eb6bf47c321f1478618d559c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.52Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6488175089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/080209f4680feeec4d01b800d32ea49f.webp"
"MediaSize" => 110537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-080209f4680feeec4d01b800d32ea49f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.54Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6488175152"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/dc65c18bbd95376c7c9b6c46e5443a3d.webp"
"MediaSize" => 103162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-dc65c18bbd95376c7c9b6c46e5443a3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.56Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6488175215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/78e414724e9de7a1d5c4905fe480df90.webp"
"MediaSize" => 117854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-78e414724e9de7a1d5c4905fe480df90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.7Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6488175264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/11d474347a9efd8fbc973338c67e1998.webp"
"MediaSize" => 105343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-11d474347a9efd8fbc973338c67e1998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.68Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6488175323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/de57e0e2bb50d350746b9a1b60864a0e.webp"
"MediaSize" => 102019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-de57e0e2bb50d350746b9a1b60864a0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.77Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6488175377"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/cc38a65eafe0d1987f7a1ff9f84dc568.webp"
"MediaSize" => 80554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-cc38a65eafe0d1987f7a1ff9f84dc568.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.7Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6488175436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/0243dff517766f6f2e27d81383820a33.webp"
"MediaSize" => 104838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-0243dff517766f6f2e27d81383820a33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.8Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6488175448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/9ff66159e95a424e465b011fc61a5aca.webp"
"MediaSize" => 60798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-9ff66159e95a424e465b011fc61a5aca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.52Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6488175465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/d285367487556a5e78613d6afd85e3e2.webp"
"MediaSize" => 110879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-d285367487556a5e78613d6afd85e3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.52Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6488175499"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/d1b0ec3133096a3a582507d32341017d.webp"
"MediaSize" => 76586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-d1b0ec3133096a3a582507d32341017d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.51Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6488175530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/c454f887a868df964ff63750e8b5a359.webp"
"MediaSize" => 106452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-c454f887a868df964ff63750e8b5a359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.7Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6488175591"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/550f9c9ed4c2423a7ab07178f78f0883.webp"
"MediaSize" => 110595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-550f9c9ed4c2423a7ab07178f78f0883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.81Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6488175629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/9dbea0ac60cb3f79eacb7d39ed437a0c.webp"
"MediaSize" => 94200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-9dbea0ac60cb3f79eacb7d39ed437a0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.72Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6488175672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/a7bd18f30251fab033930d1a06461727.webp"
"MediaSize" => 110490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-a7bd18f30251fab033930d1a06461727.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.52Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6488175699"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/e814b13cad32b635d09ae8fee74316e7.webp"
"MediaSize" => 94277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-e814b13cad32b635d09ae8fee74316e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:40.51Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6488175730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/564ee74bb1ec2a5731665e76c1cec28d.webp"
"MediaSize" => 107158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-564ee74bb1ec2a5731665e76c1cec28d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.75Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6488175743"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/673e6aac8b7dc6d4553a258afa6410a0.webp"
"MediaSize" => 66121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-673e6aac8b7dc6d4553a258afa6410a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.72Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6488175763"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/6d32fbfe0a7e757297b08786ef87de62.webp"
"MediaSize" => 49644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-6d32fbfe0a7e757297b08786ef87de62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.68Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6488175783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29413238/46527e971bf2f5358c0a19ab55e55cee.webp"
"MediaSize" => 66110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29413238/thumbnail-46527e971bf2f5358c0a19ab55e55cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40808391"
"ResourceRecordKey" => "29413238"
"ModificationTimestamp" => "2026-03-02T14:21:39.75Z"
]
]
+"DaysOnMarket": 111
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29413238')"
+"ID": "1187626"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1120921"
+post_author: 1
+"ListingKey": "29316483"
+"ListingId": "40801187"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:00:42Z"
+"RFModificationTimestamp": "2026-06-02T16:14:39Z"
+"ListPrice": 199000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8G1A4"
+"UnparsedAddress": "754 QUEENSTON Road Unit# 1 & 2, Hamilton, Ontario L8G1A4"
+"Coordinates": array:2 [
0 => -79.7692275
1 => 43.2281071
]
+"Latitude": 43.2281071
+"Longitude": -79.7692275
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "CAN BE CONVERTED INTO OTHER FOOD CONCEPT. Sarajevo Grill & Meat Business in Hamilton, ON is For Sale. Located at the busy intersection of Queenston Rd/Clapham Rd. Surrounded by Fully Residential Neighbourhood, Close to Schools, Highway, Offices, Banks, Major Big Box Store and Much More. Business with so much opportunity to grow the business even more. Monthly Sales: Approx: $50,000 - $52,000 before HST, Rent: $7561.82/m including TMI & HST, Lease Term: Existing 5 + Option to renew, Seating: 35. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-02-03T03:30:08.822575+00:00"
+"Directions": "Turn right on Queenston Road"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076777"
+"ListOfficeKey": "284587"
+"PhotosChangeTimestamp": "2026-05-09T04:20:53Z"
+"PhotosCount": 47
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T15:50:08Z"
+"StreetName": "QUEENSTON"
+"StreetNumber": "754"
+"StreetSuffix": "Road"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29316483/754-queenston-road-unit-1-2-hamilton"
+"GeocodeManualYN": true
+"ZoningDescription": "HH"
+"OriginalEntryTimestamp": "2026-02-03T02:18:47.05Z"
+"ListAgentNationalAssociationId": "1351906"
+"ListOfficeNationalAssociationId": "1343174"
+"Media": array:47 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6438177218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/14094fce31ed3372c359dac318839420.webp"
"MediaSize" => 104567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-14094fce31ed3372c359dac318839420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6438177239"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/0dc20c8b8216a34f77606862c64afa52.webp"
"MediaSize" => 103480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-0dc20c8b8216a34f77606862c64afa52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6438177257"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/3d224e04202d4264aa3749295f198d2c.webp"
"MediaSize" => 102251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-3d224e04202d4264aa3749295f198d2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6438177300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/f7e8ceac8110735b752477773fb14fe4.webp"
"MediaSize" => 140809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-f7e8ceac8110735b752477773fb14fe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6438177313"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/0494bfdea7ef788721fe6620ceba7a8a.webp"
"MediaSize" => 134215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-0494bfdea7ef788721fe6620ceba7a8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6438177346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/1f7202c8ded708c8c206568924ff1b6a.webp"
"MediaSize" => 134486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-1f7202c8ded708c8c206568924ff1b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6438177368"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/df9d24c0b20033370e0d7594dbf3d940.webp"
"MediaSize" => 136470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-df9d24c0b20033370e0d7594dbf3d940.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6438177384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/468730401a63678e0ff94f290c897493.webp"
"MediaSize" => 131539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-468730401a63678e0ff94f290c897493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6438177425"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/ffa42255ea6f8f00ebdc270b16a02694.webp"
"MediaSize" => 140816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-ffa42255ea6f8f00ebdc270b16a02694.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6438177439"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/c85c1cb70d9e41fdbe4fb93a85cca16b.webp"
"MediaSize" => 127659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-c85c1cb70d9e41fdbe4fb93a85cca16b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6438177460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/ef36af763070867d7e85808dca1d1865.webp"
"MediaSize" => 116338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-ef36af763070867d7e85808dca1d1865.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6438177500"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/6b8bf13ec96996661b0bba2d4d20343e.webp"
"MediaSize" => 129023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-6b8bf13ec96996661b0bba2d4d20343e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6438177527"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/ac8a29f51eddb17f127d4458ad9ce1eb.webp"
"MediaSize" => 134347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-ac8a29f51eddb17f127d4458ad9ce1eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6438177550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/84509225346dd5c5b917d3ce6eea33d9.webp"
"MediaSize" => 136983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29316483/thumbnail-84509225346dd5c5b917d3ce6eea33d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40801187"
"ResourceRecordKey" => "29316483"
"ModificationTimestamp" => "2026-02-03T02:18:47.07Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6438177563"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29316483/b1bf73e25a47a9dd108f5a558eb31ce7.webp"
"MediaSize" => 95299
"MediaType" => "webp"
…8
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 138
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29316483')"
+"ID": "1120921"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1114932"
+post_author: 1
+"ListingKey": "29307976"
+"ListingId": "X12744018"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-13T16:00:12Z"
+"RFModificationTimestamp": "2026-05-13T16:56:32Z"
+"ListPrice": 199000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3212.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Hamilton Beach)"
+"PostalCode": "L8G1A4"
+"UnparsedAddress": "1 & 2 - 754 QUEENSTON ROAD, Hamilton (Hamilton Beach), Ontario L8G1A4"
+"Coordinates": array:2 [
0 => -79.769122
1 => 43.228344
]
+"Latitude": 43.228344
+"Longitude": -79.769122
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "CAN BE CONVERTED INTO OTHER FOOD CONCEPT. Sarajevo Grill & Meat Business in Hamilton, ON is For Sale. Located at the busy intersection of Queenston Rd/Clapham Rd. Surrounded by Fully Residential Neighbourhood, Close to Schools, Highway, Offices, Banks, Major Big Box Store and Much More. Business with so much opportunity to grow the business even more. Monthly Sales: Approx: $50,000 - $52,000 before HST, Rent: $7561.82/m including TMI & HST, Lease Term: Existing 5 + Option to renew, Seating: 35. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-01-31T00:58:53.814425+00:00"
+"Directions": "Cross Streets: Queenston Rd/Greenford Dr. ** Directions: Turn right on Queenston Rd."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964360"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-01-30T23:12:08Z"
+"PhotosCount": 47
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-13T15:51:28Z"
+"StreetName": "Queenston"
+"StreetNumber": "754"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Hamilton Beach"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29307976/1-2-754-queenston-road-hamilton-hamilton-beach-hamilton-beach"
+"CoListAgentKey": "2196919"
+"CoListOfficeKey": "146431"
+"GeocodeManualYN": false
+"ZoningDescription": "HH"
+"OriginalEntryTimestamp": "2026-01-30T23:12:08.62Z"
+"ListAgentNationalAssociationId": "1253104"
+"ListOfficeNationalAssociationId": "1231804"
+"CoListAgentNationalAssociationId": "1445459"
+"CoListOfficeNationalAssociationId": "1201577"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 141
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29307976')"
+"ID": "1114932"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1109212"
+post_author: 1
+"ListingKey": "29298322"
+"ListingId": "X12736480"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-23T04:20:11Z"
+"RFModificationTimestamp": "2026-03-23T04:22:27Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1725.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E1H6"
+"UnparsedAddress": "# 2 - 40 CENTENNIAL PARKWAY N, Hamilton (Riverdale), Ontario L8E1H6"
+"Coordinates": array:2 [
0 => -79.763072
1 => 43.229207
]
+"Latitude": 43.229207
+"Longitude": -79.763072
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRIME LOCATION !!!!! In the Heart of Hamilton ,High-traffic marinated meats and ready-to-eat restaurant in Hamilton! This well-established business offers over 1,700 sq. ft. of clean, professionally maintained commercial space and one of the best restaurant & meat shop unique niche with strong demand in Hamilton In addition to its specialty meats, it also serves high-quality ready-to-eat meals, attracting a loyal customer base, The restaurant is strategically located right off the QEW, across from a busy mall with excellent visibility and foot traffic, and with the upcoming LRT line set to pass directly through the mall parking lot, the location is truly future-proof with projected growth in footfall. The space comes fully equipped with two bathrooms, a custom-built walk-in freezer and refrigerator, meat cutter and grinder, two custom deli display fridges, as well as a back office complete with desk, computer, monitor, and printer. With ample parking and prominent signage exposure, the business is turnkey and revenue-ready from Day 1. Buyers have full flexibility to take over with or without the franchise brand, and the layout allows easy conversion into a full dine-in restaurant, catering kitchen, or even a hybrid fusion concept. Offering excellent growth potential through catering, delivery, and dine-in services, this opportunity is perfect for entrepreneurs looking to step into a proven and scalable food business. Very Good Google Rating as well , A must see Business for restaurant lovers. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-01-28T23:38:35.273351+00:00"
+"Directions": "Queenston Rd/ Centennial Pkwy"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068144"
+"ListOfficeKey": "65275"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-01-28T19:40:56Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-23T04:11:01Z"
+"StreetDirSuffix": "North"
+"StreetName": "Centennial"
+"StreetNumber": "40"
+"StreetSuffix": "Parkway"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Riverdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29298322/2-40-centennial-parkway-n-hamilton-riverdale-riverdale"
+"CoListAgentKey": "2166743"
+"CoListOfficeKey": "65275"
+"GeocodeManualYN": false
+"ZoningDescription": "commercial"
+"OriginalEntryTimestamp": "2026-01-28T19:40:55.95Z"
+"ListAgentNationalAssociationId": "1343210"
+"ListOfficeNationalAssociationId": "1260430"
+"CoListAgentNationalAssociationId": "1417654"
+"CoListOfficeNationalAssociationId": "1260430"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 144
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29298322')"
+"ID": "1109212"
}
]
+success: true
+page_size: 9
+page_count: 1
+count: 9
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]