array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30033009 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1637188"
+post_author: 1
+"ListingKey": "30033009"
+"ListingId": "40848205"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:06Z"
+"RFModificationTimestamp": "2026-07-17T21:00:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1560.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T3"
+"UnparsedAddress": "504 BLUE BEECH Boulevard Unit# B, Waterloo, Ontario N2V2T3"
+"Coordinates": array:2 [
0 => -80.5921619
1 => 43.4686678
]
+"Latitude": 43.4686678
+"Longitude": -80.5921619
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Most popular location with best schools, Mins to Abraham Erb and Laurel Hights high school. close to trails, playground and forest. Spacious semi with 4 bedrooms, finished from top to bottom. Open concept main floor, fully fenced rear yard with deck and pergola. On the bus routes, close to YMCA, shopping center, Library and Universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T21:00:42.220675+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T21:29:14Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:44Z"
+"Stories": "2.0"
+"StreetName": "BLUE BEECH"
+"StreetNumber": "504"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686994567"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.4Z"
]
1 => array:11 [
"RoomKey" => "1686994568"
"RoomType" => "Office"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
2 => array:11 [
"RoomKey" => "1686994569"
"RoomType" => "Den"
"ListingId" => "40848205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
3 => array:11 [
"RoomKey" => "1686994570"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
4 => array:11 [
"RoomKey" => "1686994571"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
5 => array:11 [
"RoomKey" => "1686994572"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
6 => array:11 [
"RoomKey" => "1686994573"
"RoomType" => "Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
7 => array:11 [
"RoomKey" => "1686994574"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 25'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
8 => array:11 [
"RoomKey" => "1686994575"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
9 => array:11 [
"RoomKey" => "1686994576"
"RoomType" => "Living room"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
10 => array:11 [
"RoomKey" => "1686994577"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40848205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30033009"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:44.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30033009/504-blue-beech-boulevard-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2850
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1560
+"OriginalEntryTimestamp": "2026-07-14T21:29:14.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30033009_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/90ba1e6d53ac71ae8f5f1bf86e3c09ab.webp"
"MediaSize" => 148704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-90ba1e6d53ac71ae8f5f1bf86e3c09ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story exterior featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30033009_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/37d693d2f9ff6e7c189e7e803ce18e6d.webp"
"MediaSize" => 139755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-37d693d2f9ff6e7c189e7e803ce18e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30033009_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/8de40d8e06a81828a68a5b14f38001d0.webp"
"MediaSize" => 51787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-8de40d8e06a81828a68a5b14f38001d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30033009_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/4dbdf43997230825d6f4bc2970a04ce0.webp"
"MediaSize" => 37419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-4dbdf43997230825d6f4bc2970a04ce0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30033009_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/96e90abbf5456257f39f57cf5b822fa6.webp"
"MediaSize" => 58606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-96e90abbf5456257f39f57cf5b822fa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring ceramic tile flooring, neutral wall tones, and two paneled closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30033009_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/f905b238ef4456f1fac3182a9e492196.webp"
"MediaSize" => 70054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-f905b238ef4456f1fac3182a9e492196.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30033009_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/83f7ebc7a5810e18fda830d83f2d3cf9.webp"
"MediaSize" => 84875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-83f7ebc7a5810e18fda830d83f2d3cf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood cabinetry, white appliances, a double basin sink, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30033009_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/23b10ce08767d172c03882e1c7edf768.webp"
"MediaSize" => 81935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-23b10ce08767d172c03882e1c7edf768.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring wood cabinetry, white appliances, and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30033009_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/bcc6e43f082e01fd6e24076f3e91c881.webp"
"MediaSize" => 82776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-bcc6e43f082e01fd6e24076f3e91c881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring tile flooring, a sliding glass door, overhead chandelier lighting, and a light beige wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30033009_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/2242d1c28b5c6937caf86cfa8a021c9d.webp"
"MediaSize" => 80520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-2242d1c28b5c6937caf86cfa8a021c9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring a window, overhead lighting, and carpeted flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30033009_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/9a1d7a3471efa557fece69eec953ced7.webp"
"MediaSize" => 50012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-9a1d7a3471efa557fece69eec953ced7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring vaulted ceilings and a window with an arched transom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30033009_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/cf192747804aab98430ae20c272d6c22.webp"
"MediaSize" => 41933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-cf192747804aab98430ae20c272d6c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned room featuring a panel door and bi-fold closet doors, wall-to-wall carpeting, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30033009_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/621dde4dab58a5439df5160681456f63.webp"
"MediaSize" => 42910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-621dde4dab58a5439df5160681456f63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted interior space featuring a window with grid patterns, light-toned walls, white trim, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30033009_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/5282b1769bbb582f34dbb17ecdfe3a14.webp"
"MediaSize" => 49491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-5282b1769bbb582f34dbb17ecdfe3a14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single window, white vanity with integrated sink, chrome faucet, and a wall-mounted medicine cabinet with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30033009_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/8a4a43fc9965bedc8668452e2e03318e.webp"
"MediaSize" => 40003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-8a4a43fc9965bedc8668452e2e03318e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bifold closet doors featuring panel detailing and brass-toned hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30033009_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/5340effc8558f3349d6949ecbb4969a0.webp"
"MediaSize" => 60372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-5340effc8558f3349d6949ecbb4969a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring neutral carpeting, olive-toned walls, and a white trim window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30033009_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/82506fb0562a1de49ee74c8e5310bc44.webp"
"MediaSize" => 63486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-82506fb0562a1de49ee74c8e5310bc44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30033009_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/0c37753f5ccee8b2083765333142c5a5.webp"
"MediaSize" => 63486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-0c37753f5ccee8b2083765333142c5a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30033009_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/cf26a7ccd1ed2e76e2fa5d0e163ee000.webp"
"MediaSize" => 61860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-cf26a7ccd1ed2e76e2fa5d0e163ee000.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30033009_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/71e44224d48c6e1ba271ecee7b89421e.webp"
"MediaSize" => 61860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-71e44224d48c6e1ba271ecee7b89421e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30033009_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30033009/61517ec02b18ed6395f69051f1a59571.webp"
"MediaSize" => 58010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30033009/thumbnail-61517ec02b18ed6395f69051f1a59571.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corner shower enclosure with glass doors and a light-toned tile surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848205"
"ResourceRecordKey" => "30033009"
"ModificationTimestamp" => "2026-07-14T21:29:14.5Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30033009')"
+"ID": "1637188"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24985
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24932
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('295659')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2162407" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24919
+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 '30033009'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25301
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30033009' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25398
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30033009' 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.5921619 43.4686678)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25335
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1644204"
+post_author: 1
+"ListingKey": "30058773"
+"ListingId": "X13586678"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T03:15:05Z"
+"RFModificationTimestamp": "2026-07-21T04:39:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "565 BALSAM POPAR STREET, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.599902
1 => 43.457707
]
+"Latitude": 43.457707
+"Longitude": -80.599902
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client RemarksThis stunning 3,000+ sqft home offers the potential for an elevator and features a spacious double-car garage with a separate entrance to the finished basement.Large basement windows with 3pc Ensuite of Bathroom .The garage itself is exceptionally large, providing ample storage and parking space. The house has 4 generously sized bedrooms, including two luxurious master suites, plus a dedicated home office perfect for remote work or study. The home boasts 4.5 bathrooms, ensuring comfort and privacy for the whole family. Designed for modern efficiency and comfort, this home is equipped with a dual-fuel furnace, air-source heat pump, and an ERV system, promoting superior air quality and energy savings. High-end finishes include 9-ft ceilings on both the main and second floors, and elegant hardwood flooring throughout the second floor. Conveniently located near shopping plazas, Costco, Highway 85, and the famous St. Jacobs Market, this home offers both luxury and accessibility in a prime location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T04:38:57.152429+00:00"
+"Directions": "Cross Streets: Columbia St W/ Platinum Dr. ** Directions: Found on the west side of street near Sundew Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2221801"
+"ListOfficeKey": "280107"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.2 x 98.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T03:08:30Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T03:08:30Z"
+"Stories": "3.0"
+"StreetName": "Balsam Popar"
+"StreetNumber": "565"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1689762721"
"RoomType" => "Foyer"
"ListingId" => "X13586678"
"RoomLevel" => "Main level"
"RoomWidth" => 1.77
"ListingKey" => "30058773"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
1 => array:11 [
"RoomKey" => "1689762722"
"RoomType" => "Living room"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "30058773"
"RoomLength" => 4.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
2 => array:11 [
"RoomKey" => "1689762723"
"RoomType" => "Kitchen"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "30058773"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
3 => array:11 [
"RoomKey" => "1689762724"
"RoomType" => "Dining room"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.36
"ListingKey" => "30058773"
"RoomLength" => 4.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
4 => array:11 [
"RoomKey" => "1689762725"
"RoomType" => "Office"
"ListingId" => "X13586678"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "30058773"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
5 => array:11 [
"RoomKey" => "1689762726"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.78
"ListingKey" => "30058773"
"RoomLength" => 4.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
6 => array:11 [
"RoomKey" => "1689762727"
"RoomType" => "Bedroom 2"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 2.7
"ListingKey" => "30058773"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
7 => array:11 [
"RoomKey" => "1689762728"
"RoomType" => "Bedroom 3"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.3
"ListingKey" => "30058773"
"RoomLength" => 3.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
8 => array:11 [
"RoomKey" => "1689762729"
"RoomType" => "Bedroom 4"
"ListingId" => "X13586678"
"RoomLevel" => "Third level"
"RoomWidth" => 3.3
"ListingKey" => "30058773"
"RoomLength" => 3.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
9 => array:11 [
"RoomKey" => "1689762730"
"RoomType" => "Bedroom"
"ListingId" => "X13586678"
"RoomLevel" => "Basement"
"RoomWidth" => 4.4
"ListingKey" => "30058773"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-21T03:08:30.86Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30058773/565-balsam-popar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4000
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.2
+"OriginalEntryTimestamp": "2026-07-21T03:08:30.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1465441"
+"ListOfficeNationalAssociationId": "1309558"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30058773_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/34eaf709898229602f0dfeffc5bef455.webp"
"MediaSize" => 362925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-34eaf709898229602f0dfeffc5bef455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30058773_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f7c70c896d261cee60018c1d7719d722.webp"
"MediaSize" => 102891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f7c70c896d261cee60018c1d7719d722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30058773_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/0868fe33b1c0bc8e601851f16a7f8a7b.webp"
"MediaSize" => 183447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-0868fe33b1c0bc8e601851f16a7f8a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30058773_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/3eee0ba044d4db22764fabdb78c23323.webp"
"MediaSize" => 171355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-3eee0ba044d4db22764fabdb78c23323.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30058773_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/b376338bef52ea44323b1b67ac5e2cd1.webp"
"MediaSize" => 171738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-b376338bef52ea44323b1b67ac5e2cd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30058773_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/7aa09909350da76887ac3dac3b499169.webp"
"MediaSize" => 168356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-7aa09909350da76887ac3dac3b499169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30058773_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/74f108c73cabfc3eabf72d5643fabcfc.webp"
"MediaSize" => 175960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-74f108c73cabfc3eabf72d5643fabcfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30058773_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/d6c1401f3603083ebaa3b4ef47c6f84c.webp"
"MediaSize" => 133479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-d6c1401f3603083ebaa3b4ef47c6f84c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30058773_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f72049e1ea9a0b76b5fe4ace7b2b2632.webp"
"MediaSize" => 154036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f72049e1ea9a0b76b5fe4ace7b2b2632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30058773_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/d127ebb7f05e2b127b704d7c9ad00f29.webp"
"MediaSize" => 254191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-d127ebb7f05e2b127b704d7c9ad00f29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30058773_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/207989f21f7b4fcb9cbfa696be36eb69.webp"
"MediaSize" => 146787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-207989f21f7b4fcb9cbfa696be36eb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30058773_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/777e376f5f8fb143e7d0fd9923da0630.webp"
"MediaSize" => 146440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-777e376f5f8fb143e7d0fd9923da0630.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30058773_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/0618d9afcdc7e4be903ad50cc944d172.webp"
"MediaSize" => 125621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-0618d9afcdc7e4be903ad50cc944d172.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30058773_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/f7ec9326e626662cd109e1c4d9966930.webp"
"MediaSize" => 146674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-f7ec9326e626662cd109e1c4d9966930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30058773_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/16930175d4edb6fa26a49ec8db17a1dc.webp"
"MediaSize" => 134860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-16930175d4edb6fa26a49ec8db17a1dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30058773_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/c4435c9f3e2d7154c70634ebd18333ad.webp"
"MediaSize" => 123404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-c4435c9f3e2d7154c70634ebd18333ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30058773_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/1ad9ce60dd58980de70963eefe8906ce.webp"
"MediaSize" => 162609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-1ad9ce60dd58980de70963eefe8906ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30058773_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/36ccb99fdd3633fc8aa48b7b3be77b29.webp"
"MediaSize" => 133424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-36ccb99fdd3633fc8aa48b7b3be77b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30058773_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/66dda4034d572f662b61f2c070198a95.webp"
"MediaSize" => 111162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-66dda4034d572f662b61f2c070198a95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30058773_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/6e4c0aa11d863c3e5ab5d6415b196ca7.webp"
"MediaSize" => 119629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-6e4c0aa11d863c3e5ab5d6415b196ca7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30058773_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/28c1bf705ceefb1e436163494df1da62.webp"
"MediaSize" => 110636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-28c1bf705ceefb1e436163494df1da62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30058773_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/84981062097b131c6e5bf46462eec7f0.webp"
"MediaSize" => 117111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-84981062097b131c6e5bf46462eec7f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30058773_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/40086a02eb0875c10cac2c03ef0ebaf3.webp"
"MediaSize" => 136133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-40086a02eb0875c10cac2c03ef0ebaf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30058773_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/2727aee0defc3cdf7425eb1721e0b058.webp"
"MediaSize" => 130482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-2727aee0defc3cdf7425eb1721e0b058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30058773_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/8ca9aeeaad9ab56e9b8483a2d0eacb84.webp"
"MediaSize" => 116583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-8ca9aeeaad9ab56e9b8483a2d0eacb84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30058773_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30058773/054fc2db11ee3719e43523a8968a7ab4.webp"
"MediaSize" => 146523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30058773/thumbnail-054fc2db11ee3719e43523a8968a7ab4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13586678"
"ResourceRecordKey" => "30058773"
"ModificationTimestamp" => "2026-07-21T03:08:30.85Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30058773')"
+"ID": "1644204"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1643238"
+post_author: 1
+"ListingKey": "30057921"
+"ListingId": "40849786"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T03:05:19Z"
+"RFModificationTimestamp": "2026-07-21T03:08:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L1"
+"UnparsedAddress": "365 BENNINGTON Gate Unit# 13, Waterloo, Ontario N2T2L1"
+"Coordinates": array:2 [
0 => -80.5756639
1 => 43.4640033
]
+"Latitude": 43.4640033
+"Longitude": -80.5756639
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional living in prestigious Waterloo Upper Beechwood community with this spacious 2+1 bedroom, 3.5 bathroom townhome condo. $2600 plus with flexible move in date extending as late as September 1, 2026. Offering 1,500 sq ft of well-appointed living space, plus an additional 512 sq ft in the finished walk out basement. This home combines style, functionality, and quiet living. The bright and open-concept main level features an eat-in kitchen, dining area, and a comfortable living space; perfect for family gatherings and entertaining. The upper level includes a generous primary bedroom with an en-suite bathroom and ample closet space, bonus living area for a home office or family room, along with a second bedroom and full bath. The finished walk out basement offers endless possibilities, featuring a versatile layout ideal for an additional bedroom, a home gym, or a recreational room - complete with a 3-piece bathroom for added convenience. With an attached garage, a cozy backyard for outdoor relaxation, and access to a complex pool, this home provides everything you need for a balanced lifestyle. Situated in the desirable Upper Beechwood community, you'll enjoy the charm of this well-established neighborhood, with nearby parks, great schools, shopping, and easy access to Waterloo's amenities. This townhome is perfect for families, professionals, and down-sizers seeking comfort, convenience, and community living. Don't miss your chance to make this sought-after address your new home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T22:31:22.793232+00:00"
+"Directions": "Columbia St. W. to Bennington Gate"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T22:12:20Z"
+"PhotosCount": 20
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T02:58:46Z"
+"Stories": "2.0"
+"StreetName": "BENNINGTON"
+"StreetNumber": "365"
+"StreetSuffix": "Gate"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1689760383"
"RoomType" => "Laundry room"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
1 => array:11 [
"RoomKey" => "1689760384"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
2 => array:11 [
"RoomKey" => "1689760385"
"RoomType" => "Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
3 => array:11 [
"RoomKey" => "1689760386"
"RoomType" => "Recreation room"
"ListingId" => "40849786"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
4 => array:11 [
"RoomKey" => "1689760387"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
5 => array:11 [
"RoomKey" => "1689760388"
"RoomType" => "Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
6 => array:11 [
"RoomKey" => "1689760389"
"RoomType" => "Full bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
7 => array:11 [
"RoomKey" => "1689760390"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
8 => array:11 [
"RoomKey" => "1689760391"
"RoomType" => "Family room"
"ListingId" => "40849786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
9 => array:11 [
"RoomKey" => "1689760392"
"RoomType" => "Dinette"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.77Z"
]
10 => array:11 [
"RoomKey" => "1689760393"
"RoomType" => "Kitchen"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
11 => array:11 [
"RoomKey" => "1689760394"
"RoomType" => "Living room"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
12 => array:11 [
"RoomKey" => "1689760395"
"RoomType" => "Dining room"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
13 => array:11 [
"RoomKey" => "1689760396"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849786"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T02:58:46.78Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30057921/365-bennington-gate-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 2060
+"BelowGradeFinishedArea": 512
+"OriginalEntryTimestamp": "2026-07-20T22:08:34.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30057921_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/16b7af1c0390686eca52ee36d6ca5c7b.webp"
"MediaSize" => 126306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057921/thumbnail-16b7af1c0390686eca52ee36d6ca5c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level exterior featuring light-toned brick and horizontal siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849786"
"ResourceRecordKey" => "30057921"
"ModificationTimestamp" => "2026-07-20T22:12:18.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30057921_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057921/2b5f997b4ec2555e1d21e83da799553b.webp"
…10
]
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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057921')"
+"ID": "1643238"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1642826"
+post_author: 1
+"ListingKey": "30055809"
+"ListingId": "X13584212"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T17:15:12Z"
+"RFModificationTimestamp": "2026-07-20T19:17:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B2"
+"UnparsedAddress": "MAIN - 286 BUTTONBUSH STREET, Waterloo, Ontario N2V0B2"
+"Coordinates": array:2 [
0 => -80.589804
1 => 43.451538
]
+"Latitude": 43.451538
+"Longitude": -80.589804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous 4 Bedroom Detached house (Upper only) in one most demanding neighborhood. Boosting 9'Ceilings & Plenty Of Upgrades. Enjoy 4 Spacious Bedrooms + Study And A Great Room With A Practical & Commodious Layout. Large Windows - Lots Of Sunlight. Mins Drive to Costco & other amenities, Walking distance to School & Park. Move In & Enjoy! Won't last long. No disappointments here! (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Oven"
4 => "Hood Fan"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:17:44.810351+00:00"
+"Directions": "Columbia St & Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072435"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "In suite Laundry"
1 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 98.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T17:09:53Z"
+"PhotosCount": 15
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T17:09:53Z"
+"Stories": "2.0"
+"StreetName": "Buttonbush"
+"StreetNumber": "286"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30055809/main-286-buttonbush-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-20T17:09:53.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347614"
+"ListOfficeNationalAssociationId": "1002993"
+"Media": array:15 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055809')"
+"ID": "1642826"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1640662"
+post_author: 1
+"ListingKey": "30053492"
+"ListingId": "40849408"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T19:20:07Z"
+"RFModificationTimestamp": "2026-07-19T19:22:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1607.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T4"
+"UnparsedAddress": "379 HAVENDALE Crescent, Waterloo, Ontario N2T2T4"
+"Coordinates": array:2 [
0 => -80.5827649
1 => 43.4709381
]
+"Latitude": 43.4709381
+"Longitude": -80.5827649
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** NEW VINYL FLOORING WILL REPLACE ALL CARPETING AND THE ENTIRE HOME WILL BE FRESHLY PAINTED*** Located in the heart of the highly sought-after Laurelwood community and top-rated school district, this bright and well-maintained 3-bedroom, 3-bathroom detached home offers the perfect combination of comfort and convenience. The open-concept main floor features a spacious living area with a sunken great room, while the second level boasts a large primary bedroom, two generously sized bedrooms, and the convenience of second-floor laundry. The finished basement includes a large recreation room and a 2-piece bathroom, providing additional living space for the family. Enjoy the fully fenced backyard with a deck and storage shed. Ideally located close to top-ranked schools, the University of Waterloo, RIM Park, Laurel Creek Conservation Area, shopping, and transit. Children may attend Laurelwood Public School or St. Nicholas Catholic School. ALL UPDATES WILL BE COMPLETED PRIOR TO AUGUST OCCUPANCY. Available August 2026. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-19T19:22:48.117759+00:00"
+"Directions": "Beaver Creek Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-07-19T19:11:07Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T19:18:02Z"
+"Stories": "2.0"
+"StreetName": "HAVENDALE"
+"StreetNumber": "379"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30053492/379-havendale-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1607
+"OriginalEntryTimestamp": "2026-07-19T18:58:56.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:20 [
0 => array:13 [ …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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30053492')"
+"ID": "1640662"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1637223"
+post_author: 1
+"ListingKey": "30043864"
+"ListingId": "40848815"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:15Z"
+"RFModificationTimestamp": "2026-07-17T20:52:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5956476
1 => 43.4555934
]
+"Latitude": 43.4555934
+"Longitude": -80.5956476
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:52:43.451105+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:29:28Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:36Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043864/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-16T19:29:28.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043864')"
+"ID": "1637223"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1627218"
+post_author: 1
+"ListingKey": "30035197"
+"ListingId": "X13565240"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T15:20:06Z"
+"RFModificationTimestamp": "2026-07-15T17:25:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T3"
+"UnparsedAddress": "414 HAVENDALE CRESCENT, Waterloo, Ontario N2T2T3"
+"Coordinates": array:2 [
0 => -80.581405
1 => 43.470069
]
+"Latitude": 43.470069
+"Longitude": -80.581405
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 414 Havendale Crescent, a beautifully upgraded 2-storey home located on a quiet crescent in one of Waterloo's most desirable family neighbourhoods. Sitting on a rare 31.83x164.7 ft lot, this home offers a perfect blend of style, function, and space. The main floor features a dedicated office, an open-concept living and dining area, and a modern kitchen with stainless steel appliances, upgraded cabinetry with a white and wood finish, and a breakfast area overlooking the backyard. Upstairs, you'll find three spacious bedrooms and two full bathrooms, including a large primary bedroom with serene views of the backyard. A standout feature is the elevated family room above the garage, complete with a cozy fireplace perfect for movie nights or relaxing with the family. The fully finished basement adds incredible living space, with a huge recreation room ideal for entertaining, a secondary office or guest room (newly added), and a separate laundry room. Step outside to enjoy the oversized backyard, featuring a large deck and a private hot tub perfect for summer entertaining or year-round enjoyment. This home is move-in ready and perfect for growing families. Located in a friendly, well-established community with excellent school zones, including Laurelwood Public School and Laurel Heights Secondary School (Sir John A. Macdonald Secondary School), both known for strong academic performance. Close to parks, walking trails, shopping, and transit. Don't miss this opportunity to lease a spacious, turn-key home in one of Waterloo's most family-friendly neighbourhoods. Book your private tour today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T17:25:49.947428+00:00"
+"Directions": "Cross Streets: Erbsville Rd/Laurelwood Dr. ** Directions: Turn north onto Beaver Creek Rd from Willow Wood DrTurn north onto Beaver Creek Rd from Willow Wood Dr."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085514"
+"ListOfficeKey": "292919"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Flat site"
]
+"LotSizeDimensions": "31.8 x 164.7 FT ; At backside"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T14:09:39Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T15:10:46Z"
+"Stories": "2.0"
+"StreetName": "Havendale"
+"StreetNumber": "414"
+"StreetSuffix": "Crescent"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/414_havendale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035197/414-havendale-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2063353"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292919"
+"GeocodeManualYN": false
+"TotalActualRent": 3499
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.9
+"OriginalEntryTimestamp": "2026-07-15T14:09:39.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1358915"
+"ListOfficeNationalAssociationId": "1419411"
+"CoListAgentNationalAssociationId": "1338399"
+"CoListOfficeNationalAssociationId": "1419411"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035197')"
+"ID": "1627218"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1616139"
+post_author: 1
+"ListingKey": "30021051"
+"ListingId": "X13552080"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T04:10:00Z"
+"RFModificationTimestamp": "2026-07-19T04:18:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as afitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T04:47:41.976622+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Keats way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T05:37:02Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T04:03:00Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021051/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-11T01:34:00.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021051')"
+"ID": "1616139"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1610972"
+post_author: 1
+"ListingKey": "30013604"
+"ListingId": "X13545338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T19:20:09Z"
+"RFModificationTimestamp": "2026-07-20T19:23:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "UNIT 21 - 350 ERBSVILLE ROAD, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.578721
1 => 43.461152
]
+"Latitude": 43.461152
+"Longitude": -80.578721
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*** Additional Listing Details - Click Brochure Link *** Welcome to this Exquisite and Serene 3-bedroom Fully Licensed rental townhome, located in the highly desired Upper Beechwood West!Location: #21-350 Erbsville Rd. Waterloo. Virtual Tour: https://youtu.be/nQvJ3BmpVL8. Features: 3 large bedroom, Master bedroom with ensuite 2-piece private washroom. Separated dining room and living room, Living room patio door to the Upper deck with green view. Fully finished basement all above ground with large window and a Large Storage room, walk out to the second deck and greenbelt. Steps to the playground, trails, bus stops. visitors parking in front of the house. Bus route #13 and #31 taking you directly to the University of Waterloo, the Sobeys Shopping plaza, Food basics, the Boardwalk, Golf courses, gyms, Conestoga Mall, Canadian Tire, Costco. School buses are in front of the compound's door. Mary Johnson elementary school, Sir John A Macdonald secondary school. Enjoy having your morning coffee or BBQ dinner on the choice of 2 back decks which look out onto the green and watch the four seasons passing by... A truly country living in the city! Have a playground park which is just meters away for the children, walk off the stress after work, or have a morning run in the back wood trail... All possible with this family friendly townhome. Available: August 1st. 2026. Price: $2800 Plus Utilities *Non-Smoking *Credit and reference check Required. *Tenant Insurance is Mandatory and Must Be Provided Before Move-in*Call today with a brief introduction to book a viewing! (id:62650)"
+"Appliances": array:2 [
0 => "Oven - Built-In"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "240"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T23:16:07.985296+00:00"
+"Directions": "Clumbia Street & Erbsville Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987594"
+"ListOfficeKey": "296503"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T20:09:54Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T19:12:58Z"
+"Stories": "2.0"
+"StreetName": "Erbsville"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013604/unit-21-350-erbsville-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Green Brick Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T20:09:54.28Z"
+"ListAgentNationalAssociationId": "1271850"
+"ListOfficeNationalAssociationId": "1459260"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013604')"
+"ID": "1610972"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1607907"
+post_author: 1
+"ListingKey": "30009704"
+"ListingId": "X13541548"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T12:15:06Z"
+"RFModificationTimestamp": "2026-07-09T13:59:20Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "613 - 778 LAURELWOOD DRIVE, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.598809
1 => 43.471162
]
+"Latitude": 43.471162
+"Longitude": -80.598809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 613 at 778 Laurelwood Dr, this spacious, professionally cleaned corner unit offering approximately 1,186 sq ft of well-designed living space in the highly desirable Laurelwood community. This carpet-free, fully furnished 2-bedroom, 2-bathroom condo features a functional split-bedroom layout, ideal for families, professionals, or roommates. The open-concept kitchen offers stainless steel appliances, abundant cabinetry, generous counter space, and a large island overlooking the bright living area. The spacious primary bedroom features a walk-in closet and private ensuite, while the second bedroom is conveniently located beside the second full bathroom. Enjoy in-suite laundry, a private balcony, and one surface parking space. The unit is offered fully furnished with the furniture shown in the listing photos. Residents have access to excellent building amenities including a party room, theatre room, games room, conference room, and BBQ area. Ideally located within the top-rated Laurelwood school district, just minutes to the University of Waterloo, Wilfrid Laurier University, The Boardwalk, shopping, restaurants, parks, trails, Laurel Creek Conservation Area, and public transit. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:58:37.351523+00:00"
+"Directions": "Cross Streets: Laurelwood Drive. ** Directions: Erbsville Road to Laurelwood Drive."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T12:08:01Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T12:08:01Z"
+"StreetName": "Laurelwood"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009704/613-778-laurelwood-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T12:08:01.49Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009704')"
+"ID": "1607907"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 20
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]