array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30029200 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1622277"
+post_author: 1
+"ListingKey": "30029200"
+"ListingId": "X13559688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "904 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 bed, 1 bath condo showcasing a bright, open-concept design with modern finishes throughout. Featuring an upgraded kitchen with stainless steel appliances, a spacious island with built-in storage, and elegant pendant lighting, this unit flows effortlessly into the sun-filled living area with expansive windows and beautiful views. The generous bedroom is complemented by a contemporary 4-piece bath and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Enjoy premium building amenities including a party room, gym, rooftop patios, and bike storage. Ideally located in the sought-after Waterdown community, just minutes to dining, shopping, parks, and a quick 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-14T06:44:12.429132+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1683787670"
"RoomType" => "Bedroom"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "30029200"
"RoomLength" => 2.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
1 => array:11 [
"RoomKey" => "1683787671"
"RoomType" => "Great room"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 5.92
"ListingKey" => "30029200"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
2 => array:11 [
"RoomKey" => "1683787672"
"RoomType" => "Kitchen"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "30029200"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029200/904-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentia"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.26Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30029200_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a5fbd58071f9ee559ada8f443103c4f0.webp"
"MediaSize" => 221553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a5fbd58071f9ee559ada8f443103c4f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30029200_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/238c77be84a5a934016e90a9a957bf15.webp"
"MediaSize" => 205608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-238c77be84a5a934016e90a9a957bf15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30029200_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a13611ec1b2ccd0fcc9cb08ec598bdfe.webp"
"MediaSize" => 206558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a13611ec1b2ccd0fcc9cb08ec598bdfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30029200_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/dbe9fd4a63e2286b1314bca98af3b813.webp"
"MediaSize" => 176913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-dbe9fd4a63e2286b1314bca98af3b813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30029200_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/6c7cd0094c63d7cf51aee7a4a4d84c15.webp"
"MediaSize" => 147361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-6c7cd0094c63d7cf51aee7a4a4d84c15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30029200_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/cf138a0f8630de6094ec34fc105c8b43.webp"
"MediaSize" => 119587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-cf138a0f8630de6094ec34fc105c8b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30029200_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/831f72d64cfec68920d67c299c179d5b.webp"
"MediaSize" => 107254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-831f72d64cfec68920d67c299c179d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30029200_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a7d36eebe17e3e9955e566f34c249486.webp"
"MediaSize" => 113240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a7d36eebe17e3e9955e566f34c249486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30029200_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/9fe12c8fd404c0f09242c47834a959e1.webp"
"MediaSize" => 97970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-9fe12c8fd404c0f09242c47834a959e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30029200_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/34bde3859efdee862f502b1de8f9d040.webp"
"MediaSize" => 142439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-34bde3859efdee862f502b1de8f9d040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30029200_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/efc9c2d804f7a70e6879c70ce0b27b03.webp"
"MediaSize" => 96334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-efc9c2d804f7a70e6879c70ce0b27b03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30029200_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/918d6f5bfd88efddfd5ca1890819f11c.webp"
"MediaSize" => 117586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-918d6f5bfd88efddfd5ca1890819f11c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30029200_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/8bca9f07744b51da761bb381a8407c4c.webp"
"MediaSize" => 131488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-8bca9f07744b51da761bb381a8407c4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30029200_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/2cc9e294311adfaf22769956074028f1.webp"
"MediaSize" => 145957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-2cc9e294311adfaf22769956074028f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30029200_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/756b3b2feffb0d336d0e96d9cbfbf07f.webp"
"MediaSize" => 128183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-756b3b2feffb0d336d0e96d9cbfbf07f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30029200_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/96204354fdd01b7a3990d0757708561e.webp"
"MediaSize" => 127767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-96204354fdd01b7a3990d0757708561e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30029200_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/fdfd332fbc37107c0a7a713418c48fd5.webp"
"MediaSize" => 137317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-fdfd332fbc37107c0a7a713418c48fd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30029200_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/2fc25df56b2d2f734feacd81a708e19f.webp"
"MediaSize" => 168199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-2fc25df56b2d2f734feacd81a708e19f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30029200_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/27a7d2ecbbf44081dae9405e5160847a.webp"
"MediaSize" => 202497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-27a7d2ecbbf44081dae9405e5160847a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30029200_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/b6372b4a8d3bfaf11dc3e9df2a89bacf.webp"
"MediaSize" => 140664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-b6372b4a8d3bfaf11dc3e9df2a89bacf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30029200_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/3bb1c45ddc9a3f5168ac068267ced992.webp"
"MediaSize" => 104873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-3bb1c45ddc9a3f5168ac068267ced992.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30029200_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/cc5d5f4d39faf3d4eaedeec0abd743e1.webp"
"MediaSize" => 104249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-cc5d5f4d39faf3d4eaedeec0abd743e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30029200_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/12e2c21a055a702240c4ecab11a8b40d.webp"
"MediaSize" => 81649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-12e2c21a055a702240c4ecab11a8b40d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30029200_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/58057845e6f3c7e59fc3f806eb984d0f.webp"
"MediaSize" => 97794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-58057845e6f3c7e59fc3f806eb984d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029200')"
+"ID": "1622277"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 284790" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24951
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24895
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "184006"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284790"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "502 BRANT ST #1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7R2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344892"
+"OriginalEntryTimestamp": "2019-02-27T19:51:00Z"
+"OfficeFax": "905-631-5445"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1499122"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284790')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2092595" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24905
+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 '30029200'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30029200' AND OpenHouseDate ge '2026-07-13'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30029200' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25304
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1622278"
+post_author: 1
+"ListingKey": "30029198"
+"ListingId": "X13559668"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "804 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 1 bed, 1 bath condo offering a bright, open-concept layout with modern finishes throughout. The stylish kitchen features stainless steel appliances, a breakfast bar, and contemporary cabinetry, flowing effortlessly into the spacious living area with large windows and plenty of natural light. The well-sized bedroom offers comfort and great views, complemented by a sleek 4-piece bathroom and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Residents have access to excellent amenities including a party room, gym, rooftop patios, and bike storage. Located in the highly desirable Waterdown community, close to dining, shopping, schools, parks, and just a 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-14T06:44:11.804722+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1683787667"
"RoomType" => "Kitchen"
"ListingId" => "X13559668"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "30029198"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.11Z"
]
1 => array:11 [
"RoomKey" => "1683787668"
"RoomType" => "Bedroom"
"ListingId" => "X13559668"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "30029198"
"RoomLength" => 2.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.11Z"
]
2 => array:11 [
"RoomKey" => "1683787669"
"RoomType" => "Great room"
"ListingId" => "X13559668"
"RoomLevel" => "Main level"
"RoomWidth" => 5.92
"ListingKey" => "30029198"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.11Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029198/804-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30029198_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/728b007b58536b7cc6692333e7b418d9.webp"
"MediaSize" => 221553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-728b007b58536b7cc6692333e7b418d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30029198_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/40b71678da9c954ce7fe87b419058a06.webp"
"MediaSize" => 205608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-40b71678da9c954ce7fe87b419058a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30029198_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/48afda0eb2f5220a51e170b5cbf8e8e5.webp"
"MediaSize" => 206558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-48afda0eb2f5220a51e170b5cbf8e8e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30029198_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/b57e025e75f057d52d3df06d7977d798.webp"
"MediaSize" => 176913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-b57e025e75f057d52d3df06d7977d798.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30029198_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/a1107993c0828ea221b387a088ec5561.webp"
"MediaSize" => 147361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-a1107993c0828ea221b387a088ec5561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30029198_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/9bfaf2a5b439befc2a5d52626f1e91ec.webp"
"MediaSize" => 127012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-9bfaf2a5b439befc2a5d52626f1e91ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30029198_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/07b3c1c50eaafe42e31145791bb059cd.webp"
"MediaSize" => 111434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-07b3c1c50eaafe42e31145791bb059cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30029198_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/ea294bc6cc56cf8dd459a297e198d68c.webp"
"MediaSize" => 125724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-ea294bc6cc56cf8dd459a297e198d68c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30029198_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/152d0abab16fc97872db634b39a8a37e.webp"
"MediaSize" => 98968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-152d0abab16fc97872db634b39a8a37e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30029198_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/ebb06bcca823a0cb39a691b0fa9dc873.webp"
"MediaSize" => 134578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-ebb06bcca823a0cb39a691b0fa9dc873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30029198_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/c70a28bb3acc83784e4b00d044b5fd6e.webp"
"MediaSize" => 107342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-c70a28bb3acc83784e4b00d044b5fd6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30029198_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/dacf406e047b9ca9d59e55334a13e64c.webp"
"MediaSize" => 113455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-dacf406e047b9ca9d59e55334a13e64c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30029198_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/17bffb308a8a1422c5526854dd310447.webp"
"MediaSize" => 127632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-17bffb308a8a1422c5526854dd310447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30029198_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/b4725a3d5d09fd5d7d0c1dfe9b66c5d8.webp"
"MediaSize" => 148244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-b4725a3d5d09fd5d7d0c1dfe9b66c5d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30029198_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/da4d3786b34e480da07f9d9ad3c97b25.webp"
"MediaSize" => 124772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-da4d3786b34e480da07f9d9ad3c97b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30029198_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/ea7d83a2bcd8acddfb7bbbdb63b5220d.webp"
"MediaSize" => 136896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-ea7d83a2bcd8acddfb7bbbdb63b5220d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30029198_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/e9ac37ea0ef679775d938de1bdf6deb0.webp"
"MediaSize" => 153531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-e9ac37ea0ef679775d938de1bdf6deb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30029198_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/aa601ff8867fca5b049c232cd28e256c.webp"
"MediaSize" => 196064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-aa601ff8867fca5b049c232cd28e256c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30029198_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/da2a85fe9fe12c7ddfa6dde71f2c6e7a.webp"
"MediaSize" => 126853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-da2a85fe9fe12c7ddfa6dde71f2c6e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30029198_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/52e3a779f66f310151f202d63aa77a09.webp"
"MediaSize" => 116317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-52e3a779f66f310151f202d63aa77a09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30029198_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/f562f09f82aa8872041894882f9877a1.webp"
"MediaSize" => 96513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-f562f09f82aa8872041894882f9877a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30029198_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029198/29cb7119988f4b2c3c092824e2180e38.webp"
"MediaSize" => 131901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029198/thumbnail-29cb7119988f4b2c3c092824e2180e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559668"
"ResourceRecordKey" => "30029198"
"ModificationTimestamp" => "2026-07-14T05:07:37.08Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029198')"
+"ID": "1622278"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1620942"
+post_author: 1
+"ListingKey": "30027846"
+"ListingId": "X13558740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:50:04Z"
+"RFModificationTimestamp": "2026-07-13T22:43:29Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.891184
1 => 43.331196
]
+"Latitude": 43.331196
+"Longitude": -79.891184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:43:18.555618+00:00"
+"Directions": "Cross Streets: Flamboro St. and Barton St. ** Directions: Take Highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Flat site"
3 => "Carpet Free"
]
+"LotSizeDimensions": "68.1 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T21:40:18Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T21:40:18Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1683427178"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.44
"ListingKey" => "30027846"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
1 => array:11 [
"RoomKey" => "1683427179"
"RoomType" => "Laundry room"
"ListingId" => "X13558740"
"RoomLevel" => "Basement"
"RoomWidth" => 3.18
"ListingKey" => "30027846"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
2 => array:11 [
"RoomKey" => "1683427180"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13558740"
"RoomLevel" => "Basement"
"RoomWidth" => 3.8
"ListingKey" => "30027846"
"RoomLength" => 5.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
3 => array:11 [
"RoomKey" => "1683427181"
"RoomType" => "Bedroom 2"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.47
"ListingKey" => "30027846"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
4 => array:11 [
"RoomKey" => "1683427182"
"RoomType" => "Bedroom 3"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "30027846"
"RoomLength" => 2.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
5 => array:11 [
"RoomKey" => "1683427183"
"RoomType" => "Living room"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.47
"ListingKey" => "30027846"
"RoomLength" => 5.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
6 => array:11 [
"RoomKey" => "1683427184"
"RoomType" => "Dining room"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "30027846"
"RoomLength" => 2.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
7 => array:11 [
"RoomKey" => "1683427185"
"RoomType" => "Kitchen"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 4.02
"ListingKey" => "30027846"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
8 => array:11 [
"RoomKey" => "1683427186"
"RoomType" => "Bathroom"
"ListingId" => "X13558740"
"RoomLevel" => "Main level"
"RoomWidth" => 2.83
"ListingKey" => "30027846"
"RoomLength" => 2.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
9 => array:11 [
"RoomKey" => "1683427187"
"RoomType" => "Bedroom 4"
"ListingId" => "X13558740"
"RoomLevel" => "Basement"
"RoomWidth" => 2.82
"ListingKey" => "30027846"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.73Z"
]
10 => array:11 [
"RoomKey" => "1683427188"
"RoomType" => "Utility room"
"ListingId" => "X13558740"
"RoomLevel" => "Basement"
"RoomWidth" => 3.67
"ListingKey" => "30027846"
"RoomLength" => 8.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.74Z"
]
11 => array:11 [
"RoomKey" => "1683427189"
"RoomType" => "Bathroom"
"ListingId" => "X13558740"
"RoomLevel" => "Basement"
"RoomWidth" => 3.13
"ListingKey" => "30027846"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T21:40:18.74Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30027846/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-13T21:40:18.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30027846_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/4e102971a795096b9b31e6d2209e916e.webp"
"MediaSize" => 488263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-4e102971a795096b9b31e6d2209e916e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30027846_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/872be179d67c7e292d95325b23b66560.webp"
"MediaSize" => 407138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-872be179d67c7e292d95325b23b66560.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30027846_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/a9f4f3e1739a0417bb4b5c78c51ae52d.webp"
"MediaSize" => 178214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-a9f4f3e1739a0417bb4b5c78c51ae52d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30027846_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/2b0d2c8646e301d511bc09aa7cc53b71.webp"
"MediaSize" => 187871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-2b0d2c8646e301d511bc09aa7cc53b71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30027846_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/b458d531f9399aec87b1a20a787a592f.webp"
"MediaSize" => 231060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-b458d531f9399aec87b1a20a787a592f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30027846_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/b2338decd0e6e52fc5b9fe4fd188cdff.webp"
"MediaSize" => 234530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-b2338decd0e6e52fc5b9fe4fd188cdff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30027846_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/eb18c41f4f2c0898d5a6a0684a58c4d2.webp"
"MediaSize" => 245414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-eb18c41f4f2c0898d5a6a0684a58c4d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30027846_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/c0a0840178b4b1acec6c0e1f399b0795.webp"
"MediaSize" => 200446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-c0a0840178b4b1acec6c0e1f399b0795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30027846_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/46ffdc8a2b0826896318240d7e343c59.webp"
"MediaSize" => 221203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-46ffdc8a2b0826896318240d7e343c59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30027846_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/d0dca7819370105512612f17bddefa16.webp"
"MediaSize" => 173837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-d0dca7819370105512612f17bddefa16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30027846_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027846/de6ca9cde9693c47eb54230a1d91783c.webp"
"MediaSize" => 253235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027846/thumbnail-de6ca9cde9693c47eb54230a1d91783c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13558740"
"ResourceRecordKey" => "30027846"
"ModificationTimestamp" => "2026-07-13T21:40:18.71Z"
]
11 => array:13 [
"Order" => 12
…12
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:25:18Z"
+"RFModificationTimestamp": "2026-07-13T21:46:42Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8912452
1 => 43.3312034
]
+"Latitude": 43.3312034
+"Longitude": -79.8912452
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T21:46:37.455766+00:00"
+"Directions": "Take highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024789"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-13T21:18:11Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T21:18:11Z"
+"Stories": "1.0"
+"StreetName": "FLAMBORO"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027582/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2026-07-13T21:18:11.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304516"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063598"
+"CoListOfficeNationalAssociationId": "1325425"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1616966"
+post_author: 1
+"ListingKey": "30021444"
+"ListingId": "X13552446"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T12:15:17Z"
+"RFModificationTimestamp": "2026-07-11T19:04:31Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 10.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L4B1W8"
+"UnparsedAddress": "44 GOLDEN HAWK DRIVE, Hamilton (Waterdown), Ontario L4B1W8"
+"Coordinates": array:2 [
0 => -79.8808833
1 => 43.3336484
]
+"Latitude": 43.3336484
+"Longitude": -79.8808833
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "unique opportunity for a family looking for an upgraded quality home in an exceptional and mature neighbourhood! Excellent layout 5 bedroom, 4 bathroom home, with a w/o basement backing onto a pond!150k spent on upgrades.10-foot ceilings, Modern Kitchen with S/S Appliances, Quartz countertop &Backsplash, Central Island, Open Concept living/Dinning with Pot Lights & Crown Moulding,Hardwood Floor, New Upgrade Bathrooms,freshly Painted, new light fixtures, gas fireplace, Shangri-La Curtains, Interlock Driveway,R-In Cvac etc. Basement potential rent $2200/month.Very Private Backyard, No Sidewalk. Close To Go Train,407/QEW,school,park. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Dryer"
2 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-11T19:04:11.527911+00:00"
+"Directions": "Cross Streets: Dundas St E/Burke St. ** Directions: Dundas st to Burke st toGolden Hawk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1639389"
+"ListOfficeKey": "91727"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "46.9 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T12:06:39Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T12:06:39Z"
+"Stories": "2.0"
+"StreetName": "Golden Hawk"
+"StreetNumber": "44"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10393.89"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021444/44-golden-hawk-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-07-11T12:06:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1164665"
+"ListOfficeNationalAssociationId": "1155942"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021444')"
+"ID": "1616966"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1616967"
+post_author: 1
+"ListingKey": "30021880"
+"ListingId": "40847301"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T16:25:16Z"
+"RFModificationTimestamp": "2026-07-11T19:00:18Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2184.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "22 SPRING CREEK Drive Unit# 33, Waterdown, Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.8789989
1 => 43.3464788
]
+"Latitude": 43.3464788
+"Longitude": -79.8789989
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful freehold end-unit townhome in Waterdown, where thoughtful upgrades, generous living space, and everyday comfort come together perfectly. Offering 3 bedrooms and 2.5 bathrooms, this impressive home features a separate formal dining room and a bright, inviting great room with a dedicated breakfast area. Hardwood flooring, elegant crown moulding, and California shutters add warmth and character throughout the main level. At the heart of the home is a stunning kitchen designed to impress, complete with quartz countertops, a stylish backsplash, and under-cabinet lighting. Upstairs, retreat to the spacious primary bedroom featuring a spa-inspired ensuite with a double-sink quartz vanity, walk-in shower, and relaxing soaker tub. Two additional bedrooms and convenient upper-level laundry complete the second floor. The finished basement provides valuable additional living space with custom storage cabinetry, while the beautifully landscaped backyard features a premium 16' x 16' composite deck, perfect for entertaining or unwinding outdoors. Ideally located close to trails, parks, the GO Station, and major highways including the 403, 407, and QEW, this is the perfect opportunity to enjoy the charm of Waterdown with exceptional commuter convenience. A stylish, spacious, move-in-ready home you don't want to miss! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T19:00:11.638969+00:00"
+"Directions": "Dundas St. to Spring Creek Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2169171"
+"ListOfficeKey": "283890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-11T16:18:14Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T16:18:14Z"
+"Stories": "2.0"
+"StreetName": "SPRING CREEK"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6860"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30021880/22-spring-creek-drive-unit-33-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-42"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1884
+"BelowGradeFinishedArea": 300
+"OriginalEntryTimestamp": "2026-07-11T16:18:14.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419828"
+"ListOfficeNationalAssociationId": "1336415"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021880')"
+"ID": "1616967"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1616968"
+post_author: 1
+"ListingKey": "30022062"
+"ListingId": "X13553070"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T17:45:02Z"
+"RFModificationTimestamp": "2026-07-11T18:49:17Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "33 - 22 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.878421
1 => 43.345434
]
+"Latitude": 43.345434
+"Longitude": -79.878421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful freehold end-unit townhome in Waterdown, where thoughtful upgrades, generous living space, and everyday comfort come together perfectly. Offering 3 bedrooms and 2.5 bathrooms, this impressive home features a separate formal dining room and a bright, inviting great room with a dedicated breakfast area. Hardwood flooring, elegant crown moulding, and California shutters add warmth and character throughout the main level. At the heart of the home is a stunning kitchen designed to impress, complete with quartz countertops, a stylish backsplash, and under-cabinet lighting. Upstairs, retreat to the spacious primary bedroom featuring a spa-inspired ensuite with a double-sink quartz vanity, walk-in shower, and relaxing soaker tub. Two additional bedrooms and convenient upper-level laundry complete the second floor. The finished basement provides valuable additional living space with custom storage cabinetry, while the beautifully landscaped backyard features a premium 16' x 16' composite deck, perfect for entertaining or unwinding outdoors. Ideally located close to trails, parks, the GO Station, and major highways including the 403, 407, and QEW, this is the perfect opportunity to enjoy the charm of Waterdown with exceptional commuter convenience. A stylish, spacious, move-in-ready home you don't want to miss! (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T18:49:10.355369+00:00"
+"Directions": "Cross Streets: Dundas. ** Directions: Dundas St. to Spring Creek Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190994"
+"ListOfficeKey": "283948"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.9 x 62.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T17:38:39Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T17:38:39Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6860"
+"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fo/rlazyk9o5bvpf56x75gq1/AF_f009yRL_C-8vlNcSGEqA?rlkey=2pfr5h8f57v44tp48xyhrjkiw&dl=0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30022062/33-22-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.1
+"OriginalEntryTimestamp": "2026-07-11T17:38:39.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1440064"
+"ListOfficeNationalAssociationId": "1337191"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022062')"
+"ID": "1616968"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1615240"
+post_author: 1
+"ListingKey": "30019447"
+"ListingId": "X13550690"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T20:10:02Z"
+"RFModificationTimestamp": "2026-07-10T23:08:53Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "83 BOULDING AVENUE, Hamilton (Waterdown), Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.884312
1 => 43.342764
]
+"Latitude": 43.342764
+"Longitude": -79.884312
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well-maintained, all-brick detached home situated in the desirable east-end of Waterdown, located just minutes to QEW, 407, Go Stations, Burlington waterfront, grocery, schools, parks, trails, and more. Built in 1986, w/ various improvements, this home offers approximately 1950 ft of finished living space, including a finished basement. On a generous 50x117 lot, this property combines comfort, functionality, and an exceptional location, w/ a large backyard bordering a city park. The main level features a bright eat-in kitchen, spacious living room, and separate dining room. A convenient mudroom w/ storage & direct access to the attached 2-car garage, adds practicality for busy families. Upstairs, you'll find 3 spacious bedrooms and a 4-pc bath, w/ a walk-in closet in the primary bedroom. The fully finished basement expands the living space, including a 3-pc bath, laundry room, and ample room for a recreation area, home office, or additional family living space. The large private backyard backs onto a city park, creating a peaceful setting w/ no immediate rear neighbours. A rare opportunity to purchase a meticulously maintained home. *For Additional Property Details Click The Brochure Icon Below* (id:62650)"
+"Appliances": array:2 [
0 => "Central Vacuum"
1 => "Blinds"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T23:08:34.041882+00:00"
+"Directions": "Cross Streets: Dundas Street & Pamela Street. ** Directions: From the east:Travel west on Dundas Street, past Brant Street.Turn right on Pamela Street.Turn right on Boulding Avenue."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1851727"
+"ListOfficeKey": "273408"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.5 x 117.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T20:04:05Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T20:04:05Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "83"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6331.3"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30019447/83-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 49.6
+"OriginalEntryTimestamp": "2026-07-10T20:04:05.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1199331"
+"ListOfficeNationalAssociationId": "1250460"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019447')"
+"ID": "1615240"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1614596"
+post_author: 1
+"ListingKey": "30019705"
+"ListingId": "40846808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T21:05:26Z"
+"RFModificationTimestamp": "2026-07-10T21:23:01Z"
+"ListPrice": 849500.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.07
+"LivingArea": 1933.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0M7"
+"UnparsedAddress": "31 WAKEFIELD Lane, Waterdown, Ontario L8B0M7"
+"Coordinates": array:2 [
0 => -79.88482
1 => 43.3462142
]
+"Latitude": 43.3462142
+"Longitude": -79.88482
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 31 Wakefield Lane, a beautifully maintained end-unit home in the heart of Waterdown, offering approximately 1,682 sq ft above grade plus a fully finished basement. Situated on a rare 42 x 109 ft lot, this property provides the added space, privacy, and natural light that make end units so desirable. The main floor features a functional and inviting layout with a bright living room, spacious eat-in kitchen, and walkout to a private backyard. A separate front room with French doors offers the perfect space for a home office, den, or formal dining area. A convenient 2-piece powder room completes the level. Upstairs, you’ll find three generously sized bedrooms, including an oversized primary retreat with its own 3-piece ensuite. The additional bedrooms are well-proportioned and serviced by a full bathroom—ideal for families. The finished basement adds valuable living space, including a large recreation room with a wood stove, a 2-piece bathroom, a laundry/work area, and a cold cellar. Step outside to enjoy your fully fenced backyard oasis, complete with a gazebo (2021), deck, and double gate access (2022)—perfect for entertaining or relaxing. Notable updates include: windows (2022), A/C (2022), garage door & opener (2022), expanded driveway (2021), front door (2024), upper-level flooring (2018), fridge (2021), and more. Located in a family-friendly neighbourhood close to parks, schools, shopping, and amenities. A move-in ready home offering space, comfort, and exceptional value. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Central Vacuum - Roughed In"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T21:22:50.741721+00:00"
+"Directions": "Off of Boulding Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967643"
+"ListOfficeKey": "55000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Corner Site"
]
+"LotSizeDimensions": "0.07"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T20:48:26Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T20:48:26Z"
+"Stories": "2.0"
+"StreetName": "WAKEFIELD"
+"StreetNumber": "31"
+"StreetSuffix": "Lane"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "5362"
+"VirtualTourURLUnbranded": "https://youtu.be/KgPQkvwLljU"
+"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/30019705/31-wakefield-lane-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 1488
+"BelowGradeFinishedArea": 445
+"OriginalEntryTimestamp": "2026-07-10T20:48:26.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1255460"
+"ListOfficeNationalAssociationId": "1003612"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019705')"
+"ID": "1614596"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1614601"
+post_author: 1
+"ListingKey": "30019701"
+"ListingId": "40847224"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T21:05:26Z"
+"RFModificationTimestamp": "2026-07-10T21:22:28Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 585.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 503, Waterdown, Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.878818
1 => 43.3436273
]
+"Latitude": 43.3436273
+"Longitude": -79.878818
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brand New Condo 470 Dundas St E, Waterdown. Upgraded vinyl floors throughout, upgraded tile in bathroom. Kitchen upgrades: brand new stainless steel appliances, breakfast bar, tile backsplash. Large bedroom with floor to ceiling window. In-suite laundry with washer/dryer. Private Juliette balcony with escarpment view. One owned parking space, storage locker plus allocated bike storage. Trend 1 by award-winning New Horizon. Ultimate blend of modern comfort and convenience with open concept design. Fabulous amenities including party rooms, fitness facilities and rooftop patios with BBQs. Near quaint downtown Waterdown, shops, restaurants, local trails for biking/hiking. Only 10 min from Aldershot GO Station, 15 min from downtown Burlington and 18 min to Hamilton. Currently tenanted ideal investor opportunity. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "553"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T21:22:20.124181+00:00"
+"Directions": "Mallard Trail"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202234"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-10T20:48:24Z"
+"PhotosCount": 6
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T20:48:24Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2600"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30019701/470-dundas-street-e-unit-503-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 585
+"OriginalEntryTimestamp": "2026-07-10T20:48:24.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1450779"
+"ListOfficeNationalAssociationId": "1223042"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019701')"
+"ID": "1614601"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 154
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]