array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30000343 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1600663"
+post_author: 1
+"ListingKey": "30000343"
+"ListingId": "40846027"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:55:15Z"
+"RFModificationTimestamp": "2026-07-07T18:49:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N2"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 206, Waterloo, Ontario N2V2N2"
+"Coordinates": array:2 [
0 => -80.598166
1 => 43.4707566
]
+"Latitude": 43.4707566
+"Longitude": -80.598166
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 206-776 Laurelwood Drive, located in the heart of the highly sought-after Laurelwood community and top-rated school district! This bright and stylish 2-bedroom, 2-bathroom condo features an open-concept layout with a spacious kitchen offering stainless steel appliances, abundant counter space, a large island with breakfast bar, and extra cabinetry. The primary bedroom includes a walk-in closet and private ensuite, while the second bedroom is thoughtfully located on the opposite side for added privacy. Enjoy the rare benefit of a ground-level walk-out patio backing onto green space, providing exceptional privacy and easy outdoor access. Complete with in-suite laundry, one surface parking space, and a storage locker, residents also enjoy amenities including a party room, theatre, lounge/library, and BBQ pavilion. Ideally located close to the University of Waterloo, Uptown Waterloo, The Boardwalk, shopping, restaurants, parks, trails, and Laurel Creek Conservation Area. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "414.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T18:49:24.232192+00:00"
+"Directions": "Erbsville to Laurelwood Drive"
+"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": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
3 => "Shared Driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-07T17:48:31Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:48:31Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1677488348"
"RoomType" => "Full bathroom"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
1 => array:11 [
"RoomKey" => "1677488349"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
2 => array:11 [
"RoomKey" => "1677488350"
"RoomType" => "Bedroom"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
3 => array:11 [
"RoomKey" => "1677488351"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
4 => array:11 [
"RoomKey" => "1677488352"
"RoomType" => "Living room"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
5 => array:11 [
"RoomKey" => "1677488353"
"RoomType" => "Kitchen"
"ListingId" => "40846027"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30000343"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T17:48:31.45Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30000343/776-laurelwood-drive-unit-206-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-07T17:48:31.36Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30000343_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/ed486a8ae737becda271bf3f6eb63fd5.webp"
"MediaSize" => 145268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-ed486a8ae737becda271bf3f6eb63fd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story building facade featuring a prominent stone-clad central tower and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30000343_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/1fe73220f684afd9c315482eaff7d0d2.webp"
"MediaSize" => 117087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-1fe73220f684afd9c315482eaff7d0d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30000343_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/31cd7ded2532c73a80307ad26654cdff.webp"
"MediaSize" => 159888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-31cd7ded2532c73a80307ad26654cdff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building entrance featuring stone facade, prominent columns, black-framed glass doors, and a large portico"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30000343_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/f15d7c796f2604c4c7ac5ba4e5748475.webp"
"MediaSize" => 76592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-f15d7c796f2604c4c7ac5ba4e5748475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30000343_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/1507912234045f9e973fb01eb49d444e.webp"
"MediaSize" => 94226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-1507912234045f9e973fb01eb49d444e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring large format tile flooring, crown molding, recessed lighting, and decorative pillars"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30000343_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/67e59445ed62d7674c64b372e40ceb2a.webp"
"MediaSize" => 111040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-67e59445ed62d7674c64b372e40ceb2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood-finish flooring, light-toned wall paint, and a window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30000343_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/a2fb276f5a22e3a6b334852e131eac36.webp"
"MediaSize" => 100154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-a2fb276f5a22e3a6b334852e131eac36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30000343_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/b1899ed3b855c992ad57492a2c85c98d.webp"
"MediaSize" => 97911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-b1899ed3b855c992ad57492a2c85c98d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, light-toned walls, and a large window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30000343_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/70a2503a10702c045f3a881d14a1e69a.webp"
"MediaSize" => 106506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-70a2503a10702c045f3a881d14a1e69a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a central island with countertop, dark wood-finish cabinetry, stainless steel appliances, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30000343_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/7cf21a0271a4586420bfac2ae96d9c56.webp"
"MediaSize" => 104749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-7cf21a0271a4586420bfac2ae96d9c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark cabinetry, stainless steel appliances, a breakfast bar, wood-finish flooring, and a tiled backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30000343_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/99bbabada52cac80699b731faac54881.webp"
"MediaSize" => 109342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-99bbabada52cac80699b731faac54881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30000343_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/8b45691a49b58bbaf7796c0e7ca1b720.webp"
"MediaSize" => 90923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-8b45691a49b58bbaf7796c0e7ca1b720.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed ceiling detail, wood-finish flooring, and natural light from a window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30000343_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/0a5ace22ac7597847989a68cfd9e3edf.webp"
"MediaSize" => 93141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-0a5ace22ac7597847989a68cfd9e3edf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring wood-finish flooring, light neutral wall paint, and a window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30000343_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/776c89f825bd20eebdc76040f5269a76.webp"
"MediaSize" => 89838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-776c89f825bd20eebdc76040f5269a76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a window with horizontal blinds, and a neutral wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30000343_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/1ed0fde0f931a5a4c23304f8bca8a0a2.webp"
"MediaSize" => 95459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-1ed0fde0f931a5a4c23304f8bca8a0a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring rich wood-finish flooring, a window with blinds, and recessed ceiling lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30000343_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/3c0baf07c2a04ecf6ce46e043360c32b.webp"
"MediaSize" => 78151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-3c0baf07c2a04ecf6ce46e043360c32b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed shower with pebble-style flooring and tiled walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30000343_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/80812508d31d939f18e66ac7f1d7d529.webp"
"MediaSize" => 92817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-80812508d31d939f18e66ac7f1d7d529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a dark wood-finish vanity with a light countertop, an undermount sink, and a large wall-mounted mirror with overhead vanity lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30000343_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/8b40296d02b532a972a4d7269bcc745e.webp"
"MediaSize" => 94599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-8b40296d02b532a972a4d7269bcc745e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with wood-finish flooring, a white paneled door, and a window with white blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30000343_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/56a950a18817aba6919ae8fb4011971f.webp"
"MediaSize" => 97656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-56a950a18817aba6919ae8fb4011971f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, white baseboards, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30000343_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/aac323c3552cb2ff2e7f048c32d325cf.webp"
"MediaSize" => 116018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-aac323c3552cb2ff2e7f048c32d325cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring wood-finish flooring, a window with blinds, and white interior doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30000343_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/8e04d54a04b4fc3697f8917d34dd2ecc.webp"
"MediaSize" => 80977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-8e04d54a04b4fc3697f8917d34dd2ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a dark wood-finish vanity with a light countertop, an integrated sink, and a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30000343_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/c2398655a6d2e93dc13a897b7b988184.webp"
"MediaSize" => 110507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-c2398655a6d2e93dc13a897b7b988184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white shower-over-tub combination with a chrome showerhead, a neutral-toned countertop with an integrated sink, and square floor tiles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30000343_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/5e7d4c855a54f0743555144b10fb2520.webp"
"MediaSize" => 46277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-5e7d4c855a54f0743555144b10fb2520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry closet featuring a white stacked washer and dryer unit, tiled flooring, and a louvered bi-fold door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30000343_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/b609c03bfe971f3c55b5be1bda45667b.webp"
"MediaSize" => 182704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-b609c03bfe971f3c55b5be1bda45667b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Concrete patio with a stone facade, featuring a metal privacy screen and a lush green landscape beyond"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30000343_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/c88c9fb0856ef78e47c49a38c478da82.webp"
"MediaSize" => 221326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-c88c9fb0856ef78e47c49a38c478da82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30000343_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000343/73d9655989f699927e765ae705c8bc6d.webp"
"MediaSize" => 203640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000343/thumbnail-73d9655989f699927e765ae705c8bc6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor grilling station featuring two built-in gas grills within stone-clad surrounds, covered by a permanent awning"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846027"
"ResourceRecordKey" => "30000343"
"ModificationTimestamp" => "2026-07-07T17:48:31.37Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000343')"
+"ID": "1600663"
}
]
+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 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+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 2050676" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24850
+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 '30000343'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30000343'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25243
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30000343' 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.598166 43.4707566)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25296
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1597698"
+post_author: 1
+"ListingKey": "29996080"
+"ListingId": "40843001"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T21:55:25Z"
+"RFModificationTimestamp": "2026-07-06T22:46:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2060.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L1"
+"UnparsedAddress": "365 BENNINGTON Gate Unit# 13, Waterloo, Ontario N2T2L1"
+"Coordinates": array:2 [
0 => -80.5756102
1 => 43.4640096
]
+"Latitude": 43.4640096
+"Longitude": -80.5756102
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional living in prestigious Waterloo Upper Beechwood community with this spacious 2+1 bedroom, 3.5 bathroom townhome condo. $2450 plus hydro & gas. With a flexible move in date, available now or extending as late as September 1, 2026.\u{A0} Offering 1,500 sq ft of well-appointed living space, plus an additional 512 sq ft in the finished basement, this home combines style, functionality, and quiet living. The bright and open-concept main level features an eat-in kitchen, dining area, and a comfortable living space; perfect for family gatherings and entertaining. The upper level includes a generous primary bedroom with an en-suite bathroom and ample closet space, bonus living area for a home office or family room, along with a second bedroom and full bath. The finished basement offers endless possibilities, featuring a versatile layout ideal for an additional bedroom, a home gym, or a recreational room - complete with a 3-piece bathroom for added convenience. With an attached garage, a cozy backyard for outdoor relaxation, and access to a complex pool, this home provides everything you need for a balanced lifestyle. Situated in the desirable Upper Beechwood community, you'll enjoy the charm of this well-established neighborhood, with nearby parks, schools, shopping, and easy access to Waterloo's amenities. This townhome is perfect for families, professionals, and down-sizers seeking comfort, convenience, and community living. Don't miss your chance to make this sought-after address your new home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T22:46:56.193345+00:00"
+"Directions": "Columbia St. W. to Bennington Gate"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T21:18:40Z"
+"PhotosCount": 20
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T21:48:39Z"
+"Stories": "2.0"
+"StreetName": "BENNINGTON"
+"StreetNumber": "365"
+"StreetSuffix": "Gate"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1676907964"
"RoomType" => "Laundry room"
"ListingId" => "40843001"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
1 => array:11 [
"RoomKey" => "1676907965"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843001"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
2 => array:11 [
"RoomKey" => "1676907966"
"RoomType" => "Bedroom"
"ListingId" => "40843001"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
3 => array:11 [
"RoomKey" => "1676907967"
"RoomType" => "Recreation room"
"ListingId" => "40843001"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
4 => array:11 [
"RoomKey" => "1676907968"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843001"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
5 => array:11 [
"RoomKey" => "1676907969"
"RoomType" => "Bedroom"
"ListingId" => "40843001"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
6 => array:11 [
"RoomKey" => "1676907970"
"RoomType" => "Full bathroom"
"ListingId" => "40843001"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.54Z"
]
7 => array:11 [
"RoomKey" => "1676907971"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843001"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
8 => array:11 [
"RoomKey" => "1676907972"
"RoomType" => "Family room"
"ListingId" => "40843001"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
9 => array:11 [
"RoomKey" => "1676907973"
"RoomType" => "Dinette"
"ListingId" => "40843001"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
10 => array:11 [
"RoomKey" => "1676907974"
"RoomType" => "Kitchen"
"ListingId" => "40843001"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
11 => array:11 [
"RoomKey" => "1676907975"
"RoomType" => "Living room"
"ListingId" => "40843001"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
12 => array:11 [
"RoomKey" => "1676907976"
"RoomType" => "Dining room"
"ListingId" => "40843001"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
13 => array:11 [
"RoomKey" => "1676907977"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843001"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29996080"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-06T21:48:39.55Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29996080/365-bennington-gate-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1548
+"BelowGradeFinishedArea": 512
+"OriginalEntryTimestamp": "2026-07-06T21:18:40.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29996080_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/f4fa642cf65964636604cdb6a33c5c75.webp"
"MediaSize" => 126324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-f4fa642cf65964636604cdb6a33c5c75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior featuring light grey brick and horizontal siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29996080_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/7bd5219877d70d535ac86b7164cd63fd.webp"
"MediaSize" => 110748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-7bd5219877d70d535ac86b7164cd63fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level townhome featuring a brick and siding exterior, an attached garage, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29996080_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/52eef474e6e5b5e1fe47a8a079ce8e71.webp"
"MediaSize" => 45712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-52eef474e6e5b5e1fe47a8a079ce8e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative glass, sidelights, and white tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29996080_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/0f85a0407bc6db25bd31908bf8d43f76.webp"
"MediaSize" => 42183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-0f85a0407bc6db25bd31908bf8d43f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White vanity with an integrated sink and matte black faucet, illuminated by a four-light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29996080_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/684cceea5248f7c566a35f990f07f5ca.webp"
"MediaSize" => 49666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-684cceea5248f7c566a35f990f07f5ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring wood-finish flooring, white cabinetry with wood-tone knobs, quartz countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29996080_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/fd63a4a21aba8febf4948f51b8bd0a3f.webp"
"MediaSize" => 45224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-fd63a4a21aba8febf4948f51b8bd0a3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29996080_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/e2242854a200c266bc0a4919bf594e2c.webp"
"MediaSize" => 51737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-e2242854a200c266bc0a4919bf594e2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29996080_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/6ca3e34118ca43367d9ab2502d7e0eb8.webp"
"MediaSize" => 50395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-6ca3e34118ca43367d9ab2502d7e0eb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29996080_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/916d5ace8a0ea554c157e1ef327fbacb.webp"
"MediaSize" => 55581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-916d5ace8a0ea554c157e1ef327fbacb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with a ceiling fan light fixture, window with roller shade, and two wall-mounted floating shelves"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29996080_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/54c02e6eaf949d625d05c789b102236a.webp"
"MediaSize" => 59511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-54c02e6eaf949d625d05c789b102236a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white countertop and rectangular sink, black faucet, and white cabinetry with black hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29996080_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/859c06846e58a413a8ff890910b4561d.webp"
"MediaSize" => 75915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-859c06846e58a413a8ff890910b4561d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room with light-colored carpeting, white baseboards, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29996080_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/c35b492ce4316d9cf53cdadcef294c76.webp"
"MediaSize" => 48244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-c35b492ce4316d9cf53cdadcef294c76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light wood-finish flooring and paneling on the walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29996080_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/17da154930212f0ef6fa37b6ad9f742e.webp"
"MediaSize" => 127635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-17da154930212f0ef6fa37b6ad9f742e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a brick and siding facade, private wooden deck, sliding glass door access, ground-level patio door, and fenced perimeter"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29996080_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/f8cd75ed39eb6c810d51bdb9c3a74fac.webp"
"MediaSize" => 206685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-f8cd75ed39eb6c810d51bdb9c3a74fac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private backyard featuring mature trees, a manicured lawn area, and a brick paver patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29996080_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/842e40ea88666b2e437153357317f31b.webp"
"MediaSize" => 232119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-842e40ea88666b2e437153357317f31b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard with mature trees featuring vibrant foliage, a full wooden fence, and a grass area with fallen leaves"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29996080_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/7018ed6027ff921575e72ed3dafda3fc.webp"
"MediaSize" => 177622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-7018ed6027ff921575e72ed3dafda3fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29996080_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/5af7dd415fe1623728bfdab4185d4d8c.webp"
"MediaSize" => 132278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-5af7dd415fe1623728bfdab4185d4d8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor swimming pool featuring an integrated spa, concrete decking, and an adjacent paver patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29996080_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/18aba3e8997e8803931b969bd042c6be.webp"
"MediaSize" => 45175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-18aba3e8997e8803931b969bd042c6be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29996080_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/a0ae1875bef34fecb20cc33384338cc3.webp"
"MediaSize" => 44917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-a0ae1875bef34fecb20cc33384338cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29996080_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29996080/4c63ae4a3d086126f86d5c6754bb7790.webp"
"MediaSize" => 45168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29996080/thumbnail-4c63ae4a3d086126f86d5c6754bb7790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843001"
"ResourceRecordKey" => "29996080"
"ModificationTimestamp" => "2026-07-06T21:18:40.43Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29996080')"
+"ID": "1597698"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1592160"
+post_author: 1
+"ListingKey": "29988324"
+"ListingId": "40845172"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T20:20:07Z"
+"RFModificationTimestamp": "2026-07-06T20:33:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 773.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E9"
+"UnparsedAddress": "244 LADYSLIPPER Drive Unit# LOWER, Waterloo, Ontario N2V0E9"
+"Coordinates": array:2 [
0 => -80.5918946
1 => 43.455862
]
+"Latitude": 43.455862
+"Longitude": -80.5918946
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into modern living with this professionally finished (2025) 2-bedroom, 1-bathroom home. The stylish kitchen features beautiful cabinetry, elegant quartz countertops, abundant storage, stainless steel appliances, and a sleek over-the-range microwave. The spacious layout is filled with natural light thanks to large windows throughout, while window coverings (curtains) are included for added comfort and privacy. Durable subflooring has been installed throughout the unit, adding to its quality and longevity. Enjoy the convenience of a private garage with remote control access, plus even more storage space to keep everything organized. Located in a fantastic area of Waterloo, this home offers incredible convenience. You're just 5 minutes from Costco and other essential amenities. Enjoy added privacy with no backyard neighbours, and families will appreciate being just steps from great schools. Bright, stylish, and move-in ready, this is the perfect place to call home. Bonus: A 2% discount is available for tenants (terms and conditions apply). (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T00:51:14.027472+00:00"
+"Directions": "Columbia St W / Ladyslipper Dr"
+"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": "2190750"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T20:12:26Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T20:12:26Z"
+"Stories": "2.0"
+"StreetName": "LADYSLIPPER"
+"StreetNumber": "244"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1675111973"
"RoomType" => "Laundry room"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
1 => array:11 [
"RoomKey" => "1675111974"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
2 => array:11 [
"RoomKey" => "1675111975"
"RoomType" => "Bedroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
3 => array:11 [
"RoomKey" => "1675111976"
"RoomType" => "Bedroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
4 => array:11 [
"RoomKey" => "1675111977"
"RoomType" => "Kitchen"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29988324/244-ladyslipper-drive-unit-lower-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2050
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 773
+"OriginalEntryTimestamp": "2026-07-03T23:48:10.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1439796"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29988324_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/73042eb13d058bda0a9c47c12b451e32.webp"
"MediaSize" => 106980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-73042eb13d058bda0a9c47c12b451e32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29988324_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/a903382e180043c5d9f38362de321aed.webp"
"MediaSize" => 98693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-a903382e180043c5d9f38362de321aed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29988324_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/199ed73cb75b59ed6519a2103d63b62f.webp"
"MediaSize" => 81603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-199ed73cb75b59ed6519a2103d63b62f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29988324_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/462da95e8e3b8dcd7477fc9ff772c3f1.webp"
"MediaSize" => 92905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-462da95e8e3b8dcd7477fc9ff772c3f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29988324_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/01dbb17dd2a16ecfe57ef63231e03a93.webp"
"MediaSize" => 75104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-01dbb17dd2a16ecfe57ef63231e03a93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29988324_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/deba504d4a83869cde757c50a5aff0a1.webp"
"MediaSize" => 72721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-deba504d4a83869cde757c50a5aff0a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29988324_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/b6c7a132b2f8def1af70a7a786e988b9.webp"
"MediaSize" => 38871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-b6c7a132b2f8def1af70a7a786e988b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29988324_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/0f6002cc66e56685eaec647bbbe418cf.webp"
"MediaSize" => 43327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-0f6002cc66e56685eaec647bbbe418cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29988324_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/44aadbceead6bcb8605a4b922e8ceb01.webp"
"MediaSize" => 55669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-44aadbceead6bcb8605a4b922e8ceb01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29988324_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/2193100a55eafc53f7fe6b7398e20d11.webp"
"MediaSize" => 72078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-2193100a55eafc53f7fe6b7398e20d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29988324_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/388dcc90561acb74eed6d75a7a172c0d.webp"
"MediaSize" => 61116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-388dcc90561acb74eed6d75a7a172c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged image for reference"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
11 => array:13 [
"Order" => 13
"MediaKey" => "29988324_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/48b65708c1e12e4e1375322e0b800e84.webp"
"MediaSize" => 98769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-48b65708c1e12e4e1375322e0b800e84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
12 => array:13 [
"Order" => 14
"MediaKey" => "29988324_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/0c8d4006f97d6c1ecb848e80f9dac70f.webp"
"MediaSize" => 150558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-0c8d4006f97d6c1ecb848e80f9dac70f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
13 => array:13 [
"Order" => 15
"MediaKey" => "29988324_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/b006be16b7e010501def17b94671ea6c.webp"
"MediaSize" => 145071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-b006be16b7e010501def17b94671ea6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
14 => array:13 [
"Order" => 16
"MediaKey" => "29988324_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/da314725cb7494bf57d7476a487e03d9.webp"
"MediaSize" => 97145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-da314725cb7494bf57d7476a487e03d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
15 => array:13 [
"Order" => 17
"MediaKey" => "29988324_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/5ac06702a39a3769d3a3836406ec8c30.webp"
"MediaSize" => 36069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-5ac06702a39a3769d3a3836406ec8c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
16 => array:13 [
"Order" => 12
"MediaKey" => "29988324_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/70e54d1c187fc1b571719eb9c952762c.webp"
"MediaSize" => 65961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-70e54d1c187fc1b571719eb9c952762c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged image for reference"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-06T20:12:21.44Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988324')"
+"ID": "1592160"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1590612"
+post_author: 1
+"ListingKey": "29986609"
+"ListingId": "40844971"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5958568
1 => 43.4558155
]
+"Latitude": 43.4558155
+"Longitude": -80.5958568
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:46.776818+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:18Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:18Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1674342393"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
1 => array:11 [
"RoomKey" => "1674342394"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
2 => array:11 [
"RoomKey" => "1674342395"
"RoomType" => "Bedroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
3 => array:11 [
"RoomKey" => "1674342396"
…10
]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986609/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-03T19:18:18.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986609')"
+"ID": "1590612"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1587689"
+post_author: 1
+"ListingKey": "29982467"
+"ListingId": "40844834"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T23:20:15Z"
+"RFModificationTimestamp": "2026-07-03T01:13:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1630.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "449 AVENS Street, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.5965975
1 => 43.4539702
]
+"Latitude": 43.4539702
+"Longitude": -80.5965975
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Very well maintained 1.5 Car garage semi-detached home in desirable Vista Hill neighborhood. 3 bedroom and 3 bathroom, open concept on main floor, spacious kitchen with stainless steel appliances, laminate flooring and tile through the main floor. 3 good size bedrooms upstairs. Primary bedroom with ensuite and walk-in closet. Close to great schools, Universities, YMCA, Costco and Shopping. Fully fenced with NO backyard neighbors, shows AAA! Rent + Utilities, at least 1 Year Lease, Landlord prefers family living there. Good credit and employee letters are required, available August 16,2026! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:31.590566+00:00"
+"Directions": "Sundew to Wild Calla, left on Avens"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932404"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:16Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T23:10:16Z"
+"Stories": "2.0"
+"StreetName": "AVENS"
+"StreetNumber": "449"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5213.44"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982467/449-avens-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R6-S"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1630
+"OriginalEntryTimestamp": "2026-07-02T23:10:16.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1232736"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982467')"
+"ID": "1587689"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1587849"
+post_author: 1
+"ListingKey": "29981674"
+"ListingId": "40844758"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:40:22Z"
+"RFModificationTimestamp": "2026-07-02T22:53:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2230.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T4"
+"UnparsedAddress": "470 TREMBLING ASPEN Avenue, Waterloo, Ontario N2T2T4"
+"Coordinates": array:2 [
0 => -80.5933136
1 => 43.4688595
]
+"Latitude": 43.4688595
+"Longitude": -80.5933136
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 470 Trembling Aspen Home! Very clean and very well maintained 4 bedrooms, 4 bathrooms, Finished Walk-Out Basement, Carpet Free family home located in the most desirable Laurelwood area. Open concept on the main floor; Spacious kitchen with a lot of cabinet storage. Large living room and dining area. Walk out to a big deck. Second floor comes with 4 good size bedrooms and the primary bedroom with En-suite; Newer roof, newer furnace and newer Fridge. Big deck; Jacuzzi in the 2nd floor bathroom. Few minutes walking to the top-rated schools in the region - Abraham Erb P.S. and Laurel Heights Secondary School. Close to Universities, YMCA, Costco and Shopping. Shows AAA! Rent + Utilities, at least 1 Year Lease, Landlord prefers family living there. Good credit and employee letters are required, available Sep. 1st, 2026. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:53:42.177193+00:00"
+"Directions": "Laurelwood/ Wild Ginger"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932404"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:32:52Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:32:52Z"
+"Stories": "2.0"
+"StreetName": "TREMBLING ASPEN"
+"StreetNumber": "470"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4929.54"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29981674/470-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1710
+"BelowGradeFinishedArea": 520
+"OriginalEntryTimestamp": "2026-07-02T21:32:52.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232736"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981674')"
+"ID": "1587849"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1587850"
+post_author: 1
+"ListingKey": "29981415"
+"ListingId": "X13515188"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T12:20:12Z"
+"RFModificationTimestamp": "2026-07-07T19:50:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful corner-unit townhouse for lease in the sought-after Laurelwood neighbourhood! Enjoy maintenance-free living with lawn care and snow removal (driveway & sidewalk) included. This bright and spacious home features a flexible floor plan with 3 separate living areas, soaring cathedral ceilings, a sun-filled living room, a main-floor bedroom and full bathroom, a dedicated home office, and a large basement offering abundant storage and additional living space. Conveniently located near top-rated schools, Laurel Creek Conservation Area, parks, walking trails, the University of Waterloo, shopping, Costco, the Boardwalk, public transit, and all major amenities. Ideal for families, professionals, or those working from home. Move-in ready! (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Range"
3 => "Garage door opener remote(s)"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T21:45:15.663204+00:00"
+"Directions": "Erbsville rd/Laurelwood dr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T20:56:11Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T12:08:52Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981415/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-02T20:56:11.67Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981415')"
+"ID": "1587850"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1587851"
+post_author: 1
+"ListingKey": "29980985"
+"ListingId": "X13514978"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T20:05:08Z"
+"RFModificationTimestamp": "2026-07-02T20:42:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L1"
+"UnparsedAddress": "MAIN - 668A BUTTERNUT AVENUE, Waterloo, Ontario N2V2L1"
+"Coordinates": array:2 [
0 => -80.586562
1 => 43.465505
]
+"Latitude": 43.465505
+"Longitude": -80.586562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful freehold semi-detached home available for lease starting May 1. This well-maintained property offers abundant natural sunlight throughout the day, creating a bright and welcoming living space. Enjoy a private deck, perfect for relaxing or entertaining outdoors. The upper-level tenant will be responsible for 70% of the total utilities. The home also includes two designated parking spaces for added convenience. (id:62650)"
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T20:25:48.834355+00:00"
+"Directions": "Columbia Forest Blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906649"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:56:16Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:56:16Z"
+"Stories": "2.0"
+"StreetName": "Butternut"
+"StreetNumber": "668A"
+"StreetSuffix": "Avenue"
+"Utilities": array:1 [
0 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980985/main-668a-butternut-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2550
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-02T19:56:16.26Z"
+"ListAgentNationalAssociationId": "1220268"
+"ListOfficeNationalAssociationId": "1201577"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980985')"
+"ID": "1587851"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1585671"
+post_author: 1
+"ListingKey": "29980546"
+"ListingId": "40844747"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:20:02Z"
+"RFModificationTimestamp": "2026-07-02T19:36:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1560.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L1"
+"UnparsedAddress": "668A BUTTERNUT Avenue Unit# Main, Waterloo, Ontario N2V2L1"
+"Coordinates": array:2 [
0 => -80.5866181
1 => 43.4654843
]
+"Latitude": 43.4654843
+"Longitude": -80.5866181
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful freehold semi-detached home available for lease starting May 1. This well-maintained property offers abundant natural sunlight throughout the day, creating a bright and welcoming living space. Enjoy a private deck, perfect for relaxing or entertaining outdoors. The upper-level tenant will be responsible for 70% of the total utilities. The home also includes two designated parking spaces for added convenience. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:36:27.386587+00:00"
+"Directions": "Columbia Forest Blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224068"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:12:22Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:12:22Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "668"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3027"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980546/668a-butternut-avenue-unit-main-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2550
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 98.0
+"AboveGradeFinishedArea": 1560
+"OriginalEntryTimestamp": "2026-07-02T19:11:05.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1467479"
+"ListOfficeNationalAssociationId": "1379702"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980546')"
+"ID": "1585671"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1584439"
+post_author: 1
+"ListingKey": "29978059"
+"ListingId": "40844566"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:20:11Z"
+"RFModificationTimestamp": "2026-07-02T17:17:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1457.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "982 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5994372
1 => 43.471525
]
+"Latitude": 43.471525
+"Longitude": -80.5994372
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Well maintained FREEHOLD townhome in Laurel Creek Village! 3 Bedrooms /3 Baths with gorgeous open-concept design. GRAND 2-storey foyer. Carpet free flooring ON MAIN FLOOR & UPSTAIRS , HUGE Master with LARGE walk-in closet, sliders off of kitchen to Fully Fenced yard. All appliances included. FULLY FINISHED BASEMENT with KITCHENETTE and 3-piece bath ! Prime Waterloo School District . newer fridge ,newer washer and newer AC. Shows AAA, don't miss this one!! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:16:58.162083+00:00"
+"Directions": "ERBSVILLE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564082"
+"ListOfficeKey": "222711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:11:14Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:11:14Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "982"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978059/982-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2875
+"ZoningDescription": "50-R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1457
+"OriginalEntryTimestamp": "2026-07-02T15:11:14.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1130381"
+"ListOfficeNationalAssociationId": "1197443"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978059')"
+"ID": "1584439"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 18
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]