array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30021387 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1616558"
+post_author: 1
+"ListingKey": "30021387"
+"ListingId": "40847280"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T13:25:52Z"
+"RFModificationTimestamp": "2026-07-11T17:07:10Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J3"
+"UnparsedAddress": "140 UNIVERSITY Avenue W Unit# 1-5, Waterloo, Ontario N2L6J3"
+"Coordinates": array:2 [
0 => -80.5357655
1 => 43.472485
]
+"Latitude": 43.472485
+"Longitude": -80.5357655
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime Investment Opportunity, Own a landmark commercial business in the heart of Waterloo's thriving university district,presenting a rare opportunity to acquire a well-established business and income-producing commercial asset in the highly sought-after University Plaza, directly serving the vibrant communities of the University of Waterloo and Wilfrid Laurier University.Surrounded by thousands of students, faculty members, professionals, and local residents, this prime location enjoys exceptional visibility, consistent foot traffic, and strong year-round consumer demand. Prime location in Waterloo's premier university commercial district Established supermarket with a loyal customer base and strong local reputation Fully equipped and operational, ready for seamless ownership transition Excellent accessibility with ample parking and convenient transit connections Ideal for owner-operators or investors seeking stable long-term value Reliable Rental Income In addition to the supermarket operation, the property features several established tenants, including: A vape retail store An arcade entertainment venue A Chinese restaurant These leased spaces generate approximately CAD $13,000 in monthly rental income, providing immediate, stable cash flow while enhancing the property's overall investment performance. Located in one of Waterloo's strongest and most resilient retail markets Supported by two internationally recognized universities with a large, year-round customer base Multiple income streams through both business operations and rental revenue Strong long-term appreciation potential driven by continued population growth and commercial development Whether you are an experienced investor, an entrepreneur looking to expand your portfolio, or an owner-operator seeking a flagship location, offers an exceptional combination of stable income, operational potential, and long-term capital appreciation. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-11T05:57:31.994501+00:00"
+"Directions": "University and Phillip"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"PhotosChangeTimestamp": "2026-07-11T05:31:30Z"
+"PhotosCount": 35
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T13:18:06Z"
+"StreetDirSuffix": "West"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "140"
+"StreetSuffix": "Avenue"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30021387/140-university-avenue-w-unit-1-5-waterloo"
+"GeocodeManualYN": true
+"OriginalEntryTimestamp": "2026-07-11T05:28:30.81Z"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30021387_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/6a11b64e0e17047cd703741fb0069545.webp"
"MediaSize" => 107365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-6a11b64e0e17047cd703741fb0069545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial brick facade building featuring a prominent central tower entrance with arched doorway, multiple storefronts, dormer windows, and a shingle roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30021387_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/0ecb114e0253a9dafd8efd527e4e585a.webp"
"MediaSize" => 116643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-0ecb114e0253a9dafd8efd527e4e585a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring multiple storefronts, brick facade, and dormer windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30021387_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/cc83ece0835f616d6508ab24916c776c.webp"
"MediaSize" => 101142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-cc83ece0835f616d6508ab24916c776c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial plaza featuring brick exterior construction and brown shingle roofing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30021387_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/700544c43f5a7178306c5ae02df11a2d.webp"
"MediaSize" => 109105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-700544c43f5a7178306c5ae02df11a2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefront building featuring a shingled roof, dormer windows, brick veneer facade, and ample paved parking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30021387_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/7ce132c8e3abb83cf097098f18c3902d.webp"
"MediaSize" => 132912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-7ce132c8e3abb83cf097098f18c3902d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30021387_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/69c56e7dea0cffcf9f2521c038d67abd.webp"
"MediaSize" => 126968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-69c56e7dea0cffcf9f2521c038d67abd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:08.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30021387_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/d8baec366c40c283a7b55cb295f59788.webp"
"MediaSize" => 148414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-d8baec366c40c283a7b55cb295f59788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.25Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30021387_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/b350d6885177b5476a532c7b8593d277.webp"
"MediaSize" => 137145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-b350d6885177b5476a532c7b8593d277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30021387_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/e3c363ee39f14e27d9a4e55a2305a1be.webp"
"MediaSize" => 137338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-e3c363ee39f14e27d9a4e55a2305a1be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:25.93Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30021387_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/88407031b71da3f6d458d74958f0fc8d.webp"
"MediaSize" => 144323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-88407031b71da3f6d458d74958f0fc8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:24.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30021387_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/494e19612611aaff661411de37e8a62b.webp"
"MediaSize" => 127760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-494e19612611aaff661411de37e8a62b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:27.29Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30021387_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/293b1b7abe945a8237325b81520a14c2.webp"
"MediaSize" => 117832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-293b1b7abe945a8237325b81520a14c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:24.9Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30021387_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/e6ee9fed21f787cd1a75a4c1ee581330.webp"
"MediaSize" => 125254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-e6ee9fed21f787cd1a75a4c1ee581330.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30021387_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/b7f3c874ad44eae46108785ac4b9cc51.webp"
"MediaSize" => 109497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-b7f3c874ad44eae46108785ac4b9cc51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.16Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30021387_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/bc19c17fc1d6614ea9d4b7659587fa45.webp"
"MediaSize" => 118962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-bc19c17fc1d6614ea9d4b7659587fa45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:25.89Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30021387_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/4db58fb71944a15b0163af35e54f446b.webp"
"MediaSize" => 83213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-4db58fb71944a15b0163af35e54f446b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.27Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30021387_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/d3faec0de32a8ab71399129c6655ffd3.webp"
"MediaSize" => 99267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-d3faec0de32a8ab71399129c6655ffd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:24.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30021387_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/9cc4fad978796e5c484de4379235d3ac.webp"
"MediaSize" => 103761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-9cc4fad978796e5c484de4379235d3ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:25.96Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30021387_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/a27aae43d05ad0e24c69aeedf2f92363.webp"
"MediaSize" => 96351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-a27aae43d05ad0e24c69aeedf2f92363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.05Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30021387_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/c56c8bb5181d106976c40e713d5950db.webp"
"MediaSize" => 132641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-c56c8bb5181d106976c40e713d5950db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.27Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30021387_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/8e2c67e2fbeea27e07309e8387fade06.webp"
"MediaSize" => 153111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-8e2c67e2fbeea27e07309e8387fade06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:25.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30021387_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/3dde646dd1bd5422276521cb5492de34.webp"
"MediaSize" => 130501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-3dde646dd1bd5422276521cb5492de34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.23Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30021387_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/1f783ac8037e766fcd80c2d1ce20a512.webp"
"MediaSize" => 124521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-1f783ac8037e766fcd80c2d1ce20a512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30021387_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/02417e4f43278f43c3a0644eb2b94971.webp"
"MediaSize" => 70937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-02417e4f43278f43c3a0644eb2b94971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:24.9Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30021387_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/e05963c6c1a5d06b1340dc8567468602.webp"
"MediaSize" => 151874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-e05963c6c1a5d06b1340dc8567468602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.1Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30021387_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/1dcf4d27b7641f28ae7d77f7f064f0b6.webp"
"MediaSize" => 130648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-1dcf4d27b7641f28ae7d77f7f064f0b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.26Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30021387_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/1b9366dcc9ceb11329558e104be6e24b.webp"
"MediaSize" => 135036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-1b9366dcc9ceb11329558e104be6e24b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.06Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30021387_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/bd53c7b7bf82f04ff4e18151363304c6.webp"
"MediaSize" => 126213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-bd53c7b7bf82f04ff4e18151363304c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:24.9Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30021387_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/11375dbba2651b289cc7ebc5c392f148.webp"
"MediaSize" => 106935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-11375dbba2651b289cc7ebc5c392f148.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:27.29Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30021387_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/24ae0a615d82507e8a331f15b82abb93.webp"
"MediaSize" => 127421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-24ae0a615d82507e8a331f15b82abb93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:29.52Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30021387_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/72c48a1b55af4206499ad7885285c0ba.webp"
"MediaSize" => 97737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-72c48a1b55af4206499ad7885285c0ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:30.02Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30021387_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/b75fc42ece2deaffb67f894bc8cfa51e.webp"
"MediaSize" => 91160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-b75fc42ece2deaffb67f894bc8cfa51e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious commercial interior featuring neutral tone walls, bright overhead lighting, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:30.16Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30021387_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/e26c37e9461adde6c537694b590ef2cf.webp"
"MediaSize" => 95534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-e26c37e9461adde6c537694b590ef2cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial dining area featuring wood-finish flooring, an open kitchen pass-through, a decorative wall mural, and linear fluorescent lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:26.18Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30021387_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/7be275e89efac809ce46b79ce20ce733.webp"
"MediaSize" => 80618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-7be275e89efac809ce46b79ce20ce733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept room with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:28.69Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30021387_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30021387/7a2f17a2755926361c82c556d04f31e6.webp"
"MediaSize" => 82638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30021387/thumbnail-7a2f17a2755926361c82c556d04f31e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious commercial interior featuring wood-finish flooring, vibrant accent walls, and a service counter with an open kitchen pass-through"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847280"
"ResourceRecordKey" => "30021387"
"ModificationTimestamp" => "2026-07-11T05:31:29.49Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021387')"
+"ID": "1616558"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24966
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24840
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('295659')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2162407" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24863
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30021387'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25282
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30021387' AND OpenHouseDate ge '2026-07-12'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30021387' 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.5357655 43.472485)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25373
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
+post_id: "1613657"
+post_author: 1
+"ListingKey": "30018114"
+"ListingId": "X13549614"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T13:30:43Z"
+"RFModificationTimestamp": "2026-07-11T17:06:19Z"
+"ListPrice": 170000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3G9"
+"UnparsedAddress": "133 WEBER STREET N, Waterloo, Ontario N2J3G9"
+"Coordinates": array:2 [
0 => -80.515392
1 => 43.471972
]
+"Latitude": 43.471972
+"Longitude": -80.515392
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Woodstock Ingersoll Tillsonburg and Area Association of REALTORS® (WITAAR)"
+"PublicRemarks": "Turnkey opportunity alert in the heart of Waterloo! Hub Burritos & Shakes at 133 Weber St N is now available for $170,000, offering an incredible chance to step into a thriving, high-traffic location. This vibrant spot is perfectly positioned to capture steady foot traffic and a loyal customer base, making it a dream setup for any entrepreneur. Whether you're looking to expand your portfolio or jump into the future of entrepreneurship, this business is built for success from day one. The monthly rent is only $3600 + HST. The current lease is till May 2027 and can be renewed for another 5 years. A fixed low royalty of only $250 per week. Don't miss your chance to own a growing brand in one of the city's most energetic corridors. Its prime visibility and reputation make it a standout choice for seasoned operators and newcomers alike. Please do not visit the store for direct inquiries, feel free to contact me: 647 978 8210. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-07-10T19:02:08.991855+00:00"
+"Directions": "Cross Streets: Bridgeport Road E. & Weber St. N. ** Directions: From Bridgeport Road E, turn right onto Weber St N."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220920"
+"ListOfficeKey": "295844"
+"LotSizeDimensions": "Unit=190 FT"
+"PhotosChangeTimestamp": "2026-07-10T17:24:51Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T13:24:27Z"
+"StreetDirSuffix": "North"
+"StreetName": "Weber"
+"StreetNumber": "133"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Woodstock-Ingersoll-Tillsonburg"
+"ListAORKey": "33"
+"ListingURL": "www.realtor.ca/real-estate/30018114/133-weber-street-n-waterloo"
+"CoListAgentKey": "2244490"
+"CoListOfficeKey": "295844"
+"GeocodeManualYN": false
+"ZoningDescription": "AC"
+"FrontageLengthNumeric": 190.0
+"OriginalEntryTimestamp": "2026-07-10T17:24:51.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1465232"
+"ListOfficeNationalAssociationId": "1454410"
+"CoListAgentNationalAssociationId": "1483130"
+"CoListOfficeNationalAssociationId": "1454410"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30018114_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/c5c745d8ecab54e8a4d316f206bd0dbf.webp"
"MediaSize" => 210425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-c5c745d8ecab54e8a4d316f206bd0dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30018114_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/5b8bc1d7135af34db3aa53ee8ff0d992.webp"
"MediaSize" => 260581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-5b8bc1d7135af34db3aa53ee8ff0d992.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30018114_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/0c0bc76fea18a88dd3ddd39f1eab1a9b.webp"
"MediaSize" => 135480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-0c0bc76fea18a88dd3ddd39f1eab1a9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30018114_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/d43c61147282ea8725aae2f4ed23af58.webp"
"MediaSize" => 113701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-d43c61147282ea8725aae2f4ed23af58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30018114_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/1219c7ff9843d4e8666fe01ead29047e.webp"
"MediaSize" => 129440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-1219c7ff9843d4e8666fe01ead29047e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30018114_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/56a811ea29eae2ce9615ea2c09197fa5.webp"
"MediaSize" => 152765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-56a811ea29eae2ce9615ea2c09197fa5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30018114_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/19358ac8a7b6a222a8ac1bc1c3ce07bb.webp"
"MediaSize" => 248825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-19358ac8a7b6a222a8ac1bc1c3ce07bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30018114_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/8072bdcc853102144d2d63a8b41a0db7.webp"
"MediaSize" => 169451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-8072bdcc853102144d2d63a8b41a0db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30018114_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/6204f234fa113fa431cc1497fdc8b3ed.webp"
"MediaSize" => 133511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-6204f234fa113fa431cc1497fdc8b3ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30018114_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/5f7db42262f626d85624ab6da2be85a7.webp"
"MediaSize" => 108314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-5f7db42262f626d85624ab6da2be85a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30018114_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/5e6c5236345a11263de8c4cf99c46326.webp"
"MediaSize" => 145684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-5e6c5236345a11263de8c4cf99c46326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30018114_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/8557d4c147c645f37a862a92621ce1ac.webp"
"MediaSize" => 113417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-8557d4c147c645f37a862a92621ce1ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30018114_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/71e9b6c42dcb2f75ddb0339d3d013b93.webp"
"MediaSize" => 154328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-71e9b6c42dcb2f75ddb0339d3d013b93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30018114_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/69e55e5319a552a3507043a0fe6c9d01.webp"
"MediaSize" => 155466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-69e55e5319a552a3507043a0fe6c9d01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30018114_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018114/ed63eedcaaa3d2cdee8dd330d20eedb6.webp"
"MediaSize" => 140258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018114/thumbnail-ed63eedcaaa3d2cdee8dd330d20eedb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549614"
"ResourceRecordKey" => "30018114"
"ModificationTimestamp" => "2026-07-10T17:24:51.44Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30018114')"
+"ID": "1613657"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1612062"
+post_author: 1
+"ListingKey": "30015683"
+"ListingId": "40846964"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T03:35:24Z"
+"RFModificationTimestamp": "2026-07-11T03:39:03Z"
+"ListPrice": 220000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T6"
+"UnparsedAddress": "250 ALBERT Street Unit# #105-106, Waterloo, Ontario N2L3T6"
+"Coordinates": array:2 [
0 => -80.5325599
1 => 43.475132
]
+"Latitude": 43.475132
+"Longitude": -80.5325599
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Well established and elegant decorated old school hair studio in the Sage 8 main floor building. Good location and in the university student zone. The business has established clientel and profitable return business.\u{A0}The hair studio has total 4 stations and with more barber hired, the business has great potential to expand the business.\u{A0} Great opportunity to own your business.\u{A0} The owner will consider the partnership\u{A0}option.\u{A0} Please call for detail. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-10T06:44:39.710297+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563616"
+"ListOfficeKey": "253316"
+"PhotosChangeTimestamp": "2026-07-10T05:18:10Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T03:28:59Z"
+"StreetName": "ALBERT"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30015683/250-albert-street-unit-105-106-waterloo"
+"CoListAgentKey": "1884357"
+"CoListAgentKey2": "1914695"
+"CoListOfficeKey": "253316"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "253316"
+"ZoningDescription": "RN-6 and RN-12"
+"OriginalEntryTimestamp": "2026-07-10T05:18:10.17Z"
+"ListAgentNationalAssociationId": "1128019"
+"ListOfficeNationalAssociationId": "1223329"
+"CoListAgentNationalAssociationId": "1208179"
+"CoListAgentNationalAssociationId2": "1224066"
+"CoListOfficeNationalAssociationId": "1223329"
+"CoListOfficeNationalAssociationId2": "1223329"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30015683_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/339fb943c85c594c5f56e36bcc67fcb0.webp"
"MediaSize" => 150892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-339fb943c85c594c5f56e36bcc67fcb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30015683_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/50f75c58faab863dee4554986633011d.webp"
"MediaSize" => 29595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-50f75c58faab863dee4554986633011d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30015683_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/ea97dc0687a1682c1a302501917327ae.webp"
"MediaSize" => 25969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-ea97dc0687a1682c1a302501917327ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30015683_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/92bbc2625aea2269123971730e0a3740.webp"
"MediaSize" => 32322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-92bbc2625aea2269123971730e0a3740.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30015683_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/bef9d606bcd4b7d02bb155a8d65cf75a.webp"
"MediaSize" => 28548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-bef9d606bcd4b7d02bb155a8d65cf75a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30015683_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/d5e70b49c39c493ff09a462eac3c0073.webp"
"MediaSize" => 30667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-d5e70b49c39c493ff09a462eac3c0073.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30015683_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/9ecf77b39e5affae0c9d1e62f8e92f32.webp"
"MediaSize" => 31328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-9ecf77b39e5affae0c9d1e62f8e92f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30015683_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/666d0d1c14c46994d672278ab41056ab.webp"
"MediaSize" => 31386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-666d0d1c14c46994d672278ab41056ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30015683_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/7043664c336d2dae8bffac83c778c38c.webp"
"MediaSize" => 29595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-7043664c336d2dae8bffac83c778c38c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30015683_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/b05f62155792dd20419d8c467e2215dc.webp"
"MediaSize" => 25012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-b05f62155792dd20419d8c467e2215dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30015683_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/11a007480672698471ba7c233a0a138e.webp"
"MediaSize" => 25969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-11a007480672698471ba7c233a0a138e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30015683_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015683/593f480fa9b6e4b3f0c3c5a4a8caa8e5.webp"
"MediaSize" => 23441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015683/thumbnail-593f480fa9b6e4b3f0c3c5a4a8caa8e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846964"
"ResourceRecordKey" => "30015683"
"ModificationTimestamp" => "2026-07-10T05:18:10.17Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30015683')"
+"ID": "1612062"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+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": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960370')"
+"ID": "1572015"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943108')"
+"ID": "1558031"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1554363"
+post_author: 1
+"ListingKey": "29935388"
+"ListingId": "X13473114"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T15:40:09Z"
+"RFModificationTimestamp": "2026-07-08T15:51:47Z"
+"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 + HST/month (Rent increases by 3% each year) plus $627.14 of Condo fee (including TMI) and utilities 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-07-08T15:29:07Z"
+"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": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935388')"
+"ID": "1554363"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+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": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929325')"
+"ID": "1551220"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1525837"
+post_author: 1
+"ListingKey": "29898587"
+"ListingId": "X13440052"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:45:15Z"
+"RFModificationTimestamp": "2026-07-10T16:55:30Z"
+"ListPrice": 89000.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:62650)"
+"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-07-10T16:09:18Z"
+"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": 30
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898587')"
+"ID": "1525837"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+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"
…11
]
12 => array:13 [ …13]
13 => array:13 [ …13]
]
+"DaysOnMarket": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860421')"
+"ID": "1499230"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861028')"
+"ID": "1499231"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 44
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]