array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29426310 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: "1196064"
+post_author: 1
+"ListingKey": "29426310"
+"ListingId": "X12844056"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-04T17:20:23Z"
+"RFModificationTimestamp": "2026-03-04T20:27:10Z"
+"ListPrice": 2290000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5600.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "23 GRIFFIN STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8908648
1 => 43.3332351
]
+"Latitude": 43.3332351
+"Longitude": -79.8908648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Attention investors and business owners! Don't miss out on the opportunity to establish your business in the fast growing community of Waterdown Hamilton. This Mixed use commercial building is located in the heart of Watertown. With 5,600 square feet of interior space with high ceilings this property is ideal for many uses including Medical/Dental, spa, retail, professional office, art gallery, private schools ,daycare, and much more. The property is approximately 12,000 sqft and is corner lot of Griffin & Franklin Street with easy access. The property also features finished offices with reception, boardroom, kitchen. There is a warehouse and loading bay which can be converted to more office/retail space if needed. With ample parking and steps away from many other businesses and amenities this property would be ideal for many types of uses! (id:62650)"
+"BuildingAreaUnits": "square feet"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-03-04T20:26:57.943872+00:00"
+"Directions": "Mill St & Dundas St East"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932061"
+"ListOfficeKey": "277038"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Bldg=109.5 x 109.9 FT"
+"PhotosChangeTimestamp": "2026-03-04T17:14:08Z"
+"PhotosCount": 42
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-04T17:14:08Z"
+"StreetName": "Griffin"
+"StreetNumber": "23"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "24125"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=HYs8bRJY5LM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29426310/23-griffin-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "1773041"
+"CoListOfficeKey": "283223"
+"GeocodeManualYN": false
+"ZoningDescription": "C5A"
+"FrontageLengthNumeric": 109.6
+"OriginalEntryTimestamp": "2026-03-04T17:14:07.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1232427"
+"ListOfficeNationalAssociationId": "1280178"
+"CoListAgentNationalAssociationId": "1186643"
+"CoListOfficeNationalAssociationId": "1326005"
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6493242868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/122aca5c74308067a24c1d9c119f1fc1.webp"
"MediaSize" => 113450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-122aca5c74308067a24c1d9c119f1fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6493242880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/4cd492018f2dc0312899102b077b03db.webp"
"MediaSize" => 102912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-4cd492018f2dc0312899102b077b03db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6493242899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/195aa032145c2fdcbe34aa95660d00d0.webp"
"MediaSize" => 112062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-195aa032145c2fdcbe34aa95660d00d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6493242947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/5565c0f881d44f6489e0c6cb4f63cf91.webp"
"MediaSize" => 157278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-5565c0f881d44f6489e0c6cb4f63cf91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6493242962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/4e816b4b1ecc399c381891daf0f3767a.webp"
"MediaSize" => 78020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-4e816b4b1ecc399c381891daf0f3767a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6493243007"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/d929de761d32559caeddefb53baf6bdd.webp"
"MediaSize" => 81790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-d929de761d32559caeddefb53baf6bdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6493243016"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/54dec3b011453bf5cff1b8c7137e4bcb.webp"
"MediaSize" => 95609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-54dec3b011453bf5cff1b8c7137e4bcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6493243053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/ac08b08033fbfb193bcca0432fae8089.webp"
"MediaSize" => 101169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-ac08b08033fbfb193bcca0432fae8089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6493243090"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/3cab2ec88764c3faba07ab37f32ded20.webp"
"MediaSize" => 95228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-3cab2ec88764c3faba07ab37f32ded20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6493243120"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/1cc9e012a703c93714a37e10a02ecfa1.webp"
"MediaSize" => 86372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-1cc9e012a703c93714a37e10a02ecfa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6493243138"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/1019c1ac84281d4f7907363313e8871e.webp"
"MediaSize" => 89167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-1019c1ac84281d4f7907363313e8871e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6493243163"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/005a20b62daa7675deb1be850ad1991d.webp"
"MediaSize" => 88469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-005a20b62daa7675deb1be850ad1991d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6493243224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/951acf29987a1f297c8a78f7b7d6c997.webp"
"MediaSize" => 80104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-951acf29987a1f297c8a78f7b7d6c997.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6493243245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/009399d2c07dd0861b1b7ad3b488f724.webp"
"MediaSize" => 105801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-009399d2c07dd0861b1b7ad3b488f724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6493243265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/448c4ed2abcd3c21a7f553258c5d577b.webp"
"MediaSize" => 96078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-448c4ed2abcd3c21a7f553258c5d577b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6493243299"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/63bbbf13c928a3eb9abf623a9496e306.webp"
"MediaSize" => 56974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-63bbbf13c928a3eb9abf623a9496e306.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6493243354"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/ca809460514ac8a8556b4411827d774f.webp"
"MediaSize" => 112446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-ca809460514ac8a8556b4411827d774f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6493243403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/4d49944ce5624ebaee2808525ac85176.webp"
"MediaSize" => 110913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-4d49944ce5624ebaee2808525ac85176.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6493243425"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/10858b33b5c82f5a01770852f0a1b1f3.webp"
"MediaSize" => 109404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-10858b33b5c82f5a01770852f0a1b1f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6493243440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/1a5da8fd35a3c9e34bbac5801a38572a.webp"
"MediaSize" => 119202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-1a5da8fd35a3c9e34bbac5801a38572a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6493243470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/f60169cc8e04e93847ff355aecd3b7ea.webp"
"MediaSize" => 77807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-f60169cc8e04e93847ff355aecd3b7ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6493243483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/a9d0073b67c6ebacc708def352ca2228.webp"
"MediaSize" => 92216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-a9d0073b67c6ebacc708def352ca2228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6493243511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/2c832f37ad712b9c5d3d3572b3035a64.webp"
"MediaSize" => 117155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-2c832f37ad712b9c5d3d3572b3035a64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6493243527"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/29fda9aceef76bffceb1b0bb725520b2.webp"
"MediaSize" => 75797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-29fda9aceef76bffceb1b0bb725520b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6493243554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/c4e9520ae99c5bcb3b1dfe926b58490c.webp"
"MediaSize" => 96629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-c4e9520ae99c5bcb3b1dfe926b58490c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6493243568"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/0417735605681c745aeca1f3723cec15.webp"
"MediaSize" => 52829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-0417735605681c745aeca1f3723cec15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6493243600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/232e130fac72fd97d57eb22996ae47d6.webp"
"MediaSize" => 82480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-232e130fac72fd97d57eb22996ae47d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6493243613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/57154150c8c94034044d5b187d5795f2.webp"
"MediaSize" => 112873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-57154150c8c94034044d5b187d5795f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6493243641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/253910ae7c67abdbb6bb09362714eeb9.webp"
"MediaSize" => 62325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-253910ae7c67abdbb6bb09362714eeb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6493243665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/63e987e037f485ff5acb60221e8a8c10.webp"
"MediaSize" => 47695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-63e987e037f485ff5acb60221e8a8c10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6493243682"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/c5c5ef6a28e91270d3aabd0e904e6df3.webp"
"MediaSize" => 56907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-c5c5ef6a28e91270d3aabd0e904e6df3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6493243705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/513129f646d52f034a229e6163cfb4cf.webp"
"MediaSize" => 48779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-513129f646d52f034a229e6163cfb4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6493243724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/63d8a7e4cf6d7bd08968cddddcae8bda.webp"
"MediaSize" => 43612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-63d8a7e4cf6d7bd08968cddddcae8bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6493243742"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/d0b0d69c40b79447d961fb556da83a76.webp"
"MediaSize" => 55446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-d0b0d69c40b79447d961fb556da83a76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6493243752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/c9555b5662b2feab6a3f50f5046de636.webp"
"MediaSize" => 100855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-c9555b5662b2feab6a3f50f5046de636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6493243766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/adf3daa510eb7011ca68235f2348d3a0.webp"
"MediaSize" => 138574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-adf3daa510eb7011ca68235f2348d3a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6493243785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/31a43cdf327ce990f1e233cde422ae4a.webp"
"MediaSize" => 129938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-31a43cdf327ce990f1e233cde422ae4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6493243801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/63ecd1e74286edbe529405edd2f3d1ee.webp"
"MediaSize" => 92159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-63ecd1e74286edbe529405edd2f3d1ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6493243815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/27c75741642d13025d603acf5f62260f.webp"
"MediaSize" => 44342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-27c75741642d13025d603acf5f62260f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6493243831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/be8a4fa6a1527658a55e7925f3da9d45.webp"
"MediaSize" => 94048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-be8a4fa6a1527658a55e7925f3da9d45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6493243846"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/540b193348233db3113299f746890c86.webp"
"MediaSize" => 179541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-540b193348233db3113299f746890c86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6493243849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29426310/a4b0bac58db43645f76cdfdf0f63d5cc.webp"
"MediaSize" => 154939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29426310/thumbnail-a4b0bac58db43645f76cdfdf0f63d5cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12844056"
"ResourceRecordKey" => "29426310"
"ModificationTimestamp" => "2026-03-04T17:14:08.01Z"
]
]
+"DaysOnMarket": 108
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29426310')"
+"ID": "1196064"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 277038" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24902
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24903
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "277038"
+"ModificationTimestamp": "2025-09-09T22:04:45Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "277038"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('277038')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1932061" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29426310'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25218
+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 '29426310'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25234
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29426310' 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.8908648 43.3332351)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1524476"
+post_author: 1
+"ListingKey": "29894529"
+"ListingId": "40839275"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:50:10Z"
+"RFModificationTimestamp": "2026-06-16T17:11:34Z"
+"ListPrice": 4750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 10968.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD Trail Unit# 2nd, Waterdown, Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.8768347
1 => 43.3440558
]
+"Latitude": 43.3440558
+"Longitude": -79.8768347
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brand New 2-storey, 11000+/- Sq Ft Retail or Medical Plaza Build with Delivery in 15 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,000 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-12T20:09:20.791502+00:00"
+"Directions": "Dundas St to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-06-16T16:43:01Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:43:01Z"
+"Stories": "2.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894529/39-mallard-trail-unit-2nd-waterdown"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2258783"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "55165"
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-06-12T14:20:17.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListAgentNationalAssociationId2": "1498689"
+"CoListOfficeNationalAssociationId": "1114492"
+"CoListOfficeNationalAssociationId2": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894529_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894529/3d517675aa3aa84d93530f1819981943.webp"
"MediaSize" => 68680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894529/thumbnail-3d517675aa3aa84d93530f1819981943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839275"
"ResourceRecordKey" => "29894529"
"ModificationTimestamp" => "2026-06-12T14:20:17.32Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894529')"
+"ID": "1524476"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1527575"
+post_author: 1
+"ListingKey": "29895447"
+"ListingId": "X13437136"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:05:19Z"
+"RFModificationTimestamp": "2026-06-12T16:22:36Z"
+"ListPrice": 4750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 10968.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "2ND - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.877076
1 => 43.344024
]
+"Latitude": 43.344024
+"Longitude": -79.877076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Brand New 2-storey, 11000+/- Sq Ft Retail or Medical Plaza Build with Delivery in 15 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,000 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. (id:62783)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-12T16:22:30.100450+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Trail."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-06-12T15:55:47Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:55:47Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895447/2nd-39-mallard-trail-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-06-12T15:55:47.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895447_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895447/f787ad76d825066bcad19f1e0a4cf8ef.webp"
"MediaSize" => 167103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895447/thumbnail-f787ad76d825066bcad19f1e0a4cf8ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13437136"
"ResourceRecordKey" => "29895447"
"ModificationTimestamp" => "2026-06-12T15:55:47.82Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895447')"
+"ID": "1527575"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1471334"
+post_author: 1
+"ListingKey": "29820828"
+"ListingId": "X13210704"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-28T21:00:45Z"
+"RFModificationTimestamp": "2026-05-28T22:55:31Z"
+"ListPrice": 249000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "255 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.89711
1 => 43.330215
]
+"Latitude": 43.330215
+"Longitude": -79.89711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "BAR BURRITO Business in Waterdown, ON is For Sale. Located at the busy intersection of Dundas St E/Hamilton St N. Surrounded by Fully Residential Neighbourhood, Close to Schools, Offices, Banks, Major Big Box Store and Much More. Business with so much opportunity to grow the business even more. Rent: $5420/m including TMI & HST, Lease Term: Existing 7 years + Option to renew, Royalty: 5%, Advertising: 2%. (id:62783)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-28T22:55:19.263016+00:00"
+"Directions": "Cross Streets: Dundas St E/Hamilton St N. ** Directions: Turn right on Dundas St E."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964360"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-28T20:53:56Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-28T20:53:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "255"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29820828/255-dundas-street-e-hamilton-waterdown-waterdown"
+"CoListAgentKey": "2196919"
+"CoListOfficeKey": "146431"
+"GeocodeManualYN": false
+"ZoningDescription": "C5"
+"OriginalEntryTimestamp": "2026-05-28T20:53:56.49Z"
+"ListAgentNationalAssociationId": "1253104"
+"ListOfficeNationalAssociationId": "1231804"
+"CoListAgentNationalAssociationId": "1445459"
+"CoListOfficeNationalAssociationId": "1201577"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29820828_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820828/419500f486abca0d0c720eb7cc7bc15d.webp"
"MediaSize" => 13471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820828/thumbnail-419500f486abca0d0c720eb7cc7bc15d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13210704"
"ResourceRecordKey" => "29820828"
"ModificationTimestamp" => "2026-05-28T20:53:56.5Z"
]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820828')"
+"ID": "1471334"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1430824"
+post_author: 1
+"ListingKey": "29761350"
+"ListingId": "X13135788"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-15T20:01:04Z"
+"RFModificationTimestamp": "2026-05-15T22:58:04Z"
+"ListPrice": 3499900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.877076
1 => 43.344024
]
+"Latitude": 43.344024
+"Longitude": -79.877076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Brand New Retail or Medical Plaza Build with Delivery in 12 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,318 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. Need more space?!?, the final construction may allow for a second storey to be added. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-15T22:57:56.526866+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Trail."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-05-15T19:53:39Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-15T19:53:39Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29761350/39-mallard-trail-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-15T19:53:39.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29761350_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29761350/50fcdc666d807f50c7ce61c807f4598d.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29761350/thumbnail-50fcdc666d807f50c7ce61c807f4598d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13135788"
"ResourceRecordKey" => "29761350"
"ModificationTimestamp" => "2026-05-15T19:53:39.07Z"
]
]
+"DaysOnMarket": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29761350')"
+"ID": "1430824"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1427206"
+post_author: 1
+"ListingKey": "29759466"
+"ListingId": "40830629"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:15Z"
+"RFModificationTimestamp": "2026-06-02T16:33:46Z"
+"ListPrice": 3499900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD Trail, Waterdown, Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.8768458
1 => 43.3440478
]
+"Latitude": 43.3440478
+"Longitude": -79.8768458
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brand New Retail or Medical Plaza Build with Delivery in 12 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,318 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. Need more space?!?, the final construction may allow for a second storey to be added. Reach out now (before the shovel is in the ground) to understand all the possibilities available to qualified buyers. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-15T20:51:04.236969+00:00"
+"Directions": "Dundas St to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-05-15T16:50:51Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:23:25Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29759466/39-mallard-trail-waterdown"
+"StructureType": array:1 [
0 => "Commercial Apartment"
]
+"CoListAgentKey": "2007886"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-15T16:50:51.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29759466_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29759466/772d60ada406a323828a60c62783e990.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29759466/thumbnail-772d60ada406a323828a60c62783e990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830629"
"ResourceRecordKey" => "29759466"
"ModificationTimestamp" => "2026-05-15T16:50:51.14Z"
]
]
+"DaysOnMarket": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29759466')"
+"ID": "1427206"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1344349"
+post_author: 1
+"ListingKey": "29642054"
+"ListingId": "X13031460"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-22T19:05:58Z"
+"RFModificationTimestamp": "2026-04-22T19:48:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 871.0
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "9 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8934625
1 => 43.3336996
]
+"Latitude": 43.3336996
+"Longitude": -79.8934625
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime owner-user opportunity in the heart of Waterdown's growing commercial corridor. 9 Main St N offers a well-maintained, turnkey retail/restaurant building with a stable in-place tenant (The Shawarma House - business available separately), providing flexibility for investors or future owner-occupiers. The property has benefited from meaningful capital improvements, including updated ventilation (2019), roof replacement (approx. 2017), interior renovations (2019), and a new air conditioning unit (2025), reducing near-term capital risk. Positioned on Main Street North with strong visibility, consistent traffic, and surrounded by ongoing residential growth, this asset offers long-term upside through both occupancy and rental growth. Ideal for restaurateurs, service-based users, or investors seeking a foothold in one of Waterdown's most active and evolving nodes. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-04-22T19:48:15.553203+00:00"
+"Directions": "Cross Streets: Main St and Dundas St E. ** Directions: Dundas to Main St."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422448"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "871"
+"PhotosChangeTimestamp": "2026-04-22T18:48:45Z"
+"PhotosCount": 6
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-22T18:48:45Z"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "9"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29642054/9-main-street-n-hamilton-waterdown-waterdown"
+"CoListAgentKey": "2140403"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a - Exception 752, 753"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-04-22T18:48:45.24Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1122944"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1392266"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6620191456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/e09a48992b80f9e9e9a8c3d5503ddddf.webp"
"MediaSize" => 325006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-e09a48992b80f9e9e9a8c3d5503ddddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6620191471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/a4fb5696f004d0a6de51889469bf4aeb.webp"
"MediaSize" => 306210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-a4fb5696f004d0a6de51889469bf4aeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6620191544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/48449277bfd2a745b1e40638a29a3def.webp"
"MediaSize" => 341720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-48449277bfd2a745b1e40638a29a3def.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6620191606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/6f756cf634dd83ea3359c41c6daf74b0.webp"
"MediaSize" => 354595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-6f756cf634dd83ea3359c41c6daf74b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6620191683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/a127a8db036e335c4967c068edf8df29.webp"
"MediaSize" => 352907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-a127a8db036e335c4967c068edf8df29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6620191752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/125a9c96b82df72b5635b501ec7b61e5.webp"
"MediaSize" => 357645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-125a9c96b82df72b5635b501ec7b61e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
]
+"DaysOnMarket": 59
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29642054')"
+"ID": "1344349"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1343973"
+post_author: 1
+"ListingKey": "29641444"
+"ListingId": "40822749"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:40Z"
+"RFModificationTimestamp": "2026-06-02T17:42:44Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.02
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "9 N MAIN Street N, Hamilton, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8936404
1 => 43.3337097
]
+"Latitude": 43.3337097
+"Longitude": -79.8936404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime owner-user opportunity in the heart of Waterdown’s growing commercial corridor. 9 Main St N offers a well-maintained, turnkey retail/restaurant building with a stable in-place tenant (The Shawarma House – business available separately), providing flexibility for investors or future owner-occupiers. The property has benefited from meaningful capital improvements, including updated ventilation (2019), roof replacement (approx. 2017), interior renovations (2019), and a new air conditioning unit (2025), reducing near-term capital risk. Positioned on Main Street North with strong visibility, consistent traffic, and surrounded by ongoing residential growth, this asset offers long-term upside through both occupancy and rental growth. Ideal for restaurateurs, service-based users, or investors seeking a foothold in one of Waterdown’s most active and evolving nodes. (id:62783)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-04-22T18:50:24.917454+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025166"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.02"
+"PhotosChangeTimestamp": "2026-04-22T18:00:53Z"
+"PhotosCount": 6
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:39:19Z"
+"Stories": "1.0"
+"StreetDirPrefix": "North"
+"StreetDirSuffix": "North"
+"StreetName": "MAIN"
+"StreetNumber": "9"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29641444/9-n-main-street-n-hamilton"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2139701"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a - Exception 752, 753"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-04-22T18:00:53.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304838"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1391481"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6620097684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/8da104dc20a3c366563982132c57cdd3.webp"
"MediaSize" => 132693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-8da104dc20a3c366563982132c57cdd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a dark gray stucco exterior, a dark shingle roof, a prominent storefront window, and an arched entrance awning"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6620097723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/b00585590bc2f682e22fbbfac92b6385.webp"
"MediaSize" => 136895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-b00585590bc2f682e22fbbfac92b6385.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial property with a dark exterior, arched entry, and prominent roofline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6620097753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/7cc9cff5ecad51fcc54147f2229eb364.webp"
"MediaSize" => 158188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-7cc9cff5ecad51fcc54147f2229eb364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a textured gray exterior and black window awnings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6620097795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/5da8294e370cd20cfc150ca182844c98.webp"
"MediaSize" => 150324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-5da8294e370cd20cfc150ca182844c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6620097809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/cc4bf8edacc4d1566577a96fb188ed95.webp"
"MediaSize" => 153001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-cc4bf8edacc4d1566577a96fb188ed95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gray stucco exterior with a dark shingle roof and a single window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6620097858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/a662c13cacc95e5af9e23c8b2ba5f184.webp"
"MediaSize" => 147362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-a662c13cacc95e5af9e23c8b2ba5f184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a dark gray exterior, prominent street frontage, and a covered entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
]
+"DaysOnMarket": 59
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29641444')"
+"ID": "1343973"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1332834"
+post_author: 1
+"ListingKey": "29625523"
+"ListingId": "X13016632"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T20:50:33Z"
+"RFModificationTimestamp": "2026-04-18T22:42:23Z"
+"ListPrice": 99000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 871.0
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "9 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.893463
1 => 43.333656
]
+"Latitude": 43.333656
+"Longitude": -79.893463
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is a rare chance to acquire a versatile 871 sq. ft. of efficient usable space, in a detached building with a high-visibility, high-traffic location. Currently operating as a clean, well-maintained shawarma restaurant. Whether you choose to continue the successful "The Shawarma House" operation or bring a brand-new vision to life, this turn-key space is ready for immediate takeover. This is Premium Location, A freestanding building situated in the heart of downtown Waterdown, offering exceptional street visibility and a charming "main street" presence. The sale includes all equipment and infrastructure-literally "plug and play." 12-foot hood range already installed - 18-seat indoor dining area. Huge basement is included as an added value. Monthly Rent: Approximately $3,300 (inclusive TMI and HST) Growth Potential: Features a solid existing customer base. The Seller is willing to provide training to ensure a smooth transition for the new operator. (id:62650)"
+"Appliances": array:1 [
0 => "Furniture"
]
+"BuildingAreaUnits": "square feet"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-04-18T22:42:17.765162+00:00"
+"Directions": "Dundas, North on Main St. N."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128734"
+"ListOfficeKey": "50753"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "871"
+"PhotosChangeTimestamp": "2026-04-18T20:43:05Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-18T20:43:04Z"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "9"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29625523/9-main-street-n-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "CSA"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-04-18T20:43:04.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381836"
+"ListOfficeNationalAssociationId": "1002240"
+"Media": array:4 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6610610464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625523/597d26452d4e0fa3c5a4dc4794bc5b06.webp"
"MediaSize" => 410534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625523/thumbnail-597d26452d4e0fa3c5a4dc4794bc5b06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13016632"
"ResourceRecordKey" => "29625523"
"ModificationTimestamp" => "2026-04-18T20:43:04.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6610610483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625523/77e630c5da6dabaf0250f8719eb5179b.webp"
"MediaSize" => 460155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625523/thumbnail-77e630c5da6dabaf0250f8719eb5179b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016632"
"ResourceRecordKey" => "29625523"
"ModificationTimestamp" => "2026-04-18T20:43:04.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6610610575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625523/a325b5792814e7453de3d91476af8e4b.webp"
"MediaSize" => 215606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625523/thumbnail-a325b5792814e7453de3d91476af8e4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016632"
"ResourceRecordKey" => "29625523"
"ModificationTimestamp" => "2026-04-18T20:43:04.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6610610656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625523/26b37eb106ceff7a040bdf91266852fe.webp"
"MediaSize" => 342119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625523/thumbnail-26b37eb106ceff7a040bdf91266852fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016632"
"ResourceRecordKey" => "29625523"
"ModificationTimestamp" => "2026-04-18T20:43:04.97Z"
]
]
+"DaysOnMarket": 63
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29625523')"
+"ID": "1332834"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1248569"
+post_author: 1
+"ListingKey": "29479170"
+"ListingId": "X12890066"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:50:46Z"
+"RFModificationTimestamp": "2026-03-24T13:52:54Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1049.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "1 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.900589
1 => 43.32762
]
+"Latitude": 43.32762
+"Longitude": -79.900589
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Turnkey investment opportunity offering a strong 5.75% cap rate. Featuring a international, well established tenant (Edward Jones) secured by a long term lease with built-in rental escalations. This nearly new corner unit offers 1,049 sqft plus a full basement, providing excellent utility and flexibility. Ample street frontage with abundant visitor parking. Ideally situated on one of Waterdown's busiest corridors, surrounded by a dense and growing residential community of thousands of homes, ensuring consistent exposure and long term value. (id:62650)"
+"BuildingAreaUnits": "square feet"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-03-24T13:52:34.468551+00:00"
+"Directions": "Dundas & Waterdown"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003282"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-03-17T12:36:46Z"
+"PhotosCount": 8
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-24T13:42:32Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10601.43"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29479170/1-219-dundas-street-e-hamilton-waterdown-waterdown"
+"StructureType": array:1 [
0 => "Retail"
]
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial / Retail"
+"OriginalEntryTimestamp": "2026-03-17T12:36:46.6Z"
+"ListAgentNationalAssociationId": "1286167"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:8 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6538714293"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/86110848b7467d9202db5b7d45a4bd77.webp"
"MediaSize" => 132502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-86110848b7467d9202db5b7d45a4bd77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6538714302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/8bc52511d09128b34f452c7e62c06453.webp"
"MediaSize" => 68003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-8bc52511d09128b34f452c7e62c06453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6538714357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/77f865418a931f11a68ab8ae985e7852.webp"
"MediaSize" => 128188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-77f865418a931f11a68ab8ae985e7852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6538714417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/a49f98a6c70178cc6a06b0b0af6ea4cb.webp"
"MediaSize" => 59029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-a49f98a6c70178cc6a06b0b0af6ea4cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6538714440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/98132d69f3edf121fd66d015d203360c.webp"
"MediaSize" => 58477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-98132d69f3edf121fd66d015d203360c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6538714508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/927a8b10ddba614e98738459488f94aa.webp"
"MediaSize" => 126215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-927a8b10ddba614e98738459488f94aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6538714557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/877e5711572eedb315cfddde93c9a7c8.webp"
"MediaSize" => 81434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-877e5711572eedb315cfddde93c9a7c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6538714622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/f85b12c6bf20982c32f34246ea60c671.webp"
"MediaSize" => 103115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-f85b12c6bf20982c32f34246ea60c671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
]
+"DaysOnMarket": 95
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29479170')"
+"ID": "1248569"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]