array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29893337 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1523008"
+post_author: 1
+"ListingKey": "29893337"
+"ListingId": "40839237"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:15:05Z"
+"RFModificationTimestamp": "2026-06-12T05:34:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1976.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "479 TREMBLING ASPEN Avenue, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5932768
1 => 43.4687994
]
+"Latitude": 43.4687994
+"Longitude": -80.5932768
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Available for Lease AUGUST 1 2026 in Waterloo’s Top School District! Situated in one of Waterloo’s most sought-after neighbourhoods, this 3-bedroom, 2-bathroom home is just a 5-minute walk to both elementary and high schools, with easy bus access to local universities. Inside, you’ll find a functional layout with fresh updates throughout: brand-new Berber carpet on the upper level, new luxury vinyl flooring in the bathrooms, fresh paint, and modern pot lighting for a bright, contemporary feel. The open-concept kitchen flows seamlessly into the living and dining areas and is equipped with stainless steel appliances, all updated within the past five years. The upper-level family room impresses with soaring ceilings and plenty of natural light—perfect for an additional lounge or work-from-home space. The professionally landscaped front and backyard feature new sod and low-maintenance design, with a newly added walkway that can double as a second parking spot. The garage also includes a brand-new insulated door. Additional highlights include two separate living areas, an unfinished basement with laundry and rough-in for a future bathroom, and close proximity to shopping, transit, parks, and major roadways for easy commuting. This home is meticulously maintained, pet-free, and ready for its next family! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T05:34:41.323297+00:00"
+"Directions": "From Erbsville Road, turn west onto Laurelwood Drive, then turn left onto Blue Beech Boulevard, and finally turn right onto Trembling Aspen Avenue. The property is on the right-hand side."
+"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": "2091826"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T01:09:50Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:09:49Z"
+"Stories": "2.0"
+"StreetName": "TREMBLING ASPEN"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:1 [
0 => "Telephone"
]
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657487438"
"RoomType" => "Cold room"
"ListingId" => "40839237"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.91Z"
]
1 => array:11 [
"RoomKey" => "1657487439"
"RoomType" => "Laundry room"
"ListingId" => "40839237"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
2 => array:11 [
"RoomKey" => "1657487440"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
3 => array:11 [
"RoomKey" => "1657487441"
"RoomType" => "Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
4 => array:11 [
"RoomKey" => "1657487442"
"RoomType" => "Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
5 => array:11 [
"RoomKey" => "1657487443"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
6 => array:11 [
"RoomKey" => "1657487444"
"RoomType" => "Family room"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
7 => array:11 [
"RoomKey" => "1657487445"
"RoomType" => "Dining room"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
8 => array:11 [
"RoomKey" => "1657487446"
"RoomType" => "Living room"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
9 => array:11 [
"RoomKey" => "1657487447"
"RoomType" => "Kitchen"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
10 => array:11 [
"RoomKey" => "1657487448"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29893337/479-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2950
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1406
+"BelowGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-06-12T01:09:49.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29893337_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/7ac08a78d219809b7a93372cc074d278.webp"
"MediaSize" => 141460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-7ac08a78d219809b7a93372cc074d278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29893337_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/5afa566f243b0f65fdd88a5db2cb0189.webp"
"MediaSize" => 139210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-5afa566f243b0f65fdd88a5db2cb0189.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29893337_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/a0a9e36f25f2097d14127e5e95da4e7d.webp"
"MediaSize" => 158782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-a0a9e36f25f2097d14127e5e95da4e7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29893337_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/16c320386c13e443c9d6f9d3a11050fc.webp"
"MediaSize" => 150455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-16c320386c13e443c9d6f9d3a11050fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29893337_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/690203b120716846a9b77418c3a8faf7.webp"
"MediaSize" => 50849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-690203b120716846a9b77418c3a8faf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29893337_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/8d77c0185b16b7c052a2969639b460c7.webp"
"MediaSize" => 51153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-8d77c0185b16b7c052a2969639b460c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29893337_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/b18a494524a550ef2f81b303bb0e78fe.webp"
"MediaSize" => 89547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-b18a494524a550ef2f81b303bb0e78fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29893337_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/9af405f6f343b07c51d074e3bb906123.webp"
"MediaSize" => 108383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-9af405f6f343b07c51d074e3bb906123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29893337_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/47fce3cb0f981bec69c3ae4db672bd8a.webp"
"MediaSize" => 68415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-47fce3cb0f981bec69c3ae4db672bd8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29893337_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/f9e0faf7bf19f368934d0e9597cd5701.webp"
"MediaSize" => 82609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-f9e0faf7bf19f368934d0e9597cd5701.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29893337_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/583d6594e773f2ea5e1b8f47adb36a3c.webp"
"MediaSize" => 58162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-583d6594e773f2ea5e1b8f47adb36a3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29893337_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/9094e4c196b9034e069008e89fc0e3b8.webp"
"MediaSize" => 52471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-9094e4c196b9034e069008e89fc0e3b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29893337_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/9b42c8d13e6ca685b596f1ef238927fd.webp"
"MediaSize" => 58954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-9b42c8d13e6ca685b596f1ef238927fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29893337_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/b640a05d48090bd9b12ac521be750990.webp"
"MediaSize" => 51358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-b640a05d48090bd9b12ac521be750990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29893337_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/d638d951465a4891da09f0c7632ca06c.webp"
"MediaSize" => 61452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-d638d951465a4891da09f0c7632ca06c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29893337_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/4d97d56b3c92514e4b8c4ebe7b971280.webp"
"MediaSize" => 58282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-4d97d56b3c92514e4b8c4ebe7b971280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29893337_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/8c304b642e964e7bd10b9bc007efcf67.webp"
"MediaSize" => 65806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-8c304b642e964e7bd10b9bc007efcf67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29893337_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/579aaa0a671491cef8ddc995d7e00891.webp"
"MediaSize" => 56201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-579aaa0a671491cef8ddc995d7e00891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29893337_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/8d272e75c19bd1f6fe66ef8356ea2cf1.webp"
"MediaSize" => 69967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-8d272e75c19bd1f6fe66ef8356ea2cf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29893337_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/5ba767a8597167e48673bdcf7d877f8c.webp"
"MediaSize" => 74072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-5ba767a8597167e48673bdcf7d877f8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29893337_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/0703723d95451d35b48dd1ccc5740147.webp"
"MediaSize" => 69871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-0703723d95451d35b48dd1ccc5740147.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29893337_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/952d38f1a41831a80b201f5a7c24a8c6.webp"
"MediaSize" => 43519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-952d38f1a41831a80b201f5a7c24a8c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29893337_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/24619a4d36ce5f25bd166e8411d572b9.webp"
"MediaSize" => 121505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-24619a4d36ce5f25bd166e8411d572b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29893337_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/11b92942c89dc09d45d07ef9d1095e23.webp"
"MediaSize" => 117895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-11b92942c89dc09d45d07ef9d1095e23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29893337_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/704d160203460caa48404e2a7f7187c9.webp"
"MediaSize" => 102366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-704d160203460caa48404e2a7f7187c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29893337_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/61c8a9c8d0d0dbcc8e642bb52893c254.webp"
"MediaSize" => 188051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-61c8a9c8d0d0dbcc8e642bb52893c254.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landlord will consider laying sod"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29893337_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/5bbd979ea272345e8d3a31a1401a9935.webp"
"MediaSize" => 150060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-5bbd979ea272345e8d3a31a1401a9935.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landlord will consider laying sod"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29893337_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/cf4d235f7d521173afa11c5468b5a96f.webp"
"MediaSize" => 193579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-cf4d235f7d521173afa11c5468b5a96f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landlord will consider laying sod"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29893337_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/d6cc57851bb2764563fef175a4456a34.webp"
"MediaSize" => 209310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-d6cc57851bb2764563fef175a4456a34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landlord will consider laying sod"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29893337_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/b0cf4ca2304b285fca82c6f10ea590f8.webp"
"MediaSize" => 199612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29893337/thumbnail-b0cf4ca2304b285fca82c6f10ea590f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landlord will consider laying sod"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839237"
"ResourceRecordKey" => "29893337"
"ModificationTimestamp" => "2026-06-12T01:09:49.83Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893337')"
+"ID": "1523008"
}
]
+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 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24757
+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 2091826" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29893337'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25149
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29893337'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25165
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29893337' 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.5932768 43.4687994)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25218
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1537444"
+post_author: 1
+"ListingKey": "29912396"
+"ListingId": "40839543"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T21:00:09Z"
+"RFModificationTimestamp": "2026-06-16T22:53:28Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3217.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "603 SUNDEW Drive, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5977533
1 => 43.4599617
]
+"Latitude": 43.4599617
+"Longitude": -80.5977533
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 603 Sundew Drive, a beautifully maintained home in the highly desirable Vista Hills community. This impressive 2,267 sq. ft. residence offers the perfect blend of comfort, style, and convenience. The main level features 9-foot ceilings and a bright, open-concept design ideal for both everyday living and entertaining. The spacious great room is highlighted by a cozy fireplace and provides direct access to a large patio overlooking the private natural setting. A convenient main-floor laundry room offers interior access to the double-car garage. Upstairs, the generous primary suite serves as a relaxing retreat, complete with a walk-in closet and a luxurious 5-piece ensuite. Two additional well-sized bedrooms and a full main bathroom complete the upper level. The finished basement adds valuable living space, featuring a large recreation room, an additional bedroom, and a 3-piece bathroom—perfect for guests, a home office, or growing families. Outside, professionally landscaped grounds enhance the home's curb appeal and outdoor enjoyment. Ideally located close to shopping at Costco and The Boardwalk, medical facilities, parks, and public transit, with a short 12-minute bus ride to the universities. Families will also appreciate the proximity to Vista Hills Public School, making this an exceptional place to call home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:53:21.978725+00:00"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060436"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:51:17Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:51:17Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "603"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6768"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1660731641"
"RoomType" => "Living room"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "23'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.42Z"
]
1 => array:11 [
"RoomKey" => "1660731642"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.42Z"
]
2 => array:11 [
"RoomKey" => "1660731643"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.43Z"
]
3 => array:11 [
"RoomKey" => "1660731644"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.43Z"
]
4 => array:11 [
"RoomKey" => "1660731645"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.44Z"
]
5 => array:11 [
"RoomKey" => "1660731646"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.44Z"
]
6 => array:11 [
"RoomKey" => "1660731647"
"RoomType" => "Full bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
7 => array:11 [
"RoomKey" => "1660731648"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
8 => array:11 [
"RoomKey" => "1660731649"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
9 => array:11 [
"RoomKey" => "1660731650"
"RoomType" => "Family room"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.46Z"
]
10 => array:11 [
"RoomKey" => "1660731651"
"RoomType" => "Eat in kitchen"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.46Z"
]
11 => array:11 [
"RoomKey" => "1660731652"
"RoomType" => "Living room"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.47Z"
]
12 => array:11 [
"RoomKey" => "1660731653"
"RoomType" => "Dining room"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912396/603-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2267
+"BelowGradeFinishedArea": 950
+"OriginalEntryTimestamp": "2026-06-16T20:51:17.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1335580"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912396_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/75568de8f926db79fd86878aada42862.webp"
"MediaSize" => 130605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-75568de8f926db79fd86878aada42862.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912396_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/184451c7e76a3fb4f52c377b4c07b060.webp"
"MediaSize" => 90750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-184451c7e76a3fb4f52c377b4c07b060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912396_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/d1f1041167779e5d0dde4a09b2092499.webp"
"MediaSize" => 89373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-d1f1041167779e5d0dde4a09b2092499.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912396_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/52d7dea02779ed8fa4b04c9bd30d96c7.webp"
"MediaSize" => 111319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-52d7dea02779ed8fa4b04c9bd30d96c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912396_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/a816d89795cec162680fe5700324acf2.webp"
"MediaSize" => 89796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-a816d89795cec162680fe5700324acf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912396_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/9ab8c96c2aed34e812319a37e8498131.webp"
"MediaSize" => 101583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-9ab8c96c2aed34e812319a37e8498131.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912396_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/bea51a49439d9c2e444c8fa7a1b1fb3d.webp"
"MediaSize" => 64477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-bea51a49439d9c2e444c8fa7a1b1fb3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912396_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/f307b815bf4fb4a31d12164e5ea8e4e4.webp"
"MediaSize" => 109060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-f307b815bf4fb4a31d12164e5ea8e4e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912396_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/2226814acd502705bfc4cca466c243d2.webp"
"MediaSize" => 139723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-2226814acd502705bfc4cca466c243d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912396_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/22b4f23f9ad48487ed5f70771f4628f0.webp"
"MediaSize" => 123966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-22b4f23f9ad48487ed5f70771f4628f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912396_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/bfe272c9f40b1891f9636e0246b39d85.webp"
"MediaSize" => 96045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-bfe272c9f40b1891f9636e0246b39d85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912396_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/1f0cd7015ab8b4b0f13fc399e0f60c7b.webp"
"MediaSize" => 109647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-1f0cd7015ab8b4b0f13fc399e0f60c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912396_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/5ac2a4c45245eb38505d0091b61707c7.webp"
"MediaSize" => 104764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-5ac2a4c45245eb38505d0091b61707c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912396_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/4911bb1c5fa3aef49da2f7a1bddc8904.webp"
"MediaSize" => 128367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-4911bb1c5fa3aef49da2f7a1bddc8904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912396_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/9da67e9981c66327a5dfc7dbdf2693b9.webp"
"MediaSize" => 81965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-9da67e9981c66327a5dfc7dbdf2693b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912396_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/fb59ea074a2ad0ab4668ff4533846209.webp"
"MediaSize" => 68847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-fb59ea074a2ad0ab4668ff4533846209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912396_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/fcd8470117daa9ffbca1ad92ad0a9ba2.webp"
"MediaSize" => 95299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-fcd8470117daa9ffbca1ad92ad0a9ba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912396_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/538f6bb8dacb6d5c2e0bc9cf59fce019.webp"
"MediaSize" => 74621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-538f6bb8dacb6d5c2e0bc9cf59fce019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912396_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/98c1aa4b9c29e169b6d80bd62d49f0ec.webp"
"MediaSize" => 84266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-98c1aa4b9c29e169b6d80bd62d49f0ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912396_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/374d90684fbe5d96b1899d46c1fbc28b.webp"
"MediaSize" => 108213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-374d90684fbe5d96b1899d46c1fbc28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912396_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/c482d4917f216dcbee74b69708f90039.webp"
"MediaSize" => 132676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-c482d4917f216dcbee74b69708f90039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912396')"
+"ID": "1537444"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1532832"
+post_author: 1
+"ListingKey": "29907351"
+"ListingId": "X13448166"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:25:03Z"
+"RFModificationTimestamp": "2026-06-16T14:25:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "437 SPECKLED ALDER STREET, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.594098
1 => 43.468816
]
+"Latitude": 43.468816
+"Longitude": -80.594098
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well Maintained 3 Bedroom House, Open Concept Kitchen With Large Breakfast Area. Large Master Bedroom, Walking Distance To Schools. Close To Park And All Other Amenities. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:44:46.016698+00:00"
+"Directions": "Erbsville Rd/Laurewood Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948797"
+"ListOfficeKey": "51127"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "33.1 x 82 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T22:48:00Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:19:55Z"
+"Stories": "2.0"
+"StreetName": "Speckled Alder"
+"StreetNumber": "437"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29907351/437-speckled-alder-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1569377"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "51127"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 33.1
+"OriginalEntryTimestamp": "2026-06-15T22:48:00.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1243317"
+"ListOfficeNationalAssociationId": "1003215"
+"CoListAgentNationalAssociationId": "1150697"
+"CoListOfficeNationalAssociationId": "1003215"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907351_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/fe91422d20bcb6cb8f61450823278725.webp"
"MediaSize" => 206465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-fe91422d20bcb6cb8f61450823278725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907351_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/8458e69f55c15e201c1d3abc79e5e6f2.webp"
"MediaSize" => 119812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-8458e69f55c15e201c1d3abc79e5e6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907351_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/afbbac0c25c22fc7963b7938bceec0fa.webp"
"MediaSize" => 123431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-afbbac0c25c22fc7963b7938bceec0fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907351_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/f10baf54748663b05ce219af2186b9b7.webp"
"MediaSize" => 58205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-f10baf54748663b05ce219af2186b9b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907351_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/dead3799f9d66e13c8b7b2d6844f9828.webp"
"MediaSize" => 125867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-dead3799f9d66e13c8b7b2d6844f9828.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907351_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/e335a79c963a97c22c7f06bbcd204b7c.webp"
"MediaSize" => 135842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-e335a79c963a97c22c7f06bbcd204b7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907351_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/780186d2c989373bef46ba9139df6cc2.webp"
"MediaSize" => 111115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-780186d2c989373bef46ba9139df6cc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907351_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/34b518d5ac3521a9794687f0a9a45658.webp"
"MediaSize" => 102736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-34b518d5ac3521a9794687f0a9a45658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907351_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/951fc206b9f93d506c83e7c8c4208fe7.webp"
"MediaSize" => 75944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-951fc206b9f93d506c83e7c8c4208fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907351_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/7c47f4c8045039c29b185ddd00e1b83e.webp"
"MediaSize" => 79447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-7c47f4c8045039c29b185ddd00e1b83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907351_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/99ba3b67ea3ee28e9c187241642c70d6.webp"
"MediaSize" => 66781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-99ba3b67ea3ee28e9c187241642c70d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29907351_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/dc03aa6d0a84687f413abd3bcd6e55bb.webp"
"MediaSize" => 58070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-dc03aa6d0a84687f413abd3bcd6e55bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
12 => array:13 [
"Order" => 13
…12
]
13 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907351')"
+"ID": "1532832"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1528796"
+post_author: 1
+"ListingKey": "29901337"
+"ListingId": "40838911"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:15:06Z"
+"RFModificationTimestamp": "2026-06-14T18:15:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1855.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2S6"
+"UnparsedAddress": "388 LAUREL GATE Drive, Waterloo, Ontario N2T2S6"
+"Coordinates": array:2 [
0 => -80.5713913
1 => 43.4724344
]
+"Latitude": 43.4724344
+"Longitude": -80.5713913
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Newly Renovated Townhome in the Heart of Laurelwood! Located in the desirable Erbsville/Laurelwood area of Waterloo, this townhome with a fully finished basement is perfect for families or professionals seeking convenience and comfort. Featuring 3+1 bedrooms, 3 bathrooms, and a fenced backyard with a deck, this home truly has it all. The primary bedroom offers double closets and a cheater ensuite, while the convenient door from the garage to the backyard makes maintenance a breeze. Enjoy proximity to top-rated schools, shopping centers, the scenic Laurelwood Conservation Area, and public transit. This property combines privacy, practicality, and an unbeatable location. Don’t miss out on this prime rental opportunity. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T07:25:44.489990+00:00"
+"Directions": "Fischer Hallman/Laurelwood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Recreational"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-14T03:00:53Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T18:09:55Z"
+"Stories": "2.0"
+"StreetName": "LAUREL GATE"
+"StreetNumber": "388"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4038"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29901337/388-laurel-gate-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1257
+"BelowGradeFinishedArea": 598
+"OriginalEntryTimestamp": "2026-06-14T03:00:53.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901337')"
+"ID": "1528796"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1528775"
+post_author: 1
+"ListingKey": "29901403"
+"ListingId": "40839617"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T04:50:12Z"
+"RFModificationTimestamp": "2026-06-16T04:52:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 710, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5994963
1 => 43.4707058
]
+"Latitude": 43.4707058
+"Longitude": -80.5994963
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning two bedrooms, two full baths with unobstructed views and beautiful sunsets, luxurious kitchen; a chef's dream, with plenty of cabinets for the gourmet cook, an oversized island for your entertainment and family gatherings. Located in the desirable Clair Hills, close to schools, trails, nature, and shopping. The building has a party room that can be used to host the bigger crowd, a lounge and media room, all can be booked free of charge. A big locker 7x5x7 and one surface parking space are included. More parking can be rented if needed. Don't wait, it is available Aug 1. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T05:47:11.767617+00:00"
+"Directions": "ERBSVILLE TO LAURELWOOD"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087196"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-14T04:31:39Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T04:31:51Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29901403/778-laurelwood-drive-unit-710-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2550
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RM100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-06-14T04:31:39.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1360531"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901403')"
+"ID": "1528775"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1519777"
+post_author: 1
+"ListingKey": "29889657"
+"ListingId": "40836552"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:35:26Z"
+"RFModificationTimestamp": "2026-06-15T17:59:41Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3460.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C4"
+"UnparsedAddress": "757 PASTURE ROSE Street, Waterloo, Ontario N2V0C4"
+"Coordinates": array:2 [
0 => -80.6014022
1 => 43.4612875
]
+"Latitude": 43.4612875
+"Longitude": -80.6014022
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "FOR RENT ** Welcome to 757 PASTURE ROSE ST, an exceptional, CARPET-FREE detached home available for lease in the highly desirable VISTA HILLS community of Waterloo West. This 5-BEDROOM & 4.5 BATH residence spans an impressive 3,400+ sq. ft of finished living space (2,760 above grade + 700 in the basement), perfectly blending executive luxury with everyday family functionality. The bright, open-concept main floor boasts 9-foot ceilings, a spacious living room with California shutters and a cozy fireplace, a double-sink kitchen with a Butler’s pantry + Walk-In pantry, Powder Room and a breakfast room that walks out to the backyard. Upstairs, you will find 4 large bedrooms and 3 bathrooms—including a primary bedroom with a wall-to-wall walk-in closet and private ensuite—along side a highly convenient UPPER-LEVEL LAUNDRY ROOM. The FULLY FINISHED BASEMENT adds excellent auxiliary space, featuring a massive 30-foot recreation room, an additional guest/in-law bedroom, and a full 3-piece bathroom. Outfitted with durable luxury vinyl and tile flooring throughout, this home is incredibly practical for active families and pet considerations. Outdoor living is a breeze on the large, welcoming deck within the FULLY-FENCED LARGE BACKYARD, complete with an included BBQ and patio set. Parking is effortless with a 2-car garage and a double-wide driveway accommodating a total of 4-VEHICLES PARKING. Close to top-rated schools & universities, parks, trails, Costco, Cinemas and Medical clinics, this home is ideal for corporate relocations or families seeking a move-in ready property with great landlords. Tenants pay 100% utilities and water heater rental (approx. $50/month). Applicants must provide a rental application, government ID, employment letter, 3 recent pay stubs, references, a valid Equifax credit report, a $100 key deposit, and tenant liability insurance. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"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-06-11T18:18:08.204276+00:00"
+"Directions": "Take Columbia St W toward Vista Hills, turn onto Sundew Dr. towards the end. Take a left to Rock Elm, then 2nd right onto Pasture Rose St."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130641"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:11:18Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:11:18Z"
+"Stories": "2.0"
+"StreetName": "PASTURE ROSE"
+"StreetNumber": "757"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8092"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889657/757-pasture-rose-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 4600
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 2760
+"BelowGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-11T16:51:47.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1383481"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889657')"
+"ID": "1519777"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1518442"
+post_author: 1
+"ListingKey": "29886681"
+"ListingId": "X13429250"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T13:25:10Z"
+"RFModificationTimestamp": "2026-06-11T13:28:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "445 AVENS STREET, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.596467
1 => 43.453819
]
+"Latitude": 43.453819
+"Longitude": -80.596467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "445 Avens Street is a rare offering in the heart of Vista Hills-an address that captures the essence of modern Waterloo living with confidence, style, and undeniable potential. Thoughtfully designed and effortlessly livable, this residence balances clean architectural lines with warm, inviting spaces that feel as good as they look. Natural light pours through the home, animating every corner and enhancing a layout created for both connection and quiet retreat. The main level unfolds with ease-an open, contemporary setting where daily life and entertaining exist in perfect harmony. At its centre, a refined kitchen anchors the space, equal parts function and design, ready to host everything from casual mornings to unforgettable evenings. Above, three well-appointed bedrooms offers comfort without compromise. The primary suite is a calm and elevated escape, complete with its own ensuite and walk-in closet-a space designed to recharge and reset. Beyond the interiors, the home continues to impress. Set against a quiet residential backdrop, the outdoor space offers a sense of calm rarely found at this price point-an everyday luxury that enhances how the home is lived and experienced. The lower level remains untouched-a canvas of opportunity, inviting future owners to expand, create, and add lasting value. Positioned just moments from The Boardwalk, Costco Wholesale, and the academic and cultural energy of University of Waterloo and Wilfrid Laurier University, this is a location defined by convenience, growth, and community. This is more than a home-it's a smart, stylish foothold in one of Waterloo's most desirable neighbourhoods. A place to grow, invest, and thrive.445 Avens Street is not just an opportunity. It's a move forward. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:12:13.275388+00:00"
+"Directions": "SUNDEW DR / WILD CALLA ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197711"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "28.7 x 119.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T01:12:52Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T13:16:18Z"
+"Stories": "2.0"
+"StreetName": "Avens"
+"StreetNumber": "445"
+"StreetSuffix": "Street"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886681/445-avens-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.8
+"OriginalEntryTimestamp": "2026-06-11T01:12:52.65Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1446160"
+"ListOfficeNationalAssociationId": "1316438"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886681')"
+"ID": "1518442"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1481265"
+post_author: 1
+"ListingKey": "29835119"
+"ListingId": "X13223564"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T19:26:02Z"
+"RFModificationTimestamp": "2026-06-01T20:31:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B8"
+"UnparsedAddress": "BSMNT - 400 WILDCALLA STREET, Waterloo, Ontario N2V0B8"
+"Coordinates": array:2 [
0 => -80.595386
1 => 43.452648
]
+"Latitude": 43.452648
+"Longitude": -80.595386
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning, Bright & Spacious 1-Bedroom Basement Apartment in Vista Hills!? Welcome to your next home! This newer, premium basement apartment is located in the highly prestigious and desirable Vista Hills community. Built to impress, this unit offers exceptional living space that is much larger than your expectations. Key Features: Spacious Open-Concept: Seamless flow between the massive living area and the kitchen, perfect for relaxing or entertaining. Modern Kitchen: Equipped with 1-year brand-new appliances and sleek finishes. Sun-Drenched Rooms: Large windows and a layout designed to maximize natural light. Premium Lighting: Packed with elegant pot lights throughout for a warm, bright ambiance. Separate Entrance: Private and secure entry accessible directly from the backyard. Convenience & Storage: Dedicated laundry room and ample storage space. Rental Details: Rent: Monthly Rent + 30%Utilities (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T20:31:41.375747+00:00"
+"Directions": "ERBSVILLE/COLUMBIA ST"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994479"
+"ListOfficeKey": "290183"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T19:17:17Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T19:17:17Z"
+"StreetName": "Wildcalla"
+"StreetNumber": "400"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29835119/bsmnt-400-wildcalla-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1600
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-01T19:17:17.65Z"
+"ListAgentNationalAssociationId": "1277525"
+"ListOfficeNationalAssociationId": "1384540"
+"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": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29835119')"
+"ID": "1481265"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1480760"
+post_author: 1
+"ListingKey": "29834774"
+"ListingId": "40835228"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:45:39Z"
+"RFModificationTimestamp": "2026-06-09T23:56:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 785.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "400 WILD CALLA Street Unit# Basement, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.5953803
1 => 43.4526724
]
+"Latitude": 43.4526724
+"Longitude": -80.5953803
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning, Bright & Spacious 1-Bedroom Basement Apartment in Vista Hills! ?Welcome to your next home! This newer, premium basement apartment is located in the highly prestigious and desirable Vista Hills community. Built to impress, this unit offers exceptional living space that is much larger than your expectations. Key Features: Spacious Open-Concept: Seamless flow between the massive living area and the kitchen, perfect for relaxing or entertaining.Modern Kitchen: Equipped with 1-year brand-new appliances and sleek finishes.Sun-Drenched Rooms: Large windows and a layout designed to maximize natural light. Premium Lighting: Packed with elegant potlights throughout for a warm, bright ambiance.Separate Entrance: Private and secure entry accessible directly from the backyard.Convenience & Storage: Dedicated laundry room and ample storage space.Rental Details:Rent: Monthly Rent + 30% Utilities (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T19:50:28.593488+00:00"
+"Directions": "COLUMBIA/ERBSVILLE"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2064883"
+"ListOfficeKey": "284215"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-01T18:51:02Z"
+"PhotosCount": 15
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:39:40Z"
+"Stories": "2.0"
+"StreetName": "WILD CALLA"
+"StreetNumber": "400"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29834774/400-wild-calla-street-unit-basement-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1600
+"ZoningDescription": "R6-S"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 785
+"OriginalEntryTimestamp": "2026-06-01T18:51:01.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1340178"
+"ListOfficeNationalAssociationId": "1339715"
+"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": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29834774')"
+"ID": "1480760"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1472850"
+post_author: 1
+"ListingKey": "29822723"
+"ListingId": "X13212046"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T13:55:34Z"
+"RFModificationTimestamp": "2026-06-08T13:59:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N9"
+"UnparsedAddress": "7 - 360 CORNRIDGE PLACE, Waterloo, Ontario N2T2N9"
+"Coordinates": array:2 [
0 => -80.57714
1 => 43.460212
]
+"Latitude": 43.460212
+"Longitude": -80.57714
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained town home located in upper Beechwood community, backing to ravine green space and trail. This house featuring 3 bed rooms, 2 bathroom with finished basement for additional space (recreation room/office, laundry room, 3PC washroom, in-law potential). Upgraded kitchen has extended cabinetry for more storage, Quartz Countertops, Stainless Steel Appliances. Freshly Painted, fully fenced yard, quiet friendly neighborhood. Attached garage and one additional parking space in drive way. Situated in prime Waterloo Location a) Near the University of Waterloo, b) Close to top-rated schools, c) Public transit, Gym, Theater, lake trails and all amenities d) Popular shopping destinations (Costco, Sobeys, Canadian Tire, and more), e) The boardwalk. Ideal for families, professionals, or students. Ready to move in (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "345"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T05:19:10.353588+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Columbia St. ** Directions: Erbsville Rd and Cornridge place intersection, take left in Cornridge place."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167766"
+"ListOfficeKey": "300443"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T04:45:32Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T13:45:33Z"
+"Stories": "2.0"
+"StreetName": "Cornridge"
+"StreetNumber": "360"
+"StreetSuffix": "Place"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29822723/7-360-cornridge-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-29T04:45:32.3Z"
+"ListAgentNationalAssociationId": "1418479"
+"ListOfficeNationalAssociationId": "1487969"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29822723')"
+"ID": "1472850"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]