array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29878628 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1512898"
+post_author: 1
+"ListingKey": "29878628"
+"ListingId": "X13422258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T23:50:02Z"
+"RFModificationTimestamp": "2026-06-11T23:52:29Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5E5"
+"UnparsedAddress": "26A HELENE CRESCENT, Waterloo, Ontario N2L5E5"
+"Coordinates": array:2 [
0 => -80.545003
1 => 43.456854
]
+"Latitude": 43.456854
+"Longitude": -80.545003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic opportunity for first-time buyers and investors! This exceptionally clean and well-maintained 3-bedroom semi-detached home features a highly functional, sun-filled layout with spacious principal rooms and a practical kitchen. The upper level offers 3 comfortable bedrooms and a solid 4-piece bathroom. Features a private separate side entrance leading to a fully self-contained, city-registered 1-bedroom Legal Basement apartment-the ultimate mortgage helper to offset living costs! Extended driveway with parking for 3 cars. Move right in or customize to your taste over time. Unbeatable location close to top schools, local transit, major highway, and shopping centers! The tenant is willing to stay and pay $1,300 per month. An unbeatable location perfect for students or commuters, offering effortless access to both the universities University of Waterloo & Wilfrid Laurier university and public transit(Bus Stop). Upgraded electrical Panel. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Apartment in basement"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-09T22:22:30.502075+00:00"
+"Directions": "ERB ST/AMOS AVE"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062462"
+"ListOfficeKey": "278186"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "32.3 x 95.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T21:36:55Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T23:43:55Z"
+"Stories": "2.0"
+"StreetName": "Helene"
+"StreetNumber": "26A"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3548"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1657441966"
"RoomType" => "Kitchen"
"ListingId" => "X13422258"
"RoomLevel" => "Main level"
"RoomWidth" => 3.44
"ListingKey" => "29878628"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:43:55.41Z"
]
1 => array:11 [
"RoomKey" => "1657441967"
"RoomType" => "Living room"
"ListingId" => "X13422258"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29878628"
"RoomLength" => 4.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:43:55.41Z"
]
2 => array:11 [
"RoomKey" => "1657441968"
"RoomType" => "Bedroom"
"ListingId" => "X13422258"
"RoomLevel" => "Second level"
"RoomWidth" => 2.77
"ListingKey" => "29878628"
"RoomLength" => 3.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:43:55.41Z"
]
3 => array:11 [
"RoomKey" => "1657441969"
"RoomType" => "Bedroom 2"
"ListingId" => "X13422258"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29878628"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:43:55.41Z"
]
4 => array:11 [
"RoomKey" => "1657441970"
"RoomType" => "Bedroom 3"
"ListingId" => "X13422258"
"RoomLevel" => "Second level"
"RoomWidth" => 2.47
"ListingKey" => "29878628"
"RoomLength" => 2.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:43:55.42Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29878628/26a-helene-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.3
+"OriginalEntryTimestamp": "2026-06-09T20:48:43.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1337461"
+"ListOfficeNationalAssociationId": "1290738"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29878628_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/ca44e0c80e77d01fbc4f5840546d53d2.webp"
"MediaSize" => 397066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-ca44e0c80e77d01fbc4f5840546d53d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:14.04Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29878628_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/8ac0c00f109cae074bd0e24ac3ede915.webp"
"MediaSize" => 372485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-8ac0c00f109cae074bd0e24ac3ede915.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:26.17Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29878628_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/187f393e2eba8851bdac4108924dbc37.webp"
"MediaSize" => 396174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-187f393e2eba8851bdac4108924dbc37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.52Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29878628_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/32cea22e6aee7543c8415920ca83b1f1.webp"
"MediaSize" => 100010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-32cea22e6aee7543c8415920ca83b1f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29878628_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/b383fa11e77628ac2a80f386d792fcf2.webp"
"MediaSize" => 124088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-b383fa11e77628ac2a80f386d792fcf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29878628_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/7a18507440c9e4766619af8ad173493c.webp"
"MediaSize" => 181628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-7a18507440c9e4766619af8ad173493c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.54Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29878628_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/fcc3ced8e718c86ec96139266eb0ec72.webp"
"MediaSize" => 190642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-fcc3ced8e718c86ec96139266eb0ec72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29878628_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/446912700b3cad5a3210bd719c7ee5c1.webp"
"MediaSize" => 169521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-446912700b3cad5a3210bd719c7ee5c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.65Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29878628_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/2c289fe26ad2323ccb411ca6d85052e8.webp"
"MediaSize" => 161192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-2c289fe26ad2323ccb411ca6d85052e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29878628_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/de805d03850b4209f267636281381406.webp"
"MediaSize" => 167390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-de805d03850b4209f267636281381406.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:03.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29878628_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/198151352c68ebf2b1facc94d905dd3e.webp"
"MediaSize" => 98313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-198151352c68ebf2b1facc94d905dd3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:57.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29878628_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/af6982282b4a8c5ce319e6760e2694ca.webp"
"MediaSize" => 123569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-af6982282b4a8c5ce319e6760e2694ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:56.25Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29878628_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/efd599102bbd57e0172bdfd56529b29b.webp"
"MediaSize" => 97523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-efd599102bbd57e0172bdfd56529b29b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:02.59Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29878628_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/ae9ce5b51895dac1d834123a1b77d58f.webp"
"MediaSize" => 121640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-ae9ce5b51895dac1d834123a1b77d58f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:07.48Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29878628_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/d6674439adade0e08e18f86a6b247c1f.webp"
"MediaSize" => 175254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-d6674439adade0e08e18f86a6b247c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:11.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29878628_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/3ee7e70a7e3fddae817409f3f72abbc3.webp"
"MediaSize" => 162077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-3ee7e70a7e3fddae817409f3f72abbc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:57.81Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29878628_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/d3175fd1b5244b10a589fc0c9536df5f.webp"
"MediaSize" => 199551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-d3175fd1b5244b10a589fc0c9536df5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29878628_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/f4b0eb7f676d6d907c72125b87137e9c.webp"
"MediaSize" => 112741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-f4b0eb7f676d6d907c72125b87137e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29878628_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/e0aa3a97acc548b0bd253acf1d973649.webp"
"MediaSize" => 145988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-e0aa3a97acc548b0bd253acf1d973649.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.59Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29878628_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/337299b20611622cfb2c4924c738a019.webp"
"MediaSize" => 154267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-337299b20611622cfb2c4924c738a019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:10.74Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29878628_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/e1d298c49fac84fcc5c8d2a5256b0fe7.webp"
"MediaSize" => 114301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-e1d298c49fac84fcc5c8d2a5256b0fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:18.1Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29878628_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/bffdc202e6766828f0d8fe5959010c64.webp"
"MediaSize" => 139518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-bffdc202e6766828f0d8fe5959010c64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:26:58.31Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29878628_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/5cf1f35e813cac85ca4ce307438e3f40.webp"
"MediaSize" => 100367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-5cf1f35e813cac85ca4ce307438e3f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:27:04.56Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29878628_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/f3de9113a0cc9935db50ab8aca6d9c15.webp"
"MediaSize" => 345664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-f3de9113a0cc9935db50ab8aca6d9c15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:55.96Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29878628_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/030fe868c223b064ed37a3fd1b3e9e9d.webp"
"MediaSize" => 275153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-030fe868c223b064ed37a3fd1b3e9e9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:51.36Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29878628_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/8e111e5c689914741287dc790c5a4586.webp"
"MediaSize" => 247300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-8e111e5c689914741287dc790c5a4586.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:55.53Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29878628_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/483f145e805f43d34d787ff24cccb4dc.webp"
"MediaSize" => 99097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-483f145e805f43d34d787ff24cccb4dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:51.43Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29878628_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/02a5b94b7e5f648235fa6fd7f38f6c98.webp"
"MediaSize" => 165798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-02a5b94b7e5f648235fa6fd7f38f6c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:55.91Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29878628_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/2e2603361e9a1d5be3ed05393da3b5c6.webp"
"MediaSize" => 98675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-2e2603361e9a1d5be3ed05393da3b5c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T21:36:51.4Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29878628_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/407959eebda140d9e531da3fd9f42370.webp"
"MediaSize" => 26030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-407959eebda140d9e531da3fd9f42370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:18.66Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29878628_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/0a874020144bb99e8547e7c1a6f98ec7.webp"
"MediaSize" => 37506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-0a874020144bb99e8547e7c1a6f98ec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:22.93Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29878628_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/47b90df80dc844e167281b8319737d5a.webp"
"MediaSize" => 275153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-47b90df80dc844e167281b8319737d5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:26.78Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29878628_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/5f6c59710aa11b041c28d7d270981eed.webp"
"MediaSize" => 98675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-5f6c59710aa11b041c28d7d270981eed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:15.16Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29878628_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/94530e4133c2be3a90edac9c2a950e86.webp"
"MediaSize" => 165798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-94530e4133c2be3a90edac9c2a950e86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:19.38Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29878628_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/21b1cb015622b3b64c88ac89c3076442.webp"
"MediaSize" => 247300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-21b1cb015622b3b64c88ac89c3076442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:24.69Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29878628_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/e7d5d25ea3ef57dec90349d957a51535.webp"
"MediaSize" => 99097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-e7d5d25ea3ef57dec90349d957a51535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-10T20:47:27.07Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29878628_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/dbde446474e85296a82df029948fbd4b.webp"
"MediaSize" => 99097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-dbde446474e85296a82df029948fbd4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29878628_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/36c2e2b99b00fda0f5d28fe8c389ae79.webp"
"MediaSize" => 4477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-36c2e2b99b00fda0f5d28fe8c389ae79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29878628_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/c58f7934246f66a2695698c0cefc980e.webp"
"MediaSize" => 218141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-c58f7934246f66a2695698c0cefc980e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29878628_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/dc02f62b87f5843c842c42d8f271391f.webp"
"MediaSize" => 197436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-dc02f62b87f5843c842c42d8f271391f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29878628_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/a19da5cb9a59d4afded8e070d8148a8c.webp"
"MediaSize" => 141982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-a19da5cb9a59d4afded8e070d8148a8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29878628_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/4daf84ee98576329f3140a47f33d245a.webp"
"MediaSize" => 121559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-4daf84ee98576329f3140a47f33d245a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29878628_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878628/f5f7bb070f0297c5daa36c33e8cfa8c6.webp"
"MediaSize" => 128619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878628/thumbnail-f5f7bb070f0297c5daa36c33e8cfa8c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13422258"
"ResourceRecordKey" => "29878628"
"ModificationTimestamp" => "2026-06-09T20:48:43.13Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878628')"
+"ID": "1512898"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 278186" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24809
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062462" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24782
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29878628'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25126
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29878628'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25141
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31436909"
+"ListingKey": "29878628"
+"ListingId": "X13422258"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T21:19:35Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31436909')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31436910"
+"ListingKey": "29878628"
+"ListingId": "X13422258"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T21:19:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31436910')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29878628' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.545003 43.456854)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1524680"
+post_author: 1
+"ListingKey": "29894553"
+"ListingId": "40829023"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:30:06Z"
+"RFModificationTimestamp": "2026-06-12T20:09:42Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5566627
1 => 43.4577016
]
+"Latitude": 43.4577016
+"Longitude": -80.5566627
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you’ll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:09:38.059035+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T14:22:18Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:22:18Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1657712188"
"RoomType" => "Utility room"
"ListingId" => "40829023"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
1 => array:11 [
"RoomKey" => "1657712189"
"RoomType" => "Recreation room"
"ListingId" => "40829023"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 21'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
2 => array:11 [
"RoomKey" => "1657712190"
"RoomType" => "Laundry room"
"ListingId" => "40829023"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
3 => array:11 [
"RoomKey" => "1657712191"
"RoomType" => "3pc Bathroom"
"ListingId" => "40829023"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
4 => array:11 [
"RoomKey" => "1657712192"
"RoomType" => "Primary Bedroom"
"ListingId" => "40829023"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
5 => array:11 [
"RoomKey" => "1657712193"
"RoomType" => "Bedroom"
"ListingId" => "40829023"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
6 => array:11 [
"RoomKey" => "1657712194"
"RoomType" => "Bedroom"
"ListingId" => "40829023"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
7 => array:11 [
"RoomKey" => "1657712195"
"RoomType" => "4pc Bathroom"
"ListingId" => "40829023"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "5'7'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
8 => array:11 [
"RoomKey" => "1657712196"
"RoomType" => "Living room"
"ListingId" => "40829023"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
9 => array:11 [
"RoomKey" => "1657712197"
"RoomType" => "Kitchen"
"ListingId" => "40829023"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
10 => array:11 [
"RoomKey" => "1657712198"
"RoomType" => "Dining room"
"ListingId" => "40829023"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
11 => array:11 [
"RoomKey" => "1657712199"
"RoomType" => "2pc Bathroom"
"ListingId" => "40829023"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29894553"
"RoomLength" => null
"RoomDimensions" => "2'8'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:22:18.63Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894553/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 230
+"OriginalEntryTimestamp": "2026-06-12T14:22:18.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894553_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/a5fc281ca06654ae55695e9da09e6dea.webp"
"MediaSize" => 135123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-a5fc281ca06654ae55695e9da09e6dea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29894553_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/dec28f4c562a05d7a96d59f517589e39.webp"
"MediaSize" => 148073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-dec28f4c562a05d7a96d59f517589e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29894553_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/73ebb73f7fb5e375437a2f35edea15be.webp"
"MediaSize" => 141750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-73ebb73f7fb5e375437a2f35edea15be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29894553_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/4aa2c24db3b82b18b9770516e9d0a015.webp"
"MediaSize" => 134187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-4aa2c24db3b82b18b9770516e9d0a015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29894553_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/97adcb64b6f75757bdb721b6b978cc34.webp"
"MediaSize" => 37938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-97adcb64b6f75757bdb721b6b978cc34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29894553_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/902baf67c363480db29c9fbc4bde2af1.webp"
"MediaSize" => 47995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-902baf67c363480db29c9fbc4bde2af1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29894553_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/d5aa2052c744560c241598b19be9ba62.webp"
"MediaSize" => 36824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-d5aa2052c744560c241598b19be9ba62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29894553_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/2a1d833ee3190dabf776bd972971f5bb.webp"
"MediaSize" => 20570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-2a1d833ee3190dabf776bd972971f5bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29894553_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/936fab41700eee3d585690cb7136b034.webp"
"MediaSize" => 54318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-936fab41700eee3d585690cb7136b034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29894553_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/b15e445c041ba37b1299a4901829feb9.webp"
"MediaSize" => 48548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-b15e445c041ba37b1299a4901829feb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29894553_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/c5d9129a8a6be1bdb6b042a3e5900d92.webp"
"MediaSize" => 57034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-c5d9129a8a6be1bdb6b042a3e5900d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29894553_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/9f386b522cb443553b2751b929f6a599.webp"
"MediaSize" => 53807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-9f386b522cb443553b2751b929f6a599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29894553_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894553/f58cad7f73c6e0d2acdcedbce40592d0.webp"
"MediaSize" => 61943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894553/thumbnail-f58cad7f73c6e0d2acdcedbce40592d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40829023"
"ResourceRecordKey" => "29894553"
"ModificationTimestamp" => "2026-06-12T14:22:18.6Z"
]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894553')"
+"ID": "1524680"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1524681"
+post_author: 1
+"ListingKey": "29895192"
+"ListingId": "X13436726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:47Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "4 - 417 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556684
1 => 43.457734
]
+"Latitude": 43.457734
+"Longitude": -80.556684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you'll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:38.683182+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Carport"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895192/4-417-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.56Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895192')"
+"ID": "1524681"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1523522"
+post_author: 1
+"ListingKey": "29894773"
+"ListingId": "40839244"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:30:07Z"
+"RFModificationTimestamp": "2026-06-12T15:32:17Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2494.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2S4"
+"UnparsedAddress": "186 UNION Boulevard, Kitchener, Ontario N2M2S4"
+"Coordinates": array:2 [
0 => -80.5216985
1 => 43.4544746
]
+"Latitude": 43.4544746
+"Longitude": -80.5216985
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**186 Union Boulevard, Kitchener** Located in the heart of prestigious Old Westmount, this beautifully maintained family home offers four bedrooms and four baths, space, privacy, and timeless appeal on one of Kitchener's most desirable streets. Surrounded by mature trees and established gardens, the property provides a private outdoor retreat complete with a charming waterfall pond and inviting backyard setting. Inside, hardwood flooring flows throughout the home. Abundant windows throughout the house fill the living spaces with natural light, creating a bright and welcoming atmosphere. The second floor features four generous bedrooms, including a spacious primary suite with large windows and a private ensuite bathroom. A stunning family bathroom with beautiful tile work serves the additional bedrooms. The main floor is designed for both everyday living and entertaining. A renovated kitchen opens to the breakfast and family rooms, where walls of floor-to-ceiling windows overlook the gardens and flood the space with natural light. Through French doors, a formal dining room and living room provide additional space to gather, while a convenient two-piece bathroom completes the main level. The finished basement extends the living space with a large recreation room and an additional two-piece bathroom. An attached garage, spacious double wide driveway, mature landscaping, and an exceptional Old Westmount location near schools, a welcoming community, parks, shopping, and Uptown Waterloo complete this rare offering. A wonderful opportunity to own a thoughtfully updated family home in one of the Region's most established and sought-after neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Dishwasher"
1 => "Freezer"
2 => "Window Coverings"
3 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T15:32:10.805384+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068773"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T14:42:56Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:20:10Z"
+"Stories": "2.0"
+"StreetName": "UNION"
+"StreetNumber": "186"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5413"
+"VirtualTourURLUnbranded": "https://youriguide.com/186_union_blvd_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894773/186-union-boulevard-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1904
+"BelowGradeFinishedArea": 590
+"OriginalEntryTimestamp": "2026-06-12T14:40:34.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1343939"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894773')"
+"ID": "1523522"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+post_id: "1516908"
+post_author: 1
+"ListingKey": "29881913"
+"ListingId": "40838438"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T21:45:03Z"
+"RFModificationTimestamp": "2026-06-13T21:50:36Z"
+"ListPrice": 665400.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1844.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M1R7"
+"UnparsedAddress": "627 WESTMOUNT Road W, Kitchener, Ontario N2M1R7"
+"Coordinates": array:2 [
0 => -80.5242875
1 => 43.4496302
]
+"Latitude": 43.4496302
+"Longitude": -80.5242875
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in the heart of Old Westmount! Situated on a PREMIUM DOUBLE LOT 105' x 107' this well-maintained split-level home offers exceptional potential in one of Waterloo's most sought-after neighborhoods. Whether you're looking to renovate, build your dream home, invest, or explore future development opportunities, the possibilities here are endless. Offering just under 1900 square feet of living space, the home features 3 bedrooms, 2 full bathrooms, hardwood flooring throughout, a double car garage, and a bright sunroom addition overlooking the expansive property. The lower level boasts a spacious rec room with a fireplace, providing additional living and entertaining space. This residence offers a solid foundation for renovation while preserving the character and charm that make Old Westmount so desirable. Located at the prominent corner of Westmount Road and Glasgow Street, this property is just steps to Belmont Village, parks, trails, schools, and all the amenities of Uptown Waterloo. Large double lots in Old Westmount are increasingly rare, making this an exceptional opportunity for homeowners, builders, investors, and developers alike. Buy, renovate, build, or develop — a truly unique opportunity in one of Waterloo's most prestigious neighborhoods. Some photos virtually staged (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:25:31.644402+00:00"
+"Directions": "Glasgow to Westmount Road, W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:19:50Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T21:39:36Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "627"
+"StreetSuffix": "Road"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "6865"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29881913/627-westmount-road-w-kitchener"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 105.0
+"AboveGradeFinishedArea": 1488
+"BelowGradeFinishedArea": 356
+"OriginalEntryTimestamp": "2026-06-10T15:19:50.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881913')"
+"ID": "1516908"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1514265"
+post_author: 1
+"ListingKey": "29881234"
+"ListingId": "40837861"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T14:30:08Z"
+"RFModificationTimestamp": "2026-06-10T14:49:36Z"
+"ListPrice": 1339000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2540.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2M8"
+"UnparsedAddress": "314 GLASGOW Street, Kitchener, Ontario N2M2M8"
+"Coordinates": array:2 [
0 => -80.5230304
1 => 43.4499906
]
+"Latitude": 43.4499906
+"Longitude": -80.5230304
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Extremely rare, private, park-like backyard in a highly desirable Westmount location. Enjoy the fibreglass swimming pool and extensive stone paver patio. Mature trees surround the gorgeous fully fenced landscape. This home has been meticulously maintained! It is in absolute move-in condition. Classic kitchen with breakfast bar and corian counters. All appliances included. Separate main floor family room, perfect for working at home. Hardwood floors throughout, gas fireplace and convenient main floor laundry. The principal bedroom offers both a sitting room and ensuite. Walk-out basement is finished with a spacious gym and recreation room. Walking distance to many amenities, Belmont Village, the Iron Horse trail, Westmount Golf & CC, schools and KW Hospital. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T14:49:31.151384+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Hot water radiator heat"
1 => "Forced air"
2 => "In Floor Heating"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564225"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-10T14:04:20Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T14:20:48Z"
+"Stories": "2.0"
+"StreetName": "GLASGOW"
+"StreetNumber": "314"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "6051"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/314_glasgow_street_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29881234/314-glasgow-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2038
+"BelowGradeFinishedArea": 502
+"OriginalEntryTimestamp": "2026-06-10T14:00:19.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069699"
+"ListOfficeNationalAssociationId": "1004398"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881234')"
+"ID": "1514265"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1512361"
+post_author: 1
+"ListingKey": "29879145"
+"ListingId": "X13422676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:25:49Z"
+"RFModificationTimestamp": "2026-06-09T22:27:31Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "72 PINEMEADOW CRESCENT, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.554071
1 => 43.449234
]
+"Latitude": 43.449234
+"Longitude": -80.554071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 72 Pinemeadow Crescent! This spotless, completely carpet-free over 1700 sqft finished living space raised bungalow in highly sought-after Westvale is move-in ready. Premium vinyl flooring & fresh professional paint (both 2026) flow throughout. Enjoy new pot lights in the living room & major updates including refrigerator (2026), dryer (2026), sump pump (2026), and A/C (2021). The fully finished lower level offers incredible versatility with a 4th bedroom, full bath & spacious rec room-ideal for an in-law suite, guest retreat, or rental potential. Step outside to a private, fenced backyard perfect for family gatherings. No sidewalk = less hassle & easier snow removal! Parking is a breeze w/ total 5 spaces (1 garage + 4 driveway). Minutes to top-rated schools, parks, transit, and The Boardwalk, featuring medical centres, a movie theatre, a water splash park, and a climbing park. Also close to Walmart, Costco & shops at Boardwalk. A quick walk away from the 201 and 202 bus stations to the University of Waterloo and Wilfrid Laurier University " A truly rare, turn-key opportunity - don't miss! (id:62650)"
+"Appliances": array:4 [
0 => "Water meter"
1 => "Water softener"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:27:20.959675+00:00"
+"Directions": "westvake dr & thorndale dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135760"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "47 x 118 FT ; 119.98ftx47.46ft x125.48 ftx36.24ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T21:49:10Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T22:19:22Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "72"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4055"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=tmdr6sHSX76&play=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29879145/72-pinemeadow-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.0
+"OriginalEntryTimestamp": "2026-06-09T21:49:10.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1388108"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29879145')"
+"ID": "1512361"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1509687"
+post_author: 1
+"ListingKey": "29874428"
+"ListingId": "40838031"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T20:45:03Z"
+"RFModificationTimestamp": "2026-06-13T20:49:03Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1772.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "72 PINEMEADOW Crescent, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.5540396
1 => 43.4492502
]
+"Latitude": 43.4492502
+"Longitude": -80.5540396
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 72 Pinemeadow Crescent! This spotless, completely carpet-free over 1700 sqft finished living space raised bungalow in highly sought-after Westvale is move-in ready. Premium vinyl flooring & fresh professional paint (both 2026) flow throughout. Enjoy new pot lights in the living room & major updates including refrigerator (2026), dryer (2026), sump pump (2026), and A/C (2021). The fully finished lower level offers incredible versatility with a 4th bedroom, full bath & spacious rec room—ideal for an in-law suite, guest retreat, or rental potential. Step outside to a private, fenced backyard perfect for family gatherings. No sidewalk = less hassle & easier snow removal! Parking is a breeze w/ total 5 spaces (1 garage + 4 driveway). Minutes to top-rated schools, parks, transit, and The Boardwalk, featuring medical centres, a movie theatre, a water splash park, and a climbing park. Also close to Walmart, Costco & shops at Boardwalk. A quick walk away from the 201 and 202 bus stations to the University of Waterloo and Wilfrid Laurier University “ A truly rare, turn-key opportunity – don't miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T06:45:08.223999+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T04:49:37Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T20:39:59Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "72"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4055"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=tmdr6sHSX76&play=1"
+"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/29874428/72-pinemeadow-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 1072
+"BelowGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-09T04:49:37.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874428')"
+"ID": "1509687"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1508941"
+post_author: 1
+"ListingKey": "29872724"
+"ListingId": "40837713"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:30:06Z"
+"RFModificationTimestamp": "2026-06-11T22:31:09Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3062.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1N1"
+"UnparsedAddress": "79 SOMERSET Crescent, Waterloo, Ontario N2L1N1"
+"Coordinates": array:2 [
0 => -80.5374417
1 => 43.4541545
]
+"Latitude": 43.4541545
+"Longitude": -80.5374417
+"YearBuilt": 1962
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on a quiet, tree-lined crescent in Waterloo's highly sought-after Westmount neighbourhood, 79 Somerset Crescent offers the kind of lifestyle that keeps families in a community for generations. Situated on an oversized, mature lot and surrounded by towering trees and beautiful landscaping, this exceptional home is just a short walk to top-rated Empire Public School, parks, trails, shopping, and only minutes from both universities. The classic side-split design creates a natural separation of space, offering a bright main living room, an inviting lower family room, and a dedicated theatre room with built-in surround sound that makes movie nights and game days unforgettable. Rich oak hardwood flooring flows throughout, while the extensively renovated kitchen serves as the heart of the home with marble countertops and backsplash, built-in ovens, a gas range, premium appliances, and views overlooking the backyard oasis. Three spacious bedrooms provide comfortable accommodations, highlighted by a luxurious primary ensuite renovated with elegant marble finishes and complemented by motorized window coverings. Outside, the property truly comes to life. Professionally landscaped and fully fenced for privacy, the backyard feels like your own private resort, featuring a saltwater inground pool with automatic cover, hot tub, irrigation system, landscape lighting, expansive stone patios, and an incredible covered outdoor living space complete with a fully equipped outdoor kitchen. Whether hosting family and friends, watching the kids spend endless summer days by the pool, or enjoying a quiet evening under the covered porch, this is a home designed around creating lasting memories. Combining timeless design, extensive updates, and one of Waterloo's most desirable family neighbourhoods, 79 Somerset Crescent offers a rare opportunity to enjoy refined living in the heart of Westmount. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T23:30:48.615587+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T21:21:26Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T22:21:08Z"
+"Stories": "2.0"
+"StreetName": "SOMERSET"
+"StreetNumber": "79"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "8001"
+"VirtualTourURLUnbranded": "https://youriguide.com/2r5uc_79_somerset_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29872724/79-somerset-crescent-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 123.0
+"AboveGradeFinishedArea": 2378
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-08T21:19:19.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872724')"
+"ID": "1508941"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1508091"
+post_author: 1
+"ListingKey": "29872328"
+"ListingId": "40835963"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T20:26:06Z"
+"RFModificationTimestamp": "2026-06-08T23:19:14Z"
+"ListPrice": 320000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1059.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 402, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5395355
1 => 43.4616179
]
+"Latitude": 43.4616179
+"Longitude": -80.5395355
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, spacious, and ideally located—welcome to Unit 402 at 65 Westmount Road N! Enjoy exceptional value with condo fees that include all utilities, making everyday living simple and hassle-free. This well-maintained 2-bedroom, 2-bathroom condo offers a sun-filled floor plan, exceptional building amenities, and a highly desirable Waterloo location that puts everyday conveniences right at your doorstep. Large windows fill the living spaces with natural light, creating a warm and inviting atmosphere throughout. The functional layout offers comfortable living and dining areas, while the primary bedroom features the convenience of its own ensuite bathroom. Whether you're a first-time buyer, downsizer, or investor, this home presents an excellent opportunity to own in a sought-after community. Residents enjoy access to a fantastic selection of amenities, including an elevator, exercise room, library, party room, workshop, and visitor parking. Ideally situated close to shopping, restaurants, parks, public transit, universities, and other essential amenities, this location offers both convenience and lifestyle. All existing furniture could be included! Move-in ready and thoughtfully maintained, this bright and welcoming condo is ready for its next owner. Don't miss your chance to enjoy comfortable, low-maintenance living in the heart of Waterloo! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
3 => "Hood Fan"
]
+"AssociationFee": "1090"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-06-08T23:19:10.961720+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992656"
+"ListOfficeKey": "292918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Laundry- Coin operated"
2 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-08T20:20:55Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T20:20:55Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://singlepropertywebsite.mohrrealestatemedia.com/order/03c1bc61-83e9-4ae6-6758-08dec0998ab8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29872328/65-westmount-road-n-unit-402-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1600677"
+"CoListOfficeKey": "294047"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 500.0
+"AboveGradeFinishedArea": 1059
+"OriginalEntryTimestamp": "2026-06-08T20:20:06.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1275904"
+"ListOfficeNationalAssociationId": "1419429"
+"CoListAgentNationalAssociationId": "1148143"
+"CoListOfficeNationalAssociationId": "1435346"
+"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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872328')"
+"ID": "1508091"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 141
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]