array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29975204 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: "1582225"
+post_author: 1
+"ListingKey": "29975204"
+"ListingId": "X13508656"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:20:02Z"
+"RFModificationTimestamp": "2026-07-01T16:45:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2J1"
+"UnparsedAddress": "239 ROYAL STREET, Waterloo, Ontario N2J2J1"
+"Coordinates": array:2 [
0 => -80.505526
1 => 43.470871
]
+"Latitude": 43.470871
+"Longitude": -80.505526
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 239 Royal Street, a beautifully maintained bungalow nestled on a quiet, tree-lined street in one of Waterloo's most sought-after family neighbourhoods. Thoughtfully updated while preserving its timeless charm, this inviting home offers bright, functional living spaces designed for everyday comfort. The sun-filled open-concept living and dining area features engineered hardwood flooring and flows seamlessly into the beautifully renovated kitchen, complete with soft-close cabinetry, a Peka Magic Corner system, gas stove, Solatube skylight, and generous workspace. Three spacious main-floor bedrooms and a stylishly renovated four-piece bathroom provide comfortable accommodations for the whole family. The partially finished lower level expands the living space with a large recreation room featuring a cozy gas fireplace, a three-piece bathroom, and a convenient separate side entrance, offering excellent potential for an in-law suite or multigenerational living. Step outside to enjoy the expansive, fully fenced backyard with mature trees and a covered patio, creating the perfect setting for summer barbecues, outdoor entertaining, or relaxing evenings at home. Ideally located just minutes from parks, walking trails, excellent schools, shopping, and easy access to the Expressway, this is a wonderful opportunity to own a move-in-ready home in an exceptional Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:45:19.917992+00:00"
+"Directions": "Bridgeport Rd E / Margaret Ave N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1961392"
+"ListOfficeKey": "293699"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T15:13:43Z"
+"PhotosCount": 23
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T15:13:43Z"
+"Stories": "1.0"
+"StreetName": "Royal"
+"StreetNumber": "239"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1672696591"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13508656"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29975204"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.25Z"
]
1 => array:11 [
"RoomKey" => "1672696592"
"RoomType" => "Bedroom 2"
"ListingId" => "X13508656"
"RoomLevel" => "Main level"
"RoomWidth" => 2.54
"ListingKey" => "29975204"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.25Z"
]
2 => array:11 [
"RoomKey" => "1672696593"
"RoomType" => "Bedroom 3"
"ListingId" => "X13508656"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29975204"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.25Z"
]
3 => array:11 [
"RoomKey" => "1672696594"
"RoomType" => "Kitchen"
"ListingId" => "X13508656"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29975204"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.26Z"
]
4 => array:11 [
"RoomKey" => "1672696595"
"RoomType" => "Living room"
"ListingId" => "X13508656"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29975204"
"RoomLength" => 4.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.26Z"
]
5 => array:11 [
"RoomKey" => "1672696596"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13508656"
"RoomLevel" => "Basement"
"RoomWidth" => 10.54
"ListingKey" => "29975204"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.26Z"
]
6 => array:11 [
"RoomKey" => "1672696597"
"RoomType" => "Utility room"
"ListingId" => "X13508656"
"RoomLevel" => "Basement"
"RoomWidth" => 8.41
"ListingKey" => "29975204"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T15:13:43.26Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975204/239-royal-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3350
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-01T15:13:43.22Z"
+"ListAgentNationalAssociationId": "1251301"
+"ListOfficeNationalAssociationId": "1430373"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29975204_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/132835ceedf5b598fbc10da62e7b52d4.webp"
"MediaSize" => 216699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-132835ceedf5b598fbc10da62e7b52d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29975204_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/00843aecc58471387e3aa1b9417342d1.webp"
"MediaSize" => 131366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-00843aecc58471387e3aa1b9417342d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29975204_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/fd28495e66a94388afb3a08e98188ac1.webp"
"MediaSize" => 136829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-fd28495e66a94388afb3a08e98188ac1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29975204_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/c81620dd32d25e4621ce36ca8595c799.webp"
"MediaSize" => 133360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-c81620dd32d25e4621ce36ca8595c799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29975204_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/6bfe0d5acaf9f4f4e1e75346e4683182.webp"
"MediaSize" => 127220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-6bfe0d5acaf9f4f4e1e75346e4683182.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29975204_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/039549e359578c3f79eba84aa0392824.webp"
"MediaSize" => 103494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-039549e359578c3f79eba84aa0392824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29975204_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/9c2335d06546cb7a41b7710c4ab3788b.webp"
"MediaSize" => 122204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-9c2335d06546cb7a41b7710c4ab3788b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29975204_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/b8911e782fa4cd671f8443e2526ad20c.webp"
"MediaSize" => 130186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-b8911e782fa4cd671f8443e2526ad20c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29975204_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/35c877ed5ff861123e514703db991aa2.webp"
"MediaSize" => 110667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-35c877ed5ff861123e514703db991aa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29975204_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/1fc7046e194a96e75b09899b266cdcb2.webp"
"MediaSize" => 101638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-1fc7046e194a96e75b09899b266cdcb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29975204_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/e6227a3704a3dbc723d7f4520af0c64d.webp"
"MediaSize" => 135204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-e6227a3704a3dbc723d7f4520af0c64d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29975204_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/7dbd154a085191b602e2741a207c300b.webp"
"MediaSize" => 112662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-7dbd154a085191b602e2741a207c300b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29975204_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/eedb143695f4288c0e3ed0de3b0397fd.webp"
"MediaSize" => 121668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-eedb143695f4288c0e3ed0de3b0397fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29975204_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/7a0f994ad413e5c2b42a7c4ef60a9333.webp"
"MediaSize" => 139936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-7a0f994ad413e5c2b42a7c4ef60a9333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29975204_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/8bd6c497e21148be163c86fe2e8cb343.webp"
"MediaSize" => 124825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-8bd6c497e21148be163c86fe2e8cb343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29975204_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/3e8025c2ecdc7ac63316527ede569d54.webp"
"MediaSize" => 99909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-3e8025c2ecdc7ac63316527ede569d54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29975204_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/a480409fd3bfe30a956760628326c886.webp"
"MediaSize" => 195288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-a480409fd3bfe30a956760628326c886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29975204_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/de900956fcbc3e4e1baf086948986581.webp"
"MediaSize" => 306592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-de900956fcbc3e4e1baf086948986581.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29975204_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/9253d941c7ce60fc214f74b163bab9a4.webp"
"MediaSize" => 288578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-9253d941c7ce60fc214f74b163bab9a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29975204_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/f83b18ea7fbb5fa4ae7d63b10236400b.webp"
"MediaSize" => 222918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-f83b18ea7fbb5fa4ae7d63b10236400b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29975204_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/530069da03dfa9692d307d63e64575fb.webp"
"MediaSize" => 233583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-530069da03dfa9692d307d63e64575fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29975204_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/474995c2d8c5e80dfa5e50ea2335ccf8.webp"
"MediaSize" => 56936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-474995c2d8c5e80dfa5e50ea2335ccf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29975204_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975204/39636d94ed08e9e3bec5915182b73a45.webp"
"MediaSize" => 52188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975204/thumbnail-39636d94ed08e9e3bec5915182b73a45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508656"
"ResourceRecordKey" => "29975204"
"ModificationTimestamp" => "2026-07-01T15:13:43.23Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975204')"
+"ID": "1582225"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293699" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "293699"
+"ModificationTimestamp": "2025-03-10T23:20:07Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293699"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293699')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1961392" => 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 '29975204'" => 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.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29975204'" => 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.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29975204' 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.505526 43.470871)) 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: 1582650
+post_author: 1
+"ListingKey": "29974901"
+"ListingId": "40844333"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T14:00:06Z"
+"RFModificationTimestamp": "2026-07-01T17:13:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H5N8"
+"UnparsedAddress": "10 SHANLEY Street Unit# B, Kitchener, Ontario N2H5N8"
+"Coordinates": array:2 [
0 => -80.5052501
1 => 43.4557058
]
+"Latitude": 43.4557058
+"Longitude": -80.5052501
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous 2 Bedroom Apartment in Midtown! (Unit B) Don't miss your chance to call this newly renovated 2-bedroom apartment in a charming century home your new home! Featuring in-suite laundry, a bright open layout, and plenty of character, this home offers the perfect combination of comfort and convenience. Ideally located between Uptown Waterloo and Downtown Kitchener, you'll be just steps from the LRT, Tim Hortons, grocery stores, pharmacies, and more. Enjoy easy access to Google, Grand River Hospital, parks, restaurants, and everyday amenities. • 2 Bedrooms • 1 Bathroom • Open-Concept Main Floor • 5 Appliances (Fridge, Stove, Microwave, Washer & Dryer) • 2 Separate Entrances • Lovely Covered Front Porch • Small Back Deck • Outdoor Space • Carpet-Free • Large Windows • 1 Parking Space Included Rent Plus Electricity (Gas & Water Included with a $100 Monthly Cap) * * Available Sep 1st, 2026!! * ***See sales brochure below for showing instructions*** (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-01T17:01:33.343747+00:00"
+"Directions": "King St W to Andrew St. to Shanley St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2026-07-01T13:50:47Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T13:50:47Z"
+"Stories": "1.0"
+"StreetName": "SHANLEY"
+"StreetNumber": "10"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1672652479"
"RoomType" => "Kitchen"
"ListingId" => "40844333"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974901"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T13:50:47.36Z"
]
1 => array:11 [
"RoomKey" => "1672652481"
"RoomType" => "Laundry room"
"ListingId" => "40844333"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974901"
"RoomLength" => null
"RoomDimensions" => "4'0'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T13:50:47.37Z"
]
2 => array:11 [
"RoomKey" => "1672652483"
"RoomType" => "Bedroom"
"ListingId" => "40844333"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974901"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T13:50:47.37Z"
]
3 => array:11 [
"RoomKey" => "1672652484"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844333"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974901"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T13:50:47.37Z"
]
4 => array:11 [
"RoomKey" => "1672652486"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844333"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974901"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T13:50:47.38Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974901/10-shanley-street-unit-b-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1750
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-07-01T13:50:47.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1196776"
+"ListOfficeNationalAssociationId": "1484182"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29974901_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/1f808f7499fd042d21cea7cf62b0b4bd.webp"
"MediaSize" => 23301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-1f808f7499fd042d21cea7cf62b0b4bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring brown siding, white window trim, and a prominent front porch"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29974901_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/06d5fc89c1af6cf1a8774ce1d095b719.webp"
"MediaSize" => 29089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-06d5fc89c1af6cf1a8774ce1d095b719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29974901_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/bc500915fa69cfcab648d30ea7abcc32.webp"
"MediaSize" => 17541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-bc500915fa69cfcab648d30ea7abcc32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a white floating shelf, white walls, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29974901_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/c09dcbb84d0ffc588a40bd72e5450fcd.webp"
"MediaSize" => 22211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-c09dcbb84d0ffc588a40bd72e5450fcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, two large windows with blinds and drapery, a ceiling fan with integrated lighting, and recessed ceiling lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29974901_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/fcd311cd28bc3669f50cda9a9b3f4554.webp"
"MediaSize" => 24123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-fcd311cd28bc3669f50cda9a9b3f4554.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, white baseboards, a white paneled door, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29974901_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/6e871239b8c9f550f65e762ee0023a38.webp"
"MediaSize" => 16594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-6e871239b8c9f550f65e762ee0023a38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry door featuring a privacy blind, paneling, and a white finish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29974901_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/09af91a14394e70c27cbe145733c0bca.webp"
"MediaSize" => 27922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-09af91a14394e70c27cbe145733c0bca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring wood-finish flooring, white walls, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29974901_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/84af312028e1588b50647e05c9ba9a4b.webp"
"MediaSize" => 36375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-84af312028e1588b50647e05c9ba9a4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a white vanity with a single basin sink and chrome faucet, a mirrored medicine cabinet, a built-in storage cabinet, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29974901_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/a4bbdbc8300b629c8bf49fcf7cdbbc39.webp"
"MediaSize" => 21678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-a4bbdbc8300b629c8bf49fcf7cdbbc39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, crisp white walls, and a contemporary ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29974901_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/aa85bbd9a22c32e9d8481526fe58a0f2.webp"
"MediaSize" => 23733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-aa85bbd9a22c32e9d8481526fe58a0f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, white baseboards, a window with blinds, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29974901_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/1a318cfc090f86bc58ee1d5db757f575.webp"
"MediaSize" => 27420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-1a318cfc090f86bc58ee1d5db757f575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact kitchen featuring white upper cabinetry, dark lower cabinetry, stainless steel appliances, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29974901_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/780551ef0c1892a899a9f79b12fc95a2.webp"
"MediaSize" => 57169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-780551ef0c1892a899a9f79b12fc95a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious covered porch featuring wood flooring and a slatted wood railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29974901_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/359c3bb0491ef12b1cc6399379fb0b79.webp"
"MediaSize" => 68819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-359c3bb0491ef12b1cc6399379fb0b79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29974901_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974901/a1afa30ddc772fb2a6760decd6dff15c.webp"
"MediaSize" => 72697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974901/thumbnail-a1afa30ddc772fb2a6760decd6dff15c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior entry featuring a new wood staircase with railings, a clear canopy, and a white door with an arched brick frame"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844333"
"ResourceRecordKey" => "29974901"
"ModificationTimestamp" => "2026-07-01T13:50:47.23Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974901')"
+"ID": 1582650
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970326')"
+"ID": "1578861"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+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
…4
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969537')"
+"ID": "1578426"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969025')"
+"ID": "1578052"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1577423"
+post_author: 1
+"ListingKey": "29968865"
+"ListingId": "40843767"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T19:30:08Z"
+"RFModificationTimestamp": "2026-06-30T19:36:32Z"
+"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:62783)"
+"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-30T19:20:23Z"
+"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-unit-1004-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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968865')"
+"ID": "1577423"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967642')"
+"ID": "1577112"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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 [ …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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967889')"
+"ID": "1576730"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29965780')"
+"ID": "1575925"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1575748"
+post_author: 1
+"ListingKey": "29966573"
+"ListingId": "40843606"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T18:00:06Z"
+"RFModificationTimestamp": "2026-06-29T18:57:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 580.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E3"
+"UnparsedAddress": "5 WELLINGTON Street S Unit# 401, Kitchener, Ontario N2G0E3"
+"Coordinates": array:2 [
0 => -80.5028425
1 => 43.4534246
]
+"Latitude": 43.4534246
+"Longitude": -80.5028425
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Station Park – one of Kitchener's premier condominium communities in the heart of the Innovation District! This brand-new podium-level suite offers upgraded finishes, a desirable courtyard-facing exposure, and a thoughtfully designed layout featuring convenient ensuite bathroom access from the bedroom. Enjoy modern open-concept living with quality finishes throughout, perfect for professionals, first-time tenants, or those seeking a vibrant urban lifestyle. Located just steps from the ION LRT, Google offices, downtown restaurants, cafés, shopping, and entertainment, this unbeatable location puts everything you need within walking distance. Station Park is renowned for its resort-inspired amenities, including a bowling alley, arcade and jam room, private dining room, beautifully appointed lobby, outdoor amphitheatre, dog park, workstations, The Circuit fitness area, expansive green spaces, and planned retail including a grocery store right on-site. Complete with 1 underground parking space and 1 storage locker, this is an exceptional opportunity to lease a brand-new home in one of Kitchener's most sought-after developments. Experience modern urban living at its finest! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:57:27.206149+00:00"
+"Directions": "Entrance to Condo is off 5 Wellington St South. (the corner of King St West and Wellington St South), Kitchener, Waterloo"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962973"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-29T17:51:20Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:51:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "WELLINGTON"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"SubdivisionName": "313 - Downtown Kitchener/W. Ward"
+"TaxAnnualAmount": "2812"
+"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/29966573/5-wellington-street-s-unit-401-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1895
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C5&C3"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 580
+"OriginalEntryTimestamp": "2026-06-29T17:51:19.53Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1252469"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966573')"
+"ID": "1575748"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 150
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]