array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29774065 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1437994"
+post_author: 1
+"ListingKey": "29774065"
+"ListingId": "40830743"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T14:30:18Z"
+"RFModificationTimestamp": "2026-06-06T14:44:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1590.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W4"
+"UnparsedAddress": "541 WILD IRIS Avenue, Waterloo, Ontario N2V2W4"
+"Coordinates": array:2 [
0 => -80.5999562
1 => 43.4727599
]
+"Latitude": 43.4727599
+"Longitude": -80.5999562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the perfect blend of comfort and convenience in this stunning 4-bedroom end-unit townhouse. Designed with both first-time buyers and growing families in mind, the home features seamless, high-quality laminate flooring across both the main and upper levels. The bright, open-concept kitchen flows naturally into the living space, making it an ideal hub for entertaining. Step outside to a fully fenced, private backyard complete with a cozy porch—your own quiet retreat. Situated just moments from premier shopping, the YMCA, local universities, and top-rated schools, this home offers an unparalleled lifestyle in one of the city's most sought-after neighbourhoods. (id:62783)"
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Stove"
2 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-20T01:35:47.001589+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-25T01:49:28Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T14:20:53Z"
+"Stories": "2.0"
+"StreetName": "WILD IRIS"
+"StreetNumber": "541"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4357"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1653178298"
"RoomType" => "Bedroom"
"ListingId" => "40830743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.47Z"
]
1 => array:11 [
"RoomKey" => "1653178299"
"RoomType" => "Bedroom"
"ListingId" => "40830743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.47Z"
]
2 => array:11 [
"RoomKey" => "1653178300"
"RoomType" => "Bedroom"
"ListingId" => "40830743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.47Z"
]
3 => array:11 [
"RoomKey" => "1653178301"
"RoomType" => "Laundry room"
"ListingId" => "40830743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.48Z"
]
4 => array:11 [
"RoomKey" => "1653178302"
"RoomType" => "4pc Bathroom"
"ListingId" => "40830743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.48Z"
]
5 => array:11 [
"RoomKey" => "1653178303"
"RoomType" => "Primary Bedroom"
"ListingId" => "40830743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.49Z"
]
6 => array:11 [
"RoomKey" => "1653178304"
"RoomType" => "Living room"
"ListingId" => "40830743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.49Z"
]
7 => array:11 [
"RoomKey" => "1653178305"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40830743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 20'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.5Z"
]
8 => array:11 [
"RoomKey" => "1653178306"
"RoomType" => "2pc Bathroom"
"ListingId" => "40830743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29774065"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T14:20:53.51Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29774065/541-wild-iris-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 1590
+"OriginalEntryTimestamp": "2026-05-20T00:31:49.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29774065_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/7131552534a6c8582a50f85467a23234.webp"
"MediaSize" => 120729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-7131552534a6c8582a50f85467a23234.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhome exterior featuring a combination of brick and siding, an attached garage, a covered front entry with columns, and a front lawn"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:41.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29774065_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/1ae6281667211d9ecff9f14aa814b544.webp"
"MediaSize" => 136307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-1ae6281667211d9ecff9f14aa814b544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious entry hall featuring wood-finish flooring, a traditional wooden staircase with white risers, and a built-in coat closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:39.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29774065_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/30e9253d6df24b4e88805cc0d31b5ded.webp"
"MediaSize" => 77650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-30e9253d6df24b4e88805cc0d31b5ded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with chrome faucet, wall-mounted mirror, and three-light vanity fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:42.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29774065_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/141066ae9b805d00797a0f8a61bf882e.webp"
"MediaSize" => 73814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-141066ae9b805d00797a0f8a61bf882e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring wood-finish flooring, a bi-fold door, and a built-in wall cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:39.9Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29774065_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/123548496d844bd938c15096a749c19f.webp"
"MediaSize" => 82916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-123548496d844bd938c15096a749c19f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring vaulted ceilings and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:40.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29774065_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/da3abb99261a90a49fe665b09d07cd7b.webp"
"MediaSize" => 76316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-da3abb99261a90a49fe665b09d07cd7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, a central island with a patterned countertop, a double basin sink, and black appliances including a refrigerator, range, and microwave"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-22T14:41:40.13Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29774065_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/0b037d41d164e370aac4cfa381126939.webp"
"MediaSize" => 79762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-0b037d41d164e370aac4cfa381126939.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29774065_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/d00e388a03b562975654e50eb3127fd0.webp"
"MediaSize" => 100532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-d00e388a03b562975654e50eb3127fd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:16.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29774065_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/1b0e87b386c9ffa9786ed6092226ff6a.webp"
"MediaSize" => 52287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-1b0e87b386c9ffa9786ed6092226ff6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29774065_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/8959eaa7e4c9eed0a690465140adc428.webp"
"MediaSize" => 55235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-8959eaa7e4c9eed0a690465140adc428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.38Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29774065_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/45a1f9126588012e9309621db9ca308b.webp"
"MediaSize" => 79072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-45a1f9126588012e9309621db9ca308b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29774065_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/736018e5ac3aadbb80a34be2af42330d.webp"
"MediaSize" => 75870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-736018e5ac3aadbb80a34be2af42330d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.48Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29774065_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/f2b5e03fea27bddb7750986204feeac5.webp"
"MediaSize" => 88436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-f2b5e03fea27bddb7750986204feeac5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring wood-finish flooring, olive green walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29774065_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/834a2b44a1bb8294b3ec85e11ccfbf43.webp"
"MediaSize" => 98854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-834a2b44a1bb8294b3ec85e11ccfbf43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a single window with sheer and blackout curtains, and light green walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29774065_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/2dbe6f83b762ad574163af3abeb43eb8.webp"
"MediaSize" => 74362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-2dbe6f83b762ad574163af3abeb43eb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.23Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29774065_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/be00696d0b14f169b859536914a3a842.webp"
"MediaSize" => 81821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-be00696d0b14f169b859536914a3a842.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept space featuring wood-finish flooring, a large window with white sheers, and sliding glass doors to outdoor space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.48Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29774065_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/a60aa91854f7391947e22091976c37ca.webp"
"MediaSize" => 76071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-a60aa91854f7391947e22091976c37ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29774065_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/205af2f9d1d0ec610edaf2ed75a349ef.webp"
"MediaSize" => 84582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-205af2f9d1d0ec610edaf2ed75a349ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.49Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29774065_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/c82164fd824254f270cfeb846ecf86da.webp"
"MediaSize" => 122919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-c82164fd824254f270cfeb846ecf86da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29774065_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/8ac340418ad6220a4b7fcf6411526ab5.webp"
"MediaSize" => 169469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-8ac340418ad6220a4b7fcf6411526ab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29774065_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/0d2c38177d3f7de7e07b1b768dfd58da.webp"
"MediaSize" => 178496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-0d2c38177d3f7de7e07b1b768dfd58da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:14.37Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29774065_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/d55c89099225fd80845438e4a8b07e07.webp"
"MediaSize" => 192620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-d55c89099225fd80845438e4a8b07e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.49Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29774065_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774065/3cba5ac0e6325203ea441f3b3d5c3ec7.webp"
"MediaSize" => 105272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774065/thumbnail-3cba5ac0e6325203ea441f3b3d5c3ec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830743"
"ResourceRecordKey" => "29774065"
"ModificationTimestamp" => "2026-05-25T01:41:15.48Z"
]
]
+"DaysOnMarket": 27
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29774065')"
+"ID": "1437994"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 54a6b03c8e4285ab22cbad5cb19d199c0c97ad5ed5b69cc96c22e832e2b23613" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24457
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Cache Key: f95c309f5d5f135c89aa32bd187c2912c1826803bd34f8f1ca42053610555f8c" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24699
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29774065'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25068
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29774065'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25084
+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 '29774065' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5999562 43.4727599)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25137
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: "1536566"
+post_author: 1
+"ListingKey": "29912368"
+"ListingId": "40840265"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:40:12Z"
+"RFModificationTimestamp": "2026-06-16T22:43:36Z"
+"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:62650)"
+"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-16T22:31:53Z"
+"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 [
"RoomKey" => "1660796359"
"RoomType" => "Other"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.61Z"
]
1 => array:11 [
"RoomKey" => "1660796360"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840265"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.61Z"
]
2 => array:11 [
"RoomKey" => "1660796361"
"RoomType" => "Recreation room"
"ListingId" => "40840265"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "26'7'' x 25'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.61Z"
]
3 => array:11 [
"RoomKey" => "1660796362"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.61Z"
]
4 => array:11 [
"RoomKey" => "1660796363"
"RoomType" => "Full bathroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.61Z"
]
5 => array:11 [
"RoomKey" => "1660796364"
"RoomType" => "Bedroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
6 => array:11 [
"RoomKey" => "1660796365"
"RoomType" => "Bedroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
7 => array:11 [
"RoomKey" => "1660796366"
"RoomType" => "Bedroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
8 => array:11 [
"RoomKey" => "1660796367"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840265"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "20'4'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
9 => array:11 [
"RoomKey" => "1660796368"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
10 => array:11 [
"RoomKey" => "1660796369"
"RoomType" => "Laundry room"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
11 => array:11 [
"RoomKey" => "1660796370"
"RoomType" => "Kitchen"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
12 => array:11 [
"RoomKey" => "1660796371"
"RoomType" => "Kitchen"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "21'1'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
13 => array:11 [
"RoomKey" => "1660796372"
"RoomType" => "Dining room"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
14 => array:11 [
"RoomKey" => "1660796373"
"RoomType" => "Living room"
"ListingId" => "40840265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912368"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:31:53.62Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29912368_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/9db958a4c276795915374940824244a9.webp"
"MediaSize" => 123772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-9db958a4c276795915374940824244a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored brick and siding exterior"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912368_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/52183f6ac2e1a303409a5e628e25750d.webp"
"MediaSize" => 143442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-52183f6ac2e1a303409a5e628e25750d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:05.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912368_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/4c5ad6118329fe2b9c3f75447859bb00.webp"
"MediaSize" => 116115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-4c5ad6118329fe2b9c3f75447859bb00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a two-car garage, a turret architectural element, and a covered front entry with double doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:05.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912368_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/87c6a8b9ad214964d0a755e0a1b6821b.webp"
"MediaSize" => 98553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-87c6a8b9ad214964d0a755e0a1b6821b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered porch, dual entry doors with decorative glass inserts, and an attached garage with panel detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912368_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/3b4aa0234ee68b44825c6a5220fbc8de.webp"
"MediaSize" => 59869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-3b4aa0234ee68b44825c6a5220fbc8de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Double entry doors featuring decorative glass inserts and polished tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:05.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912368_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/8fbee2618cf353954e73688148a8c477.webp"
"MediaSize" => 82100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-8fbee2618cf353954e73688148a8c477.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring dark wood-finish flooring and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:05.42Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912368_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/4361b390cb762d727ced408efde60e07.webp"
"MediaSize" => 79020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-4361b390cb762d727ced408efde60e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:05.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912368_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/b827452c4892c797f34b8c7d7381894d.webp"
"MediaSize" => 84760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-b827452c4892c797f34b8c7d7381894d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring dark wood-finish flooring, a white spindle staircase with dark wood-finish treads and handrail, a white fireplace with a mantel, and bright white wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.3Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912368_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/40578c939c6ee426aa491e116904f21a.webp"
"MediaSize" => 72548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-40578c939c6ee426aa491e116904f21a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring a large central island with seating, pendant lighting, stainless steel appliances, and a built-in wine refrigerator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912368_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/10eff2c35f85dba8160b3bc79d4a69b0.webp"
"MediaSize" => 66545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-10eff2c35f85dba8160b3bc79d4a69b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring an oversized island with seating for four, stainless steel appliances, white cabinetry, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912368_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/61ba7e4f87d7a3e5e63e885953bdc10f.webp"
"MediaSize" => 75673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-61ba7e4f87d7a3e5e63e885953bdc10f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring white cabinetry, a stainless steel range with a coordinating hood, stone countertops, and large format floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912368_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/1e385c43a808736fe1ec9dfffd68cc3e.webp"
"MediaSize" => 64021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-1e385c43a808736fe1ec9dfffd68cc3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring an expansive island with a stainless steel sink, dual built-in dishwashers, white cabinetry with gold-tone hardware, and three ornate pendant lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.29Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912368_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/2c179ef5c90444a315b8a3b38ebced5c.webp"
"MediaSize" => 66965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-2c179ef5c90444a315b8a3b38ebced5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, light countertops, a stainless steel range with a matching range hood, and a sliding glass door to the patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.3Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912368_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/ae241122e758f0f5966bf3abad65d285.webp"
"MediaSize" => 63223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-ae241122e758f0f5966bf3abad65d285.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a large central island with seating, white shaker cabinetry with brass hardware, polished tile flooring, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.3Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912368_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/a1bd545e86a527619d6850307fae9d50.webp"
"MediaSize" => 59565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-a1bd545e86a527619d6850307fae9d50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a large center island with quartz countertops, custom white cabinetry, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912368_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/869338261dcae2f75abbeb944f2589bd.webp"
"MediaSize" => 72577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-869338261dcae2f75abbeb944f2589bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Integrated beverage cooler within extensive white cabinetry featuring gold-toned hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.25Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912368_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/97d7ba1289b46b5fcb384ce76fe6b5f3.webp"
"MediaSize" => 59525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-97d7ba1289b46b5fcb384ce76fe6b5f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.24Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912368_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/9c2ea16365da3a1fd33e601a4c5cca7f.webp"
"MediaSize" => 64787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-9c2ea16365da3a1fd33e601a4c5cca7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fireplace with a white mantel and dark hardwood flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.3Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912368_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/d68f0aad887ce8455781e2186e53b61a.webp"
"MediaSize" => 78589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-d68f0aad887ce8455781e2186e53b61a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring dark wood-finish flooring, white walls, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912368_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/fe9bb6c19c1eaab83e041f734ca8cd31.webp"
"MediaSize" => 81967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-fe9bb6c19c1eaab83e041f734ca8cd31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring a kitchen with a white countertop island, pendant lighting, and stainless steel range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.29Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912368_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/d4a437ddfe81e63f2d2f0e0d9440322d.webp"
"MediaSize" => 80577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-d4a437ddfe81e63f2d2f0e0d9440322d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring dark wood-finish flooring, recessed lighting, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.25Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912368_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/7fe2b394d9ce86a2a30f0470252b7142.webp"
"MediaSize" => 44074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-7fe2b394d9ce86a2a30f0470252b7142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with brass-finish faucet, framed mirror, and coordinating towel ring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29912368_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/a9e96b0fbe8dea7337d73b9cd9f76ed5.webp"
"MediaSize" => 62832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-a9e96b0fbe8dea7337d73b9cd9f76ed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a white utility sink with a matte black faucet, dark cabinetry, and a window for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.27Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29912368_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912368/48b90a861af225be561b0c91f4893188.webp"
"MediaSize" => 70073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912368/thumbnail-48b90a861af225be561b0c91f4893188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Curved staircase with dark wood-finish treads and white risers, complemented by a white baluster railing and dark wood-finish handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840265"
"ResourceRecordKey" => "29912368"
"ModificationTimestamp" => "2026-06-16T22:11:02.28Z"
]
24 => array:13 [
"Order" => 25
…12
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912368')"
+"ID": "1536566"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25133
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25130
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909265')"
+"ID": "1534853"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25134
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908429')"
+"ID": "1534194"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25132
+post_id: "1534854"
+post_author: 1
+"ListingKey": "29908518"
+"ListingId": "X13449038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:20:06Z"
+"RFModificationTimestamp": "2026-06-16T13:48:24Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W8"
+"UnparsedAddress": "223 BUTTERCUP COURT, Waterloo, Ontario N2V2W8"
+"Coordinates": array:2 [
0 => -80.5974666
1 => 43.4739527
]
+"Latitude": 43.4739527
+"Longitude": -80.5974666
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Cooktop"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T13:45:36.186679+00:00"
+"Directions": "Cross Streets: Creekside Drive. ** Directions: Erbsville Rd - Creekside Drive."
+"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": "2213189"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "30 x 98.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:13:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:13:51Z"
+"Stories": "2.0"
+"StreetName": "Buttercup"
+"StreetNumber": "223"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5740"
+"VirtualTourURLUnbranded": "https://youriguide.com/223_buttercup_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29908518/223-buttercup-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-06-16T12:14:08.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1458998"
+"ListOfficeNationalAssociationId": "1338998"
+"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('29908518')"
+"ID": "1534854"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "1529774"
+post_author: 1
+"ListingKey": "29902232"
+"ListingId": "40839651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T00:00:04Z"
+"RFModificationTimestamp": "2026-06-15T01:36:47Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 302, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5998272
1 => 43.4705199
]
+"Latitude": 43.4705199
+"Longitude": -80.5998272
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-bedroom, two-bathroom corner suite featuring a rare southwest exposure and an abundance of natural light throughout the day. This bright and spacious open-concept layout offers comfortable living and effortless entertaining. The modern kitchen is equipped with ample cabinetry, stainless steel appliances, and a functional center island, with sliding doors leading to a private balcony overlooking the expansive green space of the neighboring school grounds. The sun-filled living room is enhanced by two large windows, while the primary bedroom features a large window and a private ensuite with a walk-in glass shower. The generously sized second bedroom is conveniently located next to a full four-piece bathroom, making it ideal for family members or guests. Additional features include in-suite laundry with a stackable washer and dryer, one above-grade parking space (#111), and an oversized exclusive storage locker (#1707) located in Locker Room 1700 on the main floor. Situated in the highly sought-after Laurelwood community, this exceptional condo backs onto top-rated Waterloo Region schools, including Laurel Heights Secondary School and Abraham Erb Public School. Public transit provides direct access to the University of Waterloo and major shopping destinations, while supermarkets, shops, the YMCA, library, parks, playgrounds, nature trails, and Laurel Creek Conservation Area are all within walking distance. Residents enjoy excellent building amenities including a welcoming lobby, elevator, outdoor BBQ area, games room, theatre room, party room, visitor parking, and bicycle storage. This is a rare opportunity to own a beautiful, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "446.94"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T01:36:47.407038+00:00"
+"Directions": "Erbsville Rd. turn to Laurelwood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139921"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-14T23:50:36Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T23:50:35Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3953.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902232/776-laurelwood-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247895"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-06-14T23:50:35.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1391697"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1486775"
+"CoListOfficeNationalAssociationId": "1407252"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902232')"
+"ID": "1529774"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1526888"
+post_author: 1
+"ListingKey": "29899457"
+"ListingId": "40836979"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:40:11Z"
+"RFModificationTimestamp": "2026-06-15T20:42:32Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "545 LAURELWOOD Drive Unit# 8, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5892362
1 => 43.472406
]
+"Latitude": 43.472406
+"Longitude": -80.5892362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "675"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:10:08.151035+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192927"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:09:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:31:59Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29899457/545-laurelwood-drive-unit-8-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-13T01:09:43.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1441867"
+"ListOfficeNationalAssociationId": "1438749"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899457')"
+"ID": "1526888"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25135
+post_id: "1526793"
+post_author: 1
+"ListingKey": "29899532"
+"ListingId": "X13440680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:25:11Z"
+"RFModificationTimestamp": "2026-06-13T18:26:28Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "8 - 545 LAURELWOOD DRIVE, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5888765
1 => 43.4720287
]
+"Latitude": 43.4720287
+"Longitude": -80.5888765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:04:46.105847+00:00"
+"Directions": "Cross Streets: Birchmount/Cedar Bend. ** Directions: Birchmount/Cedar Bend/Hollyview Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406393"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:41:25Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:19:20Z"
+"Stories": "1.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899532/8-545-laurelwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-13T01:41:25.63Z"
+"ListAgentNationalAssociationId": "1109349"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899532')"
+"ID": "1526793"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25136
+post_id: "1524746"
+post_author: 1
+"ListingKey": "29896131"
+"ListingId": "40839300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:21Z"
+"RFModificationTimestamp": "2026-06-12T19:24:26Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5833029
1 => 43.4751935
]
+"Latitude": 43.4751935
+"Longitude": -80.5833029
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautifully maintained home is ideally located on a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood. Backing onto a conservation area with NO REAR NEIGHBOURS, this smoke-free, pet-free home features nearly 1,800 sq. ft. of finished living space, 3 bedrooms, 2 bathrooms, and a finished basement with rough-in for an additional bathroom. The bright, open-concept main floor showcases hardwood flooring and a stunning great room with soaring cathedral ceilings and tranquil forest views. Upstairs, you'll find a spacious primary bedroom with cheater ensuite access, along with two additional bedrooms ideal for family, guests, or a home office. The finished basement adds valuable living space with a bright recroom, laundry/mechanical area, storage, and future 2-pc bathroom. Step outside to a spacious pie-shaped backyard, complete with a multi-level deck and peaceful natural surroundings. Thoughtful updates include: RO water system (2026), broadloom in basement and upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), washer and dryer (2024).Located just minutes from excellent schools, scenic trails, parks, shopping, The YMCA, library, and both universities, this is a rare opportunity to enjoy the lifestyle Laurelwood is known for. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "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-12T19:24:17.772712+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:15:38Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:15:38Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/vYG2V95C5V8DD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29896131/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-06-12T17:10:09.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896131')"
+"ID": "1524746"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 91
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]