array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29791058 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1451265"
+post_author: 1
+"ListingKey": "29791058"
+"ListingId": "40830949"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:34Z"
+"RFModificationTimestamp": "2026-06-02T16:31:46Z"
+"ListPrice": 1070000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1442.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K1"
+"UnparsedAddress": "67 BRIDGEPORT Road E, Waterloo, Ontario N2J2K1"
+"Coordinates": array:2 [
0 => -80.5162186
1 => 43.4684045
]
+"Latitude": 43.4684045
+"Longitude": -80.5162186
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime uptown commercial office opportunity with exceptional visibility in a high-traffic location. This professionally maintained property offers a prominent presence ideal for professional offices, retail, medical, service-based businesses, and a variety of commercial uses permitted under versatile C1 zoning. Surrounded by established businesses, restaurants, and amenities, this location provides excellent exposure, convenient access, and strong pedestrian and vehicle traffic. Ideal for investors looking to add to their portfolio or owner-operators seeking a prime space for their business. A rare opportunity to secure a property in the heart of Waterloo with flexible zoning and great street presence. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-22T17:27:34.139685+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193974"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-05-22T16:51:39Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:22:32Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "67"
+"StreetSuffix": "Road"
+"SubdivisionName": "122 - Bridgeport"
+"TaxAnnualAmount": "11647.49"
+"VirtualTourURLUnbranded": "https://youriguide.com/5kye3_67_bridgeport_rd_e_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29791058/67-bridgeport-road-e-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Offices"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "(H) C1-20"
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2026-05-22T16:51:39.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1442839"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29791058_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/1570f3de657062f589042bad9e77661c.webp"
"MediaSize" => 135169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-1570f3de657062f589042bad9e77661c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29791058_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/ecd875e5bb4dc7560f36b84314e23f50.webp"
"MediaSize" => 125196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-ecd875e5bb4dc7560f36b84314e23f50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29791058_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/7b8ea362f9afdbd11b0923d1c9d0961a.webp"
"MediaSize" => 118521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-7b8ea362f9afdbd11b0923d1c9d0961a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29791058_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/dcafd1a14d4102a3212eed47397bc5ef.webp"
"MediaSize" => 61629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-dcafd1a14d4102a3212eed47397bc5ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29791058_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/e4e0e3c8edd41f1ba6508852d9249a47.webp"
"MediaSize" => 60787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-e4e0e3c8edd41f1ba6508852d9249a47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29791058_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/9ffcb12e8d5a282b50f03a651ccd8b90.webp"
"MediaSize" => 61952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-9ffcb12e8d5a282b50f03a651ccd8b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29791058_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/2b4dc5774dee5eb2a6420dc8fa59b9f6.webp"
"MediaSize" => 91313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-2b4dc5774dee5eb2a6420dc8fa59b9f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29791058_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/560a159fb5f23f23dd962a51c3e8b66a.webp"
"MediaSize" => 87312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-560a159fb5f23f23dd962a51c3e8b66a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29791058_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/e00ab22d8b394d636299020a13f15f8a.webp"
"MediaSize" => 81844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-e00ab22d8b394d636299020a13f15f8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29791058_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/e361dcf2ff35ebc1c7a1ef3bc1fa67a2.webp"
"MediaSize" => 77890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-e361dcf2ff35ebc1c7a1ef3bc1fa67a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29791058_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/fbab3b522bad8c85b8e3f1827ea84d6f.webp"
"MediaSize" => 82387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-fbab3b522bad8c85b8e3f1827ea84d6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29791058_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/01fe3aab1307b48324ccfab59a30df70.webp"
"MediaSize" => 79431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-01fe3aab1307b48324ccfab59a30df70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29791058_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/8803888e34563bb361b0fee948985b18.webp"
"MediaSize" => 79083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-8803888e34563bb361b0fee948985b18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29791058_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/0d10660416d94a5b25571cafd5c4d3d0.webp"
"MediaSize" => 79608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-0d10660416d94a5b25571cafd5c4d3d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29791058_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/77c5608ceb0e86e11a61d0d9360d1220.webp"
"MediaSize" => 61053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-77c5608ceb0e86e11a61d0d9360d1220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29791058_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/48e5b16bcc4bb826055969832c9b8792.webp"
"MediaSize" => 94717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-48e5b16bcc4bb826055969832c9b8792.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29791058_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/e06564092c1b06f1971c16e1e484b4ef.webp"
"MediaSize" => 101688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-e06564092c1b06f1971c16e1e484b4ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29791058_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/d8430e9e773e34c0d9c642b9995a9deb.webp"
"MediaSize" => 83556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-d8430e9e773e34c0d9c642b9995a9deb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29791058_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/85b8e74b79a1fb4654cbb56b416f7ea6.webp"
"MediaSize" => 80600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-85b8e74b79a1fb4654cbb56b416f7ea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29791058_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/92210e606281dd41bbc59745609179c8.webp"
"MediaSize" => 88672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-92210e606281dd41bbc59745609179c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29791058_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/994e357eb3474c983bb69ac394966ed5.webp"
"MediaSize" => 86637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-994e357eb3474c983bb69ac394966ed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29791058_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/70e5044e09d2b3113008ecce9a4f085f.webp"
"MediaSize" => 65047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-70e5044e09d2b3113008ecce9a4f085f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29791058_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/2bad992f09ebb600e306b67fae895440.webp"
"MediaSize" => 71480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-2bad992f09ebb600e306b67fae895440.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29791058_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/e3530a5038f035228a507215cf83b519.webp"
"MediaSize" => 69805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-e3530a5038f035228a507215cf83b519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29791058_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/3c0623f239bf6ce542364d631e2b7a5a.webp"
"MediaSize" => 68081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-3c0623f239bf6ce542364d631e2b7a5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29791058_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/be58ec46b950de4f8c63a5100d591474.webp"
"MediaSize" => 96769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-be58ec46b950de4f8c63a5100d591474.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29791058_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/82759a4f3e453ad879394927bcd03ec9.webp"
"MediaSize" => 51010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-82759a4f3e453ad879394927bcd03ec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29791058_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/5965b493e784857eddc97339f98164ce.webp"
"MediaSize" => 134557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-5965b493e784857eddc97339f98164ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29791058_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/d91e6821c0775140cb88a0c4d4405098.webp"
"MediaSize" => 136017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-d91e6821c0775140cb88a0c4d4405098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29791058_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/a5f53030e6ab099e67128f243b044532.webp"
"MediaSize" => 148088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-a5f53030e6ab099e67128f243b044532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29791058_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29791058/c5bf19d0b656a7c61ed8ea0a3407ffb2.webp"
"MediaSize" => 113149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29791058/thumbnail-c5bf19d0b656a7c61ed8ea0a3407ffb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830949"
"ResourceRecordKey" => "29791058"
"ModificationTimestamp" => "2026-05-22T16:51:39.44Z"
]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29791058')"
+"ID": "1451265"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76789" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24781
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2193974" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24704
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24754
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2193974"
+"ModificationTimestamp": "2024-08-22T18:42:44Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2193974"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2193974')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29791058'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25087
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29791058'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25103
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29791058' 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.5162186 43.4684045)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25156
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "1525837"
+post_author: 1
+"ListingKey": "29898587"
+"ListingId": "X13440052"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:00:14Z"
+"RFModificationTimestamp": "2026-06-12T23:39:39Z"
+"ListPrice": 99000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 405.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G4"
+"UnparsedAddress": "112 - 308 KING STREET N, Waterloo, Ontario N2J0G4"
+"Coordinates": array:2 [
0 => -80.525122
1 => 43.478676
]
+"Latitude": 43.478676
+"Longitude": -80.525122
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Small but Mighty!!! Jigglepuff holds a distinct market position as the only dedicated Japanese cheesecake shop in the Waterloo region, drawing regular customers from all neighboring cities. Thus turnkey Premium Dessert & Bakery shop is situated in the absolute heart of Waterloo's high-traffic University District and provides built-in, year-round foot traffic from a dense concentration of students and young professionals. Located directly beneath a 25-storey residential tower boasting a 95% occupancy rate (340 units, housing ~659 immediate residents), the area sees steady traffic at all times. Featuring an advantageously low monthly rent, the lease includes a strict exclusivity covenant. You receive an exclusive in the building to a bakery, dessert shop, coffee shop, or any business selling cakes, pies, tarts, and coffee. Enjoy zero days to market and make the most of a fully trained Staff & turnkey operations. The business layout is fully integrated with top-tier local revenue streams, capturing immediate on-demand delivery traffic across the Twin Cities. Full Delivery App Integration: Fully on-boarded and active merchant accounts with UberEats, SkipTheDishes, DoorDash, and Hungry Panda. An incoming owner inherits these active digital pipelines without dealing with tedious platform setups. Proprietary E-Commerce Website: Includes the brand's custom, dedicated website built with a direct online ordering portal, allowing customers to purchase items directly from the store while bypassing high third-party app commission fees. Many more built in efficiencies make this a winner for the future so make today the day! (id:62783)"
+"BusinessType": "Food Services and Beverage"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-12T23:39:32.745519+00:00"
+"Directions": "Cross Streets: University Ave E. ** Directions: north of University Ave E, east of King St N with entrance on Hickory St E."
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095766"
+"ListOfficeKey": "267769"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T21:53:20Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:53:20Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898587/112-308-king-street-n-waterloo"
+"ParkingTotal": 1
+"CoListAgentKey": "1560716"
+"CoListAgentKey2": "2225838"
+"CoListOfficeKey": "267769"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "267769"
+"ZoningDescription": "CR"
+"OriginalEntryTimestamp": "2026-06-12T21:53:20.55Z"
+"ListAgentNationalAssociationId": "1367963"
+"ListOfficeNationalAssociationId": "1229222"
+"CoListAgentNationalAssociationId": "1147235"
+"CoListAgentNationalAssociationId2": "1469142"
+"CoListOfficeNationalAssociationId": "1229222"
+"CoListOfficeNationalAssociationId2": "1229222"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898587_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/7330121af5e344fa065fe422120567e3.webp"
"MediaSize" => 117800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-7330121af5e344fa065fe422120567e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898587_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/fd4b4cd6a790a9a8fef2217ed2d5b76a.webp"
"MediaSize" => 217848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-fd4b4cd6a790a9a8fef2217ed2d5b76a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29898587_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/a6426317edc0ef29defaa248a6690b53.webp"
"MediaSize" => 242869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-a6426317edc0ef29defaa248a6690b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29898587_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/f899dccf84b7e8a4a15e2f018e9eed22.webp"
"MediaSize" => 237979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-f899dccf84b7e8a4a15e2f018e9eed22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29898587_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/43939bcf903ffd3436f268726c0306f3.webp"
"MediaSize" => 184683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-43939bcf903ffd3436f268726c0306f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29898587_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/2b2984376e7b3b658cf3c343c4fafdaa.webp"
"MediaSize" => 231683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-2b2984376e7b3b658cf3c343c4fafdaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29898587_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/88ccbda6553230d24fa9da4f0c0774dd.webp"
"MediaSize" => 118385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-88ccbda6553230d24fa9da4f0c0774dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29898587_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/49fabd782a342272d48f9a461d7c4cce.webp"
"MediaSize" => 70792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-49fabd782a342272d48f9a461d7c4cce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29898587_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/67a109cbaab3ed4d1958c4754c4dbb8b.webp"
"MediaSize" => 122785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-67a109cbaab3ed4d1958c4754c4dbb8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29898587_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/6223df148aa813e5cc2b6827cd6afa95.webp"
"MediaSize" => 71805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-6223df148aa813e5cc2b6827cd6afa95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29898587_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/8e0ececa4c4693c5fd3c06fc0c08da5a.webp"
"MediaSize" => 354583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-8e0ececa4c4693c5fd3c06fc0c08da5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29898587_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/8b57688c5b790423bcd7f37e9950e93d.webp"
"MediaSize" => 287374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-8b57688c5b790423bcd7f37e9950e93d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29898587_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/136f54c1cdeb931e4719367fe400fdb1.webp"
"MediaSize" => 338923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-136f54c1cdeb931e4719367fe400fdb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29898587_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/e7eff8089f14053820a93e50176714ab.webp"
"MediaSize" => 296608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-e7eff8089f14053820a93e50176714ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29898587_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898587/50e6c5d795abcdf1deb1c13a668db9e9.webp"
"MediaSize" => 338626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898587/thumbnail-50e6c5d795abcdf1deb1c13a668db9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440052"
"ResourceRecordKey" => "29898587"
"ModificationTimestamp" => "2026-06-12T21:53:20.56Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898587')"
+"ID": "1525837"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1499230"
+post_author: 1
+"ListingKey": "29860421"
+"ListingId": "40837020"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:26:10Z"
+"RFModificationTimestamp": "2026-06-05T17:39:54Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2V9"
+"UnparsedAddress": "25 UNIVERSITY Avenue E, Waterloo, Ontario N2J2V9"
+"Coordinates": array:2 [
0 => -80.5235705
1 => 43.4765
]
+"Latitude": 43.4765
+"Longitude": -80.5235705
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PROFITABLE AND WELL ESTABLISHED CANNBIS retail business in a highly visible and accessible UNIVERSITY AREA OF WATERLOO. Situated on a major corridor near University of Waterloo, Wilfred Laurier University and Conestoga college, this turnkey operation benefits from strong pedestrian and vehicle traffic, a growing customer base, and a strategic position within one of Waterloo's most active commercial districts. The business offers a modern retail environment, established supplier relationships, and a diverse selection of cannabis products and accessories. The area is surrounded by residential neighbourhoods, student housing, restaurants, and retail amenities, creating consistent year-round demand. Ideal opportunity for an owner-operator or investor looking to expand within Ontario's cannabis retail sector. Inventory extra. Purchaser must independently obtain all required approvals, permits, and licences to operate the business. Current lease is signed for 5 years, can be renewed for another 5 years term. Total area 1850 sq ft. Rent is $13500/MONTH including TMI and HST. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-05T17:39:48.919922+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"PhotosChangeTimestamp": "2026-06-05T16:10:41Z"
+"PhotosCount": 14
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:10:41Z"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "25"
+"StreetSuffix": "Avenue"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29860421/25-university-avenue-e-waterloo"
+"CoListAgentKey": "2254298"
+"CoListAgentKey2": "2244660"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "291992"
+"OriginalEntryTimestamp": "2026-06-05T16:10:41.62Z"
+"ListAgentNationalAssociationId": "1283131"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1493252"
+"CoListAgentNationalAssociationId2": "1483285"
+"CoListOfficeNationalAssociationId": "1407252"
+"CoListOfficeNationalAssociationId2": "1407252"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29860421_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/7210e98fc0de07f766c733e5730cd9ac.webp"
"MediaSize" => 136768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-7210e98fc0de07f766c733e5730cd9ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29860421_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/6dc66bcdd5095d68f01c9f4769980348.webp"
"MediaSize" => 127108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-6dc66bcdd5095d68f01c9f4769980348.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29860421_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/cbbd2f91304f52dfc613280061358826.webp"
"MediaSize" => 124774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-cbbd2f91304f52dfc613280061358826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29860421_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/03dcea55813820ac7c34df5630caf7bb.webp"
"MediaSize" => 67203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-03dcea55813820ac7c34df5630caf7bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29860421_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/120e8b9e0f2e30caa29abc0bd269abdc.webp"
"MediaSize" => 71175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-120e8b9e0f2e30caa29abc0bd269abdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29860421_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/9e2c2226fedc7d04bc3b9c27da51e55f.webp"
"MediaSize" => 106794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-9e2c2226fedc7d04bc3b9c27da51e55f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29860421_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/2a17a6200ec13dd681a05c13e9791e03.webp"
"MediaSize" => 114158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-2a17a6200ec13dd681a05c13e9791e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29860421_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/2c7cc51895dbb170b743e601bd81bb6e.webp"
"MediaSize" => 119024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-2c7cc51895dbb170b743e601bd81bb6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29860421_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/5a299bd0fe66557b08164e645a386c02.webp"
"MediaSize" => 121073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-5a299bd0fe66557b08164e645a386c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29860421_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/30e1e04d56523f0fbd501415e353bd30.webp"
"MediaSize" => 137722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-30e1e04d56523f0fbd501415e353bd30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29860421_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/d02956dd011ea9c0649559c4600f27aa.webp"
"MediaSize" => 89392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-d02956dd011ea9c0649559c4600f27aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29860421_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/8a934b38db6c78397b613058d6047b6f.webp"
"MediaSize" => 145988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-8a934b38db6c78397b613058d6047b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29860421_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/6587ff60739562c8bbba5de47c76fe00.webp"
"MediaSize" => 123178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-6587ff60739562c8bbba5de47c76fe00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29860421_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860421/c7530ae2fbb1b217f2229ee761779e7f.webp"
"MediaSize" => 138325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860421/thumbnail-c7530ae2fbb1b217f2229ee761779e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837020"
"ResourceRecordKey" => "29860421"
"ModificationTimestamp" => "2026-06-05T16:10:41.63Z"
]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860421')"
+"ID": "1499230"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25149
+post_id: "1499231"
+post_author: 1
+"ListingKey": "29861028"
+"ListingId": "X13248484"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:30:58Z"
+"RFModificationTimestamp": "2026-06-05T17:38:29Z"
+"ListPrice": 109000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2W6"
+"UnparsedAddress": "8 ERB STREET W, Waterloo, Ontario N2J2W6"
+"Coordinates": array:2 [
0 => -80.522839
1 => 43.46526
]
+"Latitude": 43.46526
+"Longitude": -80.522839
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great opportunity to take over a modern restaurant space in the heart of downtown Waterloo. Located on a busy corner with huge wraparound windows and excellent exposure, this spot gets plenty of natural light and strong foot traffic throughout the day. The space is nicely finished with quality equipment and a flexible layout that can work for many different food concepts. Clean, professional setup with a modern feel, ready for a new owner to start operating right away.15 ft hood. 55 indoor seats and 20 patio seats. Basement included. 2 walk in coolers and 1walk-in freezer. Rent $9,910 (TMI & HST included). 2 years remaining plus a 5-year option to renew. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-05T17:38:15.062145+00:00"
+"Directions": "Cross Streets: Erb St & King St W. ** Directions: -."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023981"
+"ListOfficeKey": "279601"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-05T16:57:47Z"
+"PhotosCount": 22
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:57:47Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861028/8-erb-street-w-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-06-05T16:57:47.89Z"
+"ListAgentNationalAssociationId": "1303728"
+"ListOfficeNationalAssociationId": "1306325"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29861028_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/60c9edcc6aeced38abd30eb131f9c308.webp"
"MediaSize" => 373467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-60c9edcc6aeced38abd30eb131f9c308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861028_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/15b4a1d5d0db9c02d62b3e24493a300d.webp"
"MediaSize" => 140835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-15b4a1d5d0db9c02d62b3e24493a300d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861028_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/36eaad1b003335ba4378bd7ab4b534d7.webp"
"MediaSize" => 294438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-36eaad1b003335ba4378bd7ab4b534d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861028_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/491e7b98251a0e04d327f1e1d6e5087f.webp"
"MediaSize" => 354661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-491e7b98251a0e04d327f1e1d6e5087f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861028_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/0f4c21086d0edac4ae582bd1bcfddda7.webp"
"MediaSize" => 272454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-0f4c21086d0edac4ae582bd1bcfddda7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861028_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5aa61918c815f6bad4aad61c73f65454.webp"
"MediaSize" => 333831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5aa61918c815f6bad4aad61c73f65454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861028_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/de48171b1aec1d7f194f70019e8a064a.webp"
"MediaSize" => 296385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-de48171b1aec1d7f194f70019e8a064a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861028_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/00df397b1c903dfaa944114c0a984373.webp"
"MediaSize" => 176194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-00df397b1c903dfaa944114c0a984373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861028_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/421e7bd01e4a1690883a403cb1eacff9.webp"
"MediaSize" => 290032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-421e7bd01e4a1690883a403cb1eacff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861028_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/595660cb966e59691998aeca1f7c447b.webp"
"MediaSize" => 271339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-595660cb966e59691998aeca1f7c447b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29861028_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/9c57545730b8800c81aa74d9022abfdf.webp"
"MediaSize" => 331281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-9c57545730b8800c81aa74d9022abfdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29861028_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5beef2891c7c9b065705d5335b30ee83.webp"
"MediaSize" => 223793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5beef2891c7c9b065705d5335b30ee83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29861028_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/023242d5b494637084caa8abfcd29b9e.webp"
"MediaSize" => 249197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-023242d5b494637084caa8abfcd29b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29861028_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/3547ad65d11020646b24f3df453df19c.webp"
"MediaSize" => 107928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-3547ad65d11020646b24f3df453df19c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29861028_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/1527a46cde80205f24c2170ccb302198.webp"
"MediaSize" => 373467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-1527a46cde80205f24c2170ccb302198.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29861028_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/5ff97a4a2cc87def27204f1ac7922c1e.webp"
"MediaSize" => 292094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-5ff97a4a2cc87def27204f1ac7922c1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29861028_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/eb31066188dc3b95230b73633085516f.webp"
"MediaSize" => 296194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-eb31066188dc3b95230b73633085516f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29861028_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/436a6b1d07436e1795191d327ee54e07.webp"
"MediaSize" => 254927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-436a6b1d07436e1795191d327ee54e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29861028_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/a529c526dbb48accb2f5a7fc54eea75f.webp"
"MediaSize" => 253115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-a529c526dbb48accb2f5a7fc54eea75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29861028_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/3da492e37a038015dbc65d1c6507b72a.webp"
"MediaSize" => 332394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-3da492e37a038015dbc65d1c6507b72a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29861028_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/619b220e23f829becc1097ffdd8ad6e9.webp"
"MediaSize" => 318464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-619b220e23f829becc1097ffdd8ad6e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29861028_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861028/81332e0e7488214a96c28f240d21b273.webp"
"MediaSize" => 297638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861028/thumbnail-81332e0e7488214a96c28f240d21b273.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248484"
"ResourceRecordKey" => "29861028"
"ModificationTimestamp" => "2026-06-05T16:57:47.9Z"
]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861028')"
+"ID": "1499231"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1492945"
+post_author: 1
+"ListingKey": "29851045"
+"ListingId": "40836620"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T02:16:16Z"
+"RFModificationTimestamp": "2026-06-04T04:44:21Z"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2V9"
+"UnparsedAddress": "29 UNIVERSITY Avenue E, Waterloo, Ontario N2J2V9"
+"Coordinates": array:2 [
0 => -80.523169
1 => 43.476546
]
+"Latitude": 43.476546
+"Longitude": -80.523169
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional opportunity to own a well-established vape shop in a prime high-traffic location on Waterloo’s busy Main Street. Situated at one of the city’s busiest intersections, this turnkey business offers outstanding visibility, steady customer flow, and excellent future growth potential. The fully equipped space includes display cases, shelving, fixtures, and a complete retail setup, making it ideal for an owner-operator or investor looking to step into a ready-to-run business. With several new multi-unit condominium developments underway nearby, the area is poised for significant population growth, creating even greater upside potential for future sales and profitability. The unit offers approximately 1,450 sq. ft. of retail space with a newly renewed lease term of 5 + 5 years, providing long-term stability. Current rent is $7,437/month. Don’t miss this rare chance to secure a thriving business in one of Waterloo’s most desirable and rapidly growing commercial locations! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-04T04:44:13.899843+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"PhotosChangeTimestamp": "2026-06-04T02:09:45Z"
+"PhotosCount": 10
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T02:09:45Z"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "29"
+"StreetSuffix": "Avenue"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29851045/29-university-avenue-e-waterloo"
+"GeocodeManualYN": false
+"OriginalEntryTimestamp": "2026-06-04T02:09:45.79Z"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29851045_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/2594a1763f8387bd606a495cd19a7034.webp"
"MediaSize" => 79050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-2594a1763f8387bd606a495cd19a7034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefront featuring a prominent illuminated sign, extensive front window displays, and a central glass entry door"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29851045_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/b6f39e3f8270f8dbd0340d21818313d6.webp"
"MediaSize" => 79228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-b6f39e3f8270f8dbd0340d21818313d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial storefront featuring a prominent illuminated sign, a brick facade, and a glass entrance with large display windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29851045_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/f32375e908ce3257af6fcc36251638aa.webp"
"MediaSize" => 93136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-f32375e908ce3257af6fcc36251638aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29851045_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/465e89f38cff1ecde1e24218ccccb0b4.webp"
"MediaSize" => 76716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-465e89f38cff1ecde1e24218ccccb0b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29851045_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/ba54b80aaf475b2402f8409926b69ef1.webp"
"MediaSize" => 85792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-ba54b80aaf475b2402f8409926b69ef1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29851045_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/777ff2cc10847f81a73fb8cab34d57e6.webp"
"MediaSize" => 100930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-777ff2cc10847f81a73fb8cab34d57e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29851045_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/84e258fc0b66f2197284f85ef50e3be5.webp"
"MediaSize" => 96434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-84e258fc0b66f2197284f85ef50e3be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29851045_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/3a0c0f8483f4a7731397454b58bb0f6b.webp"
"MediaSize" => 84206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-3a0c0f8483f4a7731397454b58bb0f6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility space featuring industrial metal shelving, gray tile flooring, and a white bi-fold door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29851045_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/0517d88c0477c90061b0f322c7d390b0.webp"
"MediaSize" => 64932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-0517d88c0477c90061b0f322c7d390b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29851045_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851045/62f7d34728c5c4e76b1455c7341ee036.webp"
"MediaSize" => 63243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851045/thumbnail-62f7d34728c5c4e76b1455c7341ee036.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836620"
"ResourceRecordKey" => "29851045"
"ModificationTimestamp" => "2026-06-04T02:09:45.8Z"
]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851045')"
+"ID": "1492945"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1484901"
+post_author: 1
+"ListingKey": "29839989"
+"ListingId": "X13228088"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:37:23Z"
+"RFModificationTimestamp": "2026-06-02T18:02:09Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 926.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T6"
+"UnparsedAddress": "105&106 - 250 ALBERT STREET, Waterloo, Ontario N2L3T6"
+"Coordinates": array:2 [
0 => -80.532427
1 => 43.475199
]
+"Latitude": 43.475199
+"Longitude": -80.532427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime Retail Space In The Heart Of Waterloo. Extremely Close Proximity To Both Wilfrid Laurier University & The University Of Waterloo. Steps To The University Ave!! Exciting Opportunity To Invest In A Newer Mixed Use Condo Building. Unit Features Include Floor To Ceiling Windows, High Ceilings & Vanilla Shell Direct Street Exposure. Would Suit Many Uses Both Retail And Professional. Two parking spots included. Sold "As-is" because the tenant is still occupying the unit. Unit 105 and 106 are connected and the owners prefer to sell both units together. **EXTRAS** Currently renting to a barbershop until 2029 Feb 29th for 5798.56/m gross rent. The base rent is 38/sqft, TMI is 28.56. Condo fee: 925.25/m (id:62650)"
+"BusinessType": "Personal Services"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-02T18:01:56.177934+00:00"
+"Directions": "Cross Streets: University Ave And King St N. ** Directions: University Ave And Albert."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1943382"
+"ListOfficeKey": "103644"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-02T16:33:20Z"
+"PhotosCount": 2
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T17:03:38Z"
+"StreetName": "Albert"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8328.34"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29839989/105106-250-albert-street-waterloo"
+"ParkingTotal": 2
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial/Retail"
+"OriginalEntryTimestamp": "2026-06-02T16:33:20.27Z"
+"ListAgentNationalAssociationId": "1239598"
+"ListOfficeNationalAssociationId": "1162020"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29839989_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839989/85e333220422c83ad8fc36f6f85a6a5f.webp"
"MediaSize" => 57505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839989/thumbnail-85e333220422c83ad8fc36f6f85a6a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13228088"
"ResourceRecordKey" => "29839989"
"ModificationTimestamp" => "2026-06-02T16:33:20.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29839989_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839989/ae2b5f56139babbc29d7880eadc245e0.webp"
"MediaSize" => 25093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839989/thumbnail-ae2b5f56139babbc29d7880eadc245e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228088"
"ResourceRecordKey" => "29839989"
"ModificationTimestamp" => "2026-06-02T16:33:20.28Z"
]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839989')"
+"ID": "1484901"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "1481500"
+post_author: 1
+"ListingKey": "29833634"
+"ListingId": "X13222068"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T17:30:30Z"
+"RFModificationTimestamp": "2026-06-01T19:08:25Z"
+"ListPrice": 40000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M1N6"
+"UnparsedAddress": "102 - 690 BELMONT AVENUE, Kitchener, Ontario N2M1N6"
+"Coordinates": array:2 [
0 => -80.517515
1 => 43.453267
]
+"Latitude": 43.453267
+"Longitude": -80.517515
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Lock Stock & Barrel, a beautifully designed, fully turnkey salon business located in the heart of Waterloo's vibrant Belmont Village. This is a rare opportunity to step into an established and successful business in one of the city's most charming and walkable neighbourhoods. The salon features a chic, move in ready interior thoughtfully designed to create an inviting and stylish atmosphere for both clients and staff. With favourable lease terms already in place and a loyal, established clientele, this business offers a seamless transition for a new owner looking to continue its success. Surrounded by Belmont Village's popular boutiques, cafés, and local businesses, the location benefits from steady foot traffic and a strong sense of community. Whether you are an experienced stylist ready to take ownership of your own space or an entrepreneur seeking a ready to operate beauty business, this opportunity offers both lifestyle and income potential in one of Waterloo's most desirable neighbourhoods. An exceptional opportunity to own a thriving salon business in a prime location. (id:62783)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"BusinessType": "Personal Services"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-01T19:08:03.115613+00:00"
+"Directions": "Cross Streets: Union, Glasgow. ** Directions: On Belmont Ave between Union Blvd and Glasgow St."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202928"
+"ListOfficeKey": "294429"
+"PhotosChangeTimestamp": "2026-06-01T16:57:06Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T16:57:06Z"
+"StreetName": "BELMONT"
+"StreetNumber": "690"
+"StreetSuffix": "Avenue"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/07NY2ZuTrNA?si=SRKQtM-c_8293EVI"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29833634/102-690-belmont-avenue-kitchener"
+"GeocodeManualYN": false
+"ZoningDescription": "N/A"
+"OriginalEntryTimestamp": "2026-06-01T16:57:06.09Z"
+"ListAgentNationalAssociationId": "1451479"
+"ListOfficeNationalAssociationId": "1438893"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29833634_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/07afe1b3e140109ea27e7edf60978e29.webp"
"MediaSize" => 125643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-07afe1b3e140109ea27e7edf60978e29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29833634_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/be2e5f95783fdc6d35a1ce203439cdb9.webp"
"MediaSize" => 124218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-be2e5f95783fdc6d35a1ce203439cdb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29833634_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/c377823fd9ebbd917237f5fa90a84fae.webp"
"MediaSize" => 105671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-c377823fd9ebbd917237f5fa90a84fae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29833634_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/c76bce9d9eafab29769f663d11c3e473.webp"
"MediaSize" => 107533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-c76bce9d9eafab29769f663d11c3e473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29833634_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/b7239ce6af91a36d96432b9cfad72556.webp"
"MediaSize" => 126421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-b7239ce6af91a36d96432b9cfad72556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29833634_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/a9db53b7d624a0450fae462ab47c6a0e.webp"
"MediaSize" => 129797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-a9db53b7d624a0450fae462ab47c6a0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29833634_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/b175a002369df63d42739c16a5f76787.webp"
"MediaSize" => 105045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-b175a002369df63d42739c16a5f76787.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29833634_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/a8c71c2f0dc326ad62549f70b991d999.webp"
"MediaSize" => 114527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-a8c71c2f0dc326ad62549f70b991d999.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29833634_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/89704580fd04eb40c92af478cf94159d.webp"
"MediaSize" => 97408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-89704580fd04eb40c92af478cf94159d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29833634_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/276226788910ad4168d8ace399451060.webp"
"MediaSize" => 108974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-276226788910ad4168d8ace399451060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29833634_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/db68f63fe2a9e8fea28cae1b4815f141.webp"
"MediaSize" => 86591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-db68f63fe2a9e8fea28cae1b4815f141.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29833634_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/dbad3c83a6550ae992107e4a127f54d2.webp"
"MediaSize" => 63497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-dbad3c83a6550ae992107e4a127f54d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29833634_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/cd131eb0502e8eda8598d46aae8577ef.webp"
"MediaSize" => 138294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-cd131eb0502e8eda8598d46aae8577ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29833634_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/5e00c856e806617847b212bd6d5c5058.webp"
"MediaSize" => 123521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-5e00c856e806617847b212bd6d5c5058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29833634_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29833634/725f58be2dfd7c3b54c9d75f2740b7f1.webp"
"MediaSize" => 139749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29833634/thumbnail-725f58be2dfd7c3b54c9d75f2740b7f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13222068"
"ResourceRecordKey" => "29833634"
"ModificationTimestamp" => "2026-06-01T16:57:06.09Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29833634')"
+"ID": "1481500"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1482507"
+post_author: 1
+"ListingKey": "29832984"
+"ListingId": "40835280"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T15:10:59Z"
+"RFModificationTimestamp": "2026-06-02T15:25:25Z"
+"ListPrice": 40000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M1N6"
+"UnparsedAddress": "690 BELMONT Avenue W Unit# 102, Kitchener, Ontario N2M1N6"
+"Coordinates": array:2 [
0 => -80.5172214
1 => 43.453327
]
+"Latitude": 43.453327
+"Longitude": -80.5172214
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Lock Stock & Barrel, a beautifully designed, fully turnkey salon business located in the heart of Waterloo’s vibrant Belmont Village. This is a rare opportunity to step into an established and successful business in one of the city’s most charming and walkable neighbourhoods. The salon features a chic, move in ready interior thoughtfully designed to create an inviting and stylish atmosphere for both clients and staff. With favourable lease terms already in place and a loyal, established clientele, this business offers a seamless transition for a new owner looking to continue its success. Surrounded by Belmont Village’s popular boutiques, cafés, and local businesses, the location benefits from steady foot traffic and a strong sense of community. Whether you are an experienced stylist ready to take ownership of your own space or an entrepreneur seeking a ready to operate beauty business, this opportunity offers both lifestyle and income potential in one of Waterloo’s most desirable neighbourhoods. An exceptional opportunity to own a thriving salon business in a prime location. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-01T16:43:10.649492+00:00"
+"Directions": "On Belmont Ave between Union Blvd and Glasgow St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067042"
+"ListOfficeKey": "294394"
+"PhotosChangeTimestamp": "2026-06-01T16:03:19Z"
+"PhotosCount": 15
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T15:02:31Z"
+"StreetDirSuffix": "West"
+"StreetName": "BELMONT"
+"StreetNumber": "690"
+"StreetSuffix": "Avenue"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/07NY2ZuTrNA?si=SRKQtM-c_8293EVI"
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29832984/690-belmont-avenue-w-unit-102-kitchener"
+"CoListAgentKey": "2242919"
+"CoListOfficeKey": "290392"
+"GeocodeManualYN": true
+"OriginalEntryTimestamp": "2026-06-01T16:01:41.98Z"
+"ListAgentNationalAssociationId": "1342144"
+"ListOfficeNationalAssociationId": "1438749"
+"CoListAgentNationalAssociationId": "1481019"
+"CoListOfficeNationalAssociationId": "1386847"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29832984_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/f2f45d4e3c4f2c9d75fd7c44cf55e3ff.webp"
"MediaSize" => 122485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-f2f45d4e3c4f2c9d75fd7c44cf55e3ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:18.35Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29832984_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/e045c9ec9aa3d72c1e55db06f824edfe.webp"
"MediaSize" => 122213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-e045c9ec9aa3d72c1e55db06f824edfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:19.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29832984_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/e8d718ee19bdf6aec48b4583ed0447f1.webp"
"MediaSize" => 101669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-e8d718ee19bdf6aec48b4583ed0447f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:18.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29832984_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/55e297e330daf0ae3d6dc67007176ffd.webp"
"MediaSize" => 103801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-55e297e330daf0ae3d6dc67007176ffd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29832984_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/c9b42cd1a500f5a944b73101ef0c9cc9.webp"
"MediaSize" => 123327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-c9b42cd1a500f5a944b73101ef0c9cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29832984_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/41bfc16abf2e78ba55d137948ecde4ab.webp"
"MediaSize" => 126968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-41bfc16abf2e78ba55d137948ecde4ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29832984_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/cdacb1a8428aa2ea57e4e15c2f8cf681.webp"
"MediaSize" => 103176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-cdacb1a8428aa2ea57e4e15c2f8cf681.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29832984_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/f7c10817abaecdae1753a3add830a2de.webp"
"MediaSize" => 111785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-f7c10817abaecdae1753a3add830a2de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29832984_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/81cbbd74c55a158d73d72d53d423db81.webp"
"MediaSize" => 94336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-81cbbd74c55a158d73d72d53d423db81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29832984_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/506f85e541af5c75a74ff010e5fdb6f7.webp"
"MediaSize" => 105320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-506f85e541af5c75a74ff010e5fdb6f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29832984_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/f5db7ad93ed078c99b5e2958e5dafdc8.webp"
"MediaSize" => 83778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-f5db7ad93ed078c99b5e2958e5dafdc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:17.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29832984_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/03451530ca00b6bbf755b0057041deaf.webp"
"MediaSize" => 57995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-03451530ca00b6bbf755b0057041deaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:18.29Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29832984_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/9a6ef150904b76ae9c7c35b3d44bd4ca.webp"
"MediaSize" => 136780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-9a6ef150904b76ae9c7c35b3d44bd4ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:18.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29832984_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/63d4cf99bca02bccea38300c702aea78.webp"
"MediaSize" => 121871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-63d4cf99bca02bccea38300c702aea78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835280"
"ResourceRecordKey" => "29832984"
"ModificationTimestamp" => "2026-06-01T16:03:18.29Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29832984_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29832984/bc3de73e51ea10f7e7ba3b3db033f56e.webp"
"MediaSize" => 138253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29832984/thumbnail-bc3de73e51ea10f7e7ba3b3db033f56e.webp"
"ResourceName" => "Property"
…6
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29832984')"
+"ID": "1482507"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: "1478688"
+post_author: 1
+"ListingKey": "29830429"
+"ListingId": "X13219054"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T15:21:21Z"
+"RFModificationTimestamp": "2026-05-31T15:34:00Z"
+"ListPrice": 330000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1880.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J3"
+"UnparsedAddress": "6B - 140 UNIVERSITY AVENUE W, Waterloo, Ontario N2L6J3"
+"Coordinates": array:2 [
0 => -80.535203
1 => 43.472972
]
+"Latitude": 43.472972
+"Longitude": -80.535203
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well Established Famous Restaurant. Located at 140 University Ave W, in a high-traffic,high-visibility And One of the most prominent retail plazas. Turnkey opportunity to own a very profitable Korean restaurant in one of Waterloos busiest commercial corridors, Best Location Close to the University of Waterloo and Wilfrid Laurier. This location sees over 40,000 daily foot traffic, ensuring consistent high-volume business. Fully Equipped Kitchen All equipment included. 1,880 sq ft W/ 68 Seats of LLBO Licensed.***Gross Rent $9,250/m included in TMI & Water. Open Hours: Monday - Saturday, 12PM - 11PM | Sunday Closed. ***This is a#1 spot for a restaurant in Waterloo - ideal for investors, owner-operators, or expanding brands looking for strong income.*** (id:62783)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-31T15:33:50.896098+00:00"
+"Directions": "Cross Streets: University Ave / Albert St. ** Directions: Through Entrance."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562748"
+"ListOfficeKey": "91221"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-31T15:12:24Z"
+"PhotosCount": 11
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-31T15:12:24Z"
+"StreetDirSuffix": "West"
+"StreetName": "University"
+"StreetNumber": "140"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29830429/6b-140-university-avenue-w-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-05-31T15:12:24.22Z"
+"ListAgentNationalAssociationId": "1148406"
+"ListOfficeNationalAssociationId": "1155195"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29830429')"
+"ID": "1478688"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: "1474711"
+post_author: 1
+"ListingKey": "29825162"
+"ListingId": "X13214406"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-29T17:30:32Z"
+"RFModificationTimestamp": "2026-05-29T19:30:07Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2Z3"
+"UnparsedAddress": "402 KING STREET N, Waterloo, Ontario N2J2Z3"
+"Coordinates": array:2 [
0 => -80.52628
1 => 43.484483
]
+"Latitude": 43.484483
+"Longitude": -80.52628
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Successfully operating since 2019, this is a rare chance to acquire a proven, high-performing restaurant in a prime King Street North location in Waterloo.This turnkey, well-established business offers outstanding exposure along one of the city's busiest corridors, surrounded by dense residential, student, and commercial activity, including offices such as Manulife. Strong street presence and pylon signage provide consistent visibility and traffic. The location is just minutes from major institutions like University of Waterloo, Wilfrid Laurier University, and Conestoga College. Nearby anchors such as Farm Boy, Tim Hortons, and other big-box retailers, plus close proximity to Wholesale Club, make daily operations and supply runs convenient.The space is approximately 1,200 sq ft with around 40 indoor seats, a modern open-ceiling design, and recent upgrades including new flooring, fresh paint, and bright LED lighting.The commercial kitchen is built for volume, featuring a 15-ft hood with rough-in for an additional 15 ft (up to 30 ft total potential), walk-in cooler, convection oven, gas burners, griller, and more - suitable for high-output or multi-cuisine concepts.Revenue comes from multiple streams including dine-in, catering, tiffin services, and online delivery, backed by an impressive ~4.5 Google rating.Average sales are approximately $52,000 per month. Rent is $6,300 per month, inclusive of TMI, HST, water, and pylon signage.A true turnkey and profitable operation in a high-demand location, ready for the next owner to step in and scale further. All showings by appointment only. (id:62650)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-29T19:29:56.499542+00:00"
+"Directions": "Cross Streets: LAKESHORE/PARKDALE. ** Directions: LOCATED ON KING STREET NORTH JUST SOUTH OF WEBER STREET NORTH, WATERLOO."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2149853"
+"ListOfficeKey": "285194"
+"PhotosChangeTimestamp": "2026-05-29T17:15:10Z"
+"PhotosCount": 38
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-29T17:15:10Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "402"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29825162/402-king-street-n-waterloo"
+"GeocodeManualYN": false
+"ZoningDescription": "SC"
+"OriginalEntryTimestamp": "2026-05-29T17:15:10.06Z"
+"ListAgentNationalAssociationId": "1400674"
+"ListOfficeNationalAssociationId": "1348537"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825162')"
+"ID": "1474711"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 44
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]