array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29967889 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1576730"
+post_author: 1
+"ListingKey": "29967889"
+"ListingId": "X13502408"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T23:20:13Z"
+"RFModificationTimestamp": "2026-06-29T23:24:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K3"
+"UnparsedAddress": "4 - 151 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2K3"
+"Coordinates": array:2 [
0 => -80.508934
1 => 43.471083
]
+"Latitude": 43.471083
+"Longitude": -80.508934
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to unit 4 of 151 Brideport Road, Waterloo. This modern and spacious apartment is perfect for families, professionals, or corporate rentals and is available immediately with a minimum one-year lease. Located in a newer building, this top-floor unit offers 1,500 sq. ft. of bright and comfortable living space, complete with 5 bedrooms and 2 bathrooms. The open-concept design features a large common area that flows seamlessly into the kitchen, creating an inviting space for both relaxation and entertaining. With windows on all four sides and a Juliet balcony, the apartment is flooded with natural light, enhancing its warm and welcoming atmosphere. Convenience and comfort are at the heart of this unit. It comes equipped with in-suite laundry for added ease and includes one dedicated parking spot. The apartment is carpet-free and features central air conditioning, a private furnace, and a water heater with in-unit heating control, allowing you to customize your comfort year-round. The location couldn't be more ideal. Just a short walk to Bridgeport Supercenter, you'll find a variety of shops and services, including Walmart, Tim Hortons, Shoppers Drug Mart, the Dollar Store, and Bulk Barn. The building is also situated on a bus route that provides direct access to local universities, making it a great option for students. For those who commute, the proximity to major highways ensures quick and easy travel. This small building houses only four apartments, offering a quieter and more private living experience. The no-pets and no-smoking policy ensures a clean and peaceful environment for all residents. With its thoughtful design, prime location, and bright interior, this unit is an excellent choice for anyone looking for a well-maintained and convenient place to live. Book your showing today and see all that this beautiful apartment has to offer. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T22:48:48.950487+00:00"
+"Directions": "Cross Streets: ELLIS CR N. ** Directions: ELLIS CR N to Bridgeport Road E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T23:12:48Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T23:12:48Z"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "151"
+"StreetSuffix": "Road"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29967889/4-151-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "N/A"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-29T20:54:15.59Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:26 [
0 => array:13 [
"Order" => 19
"MediaKey" => "29967889_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/f1ceab71801830053a2d8387e83589fd.webp"
"MediaSize" => 73667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-f1ceab71801830053a2d8387e83589fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T20:54:15.6Z"
]
1 => array:13 [
"Order" => 26
"MediaKey" => "29967889_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/3d0b01fb1cf17f3f6027582383f0fd73.webp"
"MediaSize" => 156415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-3d0b01fb1cf17f3f6027582383f0fd73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T20:54:15.6Z"
]
2 => array:13 [
"Order" => 1
"MediaKey" => "29967889_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/d4ebd6bac4e1e66c4fd3971c03525a64.webp"
"MediaSize" => 163401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-d4ebd6bac4e1e66c4fd3971c03525a64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.41Z"
]
3 => array:13 [
"Order" => 2
"MediaKey" => "29967889_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/5e0e9bc246ce21bade7af7d857a82bab.webp"
"MediaSize" => 159695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-5e0e9bc246ce21bade7af7d857a82bab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.76Z"
]
4 => array:13 [
"Order" => 3
"MediaKey" => "29967889_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/ea9c3c1b802f8d406523932ae0ed1070.webp"
"MediaSize" => 79185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-ea9c3c1b802f8d406523932ae0ed1070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.51Z"
]
5 => array:13 [
"Order" => 4
"MediaKey" => "29967889_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/e624f20cd0697f8c1a992adf332a1e23.webp"
"MediaSize" => 79497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-e624f20cd0697f8c1a992adf332a1e23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.61Z"
]
6 => array:13 [
"Order" => 5
"MediaKey" => "29967889_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/7196f1b9218f6befaeee56305c9090cd.webp"
"MediaSize" => 75481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-7196f1b9218f6befaeee56305c9090cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:46.54Z"
]
7 => array:13 [
"Order" => 6
"MediaKey" => "29967889_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/a6c9caba021c51b9628e2a01511d63fd.webp"
"MediaSize" => 85426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-a6c9caba021c51b9628e2a01511d63fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.54Z"
]
8 => array:13 [
"Order" => 7
"MediaKey" => "29967889_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/6424c9e7137d688e596a8b071d054ff2.webp"
"MediaSize" => 84736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-6424c9e7137d688e596a8b071d054ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:46.76Z"
]
9 => array:13 [
"Order" => 8
"MediaKey" => "29967889_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/f5e3600f1f4a44b4ca2ac891471205d5.webp"
"MediaSize" => 86481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-f5e3600f1f4a44b4ca2ac891471205d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.06Z"
]
10 => array:13 [
"Order" => 9
"MediaKey" => "29967889_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/cd03a8790d8e7e62e40abd72b021fcec.webp"
"MediaSize" => 80565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-cd03a8790d8e7e62e40abd72b021fcec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.62Z"
]
11 => array:13 [
"Order" => 10
"MediaKey" => "29967889_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/7d0024942644f0c5cfe80cbbc69ca0d8.webp"
"MediaSize" => 80595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-7d0024942644f0c5cfe80cbbc69ca0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.19Z"
]
12 => array:13 [
"Order" => 11
"MediaKey" => "29967889_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/d6c8e9b42ffa3f31bfa96eceebc8e380.webp"
"MediaSize" => 87548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-d6c8e9b42ffa3f31bfa96eceebc8e380.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.83Z"
]
13 => array:13 [
"Order" => 12
"MediaKey" => "29967889_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/4896de95af1c3be2021f99995f200ba1.webp"
"MediaSize" => 58759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-4896de95af1c3be2021f99995f200ba1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.54Z"
]
14 => array:13 [
"Order" => 13
"MediaKey" => "29967889_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/22c4afa34ac2023f4790661669aa8c47.webp"
"MediaSize" => 80932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-22c4afa34ac2023f4790661669aa8c47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.56Z"
]
15 => array:13 [
"Order" => 14
"MediaKey" => "29967889_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/9ad9fad8db4acbb111387a1b00d71177.webp"
"MediaSize" => 71813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-9ad9fad8db4acbb111387a1b00d71177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.21Z"
]
16 => array:13 [
"Order" => 15
"MediaKey" => "29967889_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/c67f0585f43a0c46eae84f2901e94dd8.webp"
"MediaSize" => 54396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-c67f0585f43a0c46eae84f2901e94dd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.53Z"
]
17 => array:13 [
"Order" => 16
"MediaKey" => "29967889_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/651051244569e0e49209f96691b9f8ed.webp"
"MediaSize" => 52285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-651051244569e0e49209f96691b9f8ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:46.91Z"
]
18 => array:13 [
"Order" => 17
"MediaKey" => "29967889_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/1fae6d2ef8c9875c30f7712c7bb7fa6d.webp"
"MediaSize" => 68617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-1fae6d2ef8c9875c30f7712c7bb7fa6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.83Z"
]
19 => array:13 [
"Order" => 18
"MediaKey" => "29967889_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/6ca3858cd2e0fb19d684a0d09bff5d3f.webp"
"MediaSize" => 66929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-6ca3858cd2e0fb19d684a0d09bff5d3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.33Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "29967889_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/aaab2a52b358ce62d91196795188d404.webp"
"MediaSize" => 73667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-aaab2a52b358ce62d91196795188d404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.39Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "29967889_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/81669b10b4030a09a3e64f66534a6845.webp"
"MediaSize" => 56108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-81669b10b4030a09a3e64f66534a6845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.7Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "29967889_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/ab99b41bc5ca9584f30779f37f079c91.webp"
"MediaSize" => 70875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-ab99b41bc5ca9584f30779f37f079c91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.1Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "29967889_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/dc8c40386c5ff38e6a0178b25062297d.webp"
"MediaSize" => 69269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-dc8c40386c5ff38e6a0178b25062297d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.71Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "29967889_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/01ae1c50c915c0b3fd98fc7e8c79d76d.webp"
"MediaSize" => 150536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-01ae1c50c915c0b3fd98fc7e8c79d76d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:47.55Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "29967889_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967889/b2eb5f06ca6b911e55b492634de6c873.webp"
"MediaSize" => 129293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967889/thumbnail-b2eb5f06ca6b911e55b492634de6c873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13502408"
"ResourceRecordKey" => "29967889"
"ModificationTimestamp" => "2026-06-29T23:12:48.87Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967889')"
+"ID": "1576730"
}
]
+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 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24834
+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 2130557" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24825
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29967889'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25214
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29967889'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29967889' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.508934 43.471083)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25283
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: 1578861
+post_author: 1
+"ListingKey": "29970326"
+"ListingId": "X13504480"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3Br Unit Offers Large Windows, Lots Of Natural Light.9 Ft Ceilings. Custom Kitchen Cabinetry. Fully Furnished Appliance, Ensuite Laundry (brand new), 3 Great Size Bdrms & 2 Full Baths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! Tenant Requirements: One occupant/student per bedroom only. Tenant required to pay all Hydro Charges. Each occupant must provide a qualified guarantor, along with first and last month's rent. No pets permitted. A refundable $500 security deposit per occupant is required and will be returned at the conclusion of the lease term, subject to the unit being maintained in good condition. A refundable key FOB deposit of $125 per FOB is also required and will be returned upon surrender of the FOB at the end of the tenancy. Rent is payable on the first day of each month. Two underground parking spaces are available at an additional cost of $150 per month, per space. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.814800+00:00"
+"Directions": "King St N / University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:27Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:27Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671906610"
"RoomType" => "Dining room"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.53Z"
]
1 => array:11 [
"RoomKey" => "1671906611"
"RoomType" => "Living room"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
2 => array:11 [
"RoomKey" => "1671906612"
"RoomType" => "Kitchen"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
3 => array:11 [
"RoomKey" => "1671906613"
"RoomType" => "Bedroom"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
4 => array:11 [
"RoomKey" => "1671906614"
"RoomType" => "Bedroom 2"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
5 => array:11 [
"RoomKey" => "1671906615"
"RoomType" => "Bedroom 3"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970326/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"TotalActualRent": 3300
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-30T15:16:27.5Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29970326_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/d8b6d91e516290f4bc8aa5e937db5d3c.webp"
"MediaSize" => 186888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-d8b6d91e516290f4bc8aa5e937db5d3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29970326_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/8515be22a8f2711be3cb7096bf495ee8.webp"
"MediaSize" => 104335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-8515be22a8f2711be3cb7096bf495ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29970326_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/950b7527017bf3b0b7b1f74c98be5d5e.webp"
"MediaSize" => 163632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-950b7527017bf3b0b7b1f74c98be5d5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29970326_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/19ce6038aa250fea2ba8f24af491b91e.webp"
"MediaSize" => 158242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-19ce6038aa250fea2ba8f24af491b91e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29970326_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/dbbf811b52f9e3db72119ce74252ea02.webp"
"MediaSize" => 42480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-dbbf811b52f9e3db72119ce74252ea02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29970326_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/d0b18d20136a5fa2619ca6fd303a1d11.webp"
"MediaSize" => 123845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-d0b18d20136a5fa2619ca6fd303a1d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29970326_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/9055c972fcc8cd647138e494f92b64d1.webp"
"MediaSize" => 205003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-9055c972fcc8cd647138e494f92b64d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29970326_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/b0b4a417784c2d57a2c49692dd25152b.webp"
"MediaSize" => 192855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-b0b4a417784c2d57a2c49692dd25152b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29970326_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/02decbd227765f3fb15aad27ac78da7e.webp"
"MediaSize" => 153957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-02decbd227765f3fb15aad27ac78da7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29970326_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/a0f7629bb4ceea4ebf1b9963ed2b8f70.webp"
"MediaSize" => 161431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-a0f7629bb4ceea4ebf1b9963ed2b8f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29970326_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/dde229aadbaa70129b0b0e4ac0ef58fb.webp"
"MediaSize" => 190934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-dde229aadbaa70129b0b0e4ac0ef58fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29970326_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/91ea0ac3b2134f23634ce5ba141bc370.webp"
"MediaSize" => 72377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-91ea0ac3b2134f23634ce5ba141bc370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29970326_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/afad2061d576191542d54165d87aacf9.webp"
"MediaSize" => 78051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-afad2061d576191542d54165d87aacf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29970326_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/37b025ce464c8101379d2b2a339e31d6.webp"
"MediaSize" => 181868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-37b025ce464c8101379d2b2a339e31d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29970326_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/e5176adc371b20a0613344ab3989e4a3.webp"
"MediaSize" => 232599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-e5176adc371b20a0613344ab3989e4a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29970326_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/37b8aef6c208ead58962f433d1098e1c.webp"
"MediaSize" => 251775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-37b8aef6c208ead58962f433d1098e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970326')"
+"ID": 1578861
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1578426"
+post_author: 1
+"ListingKey": "29969537"
+"ListingId": "40844025"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T12:50:17Z"
+"RFModificationTimestamp": "2026-06-30T14:24:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 752.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1C5"
+"UnparsedAddress": "112 UNION Street E Unit# A103, Waterloo, Ontario N2J1C5"
+"Coordinates": array:2 [
0 => -80.5117747
1 => 43.4632327
]
+"Latitude": 43.4632327
+"Longitude": -80.5117747
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this impeccably maintained executive condo, perfectly located just minutes from both Uptown Waterloo and Downtown Kitchener. With easy access to the highway and just steps from the LRT, this move-in-ready home is ideal for professionals and commuters alike. Thoughtfully designed with a highly functional layout, the unit features high-end finishes, abundant natural light, and a completely carpet-free interior. The spacious open-concept kitchen is equipped with stainless steel appliances, quartz countertops, and generous cabinet space—perfect for cooking and entertaining. Additional highlights include 9-foot ceilings, pot lights, fresh paint and all new flooring throughout, a cheater en-suite from the primary bedroom, and the rare bonus of a second entrance to the unit. Modern construction ensures low utility costs, and the location can’t be beat—just steps to the Spur Line Trail, Waterloo Town Square, the Kitchener Tannery District, University of Waterloo and Wilfrid Laurier University, great restaurants, and fresh markets. Don’t miss your chance to live in a vibrant, walkable community! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "295.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T14:24:21.875178+00:00"
+"Directions": "Moore Ave S"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-30T12:40:18Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T12:40:18Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNION"
+"StreetNumber": "112"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1671792175"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844025"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29969537"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T12:40:18.22Z"
]
1 => array:11 [
"RoomKey" => "1671792176"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844025"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29969537"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T12:40:18.22Z"
]
2 => array:11 [
"RoomKey" => "1671792177"
"RoomType" => "Kitchen"
"ListingId" => "40844025"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29969537"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T12:40:18.22Z"
]
3 => array:11 [
"RoomKey" => "1671792178"
"RoomType" => "Dining room"
"ListingId" => "40844025"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29969537"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T12:40:18.22Z"
]
4 => array:11 [
"RoomKey" => "1671792179"
"RoomType" => "Living room"
"ListingId" => "40844025"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29969537"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T12:40:18.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29969537/112-union-street-e-unit-a103-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"TotalActualRent": 1900
+"ZoningDescription": "(H)RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-30T12:40:18.17Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29969537_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/06d94ed5989d0c32109e1d6ee30f94a3.webp"
"MediaSize" => 206390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-06d94ed5989d0c32109e1d6ee30f94a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29969537_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/0d9170a4413da003c4315e77f73ed2c7.webp"
"MediaSize" => 192900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-0d9170a4413da003c4315e77f73ed2c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29969537_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/e56ea50c6f54d6a87faec02218319aa1.webp"
"MediaSize" => 218813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-e56ea50c6f54d6a87faec02218319aa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29969537_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/d5c29a9d1110cd027151162b295d2821.webp"
"MediaSize" => 190742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-d5c29a9d1110cd027151162b295d2821.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29969537_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/09fc01521b0826dbc2fda8b8d527ade8.webp"
"MediaSize" => 74106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-09fc01521b0826dbc2fda8b8d527ade8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29969537_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/0c335f1502fbc2a087726b69e8ee2c17.webp"
"MediaSize" => 79416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-0c335f1502fbc2a087726b69e8ee2c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29969537_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/b213d089bd997db3f4e915a73a718541.webp"
"MediaSize" => 72522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-b213d089bd997db3f4e915a73a718541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29969537_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/96dd4ee0ae860698df98f15b527f7c66.webp"
"MediaSize" => 67953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-96dd4ee0ae860698df98f15b527f7c66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29969537_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/464130fb427ac6b9d7398cea09e2fe6d.webp"
"MediaSize" => 84584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-464130fb427ac6b9d7398cea09e2fe6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29969537_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/c01c39804eb3ee4b24f31f1106b5ec42.webp"
"MediaSize" => 85814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-c01c39804eb3ee4b24f31f1106b5ec42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29969537_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/0cb551c498cc2ecc7fa37db73e3b61f8.webp"
"MediaSize" => 57320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-0cb551c498cc2ecc7fa37db73e3b61f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29969537_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/fd7b43ccfe512c58db97be789c38ba42.webp"
"MediaSize" => 62470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-fd7b43ccfe512c58db97be789c38ba42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29969537_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/814cae76d61110f8c76d2f40f54a6048.webp"
"MediaSize" => 68217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-814cae76d61110f8c76d2f40f54a6048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29969537_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/02981f9b52c276b16837e380fedcede7.webp"
"MediaSize" => 75220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-02981f9b52c276b16837e380fedcede7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29969537_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/812dbd6894cd83a97a71ee459793e10a.webp"
"MediaSize" => 66776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-812dbd6894cd83a97a71ee459793e10a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29969537_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/07b15bcaca233d806fd7b7dffc103d3a.webp"
"MediaSize" => 78095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-07b15bcaca233d806fd7b7dffc103d3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29969537_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/591a96c1abe8efd3fd959d037dc20bdc.webp"
"MediaSize" => 72687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-591a96c1abe8efd3fd959d037dc20bdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29969537_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/46432606cfbd429c0e28433110f63973.webp"
"MediaSize" => 64291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-46432606cfbd429c0e28433110f63973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29969537_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/06520fdeac3f2cc4cb28e2f79afe204d.webp"
"MediaSize" => 87548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-06520fdeac3f2cc4cb28e2f79afe204d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29969537_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/d363ec3a073aa971c96ae2f12d26109a.webp"
"MediaSize" => 74015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-d363ec3a073aa971c96ae2f12d26109a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29969537_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/c948891b6a0c0c9e0012d3004c44c135.webp"
"MediaSize" => 57338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-c948891b6a0c0c9e0012d3004c44c135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29969537_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/d85ab546e937ab21512e9f0356a0ad36.webp"
"MediaSize" => 60666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-d85ab546e937ab21512e9f0356a0ad36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29969537_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/8ee5d9e67999225d66e3e883a3f847a4.webp"
"MediaSize" => 71157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-8ee5d9e67999225d66e3e883a3f847a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29969537_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/affa30684941ca3aac304e7abd944026.webp"
"MediaSize" => 56641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-affa30684941ca3aac304e7abd944026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29969537_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/a0441b37a83f39f5fa9e346bf0f676de.webp"
"MediaSize" => 48342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-a0441b37a83f39f5fa9e346bf0f676de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29969537_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/b88299c500f71909782864ba7f95dc39.webp"
"MediaSize" => 80252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-b88299c500f71909782864ba7f95dc39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29969537_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/e6977e7697cb77add9c8ffdebf1a999e.webp"
"MediaSize" => 61060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-e6977e7697cb77add9c8ffdebf1a999e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29969537_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/8f3e2e324ae32e0e2403281a790b5bec.webp"
"MediaSize" => 176999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-8f3e2e324ae32e0e2403281a790b5bec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29969537_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/7141537a036d7c5eefb7371b9b14199a.webp"
"MediaSize" => 216729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-7141537a036d7c5eefb7371b9b14199a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29969537_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/069ec7c30e89de9c50bab52009535704.webp"
"MediaSize" => 178577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-069ec7c30e89de9c50bab52009535704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29969537_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/bdd8985caaf55944a28e299c1850361f.webp"
"MediaSize" => 165846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969537/thumbnail-bdd8985caaf55944a28e299c1850361f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844025"
"ResourceRecordKey" => "29969537"
"ModificationTimestamp" => "2026-06-30T12:40:18.18Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29969537_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969537/ebb63caa12e4afabff45921d70d79395.webp"
"MediaSize" => 188411
"MediaType" => "webp"
…8
]
32 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969537')"
+"ID": "1578426"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1578052"
+post_author: 1
+"ListingKey": "29969025"
+"ListingId": "40844016"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T01:25:13Z"
+"RFModificationTimestamp": "2026-06-30T04:40:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 691.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "160 KING Street N Unit# #1003, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.5233299
1 => 43.4717062
]
+"Latitude": 43.4717062
+"Longitude": -80.5233299
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 160 King Street N, Unit #1003 – a beautifully spacious 2-bedroom, 2-bathroom condo located in the heart of downtown Waterloo! This bright and modern unit features 9 ft ceilings, oversized windows, and an open-concept living and dining area filled with natural light. Enjoy the convenience of in-suite laundry and a layout that’s perfect for families, students, or working professionals. Just steps from Wilfrid Laurier University, the University of Waterloo, the Science Building, shops, restaurants, and more. Excellent public transit and connectivity make this location unbeatable. Don’t miss this fantastic opportunity to live in one of Waterloo’s most sought-after locations! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:7 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T04:40:34.779512+00:00"
+"Directions": "Intersection of Noecker ST and King ST"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104481"
+"ListOfficeKey": "292713"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "None"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T01:19:37Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T01:19:37Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "160"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29969025/160-king-street-n-unit-1003-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 691
+"OriginalEntryTimestamp": "2026-06-30T01:19:36.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1373851"
+"ListOfficeNationalAssociationId": "1416387"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969025')"
+"ID": "1578052"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1577423"
+post_author: 1
+"ListingKey": "29968865"
+"ListingId": "40843767"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T00:15:06Z"
+"RFModificationTimestamp": "2026-06-30T00:44:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1373.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5166824
1 => 43.4655444
]
+"Latitude": 43.4655444
+"Longitude": -80.5166824
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Newly renovated 2-bedroom plus solarium suite located at The Waterpark Place, 6 Willow Street, in the heart of Waterloo. This prime location is within walking distance to trails, transit, Uptown restaurants, a hospital, and boutique shops, offering an active and convenient urban lifestyle. Bright, spacious suite with panoramic city views and lush treetop canopy outlooks, offering beautiful day-to-night scenery. Elegant blend of comfort and function with wood flooring throughout and a full wall of windows providing abundant natural light. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T00:44:48.882869+00:00"
+"Directions": "Erb Street East to Willow Street"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1601823"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "No Pet Home"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-30T00:11:42Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T00:11:42Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4713"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29968865/6-willow-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1373
+"OriginalEntryTimestamp": "2026-06-30T00:10:11.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1158319"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:44 [
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]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968865')"
+"ID": "1577423"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1577112"
+post_author: 1
+"ListingKey": "29967642"
+"ListingId": "40843788"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T20:20:08Z"
+"RFModificationTimestamp": "2026-06-29T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K3"
+"UnparsedAddress": "151 BRIDGEPORT Road E Unit# 4, Waterloo, Ontario N2J2K3"
+"Coordinates": array:2 [
0 => -80.5089956
1 => 43.4711627
]
+"Latitude": 43.4711627
+"Longitude": -80.5089956
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to unit 4 of 151 Brideport Road, Waterloo. This modern and spacious apartment is perfect for families, professionals, or corporate rentals and is available immediately with a minimum one-year lease. Located in a newer building, this top-floor unit offers 1,500 sq. ft. of bright and comfortable living space, complete with 5 bedrooms and 2 bathrooms. The open-concept design features a large common area that flows seamlessly into the kitchen, creating an inviting space for both relaxation and entertaining. With windows on all four sides and a Juliet balcony, the apartment is flooded with natural light, enhancing its warm and welcoming atmosphere. Convenience and comfort are at the heart of this unit. It comes equipped with in-suite laundry for added ease and includes one dedicated parking spot. The apartment is carpet-free and features central air conditioning, a private furnace, and a water heater with in-unit heating control, allowing you to customize your comfort year-round. The location couldn’t be more ideal. Just a short walk to Bridgeport Supercenter, you’ll find a variety of shops and services, including Walmart, Tim Hortons, Shoppers Drug Mart, the Dollar Store, and Bulk Barn. The building is also situated on a bus route that provides direct access to local universities, making it a great option for students. For those who commute, the proximity to major highways ensures quick and easy travel. This small building houses only four apartments, offering a quieter and more private living experience. The no-pets and no-smoking policy ensures a clean and peaceful environment for all residents. With its thoughtful design, prime location, and bright interior, this unit is an excellent choice for anyone looking for a well-maintained and convenient place to live. Book your showing today and see all that this beautiful apartment has to offer. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T23:03:42.456826+00:00"
+"Directions": "ELLIS CR N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Shared Driveway"
3 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-29T20:10:29Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T20:10:29Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "151"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967642/151-bridgeport-road-e-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2700
+"ZoningDescription": "R-1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-29T20:10:29.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967642')"
+"ID": "1577112"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1575925"
+post_author: 1
+"ListingKey": "29965780"
+"ListingId": "40843373"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T16:20:09Z"
+"RFModificationTimestamp": "2026-06-29T19:32:14Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1B7"
+"UnparsedAddress": "24 UNION Street E Unit# 103, Waterloo, Ontario N2J1B7"
+"Coordinates": array:2 [
0 => -80.5149171
1 => 43.4597179
]
+"Latitude": 43.4597179
+"Longitude": -80.5149171
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "STRIDE on Union! Welcome to elevated living in Mary Allen, walkable to Uptown Waterloo and Belmont Village. This upscale purpose-built rental building is finished to the highest quality. The 1 bed, 1 bath Willow floor plan features luxury finishes, juliette balcony, and walk-in laundry closet. This suite is outfitted with luxury vinyl plank, splendid noir quartz countertops in the kitchen, along with black lower cabinetry and wooden style upper cabinetry, anatolia davenport ash tile in the bathrooms, white subway tile, and sleek black hardware throughout. Steps from Mary Allen Park, the Spur Line trail, Vincenzo's boutique grocer, the LRT, LCBO, Grand River Hospital, and all the amazing restaurants and retail you would come to expect: Arabella, Janet Lynn's Bistro, Casa Rugantino, Beertown, and so much more - an amazing opportunity for spacious living in an unbeatable location! Utilities are extra, high-speed Internet included. Photos are of a similar unit. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T19:31:56.147049+00:00"
+"Directions": "KING AND UNION"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239753"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-29T16:11:12Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:11:12Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNION"
+"StreetNumber": "24"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29965780/24-union-street-e-unit-103-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1995
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 692
+"OriginalEntryTimestamp": "2026-06-29T16:11:12.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1477702"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:41 [
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]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29965780')"
+"ID": "1575925"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1575926"
+post_author: 1
+"ListingKey": "29966631"
+"ListingId": "X13501172"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T18:05:25Z"
+"RFModificationTimestamp": "2026-06-29T18:53:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G3"
+"UnparsedAddress": "609 - 107 ROGER STREET, Waterloo, Ontario N2J0G3"
+"Coordinates": array:2 [
0 => -80.509813
1 => 43.460867
]
+"Latitude": 43.460867
+"Longitude": -80.509813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Spur Line Condos, an exclusive address in the heart of Waterloo. This exceptional 1-bedroom unit offers a spacious and modern living environment, perfect for those seeking a premium rental experience. With its prime location, top-tier amenities, and contemporary finishes, this condo is ideal for professionals and small families alike.Key features include a stylish open-concept kitchen with stainless steel appliances, as well as the added convenience of in-suite laundry. Located in a highly desirable area, this luxury condo is ready to offer you a refined living experience. Schedule a showing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:53:31.271335+00:00"
+"Directions": "Cross Streets: Roger Street And Moore Ave. ** Directions: The lockbox is located at the front of the building, attached to the parking pole. It is yellow in color for easy identification."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1811397"
+"ListOfficeKey": "276295"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:56:25Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:56:25Z"
+"StreetName": "Roger"
+"StreetNumber": "107"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29966631/609-107-roger-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Duka Property Management Inc."
+"GeocodeManualYN": false
+"TotalActualRent": 1650
+"BuildingFeatures": array:2 [
0 => "Party Room"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-29T17:56:25.13Z"
+"ListAgentNationalAssociationId": "1191972"
+"ListOfficeNationalAssociationId": "1272914"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966631')"
+"ID": "1575926"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1575412"
+post_author: 1
+"ListingKey": "29964885"
+"ListingId": "40842736"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T13:40:16Z"
+"RFModificationTimestamp": "2026-06-29T17:29:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 795.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E4"
+"UnparsedAddress": "15 WELLINGTON Street S Unit# 2102, Kitchener, Ontario N2G0E4"
+"Coordinates": array:2 [
0 => -80.5028941
1 => 43.4539363
]
+"Latitude": 43.4539363
+"Longitude": -80.5028941
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully Upgraded 2 Bed, 2 Bath Corner Unit – 21st Floor at Station Park Tower B! Experience elevated living in this stunning 2 bedroom, 2 bathroom corner unit on the 21st floor of Station Park’s Union Towers. Featuring floor-to-ceiling windows, this bright and modern suite offers spectacular panoramic views and premium upgrades throughout, including high-end flooring, tiling, hardware, faucets, and custom blinds. Step outside to your private 45 sq ft balcony—perfect for relaxing or entertaining. What’s Included - 1 Underground Parking Space, Bell Internet, Heat & Air Conditioning. Residents enjoy access to an exceptional range of luxury amenities, including: Two-lane bowling alley with lounge. Premier resident lounge with bar, pool table & foosball. Hydropool swim spa & hot tub. Fully equipped fitness centre, yoga/pilates studio & Peloton studio. Dog washing station / pet spa. Landscaped outdoor terrace with cabanas & BBQs. Concierge service. Private dining room with full kitchen. Smart parcel locker system for secure deliveries. Located in the heart of Kitchener-Waterloo’s Innovation District, Station Park places you steps from shopping, dining, and everyday conveniences—with a grocery store and more right at your doorstep. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:29:26.020253+00:00"
+"Directions": "King & Wellington St S - Across from Google"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964580"
+"ListOfficeKey": "292479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "None"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-29T13:32:19Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T13:32:19Z"
+"Stories": "29.0"
+"StreetDirSuffix": "South"
+"StreetName": "WELLINGTON"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"SubdivisionName": "313 - Downtown Kitchener/W. Ward"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964885/15-wellington-street-s-unit-2102-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "mU3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 795
+"OriginalEntryTimestamp": "2026-06-29T13:32:19.41Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1262615"
+"ListOfficeNationalAssociationId": "1412478"
+"Media": array:44 [
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]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964885')"
+"ID": "1575412"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1574889"
+post_author: 1
+"ListingKey": "29964581"
+"ListingId": "X13499338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T05:50:02Z"
+"RFModificationTimestamp": "2026-06-29T06:03:44Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "2204 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spotless | 22nd Floor | 1 BR + Den | Waterloo Core -Welcome to Unit 2204 - a pristine, owner-occupied suite offering clear northwest views and an abundance of natural light through floor-to-ceiling windows. Whether you are a single or couple, this move-in ready condo checks every box.The open-concept layout features a modern kitchen with stainless steel appliances, integrated dishwasher, and microwave/range hood, with sleek laminate flooring throughout. The den is currently open to the living area, creating a bright, loft-like feel - and easily enclosed as a fully private bedroom with the closet already in place. The primary bedroom features a mirrored closet and floor-to-ceiling windows. The 4-piece bath is finished with a soaker tub and ceramic tile flooring. Ensuite laundry included. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Blinds"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:03:42.880502+00:00"
+"Directions": "King & University Ave"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2008266"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T05:40:30Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T05:40:30Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964581/2204-158-king-street-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc"
+"GeocodeManualYN": false
+"TotalActualRent": 1700
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-29T05:40:30.2Z"
+"ListAgentNationalAssociationId": "1290180"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964581')"
+"ID": "1574889"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 179
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]