array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29626072 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1333367"
+post_author: 1
+"ListingKey": "29626072"
+"ListingId": "40822008"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:56:06Z"
+"RFModificationTimestamp": "2026-06-10T00:07:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J6"
+"UnparsedAddress": "536 BEAVER CREEK Crescent, Waterloo, Ontario N2V2J6"
+"Coordinates": array:2 [
0 => -80.5817966
1 => 43.4731455
]
+"Latitude": 43.4731455
+"Longitude": -80.5817966
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Unique opportunity short term lease from July 1 to September 30, 2026. Main and Second level included. Utilities included! 2 Bedrooms. 2 bathrooms Primary ensuite and walk in closet. Fully furnished. Beautifully maintained. Great room featuring gas fireplace, kitchen and dining area. Island kitchen, stainless steel appliances. 2nd bedroom vaulted ceiling. Second floor laundry closet with side by side laundry appliances. Blinds throughout. Use of one parking space outside, deck with BBQ provided. Main and Upper floor. Private entrance to both suites. Lower level occupied by quiet Senior who looks after the lawn. Tenant provides their own linens and towels and personal care items. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Cable TV"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-19T13:58:52.438147+00:00"
+"Directions": "Off Laurelwood Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563463"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-04-21T15:42:32Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:47:31Z"
+"Stories": "2.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "536"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5220"
+"View": "Unobstructed Water View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1655984266"
"RoomType" => "3pc Bathroom"
"ListingId" => "40822008"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "411' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
1 => array:11 [
"RoomKey" => "1655984267"
"RoomType" => "Full bathroom"
"ListingId" => "40822008"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
2 => array:11 [
"RoomKey" => "1655984268"
"RoomType" => "Bedroom"
"ListingId" => "40822008"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
3 => array:11 [
"RoomKey" => "1655984269"
"RoomType" => "Primary Bedroom"
"ListingId" => "40822008"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
4 => array:11 [
"RoomKey" => "1655984270"
"RoomType" => "2pc Bathroom"
"ListingId" => "40822008"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "2'5'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
5 => array:11 [
"RoomKey" => "1655984271"
"RoomType" => "Great room"
"ListingId" => "40822008"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
6 => array:11 [
"RoomKey" => "1655984272"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40822008"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "6'8'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
7 => array:11 [
"RoomKey" => "1655984273"
"RoomType" => "Foyer"
"ListingId" => "40822008"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29626072"
"RoomLength" => null
"RoomDimensions" => "6'10'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:47:31.12Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29626072/536-beaver-creek-crescent-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2400
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1600
+"OriginalEntryTimestamp": "2026-04-19T11:59:09.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1070265"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6617489665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/52c10bffef37ed2cc86333632a41af2d.webp"
"MediaSize" => 52435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-52c10bffef37ed2cc86333632a41af2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features a brick and siding exterior with a dark shingled roof, a white garage door, and an asphalt driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6617489672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/8f852623038189ed1f32f43253d1f9e0.webp"
"MediaSize" => 79258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-8f852623038189ed1f32f43253d1f9e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features a brick exterior with an attached garage and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6617489679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/53f484225308513df8b05e5983d00b1f.webp"
"MediaSize" => 104604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-53f484225308513df8b05e5983d00b1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features a well-maintained lawn, a winding stone pathway, and mature trees providing natural screening"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6617489687"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/53973ffb2d756356bb01523e471b7cf4.webp"
"MediaSize" => 96234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-53973ffb2d756356bb01523e471b7cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features a winding pathway, bordered by a well-maintained lawn and a decorative stone bed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.93Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6617489706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/183246710430286c954720720e760966.webp"
"MediaSize" => 184094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-183246710430286c954720720e760966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enjoy scenic water views from the property, featuring a tranquil pond and surrounding greenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6617489709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/e8e0bad6f8df300a3993e65fdee04fe8.webp"
"MediaSize" => 109259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-e8e0bad6f8df300a3993e65fdee04fe8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The kitchen features dark wood flooring, grey cabinetry, a patterned backsplash, and stainless steel appliances including a refrigerator, dishwasher, and range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6617489727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/34b68dea919f727fc1b817671f458210.webp"
"MediaSize" => 118701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-34b68dea919f727fc1b817671f458210.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features an open-concept living area with dark wood flooring, recessed lighting, and a modern kitchen equipped with stainless steel appliances and dark cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6617489759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/e3815d3aa89be51c26a0c2b886933346.webp"
"MediaSize" => 79900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-e3815d3aa89be51c26a0c2b886933346.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features hardwood floors throughout the main living areas"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6617489793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/66cd959d888f32e9da96fddfd48137cb.webp"
"MediaSize" => 71007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-66cd959d888f32e9da96fddfd48137cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This interior features rich, dark wood-look flooring throughout the main living areas"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.94Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6617489824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/3c87772394601f58b69c40bdd1ac808b.webp"
"MediaSize" => 65555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-3c87772394601f58b69c40bdd1ac808b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6617489865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/5772541f68a3ebe86fb6337a51c08b43.webp"
"MediaSize" => 73627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-5772541f68a3ebe86fb6337a51c08b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept living area featuring dark hardwood floors, a kitchen with stainless steel appliances, and an island with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6617489881"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/7f95a70d7aaceed623168adcbc51712d.webp"
"MediaSize" => 90920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-7f95a70d7aaceed623168adcbc51712d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The kitchen features granite countertops, dark cabinetry, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6617489888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/bcfed617aa3b770b2181cfcecac2ccba.webp"
"MediaSize" => 61532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-bcfed617aa3b770b2181cfcecac2ccba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The entry foyer features dark wood flooring and a staircase with light wood banisters and carpeted treads"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6617489893"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/c029c68246680c3805fcf8529153acd6.webp"
"MediaSize" => 57965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-c029c68246680c3805fcf8529153acd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This property features a staircase with carpeted treads and light wood banisters, complemented by dark wood flooring in the landing areas"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:32.65Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6617489899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/345895283ca49100cf153c04e9bedc2f.webp"
"MediaSize" => 56279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-345895283ca49100cf153c04e9bedc2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairway featuring carpeting, wood railings, and a wall-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6617489903"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/bca94db9025d02bde2e6763d8ea940bb.webp"
"MediaSize" => 59856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-bca94db9025d02bde2e6763d8ea940bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This inviting room features dark hardwood flooring, a large window with horizontal blinds, and a ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.94Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6617489909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/f2141554b6b623af31e30feca0d21342.webp"
"MediaSize" => 52119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-f2141554b6b623af31e30feca0d21342.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The room features a ceiling light fixture, white sliding closet doors, and light brown painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6617489923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/b6fb6ce02edc7d40d705411db6599dae.webp"
"MediaSize" => 60545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-b6fb6ce02edc7d40d705411db6599dae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The room features dark wood flooring, a window with blinds, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.94Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6617489980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/3cb9a7e7741572b907dc6e81764f9bd6.webp"
"MediaSize" => 54999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-3cb9a7e7741572b907dc6e81764f9bd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This room features rich, dark hardwood flooring and warm beige walls, creating a welcoming atmosphere"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.93Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6617489981"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/89e0c3df03a912bdb601a84424b84010.webp"
"MediaSize" => 43007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-89e0c3df03a912bdb601a84424b84010.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This hallway features dark wood-look flooring and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.93Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6617490015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/1d40f51e435ac4bddcaf7e387d46ee79.webp"
"MediaSize" => 55743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-1d40f51e435ac4bddcaf7e387d46ee79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a double vanity with two rectangular sinks and black faucets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6617490018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/4b726077bc74f8a6eef85ef42a806d68.webp"
"MediaSize" => 47777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-4b726077bc74f8a6eef85ef42a806d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The bathroom features a modern vanity with an integrated sink and a window with a natural view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6617490046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/1567525ddb2b30a3538cc214262face1.webp"
"MediaSize" => 41561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-1567525ddb2b30a3538cc214262face1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This bathroom features a contemporary vanity with an integrated sink and a window providing natural light and exterior views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6617490083"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/2527d824bab322448e0028ef7ef2287e.webp"
"MediaSize" => 40931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-2527d824bab322448e0028ef7ef2287e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The bathroom features a spacious shower with glass doors and white marble-patterned wall tiles, complemented by a white toilet and a dark gray accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6617490094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/908a22fd98a82b5758fc4fdbb3eb89c5.webp"
"MediaSize" => 80087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-908a22fd98a82b5758fc4fdbb3eb89c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This room features dark wood flooring and light tan walls, with a white door providing access to another area of the property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6617490106"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/e399ce4a811b39159fccdaab19e3f44d.webp"
"MediaSize" => 81638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-e399ce4a811b39159fccdaab19e3f44d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in closet featuring built-in shelving and hanging rods"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6617490116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/62752ea6cca9bd73b20803ff1d036e7a.webp"
"MediaSize" => 33493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-62752ea6cca9bd73b20803ff1d036e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The bathroom features a modern vanity with a white countertop and a mirror, a white toilet, and white tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6617490134"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/543b8ed6d189b7d811777236047f9636.webp"
"MediaSize" => 50112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-543b8ed6d189b7d811777236047f9636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The bathroom features a spacious walk-in shower with clear glass sliding doors and white tiled walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.94Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6617490142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/248e9a2008d41dd33b18566ea49dba35.webp"
"MediaSize" => 45501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-248e9a2008d41dd33b18566ea49dba35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "This utility area features a white wire shelf, a wooden wall cabinet, and a water hookup"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6617490149"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29626072/40a6dea9fd1c32ba02e1766477fb5f92.webp"
"MediaSize" => 111745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29626072/thumbnail-40a6dea9fd1c32ba02e1766477fb5f92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The property features a wooden deck with railing, offering views of a serene, snow-covered landscape with mature trees and a body of water"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822008"
"ResourceRecordKey" => "29626072"
"ModificationTimestamp" => "2026-04-21T15:42:27.92Z"
]
]
+"DaysOnMarket": 59
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29626072')"
+"ID": "1333367"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24758
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563463" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24843
+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 '29626072'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25150
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29626072'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25166
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29626072' 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.5817966 43.4731455)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25219
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1537444"
+post_author: 1
+"ListingKey": "29912396"
+"ListingId": "40839543"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T21:00:09Z"
+"RFModificationTimestamp": "2026-06-16T22:53:28Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3217.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "603 SUNDEW Drive, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5977533
1 => 43.4599617
]
+"Latitude": 43.4599617
+"Longitude": -80.5977533
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 603 Sundew Drive, a beautifully maintained home in the highly desirable Vista Hills community. This impressive 2,267 sq. ft. residence offers the perfect blend of comfort, style, and convenience. The main level features 9-foot ceilings and a bright, open-concept design ideal for both everyday living and entertaining. The spacious great room is highlighted by a cozy fireplace and provides direct access to a large patio overlooking the private natural setting. A convenient main-floor laundry room offers interior access to the double-car garage. Upstairs, the generous primary suite serves as a relaxing retreat, complete with a walk-in closet and a luxurious 5-piece ensuite. Two additional well-sized bedrooms and a full main bathroom complete the upper level. The finished basement adds valuable living space, featuring a large recreation room, an additional bedroom, and a 3-piece bathroom—perfect for guests, a home office, or growing families. Outside, professionally landscaped grounds enhance the home's curb appeal and outdoor enjoyment. Ideally located close to shopping at Costco and The Boardwalk, medical facilities, parks, and public transit, with a short 12-minute bus ride to the universities. Families will also appreciate the proximity to Vista Hills Public School, making this an exceptional place to call home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:53:21.978725+00:00"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060436"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:51:17Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:51:17Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "603"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6768"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1660731641"
"RoomType" => "Living room"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "23'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.42Z"
]
1 => array:11 [
"RoomKey" => "1660731642"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.42Z"
]
2 => array:11 [
"RoomKey" => "1660731643"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.43Z"
]
3 => array:11 [
"RoomKey" => "1660731644"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.43Z"
]
4 => array:11 [
"RoomKey" => "1660731645"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.44Z"
]
5 => array:11 [
"RoomKey" => "1660731646"
"RoomType" => "Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.44Z"
]
6 => array:11 [
"RoomKey" => "1660731647"
"RoomType" => "Full bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
7 => array:11 [
"RoomKey" => "1660731648"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
8 => array:11 [
"RoomKey" => "1660731649"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.45Z"
]
9 => array:11 [
"RoomKey" => "1660731650"
"RoomType" => "Family room"
"ListingId" => "40839543"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.46Z"
]
10 => array:11 [
"RoomKey" => "1660731651"
"RoomType" => "Eat in kitchen"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.46Z"
]
11 => array:11 [
"RoomKey" => "1660731652"
"RoomType" => "Living room"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.47Z"
]
12 => array:11 [
"RoomKey" => "1660731653"
"RoomType" => "Dining room"
"ListingId" => "40839543"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912396"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T20:51:17.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912396/603-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2267
+"BelowGradeFinishedArea": 950
+"OriginalEntryTimestamp": "2026-06-16T20:51:17.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1335580"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912396_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/75568de8f926db79fd86878aada42862.webp"
"MediaSize" => 130605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-75568de8f926db79fd86878aada42862.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912396_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/184451c7e76a3fb4f52c377b4c07b060.webp"
"MediaSize" => 90750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-184451c7e76a3fb4f52c377b4c07b060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912396_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/d1f1041167779e5d0dde4a09b2092499.webp"
"MediaSize" => 89373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-d1f1041167779e5d0dde4a09b2092499.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912396_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/52d7dea02779ed8fa4b04c9bd30d96c7.webp"
"MediaSize" => 111319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-52d7dea02779ed8fa4b04c9bd30d96c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912396_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/a816d89795cec162680fe5700324acf2.webp"
"MediaSize" => 89796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-a816d89795cec162680fe5700324acf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912396_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/9ab8c96c2aed34e812319a37e8498131.webp"
"MediaSize" => 101583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-9ab8c96c2aed34e812319a37e8498131.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912396_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/bea51a49439d9c2e444c8fa7a1b1fb3d.webp"
"MediaSize" => 64477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-bea51a49439d9c2e444c8fa7a1b1fb3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912396_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/f307b815bf4fb4a31d12164e5ea8e4e4.webp"
"MediaSize" => 109060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-f307b815bf4fb4a31d12164e5ea8e4e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912396_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/2226814acd502705bfc4cca466c243d2.webp"
"MediaSize" => 139723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-2226814acd502705bfc4cca466c243d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912396_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/22b4f23f9ad48487ed5f70771f4628f0.webp"
"MediaSize" => 123966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-22b4f23f9ad48487ed5f70771f4628f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912396_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/bfe272c9f40b1891f9636e0246b39d85.webp"
"MediaSize" => 96045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-bfe272c9f40b1891f9636e0246b39d85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912396_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/1f0cd7015ab8b4b0f13fc399e0f60c7b.webp"
"MediaSize" => 109647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-1f0cd7015ab8b4b0f13fc399e0f60c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912396_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/5ac2a4c45245eb38505d0091b61707c7.webp"
"MediaSize" => 104764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-5ac2a4c45245eb38505d0091b61707c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912396_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/4911bb1c5fa3aef49da2f7a1bddc8904.webp"
"MediaSize" => 128367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-4911bb1c5fa3aef49da2f7a1bddc8904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912396_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/9da67e9981c66327a5dfc7dbdf2693b9.webp"
"MediaSize" => 81965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-9da67e9981c66327a5dfc7dbdf2693b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912396_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/fb59ea074a2ad0ab4668ff4533846209.webp"
"MediaSize" => 68847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-fb59ea074a2ad0ab4668ff4533846209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912396_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/fcd8470117daa9ffbca1ad92ad0a9ba2.webp"
"MediaSize" => 95299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-fcd8470117daa9ffbca1ad92ad0a9ba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912396_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/538f6bb8dacb6d5c2e0bc9cf59fce019.webp"
"MediaSize" => 74621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-538f6bb8dacb6d5c2e0bc9cf59fce019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912396_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/98c1aa4b9c29e169b6d80bd62d49f0ec.webp"
"MediaSize" => 84266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-98c1aa4b9c29e169b6d80bd62d49f0ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912396_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/374d90684fbe5d96b1899d46c1fbc28b.webp"
"MediaSize" => 108213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-374d90684fbe5d96b1899d46c1fbc28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912396_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912396/c482d4917f216dcbee74b69708f90039.webp"
"MediaSize" => 132676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912396/thumbnail-c482d4917f216dcbee74b69708f90039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839543"
"ResourceRecordKey" => "29912396"
"ModificationTimestamp" => "2026-06-16T20:51:17.39Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912396')"
+"ID": "1537444"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1532832"
+post_author: 1
+"ListingKey": "29907351"
+"ListingId": "X13448166"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:25:03Z"
+"RFModificationTimestamp": "2026-06-16T14:25:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "437 SPECKLED ALDER STREET, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.594098
1 => 43.468816
]
+"Latitude": 43.468816
+"Longitude": -80.594098
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well Maintained 3 Bedroom House, Open Concept Kitchen With Large Breakfast Area. Large Master Bedroom, Walking Distance To Schools. Close To Park And All Other Amenities. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:44:46.016698+00:00"
+"Directions": "Erbsville Rd/Laurewood Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948797"
+"ListOfficeKey": "51127"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "33.1 x 82 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T22:48:00Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:19:55Z"
+"Stories": "2.0"
+"StreetName": "Speckled Alder"
+"StreetNumber": "437"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29907351/437-speckled-alder-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1569377"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "51127"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 33.1
+"OriginalEntryTimestamp": "2026-06-15T22:48:00.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1243317"
+"ListOfficeNationalAssociationId": "1003215"
+"CoListAgentNationalAssociationId": "1150697"
+"CoListOfficeNationalAssociationId": "1003215"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907351_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/fe91422d20bcb6cb8f61450823278725.webp"
"MediaSize" => 206465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-fe91422d20bcb6cb8f61450823278725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907351_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/8458e69f55c15e201c1d3abc79e5e6f2.webp"
"MediaSize" => 119812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-8458e69f55c15e201c1d3abc79e5e6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907351_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/afbbac0c25c22fc7963b7938bceec0fa.webp"
"MediaSize" => 123431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-afbbac0c25c22fc7963b7938bceec0fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907351_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/f10baf54748663b05ce219af2186b9b7.webp"
"MediaSize" => 58205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-f10baf54748663b05ce219af2186b9b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907351_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/dead3799f9d66e13c8b7b2d6844f9828.webp"
"MediaSize" => 125867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-dead3799f9d66e13c8b7b2d6844f9828.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907351_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/e335a79c963a97c22c7f06bbcd204b7c.webp"
"MediaSize" => 135842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-e335a79c963a97c22c7f06bbcd204b7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907351_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/780186d2c989373bef46ba9139df6cc2.webp"
"MediaSize" => 111115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-780186d2c989373bef46ba9139df6cc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907351_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/34b518d5ac3521a9794687f0a9a45658.webp"
"MediaSize" => 102736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-34b518d5ac3521a9794687f0a9a45658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907351_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/951fc206b9f93d506c83e7c8c4208fe7.webp"
"MediaSize" => 75944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-951fc206b9f93d506c83e7c8c4208fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907351_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/7c47f4c8045039c29b185ddd00e1b83e.webp"
"MediaSize" => 79447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-7c47f4c8045039c29b185ddd00e1b83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907351_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/99ba3b67ea3ee28e9c187241642c70d6.webp"
"MediaSize" => 66781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-99ba3b67ea3ee28e9c187241642c70d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29907351_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/dc03aa6d0a84687f413abd3bcd6e55bb.webp"
"MediaSize" => 58070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-dc03aa6d0a84687f413abd3bcd6e55bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448166"
"ResourceRecordKey" => "29907351"
"ModificationTimestamp" => "2026-06-15T22:48:00.53Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29907351_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907351/a538d182e9aa8ae3c83381b76cd06e89.webp"
"MediaSize" => 100586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907351/thumbnail-a538d182e9aa8ae3c83381b76cd06e89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
13 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907351')"
+"ID": "1532832"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1528796"
+post_author: 1
+"ListingKey": "29901337"
+"ListingId": "40838911"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:15:06Z"
+"RFModificationTimestamp": "2026-06-14T18:15:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1855.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2S6"
+"UnparsedAddress": "388 LAUREL GATE Drive, Waterloo, Ontario N2T2S6"
+"Coordinates": array:2 [
0 => -80.5713913
1 => 43.4724344
]
+"Latitude": 43.4724344
+"Longitude": -80.5713913
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Newly Renovated Townhome in the Heart of Laurelwood! Located in the desirable Erbsville/Laurelwood area of Waterloo, this townhome with a fully finished basement is perfect for families or professionals seeking convenience and comfort. Featuring 3+1 bedrooms, 3 bathrooms, and a fenced backyard with a deck, this home truly has it all. The primary bedroom offers double closets and a cheater ensuite, while the convenient door from the garage to the backyard makes maintenance a breeze. Enjoy proximity to top-rated schools, shopping centers, the scenic Laurelwood Conservation Area, and public transit. This property combines privacy, practicality, and an unbeatable location. Don’t miss out on this prime rental opportunity. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T07:25:44.489990+00:00"
+"Directions": "Fischer Hallman/Laurelwood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Recreational"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-14T03:00:53Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T18:09:55Z"
+"Stories": "2.0"
+"StreetName": "LAUREL GATE"
+"StreetNumber": "388"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4038"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29901337/388-laurel-gate-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1257
+"BelowGradeFinishedArea": 598
+"OriginalEntryTimestamp": "2026-06-14T03:00:53.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901337')"
+"ID": "1528796"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1528775"
+post_author: 1
+"ListingKey": "29901403"
+"ListingId": "40839617"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T04:50:12Z"
+"RFModificationTimestamp": "2026-06-16T04:52:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 710, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5994963
1 => 43.4707058
]
+"Latitude": 43.4707058
+"Longitude": -80.5994963
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning two bedrooms, two full baths with unobstructed views and beautiful sunsets, luxurious kitchen; a chef's dream, with plenty of cabinets for the gourmet cook, an oversized island for your entertainment and family gatherings. Located in the desirable Clair Hills, close to schools, trails, nature, and shopping. The building has a party room that can be used to host the bigger crowd, a lounge and media room, all can be booked free of charge. A big locker 7x5x7 and one surface parking space are included. More parking can be rented if needed. Don't wait, it is available Aug 1. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T05:47:11.767617+00:00"
+"Directions": "ERBSVILLE TO LAURELWOOD"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087196"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-14T04:31:39Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T04:31:51Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29901403/778-laurelwood-drive-unit-710-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2550
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RM100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-06-14T04:31:39.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1360531"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901403')"
+"ID": "1528775"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1523008"
+post_author: 1
+"ListingKey": "29893337"
+"ListingId": "40839237"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:15:05Z"
+"RFModificationTimestamp": "2026-06-12T05:34:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1976.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "479 TREMBLING ASPEN Avenue, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5932768
1 => 43.4687994
]
+"Latitude": 43.4687994
+"Longitude": -80.5932768
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Available for Lease AUGUST 1 2026 in Waterloo’s Top School District! Situated in one of Waterloo’s most sought-after neighbourhoods, this 3-bedroom, 2-bathroom home is just a 5-minute walk to both elementary and high schools, with easy bus access to local universities. Inside, you’ll find a functional layout with fresh updates throughout: brand-new Berber carpet on the upper level, new luxury vinyl flooring in the bathrooms, fresh paint, and modern pot lighting for a bright, contemporary feel. The open-concept kitchen flows seamlessly into the living and dining areas and is equipped with stainless steel appliances, all updated within the past five years. The upper-level family room impresses with soaring ceilings and plenty of natural light—perfect for an additional lounge or work-from-home space. The professionally landscaped front and backyard feature new sod and low-maintenance design, with a newly added walkway that can double as a second parking spot. The garage also includes a brand-new insulated door. Additional highlights include two separate living areas, an unfinished basement with laundry and rough-in for a future bathroom, and close proximity to shopping, transit, parks, and major roadways for easy commuting. This home is meticulously maintained, pet-free, and ready for its next family! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T05:34:41.323297+00:00"
+"Directions": "From Erbsville Road, turn west onto Laurelwood Drive, then turn left onto Blue Beech Boulevard, and finally turn right onto Trembling Aspen Avenue. The property is on the right-hand side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091826"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T01:09:50Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:09:49Z"
+"Stories": "2.0"
+"StreetName": "TREMBLING ASPEN"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:1 [
0 => "Telephone"
]
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:11 [
0 => array:11 [ …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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29893337/479-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2950
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1406
+"BelowGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-06-12T01:09:49.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:30 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893337')"
+"ID": "1523008"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1472850"
+post_author: 1
+"ListingKey": "29822723"
+"ListingId": "X13212046"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T13:55:34Z"
+"RFModificationTimestamp": "2026-06-08T13:59:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N9"
+"UnparsedAddress": "7 - 360 CORNRIDGE PLACE, Waterloo, Ontario N2T2N9"
+"Coordinates": array:2 [
0 => -80.57714
1 => 43.460212
]
+"Latitude": 43.460212
+"Longitude": -80.57714
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained town home located in upper Beechwood community, backing to ravine green space and trail. This house featuring 3 bed rooms, 2 bathroom with finished basement for additional space (recreation room/office, laundry room, 3PC washroom, in-law potential). Upgraded kitchen has extended cabinetry for more storage, Quartz Countertops, Stainless Steel Appliances. Freshly Painted, fully fenced yard, quiet friendly neighborhood. Attached garage and one additional parking space in drive way. Situated in prime Waterloo Location a) Near the University of Waterloo, b) Close to top-rated schools, c) Public transit, Gym, Theater, lake trails and all amenities d) Popular shopping destinations (Costco, Sobeys, Canadian Tire, and more), e) The boardwalk. Ideal for families, professionals, or students. Ready to move in (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "345"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T05:19:10.353588+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Columbia St. ** Directions: Erbsville Rd and Cornridge place intersection, take left in Cornridge place."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167766"
+"ListOfficeKey": "300443"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T04:45:32Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T13:45:33Z"
+"Stories": "2.0"
+"StreetName": "Cornridge"
+"StreetNumber": "360"
+"StreetSuffix": "Place"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29822723/7-360-cornridge-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-29T04:45:32.3Z"
+"ListAgentNationalAssociationId": "1418479"
+"ListOfficeNationalAssociationId": "1487969"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29822723')"
+"ID": "1472850"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1445778"
+post_author: 1
+"ListingKey": "29784488"
+"ListingId": "40832047"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T01:00:03Z"
+"RFModificationTimestamp": "2026-06-13T01:12:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1861.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X2"
+"UnparsedAddress": "775 KARLSFELD Road, Waterloo, Ontario N2T2X2"
+"Coordinates": array:2 [
0 => -80.5778441
1 => 43.45651
]
+"Latitude": 43.45651
+"Longitude": -80.5778441
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious and well-maintained 3-bedroom, 2-bathroom two-storey rental (excluding basement) unit located in a desirable Waterloo neighbourhood. This bright and inviting home offers a functional layout with generous living space, perfect for families or professionals. Enjoy access to a private backyard and garage, along with the convenience of two parking spaces. Ideally situated close to schools, shopping, parks, transit, and everyday amenities, this home combines comfort and convenience in a great location. A wonderful opportunity to lease in one of Waterloo’s sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-21T18:51:45.001367+00:00"
+"Directions": "ERBSVILLE ROAD, TURN WEST ON KEATS WAY, TURN NORTH ON KARLSFELD, 775 IS LOCATED ON WEST SIDE OF THE STREET"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564437"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T05:39:15Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:51:41Z"
+"Stories": "2.0"
+"StreetName": "KARLSFELD"
+"StreetNumber": "775"
+"StreetSuffix": "Road"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29784488/775-karlsfeld-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1992792"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1564379"
+"CoListAgentKey3": "1921771"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"TotalActualRent": 2690
+"CoListOfficeKey2": "289541"
+"CoListOfficeKey3": "76840"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1861
+"OriginalEntryTimestamp": "2026-05-21T17:10:18.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1115807"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1276055"
+"CoListAgentNationalAssociationId2": "1070065"
+"CoListAgentNationalAssociationId3": "1227142"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1378680"
+"CoListOfficeNationalAssociationId3": "1004363"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 27
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29784488')"
+"ID": "1445778"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1418773"
+post_author: 1
+"ListingKey": "29747857"
+"ListingId": "40830083"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T19:30:26Z"
+"RFModificationTimestamp": "2026-06-09T22:55:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 102, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5994493
1 => 43.4705757
]
+"Latitude": 43.4705757
+"Longitude": -80.5994493
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully maintained 2-bedroom, 2 full bathroom condo available for lease from June 1st in Waterloo’s highly sought-after Laurelwood neighborhood. This unique ground-floor unit offers 1,086 sq. ft. of thoughtfully designed living space along with a private backyard — a rare feature in the building. The unit is exceptionally bright and filled with natural sunlight throughout. The open-concept layout features a modern kitchen with granite countertops, stainless steel appliances, a large island/breakfast bar, and ample cabinetry. The spacious living and dining area is filled with natural light and walks out to the private outdoor space, perfect for relaxing or entertaining. The primary bedroom includes a walk-in closet and a full ensuite bathroom. Additional features include in-suite laundry, central heating and air conditioning, carpet-free living, a dedicated storage locker, and 1 dedicated parking space. Rent includes water and the owned water heater. Tenant pays hydro and gas only. Residents of Reflections Condos enjoy excellent amenities including a theatre room, games/party room with billiards and kitchenette, entertainment lounge, bicycle storage, secure fob entry, and beautifully landscaped outdoor cabanas with BBQs. Located in the catchment area of highly rated schools and close to parks, trails, Laurelwood Conservation Area, The Boardwalk Shopping District, transit, University of Waterloo, tech park, and many everyday amenities. Perfect for professionals or small families seeking comfort, convenience, and upscale living in one of Waterloo’s most desirable communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Microwave Built-in"
]
+"AssociationFee": "440"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-13T20:38:28.515052+00:00"
+"Directions": "From Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-05-13T22:09:36Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T19:21:45Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …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/29747857/778-laurelwood-drive-unit-102-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-05-13T20:10:31.2Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1463723"
+"ListOfficeNationalAssociationId": "1378643"
+"Media": array:31 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29747857')"
+"ID": "1418773"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1187634"
+post_author: 1
+"ListingKey": "29414599"
+"ListingId": "40803771"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T00:00:50Z"
+"RFModificationTimestamp": "2026-06-10T00:03:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X8"
+"UnparsedAddress": "608 WOOLGRASS Avenue Unit# Lower, Waterloo, Ontario N2V2X8"
+"Coordinates": array:2 [
0 => -80.6033349
1 => 43.473069
]
+"Latitude": 43.473069
+"Longitude": -80.6033349
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 608 Woolgrass Ave. Waterloo. This is for the LOWER unit with a separate unit upstairs. Located in the sought-after, family-friendly neighborhood of Laurelwood close to schools, parks, shopping, restaurants and an extensive network of trails and nature areas. Easy access to bus routes to the University of Waterloo and the Boardwalk Mall. The property offers a fully separate entrance to a spacious basement unit with one bedroom, a full bathroom, and separate laundry facility. There is parking space for 1 vehicle and utilities & water heater rental are shared with the upper unit which is currently rented. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-03-02T19:39:28.959547+00:00"
+"Directions": "Laurelwood Dr and Wideman Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175280"
+"ListOfficeKey": "287413"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-03-02T17:09:29Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:52:47Z"
+"Stories": "2.0"
+"StreetName": "WOOLGRASS"
+"StreetNumber": "608"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29414599/608-woolgrass-avenue-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1250
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-03-02T17:09:29.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1425655"
+"ListOfficeNationalAssociationId": "1367810"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 107
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29414599')"
+"ID": "1187634"
}
]
+success: true
+page_size: 9
+page_count: 1
+count: 9
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]