array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29987586 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1590861"
+post_author: 1
+"ListingKey": "29987586"
+"ListingId": "40844583"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:35:14Z"
+"RFModificationTimestamp": "2026-07-03T22:56:26Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2958.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P5"
+"UnparsedAddress": "461 COLUMBIA Street W Unit# 49, Waterloo, Ontario N2T2P5"
+"Coordinates": array:2 [
0 => -80.5662502
1 => 43.4667817
]
+"Latitude": 43.4667817
+"Longitude": -80.5662502
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare found elegant bungalow/two-storey condo as your next dream home. much bigger inside than from appearance. prime location in Waterloo's Beechwood neighborhood. Clean and well maintained. Perfect for single families, multi-generational living, or downsizers, minutes to universities, shopping centers, public library, trails, the Laurel Creek Reservoir, COSTCO, hospitals, and YMCA. living room has vaulted ceilings, large windows, and abundant natural sunlight. two spacious bedrooms on main floor, large master bedroom has suite and walk in closet. Second floor offers extra bedroom, a bathroom, and a versatile loft-like space, perfect for relaxing or working from home. The finished basement has recreation room, den, a cozy gas fireplace, and a 2-piece bathroom. main floor laundry for your convenience. Detached double garage, and a very private cozy back yard for your family's quite enjoyment. carpet downstairs will be replaced with new vinyl flooring. won't last long! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Garage door opener"
]
+"AssociationFee": "363"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T22:56:16.645439+00:00"
+"Directions": "Fischer-Hallman Rd. N. and Columbia St.W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564082"
+"ListOfficeKey": "222711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:3 [
0 => "Detached Garage"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T21:29:30Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T21:29:30Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "461"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1674438137"
"RoomType" => "Loft"
"ListingId" => "40844583"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
1 => array:11 [
"RoomKey" => "1674438138"
"RoomType" => "Full bathroom"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
2 => array:11 [
"RoomKey" => "1674438139"
"RoomType" => "Den"
"ListingId" => "40844583"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
3 => array:11 [
"RoomKey" => "1674438140"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844583"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
4 => array:11 [
"RoomKey" => "1674438141"
"RoomType" => "Recreation room"
"ListingId" => "40844583"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "19'10'' x 38'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
5 => array:11 [
"RoomKey" => "1674438142"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844583"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "5' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
6 => array:11 [
"RoomKey" => "1674438143"
"RoomType" => "Bedroom"
"ListingId" => "40844583"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
7 => array:11 [
"RoomKey" => "1674438144"
"RoomType" => "Laundry room"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "6'8'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
8 => array:11 [
"RoomKey" => "1674438145"
"RoomType" => "Bedroom"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
9 => array:11 [
"RoomKey" => "1674438146"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
10 => array:11 [
"RoomKey" => "1674438147"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
11 => array:11 [
"RoomKey" => "1674438148"
"RoomType" => "Kitchen"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
12 => array:11 [
"RoomKey" => "1674438149"
"RoomType" => "Dining room"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.02Z"
]
13 => array:11 [
"RoomKey" => "1674438150"
"RoomType" => "Living room"
"ListingId" => "40844583"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987586"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T21:29:30.03Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987586/461-columbia-street-w-unit-49-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1725
+"BelowGradeFinishedArea": 1233
+"OriginalEntryTimestamp": "2026-07-03T21:29:29.98Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1130381"
+"ListOfficeNationalAssociationId": "1197443"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29987586_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/edd622ae235934730a27b680a167e2a7.webp"
"MediaSize" => 99050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-edd622ae235934730a27b680a167e2a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987586_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/4f44326f4b9f4bb26ddff37b9caa47cc.webp"
"MediaSize" => 156657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-4f44326f4b9f4bb26ddff37b9caa47cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry featuring a dark green door with decorative sidelight, concrete steps, and a white support column"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987586_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/0b297cb07203f50bdb1ea90e30946fa5.webp"
"MediaSize" => 37718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-0b297cb07203f50bdb1ea90e30946fa5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white paneled door with brass hardware, an arched doorway, and built-in overhead lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987586_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/8fd9debbce84a06df6ee642d61b19b83.webp"
"MediaSize" => 56656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-8fd9debbce84a06df6ee642d61b19b83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceiling living area featuring a large arched window with vertical blinds and decorative valance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987586_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/25cef6c9c4be0b0856fda2d6b0800573.webp"
"MediaSize" => 44362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-25cef6c9c4be0b0856fda2d6b0800573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29987586_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/cf9eb848f70548c9e6f3759417eba9bb.webp"
"MediaSize" => 58003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-cf9eb848f70548c9e6f3759417eba9bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, and a double basin stainless steel sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29987586_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/f05c676f6d20379cba732379d0080e57.webp"
"MediaSize" => 57603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-f05c676f6d20379cba732379d0080e57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, a stainless steel refrigerator, white electric range, and a stainless steel range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29987586_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/0d1b824b51a2779da8f100d22dd8024d.webp"
"MediaSize" => 68589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-0d1b824b51a2779da8f100d22dd8024d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceiling living space featuring a drum pendant light fixture, a large arched window with vertical blinds and draped valance, dark wood-finish flooring, and a granite-finish countertop visible i"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29987586_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/b8706cff30f45e58451fdc2991b4eaf2.webp"
"MediaSize" => 60933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-b8706cff30f45e58451fdc2991b4eaf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29987586_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/49355868f492e5c764967629881cb125.webp"
"MediaSize" => 52415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-49355868f492e5c764967629881cb125.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring throughout, featuring a window with sheer curtains, a decorative ceiling light fixture, and two panel-door closets with brass-finish hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29987586_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/dc624901169579f65f260b6a56b2d683.webp"
"MediaSize" => 37463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-dc624901169579f65f260b6a56b2d683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, white baseboards, and a window with a white frame and sill"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29987586_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/fa1bf233a0ecd45bde13e65d3dee7cc4.webp"
"MediaSize" => 52458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-fa1bf233a0ecd45bde13e65d3dee7cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, neutral-toned walls, and a large window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29987586_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/2451d2540a82a3f86cebc2f3a045cb11.webp"
"MediaSize" => 33278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-2451d2540a82a3f86cebc2f3a045cb11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29987586_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/7a606d54121dc1e36a0a7a8361a498fa.webp"
"MediaSize" => 55459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-7a606d54121dc1e36a0a7a8361a498fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish fireplace with dark firebox, wall-to-wall carpet, drop ceiling with recessed lighting, and wall-mounted baseboard trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29987586_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/4f879638577852eac4b3ea87d4e18364.webp"
"MediaSize" => 46007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-4f879638577852eac4b3ea87d4e18364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29987586_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/0f0a6201449762ad4379e70e154dcb58.webp"
"MediaSize" => 47409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-0f0a6201449762ad4379e70e154dcb58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with recessed lighting and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29987586_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/a2f13dabc9d49819dade731dd402ed12.webp"
"MediaSize" => 31980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-a2f13dabc9d49819dade731dd402ed12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned walls featuring chair rail molding and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29987586_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/4e468ceb9acd8328c0d4c3063ab9330c.webp"
"MediaSize" => 36408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-4e468ceb9acd8328c0d4c3063ab9330c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a shower-tub combination with a white basin and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29987586_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/023f50f9d2c330933ffeb86fd4a6f349.webp"
"MediaSize" => 41715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-023f50f9d2c330933ffeb86fd4a6f349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a wood-finish vanity with an integrated sink, a large wall-mounted mirror, a corner soaking tub with white tile surround, a toilet, and a window for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29987586_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/641848efa55ffdfa6039f9edf5d9e7f5.webp"
"MediaSize" => 36780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-641848efa55ffdfa6039f9edf5d9e7f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Soaking tub with chrome fixtures, tiled surround, and adjacent window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29987586_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/40e73b777b43c50b709889a8b7f5ba7b.webp"
"MediaSize" => 29845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-40e73b777b43c50b709889a8b7f5ba7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white basin and chrome faucet, a framed wall mirror, a toilet, and light-toned wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29987586_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/5d26c1b97fd68219a407a2dcfae7e8a0.webp"
"MediaSize" => 45547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-5d26c1b97fd68219a407a2dcfae7e8a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area featuring white cabinetry, a utility sink, and a paneled door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29987586_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/83ca85944567c95c2ab0e41e2c72fed4.webp"
"MediaSize" => 121540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-83ca85944567c95c2ab0e41e2c72fed4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Low-maintenance outdoor space featuring artificial turf, a concrete patio, and a privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29987586_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/81a62c702df5e6cbdaab097b5121ce79.webp"
"MediaSize" => 94571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-81a62c702df5e6cbdaab097b5121ce79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Side patio area featuring a concrete surface, white vinyl siding, and a brick pathway bordered by established shrubs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29987586_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/d3199db90c7a83c1350a662514db255e.webp"
"MediaSize" => 91533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-d3199db90c7a83c1350a662514db255e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29987586_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/cb2fd70db612e4258164cf6894d0dbb3.webp"
"MediaSize" => 128396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-cb2fd70db612e4258164cf6894d0dbb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29987586_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/0d2b4deb6c7472306e0dcecad495e297.webp"
"MediaSize" => 142529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-0d2b4deb6c7472306e0dcecad495e297.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29987586_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/55d6c56a571ceb605072734441e839de.webp"
"MediaSize" => 138957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-55d6c56a571ceb605072734441e839de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick paver walkway flanked by manicured shrubs and mature plantings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29987586_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987586/2ab6544431a1ad6b9693899436bb31f0.webp"
"MediaSize" => 81223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987586/thumbnail-2ab6544431a1ad6b9693899436bb31f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence with arched window and a tiered roofline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844583"
"ResourceRecordKey" => "29987586"
"ModificationTimestamp" => "2026-07-03T21:29:29.99Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987586')"
+"ID": "1590861"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 222711" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24883
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564082" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29987586'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29987586'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25243
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29987586' 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.5662502 43.4667817)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25296
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1587851"
+post_author: 1
+"ListingKey": "29980985"
+"ListingId": "X13514978"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T20:05:08Z"
+"RFModificationTimestamp": "2026-07-02T20:42:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L1"
+"UnparsedAddress": "MAIN - 668A BUTTERNUT AVENUE, Waterloo, Ontario N2V2L1"
+"Coordinates": array:2 [
0 => -80.586562
1 => 43.465505
]
+"Latitude": 43.465505
+"Longitude": -80.586562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful freehold semi-detached home available for lease starting May 1. This well-maintained property offers abundant natural sunlight throughout the day, creating a bright and welcoming living space. Enjoy a private deck, perfect for relaxing or entertaining outdoors. The upper-level tenant will be responsible for 70% of the total utilities. The home also includes two designated parking spaces for added convenience. (id:62650)"
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T20:25:48.834355+00:00"
+"Directions": "Columbia Forest Blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906649"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:56:16Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:56:16Z"
+"Stories": "2.0"
+"StreetName": "Butternut"
+"StreetNumber": "668A"
+"StreetSuffix": "Avenue"
+"Utilities": array:1 [
0 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1673558809"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13514978"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29980985"
"RoomLength" => 4.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T19:56:16.29Z"
]
1 => array:11 [
"RoomKey" => "1673558810"
"RoomType" => "Bedroom 2"
"ListingId" => "X13514978"
"RoomLevel" => "Second level"
"RoomWidth" => 2.72
"ListingKey" => "29980985"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T19:56:16.29Z"
]
2 => array:11 [
"RoomKey" => "1673558811"
"RoomType" => "Bedroom 3"
"ListingId" => "X13514978"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29980985"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T19:56:16.29Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980985/main-668a-butternut-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2550
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-02T19:56:16.26Z"
+"ListAgentNationalAssociationId": "1220268"
+"ListOfficeNationalAssociationId": "1201577"
+"Media": array:13 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29980985_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/ae5e2b4d23f2828b91448128fbb0bbca.webp"
"MediaSize" => 146461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-ae5e2b4d23f2828b91448128fbb0bbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29980985_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/5fce8160a2a013ea8d770b535542bbc4.webp"
"MediaSize" => 137304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-5fce8160a2a013ea8d770b535542bbc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29980985_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/726af4d56395f00a2fcf62ea96df63e7.webp"
"MediaSize" => 138108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-726af4d56395f00a2fcf62ea96df63e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29980985_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/f1ecd83ef57746082c8bb65cfc7bcda4.webp"
"MediaSize" => 133696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-f1ecd83ef57746082c8bb65cfc7bcda4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29980985_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/444f27a8bf3596d142daeaf6502e8fbc.webp"
"MediaSize" => 120786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-444f27a8bf3596d142daeaf6502e8fbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29980985_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/6ca85da4d6710d4b5caee13ab74073a1.webp"
"MediaSize" => 104502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-6ca85da4d6710d4b5caee13ab74073a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29980985_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/be38dd3d8e13da0ab72f9e2826011e28.webp"
"MediaSize" => 148768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-be38dd3d8e13da0ab72f9e2826011e28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29980985_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/e60a64f716719bebcb8333e594886453.webp"
"MediaSize" => 161195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-e60a64f716719bebcb8333e594886453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29980985_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/886ae86f216037fa818ac99fece7fb00.webp"
"MediaSize" => 154140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-886ae86f216037fa818ac99fece7fb00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29980985_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/21f584429acc040a39d03f37a7e68950.webp"
"MediaSize" => 144211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-21f584429acc040a39d03f37a7e68950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29980985_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/40cdaae26bd8fe328df1dffd98306f6d.webp"
"MediaSize" => 106281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-40cdaae26bd8fe328df1dffd98306f6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29980985_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/cb4eacb99c40a4398842fafc07bee97b.webp"
"MediaSize" => 57520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-cb4eacb99c40a4398842fafc07bee97b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29980985_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980985/1e1e0c8e7c603ea37429e7a73c8de095.webp"
"MediaSize" => 142850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980985/thumbnail-1e1e0c8e7c603ea37429e7a73c8de095.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13514978"
"ResourceRecordKey" => "29980985"
"ModificationTimestamp" => "2026-07-02T19:56:16.27Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980985')"
+"ID": "1587851"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1585671"
+post_author: 1
+"ListingKey": "29980546"
+"ListingId": "40844747"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:20:02Z"
+"RFModificationTimestamp": "2026-07-02T19:36:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1560.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L1"
+"UnparsedAddress": "668A BUTTERNUT Avenue Unit# Main, Waterloo, Ontario N2V2L1"
+"Coordinates": array:2 [
0 => -80.5866181
1 => 43.4654843
]
+"Latitude": 43.4654843
+"Longitude": -80.5866181
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful freehold semi-detached home available for lease starting May 1. This well-maintained property offers abundant natural sunlight throughout the day, creating a bright and welcoming living space. Enjoy a private deck, perfect for relaxing or entertaining outdoors. The upper-level tenant will be responsible for 70% of the total utilities. The home also includes two designated parking spaces for added convenience. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:36:27.386587+00:00"
+"Directions": "Columbia Forest Blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224068"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:12:22Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:12:22Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "668"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3027"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1673521584"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844747"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29980546"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:11:05.59Z"
]
1 => array:11 [
"RoomKey" => "1673521585"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844747"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29980546"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:11:05.59Z"
]
2 => array:11 [
"RoomKey" => "1673521586"
"RoomType" => "Bedroom"
"ListingId" => "40844747"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29980546"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:11:05.59Z"
]
3 => array:11 [
"RoomKey" => "1673521587"
"RoomType" => "Bedroom"
"ListingId" => "40844747"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29980546"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:11:05.59Z"
]
4 => array:11 [
"RoomKey" => "1673521588"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844747"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29980546"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:11:05.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980546/668a-butternut-avenue-unit-main-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2550
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 98.0
+"AboveGradeFinishedArea": 1560
+"OriginalEntryTimestamp": "2026-07-02T19:11:05.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1467479"
+"ListOfficeNationalAssociationId": "1379702"
+"Media": array:13 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29980546_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/f1d95e865ca9558b2c9bd16f8d68d52c.webp"
"MediaSize" => 65400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-f1d95e865ca9558b2c9bd16f8d68d52c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, marble-patterned countertops, and tile flooring"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29980546_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/2fb199f1a899f262a34247a20116677b.webp"
"MediaSize" => 69919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-2fb199f1a899f262a34247a20116677b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29980546_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/7ed762288bce8ea5dbe4da9d6da2a9c5.webp"
"MediaSize" => 63580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-7ed762288bce8ea5dbe4da9d6da2a9c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, neutral wall tones, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.91Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29980546_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/cc58f9fcd611a2b655ffaee40e73809e.webp"
"MediaSize" => 60499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-cc58f9fcd611a2b655ffaee40e73809e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light neutral wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29980546_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/e0b41b4c0bbcd91513dd02ec30dca3a0.webp"
"MediaSize" => 49818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-e0b41b4c0bbcd91513dd02ec30dca3a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a neutral wall color, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29980546_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/16453640eff9a22f04a5262d47f0cb5b.webp"
"MediaSize" => 44782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-16453640eff9a22f04a5262d47f0cb5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a window with horizontal blinds, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29980546_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/27ae9d3782678e03cfcc335d0c761658.webp"
"MediaSize" => 77279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-27ae9d3782678e03cfcc335d0c761658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper-level space featuring a vaulted ceiling and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.93Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29980546_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/0358fcfa92f98ff8996e2eef79f4b784.webp"
"MediaSize" => 67687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-0358fcfa92f98ff8996e2eef79f4b784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper landing featuring hardwood railing and balusters, wood-finish flooring, and multiple panel doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29980546_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/925749f418d5bb5e2d2b08f2431b026a.webp"
"MediaSize" => 72237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-925749f418d5bb5e2d2b08f2431b026a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29980546_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/33d5c349b3836da50308043a70e4838a.webp"
"MediaSize" => 25930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-33d5c349b3836da50308043a70e4838a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring recessed lighting, panel doors, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29980546_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/a7d0346a014db2119a8d656cd372839f.webp"
"MediaSize" => 56370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-a7d0346a014db2119a8d656cd372839f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light neutral wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.19Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29980546_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/40a1be15dc28fce8be4d3a6e91f5ad77.webp"
"MediaSize" => 49969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-40a1be15dc28fce8be4d3a6e91f5ad77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a speckled countertop, an undermount sink with chrome faucet, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29980546_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29980546/e5e7f028ec1e89f049ddb0462d2a8741.webp"
"MediaSize" => 68706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29980546/thumbnail-e5e7f028ec1e89f049ddb0462d2a8741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with wood-finish cabinetry and a single basin sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844747"
"ResourceRecordKey" => "29980546"
"ModificationTimestamp" => "2026-07-02T19:12:22.21Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980546')"
+"ID": "1585671"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1574305"
+post_author: 1
+"ListingKey": "29963606"
+"ListingId": "40843614"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T02:40:03Z"
+"RFModificationTimestamp": "2026-06-28T03:07:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 780.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K7"
+"UnparsedAddress": "624A RUMMELHARDT Drive, Waterloo, Ontario N2T2K7"
+"Coordinates": array:2 [
0 => -80.5703469
1 => 43.4503135
]
+"Latitude": 43.4503135
+"Longitude": -80.5703469
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your next home! This property offers the perfect balance of peace and convenience, making it an ideal fit for working professionals and families. Situated in a quiet, friendly area, it is just minutes away from Costco, Canadian Tire, a variety of restaurants, and everyday shopping. It is the perfect spot for anyone looking for a reliable, accessible, and calm place to live. Enjoy a hassle-free lifestyle with all your daily essentials right at your doorstep. Book your shopwing today! (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T03:06:58.648674+00:00"
+"Directions": "Erb St. W. , then left on Erbsville Ct. and take 1st left is Rummelhardt."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Vinyl siding"
2 => "Shingles"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192748"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T02:31:40Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T02:31:40Z"
+"Stories": "1.0"
+"StreetName": "RUMMELHARDT"
+"StreetNumber": "624"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1669925795"
"RoomType" => "Bedroom"
"ListingId" => "40843614"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29963606"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T02:31:40.41Z"
]
1 => array:11 [
"RoomKey" => "1669925796"
"RoomType" => "Bedroom"
"ListingId" => "40843614"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29963606"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T02:31:40.41Z"
]
2 => array:11 [
"RoomKey" => "1669925797"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843614"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29963606"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T02:31:40.41Z"
]
3 => array:11 [
"RoomKey" => "1669925798"
"RoomType" => "Living room/Dining room"
"ListingId" => "40843614"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29963606"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T02:31:40.41Z"
]
4 => array:11 [
"RoomKey" => "1669925799"
"RoomType" => "Kitchen"
"ListingId" => "40843614"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29963606"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T02:31:40.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963606/624a-rummelhardt-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1899
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 780
+"OriginalEntryTimestamp": "2026-06-28T02:31:40.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1441696"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29963606_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/b6fc47129460b48a34bbcec26e0504fa.webp"
"MediaSize" => 177831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-b6fc47129460b48a34bbcec26e0504fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring an integrated garage, bay window, and a paved stone driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29963606_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/c92dd0ffeaea31e6f789b5f51c49fccb.webp"
"MediaSize" => 164049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-c92dd0ffeaea31e6f789b5f51c49fccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with white garage door, featuring a paver driveway and a gravel side path"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29963606_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/13fe50820282f437237819850f5db958.webp"
"MediaSize" => 159248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-13fe50820282f437237819850f5db958.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29963606_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/b3693068b54b3cf2cc77e7d3f1831041.webp"
"MediaSize" => 70078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-b3693068b54b3cf2cc77e7d3f1831041.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior area featuring wood-finish flooring transitioning to square floor tiles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29963606_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/e73ea75bec473055e8fef6163d4b6523.webp"
"MediaSize" => 83008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-e73ea75bec473055e8fef6163d4b6523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior living space featuring a black fireplace with mantle, sliding glass patio door, and mixed flooring with wood-finish planks and square tiles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29963606_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/d5540b43faf960c2ff5f0bfaefb3ff91.webp"
"MediaSize" => 89995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-d5540b43faf960c2ff5f0bfaefb3ff91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29963606_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/ef51c093194255c15940b7b0f77a19bd.webp"
"MediaSize" => 96447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-ef51c093194255c15940b7b0f77a19bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29963606_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/b18bc946aea1e7c014586489ab4d9359.webp"
"MediaSize" => 37019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-b18bc946aea1e7c014586489ab4d9359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring neutral wall paint, dark carpet flooring, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29963606_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/43101c285510b0edaffedfb408d12b03.webp"
"MediaSize" => 45783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-43101c285510b0edaffedfb408d12b03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29963606_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/dc01cd6d5291888e87ff48d5df7b1788.webp"
"MediaSize" => 42667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-dc01cd6d5291888e87ff48d5df7b1788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower with clear glass enclosure and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29963606_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29963606/8391c14b8d4405ed5bbb368084dd6d94.webp"
"MediaSize" => 41949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29963606/thumbnail-8391c14b8d4405ed5bbb368084dd6d94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a light wood-finish vanity with an integrated sink, polished chrome faucet, and a circular wall mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843614"
"ResourceRecordKey" => "29963606"
"ModificationTimestamp" => "2026-06-28T02:31:40.31Z"
]
11 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963606')"
+"ID": "1574305"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1569904"
+post_author: 1
+"ListingKey": "29958055"
+"ListingId": "X13493376"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:00:13Z"
+"RFModificationTimestamp": "2026-06-26T16:52:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "1 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "One Bedroom for lease in this beautiful and Cozy End-Unit Townhouse In Desirable Beechwood! Main Floor Features A Large, Comfortable Living Space And Newer Kitchen Appliances. Student Welcome. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T16:52:35.012034+00:00"
+"Directions": "Keats Way And Fischer Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091671"
+"ListOfficeKey": "289061"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-26T15:52:19Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T15:52:19Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"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/29958055/1-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"TotalActualRent": 750
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-26T15:52:19.77Z"
+"ListAgentNationalAssociationId": "1364249"
+"ListOfficeNationalAssociationId": "1374074"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958055')"
+"ID": "1569904"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1564332"
+post_author: 1
+"ListingKey": "29951981"
+"ListingId": "40842491"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:40:11Z"
+"RFModificationTimestamp": "2026-06-25T19:43:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K9"
+"UnparsedAddress": "589 BEECHWOOD Drive Unit# 43, Waterloo, Ontario N2T2K9"
+"Coordinates": array:2 [
0 => -80.5651093
1 => 43.4490937
]
+"Latitude": 43.4490937
+"Longitude": -80.5651093
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Offered for Lease, an opportunity to enjoy the condo lifestyle in one of Waterloo's most desirable neighbourhoods, Beechwood! You will appreciate the main floor powder room (2 piece bath), spacious and well appointed eat in kitchen and a bright living room with soaring ceilings, a wood burning fireplace and a walk out to the backyard. The upper floor features 3 spacious bedrooms, the main bathroom (4 piece bath) and a skylight provides plenty of natural light. Two parking spaces! One driveway space and one garage space. Excellent schools. Easy access to banking, groceries, Costco and the Boardwalk. Arrange your visit today! Potential tenants must provide an OREA Rental Application including the names of all adult and minor tenants, Credit Report & Score (full report) for all adult tenants, Employment letter or recent pay stubs for all adult tenants, Proof of ID and References from previous landlord(s) (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"AssociationFee": "351.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Property Management"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:42:57.407923+00:00"
+"Directions": "ERB STREET & BEECHWOOD DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563429"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T16:32:00Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T16:32:00Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "589"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_43_589_beechwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951981/589-beechwood-drive-unit-43-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2026-06-25T16:32:00.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1126015"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951981')"
+"ID": "1564332"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1552779"
+post_author: 1
+"ListingKey": "29934485"
+"ListingId": "40841747"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:00:18Z"
+"RFModificationTimestamp": "2026-06-26T01:06:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5K1"
+"UnparsedAddress": "67 KAREN Walk Unit# Lower, Waterloo, Ontario N2L5K1"
+"Coordinates": array:2 [
0 => -80.546221
1 => 43.4584627
]
+"Latitude": 43.4584627
+"Longitude": -80.546221
+"YearBuilt": 1979
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Lower Unit Duplex for Rent – 67 Karen Walk, Waterloo, ON Available September 1st Bright lower duplex unit located in a desirable Waterloo neighbourhood, offering comfort, convenience, and a functional layout. Property Details: - 2 Bedrooms | 1 Bathroom - Lower Unit Duplex - Approx. 750 sq ft - 1 Driveway Parking Spot Included - Utilities approximately $50–$80/month - In-Unit Laundry - Central A/C - Central Heating This comfortable unit is ideal for small families, couples, students, or working professionals looking for a well-located home with modern conveniences. Conveniently situated close to schools, parks, shopping, public transit, and everyday amenities. Contact for more information or to schedule a viewing. Available date Sept 1st. Tenanted Property - 24 hours notice required (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-21T19:32:52.984194+00:00"
+"Directions": "KEATS WAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2178011"
+"ListOfficeKey": "152170"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-23T04:49:57Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:51:32Z"
+"Stories": "1.0"
+"StreetName": "KAREN"
+"StreetNumber": "67"
+"StreetSuffix": "Walk"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29934485/67-karen-walk-unit-lower-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-21T18:10:26.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1427985"
+"ListOfficeNationalAssociationId": "1179396"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934485')"
+"ID": "1552779"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1548454"
+post_author: 1
+"ListingKey": "29929777"
+"ListingId": "X13468074"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:30:09Z"
+"RFModificationTimestamp": "2026-06-23T15:36:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "55 - 461 BEECHWOOD PLACE, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.557671
1 => 43.451655
]
+"Latitude": 43.451655
+"Longitude": -80.557671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Freshly Painted 2-Bed, 2-Bath End Unit Condo Townhouse in Waterloo. Step Into This Freshly Painted And Move-In-Ready 2-Bedroom, 2-Bathroom Condo Townhouse, Offering Approximately 1000Sq Ft Of Thoughtfully Designed Living Space In One Of Waterloos Most Convenient Locations. This Bright And Welcoming Home Features An Open-Concept Living And Dining Area, A Functional Kitchen With A Newer Fridge, And The Added Bonus Of In-Suite Laundry With A Newer Washer & Dryer. The Second Bedroom And Full Bath Offer Flexibility For Families, Guests, Or A Home Office Setup. Located Close To Universities, Tech Companies, Shopping, Public Transit, And Parks, This Home Offers A Balanced Lifestyle Of Comfort And Accessibility!! (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:49:51.091745+00:00"
+"Directions": "Erb St W & Beechwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1907315"
+"ListOfficeKey": "51317"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:21:07Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:21:07Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "461"
+"StreetSuffix": "Place"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929777/55-461-beechwood-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T18:32:58.46Z"
+"ListAgentNationalAssociationId": "1220644"
+"ListOfficeNationalAssociationId": "1003156"
+"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": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929777')"
+"ID": "1548454"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1477182"
+post_author: 1
+"ListingKey": "29828853"
+"ListingId": "40834715"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:21:08Z"
+"RFModificationTimestamp": "2026-06-02T16:49:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 688.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J7"
+"UnparsedAddress": "537 VALHALLA Crescent Unit# B, Waterloo, Ontario N2T2J7"
+"Coordinates": array:2 [
0 => -80.5702338
1 => 43.4535178
]
+"Latitude": 43.4535178
+"Longitude": -80.5702338
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful lower unit in the sought after subdivision of Upper Beechwood in Waterloo. Less than 1 year old complete with beautiful fully equipped kitchen with SS new appliances, En-suite laundry, upgraded finishing, large & bright windows with separate heat/cool thermostat control. Tenant to pay 1/3 of all utility’s bills including the internet. One parking space available a second one is available with an extra charge of a $50/month. Near all amenities, shopping, medical Centre, movie theatre, restaurants and more. Short Driving distance to Wilfred Laurier University & UW, Shows AAA and available immediately. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
]
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-30T13:34:40.933628+00:00"
+"Directions": "Erbsville Rd / Paradise Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025688"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2026-05-30T12:49:14Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:12:53Z"
+"Stories": "1.0"
+"StreetName": "VALHALLA"
+"StreetNumber": "537"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29828853/537-valhalla-crescent-unit-b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1700
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 688
+"OriginalEntryTimestamp": "2026-05-30T12:49:14.72Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1305261"
+"ListOfficeNationalAssociationId": "1004370"
+"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": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29828853')"
+"ID": "1477182"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1472850"
+post_author: 1
+"ListingKey": "29822723"
+"ListingId": "X13212046"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T13:55:34Z"
+"RFModificationTimestamp": "2026-06-08T13:59:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N9"
+"UnparsedAddress": "7 - 360 CORNRIDGE PLACE, Waterloo, Ontario N2T2N9"
+"Coordinates": array:2 [
0 => -80.57714
1 => 43.460212
]
+"Latitude": 43.460212
+"Longitude": -80.57714
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained town home located in upper Beechwood community, backing to ravine green space and trail. This house featuring 3 bed rooms, 2 bathroom with finished basement for additional space (recreation room/office, laundry room, 3PC washroom, in-law potential). Upgraded kitchen has extended cabinetry for more storage, Quartz Countertops, Stainless Steel Appliances. Freshly Painted, fully fenced yard, quiet friendly neighborhood. Attached garage and one additional parking space in drive way. Situated in prime Waterloo Location a) Near the University of Waterloo, b) Close to top-rated schools, c) Public transit, Gym, Theater, lake trails and all amenities d) Popular shopping destinations (Costco, Sobeys, Canadian Tire, and more), e) The boardwalk. Ideal for families, professionals, or students. Ready to move in (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "345"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T05:19:10.353588+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Columbia St. ** Directions: Erbsville Rd and Cornridge place intersection, take left in Cornridge place."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167766"
+"ListOfficeKey": "300443"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T04:45:32Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T13:45:33Z"
+"Stories": "2.0"
+"StreetName": "Cornridge"
+"StreetNumber": "360"
+"StreetSuffix": "Place"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29822723/7-360-cornridge-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-29T04:45:32.3Z"
+"ListAgentNationalAssociationId": "1418479"
+"ListOfficeNationalAssociationId": "1487969"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 37
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29822723')"
+"ID": "1472850"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.36 seconds"
]
]