array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30027421 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1621722"
+post_author: 1
+"ListingKey": "30027421"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T20:55:28Z"
+"RFModificationTimestamp": "2026-07-13T23:04:11Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# Lot 158, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5851199
1 => 43.4834036
]
+"Latitude": 43.4834036
+"Longitude": -80.5851199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Private serene setting in Green Acre Park. Located right next to beautiful forest and no rear or side neighbours. Approximately 700 sf plus 500 sf of freshly painted deck plus gazebo to enjoy a wonderful summer in a resort like park with lots of fun amenities. Newer French doors, roof furnace and AC. Nothing to do but enjoy. Tastefully decorated throughout with two bedrooms, one bathroom and an open concept kitchen dining and living room area. Lots of room to park on a dead end street. Large yard area with campfire pit and shed for storage. Park is closed January and February. Annual lease fees include use of all amenities to include heated swimming pool, playground, mini putt, fishing pond and more. Also includes water, sewer, garbage disposal, property taxes and common area maintenance. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T23:04:05.092522+00:00"
+"Directions": "Conservation Rd/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-13T20:54:29Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T20:54:29Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1683383846"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027421"
"RoomLength" => null
"RoomDimensions" => "8' x 5'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T20:49:06.51Z"
]
1 => array:11 [
"RoomKey" => "1683383847"
"RoomType" => "Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027421"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T20:49:06.51Z"
]
2 => array:11 [
"RoomKey" => "1683383848"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027421"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T20:49:06.51Z"
]
3 => array:11 [
"RoomKey" => "1683383849"
"RoomType" => "Living room"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027421"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T20:49:06.51Z"
]
4 => array:11 [
"RoomKey" => "1683383850"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027421"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T20:49:06.51Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027421/580-beaver-creek-road-unit-lot-158-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-07-13T20:49:06.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30027421_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/9c75dfd866d5d2ecbdd697b8e427e6c7.webp"
"MediaSize" => 101865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-9c75dfd866d5d2ecbdd697b8e427e6c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30027421_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/53f649d128f719d9efc626c8ba16a35e.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-53f649d128f719d9efc626c8ba16a35e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:29.07Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30027421_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/3455646010e2ac24d5ceb46123622f19.webp"
"MediaSize" => 101103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-3455646010e2ac24d5ceb46123622f19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30027421_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/6b5b7b7c0b1e07e0a5e90eba88afab2d.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-6b5b7b7c0b1e07e0a5e90eba88afab2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30027421_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/50790c2c27f895498f887f47a665a1c5.webp"
"MediaSize" => 88881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-50790c2c27f895498f887f47a665a1c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30027421_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/ebf48a52136d37c7b052d6720a869b39.webp"
"MediaSize" => 97840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-ebf48a52136d37c7b052d6720a869b39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30027421_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/d81c44ccb46670655f91108597f3bed6.webp"
"MediaSize" => 76740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-d81c44ccb46670655f91108597f3bed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30027421_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/c7811143b05aa8fabe98a75edb4303e4.webp"
"MediaSize" => 90113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-c7811143b05aa8fabe98a75edb4303e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30027421_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/172ee43f3953f7a41f44bff8ef61d993.webp"
"MediaSize" => 84219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-172ee43f3953f7a41f44bff8ef61d993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.94Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30027421_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/996464fa7ae23188b8f4ebd7600d4e91.webp"
"MediaSize" => 104626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-996464fa7ae23188b8f4ebd7600d4e91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30027421_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/7d1281925f19d741ab5c484a647c1592.webp"
"MediaSize" => 122115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-7d1281925f19d741ab5c484a647c1592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.94Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30027421_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/7d76ea84eb5e94b9c2f16296631bc804.webp"
"MediaSize" => 52329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-7d76ea84eb5e94b9c2f16296631bc804.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30027421_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/accbdfee50494dffedc1c9d073f161f2.webp"
"MediaSize" => 62817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-accbdfee50494dffedc1c9d073f161f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.99Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30027421_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/b5fb96778c7c94826fc21b53f668eb7a.webp"
"MediaSize" => 63803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-b5fb96778c7c94826fc21b53f668eb7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30027421_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/94eddafaf1cd4e2b2caf0820eb03c9fc.webp"
"MediaSize" => 65090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-94eddafaf1cd4e2b2caf0820eb03c9fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30027421_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/b6caa29872f268c5dac6b2433fd3537a.webp"
"MediaSize" => 61993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-b6caa29872f268c5dac6b2433fd3537a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.22Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30027421_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/e3f45563d0805c79fb9c3934c449d387.webp"
"MediaSize" => 61811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-e3f45563d0805c79fb9c3934c449d387.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30027421_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/3e7dc6e285e727fd95e4462a481b2268.webp"
"MediaSize" => 58872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-3e7dc6e285e727fd95e4462a481b2268.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:29.04Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30027421_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/5617df4fe0ff88c42b892dc027d0558a.webp"
"MediaSize" => 50949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-5617df4fe0ff88c42b892dc027d0558a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30027421_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/83ddaf75b47e30120b52dd8d237ec855.webp"
"MediaSize" => 58660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-83ddaf75b47e30120b52dd8d237ec855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.19Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30027421_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/f2d4fb38e6ac7daebae6d631f0b501de.webp"
"MediaSize" => 49630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-f2d4fb38e6ac7daebae6d631f0b501de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.19Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30027421_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027421/802b71bc426ecbac11b00b9c7f568a58.webp"
"MediaSize" => 38253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027421/thumbnail-802b71bc426ecbac11b00b9c7f568a58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "30027421"
"ModificationTimestamp" => "2026-07-13T20:54:28.18Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027421')"
+"ID": "1621722"
}
]
+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=OfficeKey eq 288925" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24956
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24900
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-648-4451"
+"OfficeMlsId": "HBRLPSTATEA2"
+"ModificationTimestamp": "2026-02-09T20:01:41Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288925"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1122 Wilson Street W Suite 200"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Ancaster"
+"OfficePostalCode": "L9G3K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1372539"
+"OriginalEntryTimestamp": "2020-11-03T19:13:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439678"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288925"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2026-02-09T18:47:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('288925')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1987928" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24910
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30027421'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25238
+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 '30027421' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25254
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30027421' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5851199 43.4834036)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1636878"
+post_author: 1
+"ListingKey": "30047422"
+"ListingId": "X13576166"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:07Z"
+"RFModificationTimestamp": "2026-07-17T17:03:14Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A8"
+"UnparsedAddress": "364 STONEHEIGHT PLACE, Waterloo, Ontario N2V2A8"
+"Coordinates": array:2 [
0 => -80.570164
1 => 43.496971
]
+"Latitude": 43.496971
+"Longitude": -80.570164
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 364 Stoneheight Place! Situated on a quiet court in one of Waterloo's sought-after family neighbourhoods, this beautifully updated 4-bedroom detached home has been thoughtfully expanded with an impressive approximately 1,000 sq. ft. addition, creating the perfect blend of luxury, functionality and space. The showpiece of the home is the spectacular custom kitchen, complete with quartz countertops, premium cabinetry, stainless steel appliances, gas cooktop, built-in wall ovens, an oversized island and a spacious eat-in area designed for family gatherings and entertaining. Multiple living spaces, updated flooring and tasteful finishes create an inviting atmosphere throughout. Upstairs you'll find three generous bedrooms, including a stunning primary retreat featuring a spa-inspired ensuite with a soaker tub, oversized glass shower, dual vanity and an incredible custom walk-in dressing room. The fully finished basement adds even more versatility with its own kitchen, bedroom, 3-piece bathroom and spacious recreation area, making it an excellent option for multi-generational living, guests or a private in-law suite. Step outside and discover your own backyard oasis. The expansive deck surrounds a sparkling pool, creating the ultimate setting for summer entertaining, family fun and relaxing weekends at home. Offering exceptional living space, designer updates, an incredible addition and a prime Waterloo location close to schools, parks, shopping, universities and expressway access, 364 Stoneheight Place is a home that truly stands apart. (id:62650)"
+"Appliances": array:5 [
0 => "Water meter"
1 => "Water softener"
2 => "Freezer"
3 => "Oven - Built-In"
4 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:03:02.635022+00:00"
+"Directions": "Westmount Rd N/ Osprey Dr"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1901379"
+"ListOfficeKey": "277619"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Irregular lot size"
2 => "Flat site"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "52.3 x 116.3 FT ; 107.7ftx41.2ftx41.3ftx116.3ftx **"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:11:17Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:11:17Z"
+"Stories": "2.0"
+"StreetName": "Stoneheight"
+"StreetNumber": "364"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7510"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/364_stoneheight_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686697519"
"RoomType" => "Kitchen"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 3.34
"ListingKey" => "30047422"
"RoomLength" => 5.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
1 => array:11 [
"RoomKey" => "1686697520"
"RoomType" => "Bedroom 4"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 3.05
"ListingKey" => "30047422"
"RoomLength" => 4.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
2 => array:11 [
"RoomKey" => "1686697521"
"RoomType" => "Dining room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "30047422"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
3 => array:11 [
"RoomKey" => "1686697522"
"RoomType" => "Living room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 5.39
"ListingKey" => "30047422"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
4 => array:11 [
"RoomKey" => "1686697523"
"RoomType" => "Family room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 4.57
"ListingKey" => "30047422"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
5 => array:11 [
"RoomKey" => "1686697524"
"RoomType" => "Laundry room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 1.79
"ListingKey" => "30047422"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
6 => array:11 [
"RoomKey" => "1686697525"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 5.45
"ListingKey" => "30047422"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
7 => array:11 [
"RoomKey" => "1686697526"
"RoomType" => "Bedroom 2"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 2.78
"ListingKey" => "30047422"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
8 => array:11 [
"RoomKey" => "1686697527"
"RoomType" => "Bedroom 3"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 3.19
"ListingKey" => "30047422"
"RoomLength" => 4.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
9 => array:11 [
"RoomKey" => "1686697528"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 5.74
"ListingKey" => "30047422"
"RoomLength" => 6.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
10 => array:11 [
"RoomKey" => "1686697529"
"RoomType" => "Kitchen"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 3.08
"ListingKey" => "30047422"
"RoomLength" => 2.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30047422/364-stoneheight-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.3
+"OriginalEntryTimestamp": "2026-07-17T15:11:17.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1217537"
+"ListOfficeNationalAssociationId": "1286063"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30047422_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/456d0737a18d8ab72c8259e2fd3bd5f0.webp"
"MediaSize" => 425733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-456d0737a18d8ab72c8259e2fd3bd5f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30047422_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/5613272866d1c52459fd19eb3261e412.webp"
"MediaSize" => 360296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-5613272866d1c52459fd19eb3261e412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30047422_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/fcb645325184fc9e4e91f5a1a62cf2b4.webp"
"MediaSize" => 374899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-fcb645325184fc9e4e91f5a1a62cf2b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30047422_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/fc010a755d60b80970a9ea77c544b159.webp"
"MediaSize" => 445682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-fc010a755d60b80970a9ea77c544b159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30047422_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/06be4c8ead77392edf4b60497e467d18.webp"
"MediaSize" => 404244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-06be4c8ead77392edf4b60497e467d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30047422_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/799ad111db182b210bf0094162108582.webp"
"MediaSize" => 343142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-799ad111db182b210bf0094162108582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30047422_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/0f782e01c8f7d5a4265104c31e0f73d4.webp"
"MediaSize" => 416371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-0f782e01c8f7d5a4265104c31e0f73d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30047422_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/f1e7440b6fc1282b0f30dc5cecfd5bcf.webp"
"MediaSize" => 406929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-f1e7440b6fc1282b0f30dc5cecfd5bcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30047422_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/e0c063bf7f34bfcb5b65ca558d90f293.webp"
"MediaSize" => 222775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-e0c063bf7f34bfcb5b65ca558d90f293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30047422_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a29cd0e7273aeb1131f8839843457733.webp"
"MediaSize" => 166386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a29cd0e7273aeb1131f8839843457733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30047422_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a448eed90df2c56290bdb18972e8ce9e.webp"
"MediaSize" => 206132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a448eed90df2c56290bdb18972e8ce9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30047422_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/12e7f7840dada466e30a4b4dd5aa4b34.webp"
"MediaSize" => 177000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-12e7f7840dada466e30a4b4dd5aa4b34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30047422_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/cb9910dd4afa11c11db58f69092a3b96.webp"
"MediaSize" => 174696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-cb9910dd4afa11c11db58f69092a3b96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30047422_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/00459f92f2f5bfa19ab7b00c6516b358.webp"
"MediaSize" => 181722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-00459f92f2f5bfa19ab7b00c6516b358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30047422_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/668a83f576a124a6dd516578c21fe32d.webp"
"MediaSize" => 192036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-668a83f576a124a6dd516578c21fe32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30047422_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/af4e24887209cd137cc2ac8339c40184.webp"
"MediaSize" => 168397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-af4e24887209cd137cc2ac8339c40184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30047422_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a2bc2d24b0e61c8a278bdcffa9470101.webp"
"MediaSize" => 125338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a2bc2d24b0e61c8a278bdcffa9470101.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30047422_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/25ea58a2a753a9141c0c39a1bac28021.webp"
"MediaSize" => 138203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-25ea58a2a753a9141c0c39a1bac28021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30047422_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/d4f4c7f4fd5b38927d8294cb741d7189.webp"
"MediaSize" => 187517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-d4f4c7f4fd5b38927d8294cb741d7189.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30047422_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a0c30fa92a996466c7bcd7c7bdf311c9.webp"
"MediaSize" => 199346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a0c30fa92a996466c7bcd7c7bdf311c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30047422_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/4e25e06646415afef3efac2fc33ee1cd.webp"
"MediaSize" => 202120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-4e25e06646415afef3efac2fc33ee1cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30047422_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/4986417929bcecddfca3758af9b49525.webp"
"MediaSize" => 204030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-4986417929bcecddfca3758af9b49525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30047422_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/d1543e138c18c4bddc6046df3e5bdd9b.webp"
…10
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047422')"
+"ID": "1636878"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1633477"
+post_author: 1
+"ListingKey": "30043986"
+"ListingId": "X13573118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y2"
+"UnparsedAddress": "615 DOGWOOD LANE, Waterloo, Ontario N2L4Y2"
+"Coordinates": array:2 [
0 => -80.562739
1 => 43.486821
]
+"Latitude": 43.486821
+"Longitude": -80.562739
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 615 Dogwood Lane, Waterloo! This beautifully updated detached bungalow offers the perfect blend of comfort, versatility, and location. Featuring 3 spacious bedrooms and 1 full bathroom on the main level, plus a fully finished basement with a separate side entrance, second kitchen, additional bedroom, full bathroom, and excellent in-law or income potential. The main floor showcases a beautifully renovated kitchen with quartz countertops, new cabinetry, backsplash, flooring, and stainless steel appliances, complemented by pot lights throughout the home. Enjoy a large private backyard, perfect for entertaining or relaxing, in a family-friendly neighbourhood just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, schools, parks, shopping, transit, uptown Waterloo and a new hospital is planned approximately 5 minutes from the property. A fantastic opportunity for families, investors, or multi-generational living in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T00:00:23.294569+00:00"
+"Directions": "Highpoint Ave & Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099530"
+"ListOfficeKey": "298485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:40:09Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:30Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "615"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "3823.47"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30043986/615-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2169025"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-16T19:40:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1369712"
+"ListOfficeNationalAssociationId": "1470118"
+"CoListAgentNationalAssociationId": "1419701"
+"CoListOfficeNationalAssociationId": "1470118"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043986')"
+"ID": "1633477"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1626530"
+post_author: 1
+"ListingKey": "30034584"
+"ListingId": "40844927"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T19:50:03Z"
+"RFModificationTimestamp": "2026-07-17T23:46:33Z"
+"ListPrice": 3150000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6452.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "596 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6023274
1 => 43.4779011
]
+"Latitude": 43.4779011
+"Longitude": -80.6023274
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience upscale living in this stunning, over 6000 sq ft rarely found bungalow located in one of Waterloo’s most prestigious neighborhoods! The main level features three bedrooms, each with its own walk-in closet and private ensuite! A bright, welcoming foyer leads to a spacious living room with 12 ft ceiling, a gas fireplace, a stunning, open-concept kitchen with a large granite countertop, plenty of cabinets, butler's kitchen, high-end Miele appliances, and a sunny dining area that’s sure to impress. The main floor also includes an office with large windows for plenty of natural light, a separate dining room, a generous walk-in kitchen pantry, a beautiful 2 piece bathroom, and a laundry room. Head down to the expansive wide open basement and discover large windows, two large additional bedrooms (one currently serving as a gym), a luxurious three-piece bathroom, two spacious living areas, a bar/kitchenette, and plenty of room to let your creativity flow. The garage fits three cars and includes stairs leading down to the basement. This home features in-floor heating, granite countertops, high-end finishes throughout and top-of-the-line craftsmanship. The beautifully landscaped backyard is an entertainer’s dream, complete with an inground heated pool, a covered sitting area, and plenty of space for kids to play or for hosting parties. Regal Place is a private street with no through traffic and close to some of the best schools in the region and many amenities. Homes like this are rarely offered for sale. Don't let this one slip away! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "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-07-15T14:09:19.084098+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046754"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:41:11Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:41:11Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "596"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "17817.31"
+"VirtualTourURLUnbranded": "https://youriguide.com/596_regal_pl_waterloo_on/"
+"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/30034584/596-regal-place-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 3285
+"BelowGradeFinishedArea": 3167
+"OriginalEntryTimestamp": "2026-07-15T11:49:59.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1322161"
+"ListOfficeNationalAssociationId": "1004363"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034584')"
+"ID": "1626530"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1625929"
+post_author: 1
+"ListingKey": "30031018"
+"ListingId": "X13561526"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:35Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY TRAIL, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.590278
1 => 43.490303
]
+"Latitude": 43.490303
+"Longitude": -80.590278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community - one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:49:41.681116+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "39.6 x 101.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T16:40:51Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:23Z"
+"Stories": "2.0"
+"StreetName": "Pinery"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30031018/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.7
+"OriginalEntryTimestamp": "2026-07-14T16:40:51.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031018')"
+"ID": "1625929"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1624331"
+post_author: 1
+"ListingKey": "30031061"
+"ListingId": "40847488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T16:05:27Z"
+"RFModificationTimestamp": "2026-07-15T16:25:27Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1398.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H47, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5939632
1 => 43.4698313
]
+"Latitude": 43.4698313
+"Longitude": -80.5939632
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "***OPEN HOUSE: SATURDAY JULY 18TH AND SUNDAY JULY 19TH 2-4pm*** Welcome to Unit H47 at 619 Wild Ginger Avenue, a beautifully refreshed four-level townhome offering exceptional value for first-time buyers, families, or investors. Lovingly maintained by the same tenant since 2007, this home has been thoughtfully updated and is move-in ready. Freshly painted throughout, with new flooring, modern lighting, and a stylish new kitchen backsplash, it offers a bright feel from the moment you arrive. The Furnace and AC were replaced in 2024 and 2026 respectively. The front door was replaced in 2022. The main level features a spacious eat-in kitchen, a convenient two-piece powder room, and a generous living room overlooking your private backyard. Upstairs, you'll find two large bedrooms, including a primary bedroom with direct access to the four-piece main bathroom through a convenient cheater ensuite. The lower level offers an ideal third bedroom, home office, or family room, complete with its own three-piece ensuite bathroom. Sliding doors lead to a private deck and fenced backyard. The basement, accessible through the attached garage, houses the laundry area, HVAC system, and additional storage space. Located in a desirable neighbourhood, this home is close to excellent elementary and secondary schools, shopping, parks, public transit, and other everyday conveniences. Whether you're looking for your next home or a smart investment opportunity, this property is one you won't want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "277"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:42:59.525510+00:00"
+"Directions": "First right turn into complex off of Wild Ginger Ave"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067711"
+"ListOfficeKey": "286933"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T20:48:23Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T15:59:27Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3852.78"
+"VirtualTourURLUnbranded": "https://youriguide.com/h47_619_wild_ginger_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031061/619-wild-ginger-avenue-unit-h47-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1564408"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "286933"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1398
+"OriginalEntryTimestamp": "2026-07-14T16:48:17.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342782"
+"ListOfficeNationalAssociationId": "1364894"
+"CoListAgentNationalAssociationId": "1129302"
+"CoListOfficeNationalAssociationId": "1364894"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031061')"
+"ID": "1624331"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1621982"
+post_author: 1
+"ListingKey": "30028922"
+"ListingId": "40845774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T02:30:01Z"
+"RFModificationTimestamp": "2026-07-18T02:35:05Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2613.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY Trail, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.5909464
1 => 43.4901449
]
+"Latitude": 43.4901449
+"Longitude": -80.5909464
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community — one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T03:23:27.756438+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T02:20:27Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T02:29:58Z"
+"Stories": "2.0"
+"StreetName": "PINERY"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30028922/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2613
+"OriginalEntryTimestamp": "2026-07-14T02:29:30.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028922')"
+"ID": "1621982"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1619390"
+post_author: 1
+"ListingKey": "30024345"
+"ListingId": "40847363"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T17:20:05Z"
+"RFModificationTimestamp": "2026-07-13T17:22:08Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.58336
1 => 43.4751863
]
+"Latitude": 43.4751863
+"Longitude": -80.58336
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned at the end of a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood, this beautifully maintained home sits on a pie-shaped lot backing onto a conservation area with no rear neighbours. Offering 1,230 sq. ft. above grade and nearly 1,800 sq. ft. of finished living space, this smoke-free, pet-free home features 3 bedrooms, 2 bathrooms, and a finished basement with a rough-in for an additional bathroom. The bright, open-concept main floor features hardwood flooring and a spacious Great Room with soaring cathedral ceilings and views of the forest beyond. Upstairs, the generous primary bedroom offers cheater ensuite access, while two additional bedrooms provide room for family, guests, or a home office. The finished basement includes a bright recreation room, laundry and mechanical area, storage, and a rough-in for a future 2-piece bathroom. Outside, the pie-shaped backyard is a great place to unwind or entertain, with a multi-level, surrounded by trees. Recent updates include an RO water system (2026), broadloom in the basement and on the upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), and washer and dryer (2024). Located close to excellent schools, parks, walking trails, shopping, the YMCA, library, and both universities, this is a wonderful opportunity to own a home in the heart of Laurelwood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:20:08.994594+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T17:18:16Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T17:18:16Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/742_brookmill_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024345/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-07-13T13:48:07.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024345')"
+"ID": "1619390"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1618779"
+post_author: 1
+"ListingKey": "30024348"
+"ListingId": "40847107"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:00:05Z"
+"RFModificationTimestamp": "2026-07-13T16:01:30Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 405, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.598786
1 => 43.4711667
]
+"Latitude": 43.4711667
+"Longitude": -80.598786
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience care-free condo living at its finest in Waterloo’s premier Laurelwood neighbourhood. Welcome to Suite 405 at Laurelwood Reflections Phase 2, a stunning unit boasting over 1,000 sq ft of bright, open-concept living. The versatile floor plan features a wealth of natural light, offering total flexibility for your ideal living and dining configurations. Culinary enthusiasts will love the upgraded chef’s kitchen, complete with granite countertops, stainless steel appliances, abundant storage, and a large island with seating for three. The split bedroom layout is ideal for privacy and both bedrooms are generously sized. The primary bedroom features a spacious walk-in closet and a private 3-piece ensuite with a modern glass shower. Step outside onto your private balcony to enjoy picturesque, northern views of Creekside Pond and breathtaking seasonal foliage. There are 2 parking spots with 1 underground and 1 surface spot. Building amenities include a party room, lounge, theatre room, bike storage, visitor parking, and an outdoor BBQ pavilion. You'll love the location in a AAA+ family-friendly area. Walk to groceries, top-rated schools, walking trails, and the Laurel Creek Conservation Area. Turn-key, modern mid-rise living awaits! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"AssociationFee": "480.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:57:25.447459+00:00"
+"Directions": "Erbsville / Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-13T15:58:58Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T15:58:58Z"
+"Stories": "5.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4083"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024348/778-laurelwood-drive-unit-405-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-13T13:48:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024348')"
+"ID": "1618779"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1618638"
+post_author: 1
+"ListingKey": "30023953"
+"ListingId": "40847395"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T23:55:19Z"
+"RFModificationTimestamp": "2026-07-15T00:27:35Z"
+"ListPrice": 682000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.16
+"LivingArea": 2122.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H4"
+"UnparsedAddress": "330 LAKE LOUISE Boulevard, Waterloo, Ontario N2V2H4"
+"Coordinates": array:2 [
0 => -80.572408
1 => 43.4967469
]
+"Latitude": 43.4967469
+"Longitude": -80.572408
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 330 Lake Louise Boulevard in Waterloo—a beautifully maintained freehold bungalow townhouse that offers the perfect blend of comfort, convenience, and low-maintenance living. Ideal for those looking to right-size without compromise, this carpet-free home features an inviting open-concept main floor where the kitchen, dining, and living areas flow seamlessly together. Step through the living room walkout to your own private patio, creating the perfect space to relax, unwind, or entertain family and friends. The spacious main-floor primary suite is thoughtfully designed with a private ensuite and the convenience of a dedicated laundry closet, allowing for true main-floor living. A double garage provides plenty of space for parking and storage. The finished lower level is an entertainer's dream, offering an oversized recreation room complete with a wet bar and shuffleboard area, along with two additional bedrooms and a full bathroom—perfect for overnight guests, hobbies, or a home office. The basement has been freshly painted and updated with brand-new flooring in April 2026, giving the space a fresh, modern feel. Situated in one of Waterloo's most desirable neighbourhoods, you'll enjoy being just minutes from Laurel Creek Conservation Area, scenic walking trails, golf courses, shopping, restaurants, and the renowned St. Jacobs Farmers' Market. This exceptional home combines carefree living, stylish updates, and an unbeatable location, making it the perfect place to enjoy your next chapter. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Wet Bar"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:01:32.429566+00:00"
+"Directions": "corner of Lake Louise and Ellesmere"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1728710"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:8 [
0 => "Cul-de-sac"
1 => "Corner Site"
2 => "Conservation/green belt"
3 => "Wet bar"
4 => "Paved driveway"
5 => "Skylight"
6 => "Sump Pump"
7 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T11:48:21Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T23:48:14Z"
+"Stories": "1.0"
+"StreetName": "LAKE LOUISE"
+"StreetNumber": "330"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "4998.59"
+"VirtualTourURLUnbranded": "https://youriguide.com/2ggil_330_lake_louise_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30023953/330-lake-louise-boulevard-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 141.0
+"AboveGradeFinishedArea": 1144
+"BelowGradeFinishedArea": 978
+"OriginalEntryTimestamp": "2026-07-13T11:48:21.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1176375"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023953')"
+"ID": "1618638"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 86
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]