array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29956800 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1571384"
+post_author: 1
+"ListingKey": "29956800"
+"ListingId": "40843284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T19:00:06Z"
+"RFModificationTimestamp": "2026-06-26T19:05:21Z"
+"ListPrice": 875000.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.5768597
1 => 43.4964463
]
+"Latitude": 43.4964463
+"Longitude": -80.5768597
+"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"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T13:40:39.835887+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-26T13:01:54Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T18:51:22Z"
+"Stories": "1.5"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/view/?s=3148434&nohit=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1668753828"
"RoomType" => "Laundry room"
"ListingId" => "40843284"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.1Z"
]
1 => array:11 [
"RoomKey" => "1668753829"
"RoomType" => "Bonus Room"
"ListingId" => "40843284"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.12Z"
]
2 => array:11 [
"RoomKey" => "1668753830"
"RoomType" => "Utility room"
"ListingId" => "40843284"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.13Z"
]
3 => array:11 [
"RoomKey" => "1668753831"
"RoomType" => "Recreation room"
"ListingId" => "40843284"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "25'1'' x 25'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.13Z"
]
4 => array:11 [
"RoomKey" => "1668753832"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843284"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.13Z"
]
5 => array:11 [
"RoomKey" => "1668753833"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843284"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.14Z"
]
6 => array:11 [
"RoomKey" => "1668753834"
"RoomType" => "Bedroom"
"ListingId" => "40843284"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.14Z"
]
7 => array:11 [
"RoomKey" => "1668753835"
"RoomType" => "Bedroom"
"ListingId" => "40843284"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.15Z"
]
8 => array:11 [
"RoomKey" => "1668753836"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843284"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "17'9'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.16Z"
]
9 => array:11 [
"RoomKey" => "1668753837"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843284"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.16Z"
]
10 => array:11 [
"RoomKey" => "1668753838"
"RoomType" => "Bedroom"
"ListingId" => "40843284"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.17Z"
]
11 => array:11 [
"RoomKey" => "1668753839"
"RoomType" => "Kitchen"
"ListingId" => "40843284"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.17Z"
]
12 => array:11 [
"RoomKey" => "1668753840"
"RoomType" => "Dining room"
"ListingId" => "40843284"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.18Z"
]
13 => array:11 [
"RoomKey" => "1668753841"
"RoomType" => "Living room"
"ListingId" => "40843284"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29956800"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 33'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:22.18Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956800/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 3
+"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-26T13:01:54.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29956800_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/22e587e5c83a7bad77a17c8c459b59cf.webp"
"MediaSize" => 126562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-22e587e5c83a7bad77a17c8c459b59cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29956800_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/877ad75296d8f6411cdd48e21ba00c29.webp"
"MediaSize" => 116910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-877ad75296d8f6411cdd48e21ba00c29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2 Storey home"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29956800_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/0c0c028fc4305ac2534ef0f85598bae5.webp"
"MediaSize" => 136960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-0c0c028fc4305ac2534ef0f85598bae5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2 Storey home"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29956800_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/05b9d4b9e1b32d2fd5415004ab86582e.webp"
"MediaSize" => 137908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-05b9d4b9e1b32d2fd5415004ab86582e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29956800_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/f5f7503a07e434f321cca74e4a751d9a.webp"
"MediaSize" => 78253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-f5f7503a07e434f321cca74e4a751d9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen renovation completed by Millbank Custom Kitchens."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29956800_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/bb679aa2128615bf378d9bc4e0fc8cb0.webp"
"MediaSize" => 88279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-bb679aa2128615bf378d9bc4e0fc8cb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen renovation completed by Millbank Custom Kitchens."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29956800_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/e44ef3ecee3aa05cacca03fb8b58a022.webp"
"MediaSize" => 77188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-e44ef3ecee3aa05cacca03fb8b58a022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen renovation completed by Millbank Custom Kitchens."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29956800_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/b6eb0664b0530274e0f971b749b81a24.webp"
"MediaSize" => 70158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-b6eb0664b0530274e0f971b749b81a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen renovation completed by Millbank Custom Kitchens."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29956800_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/fdc1e17b3f448467ef55ddbc9ae3565a.webp"
"MediaSize" => 68302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-fdc1e17b3f448467ef55ddbc9ae3565a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29956800_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/2f241ae7d85d0bef5f4f73be3b4efb0b.webp"
"MediaSize" => 97437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-2f241ae7d85d0bef5f4f73be3b4efb0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29956800_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/05a39dafdb73805ecf6caab196d7ed16.webp"
"MediaSize" => 97859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-05a39dafdb73805ecf6caab196d7ed16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29956800_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/6e8cbb737a04fc3d538700939c861190.webp"
"MediaSize" => 90500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-6e8cbb737a04fc3d538700939c861190.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29956800_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/d8ea453545db6bc858bb74b8a2d1926e.webp"
"MediaSize" => 84582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-d8ea453545db6bc858bb74b8a2d1926e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29956800_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/78f53905b8f344dbe75446f94e969b93.webp"
"MediaSize" => 82930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-78f53905b8f344dbe75446f94e969b93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29956800_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/d2512b9389ac784f9e2c80517dd5aa05.webp"
"MediaSize" => 86941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-d2512b9389ac784f9e2c80517dd5aa05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29956800_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/c1007dca108ceae04268b28484488d84.webp"
"MediaSize" => 74255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-c1007dca108ceae04268b28484488d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29956800_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/de2b6c8d80027133b0227fd778171106.webp"
"MediaSize" => 80606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-de2b6c8d80027133b0227fd778171106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29956800_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/e7e02f31bab05b76c4187d2772acb407.webp"
"MediaSize" => 62538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-e7e02f31bab05b76c4187d2772acb407.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29956800_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/9b40d74f8d7792e31dfbbd3c0382e933.webp"
"MediaSize" => 66682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-9b40d74f8d7792e31dfbbd3c0382e933.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29956800_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/d90f57f116e35da1ee1f5af0fced2864.webp"
"MediaSize" => 60715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-d90f57f116e35da1ee1f5af0fced2864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor full bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29956800_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/b2ec928095141520e8c832bcbabb7c24.webp"
"MediaSize" => 47140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-b2ec928095141520e8c832bcbabb7c24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor full bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29956800_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/1f01b2ae6108315ef8df499e2ed4af4f.webp"
"MediaSize" => 75730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-1f01b2ae6108315ef8df499e2ed4af4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29956800_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/3c262580cda6bc7f6bf57221c83e8a61.webp"
"MediaSize" => 78794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-3c262580cda6bc7f6bf57221c83e8a61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29956800_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/ee2bcd25ca1b53a7e72fb26e71e0cefa.webp"
"MediaSize" => 66492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-ee2bcd25ca1b53a7e72fb26e71e0cefa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29956800_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/15e7933e7ab5ce6adc2b48b6ac3d39f2.webp"
"MediaSize" => 63206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-15e7933e7ab5ce6adc2b48b6ac3d39f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29956800_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/3cf5aba3029ae9a6f0bf2b3b06bdb4dc.webp"
"MediaSize" => 68375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-3cf5aba3029ae9a6f0bf2b3b06bdb4dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29956800_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/935e6139c2f0234e160e6bf6dd98fc78.webp"
"MediaSize" => 57506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-935e6139c2f0234e160e6bf6dd98fc78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29956800_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/a8d771699337052c21c98177648b1018.webp"
"MediaSize" => 61272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-a8d771699337052c21c98177648b1018.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29956800_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/bb02608a729700a32caf79c920cc7a1d.webp"
"MediaSize" => 60832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-bb02608a729700a32caf79c920cc7a1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29956800_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/f7e3d5ec56032df3de36eea0e270d4ff.webp"
"MediaSize" => 74313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-f7e3d5ec56032df3de36eea0e270d4ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29956800_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/e166448c0556bdc13b7aa4d619b8a12f.webp"
"MediaSize" => 67177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-e166448c0556bdc13b7aa4d619b8a12f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29956800_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/278dc57c7eb1eefcdfdb3308cdf2fe45.webp"
"MediaSize" => 67444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-278dc57c7eb1eefcdfdb3308cdf2fe45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29956800_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/517847129ed56c831b815293ef78b79c.webp"
"MediaSize" => 146486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-517847129ed56c831b815293ef78b79c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29956800_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/f115ad5e6fd693ac52a8fd8ff8eeee4a.webp"
"MediaSize" => 137988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-f115ad5e6fd693ac52a8fd8ff8eeee4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29956800_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/0cfe0833793eeb5423e2da5bc4bbf5da.webp"
"MediaSize" => 148351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-0cfe0833793eeb5423e2da5bc4bbf5da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29956800_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/06eb8e8e102cb1383295d7b76d184a43.webp"
"MediaSize" => 167456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-06eb8e8e102cb1383295d7b76d184a43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29956800_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/2f70a1d04e7e2dd41a3fb5418303cdf6.webp"
"MediaSize" => 167585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-2f70a1d04e7e2dd41a3fb5418303cdf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29956800_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/b9d47bc60a058534a003b9aa101da251.webp"
"MediaSize" => 144563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-b9d47bc60a058534a003b9aa101da251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29956800_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/e91a16e30850331908a5c900d466bcba.webp"
"MediaSize" => 148540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-e91a16e30850331908a5c900d466bcba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29956800_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/45b108f48b5fc0ecff5218691164531d.webp"
"MediaSize" => 137074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-45b108f48b5fc0ecff5218691164531d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29956800_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/23fcc46e2f13d1b9d3bfaad75d635d28.webp"
"MediaSize" => 75586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-23fcc46e2f13d1b9d3bfaad75d635d28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29956800_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956800/c4cfbb3f0de637acdf838f5c9ab391d2.webp"
"MediaSize" => 134699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956800/thumbnail-c4cfbb3f0de637acdf838f5c9ab391d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom ramp and stair entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843284"
"ResourceRecordKey" => "29956800"
"ModificationTimestamp" => "2026-06-26T13:01:54.38Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956800')"
+"ID": "1571384"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24907
+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 1990854" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24876
+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 '29956800'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269
+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 '29956800'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31663459"
+"ListingKey": "29956800"
+"ListingId": "40843284"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T17:22:36Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31663459')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31670395"
+"ListingKey": "29956800"
+"ListingId": "40843284"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T11:49:29Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31670395')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29956800' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5768597 43.4964463)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25362
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1566184"
+post_author: 1
+"ListingKey": "29947549"
+"ListingId": "40842250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T17:40:59Z"
+"RFModificationTimestamp": "2026-06-26T01:56:27Z"
+"ListPrice": 725000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2273.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H4"
+"UnparsedAddress": "658 ELLESMERE Court, Waterloo, Ontario N2V2H4"
+"Coordinates": array:2 [
0 => -80.5729223
1 => 43.4973152
]
+"Latitude": 43.4973152
+"Longitude": -80.5729223
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful Thomas built Executive FREEHOLD Townhome. The bungalow feature makes it wonderful for anyone thinking of downsizing. Open concept living room and dining. Look through Galley kitchen for wonderful entertaining purposes. Backing onto the trans Canada Trail. Home is located on a wonderful cul-de-sac location in the quiet area of conservation Meadows. Parking for four cars, including a double car garage. All appliances included. Entrance to rear yard and deck off living. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:56:05.034971+00:00"
+"Directions": "OFF LAKE LOUISE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T17:11:16Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T17:31:52Z"
+"Stories": "1.0"
+"StreetName": "ELLESMERE"
+"StreetNumber": "658"
+"StreetSuffix": "Court"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4497.29"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/658-Ellesmere-Ct"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1667014725"
"RoomType" => "Cold room"
"ListingId" => "40842250"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.56Z"
]
1 => array:11 [
"RoomKey" => "1667014726"
"RoomType" => "Other"
"ListingId" => "40842250"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "24'1'' x 45'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.56Z"
]
2 => array:11 [
"RoomKey" => "1667014727"
"RoomType" => "1pc Bathroom"
"ListingId" => "40842250"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
3 => array:11 [
"RoomKey" => "1667014728"
"RoomType" => "Kitchen"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
4 => array:11 [
"RoomKey" => "1667014729"
"RoomType" => "Dining room"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
5 => array:11 [
"RoomKey" => "1667014730"
"RoomType" => "Living room"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
6 => array:11 [
"RoomKey" => "1667014731"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
7 => array:11 [
"RoomKey" => "1667014732"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
8 => array:11 [
"RoomKey" => "1667014733"
"RoomType" => "Bedroom"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
9 => array:11 [
"RoomKey" => "1667014734"
"RoomType" => "Foyer"
"ListingId" => "40842250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947549"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:31:52.57Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947549/658-ellesmere-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "RB"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1133
+"BelowGradeFinishedArea": 1140
+"OriginalEntryTimestamp": "2026-06-24T17:11:15.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29947549_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/4bece924b29c9ee7661ab8d19b319f42.webp"
"MediaSize" => 104839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947549/thumbnail-4bece924b29c9ee7661ab8d19b319f42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842250"
"ResourceRecordKey" => "29947549"
"ModificationTimestamp" => "2026-06-24T17:11:15.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29947549_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/7967dfe83008290edaa46ab91833067b.webp"
"MediaSize" => 125264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947549/thumbnail-7967dfe83008290edaa46ab91833067b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842250"
"ResourceRecordKey" => "29947549"
"ModificationTimestamp" => "2026-06-24T17:11:15.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29947549_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/42f283f82e32e208bf40d8090423de90.webp"
"MediaSize" => 98517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947549/thumbnail-42f283f82e32e208bf40d8090423de90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842250"
"ResourceRecordKey" => "29947549"
"ModificationTimestamp" => "2026-06-24T17:11:15.96Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29947549_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/81a1874483c91641401d4f1912810051.webp"
"MediaSize" => 109686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947549/thumbnail-81a1874483c91641401d4f1912810051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842250"
"ResourceRecordKey" => "29947549"
"ModificationTimestamp" => "2026-06-24T17:11:15.96Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29947549_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/9bab667b25c586fc2a6628a4dbffe2f1.webp"
"MediaSize" => 138217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947549/thumbnail-9bab667b25c586fc2a6628a4dbffe2f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842250"
"ResourceRecordKey" => "29947549"
"ModificationTimestamp" => "2026-06-24T17:11:15.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29947549_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947549/af2fd9f259e2945baffab273018ee8c3.webp"
"MediaSize" => 72153
"MediaType" => "webp"
…8
]
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947549')"
+"ID": "1566184"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1565600"
+post_author: 1
+"ListingKey": "29947558"
+"ListingId": "40841264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:00:19Z"
+"RFModificationTimestamp": "2026-06-26T01:05:49Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.5885442
1 => 43.4909309
]
+"Latitude": 43.4909309
+"Longitude": -80.5885442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30 electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62783)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:04:27.455329+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": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:53:43Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:53:43Z"
+"Stories": "1.0"
+"StreetName": "RIDEAU RIVER"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947558/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 799
+"OriginalEntryTimestamp": "2026-06-24T17:11:26.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947558')"
+"ID": "1565600"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1565101"
+post_author: 1
+"ListingKey": "29946711"
+"ListingId": "X13483494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:05:05Z"
+"RFModificationTimestamp": "2026-06-25T20:28:54Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.588549
1 => 43.49095
]
+"Latitude": 43.49095
+"Longitude": -80.588549
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30" electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:66098)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:21:03.319748+00:00"
+"Directions": "Conservation Dr & Rideau River St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962651"
+"ListOfficeKey": "293196"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 101.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:56:17Z"
+"Stories": "1.0"
+"StreetName": "Rideau River"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29946711/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1834162"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1899457"
+"CoListOfficeKey": "293196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "292096"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-24T15:34:32.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1252137"
+"ListOfficeNationalAssociationId": "1423680"
+"CoListAgentNationalAssociationId": "1196633"
+"CoListAgentNationalAssociationId2": "1216506"
+"CoListOfficeNationalAssociationId": "1423680"
+"CoListOfficeNationalAssociationId2": "1408169"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946711')"
+"ID": "1565101"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1562913"
+post_author: 1
+"ListingKey": "29951568"
+"ListingId": "40842931"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:14Z"
+"RFModificationTimestamp": "2026-06-25T20:04:15Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2385.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A4"
+"UnparsedAddress": "464 NORTHLAKE Drive, Waterloo, Ontario N2V2A4"
+"Coordinates": array:2 [
0 => -80.566943
1 => 43.497345
]
+"Latitude": 43.497345
+"Longitude": -80.566943
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 464 Northlake Drive, Waterloo – nothing to do but move in and enjoy this fully updated home! From the windows to the kitchen, flooring, bathrooms, and more, this 3-bedroom, 3-bathroom home has been extensively updated throughout. Step inside through the welcoming foyer with a convenient coat closet. The renovated kitchen is designed for both style and function, featuring quartz countertops, a beautiful backsplash, ample workspace, and room for a large island. The dining area flows seamlessly into the bright living room with impressive vaulted ceilings, creating an open and airy space ideal for everyday living and entertaining. A fireplace rough-in is already in place, offering the option to add a cozy focal point. From the kitchen, step out to the professionally landscaped, fully fenced backyard complete with a spacious deck, perfect for summer gatherings. New flooring and carpeting throughout provide a fresh, move-in-ready feel. A convenient 2-piece bathroom completes the main floor. Upstairs, the spacious primary bedroom features a walk-in closet with custom California Closets organizers and a beautifully updated 3-piece ensuite. Two additional bedrooms, both with custom closet organizers, and an updated 4-piece bathroom complete the upper level. The finished basement adds valuable living space with a large recreation room ideal for a family room, games area, home gym, or home office. A rough-in for a future 4-piece bathroom offers added potential. Additional updates include attic insulation, doors, furnace, air conditioner, water softener and hot water heater for improved efficiency and peace of mind. Outside, enjoy an aggregate driveway with parking for two vehicles and a double attached garage. Located in a desirable Waterloo neighbourhood close to parks, schools, shopping, and amenities, this home offers modern updates, comfort, and outstanding value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"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-25T20:04:02.027755+00:00"
+"Directions": "Conservation Drive to Northlake"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T15:11:20Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:44Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "464"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5729.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/464_northlake_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951568/464-northlake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1625
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-25T15:11:20.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951568')"
+"ID": "1562913"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1557723"
+post_author: 1
+"ListingKey": "29942117"
+"ListingId": "40841769"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:41:21Z"
+"RFModificationTimestamp": "2026-06-23T17:49:50Z"
+"ListPrice": 1289000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2857.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G4"
+"UnparsedAddress": "667 FERN Road, Waterloo, Ontario N2V1G4"
+"Coordinates": array:2 [
0 => -80.5596766
1 => 43.500152
]
+"Latitude": 43.500152
+"Longitude": -80.5596766
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Lakeshore North! Set on an impressive 69' x 159' mature, forested lot, this beautifully updated 4 bedroom home offers an incredible backyard oasis with a heated saltwater pool & hot tub surrounded by hardwood forest. The tranquil setting provides exceptional privacy, low maintenance landscaping & the perfect place to spend the summer relaxing, hosting family & friends, BBQing and entertaining. Inside you will find a spacious & functional layout with extensive upgrades! The kitchen is the heart of the home with an incredible 12 foot quartz island, gas stove, double ovens, updated stainless appliances, & a separate granite coffee & wine bar complete with a second sink, wine fridge & more cabinetry. The dining area is open to the cozy family room with engineered hardwood floors, overlooking the backyard with a wood burning fireplace & walkout to the deck. An additional living room provides even more space, open to the kitchen steps from the 2 pc bath and main floor laundry room. Upstairs you will find a primary bedroom with spa-like ensuite bath, 4 large bedrooms and & another renovated 4 piece bath, this is truly a family home! The finished basement offers a huge rec room with gas fireplace, 2 pc bath and spacious workshop for the woodworker or hobbyist. Many updates, including roof (2021), attic and cold cellar insulation (2018), owned water heater (2019), driveway restoration (2024), eavestroughs, soffits and leaf guards (2021), bathrooms (2024/2025). The backyard retreat has been improved with a new pool liner and heater (2024), pool pump (2026), pool cover (2025), hot tub (2024). Exceptional location, waking distance to Northlake Woods PS, nature trails, St Jacobs Farmer's Market, shopping and all amenities plus moments from expressway access. Combining modern updates, timeless character, and a spectacular natural setting, this is your chance to own a move-in-ready home on one of Lakeshore North's most desirable oversized lots. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:49:42.644745+00:00"
+"Directions": "Northlake Drive to Fern Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909721"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T17:00:08Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:00:08Z"
+"Stories": "2.0"
+"StreetName": "FERN"
+"StreetNumber": "667"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7439"
+"VirtualTourURLUnbranded": "https://667fern.com/idx"
+"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/29942117/667-fern-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172119"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "77518"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2181
+"BelowGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-06-23T16:51:25.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1222004"
+"ListOfficeNationalAssociationId": "1186916"
+"CoListAgentNationalAssociationId": "1422636"
+"CoListOfficeNationalAssociationId": "1186916"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942117')"
+"ID": "1557723"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"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 [ …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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939876')"
+"ID": "1556233"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917845')"
+"ID": "1552069"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1551580"
+post_author: 1
+"ListingKey": "29932825"
+"ListingId": "40839561"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:00:03Z"
+"RFModificationTimestamp": "2026-06-25T18:07:59Z"
+"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:62650)"
+"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-25T17:53:02Z"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932825')"
+"ID": "1551580"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1551024"
+post_author: 1
+"ListingKey": "29932336"
+"ListingId": "X13470220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T12:25:19Z"
+"RFModificationTimestamp": "2026-06-27T12:30:00Z"
+"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:62650)"
+"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-26T17:49:09Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T12:16:36Z"
+"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:18 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932336')"
+"ID": "1551024"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 60
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]