array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30058773 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: "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"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 280107" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24994
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24941
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HIGHLAND REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-803-3399"
+"OfficeMlsId": "283100"
+"ModificationTimestamp": "2026-03-03T10:53:20Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "280107"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "40 VILLAGE CENTRE PL #300"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L4Z1V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1309558"
+"OriginalEntryTimestamp": "2017-05-02T00:30:00Z"
+"OfficeFax": "647-361-1112"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "370372"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "280107"
"SocialMediaUrlOrId" => "http://www.realtyhighland.com/"
"ModificationTimestamp" => "2025-06-11T21:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1185526"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('280107')"
}
]
+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 2221801" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25011
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24928
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2221801"
+"ModificationTimestamp": "2025-01-29T23:39:16Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2221801"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2221801')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30058773'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+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 '30058773' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+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 '30058773' 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.599902 43.457707)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25385
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+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 [
"RoomKey" => "1689365216"
"RoomType" => "Foyer"
"ListingId" => "X13584212"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.43
"ListingKey" => "30055809"
"RoomLength" => 1.823
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
1 => array:11 [
"RoomKey" => "1689365217"
"RoomType" => "Great room"
"ListingId" => "X13584212"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.6
"ListingKey" => "30055809"
"RoomLength" => 7.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
2 => array:11 [
"RoomKey" => "1689365218"
"RoomType" => "Kitchen"
"ListingId" => "X13584212"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.04
"ListingKey" => "30055809"
"RoomLength" => 4.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
3 => array:11 [
"RoomKey" => "1689365219"
"RoomType" => "Eating area"
"ListingId" => "X13584212"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.47
"ListingKey" => "30055809"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
4 => array:11 [
"RoomKey" => "1689365220"
"RoomType" => "Laundry room"
"ListingId" => "X13584212"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.82
"ListingKey" => "30055809"
"RoomLength" => 2.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
5 => array:11 [
"RoomKey" => "1689365221"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13584212"
"RoomLevel" => "Second level"
"RoomWidth" => 3.9
"ListingKey" => "30055809"
"RoomLength" => 4.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
6 => array:11 [
"RoomKey" => "1689365222"
"RoomType" => "Bedroom 2"
"ListingId" => "X13584212"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "30055809"
"RoomLength" => 3.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
7 => array:11 [
"RoomKey" => "1689365223"
"RoomType" => "Bedroom 3"
"ListingId" => "X13584212"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "30055809"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
8 => array:11 [
"RoomKey" => "1689365224"
"RoomType" => "Bedroom 4"
"ListingId" => "X13584212"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "30055809"
"RoomLength" => 3.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
9 => array:11 [
"RoomKey" => "1689365225"
"RoomType" => "Study"
"ListingId" => "X13584212"
"RoomLevel" => "Second level"
"RoomWidth" => 2.47
"ListingKey" => "30055809"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T17:09:53.53Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30055809_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/99bc7ab72ef6aa474d34c4c175186275.webp"
"MediaSize" => 88386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-99bc7ab72ef6aa474d34c4c175186275.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30055809_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/0ebee2c781ff58f2f1a4ae42d2e3b332.webp"
"MediaSize" => 53180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-0ebee2c781ff58f2f1a4ae42d2e3b332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30055809_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/cd5786c869ea18b998240edf8d1b34aa.webp"
"MediaSize" => 63160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-cd5786c869ea18b998240edf8d1b34aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30055809_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/650ac1566d8bf0ccad567f027f2e16d1.webp"
"MediaSize" => 68077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-650ac1566d8bf0ccad567f027f2e16d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30055809_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/f29b3a47a713fc172e56322bf98edce7.webp"
"MediaSize" => 68417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-f29b3a47a713fc172e56322bf98edce7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30055809_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/f339f129a726a4955e8354afae4cb512.webp"
"MediaSize" => 36578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-f339f129a726a4955e8354afae4cb512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30055809_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/4e2fa63f23b419ffe3a88615d7f47e1c.webp"
"MediaSize" => 35765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-4e2fa63f23b419ffe3a88615d7f47e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30055809_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/9eef2dc9b951e456f24594fb15433576.webp"
"MediaSize" => 29472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-9eef2dc9b951e456f24594fb15433576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30055809_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/f1fa717fddf441ce7074a927cb61b780.webp"
"MediaSize" => 29566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-f1fa717fddf441ce7074a927cb61b780.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30055809_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/d3cedec6ce665d6dbfb5822464d66098.webp"
"MediaSize" => 38794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-d3cedec6ce665d6dbfb5822464d66098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30055809_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/2c5eec0251e1ef996448b7f771b0f399.webp"
"MediaSize" => 42243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-2c5eec0251e1ef996448b7f771b0f399.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30055809_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/e83f58de639ae5ecda1461d6c5dfcb0f.webp"
"MediaSize" => 36495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-e83f58de639ae5ecda1461d6c5dfcb0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30055809_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/10214d41bea6879fa3375c1acf5d4f9b.webp"
"MediaSize" => 35560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-10214d41bea6879fa3375c1acf5d4f9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30055809_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/3f53b2b33c816b56b79fcbc79f341689.webp"
"MediaSize" => 24020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-3f53b2b33c816b56b79fcbc79f341689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30055809_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055809/7340fb04b66209821493da71627b3de8.webp"
"MediaSize" => 28828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055809/thumbnail-7340fb04b66209821493da71627b3de8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13584212"
"ResourceRecordKey" => "30055809"
"ModificationTimestamp" => "2026-07-20T17:09:53.51Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055809')"
+"ID": "1642826"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1639484"
+post_author: 1
+"ListingKey": "30051724"
+"ListingId": "40843773"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T13:55:19Z"
+"RFModificationTimestamp": "2026-07-18T16:48:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N3V0J1"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 22, Waterloo, Ontario N3V0J1"
+"Coordinates": array:2 [
0 => -80.5899368
1 => 43.4496854
]
+"Latitude": 43.4496854
+"Longitude": -80.5899368
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "2-Year-New Condo Townhome for Lease in Vista Hills, Waterloo Bright and modern 1,300 sq. ft. condo townhome with quartz counters, stainless steel appliances, elegant flooring, and quality upgrades throughout. Features 2 spacious bedrooms, 2 full bathrooms, a primary suite with walk-in closet and balcony access, plus upper-level laundry and 1 parking spot. Great location close to schools, parks, Costco, shopping, restaurants, and both Waterloo universities. Preferred tenants: families or working professionals with strong credit and stable income. Utilities extra. Avaliable Oct 1, 2026 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T16:48:00.563724+00:00"
+"Directions": "ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Paved driveway"
3 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-18T13:48:39Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T13:48:39Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1687640103"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
1 => array:11 [
"RoomKey" => "1687640104"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
2 => array:11 [
"RoomKey" => "1687640105"
"RoomType" => "Bedroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
3 => array:11 [
"RoomKey" => "1687640106"
"RoomType" => "Full bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
4 => array:11 [
"RoomKey" => "1687640107"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
5 => array:11 [
"RoomKey" => "1687640108"
"RoomType" => "Kitchen"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.6Z"
]
6 => array:11 [
"RoomKey" => "1687640109"
"RoomType" => "Great room"
"ListingId" => "40843773"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051724"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:39.61Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30051724/142-foamflower-place-unit-22-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1300
+"OriginalEntryTimestamp": "2026-07-18T13:48:39.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:7 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051724_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/ad41cc9f4e365553d468bc2ee48e947b.webp"
"MediaSize" => 68065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-ad41cc9f4e365553d468bc2ee48e947b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051724_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/dffd8e1d44d87c085f66c9b017484956.webp"
"MediaSize" => 154024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-dffd8e1d44d87c085f66c9b017484956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051724_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/34a66d950c8b1458e5170c4a0a9839a4.webp"
"MediaSize" => 58055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-34a66d950c8b1458e5170c4a0a9839a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051724_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/6678d6423593dac3cf32bed035673d07.webp"
"MediaSize" => 55504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-6678d6423593dac3cf32bed035673d07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051724_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/c660d106cdfe84a9a01217305a63ef64.webp"
"MediaSize" => 69631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-c660d106cdfe84a9a01217305a63ef64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051724_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/4adbb123a5311dc5ae329458f4bfd1df.webp"
"MediaSize" => 63208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-4adbb123a5311dc5ae329458f4bfd1df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051724_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051724/72b2a091e8b8c985e6d8ad4f215ac1e4.webp"
"MediaSize" => 128388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051724/thumbnail-72b2a091e8b8c985e6d8ad4f215ac1e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843773"
"ResourceRecordKey" => "30051724"
"ModificationTimestamp" => "2026-07-18T13:48:39.57Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051724')"
+"ID": "1639484"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1639287"
+post_author: 1
+"ListingKey": "30049920"
+"ListingId": "40848853"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:25:20Z"
+"RFModificationTimestamp": "2026-07-17T23:11:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1147.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 36, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5883282
1 => 43.449943
]
+"Latitude": 43.449943
+"Longitude": -80.5883282
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury living in the highly sought-after Vista Hills community of West Waterloo. This stunning executive stacked townhouse offers the perfect blend of modern design, comfort, and convenience. Featuring 3 spacious bedrooms and 2.5 bathrooms, this beautifully maintained home boasts an open-concept layout designed for today's lifestyle. The bright and inviting main floor is carpet-free and showcases a stylish kitchen complete with elegant quartz countertops, abundant cabinetry, a large center island with breakfast bar seating, and plenty of workspace for entertaining or everyday living. The spacious living and dining areas flow seamlessly to private outdoor spaces, with two balconies providing the perfect setting to enjoy your morning coffee or unwind after a long day. Upstairs, the primary retreat offers a luxurious ensuite bathroom featuring a sleek glass-enclosed shower, creating a spa-like experience in the comfort of your own home. Located in one of Waterloo's most desirable neighborhoods, Vista Hills is known for its top-rated schools, scenic walking trails, parks, and close proximity to shopping, dining, universities, and major commuter routes. xWhether you're a professional, growing family, or savvy investor, this exceptional home delivers the perfect combination of style, functionality, and an unbeatable location. Don't miss your opportunity to own in one of West Waterloo's premier communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "346.55"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:11:16.005412+00:00"
+"Directions": "Columbia St W to Ladyslipper Dr, Ladyslipper Dr to Foamflower"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878382"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-17T20:18:24Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:18:24Z"
+"Stories": "3.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1687006360"
"RoomType" => "Laundry room"
"ListingId" => "40848853"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
1 => array:11 [
"RoomKey" => "1687006361"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848853"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
2 => array:11 [
"RoomKey" => "1687006362"
"RoomType" => "Bedroom"
"ListingId" => "40848853"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
3 => array:11 [
"RoomKey" => "1687006363"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848853"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
4 => array:11 [
"RoomKey" => "1687006364"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848853"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
5 => array:11 [
"RoomKey" => "1687006365"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848853"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
6 => array:11 [
"RoomKey" => "1687006367"
"RoomType" => "Kitchen"
"ListingId" => "40848853"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.76Z"
]
7 => array:11 [
"RoomKey" => "1687006369"
"RoomType" => "Great room"
"ListingId" => "40848853"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30049920"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:18:24.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30049920/142-foamflower-place-unit-36-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1147
+"OriginalEntryTimestamp": "2026-07-17T20:18:24.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205009"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30049920_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/6d97706863ba5ca55fe06845883212d3.webp"
"MediaSize" => 68851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-6d97706863ba5ca55fe06845883212d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-story townhome complex featuring a contemporary facade with varied paneling, expansive windows, glass-paneled balconies, and individual entryways"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30049920_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/6297b93d954db34f1a4aa0a6b409b473.webp"
"MediaSize" => 85087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-6297b93d954db34f1a4aa0a6b409b473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome complex featuring a multi-toned facade, private balconies, and a paved parking area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30049920_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/d6f91bce31547cd16710d68a5d5b90f2.webp"
"MediaSize" => 44454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-d6f91bce31547cd16710d68a5d5b90f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a full-light door with a matte black frame, complemented by light grey brick and horizontal siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30049920_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/1405dabdf690e3a77b9196f6f8b6d789.webp"
"MediaSize" => 52794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-1405dabdf690e3a77b9196f6f8b6d789.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring light wood-finish flooring, a kitchen island with a light-toned countertop, and recessed ceiling details"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30049920_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/ff4a6afbc46f11c885901e4896ee8019.webp"
"MediaSize" => 57843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-ff4a6afbc46f11c885901e4896ee8019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, stainless steel appliances, a white subway tile backsplash, and a granite-look island with a built-in double sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30049920_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/c4431873ea24903e4a23903f5f63a311.webp"
"MediaSize" => 63087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049920/thumbnail-c4431873ea24903e4a23903f5f63a311.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring wood-finish cabinetry, stainless steel appliances, a white subway tile backsplash, and a large island with an undermount double sink and granite-style countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848853"
"ResourceRecordKey" => "30049920"
"ModificationTimestamp" => "2026-07-17T20:18:24.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30049920_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049920/8c7b963efc895617bcfe8b34931d6981.webp"
"MediaSize" => 61728
…9
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049920')"
+"ID": "1639287"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+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 [ …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/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 [ …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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30033009')"
+"ID": "1637188"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+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 {#25375
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+post_id: "1600662"
+post_author: 1
+"ListingKey": "30000036"
+"ListingId": "X13532956"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:45:54Z"
+"RFModificationTimestamp": "2026-07-07T19:09:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "14 - 142 FOAMFLOWER PLACE, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.589669
1 => 43.44955
]
+"Latitude": 43.44955
+"Longitude": -80.589669
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 142 Foamflower Place Unit #14, a rare opportunity to lease a stunning brand new condo townhome in the highly desirable Vista Hills community of Waterloo. This beautifully designed "Viola" model offers approximately 1,300 sq. ft. of modern finished living space, perfectly blending style, comfort, and functionality. From the moment you step inside, you'll appreciate the bright open-concept layout, elegant laminate flooring, upgraded finishes, and thoughtfully selected details throughout. The contemporary kitchen features rich chocolate brown cabinetry, sleek quartz countertops, a spacious center island, and brand-new stainless steel appliances, making it ideal for both everyday living and entertaining. The inviting Great Room opens onto a private balcony, creating the perfect space to relax and unwind. The upper level offers two spacious bedrooms, including a luxurious primary retreat complete with a walk-in closet, private balcony access, and a spa-inspired 4-piece ensuite featuring an upgraded glass-enclosed shower. The second bedroom is generously sized and conveniently served by another full 4-piece bathroom, making this home ideal for families, professionals, or roommates. Additional conveniences include upper-level laundry with a stackable washer and dryer, linen storage, zebra blinds already installed, and one dedicated parking space. Located just minutes from top-rated schools, beautiful parks, Costco, shopping centers, restaurants, and both the University of Waterloo and Wilfrid Laurier University, this exceptional property offers unmatched convenience in one of Waterloo's fastest-growing communities. Owners prefer families or working professionals with strong credit and stable income. Utilities are extra. Don't miss your chance to enjoy upscale, stress-free living in this AAA+ location, schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:09:24.951939+00:00"
+"Directions": "Cross Streets: Columbia St. ** Directions: ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:11:08Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:11:07Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30000036/14-142-foamflower-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "1280"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-07T17:11:07.71Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000036')"
+"ID": "1600662"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 22
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]