array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29491969 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1237411"
+post_author: 1
+"ListingKey": "29491969"
+"ListingId": "X12900214"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T23:56:12Z"
+"RFModificationTimestamp": "2026-05-25T00:05:18Z"
+"ListPrice": 80000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2Z8"
+"UnparsedAddress": "5 - 8 REGINA STREET N, Waterloo, Ontario N2J2Z8"
+"Coordinates": array:2 [
0 => -80.521075
1 => 43.465844
]
+"Latitude": 43.465844
+"Longitude": -80.521075
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Public Remarks: Turnkey bakery business available in the vibrant core of Uptown Waterloo. Crumby Pantry presents a unique opportunity to acquire a fully equipped, move-in ready operation with a distinctive brand and product offering. The sale includes all equipment, inventory, digital assets, and established branding, providing a seamless transition for a new owner. Ideal for an entrepreneur with a passion for local food and innovation, this business offers strong foundations with significant room for growth. Ownership is committed to training the right buyer. (id:62650)"
+"BusinessType": "Food Services and Beverage"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-03-19T18:23:06.574452+00:00"
+"Directions": "Cross Streets: Dupont St E. ** Directions: Dupont St E to Regina St N."
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091690"
+"ListOfficeKey": "286835"
+"PhotosChangeTimestamp": "2026-03-19T17:43:05Z"
+"PhotosCount": 39
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T23:48:04Z"
+"StreetDirSuffix": "North"
+"StreetName": "Regina"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/A7iaaml9Mlo"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29491969/5-8-regina-street-n-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "C7"
+"OriginalEntryTimestamp": "2026-03-19T17:43:05.27Z"
+"ListAgentNationalAssociationId": "1364243"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:39 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6528395359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/5d8c2620665f48c648179903f9e6cd40.webp"
"MediaSize" => 218109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-5d8c2620665f48c648179903f9e6cd40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6528395413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/fc0ed9170b792188d863c439fa291788.webp"
"MediaSize" => 421633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-fc0ed9170b792188d863c439fa291788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6528395511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/c083ddfa378564709ffd3d5da455fbce.webp"
"MediaSize" => 339684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-c083ddfa378564709ffd3d5da455fbce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6528395534"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/a098ac713bd46545146b7d292ea48311.webp"
"MediaSize" => 378155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-a098ac713bd46545146b7d292ea48311.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6528395644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/a764f7ce56f895e44274bbe33f9177f0.webp"
"MediaSize" => 206409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-a764f7ce56f895e44274bbe33f9177f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6528395716"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/3751b8968d486e664029849c3d94f6ed.webp"
"MediaSize" => 223486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-3751b8968d486e664029849c3d94f6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6528395778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/cc3985d1c59b68e35d56993904e4e3dd.webp"
"MediaSize" => 310577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-cc3985d1c59b68e35d56993904e4e3dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6528395882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/9f6b85b496d0ac88ede6261cdda7cde8.webp"
"MediaSize" => 236879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-9f6b85b496d0ac88ede6261cdda7cde8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6528395945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/486790887ef56e0c52fd9dbab29e43c0.webp"
"MediaSize" => 245619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-486790887ef56e0c52fd9dbab29e43c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6528396016"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/edd623f39a26a0d8b048b6fdedc72d0b.webp"
"MediaSize" => 234779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-edd623f39a26a0d8b048b6fdedc72d0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6528396125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/691c493d141686bf91b5e68c119648b3.webp"
"MediaSize" => 301943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-691c493d141686bf91b5e68c119648b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6528396195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/5ff8c9ca41c73ee296cc73299d6cdd32.webp"
"MediaSize" => 281609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-5ff8c9ca41c73ee296cc73299d6cdd32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6528396273"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/37a18f759b0ab107d99e432b05bfd0b7.webp"
"MediaSize" => 273521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-37a18f759b0ab107d99e432b05bfd0b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6528396366"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/508bf8e569f751b19d6a65d50547e53e.webp"
"MediaSize" => 318064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-508bf8e569f751b19d6a65d50547e53e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6528396377"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/6d11b32406c8647b1f6ab8a2f83734f5.webp"
"MediaSize" => 157743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-6d11b32406c8647b1f6ab8a2f83734f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6528396416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/d2c449fc8cd0b361d31bde4a3d5c8db2.webp"
"MediaSize" => 224835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-d2c449fc8cd0b361d31bde4a3d5c8db2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6528396482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/173e59a0cd5bf36f5f1d201555c4950d.webp"
"MediaSize" => 216121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-173e59a0cd5bf36f5f1d201555c4950d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6528396551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/11847493201948ac96bd62a02923ce56.webp"
"MediaSize" => 246366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-11847493201948ac96bd62a02923ce56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6528396622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/dd0392118c26f3cc4212c910bed3915f.webp"
"MediaSize" => 190385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-dd0392118c26f3cc4212c910bed3915f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6528396626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/cf82757c5ec775b974d658f6d42f4fc2.webp"
"MediaSize" => 137684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-cf82757c5ec775b974d658f6d42f4fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6528396746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/a649059a921b5fadf4d0bb059c5bb143.webp"
"MediaSize" => 220373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-a649059a921b5fadf4d0bb059c5bb143.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6528396768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/1e7565c11251d71a2c666368cd3b5a0d.webp"
"MediaSize" => 276374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-1e7565c11251d71a2c666368cd3b5a0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6528396777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/80a95172ca0e9fdbea29eba1d079b713.webp"
"MediaSize" => 114497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-80a95172ca0e9fdbea29eba1d079b713.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6528396863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/3c44ac855f14d2b7db0cad11d28746b6.webp"
"MediaSize" => 147750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-3c44ac855f14d2b7db0cad11d28746b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6528396871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/16c5eeae87258cfefd03586f23f5483a.webp"
"MediaSize" => 136730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-16c5eeae87258cfefd03586f23f5483a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6528396897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/e18d2cdfe443624c1e7f2a8b1a7e91d7.webp"
"MediaSize" => 214083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-e18d2cdfe443624c1e7f2a8b1a7e91d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6528396955"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/d7976044e0ab66a61a7f35b7ee9fbe35.webp"
"MediaSize" => 170895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-d7976044e0ab66a61a7f35b7ee9fbe35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6528397009"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/637596eb75380097ad8f91d420c29cc9.webp"
"MediaSize" => 222761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-637596eb75380097ad8f91d420c29cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6528397077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/26da6842d15789a66533a7b5cc5915eb.webp"
"MediaSize" => 240186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-26da6842d15789a66533a7b5cc5915eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6528397130"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/b746c64c4531fe3e0cc741dbbf5f8e85.webp"
"MediaSize" => 227501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-b746c64c4531fe3e0cc741dbbf5f8e85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6528397177"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/09e80a66b57cb492a67312f44dc8ca0e.webp"
"MediaSize" => 236511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-09e80a66b57cb492a67312f44dc8ca0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6528397204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/5453818518bb8e8ab9ca5a585a8873fe.webp"
"MediaSize" => 187107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-5453818518bb8e8ab9ca5a585a8873fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6528397247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/16414bb1394ec6e8542a86c39e49b313.webp"
"MediaSize" => 122351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-16414bb1394ec6e8542a86c39e49b313.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6528397277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/7311cb167b1cfce4e0db48a612b963d2.webp"
"MediaSize" => 114134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-7311cb167b1cfce4e0db48a612b963d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6528397308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/3b93b8d32feca64013c3b482999f4976.webp"
"MediaSize" => 267366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-3b93b8d32feca64013c3b482999f4976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6528397341"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/23a74ff21b4c967fbfb186c0f2c64452.webp"
"MediaSize" => 331584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-23a74ff21b4c967fbfb186c0f2c64452.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6528397362"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/94e7f85133664d76076b8c45698bd252.webp"
"MediaSize" => 346430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-94e7f85133664d76076b8c45698bd252.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6528397383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/cea32a8c348eb97f3a43225c7cef4db5.webp"
"MediaSize" => 333038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-cea32a8c348eb97f3a43225c7cef4db5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6528397393"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29491969/999a6da15adcce35fefe3449782a4183.webp"
"MediaSize" => 321503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29491969/thumbnail-999a6da15adcce35fefe3449782a4183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12900214"
"ResourceRecordKey" => "29491969"
"ModificationTimestamp" => "2026-03-19T17:43:05.27Z"
]
]
+"DaysOnMarket": 100
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29491969')"
+"ID": "1237411"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 286835" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24892
+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 2091690" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24861
+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 '29491969'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+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 '29491969'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25267
+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 '29491969' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-80.521075 43.465844)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25340
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1572015"
+post_author: 1
+"ListingKey": "29960370"
+"ListingId": "X13495520"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:25:23Z"
+"RFModificationTimestamp": "2026-06-26T23:11:06Z"
+"ListPrice": 3499999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3N5"
+"UnparsedAddress": "309-311 HAWTHORN STREET, Waterloo, Ontario N2L3N5"
+"Coordinates": array:2 [
0 => -80.527842
1 => 43.478323
]
+"Latitude": 43.478323
+"Longitude": -80.527842
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great turn-key development project in the Waterloo University district! Assembly of 2 single detached houses: 309 & 311 Hawthorn St. Development of a six (6) storey multi-unit apartment building containing fifty-five (55) residential dwelling units, eighty (80) bedrooms, twenty-two (22) parking spaces, and thirty-eight (38) bicycle parking spaces. Site plan drawings have been approved. The site plan agreement is currently under review by the Director. We shall receive the site plan agreement soon. Situated just a short walk from King Street and Wilfrid Laurier University campus, this location is only minutes away from the University of Waterloo. It also enjoys close proximity to various Grand River transit stops and routes, offering convenient access to Uptown Waterloo and major commercial nodes. Package includes all drawings and reports for city permit. (id:62783)"
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-26T23:10:53.808457+00:00"
+"Directions": "Spruce Str. & Hawthorn Str."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003456"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "111 x 145 FT ; 134.81 x 111.14 x 156.4 x 111.39"
+"PhotosChangeTimestamp": "2026-06-26T20:20:07Z"
+"PhotosCount": 2
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:20:07Z"
+"StreetName": "HAWTHORN"
+"StreetNumber": "309-311"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "14336.93"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960370/309-311-hawthorn-street-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "RN-6"
+"FrontageLengthNumeric": 111.0
+"OriginalEntryTimestamp": "2026-06-26T20:20:07.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1286347"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29960370_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960370/78446d74a0d975e60c1c20290258bc2d.webp"
"MediaSize" => 184931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960370/thumbnail-78446d74a0d975e60c1c20290258bc2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13495520"
"ResourceRecordKey" => "29960370"
"ModificationTimestamp" => "2026-06-26T20:20:07.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29960370_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960370/c47f1ec899692a0382266e960f768c0b.webp"
"MediaSize" => 113888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960370/thumbnail-c47f1ec899692a0382266e960f768c0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495520"
"ResourceRecordKey" => "29960370"
"ModificationTimestamp" => "2026-06-26T20:20:07.33Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960370')"
+"ID": "1572015"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1558031"
+post_author: 1
+"ListingKey": "29943108"
+"ListingId": "40842409"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T19:00:27Z"
+"RFModificationTimestamp": "2026-06-23T19:36:57Z"
+"ListPrice": 125000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1N8"
+"UnparsedAddress": "22 KING Street S, Waterloo, Ontario N2J1N8"
+"Coordinates": array:2 [
0 => -80.521886
1 => 43.464686
]
+"Latitude": 43.464686
+"Longitude": -80.521886
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Established Café Business for Sale – Prime Uptown Waterloo Location An exceptional opportunity to acquire a fully operational, turnkey café in the vibrant heart of Uptown Waterloo. This beautifully designed establishment offers a distinctive European-inspired ambiance, setting it apart as a destination for both casual and curated dining experiences. Known for its specialty handcrafted beverages, curated menu, and inviting atmosphere, Café 22 has built a strong and loyal customer base with consistent repeat business. The space is thoughtfully designed, featuring an upper-level seating area accommodating up to 30 guests, making it ideal for private events, meetings, and social gatherings. Patrons enjoy everything from artisanal coffee and tea selections to gourmet lunches, indulgent desserts, and unique charcuterie boards, creating a well-rounded offering that appeals to a wide demographic. Business Highlights: * Prime Uptown Waterloo location with high foot traffic * Fully equipped and operational – all fixtures, equipment, and leasehold improvements included * Beautifully designed interior with dedicated event space * Established brand with strong community presence * Upper-level seating capacity for additional revenue opportunities * Significant growth potential for an owner-operator or investor * Training and transition support available With the current owners preparing for retirement, this is a rare chance to step into a well-established café with a proven concept, strong identity, and immediate income potential. Ideal for entrepreneurs looking to expand or enter the hospitality space with a recognized and reputable business. A truly turnkey opportunity in one of Waterloo’s most sought-after locations. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-23T19:36:48.775309+00:00"
+"Directions": "King St S"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069076"
+"ListOfficeKey": "283896"
+"PhotosChangeTimestamp": "2026-06-23T18:51:54Z"
+"PhotosCount": 8
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:51:54Z"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "22"
+"StreetSuffix": "Street"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29943108/22-king-street-s-waterloo"
+"CoListAgentKey": "1951360"
+"CoListAgentKey2": "2173146"
+"CoListOfficeKey": "283896"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "156288"
+"OriginalEntryTimestamp": "2026-06-23T18:51:53.96Z"
+"ListAgentNationalAssociationId": "1344245"
+"ListOfficeNationalAssociationId": "1349002"
+"CoListAgentNationalAssociationId": "1245210"
+"CoListAgentNationalAssociationId2": "1423603"
+"CoListOfficeNationalAssociationId": "1349002"
+"CoListOfficeNationalAssociationId2": "1112493"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29943108_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/3842dfb72a604a747fe5268e5e7c9789.webp"
"MediaSize" => 124704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-3842dfb72a604a747fe5268e5e7c9789.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943108_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/2892431f606a8000471ee5a3aa131bd9.webp"
"MediaSize" => 138403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-2892431f606a8000471ee5a3aa131bd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943108_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/5dff0c7d977b36ef51aa936c61c4a506.webp"
"MediaSize" => 118944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-5dff0c7d977b36ef51aa936c61c4a506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious commercial interior featuring a built-in service counter with bar seating, tiled flooring, patterned wall covering, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943108_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/5335f15d9aed60c8f453f6527aa23f2d.webp"
"MediaSize" => 130304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-5335f15d9aed60c8f453f6527aa23f2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior window seating featuring a large arched window, decorative iron chandeliers, patterned wallpaper, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943108_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/c8e4303a5386fbbcd4fa2fe052f0a18a.webp"
"MediaSize" => 135207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-c8e4303a5386fbbcd4fa2fe052f0a18a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943108_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/bcf63f425559377139dd5b3eb4c098fd.webp"
"MediaSize" => 141989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-bcf63f425559377139dd5b3eb4c098fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943108_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/e36f7e0da6978003349eea7b13d31fe0.webp"
"MediaSize" => 155298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-e36f7e0da6978003349eea7b13d31fe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943108_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943108/be02eb728f3373e92b8cab7419dff603.webp"
"MediaSize" => 134999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943108/thumbnail-be02eb728f3373e92b8cab7419dff603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial space featuring an extended countertop bar with seating, recessed lighting, and patterned wall coverings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842409"
"ResourceRecordKey" => "29943108"
"ModificationTimestamp" => "2026-06-23T18:51:53.97Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943108')"
+"ID": "1558031"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1554363"
+post_author: 1
+"ListingKey": "29935388"
+"ListingId": "X13473114"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T02:40:14Z"
+"RFModificationTimestamp": "2026-06-26T04:33:14Z"
+"ListPrice": 569900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 810.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "111 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Exceptional commercial investment opportunity in Waterloo's thriving university district. This 810 sq. ft. corner unit is ideally located within walking distance of the University of Waterloo and Wilfrid Laurier University, offering excellent visibility and consistent foot traffic. Currently leased to BerryBir & Beans Restaurant at $3,000/month (Rent increases by 3% each year) plus Condo fee / maintenance's fee until September 30, 2028 with another 3 years renewal option, providing stable income and strong cash flow. Previously operated as a successful restaurant, this turnkey investment includes one parking space(#51) and offers outstanding long-term growth potential. (id:66098)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-22T14:40:23.773764+00:00"
+"Directions": "Cross Streets: HICKORY ST W;UNIVERSITY AVE;COLUMBIA ST W. ** Directions: University W to Lester St, Or Columbia St W to Lester St."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1556196"
+"ListOfficeKey": "85076"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-22T21:46:42Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Storm sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T02:33:06Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8987.06"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29935388/111-280-lester-street-waterloo"
+"ParkingTotal": 1
+"GeocodeManualYN": false
+"ZoningDescription": "GR"
+"OriginalEntryTimestamp": "2026-06-22T14:01:31Z"
+"ListAgentNationalAssociationId": "1147366"
+"ListOfficeNationalAssociationId": "1187880"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935388_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/576afe7bf61eb626656cd117f83b3e6d.webp"
"MediaSize" => 434461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-576afe7bf61eb626656cd117f83b3e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935388_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/6593f90558895d15e98b8c2c20d30aea.webp"
"MediaSize" => 376196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-6593f90558895d15e98b8c2c20d30aea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935388_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/54452c227e5a703d0f61693f2754a370.webp"
"MediaSize" => 394045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-54452c227e5a703d0f61693f2754a370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935388_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/12b7fb0088c40514e5ab82a53336c711.webp"
"MediaSize" => 382865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-12b7fb0088c40514e5ab82a53336c711.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935388_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/e5bd811022cf68c9bfb0e1abb7d5b802.webp"
"MediaSize" => 219000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-e5bd811022cf68c9bfb0e1abb7d5b802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935388_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/70fef488878e834b851ed7ce91bb7f3a.webp"
"MediaSize" => 283349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-70fef488878e834b851ed7ce91bb7f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935388_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/22c863d6e9741bc94acf393274098d06.webp"
"MediaSize" => 233323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-22c863d6e9741bc94acf393274098d06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935388_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/8a73cbb2dd8417c98209a614ca22713c.webp"
"MediaSize" => 180060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-8a73cbb2dd8417c98209a614ca22713c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935388_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/03c61354899164a5add7094993ae58db.webp"
"MediaSize" => 195028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-03c61354899164a5add7094993ae58db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935388_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/c8059f12da771504122fabbeaa518ed3.webp"
"MediaSize" => 191915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-c8059f12da771504122fabbeaa518ed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935388_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/12a7be7106640136f080d3d138519e9c.webp"
"MediaSize" => 246733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-12a7be7106640136f080d3d138519e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935388_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/c63dea16a3d18f3569387648f75dd7f5.webp"
"MediaSize" => 304764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-c63dea16a3d18f3569387648f75dd7f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935388_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/31ebf7d2888c2ce62583dc1ef32b09a2.webp"
"MediaSize" => 221769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-31ebf7d2888c2ce62583dc1ef32b09a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935388_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/7f1b02906c4e0e429431bf3787ecd4e7.webp"
"MediaSize" => 248644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-7f1b02906c4e0e429431bf3787ecd4e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935388_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/7595fb4f11c00d80ee390f1983674f9d.webp"
"MediaSize" => 227581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-7595fb4f11c00d80ee390f1983674f9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935388_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/5a5b9946ccc5251db0e31d6c0b25cb21.webp"
"MediaSize" => 247573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-5a5b9946ccc5251db0e31d6c0b25cb21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935388_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/efa0ea649a321dd0d1fd80b7a6c546f8.webp"
"MediaSize" => 282348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-efa0ea649a321dd0d1fd80b7a6c546f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935388_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/40cf1318b6359652bb1ba49ed5fc65e3.webp"
"MediaSize" => 285952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-40cf1318b6359652bb1ba49ed5fc65e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935388_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/c0cc6d8926042d9103bef8416236e2a3.webp"
"MediaSize" => 134924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-c0cc6d8926042d9103bef8416236e2a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935388_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/1ebe118966912f35ce585314252cb481.webp"
"MediaSize" => 407546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-1ebe118966912f35ce585314252cb481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935388_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935388/feba934aa20a60adcef8e21483e873ec.webp"
"MediaSize" => 342957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935388/thumbnail-feba934aa20a60adcef8e21483e873ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473114"
"ResourceRecordKey" => "29935388"
"ModificationTimestamp" => "2026-06-22T14:01:31.01Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935388')"
+"ID": "1554363"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1551220"
+post_author: 1
+"ListingKey": "29929325"
+"ListingId": "40841502"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T13:40:31Z"
+"RFModificationTimestamp": "2026-06-20T13:43:52Z"
+"ListPrice": 99000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3G9"
+"UnparsedAddress": "90 WEBER Street N Unit# 2, Waterloo, Ontario N2J3G9"
+"Coordinates": array:2 [
0 => -80.5139452
1 => 43.4711251
]
+"Latitude": 43.4711251
+"Longitude": -80.5139452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "TURN-KEY BUSINESS OPERATING FOR 50 YEARS JUST FROM WORD OF MOUTH ADVERTISING! MANY WAYS TO INCREASE SALES SUCH AS:CREATING A WEBSITE, OFFERING DELIVERY, AND/OR OBTAINING A LIQUOR LICENSE! DO NOT GO DIRECT! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "Community Centre"
]
+"CreationDate": "2026-06-19T19:17:34.066126+00:00"
+"Directions": "CONESTOGA PKWY, WEST ON BRIDGEPORT RD, NORTH ON WEBER, PLAZA ON THE EAST SIDE AT LONDON RD."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564078"
+"ListOfficeKey": "280014"
+"LotFeatures": array:1 [
0 => "Corner Site"
]
+"PhotosChangeTimestamp": "2026-06-19T17:31:37Z"
+"PhotosCount": 5
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T13:31:12Z"
+"StreetDirSuffix": "North"
+"StreetName": "WEBER"
+"StreetNumber": "90"
+"StreetSuffix": "Street"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29929325/90-weber-street-n-unit-2-waterloo"
+"GeocodeManualYN": true
+"OriginalEntryTimestamp": "2026-06-19T17:31:37.52Z"
+"ListAgentNationalAssociationId": "1069575"
+"ListOfficeNationalAssociationId": "1308830"
+"Media": array:5 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29929325_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929325/cc2e33cdb5f6d9669f178ee3e309a0db.webp"
"MediaSize" => 75571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929325/thumbnail-cc2e33cdb5f6d9669f178ee3e309a0db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Service counter with a pass-through window, integrated menu boards, and a built-in display cooler"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841502"
"ResourceRecordKey" => "29929325"
"ModificationTimestamp" => "2026-06-19T17:31:37.54Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29929325_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929325/7f80566f921f7fde2d2ccb09a28dc481.webp"
"MediaSize" => 53597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929325/thumbnail-7f80566f921f7fde2d2ccb09a28dc481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841502"
"ResourceRecordKey" => "29929325"
"ModificationTimestamp" => "2026-06-19T17:31:37.54Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29929325_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929325/c641027545d1706730dfaa37298ef5ae.webp"
"MediaSize" => 93482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929325/thumbnail-c641027545d1706730dfaa37298ef5ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841502"
"ResourceRecordKey" => "29929325"
"ModificationTimestamp" => "2026-06-19T17:31:37.54Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29929325_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929325/318e0f3687e7c1be7a7c9ccd525aa0c3.webp"
"MediaSize" => 150989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929325/thumbnail-318e0f3687e7c1be7a7c9ccd525aa0c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefronts featuring brick facades and large display windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841502"
"ResourceRecordKey" => "29929325"
"ModificationTimestamp" => "2026-06-19T17:31:37.54Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29929325_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929325/f89a2da95e12d31ef0306ce564bb8b79.webp"
"MediaSize" => 127765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929325/thumbnail-f89a2da95e12d31ef0306ce564bb8b79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841502"
"ResourceRecordKey" => "29929325"
"ModificationTimestamp" => "2026-06-19T17:31:37.54Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929325')"
+"ID": "1551220"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+post_id: "1525837"
+post_author: 1
+"ListingKey": "29898587"
+"ListingId": "X13440052"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:00:14Z"
+"RFModificationTimestamp": "2026-06-12T23:39:39Z"
+"ListPrice": 99000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 405.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G4"
+"UnparsedAddress": "112 - 308 KING STREET N, Waterloo, Ontario N2J0G4"
+"Coordinates": array:2 [
0 => -80.525122
1 => 43.478676
]
+"Latitude": 43.478676
+"Longitude": -80.525122
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Small but Mighty!!! Jigglepuff holds a distinct market position as the only dedicated Japanese cheesecake shop in the Waterloo region, drawing regular customers from all neighboring cities. Thus turnkey Premium Dessert & Bakery shop is situated in the absolute heart of Waterloo's high-traffic University District and provides built-in, year-round foot traffic from a dense concentration of students and young professionals. Located directly beneath a 25-storey residential tower boasting a 95% occupancy rate (340 units, housing ~659 immediate residents), the area sees steady traffic at all times. Featuring an advantageously low monthly rent, the lease includes a strict exclusivity covenant. You receive an exclusive in the building to a bakery, dessert shop, coffee shop, or any business selling cakes, pies, tarts, and coffee. Enjoy zero days to market and make the most of a fully trained Staff & turnkey operations. The business layout is fully integrated with top-tier local revenue streams, capturing immediate on-demand delivery traffic across the Twin Cities. Full Delivery App Integration: Fully on-boarded and active merchant accounts with UberEats, SkipTheDishes, DoorDash, and Hungry Panda. An incoming owner inherits these active digital pipelines without dealing with tedious platform setups. Proprietary E-Commerce Website: Includes the brand's custom, dedicated website built with a direct online ordering portal, allowing customers to purchase items directly from the store while bypassing high third-party app commission fees. Many more built in efficiencies make this a winner for the future so make today the day! (id:62783)"
+"BusinessType": "Food Services and Beverage"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-12T23:39:32.745519+00:00"
+"Directions": "Cross Streets: University Ave E. ** Directions: north of University Ave E, east of King St N with entrance on Hickory St E."
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095766"
+"ListOfficeKey": "267769"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T21:53:20Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:53:20Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898587/112-308-king-street-n-waterloo"
+"ParkingTotal": 1
+"CoListAgentKey": "1560716"
+"CoListAgentKey2": "2225838"
+"CoListOfficeKey": "267769"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "267769"
+"ZoningDescription": "CR"
+"OriginalEntryTimestamp": "2026-06-12T21:53:20.55Z"
+"ListAgentNationalAssociationId": "1367963"
+"ListOfficeNationalAssociationId": "1229222"
+"CoListAgentNationalAssociationId": "1147235"
+"CoListAgentNationalAssociationId2": "1469142"
+"CoListOfficeNationalAssociationId": "1229222"
+"CoListOfficeNationalAssociationId2": "1229222"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898587_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/7330121af5e344fa065fe422120567e3.webp"
"MediaSize" => 117800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-7330121af5e344fa065fe422120567e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898587_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/fd4b4cd6a790a9a8fef2217ed2d5b76a.webp"
"MediaSize" => 217848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-fd4b4cd6a790a9a8fef2217ed2d5b76a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29898587_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/a6426317edc0ef29defaa248a6690b53.webp"
"MediaSize" => 242869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-a6426317edc0ef29defaa248a6690b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29898587_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/f899dccf84b7e8a4a15e2f018e9eed22.webp"
"MediaSize" => 237979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-f899dccf84b7e8a4a15e2f018e9eed22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29898587_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/43939bcf903ffd3436f268726c0306f3.webp"
"MediaSize" => 184683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-43939bcf903ffd3436f268726c0306f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29898587_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/2b2984376e7b3b658cf3c343c4fafdaa.webp"
"MediaSize" => 231683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-2b2984376e7b3b658cf3c343c4fafdaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29898587_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/88ccbda6553230d24fa9da4f0c0774dd.webp"
"MediaSize" => 118385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-88ccbda6553230d24fa9da4f0c0774dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29898587_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/49fabd782a342272d48f9a461d7c4cce.webp"
"MediaSize" => 70792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-49fabd782a342272d48f9a461d7c4cce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29898587_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/67a109cbaab3ed4d1958c4754c4dbb8b.webp"
"MediaSize" => 122785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-67a109cbaab3ed4d1958c4754c4dbb8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29898587_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/6223df148aa813e5cc2b6827cd6afa95.webp"
"MediaSize" => 71805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-6223df148aa813e5cc2b6827cd6afa95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29898587_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/8e0ececa4c4693c5fd3c06fc0c08da5a.webp"
"MediaSize" => 354583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-8e0ececa4c4693c5fd3c06fc0c08da5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29898587_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/8b57688c5b790423bcd7f37e9950e93d.webp"
"MediaSize" => 287374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-8b57688c5b790423bcd7f37e9950e93d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29898587_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/136f54c1cdeb931e4719367fe400fdb1.webp"
"MediaSize" => 338923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-136f54c1cdeb931e4719367fe400fdb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29898587_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/e7eff8089f14053820a93e50176714ab.webp"
"MediaSize" => 296608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-e7eff8089f14053820a93e50176714ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29898587_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/50e6c5d795abcdf1deb1c13a668db9e9.webp"
"MediaSize" => 338626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-50e6c5d795abcdf1deb1c13a668db9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898587')"
+"ID": "1525837"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1499230"
+post_author: 1
+"ListingKey": "29860421"
+"ListingId": "40837020"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:26:10Z"
+"RFModificationTimestamp": "2026-06-05T17:39:54Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2V9"
+"UnparsedAddress": "25 UNIVERSITY Avenue E, Waterloo, Ontario N2J2V9"
+"Coordinates": array:2 [
0 => -80.5235705
1 => 43.4765
]
+"Latitude": 43.4765
+"Longitude": -80.5235705
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PROFITABLE AND WELL ESTABLISHED CANNBIS retail business in a highly visible and accessible UNIVERSITY AREA OF WATERLOO. Situated on a major corridor near University of Waterloo, Wilfred Laurier University and Conestoga college, this turnkey operation benefits from strong pedestrian and vehicle traffic, a growing customer base, and a strategic position within one of Waterloo's most active commercial districts. The business offers a modern retail environment, established supplier relationships, and a diverse selection of cannabis products and accessories. The area is surrounded by residential neighbourhoods, student housing, restaurants, and retail amenities, creating consistent year-round demand. Ideal opportunity for an owner-operator or investor looking to expand within Ontario's cannabis retail sector. Inventory extra. Purchaser must independently obtain all required approvals, permits, and licences to operate the business. Current lease is signed for 5 years, can be renewed for another 5 years term. Total area 1850 sq ft. Rent is $13500/MONTH including TMI and HST. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-05T17:39:48.919922+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"PhotosChangeTimestamp": "2026-06-05T16:10:41Z"
+"PhotosCount": 14
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:10:41Z"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "25"
+"StreetSuffix": "Avenue"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29860421/25-university-avenue-e-waterloo"
+"CoListAgentKey": "2254298"
+"CoListAgentKey2": "2244660"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "291992"
+"OriginalEntryTimestamp": "2026-06-05T16:10:41.62Z"
+"ListAgentNationalAssociationId": "1283131"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1493252"
+"CoListAgentNationalAssociationId2": "1483285"
+"CoListOfficeNationalAssociationId": "1407252"
+"CoListOfficeNationalAssociationId2": "1407252"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29860421_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/7210e98fc0de07f766c733e5730cd9ac.webp"
"MediaSize" => 136768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-7210e98fc0de07f766c733e5730cd9ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29860421_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/6dc66bcdd5095d68f01c9f4769980348.webp"
"MediaSize" => 127108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-6dc66bcdd5095d68f01c9f4769980348.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29860421_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/cbbd2f91304f52dfc613280061358826.webp"
"MediaSize" => 124774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-cbbd2f91304f52dfc613280061358826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29860421_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/03dcea55813820ac7c34df5630caf7bb.webp"
"MediaSize" => 67203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-03dcea55813820ac7c34df5630caf7bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29860421_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/120e8b9e0f2e30caa29abc0bd269abdc.webp"
"MediaSize" => 71175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-120e8b9e0f2e30caa29abc0bd269abdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29860421_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/9e2c2226fedc7d04bc3b9c27da51e55f.webp"
"MediaSize" => 106794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-9e2c2226fedc7d04bc3b9c27da51e55f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29860421_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/2a17a6200ec13dd681a05c13e9791e03.webp"
"MediaSize" => 114158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-2a17a6200ec13dd681a05c13e9791e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29860421_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/2c7cc51895dbb170b743e601bd81bb6e.webp"
"MediaSize" => 119024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-2c7cc51895dbb170b743e601bd81bb6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29860421_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/5a299bd0fe66557b08164e645a386c02.webp"
"MediaSize" => 121073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-5a299bd0fe66557b08164e645a386c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29860421_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/30e1e04d56523f0fbd501415e353bd30.webp"
"MediaSize" => 137722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-30e1e04d56523f0fbd501415e353bd30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29860421_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/d02956dd011ea9c0649559c4600f27aa.webp"
"MediaSize" => 89392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-d02956dd011ea9c0649559c4600f27aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29860421_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/8a934b38db6c78397b613058d6047b6f.webp"
"MediaSize" => 145988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-8a934b38db6c78397b613058d6047b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29860421_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/6587ff60739562c8bbba5de47c76fe00.webp"
"MediaSize" => 123178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-6587ff60739562c8bbba5de47c76fe00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29860421_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/c7530ae2fbb1b217f2229ee761779e7f.webp"
"MediaSize" => 138325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-c7530ae2fbb1b217f2229ee761779e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
]
+"DaysOnMarket": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860421')"
+"ID": "1499230"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1499231"
+post_author: 1
+"ListingKey": "29861028"
+"ListingId": "X13248484"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:30:58Z"
+"RFModificationTimestamp": "2026-06-05T17:38:29Z"
+"ListPrice": 109000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2W6"
+"UnparsedAddress": "8 ERB STREET W, Waterloo, Ontario N2J2W6"
+"Coordinates": array:2 [
0 => -80.522839
1 => 43.46526
]
+"Latitude": 43.46526
+"Longitude": -80.522839
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great opportunity to take over a modern restaurant space in the heart of downtown Waterloo. Located on a busy corner with huge wraparound windows and excellent exposure, this spot gets plenty of natural light and strong foot traffic throughout the day. The space is nicely finished with quality equipment and a flexible layout that can work for many different food concepts. Clean, professional setup with a modern feel, ready for a new owner to start operating right away.15 ft hood. 55 indoor seats and 20 patio seats. Basement included. 2 walk in coolers and 1walk-in freezer. Rent $9,910 (TMI & HST included). 2 years remaining plus a 5-year option to renew. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-05T17:38:15.062145+00:00"
+"Directions": "Cross Streets: Erb St & King St W. ** Directions: -."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023981"
+"ListOfficeKey": "279601"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-05T16:57:47Z"
+"PhotosCount": 22
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:57:47Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861028/8-erb-street-w-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-06-05T16:57:47.89Z"
+"ListAgentNationalAssociationId": "1303728"
+"ListOfficeNationalAssociationId": "1306325"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29861028_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/60c9edcc6aeced38abd30eb131f9c308.webp"
"MediaSize" => 373467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-60c9edcc6aeced38abd30eb131f9c308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861028_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/15b4a1d5d0db9c02d62b3e24493a300d.webp"
"MediaSize" => 140835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-15b4a1d5d0db9c02d62b3e24493a300d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861028_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/36eaad1b003335ba4378bd7ab4b534d7.webp"
"MediaSize" => 294438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-36eaad1b003335ba4378bd7ab4b534d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861028_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/491e7b98251a0e04d327f1e1d6e5087f.webp"
"MediaSize" => 354661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-491e7b98251a0e04d327f1e1d6e5087f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861028_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/0f4c21086d0edac4ae582bd1bcfddda7.webp"
"MediaSize" => 272454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-0f4c21086d0edac4ae582bd1bcfddda7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861028_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5aa61918c815f6bad4aad61c73f65454.webp"
"MediaSize" => 333831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5aa61918c815f6bad4aad61c73f65454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861028_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/de48171b1aec1d7f194f70019e8a064a.webp"
"MediaSize" => 296385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-de48171b1aec1d7f194f70019e8a064a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861028_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/00df397b1c903dfaa944114c0a984373.webp"
"MediaSize" => 176194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-00df397b1c903dfaa944114c0a984373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861028_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/421e7bd01e4a1690883a403cb1eacff9.webp"
"MediaSize" => 290032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-421e7bd01e4a1690883a403cb1eacff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861028_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/595660cb966e59691998aeca1f7c447b.webp"
"MediaSize" => 271339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-595660cb966e59691998aeca1f7c447b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29861028_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/9c57545730b8800c81aa74d9022abfdf.webp"
"MediaSize" => 331281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-9c57545730b8800c81aa74d9022abfdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29861028_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5beef2891c7c9b065705d5335b30ee83.webp"
"MediaSize" => 223793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5beef2891c7c9b065705d5335b30ee83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29861028_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/023242d5b494637084caa8abfcd29b9e.webp"
"MediaSize" => 249197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-023242d5b494637084caa8abfcd29b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29861028_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/3547ad65d11020646b24f3df453df19c.webp"
"MediaSize" => 107928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-3547ad65d11020646b24f3df453df19c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29861028_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/1527a46cde80205f24c2170ccb302198.webp"
"MediaSize" => 373467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-1527a46cde80205f24c2170ccb302198.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29861028_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5ff97a4a2cc87def27204f1ac7922c1e.webp"
"MediaSize" => 292094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5ff97a4a2cc87def27204f1ac7922c1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29861028_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/eb31066188dc3b95230b73633085516f.webp"
"MediaSize" => 296194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-eb31066188dc3b95230b73633085516f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29861028_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/436a6b1d07436e1795191d327ee54e07.webp"
"MediaSize" => 254927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-436a6b1d07436e1795191d327ee54e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29861028_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/a529c526dbb48accb2f5a7fc54eea75f.webp"
"MediaSize" => 253115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-a529c526dbb48accb2f5a7fc54eea75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29861028_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/3da492e37a038015dbc65d1c6507b72a.webp"
"MediaSize" => 332394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-3da492e37a038015dbc65d1c6507b72a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29861028_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/619b220e23f829becc1097ffdd8ad6e9.webp"
"MediaSize" => 318464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-619b220e23f829becc1097ffdd8ad6e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29861028_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/81332e0e7488214a96c28f240d21b273.webp"
"MediaSize" => 297638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-81332e0e7488214a96c28f240d21b273.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
]
+"DaysOnMarket": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861028')"
+"ID": "1499231"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+post_id: "1492945"
+post_author: 1
+"ListingKey": "29851045"
+"ListingId": "40836620"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T02:16:16Z"
+"RFModificationTimestamp": "2026-06-04T04:44:21Z"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2V9"
+"UnparsedAddress": "29 UNIVERSITY Avenue E, Waterloo, Ontario N2J2V9"
+"Coordinates": array:2 [
0 => -80.523169
1 => 43.476546
]
+"Latitude": 43.476546
+"Longitude": -80.523169
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional opportunity to own a well-established vape shop in a prime high-traffic location on Waterloo’s busy Main Street. Situated at one of the city’s busiest intersections, this turnkey business offers outstanding visibility, steady customer flow, and excellent future growth potential. The fully equipped space includes display cases, shelving, fixtures, and a complete retail setup, making it ideal for an owner-operator or investor looking to step into a ready-to-run business. With several new multi-unit condominium developments underway nearby, the area is poised for significant population growth, creating even greater upside potential for future sales and profitability. The unit offers approximately 1,450 sq. ft. of retail space with a newly renewed lease term of 5 + 5 years, providing long-term stability. Current rent is $7,437/month. Don’t miss this rare chance to secure a thriving business in one of Waterloo’s most desirable and rapidly growing commercial locations! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-04T04:44:13.899843+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"PhotosChangeTimestamp": "2026-06-04T02:09:45Z"
+"PhotosCount": 10
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T02:09:45Z"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "29"
+"StreetSuffix": "Avenue"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29851045/29-university-avenue-e-waterloo"
+"GeocodeManualYN": false
+"OriginalEntryTimestamp": "2026-06-04T02:09:45.79Z"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29851045_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/2594a1763f8387bd606a495cd19a7034.webp"
"MediaSize" => 79050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-2594a1763f8387bd606a495cd19a7034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefront featuring a prominent illuminated sign, extensive front window displays, and a central glass entry door"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29851045_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/b6f39e3f8270f8dbd0340d21818313d6.webp"
"MediaSize" => 79228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-b6f39e3f8270f8dbd0340d21818313d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefront featuring a prominent illuminated sign, a brick facade, and a glass entrance with large display windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29851045_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/f32375e908ce3257af6fcc36251638aa.webp"
"MediaSize" => 93136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-f32375e908ce3257af6fcc36251638aa.webp"
"ResourceName" => "Property"
…6
]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851045')"
+"ID": "1492945"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: "1484901"
+post_author: 1
+"ListingKey": "29839989"
+"ListingId": "X13228088"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:37:23Z"
+"RFModificationTimestamp": "2026-06-02T18:02:09Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 926.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T6"
+"UnparsedAddress": "105&106 - 250 ALBERT STREET, Waterloo, Ontario N2L3T6"
+"Coordinates": array:2 [
0 => -80.532427
1 => 43.475199
]
+"Latitude": 43.475199
+"Longitude": -80.532427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime Retail Space In The Heart Of Waterloo. Extremely Close Proximity To Both Wilfrid Laurier University & The University Of Waterloo. Steps To The University Ave!! Exciting Opportunity To Invest In A Newer Mixed Use Condo Building. Unit Features Include Floor To Ceiling Windows, High Ceilings & Vanilla Shell Direct Street Exposure. Would Suit Many Uses Both Retail And Professional. Two parking spots included. Sold "As-is" because the tenant is still occupying the unit. Unit 105 and 106 are connected and the owners prefer to sell both units together. **EXTRAS** Currently renting to a barbershop until 2029 Feb 29th for 5798.56/m gross rent. The base rent is 38/sqft, TMI is 28.56. Condo fee: 925.25/m (id:62650)"
+"BusinessType": "Personal Services"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-02T18:01:56.177934+00:00"
+"Directions": "Cross Streets: University Ave And King St N. ** Directions: University Ave And Albert."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1943382"
+"ListOfficeKey": "103644"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-02T16:33:20Z"
+"PhotosCount": 2
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T17:03:38Z"
+"StreetName": "Albert"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8328.34"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29839989/105106-250-albert-street-waterloo"
+"ParkingTotal": 2
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial/Retail"
+"OriginalEntryTimestamp": "2026-06-02T16:33:20.27Z"
+"ListAgentNationalAssociationId": "1239598"
+"ListOfficeNationalAssociationId": "1162020"
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839989')"
+"ID": "1484901"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 43
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]