array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30053492 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1640662"
+post_author: 1
+"ListingKey": "30053492"
+"ListingId": "40849408"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T19:20:07Z"
+"RFModificationTimestamp": "2026-07-19T19:22:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1607.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T4"
+"UnparsedAddress": "379 HAVENDALE Crescent, Waterloo, Ontario N2T2T4"
+"Coordinates": array:2 [
0 => -80.5827649
1 => 43.4709381
]
+"Latitude": 43.4709381
+"Longitude": -80.5827649
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** NEW VINYL FLOORING WILL REPLACE ALL CARPETING AND THE ENTIRE HOME WILL BE FRESHLY PAINTED*** Located in the heart of the highly sought-after Laurelwood community and top-rated school district, this bright and well-maintained 3-bedroom, 3-bathroom detached home offers the perfect combination of comfort and convenience. The open-concept main floor features a spacious living area with a sunken great room, while the second level boasts a large primary bedroom, two generously sized bedrooms, and the convenience of second-floor laundry. The finished basement includes a large recreation room and a 2-piece bathroom, providing additional living space for the family. Enjoy the fully fenced backyard with a deck and storage shed. Ideally located close to top-ranked schools, the University of Waterloo, RIM Park, Laurel Creek Conservation Area, shopping, and transit. Children may attend Laurelwood Public School or St. Nicholas Catholic School. ALL UPDATES WILL BE COMPLETED PRIOR TO AUGUST OCCUPANCY. Available August 2026. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-19T19:22:48.117759+00:00"
+"Directions": "Beaver Creek Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-07-19T19:11:07Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T19:18:02Z"
+"Stories": "2.0"
+"StreetName": "HAVENDALE"
+"StreetNumber": "379"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1688748975"
"RoomType" => "Laundry room"
"ListingId" => "40849408"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.84Z"
]
1 => array:11 [
"RoomKey" => "1688748976"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849408"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.84Z"
]
2 => array:11 [
"RoomKey" => "1688748977"
"RoomType" => "Bedroom"
"ListingId" => "40849408"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
3 => array:11 [
"RoomKey" => "1688748978"
"RoomType" => "Bedroom"
"ListingId" => "40849408"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
4 => array:11 [
"RoomKey" => "1688748979"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849408"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
5 => array:11 [
"RoomKey" => "1688748980"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849408"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
6 => array:11 [
"RoomKey" => "1688748981"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40849408"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
7 => array:11 [
"RoomKey" => "1688748982"
"RoomType" => "Living room"
"ListingId" => "40849408"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
8 => array:11 [
"RoomKey" => "1688748983"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849408"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
9 => array:11 [
"RoomKey" => "1688748984"
"RoomType" => "Recreation room"
"ListingId" => "40849408"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30053492"
"RoomLength" => null
"RoomDimensions" => "24'0'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T19:18:02.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30053492/379-havendale-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1607
+"OriginalEntryTimestamp": "2026-07-19T18:58:56.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30053492_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/841a0f32d6ad9a33b8bdef4c6b2e77de.webp"
"MediaSize" => 153015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-841a0f32d6ad9a33b8bdef4c6b2e77de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:05.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30053492_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/5e8beec398684ab3fce077185dcb916f.webp"
"MediaSize" => 211115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-5e8beec398684ab3fce077185dcb916f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a teal garage door, a covered porch with white railing, and a dark green entry door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30053492_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/1c51062302acc7328940217821b71e15.webp"
"MediaSize" => 73735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-1c51062302acc7328940217821b71e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tiled entryway featuring a staircase with wood banister and carpeted treads, leading to an open-concept area with glass patio doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30053492_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/075bf6210b099d2c2f1e05c9c9a54749.webp"
"MediaSize" => 81747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-075bf6210b099d2c2f1e05c9c9a54749.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring dark wood-finish cabinetry, stainless steel dishwasher, and an island with a sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30053492_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/15bcea2de59983f68d3834858599d3fe.webp"
"MediaSize" => 82416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-15bcea2de59983f68d3834858599d3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive main level featuring wood-finish flooring and an open-concept design"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30053492_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/a750ffcc9ccbd52ea1cb747b44939cb7.webp"
"MediaSize" => 99064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-a750ffcc9ccbd52ea1cb747b44939cb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior featuring wood-finish flooring, a built-in fireplace with white mantel and cabinetry, and sliding glass patio doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30053492_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/29ce537e68c536588e60d0c1ba3a1e6e.webp"
"MediaSize" => 102694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-29ce537e68c536588e60d0c1ba3a1e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a built-in fireplace with white mantel and cabinetry, and sliding glass doors to the exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30053492_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/4e8c3348781ff7a1340f7163ae49f353.webp"
"MediaSize" => 80661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-4e8c3348781ff7a1340f7163ae49f353.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring rich wood-finish cabinetry, white countertops, and white appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30053492_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/ad892c907e547683dc29486da2aa0a02.webp"
"MediaSize" => 74309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-ad892c907e547683dc29486da2aa0a02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single window, a built-in vanity with a countertop, an integrated sink, and a wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30053492_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/3b9828ce0c0c55b5d9d3f0f4ddf7a42c.webp"
"MediaSize" => 102484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-3b9828ce0c0c55b5d9d3f0f4ddf7a42c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring multiple window units, vaulted ceilings, and a central chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30053492_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/8ef10e03864c6adc872fb6a360601e0e.webp"
"MediaSize" => 85821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-8ef10e03864c6adc872fb6a360601e0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring a vaulted ceiling with a semi-flush mount light fixture, multiple windows, and a panel door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30053492_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/757e80b4d265dd62a42ddcbeccbc68fe.webp"
"MediaSize" => 76439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-757e80b4d265dd62a42ddcbeccbc68fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white countertop and dark cabinetry, overhead vanity lighting, a large wall-mounted mirror, a toilet, and a window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30053492_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/841ea942afe139a60f5deb06863d213d.webp"
"MediaSize" => 57625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-841ea942afe139a60f5deb06863d213d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area featuring light-colored flooring, a utility sink, and a high window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30053492_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/a28e2c0288aeb2bd4d352715516f7c8c.webp"
"MediaSize" => 91728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-a28e2c0288aeb2bd4d352715516f7c8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a single window and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:02.9Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30053492_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/c9ac0e98098af1f3a1203458849a12a5.webp"
"MediaSize" => 95904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-c9ac0e98098af1f3a1203458849a12a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a single window and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30053492_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/0754a7909501ad67fabe4c623d18571e.webp"
"MediaSize" => 77470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-0754a7909501ad67fabe4c623d18571e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.8Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30053492_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/005475e961a2e4a2100cd8d62c32b9d6.webp"
"MediaSize" => 70119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-005475e961a2e4a2100cd8d62c32b9d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light grey walls, white baseboards, and two overhead flush-mount light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30053492_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/31b7d89d7f727df756a904094a2bd584.webp"
"MediaSize" => 86466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-31b7d89d7f727df756a904094a2bd584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30053492_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/a5b1f0e1119dbd4213c66616e776df0e.webp"
"MediaSize" => 76066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-a5b1f0e1119dbd4213c66616e776df0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a single basin sink, framed mirror, and a white commode"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:01.81Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30053492_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053492/de505be7787fd94fc6bb4690a378eb99.webp"
"MediaSize" => 60595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053492/thumbnail-de505be7787fd94fc6bb4690a378eb99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and a wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849408"
"ResourceRecordKey" => "30053492"
"ModificationTimestamp" => "2026-07-19T19:11:07.7Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30053492')"
+"ID": "1640662"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Cache Key: 9bbe3c07d0ccc9e147d1404cbf124735205552867fdeb9428976d2b213446618" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24673
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24925
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('295659')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2050676" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24933
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30053492'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30053492' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+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 '30053492' 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.5827649 43.4709381)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25367
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1643238"
+post_author: 1
+"ListingKey": "30057921"
+"ListingId": "40849786"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T03:05:19Z"
+"RFModificationTimestamp": "2026-07-21T03:08:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L1"
+"UnparsedAddress": "365 BENNINGTON Gate Unit# 13, Waterloo, Ontario N2T2L1"
+"Coordinates": array:2 [
0 => -80.5756639
1 => 43.4640033
]
+"Latitude": 43.4640033
+"Longitude": -80.5756639
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional living in prestigious Waterloo Upper Beechwood community with this spacious 2+1 bedroom, 3.5 bathroom townhome condo. $2600 plus with flexible move in date extending as late as September 1, 2026. Offering 1,500 sq ft of well-appointed living space, plus an additional 512 sq ft in the finished walk out basement. This home combines style, functionality, and quiet living. The bright and open-concept main level features an eat-in kitchen, dining area, and a comfortable living space; perfect for family gatherings and entertaining. The upper level includes a generous primary bedroom with an en-suite bathroom and ample closet space, bonus living area for a home office or family room, along with a second bedroom and full bath. The finished walk out basement offers endless possibilities, featuring a versatile layout ideal for an additional bedroom, a home gym, or a recreational room - complete with a 3-piece bathroom for added convenience. With an attached garage, a cozy backyard for outdoor relaxation, and access to a complex pool, this home provides everything you need for a balanced lifestyle. Situated in the desirable Upper Beechwood community, you'll enjoy the charm of this well-established neighborhood, with nearby parks, great schools, shopping, and easy access to Waterloo's amenities. This townhome is perfect for families, professionals, and down-sizers seeking comfort, convenience, and community living. Don't miss your chance to make this sought-after address your new home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T22:31:22.793232+00:00"
+"Directions": "Columbia St. W. to Bennington Gate"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T22:12:20Z"
+"PhotosCount": 20
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T02:58:46Z"
+"Stories": "2.0"
+"StreetName": "BENNINGTON"
+"StreetNumber": "365"
+"StreetSuffix": "Gate"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1689760383"
"RoomType" => "Laundry room"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
1 => array:11 [
"RoomKey" => "1689760384"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
2 => array:11 [
"RoomKey" => "1689760385"
"RoomType" => "Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
3 => array:11 [
"RoomKey" => "1689760386"
"RoomType" => "Recreation room"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
4 => array:11 [
"RoomKey" => "1689760387"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
5 => array:11 [
"RoomKey" => "1689760388"
"RoomType" => "Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
6 => array:11 [
"RoomKey" => "1689760389"
"RoomType" => "Full bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
7 => array:11 [
"RoomKey" => "1689760390"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
8 => array:11 [
"RoomKey" => "1689760391"
"RoomType" => "Family room"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
9 => array:11 [
"RoomKey" => "1689760392"
"RoomType" => "Dinette"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
10 => array:11 [
"RoomKey" => "1689760393"
"RoomType" => "Kitchen"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
11 => array:11 [
"RoomKey" => "1689760394"
"RoomType" => "Living room"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
12 => array:11 [
"RoomKey" => "1689760395"
"RoomType" => "Dining room"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
13 => array:11 [
"RoomKey" => "1689760396"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30057921/365-bennington-gate-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 2060
+"BelowGradeFinishedArea": 512
+"OriginalEntryTimestamp": "2026-07-20T22:08:34.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30057921_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/16b7af1c0390686eca52ee36d6ca5c7b.webp"
"MediaSize" => 126306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-16b7af1c0390686eca52ee36d6ca5c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level exterior featuring light-toned brick and horizontal siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30057921_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/2b5f997b4ec2555e1d21e83da799553b.webp"
"MediaSize" => 110795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-2b5f997b4ec2555e1d21e83da799553b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story townhome featuring a brick and siding exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30057921_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/d41b101cecbbfd9a565ad0f25234b609.webp"
"MediaSize" => 45672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-d41b101cecbbfd9a565ad0f25234b609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white paneled door with brass hardware, a main entry door with leaded glass, a sidelight window, and white tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.12Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30057921_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/12d9c636f3f0558e00248a954a9ece05.webp"
"MediaSize" => 49671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-12d9c636f3f0558e00248a954a9ece05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring abundant white cabinetry with round wooden knobs, light-toned wood-finish flooring, and white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30057921_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/dcdd3f7112ce4de8806be436a37a487d.webp"
"MediaSize" => 42182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-dcdd3f7112ce4de8806be436a37a487d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White tiled flooring with a toilet and a wall-mounted shelving unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30057921_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/bd27fd2eaa3336fc6a74e1559fff400a.webp"
"MediaSize" => 45235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-bd27fd2eaa3336fc6a74e1559fff400a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30057921_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/6709ae69ccb7035381c8fe4b726742ed.webp"
"MediaSize" => 51755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-6709ae69ccb7035381c8fe4b726742ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30057921_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/9e11693a3da6ad380e74e31e4f00ee8a.webp"
"MediaSize" => 50399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-9e11693a3da6ad380e74e31e4f00ee8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring throughout the entryway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:20.3Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30057921_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/0afba0435c44931d131b2cef85b6b9e2.webp"
"MediaSize" => 55589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-0afba0435c44931d131b2cef85b6b9e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned wall-to-wall carpeting throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.12Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30057921_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/55d62ce4b39cccef363457d536a9116e.webp"
"MediaSize" => 59459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-55d62ce4b39cccef363457d536a9116e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring wood-finish flooring, a contemporary vanity with a white countertop and integrated sink, matte black faucet, and a bathtub with tiled surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:20.3Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30057921_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/e2e56d3d20e9af7d53c618e075394079.webp"
"MediaSize" => 75955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-e2e56d3d20e9af7d53c618e075394079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring neutral carpeting, a large window, white walls, a ceiling fan, and baseboard trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:19.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30057921_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/fe76931e5d5cbe760930ad280f7a3583.webp"
"MediaSize" => 48169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-fe76931e5d5cbe760930ad280f7a3583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light-colored paneled walls, recessed lighting, and a baseboard heating unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:19.89Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30057921_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/b59ed12494b79b588d40370318518013.webp"
"MediaSize" => 128144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-b59ed12494b79b588d40370318518013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring multiple large windows and a wooden deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:20.3Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30057921_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/d69c7d1d3b6ed342545ad9919b0924d3.webp"
"MediaSize" => 207531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-d69c7d1d3b6ed342545ad9919b0924d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick paver patio with a mature tree, privacy fencing, and a grassy area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30057921_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/927190c113e5e6944df2556a731e436d.webp"
"MediaSize" => 233679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-927190c113e5e6944df2556a731e436d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn and mature trees with vibrant fall foliage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30057921_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/0b54903373cd8852b0c546fa966cde71.webp"
"MediaSize" => 178318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-0b54903373cd8852b0c546fa966cde71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:19.89Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30057921_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/81d242c71348f45ea030ba7460f7f2cf.webp"
"MediaSize" => 132446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-81d242c71348f45ea030ba7460f7f2cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Curved swimming pool with integrated spa and concrete surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30057921_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/33a58ff79e7c0ef245dfe7e366bf11e5.webp"
"MediaSize" => 45206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-33a58ff79e7c0ef245dfe7e366bf11e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30057921_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/b2f17d8300ddb7290154b9e0fab7b032.webp"
"MediaSize" => 44908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-b2f17d8300ddb7290154b9e0fab7b032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:20.3Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30057921_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/84326e818991c89810eff4b777ec0540.webp"
"MediaSize" => 45173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-84326e818991c89810eff4b777ec0540.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.11Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057921')"
+"ID": "1643238"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1637188"
+post_author: 1
+"ListingKey": "30033009"
+"ListingId": "40848205"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:06Z"
+"RFModificationTimestamp": "2026-07-17T21:00:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1560.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T3"
+"UnparsedAddress": "504 BLUE BEECH Boulevard Unit# B, Waterloo, Ontario N2V2T3"
+"Coordinates": array:2 [
0 => -80.5921619
1 => 43.4686678
]
+"Latitude": 43.4686678
+"Longitude": -80.5921619
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Most popular location with best schools, Mins to Abraham Erb and Laurel Hights high school. close to trails, playground and forest. Spacious semi with 4 bedrooms, finished from top to bottom. Open concept main floor, fully fenced rear yard with deck and pergola. On the bus routes, close to YMCA, shopping center, Library and Universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T21:00:42.220675+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T21:29:14Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:44Z"
+"Stories": "2.0"
+"StreetName": "BLUE BEECH"
+"StreetNumber": "504"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686994567"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.4Z"
]
1 => array:11 [
"RoomKey" => "1686994568"
"RoomType" => "Office"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
2 => array:11 [
"RoomKey" => "1686994569"
"RoomType" => "Den"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
3 => array:11 [
"RoomKey" => "1686994570"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
4 => array:11 [
"RoomKey" => "1686994571"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
5 => array:11 [
"RoomKey" => "1686994572"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
6 => array:11 [
"RoomKey" => "1686994573"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
7 => array:11 [
"RoomKey" => "1686994574"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 25'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
8 => array:11 [
"RoomKey" => "1686994575"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
9 => array:11 [
"RoomKey" => "1686994576"
"RoomType" => "Living room"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
10 => array:11 [
"RoomKey" => "1686994577"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30033009/504-blue-beech-boulevard-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2850
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1560
+"OriginalEntryTimestamp": "2026-07-14T21:29:14.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30033009_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/90ba1e6d53ac71ae8f5f1bf86e3c09ab.webp"
"MediaSize" => 148704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-90ba1e6d53ac71ae8f5f1bf86e3c09ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story exterior featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30033009_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/37d693d2f9ff6e7c189e7e803ce18e6d.webp"
"MediaSize" => 139755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-37d693d2f9ff6e7c189e7e803ce18e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30033009_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/8de40d8e06a81828a68a5b14f38001d0.webp"
"MediaSize" => 51787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-8de40d8e06a81828a68a5b14f38001d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30033009_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/4dbdf43997230825d6f4bc2970a04ce0.webp"
"MediaSize" => 37419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-4dbdf43997230825d6f4bc2970a04ce0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30033009_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/96e90abbf5456257f39f57cf5b822fa6.webp"
"MediaSize" => 58606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-96e90abbf5456257f39f57cf5b822fa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring ceramic tile flooring, neutral wall tones, and two paneled closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30033009_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/f905b238ef4456f1fac3182a9e492196.webp"
"MediaSize" => 70054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-f905b238ef4456f1fac3182a9e492196.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30033009_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/83f7ebc7a5810e18fda830d83f2d3cf9.webp"
"MediaSize" => 84875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-83f7ebc7a5810e18fda830d83f2d3cf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood cabinetry, white appliances, a double basin sink, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
…1
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30033009')"
+"ID": "1637188"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1637223"
+post_author: 1
+"ListingKey": "30043864"
+"ListingId": "40848815"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:15Z"
+"RFModificationTimestamp": "2026-07-17T20:52:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5956476
1 => 43.4555934
]
+"Latitude": 43.4555934
+"Longitude": -80.5956476
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:52:43.451105+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:29:28Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:36Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043864/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-16T19:29:28.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043864')"
+"ID": "1637223"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1627218"
+post_author: 1
+"ListingKey": "30035197"
+"ListingId": "X13565240"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T15:20:06Z"
+"RFModificationTimestamp": "2026-07-15T17:25:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T3"
+"UnparsedAddress": "414 HAVENDALE CRESCENT, Waterloo, Ontario N2T2T3"
+"Coordinates": array:2 [
0 => -80.581405
1 => 43.470069
]
+"Latitude": 43.470069
+"Longitude": -80.581405
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 414 Havendale Crescent, a beautifully upgraded 2-storey home located on a quiet crescent in one of Waterloo's most desirable family neighbourhoods. Sitting on a rare 31.83x164.7 ft lot, this home offers a perfect blend of style, function, and space. The main floor features a dedicated office, an open-concept living and dining area, and a modern kitchen with stainless steel appliances, upgraded cabinetry with a white and wood finish, and a breakfast area overlooking the backyard. Upstairs, you'll find three spacious bedrooms and two full bathrooms, including a large primary bedroom with serene views of the backyard. A standout feature is the elevated family room above the garage, complete with a cozy fireplace perfect for movie nights or relaxing with the family. The fully finished basement adds incredible living space, with a huge recreation room ideal for entertaining, a secondary office or guest room (newly added), and a separate laundry room. Step outside to enjoy the oversized backyard, featuring a large deck and a private hot tub perfect for summer entertaining or year-round enjoyment. This home is move-in ready and perfect for growing families. Located in a friendly, well-established community with excellent school zones, including Laurelwood Public School and Laurel Heights Secondary School (Sir John A. Macdonald Secondary School), both known for strong academic performance. Close to parks, walking trails, shopping, and transit. Don't miss this opportunity to lease a spacious, turn-key home in one of Waterloo's most family-friendly neighbourhoods. Book your private tour today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T17:25:49.947428+00:00"
+"Directions": "Cross Streets: Erbsville Rd/Laurelwood Dr. ** Directions: Turn north onto Beaver Creek Rd from Willow Wood DrTurn north onto Beaver Creek Rd from Willow Wood Dr."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085514"
+"ListOfficeKey": "292919"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Flat site"
]
+"LotSizeDimensions": "31.8 x 164.7 FT ; At backside"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T14:09:39Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T15:10:46Z"
+"Stories": "2.0"
+"StreetName": "Havendale"
+"StreetNumber": "414"
+"StreetSuffix": "Crescent"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/414_havendale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035197/414-havendale-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2063353"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292919"
+"GeocodeManualYN": false
+"TotalActualRent": 3499
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.9
+"OriginalEntryTimestamp": "2026-07-15T14:09:39.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1358915"
+"ListOfficeNationalAssociationId": "1419411"
+"CoListAgentNationalAssociationId": "1338399"
+"CoListOfficeNationalAssociationId": "1419411"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035197')"
+"ID": "1627218"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1616139"
+post_author: 1
+"ListingKey": "30021051"
+"ListingId": "X13552080"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T04:10:00Z"
+"RFModificationTimestamp": "2026-07-19T04:18:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as afitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T04:47:41.976622+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Keats way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T05:37:02Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T04:03:00Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021051/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-11T01:34:00.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021051')"
+"ID": "1616139"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1610972"
+post_author: 1
+"ListingKey": "30013604"
+"ListingId": "X13545338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T19:20:09Z"
+"RFModificationTimestamp": "2026-07-20T19:23:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "UNIT 21 - 350 ERBSVILLE ROAD, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.578721
1 => 43.461152
]
+"Latitude": 43.461152
+"Longitude": -80.578721
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*** Additional Listing Details - Click Brochure Link *** Welcome to this Exquisite and Serene 3-bedroom Fully Licensed rental townhome, located in the highly desired Upper Beechwood West!Location: #21-350 Erbsville Rd. Waterloo. Virtual Tour: https://youtu.be/nQvJ3BmpVL8. Features: 3 large bedroom, Master bedroom with ensuite 2-piece private washroom. Separated dining room and living room, Living room patio door to the Upper deck with green view. Fully finished basement all above ground with large window and a Large Storage room, walk out to the second deck and greenbelt. Steps to the playground, trails, bus stops. visitors parking in front of the house. Bus route #13 and #31 taking you directly to the University of Waterloo, the Sobeys Shopping plaza, Food basics, the Boardwalk, Golf courses, gyms, Conestoga Mall, Canadian Tire, Costco. School buses are in front of the compound's door. Mary Johnson elementary school, Sir John A Macdonald secondary school. Enjoy having your morning coffee or BBQ dinner on the choice of 2 back decks which look out onto the green and watch the four seasons passing by... A truly country living in the city! Have a playground park which is just meters away for the children, walk off the stress after work, or have a morning run in the back wood trail... All possible with this family friendly townhome. Available: August 1st. 2026. Price: $2800 Plus Utilities *Non-Smoking *Credit and reference check Required. *Tenant Insurance is Mandatory and Must Be Provided Before Move-in*Call today with a brief introduction to book a viewing! (id:62650)"
+"Appliances": array:2 [
0 => "Oven - Built-In"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "240"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T23:16:07.985296+00:00"
+"Directions": "Clumbia Street & Erbsville Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987594"
+"ListOfficeKey": "296503"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T20:09:54Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T19:12:58Z"
+"Stories": "2.0"
+"StreetName": "Erbsville"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013604/unit-21-350-erbsville-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Green Brick Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T20:09:54.28Z"
+"ListAgentNationalAssociationId": "1271850"
+"ListOfficeNationalAssociationId": "1459260"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013604')"
+"ID": "1610972"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1607907"
+post_author: 1
+"ListingKey": "30009704"
+"ListingId": "X13541548"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T12:15:06Z"
+"RFModificationTimestamp": "2026-07-09T13:59:20Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "613 - 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": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 613 at 778 Laurelwood Dr, this spacious, professionally cleaned corner unit offering approximately 1,186 sq ft of well-designed living space in the highly desirable Laurelwood community. This carpet-free, fully furnished 2-bedroom, 2-bathroom condo features a functional split-bedroom layout, ideal for families, professionals, or roommates. The open-concept kitchen offers stainless steel appliances, abundant cabinetry, generous counter space, and a large island overlooking the bright living area. The spacious primary bedroom features a walk-in closet and private ensuite, while the second bedroom is conveniently located beside the second full bathroom. Enjoy in-suite laundry, a private balcony, and one surface parking space. The unit is offered fully furnished with the furniture shown in the listing photos. Residents have access to excellent building amenities including a party room, theatre room, games room, conference room, and BBQ area. Ideally located within the top-rated Laurelwood school district, just minutes to the University of Waterloo, Wilfrid Laurier University, The Boardwalk, shopping, restaurants, parks, trails, Laurel Creek Conservation Area, and public transit. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:58:37.351523+00:00"
+"Directions": "Cross Streets: Laurelwood Drive. ** Directions: Erbsville Road to Laurelwood Drive."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T12:08:01Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T12:08:01Z"
+"StreetName": "Laurelwood"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009704/613-778-laurelwood-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T12:08:01.49Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009704')"
+"ID": "1607907"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
+post_id: "1600663"
+post_author: 1
+"ListingKey": "30000343"
+"ListingId": "40846027"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:55:15Z"
+"RFModificationTimestamp": "2026-07-07T18:49:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N2"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 206, Waterloo, Ontario N2V2N2"
+"Coordinates": array:2 [
0 => -80.598166
1 => 43.4707566
]
+"Latitude": 43.4707566
+"Longitude": -80.598166
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 206-776 Laurelwood Drive, located in the heart of the highly sought-after Laurelwood community and top-rated school district! This bright and stylish 2-bedroom, 2-bathroom condo features an open-concept layout with a spacious kitchen offering stainless steel appliances, abundant counter space, a large island with breakfast bar, and extra cabinetry. The primary bedroom includes a walk-in closet and private ensuite, while the second bedroom is thoughtfully located on the opposite side for added privacy. Enjoy the rare benefit of a ground-level walk-out patio backing onto green space, providing exceptional privacy and easy outdoor access. Complete with in-suite laundry, one surface parking space, and a storage locker, residents also enjoy amenities including a party room, theatre, lounge/library, and BBQ pavilion. Ideally located close to the University of Waterloo, Uptown Waterloo, The Boardwalk, shopping, restaurants, parks, trails, and Laurel Creek Conservation Area. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "414.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T18:49:24.232192+00:00"
+"Directions": "Erbsville to Laurelwood Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
3 => "Shared Driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-07T17:48:31Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:48:31Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30000343/776-laurelwood-drive-unit-206-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-07T17:48:31.36Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:26 [
0 => array:13 [ …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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000343')"
+"ID": "1600663"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1592160"
+post_author: 1
+"ListingKey": "29988324"
+"ListingId": "40845172"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T20:20:07Z"
+"RFModificationTimestamp": "2026-07-06T20:33:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 773.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E9"
+"UnparsedAddress": "244 LADYSLIPPER Drive Unit# LOWER, Waterloo, Ontario N2V0E9"
+"Coordinates": array:2 [
0 => -80.5918946
1 => 43.455862
]
+"Latitude": 43.455862
+"Longitude": -80.5918946
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into modern living with this professionally finished (2025) 2-bedroom, 1-bathroom home. The stylish kitchen features beautiful cabinetry, elegant quartz countertops, abundant storage, stainless steel appliances, and a sleek over-the-range microwave. The spacious layout is filled with natural light thanks to large windows throughout, while window coverings (curtains) are included for added comfort and privacy. Durable subflooring has been installed throughout the unit, adding to its quality and longevity. Enjoy the convenience of a private garage with remote control access, plus even more storage space to keep everything organized. Located in a fantastic area of Waterloo, this home offers incredible convenience. You're just 5 minutes from Costco and other essential amenities. Enjoy added privacy with no backyard neighbours, and families will appreciate being just steps from great schools. Bright, stylish, and move-in ready, this is the perfect place to call home. Bonus: A 2% discount is available for tenants (terms and conditions apply). (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T00:51:14.027472+00:00"
+"Directions": "Columbia St W / Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190750"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T20:12:26Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T20:12:26Z"
+"Stories": "2.0"
+"StreetName": "LADYSLIPPER"
+"StreetNumber": "244"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29988324/244-ladyslipper-drive-unit-lower-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2050
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 773
+"OriginalEntryTimestamp": "2026-07-03T23:48:10.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1439796"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:17 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988324')"
+"ID": "1592160"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 16
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]