array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29233700/Property?$select=ALL&$top=20&$filter=ListingKey eq 29233700&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29233700/Property?$select=ALL&$top=20&$filter=ListingKey eq 29233700&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23467
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23469
+post_id: "522840"
+post_author: 1
+"ListingKey": "29233700"
+"ListingId": "40797332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T17:30:55Z"
+"RFModificationTimestamp": "2026-01-09T17:55:50Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 692.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 333, Waterdown, Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.8796682
1 => 43.3426305
]
+"Latitude": 43.3426305
+"Longitude": -79.8796682
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO TREND! A New Condominium built by New Horizon in Waterdown. This bright west facing spacious unit is a 1 bedroom + den. Suitable for anyone who needs a home office or just some extra living space. Fantastic galley kitchen with a large breakfast bar and a walk-out to your private balcony. This unit features an open concept layout with many upgrades including Shaw luxury vinyl flooring, quartz countertops, porcelain floor to wall tiles in the bathroom with rain head shower faucet, upgraded stainless kitchen appliance package, upgraded large washer and dryer. The spacious primary bedroom boasts a walk in closet and floor to ceiling windows. One underground parking spot with a locker on the same floor as the unit are also added features. Amenities include fitness room, party room, roof top patio and a bike room. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T17:31:52.499334+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1936273"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-09T17:22:17Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T17:22:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1558313060"
"RoomType" => "Den"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.53Z"
]
1 => array:11 [
"RoomKey" => "1558313061"
"RoomType" => "Kitchen"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.53Z"
]
2 => array:11 [
"RoomKey" => "1558313062"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.53Z"
]
3 => array:11 [
"RoomKey" => "1558313063"
"RoomType" => "Laundry room"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.53Z"
]
4 => array:11 [
"RoomKey" => "1558313064"
"RoomType" => "Living room"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.54Z"
]
5 => array:11 [
"RoomKey" => "1558313065"
"RoomType" => "Bedroom"
"ListingId" => "40797332"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29233700"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T17:19:46.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29233700/450-dundas-street-e-unit-333-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 692
+"OriginalEntryTimestamp": "2026-01-09T16:38:43.16Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398044562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/18efae88a10d53b430e2d461659d0008.webp"
"MediaSize" => 80457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-18efae88a10d53b430e2d461659d0008.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398044589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/aa9786877608633f5542514822b1c327.webp"
"MediaSize" => 96385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-aa9786877608633f5542514822b1c327.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:17.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398044631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/365097507a49d6730f53dade66e0184f.webp"
"MediaSize" => 89057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-365097507a49d6730f53dade66e0184f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:17.77Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398044690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/99297a7330d17bc774ce8c0a8756b22a.webp"
"MediaSize" => 87968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-99297a7330d17bc774ce8c0a8756b22a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:17.01Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398044721"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/433533aa502d5539e310cca1eb68e089.webp"
"MediaSize" => 83453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-433533aa502d5539e310cca1eb68e089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398044771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/dc84d1d89121e656375df652f6843802.webp"
"MediaSize" => 37217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-dc84d1d89121e656375df652f6843802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398044786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/db974493d9188e741973b9f97a35979a.webp"
"MediaSize" => 67999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-db974493d9188e741973b9f97a35979a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398044815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/c3c5d56c3668a864c5a57bcab4cd718c.webp"
"MediaSize" => 76394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-c3c5d56c3668a864c5a57bcab4cd718c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.45Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398044884"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/c3553a62640817c5d6efa0735bc68461.webp"
"MediaSize" => 77465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-c3553a62640817c5d6efa0735bc68461.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.45Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398044907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/df9569d2d1676da1069bdce49056f18f.webp"
"MediaSize" => 32881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-df9569d2d1676da1069bdce49056f18f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398044967"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/6923635efbf9de38b2213e5a8e3cdb2a.webp"
"MediaSize" => 24013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-6923635efbf9de38b2213e5a8e3cdb2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.47Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398045010"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/91ac7589b58e229379b1d7ecbefa0730.webp"
"MediaSize" => 24543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-91ac7589b58e229379b1d7ecbefa0730.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:17.01Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398045046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/a2b9c02ee1a05d80a4eb9118db5b18c3.webp"
"MediaSize" => 27877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-a2b9c02ee1a05d80a4eb9118db5b18c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.44Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398045132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/c446580427bc35033e2a2cf09550267d.webp"
"MediaSize" => 27850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-c446580427bc35033e2a2cf09550267d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.47Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398045233"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233700/f46dad8cba356159e4fd62e74f0f0ebe.webp"
"MediaSize" => 43680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233700/thumbnail-f46dad8cba356159e4fd62e74f0f0ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797332"
"ResourceRecordKey" => "29233700"
"ModificationTimestamp" => "2026-01-09T17:22:11.45Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Ajay Bassi"
"MemberFirstName" => "Ajay"
"MemberLastName" => "Bassi"
"MemberMlsId" => "HBBASSIAJ"
"OriginatingSystemName" => 26
"MemberKey" => "1936273"
"ModificationTimestamp" => "2025-10-28T23:16:17Z"
"MemberStatus" => "Active"
"OfficeKey" => "55165"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "905-681-9908"
"MemberCity" => "Burlington"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-639-7676"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2012-04-30T14:47:00Z"
"MemberNationalAssociationId" => "1235068"
"OfficeNationalAssociationId" => "1114492"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX Escarpment Realty Inc."
"OfficePhone" => "905-639-7676"
"OfficeMlsId" => "HBREMAESBU"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "55165"
"ModificationTimestamp" => "2025-12-05T17:10:42Z"
"OfficeAddress1" => "2180 Itabashi Way Unit 4A"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7M5A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "905-681-9908"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1114492"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1201589"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233700')"
+"ID": "522840"
}
]
+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 55165/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55165&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55165/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55165&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "HBREMAESBU"
+"ModificationTimestamp": "2025-12-05T17:10:42Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55165"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 Itabashi Way Unit 4A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1114492"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-681-9908"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439640"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55165"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-12-05T14:58:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1201589"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('55165')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1936273/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1936273&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1936273/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1936273&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25266
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29233700" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24903
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29233700/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29233700&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29233700/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29233700&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24883
+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 29233700 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8796682 43.3426305)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29233700 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8796682 43.3426305)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29233700 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8796682 43.3426305)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29233700 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8796682 43.3426305)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25117
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24795
+post_id: "523751"
+post_author: 1
+"ListingKey": "29235192"
+"ListingId": "40797504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:30:39Z"
+"RFModificationTimestamp": "2026-01-09T23:35:13Z"
+"ListPrice": 1165000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2903.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "43 NISKA Drive, Waterdown, Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.8891476
1 => 43.3433412
]
+"Latitude": 43.3433412
+"Longitude": -79.8891476
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3-bedroom, 2.5-bathroom home located in a quiet, family-friendly neighbourhood, with easy access to highway and GO station. Thoughtfully updated for modern living and easy entertaining. Inside, enjoy a spacious, sunlit kitchen perfect for gatherings and daily life. The home has seen important updates, including a newly replaced roof and windows that were updated within the past few years, providing comfort, efficiency, and long-term peace of mind. The furnace and A/C are only 5-6 years old, so major systems are well taken care of. Fully finished basement features a dedicated gym area, creating a flexible space for wellness or recreation. Step outside and you’ll find a true backyard retreat: A sparkling in-ground pool with a Safecover, safe, secure, and easy to operate; A hot tub with a hard cover, perfect for relaxing year-round. Private, landscaped yard in a peaceful neighbourhood. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T23:34:47.694093+00:00"
+"Directions": "Dundas St.. E. to First St. to Niska Dr."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:19:13Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T20:19:13Z"
+"Stories": "2.0"
+"StreetName": "NISKA"
+"StreetNumber": "43"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6467.49"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1558399772"
"RoomType" => "Laundry room"
"ListingId" => "40797504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
1 => array:11 [
"RoomKey" => "1558399773"
"RoomType" => "Exercise room"
"ListingId" => "40797504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
2 => array:11 [
"RoomKey" => "1558399774"
"RoomType" => "Recreation room"
"ListingId" => "40797504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 31'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
3 => array:11 [
"RoomKey" => "1558399775"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
4 => array:11 [
"RoomKey" => "1558399776"
"RoomType" => "Bedroom"
"ListingId" => "40797504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
5 => array:11 [
"RoomKey" => "1558399777"
"RoomType" => "Bedroom"
"ListingId" => "40797504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.83Z"
]
6 => array:11 [
"RoomKey" => "1558399778"
"RoomType" => "Full bathroom"
"ListingId" => "40797504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
7 => array:11 [
"RoomKey" => "1558399779"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
8 => array:11 [
"RoomKey" => "1558399780"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
9 => array:11 [
"RoomKey" => "1558399781"
"RoomType" => "Family room"
"ListingId" => "40797504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
10 => array:11 [
"RoomKey" => "1558399782"
"RoomType" => "Eat in kitchen"
"ListingId" => "40797504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
11 => array:11 [
"RoomKey" => "1558399783"
"RoomType" => "Dining room"
"ListingId" => "40797504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
12 => array:11 [
"RoomKey" => "1558399784"
"RoomType" => "Living room"
"ListingId" => "40797504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235192"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:19:13.84Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29235192/43-niska-drive-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2158
+"BelowGradeFinishedArea": 745
+"OriginalEntryTimestamp": "2026-01-09T20:19:13.73Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:34 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398335592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/464a37950cdc6ac1c1247b4c70c34487.webp"
"MediaSize" => 173035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-464a37950cdc6ac1c1247b4c70c34487.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional home featuring asphalt driveway, brick siding, a garage, and covered porch"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398335708"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/5ef2eba50cf2af486cd2109525132f4c.webp"
"MediaSize" => 119731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-5ef2eba50cf2af486cd2109525132f4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of covered porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398335768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/1f45034e96c19e302f16c9f945647169.webp"
"MediaSize" => 84098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-1f45034e96c19e302f16c9f945647169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398335776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/03b2dcbc293c074278f389cbddc1d8a3.webp"
"MediaSize" => 80772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-03b2dcbc293c074278f389cbddc1d8a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398335863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/2aa46edd54bd0fafcc74776ff6c42966.webp"
"MediaSize" => 105993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-2aa46edd54bd0fafcc74776ff6c42966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with a textured ceiling, a chandelier, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398335957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/68c8ee3dd690fbf2ce86f8cbcc4f7820.webp"
"MediaSize" => 90786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-68c8ee3dd690fbf2ce86f8cbcc4f7820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room with a textured ceiling and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398335969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/025bf12b9146ffc6b3ea6fa3eacabbaf.webp"
"MediaSize" => 92155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-025bf12b9146ffc6b3ea6fa3eacabbaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a kitchen breakfast bar, brown cabinets, stainless steel appliances, and dark stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398336075"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/a657748f6acd212f82967e220fc5d71c.webp"
"MediaSize" => 99979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-a657748f6acd212f82967e220fc5d71c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with a chandelier, stairs, a textured ceiling, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398336174"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/d4dcc7022fa8309e006b23a84925e10c.webp"
"MediaSize" => 143549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-d4dcc7022fa8309e006b23a84925e10c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stainless steel appliances, brown cabinetry, light tile patterned floors, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398336196"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/62e032391c7a11297e4e61f9471eff13.webp"
"MediaSize" => 109428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-62e032391c7a11297e4e61f9471eff13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a breakfast bar, dark stone counters, stainless steel appliances, a large island, and hanging light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398336288"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/b3a9e27528c4a7f56e2c4e2cbd615ef2.webp"
"MediaSize" => 143549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-b3a9e27528c4a7f56e2c4e2cbd615ef2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stainless steel appliances, brown cabinetry, light tile patterned floors, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398336307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/509a2ec72aba0d9970f43b986c24391d.webp"
"MediaSize" => 84539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-509a2ec72aba0d9970f43b986c24391d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, brown cabinets, a breakfast bar area, dark stone countertops, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398336328"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/3ba87ef44fa9ab16d5bf233cd0718db7.webp"
"MediaSize" => 117595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-3ba87ef44fa9ab16d5bf233cd0718db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring french doors, a textured ceiling, wood finished floors, a ceiling fan, and a fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398336378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/c1db97c99356a26d84081c8c0200f290.webp"
"MediaSize" => 96552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-c1db97c99356a26d84081c8c0200f290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with a fireplace, a textured ceiling, wood finished floors, and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398336415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/e39a38b985377de90e9f7b110464cc28.webp"
"MediaSize" => 81764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-e39a38b985377de90e9f7b110464cc28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, light tile patterned flooring, and tasteful backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6398336456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/e98b4f1deed1a055a2dfd6ba9a6db100.webp"
"MediaSize" => 96862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-e98b4f1deed1a055a2dfd6ba9a6db100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-type flooring and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6398336472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/56d8e48fae894db1514af8942bfbd1a8.webp"
"MediaSize" => 74099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-56d8e48fae894db1514af8942bfbd1a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs with wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6398336547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/fcd034227436a7a97cf539158ddf2173.webp"
"MediaSize" => 88666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-fcd034227436a7a97cf539158ddf2173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a textured ceiling and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6398336602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/b7ff8de249e764ffb572f471a52b4291.webp"
"MediaSize" => 85622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-b7ff8de249e764ffb572f471a52b4291.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with a ceiling fan, a textured ceiling, and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6398336654"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/a8d5f05945bf4569ad4694890afacde6.webp"
"MediaSize" => 70818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-a8d5f05945bf4569ad4694890afacde6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a desk, a ceiling fan, light wood-style floors, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6398336697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/6575622f0df951a28a1dbcc299d451e6.webp"
"MediaSize" => 58052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-6575622f0df951a28a1dbcc299d451e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath featuring shower / bath combination with curtain and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6398336719"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/7f5940e1c027bfffc5ab0b12a4a8cea5.webp"
"MediaSize" => 77949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-7f5940e1c027bfffc5ab0b12a4a8cea5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, light tile patterned flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6398336779"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/fb81f6b5b672a0bb499e11da12206da9.webp"
"MediaSize" => 68063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-fb81f6b5b672a0bb499e11da12206da9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, a shower stall, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6398336862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/5d9cc88f9640b5dd9cd3f2a656174b8a.webp"
"MediaSize" => 83056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-5d9cc88f9640b5dd9cd3f2a656174b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath featuring vanity and shower / tub combo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6398336880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/94e8d5cc586df8bea3057d87f62b6da1.webp"
"MediaSize" => 91947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-94e8d5cc586df8bea3057d87f62b6da1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement with wooden ceiling, light wood finished floors, stairway, and a textured wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6398336937"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/dc2def77ea512cacb55604ddc35c337d.webp"
"MediaSize" => 94249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-dc2def77ea512cacb55604ddc35c337d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercise area featuring a textured wall, wooden ceiling, and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6398336952"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/c03b78be48fd91546642597bc0fab6e6.webp"
"MediaSize" => 96299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-c03b78be48fd91546642597bc0fab6e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreation room with wood ceiling, light wood-style floors, and a textured wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6398336998"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/2a2e7bf38e510d962f152424343b883d.webp"
"MediaSize" => 86895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-2a2e7bf38e510d962f152424343b883d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wooden ceiling and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6398337076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/ac083308c03a8f8a37aa1db45d746c8a.webp"
"MediaSize" => 103437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-ac083308c03a8f8a37aa1db45d746c8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercise room with wooden ceiling, a textured wall, and carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6398337111"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/10aa31a1be82d5c1c9883cb339a2b8b1.webp"
"MediaSize" => 148436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-10aa31a1be82d5c1c9883cb339a2b8b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of property with a wooden deck, a fenced backyard, brick siding, a hot tub, and a patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6398337158"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/afd796d6606b99509fb2e3fefb857b84.webp"
"MediaSize" => 170830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-afd796d6606b99509fb2e3fefb857b84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard featuring a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6398337205"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/94d7b845557b14d59b15b41361ba0e37.webp"
"MediaSize" => 23623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-94d7b845557b14d59b15b41361ba0e37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of room layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6398337245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/1fa20599f2b4704691bf691c0ae5e9db.webp"
"MediaSize" => 24958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-1fa20599f2b4704691bf691c0ae5e9db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6398337249"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235192/63de57a33cb72ded88fd10f3b055964f.webp"
"MediaSize" => 20951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235192/thumbnail-63de57a33cb72ded88fd10f3b055964f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797504"
"ResourceRecordKey" => "29235192"
"ModificationTimestamp" => "2026-01-09T20:19:13.74Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Ying Liu"
"MemberFirstName" => "Ying"
"MemberLastName" => "Liu"
"MemberMlsId" => "HBLIUYI"
"OriginatingSystemName" => 26
"MemberKey" => "1524541"
"ModificationTimestamp" => "2025-10-28T23:12:53Z"
"MemberStatus" => "Active"
"OfficeKey" => "293386"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Burlington"
…8
]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235192')"
+"ID": "523751"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+post_id: "523251"
+post_author: 1
+"ListingKey": "29235663"
+"ListingId": "X12682138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T21:50:47Z"
+"RFModificationTimestamp": "2026-01-09T22:02:21Z"
+"ListPrice": 1279000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R4"
+"UnparsedAddress": "174 MCKNIGHT AVENUE, Hamilton (Waterdown), Ontario L8B0R4"
+"Coordinates": array:2 [
0 => -79.877943
1 => 43.340356
]
+"Latitude": 43.340356
+"Longitude": -79.877943
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 2,955 sq ft, four bedroom, three and a half bath home in a sought after Waterdown neighbourhood built in 2012. Featuring formal living and dining rooms, a large kitchen open to the family room with gas fireplace, and a generous primary suite with walk in closet and en suite with soaker tub. Three additional bedrooms and two full bathrooms complete the upper level.Located minutes to Waterdown's charming downtown core, the Bruce Trail, parks, and conservation areas, with easy access to Highway 403, Highway 6, and the QEW for commuters. Double car garage and covered front porch complete this inviting family home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T22:01:59.469084+00:00"
+"Directions": "Cross Streets: Dundas And Burke. ** Directions: Dundas to Burke."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1407052"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "75.7 x 94 FT ; REAR-38.79"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T21:40:13Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T21:40:13Z"
+"Stories": "2.0"
+"StreetName": "Mcknight"
+"StreetNumber": "174"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "8534"
+"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/29235663/174-mcknight-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 75.8
+"OriginalEntryTimestamp": "2026-01-09T21:40:13.7Z"
+"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]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235663')"
+"ID": "523251"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24779
+post_id: "522839"
+post_author: 1
+"ListingKey": "29234148"
+"ListingId": "X12680794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T17:50:46Z"
+"RFModificationTimestamp": "2026-01-09T18:20:17Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y1"
+"UnparsedAddress": "7 WESTFIELD CRESCENT, Hamilton (Waterdown), Ontario L8B1Y1"
+"Coordinates": array:2 [
0 => -79.8794614
1 => 43.3365679
]
+"Latitude": 43.3365679
+"Longitude": -79.8794614
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 7 Westfield Cres, a beautifully maintained 3-bedroom home in the newer, highly sought-after pocket of Waterdown, where modern design meets everyday comfort. The spacious open-concept main floor is filled with natural light and anchored by a cozy fireplace - perfect for warm winter nights and effortless summer entertaining. Completely carpet-free, the home offers three generous bedrooms and a private, gated backyard ideal for kids, pets, and weekend gatherings. Set in the heart of the Village of Waterdown, you're surrounded by top-rated schools, scenic parks and trails, great dining, and every amenity you could need, all while enjoying quick 5-minute easy access to Aldershot GO, and seamless connections to Highways 6 and 6. This is the kind of home that just feels right - so why not make this Waterdown gem your next home sweet home? (id:62650)"
+"Appliances": array:2 [
0 => "Range"
1 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T18:19:57.590756+00:00"
+"Directions": "DUNDAS ST E & BURKE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162448"
+"ListOfficeKey": "269338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T17:41:03Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T17:41:03Z"
+"Stories": "2.0"
+"StreetName": "Westfield"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6665.35"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29234148/7-westfield-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-01-09T17:41:03.24Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234148')"
+"ID": "522839"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24783
+post_id: "522841"
+post_author: 1
+"ListingKey": "29233356"
+"ListingId": "40787081"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T16:05:47Z"
+"RFModificationTimestamp": "2026-01-09T16:50:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1386.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "70 KENESKY Drive Unit# 30, Hamilton, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.878484
1 => 43.3369104
]
+"Latitude": 43.3369104
+"Longitude": -79.878484
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Be The First To Live In This Stunning, Never-Before-Lived-In 3-Bed, 2.5-Bath Townhome In Sought-After Waterdown! This Bright, Modern Home Offers 1,386 Sq Ft Of Functional Living With Quality Finishes Throughout — Including Quartz Countertops, Vinyl Plank Flooring, And Full-Size Stainless Steel Appliances. Enjoy A Spacious Open-Concept Layout With A Versatile Den, Perfect For A Home Office Or Reading Nook. The Primary Bedroom Features A Luxurious Glass-Enclosed Ensuite. Relax On The 160 Sq Ft Terrace Or Take Advantage Of The Private Garage And Additional Parking Options. Located Minutes From Downtown Waterdown’s Shops, Dining, Bruce Trail, And Smokey Hollow Waterfall. Easy Access To Aldershot GO, Hwy 403 & 407. Lawn & Snow Care Included! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T16:50:14.286291+00:00"
+"Directions": "Dundas St E/Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1752844"
+"ListOfficeKey": "190426"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T15:50:25Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:50:25Z"
+"Stories": "3.0"
+"StreetName": "KENESKY"
+"StreetNumber": "70"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29233356/70-kenesky-drive-unit-30-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1386
+"OriginalEntryTimestamp": "2026-01-09T15:50:24.81Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233356')"
+"ID": "522841"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24802
+post_id: "519633"
+post_author: 1
+"ListingKey": "29229893"
+"ListingId": "X12676720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T18:26:11Z"
+"RFModificationTimestamp": "2026-01-08T18:51:48Z"
+"ListPrice": 1348800.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8817092
1 => 43.3352959
]
+"Latitude": 43.3352959
+"Longitude": -79.8817092
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T18:51:36.902973+00:00"
+"Directions": "Cross Streets: Dundas St & Burke St. ** Directions: Burke St. South To Kenesky Dr. To Avanti Cres."
+"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": "1991785"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "41 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T18:16:02Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T18:16:02Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29229893/107-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-01-08T18:16:02.15Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29229893')"
+"ID": "519633"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24842
+post_id: "519414"
+post_author: 1
+"ListingKey": "29229510"
+"ListingId": "40797077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T17:35:37Z"
+"RFModificationTimestamp": "2026-01-08T18:01:23Z"
+"ListPrice": 1348800.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2870.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI Crescent, Waterdown, Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8819455
1 => 43.3353076
]
+"Latitude": 43.3353076
+"Longitude": -79.8819455
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T18:01:04.243789+00:00"
+"Directions": "Burke St. South To Kenesky Dr. To Avanti Cres"
+"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": "2062140"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T17:28:56Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T17:28:56Z"
+"Stories": "2.0"
+"StreetName": "AVANTI"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"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/29229510/107-avanti-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2085942"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "R1 - 64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 2870
+"OriginalEntryTimestamp": "2026-01-08T17:28:56.31Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29229510')"
+"ID": "519414"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+post_id: "517821"
+post_author: 1
+"ListingKey": "29227505"
+"ListingId": "40795589"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T00:15:27Z"
+"RFModificationTimestamp": "2026-01-08T00:48:37Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 909, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786324
1 => 43.3440957
]
+"Latitude": 43.3440957
+"Longitude": -79.8786324
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Corner Condo with Expansive Private Rooftop Terrace, a storage locker and two parking spots! Discover a one-of-a-kind opportunity to own this beautiful corner unit with breathtaking views and a massive private terrace—your very own rooftop retreat. Whether you love to entertain, need a play space, or simply want to bask in the sun, this outdoor oasis is a rare find. Inside, the open concept living space is designed for both style and functionality. The upgraded kitchen boasts ample cabinetry, quartz countertops, and high-end finishes, perfect for cooking and hosting. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy ambiance. Step into the primary bedroom and enjoy expansive windows and a spacious walk-in closet. The second bedroom, also featuring a walk-in closet and floor-to-ceiling windows, is ideal as a guest room or home office. The sleek, upgraded bathroom includes a stunning walk-in shower with a waterfall showerhead for a spa-like experience. Located in a prime area, you’ll be within walking distance of restaurants and shops, with easy access to highways and the GO Station for commuters. Residents enjoy top-tier amenities, including a state-of-the-art fitness center, an elegant party room, and a rooftop deck with a community BBQ area. Don’t miss this rare opportunity to own a beautiful, modern condo with a private rooftop terrace that truly sets it apart. Schedule your viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "440.93"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T00:48:28.585103+00:00"
+"Directions": "Dundas St. E"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156372"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-08T00:08:46Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T00:08:46Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3297.86"
+"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/29227505/470-dundas-street-e-unit-909-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 728
+"OriginalEntryTimestamp": "2026-01-08T00:08:46.19Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29227505')"
+"ID": "517821"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24745
+post_id: "517560"
+post_author: 1
+"ListingKey": "29227165"
+"ListingId": "40796387"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T14:20:21Z"
+"RFModificationTimestamp": "2026-01-09T14:21:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1868.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "300 SKINNER Road Unit# Upper, Hamilton, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8745967
1 => 43.3421192
]
+"Latitude": 43.3421192
+"Longitude": -79.8745967
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "2023-Built ; 4-Bedroom, 2.5 Washroom Semi-Detached home Upper floor available for Rent; in the highly sought-after community of Waterdown. Features 9-ft ceilings, floor-to-ceiling windows and abundant natural light, this home offers an inviting and modern living experience. Open concept Living room ; S/S Appliances, Garage door Opener and remote ; Open Concept Layout. 9' Ceiling. Lots Of Space In Kitchen And Rooms. Primary Bedroom With 4-Pc Ensuite And Walk-in Closet. Large Closet Space. Located just minutes from major highways (403, 407, and 401 via Hwy 6), GO Train, parks, trails, shopping, and excellent schools. Easy and convenient access to all amenities, shopping and highways. Laundry Room is conveniently located on the Main floor. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T23:20:20.707149+00:00"
+"Directions": "Dundas Street / Mallard Trail"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103920"
+"ListOfficeKey": "283981"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T23:00:10Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T14:08:50Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "300"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29227165/300-skinner-road-unit-upper-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1868
+"OriginalEntryTimestamp": "2026-01-07T23:00:10.64Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29227165')"
+"ID": "517560"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25118
+post_id: "516911"
+post_author: 1
+"ListingKey": "29224637"
+"ListingId": "40796696"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T17:20:30Z"
+"RFModificationTimestamp": "2026-01-07T19:45:19Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1006.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 305, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940031
1 => 43.3303163
]
+"Latitude": 43.3303163
+"Longitude": -79.8940031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Dreaming of condo living without giving up your outdoor space? This rarely offered corner unit delivers the best of both worlds with a massive 600 sq ft private terrace perfect for entertaining, relaxing and soaking up incredible lake AND city views. Inside, you’ll find a 2-bed, 2-bath gem loaded with upgrades: a chef’s kitchen with beautiful quartz counters, clean white subway tile backsplash, soft-close custom cabinetry, undercabinet lighting and a breakfast bar. The bedrooms are spacious, and the primary suite has its own four-piece ensuite. Enjoy in-suite laundry for your convenience. That’s not all, this building has stunning amenities including a lavish party room, a dog wash station, a gym and rooftop patio. And the location? Unbeatable. Steps to restaurants, groceries, trails and highway access, all in the heart of Waterdown. This one has it all. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"AssociationFee": "1332.68"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:44:56.810107+00:00"
+"Directions": "Dundas St E to Hamilton St S"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-07T17:08:43Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T17:08:43Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6109"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29224637/30-hamilton-street-s-unit-305-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1006
+"OriginalEntryTimestamp": "2026-01-07T17:08:43.42Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29224637')"
+"ID": "516911"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 164
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]