array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29769162 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: "1434290"
+post_author: 1
+"ListingKey": "29769162"
+"ListingId": "40831180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:21Z"
+"RFModificationTimestamp": "2026-06-02T16:33:08Z"
+"ListPrice": 108000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 888.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 243, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5898148
1 => 43.485394
]
+"Latitude": 43.485394
+"Longitude": -80.5898148
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "We are excited to present this incredible opportunity! This sought-after 2-bedroom trailer offers 888 sq. ft. of comfortable indoor living space, complete with a spacious addition and several recent updates, including a new furnace and water heater (2024).Large windows fill the space with natural light, while the open-concept living, kitchen, and dining areas create the perfect setting for everyday living and easy entertaining. The oversized kitchen island/table provides ample prep and gathering space, adding to the home’s functional and welcoming layout.Step outside and enjoy peaceful outdoor living with room to garden or relax on the back patio beneath the 10' x 12' steel-top gazebo. A 7' x 7' shed offers convenient additional storage. The park itself is exceptionally well maintained and ideally located beside the beautiful Laurel Creek Conservation Area, offering easy access to hiking, biking, and nature trails. Enjoy peaceful sunsets over surrounding farmland while remaining just minutes from shopping, the St. Jacobs Farmers’ Market (5.1 km), and HWY 85 (5.5 km). Residents enjoy an impressive list of amenities, including a heated pool, two hot tubs, playground, mini golf, recreation hall, games room, fishing pond, seasonal tractor rides, and activities for all ages. Book your showing today! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Mobile Home"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-05-19T17:13:23.763759+00:00"
+"Directions": "At 580 Beaver Creek Rd, enter park & once through gated entrance, turn South, turn Left on first street on the Left (after parking area), pass Pond on Left & first roadway after pond, Turn Left. Unit is around the first bend on the Right Hand Side"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094304"
+"ListOfficeKey": "297560"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-05-19T15:14:31Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:21:50Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1649811115"
"RoomType" => "2pc Bathroom"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
1 => array:11 [
"RoomKey" => "1649811116"
"RoomType" => "Laundry room"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
2 => array:11 [
"RoomKey" => "1649811117"
"RoomType" => "3pc Bathroom"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "4'5'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
3 => array:11 [
"RoomKey" => "1649811118"
"RoomType" => "Bedroom"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
4 => array:11 [
"RoomKey" => "1649811119"
"RoomType" => "Primary Bedroom"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
5 => array:11 [
"RoomKey" => "1649811120"
"RoomType" => "Dining room"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
6 => array:11 [
"RoomKey" => "1649811121"
"RoomType" => "Kitchen"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
7 => array:11 [
"RoomKey" => "1649811122"
"RoomType" => "Living room"
"ListingId" => "40831180"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29769162"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 21'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:21:50.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29769162/580-beaver-creek-road-unit-243-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CoListAgentKey": "2245088"
+"CommonInterest": "Leasehold"
+"CoListOfficeKey": "292918"
+"GeocodeManualYN": true
+"ZoningDescription": "FD1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 888
+"OriginalEntryTimestamp": "2026-05-19T15:11:13.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1366723"
+"ListOfficeNationalAssociationId": "1467595"
+"CoListAgentNationalAssociationId": "1483759"
+"CoListOfficeNationalAssociationId": "1419429"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29769162_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/5b4d46835aabfe945598db653a76ec15.webp"
"MediaSize" => 230227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-5b4d46835aabfe945598db653a76ec15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29769162_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/b8d0ccf80dce35b9a198f6d51905a4d7.webp"
"MediaSize" => 204113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-b8d0ccf80dce35b9a198f6d51905a4d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.84Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29769162_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/a6196738e377f27b35ce69846daed0cd.webp"
"MediaSize" => 126495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-a6196738e377f27b35ce69846daed0cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29769162_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/293423d71b0e06f960c8dd0299279ca5.webp"
"MediaSize" => 121593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-293423d71b0e06f960c8dd0299279ca5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29769162_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/784b6efdd2d3a4146c60660b5d26d21c.webp"
"MediaSize" => 124827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-784b6efdd2d3a4146c60660b5d26d21c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29769162_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/837bef7215563dec7670c1c0af3aeb6f.webp"
"MediaSize" => 119563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-837bef7215563dec7670c1c0af3aeb6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29769162_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/73e5effae118d541bb1cdbe3c98409cb.webp"
"MediaSize" => 120400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-73e5effae118d541bb1cdbe3c98409cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29769162_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/36d84cf1e5e46b42a3affbaa1351e3ba.webp"
"MediaSize" => 123773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-36d84cf1e5e46b42a3affbaa1351e3ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29769162_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/6b80459fca4b23e65074437c1910a17f.webp"
"MediaSize" => 139039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-6b80459fca4b23e65074437c1910a17f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29769162_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/1dc32e4fb10d1903a9eafe83628894bd.webp"
"MediaSize" => 128531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-1dc32e4fb10d1903a9eafe83628894bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.22Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29769162_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/f55a9920b0bfce73c9806a80a06b28f0.webp"
"MediaSize" => 125161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-f55a9920b0bfce73c9806a80a06b28f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29769162_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/bb157c33b9ea12245a61d1b09374480c.webp"
"MediaSize" => 117861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-bb157c33b9ea12245a61d1b09374480c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29769162_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/67b4f3aee70051b85b0e1445b08f62c7.webp"
"MediaSize" => 125786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-67b4f3aee70051b85b0e1445b08f62c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29769162_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/04f3e37fd55108aa76b2484f719a29ec.webp"
"MediaSize" => 113759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-04f3e37fd55108aa76b2484f719a29ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29769162_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/4aea2330aa4e8476388e176eb9fc9ca6.webp"
"MediaSize" => 145465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-4aea2330aa4e8476388e176eb9fc9ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.22Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29769162_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/2b706f2f6f245a00ae43dd011e9f55e8.webp"
"MediaSize" => 122514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-2b706f2f6f245a00ae43dd011e9f55e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29769162_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/0c6f83ab950a11b11795dbe0aefe785b.webp"
"MediaSize" => 89770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-0c6f83ab950a11b11795dbe0aefe785b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.22Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29769162_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/8117c433d0714be8cdc29aa006bd5344.webp"
"MediaSize" => 92758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-8117c433d0714be8cdc29aa006bd5344.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29769162_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/96479f7e489c9ad1bee713bc185e485b.webp"
"MediaSize" => 104368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-96479f7e489c9ad1bee713bc185e485b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29769162_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/f5f0aa20df0a1d76ba4f03afefd3ddc3.webp"
"MediaSize" => 139380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-f5f0aa20df0a1d76ba4f03afefd3ddc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.88Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29769162_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/2cae3b2b0b0b553dedd845ac315300e1.webp"
"MediaSize" => 84274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-2cae3b2b0b0b553dedd845ac315300e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29769162_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/99312bda547fe0fd396ec9ab55155b02.webp"
"MediaSize" => 124518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-99312bda547fe0fd396ec9ab55155b02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29769162_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/c277af090c7b3b604e23f7e39106ff66.webp"
"MediaSize" => 112401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-c277af090c7b3b604e23f7e39106ff66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29769162_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/f5685faa9b558eb330348506e5ad5506.webp"
"MediaSize" => 109294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-f5685faa9b558eb330348506e5ad5506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29769162_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/367b612a1d70fb418490034102ba0df3.webp"
"MediaSize" => 105436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-367b612a1d70fb418490034102ba0df3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29769162_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/1153cf1ce5349f140fa257ffa412d646.webp"
"MediaSize" => 210467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-1153cf1ce5349f140fa257ffa412d646.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29769162_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/9c98503a89906b6124d8b2054b4c2de6.webp"
"MediaSize" => 206260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-9c98503a89906b6124d8b2054b4c2de6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:31.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29769162_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/9e8439b6e5ce4f2309a4d4994fb130a6.webp"
"MediaSize" => 179713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-9e8439b6e5ce4f2309a4d4994fb130a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.45Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29769162_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/14f071f92ca0d2516298f9b3d5871130.webp"
"MediaSize" => 186388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-14f071f92ca0d2516298f9b3d5871130.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.87Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29769162_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/b0683900c82951ab53c7c48935c58eea.webp"
"MediaSize" => 236270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-b0683900c82951ab53c7c48935c58eea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29769162_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/410d0d52a681935736c03ff2e2e1739c.webp"
"MediaSize" => 233158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-410d0d52a681935736c03ff2e2e1739c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.85Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29769162_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/38305b586e297538b575ab49096705e7.webp"
"MediaSize" => 241700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-38305b586e297538b575ab49096705e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.85Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29769162_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/4f59572c312aee9c39bf056eee31a310.webp"
"MediaSize" => 180525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-4f59572c312aee9c39bf056eee31a310.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29769162_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/f074dffcd8fe453d383814f940b8275e.webp"
"MediaSize" => 244583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-f074dffcd8fe453d383814f940b8275e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.85Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29769162_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/0a65ae0e06c0c4a7863175f0294a57ca.webp"
"MediaSize" => 226479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-0a65ae0e06c0c4a7863175f0294a57ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.83Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29769162_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29769162/70217c5cf4ed65545ef352f137358c3e.webp"
"MediaSize" => 232181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29769162/thumbnail-70217c5cf4ed65545ef352f137358c3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831180"
"ResourceRecordKey" => "29769162"
"ModificationTimestamp" => "2026-05-19T15:14:29.86Z"
]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29769162')"
+"ID": "1434290"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 297560" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24688
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2094304" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24685
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29769162'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25139
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29769162'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25155
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29769162' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5898148 43.485394)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25218
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24770
+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"
…10
]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912368')"
+"ID": "1536566"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24762
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:13Z"
+"RFModificationTimestamp": "2026-06-17T02:46:19Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:32:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:32:01Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24778
+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 {#25215
+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 {#24798
+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 {#24783
+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": 2
+"@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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899457')"
+"ID": "1526888"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899532')"
+"ID": "1526793"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+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: 7
+count: 61
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]