array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29224637/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224637&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224637/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224637&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23445
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23447
+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 [
"RoomKey" => "1557591009"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.51Z"
]
1 => array:11 [
"RoomKey" => "1557591010"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.52Z"
]
2 => array:11 [
"RoomKey" => "1557591011"
"RoomType" => "Bedroom"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.52Z"
]
3 => array:11 [
"RoomKey" => "1557591012"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.52Z"
]
4 => array:11 [
"RoomKey" => "1557591013"
"RoomType" => "Kitchen"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.52Z"
]
5 => array:11 [
"RoomKey" => "1557591014"
"RoomType" => "Den"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.53Z"
]
6 => array:11 [
"RoomKey" => "1557591015"
"RoomType" => "Dining room"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.53Z"
]
7 => array:11 [
"RoomKey" => "1557591016"
"RoomType" => "Living room"
"ListingId" => "40796696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224637"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:08:43.53Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6395506042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/f7553d10f81d5674bf7b307801818f86.webp"
"MediaSize" => 100643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-f7553d10f81d5674bf7b307801818f86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6395506057"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/7b3bc84e716b26e9049035b6062e1e0f.webp"
"MediaSize" => 158329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-7b3bc84e716b26e9049035b6062e1e0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6395506064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/08b55328dc03a876086b6188fc601ca7.webp"
"MediaSize" => 151063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-08b55328dc03a876086b6188fc601ca7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6395506074"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/8499f9cac58d6edf879217d587cb434b.webp"
"MediaSize" => 85266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-8499f9cac58d6edf879217d587cb434b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6395506091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/d0ef9686e6c4396cd74a9087dff5ab06.webp"
"MediaSize" => 45929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-d0ef9686e6c4396cd74a9087dff5ab06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6395506103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/638cb476f5c71a9d8bed802fcd9dddb3.webp"
"MediaSize" => 65749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-638cb476f5c71a9d8bed802fcd9dddb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6395506129"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/0b26ca8128b48d97932a78f9876fbde0.webp"
"MediaSize" => 57758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-0b26ca8128b48d97932a78f9876fbde0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6395506169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/43aea12c9b29b9411fa52b4a711159a9.webp"
"MediaSize" => 53900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-43aea12c9b29b9411fa52b4a711159a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6395506173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/31777da056d0199db3dc155c1bafed80.webp"
"MediaSize" => 64764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-31777da056d0199db3dc155c1bafed80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6395506231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/cdd5356c3408f4220e246a09a866dc7a.webp"
"MediaSize" => 66256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-cdd5356c3408f4220e246a09a866dc7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6395506260"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/54e8f1713dbfbf2720f5fce15520a126.webp"
"MediaSize" => 58205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-54e8f1713dbfbf2720f5fce15520a126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6395506294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/166ddd01c334049355a2b0370ba0bbe5.webp"
"MediaSize" => 71452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-166ddd01c334049355a2b0370ba0bbe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6395506329"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/54390ae8f05a54380422ae87b7690f6f.webp"
"MediaSize" => 67199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-54390ae8f05a54380422ae87b7690f6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6395506355"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/997d5d357c83068d3ca109423231ded4.webp"
"MediaSize" => 79939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-997d5d357c83068d3ca109423231ded4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6395506363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/45bf131704407071d2331ceb6983227f.webp"
"MediaSize" => 85585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-45bf131704407071d2331ceb6983227f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6395506390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/9a6f795332a67ee950c5db499cfca54d.webp"
"MediaSize" => 70978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-9a6f795332a67ee950c5db499cfca54d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6395506438"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/f35041ed5f84b5e1195b5f5d08b3a2d0.webp"
"MediaSize" => 79605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-f35041ed5f84b5e1195b5f5d08b3a2d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6395506456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/37ded537b26a680d3e3430f09080e5e1.webp"
"MediaSize" => 66459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-37ded537b26a680d3e3430f09080e5e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6395506484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/961a985991c6a787d2ff3eb1451000dc.webp"
"MediaSize" => 43719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-961a985991c6a787d2ff3eb1451000dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6395506504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/49821557c076f66083e15cd7bd675d6a.webp"
"MediaSize" => 60938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-49821557c076f66083e15cd7bd675d6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6395506523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/b71839a30e99614b813571d255cb8035.webp"
"MediaSize" => 74481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-b71839a30e99614b813571d255cb8035.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6395506561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/52904a1d579cc949d99f620b0d2c4b52.webp"
"MediaSize" => 52905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-52904a1d579cc949d99f620b0d2c4b52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6395506599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/4af38d3bdcd98b8a5723572f67897801.webp"
"MediaSize" => 108747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-4af38d3bdcd98b8a5723572f67897801.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6395506619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/b0fc4db8c243ddc834a41b1f37a492a1.webp"
"MediaSize" => 114163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-b0fc4db8c243ddc834a41b1f37a492a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6395506639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/30041da05a19d8dcd2a27c60709c032b.webp"
"MediaSize" => 163727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-30041da05a19d8dcd2a27c60709c032b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6395506649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/d5c71bdc1e3a4105588cd7d4cd3b4c51.webp"
"MediaSize" => 138835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-d5c71bdc1e3a4105588cd7d4cd3b4c51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6395506665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/613546f61cc516986c9d152a405601c7.webp"
"MediaSize" => 75778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-613546f61cc516986c9d152a405601c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6395506683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/ec0649c2810ce5f75eb1debc56197149.webp"
"MediaSize" => 73316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-ec0649c2810ce5f75eb1debc56197149.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6395506711"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/eddd8df52745ac5a26f520745f2f97aa.webp"
"MediaSize" => 54791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-eddd8df52745ac5a26f520745f2f97aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6395506725"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/9ad207505e8a5bf73bea3f06618e122b.webp"
"MediaSize" => 76470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-9ad207505e8a5bf73bea3f06618e122b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6395506738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/4d34822d6018a31e361e8b25ff2973fb.webp"
"MediaSize" => 75740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-4d34822d6018a31e361e8b25ff2973fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6395506750"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/0e85d16b8431f358eb5c18db56bc00c6.webp"
"MediaSize" => 88432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-0e85d16b8431f358eb5c18db56bc00c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6395506771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/618b37b647f6d88a493688f9bb95aada.webp"
"MediaSize" => 71032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-618b37b647f6d88a493688f9bb95aada.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6395506781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/e78d31bb7b3794323fc3848918790a69.webp"
"MediaSize" => 112780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-e78d31bb7b3794323fc3848918790a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6395506806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/d3908613cdf9713d787a9bb2a475e682.webp"
"MediaSize" => 168808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-d3908613cdf9713d787a9bb2a475e682.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6395506810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/03c751ad0bd8b806920caf804de70039.webp"
"MediaSize" => 145971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-03c751ad0bd8b806920caf804de70039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6395506826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/3cc8daf7daadc5d01c3a2110c17b0559.webp"
"MediaSize" => 105514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-3cc8daf7daadc5d01c3a2110c17b0559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6395506834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/d80d6a6be0ee4c097e00e7d2a187aa69.webp"
"MediaSize" => 119185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-d80d6a6be0ee4c097e00e7d2a187aa69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6395506845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224637/6570a693de29a3bed2a5e3c7dec634b3.webp"
"MediaSize" => 171884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224637/thumbnail-6570a693de29a3bed2a5e3c7dec634b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796696"
"ResourceRecordKey" => "29224637"
"ModificationTimestamp" => "2026-01-07T17:08:43.43Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Drew Woolcott"
"MemberFirstName" => "Drew"
"MemberLastName" => "Woolcott"
"MemberMlsId" => "HBWOOLCDR"
"OriginatingSystemName" => 26
"MemberKey" => "1525426"
"ModificationTimestamp" => "2025-12-09T16:11:41Z"
"MemberStatus" => "Active"
"OfficeKey" => "293261"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberCity" => "Waterdown"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-332-9223"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1063673"
"OfficeNationalAssociationId" => "1424570"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX Escarpment Realty Inc."
"OfficePhone" => "905-689-9223"
"OfficeMlsId" => "HBRMXESCDUND"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293261"
"ModificationTimestamp" => "2025-07-09T18:36:53Z"
"OfficeAddress1" => "#1B-493 Dundas Street E."
"OfficeCity" => "Waterdown"
"OfficePostalCode" => "L0R2H"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2022-09-12T18:20:00Z"
"OfficeNationalAssociationId" => "1424570"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1064286"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29224637')"
+"ID": "516911"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25286
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-689-9223"
+"OfficeMlsId": "HBRMXESCDUND"
+"ModificationTimestamp": "2025-07-09T18:36:53Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293261"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#1B-493 Dundas Street E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterdown"
+"OfficePostalCode": "L0R2H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1424570"
+"OriginalEntryTimestamp": "2022-09-12T18:20:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439666"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "293261"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-07-09T18:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293261')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525426/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525426&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525426/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525426&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29224637" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24904
+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 29224637/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224637&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224637/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224637&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24884
+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 29224637 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8940031 43.3303163)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224637 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8940031 43.3303163)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224637 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8940031 43.3303163)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224637 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8940031 43.3303163)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24819
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24753
+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"
…5
]
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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24831
+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 {#24760
+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 {#24826
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24812
+post_id: "523068"
+post_author: 1
+"ListingKey": "29233329"
+"ListingId": "X12679884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:50:09Z"
+"RFModificationTimestamp": "2026-01-09T16:58:07Z"
+"ListPrice": 699800.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "53 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.907957
1 => 43.3367114
]
+"Latitude": 43.3367114
+"Longitude": -79.907957
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning semi-detached home located in one of the best pockets of Waterdown! This beautifully updated home offers an open concept main floor area with hardwood floors, custom millwork, pot lights and a bay window overlooking the rear gardens. Gourmet kitchen boasts granite counters, an oversized island, upgraded cabinetry with mouldings and stainless steel appliances. Walk-out from the kitchen to deck and fully fenced private backyard. Two bright & spacious bedrooms and a spa-inspired bathroom complete the upper level. The unspoiled basement awaits your personal touch and includes a rough-in for a 3-piece bathroom. This family-friendly community is conveniently located within close proximity to shopping, great schools, the YMCA and fabulous parks. Welcome home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T16:57:42.402755+00:00"
+"Directions": "Parkside Dr & Hamilton St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1414333"
+"ListOfficeKey": "275900"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T15:42:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:42:55Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "53"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/53_cole_st_waterdown_on/"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29233329/53-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2026-01-09T15:42:55.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:32 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233329')"
+"ID": "523068"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24824
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23459
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24825
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24818
+post_id: "518980"
+post_author: 1
+"ListingKey": "29228819"
+"ListingId": "X12675804"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T15:51:09Z"
+"RFModificationTimestamp": "2026-01-08T16:06:08Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V9"
+"UnparsedAddress": "181 SPRINGVIEW DRIVE, Hamilton (Waterdown), Ontario L8B0V9"
+"Coordinates": array:2 [
0 => -79.9159008
1 => 43.3298005
]
+"Latitude": 43.3298005
+"Longitude": -79.9159008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your dream home featuring a premium lot & an entertainer's paradise in the backyard! Enjoy your private outdoor retreat complete with stamped concrete patio, elevated deck, beautifully landscaped grounds, vinyl fencing, gas line for BBQ & an incredible 17 ft Hydro pool. This versatile Hydro pool includes tranquil waterfalls, a convenient roll-up cover & functions as a swim spa, oversized hot tub, or refreshing summer pool. Upgrades in 2025 make this home truly move-in ready: Fully finished walk-out basement with bedroom, 3-pc bath, den, rec room & kitchenette - perfect for in-laws or guests. Engineered hardwood flooring throughout the bedroom level. Custom built-ins throughout provide exceptional storage and style. Quartz countertops in the kitchen & upstairs bathrooms. Brand new appliances (2025) included. Plus, anew shed for extra storage. This home combines luxury, functionality &outdoor living at its finest. RSA. SQFTA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T16:04:54.730500+00:00"
+"Directions": "Cross Streets: Parkside Dr & Mosaic Dr. ** Directions: Parkside Dr to Mosaic Dr, to Painter Terrace and right on Springview Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132248"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "32.2 x 138.4 FT ; 32.23ft x 114.82ft x 78.26ft x 138.41ft"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-08T15:44:43Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T15:44:42Z"
+"Stories": "2.0"
+"StreetName": "Springview"
+"StreetNumber": "181"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8471.23"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360094"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29228819/181-springview-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-48"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.2
+"OriginalEntryTimestamp": "2026-01-08T15:44:42.9Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228819')"
+"ID": "518980"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 168
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]