array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28843316 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23526
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23528
+post_id: "719276"
+post_author: 1
+"ListingKey": "28843316"
+"ListingId": "40768049"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:35:37Z"
+"RFModificationTimestamp": "2026-06-02T18:13:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.78
+"LivingArea": 610.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H3"
+"UnparsedAddress": "580 COLDSTREAM Drive Unit# 312, Waterloo, Ontario N2V2H3"
+"Coordinates": array:2 [
0 => -80.57404146
1 => 43.49298417
]
+"Latitude": 43.49298417
+"Longitude": -80.57404146
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 580 Coldstream Drive, A perfect blend of modern living and natural beauty in one of Waterloo's most peaceful residential communities. Backing onto the breathtaking Laurel Creek Conservation Area, this brand-new rental residence offers direct access to scenic trails and endless outdoor activities right at your doorstep. Inside, each thoughtfully crafted suite features a complete stainless steel appliance package (LG & Samsung), sleek quartz countertops and backsplash, durable vinyl plank flooring, in-suite laundry, and stylish gold-accented finishes. Residents will enjoy two elegant 3-piece tiled bathrooms, spacious walk-in closets, a water softener system, and secure Brivo smart access for peace of mind. The community also offers premium on-site amenities, including a fully equipped fitness centre and a modern co-working space designed to complement today's lifestyle. Occupancy begins September 2025. Don't miss this opportunity to live steps from nature while enjoying the best of Waterloo's conveniences. High speed Internet included. Parking is $100 PM (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Exterior Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-09-10T22:03:16.253221+00:00"
+"Directions": "Coldstream Dr & Conservation Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092787"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.78"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-09-23T13:19:17Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T17:03:10Z"
+"Stories": "1.0"
+"StreetName": "COLDSTREAM"
+"StreetNumber": "580"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"VirtualTourURLUnbranded": "https://youriguide.com/2_580_coldstream_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1649958172"
"RoomType" => "3pc Bathroom"
"ListingId" => "40768049"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28843316"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:03:10.06Z"
]
1 => array:11 [
"RoomKey" => "1649958173"
"RoomType" => "Den"
"ListingId" => "40768049"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28843316"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:03:10.06Z"
]
2 => array:11 [
"RoomKey" => "1649958174"
"RoomType" => "3pc Bathroom"
"ListingId" => "40768049"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28843316"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:03:10.07Z"
]
3 => array:11 [
"RoomKey" => "1649958175"
"RoomType" => "Bedroom"
"ListingId" => "40768049"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28843316"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:03:10.07Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28843316/580-coldstream-drive-unit-312-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2141441"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2109542"
+"CoListOfficeKey": "289615"
+"GeocodeManualYN": true
+"TotalActualRent": 2495
+"CoListOfficeKey2": "288733"
+"ZoningDescription": "C3-10"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 147.0
+"AboveGradeFinishedArea": 610
+"OriginalEntryTimestamp": "2025-09-10T18:19:35.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1365329"
+"ListOfficeNationalAssociationId": "1386847"
+"CoListAgentNationalAssociationId": "1393129"
+"CoListAgentNationalAssociationId2": "1378310"
+"CoListOfficeNationalAssociationId": "1379545"
+"CoListOfficeNationalAssociationId2": "1371169"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "28843316_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/509c563d12ea5cf3f3ef783c34e99d5c.webp"
"MediaSize" => 80298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-509c563d12ea5cf3f3ef783c34e99d5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood finished floors and baseboards"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "28843316_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/844463046ebfc5d2b59ce9260f41b907.webp"
"MediaSize" => 51247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-844463046ebfc5d2b59ce9260f41b907.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring tile walls, vanity, a shower stall, a textured ceiling, and a wainscoted wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "28843316_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/a7fa28017ff85af49708296611be79cd.webp"
"MediaSize" => 76326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-a7fa28017ff85af49708296611be79cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.07Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "28843316_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/0074ec1dd3a95582870afd59a9a8c782.webp"
"MediaSize" => 50727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-0074ec1dd3a95582870afd59a9a8c782.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, light countertops, a textured ceiling, dark wood-style floors, and open floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6193745008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/1851521ee73e74d158de1c5875b029ea.webp"
"MediaSize" => 80298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-1851521ee73e74d158de1c5875b029ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood finished floors and baseboards"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.05Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "28843316_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/91a43d3a909b88b48d82f9e2c10f3a87.webp"
"MediaSize" => 53482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-91a43d3a909b88b48d82f9e2c10f3a87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a textured ceiling and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "28843316_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/ddeb6de967764bcc7c6ed22bebd6533e.webp"
"MediaSize" => 83831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-ddeb6de967764bcc7c6ed22bebd6533e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.07Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "28843316_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/c9060a5cd5dde5601671478f4988532d.webp"
"MediaSize" => 104511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-c9060a5cd5dde5601671478f4988532d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex with covered parking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "28843316_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/97409814482e2a730415bb16c3566293.webp"
"MediaSize" => 96782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-97409814482e2a730415bb16c3566293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property featuring covered parking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.07Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "28843316_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/91c6bbb87c3cbc7d02fc698418427986.webp"
"MediaSize" => 62146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-91c6bbb87c3cbc7d02fc698418427986.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring vanity, a stall shower, and tile walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.07Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "28843316_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/4b8c528ba9c2761057d609e4295a7237.webp"
"MediaSize" => 56631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-4b8c528ba9c2761057d609e4295a7237.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with appliances with stainless steel finishes, dark wood finished floors, recessed lighting, and modern cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "28843316_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/ba7839eeb5e2423c205364731ffdaee3.webp"
"MediaSize" => 73481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-ba7839eeb5e2423c205364731ffdaee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring stainless steel appliances, backsplash, light stone counters, and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "28843316_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/a12b68c6206c2dab6bf1ab0c68e30d82.webp"
"MediaSize" => 72561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-a12b68c6206c2dab6bf1ab0c68e30d82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring stainless steel appliances, dark wood-style flooring, decorative backsplash, light stone countertops, and modern cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "28843316_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/033760b079fab96c7f1945ee759a4b9f.webp"
"MediaSize" => 51943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-033760b079fab96c7f1945ee759a4b9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with dark wood-style floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "28843316_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/f46ba21afe1e302d15cc8f2ac4025adf.webp"
"MediaSize" => 48527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-f46ba21afe1e302d15cc8f2ac4025adf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room featuring baseboards and dark wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.08Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "28843316_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/acb6fff2e6940b8059ecffb1541e4816.webp"
"MediaSize" => 48131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-acb6fff2e6940b8059ecffb1541e4816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom featuring dark wood-style flooring and connected bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "28843316_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28843316/a269d5fcc4b76458c930b839004dd4fd.webp"
"MediaSize" => 68043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28843316/thumbnail-a269d5fcc4b76458c930b839004dd4fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, a stall shower, and tile walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40768049"
"ResourceRecordKey" => "28843316"
"ModificationTimestamp" => "2025-09-23T13:11:51.07Z"
]
]
+"DaysOnMarket": 314
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28843316')"
+"ID": "719276"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290392" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24979
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24883
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "EXP REALTY"
+"OfficeEmail": null
+"OfficePhone": "866-530-7737"
+"OfficeMlsId": "KW362"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290392"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "7-871 Victoria Street North Unit: 355"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2B3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1386847"
+"OriginalEntryTimestamp": "2021-05-12T18:25:00Z"
+"OfficeFax": "647-849-3180"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "11517"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290392"
"SocialMediaUrlOrId" => "https://exprealty.ca/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1406847"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290392')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2092787" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24939
+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 '28843316'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25312
+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 '28843316' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25328
+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 '28843316' 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.57404146 43.49298417)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25401
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25395
+post_id: "1641660"
+post_author: 1
+"ListingKey": "30055584"
+"ListingId": "X13583926"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T16:50:13Z"
+"RFModificationTimestamp": "2026-07-20T17:04:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Z6"
+"UnparsedAddress": "402 LAKEVIEW DRIVE, Waterloo, Ontario N2L4Z6"
+"Coordinates": array:2 [
0 => -80.566851
1 => 43.487317
]
+"Latitude": 43.487317
+"Longitude": -80.566851
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 402 Lakeview Drive, a stunning home nestled in the highly coveted Lakeshore neighbourhood of Waterloo. Beautifully upgraded and completely move-in ready, this exceptional 3+1 bedroom raised bungalow offers an elevated living. Set on a premium lot with no rear neighbours, this property delivers rare privacy and a peaceful setting. Step inside the bright, open-concept living spaces, enhanced by newly installed pot lights and stylish designer fixtures. The expansive living and dining areas are ideal for both everyday living and elegant entertaining. Fully renovated kitchen (2026) shines with brand-new stainless steel appliances contemporary finishes and abundant space for hosting and gathering with loved ones. Every detail has been thoughtfully updated, including beautifully renovated bathrooms, a new furnace and air conditioning system and carpet-free flooring that flows throughout the entire home. The main level features 3 generously sized bedrooms, each filled with natural light, along with a tastefully updated bathroom. The fully finished walkout basement, featuring an additional bedroom, a modern 3pc bathroom and a large recreation room with direct access to a bright, inviting sunroom. The basement reveals an additional bedroom, offering even more accommodation options, whether for guests, a home office, or a hobby room. Nestled in a tranquil yet accessible area, 402 Lakeview benefits from its proximity to all essential amenities, including shopping centers, schools, parks, and public transit, making your daily commutes and errands effortless and convenient. This property seamlessly blends style, functionality, and thoughtful design, creating a harmonious living environment that you'll be proud to call home. Don't miss the opportunity, Book your private showing today. PLEASE NOTE: The owners intend to keep one bedroom in the basement for their personal use. However, it can be made available to the tenants upon request. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T17:04:48.050032+00:00"
+"Directions": "Cross Streets: Northfield Dr W. ** Directions: Pineridge Road To Lakeview Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T16:40:12Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T16:40:12Z"
+"Stories": "1.0"
+"StreetName": "Lakeview"
+"StreetNumber": "402"
+"StreetSuffix": "Drive"
+"VirtualTourURLUnbranded": "https://youriguide.com/402_lakeview_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1689341571"
"RoomType" => "Bedroom"
"ListingId" => "X13583926"
"RoomLevel" => "Basement"
"RoomWidth" => 3.76
"ListingKey" => "30055584"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
1 => array:11 [
"RoomKey" => "1689341572"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "30055584"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
2 => array:11 [
"RoomKey" => "1689341573"
"RoomType" => "Bathroom"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 1.4
"ListingKey" => "30055584"
"RoomLength" => 2.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
3 => array:11 [
"RoomKey" => "1689341574"
"RoomType" => "Bathroom"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 2.1
"ListingKey" => "30055584"
"RoomLength" => 2.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
4 => array:11 [
"RoomKey" => "1689341575"
"RoomType" => "Kitchen"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "30055584"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
5 => array:11 [
"RoomKey" => "1689341576"
"RoomType" => "Bedroom"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "30055584"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
6 => array:11 [
"RoomKey" => "1689341577"
"RoomType" => "Bedroom"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "30055584"
"RoomLength" => 2.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.49Z"
]
7 => array:11 [
"RoomKey" => "1689341578"
"RoomType" => "Dining room"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 3.17
"ListingKey" => "30055584"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.5Z"
]
8 => array:11 [
"RoomKey" => "1689341579"
"RoomType" => "Living room"
"ListingId" => "X13583926"
"RoomLevel" => "Main level"
"RoomWidth" => 3.17
"ListingKey" => "30055584"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T16:40:12.5Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30055584/402-lakeview-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-20T16:40:12.47Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30055584_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/80cc52c942ce702787a810d94762cd85.webp"
"MediaSize" => 374173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-80cc52c942ce702787a810d94762cd85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30055584_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/6ab29e777a82c7274fa4494537d13102.webp"
"MediaSize" => 286262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-6ab29e777a82c7274fa4494537d13102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30055584_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/90f67e12c7592da84782b1f4935d323e.webp"
"MediaSize" => 200609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-90f67e12c7592da84782b1f4935d323e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30055584_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/77543a2edcb54e8f79ec1ef0eafb9eb4.webp"
"MediaSize" => 150186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-77543a2edcb54e8f79ec1ef0eafb9eb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30055584_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/93507b633f4d8ce10b6b668ba3edbdbd.webp"
"MediaSize" => 131869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-93507b633f4d8ce10b6b668ba3edbdbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30055584_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/1f1d5df69b4aeee706a869bc3ab4ccb1.webp"
"MediaSize" => 127563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-1f1d5df69b4aeee706a869bc3ab4ccb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30055584_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/7f4d6250f70dbb40fc03599d02f407d5.webp"
"MediaSize" => 170043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-7f4d6250f70dbb40fc03599d02f407d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30055584_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/a24cf9832ab9598442a01d518d939ff2.webp"
"MediaSize" => 141709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-a24cf9832ab9598442a01d518d939ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30055584_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/9482ba43e65a36da748dbd7f2937701c.webp"
"MediaSize" => 126153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-9482ba43e65a36da748dbd7f2937701c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30055584_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/6ac2a839b395c310eb19b418b28eb565.webp"
"MediaSize" => 175933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-6ac2a839b395c310eb19b418b28eb565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30055584_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/2731e4fe358a4fd8a25c91359572be41.webp"
"MediaSize" => 159861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-2731e4fe358a4fd8a25c91359572be41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30055584_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/b0be35c394cc1f1f84d67eb258ff9e30.webp"
"MediaSize" => 72305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-b0be35c394cc1f1f84d67eb258ff9e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30055584_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/ef7215f0e91aa18cb2999daeeb0b8ada.webp"
"MediaSize" => 121358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-ef7215f0e91aa18cb2999daeeb0b8ada.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30055584_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/0de241695d52c370868f0fb287f6c259.webp"
"MediaSize" => 110535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-0de241695d52c370868f0fb287f6c259.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30055584_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/fbf03e3da6bc5ad9d0b4a60ac498ba7b.webp"
"MediaSize" => 107325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-fbf03e3da6bc5ad9d0b4a60ac498ba7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30055584_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/adcfda3dcda605a712a25d52341fad3a.webp"
"MediaSize" => 126346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-adcfda3dcda605a712a25d52341fad3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30055584_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/0ef703aae0975fb70bd5888b3403703e.webp"
"MediaSize" => 116930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-0ef703aae0975fb70bd5888b3403703e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30055584_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/e0a0b5e1b8ffdbec2d8b9cef0de57279.webp"
"MediaSize" => 109666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-e0a0b5e1b8ffdbec2d8b9cef0de57279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30055584_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/e02347341f2316a1a656c35d42172947.webp"
"MediaSize" => 113592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-e02347341f2316a1a656c35d42172947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30055584_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/68a133934a7c601d5c8400c8e571a5bc.webp"
"MediaSize" => 119706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-68a133934a7c601d5c8400c8e571a5bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30055584_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/3151ee5aad4999d5093e1792776d2617.webp"
"MediaSize" => 116413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-3151ee5aad4999d5093e1792776d2617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30055584_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/202255021734333b12b26236587b7c12.webp"
"MediaSize" => 123570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-202255021734333b12b26236587b7c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30055584_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/a6e19c7d3510461dbdb1283eebe836d2.webp"
"MediaSize" => 111799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-a6e19c7d3510461dbdb1283eebe836d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30055584_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/36d2c1a6c6c54b4cdf7e36cab74acd18.webp"
"MediaSize" => 128250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-36d2c1a6c6c54b4cdf7e36cab74acd18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30055584_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/0f028117f6f884820edcc2e00ddb1ced.webp"
"MediaSize" => 121856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-0f028117f6f884820edcc2e00ddb1ced.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30055584_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/9577f9a4acc40da3fc9b9d0918803e87.webp"
"MediaSize" => 154896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-9577f9a4acc40da3fc9b9d0918803e87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30055584_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/c4c0608798d7b87a9f43a9354dc8c136.webp"
"MediaSize" => 143048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-c4c0608798d7b87a9f43a9354dc8c136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30055584_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/b55a7bc2885483bfad12b705c62a5a15.webp"
"MediaSize" => 198102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-b55a7bc2885483bfad12b705c62a5a15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30055584_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/7124b3cd7973a3ada05d14a0c98f1be4.webp"
"MediaSize" => 203342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-7124b3cd7973a3ada05d14a0c98f1be4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30055584_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/7567a126d9e1ac57285fdc4163ddc09c.webp"
"MediaSize" => 156383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-7567a126d9e1ac57285fdc4163ddc09c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30055584_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/a2dece1193440e08346ee242974ecd7e.webp"
"MediaSize" => 262428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-a2dece1193440e08346ee242974ecd7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30055584_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/cbf0beccb47dc286746dedecdd69fc70.webp"
"MediaSize" => 333306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-cbf0beccb47dc286746dedecdd69fc70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30055584_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/2e9175db3422d461afe5a2575d773acb.webp"
"MediaSize" => 319952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-2e9175db3422d461afe5a2575d773acb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30055584_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/162dd18d84abcfd1516a46e481d7241e.webp"
"MediaSize" => 427778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-162dd18d84abcfd1516a46e481d7241e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30055584_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/f25d6418c63334a8294229478f785951.webp"
"MediaSize" => 460824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-f25d6418c63334a8294229478f785951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30055584_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/0693cc2f51dc4571efde092aea204a91.webp"
"MediaSize" => 413706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-0693cc2f51dc4571efde092aea204a91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30055584_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/ca04a7ef766a52683dc99ff452088d2c.webp"
"MediaSize" => 509423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-ca04a7ef766a52683dc99ff452088d2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30055584_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/e3eef50334e5cf9c889122b0405ac4a9.webp"
"MediaSize" => 431623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-e3eef50334e5cf9c889122b0405ac4a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30055584_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/24c3063378356b8f333342611240a7c3.webp"
"MediaSize" => 389660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-24c3063378356b8f333342611240a7c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30055584_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/8927a9c7eb801bdddd3a83472fa45c33.webp"
"MediaSize" => 350172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-8927a9c7eb801bdddd3a83472fa45c33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30055584_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/687caaa88a04dd079ac188676d89d73e.webp"
"MediaSize" => 389413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-687caaa88a04dd079ac188676d89d73e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30055584_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/10384337a5b4e39597932d31a619db5e.webp"
"MediaSize" => 383671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-10384337a5b4e39597932d31a619db5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30055584_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/bb98e5971971d48a237db54c61a7351a.webp"
"MediaSize" => 417644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-bb98e5971971d48a237db54c61a7351a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30055584_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/0b92420cd7b7f827e5e00ebb67b77c7c.webp"
"MediaSize" => 376878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-0b92420cd7b7f827e5e00ebb67b77c7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30055584_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/2e7b8bfb8f327773ab97734559632c0d.webp"
"MediaSize" => 332685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-2e7b8bfb8f327773ab97734559632c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30055584_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/416185d908dc5d45ffb5fb199f9d4952.webp"
"MediaSize" => 116364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-416185d908dc5d45ffb5fb199f9d4952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30055584_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055584/cdf0f85b8d126a1026b2956eb66cf333.webp"
"MediaSize" => 108369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055584/thumbnail-cdf0f85b8d126a1026b2956eb66cf333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13583926"
"ResourceRecordKey" => "30055584"
"ModificationTimestamp" => "2026-07-20T16:40:12.48Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055584')"
+"ID": "1641660"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+post_id: "1641734"
+post_author: 1
+"ListingKey": "30055223"
+"ListingId": "40848895"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T16:05:19Z"
+"RFModificationTimestamp": "2026-07-20T16:41:36Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Z6"
+"UnparsedAddress": "402 LAKEVIEW Drive, Waterloo, Ontario N2L4Z6"
+"Coordinates": array:2 [
0 => -80.5668567
1 => 43.4873256
]
+"Latitude": 43.4873256
+"Longitude": -80.5668567
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 402 Lakeview Drive, a stunning home nestled in the highly coveted Lakeshore neighbourhood of Waterloo. Beautifully upgraded and completely move-in ready, this exceptional 3+1 bedroom raised bungalow offers an elevated living. Set on a premium lot with no rear neighbours, this property delivers rare privacy and a peaceful setting. Step inside the bright, open-concept living spaces, enhanced by newly installed pot lights and stylish designer fixtures. The expansive living and dining areas are ideal for both everyday living and elegant entertaining. Fully renovated kitchen (2026) shines with brand-new stainless steel appliances contemporary finishes and abundant space for hosting and gathering with loved ones. Every detail has been thoughtfully updated, including beautifully renovated bathrooms, a new furnace and air conditioning system and carpet-free flooring that flows throughout the entire home. The main level features 3 generously sized bedrooms, each filled with natural light, along with a tastefully updated bathroom. The fully finished walkout basement, featuring an additional bedroom, a modern 3pc bathroom and a large recreation room with direct access to a bright, inviting sunroom. The basement reveals an additional bedroom, offering even more accommodation options, whether for guests, a home office, or a hobby room. Nestled in a tranquil yet accessible area, 402 Lakeview benefits from its proximity to all essential amenities, including shopping centers, schools, parks, and public transit, making your daily commutes and errands effortless and convenient. This property seamlessly blends style, functionality, and thoughtful design, creating a harmonious living environment that you'll be proud to call home. Don't miss the opportunity, Book your private showing today. PLEASE NOTE: The owners intend to keep one bedroom in the basement for their personal use. However, it can be made available to the tenants upon request. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T16:41:24.002223+00:00"
+"Directions": "Pineridge Road To Lakeview Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T15:59:53Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T15:59:53Z"
+"StreetName": "LAKEVIEW"
+"StreetNumber": "402"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"VirtualTourURLUnbranded": "https://youriguide.com/402_lakeview_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1689313371"
"RoomType" => "Laundry room"
"ListingId" => "40848895"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.58Z"
]
1 => array:11 [
"RoomKey" => "1689313372"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848895"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.58Z"
]
2 => array:11 [
"RoomKey" => "1689313373"
"RoomType" => "Sunroom"
"ListingId" => "40848895"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
3 => array:11 [
"RoomKey" => "1689313374"
"RoomType" => "Recreation room"
"ListingId" => "40848895"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 20'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
4 => array:11 [
"RoomKey" => "1689313375"
"RoomType" => "Bedroom"
"ListingId" => "40848895"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
5 => array:11 [
"RoomKey" => "1689313376"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
6 => array:11 [
"RoomKey" => "1689313377"
"RoomType" => "Bedroom"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
7 => array:11 [
"RoomKey" => "1689313378"
"RoomType" => "Bedroom"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
8 => array:11 [
"RoomKey" => "1689313379"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
9 => array:11 [
"RoomKey" => "1689313380"
"RoomType" => "Dining room"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
10 => array:11 [
"RoomKey" => "1689313381"
"RoomType" => "Kitchen"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
11 => array:11 [
"RoomKey" => "1689313382"
"RoomType" => "Living room"
"ListingId" => "40848895"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055223"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T15:59:53.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30055223/402-lakeview-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-20T15:59:53.56Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055223')"
+"ID": "1641734"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25394
+post_id: "1639115"
+post_author: 1
+"ListingKey": "30050767"
+"ListingId": "X13579240"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T22:45:07Z"
+"RFModificationTimestamp": "2026-07-18T01:09:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R5"
+"UnparsedAddress": "555 GRASSLANDS COURT, Waterloo, Ontario N2V2R5"
+"Coordinates": array:2 [
0 => -80.577839
1 => 43.491753
]
+"Latitude": 43.491753
+"Longitude": -80.577839
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 555 Grasslands Court, Waterloo, a bright and spacious freehold townhouse located in the highly desirable Lakeshore North neighbourhood. Nestled on a quiet cul-de-sac and backing directly onto Laurel Creek Conservation Area, this beautifully maintained home offers the perfect blend of privacy, natural beauty, and modern convenience. Featuring 3 bedrooms, 4 bathrooms (2 full bathrooms and 2 powder rooms), and approximately 1,600 sq. ft. of living space, this home also boasts a fully finished basement, an open-concept layout filled with natural light, an ensuite washer and dryer, and a private fenced backyard with breathtaking conservation views and no rear neighbours. Enjoy direct access to walking trails, parks, and outdoor recreation, while remaining just minutes from the University of Waterloo, Wilfrid Laurier University, top-rated schools, shopping, restaurants, public transit, and Highway 85. Additional features include 2 parking spaces (1 attached garage and 1 driveway), with all appliances included. Tenants are responsible for 100% of utilities (Electricity: Enova Electricity, Gas: Enbridge, Water: City of Waterloo; Hot Water Tank included). Available immediately for $3,100/month, this exceptional home offers a rare opportunity to enjoy peaceful conservation-area living while staying connected to everything Waterloo has to offer. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T01:09:50.669211+00:00"
+"Directions": "Conservation Drive and Westmount Road North"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152390"
+"ListOfficeKey": "295056"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T22:38:39Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T22:38:39Z"
+"Stories": "2.0"
+"StreetName": "Grasslands"
+"StreetNumber": "555"
+"StreetSuffix": "Court"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30050767/555-grasslands-court-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-17T22:38:39.8Z"
+"ListAgentNationalAssociationId": "1404084"
+"ListOfficeNationalAssociationId": "1445789"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050767')"
+"ID": "1639115"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25398
+post_id: "1613882"
+post_author: 1
+"ListingKey": "30016219"
+"ListingId": "40846428"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T13:55:02Z"
+"RFModificationTimestamp": "2026-07-10T17:42:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 545.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1C3"
+"UnparsedAddress": "101 GOLDEN EAGLE Road Unit# 506, Waterloo, Ontario N2V1C3"
+"Coordinates": array:2 [
0 => -80.5515582
1 => 43.4982912
]
+"Latitude": 43.4982912
+"Longitude": -80.5515582
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ONE MONTH FREE RENT! Experience modern living at The Jake Condos in Waterloo’s sought-after Lakeshore neighbourhood. This thoughtfully designed 1-bedroom, 1-bath suite offers 545 sq. ft. of stylish, functional living space featuring an open-concept layout, modern kitchen with island seating, in-suite laundry, and a private balcony. Perfect for first-time buyers, students, young professionals, or investors. Ideally located close to transit, the LRT, shopping, restaurants, parks, and everyday amenities, with quick access to the University of Waterloo, Wilfrid Laurier University, Conestoga College, Conestoga Mall, and St. Jacobs Farmers’ Market. Residents also enjoy premium building amenities including a fitness centre, rooftop terrace, lounge, and secure bike storage. A fantastic opportunity to enjoy convenient urban living in one of Waterloo’s fastest-growing communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:41:37.659317+00:00"
+"Directions": "Weber St N. & Northfield Dr W."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145306"
+"ListOfficeKey": "292479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-10T13:48:26Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T13:48:26Z"
+"Stories": "5.0"
+"StreetName": "GOLDEN EAGLE"
+"StreetNumber": "101"
+"StreetSuffix": "Road"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"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/30016219/101-golden-eagle-road-unit-506-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1825
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 545
+"OriginalEntryTimestamp": "2026-07-10T13:48:26.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1396659"
+"ListOfficeNationalAssociationId": "1412478"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30016219')"
+"ID": "1613882"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25396
+post_id: "1609081"
+post_author: 1
+"ListingKey": "30010201"
+"ListingId": "X13542040"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:15:08Z"
+"RFModificationTimestamp": "2026-07-09T17:37:50Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4M3"
+"UnparsedAddress": "LOWER - 275 TOLL GATE BOULEVARD, Waterloo, Ontario N2L4M3"
+"Coordinates": array:2 [
0 => -80.558604
1 => 43.486464
]
+"Latitude": 43.486464
+"Longitude": -80.558604
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Ottawa Real Estate Board"
+"PublicRemarks": "Looking for the perfect student rental near campus? This bright and partially furnished 3-bedroom detached home(Lower Floor) is located minutes from University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an ideal choice for students and professionals! Each spacious bedroom comes with a double bed frame and a study desk, plus windows for natural sunlight perfect for focused study sessions or relaxing downtime. The furnished kitchen includes a stove, fridge, and microwave, so you're ready to move in and start cooking from day one. Enjoy the convenience of your own private ensuite laundry (washer & dryer). The property is right on the bus route to major destinations including campuses, David Johnston Research & Technology Park, and Northfield Centre with access to Sobeys, Tim Hortons, Shoppers, RBC, Fit4Less, and more. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T17:37:39.459157+00:00"
+"Directions": "Cross Streets: Glen Forrest Blvd and Toll Gate Blvd. ** Directions: From Glen Forrest Blvd turn On Toll Gate Blvd and the house will be on the left side."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168166"
+"ListOfficeKey": "286366"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "54.1 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:05:02Z"
+"PhotosCount": 9
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:05:02Z"
+"StreetName": "Toll Gate"
+"StreetNumber": "275"
+"StreetSuffix": "Boulevard"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Ottawa"
+"ListAORKey": "76"
+"ListingURL": "www.realtor.ca/real-estate/30010201/lower-275-toll-gate-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2200
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.1
+"OriginalEntryTimestamp": "2026-07-09T14:05:02.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1418879"
+"ListOfficeNationalAssociationId": "1360249"
+"Media": array:9 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010201')"
+"ID": "1609081"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1595036"
+post_author: 1
+"ListingKey": "29991373"
+"ListingId": "40845368"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T21:35:09Z"
+"RFModificationTimestamp": "2026-07-05T22:34:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 1766.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4P2"
+"UnparsedAddress": "510 OAKRIDGE Place Unit# LOWER, Waterloo, Ontario N2L4P2"
+"Coordinates": array:2 [
0 => -80.5595113
1 => 43.4889494
]
+"Latitude": 43.4889494
+"Longitude": -80.5595113
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this one, Lower unit with separate entrance, Many updates include new kitchen, floor, electrical panel, plumbing, painting, on demand water heater 2020, furnace and A/C 2020, drive way ashphalt+Stone(2023), garage door, eavestroughs, and fascia. Front porch and fully fenced back yard both new. Close to the Conservation Area, universities, Bus Station, 8 mins bus direct to UW,YMCA GYMS, Library, Walking distance to schools, public transit and shopping .Furnished with two beds included with new memory form mattresses, new appliance, dining sets. Lower unit tenants will share 45% utilities with upper level. One parking spot. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-05T22:34:13.236075+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-05T21:31:49Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T21:31:49Z"
+"Stories": "1.0"
+"StreetName": "OAKRIDGE"
+"StreetNumber": "510"
+"StreetSuffix": "Place"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29991373/510-oakridge-place-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1650
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 929
+"BelowGradeFinishedArea": 837
+"OriginalEntryTimestamp": "2026-07-05T21:29:25.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"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('29991373')"
+"ID": "1595036"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23540
+post_id: "1594048"
+post_author: 1
+"ListingKey": "29990478"
+"ListingId": "40845225"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T00:55:12Z"
+"RFModificationTimestamp": "2026-07-05T01:32:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2150.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4S7"
+"UnparsedAddress": "242 CEDARBRAE Avenue Unit# B, Waterloo, Ontario N2L4S7"
+"Coordinates": array:2 [
0 => -80.5511615
1 => 43.4863408
]
+"Latitude": 43.4863408
+"Longitude": -80.5511615
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AVAILABLE FOR SEPT.1,2026, this conveniently located 2-story semi-detached home offers 3 bedrooms and 2 baths with a fenced-in yard. 2 car parking includes a carport and driveway. Cedarbrae public school and local transit are only steps away. Also conveniently located a short distance to universities. Only minutes away from the expressway and shopping. Conveniences include on-site laundry, 2 sheds, and central air conditioning. (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Full Bath"
]
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-05T01:32:32.491544+00:00"
+"Directions": "Lakeshore/Parkdale"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1969762"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-05T00:48:12Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T00:48:12Z"
+"Stories": "2.0"
+"StreetName": "CEDARBRAE"
+"StreetNumber": "242"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3192"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29990478/242-cedarbrae-avenue-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1100
+"BelowGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-05T00:48:12.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1257702"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29990478')"
+"ID": "1594048"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1579291"
+post_author: 1
+"ListingKey": "29969782"
+"ListingId": "40843787"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T14:10:28Z"
+"RFModificationTimestamp": "2026-06-30T15:42:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 545.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1C3"
+"UnparsedAddress": "101 GOLDEN EAGLE Road Unit# 512, Waterloo, Ontario N2V1C3"
+"Coordinates": array:2 [
0 => -80.5514601
1 => 43.4981253
]
+"Latitude": 43.4981253
+"Longitude": -80.5514601
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ONE MONTH FREE RENT! Experience modern living at The Jake Condos in Waterloo’s sought-after Lakeshore neighbourhood. This thoughtfully designed 1-bedroom, 1-bath suite offers 545 sq. ft. of stylish, functional living space featuring an open-concept layout, modern kitchen with island seating, in-suite laundry, and a private balcony. Perfect for first-time buyers, students, young professionals, or investors. Ideally located close to transit, the LRT, shopping, restaurants, parks, and everyday amenities, with quick access to the University of Waterloo, Wilfrid Laurier University, Conestoga College, Conestoga Mall, and St. Jacobs Farmers’ Market. Residents also enjoy premium building amenities including a fitness centre, rooftop terrace, lounge, and secure bike storage. A fantastic opportunity to enjoy convenient urban living in one of Waterloo’s fastest-growing communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T15:26:03.424594+00:00"
+"Directions": "Weber St N. & Northfield Dr W."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145306"
+"ListOfficeKey": "292479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-30T14:02:18Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T14:02:18Z"
+"Stories": "5.0"
+"StreetName": "GOLDEN EAGLE"
+"StreetNumber": "101"
+"StreetSuffix": "Road"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"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/29969782/101-golden-eagle-road-unit-512-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1825
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 545
+"OriginalEntryTimestamp": "2026-06-30T14:02:18.66Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1396659"
+"ListOfficeNationalAssociationId": "1412478"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969782')"
+"ID": "1579291"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+post_id: "1569955"
+post_author: 1
+"ListingKey": "29956771"
+"ListingId": "X13492270"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T20:30:06Z"
+"RFModificationTimestamp": "2026-06-30T20:31:14Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4K7"
+"UnparsedAddress": "UPPER - 695 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4K7"
+"Coordinates": array:2 [
0 => -80.551299
1 => 43.493392
]
+"Latitude": 43.493392
+"Longitude": -80.551299
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover your new home at 695 Glen Forrest Blvd (Upper) located in one of Waterloo's most sought after neighbourhoods. This well maintained main-level unit features three generously sized bedrooms, a modern four piece bathroom, and a welcoming living and dining area. The unit includes convenient amenities such as in-unit laundry and central air conditioning. Additionally, you'll have the benefit of two designated parking spots. Students welcome! Residents will love the close proximity to a wide range of amenities, including shopping centers, restaurants, Wilfrid Laurier University, The University of Waterloo, Conestoga's Waterloo campus, St.Jacobs Farmers Market, and easy access to Highway 85. Combining comfort with prime location, this home offers an exceptional lifestyle. Please note that all photos were taken prior to the current tenants moving in. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:32:27.132171+00:00"
+"Directions": "Cross Streets: Glen Forrest/Weber St. ** Directions: Turn onto Weber St N from Northfield Drive W and then a right on Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154976"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T12:47:27Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T20:22:58Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "695"
+"StreetSuffix": "Boulevard"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956771/upper-695-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-26T12:47:27.64Z"
+"ListAgentNationalAssociationId": "1406489"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956771')"
+"ID": "1569955"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 21
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]