array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29980546 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: "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"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289628" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24846
+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 2224068" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24804
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29980546'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25174
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29980546'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29980546' 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.5866181 43.4654843)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25243
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1592160"
+post_author: 1
+"ListingKey": "29988324"
+"ListingId": "40845172"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T18:25:17Z"
+"RFModificationTimestamp": "2026-07-04T18:34:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 773.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E9"
+"UnparsedAddress": "244 LADYSLIPPER Drive Unit# LOWER, Waterloo, Ontario N2V0E9"
+"Coordinates": array:2 [
0 => -80.5918946
1 => 43.455862
]
+"Latitude": 43.455862
+"Longitude": -80.5918946
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into modern living with this professionally finished (2025) 2-bedroom, 1-bathroom home. The stylish kitchen features beautiful cabinetry, elegant quartz countertops, abundant storage, stainless steel appliances, and a sleek over-the-range microwave. The spacious layout is filled with natural light thanks to large windows throughout, while window coverings (curtains) are included for added comfort and privacy. Durable subflooring has been installed throughout the unit, adding to its quality and longevity. Enjoy the convenience of a private garage with remote control access, plus even more storage space to keep everything organized. Located in a fantastic area of Waterloo, this home offers incredible convenience. You're just 5 minutes from Costco and other essential amenities. Enjoy added privacy with no backyard neighbours, and families will appreciate being just steps from great schools. Bright, stylish, and move-in ready, this is the perfect place to call home. Bonus: A 2% discount is available for tenants (terms and conditions apply). (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T00:51:14.027472+00:00"
+"Directions": "Columbia St W / Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190750"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T23:48:11Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T18:18:24Z"
+"Stories": "2.0"
+"StreetName": "LADYSLIPPER"
+"StreetNumber": "244"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1675111973"
"RoomType" => "Laundry room"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
1 => array:11 [
"RoomKey" => "1675111974"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
2 => array:11 [
"RoomKey" => "1675111975"
"RoomType" => "Bedroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
3 => array:11 [
"RoomKey" => "1675111976"
"RoomType" => "Bedroom"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
4 => array:11 [
"RoomKey" => "1675111977"
"RoomType" => "Kitchen"
"ListingId" => "40845172"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29988324"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T18:18:24.42Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29988324/244-ladyslipper-drive-unit-lower-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2050
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 773
+"OriginalEntryTimestamp": "2026-07-03T23:48:10.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1439796"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29988324_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/73042eb13d058bda0a9c47c12b451e32.webp"
"MediaSize" => 106980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-73042eb13d058bda0a9c47c12b451e32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29988324_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/a903382e180043c5d9f38362de321aed.webp"
"MediaSize" => 98693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-a903382e180043c5d9f38362de321aed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29988324_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/199ed73cb75b59ed6519a2103d63b62f.webp"
"MediaSize" => 81603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-199ed73cb75b59ed6519a2103d63b62f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29988324_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/462da95e8e3b8dcd7477fc9ff772c3f1.webp"
"MediaSize" => 92905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-462da95e8e3b8dcd7477fc9ff772c3f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29988324_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/01dbb17dd2a16ecfe57ef63231e03a93.webp"
"MediaSize" => 75104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-01dbb17dd2a16ecfe57ef63231e03a93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29988324_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/deba504d4a83869cde757c50a5aff0a1.webp"
"MediaSize" => 72721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-deba504d4a83869cde757c50a5aff0a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29988324_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/b6c7a132b2f8def1af70a7a786e988b9.webp"
"MediaSize" => 38871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-b6c7a132b2f8def1af70a7a786e988b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29988324_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/0f6002cc66e56685eaec647bbbe418cf.webp"
"MediaSize" => 43327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-0f6002cc66e56685eaec647bbbe418cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29988324_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/44aadbceead6bcb8605a4b922e8ceb01.webp"
"MediaSize" => 55669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-44aadbceead6bcb8605a4b922e8ceb01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29988324_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/2193100a55eafc53f7fe6b7398e20d11.webp"
"MediaSize" => 72078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-2193100a55eafc53f7fe6b7398e20d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29988324_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/388dcc90561acb74eed6d75a7a172c0d.webp"
"MediaSize" => 61116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-388dcc90561acb74eed6d75a7a172c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged image for reference"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29988324_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/c52b381a998df810b076b163e7f4b345.webp"
"MediaSize" => 77078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-c52b381a998df810b076b163e7f4b345.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged image for reference"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29988324_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/48b65708c1e12e4e1375322e0b800e84.webp"
"MediaSize" => 98769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-48b65708c1e12e4e1375322e0b800e84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29988324_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/0c8d4006f97d6c1ecb848e80f9dac70f.webp"
"MediaSize" => 150558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-0c8d4006f97d6c1ecb848e80f9dac70f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29988324_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/b006be16b7e010501def17b94671ea6c.webp"
"MediaSize" => 145071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-b006be16b7e010501def17b94671ea6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29988324_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/da314725cb7494bf57d7476a487e03d9.webp"
"MediaSize" => 97145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-da314725cb7494bf57d7476a487e03d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29988324_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988324/5ac06702a39a3769d3a3836406ec8c30.webp"
"MediaSize" => 36069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988324/thumbnail-5ac06702a39a3769d3a3836406ec8c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845172"
"ResourceRecordKey" => "29988324"
"ModificationTimestamp" => "2026-07-03T23:48:10.92Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988324')"
+"ID": "1592160"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1590612"
+post_author: 1
+"ListingKey": "29986609"
+"ListingId": "40844971"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5958568
1 => 43.4558155
]
+"Latitude": 43.4558155
+"Longitude": -80.5958568
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:46.776818+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:18Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:18Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1674342393"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
1 => array:11 [
"RoomKey" => "1674342394"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
2 => array:11 [
"RoomKey" => "1674342395"
"RoomType" => "Bedroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
3 => array:11 [
"RoomKey" => "1674342396"
"RoomType" => "Bedroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
4 => array:11 [
"RoomKey" => "1674342397"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844971"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
5 => array:11 [
"RoomKey" => "1674342398"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844971"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
6 => array:11 [
"RoomKey" => "1674342399"
"RoomType" => "Kitchen"
"ListingId" => "40844971"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986609"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:18.7Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986609/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-03T19:18:18.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986609_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986609/9c5ef95b3d6665ddb0fa26b4364b86c0.webp"
"MediaSize" => 136509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986609/thumbnail-9c5ef95b3d6665ddb0fa26b4364b86c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually enhanced"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844971"
"ResourceRecordKey" => "29986609"
"ModificationTimestamp" => "2026-07-03T19:18:18.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986609_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986609/58a18317f1fa1cdc20c93da94fbd5aea.webp"
"MediaSize" => 145690
…9
]
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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986609')"
+"ID": "1590612"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1587689"
+post_author: 1
+"ListingKey": "29982467"
+"ListingId": "40844834"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T23:20:15Z"
+"RFModificationTimestamp": "2026-07-03T01:13:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1630.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "449 AVENS Street, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.5965975
1 => 43.4539702
]
+"Latitude": 43.4539702
+"Longitude": -80.5965975
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Very well maintained 1.5 Car garage semi-detached home in desirable Vista Hill neighborhood. 3 bedroom and 3 bathroom, open concept on main floor, spacious kitchen with stainless steel appliances, laminate flooring and tile through the main floor. 3 good size bedrooms upstairs. Primary bedroom with ensuite and walk-in closet. Close to great schools, Universities, YMCA, Costco and Shopping. Fully fenced with NO backyard neighbors, shows AAA! Rent + Utilities, at least 1 Year Lease, Landlord prefers family living there. Good credit and employee letters are required, available August 16,2026! (id:62650)"
+"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"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:31.590566+00:00"
+"Directions": "Sundew to Wild Calla, left on Avens"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932404"
+"ListOfficeKey": "290620"
+"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-07-02T23:10:16Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T23:10:16Z"
+"Stories": "2.0"
+"StreetName": "AVENS"
+"StreetNumber": "449"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5213.44"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982467/449-avens-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R6-S"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1630
+"OriginalEntryTimestamp": "2026-07-02T23:10:16.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1232736"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:10 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982467')"
+"ID": "1587689"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1587849"
+post_author: 1
+"ListingKey": "29981674"
+"ListingId": "40844758"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:40:22Z"
+"RFModificationTimestamp": "2026-07-02T22:53:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2230.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T4"
+"UnparsedAddress": "470 TREMBLING ASPEN Avenue, Waterloo, Ontario N2T2T4"
+"Coordinates": array:2 [
0 => -80.5933136
1 => 43.4688595
]
+"Latitude": 43.4688595
+"Longitude": -80.5933136
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 470 Trembling Aspen Home! Very clean and very well maintained 4 bedrooms, 4 bathrooms, Finished Walk-Out Basement, Carpet Free family home located in the most desirable Laurelwood area. Open concept on the main floor; Spacious kitchen with a lot of cabinet storage. Large living room and dining area. Walk out to a big deck. Second floor comes with 4 good size bedrooms and the primary bedroom with En-suite; Newer roof, newer furnace and newer Fridge. Big deck; Jacuzzi in the 2nd floor bathroom. Few minutes walking to the top-rated schools in the region - Abraham Erb P.S. and Laurel Heights Secondary School. Close to Universities, YMCA, Costco and Shopping. Shows AAA! Rent + Utilities, at least 1 Year Lease, Landlord prefers family living there. Good credit and employee letters are required, available Sep. 1st, 2026. (id:62650)"
+"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"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:53:42.177193+00:00"
+"Directions": "Laurelwood/ Wild Ginger"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932404"
+"ListOfficeKey": "290620"
+"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-07-02T21:32:52Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:32:52Z"
+"Stories": "2.0"
+"StreetName": "TREMBLING ASPEN"
+"StreetNumber": "470"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4929.54"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29981674/470-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1710
+"BelowGradeFinishedArea": 520
+"OriginalEntryTimestamp": "2026-07-02T21:32:52.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232736"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981674')"
+"ID": "1587849"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1587850"
+post_author: 1
+"ListingKey": "29981415"
+"ListingId": "X13515188"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T23:45:03Z"
+"RFModificationTimestamp": "2026-07-04T23:49:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful corner-unit townhouse for lease in the sought-after Laurelwood neighbourhood! Enjoy maintenance-free living with lawn care and snow removal (driveway & sidewalk) included. This bright and spacious home features a flexible floor plan with 3 separate living areas, soaring cathedral ceilings, a sun-filled living room, a main-floor bedroom and full bathroom, a dedicated home office, and a large basement offering abundant storage and additional living space. Conveniently located near top-rated schools, Laurel Creek Conservation Area, parks, walking trails, the University of Waterloo, shopping, Costco, the Boardwalk, public transit, and all major amenities. Ideal for families, professionals, or those working from home. Move-in ready! (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Range"
3 => "Garage door opener remote(s)"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T21:45:15.663204+00:00"
+"Directions": "Erbsville rd/Laurelwood dr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T20:56:11Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T23:38:56Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981415/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"GeocodeManualYN": false
+"TotalActualRent": 3100
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-02T20:56:11.67Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981415')"
+"ID": "1587850"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"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 [ …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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980985')"
+"ID": "1587851"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1584439"
+post_author: 1
+"ListingKey": "29978059"
+"ListingId": "40844566"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:20:11Z"
+"RFModificationTimestamp": "2026-07-02T17:17:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1457.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "982 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5994372
1 => 43.471525
]
+"Latitude": 43.471525
+"Longitude": -80.5994372
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Well maintained FREEHOLD townhome in Laurel Creek Village! 3 Bedrooms /3 Baths with gorgeous open-concept design. GRAND 2-storey foyer. Carpet free flooring ON MAIN FLOOR & UPSTAIRS , HUGE Master with LARGE walk-in closet, sliders off of kitchen to Fully Fenced yard. All appliances included. FULLY FINISHED BASEMENT with KITCHENETTE and 3-piece bath ! Prime Waterloo School District . newer fridge ,newer washer and newer AC. Shows AAA, don't miss this one!! (id:62650)"
+"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"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:16:58.162083+00:00"
+"Directions": "ERBSVILLE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564082"
+"ListOfficeKey": "222711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:11:14Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:11:14Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "982"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978059/982-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2875
+"ZoningDescription": "50-R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1457
+"OriginalEntryTimestamp": "2026-07-02T15:11:14.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1130381"
+"ListOfficeNationalAssociationId": "1197443"
+"Media": array:15 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978059')"
+"ID": "1584439"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1581723"
+post_author: 1
+"ListingKey": "29973003"
+"ListingId": "X13506914"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:45:13Z"
+"RFModificationTimestamp": "2026-07-01T03:50:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "474 TREMBLING ASPEN AVENUE, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.593455
1 => 43.468742
]
+"Latitude": 43.468742
+"Longitude": -80.593455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Looking For A Comfortable And Affordable Rental Place To Call Home? This Beautifully Maintained Home Located At 474 Trembling Aspen Offers A Perfect Balance Of Space, Convenience, And Value In One Of Waterloo's Most Sought-After Neighborhoods. The Main Floor Features A Bright And Inviting Living Room, Dining Area, And Functional Kitchen, Providing A Comfortable Space For Everyday Living, Studying, And Entertaining. The Second Floor Offers 4 Spacious Bedrooms. Every Single Bedroom Comes Fully Furnished With Its Own Desk And Chair, Making It 100% Move-In Ready For Studying Or Working From Home. Situated In The Desirable Laurelwood Community, This Home Is Surrounded By Parks, Schools, Shopping, Restaurants, Public Transit, And Everyday Amenities. While Offering A Peaceful Residential Environment Away From The Busy Campus Area, It Still Provides Convenient Access To The University Of Waterloo And Wilfrid Laurier University Through Nearby Transit Routes. Main And Second Floors For Lease Only, Needs To Pay 2/3 Of The Hydro & Gas Bills, But The Water Bill Depends On The Number Of Tenants. (id:62650)"
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:41:09.030395+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Laurelwood Dr. ** Directions: Columbia St W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952388"
+"ListOfficeKey": "276761"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "28 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T03:36:47Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T03:36:47Z"
+"Stories": "2.5"
+"StreetName": "Trembling Aspen"
+"StreetNumber": "474"
+"StreetSuffix": "Avenue"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29973003/474-trembling-aspen-avenue-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-06-30T21:13:11.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245939"
+"ListOfficeNationalAssociationId": "1277704"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29973003')"
+"ID": "1581723"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 24
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]