array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29236873/Property?$select=ALL&$top=20&$filter=ListingKey eq 29236873&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29236873/Property?$select=ALL&$top=20&$filter=ListingKey eq 29236873&$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: "524595"
+post_author: 1
+"ListingKey": "29236873"
+"ListingId": "X12683140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T04:50:06Z"
+"RFModificationTimestamp": "2026-01-10T04:51:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y6"
+"UnparsedAddress": "BASEMENT - 171 GREAT FALLS BOULEVARD, Hamilton (Waterdown), Ontario L8B1Y6"
+"Coordinates": array:2 [
0 => -79.8749328
1 => 43.3382768
]
+"Latitude": 43.3382768
+"Longitude": -79.8749328
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright, spacious, and fully legal 3-bedroom, 2-bathroom basement apartment located in the highly desirable Waterdown community. With thoughtful design and generous living space, this home offers modern comfort and excellent ventilation, making it feel warm, inviting, and truly livable year-round.Step inside to find a well-planned layout featuring three full-sized bedrooms, perfect for families, professionals, or roommates seeking privacy and comfort. The two updated bathrooms provide convenience and functionality, while the open living and dining areas create a welcoming environment ideal for relaxing or entertaining.The unit is situated in a quiet, family-friendly neighbourhood known for its safety, charm, and strong sense of community. Daily life is made easier with close proximity to Highway 403, public transit routes, multiple grocery stores, shopping plazas, schools, parks, cafés, and other essential amenities. Whether you're commuting, running errands, or enjoying local trails and recreation, everything you need is right at your doorstep.With an unbeatable combination of location, comfort, and practical living, this apartment presents a fantastic opportunity for those looking for quality housing in Waterdown. (id:62650)"
+"Basement": array:5 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T04:31:08.035343+00:00"
+"Directions": "GREAT FALLS BLVD & SEALEY AVE."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146090"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"LotSizeDimensions": "46.4 x 90.4 FT ; 34.85 ft x 23.24 ft x 73.97 ft x 51.29 f"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T04:11:21Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T04:39:43Z"
+"Stories": "2.0"
+"StreetName": "Great Falls"
+"StreetNumber": "171"
+"StreetSuffix": "Boulevard"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1558559371"
"RoomType" => "Living room"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29236873"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
1 => array:11 [
"RoomKey" => "1558559372"
"RoomType" => "Dining room"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29236873"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
2 => array:11 [
"RoomKey" => "1558559373"
"RoomType" => "Bedroom"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 3.9
"ListingKey" => "29236873"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
3 => array:11 [
"RoomKey" => "1558559374"
"RoomType" => "Bedroom 2"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 2.89
"ListingKey" => "29236873"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
4 => array:11 [
"RoomKey" => "1558559375"
"RoomType" => "Bedroom 3"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 2.55
"ListingKey" => "29236873"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29236873/basement-171-great-falls-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 46.4
+"OriginalEntryTimestamp": "2026-01-10T04:11:21.76Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:11 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398828341"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/864e0e6d1c05e333cd7a17c2475ff840.webp"
"MediaSize" => 231781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-864e0e6d1c05e333cd7a17c2475ff840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398828346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/196b17df1775e2ad17c2fa1ff91bc6d2.webp"
"MediaSize" => 112242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-196b17df1775e2ad17c2fa1ff91bc6d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398828350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/18d40bed1f6c7de96d087edb07cc735b.webp"
"MediaSize" => 212790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-18d40bed1f6c7de96d087edb07cc735b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398828354"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/b633c5603db6a82917ddbd603da62416.webp"
"MediaSize" => 132404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-b633c5603db6a82917ddbd603da62416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398828359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/7a5161f0b34464f6ee2cd6a1eabd3306.webp"
"MediaSize" => 135972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-7a5161f0b34464f6ee2cd6a1eabd3306.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398828364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/57e4f40653f6237fb44ec7364c78fe83.webp"
"MediaSize" => 127258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-57e4f40653f6237fb44ec7364c78fe83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398828367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/78b24b0a98cc18d1e71d1bbf53049bf0.webp"
"MediaSize" => 130954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-78b24b0a98cc18d1e71d1bbf53049bf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398828371"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/33f8b61b6159cbf25289c249dd6d5628.webp"
"MediaSize" => 121236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-33f8b61b6159cbf25289c249dd6d5628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398828378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/0a0ccaf9fa30264722ff4f9d64ddda05.webp"
"MediaSize" => 130468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-0a0ccaf9fa30264722ff4f9d64ddda05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398828384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/93f842a7927af016bd2fe5e929bdfb75.webp"
"MediaSize" => 114688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-93f842a7927af016bd2fe5e929bdfb75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398828390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/bdd96f97b6763142c0422e8677c71c33.webp"
"MediaSize" => 117383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-bdd96f97b6763142c0422e8677c71c33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "RAMIN ALOKOZAY"
"MemberFirstName" => "RAMIN"
"MemberLastName" => "ALOKOZAY"
"MemberMlsId" => "9611874"
"OriginatingSystemName" => 26
"MemberKey" => "2146090"
"ModificationTimestamp" => "2025-12-15T09:59:54Z"
"MemberStatus" => "Active"
"OfficeKey" => "270920"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:5 [ …5]
"MemberOfficePhone" => "416-910-5424"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-09-21T15:20:00Z"
"MemberNationalAssociationId" => "1397417"
"OfficeNationalAssociationId" => "1236912"
]
]
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RIGHT AT HOME REALTY, BROKERAGE"
"OfficePhone" => "905-637-1700"
"OfficeMlsId" => "466000"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293485"
"ModificationTimestamp" => "2025-01-12T14:00:57Z"
"OfficeAddress1" => "5111 New Street, Suite 106"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7L1V"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Niagara"
"OfficeType" => "Firm"
"OfficeAORKey" => "114"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2022-10-27T17:59:00Z"
"OfficeNationalAssociationId" => "1427673"
"OfficeBrokerNationalAssociationId" => "1411464"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236873')"
+"ID": "524595"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293485/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293485&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293485/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293485&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25248
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RIGHT AT HOME REALTY, BROKERAGE"
+"OfficeEmail": null
+"OfficePhone": "905-637-1700"
+"OfficeMlsId": "466000"
+"ModificationTimestamp": "2025-01-12T14:00:57Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293485"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5111 New Street, Suite 106"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7L1V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Niagara"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1427673"
+"OriginalEntryTimestamp": "2022-10-27T17:59:00Z"
+"OfficeAORKey": "114"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "262705"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "293485"
"SocialMediaUrlOrId" => "http://www.rightathomerealtycom/"
"ModificationTimestamp" => "2024-12-05T12:52:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1411464"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293485')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2146090/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2146090&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2146090/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2146090&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25253
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29236873" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24894
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29236873/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29236873&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29236873/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29236873&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24874
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29236873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8749328 43.3382768)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29236873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8749328 43.3382768)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29236873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8749328 43.3382768)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29236873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8749328 43.3382768)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25113
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24829
+post_id: "525177"
+post_author: 1
+"ListingKey": "29237377"
+"ListingId": "X12683678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T17:50:24Z"
+"RFModificationTimestamp": "2026-01-10T18:42:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "612 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and sunny 1-bedroom condo with underground parking and locker in a well-managed, modern condo community. This stylish unit features an unobstructed balcony, upgraded flooring, sleek kitchen cabinetry, granite countertops, and upgraded stainless steel appliances. You'll also enjoy full-sized front-loading laundry, and a contemporary bathroom vanity with quartz finishes. The building offers top-tier amenities including a fully equipped gym, rooftop terrace with BBQs, elegant party room, and secure bike storage. Conveniently located just minutes from Aldershot GO, major highways, scenic trails, shops, and a short drive to Lake Ontario. Available immediately for a one-year lease. Full credit check, employment letter, rental application, and two months' deposit required. Book your showing today and make this space your next home! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-01-10T18:41:48.582202+00:00"
+"Directions": "Dundas/Mallard/Riverwalk"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048285"
+"ListOfficeKey": "257079"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-10T17:41:10Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T17:41:10Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1558671961"
"RoomType" => "Bedroom"
"ListingId" => "X12683678"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29237377"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.54Z"
]
1 => array:11 [
"RoomKey" => "1558671962"
"RoomType" => "Living room"
"ListingId" => "X12683678"
"RoomLevel" => "Main level"
"RoomWidth" => 4.09
"ListingKey" => "29237377"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.54Z"
]
2 => array:11 [
"RoomKey" => "1558671963"
"RoomType" => "Kitchen"
"ListingId" => "X12683678"
"RoomLevel" => "Main level"
"RoomWidth" => 2.24
"ListingKey" => "29237377"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.54Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29237377/612-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 1995
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-10T17:41:10.52Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:24 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6399198308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/3a4ed485dc93cfe35de98e20625b130c.webp"
"MediaSize" => 169185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-3a4ed485dc93cfe35de98e20625b130c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6399198315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/3b0996621b24e6da3a6f9a924350d248.webp"
"MediaSize" => 274842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-3b0996621b24e6da3a6f9a924350d248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6399198321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/59db82daf22e84d799e5cc6dc9b39e3a.webp"
"MediaSize" => 101987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-59db82daf22e84d799e5cc6dc9b39e3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6399198330"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/b8e05037390c602d0b7d9e3915b7848f.webp"
"MediaSize" => 231210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-b8e05037390c602d0b7d9e3915b7848f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6399198337"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/64465f705e077a2190a1964bf25dda3a.webp"
"MediaSize" => 97529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-64465f705e077a2190a1964bf25dda3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6399198345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/a8a37a71fa5b0267603e6848cb7c83c8.webp"
"MediaSize" => 198741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-a8a37a71fa5b0267603e6848cb7c83c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6399198359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/5b87645c8ec1d9ffad557aa915d3c062.webp"
"MediaSize" => 144392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-5b87645c8ec1d9ffad557aa915d3c062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6399198384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/633c3743addde9b53fab8e75867a751e.webp"
"MediaSize" => 131937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-633c3743addde9b53fab8e75867a751e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6399198411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/16e25cddd62a398193b55105b2dfebe3.webp"
"MediaSize" => 131544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-16e25cddd62a398193b55105b2dfebe3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6399198427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/cf010513e1d7d411a38d2f7df8e22f8f.webp"
"MediaSize" => 84379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-cf010513e1d7d411a38d2f7df8e22f8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6399198438"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/749dc6fe14b71463b721ccf94e285a82.webp"
"MediaSize" => 65879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-749dc6fe14b71463b721ccf94e285a82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6399198465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/6a3a2e16dc470e71fb48b067326d2d04.webp"
"MediaSize" => 78359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-6a3a2e16dc470e71fb48b067326d2d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6399198470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/a97f4dec055c9f71d8535730eff73a24.webp"
"MediaSize" => 78630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-a97f4dec055c9f71d8535730eff73a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6399198496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/1d7fe8f8e0d7b8464469a52b61eb1417.webp"
"MediaSize" => 152559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-1d7fe8f8e0d7b8464469a52b61eb1417.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6399198511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/73e4bc047eb7bac5e833fafffb6b5a6e.webp"
"MediaSize" => 67752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-73e4bc047eb7bac5e833fafffb6b5a6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6399198569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/6929a689d39d1dc1fe4d521f1b28610e.webp"
"MediaSize" => 69326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-6929a689d39d1dc1fe4d521f1b28610e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6399198604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/b308f2514865a3f8d7c600289065caa2.webp"
"MediaSize" => 257637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-b308f2514865a3f8d7c600289065caa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6399198641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/87665e634aa3c75c7715cbed2a5ced28.webp"
"MediaSize" => 117293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-87665e634aa3c75c7715cbed2a5ced28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6399198654"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/cf3234f25f4c6a1a920e032fcb6d7f79.webp"
"MediaSize" => 112230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-cf3234f25f4c6a1a920e032fcb6d7f79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6399198712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/fe946241761339c6ade24a53880f758e.webp"
"MediaSize" => 189648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-fe946241761339c6ade24a53880f758e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6399198746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/6e220d7acc2a59475c085bdd502388ba.webp"
"MediaSize" => 147383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-6e220d7acc2a59475c085bdd502388ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6399198814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/182f9ef52f9c978d6d37351e44a5d2af.webp"
"MediaSize" => 117115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-182f9ef52f9c978d6d37351e44a5d2af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6399198826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/b6731c1a706b502c3234ce89dc654b20.webp"
"MediaSize" => 122146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-b6731c1a706b502c3234ce89dc654b20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6399198850"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237377/0caa41074b238d4e202e9f3ff6064f75.webp"
"MediaSize" => 113544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237377/thumbnail-0caa41074b238d4e202e9f3ff6064f75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683678"
"ResourceRecordKey" => "29237377"
"ModificationTimestamp" => "2026-01-10T17:41:10.53Z"
]
]
+"Member": array:1 [
0 => array:4 [
"MemberMlsId" => "2048285"
"OriginatingSystemName" => 26
"MemberKey" => "2048285"
"ModificationTimestamp" => "2024-11-12T20:35:59Z"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "FUTURE GROUP REALTY SERVICES LTD."
"OfficePhone" => "905-274-3434"
"OfficeMlsId" => "172500"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "257079"
"ModificationTimestamp" => "2024-09-26T21:27:47Z"
"OfficeAddress1" => "236 WILLARD AVENUE MAIN FLR"
"OfficeCity" => "TORONTO"
"OfficePostalCode" => "M6S3P8"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "647-494-0181"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2010-08-13T03:21:00Z"
"OfficeNationalAssociationId" => "1213993"
"OfficeBrokerNationalAssociationId" => "1216486"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237377')"
+"ID": "525177"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25100
+post_id: "524488"
+post_author: 1
+"ListingKey": "29236583"
+"ListingId": "X12682864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T01:20:45Z"
+"RFModificationTimestamp": "2026-01-10T03:45:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "212 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.8837091
1 => 43.3486947
]
+"Latitude": 43.3486947
+"Longitude": -79.8837091
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautiful detached home is over 2200 sqft, main floor offers 9 ft ceilings, an open concept with maple hardwood floors, maple wood staircase with steel pickets, large great room, upgraded chef's kitchen with quartz countertops, high end stainless steel appliances, walk in pantry, zebra window coverings on main floor, California shutters on 2nd floor. 4 bedrooms w/large mbdrm w/his and hers walk in closets, glass uper shower in master ensuite and 2nd floor laundry. Comes with Gazebo, Outdoor furniture and the deck! (id:62650)"
+"Appliances": array:2 [
0 => "Oven - Built-In"
1 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T03:45:34.846371+00:00"
+"Directions": "Dundas & Spring Creek"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2131503"
+"ListOfficeKey": "295098"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T01:13:07Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T01:13:07Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "212"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:1 [
0 => array:11 [
"RoomKey" => "1558502785"
"RoomType" => "Dining room"
"ListingId" => "X12682864"
"RoomLevel" => "Main level"
"RoomWidth" => 7.0
"ListingKey" => "29236583"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T01:13:07.44Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29236583/212-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"TotalActualRent": 3199
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-10T01:13:07.35Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398691507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/6e5f600a6381a1e228ac7c5a505c3a63.webp"
"MediaSize" => 183775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-6e5f600a6381a1e228ac7c5a505c3a63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398691511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/ce0765962d405c3ac9c2a89ee17bed40.webp"
"MediaSize" => 182858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-ce0765962d405c3ac9c2a89ee17bed40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398691517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/c318ef40982d0d23dc51c2012cf6c574.webp"
"MediaSize" => 397142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-c318ef40982d0d23dc51c2012cf6c574.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398691520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/dde1ac3d86be7042e6e117f8b9218791.webp"
"MediaSize" => 251414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-dde1ac3d86be7042e6e117f8b9218791.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398691526"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/2a2931214696387e2e3c817c7cb7abf9.webp"
"MediaSize" => 217231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-2a2931214696387e2e3c817c7cb7abf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398691541"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/f9c0500efacd09cd8d7a43e69ef5d0df.webp"
"MediaSize" => 170611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-f9c0500efacd09cd8d7a43e69ef5d0df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398691550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/c93ed0d4cdce2b89f706e2ab427b207a.webp"
"MediaSize" => 202186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-c93ed0d4cdce2b89f706e2ab427b207a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398691558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/5011cf7fd576a7255048d6376fa229af.webp"
"MediaSize" => 195098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-5011cf7fd576a7255048d6376fa229af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398691571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/f4516fb82244ba7946d000a6b032ec3d.webp"
"MediaSize" => 271671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-f4516fb82244ba7946d000a6b032ec3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398691581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/dbfd21aa7088dd2383122371e4ebdfbb.webp"
"MediaSize" => 160493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-dbfd21aa7088dd2383122371e4ebdfbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398691590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/9db31cd8bea4fda8bc7809cab55b7a6b.webp"
"MediaSize" => 367911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-9db31cd8bea4fda8bc7809cab55b7a6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398691606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/f9eb7cbba07fdc80e38b8d0e14ae9a94.webp"
"MediaSize" => 360005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-f9eb7cbba07fdc80e38b8d0e14ae9a94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398691617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/cfb31551f45cfc747f0cefd38559948f.webp"
"MediaSize" => 212824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-cfb31551f45cfc747f0cefd38559948f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398691627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/58042dccf6a1ef8c11f66ebadeab1647.webp"
"MediaSize" => 212921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-58042dccf6a1ef8c11f66ebadeab1647.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398691640"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/7d014dd2b6754c23b2250cc69d715b15.webp"
"MediaSize" => 169101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-7d014dd2b6754c23b2250cc69d715b15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6398691652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/ff3ad200f07186946d3bcf1c3718140b.webp"
"MediaSize" => 213773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-ff3ad200f07186946d3bcf1c3718140b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6398691659"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/5c35f2605f72cefcdfe44ea86e396f01.webp"
"MediaSize" => 346871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-5c35f2605f72cefcdfe44ea86e396f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6398691670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/08e687e8c49a244e780feceb03f30b58.webp"
"MediaSize" => 113530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-08e687e8c49a244e780feceb03f30b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6398691681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/a910df0ab2721a1b43cc8d6c438143aa.webp"
"MediaSize" => 95452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-a910df0ab2721a1b43cc8d6c438143aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6398691697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/1f14000fb0b8875cee0f6b8a6072551b.webp"
"MediaSize" => 188427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-1f14000fb0b8875cee0f6b8a6072551b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6398691703"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/7f441a6ad60fcfb727e7d1cc815e08bc.webp"
"MediaSize" => 209625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-7f441a6ad60fcfb727e7d1cc815e08bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6398691712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/67dae6868c7ae1a5c7172691e0b3eecf.webp"
"MediaSize" => 253230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-67dae6868c7ae1a5c7172691e0b3eecf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6398691723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/4ce8b1535bb2dca7a78d7ac267227f81.webp"
"MediaSize" => 198834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-4ce8b1535bb2dca7a78d7ac267227f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6398691729"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/211a679813a5f24949478d22f75fd173.webp"
"MediaSize" => 124497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-211a679813a5f24949478d22f75fd173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6398691737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/1827da23b77cd24d5f8da1b80936fb02.webp"
"MediaSize" => 204188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-1827da23b77cd24d5f8da1b80936fb02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6398691741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/443745d09c2698718dde7e079366203b.webp"
"MediaSize" => 206840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-443745d09c2698718dde7e079366203b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6398691749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/40e4aba1cb08c38c9c32379b03642211.webp"
"MediaSize" => 224167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-40e4aba1cb08c38c9c32379b03642211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6398691758"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/c9a162a88df8c1b7ca2052fba2f57cb1.webp"
"MediaSize" => 161048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-c9a162a88df8c1b7ca2052fba2f57cb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682864"
"ResourceRecordKey" => "29236583"
"ModificationTimestamp" => "2026-01-10T01:13:07.37Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6398691766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236583/d93f411923bcd792fed664048e769eda.webp"
"MediaSize" => 278832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236583/thumbnail-d93f411923bcd792fed664048e769eda.webp"
"ResourceName" => "Property"
…6
]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236583')"
+"ID": "524488"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24830
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235192')"
+"ID": "523751"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24766
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24724
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24833
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233700')"
+"ID": "522840"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24782
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24789
+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"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 163
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]