array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29537260 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: "1269581"
+post_author: 1
+"ListingKey": "29537260"
+"ListingId": "X12939250"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:09Z"
+"RFModificationTimestamp": "2026-06-29T17:57:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1N2"
+"UnparsedAddress": "BSMT - 251 ERB STREET E, Waterloo, Ontario N2J1N2"
+"Coordinates": array:2 [
0 => -80.502502
1 => 43.470538
]
+"Latitude": 43.470538
+"Longitude": -80.502502
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully Renovated 2-Bedroom 1 Bathroom Bsmt Apartment in Prime Waterloo Location. Spacious and bright legal 2-bedroom, 1-bathroom basement accessory apartment ideally located at Erb St E & Margaret St in Waterloo, just minutes from Downtown Waterloo and a short drive to both universities.This well-maintained unit features a large open living area, two oversized bedrooms, and a modern 3-piece bathroom. The apartment has been fully renovated, including new plumbing, electrical, flooring, bathroom, and kitchenette, New Stove, New Fridge, New Washer & Dryer (2025), along with a new metal roof for the home. The entire property has also been professionally waterproofed around the perimeter, providing added comfort and peace of mind. Enjoy a bright interior with windows in every room, separate laundry, and an extra-large storage room (11' x 17'). Additional features include: 1 driveway parking space. All utilities included (Hydro, Gas & Water). Quiet residential setting with convenient access to shopping, transit, and amenities. A great opportunity to live in a renovated, spacious unit in one of Waterloo's most convenient locations. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-03-31T16:53:08.848244+00:00"
+"Directions": "Cross Streets: Erb St E & Margaret Ave South. ** Directions: Erb St E & Margaret Ave S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908361"
+"ListOfficeKey": "50455"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T16:56:13Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:56:13Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Erb"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29537260/bsmt-251-erb-street-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1750
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-03-31T15:49:42.26Z"
+"ListAgentNationalAssociationId": "1221257"
+"ListOfficeNationalAssociationId": "1003204"
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6556740258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/c821e9da16e3a2413d7cd4da7565f889.webp"
"MediaSize" => 64219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-c821e9da16e3a2413d7cd4da7565f889.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-03-31T15:49:42.26Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6556740308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/1335a07b8ebb94f3dd892fd01fd8577b.webp"
"MediaSize" => 84301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-1335a07b8ebb94f3dd892fd01fd8577b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-03-31T15:49:42.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29537260_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/0409eb5efc406ddfa7e4f5c92ff65abe.webp"
"MediaSize" => 45576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-0409eb5efc406ddfa7e4f5c92ff65abe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:05.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29537260_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/02864ba7ed14d66fd403e6667c6f3dc6.webp"
"MediaSize" => 39516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-02864ba7ed14d66fd403e6667c6f3dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:01.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29537260_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/2c5bbae7c2e5a03b44fac087fb9ce15e.webp"
"MediaSize" => 40617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-2c5bbae7c2e5a03b44fac087fb9ce15e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:00.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29537260_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/4b61d4588a318daa12c58bbe37b45e9b.webp"
"MediaSize" => 33174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-4b61d4588a318daa12c58bbe37b45e9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:09.54Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29537260_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/d0af1b7a15ead4df9bf84fffd062e67e.webp"
"MediaSize" => 33822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-d0af1b7a15ead4df9bf84fffd062e67e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:01.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29537260_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/d24a24f377db511b072c51512a6ef5f4.webp"
"MediaSize" => 35158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-d24a24f377db511b072c51512a6ef5f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:02.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29537260_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/5f8d0fc5a0be43539b65ca962ad6b240.webp"
"MediaSize" => 35158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-5f8d0fc5a0be43539b65ca962ad6b240.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:03.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29537260_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/d53a2fac92e9237213aeb0495a8af6bb.webp"
"MediaSize" => 33435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-d53a2fac92e9237213aeb0495a8af6bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:55.91Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29537260_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/a735f1198c13eef217610065ac9f0219.webp"
"MediaSize" => 36774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-a735f1198c13eef217610065ac9f0219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:58.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29537260_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/285386e531c34475ef2af066a732340a.webp"
"MediaSize" => 34359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-285386e531c34475ef2af066a732340a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3Pc Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:54.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29537260_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/71b816dbde9e379a3d8d6b2cb4c2ca3c.webp"
"MediaSize" => 31160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-71b816dbde9e379a3d8d6b2cb4c2ca3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3Pc Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:57.9Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29537260_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/8596c4e322d4b13deb234e82e2711c52.webp"
"MediaSize" => 29578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-8596c4e322d4b13deb234e82e2711c52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3Pc Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:55.75Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29537260_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/eccc96e98c877539c67a881d8d3cdd27.webp"
"MediaSize" => 37078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-eccc96e98c877539c67a881d8d3cdd27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:55.91Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29537260_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/7b2309ee16ddb41ca7724ef01194db8a.webp"
"MediaSize" => 37078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-7b2309ee16ddb41ca7724ef01194db8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:03.66Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29537260_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/11557aedf51c78f8f2fd80ec7c7c60e6.webp"
"MediaSize" => 34585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-11557aedf51c78f8f2fd80ec7c7c60e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:54.38Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29537260_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/7f34a3eb6abbe08ea809f99dea643429.webp"
"MediaSize" => 34585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-7f34a3eb6abbe08ea809f99dea643429.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:58.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29537260_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/691dd3bce14b587e310136669e62c80b.webp"
"MediaSize" => 37998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-691dd3bce14b587e310136669e62c80b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:56Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29537260_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/916ae4330a85ec2928eca7a898f0137f.webp"
"MediaSize" => 38567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-916ae4330a85ec2928eca7a898f0137f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:01:00.42Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29537260_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29537260/3e5814a6694b435ff07ddecc47a8d8c7.webp"
"MediaSize" => 50202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29537260/thumbnail-3e5814a6694b435ff07ddecc47a8d8c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mechanical Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12939250"
"ResourceRecordKey" => "29537260"
"ModificationTimestamp" => "2026-06-29T16:00:57.55Z"
]
]
+"DaysOnMarket": 92
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29537260')"
+"ID": "1269581"
}
]
+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 50455" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24863
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908361" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24789
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29537260'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29537260'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25228
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29537260' 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.502502 43.470538)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25281
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1578861"
+post_author: 1
+"ListingKey": "29970326"
+"ListingId": "X13504480"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3Br Unit Offers Large Windows, Lots Of Natural Light.9 Ft Ceilings. Custom Kitchen Cabinetry. Fully Furnished Appliance, Ensuite Laundry (brand new), 3 Great Size Bdrms & 2 Full Baths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! Tenant Requirements: One occupant/student per bedroom only. Tenant required to pay all Hydro Charges. Each occupant must provide a qualified guarantor, along with first and last month's rent. No pets permitted. A refundable $500 security deposit per occupant is required and will be returned at the conclusion of the lease term, subject to the unit being maintained in good condition. A refundable key FOB deposit of $125 per FOB is also required and will be returned upon surrender of the FOB at the end of the tenancy. Rent is payable on the first day of each month. Two underground parking spaces are available at an additional cost of $150 per month, per space. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.814800+00:00"
+"Directions": "King St N / University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:27Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:27Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671906610"
"RoomType" => "Dining room"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.53Z"
]
1 => array:11 [
"RoomKey" => "1671906611"
"RoomType" => "Living room"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
2 => array:11 [
"RoomKey" => "1671906612"
"RoomType" => "Kitchen"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970326"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
3 => array:11 [
"RoomKey" => "1671906613"
"RoomType" => "Bedroom"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
4 => array:11 [
"RoomKey" => "1671906614"
"RoomType" => "Bedroom 2"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
5 => array:11 [
"RoomKey" => "1671906615"
"RoomType" => "Bedroom 3"
"ListingId" => "X13504480"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970326"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:27.54Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970326/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"TotalActualRent": 3300
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-30T15:16:27.5Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29970326_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/d8b6d91e516290f4bc8aa5e937db5d3c.webp"
"MediaSize" => 186888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-d8b6d91e516290f4bc8aa5e937db5d3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29970326_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/8515be22a8f2711be3cb7096bf495ee8.webp"
"MediaSize" => 104335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-8515be22a8f2711be3cb7096bf495ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29970326_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/950b7527017bf3b0b7b1f74c98be5d5e.webp"
"MediaSize" => 163632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-950b7527017bf3b0b7b1f74c98be5d5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29970326_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/19ce6038aa250fea2ba8f24af491b91e.webp"
"MediaSize" => 158242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-19ce6038aa250fea2ba8f24af491b91e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29970326_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/dbbf811b52f9e3db72119ce74252ea02.webp"
"MediaSize" => 42480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-dbbf811b52f9e3db72119ce74252ea02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29970326_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/d0b18d20136a5fa2619ca6fd303a1d11.webp"
"MediaSize" => 123845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-d0b18d20136a5fa2619ca6fd303a1d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29970326_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/9055c972fcc8cd647138e494f92b64d1.webp"
"MediaSize" => 205003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-9055c972fcc8cd647138e494f92b64d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29970326_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/b0b4a417784c2d57a2c49692dd25152b.webp"
"MediaSize" => 192855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-b0b4a417784c2d57a2c49692dd25152b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29970326_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/02decbd227765f3fb15aad27ac78da7e.webp"
"MediaSize" => 153957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-02decbd227765f3fb15aad27ac78da7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29970326_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/a0f7629bb4ceea4ebf1b9963ed2b8f70.webp"
"MediaSize" => 161431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-a0f7629bb4ceea4ebf1b9963ed2b8f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29970326_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/dde229aadbaa70129b0b0e4ac0ef58fb.webp"
"MediaSize" => 190934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-dde229aadbaa70129b0b0e4ac0ef58fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29970326_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/91ea0ac3b2134f23634ce5ba141bc370.webp"
"MediaSize" => 72377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-91ea0ac3b2134f23634ce5ba141bc370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29970326_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/afad2061d576191542d54165d87aacf9.webp"
"MediaSize" => 78051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-afad2061d576191542d54165d87aacf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29970326_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/37b025ce464c8101379d2b2a339e31d6.webp"
"MediaSize" => 181868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-37b025ce464c8101379d2b2a339e31d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29970326_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/e5176adc371b20a0613344ab3989e4a3.webp"
"MediaSize" => 232599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-e5176adc371b20a0613344ab3989e4a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29970326_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970326/37b8aef6c208ead58962f433d1098e1c.webp"
"MediaSize" => 251775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970326/thumbnail-37b8aef6c208ead58962f433d1098e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504480"
"ResourceRecordKey" => "29970326"
"ModificationTimestamp" => "2026-06-30T15:16:27.51Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970326')"
+"ID": "1578861"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+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"
…8
]
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 {#25278
+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 {#25276
+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 {#25271
+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 {#25279
+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 {#25280
+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: 147
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]