array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28524893 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: "750792"
+post_author: 1
+"ListingKey": "28524893"
+"ListingId": "40745281"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:35:33Z"
+"RFModificationTimestamp": "2026-06-02T18:14:09Z"
+"ListPrice": 1750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 7585.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "22 MILL Street S, Hamilton, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.89136301
1 => 43.33389666
]
+"Latitude": 43.33389666
+"Longitude": -79.89136301
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Heritage-designated mixed-use building in downtown Waterdown. 3 commercial units on main level, 4 residential units above. All tenants in good standing. 22 dedicated on-site parking spaces. Well-maintained by long-term owner with visible pride of ownership. Excellent tenant mix with stable income and minimal turnover. Please do not approach tenants. Financials available upon request with signed NDA. Showings require a minimum 24–48 hours' notice. (id:62650)"
+"Basement": array:1 [
0 => "Partial"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-06-28T10:45:07.399839+00:00"
+"Directions": "DUNDAS ST TO MILL STREET, SOUTH"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-07-05T12:30:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T17:03:59Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "22"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "19685.02"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/22_mill_st_s_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28524893/22-mill-street-s-hamilton"
+"ParkingTotal": 22
+"StructureType": array:1 [
0 => "Commercial Apartment"
]
+"CoListAgentKey": "1982606"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a"
+"FrontageLengthNumeric": 115.0
+"OriginalEntryTimestamp": "2025-06-26T17:07:27.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1063775"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1267853"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6074460339"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/ba608e292b47d5e3c54b7333e5c47b04.webp"
"MediaSize" => 125615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-ba608e292b47d5e3c54b7333e5c47b04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.8Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6074460402"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/59db603d8190a41356000b4d4610ae31.webp"
"MediaSize" => 140714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-59db603d8190a41356000b4d4610ae31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.82Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6074460478"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/dd675de3c9722e7844c236713c0a9e12.webp"
"MediaSize" => 126762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-dd675de3c9722e7844c236713c0a9e12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6074460562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/c216772bb62213acc215359cb3a37aba.webp"
"MediaSize" => 167871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-c216772bb62213acc215359cb3a37aba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.82Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6074460581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/28fbb4c350aed6259f476a86a572b753.webp"
"MediaSize" => 129049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-28fbb4c350aed6259f476a86a572b753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6074460643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/413361d1c27bfdf1b3865e6d0cb45df2.webp"
"MediaSize" => 119004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-413361d1c27bfdf1b3865e6d0cb45df2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.83Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6074460685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/7998c6363d01aa57ff2acd28583dbb25.webp"
"MediaSize" => 108500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-7998c6363d01aa57ff2acd28583dbb25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.81Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6074460727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/87cfb267d59a8ee0870bf0ca95c15ed8.webp"
"MediaSize" => 98582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-87cfb267d59a8ee0870bf0ca95c15ed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.8Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6074460744"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/08ab29498f8321aeb25e965a5f371db4.webp"
"MediaSize" => 97400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-08ab29498f8321aeb25e965a5f371db4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.82Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6074460783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/1ecd388ac807c8669c90c091c89d0688.webp"
"MediaSize" => 104378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-1ecd388ac807c8669c90c091c89d0688.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.87Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6074460852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/cbf0e20cf8fb8dba2c1e7de9a57b38b2.webp"
"MediaSize" => 74325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-cbf0e20cf8fb8dba2c1e7de9a57b38b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.75Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6074460895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/cdb2281dfd78caf1d365d3392798e3fa.webp"
"MediaSize" => 86774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-cdb2281dfd78caf1d365d3392798e3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.87Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6074460952"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/da362f60509d2f95db0de02725efcbde.webp"
"MediaSize" => 70177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-da362f60509d2f95db0de02725efcbde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6074461025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/464caea4dac8c57a2b7ea65188f9acf9.webp"
"MediaSize" => 67148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-464caea4dac8c57a2b7ea65188f9acf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.78Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6074461111"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/f657bcc76b504dc17269bb197bf38f61.webp"
"MediaSize" => 81688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-f657bcc76b504dc17269bb197bf38f61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6074461206"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/54262ff1b74db08b1296d504e09c8861.webp"
"MediaSize" => 67614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-54262ff1b74db08b1296d504e09c8861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.87Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6074461278"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/727ef91e6f7e68fbfd93253dc2690530.webp"
"MediaSize" => 67759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-727ef91e6f7e68fbfd93253dc2690530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6074461343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/d89e3b49ee7c53dcc986fc02023a9823.webp"
"MediaSize" => 92513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-d89e3b49ee7c53dcc986fc02023a9823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6074461442"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/a4f0058bdd175b841e5ef404b08311d3.webp"
"MediaSize" => 66697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-a4f0058bdd175b841e5ef404b08311d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6074461513"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/c5762c8de4598fcb08c5d24e977e5e1e.webp"
"MediaSize" => 57200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-c5762c8de4598fcb08c5d24e977e5e1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6074461586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/8b29d0d62d99b93dd5fcd5aef319d977.webp"
"MediaSize" => 105899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-8b29d0d62d99b93dd5fcd5aef319d977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6074461714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/b008a9bac7fea2cf6e052822fb6200c5.webp"
"MediaSize" => 87718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-b008a9bac7fea2cf6e052822fb6200c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6074461795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/fed8ae570da94f553927bd9d56118272.webp"
"MediaSize" => 119243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-fed8ae570da94f553927bd9d56118272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.81Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6074461910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/2498c0a89e6f178967e3af4d6b33a68c.webp"
"MediaSize" => 105799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-2498c0a89e6f178967e3af4d6b33a68c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.81Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6074461965"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/2a5ec1bc035ce1fc6a25d999bd814375.webp"
"MediaSize" => 84282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-2a5ec1bc035ce1fc6a25d999bd814375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.82Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6074462044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/8d702c3427b2ef479c10ff0fac6046ec.webp"
"MediaSize" => 99143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-8d702c3427b2ef479c10ff0fac6046ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.87Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6074462158"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/521fa6fa99f6d86d0daab9494ca82c12.webp"
"MediaSize" => 108826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-521fa6fa99f6d86d0daab9494ca82c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6074462235"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/566ddf9b3dcd47f82b3aa8c41488a3fa.webp"
"MediaSize" => 109937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-566ddf9b3dcd47f82b3aa8c41488a3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.6Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6074462335"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/d073ffece912b8f3c484188eb26267a2.webp"
"MediaSize" => 111163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-d073ffece912b8f3c484188eb26267a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.82Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6074462437"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/9c6d2f79188c8a2d6bd2802ca5c857a2.webp"
"MediaSize" => 89222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-9c6d2f79188c8a2d6bd2802ca5c857a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.81Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6074462488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/adc27cf259175added479d232a387402.webp"
"MediaSize" => 54374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-adc27cf259175added479d232a387402.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.77Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6074462562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/ccdfa083123de9ff018aca9709610bc0.webp"
"MediaSize" => 61776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-ccdfa083123de9ff018aca9709610bc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.68Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6074462628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/c908baea9af95d7d99a2de3708fe53f6.webp"
"MediaSize" => 46327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-c908baea9af95d7d99a2de3708fe53f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.36Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6074462723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/987bc59268dc8a4843625cdcee4dc138.webp"
"MediaSize" => 45943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-987bc59268dc8a4843625cdcee4dc138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.63Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6074462840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/fe1afbb274ea7311c466c1caba254a56.webp"
"MediaSize" => 41742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-fe1afbb274ea7311c466c1caba254a56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.86Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6074462873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/3ad4e1aeaf4875e9ad26c5d91fee9b6a.webp"
"MediaSize" => 36919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-3ad4e1aeaf4875e9ad26c5d91fee9b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:08.67Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6074462946"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/1c360096a8d1e485e5e85c027c64919a.webp"
"MediaSize" => 24558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-1c360096a8d1e485e5e85c027c64919a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.64Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6074462988"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/79955e8561b743695b123785d173b10f.webp"
"MediaSize" => 106751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-79955e8561b743695b123785d173b10f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.6Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6074463000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/5b86ced80b8a6d30c4a75766d21aa783.webp"
"MediaSize" => 104085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-5b86ced80b8a6d30c4a75766d21aa783.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:10.68Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6074463088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/6fa9d46479f7a1add03d4d65b601deeb.webp"
"MediaSize" => 88159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-6fa9d46479f7a1add03d4d65b601deeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:10.68Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6074463135"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/876428c63bf62d36089081b6bf7382e2.webp"
"MediaSize" => 97750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-876428c63bf62d36089081b6bf7382e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:10.69Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6074463245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/46ce34ce64fb7dcfcb166716c98d66bd.webp"
"MediaSize" => 82216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-46ce34ce64fb7dcfcb166716c98d66bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.77Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6074463311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/4516701ea836a820db568f501f456711.webp"
"MediaSize" => 125488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-4516701ea836a820db568f501f456711.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:10.84Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6074463387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/7a632544a9156ba03fbf0765be36ee5f.webp"
"MediaSize" => 120614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-7a632544a9156ba03fbf0765be36ee5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:11.11Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6074463465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/cf104e638ab5f7ef8cd5a616b11e98b4.webp"
"MediaSize" => 128204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-cf104e638ab5f7ef8cd5a616b11e98b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.36Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6074463543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/13585f7487dfe08a6473b962923310af.webp"
"MediaSize" => 54113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-13585f7487dfe08a6473b962923310af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.68Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6074463608"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/efc1bd57bdc7a215a2306b649ec7cc1d.webp"
"MediaSize" => 67404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-efc1bd57bdc7a215a2306b649ec7cc1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:11.15Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6074463661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/2b03584555e9ad7edf784fb156437c16.webp"
"MediaSize" => 50612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-2b03584555e9ad7edf784fb156437c16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:10.84Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6074463714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/c41d27ac696c41b8dbddaf1447bd649a.webp"
"MediaSize" => 42991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-c41d27ac696c41b8dbddaf1447bd649a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:09.72Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6074463793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28524893/f59f4db8766a5197560527ee48f17820.webp"
"MediaSize" => 46195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28524893/thumbnail-f59f4db8766a5197560527ee48f17820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40745281"
"ResourceRecordKey" => "28524893"
"ModificationTimestamp" => "2025-07-05T12:30:11.11Z"
]
]
+"DaysOnMarket": 359
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28524893')"
+"ID": "750792"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283457" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24925
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525314" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24898
+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 '28524893'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25247
+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 '28524893'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '28524893' 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.89136301 43.33389666)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25336
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+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 {#25332
+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 {#25329
+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 {#25333
+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 {#25331
+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 {#25325
+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 {#25334
+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 {#25335
+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.14 seconds"
]
]