array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29883477 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23344
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23346
+post_id: "1515451"
+post_author: 1
+"ListingKey": "29883477"
+"ListingId": "40837309"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T02:10:12Z"
+"RFModificationTimestamp": "2026-06-11T02:15:26Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S6"
+"UnparsedAddress": "819 CREEKSIDE Drive, Waterloo, Ontario N2V2S6"
+"Coordinates": array:2 [
0 => -80.5920205
1 => 43.4730669
]
+"Latitude": 43.4730669
+"Longitude": -80.5920205
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare executive bungaloft townhome in one of Waterloo's most sought after neighbourhoods! Beautifully maintained, this bright and functional home is ideal for downsizers, professionals or anyone seeking the convenience of main floor living. Featuring a main floor primary bedroom, a private loft with a second bedroom and ensuite bath and a finished basement offering additional space for entertaining, hobbies, or relaxation. The gorgeous private backyard is perfect for morning coffee, summer evenings and peaceful outdoor enjoyment. Ideally located near walking trails, parks, shopping, and Laurel Creek Conservation Area, this home offers the perfect blend of comfort and convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"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-10T18:57:44.529764+00:00"
+"Directions": "LAURELWOOD DRIVE TO CREEKSIDE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564345"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T17:51:15Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T02:01:52Z"
+"Stories": "1.5"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "819"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5530.38"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/819-Creekside-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1656743851"
"RoomType" => "Utility room"
"ListingId" => "40837309"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
1 => array:11 [
"RoomKey" => "1656743852"
"RoomType" => "Recreation room"
"ListingId" => "40837309"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "32'3'' x 29'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
2 => array:11 [
"RoomKey" => "1656743853"
"RoomType" => "Cold room"
"ListingId" => "40837309"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
3 => array:11 [
"RoomKey" => "1656743854"
"RoomType" => "Other"
"ListingId" => "40837309"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "3'10'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
4 => array:11 [
"RoomKey" => "1656743855"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837309"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
5 => array:11 [
"RoomKey" => "1656743856"
"RoomType" => "Bedroom"
"ListingId" => "40837309"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
6 => array:11 [
"RoomKey" => "1656743857"
"RoomType" => "Full bathroom"
"ListingId" => "40837309"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
7 => array:11 [
"RoomKey" => "1656743858"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
8 => array:11 [
"RoomKey" => "1656743859"
"RoomType" => "Living room"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
9 => array:11 [
"RoomKey" => "1656743860"
"RoomType" => "Kitchen"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.01Z"
]
10 => array:11 [
"RoomKey" => "1656743861"
"RoomType" => "Foyer"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.02Z"
]
11 => array:11 [
"RoomKey" => "1656743862"
"RoomType" => "Dining room"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.02Z"
]
12 => array:11 [
"RoomKey" => "1656743863"
"RoomType" => "Breakfast"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.02Z"
]
13 => array:11 [
"RoomKey" => "1656743864"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837309"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29883477"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:52.02Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29883477/819-creekside-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1584
+"BelowGradeFinishedArea": 774
+"OriginalEntryTimestamp": "2026-06-10T17:51:14.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1135414"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29883477_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/9ba4412bf8e098e80a92696fdda960a5.webp"
"MediaSize" => 118299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-9ba4412bf8e098e80a92696fdda960a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29883477_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/e2c36fab608d27892ef9bd1f8445e383.webp"
"MediaSize" => 114409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-e2c36fab608d27892ef9bd1f8445e383.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29883477_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/597c70586b0595bd973ba7ee32903417.webp"
"MediaSize" => 125452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-597c70586b0595bd973ba7ee32903417.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29883477_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/74ee3af74c724b4868b90341ebcc0c5d.webp"
"MediaSize" => 133474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-74ee3af74c724b4868b90341ebcc0c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29883477_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/4b65a773d0a209d572c5bd1df6310cba.webp"
"MediaSize" => 117581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-4b65a773d0a209d572c5bd1df6310cba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29883477_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/9dcd6aa416fb51d57e04c84e818820cc.webp"
"MediaSize" => 70373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-9dcd6aa416fb51d57e04c84e818820cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29883477_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/1f13ec5844b8d6ab01de53c6746f85db.webp"
"MediaSize" => 84517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-1f13ec5844b8d6ab01de53c6746f85db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29883477_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/b2754453b3157168b2c34939518e9435.webp"
"MediaSize" => 80699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-b2754453b3157168b2c34939518e9435.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29883477_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/12a2d8d05fcb25e9e1ba5fa5391eb9e1.webp"
"MediaSize" => 88694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-12a2d8d05fcb25e9e1ba5fa5391eb9e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29883477_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/ee41bbf1222452e7d2eae09143de1720.webp"
"MediaSize" => 86942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-ee41bbf1222452e7d2eae09143de1720.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29883477_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/6e98dd13d8cbb35bd2032aa8443e3777.webp"
"MediaSize" => 99918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-6e98dd13d8cbb35bd2032aa8443e3777.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29883477_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/18c815b982ba80d142e3c37b76d14d76.webp"
"MediaSize" => 74660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-18c815b982ba80d142e3c37b76d14d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29883477_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/fad12b9f2fb8a9874d67b82c51196675.webp"
"MediaSize" => 81560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-fad12b9f2fb8a9874d67b82c51196675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29883477_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/d41c7b65dd1e685f9c3398ba9d9c1cbc.webp"
"MediaSize" => 86576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-d41c7b65dd1e685f9c3398ba9d9c1cbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29883477_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/769c365eeaf5b9b9d2da9b87b07eb0dd.webp"
"MediaSize" => 69271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-769c365eeaf5b9b9d2da9b87b07eb0dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29883477_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/bec2ff438911804f1e95e85afae99efe.webp"
"MediaSize" => 78781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-bec2ff438911804f1e95e85afae99efe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29883477_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/88671d5379d8b0eb96544482ed0c1a2c.webp"
"MediaSize" => 68996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-88671d5379d8b0eb96544482ed0c1a2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29883477_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/568a1e3e0d579a4fbc2ef5c4847d7a1d.webp"
"MediaSize" => 65860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-568a1e3e0d579a4fbc2ef5c4847d7a1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29883477_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/5fee9aaea83e45b606f1bb8c4013f060.webp"
"MediaSize" => 68234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-5fee9aaea83e45b606f1bb8c4013f060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29883477_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/e608ea936c5eb74d4fa0582cbcff38c7.webp"
"MediaSize" => 63047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-e608ea936c5eb74d4fa0582cbcff38c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29883477_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/eb769093c7dd3f8041a1c1ae71cbab94.webp"
"MediaSize" => 67105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-eb769093c7dd3f8041a1c1ae71cbab94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29883477_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/8c48a241664388ec7e437c4674311675.webp"
"MediaSize" => 95908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-8c48a241664388ec7e437c4674311675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29883477_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/e4781cb446ea34f2c040650164f89278.webp"
"MediaSize" => 88499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-e4781cb446ea34f2c040650164f89278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29883477_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/3509c683f505aacf684fa0eb27e4fa83.webp"
"MediaSize" => 50093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-3509c683f505aacf684fa0eb27e4fa83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29883477_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/85585828009fe7ac5aa79f8298b8b777.webp"
"MediaSize" => 67651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-85585828009fe7ac5aa79f8298b8b777.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29883477_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/0bf51c263f1e7cb74991aa2616c54caf.webp"
"MediaSize" => 80800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-0bf51c263f1e7cb74991aa2616c54caf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29883477_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/db64f9ffc5453a6e64d23b928ebf3bec.webp"
"MediaSize" => 84687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-db64f9ffc5453a6e64d23b928ebf3bec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29883477_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/f558ccc97486547a09840b16e9bf038c.webp"
"MediaSize" => 74696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-f558ccc97486547a09840b16e9bf038c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29883477_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/c74ef071f9b5a0d466de10eed02399c3.webp"
"MediaSize" => 80473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-c74ef071f9b5a0d466de10eed02399c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29883477_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/caac59f1d51edea2b57ffd5bb1e56c17.webp"
"MediaSize" => 68990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-caac59f1d51edea2b57ffd5bb1e56c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29883477_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/9c6cbd736e1db5275a9bd5c0f9575193.webp"
"MediaSize" => 68909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-9c6cbd736e1db5275a9bd5c0f9575193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29883477_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/ddb2aedc5ef19d288226fded0e62cd9f.webp"
"MediaSize" => 68287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-ddb2aedc5ef19d288226fded0e62cd9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29883477_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/9ad8215d5bf86f32a3dd950c58d33356.webp"
"MediaSize" => 142427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-9ad8215d5bf86f32a3dd950c58d33356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29883477_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/5048e30e159f62fc60d5f7cc13a9f212.webp"
"MediaSize" => 128666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-5048e30e159f62fc60d5f7cc13a9f212.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29883477_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/1a7dea157fe91337f6ccde5df9e2adcf.webp"
"MediaSize" => 143970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-1a7dea157fe91337f6ccde5df9e2adcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29883477_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/f54c7f152c59ec40d7042334f9042343.webp"
"MediaSize" => 158545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-f54c7f152c59ec40d7042334f9042343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29883477_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/56c51896232d75b791176b0809969ad6.webp"
"MediaSize" => 148104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-56c51896232d75b791176b0809969ad6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29883477_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/9bc00d9ddede0e4ac2615b972cdb9f76.webp"
"MediaSize" => 156771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-9bc00d9ddede0e4ac2615b972cdb9f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29883477_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/e7108511aa0bfa4933c72dc3cadf5f0c.webp"
"MediaSize" => 137311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-e7108511aa0bfa4933c72dc3cadf5f0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29883477_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/869fa874cf74b7ddf0da08cc9d996e52.webp"
"MediaSize" => 47784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-869fa874cf74b7ddf0da08cc9d996e52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29883477_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/17394f8fbed8dcd9e6548c83181c2930.webp"
"MediaSize" => 38178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-17394f8fbed8dcd9e6548c83181c2930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29883477_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29883477/79cdbb3327120e14878792150d4a6e3a.webp"
"MediaSize" => 44177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29883477/thumbnail-79cdbb3327120e14878792150d4a6e3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837309"
"ResourceRecordKey" => "29883477"
"ModificationTimestamp" => "2026-06-10T17:51:14.76Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29883477')"
+"ID": "1515451"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 299554" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24668
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564345" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24670
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29883477'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25159
+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 '29883477'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25195
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29883477' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5920205 43.4730669)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: 1518667
+post_author: 1
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T15:40:13Z"
+"RFModificationTimestamp": "2026-06-11T15:43:59Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1847.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN Street, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.5898653
1 => 43.4648243
]
+"Latitude": 43.4648243
+"Longitude": -80.5898653
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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. ** SEE VIDEO FOR FULL TOUR!! ** WOW! 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. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"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-11T15:39:38.270491+00:00"
+"Directions": "Erbsville Road, west onto Columbia Forest Blvd, right onto Royal Fern, house on the left near top of the street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1921681"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T15:13:41Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:31:59Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1657111442"
"RoomType" => "Storage"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.49Z"
]
1 => array:11 [
"RoomKey" => "1657111443"
"RoomType" => "Laundry room"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.49Z"
]
2 => array:11 [
"RoomKey" => "1657111444"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.49Z"
]
3 => array:11 [
"RoomKey" => "1657111445"
"RoomType" => "Office"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.49Z"
]
4 => array:11 [
"RoomKey" => "1657111446"
"RoomType" => "Recreation room"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.49Z"
]
5 => array:11 [
"RoomKey" => "1657111447"
"RoomType" => "Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
6 => array:11 [
"RoomKey" => "1657111448"
"RoomType" => "Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
7 => array:11 [
"RoomKey" => "1657111449"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
8 => array:11 [
"RoomKey" => "1657111450"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
9 => array:11 [
"RoomKey" => "1657111451"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
10 => array:11 [
"RoomKey" => "1657111452"
"RoomType" => "Living room"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T15:31:59.5Z"
]
11 => array:11 [
"RoomKey" => "1657111453"
"RoomType" => "Dining room"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
…1
]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29888538/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1434
+"BelowGradeFinishedArea": 413
+"OriginalEntryTimestamp": "2026-06-11T15:11:24.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227128"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888538')"
+"ID": 1518667
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1517955"
+post_author: 1
+"ListingKey": "29884895"
+"ListingId": "40838570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:15:15Z"
+"RFModificationTimestamp": "2026-06-10T20:43:37Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1952.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L2"
+"UnparsedAddress": "704 STAR FLOWER Avenue, Waterloo, Ontario N2V2L2"
+"Coordinates": array:2 [
0 => -80.5876117
1 => 43.4653582
]
+"Latitude": 43.4653582
+"Longitude": -80.5876117
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 story home with a HUGE LOFT in a desirable family neighbourhood. Brand new kitchen with quartz countertops and new stainless appliances. Lovely living room with multiple windows that provide lots of natural light--such a great family space. Sunny dinette with slider walk-out to the deck. Amazing 3rd floor loft is fabulous bonus space for multipurpose--so many options: family room, workout area, office, den, playroom, etc! Good sized primary bedroom with vaulted ceiling and walk-in closet. The 2 other bedrooms are also large with good size closets. Finished basement with a walk out to the large private fenced yard. The home just received multiple updates which include New Kitchen, Appliances, Bathrooms, Paint, Carpet-Free Flooring, Lighting and much more! Amazing location: close to top rated schools, parks, shopping, Costco, kilometres of walking trails (also great for running, biking, walking the dog, etc.) (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T20:41:07.698967+00:00"
+"Directions": "Erbsville Rd & Columbia Forest Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T20:09:55Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T20:09:55Z"
+"Stories": "2.0"
+"StreetName": "STAR FLOWER"
+"StreetNumber": "704"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4864"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_star_flower_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29884895/704-star-flower-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1952
+"OriginalEntryTimestamp": "2026-06-10T20:09:55.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1185878"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884895')"
+"ID": "1517955"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1511676"
+post_author: 1
+"ListingKey": "29877136"
+"ListingId": "X13420892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:01:04Z"
+"RFModificationTimestamp": "2026-06-09T18:46:38Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2V0B8"
+"UnparsedAddress": "541 SUNDEW DRIVE, Kitchener, Ontario N2V0B8"
+"Coordinates": array:2 [
0 => -80.596797
1 => 43.457194
]
+"Latitude": 43.457194
+"Longitude": -80.596797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "(STEP INSIDE) 4-bdrm detached 2-storey in Vista Hills, Waterloo. Open-concept main floor built around a fully equipped gas kitchen, walk-out dining rm with built-in wine cooler & a family rm that overlooks the backyard. Primary bdrm has his & her walk-in closets & a private 4pc en suite with soaker tub & standup shower. Full-width unfinished basement rec room. Vacant & available with flexible closing. (MAIN LEVEL) Ceramic-tiled foyer leads to a generous laminate landing before the living areas open up. Kitchen has a full stainless steel appliance package - gas stove, range hood, fridge, dishwasher & microwave - double sink & laminate floors, all open to the family rm with clear backyard views. Dining area has a wine cooler & walk-out to the back deck - a practical extension of the space on warmer evenings. 2pc powder rm off the main hall. Dedicated laundry rm with GE washer/dryer, blue cabinetry & direct inside access to the garage. (UPPER LEVEL) Primary bdrm has his & her walk-in closets & a private 4pc en suite with separate standup shower & large soaker tub. Bdrms 2, 3 & 4 are each well-proportioned with double closets, large windows & laminate floors. Main 4pc bath serves the secondary bdrms. (BASEMENT) Full-width open rec room - unfinished & ready for your own layout. Utility rm has hot water tank, water treatment system & HRV, all in one organized space. Additional dedicated storage rm. (LOCATION) Vista Hills at the northwest edge of Waterloo, backed by Laurel Creek Conservation Area to the west. Sundew Park is steps from the door - playground & community garden with direct trail access. Geo-Time Trail network connects the neighbourhood to the largest protected woodland in Waterloo. The Boardwalk at Ira Needles is ~10 min by car for grocery, dining, retail & Costco. Laurel Heights SS 1.5 km north. University of Waterloo & Wilfrid Laurier University a short drive east. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:46:25.888979+00:00"
+"Directions": "Cross Streets: Platinum Dr and Columbia St W. ** Directions: At Platinum Dr and Columbia St W, head northwest on Platinum Dr; At the roundabout, take the 3rd exit onto Columbia St W for 400 m; At the roundabout, take the 1st exit onto Sundew Dr; Destination will be on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922276"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:50:25Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:50:25Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "541"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6686"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29877136/541-sundew-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-06-09T17:50:25.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227436"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877136')"
+"ID": "1511676"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1510540"
+post_author: 1
+"ListingKey": "29874981"
+"ListingId": "40836085"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T12:40:06Z"
+"RFModificationTimestamp": "2026-06-11T12:44:54Z"
+"ListPrice": 1349888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.16
+"LivingArea": 3928.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N5"
+"UnparsedAddress": "805 MUNICH Circle, Waterloo, Ontario N2V2N5"
+"Coordinates": array:2 [
0 => -80.5902978
1 => 43.4603169
]
+"Latitude": 43.4603169
+"Longitude": -80.5902978
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 805 Munich Circle, a STUNNING LAURELVIEW HOMES-BUILT RESIDENCE nestled within the prestigious Rosewood Estates enclave of Clair Hills, one of Waterloo's most sought-after communities. Offering over 3,900 sq. ft. of finished living space, this exceptional 4-bedroom, 3.5-bathroom HOME IS PERFECTLY SITUATED ON A BEAUTIFULLY LANDSCAPED 0.16-ACRE LOT in a quiet cul-de-sac surrounded by nature trails and executive homes. Step inside to a grand two-storey foyer and discover elegant formal living and dining rooms accented by arched entryways and abundant natural light. The spacious kitchen is designed for both EVERYDAY LIVING AND ENTERTAINING, featuring white shaker cabinetry, granite countertops, mosaic tile backsplash, valance lighting, gas stove, peninsula island, recessed lighting and a bright dinette overlooking the backyard. The adjoining family room offers a cozy gas fireplace, wall-mounted TV feature, and EXPANSIVE WINDOWS SHOWCASING THE OUTDOOR SETTING. The main floor is complete with California shutters, laundry room, powder room, and direct access to the double-car garage. Upstairs, a curved hardwood staircase with wrought iron spindles leads to the SPACIOUS PRIMARY SUITE featuring a walk-in closet and 4-piece ensuite with soaker tub, granite vanity, and separate shower. Three additional bedrooms and a full family bathroom complete the upper level. The professionally finished basement expands the living space with a large recreation room, media/games area, full 3-piece bathroom, and VERSATILE HOBBY ROOM OR HOME OFFICE with walk-in closet. Enjoy outdoor living with a deck, gazebo, interlock patio, landscaped grounds, and private backyard retreat. Located just minutes from TOP-RATED SCHOOLS, PARKS, TRAILS, SHOPPING, UNIVERSITIES, AND THE BOARDWALK, this exceptional property offers the perfect combination of luxury, comfort, and convenience in one of Waterloo's premier neighbourhoods. A rare opportunity to call Rosewood Estates home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
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-09T17:33:46.286858+00:00"
+"Directions": "Columbia St turn onto Salzburg Drive follow until Munich Circle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Visual exposure"
2 => "Ravine"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T13:40:50Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T12:31:40Z"
+"Stories": "2.0"
+"StreetName": "MUNICH"
+"StreetNumber": "805"
+"StreetSuffix": "Circle"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/805-munich-cir-waterloo-on-n2v-2n5-25574745/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29874981/805-munich-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "47.7-R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 92.0
+"AboveGradeFinishedArea": 2760
+"BelowGradeFinishedArea": 1168
+"OriginalEntryTimestamp": "2026-06-09T13:39:46.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874981')"
+"ID": "1510540"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1510367"
+post_author: 1
+"ListingKey": "29874545"
+"ListingId": "40833492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:30:35Z"
+"RFModificationTimestamp": "2026-06-09T16:44:48Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0.17
+"LivingArea": 3477.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "712 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.584917
1 => 43.474518
]
+"Latitude": 43.474518
+"Longitude": -80.584917
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Laurelwood is a community known for its beautiful family homes, welcoming neighbours, and close proximity to the natural beauty of Laurel Creek Conservation Area. It offers a lifestyle that balances connection, convenience, and calm. From top-ranked schools within walking distance to trails, reservoir views, and quiet streets, it’s a place families put down roots and stay awhile. Backing onto protected greenspace with towering trees and the gentle soundtrack of birdsong, 712 Brookmill Place captures that lifestyle perfectly. Set on a premium pie-shaped lot, there’s room here for kids, pets, and gatherings with friends and family. Inside, the home is designed to grow with you. With five bedrooms upstairs, flexibility is built right in—space for a larger family, guest rooms, or dedicated areas for work and creativity. The primary suite offers both comfort and practicality, with generous closet space, and an updated ensuite that adds a touch of everyday luxury. The main floor is where life naturally comes together. A cozy gas fireplace anchors the living room, while the dinette and kitchen—with sliding doors to the deck—invite you to dine, relax, and take in uninterrupted views of the lush greenery beyond. It’s the kind of backdrop that changes with the seasons and never gets old. Downstairs, the fully finished lower level opens even more possibilities. With two large bedrooms, oversized windows, a full bath, and convenient access near the garage entry, it’s perfectly suited for multi-generational living or an in-law suite. Shopping, dining, entertainment, health care facilities, two universities, and amenities like public transit and bike lanes are just minutes away, while nearby golf courses and open countryside offer a welcome escape. A new hospital is planned for the north campus property of the U of W. And for those who love the outdoors, canoeing, kayaking, paddleboarding, or simply unwinding by the water at Laurel Creek are all part of everyday life here! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:44:24.543586+00:00"
+"Directions": "LAURELWOOD DRIVE TO BROOKMILL CRES., TO BROOKMILL PLACE."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976313"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T12:00:01Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T16:21:21Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "712"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7401.14"
+"VirtualTourURLUnbranded": "https://youriguide.com/712_brookmill_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29874545/712-brookmill-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 2677
+"BelowGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-09T12:00:01.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1262777"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874545')"
+"ID": "1510367"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24779
+post_id: "1510066"
+post_author: 1
+"ListingKey": "29875583"
+"ListingId": "X13419136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:05:47Z"
+"RFModificationTimestamp": "2026-06-09T16:10:39Z"
+"ListPrice": 1450000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY COURT, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.602215
1 => 43.462072
]
+"Latitude": 43.462072
+"Longitude": -80.602215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:10:35.124713+00:00"
+"Directions": "Cross Streets: Autumn Willow. ** Directions: Columbia St to Sundew right on Balsam Poplar St left on Autumn Willow follow to Snowberry Court."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239281"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.1 x 108 FT ; 103.79 x 46.29 x 107.96 x 63.28"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:55:41Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T15:54:00Z"
+"Stories": "2.0"
+"StreetName": "Snowberry"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://youtu.be/Vn1tecMngZM"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29875583/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-06-09T14:55:41.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1477313"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875583')"
+"ID": "1510066"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23357
+post_id: "1509969"
+post_author: 1
+"ListingKey": "29875084"
+"ListingId": "40836738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T15:11:08Z"
+"RFModificationTimestamp": "2026-06-09T15:13:27Z"
+"ListPrice": 1450000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3118.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY Court, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.6023791
1 => 43.4621044
]
+"Latitude": 43.4621044
+"Longitude": -80.6023791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T15:13:19.628518+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1836163"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:02:32Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T15:00:34Z"
+"Stories": "2.0"
+"StreetName": "SNOWBERRY"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://youtu.be/Vn1tecMngZM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875084/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563584"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 3118
+"OriginalEntryTimestamp": "2026-06-09T14:02:32.4Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1197077"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1143001"
+"CoListOfficeNationalAssociationId": "1004357"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875084')"
+"ID": "1509969"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1502400"
+post_author: 1
+"ListingKey": "29863317"
+"ListingId": "40837217"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:30:14Z"
+"RFModificationTimestamp": "2026-06-09T20:33:09Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3125.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "795 LAURELWOOD Drive Unit# C13, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.6003139
1 => 43.4707332
]
+"Latitude": 43.4707332
+"Longitude": -80.6003139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated corner-unit townhouse in the highly sought-after Laurelwood community. Nestled on a quiet cul-de-sac and surrounded by mature trees, this maintenance-free home offers exceptional space, privacy, and abundant natural light. Featuring three separate living areas and a rare main-floor primary bedroom with a full ensuite, this home is designed for both comfort and convenience. The main floor boasts soaring ceilings, a versatile front living room, a dedicated office, a powder room, and a renovated kitchen (2023) complete with quartz countertops, an island, white cabinetry, stainless steel appliances, and an open-concept layout that flows seamlessly into the dining and living areas. Upstairs, you'll find two spacious bedrooms, a full bathroom, and a large family room with the potential to be converted into a fourth bedroom. Step outside through sliding doors to a private deck overlooking peaceful greenspace-perfect for relaxing or entertaining. The expansive unfinished basement offers endless possibilities for future living space and awaits your personal touch. Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights. Ideally located near Laurel Creek, top-rated Kitchener-Waterloo schools, the University of Waterloo, shopping, and everyday amenities. Enjoy worry-free living with lawn maintenance and snow removal included. A rare opportunity to own a spacious, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T21:33:03.183497+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141441"
+"ListOfficeKey": "300100"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-09T20:21:52Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:21:52Z"
+"Stories": "2.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4864"
+"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/29863317/795-laurelwood-drive-unit-c13-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Md-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1992
+"BelowGradeFinishedArea": 1133
+"OriginalEntryTimestamp": "2026-06-05T20:50:57.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1393129"
+"ListOfficeNationalAssociationId": "1482864"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863317')"
+"ID": "1502400"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1498873"
+post_author: 1
+"ListingKey": "29859873"
+"ListingId": "40837053"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:26:00Z"
+"RFModificationTimestamp": "2026-06-05T17:04:20Z"
+"ListPrice": 1083900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3782.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X9"
+"UnparsedAddress": "512 WOOD NETTLE Way, Waterloo, Ontario N2V2X9"
+"Coordinates": array:2 [
0 => -80.6039602
1 => 43.4724714
]
+"Latitude": 43.4724714
+"Longitude": -80.6039602
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFERS. MOVE-IN READY! Beautiful family home in one of Waterloo’s most desirable neighborhoods in Laurelwood, steps to top-ranked schools and bus routes. Spacious 3,782 sq ft comfortable living space with 4+1 bedrooms and 3.5 baths. Main floor boasts 9' ceilings, gleaming hardwood and porcelain tiles, a grand foyer, formal dining room, and a great room with gas fireplace. Gourmet kitchen with stainless appliances and quartz countertops. The spacious breakfast area has a door that opens to a generously sized deck in fully fenced backyard. On the upper level, the large primary suite with walk-in closet and luxurious 5pc en-suite featuring a glass shower and custom whirlpool tub, all other 3 bedrooms are nicely sized, and the main bathroom features double sinks and a large bonus linen cabinet. The fully finished basement (2021) has a mirrored wall great for yoga practice, a large rec room ideal for home theater, and a home gym, and the 5th bedroom can be used as a home office. Recent Updates: Roof (2021), Owned Hot Water Heater (2025), Kitchen Cabinets and Fireplace Professionally Repainted (2026), Added Additional Insulation in Attic (2022), Multiple Modern Light Fixtures Installed (2026). Convenient to Costco, parks, trails, and transit to both universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:04:10.429784+00:00"
+"Directions": "Wideman Rd to Laurelwood Dr To Wood Nettle Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T15:19:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:19:24Z"
+"Stories": "2.0"
+"StreetName": "WOOD NETTLE"
+"StreetNumber": "512"
+"StreetSuffix": "Way"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7357"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/512-WOOD-NETTLE-Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859873/512-wood-nettle-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2627
+"BelowGradeFinishedArea": 1155
+"OriginalEntryTimestamp": "2026-06-05T15:19:24.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859873')"
+"ID": "1498873"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 92
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]
