array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29896571 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1524092"
+post_author: 1
+"ListingKey": "29896571"
+"ListingId": "X13438200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:55:09Z"
+"RFModificationTimestamp": "2026-06-12T22:58:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN STREET, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.589798
1 => 43.464848
]
+"Latitude": 43.464848
+"Longitude": -80.589798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARE FIND! Prime location with amazing privacy and forest views! This fully finished detached 3 bedroom, 3 bathroom home offers an exceptional layout and an excellent finished basement. As you pull up to the home, you'll immediately notice its charming curb appeal. Step inside and you'll find a bright, welcoming space that feels just right. The care and updates throughout the home are evident at every turn. The main floor features an open-concept kitchen, dining, and living area with a vaulted ceiling and beautiful patio doors leading to your backyard paradise. The yard includes a new deck (2024) and a fenced yard, creating a beautiful, peaceful retreat that is still low maintenance. Upstairs, the spacious primary bedroom overlooks the backyard and offers plenty of room to relax. The stunning, spa-like primary ensuite, updated in 2023, is truly impressive. Two additional bedrooms complete the upper level. The basement features another full bathroom, plenty of storage space, a home office, and a large recreation room. The location is fantastic, close to top rated schools, beautiful walking trails, shopping, and more! Don't miss this rare opportunity to own a private, move-in-ready home in an outstanding location. ** SEE VIDEO FOR FULL TOUR!! ** WOW! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:21:27.298705+00:00"
+"Directions": "Cross Streets: Erbville Rd and Columbia Forst Blvd. ** Directions: Erbsville Rd, West on Columbia Forest Blvd, right on Royal Fern St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246631"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "27.8 x 106.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-12T22:49:11Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:49:11Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1658068252"
"RoomType" => "Kitchen"
"ListingId" => "X13438200"
"RoomLevel" => "Main level"
"RoomWidth" => 2.921
"ListingKey" => "29896571"
"RoomLength" => 3.1242
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.51Z"
]
1 => array:11 [
"RoomKey" => "1658068253"
"RoomType" => "Bathroom"
"ListingId" => "X13438200"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29896571"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.51Z"
]
2 => array:11 [
"RoomKey" => "1658068254"
"RoomType" => "Laundry room"
"ListingId" => "X13438200"
"RoomLevel" => "Basement"
"RoomWidth" => 2.6162
"ListingKey" => "29896571"
"RoomLength" => 3.0988
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.51Z"
]
3 => array:11 [
"RoomKey" => "1658068255"
"RoomType" => "Other"
"ListingId" => "X13438200"
"RoomLevel" => "Basement"
"RoomWidth" => 1.5748
"ListingKey" => "29896571"
"RoomLength" => 2.159
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
4 => array:11 [
"RoomKey" => "1658068256"
"RoomType" => "Dining room"
"ListingId" => "X13438200"
"RoomLevel" => "Main level"
"RoomWidth" => 2.794
"ListingKey" => "29896571"
"RoomLength" => 3.175
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
5 => array:11 [
"RoomKey" => "1658068257"
"RoomType" => "Living room"
"ListingId" => "X13438200"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4036
"ListingKey" => "29896571"
"RoomLength" => 5.8166
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
6 => array:11 [
"RoomKey" => "1658068258"
"RoomType" => "Bathroom"
"ListingId" => "X13438200"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29896571"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
7 => array:11 [
"RoomKey" => "1658068259"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13438200"
"RoomLevel" => "Second level"
"RoomWidth" => 3.7592
"ListingKey" => "29896571"
"RoomLength" => 4.9276
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
8 => array:11 [
"RoomKey" => "1658068260"
"RoomType" => "Bathroom"
"ListingId" => "X13438200"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29896571"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
9 => array:11 [
"RoomKey" => "1658068261"
"RoomType" => "Bedroom"
"ListingId" => "X13438200"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0734
"ListingKey" => "29896571"
"RoomLength" => 3.8354
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
10 => array:11 [
"RoomKey" => "1658068262"
"RoomType" => "Bedroom"
"ListingId" => "X13438200"
"RoomLevel" => "Second level"
"RoomWidth" => 2.8702
"ListingKey" => "29896571"
"RoomLength" => 3.175
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
11 => array:11 [
"RoomKey" => "1658068263"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13438200"
"RoomLevel" => "Basement"
"RoomWidth" => 3.3528
"ListingKey" => "29896571"
"RoomLength" => 5.2578
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
12 => array:11 [
"RoomKey" => "1658068264"
"RoomType" => "Office"
"ListingId" => "X13438200"
"RoomLevel" => "Basement"
"RoomWidth" => 2.54
"ListingKey" => "29896571"
"RoomLength" => 3.3274
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:49:11.52Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896571/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2026-06-12T17:56:38.8Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485484"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29896571_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/a9aa90b58d90c2dd448755e4b6dcc19b.webp"
"MediaSize" => 271822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-a9aa90b58d90c2dd448755e4b6dcc19b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:46:45.35Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29896571_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/b63c8ff1d3de2d011f6235f53d41256c.webp"
"MediaSize" => 413438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-b63c8ff1d3de2d011f6235f53d41256c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:46:47.13Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29896571_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/998936b8a2f5af426e3a59e8e559e7dc.webp"
"MediaSize" => 307820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-998936b8a2f5af426e3a59e8e559e7dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:59:00.17Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29896571_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/0e060f6e6522bae8cade99903c980108.webp"
"MediaSize" => 186672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-0e060f6e6522bae8cade99903c980108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:33.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29896571_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/977b8923c60f050978c8dcde1e2d06a4.webp"
"MediaSize" => 177313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-977b8923c60f050978c8dcde1e2d06a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:37.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29896571_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/7db4c08a6f19cbd8397a4e60ab2b9c97.webp"
"MediaSize" => 198511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-7db4c08a6f19cbd8397a4e60ab2b9c97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:28.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29896571_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/5b0575c8d16b7f67092333b9418b81c2.webp"
"MediaSize" => 240615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-5b0575c8d16b7f67092333b9418b81c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:37.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29896571_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/89527d7affc98466b6fca2860fde71c4.webp"
"MediaSize" => 179264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-89527d7affc98466b6fca2860fde71c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:28.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29896571_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/c7513d14ceb9fd56092bb484f3c5e5ff.webp"
"MediaSize" => 147893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-c7513d14ceb9fd56092bb484f3c5e5ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:36.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29896571_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/e29f0a01bd4aece69add9eb3d67355d1.webp"
"MediaSize" => 163638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-e29f0a01bd4aece69add9eb3d67355d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:23.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29896571_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/a01dcb5633f02e8219ada050d9c33267.webp"
"MediaSize" => 156120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-a01dcb5633f02e8219ada050d9c33267.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:29.12Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29896571_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/5451f4ff77f4c370a94f1c706a3b31e7.webp"
"MediaSize" => 187235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-5451f4ff77f4c370a94f1c706a3b31e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:36.34Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29896571_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/673c1bb952a0f84e0d907418c3887bb7.webp"
"MediaSize" => 94643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-673c1bb952a0f84e0d907418c3887bb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:44.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29896571_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/52987b85e61fa6897dbf82466fc38a85.webp"
"MediaSize" => 119565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-52987b85e61fa6897dbf82466fc38a85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:24.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29896571_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/68571f759d352be3eb8adc40fcd0efc9.webp"
"MediaSize" => 90295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-68571f759d352be3eb8adc40fcd0efc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:31.35Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29896571_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/3007f9e385aae9e6f58709547fd09e94.webp"
"MediaSize" => 70396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-3007f9e385aae9e6f58709547fd09e94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:39.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29896571_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/fcc060a6399d13ef64a33554083ea0f8.webp"
"MediaSize" => 150815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-fcc060a6399d13ef64a33554083ea0f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:48.22Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29896571_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/a26bb4d5760d772a304cc63c073b6e45.webp"
"MediaSize" => 108535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-a26bb4d5760d772a304cc63c073b6e45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:51.64Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29896571_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/8f87bc8c4735243c087c8010eef37fb0.webp"
"MediaSize" => 108535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-8f87bc8c4735243c087c8010eef37fb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T17:56:38.8Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29896571_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/1840664ae86de36b56d8ef97e003a57b.webp"
"MediaSize" => 139197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-1840664ae86de36b56d8ef97e003a57b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:54.87Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29896571_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/82cc9983605d60f61177930c5f93daba.webp"
"MediaSize" => 147414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-82cc9983605d60f61177930c5f93daba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:56.8Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29896571_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/bd9a274cdbefd92208d41bb8dc480b95.webp"
"MediaSize" => 131951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-bd9a274cdbefd92208d41bb8dc480b95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:59.13Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29896571_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/51eb03539b4785b43fb4ad66fc46d5d8.webp"
"MediaSize" => 139991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-51eb03539b4785b43fb4ad66fc46d5d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:25.06Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29896571_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/de91ef507b38de3ad360f38800d4cbf5.webp"
"MediaSize" => 127424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-de91ef507b38de3ad360f38800d4cbf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:31.62Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29896571_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/2a5fa9955abb881516697407dcfa3737.webp"
"MediaSize" => 141333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-2a5fa9955abb881516697407dcfa3737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:41.13Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29896571_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/e8047c424daaeaeec5a23da356044f5e.webp"
"MediaSize" => 146839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-e8047c424daaeaeec5a23da356044f5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:48.65Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29896571_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/d05792c8829bd38e72032a9f42f9eefb.webp"
"MediaSize" => 174119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-d05792c8829bd38e72032a9f42f9eefb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:52.19Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29896571_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/e6bd4122720bd47bbecd698de285c205.webp"
"MediaSize" => 150402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-e6bd4122720bd47bbecd698de285c205.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:55.92Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29896571_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/d93496e8749b83615e6766e190ebd226.webp"
"MediaSize" => 142713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-d93496e8749b83615e6766e190ebd226.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:57.94Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29896571_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/6241072a74cc7270ac9d965baf5366b0.webp"
"MediaSize" => 112037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-6241072a74cc7270ac9d965baf5366b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:26.56Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29896571_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/79a808653191a57296cfa45867303c3a.webp"
"MediaSize" => 106193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-79a808653191a57296cfa45867303c3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:27.43Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29896571_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/78fb32015730eacf483f2a80eecee1dc.webp"
"MediaSize" => 115659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-78fb32015730eacf483f2a80eecee1dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:35.48Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29896571_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/5dc76fa0ee625f0ea9948386b8f1eec5.webp"
"MediaSize" => 139341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-5dc76fa0ee625f0ea9948386b8f1eec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:43.45Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29896571_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/80f64d069557b81e1b9049460e0754ff.webp"
"MediaSize" => 161172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-80f64d069557b81e1b9049460e0754ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:48.77Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29896571_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/660372618f57541de9aba17729a54c36.webp"
"MediaSize" => 150430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-660372618f57541de9aba17729a54c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:52.25Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29896571_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/359e88953633f920e624afc98ffe9f36.webp"
"MediaSize" => 152139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-359e88953633f920e624afc98ffe9f36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:56.31Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29896571_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/4250541541e9be1c2f053ca8e5b54837.webp"
"MediaSize" => 180705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-4250541541e9be1c2f053ca8e5b54837.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:59.15Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29896571_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/31ae58fae203783deee7cba232653a47.webp"
"MediaSize" => 395473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-31ae58fae203783deee7cba232653a47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:59:00.53Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29896571_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/c7ba2aad96282472770190a0eee84820.webp"
"MediaSize" => 509928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-c7ba2aad96282472770190a0eee84820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:26.86Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29896571_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896571/aaa8647be8013bf96ca2f62679f77c08.webp"
"MediaSize" => 344828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896571/thumbnail-aaa8647be8013bf96ca2f62679f77c08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13438200"
"ResourceRecordKey" => "29896571"
"ModificationTimestamp" => "2026-06-12T21:58:27.74Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Cache Key: 9b19ecd0f92debd09157cbd0b6846504cca5c967e4e52cac4836ef7118b2aded" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24547
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2246631" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29896571'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25175
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29896571'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25191
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29896571' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589798 43.464848)) 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 {#25238
+post_id: "1544041"
+post_author: 1
+"ListingKey": "29922564"
+"ListingId": "X13461546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:10:09Z"
+"RFModificationTimestamp": "2026-06-18T19:13:19Z"
+"ListPrice": 999990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "274 BUTTONBUSH STREET, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.590313
1 => 43.451104
]
+"Latitude": 43.451104
+"Longitude": -80.590313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This Is The Opportunity Buyers Have Been Waiting For. A Detached 4+1 Bedroom, 4 Bathroom Home With Over 3,000 Sq Ft Of Finished Living Space, Double Garage, Finished Basement With Separate Entrance, And Immediate Vacant Possession - All In One Of Waterloo's Most Sought-After School Communities. Located In The Highly Desired Vista Hills Neighbourhood, Known For Top-Ranked Schools, Parks, Trails, And Family-Friendly Living, This Home Delivers The Space, Location, And Flexibility That Are Almost Impossible To Replace At This Price Point. The Main Floor Offers A Bright Open-Concept Layout With Hardwood Floors, Pot Lights, Large Windows, And A Chef-Inspired Kitchen Featuring Quartz Counters, Stainless Steel Appliances, And An Oversized Centre Island. Upstairs Features A Spacious Primary Retreat With Walk-In Closet And Ensuite, Plus Generous Bedrooms - Including A Rare Jr. Primary-Style Bedroom Ideal For Older Children, Guests, Extended Family, Or A Private Home Office. The Finished Lower Level Adds Major Value With A Full Bedroom, 3-Piece Bath, Large Rec Room, Separate Entrance, And Excellent In-Law Suite Or Income Potential. Vacant, Easy To Show, And Ready For Immediate Closing. If You Have Been Waiting For The Right Waterloo Family Home At The Right Price - This Is It. A Home With This Much Space, In This School District, At This Price Point, Should Not Be Missed! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:59:58.572140+00:00"
+"Directions": "Columbia St W and Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976739"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:00:22Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:00:21Z"
+"Stories": "2.5"
+"StreetName": "Buttonbush"
+"StreetNumber": "274"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6513.55"
+"VirtualTourURLUnbranded": "https://sites.happyhousegta.com/274buttonbushstreet"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1662332853"
"RoomType" => "Living room"
"ListingId" => "X13461546"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29922564"
"RoomLength" => 7.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
1 => array:11 [
"RoomKey" => "1662332854"
"RoomType" => "Dining room"
"ListingId" => "X13461546"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29922564"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
2 => array:11 [
"RoomKey" => "1662332855"
"RoomType" => "Kitchen"
"ListingId" => "X13461546"
"RoomLevel" => "Main level"
"RoomWidth" => 5.36
"ListingKey" => "29922564"
"RoomLength" => 4.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
3 => array:11 [
"RoomKey" => "1662332856"
"RoomType" => "Bedroom 2"
"ListingId" => "X13461546"
"RoomLevel" => "In between"
"RoomWidth" => 4.49
"ListingKey" => "29922564"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
4 => array:11 [
"RoomKey" => "1662332857"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13461546"
"RoomLevel" => "Second level"
"RoomWidth" => 5.13
"ListingKey" => "29922564"
"RoomLength" => 4.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
5 => array:11 [
"RoomKey" => "1662332858"
"RoomType" => "Bedroom 3"
"ListingId" => "X13461546"
"RoomLevel" => "Second level"
"RoomWidth" => 3.21
"ListingKey" => "29922564"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
6 => array:11 [
"RoomKey" => "1662332859"
"RoomType" => "Bedroom 4"
"ListingId" => "X13461546"
"RoomLevel" => "Second level"
"RoomWidth" => 4.64
"ListingKey" => "29922564"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
7 => array:11 [
"RoomKey" => "1662332860"
"RoomType" => "Bedroom"
"ListingId" => "X13461546"
"RoomLevel" => "Basement"
"RoomWidth" => 4.63
"ListingKey" => "29922564"
"RoomLength" => 2.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
8 => array:11 [
"RoomKey" => "1662332861"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13461546"
"RoomLevel" => "Basement"
"RoomWidth" => 8.49
"ListingKey" => "29922564"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
9 => array:11 [
"RoomKey" => "1662332862"
"RoomType" => "Laundry room"
"ListingId" => "X13461546"
"RoomLevel" => "Main level"
"RoomWidth" => 2.19
"ListingKey" => "29922564"
"RoomLength" => 2.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T19:00:21.98Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922564/274-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.1
+"OriginalEntryTimestamp": "2026-06-18T16:44:37.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1263079"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29922564_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/405d3baa1c970a1edb4789bd2d4865fc.webp"
"MediaSize" => 355115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-405d3baa1c970a1edb4789bd2d4865fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29922564_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/4bc786f352de2ee87d6e2df79488498b.webp"
"MediaSize" => 297551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-4bc786f352de2ee87d6e2df79488498b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29922564_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/d582b502a3ba88f26e379f71961145f8.webp"
"MediaSize" => 349152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-d582b502a3ba88f26e379f71961145f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29922564_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/4896f858c3bf62af1b5d7fc5319e7c4f.webp"
"MediaSize" => 381296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-4896f858c3bf62af1b5d7fc5319e7c4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29922564_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/a8edf7a0d4e37db8cef328bb6fc4774e.webp"
"MediaSize" => 133065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-a8edf7a0d4e37db8cef328bb6fc4774e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29922564_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/870daf64f8e7a2c4420ffa0e1d8b2fef.webp"
"MediaSize" => 95556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-870daf64f8e7a2c4420ffa0e1d8b2fef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29922564_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/a82762cecc1dc825015c14ba6e4a23a2.webp"
"MediaSize" => 162766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922564/thumbnail-a82762cecc1dc825015c14ba6e4a23a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13461546"
"ResourceRecordKey" => "29922564"
"ModificationTimestamp" => "2026-06-18T16:44:37.32Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29922564_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922564/084646b87b8cf4d233e83579a095a8b3.webp"
"MediaSize" => 179948
"MediaType" => "webp"
…8
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922564')"
+"ID": "1544041"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1543514"
+post_author: 1
+"ListingKey": "29921932"
+"ListingId": "40841103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:06Z"
+"RFModificationTimestamp": "2026-06-18T17:34:50Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1638.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 13, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5787185
1 => 43.4610221
]
+"Latitude": 43.4610221
+"Longitude": -80.5787185
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 350 Erbsville Rd #13, Waterloo! Ideally located in a highly desirable neighbourhood with convenient access to the universities, Tech Park, YMCA, shopping centres, transit, and numerous amenities. This well-maintained home offers excellent potential for first-time buyers, investors, or parents seeking housing for university students. Main floor features a functional layout with a walkout from the living room to a private deck and spacious backyard—perfect for relaxing or entertaining. The finished basement adds valuable living space, complete with a large recreation room featuring good-sized windows, laminate flooring, and a 3-piece bathroom. this home presents a fantastic opportunity to build equity and create a comfortable living space in one of Waterloo’s most sought-after locations. Don't miss this affordable entry into the Waterloo market! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"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-18T17:34:37.381920+00:00"
+"Directions": "olumbia Street W/ Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834644"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-18T16:11:13Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:13Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3652"
+"View": "City view"
+"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/29921932/350-erbsville-road-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 415
+"OriginalEntryTimestamp": "2026-06-18T15:51:28.04Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1196787"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921932')"
+"ID": "1543514"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1542528"
+post_author: 1
+"ListingKey": "29920639"
+"ListingId": "40839251"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:25:12Z"
+"RFModificationTimestamp": "2026-06-18T14:26:32Z"
+"ListPrice": 1270000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3505.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H9"
+"UnparsedAddress": "350 CANADA PLUM Street, Waterloo, Ontario N2V0H9"
+"Coordinates": array:2 [
0 => -80.5983757
1 => 43.4579421
]
+"Latitude": 43.4579421
+"Longitude": -80.5983757
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Better Than New – 2025 Built Home in Prestigious Vista Hills! Nestled in one of Waterloo’s most desirable communities and located within the highly acclaimed Laurel Heights Secondary School boundary, this stunning 4-bedroom family home offers over 3,500 sq. ft. of beautifully finished living space. Enjoy exceptional convenience with easy access to Costco, The Boardwalk, restaurants, parks, and transit. The thoughtfully designed main floor features 9-foot ceilings, engineered hardwood flooring in the great room, elegant pot lighting throughout, and a spacious open-concept layout perfect for modern living. The upgraded chef’s kitchen showcases quartz countertops, a large centre island with breakfast bar, premium cabinetry, and stainless steel appliances. A convenient main-floor laundry and mudroom adds everyday functionality. Upstairs, you’ll find four generously sized bedrooms, including a luxurious primary retreat complete with a walk-in closet and a versatile sitting area ideal for a home office, reading nook, or entertainment space. The professionally finished walk-out basement, completed by the builder, includes a full bathroom and offers outstanding potential for a future legal secondary suite or in-law setup, subject to municipal approvals—an excellent opportunity for additional rental income. Step outside and enjoy direct access to the scenic Vista Hills trail system, perfect for walking, cycling, and year-round outdoor enjoyment. Surrounded by playgrounds, greenspace, and the city’s largest forest park, this family-friendly neighbourhood offers the perfect blend of nature and convenience. As an added bonus, the builder will complete the rear deck featuring elegant glass railings, creating the perfect outdoor space for relaxing or entertaining. A rare opportunity to own a move-in-ready, better-than-new home in one of Waterloo’s most sought-after communities. Don't miss it! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-18T14:25:22.085552+00:00"
+"Directions": "Sundew Drive and Mayapple Street"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T12:51:04Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:11:35Z"
+"Stories": "2.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "350"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7782"
+"VirtualTourURLUnbranded": "https://youriguide.com/350_canada_plum_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920639/350-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2475
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-18T12:51:03.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920639')"
+"ID": "1542528"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1542297"
+post_author: 1
+"ListingKey": "29920234"
+"ListingId": "40840985"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T04:25:09Z"
+"RFModificationTimestamp": "2026-06-18T05:21:34Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3965.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B3"
+"UnparsedAddress": "505 ST MORITZ Avenue, Waterloo, Ontario N2T0B3"
+"Coordinates": array:2 [
0 => -80.5797441
1 => 43.4507512
]
+"Latitude": 43.4507512
+"Longitude": -80.5797441
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional custom-built two-storey residence nestled in the highly sought-after Clair Hills community. This stunning home offers over three levels of beautifully finished living space, featuring 3+2 bedrooms and 3.5 bathrooms. Meticulously maintained and extensively upgraded over the last three years, the home showcases a beautifully renovated chef-inspired kitchen and a luxurious primary ensuite, along with numerous high-quality improvements throughout. The sophisticated open-concept layout is ideal for both everyday living and entertaining, while the expansive walk-in pantry provides exceptional storage and convenience. The inviting family room is anchored by a striking custom stone fireplace and enhanced by a premium built-in audio system throughout the home. Sliding doors lead to a spacious deck overlooking a private, resort-style backyard oasis complete with a sparkling inground pool, creating the perfect setting for summer enjoyment and outdoor entertaining. Fronting onto St. Moritz Park, the property enjoys exceptional privacy with no rear neighbours, offering a serene, countryside-like setting rarely found within the city. Surrounded by mature greenery and tranquil views, the backyard provides a peaceful retreat that feels miles away from urban living. A functional mudroom with direct garage access adds practicality, while the professionally finished lower level offers additional living space, two bedrooms, full bathroom, and a walk-up to the backyard, providing excellent flexibility for guests, extended family, or recreation. Ideally situated within walking distance to top-rated schools, parks, scenic trails, and everyday amenities, and just minutes from Highways 7 / 8, this remarkable property seamlessly blends luxury, comfort, and convenience in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Wine Fridge"
8 => "Dryer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T05:21:24.245183+00:00"
+"Directions": "Columbia Road/St.Moritz Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905477"
+"ListOfficeKey": "296136"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T04:19:37Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T04:19:37Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "505"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8727"
+"VirtualTourURLUnbranded": "https://youriguide.com/505_st_moritz_ave_waterloo_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/29920234/505-st-moritz-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2039305"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296136"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2787
+"BelowGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-18T04:19:36.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1219577"
+"ListOfficeNationalAssociationId": "1454937"
+"CoListAgentNationalAssociationId": "1315396"
+"CoListOfficeNationalAssociationId": "1454937"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920234')"
+"ID": "1542297"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1538007"
+post_author: 1
+"ListingKey": "29914132"
+"ListingId": "40838042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:25:14Z"
+"RFModificationTimestamp": "2026-06-17T16:34:14Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2655.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E3"
+"UnparsedAddress": "626 WILD RYE Street, Waterloo, Ontario N2V0E3"
+"Coordinates": array:2 [
0 => -80.6008015
1 => 43.4593743
]
+"Latitude": 43.4593743
+"Longitude": -80.6008015
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 626 Wild Rye Street, a quintessential 4-bedroom, 3.5-bathroom home located in Waterloo's highly sought-after Vista Hills community. This exceptional property seamlessly blends comfort, functionality, and modern luxury. Pride of ownership is evident the moment you arrive and take in the home's outstanding curb appeal. This is far from your typical builder-basic home. Extensive upgrades and high-quality finishes can be found throughout. The thoughtfully designed mudroom entry from the garage has been meticulously planned with custom storage, benches, and hooks to keep everyday essentials organized and easily accessible. The main floor is the definition of open-concept living, anchored by a show-stopping kitchen featuring top-of-the-line appliances, premium finishes, and a dedicated bar area complete with an additional wine fridge. The built-in Sonos sound system throughout the home is a feature you'll quickly learn not to live without, setting the perfect atmosphere whether hosting guests or enjoying a quiet evening at home. Step outside to a professionally designed backyard retreat complete with outdoor dining, comfortable seating around a gas fire pit and a gas BBQ. For golf enthusiasts, a private putting green provides the perfect opportunity to work on those three-foot putts between rounds. The second floor offers four generously sized bedrooms, abundant storage, and three full bathrooms. The impressive primary suite features separate his-and-her walk-in closets and a private spa-inspired ensuite. Laundry day becomes effortless with the convenience of a dedicated second-floor laundry room. Located close to top-rated schools, scenic walking trails, parks, and all the amenities Waterloo has to offer. All furnishings are negotiable, creating a rare opportunity for buyers seeking a move-in-ready lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T06:44:18.154147+00:00"
+"Directions": "COLUMBIA ST W TOSUNDEW DR TO MAYAPPLE ST TO WOOD LILY ST TO WILD RYE ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878141"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T04:31:52Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:11:47Z"
+"Stories": "2.0"
+"StreetName": "WILD RYE"
+"StreetNumber": "626"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7480"
+"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/29914132/626-wild-rye-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2655
+"OriginalEntryTimestamp": "2026-06-17T04:31:52.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1204909"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914132')"
+"ID": "1538007"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1536566"
+post_author: 1
+"ListingKey": "29912368"
+"ListingId": "40840265"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:30:06Z"
+"RFModificationTimestamp": "2026-06-17T18:41:30Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:16:39.528562+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:11:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:20:56Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"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/29912368/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-16T20:51:08.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912368')"
+"ID": "1536566"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:15:05Z"
+"RFModificationTimestamp": "2026-06-16T22:16:00Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:09:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1534853"
+post_author: 1
+"ListingKey": "29909265"
+"ListingId": "40840228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:00:09Z"
+"RFModificationTimestamp": "2026-06-16T17:33:37Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1085.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 406, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.598513
1 => 43.4709788
]
+"Latitude": 43.4709788
+"Longitude": -80.598513
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This Amazing condo in a popular neighbourhood - Laurelwood, facing South with a bright, open layout, 2 bedrooms, 2 full bathrooms and 2 Parking Spaces. Upgraded white cabinetry on black granite kitchen, upgraded beautiful backsplash, under-mount lighting, upgraded stainless steel appliances including bar/wine fridge, upgraded lighting throughout.Insuite laundry. Well-painted, ready to move in. Great common amenities include a pool table, bike room, Locker room, Lounge, party room with a kitchen, a media room for private movie nights, and a gazebo with gas BBQs. The house is close to schools, ideal for families with school-going children, families with grown-up children, or empty nesters. The house is also conveniently located close to grocery shops, bus stops, a YMCA, a library, the boardwalk, Costco, conservation areas, and Lots of walking trails! Both the University of Waterloo and Wilfrid Laurier University are just a 10-minute drive by bus #13 or car. A MUST-SEE House!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "451.89"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:33:33.322457+00:00"
+"Directions": "Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:4 [
0 => "Steel"
1 => "Brick"
2 => "Stone"
3 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T14:52:23Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:52:23Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3796.16"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=9ji1sHAZH4Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29909265/776-laurelwood-drive-unit-406-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1085
+"OriginalEntryTimestamp": "2026-06-16T14:50:59.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909265')"
+"ID": "1534853"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1534194"
+post_author: 1
+"ListingKey": "29908429"
+"ListingId": "40839737"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:12:53Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2651.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W8"
+"UnparsedAddress": "223 BUTTERCUP Court, Waterloo, Ontario N2V2W8"
+"Coordinates": array:2 [
0 => -80.5974582
1 => 43.4739662
]
+"Latitude": 43.4739662
+"Longitude": -80.5974582
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "BACKING ONTO CREEKSIDE PARK! Welcome to 223 Buttercup Court, located on a quiet court in Waterloo's sought-after Columbia Forest-Laurelwood neighbourhood. Offering 1,920 sq. ft., plus a fully finished walkout basement, this beautifully updated 3-bedroom, 4-bathroom home provides the perfect blend of space, flexibility, and location. The bright, functional layout features a second-floor family room, a beautifully renovated primary ensuite, fresh paint, updated flooring, and plenty of room for everyday family living. The fully finished walkout basement includes a second kitchen and full bathroom, offering excellent in-law or multi-generational living potential. Step outside to enjoy the expansive deck overlooking the fenced backyard and parkland beyond. Families will love the proximity to walking trails, parks, shopping, and top-rated schools, including Abraham Erb Public School (JK-6), Laurelwood Public School (7-8), and Laurel Heights Secondary School. Recent updates include Roof Shingles (2021), Furnace and Air Conditioner (2017), remodelled Primary Ensuite (2026), updated Family Bathroom Vanity (2026), fresh paint on the main and upper levels (2026), new Flooring on the second floor and basement (2026), a new Refrigerator in the main floor kitchen (2026), and a new Cooktop in the basement kitchen (2026). A fantastic opportunity to own a move-in ready home in one of Waterloo's most desirable family communities. Homes backing onto greenspace in this location don't come along often. Book your private showing today and discover everything this home has to offer. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:12:47.156696+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073668"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:25Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:24Z"
+"Stories": "2.0"
+"StreetName": "BUTTERCUP"
+"StreetNumber": "223"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5740"
+"VirtualTourURLUnbranded": "https://youriguide.com/223_buttercup_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908429/223-buttercup-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1920
+"BelowGradeFinishedArea": 731
+"OriginalEntryTimestamp": "2026-06-16T11:49:24.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1348841"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908429')"
+"ID": "1534194"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 115
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]