array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29140356/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140356&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140356/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140356&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23280
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23282
+post_id: "447353"
+post_author: 1
+"ListingKey": "29140356"
+"ListingId": "X12579976"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:10:24Z"
+"RFModificationTimestamp": "2025-11-27T01:33:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A3"
+"UnparsedAddress": "24 SAVAGE DRIVE, Hamilton (Waterdown), Ontario L8B0A3"
+"Coordinates": array:2 [
0 => -79.9086677
1 => 43.3393322
]
+"Latitude": 43.3393322
+"Longitude": -79.9086677
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedroom Freehold Townhome In An Unbeatable Location! Just Steps To Local Shopping, Parks, Schools And Ymca. Main Floor Offer Bright Airy Great Room With Walk-Out To Large Covered Balcony. Kitchen Features Stainless Steel Appliances, Lots Of Cabinetry And Workspace. Handy Breakfast Bar. Upper Level Offers 2 Spacious Bedrooms And Convenient Laundry. Ground Floor Entry With Lots Of Storage Space. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:33:36.526726+00:00"
+"Directions": "Cross Streets: Centre Rd. ** Directions: Parkside Dr & Centre Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1415763"
+"ListOfficeKey": "50737"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "19.7 x 49.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:21Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:00:21Z"
+"Stories": "3.0"
+"StreetName": "Savage"
+"StreetNumber": "24"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1540605075"
"RoomType" => "Great room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
1 => array:11 [
"RoomKey" => "1540605076"
"RoomType" => "Dining room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
2 => array:11 [
"RoomKey" => "1540605077"
"RoomType" => "Kitchen"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29140356"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
3 => array:11 [
"RoomKey" => "1540605078"
"RoomType" => "Laundry room"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29140356"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
4 => array:11 [
"RoomKey" => "1540605079"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 2.9
"ListingKey" => "29140356"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
5 => array:11 [
"RoomKey" => "1540605080"
"RoomType" => "Bedroom"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 3.43
"ListingKey" => "29140356"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140356/24-savage-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-11-26T22:00:21.78Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:19 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341638522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/7f44cc64fe916418b0fdc0b6ad218922.webp"
"MediaSize" => 91806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-7f44cc64fe916418b0fdc0b6ad218922.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341638548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/c537e98e8c19c7c697e74619c4fb4ca4.webp"
"MediaSize" => 135333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-c537e98e8c19c7c697e74619c4fb4ca4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341638549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/215ac4803c733e54cf24ada78f888679.webp"
"MediaSize" => 59387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-215ac4803c733e54cf24ada78f888679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341638562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/dfc61ac536a0480bdf039a8c6ac51b60.webp"
"MediaSize" => 98206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-dfc61ac536a0480bdf039a8c6ac51b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341638576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/45f128b338ddd305ceebd6a4e4e863fd.webp"
"MediaSize" => 111176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-45f128b338ddd305ceebd6a4e4e863fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341638589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/35529b55daf7206355dc2c22f4fd10ca.webp"
"MediaSize" => 98206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-35529b55daf7206355dc2c22f4fd10ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341638631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/4ceaa8a6793779511334a223409ea014.webp"
"MediaSize" => 84723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-4ceaa8a6793779511334a223409ea014.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341638664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/0c829b917f776490204e59c07c39c10a.webp"
"MediaSize" => 93726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-0c829b917f776490204e59c07c39c10a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341638672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/bc5dc0f701fc47576aa0e6b6ee4931b1.webp"
"MediaSize" => 104187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-bc5dc0f701fc47576aa0e6b6ee4931b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341638738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/79bfccfd4516c417057d0f47cf7b018e.webp"
"MediaSize" => 120460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-79bfccfd4516c417057d0f47cf7b018e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341638773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/9eab31f6342209576ec4a927ac224564.webp"
"MediaSize" => 67962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-9eab31f6342209576ec4a927ac224564.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341638840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/0b439a801b4ed76847a5e47ac3942db8.webp"
"MediaSize" => 70950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-0b439a801b4ed76847a5e47ac3942db8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341638895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/a5b3107009f86c34bc44e0a31a9f8222.webp"
"MediaSize" => 58294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-a5b3107009f86c34bc44e0a31a9f8222.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341638914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/c7a10d885dabae753f05a56d173c682a.webp"
"MediaSize" => 21858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-c7a10d885dabae753f05a56d173c682a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341638980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/b60f899a55b9cc12000dd7eeccb12604.webp"
"MediaSize" => 49476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-b60f899a55b9cc12000dd7eeccb12604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341639017"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/82c77f0a48145065cf2e849c9732df08.webp"
"MediaSize" => 75614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-82c77f0a48145065cf2e849c9732df08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341639082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/c3e99e9505aa131e1a1127fef6d0f278.webp"
"MediaSize" => 137275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-c3e99e9505aa131e1a1127fef6d0f278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341639119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/60edb095dff8c37c9f6bb9f4af4c0932.webp"
"MediaSize" => 122630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-60edb095dff8c37c9f6bb9f4af4c0932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341639128"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/9005f5895f961044f93e5e98f87ad0cc.webp"
"MediaSize" => 98034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-9005f5895f961044f93e5e98f87ad0cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140356')"
+"ID": "447353"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 50737/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50737&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50737/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50737&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25090
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25092
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 ASSOCIATES INC."
+"OfficeEmail": null
+"OfficePhone": "905-279-8888"
+"OfficeMlsId": "32600"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "50737"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "200 MATHESON BLVD WEST #103"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5R3L7"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1107626"
+"OriginalEntryTimestamp": null
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "5402586505"
"MediaURL" => "https://ddfcdn.realtor.ca/organization/en-ca/TS636657861600000000/highres/50737.jpg"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "32600"
"ResourceRecordKey" => "50737"
"ModificationTimestamp" => "2018-06-28T16:36:00Z"
]
]
+"OfficeFax": "905-361-1333"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "7540"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "50737"
"SocialMediaUrlOrId" => "http://www.century21ontario.com/"
"ModificationTimestamp" => "2018-06-28T16:36:00Z"
]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1045482"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('50737')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1415763/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1415763&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1415763/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1415763&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25095
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29140356" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24705
+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 29140356/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140356&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140356/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140356&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24685
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140356 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9086677 43.3393322)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140356 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9086677 43.3393322)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140356 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9086677 43.3393322)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140356 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9086677 43.3393322)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24559
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24963
+post_id: 447914
+post_author: 1
+"ListingKey": "29141367"
+"ListingId": "40790838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T05:45:32Z"
+"RFModificationTimestamp": "2025-11-27T06:47:46Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2085.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "30 KELLY Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.899403
1 => 43.338015
]
+"Latitude": 43.338015
+"Longitude": -79.899403
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Charming All Brick Bungalow in the coveted Core of Waterdown Village. Situated on quiet, dead end street just steps away from Memorial Park, Shopping and Restaurants. This property features a large private lot, backing onto Mary Hopkins Elementary School - the perfect starter HOME for a young family or perhaps the downsizer looking for simple, convinient one floor living. Main Floor features a cozy Gas Fireplace & Hardwood in the Living & Dining Rms, Original Kitchen open to LR & DR. 2 spacious Bedrms, main floor Bathroom and a walk out to the sprawling back yard complete with Garden Shed & Pond. Recent Updates include: Roof/Shingles, Furnace, A/C, Windows, Exterior Doors, Gas Fireplace, Repointed Chimney and a Gorgeous renovated 5pc Bath for your own personal SPA Retreat. Partially finished Basement offers loads of potential for additional living space. A solid build awaiting your finishing touches, this HOME offers great space, privacy, and convenience in a family-friendly location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T06:47:30.449065+00:00"
+"Directions": "MAIN STREET NORTH TO KELLY STREET"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533119"
+"ListOfficeKey": "279638"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-27T05:38:27Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T05:38:27Z"
+"Stories": "1.0"
+"StreetName": "KELLY"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5490"
+"VirtualTourURLUnbranded": "https://youriguide.com/30_kelly_st_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1540755236"
"RoomType" => "Utility room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
1 => array:11 [
"RoomKey" => "1540755237"
"RoomType" => "Storage"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
2 => array:11 [
"RoomKey" => "1540755238"
"RoomType" => "Laundry room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
3 => array:11 [
"RoomKey" => "1540755239"
"RoomType" => "Recreation room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 33'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
4 => array:11 [
"RoomKey" => "1540755240"
"RoomType" => "5pc Bathroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
5 => array:11 [
"RoomKey" => "1540755241"
"RoomType" => "Bedroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
6 => array:11 [
"RoomKey" => "1540755242"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
7 => array:11 [
"RoomKey" => "1540755243"
"RoomType" => "Kitchen"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
8 => array:11 [
"RoomKey" => "1540755244"
"RoomType" => "Dining room"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
9 => array:11 [
"RoomKey" => "1540755245"
"RoomType" => "Living room"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141367/30-kelly-street-waterdown"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2075759"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284639"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1064
+"BelowGradeFinishedArea": 1021
+"OriginalEntryTimestamp": "2025-11-27T05:38:27.74Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342141253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/33b1c07194f45a53de2222a592190ff2.webp"
"MediaSize" => 173638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-33b1c07194f45a53de2222a592190ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342141346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/c4a08adbc3f76cee09257fbb8a032be8.webp"
"MediaSize" => 173554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-c4a08adbc3f76cee09257fbb8a032be8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342141455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/a11f14a2e1a3e3f5930a9f237d0ae159.webp"
"MediaSize" => 45014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-a11f14a2e1a3e3f5930a9f237d0ae159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342141547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fed042f15e27c253b3ffed4f87e89042.webp"
"MediaSize" => 64708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fed042f15e27c253b3ffed4f87e89042.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342141625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/27c69b349051f81e6d84aff34b577b8e.webp"
"MediaSize" => 89041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-27c69b349051f81e6d84aff34b577b8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342141682"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/88378fc29b6aba7165a2907e155a184c.webp"
"MediaSize" => 80839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-88378fc29b6aba7165a2907e155a184c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342141698"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/6702422fc18c2b1b75dd1aa52193706d.webp"
"MediaSize" => 79912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-6702422fc18c2b1b75dd1aa52193706d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342141799"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d51470092220f49b96f20afce169da0c.webp"
"MediaSize" => 79409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d51470092220f49b96f20afce169da0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342141877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/5dd3866d7c4d721d3178328581644295.webp"
"MediaSize" => 67355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-5dd3866d7c4d721d3178328581644295.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342141951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/7f5732a96bab1198dcb87c7183d25d81.webp"
"MediaSize" => 68016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-7f5732a96bab1198dcb87c7183d25d81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342142018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d75baacbbf9468f82ab05460e7572632.webp"
"MediaSize" => 88512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d75baacbbf9468f82ab05460e7572632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342142062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/724fe8fb95dfe24a56a1e5392b5d72b3.webp"
"MediaSize" => 89212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-724fe8fb95dfe24a56a1e5392b5d72b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342142105"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/e2ffff9a8a1411b7ffaa69bee00639df.webp"
"MediaSize" => 75170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-e2ffff9a8a1411b7ffaa69bee00639df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342142142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/23de4bbccba0bdd8e300065c813121ea.webp"
"MediaSize" => 77884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-23de4bbccba0bdd8e300065c813121ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342142231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/471aee9cf3c59aa02fa760b235cbf4a0.webp"
"MediaSize" => 73536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-471aee9cf3c59aa02fa760b235cbf4a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6342142253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/cbc68237f803010a4d7a36c0a37e185d.webp"
"MediaSize" => 71294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-cbc68237f803010a4d7a36c0a37e185d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6342142297"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/864028c3eb96630d2ae09c6bc712ff04.webp"
"MediaSize" => 71372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-864028c3eb96630d2ae09c6bc712ff04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6342142355"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/3405e0e853409689fdcf2d4ed65acbfd.webp"
"MediaSize" => 68286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-3405e0e853409689fdcf2d4ed65acbfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6342142381"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/9fbdc84e1be7e853ee8aa4b43c116241.webp"
"MediaSize" => 54006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-9fbdc84e1be7e853ee8aa4b43c116241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6342142403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/85fdd1700ac7747346693018f11a7a68.webp"
"MediaSize" => 55598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-85fdd1700ac7747346693018f11a7a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6342142429"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fb2738b1972c1666da431970855097b9.webp"
"MediaSize" => 57803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fb2738b1972c1666da431970855097b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6342142452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/be89c7851225b87358e39b0a12ea1bf2.webp"
"MediaSize" => 59656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-be89c7851225b87358e39b0a12ea1bf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6342142467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d848def7b6692e0f2301755ccf2e4434.webp"
"MediaSize" => 64909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d848def7b6692e0f2301755ccf2e4434.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6342142489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d1beee7c1639805c08dd9393e21547a9.webp"
"MediaSize" => 51337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d1beee7c1639805c08dd9393e21547a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6342142504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/f1f0c36c9554abc274d00b8022079ab6.webp"
"MediaSize" => 55855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-f1f0c36c9554abc274d00b8022079ab6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6342142520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/72bb933460a40cfe899bbc958578401b.webp"
"MediaSize" => 54596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-72bb933460a40cfe899bbc958578401b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6342142538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/a696975ba9fc6c7dc7d4b3e88c71fcf0.webp"
"MediaSize" => 60061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-a696975ba9fc6c7dc7d4b3e88c71fcf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6342142546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/411b1a18fa339137d8e78c0b8cbdf22f.webp"
"MediaSize" => 60841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-411b1a18fa339137d8e78c0b8cbdf22f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6342142562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fbabe35a97b2bab89898e9eebfb1db02.webp"
"MediaSize" => 66060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fbabe35a97b2bab89898e9eebfb1db02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6342142576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/da7a04fc0ca28dc97dd44951ac424378.webp"
"MediaSize" => 152623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-da7a04fc0ca28dc97dd44951ac424378.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6342142596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ab4069c981ab5346d4dde749d8e49ec1.webp"
"MediaSize" => 141252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ab4069c981ab5346d4dde749d8e49ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6342142600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ccde89c3d685fdb13559599035821ba7.webp"
"MediaSize" => 163615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ccde89c3d685fdb13559599035821ba7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6342142657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ebc7abf4573984983d34942b71323fd8.webp"
"MediaSize" => 195982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ebc7abf4573984983d34942b71323fd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6342142662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/df7390ecda63970f063f3a9b785ccb3a.webp"
"MediaSize" => 211583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-df7390ecda63970f063f3a9b785ccb3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6342142667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/28e934230ea3c9216f2be0dfdca49b2e.webp"
"MediaSize" => 198565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-28e934230ea3c9216f2be0dfdca49b2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6342142671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/968a4d74dac1868271c3ab37c3960e56.webp"
"MediaSize" => 203749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-968a4d74dac1868271c3ab37c3960e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141367')"
+"ID": 447914
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24961
+post_id: "445160"
+post_author: 1
+"ListingKey": "29137642"
+"ListingId": "X12577214"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T03:40:38Z"
+"RFModificationTimestamp": "2025-11-26T03:42:44Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X2"
+"UnparsedAddress": "4 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X2"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained condo townhouse offering style, comfort, and convenience in every detail. The main level features an inviting open-concept layout with hardwood flooring and neutral paint tones that create a warm, modern feel. The gourmet kitchen boasts stainless steel appliances, a functional island, and plenty of counter space-perfect for cooking and entertaining. A custom built-in wall unit with charming shiplap & electric fireplace adds character and a cozy focal point to the living area. Upstairs, you'll find three generous-sized bedrooms, including a spacious primary suite complete with built-ins in the walk-in closet and its own 4-piece ensuite bathroom. An additional 4-piece bathroom serves guests or family. The second-floor laundry room has been tastefully updated, offering added convenience and style. The finished basement expands your living space with a versatile recreation room and ample storage options. A single-car garage provides secure parking and additional room for belongings. Move-in ready and thoughtfully updated, this home blends updated finishes with practical living spaces-perfect for families, professionals, or anyone seeking a low-maintenance lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "260.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T03:21:10.295086+00:00"
+"Directions": "Dundas St E/ Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235857"
+"ListOfficeKey": "280835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:53:38Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T03:20:42Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5639.1"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/4_215_dundas_st_e_hamilton_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137642/4-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1956613"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blair Blanchard"
+"CoListAgentKey2": "2235858"
+"CoListOfficeKey": "280835"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"CoListOfficeKey2": "280835"
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-11-26T02:53:38.32Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137642')"
+"ID": "445160"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24574
+post_id: "440067"
+post_author: 1
+"ListingKey": "29130694"
+"ListingId": "X12570684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T17:45:39Z"
+"RFModificationTimestamp": "2025-11-24T19:18:59Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0E1"
+"UnparsedAddress": "3 LONGYEAR DRIVE, Hamilton (Waterdown), Ontario L8B0E1"
+"Coordinates": array:2 [
0 => -79.912484
1 => 43.328148
]
+"Latitude": 43.328148
+"Longitude": -79.912484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A Rare Opportunity Awaits Your Visit In The Heart Of Waterdown, Ontario! With The Utmost Excitement We Bring To You 3 Longyear Drive, Situated On A Breathtaking Lot Offering You Comfort And A Full Retreat Experience - All In One. Its Unique Interior Offers Traditional Finishing W/ A Touch Of Modern Design; Features 3 Bedrooms, 3 Washrooms, & A Fully Finished Basement. Step Inside To A Bright, Inviting Main Floor Highlighted By An Impressive Open-To-Above Living Area Featuring Soaring Ceilings And A Cozy Wood-Burning Fireplace, Creating A Stunning Focal Point For The Home! The Open-Concept Layout Continues W/ A Spacious Living/Dining Area (Large Bay-Window Overlooking The Backyard) & A Well-Appointed Kitchen Offering Ample Counter Space & Storage - Perfect For Everyday Living/Entertaining. Upstairs, You'll Find Three Generously Sized Bedrooms, Including A Primary Suite W/ A Walk-In Closet And Private Ensuite. An Additional Full Bathroom On The Upper-Level, And Overall, It's Functional Layout Make It Ideal For Families Of All Sizes. The Finished Basement Adds Valuable Living Space With A Large Recreation Area, Perfect For Movie Nights, Kids' Play Space, A Home Gym, Or A Comfortable Work-From-Home Setup - Along With Plenty Of Storage. All Of This Is Set In An Unbeatable Location, Walking Distance To Waterdown's Vibrant New Hub Of Shops, Dining, And Services, Plus Schools, Parks, And Trails Just Around The Corner. This Is More Than Just A Home, Its A Lifestyle. Rarely Does A Property Combine Such An Exceptional Layout/Size & Backyard With City Convenience; Plus A Walking Trail Directly Out Front (Open Area W/ A Ravine)! Don't Miss This Opportunity, Book Your Showing Today! (id:62650)"
+"Appliances": array:9 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T07:31:36.649788+00:00"
+"Directions": "Hwy 5 To Hollybush To Longyear"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110997"
+"ListOfficeKey": "274537"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42 x 95.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T06:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T17:34:59Z"
+"Stories": "2.0"
+"StreetName": "Longyear"
+"StreetNumber": "3"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6400"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/3-longyear-drive-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29130694/3-longyear-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2128727"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "274537"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2025-11-24T06:50:05.94Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29130694')"
+"ID": "440067"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24960
+post_id: "435678"
+post_author: 1
+"ListingKey": "29125383"
+"ListingId": "X12565450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T22:05:12Z"
+"RFModificationTimestamp": "2025-11-25T22:14:10Z"
+"ListPrice": 979000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "160 MILL STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.895992
1 => 43.337802
]
+"Latitude": 43.337802
+"Longitude": -79.895992
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 160 Mill St N, a charming 1.5-storey detached home set on a PREMIUM TREED 66 x 147 ft lot with In Ground Pool in the heart of Downtown Waterdown. Offering 2+1 bedrooms, 2 full bathrooms, a partially finished basement, and a detached 1.5 car garage, this property blends character, functionality, and space. The main floor features a large eat-in kitchen with walkout to the mudroom, a cozy living room with an electric fireplace, and a spacious family room with a gas fireplace, perfect for everyday living and entertaining. A beautifully updated 4-piece bathroom and main floor bedroom complete the level. Upstairs, the private primary retreat offers a generous walk-in closet and a stylish 3-piece ensuite, creating a serene space to unwind. A separate entrance from the backyard to the basement provides excellent potential for an in-law suite. With a large existing bedroom with an electric fireplace feature wall, the lower level is ready for your finishing touches. Step outside to your private backyard oasis, lined with mature trees and featuring a fully fenced in-ground pool, green space, a spacious deck, hot tub, and a storage shed. Enjoy all-day sun and a true retreat-like setting. Centrally located in Old Waterdown near top-rated schools, parks, trails, and every major amenity, this home combines small-town charm with unbeatable convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2025-11-21T15:52:11.397118+00:00"
+"Directions": "Cross Streets: John St E. ** Directions: Dundas St to Mill St."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:5 [
0 => "Forced air"
1 => "Not known"
2 => "Not known"
3 => "Electric"
4 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "286765"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "66.2 x 146.9 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T14:55:41Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T21:54:53Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "Mill"
+"StreetNumber": "160"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5200"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/160-mill-st-n-waterdown-on-l0r-2h0-20322421/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29125383/160-mill-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 66.2
+"OriginalEntryTimestamp": "2025-11-21T14:55:41.58Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29125383')"
+"ID": "435678"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24962
+post_id: "432595"
+post_author: 1
+"ListingKey": "29121351"
+"ListingId": "X12561662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T15:30:26Z"
+"RFModificationTimestamp": "2025-11-20T16:48:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "31 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into this stylish, modern 2-bedroom, 2.5-bathroom townhome, boasting 10-foot ceilings and an open-concept, 1,260 sq.ft. layout. This property is impeccably maintained, featuring a sleek kitchen with stainless steel appliances and sunlit living spaces. A standout feature is the privacy: both upstairs bedrooms come with their own private ensuite bathrooms, a major draw for roommates or professionals.The location offers unmatched convenience. Situated in the charming Village of Waterdown, you get a quaint community feel with urban accessibility. Professionals will appreciate the direct access to the 403, 407, and QEW, and the quick 5-minute drive to Aldershot GO Station for an easy commute to Toronto. This home is also perfect for young families seeking an excellent community or executive couples looking for high-end, low-maintenance living. Enjoy local parks, shops, and amenities right nearby. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T16:48:23.681491+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Dundas Street East Waterdown."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Facing"
]
+"Flooring": array:1 [
0 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2144299"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T15:21:13Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T15:21:13Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29121351/31-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2139671"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283413"
+"TotalActualRent": 2950
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-20T15:21:13.62Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:27 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121351')"
+"ID": "432595"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24625
+post_id: "430991"
+post_author: 1
+"ListingKey": "29119294"
+"ListingId": "X12559530"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T13:40:58Z"
+"RFModificationTimestamp": "2025-11-24T13:45:36Z"
+"ListPrice": 964000.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.8915404
1 => 43.3312884
]
+"Latitude": 43.3312884
+"Longitude": -79.8915404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming 3+1 bedroom, 2-bathroom home in the heart of Waterdown's original village, perfectly positioned for both convenience and community living. Nestled in a mature, tree-lined neighbourhood, this bright and inviting home is just steps from downtown shops, restaurants, parks, and scenic trails, and only a 4-minute walk to Sealey Park. Commuters will appreciate the easy access to major highways and the Aldershot GO Station, just a 7-minute drive away. Inside, the home features a warm and functional layout filled with natural light. The large, bright finished basement offers an additional bedroom or flexible living space, complete with ample storage, making it ideal for guests, a home office, a playroom, or a cozy family room. Outside, enjoy the generous backyard, providing plenty of space to relax, entertain, or garden-perfect for families or anyone seeking a peaceful outdoor retreat. With excellent schools nearby and a vibrant, walkable village at your doorstep, this property is an outstanding opportunity for young families, downsizers, or anyone looking to enjoy the best of Waterdown living. Don't miss the opportunity to make this your next home! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T21:46:10.455324+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": "2025-11-19T20:33:31Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:24:25Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/75_flamboro_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29119294/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2025-11-19T20:33:31.67Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29119294')"
+"ID": "430991"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23294
+post_id: "430661"
+post_author: 1
+"ListingKey": "29118904"
+"ListingId": "40788601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-23T21:45:47Z"
+"RFModificationTimestamp": "2025-11-23T21:46:56Z"
+"ListPrice": 964000.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.8912109
1 => 43.331207
]
+"Latitude": 43.331207
+"Longitude": -79.8912109
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming 3+1 bedroom, 2-bathroom home in the heart of Waterdown’s original village, perfectly positioned for both convenience and community living. Nestled in a mature, tree-lined neighbourhood, this bright and inviting home is just steps from downtown shops, restaurants, parks, and scenic trails, and only a 4-minute walk to Sealey Park. Commuters will appreciate the easy access to major highways and the Aldershot GO Station, just a 7-minute drive away. Inside, the home features a warm and functional layout filled with natural light. The large, bright finished basement offers an additional bedroom or flexible living space, complete with ample storage, making it ideal for guests, a home office, a playroom, or a cozy family room. Outside, enjoy the generous backyard, providing plenty of space to relax, entertain, or garden—perfect for families or anyone seeking a peaceful outdoor retreat. With excellent schools nearby and a vibrant, walkable village at your doorstep, this property is an outstanding opportunity for young families, downsizers, or anyone looking to enjoy the best of Waterdown living. Don't miss the opportunity to make this your next home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:55:08.825021+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": "2025-11-19T19:30:14Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-23T21:30:48Z"
+"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"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/75_flamboro_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118904/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2025-11-19T19:30:13.92Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118904')"
+"ID": "430661"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24953
+post_id: "428063"
+post_author: 1
+"ListingKey": "29115808"
+"ListingId": "40789002"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T14:55:51Z"
+"RFModificationTimestamp": "2025-11-19T14:59:32Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1609.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "40 HAMILTON Street S Unit# 31, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8935382
1 => 43.3299256
]
+"Latitude": 43.3299256
+"Longitude": -79.8935382
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover this stunning executive townhome perfectly situated in the charming and vibrant community of Waterdown. With an unbeatable location, you’re just steps away from trendy shops, cozy cafés, restaurants, pubs and every convenience imaginable. Nature lovers will also appreciate being within walking distance of scenic trails and the breathtaking Smokey Hollow Waterfalls. Inside, this beautifully designed home features an open-concept main level complete with pot lighting, elegant granite countertops and luxury vinyl flooring. Step through the walkout to your spacious deck (with gas line for a BBQ) overlooking a tranquil ravine; the perfect backdrop for relaxing or entertaining. Upstairs, the primary bedroom offers a generous walk-in closet and a lovely ensuite, complemented by two additional bedrooms, a full main bath and the convenience of second-floor laundry. The bright, spacious basement with large windows is ready for your personal touch. Features the convenience of a car charger, easy access to the GO Train, Highways 407, 403 and 6, and just a short stroll to every amenity, this home truly has it all. Experience comfort, convenience and style — welcome home to St. Thomas Walk! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "421.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T23:58:28.606906+00:00"
+"Directions": "Dundas Street E to Hamilton Street S"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T14:41:16Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T14:41:16Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "5968.08"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=69637"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29115808/40-hamilton-street-s-unit-31-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"ZoningDescription": "R6-43, P5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1609
+"OriginalEntryTimestamp": "2025-11-18T22:30:26.64Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29115808')"
+"ID": "428063"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24571
+post_id: "423475"
+post_author: 1
+"ListingKey": "29109952"
+"ListingId": "40788620"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T21:25:57Z"
+"RFModificationTimestamp": "2025-11-24T23:48:27Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 760.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 E DUNDAS Street E Unit# 306, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8959931
1 => 43.330732
]
+"Latitude": 43.330732
+"Longitude": -79.8959931
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic Condo in the Historic Waterdown High School Conversion! Welcome to this beautifully appointed condo featuring 10-foot ceilings, a bright open-concept layout, and extra-large windows that flood the space with natural light. The kitchen offers stainless steel appliances, while the entire unit has been freshly painted in neutral tones, making it truly move-in ready. Enjoy the convenience of in-suite laundry, a private balcony, and a dedicated storage locker. This exceptionally clean and well-maintained building is situated just steps from restaurants, grocery stores, banks, parks, schools, and easy highway access. Simply move in and enjoy! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "638"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T17:57:41.129945+00:00"
+"Directions": "Dundas St E-Hamilton St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1896483"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-11-24T20:51:55Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T21:09:48Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3474.84"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/360621"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29109952/262-dundas-street-e-unit-306-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2025-11-17T17:29:49.49Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:11 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29109952')"
+"ID": "423475"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 106
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
]