array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29173268/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173268&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173268/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173268&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+post_id: "470347"
+post_author: 1
+"ListingKey": "29173268"
+"ListingId": "40793031"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T17:50:07Z"
+"RFModificationTimestamp": "2025-12-09T17:51:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G3"
+"UnparsedAddress": "30 AMOS Avenue Unit# A, Waterloo, Ontario N2L5G3"
+"Coordinates": array:2 [
0 => -80.548616
1 => 43.45845
]
+"Latitude": 43.45845
+"Longitude": -80.548616
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious three-bedroom semi-detached home in a prime Waterloo location. This well-maintained property features a finished basement with a separate entrance, perfect for additional living space or potential income. The modern white eat-in kitchen boasts contemporary finishes and a convenient walkout to an expansive private backyard, ideal for entertaining or relaxation. Located just minutes from uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Costco, and KW Hospital, this home offers the perfect combination of comfort and convenience. Three generous bedrooms provide ample space for families, professionals, or students. The large yard offers endless possibilities for outdoor enjoyment. Easy access to public transit, shopping, dining, and entertainment makes daily life effortless. Don't miss this opportunity to lease a beautiful home in one of Waterloo's most sought-after neighborhoods. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Exterior Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-09T06:54:33.148121+00:00"
+"Directions": "KEATS WAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2111050"
+"ListOfficeKey": "284587"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-12-09T04:29:10Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T17:38:36Z"
+"Stories": "2.0"
+"StreetName": "AMOS"
+"StreetNumber": "30"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1547173136"
"RoomType" => "Recreation room"
"ListingId" => "40793031"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
1 => array:11 [
"RoomKey" => "1547173137"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793031"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
2 => array:11 [
"RoomKey" => "1547173138"
"RoomType" => "Bedroom"
"ListingId" => "40793031"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
3 => array:11 [
"RoomKey" => "1547173139"
"RoomType" => "Bedroom"
"ListingId" => "40793031"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "19'7'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
4 => array:11 [
"RoomKey" => "1547173140"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793031"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
5 => array:11 [
"RoomKey" => "1547173141"
"RoomType" => "Living room"
"ListingId" => "40793031"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
6 => array:11 [
"RoomKey" => "1547173142"
"RoomType" => "Kitchen"
"ListingId" => "40793031"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29173268"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T17:38:36.06Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29173268/30-amos-avenue-unit-a-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2025-12-09T04:29:10.3Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:24 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362416299"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/103d6bf8af1ea7a6fede8cd865c32f6b.webp"
"MediaSize" => 121083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-103d6bf8af1ea7a6fede8cd865c32f6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of house with brick siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362416315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/51ebafb97c5cf4fd3bd0515647af8d62.webp"
"MediaSize" => 65008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-51ebafb97c5cf4fd3bd0515647af8d62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with freestanding refrigerator, plenty of natural light, light countertops, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362416331"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/074bf4e1ca4b7d9a3d2db7f9e41718b0.webp"
"MediaSize" => 71629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-074bf4e1ca4b7d9a3d2db7f9e41718b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light countertops, white appliances, white cabinetry, and decorative backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362416349"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/f57ca7520b85558ef46df6f0fdb1b66c.webp"
"MediaSize" => 74056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-f57ca7520b85558ef46df6f0fdb1b66c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, estacked washer and dryer, white appliances, decorative backsplash, and light stone finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362416376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/be8aa8f90ac2a4118e763a39a4fc0a30.webp"
"MediaSize" => 69182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-be8aa8f90ac2a4118e763a39a4fc0a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinets, white appliances, tasteful backsplash, a textured ceiling, and light stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362416403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/d51ece6bee12769c4d26e90a006207ca.webp"
"MediaSize" => 45112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-d51ece6bee12769c4d26e90a006207ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room featuring dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362416431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/00fbe228afbf91bf143b486560dee0d3.webp"
"MediaSize" => 40206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-00fbe228afbf91bf143b486560dee0d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinets, white dishwasher, healthy amount of natural light, and stacked washer / drying machine"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362416463"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/2ae0fdaba6e5b070e00f303ef243c61e.webp"
"MediaSize" => 58849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-2ae0fdaba6e5b070e00f303ef243c61e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, a stall shower, and tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362416494"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/3b18cbdef633e426641c1fad22beeb64.webp"
"MediaSize" => 44878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-3b18cbdef633e426641c1fad22beeb64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and shower / tub combination"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362416538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/7af1da04cde94b98cf3d9f0a67de17be.webp"
"MediaSize" => 50019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-7af1da04cde94b98cf3d9f0a67de17be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room with dark wood-style flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362416558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/7ae8669cdc953aaf55b718ad1289887a.webp"
"MediaSize" => 64775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-7ae8669cdc953aaf55b718ad1289887a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a shower stall and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362416578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/ab0049c475106faef0ae5cc88770ef40.webp"
"MediaSize" => 53266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-ab0049c475106faef0ae5cc88770ef40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bathroom featuring vanity and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362416616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/96d7b3331ae2538fad0a7d27b0eb11aa.webp"
"MediaSize" => 40206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-96d7b3331ae2538fad0a7d27b0eb11aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinets, white dishwasher, healthy amount of natural light, and stacked washer / drying machine"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362416649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/0ae34519de63eb4b6abfb09d802ea850.webp"
"MediaSize" => 69235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-0ae34519de63eb4b6abfb09d802ea850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white appliances, light countertops, white cabinetry, and decorative backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362416675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/ddd38ccb5cc66df10bac059c0efebd2c.webp"
"MediaSize" => 52639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-ddd38ccb5cc66df10bac059c0efebd2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring freestanding refrigerator, white cabinets, light stone countertops, and decorative backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362416698"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/59488d20fe7f66acc28e9cfbaf694e10.webp"
"MediaSize" => 92857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-59488d20fe7f66acc28e9cfbaf694e10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring tasteful backsplash and white cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362416718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/24be01fbb92c7c1515397066c1e6c5b9.webp"
"MediaSize" => 40005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-24be01fbb92c7c1515397066c1e6c5b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with light wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362416756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/a2de4e398e3c78decc363fc96fb831ca.webp"
"MediaSize" => 69235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-a2de4e398e3c78decc363fc96fb831ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white appliances, light countertops, white cabinetry, and decorative backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362416785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/987627ffb745ac0f87f03e0c9e957ef5.webp"
"MediaSize" => 49673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-987627ffb745ac0f87f03e0c9e957ef5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs with a textured ceiling and washer / clothes dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362416810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/a062793fed561ab8176e9181a76f0f16.webp"
"MediaSize" => 68901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-a062793fed561ab8176e9181a76f0f16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom featuring stacked washer / dryer and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6362416834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/dad2e30ad11260a939be1ba0a251c12a.webp"
"MediaSize" => 48153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-dad2e30ad11260a939be1ba0a251c12a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring dark wood-type flooring, a ceiling fan, a textured ceiling, and an office area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6362416852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/b61dc399096e4ffa6479e167c84407c7.webp"
"MediaSize" => 48543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-b61dc399096e4ffa6479e167c84407c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with wood finished floors, a closet, a ceiling fan, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6362416867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/7cba411e9b837277e6bd0ce753641993.webp"
"MediaSize" => 30504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-7cba411e9b837277e6bd0ce753641993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with dark wood-type flooring and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6362416883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173268/9a5932f52f1ef313de1510e15c4f73ae.webp"
"MediaSize" => 65008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173268/thumbnail-9a5932f52f1ef313de1510e15c4f73ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with freestanding refrigerator, plenty of natural light, light countertops, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793031"
"ResourceRecordKey" => "29173268"
"ModificationTimestamp" => "2025-12-09T04:29:10.31Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Igor Miljanovic"
"MemberFirstName" => "Igor"
"MemberLastName" => "Miljanovic"
"MemberMlsId" => "MI5238"
"OriginatingSystemName" => 26
"MemberKey" => "2111050"
"ModificationTimestamp" => "2025-10-28T23:34:16Z"
"MemberStatus" => "Active"
"OfficeKey" => "284587"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberCity" => "Toronto"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "416-832-5895"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-02-22T22:10:00Z"
"MemberNationalAssociationId" => "1379612"
"OfficeNationalAssociationId" => "1343174"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "HOMELIFE MIRACLE REALTY LTD"
"OfficePhone" => "416-747-9777"
"OfficeMlsId" => "MI81"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "284587"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "5010 Steeles Ave W Unit 11A"
"OfficeCity" => "Toronto"
"OfficePostalCode" => "M9V5C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "416-747-7135"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2019-01-22T19:14:00Z"
"OfficeNationalAssociationId" => "1343174"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1351906"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173268')"
+"ID": "470347"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 80d1d689d5a69d7d2e812b159dbec4a0a73c380f1c409b3f30bdca100c22f6e9" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25459
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25453
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE MIRACLE REALTY LTD"
+"OfficeEmail": null
+"OfficePhone": "416-747-9777"
+"OfficeMlsId": "MI81"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284587"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5010 Steeles Ave W Unit 11A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Toronto"
+"OfficePostalCode": "M9V5C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1343174"
+"OriginalEntryTimestamp": "2019-01-22T19:14:00Z"
+"OfficeFax": "416-747-7135"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "302617"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "284587"
"SocialMediaUrlOrId" => "http://www.homelifemiracle.com/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1351906"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('284587')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2111050/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2111050&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2111050/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2111050&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25445
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29173268" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25079
+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 29173268/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173268&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173268/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173268&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25059
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173268 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.548616 43.45845)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173268 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.548616 43.45845)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173268 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.548616 43.45845)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173268 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.548616 43.45845)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24921
+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 {#25293
+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"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.68Z"
]
3 => array:11 [
"RoomKey" => "1550350880"
"RoomType" => "Bedroom"
"ListingId" => "40793961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.68Z"
]
4 => array:11 [
"RoomKey" => "1550350881"
"RoomType" => "Laundry room"
"ListingId" => "40793961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.68Z"
]
5 => array:11 [
"RoomKey" => "1550350882"
"RoomType" => "Kitchen"
"ListingId" => "40793961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29191281"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T14:29:20.68Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6373082806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/bad317f498d1db793a804d8b40d5c883.webp"
"MediaSize" => 36983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-bad317f498d1db793a804d8b40d5c883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6373082813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/4db30572aa30fb093d784f727fa34d04.webp"
"MediaSize" => 55831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-4db30572aa30fb093d784f727fa34d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "EV Charging area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6373082824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/e4b618a1039a6f4021c2100a2aa0bf9a.webp"
"MediaSize" => 53629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-e4b618a1039a6f4021c2100a2aa0bf9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6373082830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/b2e056245554ec3e4a6a39888e52e099.webp"
"MediaSize" => 45815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-b2e056245554ec3e4a6a39888e52e099.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6373082841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/1c30e5d942c12fa88426ed09d3254960.webp"
"MediaSize" => 68108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-1c30e5d942c12fa88426ed09d3254960.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6373082851"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/cf02336e491aceced43ebb1475c4332d.webp"
"MediaSize" => 92959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-cf02336e491aceced43ebb1475c4332d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793961"
"ResourceRecordKey" => "29191281"
"ModificationTimestamp" => "2025-12-17T14:29:20.65Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6373082861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29191281/830e3d4efcabfe6680b352238ac266e8.webp"
"MediaSize" => 100887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29191281/thumbnail-830e3d4efcabfe6680b352238ac266e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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 {#25300
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24920
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+post_id: "470178"
+post_author: 1
+"ListingKey": "29173218"
+"ListingId": "X12611662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T15:30:28Z"
+"RFModificationTimestamp": "2025-12-09T15:34:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G3"
+"UnparsedAddress": "30A AMOS AVENUE, Waterloo, Ontario N2L5G3"
+"Coordinates": array:2 [
0 => -80.5462165
1 => 43.4567849
]
+"Latitude": 43.4567849
+"Longitude": -80.5462165
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious three-bedroom semi-detached home in a prime Waterloo location. This well-maintained property features a finished basement with a separate entrance, perfect for additional living space or potential income. The modern white eat-in kitchen boasts contemporary finishes and a convenient walkout to an expansive private backyard, ideal for entertaining or relaxation. Located just minutes from uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Costco, and KW Hospital, this home offers the perfect combination of comfort and convenience. Three generous bedrooms provide ample space for families, professionals, or students. The large yard offers endless possibilities for outdoor enjoyment. Easy access to public transit, shopping, dining, and entertainment makes daily life effortless. Don't miss this opportunity to lease a beautiful home in one of Waterloo's most sought-after neighborhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T04:34:48.132778+00:00"
+"Directions": "Cross Streets: Amos and Erb St W. ** Directions: Turn on Amos from Erb St W."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1884502"
+"ListOfficeKey": "50892"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T03:44:28Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T15:17:20Z"
+"Stories": "2.0"
+"StreetName": "Amos"
+"StreetNumber": "30A"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29173218/30a-amos-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2500
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2025-12-09T03:44:28.55Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173218')"
+"ID": "470178"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24894
+post_id: "465332"
+post_author: 1
+"ListingKey": "29166367"
+"ListingId": "40792612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T18:30:17Z"
+"RFModificationTimestamp": "2025-12-05T19:03:01Z"
+"ListPrice": 1700000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.26
+"LivingArea": 3602.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5H7"
+"UnparsedAddress": "38 ACADEMY Crescent, Waterloo, Ontario N2L5H7"
+"Coordinates": array:2 [
0 => -80.5565336
1 => 43.4681032
]
+"Latitude": 43.4681032
+"Longitude": -80.5565336
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A masterpiece of design and craftsmanship, with over 3,600 sqft of living space, this executive home in Waterloo’s prestigious Old Beechwood neighbourhood has been completely transformed with over $550,000 in professional renovations. Each level has been meticulously designed, blending timeless elegance with state-of-the-art comfort. Kitchen and basement renovations by the Canadian Home and Renovations Team. Engineered hardwood, custom millwork, and leathered granite finishes anchor a space where luxury meets technology. With a Station Earth AV system, integrated Sonos sound, and smart networking throughout, you’ll know this isn’t a renovation—it’s a reinvention. Curb appeal is undeniable and a ¼-acre pie-shaped lot that widens to 128 feet at the rear. The main floor blends elegance and function, featuring a dedicated home office ideal for today’s flexible lifestyle. The open-concept kitchen/living areas impress with a leathered granite island, quartz backsplash, built-in beverage station, Thermador appliances, and a matching granite fireplace. Sunlit living spaces open to a sprawling deck with pergola dining, outdoor gas fireplace, and BBQ hookup—an effortless flow from indoor comfort to outdoor retreat. Upstairs, 4 bedrooms include spa-inspired bathrooms with heated floors, while the primary suite offers a gas fireplace, ensuite, and integrated Sonos sound. The lower level redefines recreation: a soundproofed theatre with blackout blinds/HD projection, full glass-walled gym, spa bath with sauna/double shower, custom bar with dishwasher/fridge, and den/music lounge with fireplace. Dual laundry areas on the main and lower levels add ultimate convenience. A new furnace, A/C, and tankless water heater (2022) add everyday efficiency to the elegance. Located close to Beechwood trails, Conestoga Mall, St. Jacobs Market, universities, tech hubs, and Uptown Waterloo’s dining and shopping, it offers rare privacy, prestige, and perfection—all in one address. (id:62650)"
+"Appliances": array:1 [
0 => "Wet Bar"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:02:53.456364+00:00"
+"Directions": "Old Post Road to Academy Cres"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565503"
+"ListOfficeKey": "283852"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.26"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T18:00:45Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:00:44Z"
+"Stories": "2.0"
+"StreetName": "ACADEMY"
+"StreetNumber": "38"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "8316.05"
+"VirtualTourURLUnbranded": "https://youtu.be/Jvhlx6z7HEQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166367/38-academy-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1565504"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 2414
+"BelowGradeFinishedArea": 1188
+"OriginalEntryTimestamp": "2025-12-05T18:00:44.52Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "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:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166367')"
+"ID": "465332"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "465049"
+post_author: 1
+"ListingKey": "29165300"
+"ListingId": "40792481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T14:15:40Z"
+"RFModificationTimestamp": "2025-12-05T17:34:52Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1814.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6N6"
+"UnparsedAddress": "255 KEATS Way Unit# 701, Waterloo, Ontario N2L6N6"
+"Coordinates": array:2 [
0 => -80.5433895
1 => 43.4620641
]
+"Latitude": 43.4620641
+"Longitude": -80.5433895
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "KEATSWAY ON THE PARK! Welcome to this spacious 1,800 sq. ft. 2 bedroom plus den, 2 bathroom condo situated in desirable neighbourhood within walking distance to University of Waterloo & Laurier! Carpet free with newer vinyl plank flooring throughout. Open concept living/dining/family rooms with sliding door walk-out to large open balcony with panoramic views. Split bedroom floor plan. Spacious primary bedroom with full ensuite and walk-in closet. In-suite laundry and storage room plus storage locker. Two owned parking spots – one underground and one surface! Amenities include exercise room and guest suite. Enjoy a care-free condo lifestyle in a great location near public transit, shops, restaurants & Waterloo park! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "1001"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T17:34:42.943766+00:00"
+"Directions": "Erb Street W. to University Avenue W. to Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564177"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-05T14:11:03Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T14:11:03Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "255"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "5585"
+"VirtualTourURLUnbranded": "https://youriguide.com/701_255_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29165300/255-keats-way-unit-701-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1564615"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76831"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Guest Suite"
]
+"ZoningDescription": "RMU 40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1814
+"OriginalEntryTimestamp": "2025-12-05T14:08:54.88Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165300')"
+"ID": "465049"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 112
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]