array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29939876 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1556233"
+post_author: 1
+"ListingKey": "29939876"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T02:20:06Z"
+"RFModificationTimestamp": "2026-06-23T04:41:37Z"
+"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": "Brantford Regional Real Estate Assn Inc"
+"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-06-23T04:41:34.277607+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": "291581"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-23T02:14:58Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:14:58Z"
+"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" => "1665803707"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "8' x 5'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
1 => array:11 [
"RoomKey" => "1665803708"
"RoomType" => "Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
2 => array:11 [
"RoomKey" => "1665803709"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
3 => array:11 [
"RoomKey" => "1665803710"
"RoomType" => "Living room"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
4 => array:11 [
"RoomKey" => "1665803711"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29939876/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-06-23T02:14:57.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1400487"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29939876_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/41bebb5583f0848a9f156f8762fe65a6.webp"
"MediaSize" => 101865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-41bebb5583f0848a9f156f8762fe65a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29939876_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/2e4f7262ddd67c1c95213575e414b28a.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-2e4f7262ddd67c1c95213575e414b28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29939876_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6844a3480ce4c91e70314cb465f86481.webp"
"MediaSize" => 101103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6844a3480ce4c91e70314cb465f86481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29939876_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29939876_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/ea3799368219881e646f005cca5837c6.webp"
"MediaSize" => 88881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-ea3799368219881e646f005cca5837c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29939876_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/021bee7972cd2eb60a7e14c38909c2c6.webp"
"MediaSize" => 97840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-021bee7972cd2eb60a7e14c38909c2c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29939876_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/59df0662a88af5d1842a1634f41dd394.webp"
"MediaSize" => 76740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-59df0662a88af5d1842a1634f41dd394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29939876_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/08ef3c531cdae9014538e6d56ad3872c.webp"
"MediaSize" => 90113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-08ef3c531cdae9014538e6d56ad3872c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29939876_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"MediaSize" => 84219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29939876_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/d7932f797d43acb5c47324cf285253c3.webp"
"MediaSize" => 104626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-d7932f797d43acb5c47324cf285253c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29939876_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6e05ed1714670887a0df8e860263c878.webp"
"MediaSize" => 122115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6e05ed1714670887a0df8e860263c878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29939876_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/61aba34eade769c25897480797a20dc4.webp"
"MediaSize" => 52329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-61aba34eade769c25897480797a20dc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29939876_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/763db300599294291270749ea39449e7.webp"
"MediaSize" => 62817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-763db300599294291270749ea39449e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29939876_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/79a2d09f17734c81a7610b4011ade9e8.webp"
"MediaSize" => 63803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-79a2d09f17734c81a7610b4011ade9e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29939876_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f23d047d6627006751f6816e741a404a.webp"
"MediaSize" => 65090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f23d047d6627006751f6816e741a404a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29939876_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f6bb67718de7320a324a95016b64fbd4.webp"
"MediaSize" => 61993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f6bb67718de7320a324a95016b64fbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29939876_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/dbc652ec205a2768d7cec48e6277be35.webp"
"MediaSize" => 61811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-dbc652ec205a2768d7cec48e6277be35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29939876_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/5083652eed0e8dcb963052e54c4b4a70.webp"
"MediaSize" => 58872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-5083652eed0e8dcb963052e54c4b4a70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29939876_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/321552b5b50dc7f6bd9d8edd35111d1e.webp"
"MediaSize" => 50949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-321552b5b50dc7f6bd9d8edd35111d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29939876_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/177383850602f524d297b8d7a3fe19fb.webp"
"MediaSize" => 58660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-177383850602f524d297b8d7a3fe19fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29939876_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/23f0af4be1c515a240963fd8d33d6e37.webp"
"MediaSize" => 49630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-23f0af4be1c515a240963fd8d33d6e37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29939876_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/d3848718f005d5696c1661fd162cd8eb.webp"
"MediaSize" => 38253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-d3848718f005d5696c1661fd162cd8eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939876')"
+"ID": "1556233"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291581" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24787
+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 1987928" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24874
+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 '29939876'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25171
+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 '29939876'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25187
+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 '29939876' 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 {#25240
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1553272"
+post_author: 1
+"ListingKey": "29935006"
+"ListingId": "40841536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:00:24Z"
+"RFModificationTimestamp": "2026-06-22T13:42:48Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2240.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J2"
+"UnparsedAddress": "479 TIMBERCROFT Crescent, Waterloo, Ontario N2T2J2"
+"Coordinates": array:2 [
0 => -80.5707503
1 => 43.4704296
]
+"Latitude": 43.4704296
+"Longitude": -80.5707503
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful 4-bedroom backsplit home is located in the highly sought-after Laurelwood neighbourhood of Waterloo, offering the perfect blend of space, comfort, and convenience in one of the city's most established and family-friendly communities. Situated on a mature, tree-lined street, this well-maintained property features a double-car garage and a brand-new double-wide asphalt driveway, providing ample parking and impressive curb appeal. The spacious backsplit layout offers multiple levels of living space, ideal for growing families, entertaining guests, or creating dedicated work-from-home areas.Step outside to your private backyard retreat, complete with a sparkling inground saltwater pool—perfect for relaxing on warm summer days and hosting family gatherings and outdoor celebrations.The home enjoys an exceptional location close to many of Waterloo's most desirable amenities. Families will appreciate being within easy reach of Laurelwood Public School and St. Nicholas Catholic Elementary School. Post-secondary institutions including University of Waterloo and Wilfrid Laurier University are just a short drive away, making this location ideal for university staff, faculty, and families with students. Nature lovers will enjoy the close proximity to Laurel Creek Conservation Area, offering scenic trails, recreational activities, and year-round outdoor enjoyment. Everyday conveniences are also nearby, with shopping, restaurants, services, and amenities just minutes from your doorstep. Combining a desirable backsplit design, outstanding outdoor living, excellent schools, nearby universities, and access to nature, this home presents a rare opportunity to live in one of Waterloo's most desirable mature neighbourhoods. Whether you're raising a family, entertaining friends, or simply enjoying the peaceful surroundings, this Laurelwood property offers a lifestyle that is both comfortable and convenient. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:42:38.585379+00:00"
+"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:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069548"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T11:50:15Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T11:50:15Z"
+"Stories": "2.0"
+"StreetName": "TIMBERCROFT"
+"StreetNumber": "479"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5727"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1665204082"
"RoomType" => "Recreation room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
1 => array:11 [
"RoomKey" => "1665204083"
"RoomType" => "Laundry room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
2 => array:11 [
"RoomKey" => "1665204084"
"RoomType" => "Living room"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
3 => array:11 [
"RoomKey" => "1665204085"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
4 => array:11 [
"RoomKey" => "1665204086"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
5 => array:11 [
"RoomKey" => "1665204087"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
6 => array:11 [
"RoomKey" => "1665204088"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
7 => array:11 [
"RoomKey" => "1665204089"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
8 => array:11 [
"RoomKey" => "1665204090"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
9 => array:11 [
"RoomKey" => "1665204091"
"RoomType" => "Kitchen"
"ListingId" => "40841536"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
10 => array:11 [
"RoomKey" => "1665204092"
"RoomType" => "Dining room"
"ListingId" => "40841536"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935006/479-timbercroft-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1177
+"BelowGradeFinishedArea": 1063
+"OriginalEntryTimestamp": "2026-06-22T11:50:15.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1344717"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935006_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/e0d6d4d1e97be6f0417f8f094c404cf0.webp"
"MediaSize" => 151115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-e0d6d4d1e97be6f0417f8f094c404cf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935006_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/96c462901e82fefb3440e0c163b433d4.webp"
"MediaSize" => 167326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-96c462901e82fefb3440e0c163b433d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935006_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3d6d00c7c481a54bcc8e479384bdb1bc.webp"
"MediaSize" => 133099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3d6d00c7c481a54bcc8e479384bdb1bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935006_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/a502e9c7ef53b93da3caffa15a44135b.webp"
"MediaSize" => 146735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-a502e9c7ef53b93da3caffa15a44135b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935006_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/164b31ecc35201012e02425f5c54bbd4.webp"
"MediaSize" => 122584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-164b31ecc35201012e02425f5c54bbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935006_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/1ba4ac7535a93c2c713bea9094fd89f2.webp"
"MediaSize" => 64130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-1ba4ac7535a93c2c713bea9094fd89f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935006_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/bc113c474e4b28ebf335be45a8616a98.webp"
"MediaSize" => 84158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-bc113c474e4b28ebf335be45a8616a98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935006_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/46b02810a936fe288e8949e5e9dbca6c.webp"
"MediaSize" => 92102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-46b02810a936fe288e8949e5e9dbca6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935006_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/74eeefb2b41d9e830624a7a869e8e868.webp"
"MediaSize" => 84407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-74eeefb2b41d9e830624a7a869e8e868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935006_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/7ad2ca8e5da415e295d273d4777b99e1.webp"
"MediaSize" => 87212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-7ad2ca8e5da415e295d273d4777b99e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935006_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/d128c5413f5db6da1b76488ce5f4fc65.webp"
"MediaSize" => 88913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-d128c5413f5db6da1b76488ce5f4fc65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935006_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/d956295f03e240b386ee71241632ee9f.webp"
"MediaSize" => 82675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-d956295f03e240b386ee71241632ee9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935006_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/6e6206ad813c3fe943ebdde87726b96d.webp"
"MediaSize" => 78162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-6e6206ad813c3fe943ebdde87726b96d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935006_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/2d5a36159ff0cdbd92b4c6159f8f3dbf.webp"
"MediaSize" => 71849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-2d5a36159ff0cdbd92b4c6159f8f3dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935006_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/780985eebdbe276eb74fd2cac3cd338b.webp"
"MediaSize" => 85303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-780985eebdbe276eb74fd2cac3cd338b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935006_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/17aa9ed464acc403c5540917e693d1b1.webp"
"MediaSize" => 63985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-17aa9ed464acc403c5540917e693d1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935006_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3a2e99ca690fa847d31b75563c5838fc.webp"
"MediaSize" => 69973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3a2e99ca690fa847d31b75563c5838fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935006_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/37059ecc0fe259cc43dc3df486014907.webp"
"MediaSize" => 109188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-37059ecc0fe259cc43dc3df486014907.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935006_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/31d5f66469e888c59f29c91372a617ab.webp"
"MediaSize" => 95985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-31d5f66469e888c59f29c91372a617ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935006_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f256ba4d84ad185518907b78b3caa64b.webp"
"MediaSize" => 66239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f256ba4d84ad185518907b78b3caa64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935006_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/c49c2083064fe97885aeed4634becd61.webp"
"MediaSize" => 70021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-c49c2083064fe97885aeed4634becd61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29935006_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/156f2b6de6b532e84e0183f68fc628ef.webp"
"MediaSize" => 81119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-156f2b6de6b532e84e0183f68fc628ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29935006_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/b8bdc68a03de04461a147cbb78b1c24c.webp"
"MediaSize" => 157582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-b8bdc68a03de04461a147cbb78b1c24c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29935006_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/634b26c9660711192bdd87ddfce19ac1.webp"
"MediaSize" => 146813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-634b26c9660711192bdd87ddfce19ac1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29935006_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/2bcbbb4a524e5819ca7caec662ad1a17.webp"
"MediaSize" => 144139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-2bcbbb4a524e5819ca7caec662ad1a17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29935006_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f02ddd7062cd868686f9eee380e1d46d.webp"
"MediaSize" => 127281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f02ddd7062cd868686f9eee380e1d46d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29935006_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/ebcada7ce841c39aaef8957dfdd3e8a4.webp"
"MediaSize" => 130489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-ebcada7ce841c39aaef8957dfdd3e8a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29935006_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3346a19194ecdbde782fe87024937c66.webp"
"MediaSize" => 126206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3346a19194ecdbde782fe87024937c66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29935006_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f6279c1d791201dc7c5b7884b703c77f.webp"
"MediaSize" => 131312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f6279c1d791201dc7c5b7884b703c77f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29935006_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/8773661037f19a6d04d806ec747ddea8.webp"
"MediaSize" => 135983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-8773661037f19a6d04d806ec747ddea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29935006_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/dd29f7940089c86dfc8afd95c7e66e0d.webp"
"MediaSize" => 158158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-dd29f7940089c86dfc8afd95c7e66e0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29935006_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/8669deb733b927939751337cd08eb818.webp"
"MediaSize" => 143390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-8669deb733b927939751337cd08eb818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29935006_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/0515df661f0b5505441e8322c660c709.webp"
"MediaSize" => 111413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-0515df661f0b5505441e8322c660c709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29935006_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/7510ba81493ec209cd2cf7cc4990470c.webp"
"MediaSize" => 123613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-7510ba81493ec209cd2cf7cc4990470c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29935006_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/97e02fcae3fb42ba5983caf1623b7071.webp"
"MediaSize" => 35779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-97e02fcae3fb42ba5983caf1623b7071.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
35 => array:13 [
"Order" => 36
…12
]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935006')"
+"ID": "1553272"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1552069"
+post_author: 1
+"ListingKey": "29917845"
+"ListingId": "40840697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:17Z"
+"RFModificationTimestamp": "2026-06-20T20:44:29Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2735.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H3"
+"UnparsedAddress": "599 COLDSTREAM Drive, Waterloo, Ontario N2V2H3"
+"Coordinates": array:2 [
0 => -80.5750905
1 => 43.4932507
]
+"Latitude": 43.4932507
+"Longitude": -80.5750905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Custom-built 4-bedroom backsplit offering approximately 2,700 sq. ft. of finished living space on a stunning premium lot backing onto greenspace, a playground, and a scenic pond. The bright and spacious main level showcases soaring cathedral ceilings in the living and dining rooms, creating an impressive open-concept feel. The custom kitchen overlooks the family room and features a walkout to the deck, perfect for BBQ, Matching Custom made kitchen table and chairs included. The upper level offers three generous bedrooms with California Shutters and a spacious main bath complete with a relaxing jacuzzi tub. The expansive lower level features a large family room with a cozy gas fireplace, a fourth bedroom or ideal home office with California Shutters, and a walkout to a covered porch and fully fenced backyard with gate to park. The finished rec room provides additional living space for family gatherings, recreation, or a media room. An exceptional family home in a highly desirable setting with beautiful views and direct access to nature. Excellent location close to schools & Universities, walking trails, Laurel Creek Conservation area, community centres, library, St. Jacobs Farmers Market, quick highway access! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T20:44:21.682407+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T19:20:57Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:36Z"
+"Stories": "3.0"
+"StreetName": "COLDSTREAM"
+"StreetNumber": "599"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6001.09"
+"VirtualTourURLUnbranded": "https://youriguide.com/599_coldstream_dr_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/29917845/599-coldstream-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 2119
+"BelowGradeFinishedArea": 616
+"OriginalEntryTimestamp": "2026-06-17T19:20:57.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917845')"
+"ID": "1552069"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1551580"
+post_author: 1
+"ListingKey": "29932825"
+"ListingId": "40839561"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T21:00:14Z"
+"RFModificationTimestamp": "2026-06-22T21:04:23Z"
+"ListPrice": 1185000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2770.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y3"
+"UnparsedAddress": "399 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y3"
+"Coordinates": array:2 [
0 => -80.5877793
1 => 43.4907454
]
+"Latitude": 43.4907454
+"Longitude": -80.5877793
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional executive home in the highly sought-after, family-friendly Conservation Meadows community. Offering over 2,200 sq. ft. of beautifully finished living space, this impressive 3-bedroom, 3-bathroom residence features a versatile upper-level family room and an outstanding layout designed for modern living. A grand double-door entry opens to a spacious and inviting foyer, setting the tone for the home's bright, open-concept design. The stylish kitchen is equipped with quartz countertops, a tiled backsplash, stainless steel appliances, under-cabinet lighting, a large centre island, and a generous dining area with sliding glass doors leading to the backyard. Flowing seamlessly from the kitchen and dining space, the expansive living room is filled with natural light from oversized windows, creating the perfect setting for entertaining guests or enjoying everyday family life. A convenient 2-piece powder room completes the main level. Upstairs, the spacious primary suite offers an oversized walk-in closet and a luxurious 5-piece ensuite featuring a double vanity, soaker tub, and walk-in tiled shower. Two additional generously sized bedrooms, a 4-piece main bathroom, a dedicated laundry room, and a bonus family room—ideal as a media loft, home office, or playroom—complete the upper level. Additional highlights include quartz countertops in all bathrooms, California shutters, pot lights throughout, hardwood and porcelain tile flooring on the carpet-free main level, and an upgraded stone-front exterior with a covered front porch. 3 years old furnace and 6 years AC compressor. Ideally located close to Laurel Creek Conservation Area, excellent schools, universities, parks, walking trails, highway access, and the renowned St. Jacobs Farmers’ Market, this home offers an exceptional lifestyle in one of Waterloo’s most desirable neighbourhoods. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water purifier"
2 => "Water softener"
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:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:55:22.268764+00:00"
+"Directions": "Pinery Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2134833"
+"ListOfficeKey": "268423"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T20:51:36Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T20:51:35Z"
+"Stories": "2.0"
+"StreetName": "RIDEAU RIVER"
+"StreetNumber": "399"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7834.46"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=kpcpTBhVYEx&mls=1"
+"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/29932825/399-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2205
+"BelowGradeFinishedArea": 565
+"OriginalEntryTimestamp": "2026-06-20T13:50:20.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1387179"
+"ListOfficeNationalAssociationId": "1230322"
+"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('29932825')"
+"ID": "1551580"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1551024"
+post_author: 1
+"ListingKey": "29932336"
+"ListingId": "X13470220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T16:25:09Z"
+"RFModificationTimestamp": "2026-06-20T16:29:03Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L2"
+"UnparsedAddress": "142 CORNERBROOK CRESCENT, Waterloo, Ontario N2V1L2"
+"Coordinates": array:2 [
0 => -80.565797
1 => 43.492815
]
+"Latitude": 43.492815
+"Longitude": -80.565797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "ATTENTION FIRST-TIME HOME BUYERS & INVESTORS Step into modern living with this stunning fully renovated 3-bedroom detached home, linked only by the foundation, offering the perfect combination of luxury, comfort, and value. From the moment you arrive, this beautiful residence is designed to impress.The heart of the home features a chef-inspired kitchen complete with premium quartz countertops, a stylish backsplash, and sleek stainless steel appliances. Elegant 24x24 porcelain tiles flow throughout the main living areas and lead seamlessly to a private backyard retreat - perfect for entertaining family and friends.The professionally finished basement adds even more functionality with an upgraded bathroom and convenient lower-level laundry. Every detail has been thoughtfully updated to provide a move-in-ready experience.Ideally located in a highly sought-after neighborhood with quick access to major highways, the university, schools, shopping, restaurants, parks, and all everyday amenities. A rare opportunity to own a beautifully upgraded home in a prime location. Perfect for first-time buyers, growing families, or savvy investors. Pride of ownership is evident throughout. Don't miss your chance to make this exceptional property your own! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T04:41:37.241885+00:00"
+"Directions": "Northfield Dr. & Westmount Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141660"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "33 x 106 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T01:47:05Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T16:18:43Z"
+"Stories": "2.0"
+"StreetName": "Cornerbrook"
+"StreetNumber": "142"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3288"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932336/142-cornerbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-20T01:47:05.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1393502"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932336')"
+"ID": "1551024"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1548475"
+post_author: 1
+"ListingKey": "29928698"
+"ListingId": "40841473"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:19Z"
+"RFModificationTimestamp": "2026-06-20T20:43:00Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1992.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "795 LAURELWOOD Drive Unit# C13, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.6001493
1 => 43.4708976
]
+"Latitude": 43.4708976
+"Longitude": -80.6001493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful corner unit open bright family home offers spacious layout throughout. The Master bedroom is on the main floor with a full ensuite, ideal for older home owners or families looking for comfort. Situated on a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. This unit has lots of natural lighting with soaring living room ceiling. The main floor starts with a formal living room or reading nook with a spacious powder room. The laundry/office is spacious behind the kitchen. The kitchen has stainless steel appliances, a quartz counter top, white cabinetry and an island (cabinets on both sides for more storage). The dining area flows from the kitchen with high ceilings with a 2nd floor overlook. The second floor common area is very spacious that can be converted to a 4th bedroom.Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. Few minutes walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Enjoy worry-free living with lawn maintenance and snow removal (including your driveway and steps to the entry). Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights.Enjoy easy access to numerous year-round walking trails throughout the neighbourhood.Whether you're downsizing or raising a growing family, this exceptional home offers the perfect blend of comfort, convenience, and lifestyle. (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-19T19:50:55.275414+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-19T16:32:43Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:17Z"
+"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/29928698/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
+"OriginalEntryTimestamp": "2026-06-19T16:32:42.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1393129"
+"ListOfficeNationalAssociationId": "1482864"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928698')"
+"ID": "1548475"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1546922"
+post_author: 1
+"ListingKey": "29926813"
+"ListingId": "X13465286"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:30:32Z"
+"RFModificationTimestamp": "2026-06-21T12:32:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautiful corner unit open bright family home offers spacious layout throughout. The Master bedroom is on the main floor with a full ensuite, ideal for older home owners or families looking for comfort. Situated on a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. This unit has lots of natural lighting with soaring living room ceiling. The main floor starts with a formal living room or reading nook with a spacious powder room. The laundry/office is spacious behind the kitchen. The kitchen has stainless steel appliances, a quartz counter top, white cabinetry and an island (cabinets on both sides for more storage). The dining area flows from the kitchen with high ceilings with a 2nd floor overlook. The second floor common area is very spacious that can be converted to a 4th bedroom.Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. Few minutes walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Enjoy worry-free living with lawn maintenance and snow removal (including your driveway and steps to the entry). Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights.Enjoy easy access to numerous year-round walking trails throughout the neighbourhood.Whether you're downsizing or raising a growing family, this exceptional home offers the perfect blend of comfort, convenience, and lifestyle. (id:62783)"
+"Appliances": array:11 [
0 => "Refrigerator"
1 => "Water purifier"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T06:49:35.931020+00:00"
+"Directions": "Cross Streets: Erbsville Road / Laurelwood Drive. ** Directions: Erbsville Rd/Laurelwood drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T04:42:01Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T12:23:57Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4864"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926813/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-19T04:42:01.07Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926813')"
+"ID": "1546922"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1536566"
+post_author: 1
+"ListingKey": "29912368"
+"ListingId": "40840265"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T18:40:08Z"
+"RFModificationTimestamp": "2026-06-21T18:42:31Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:16:39.528562+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:11:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T18:32:15Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912368/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-16T20:51:08.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:48 [
0 => array:13 [ …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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912368')"
+"ID": "1536566"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T19:40:10Z"
+"RFModificationTimestamp": "2026-06-20T19:43:53Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T17:12:37Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T19:31:48Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 79
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]