array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29908777 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: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:40:12Z"
+"RFModificationTimestamp": "2026-06-16T17:54:45Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:30:50Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660443396"
"RoomType" => "Laundry room"
"ListingId" => "40839715"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.02Z"
]
1 => array:11 [
"RoomKey" => "1660443397"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.02Z"
]
2 => array:11 [
"RoomKey" => "1660443398"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.02Z"
]
3 => array:11 [
"RoomKey" => "1660443399"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
4 => array:11 [
"RoomKey" => "1660443400"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
5 => array:11 [
"RoomKey" => "1660443401"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
6 => array:11 [
"RoomKey" => "1660443402"
"RoomType" => "Dining room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
7 => array:11 [
"RoomKey" => "1660443403"
"RoomType" => "Kitchen"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
8 => array:11 [
"RoomKey" => "1660443404"
"RoomType" => "Living room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:30:50.03Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908777_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/e8f17a8c4e11da4ac887713b925a8225.webp"
"MediaSize" => 129831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-e8f17a8c4e11da4ac887713b925a8225.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level townhome featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908777_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b540c3e86cf2007ac5010ff7abad587.webp"
"MediaSize" => 58996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b540c3e86cf2007ac5010ff7abad587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908777_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/f3b231388ecd09abedbc2bffdbcb43fb.webp"
"MediaSize" => 63681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-f3b231388ecd09abedbc2bffdbcb43fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908777_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/978400e537a5e36aa043858340efb3f5.webp"
"MediaSize" => 67018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-978400e537a5e36aa043858340efb3f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept living area featuring dark wood-finish flooring, recessed lighting, and a built-in console with shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908777_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d7a602fd7110265e80707893cbaea753.webp"
"MediaSize" => 81911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d7a602fd7110265e80707893cbaea753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, recessed lighting, and a sliding glass door providing access to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908777_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"MediaSize" => 88580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept interior featuring light wood-finish flooring, recessed lighting, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908777_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/47f895b949c4915fd6ffc6ac90919a96.webp"
"MediaSize" => 72664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-47f895b949c4915fd6ffc6ac90919a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish flooring, dark wood cabinetry, light-toned countertops, and stainless steel appliances including a refrigerator and range"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908777_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d00831c24a778da68afa653f89f0bd06.webp"
"MediaSize" => 82084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d00831c24a778da68afa653f89f0bd06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light countertops, a stainless steel gas range, a stainless steel dishwasher, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908777_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b2ca784855785bf4dfc06be5bc7c581.webp"
"MediaSize" => 73829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b2ca784855785bf4dfc06be5bc7c581.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring stainless steel refrigerator, dark wood-finish cabinetry, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908777_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/5c65bd6bc3e4e0e6d33c6c68c9f36aaa.webp"
"MediaSize" => 31927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-5c65bd6bc3e4e0e6d33c6c68c9f36aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a vessel sink, single-handle faucet, dark wood-finish cabinetry, and an illuminated mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908777_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/fd4e6f0af04f8d61da8588c097930dae.webp"
"MediaSize" => 59196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-fd4e6f0af04f8d61da8588c097930dae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-finish flooring complementing white walls and trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908777_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/67c675ee9b376de01850b0be3271039d.webp"
"MediaSize" => 41810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-67c675ee9b376de01850b0be3271039d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring dark wood-finish flooring, white walls, and white bi-fold closet doors with brass-tone knobs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908777_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/78fbea7c401a4dff750c6f6ac630c132.webp"
"MediaSize" => 52291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-78fbea7c401a4dff750c6f6ac630c132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29908777_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/1f56c620ba8a79fa0acf672dd8119284.webp"
"MediaSize" => 50859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-1f56c620ba8a79fa0acf672dd8119284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room with rich wood-finish flooring, white walls, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29908777_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/35ecce72f515c7f9506bc85d97e53b9b.webp"
"MediaSize" => 68359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-35ecce72f515c7f9506bc85d97e53b9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring throughout featuring white walls, a flush-mount ceiling light, and two large multi-pane windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29908777_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3fd97ccbcfc261d3a1208f972354ea20.webp"
"MediaSize" => 53873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3fd97ccbcfc261d3a1208f972354ea20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, white walls, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29908777_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3bc4405fe373dc0f5a8f19cbcbd26603.webp"
"MediaSize" => 60732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3bc4405fe373dc0f5a8f19cbcbd26603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Crisp white interior walls highlighting dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29908777_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/deaef44980c35d35470ff9caec409fc0.webp"
"MediaSize" => 49682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-deaef44980c35d35470ff9caec409fc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a built-in vanity with a marbled countertop, an integrated sink with chrome fixtures, a full-width mirror, a toilet, and a bathtub with a shower head"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29908777_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/ba0838a102aa60d3daf40b08e347161f.webp"
"MediaSize" => 87454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-ba0838a102aa60d3daf40b08e347161f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area featuring a utility sink, exposed concrete wall, exposed ceiling joists, and a window for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29908777_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/0f1c174e9e782dd238d09c7f52ed98f4.webp"
"MediaSize" => 181904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-0f1c174e9e782dd238d09c7f52ed98f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor wood deck featuring a lattice privacy screen and wood railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29908777_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/8d5d6e4f1d6f3a50c56b9b84aef3e37b.webp"
"MediaSize" => 136527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-8d5d6e4f1d6f3a50c56b9b84aef3e37b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior deck featuring wood planking and a sliding glass door with a screen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29908777_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/ddcec068e0a5d5311679512efec740d7.webp"
"MediaSize" => 183261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-ddcec068e0a5d5311679512efec740d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29908777_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/b0019e86df5e8ac601953eae776c3726.webp"
"MediaSize" => 168398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-b0019e86df5e8ac601953eae776c3726.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a wooden deck with railing, sliding glass door access, and a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29908777_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/4d04fe1b9845b8a8bad1b23ca697aaac.webp"
"MediaSize" => 165046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-4d04fe1b9845b8a8bad1b23ca697aaac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a large wooden deck, raised garden beds, and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29908777_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/bf02c630ccaa930492b7eb9673693c6e.webp"
"MediaSize" => 43903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-bf02c630ccaa930492b7eb9673693c6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29908777_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/17dcb6af0c4fb3a0dd192fb381834a39.webp"
"MediaSize" => 51263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-17dcb6af0c4fb3a0dd192fb381834a39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29908777_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/8caf517925f02ea0164e2f3fb98bf5e9.webp"
"MediaSize" => 41509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-8caf517925f02ea0164e2f3fb98bf5e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
]
+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 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24778
+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 2055634" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24751
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29908777'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25079
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29908777'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25095
+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 '29908777' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5870471 43.4667674)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25148
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+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 [
"RoomKey" => "1660482369"
"RoomType" => "Laundry room"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
1 => array:11 [
"RoomKey" => "1660482370"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
2 => array:11 [
"RoomKey" => "1660482371"
"RoomType" => "Bedroom"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
3 => array:11 [
"RoomKey" => "1660482372"
"RoomType" => "Full bathroom"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
4 => array:11 [
"RoomKey" => "1660482373"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
5 => array:11 [
"RoomKey" => "1660482374"
"RoomType" => "Living room/Dining room"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
6 => array:11 [
"RoomKey" => "1660482375"
"RoomType" => "Kitchen"
"ListingId" => "40840228"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909265"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:50:59.92Z"
]
]
+"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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+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 [
"RoomKey" => "1660423007"
"RoomType" => "Cold room"
"ListingId" => "40839737"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.45Z"
]
1 => array:11 [
"RoomKey" => "1660423008"
"RoomType" => "Utility room"
"ListingId" => "40839737"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.47Z"
]
2 => array:11 [
"RoomKey" => "1660423009"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839737"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.49Z"
]
3 => array:11 [
"RoomKey" => "1660423010"
"RoomType" => "Kitchen"
"ListingId" => "40839737"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.52Z"
]
4 => array:11 [
"RoomKey" => "1660423011"
"RoomType" => "Recreation room"
"ListingId" => "40839737"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "26'7'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.54Z"
]
5 => array:11 [
"RoomKey" => "1660423012"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.56Z"
]
6 => array:11 [
"RoomKey" => "1660423013"
"RoomType" => "Bedroom"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.58Z"
]
7 => array:11 [
"RoomKey" => "1660423014"
"RoomType" => "Bedroom"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.6Z"
]
8 => array:11 [
"RoomKey" => "1660423015"
"RoomType" => "Full bathroom"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "6'1'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.62Z"
]
9 => array:11 [
"RoomKey" => "1660423016"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.64Z"
]
10 => array:11 [
"RoomKey" => "1660423017"
"RoomType" => "Family room"
"ListingId" => "40839737"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.66Z"
]
11 => array:11 [
"RoomKey" => "1660423018"
"RoomType" => "Laundry room"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.67Z"
]
12 => array:11 [
"RoomKey" => "1660423019"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "3'10'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.69Z"
]
13 => array:11 [
"RoomKey" => "1660423020"
"RoomType" => "Dinette"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.71Z"
]
14 => array:11 [
"RoomKey" => "1660423021"
"RoomType" => "Kitchen"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.73Z"
]
15 => array:11 [
"RoomKey" => "1660423022"
"RoomType" => "Dining room"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.75Z"
]
16 => array:11 [
"RoomKey" => "1660423023"
"RoomType" => "Living room"
"ListingId" => "40839737"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908429"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:24.77Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29908429_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/5cea3720bf3b3c5f36245e64a165e2a7.webp"
"MediaSize" => 89563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-5cea3720bf3b3c5f36245e64a165e2a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908429_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/6145e16881d80efed9a61fd2c6abfcd5.webp"
"MediaSize" => 129861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-6145e16881d80efed9a61fd2c6abfcd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908429_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/e44de859764f5eeb6f44cd9ead28ff7c.webp"
"MediaSize" => 154730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-e44de859764f5eeb6f44cd9ead28ff7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908429_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/6b41e55cc8ad3d5b8a134107b9e4c784.webp"
"MediaSize" => 130516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-6b41e55cc8ad3d5b8a134107b9e4c784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.08Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908429_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/8a8f02fa700c55e46ed97cd027d4c39b.webp"
"MediaSize" => 93209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-8a8f02fa700c55e46ed97cd027d4c39b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908429_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/b287efa49094b008633c5fa2385cb6b0.webp"
"MediaSize" => 84685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-b287efa49094b008633c5fa2385cb6b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908429_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/0cb8933c147760dd368e5141cf21b6a3.webp"
"MediaSize" => 81405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-0cb8933c147760dd368e5141cf21b6a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:46.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908429_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/dbc49b0bccb7eb9467eb3764eec295a6.webp"
"MediaSize" => 89563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-dbc49b0bccb7eb9467eb3764eec295a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:46.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908429_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/6d234deb63149f0e6c156976c08f9354.webp"
"MediaSize" => 88986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-6d234deb63149f0e6c156976c08f9354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908429_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/48b02f881f5bee9347d5d4bc81a397ce.webp"
"MediaSize" => 99179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908429/thumbnail-48b02f881f5bee9347d5d4bc81a397ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839737"
"ResourceRecordKey" => "29908429"
"ModificationTimestamp" => "2026-06-16T12:40:44.12Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908429_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908429/61f16415fe2e46ad2adc08cae07d9640.webp"
"MediaSize" => 98331
"MediaType" => "webp"
…8
]
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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25145
+post_id: "1529774"
+post_author: 1
+"ListingKey": "29902232"
+"ListingId": "40839651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T00:00:04Z"
+"RFModificationTimestamp": "2026-06-15T01:36:47Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 302, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5998272
1 => 43.4705199
]
+"Latitude": 43.4705199
+"Longitude": -80.5998272
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-bedroom, two-bathroom corner suite featuring a rare southwest exposure and an abundance of natural light throughout the day. This bright and spacious open-concept layout offers comfortable living and effortless entertaining. The modern kitchen is equipped with ample cabinetry, stainless steel appliances, and a functional center island, with sliding doors leading to a private balcony overlooking the expansive green space of the neighboring school grounds. The sun-filled living room is enhanced by two large windows, while the primary bedroom features a large window and a private ensuite with a walk-in glass shower. The generously sized second bedroom is conveniently located next to a full four-piece bathroom, making it ideal for family members or guests. Additional features include in-suite laundry with a stackable washer and dryer, one above-grade parking space (#111), and an oversized exclusive storage locker (#1707) located in Locker Room 1700 on the main floor. Situated in the highly sought-after Laurelwood community, this exceptional condo backs onto top-rated Waterloo Region schools, including Laurel Heights Secondary School and Abraham Erb Public School. Public transit provides direct access to the University of Waterloo and major shopping destinations, while supermarkets, shops, the YMCA, library, parks, playgrounds, nature trails, and Laurel Creek Conservation Area are all within walking distance. Residents enjoy excellent building amenities including a welcoming lobby, elevator, outdoor BBQ area, games room, theatre room, party room, visitor parking, and bicycle storage. This is a rare opportunity to own a beautiful, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "446.94"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T01:36:47.407038+00:00"
+"Directions": "Erbsville Rd. turn to Laurelwood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139921"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-14T23:50:36Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T23:50:35Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3953.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902232/776-laurelwood-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247895"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-06-14T23:50:35.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1391697"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1486775"
+"CoListOfficeNationalAssociationId": "1407252"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902232')"
+"ID": "1529774"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: "1526888"
+post_author: 1
+"ListingKey": "29899457"
+"ListingId": "40836979"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:40:11Z"
+"RFModificationTimestamp": "2026-06-15T20:42:32Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "545 LAURELWOOD Drive Unit# 8, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5892362
1 => 43.472406
]
+"Latitude": 43.472406
+"Longitude": -80.5892362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "675"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:10:08.151035+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192927"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:09:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:31:59Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29899457/545-laurelwood-drive-unit-8-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-13T01:09:43.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1441867"
+"ListOfficeNationalAssociationId": "1438749"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899457')"
+"ID": "1526888"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
+post_id: "1526793"
+post_author: 1
+"ListingKey": "29899532"
+"ListingId": "X13440680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:25:11Z"
+"RFModificationTimestamp": "2026-06-13T18:26:28Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "8 - 545 LAURELWOOD DRIVE, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5888765
1 => 43.4720287
]
+"Latitude": 43.4720287
+"Longitude": -80.5888765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:04:46.105847+00:00"
+"Directions": "Cross Streets: Birchmount/Cedar Bend. ** Directions: Birchmount/Cedar Bend/Hollyview Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406393"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:41:25Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:19:20Z"
+"Stories": "1.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899532/8-545-laurelwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-13T01:41:25.63Z"
+"ListAgentNationalAssociationId": "1109349"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899532')"
+"ID": "1526793"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T00:40:13Z"
+"RFModificationTimestamp": "2026-06-13T00:41:23Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3112.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "725 ZURICH Drive, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.58337
1 => 43.4566032
]
+"Latitude": 43.4566032
+"Longitude": -80.58337
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable neighbourhood of Clair Hills in West Waterloo, 725 Zurich Drive is a rare opportunity for growing families seeking space, functionality, and an unbeatable location! Boasting over 3000 sq/ft of finished living space, this impressive 5 Bed/3 Bath home offers a thoughtfully designed open concept layout with incredible versatility throughout. The bright and welcoming main floor serves as the heart of the home, featuring spacious principal rooms ideal for everyday living and entertaining. Large windows provide an abundance of natural light while creating a warm and inviting atmosphere. Recent major updates including a new roof with solar panels (~5k/Yr ROI), new windows, new furnace, and new on-demand water heater provide exceptional value and peace of mind for years to come. Upstairs, the spacious primary bedroom offers a comfortable retreat with a large en-suite, while an additional bedroom and full bathroom complete the upper level with functionality and convenience. A true standout feature of this home is the fully finished basement, offering exceptional additional living space with *3 generously sized bedrooms, making it ideal for larger families, multi-generational living, overnight guests, or flexible work-from-home options. Complete with a full bathroom and ample space for recreation or additional family living, the lower level adds tremendous versatility and value rarely found in homes within this neighbourhood. Step outside to enjoy the fully fenced backyard featuring a private patio area and storage shed, the perfect setting for relaxing evenings, entertaining guests, or safe outdoor play for children and pets alike. Ideally located near top-rated schools including Vista Hills and Laurel Heights Secondary School, as well as the scenic GeoTime trails and surrounding forest, this family-friendly location offers the perfect balance of convenience and nature. Pride of ownership is evident throughout this beautifully maintained home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:03.419047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052274"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:31:49Z"
+"Stories": "1.0"
+"StreetName": "ZURICH"
+"StreetNumber": "725"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://youriguide.com/725_zurich_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895200/725-zurich-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1587
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-12T15:31:43.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1327496"
+"ListOfficeNationalAssociationId": "1004387"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895200')"
+"ID": "1524682"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1524092"
+post_author: 1
+"ListingKey": "29896571"
+"ListingId": "X13438200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:55:09Z"
+"RFModificationTimestamp": "2026-06-12T22:58:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN STREET, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.589798
1 => 43.464848
]
+"Latitude": 43.464848
+"Longitude": -80.589798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARE FIND! Prime location with amazing privacy and forest views! This fully finished detached 3 bedroom, 3 bathroom home offers an exceptional layout and an excellent finished basement. As you pull up to the home, you'll immediately notice its charming curb appeal. Step inside and you'll find a bright, welcoming space that feels just right. The care and updates throughout the home are evident at every turn. The main floor features an open-concept kitchen, dining, and living area with a vaulted ceiling and beautiful patio doors leading to your backyard paradise. The yard includes a new deck (2024) and a fenced yard, creating a beautiful, peaceful retreat that is still low maintenance. Upstairs, the spacious primary bedroom overlooks the backyard and offers plenty of room to relax. The stunning, spa-like primary ensuite, updated in 2023, is truly impressive. Two additional bedrooms complete the upper level. The basement features another full bathroom, plenty of storage space, a home office, and a large recreation room. The location is fantastic, close to top rated schools, beautiful walking trails, shopping, and more! Don't miss this rare opportunity to own a private, move-in-ready home in an outstanding location. ** SEE VIDEO FOR FULL TOUR!! ** WOW! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:21:27.298705+00:00"
+"Directions": "Cross Streets: Erbville Rd and Columbia Forst Blvd. ** Directions: Erbsville Rd, West on Columbia Forest Blvd, right on Royal Fern St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246631"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "27.8 x 106.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-12T22:49:11Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:49:11Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896571/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2026-06-12T17:56:38.8Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485484"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 117
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]