array:6 [
"RF Cache Key: 0d47733e199defb448c34a28e98000529b3d4359497692474415131b185b748c" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21776
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23360
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29747857"
+"ListingId": "40830083"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T19:30:26Z"
+"RFModificationTimestamp": "2026-06-09T22:55:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 102, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5994493
1 => 43.4705757
]
+"Latitude": 43.4705757
+"Longitude": -80.5994493
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully maintained 2-bedroom, 2 full bathroom condo available for lease from June 1st in Waterloo’s highly sought-after Laurelwood neighborhood. This unique ground-floor unit offers 1,086 sq. ft. of thoughtfully designed living space along with a private backyard — a rare feature in the building. The unit is exceptionally bright and filled with natural sunlight throughout. The open-concept layout features a modern kitchen with granite countertops, stainless steel appliances, a large island/breakfast bar, and ample cabinetry. The spacious living and dining area is filled with natural light and walks out to the private outdoor space, perfect for relaxing or entertaining. The primary bedroom includes a walk-in closet and a full ensuite bathroom. Additional features include in-suite laundry, central heating and air conditioning, carpet-free living, a dedicated storage locker, and 1 dedicated parking space. Rent includes water and the owned water heater. Tenant pays hydro and gas only. Residents of Reflections Condos enjoy excellent amenities including a theatre room, games/party room with billiards and kitchenette, entertainment lounge, bicycle storage, secure fob entry, and beautifully landscaped outdoor cabanas with BBQs. Located in the catchment area of highly rated schools and close to parks, trails, Laurelwood Conservation Area, The Boardwalk Shopping District, transit, University of Waterloo, tech park, and many everyday amenities. Perfect for professionals or small families seeking comfort, convenience, and upscale living in one of Waterloo’s most desirable communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Microwave Built-in"
]
+"AssociationFee": "440"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-13T20:38:28.515052+00:00"
+"Directions": "From Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-05-13T22:09:36Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T19:21:45Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1655811095"
"RoomType" => "Kitchen"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
1 => array:11 [
"RoomKey" => "1655811096"
"RoomType" => "4pc Bathroom"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
2 => array:11 [
"RoomKey" => "1655811097"
"RoomType" => "Bedroom"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
3 => array:11 [
"RoomKey" => "1655811098"
"RoomType" => "3pc Bathroom"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
4 => array:11 [
"RoomKey" => "1655811099"
"RoomType" => "Primary Bedroom"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
5 => array:11 [
"RoomKey" => "1655811100"
"RoomType" => "Living room"
"ListingId" => "40830083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29747857"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:21:45.34Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29747857/778-laurelwood-drive-unit-102-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-05-13T20:10:31.2Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1463723"
+"ListOfficeNationalAssociationId": "1378643"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29747857_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/1432cb29cc5cd061a0b985f9d3f55988.webp"
"MediaSize" => 90849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-1432cb29cc5cd061a0b985f9d3f55988.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a stone and brick facade, individual private balconies, a prominent main entrance, and decorative planters"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T20:10:31.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29747857_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/f60ffd16f168d8b579a5b518b76e913b.webp"
"MediaSize" => 58426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-f60ffd16f168d8b579a5b518b76e913b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:42.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29747857_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/9ae5a80165405560f2da620248ea3752.webp"
"MediaSize" => 56664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-9ae5a80165405560f2da620248ea3752.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29747857_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/9e0c513e3f11ad428d8ebbb795903e86.webp"
"MediaSize" => 58991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-9e0c513e3f11ad428d8ebbb795903e86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.07Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29747857_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/3dfbafc14d21dbe1aa235f53a085bef5.webp"
"MediaSize" => 57373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-3dfbafc14d21dbe1aa235f53a085bef5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29747857_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/a9ac82dc24f6956d7990b1bb199756ef.webp"
"MediaSize" => 87992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-a9ac82dc24f6956d7990b1bb199756ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.12Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29747857_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/e0e5d1e3d9bcd30c0a1ddc631654dba3.webp"
"MediaSize" => 87600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-e0e5d1e3d9bcd30c0a1ddc631654dba3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:42.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29747857_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/ba8fcd3fd72231ed909194cad4f4df38.webp"
"MediaSize" => 38554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-ba8fcd3fd72231ed909194cad4f4df38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.04Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29747857_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/1d343609fee9ea03bcd251b24419483f.webp"
"MediaSize" => 43001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-1d343609fee9ea03bcd251b24419483f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29747857_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/b781453497ca2938b1a3db24b7b1e18b.webp"
"MediaSize" => 46778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-b781453497ca2938b1a3db24b7b1e18b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.07Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29747857_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/698d157bd459e1a7a783d7471d7ff342.webp"
"MediaSize" => 29823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-698d157bd459e1a7a783d7471d7ff342.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.31Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29747857_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/212ccd6707dc5e977a3945e3e9fcfa09.webp"
"MediaSize" => 53606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-212ccd6707dc5e977a3945e3e9fcfa09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29747857_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/4ea461f96466a0e9fec74429f6793cc9.webp"
"MediaSize" => 42846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-4ea461f96466a0e9fec74429f6793cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29747857_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/17d453086b9c17c66c43a9e9d31aa86d.webp"
"MediaSize" => 50233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-17d453086b9c17c66c43a9e9d31aa86d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29747857_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/fbf46663cf983f7a175ed7a2ea4fc3f8.webp"
"MediaSize" => 34270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-fbf46663cf983f7a175ed7a2ea4fc3f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.07Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29747857_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/d7fc9307a9160e26651ab8fb52d2c7e1.webp"
"MediaSize" => 34012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-d7fc9307a9160e26651ab8fb52d2c7e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29747857_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/bf76e76929bab76d7dfe641a669b83e0.webp"
"MediaSize" => 75343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-bf76e76929bab76d7dfe641a669b83e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.04Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29747857_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/a79583d200ecc005e86465049e673dfe.webp"
"MediaSize" => 58163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-a79583d200ecc005e86465049e673dfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29747857_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/333a6fd0480416040230fa8fb302bbf3.webp"
"MediaSize" => 52480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-333a6fd0480416040230fa8fb302bbf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.08Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29747857_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/dde483b10db4654c3740e1aaa99c572e.webp"
"MediaSize" => 49043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-dde483b10db4654c3740e1aaa99c572e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.7Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29747857_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/397d1d2feb2745436b2789ee0c42bb82.webp"
"MediaSize" => 53658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-397d1d2feb2745436b2789ee0c42bb82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29747857_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/2240cce7c4391d1cdd384b3b9b62044c.webp"
"MediaSize" => 107145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-2240cce7c4391d1cdd384b3b9b62044c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:38.65Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29747857_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/beb71e908622a69b2dc128ae5c180252.webp"
"MediaSize" => 82488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-beb71e908622a69b2dc128ae5c180252.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.08Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29747857_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/35125e8a42af885bfb6a2db06e56618e.webp"
"MediaSize" => 72663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-35125e8a42af885bfb6a2db06e56618e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.68Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29747857_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/ee99f6a283ed10310369d473d6832279.webp"
"MediaSize" => 54459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-ee99f6a283ed10310369d473d6832279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.07Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29747857_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/446ea1166ac1ddd761f0701af510d03d.webp"
"MediaSize" => 70027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-446ea1166ac1ddd761f0701af510d03d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:39.15Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29747857_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/dcc3fdd4ae77d2ebdf298d0d2f74b04c.webp"
"MediaSize" => 66620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-dcc3fdd4ae77d2ebdf298d0d2f74b04c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.12Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29747857_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/42210a82c0f3da9a05008a2e8eea293d.webp"
"MediaSize" => 67063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-42210a82c0f3da9a05008a2e8eea293d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:41.31Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29747857_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/2f14461716a6fa18852fcfeb260d13de.webp"
"MediaSize" => 49056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-2f14461716a6fa18852fcfeb260d13de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:42.45Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29747857_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/5ef4c790c55cbcaccd2c8b9b0fff6e0d.webp"
"MediaSize" => 46025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-5ef4c790c55cbcaccd2c8b9b0fff6e0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.04Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29747857_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29747857/22abc9a43b4b660d18819c38718e470d.webp"
"MediaSize" => 42760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29747857/thumbnail-22abc9a43b4b660d18819c38718e470d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830083"
"ResourceRecordKey" => "29747857"
"ModificationTimestamp" => "2026-05-13T21:53:40.08Z"
]
]
+"DaysOnMarket": 30
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29747857')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: 6d8ee6796881b12322dc0d3593172f596bb53c5f3d4e5a0c870be2b4fbc15526" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24460
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2218013" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24783
+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 '29747857'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25080
+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 '29747857'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25096
+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 '29747857' 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.5994493 43.4705757)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25149
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: "1525711"
+post_author: 1
+"ListingKey": "29895190"
+"ListingId": "X13436704"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:50Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V6"
+"UnparsedAddress": "579 VIOLET STREET, Waterloo, Ontario N2V2V6"
+"Coordinates": array:2 [
0 => -80.596372
1 => 43.468534
]
+"Latitude": 43.468534
+"Longitude": -80.596372
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautiful carpet free 2 storey house in school zone area; Steps to Abraham Erb and SJAM High School. Walkout basement to backyard to protected forest. Approximately 3,000 sqft living area. Upper family room with vaulted ceilings and gas fireplace. Gorgeous 5 pc master ensuite, deep whirlpool tub, separate shower, double sinks and walk-in closet. Main floor crown moulding, solid oak staircase. Oak kitchen cabinets, under cabinet lighting. Kitchen and powder room with granite countertops, backsplash. Main floor laundry. Professionally finished basement with huge ensuite. Big rec room. (id:62783)"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:46.061046+00:00"
+"Directions": "Cross Streets: Laurelwood Dr & Erbsville. ** Directions: Laurelwood Dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132030"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "34 x 100.9 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.5"
+"StreetName": "Violet"
+"StreetNumber": "579"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1657760633"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13436704"
"RoomLevel" => "Second level"
"RoomWidth" => 4.14
"ListingKey" => "29895190"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.28Z"
]
1 => array:11 [
"RoomKey" => "1657760634"
"RoomType" => "Bedroom 2"
"ListingId" => "X13436704"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29895190"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.29Z"
]
2 => array:11 [
"RoomKey" => "1657760635"
"RoomType" => "Bedroom 3"
"ListingId" => "X13436704"
"RoomLevel" => "Second level"
"RoomWidth" => 2.82
"ListingKey" => "29895190"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.29Z"
]
3 => array:11 [
"RoomKey" => "1657760636"
"RoomType" => "Bedroom 4"
"ListingId" => "X13436704"
"RoomLevel" => "Basement"
"RoomWidth" => 3.68
"ListingKey" => "29895190"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.29Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895190/579-violet-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3300
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1384749"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895190_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/7a1cf499f87d61cfdeca296d807db775.webp"
"MediaSize" => 82948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-7a1cf499f87d61cfdeca296d807db775.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29895190_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/6b8e51991b020e0b134b090a4eab7f50.webp"
"MediaSize" => 168108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-6b8e51991b020e0b134b090a4eab7f50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29895190_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/5196012bf6b509a479195740ebf7e447.webp"
"MediaSize" => 175378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-5196012bf6b509a479195740ebf7e447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29895190_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/6026749aae434adc345fe1c3a57b6419.webp"
"MediaSize" => 158814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-6026749aae434adc345fe1c3a57b6419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29895190_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/251a6e8fcbcec200afd328b5a9d39c7f.webp"
"MediaSize" => 149512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-251a6e8fcbcec200afd328b5a9d39c7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29895190_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/843c8151b486a6ae9ee2a3d57de2f4f6.webp"
"MediaSize" => 169856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-843c8151b486a6ae9ee2a3d57de2f4f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29895190_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/c3233771da4fad92c6cf98effa31c9cb.webp"
"MediaSize" => 153495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-c3233771da4fad92c6cf98effa31c9cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29895190_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/e13bfdfbdaec648c1af2c2bde5b5e0ff.webp"
"MediaSize" => 143009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-e13bfdfbdaec648c1af2c2bde5b5e0ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29895190_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/a176c8058b34a1499c4d01cf265eee3f.webp"
"MediaSize" => 205046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-a176c8058b34a1499c4d01cf265eee3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29895190_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/c583ab5979cbcf949133f3d509a41443.webp"
"MediaSize" => 148380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-c583ab5979cbcf949133f3d509a41443.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29895190_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/5f32f75995039965e2064924c1ace639.webp"
"MediaSize" => 87380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-5f32f75995039965e2064924c1ace639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29895190_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/f0c155c990e8736959bed93b010cd31f.webp"
"MediaSize" => 98972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-f0c155c990e8736959bed93b010cd31f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29895190_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/48c54de9d3e413a9925d37ed2a4e7892.webp"
"MediaSize" => 137401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-48c54de9d3e413a9925d37ed2a4e7892.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29895190_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/355e93eb8af62916e17f2af7058c5f01.webp"
"MediaSize" => 160003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-355e93eb8af62916e17f2af7058c5f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29895190_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/1948abbb61e68421a4cab74fe9796773.webp"
"MediaSize" => 163999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-1948abbb61e68421a4cab74fe9796773.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29895190_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/7ca3e184fa15f0a11cf7067a539e583a.webp"
"MediaSize" => 80289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-7ca3e184fa15f0a11cf7067a539e583a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29895190_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/9d17235e819656ecbf6e9a142b12200f.webp"
"MediaSize" => 149132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-9d17235e819656ecbf6e9a142b12200f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29895190_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/f455ab083d34e4ac6c6f60696cc87471.webp"
"MediaSize" => 85871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-f455ab083d34e4ac6c6f60696cc87471.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29895190_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/085b77cd978e5020e60156e635c23598.webp"
"MediaSize" => 199266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-085b77cd978e5020e60156e635c23598.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29895190_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/f9d47d0f29d5ad7bea8cd7b634a0495a.webp"
"MediaSize" => 167660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-f9d47d0f29d5ad7bea8cd7b634a0495a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29895190_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/1301078ee8d08aa4f0b1b50294ed6051.webp"
"MediaSize" => 149498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-1301078ee8d08aa4f0b1b50294ed6051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29895190_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/240664421f9ee13e22ed18a577e3f612.webp"
"MediaSize" => 76100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-240664421f9ee13e22ed18a577e3f612.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29895190_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/8a81bb0fa3a383dfe1ed7b1a452cc12a.webp"
"MediaSize" => 160608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-8a81bb0fa3a383dfe1ed7b1a452cc12a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29895190_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/af14ca70c1cf303505b0a03706fd55fb.webp"
"MediaSize" => 117045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-af14ca70c1cf303505b0a03706fd55fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29895190_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/4f33fd36e4cd46835547995fb9985b1f.webp"
"MediaSize" => 167327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-4f33fd36e4cd46835547995fb9985b1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29895190_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/690b142fdd7361fb69bfec0c43be1d30.webp"
"MediaSize" => 101876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-690b142fdd7361fb69bfec0c43be1d30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29895190_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/3c9699f2f9ffa44ab3e4bbedc0ebb7dc.webp"
"MediaSize" => 190915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-3c9699f2f9ffa44ab3e4bbedc0ebb7dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29895190_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/c044a3e24f70dfb2266d222ff26bc398.webp"
"MediaSize" => 86565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-c044a3e24f70dfb2266d222ff26bc398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29895190_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/8e8d026e66c12e2716ff64bfeacb24da.webp"
"MediaSize" => 207546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-8e8d026e66c12e2716ff64bfeacb24da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29895190_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/cf5eab94501e5f123c8d0ce44fe8f117.webp"
"MediaSize" => 167064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-cf5eab94501e5f123c8d0ce44fe8f117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29895190_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895190/97481d2256992baed34adaca22b4d686.webp"
"MediaSize" => 425932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895190/thumbnail-97481d2256992baed34adaca22b4d686.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436704"
"ResourceRecordKey" => "29895190"
"ModificationTimestamp" => "2026-06-12T15:30:32.26Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895190')"
+"ID": "1525711"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25145
+post_id: "1523008"
+post_author: 1
+"ListingKey": "29893337"
+"ListingId": "40839237"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:15:05Z"
+"RFModificationTimestamp": "2026-06-12T05:34:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1976.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "479 TREMBLING ASPEN Avenue, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5932768
1 => 43.4687994
]
+"Latitude": 43.4687994
+"Longitude": -80.5932768
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Available for Lease AUGUST 1 2026 in Waterloo’s Top School District! Situated in one of Waterloo’s most sought-after neighbourhoods, this 3-bedroom, 2-bathroom home is just a 5-minute walk to both elementary and high schools, with easy bus access to local universities. Inside, you’ll find a functional layout with fresh updates throughout: brand-new Berber carpet on the upper level, new luxury vinyl flooring in the bathrooms, fresh paint, and modern pot lighting for a bright, contemporary feel. The open-concept kitchen flows seamlessly into the living and dining areas and is equipped with stainless steel appliances, all updated within the past five years. The upper-level family room impresses with soaring ceilings and plenty of natural light—perfect for an additional lounge or work-from-home space. The professionally landscaped front and backyard feature new sod and low-maintenance design, with a newly added walkway that can double as a second parking spot. The garage also includes a brand-new insulated door. Additional highlights include two separate living areas, an unfinished basement with laundry and rough-in for a future bathroom, and close proximity to shopping, transit, parks, and major roadways for easy commuting. This home is meticulously maintained, pet-free, and ready for its next family! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T05:34:41.323297+00:00"
+"Directions": "From Erbsville Road, turn west onto Laurelwood Drive, then turn left onto Blue Beech Boulevard, and finally turn right onto Trembling Aspen Avenue. The property is on the right-hand side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091826"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T01:09:50Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:09:49Z"
+"Stories": "2.0"
+"StreetName": "TREMBLING ASPEN"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:1 [
0 => "Telephone"
]
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657487438"
"RoomType" => "Cold room"
"ListingId" => "40839237"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.91Z"
]
1 => array:11 [
"RoomKey" => "1657487439"
"RoomType" => "Laundry room"
"ListingId" => "40839237"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
2 => array:11 [
"RoomKey" => "1657487440"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
3 => array:11 [
"RoomKey" => "1657487441"
"RoomType" => "Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
4 => array:11 [
"RoomKey" => "1657487442"
"RoomType" => "Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
5 => array:11 [
"RoomKey" => "1657487443"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
6 => array:11 [
"RoomKey" => "1657487444"
"RoomType" => "Family room"
"ListingId" => "40839237"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
7 => array:11 [
"RoomKey" => "1657487445"
"RoomType" => "Dining room"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
8 => array:11 [
"RoomKey" => "1657487446"
"RoomType" => "Living room"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
9 => array:11 [
"RoomKey" => "1657487447"
"RoomType" => "Kitchen"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
10 => array:11 [
"RoomKey" => "1657487448"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839237"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29893337"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T01:09:49.92Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29893337/479-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2950
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1406
+"BelowGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-06-12T01:09:49.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29893337_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29893337/7ac08a78d219809b7a93372cc074d278.webp"
…10
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893337')"
+"ID": "1523008"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+post_id: "1519777"
+post_author: 1
+"ListingKey": "29889657"
+"ListingId": "40836552"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:00:13Z"
+"RFModificationTimestamp": "2026-06-11T18:18:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3460.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C4"
+"UnparsedAddress": "757 PASTURE ROSE Street, Waterloo, Ontario N2V0C4"
+"Coordinates": array:2 [
0 => -80.6014022
1 => 43.4612875
]
+"Latitude": 43.4612875
+"Longitude": -80.6014022
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "FOR RENT ** Welcome to 757 PASTURE ROSE ST, an exceptional, CARPET-FREE detached home available for lease in the highly desirable VISTA HILLS community of Waterloo West. This 5-BEDROOM & 4.5 BATH residence spans an impressive 3,400+ sq. ft of finished living space (2,760 above grade + 700 in the basement), perfectly blending executive luxury with everyday family functionality. The bright, open-concept main floor boasts 9-foot ceilings, a spacious living room with California shutters and a cozy fireplace, a double-sink kitchen with a Butler’s pantry + Walk-In pantry, Powder Room and a breakfast room that walks out to the backyard. Upstairs, you will find 4 large bedrooms and 3 bathrooms—including a primary bedroom with a wall-to-wall walk-in closet and private ensuite—along side a highly convenient UPPER-LEVEL LAUNDRY ROOM. The FULLY FINISHED BASEMENT adds excellent auxiliary space, featuring a massive 30-foot recreation room, an additional guest/in-law bedroom, and a full 3-piece bathroom. Outfitted with durable luxury vinyl and tile flooring throughout, this home is incredibly practical for active families and pet considerations. Outdoor living is a breeze on the large, welcoming deck within the FULLY-FENCED LARGE BACKYARD, complete with an included BBQ and patio set. Parking is effortless with a 2-car garage and a double-wide driveway accommodating a total of 4-VEHICLES PARKING. Close to top-rated schools & universities, parks, trails, Costco, Cinemas and Medical clinics, this home is ideal for corporate relocations or families seeking a move-in ready property with great landlords. Tenants pay 100% utilities and water heater rental (approx. $50/month). Applicants must provide a rental application, government ID, employment letter, 3 recent pay stubs, references, a valid Equifax credit report, a $100 key deposit, and tenant liability insurance. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:18:08.204276+00:00"
+"Directions": "Take Columbia St W toward Vista Hills, turn onto Sundew Dr. towards the end. Take a left to Rock Elm, then 2nd right onto Pasture Rose St."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130641"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T16:51:47Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:51:47Z"
+"Stories": "2.0"
+"StreetName": "PASTURE ROSE"
+"StreetNumber": "757"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8092"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889657/757-pasture-rose-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 4600
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 2760
+"BelowGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-11T16:51:47.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1383481"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889657')"
+"ID": "1519777"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "1518442"
+post_author: 1
+"ListingKey": "29886681"
+"ListingId": "X13429250"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T13:25:10Z"
+"RFModificationTimestamp": "2026-06-11T13:28:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "445 AVENS STREET, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.596467
1 => 43.453819
]
+"Latitude": 43.453819
+"Longitude": -80.596467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "445 Avens Street is a rare offering in the heart of Vista Hills-an address that captures the essence of modern Waterloo living with confidence, style, and undeniable potential. Thoughtfully designed and effortlessly livable, this residence balances clean architectural lines with warm, inviting spaces that feel as good as they look. Natural light pours through the home, animating every corner and enhancing a layout created for both connection and quiet retreat. The main level unfolds with ease-an open, contemporary setting where daily life and entertaining exist in perfect harmony. At its centre, a refined kitchen anchors the space, equal parts function and design, ready to host everything from casual mornings to unforgettable evenings. Above, three well-appointed bedrooms offers comfort without compromise. The primary suite is a calm and elevated escape, complete with its own ensuite and walk-in closet-a space designed to recharge and reset. Beyond the interiors, the home continues to impress. Set against a quiet residential backdrop, the outdoor space offers a sense of calm rarely found at this price point-an everyday luxury that enhances how the home is lived and experienced. The lower level remains untouched-a canvas of opportunity, inviting future owners to expand, create, and add lasting value. Positioned just moments from The Boardwalk, Costco Wholesale, and the academic and cultural energy of University of Waterloo and Wilfrid Laurier University, this is a location defined by convenience, growth, and community. This is more than a home-it's a smart, stylish foothold in one of Waterloo's most desirable neighbourhoods. A place to grow, invest, and thrive.445 Avens Street is not just an opportunity. It's a move forward. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:12:13.275388+00:00"
+"Directions": "SUNDEW DR / WILD CALLA ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197711"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "28.7 x 119.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T01:12:52Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T13:16:18Z"
+"Stories": "2.0"
+"StreetName": "Avens"
+"StreetNumber": "445"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886681/445-avens-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.8
+"OriginalEntryTimestamp": "2026-06-11T01:12:52.65Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1446160"
+"ListOfficeNationalAssociationId": "1316438"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886681')"
+"ID": "1518442"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+post_id: "1502312"
+post_author: 1
+"ListingKey": "29864480"
+"ListingId": "40837384"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T23:40:36Z"
+"RFModificationTimestamp": "2026-06-06T00:51:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1457.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W4"
+"UnparsedAddress": "517 VIRGINIA CREEPER Street, Waterloo, Ontario N2V2W4"
+"Coordinates": array:2 [
0 => -80.600191
1 => 43.4721733
]
+"Latitude": 43.4721733
+"Longitude": -80.600191
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your search ends here! This stunning three-bedroom freehold townhome offers modern style, spacious living, and unbeatable convenience - just minutes from West Waterloo’s best amenities. Step inside the bright and welcoming foyer and feel right at home. The open-concept main floor is both functional and stylish, featuring a sleek modern kitchen and ample storage. The dining area flows seamlessly into the inviting living room, where warm textured flooring and large windows create the perfect space to relax and unwind. A chic powder room is tucked away for added convenience. Upstairs, discover three large bedrooms, including a primary retreat with an extra-large walk-in closet. The four-piece upstairs bathrooms are beautifully designed with gorgeous vanities and a tub/shower combo. Outside, your private, fully fenced backyard awaits that’s perfect for summer barbecues and entertaining. This is an incredible opportunity to settle in just in time for summer. Don't miss out on this move-in-ready gem! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-06T00:51:19.567109+00:00"
+"Directions": "Laurelwood Dr. and Erbsville"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2140701"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T23:30:52Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T23:30:52Z"
+"Stories": "2.0"
+"StreetName": "VIRGINIA CREEPER"
+"StreetNumber": "517"
+"StreetSuffix": "Street"
+"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/29864480/517-virginia-creeper-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2900
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1457
+"OriginalEntryTimestamp": "2026-06-05T23:30:52.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1392438"
+"ListOfficeNationalAssociationId": "1325206"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29864480')"
+"ID": "1502312"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
+post_id: "1496954"
+post_author: 1
+"ListingKey": "29855710"
+"ListingId": "X13242290"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T20:40:37Z"
+"RFModificationTimestamp": "2026-06-04T20:58:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "104 - 778 LAURELWOOD DRIVE, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.598809
1 => 43.471162
]
+"Latitude": 43.471162
+"Longitude": -80.598809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 778 Laurelwood Drive, Unit 104 - a beautiful 2-bedroom, 2-bathroom condo offering over 1,000 sq. ft. of modern living space. Complete with 2 PARKING SPACES (1 underground, 1 surface) and a storage LOCKER, this sought-after unit features a private walk-out patio, newer in-suite washer and dryer, and access to fantastic building amenities including a party room and resident lounge. Located in a quiet Waterloo neighbourhood close to trails, shopping, and everyday conveniences, this is an excellent opportunity for professionals seeking comfort, style, and convenience. Don't miss your opportunity to call this exceptional condo home! (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T20:58:54.354167+00:00"
+"Directions": "Bearinger Rd. To Laurelwood Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088761"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-04T19:34:16Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T20:34:10Z"
+"StreetName": "Laurelwood"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29855710/104-778-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-04T19:34:15.96Z"
+"ListAgentNationalAssociationId": "1362076"
+"ListOfficeNationalAssociationId": "1002051"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29855710')"
+"ID": "1496954"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1474399"
+post_author: 1
+"ListingKey": "29825137"
+"ListingId": "40833683"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:50:37Z"
+"RFModificationTimestamp": "2026-06-09T23:51:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4009.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "559 BALSAM POPLAR Street, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.5996819
1 => 43.4574794
]
+"Latitude": 43.4574794
+"Longitude": -80.5996819
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A nearly brand-new, fully finished top-to-bottom detached house featuring 5 bedrooms, 5 bathrooms, and a double garage in the highly sought-after Vista Hills community. Perfectly blending modern design, natural surroundings, and everyday convenience, this home is ideally located just minutes from shopping, dining, medical services, and all essential amenities—offering a lifestyle of comfort and connection. With nearly 4,000 sq. ft. of total living space, this impressive residence features 5 bedrooms, 5 bathrooms, and a spacious double-car garage. The fully above-grade basement offers excellent versatility and can be easily converted into a bright, self-contained one-bedroom suite—ideal for extended family or potential rental income. Designed for flexibility, each level includes oversized closets with the option to customize, even accommodating a future private elevator. The second floor boasts a stunning modern kitchen with an oversized island, breakfast seating, built-in wine fridge, sleek cabinetry, and ample workspace. It flows seamlessly into a warm living area with elegant hardwood flooring—perfect for entertaining or daily living. The adjoining family room features a stylish wet bar, custom cabinetry, premium finishes, and access to a private balcony filled with natural light. This level also includes a generously sized bedroom and 3-piece bath, ideal for guests or a home office. The third floor offers a private retreat with three spacious bedrooms, each with its own ensuite. An upper lounge provides additional living space, while the laundry room adds everyday convenience. Energy-efficient features include a dual-fuel furnace, air-source heat pump, and ERV system. With 9-foot ceilings and premium finishes throughout, this home delivers refined, modern living at its finest. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T19:31:47.426338+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"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-05-29T17:13:44Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:40:47Z"
+"Stories": "3.0"
+"StreetName": "BALSAM POPLAR"
+"StreetNumber": "559"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29825137/559-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 4000
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 3209
+"BelowGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-05-29T17:11:11.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825137')"
+"ID": "1474399"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1466567"
+post_author: 1
+"ListingKey": "29814940"
+"ListingId": "X13204796"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-27T22:00:26Z"
+"RFModificationTimestamp": "2026-05-27T22:40:00Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "600 WINTERBERRY AVENUE, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.599039
1 => 43.4721
]
+"Latitude": 43.4721
+"Longitude": -80.599039
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the charming Laurelwood Neighborhood, a beloved community in Waterloo that renters like you will adore. This fantastic house is perfect for creating a cozy home for you and your loved ones. With its open-concept design and two-story layout, you'll find it spacious and inviting. Situated in a prime location with excellent schools nearby, including Abraham Public School and Laurel Heights Secondary School, this home offers convenience and quality education for your family. Plus, you'll love being within walking distance of the serene Laurel Creek Conservation Area and its beautiful trails, as well as nearby grocery stores and restaurants. For added convenience, you're just minutes away from major retailers like Costco and T&T, as well as the prestigious University of Waterloo and Wilfrid Laurier University. Don't miss out on the opportunity to make this wonderful house your new home in the heart of Laurelwood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T22:39:57.386310+00:00"
+"Directions": "Cross Streets: LAURELWOOD DR/ WIDEMAN DR. ** Directions: Laurelwood and Wideman Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1968060"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T21:54:53Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-27T21:54:53Z"
+"Stories": "2.0"
+"StreetName": "Winterberry"
+"StreetNumber": "600"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29814940/600-winterberry-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2988
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-27T21:54:53.85Z"
+"ListAgentNationalAssociationId": "1255866"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29814940')"
+"ID": "1466567"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "1459350"
+post_author: 1
+"ListingKey": "29803638"
+"ListingId": "40832347"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:50:32Z"
+"RFModificationTimestamp": "2026-06-09T23:52:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 3021.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "708 AUTUMN WILLOW Drive Unit# LOWER, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.59952
1 => 43.45697
]
+"Latitude": 43.45697
+"Longitude": -80.59952
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked away on a quiet street in one of Waterloo’s newest communities, this brand-new 1-bedroom basement apartment offers the perfect blend of comfort, style, and convenience. Be the very first to call this beautifully finished space home! Thoughtfully designed with a bright open-concept layout, modern finishes, and a sleek contemporary kitchen, this unit feels warm, inviting, and anything but your typical basement apartment. Enjoy the convenience of a private entrance, in-suite laundry, spacious living area, and plenty of storage throughout. Located close to parks, walking trails, shopping, transit, schools, and quick highway access. Includes utilities and 1 parking space (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-26T01:37:29.157177+00:00"
+"Directions": "Columbia St W > Sundew Dr > Balsam Poplar St > Autumn Willow Drive"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246055"
+"ListOfficeKey": "156376"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-26T15:42:18Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:41:43Z"
+"Stories": "2.0"
+"StreetName": "AUTUMN WILLOW"
+"StreetNumber": "708"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29803638/708-autumn-willow-drive-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1700
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2456
+"BelowGradeFinishedArea": 565
+"OriginalEntryTimestamp": "2026-05-26T00:31:25.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1484873"
+"ListOfficeNationalAssociationId": "1003925"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29803638')"
+"ID": "1459350"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]