array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30051724 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23511
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23513
+post_id: "1639484"
+post_author: 1
+"ListingKey": "30051724"
+"ListingId": "40843773"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T13:55:19Z"
+"RFModificationTimestamp": "2026-07-18T16:48:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N3V0J1"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 22, Waterloo, Ontario N3V0J1"
+"Coordinates": array:2 [
0 => -80.5899368
1 => 43.4496854
]
+"Latitude": 43.4496854
+"Longitude": -80.5899368
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "2-Year-New Condo Townhome for Lease in Vista Hills, Waterloo Bright and modern 1,300 sq. ft. condo townhome with quartz counters, stainless steel appliances, elegant flooring, and quality upgrades throughout. Features 2 spacious bedrooms, 2 full bathrooms, a primary suite with walk-in closet and balcony access, plus upper-level laundry and 1 parking spot. Great location close to schools, parks, Costco, shopping, restaurants, and both Waterloo universities. Preferred tenants: families or working professionals with strong credit and stable income. Utilities extra. Avaliable Oct 1, 2026 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T16:48:00.563724+00:00"
+"Directions": "ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Paved driveway"
3 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-18T13:48:39Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T13:48:39Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1687640103"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
1 => array:11 [
"RoomKey" => "1687640104"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
2 => array:11 [
"RoomKey" => "1687640105"
"RoomType" => "Bedroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
3 => array:11 [
"RoomKey" => "1687640106"
"RoomType" => "Full bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
4 => array:11 [
"RoomKey" => "1687640107"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
5 => array:11 [
"RoomKey" => "1687640108"
"RoomType" => "Kitchen"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
6 => array:11 [
"RoomKey" => "1687640109"
"RoomType" => "Great room"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.61Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30051724/142-foamflower-place-unit-22-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1300
+"OriginalEntryTimestamp": "2026-07-18T13:48:39.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:7 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051724_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/ad41cc9f4e365553d468bc2ee48e947b.webp"
"MediaSize" => 68065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-ad41cc9f4e365553d468bc2ee48e947b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051724_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/dffd8e1d44d87c085f66c9b017484956.webp"
"MediaSize" => 154024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-dffd8e1d44d87c085f66c9b017484956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051724_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/34a66d950c8b1458e5170c4a0a9839a4.webp"
"MediaSize" => 58055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-34a66d950c8b1458e5170c4a0a9839a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051724_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/6678d6423593dac3cf32bed035673d07.webp"
"MediaSize" => 55504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-6678d6423593dac3cf32bed035673d07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051724_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/c660d106cdfe84a9a01217305a63ef64.webp"
"MediaSize" => 69631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-c660d106cdfe84a9a01217305a63ef64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051724_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/4adbb123a5311dc5ae329458f4bfd1df.webp"
"MediaSize" => 63208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-4adbb123a5311dc5ae329458f4bfd1df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051724_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/72b2a091e8b8c985e6d8ad4f215ac1e4.webp"
"MediaSize" => 128388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-72b2a091e8b8c985e6d8ad4f215ac1e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051724')"
+"ID": "1639484"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290620" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24913
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Peak Realty Ltd."
+"OfficeEmail": null
+"OfficePhone": "519-747-0231"
+"OfficeMlsId": "KW368"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290620"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "25 Bruce St., Unit 5B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2B1Y"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1389824"
+"OriginalEntryTimestamp": "2021-06-21T16:36:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "266649"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290620"
"SocialMediaUrlOrId" => "http://www.peakrealtyltd.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1230701"
+"OfficeBrokerNationalAssociationId": "1171153"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290620')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24864
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30051724'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25241
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30051724' AND OpenHouseDate ge '2026-07-20'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30051724' 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.5899368 43.4496854)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1644204"
+post_author: 1
+"ListingKey": "30058773"
+"ListingId": "X13586678"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T03:15:05Z"
+"RFModificationTimestamp": "2026-07-21T04:39:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "565 BALSAM POPAR STREET, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.599902
1 => 43.457707
]
+"Latitude": 43.457707
+"Longitude": -80.599902
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client RemarksThis stunning 3,000+ sqft home offers the potential for an elevator and features a spacious double-car garage with a separate entrance to the finished basement.Large basement windows with 3pc Ensuite of Bathroom .The garage itself is exceptionally large, providing ample storage and parking space. The house has 4 generously sized bedrooms, including two luxurious master suites, plus a dedicated home office perfect for remote work or study. The home boasts 4.5 bathrooms, ensuring comfort and privacy for the whole family. Designed for modern efficiency and comfort, this home is equipped with a dual-fuel furnace, air-source heat pump, and an ERV system, promoting superior air quality and energy savings. High-end finishes include 9-ft ceilings on both the main and second floors, and elegant hardwood flooring throughout the second floor. Conveniently located near shopping plazas, Costco, Highway 85, and the famous St. Jacobs Market, this home offers both luxury and accessibility in a prime location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T04:38:57.152429+00:00"
+"Directions": "Cross Streets: Columbia St W/ Platinum Dr. ** Directions: Found on the west side of street near Sundew Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2221801"
+"ListOfficeKey": "280107"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.2 x 98.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T03:08:30Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T03:08:30Z"
+"Stories": "3.0"
+"StreetName": "Balsam Popar"
+"StreetNumber": "565"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1689762721"
"RoomType" => "Foyer"
"ListingId" => "X13586678"
"RoomLevel" => "Main level"
"RoomWidth" => 1.77
"ListingKey" => "30058773"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
1 => array:11 [
"RoomKey" => "1689762722"
"RoomType" => "Living room"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "30058773"
"RoomLength" => 4.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
2 => array:11 [
"RoomKey" => "1689762723"
"RoomType" => "Kitchen"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "30058773"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
3 => array:11 [
"RoomKey" => "1689762724"
"RoomType" => "Dining room"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.36
"ListingKey" => "30058773"
"RoomLength" => 4.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
4 => array:11 [
"RoomKey" => "1689762725"
"RoomType" => "Office"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "30058773"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
5 => array:11 [
"RoomKey" => "1689762726"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.78
"ListingKey" => "30058773"
"RoomLength" => 4.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
6 => array:11 [
"RoomKey" => "1689762727"
"RoomType" => "Bedroom 2"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 2.7
"ListingKey" => "30058773"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
7 => array:11 [
"RoomKey" => "1689762728"
"RoomType" => "Bedroom 3"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.3
"ListingKey" => "30058773"
"RoomLength" => 3.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
8 => array:11 [
"RoomKey" => "1689762729"
"RoomType" => "Bedroom 4"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.3
"ListingKey" => "30058773"
"RoomLength" => 3.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
9 => array:11 [
"RoomKey" => "1689762730"
"RoomType" => "Bedroom"
"ListingId" => "X13586678"
"RoomLevel" => "Basement"
"RoomWidth" => 4.4
"ListingKey" => "30058773"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30058773/565-balsam-popar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4000
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.2
+"OriginalEntryTimestamp": "2026-07-21T03:08:30.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1465441"
+"ListOfficeNationalAssociationId": "1309558"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30058773_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/34eaf709898229602f0dfeffc5bef455.webp"
"MediaSize" => 362925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-34eaf709898229602f0dfeffc5bef455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30058773_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f7c70c896d261cee60018c1d7719d722.webp"
"MediaSize" => 102891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f7c70c896d261cee60018c1d7719d722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30058773_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/0868fe33b1c0bc8e601851f16a7f8a7b.webp"
"MediaSize" => 183447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-0868fe33b1c0bc8e601851f16a7f8a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30058773_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/3eee0ba044d4db22764fabdb78c23323.webp"
"MediaSize" => 171355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-3eee0ba044d4db22764fabdb78c23323.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30058773_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/b376338bef52ea44323b1b67ac5e2cd1.webp"
"MediaSize" => 171738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-b376338bef52ea44323b1b67ac5e2cd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30058773_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/7aa09909350da76887ac3dac3b499169.webp"
"MediaSize" => 168356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-7aa09909350da76887ac3dac3b499169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30058773_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/74f108c73cabfc3eabf72d5643fabcfc.webp"
"MediaSize" => 175960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-74f108c73cabfc3eabf72d5643fabcfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30058773_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/d6c1401f3603083ebaa3b4ef47c6f84c.webp"
"MediaSize" => 133479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-d6c1401f3603083ebaa3b4ef47c6f84c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30058773_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f72049e1ea9a0b76b5fe4ace7b2b2632.webp"
"MediaSize" => 154036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f72049e1ea9a0b76b5fe4ace7b2b2632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30058773_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/d127ebb7f05e2b127b704d7c9ad00f29.webp"
"MediaSize" => 254191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-d127ebb7f05e2b127b704d7c9ad00f29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30058773_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/207989f21f7b4fcb9cbfa696be36eb69.webp"
"MediaSize" => 146787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-207989f21f7b4fcb9cbfa696be36eb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30058773_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/777e376f5f8fb143e7d0fd9923da0630.webp"
"MediaSize" => 146440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-777e376f5f8fb143e7d0fd9923da0630.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30058773_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/0618d9afcdc7e4be903ad50cc944d172.webp"
"MediaSize" => 125621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-0618d9afcdc7e4be903ad50cc944d172.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30058773_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f7ec9326e626662cd109e1c4d9966930.webp"
"MediaSize" => 146674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f7ec9326e626662cd109e1c4d9966930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30058773_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/16930175d4edb6fa26a49ec8db17a1dc.webp"
"MediaSize" => 134860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-16930175d4edb6fa26a49ec8db17a1dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30058773_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/c4435c9f3e2d7154c70634ebd18333ad.webp"
"MediaSize" => 123404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-c4435c9f3e2d7154c70634ebd18333ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30058773_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/1ad9ce60dd58980de70963eefe8906ce.webp"
"MediaSize" => 162609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-1ad9ce60dd58980de70963eefe8906ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30058773_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/36ccb99fdd3633fc8aa48b7b3be77b29.webp"
"MediaSize" => 133424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-36ccb99fdd3633fc8aa48b7b3be77b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30058773_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/66dda4034d572f662b61f2c070198a95.webp"
"MediaSize" => 111162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-66dda4034d572f662b61f2c070198a95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30058773_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/6e4c0aa11d863c3e5ab5d6415b196ca7.webp"
"MediaSize" => 119629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-6e4c0aa11d863c3e5ab5d6415b196ca7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30058773_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/28c1bf705ceefb1e436163494df1da62.webp"
"MediaSize" => 110636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-28c1bf705ceefb1e436163494df1da62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30058773_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/84981062097b131c6e5bf46462eec7f0.webp"
"MediaSize" => 117111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-84981062097b131c6e5bf46462eec7f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30058773_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/40086a02eb0875c10cac2c03ef0ebaf3.webp"
"MediaSize" => 136133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-40086a02eb0875c10cac2c03ef0ebaf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30058773_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/2727aee0defc3cdf7425eb1721e0b058.webp"
"MediaSize" => 130482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-2727aee0defc3cdf7425eb1721e0b058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30058773_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/8ca9aeeaad9ab56e9b8483a2d0eacb84.webp"
"MediaSize" => 116583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-8ca9aeeaad9ab56e9b8483a2d0eacb84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30058773_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/054fc2db11ee3719e43523a8968a7ab4.webp"
"MediaSize" => 146523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-054fc2db11ee3719e43523a8968a7ab4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30058773')"
+"ID": "1644204"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1644096"
+post_author: 1
+"ListingKey": "30058552"
+"ListingId": "X13586466"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T01:15:04Z"
+"RFModificationTimestamp": "2026-07-21T01:31:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X6"
+"UnparsedAddress": "402 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X6"
+"Coordinates": array:2 [
0 => -80.572615
1 => 43.451475
]
+"Latitude": 43.451475
+"Longitude": -80.572615
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 402 LAUSANNE Crescent - a beautifully maintained detached home nestled on a quiet crescent in the highly desirable Clair Hills community. This bright and spacious 3-bedroom, 3-bathroom home offers the perfect blend of comfort, functionality, and location... Step insideto a Freshly Painted, Carpet-Free interior featuring hardwood flooring on the main and second levels, creating a clean and modern feel throughout... Thoughtfully designed main floor offers an inviting open-concept layout ideal for everyday family living and entertaining, along with a spacious eat-in kitchen with ample cabinetry and workspace.... Upstairs, all three bedrooms are generously sized and feature custom closet organizers for added storage and convenience... The fully finished open basement provides excellent additional living space-perfect as a recreation room, home office, gym, playroom, or media area... Enjoy outdoor living in the deep, private fenced picturesque backyard complete with pergola - an ideal space for entertaining, summer dining, or relaxing with family and friends along with completely renovated Front and BackYards... Located just minutes from The Boardwalk, Costco, Walmart, banks, restaurants, movie theatre, schools, parks, medical offices, public transit, and easy access to the universities... A rare opportunity to own a move-in-ready family home in one of Waterloo's most sought after neighborhoods.... Don't miss this rare GEM!!! Book Now and Move-in Tomorrow!! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T01:31:47.899879+00:00"
+"Directions": "Cross Streets: Brandenburg and Lausanne. ** Directions: From Erbsville Rd to Brandenburgand right on Lausanne Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878613"
+"ListOfficeKey": "68202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "32 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T01:09:00Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T01:09:00Z"
+"Stories": "2.0"
+"StreetName": "Lausanne"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1689695715"
"RoomType" => "Living room"
"ListingId" => "X13586466"
"RoomLevel" => "Main level"
"RoomWidth" => 3.74
"ListingKey" => "30058552"
"RoomLength" => 5.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
1 => array:11 [
"RoomKey" => "1689695716"
"RoomType" => "Dining room"
"ListingId" => "X13586466"
"RoomLevel" => "Main level"
"RoomWidth" => 3.74
"ListingKey" => "30058552"
"RoomLength" => 5.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
2 => array:11 [
"RoomKey" => "1689695717"
"RoomType" => "Kitchen"
"ListingId" => "X13586466"
"RoomLevel" => "Main level"
"RoomWidth" => 2.91
"ListingKey" => "30058552"
"RoomLength" => 5.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
3 => array:11 [
"RoomKey" => "1689695718"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13586466"
"RoomLevel" => "Second level"
"RoomWidth" => 4.29
"ListingKey" => "30058552"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
4 => array:11 [
"RoomKey" => "1689695719"
"RoomType" => "Bedroom 2"
"ListingId" => "X13586466"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "30058552"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
5 => array:11 [
"RoomKey" => "1689695720"
"RoomType" => "Bedroom 3"
"ListingId" => "X13586466"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "30058552"
"RoomLength" => 3.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
6 => array:11 [
"RoomKey" => "1689695721"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13586466"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30058552"
"RoomLength" => 4.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
7 => array:11 [
"RoomKey" => "1689695722"
"RoomType" => "Laundry room"
"ListingId" => "X13586466"
"RoomLevel" => "Basement"
"RoomWidth" => 1.35
"ListingKey" => "30058552"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
8 => array:11 [
"RoomKey" => "1689695723"
"RoomType" => "Cold room"
"ListingId" => "X13586466"
"RoomLevel" => "Basement"
"RoomWidth" => 1.1
"ListingKey" => "30058552"
"RoomLength" => 2.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
9 => array:11 [
"RoomKey" => "1689695724"
"RoomType" => "Bathroom"
"ListingId" => "X13586466"
"RoomLevel" => "Basement"
"RoomWidth" => 1.0
"ListingKey" => "30058552"
"RoomLength" => 1.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T01:09:00.83Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30058552/402-lausanne-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-07-21T01:09:00.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1205168"
+"ListOfficeNationalAssociationId": "1132238"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30058552_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/f84cc5686bd9cfd814fb50fcf4c51308.webp"
"MediaSize" => 179273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-f84cc5686bd9cfd814fb50fcf4c51308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30058552_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/501f13c0690ee7ef380027fcb648c3d5.webp"
"MediaSize" => 207487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-501f13c0690ee7ef380027fcb648c3d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30058552_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/a83af5c9143f594c174e6f219dbb4f3a.webp"
"MediaSize" => 67686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-a83af5c9143f594c174e6f219dbb4f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30058552_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/738ffcd6f89de1be44e5d469b0c183eb.webp"
"MediaSize" => 64986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-738ffcd6f89de1be44e5d469b0c183eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30058552_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/81e5f640dab9c3ccbc857a88683e3beb.webp"
"MediaSize" => 80343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-81e5f640dab9c3ccbc857a88683e3beb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30058552_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/edf788d3a6a3c1e834d085b082b0a233.webp"
"MediaSize" => 76637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-edf788d3a6a3c1e834d085b082b0a233.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30058552_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/d406942c0094a886c7eb2776d7ee4fe7.webp"
"MediaSize" => 64526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-d406942c0094a886c7eb2776d7ee4fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30058552_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/3a315d87d7938a3feb3d6c0bb0c88838.webp"
"MediaSize" => 61445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-3a315d87d7938a3feb3d6c0bb0c88838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30058552_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/74f520d4d7b3409d3e778fc43beed07b.webp"
"MediaSize" => 63139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-74f520d4d7b3409d3e778fc43beed07b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30058552_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/8ad58028cf7ac22d214071aafb4cf94c.webp"
"MediaSize" => 65614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-8ad58028cf7ac22d214071aafb4cf94c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30058552_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/6019afe2ed43656fbad3b3be47602f6f.webp"
"MediaSize" => 59783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-6019afe2ed43656fbad3b3be47602f6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30058552_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/1827ef40868eb059471fdba54a79f38f.webp"
"MediaSize" => 78605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-1827ef40868eb059471fdba54a79f38f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30058552_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/8ffd5dd8650500644323e6b412dcabfb.webp"
"MediaSize" => 97587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-8ffd5dd8650500644323e6b412dcabfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30058552_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/fd93ac51b172d66deab482a13d1c7161.webp"
"MediaSize" => 91898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-fd93ac51b172d66deab482a13d1c7161.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30058552_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/6e2bad8d41f881441c697717ee06461f.webp"
"MediaSize" => 65955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-6e2bad8d41f881441c697717ee06461f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30058552_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/4aedc9e505f8f5e825d1313022361f60.webp"
"MediaSize" => 71343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-4aedc9e505f8f5e825d1313022361f60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30058552_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/ae8150561f425e50ad434b30e88ecbbd.webp"
"MediaSize" => 80635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-ae8150561f425e50ad434b30e88ecbbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30058552_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/702b1f4fdb8de07d3a329559f871b6b0.webp"
"MediaSize" => 80610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-702b1f4fdb8de07d3a329559f871b6b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30058552_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/b025d228a0d7aaed93f4f62e9980c9ad.webp"
"MediaSize" => 71208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-b025d228a0d7aaed93f4f62e9980c9ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30058552_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/00a13a6e96ab90cddad81fd05ac2ab79.webp"
"MediaSize" => 55185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-00a13a6e96ab90cddad81fd05ac2ab79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30058552_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/6dbe1ec3c9c46e673eb9c5f86bed5280.webp"
"MediaSize" => 65890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-6dbe1ec3c9c46e673eb9c5f86bed5280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30058552_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/aa86c519b6fee3fba18c9a62e0373267.webp"
"MediaSize" => 60373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-aa86c519b6fee3fba18c9a62e0373267.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30058552_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/668c4af9e61c0daa4c6088a628312743.webp"
"MediaSize" => 51545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-668c4af9e61c0daa4c6088a628312743.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30058552_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/34bbcedc1a64c8fa05babcbe4e65a2a3.webp"
"MediaSize" => 64925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-34bbcedc1a64c8fa05babcbe4e65a2a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30058552_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/9a46f0c9623f841dd6cd4cffc502a1cb.webp"
"MediaSize" => 55896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-9a46f0c9623f841dd6cd4cffc502a1cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586466"
"ResourceRecordKey" => "30058552"
"ModificationTimestamp" => "2026-07-21T01:09:00.82Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30058552_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058552/dc4bcec225569c037135ef9fad764813.webp"
"MediaSize" => 67681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058552/thumbnail-dc4bcec225569c037135ef9fad764813.webp"
…7
]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30058552')"
+"ID": "1644096"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1643219"
+post_author: 1
+"ListingKey": "30057334"
+"ListingId": "40849732"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T20:45:03Z"
+"RFModificationTimestamp": "2026-07-20T23:02:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 2300.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Z8"
+"UnparsedAddress": "408 WESTCROFT Drive N Unit# Basement, Waterloo, Ontario N2T2Z8"
+"Coordinates": array:2 [
0 => -80.5668761
1 => 43.4473652
]
+"Latitude": 43.4473652
+"Longitude": -80.5668761
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the basement apartment at 408 Westcroft Drive, a bright and spacious one-bedroom unit offering comfort, privacy, and convenience. This well-maintained home features a separate private entrance, large windows that provide plenty of natural light, and private in-suite laundry for the tenant’s exclusive use. One outdoor parking space is included. Conveniently located close to shopping centres, schools, public transit, parks, and everyday amenities, this unit is an excellent choice for a professional, couple, or student. The basement tenant is responsible for 30% of the household utilities. A comfortable and private living space in a highly convenient location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T23:02:44.237898+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Vinyl siding"
2 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2177184"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-20T20:38:14Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T20:38:13Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTCROFT"
+"StreetNumber": "408"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Telephone"
]
+"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/30057334/408-westcroft-drive-n-unit-basement-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1300
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1800
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2026-07-20T20:38:13.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1427237"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057334')"
+"ID": "1643219"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1643238"
+post_author: 1
+"ListingKey": "30057921"
+"ListingId": "40849786"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T03:05:19Z"
+"RFModificationTimestamp": "2026-07-21T03:08:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L1"
+"UnparsedAddress": "365 BENNINGTON Gate Unit# 13, Waterloo, Ontario N2T2L1"
+"Coordinates": array:2 [
0 => -80.5756639
1 => 43.4640033
]
+"Latitude": 43.4640033
+"Longitude": -80.5756639
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional living in prestigious Waterloo Upper Beechwood community with this spacious 2+1 bedroom, 3.5 bathroom townhome condo. $2600 plus with flexible move in date extending as late as September 1, 2026. Offering 1,500 sq ft of well-appointed living space, plus an additional 512 sq ft in the finished walk out basement. This home combines style, functionality, and quiet living. The bright and open-concept main level features an eat-in kitchen, dining area, and a comfortable living space; perfect for family gatherings and entertaining. The upper level includes a generous primary bedroom with an en-suite bathroom and ample closet space, bonus living area for a home office or family room, along with a second bedroom and full bath. The finished walk out basement offers endless possibilities, featuring a versatile layout ideal for an additional bedroom, a home gym, or a recreational room - complete with a 3-piece bathroom for added convenience. With an attached garage, a cozy backyard for outdoor relaxation, and access to a complex pool, this home provides everything you need for a balanced lifestyle. Situated in the desirable Upper Beechwood community, you'll enjoy the charm of this well-established neighborhood, with nearby parks, great schools, shopping, and easy access to Waterloo's amenities. This townhome is perfect for families, professionals, and down-sizers seeking comfort, convenience, and community living. Don't miss your chance to make this sought-after address your new home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T22:31:22.793232+00:00"
+"Directions": "Columbia St. W. to Bennington Gate"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T22:12:20Z"
+"PhotosCount": 20
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T02:58:46Z"
+"Stories": "2.0"
+"StreetName": "BENNINGTON"
+"StreetNumber": "365"
+"StreetSuffix": "Gate"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30057921/365-bennington-gate-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 2060
+"BelowGradeFinishedArea": 512
+"OriginalEntryTimestamp": "2026-07-20T22:08:34.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057921')"
+"ID": "1643238"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1642826"
+post_author: 1
+"ListingKey": "30055809"
+"ListingId": "X13584212"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T17:15:12Z"
+"RFModificationTimestamp": "2026-07-20T19:17:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B2"
+"UnparsedAddress": "MAIN - 286 BUTTONBUSH STREET, Waterloo, Ontario N2V0B2"
+"Coordinates": array:2 [
0 => -80.589804
1 => 43.451538
]
+"Latitude": 43.451538
+"Longitude": -80.589804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous 4 Bedroom Detached house (Upper only) in one most demanding neighborhood. Boosting 9'Ceilings & Plenty Of Upgrades. Enjoy 4 Spacious Bedrooms + Study And A Great Room With A Practical & Commodious Layout. Large Windows - Lots Of Sunlight. Mins Drive to Costco & other amenities, Walking distance to School & Park. Move In & Enjoy! Won't last long. No disappointments here! (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Oven"
4 => "Hood Fan"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:17:44.810351+00:00"
+"Directions": "Columbia St & Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072435"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "In suite Laundry"
1 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 98.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T17:09:53Z"
+"PhotosCount": 15
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T17:09:53Z"
+"Stories": "2.0"
+"StreetName": "Buttonbush"
+"StreetNumber": "286"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30055809/main-286-buttonbush-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-20T17:09:53.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347614"
+"ListOfficeNationalAssociationId": "1002993"
+"Media": array:15 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055809')"
+"ID": "1642826"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1641159"
+post_author: 1
+"ListingKey": "30054341"
+"ListingId": "X13582668"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T14:50:11Z"
+"RFModificationTimestamp": "2026-07-20T14:52:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K7"
+"UnparsedAddress": "624A RUMMELHARDT DRIVE, Waterloo, Ontario N2T2K7"
+"Coordinates": array:2 [
0 => -80.570221
1 => 43.450331
]
+"Latitude": 43.450331
+"Longitude": -80.570221
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**This isn't your typical basement apartment!** Bright, spacious and filled with natural light, this unique **1-bedroom + 1 large den (could be used as another bedroom), 1-bathroom** walkout features a smart split-level design. The large living room and functional kitchen are located on the ground floor, while the bedroom(s), full bathroom and private laundry are just a few steps down, creating a natural separation between the living and sleeping areas. Enjoy **exclusive use of the fully fenced backyard** and **one dedicated parking space**. Located in a newer Kitchener neighbourhood close to parks, trails, shopping, schools and major highways. Tenants pay 35% utilities. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T14:03:40.374074+00:00"
+"Directions": "Cross Streets: Erb St. W/Erbsville Ct. ** Directions: Erbsville Rd to Royal Beech Dr to Pinerow Crescent to Rummelhardt Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080075"
+"ListOfficeKey": "285622"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31 x 111 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T14:40:46Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T14:40:46Z"
+"StreetName": "Rummelhardt"
+"StreetSuffix": "Drive"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30054341/lower-624a-rummelhardt-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1650
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"OriginalEntryTimestamp": "2026-07-20T13:38:08.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1354970"
+"ListOfficeNationalAssociationId": "1352832"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30054341')"
+"ID": "1641159"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23525
+post_id: "1639287"
+post_author: 1
+"ListingKey": "30049920"
+"ListingId": "40848853"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:25:20Z"
+"RFModificationTimestamp": "2026-07-17T23:11:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1147.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 36, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5883282
1 => 43.449943
]
+"Latitude": 43.449943
+"Longitude": -80.5883282
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury living in the highly sought-after Vista Hills community of West Waterloo. This stunning executive stacked townhouse offers the perfect blend of modern design, comfort, and convenience. Featuring 3 spacious bedrooms and 2.5 bathrooms, this beautifully maintained home boasts an open-concept layout designed for today's lifestyle. The bright and inviting main floor is carpet-free and showcases a stylish kitchen complete with elegant quartz countertops, abundant cabinetry, a large center island with breakfast bar seating, and plenty of workspace for entertaining or everyday living. The spacious living and dining areas flow seamlessly to private outdoor spaces, with two balconies providing the perfect setting to enjoy your morning coffee or unwind after a long day. Upstairs, the primary retreat offers a luxurious ensuite bathroom featuring a sleek glass-enclosed shower, creating a spa-like experience in the comfort of your own home. Located in one of Waterloo's most desirable neighborhoods, Vista Hills is known for its top-rated schools, scenic walking trails, parks, and close proximity to shopping, dining, universities, and major commuter routes. xWhether you're a professional, growing family, or savvy investor, this exceptional home delivers the perfect combination of style, functionality, and an unbeatable location. Don't miss your opportunity to own in one of West Waterloo's premier communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "346.55"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:11:16.005412+00:00"
+"Directions": "Columbia St W to Ladyslipper Dr, Ladyslipper Dr to Foamflower"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878382"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-17T20:18:24Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:18:24Z"
+"Stories": "3.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30049920/142-foamflower-place-unit-36-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1147
+"OriginalEntryTimestamp": "2026-07-17T20:18:24.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205009"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049920')"
+"ID": "1639287"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1637223"
+post_author: 1
+"ListingKey": "30043864"
+"ListingId": "40848815"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:15Z"
+"RFModificationTimestamp": "2026-07-17T20:52:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5956476
1 => 43.4555934
]
+"Latitude": 43.4555934
+"Longitude": -80.5956476
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:52:43.451105+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:29:28Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:36Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043864/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-16T19:29:28.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043864')"
+"ID": "1637223"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1616139"
+post_author: 1
+"ListingKey": "30021051"
+"ListingId": "X13552080"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T04:10:00Z"
+"RFModificationTimestamp": "2026-07-19T04:18:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as afitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T04:47:41.976622+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Keats way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T05:37:02Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T04:03:00Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021051/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-11T01:34:00.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021051')"
+"ID": "1616139"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 22
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]