array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29161249/Property?$select=ALL&$top=20&$filter=ListingKey eq 29161249&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29161249/Property?$select=ALL&$top=20&$filter=ListingKey eq 29161249&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23633
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23635
+post_id: "461801"
+post_author: 1
+"ListingKey": "29161249"
+"ListingId": "40791733"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:40:28Z"
+"RFModificationTimestamp": "2025-12-07T21:41:40Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556682
1 => 43.457743
]
+"Latitude": 43.457743
+"Longitude": -80.556682
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful 3+1 bedroom, 2.5 bathroom townhouse with a fully finished basement featuring an additional bedroom and full washroom, located in a highly desirable area of Waterloo. This property is an excellent opportunity for first-time buyers, investors, or students. The home has been well maintained and fully renovated, offering a spacious living room with built-in shelving and elegant crown molding. The upper level includes a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. Situated in a quiet complex with plenty of visitor parking. It is also conveniently close to grocery stores, bus routes, highways, and universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "595"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"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": "2025-12-04T03:21:55.037842+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175734"
+"ListOfficeKey": "273035"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2025-12-04T02:59:55Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:29:25Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3004.16"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1546322507"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791733"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.94Z"
]
1 => array:11 [
"RoomKey" => "1546322508"
"RoomType" => "Bedroom"
"ListingId" => "40791733"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 22'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.94Z"
]
2 => array:11 [
"RoomKey" => "1546322509"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791733"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.94Z"
]
3 => array:11 [
"RoomKey" => "1546322510"
"RoomType" => "Bedroom"
"ListingId" => "40791733"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.94Z"
]
4 => array:11 [
"RoomKey" => "1546322511"
"RoomType" => "Bedroom"
"ListingId" => "40791733"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
5 => array:11 [
"RoomKey" => "1546322512"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791733"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
6 => array:11 [
"RoomKey" => "1546322513"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791733"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
7 => array:11 [
"RoomKey" => "1546322514"
"RoomType" => "Living room"
"ListingId" => "40791733"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
8 => array:11 [
"RoomKey" => "1546322515"
"RoomType" => "Dining room"
"ListingId" => "40791733"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
9 => array:11 [
"RoomKey" => "1546322516"
"RoomType" => "Kitchen"
"ListingId" => "40791733"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29161249"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:25.95Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161249/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2025-12-04T02:59:55.23Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:31 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6354652539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/fd2519826cf08619332d817c9d487973.webp"
"MediaSize" => 145661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-fd2519826cf08619332d817c9d487973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered property entrance with brick siding and a carport"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6354652550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/41330d6ae8cd51a42057a55cc764d063.webp"
"MediaSize" => 52961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-41330d6ae8cd51a42057a55cc764d063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring crown molding and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6354652560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/f6b22e98aab90a6058e71722490fa3c1.webp"
"MediaSize" => 49210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-f6b22e98aab90a6058e71722490fa3c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished dining area featuring ornamental molding, a chandelier, and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6354652570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/85f24a6c8529f6263601779eadfa85e2.webp"
"MediaSize" => 44218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-85f24a6c8529f6263601779eadfa85e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with a textured ceiling, light carpet, and ornamental molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6354652587"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/f8db23bed9e4595252e114220ed2ddf3.webp"
"MediaSize" => 46034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-f8db23bed9e4595252e114220ed2ddf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with a textured ceiling and light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6354652603"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/95335fd73f5b9103c96f5167a9f23761.webp"
"MediaSize" => 36003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-95335fd73f5b9103c96f5167a9f23761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, tiled shower, and light marble finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6354652614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/9724028a7eac18f933f988bef01e10c8.webp"
"MediaSize" => 156270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-9724028a7eac18f933f988bef01e10c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional home with brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6354652625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/c524538539c0b84ffe63157b6168c34b.webp"
"MediaSize" => 51195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-c524538539c0b84ffe63157b6168c34b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with light wood-style floors and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6354652634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/eaeaf025d9898fd603340dc5e8ae30bc.webp"
"MediaSize" => 47886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-eaeaf025d9898fd603340dc5e8ae30bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room featuring crown molding, light wood-style flooring, and built in features"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6354652646"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/36a1f14ed6203f652e2fe23713687d69.webp"
"MediaSize" => 52394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-36a1f14ed6203f652e2fe23713687d69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white appliances, under cabinet range hood, light countertops, white cabinetry, and light marble finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6354652658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/9960e38e87d594148c3ce0141d98910d.webp"
"MediaSize" => 54450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-9960e38e87d594148c3ce0141d98910d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room featuring ornamental molding, a chandelier, light wood-style floors, and stairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6354652667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/c3d7eeb5c82cdda22651d278d091a588.webp"
"MediaSize" => 57180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-c3d7eeb5c82cdda22651d278d091a588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, under cabinet range hood, white cabinets, a chandelier, and light marble finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6354652673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/25bd929822f10a9751e0910949ed9021.webp"
"MediaSize" => 52317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-25bd929822f10a9751e0910949ed9021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room with a chandelier, crown molding, and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6354652683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/c74e061f356f1a0406171e134dd68d18.webp"
"MediaSize" => 39140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-c74e061f356f1a0406171e134dd68d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of stairway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6354652696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/590455458040f9d3571ac31bafb12e4a.webp"
"MediaSize" => 43125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-590455458040f9d3571ac31bafb12e4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with a textured ceiling and light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6354652705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/962a367f03f528f208700164ccaea1f3.webp"
"MediaSize" => 46651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-962a367f03f528f208700164ccaea1f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room featuring a textured ceiling, ornamental molding, and light colored carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6354652716"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/fdfc93356f14aade4dcc45d4698bbfd7.webp"
"MediaSize" => 43328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-fdfc93356f14aade4dcc45d4698bbfd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom featuring a closet, carpet, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6354652731"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/87fab0fb2d9dd37b127772a1585b5a4e.webp"
"MediaSize" => 32465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-87fab0fb2d9dd37b127772a1585b5a4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with bathing tub / shower combination and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6354652736"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/ded219ff4c869f9308aa220e645cd22d.webp"
"MediaSize" => 47121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-ded219ff4c869f9308aa220e645cd22d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry room featuring stacked washer and clothes dryer and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6354652747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/390970f0305a6dd5e3e3a3649bfba197.webp"
"MediaSize" => 129096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-390970f0305a6dd5e3e3a3649bfba197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered property entrance with brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6354652764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/070bf69215d7e44c2f2ade7b82e2cb15.webp"
"MediaSize" => 42618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-070bf69215d7e44c2f2ade7b82e2cb15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer entrance with a textured ceiling and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6354652777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/64508e275a409cc7b7736c2e415340ea.webp"
"MediaSize" => 50915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-64508e275a409cc7b7736c2e415340ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement with a paneled ceiling and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6354652786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/1d3c6e3c2d99e2fcd0bdce90f818a6c6.webp"
"MediaSize" => 123054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-1d3c6e3c2d99e2fcd0bdce90f818a6c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard layered in snow"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6354652835"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/ac4bef9b32e7ddde9cbfc220254e5ed0.webp"
"MediaSize" => 150386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-ac4bef9b32e7ddde9cbfc220254e5ed0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional-style house featuring brick siding and a carport"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6354652845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/75b61f50d2911507a5dafbe48ca7822b.webp"
"MediaSize" => 32883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-75b61f50d2911507a5dafbe48ca7822b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with light carpet, a closet, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6354652853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/b6db4e12436a57a9113063d99eecf849.webp"
"MediaSize" => 51655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-b6db4e12436a57a9113063d99eecf849.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished below grade area with a drop ceiling and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6354652861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/e9f68d82e63a694db278c65ec5610683.webp"
"MediaSize" => 48395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-e9f68d82e63a694db278c65ec5610683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with vanity, a shower stall, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6354652870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/dec3640fbc578a158a354aa28a3cb15f.webp"
"MediaSize" => 51601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-dec3640fbc578a158a354aa28a3cb15f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with light wood-type flooring and ornamental molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6354652877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/296007519a27b07a3cc03127cbd50e8f.webp"
"MediaSize" => 41751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-296007519a27b07a3cc03127cbd50e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, light countertops, light marble finish floors, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6354652878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/b3a5967a69843ca1c690ec993ead1f4d.webp"
"MediaSize" => 45927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-b3a5967a69843ca1c690ec993ead1f4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light countertops, dishwasher, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6354652883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29161249/efbc4940afc8b98f264513b5891cd54e.webp"
"MediaSize" => 34659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29161249/thumbnail-efbc4940afc8b98f264513b5891cd54e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with marble look tiles and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791733"
"ResourceRecordKey" => "29161249"
"ModificationTimestamp" => "2025-12-04T02:59:55.24Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Victoria Boluwaduro"
"MemberFirstName" => "Victoria"
"MemberLastName" => "Boluwaduro"
"MemberMlsId" => "KWkw1930"
"OriginatingSystemName" => 26
"MemberKey" => "2175734"
"ModificationTimestamp" => "2025-08-01T17:12:46Z"
"MemberStatus" => "Inactive"
"OfficeKey" => "290392"
"MemberAOR" => "Cornerstone - Waterloo Region"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "647-849-3180"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
"MemberAORKey" => "16"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-781-9332"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2022-10-05T13:25:00Z"
"MemberNationalAssociationId" => "1425916"
"OfficeNationalAssociationId" => "1386847"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "TEAM HOME REALTY INC."
"OfficePhone" => "519-419-1413"
"OfficeMlsId" => "KW297"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "273035"
"ModificationTimestamp" => "2025-12-05T21:34:07Z"
"OfficeAddress1" => "22 King St. S., Unit 300"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2J1N"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "519-669-9920"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2013-04-23T18:22:00Z"
"OfficeNationalAssociationId" => "1247789"
"OfficeBrokerNationalAssociationId" => "1207783"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161249')"
+"ID": "461801"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 273035/Office?$select=ALL&$top=10&$filter=OfficeKey eq 273035&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 273035/Office?$select=ALL&$top=10&$filter=OfficeKey eq 273035&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25462
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25464
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "TEAM HOME REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-419-1413"
+"OfficeMlsId": "KW297"
+"ModificationTimestamp": "2025-12-05T21:34:07Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "273035"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "22 King St. S., Unit 300"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J1N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1247789"
+"OriginalEntryTimestamp": "2013-04-23T18:22:00Z"
+"OfficeFax": "519-669-9920"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1207783"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('273035')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2175734/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2175734&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2175734/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2175734&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25467
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29161249" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25088
+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 29161249/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29161249&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29161249/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29161249&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25065
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25068
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29295049"
+"ListingKey": "29161249"
+"ListingId": "40791733"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-07"
+"OpenHouseStartTime": "2025-12-07T14:00:00Z"
+"OpenHouseEndTime": "2025-12-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-06T19:16:06Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29295049')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25066
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29295050"
+"ListingKey": "29161249"
+"ListingId": "40791733"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-06"
+"OpenHouseStartTime": "2025-12-06T14:00:00Z"
+"OpenHouseEndTime": "2025-12-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-06T19:16:06Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29295050')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25069
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29304895"
+"ListingKey": "29161249"
+"ListingId": "40791733"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-07"
+"OpenHouseStartTime": "2025-12-07T14:00:00Z"
+"OpenHouseEndTime": "2025-12-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-07T20:55:42Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29304895')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29161249 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.556682 43.457743)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29161249 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.556682 43.457743)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29161249 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.556682 43.457743)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29161249 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.556682 43.457743)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24999
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: 486112
+post_author: 1
+"ListingKey": "29191399"
+"ListingId": "X12638126"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T16:00:16Z"
+"RFModificationTimestamp": "2025-12-17T16:01:56Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1P9"
+"UnparsedAddress": "54 ASHTON CRESCENT, Waterloo, Ontario N2L1P9"
+"Coordinates": array:2 [
0 => -80.5375333
1 => 43.4555383
]
+"Latitude": 43.4555383
+"Longitude": -80.5375333
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 54 Ashton Crescent, a hidden gem nestled in the sought-after Westmount community of Waterloo. This detached home sits on an extra-wide, deep lot in a quiet, family-oriented cul-de-sac. Offered for the first time in over 40 years, the property has been lovingly maintained throughout the years.The home features 5 spacious bedrooms, 3 bathrooms, and a fully finished basement with high ceilings, offering ample living space for a growing family. An attached double-car garage and a generous driveway provide plenty of parking. Ideal for large families or those who love to entertain, this home combines space, comfort, and an unbeatable location. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T15:46:24.167726+00:00"
+"Directions": "WESTMOUNT RD & ERB ST W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1411043"
+"ListOfficeKey": "270562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "58 x 149.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T15:48:32Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T15:48:32Z"
+"Stories": "2.0"
+"StreetName": "Ashton"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9165"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1550381123"
"RoomType" => "Family room"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 4.16
"ListingKey" => "29191399"
"RoomLength" => 5.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.21Z"
]
1 => array:11 [
"RoomKey" => "1550381124"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12638126"
"RoomLevel" => "Second level"
"RoomWidth" => 3.89
"ListingKey" => "29191399"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.21Z"
]
2 => array:11 [
"RoomKey" => "1550381125"
"RoomType" => "Kitchen"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 3.87
"ListingKey" => "29191399"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.21Z"
]
3 => array:11 [
"RoomKey" => "1550381126"
"RoomType" => "Dining room"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 3.41
"ListingKey" => "29191399"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.21Z"
]
4 => array:11 [
"RoomKey" => "1550381127"
"RoomType" => "Living room"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 4.73
"ListingKey" => "29191399"
"RoomLength" => 6.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
5 => array:11 [
"RoomKey" => "1550381128"
"RoomType" => "Laundry room"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 1.92
"ListingKey" => "29191399"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
6 => array:11 [
"RoomKey" => "1550381129"
"RoomType" => "Sunroom"
"ListingId" => "X12638126"
"RoomLevel" => "Main level"
"RoomWidth" => 5.01
"ListingKey" => "29191399"
"RoomLength" => 5.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
7 => array:11 [
"RoomKey" => "1550381130"
"RoomType" => "Bedroom 2"
"ListingId" => "X12638126"
"RoomLevel" => "Second level"
"RoomWidth" => 3.26
"ListingKey" => "29191399"
"RoomLength" => 3.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
8 => array:11 [
"RoomKey" => "1550381131"
"RoomType" => "Bedroom 3"
"ListingId" => "X12638126"
"RoomLevel" => "Second level"
"RoomWidth" => 2.44
"ListingKey" => "29191399"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
9 => array:11 [
"RoomKey" => "1550381132"
"RoomType" => "Bedroom 4"
"ListingId" => "X12638126"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29191399"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
10 => array:11 [
"RoomKey" => "1550381133"
"RoomType" => "Bedroom 5"
"ListingId" => "X12638126"
"RoomLevel" => "Second level"
"RoomWidth" => 3.98
"ListingKey" => "29191399"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T15:48:32.22Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29191399/54-ashton-crescent-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 58.0
+"OriginalEntryTimestamp": "2025-12-17T15:20:24.84Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:14 [
0 => array:13 [
"Order" => 5
"MediaKey" => "6373150118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/1534f0daf26346790ef69fbe3ee8fa0f.webp"
"MediaSize" => 111316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-1534f0daf26346790ef69fbe3ee8fa0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:20:24.84Z"
]
1 => array:13 [
"Order" => 11
"MediaKey" => "6373150210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/f5bd00998036529dcdb3529098bb6459.webp"
"MediaSize" => 48461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-f5bd00998036529dcdb3529098bb6459.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:54.94Z"
]
2 => array:13 [
"Order" => 12
"MediaKey" => "6373150229"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/317cfc5de4763ce233f238edfed06178.webp"
"MediaSize" => 93940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-317cfc5de4763ce233f238edfed06178.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:20:24.84Z"
]
3 => array:13 [
"Order" => 0
"MediaKey" => "6373184273"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/9e2671c16cff638ff70cfb74f32e5efe.webp"
"MediaSize" => 71483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-9e2671c16cff638ff70cfb74f32e5efe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.47Z"
]
4 => array:13 [
"Order" => 1
"MediaKey" => "6373184365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/f48a3426631dfa09cd4720178ebb8248.webp"
"MediaSize" => 56834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-f48a3426631dfa09cd4720178ebb8248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.39Z"
]
5 => array:13 [
"Order" => 2
"MediaKey" => "6373184470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/0b03b1295cdb838bfd44b4f259523c46.webp"
"MediaSize" => 111316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-0b03b1295cdb838bfd44b4f259523c46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.43Z"
]
6 => array:13 [
"Order" => 3
"MediaKey" => "6373184578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/bd830b0cc20e0e6552b52f253c5943c6.webp"
"MediaSize" => 94777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-bd830b0cc20e0e6552b52f253c5943c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.02Z"
]
7 => array:13 [
"Order" => 4
"MediaKey" => "6373184668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/77d1bb33fa0d1f164440f2b2eefc5079.webp"
"MediaSize" => 50334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-77d1bb33fa0d1f164440f2b2eefc5079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.03Z"
]
8 => array:13 [
"Order" => 6
"MediaKey" => "6373184834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/b55072309fc77272ef8799283f3fbdcd.webp"
"MediaSize" => 93940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-b55072309fc77272ef8799283f3fbdcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:20:24.84Z"
]
9 => array:13 [
"Order" => 7
"MediaKey" => "6373184890"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/8a5f1080a26b005609ed2dd4d1a0eaaf.webp"
"MediaSize" => 52411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-8a5f1080a26b005609ed2dd4d1a0eaaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.11Z"
]
10 => array:13 [
"Order" => 8
"MediaKey" => "6373184998"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/46f81ca9586f115933d1565c8f0824aa.webp"
"MediaSize" => 48461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-46f81ca9586f115933d1565c8f0824aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:54.94Z"
]
11 => array:13 [
"Order" => 9
"MediaKey" => "6373185077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/59b872f59857b1929b60026b8c848559.webp"
"MediaSize" => 53808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-59b872f59857b1929b60026b8c848559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.46Z"
]
12 => array:13 [
"Order" => 10
"MediaKey" => "6373185139"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/24893d65b95eadcba2b697fc3e8f874b.webp"
"MediaSize" => 27759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-24893d65b95eadcba2b697fc3e8f874b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:21:55.04Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6373185400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191399/136d618aa4c94f2498112666b9d8889f.webp"
"MediaSize" => 99298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191399/thumbnail-136d618aa4c94f2498112666b9d8889f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12638126"
"ResourceRecordKey" => "29191399"
"ModificationTimestamp" => "2025-12-17T15:20:24.84Z"
]
]
+"Member": array:1 [
0 => array:20 [
"MemberFullName" => "CHRIS KELOS"
"MemberFirstName" => "CHRIS"
"MemberLastName" => "KELOS"
"MemberMlsId" => "2213044"
"OriginatingSystemName" => 26
"MemberKey" => "1411043"
"ModificationTimestamp" => "2025-01-09T17:52:35Z"
"MemberStatus" => "Active"
"OfficeKey" => "270562"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberAOR" => "Toronto"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "416-465-7850"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1046784"
"OfficeNationalAssociationId" => "1235863"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX HALLMARK REALTY LTD."
"OfficePhone" => "416-465-7850"
"OfficeMlsId" => "259007"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "270562"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "785 QUEEN ST EAST"
"OfficeCity" => "TORONTO"
"OfficePostalCode" => "M4M1H5"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "416-463-7850"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2012-05-17T04:36:00Z"
"OfficeNationalAssociationId" => "1235863"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1192645"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29191399')"
+"ID": 486112
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25016
+post_id: "486092"
+post_author: 1
+"ListingKey": "29191281"
+"ListingId": "40793961"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T14:35:26Z"
+"RFModificationTimestamp": "2025-12-17T14:47:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 715.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K9"
+"UnparsedAddress": "312 ERB Street W Unit# 402, Waterloo, Ontario N2L0K9"
+"Coordinates": array:2 [
0 => -80.5422466
1 => 43.456631
]
+"Latitude": 43.456631
+"Longitude": -80.5422466
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Live à la Moda — A Refined Expression of Urban Sophistication Step into this pristine, never-lived-in 2-bedroom, 2-bath retreat at Moda, where every detail exudes sophistication and intentional design. With 715 sq ft of elegant interior space complemented by 195 sq ft of outdoor living across two balconies, this home is perfect for both restful mornings and stylish entertaining. From the moment you enter, you’re welcomed by bespoke craftsmanship, a custom millwork coat closet and sleek designer lighting that sets the tone for modern luxury. Light pours in through full-height black-framed windows, illuminating a premium kitchen package with quartz counters and stainless-steel appliances. The primary suite is a quiet sanctuary: a walk-through closet framed by pocket doors leads into an ensuite filled with natural light through its own window. The guest bedroom, too, offers its own balcony, and creates a personal dimension to shared spaces. With its intuitive flow and purpose-driven design, this unit feels right at home in the kind of vibrant urban centre where innovation and lifestyle intersect. Positioned just minutes from Uptown, University of Waterloo, Wilfrid Laurier University, the Waterloo Recreation Complex, and Hydrocut trails—it’s made for an active, connected lifestyle. Cyclists will especially appreciate secure bike parking, a maintenance station, and bike-friendly routes. Moda puts convenience and community first, featuring a co-working lounge with coffee bar and meeting pods, pet wash station, EV-ready parking, a secure parcel room, and optional storage lockers, these are amenities that feel both curated and practical.Your home is more than a place to live—it’s a statement. Welcome to Moda Modern Loft Living. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T14:46:49.373524+00:00"
+"Directions": "On Erb St between McDougall & Amos"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145306"
+"ListOfficeKey": "292479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-12-17T14:29:20Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T14:29:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1550350877"
"RoomType" => "Full bathroom"
"ListingId" => "40793961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.67Z"
]
1 => array:11 [
"RoomKey" => "1550350878"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.68Z"
]
2 => array:11 [
"RoomKey" => "1550350879"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793961"
…8
]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29191281/312-erb-street-w-unit-402-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 715
+"OriginalEntryTimestamp": "2025-12-17T14:29:20.65Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29191281')"
+"ID": "486092"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25017
+post_id: "482743"
+post_author: 1
+"ListingKey": "29186814"
+"ListingId": "40793908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T17:35:20Z"
+"RFModificationTimestamp": "2025-12-15T17:47:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 750.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y2"
+"UnparsedAddress": "641 FRIEBURG Drive Unit# Lower, Waterloo, Ontario N2T2Y2"
+"Coordinates": array:2 [
0 => -80.5799905
1 => 43.4554446
]
+"Latitude": 43.4554446
+"Longitude": -80.5799905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new Waterloo home in Clair Hills! This bright, spacious, and beautifully maintained 1-bedroom apartment offers over 750 sq ft of comfortable living, tons of built-in storage, and a private entrance for complete independence and quiet living. With warm maple cabinetry, a full dine-in kitchen, front-loading LG washer/dryer, a corner gas fireplace, and an updated bathroom with a glass shower, this unit has everything a professional or graduate student needs. Rent: $1,800/month (All Inclusive) Includes: Heat, Hydro, Water Unit Features Private/separate entrance Bright living area with corner fireplace Large dine-in kitchen with: Maple cabinets Dishwasher Full-size fridge & stove LG front-loader washer & dryer Spacious bedroom with double closet Bathroom with glass corner shower Tons of built-in storage for skis, bikes, gear, etc. Oversized windows with blinds Parking for one car Water softener Space for an outdoor propane BBQ Location – Clair Hills (Waterloo) Perfect for professionals or grad students: 5-min walk to Bus Routes 13 & 29 5-min drive to UW, Costco, Boardwalk Shopping Centre 10-min drive to WLU 15-min walk to Shoppers, Tims, Winners, Dutchie’s Grocery, Canadian Tire & more Quick access to beautiful walking, biking & hiking trails 10 minutes to HydroCut bike trails Availability: January 1/ February 1st 2026 Lease: 1 year Requirements: Credit & references, tenant insurance Occupants: Professionals or graduate students preferred Pets/Smoking: Not permitted Outdoor Space: No separate private yard ***see sales brochure below for showing instructions***** (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-15T17:47:28.445888+00:00"
+"Directions": "Off of Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-15T17:29:41Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T17:29:41Z"
+"Stories": "1.0"
+"StreetName": "FRIEBURG"
+"StreetNumber": "641"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29186814/641-frieburg-drive-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2025-12-15T17:29:41.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:9 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29186814')"
+"ID": "482743"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24986
+post_id: "477610"
+post_author: 1
+"ListingKey": "29183047"
+"ListingId": "40784095"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T18:30:28Z"
+"RFModificationTimestamp": "2025-12-12T20:13:37Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1034.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "223 ERB Street W Unit# 405, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.5362068
1 => 43.4591902
]
+"Latitude": 43.4591902
+"Longitude": -80.5362068
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Warm, welcoming, and easy to live in, this 2-bedroom, 2-bath condo at 223 Erb Street West offers the kind of lifestyle that makes condo living so appealing. The open-concept layout blends a well-appointed kitchen with granite counters, rich cabinetry, and a central island into a bright living and dining space that flows effortlessly onto a private balcony, perfect for morning coffee or winding down at the end of the day. Both bedrooms are generously sized, including a primary suite with its own ensuite, while thoughtful finishes and natural light create a calm, comfortable feel throughout. Beyond the suite, the building elevates everyday living with amenities that extend your space, including a fully equipped gym, party rooms for entertaining, and a rooftop patio where you can relax, socialize, or take in the surroundings. Set in one of Waterloo’s most convenient and walkable locations, you are steps from Uptown shops, cafes, restaurants, trails, and transit, making it easy to stay connected while enjoying the simplicity of condo living. This is a home that balances comfort, convenience, and community, right where you want to be. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "1111.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T20:13:15.309742+00:00"
+"Directions": "Intersection of Erb and Westmount"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564144"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-12T18:02:43Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T18:02:43Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4437.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/vro49_405_223_erb_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29183047/223-erb-street-w-unit-405-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1034
+"OriginalEntryTimestamp": "2025-12-12T18:02:43.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183047')"
+"ID": "477610"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24947
+post_id: "477277"
+post_author: 1
+"ListingKey": "29182622"
+"ListingId": "40793443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T18:55:15Z"
+"RFModificationTimestamp": "2025-12-12T18:57:59Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1216.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K8"
+"UnparsedAddress": "621 PINEROW Crescent Unit# A, Waterloo, Ontario N2T2K8"
+"Coordinates": array:2 [
0 => -80.5684805
1 => 43.4486279
]
+"Latitude": 43.4486279
+"Longitude": -80.5684805
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "What a fantastic Christmas present for YOU! This smartly updated and lovingly maintained semi-detached home would look great in your stocking. Street appeal ++ with a rarely found Cape Cod exterior giving 2 of your upper bedrooms so much character with their dormers! Located on a quiet Crescent in popular Beechwood West and featuring a deep, fully fenced lot (with shed) and a sliding walkout from the living room to an elevated sundeck! The upper level offers 3 generous sized bedrooms and a fully renovated (2020) 4 piece bathroom highlighted by the deep, acrylic soaker bathtub, raindrop shower head, Subway tile tub/shower finish and a duo-flush water closet. All bedrooms have dark, laminate flooring! The main floor offers a combination living room/dining room with laminate floors and a bright functional kitchen appointed with oak cabinets, glass/ceramic tile backsplash, a 2 door pantry cabinet, an over the range microwave oven and a double door stainless steel fridge with water and ice dispenser. The lower level was completely gutted and rebuilt in 2019 too! Here you will find a large recreation room with grey vinyl flooring, a remodeled 2 piece bathroom and a spacious utility/laundry room. The laundry room has a convenient folding counter. Here is a list of some of the updates and extras! A natural gas hook up on the deck for your BBQ, 4 appliances included, (2016) replacement windows in the kitchen and patio door, deck boards and railing (2019), water softener (2020) and roof shingles in 2025. You can't go wrong by making this house YOUR home in 2026! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T17:19:38.535226+00:00"
+"Directions": "RUMMELHARDT TO PINEROW CR"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563599"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2025-12-12T18:01:30Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T18:38:30Z"
+"Stories": "2.0"
+"StreetName": "PINEROW"
+"StreetNumber": "621"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3632"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29182622/621-pinerow-crescent-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1216
+"OriginalEntryTimestamp": "2025-12-12T16:19:14.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29182622')"
+"ID": "477277"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24922
+post_id: "475745"
+post_author: 1
+"ListingKey": "29180081"
+"ListingId": "X12627206"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T06:31:02Z"
+"RFModificationTimestamp": "2025-12-17T06:35:24Z"
+"ListPrice": 745000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "520 CHABLIS DRIVE, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5751586
1 => 43.4502041
]
+"Latitude": 43.4502041
+"Longitude": -80.5751586
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 520 Chablis Drive, Waterloo! Located in one of Waterloo's most desirable, family-friendly, calm, and quiet neighborhoods, this beautiful carpet-free home offers exceptional convenience-just minutes to The Boardwalk, Costco, shopping, schools, and all major amenities. The main floor features an open-concept layout with a spacious kitchen, cathedral ceiling in the great room, and a sliding door walkout to the back deck and landscaped backyard. The welcoming front entrance opens into a bright hallway leading to the living room. To the right is a powder room and the kitchen; to the left is a dedicated dining room-perfect for family gatherings and entertaining. The second floor offers 3 bedrooms, including a generous primary bedroom with its own ensuite. Two additional good-sized bedrooms share a full main bathroom. The fully finished basement adds valuable living space with a large recreation room complete with countertop, sink, and cabinetry-ideal for entertaining or extended family. A full bathroom, cold cellar, laundry area, and utility room complete the lower level. Upgrades & Features: Kitchen countertop and island with quartz, interior paint (2023), Washer/Dryer/Stove (2022), Two cooking lines: Hydro/Gas, Air Conditioner (2022), Water Softener (2022), Furnace (2018), Roof (2017), Concrete driveway (2024), Properly insulated cold room. Garage door remote sold as is. A wonderful opportunity to own a well-maintained home in a prime Waterloo location! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:19:16.442127+00:00"
+"Directions": "Cross Streets: Erbsville Rd/Chablis Dr. ** Directions: Erbsville Road to Chablis Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136085"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Carpet Free"
]
+"LotSizeDimensions": "28 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T16:54:21Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T06:17:21Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4261"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29180081/520-chablis-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2025-12-11T16:54:21.42Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:27 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180081')"
+"ID": "475745"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23647
+post_id: "475035"
+post_author: 1
+"ListingKey": "29179351"
+"ListingId": "40793332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T06:40:26Z"
+"RFModificationTimestamp": "2025-12-17T06:44:21Z"
+"ListPrice": 745000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2161.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "520 CHABLIS Drive, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5751473
1 => 43.4502056
]
+"Latitude": 43.4502056
+"Longitude": -80.5751473
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 520 Chablis Drive, Waterloo! Located in one of Waterloo’s most desirable, family-friendly, calm, and quiet neighborhoods, this beautiful carpet-free home offers exceptional convenience—just minutes to The Boardwalk, Costco, shopping, schools, and all major amenities. The main floor features an open-concept layout with a spacious kitchen, cathedral ceiling in the great room, and a sliding door walkout to the back deck and landscaped backyard. The welcoming front entrance opens into a bright hallway leading to the living room. To the right is a powder room and the kitchen; to the left is a dedicated dining room—perfect for family gatherings and entertaining. The second floor offers 3 bedrooms, including a generous primary bedroom with its own ensuite. Two additional good-sized bedrooms share a full main bathroom. The fully finished basement adds valuable living space with a large recreation room complete with countertop, sink, and cabinetry—ideal for entertaining or extended family. A full bathroom, cold cellar, laundry area, and utility room complete the lower level. Upgrades & Features: Kitchen countertop and island with quartz, interior paint (2023), Washer/Dryer/Stove (2022), Two cooking lines: Hydro/Gas, Air Conditioner (2022), Water Softener (2022), Furnace (2018), Roof (2017), Concrete driveway (2024), Properly insulated cold room. Garage door remote sold as is. A wonderful opportunity to own a well-maintained home in a prime Waterloo location! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T06:41:47.676088+00:00"
+"Directions": "Erbsville Road to Chablis Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062546"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T06:08:20Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T06:29:29Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4261"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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/29179351/520-chablis-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1448
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2025-12-11T06:08:20.17Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:27 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179351')"
+"ID": "475035"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25005
+post_id: "474317"
+post_author: 1
+"ListingKey": "29178457"
+"ListingId": "X12616732"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T22:05:16Z"
+"RFModificationTimestamp": "2025-12-10T22:34:27Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T22:34:05.078153+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-10T21:55:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T21:55:53Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"Rooms": array:17 [
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]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29178457/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "G"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-10T21:55:53.48Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29178457')"
+"ID": "474317"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25000
+post_id: "470664"
+post_author: 1
+"ListingKey": "29173617"
+"ListingId": "X12612020"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T15:25:41Z"
+"RFModificationTimestamp": "2025-12-09T16:59:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "1 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bedrooms available for lease in this beautiful and Cozy End-Unit Townhouse In Desirable Beechwood! List Price is price for each room, including utilities and internet, please contact for details. Main Floor Features A Large, Comfortable Living Space And Newer Kitchen Appliances. Student Welcome, landlord considers short term lease too. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T16:59:14.953589+00:00"
+"Directions": "Cross Streets: Keats Way And Fischer Hallman. ** Directions: Google Map."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091671"
+"ListOfficeKey": "289061"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2025-12-09T15:17:20Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T15:17:20Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29173617/1-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"TotalActualRent": 750
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-09T15:17:20.94Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:7 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173617')"
+"ID": "470664"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 128
+after_key: ""
}
"RF Response Time" => "0.34 seconds"
]
]