array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29856434 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1496309"
+post_author: 1
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T12:50:01Z"
+"RFModificationTimestamp": "2026-06-16T12:52:58Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7N3"
+"UnparsedAddress": "9 - 122 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7N3"
+"Coordinates": array:2 [
0 => -79.907264
1 => 43.320201
]
+"Latitude": 43.320201
+"Longitude": -79.907264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish spacious 3-bedroom townhome nestled in the heart of Waterdown, ideal for first-time buyers and young professionals. Thoughtfully designed layout offers bright, open-concept living with contemporary finishes throughout. Modern kitchen with ample cabinetry and prep space flows seamlessly into the living and dining areas, perfect for entertaining. Generous bedrooms provide comfort and flexibility for work-from-home or guest space. Large comfortable primary suite with a 4-piece ensuite. Outdoor patio area extends your living space for summer evenings and morning coffee. Well-managed complex with visitor parking and a strong sense of community. Conveniently located close to Rockcliffe trails, shops, cafes, parks, and everyday amenities. Easy access to major highways makes commuting effortless. A fantastic opportunity to enter the market in one of Waterdown's most in-demand neighbourhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "239.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T21:21:06.676709+00:00"
+"Directions": "Cross Streets: Dundas & Hollybush. ** Directions: South off Dundas."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154241"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T13:03:34Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:41:55Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "122"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3788"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/9_122_dundas_st_e_waterdown_on/"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660416915"
"RoomType" => "Family room"
"ListingId" => "X13242798"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.05
"ListingKey" => "29856434"
"RoomLength" => 5.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.17Z"
]
1 => array:11 [
"RoomKey" => "1660416916"
"RoomType" => "Great room"
"ListingId" => "X13242798"
"RoomLevel" => "Second level"
"RoomWidth" => 4.57
"ListingKey" => "29856434"
"RoomLength" => 5.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.18Z"
]
2 => array:11 [
"RoomKey" => "1660416917"
"RoomType" => "Kitchen"
"ListingId" => "X13242798"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29856434"
"RoomLength" => 2.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.18Z"
]
3 => array:11 [
"RoomKey" => "1660416918"
"RoomType" => "Dining room"
"ListingId" => "X13242798"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29856434"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.18Z"
]
4 => array:11 [
"RoomKey" => "1660416919"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13242798"
"RoomLevel" => "Third level"
"RoomWidth" => 4.08
"ListingKey" => "29856434"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.19Z"
]
5 => array:11 [
"RoomKey" => "1660416920"
"RoomType" => "Bedroom 2"
"ListingId" => "X13242798"
"RoomLevel" => "Third level"
"RoomWidth" => 2.68
"ListingKey" => "29856434"
"RoomLength" => 2.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.19Z"
]
6 => array:11 [
"RoomKey" => "1660416921"
"RoomType" => "Bedroom 3"
"ListingId" => "X13242798"
"RoomLevel" => "Third level"
"RoomWidth" => 2.56
"ListingKey" => "29856434"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T12:41:55.19Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29856434/9-122-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Arthex Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R6-36"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-04T20:57:05.39Z"
+"ListAgentNationalAssociationId": "1405758"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29856434_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/355b8b31e49066a5a1f3e1337752f10a.webp"
"MediaSize" => 97774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-355b8b31e49066a5a1f3e1337752f10a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29856434_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/2a6c4529830bf4770d00d732f9c132f2.webp"
"MediaSize" => 101537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-2a6c4529830bf4770d00d732f9c132f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29856434_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/c08aaa5448b6fa50b08d4b02d11aabd5.webp"
"MediaSize" => 41629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-c08aaa5448b6fa50b08d4b02d11aabd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29856434_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/2ec2ffe2cd2a7a5e813a4adeb7b7bbd4.webp"
"MediaSize" => 68712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-2ec2ffe2cd2a7a5e813a4adeb7b7bbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:18.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29856434_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/4236c03b50c4111fa839e5427ca0ef7f.webp"
"MediaSize" => 41390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-4236c03b50c4111fa839e5427ca0ef7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:27.52Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29856434_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/461e440a0a9fe14540a154ebaa88270b.webp"
"MediaSize" => 54383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-461e440a0a9fe14540a154ebaa88270b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:00.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29856434_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/7e8fcbf9942c07cb05a8841dc3b20932.webp"
"MediaSize" => 48181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-7e8fcbf9942c07cb05a8841dc3b20932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:25.27Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29856434_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/1d0491d6a59c063224193342b5c35f82.webp"
"MediaSize" => 73182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-1d0491d6a59c063224193342b5c35f82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:03.54Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29856434_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/edf0f356f47721ae1f1aad2559bb774d.webp"
"MediaSize" => 67835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-edf0f356f47721ae1f1aad2559bb774d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:03.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29856434_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/24fc88993a67bd6edb1e58af0cf5b39d.webp"
"MediaSize" => 69699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-24fc88993a67bd6edb1e58af0cf5b39d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:02:59.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29856434_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/d0f890a6916e242b1b6f2b75dbb591b0.webp"
"MediaSize" => 70541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-d0f890a6916e242b1b6f2b75dbb591b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:25.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29856434_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/822fa21940cd230db0a15f86b36ddfcf.webp"
"MediaSize" => 63130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-822fa21940cd230db0a15f86b36ddfcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:31.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29856434_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/9451007880d7667705112cc52353177d.webp"
"MediaSize" => 87671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-9451007880d7667705112cc52353177d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:34Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29856434_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/44531273a2b5142dbcae0375f7ec6b3d.webp"
"MediaSize" => 88028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-44531273a2b5142dbcae0375f7ec6b3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:01.84Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29856434_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/b281fa24939f7606bddbbc7d731c6a16.webp"
"MediaSize" => 55214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-b281fa24939f7606bddbbc7d731c6a16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:06.97Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29856434_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/6b636846e0d362eadd9b661e22288d68.webp"
"MediaSize" => 68763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-6b636846e0d362eadd9b661e22288d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:02.29Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29856434_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/352b3d7fb40738918b1d0a51f9355517.webp"
"MediaSize" => 53184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-352b3d7fb40738918b1d0a51f9355517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:02.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29856434_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/c29878ca3986f5ff0cdb03e3dd3001a3.webp"
"MediaSize" => 63214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-c29878ca3986f5ff0cdb03e3dd3001a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:08.3Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29856434_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/15a4d802abb6b4f811c21b93ae958a23.webp"
"MediaSize" => 53838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-15a4d802abb6b4f811c21b93ae958a23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:14.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29856434_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/169408dc6afd6726022ac3effec24dab.webp"
"MediaSize" => 37570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-169408dc6afd6726022ac3effec24dab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:21.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29856434_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/a70dc99d26080562dcf78b1dff3bfec1.webp"
"MediaSize" => 49529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-a70dc99d26080562dcf78b1dff3bfec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:03.07Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29856434_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/c62ca9fce406c223756da2041d733405.webp"
"MediaSize" => 41489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-c62ca9fce406c223756da2041d733405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-05T13:03:08.3Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29856434_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/2c2ce1fd36cdee79c6c6914eeaec98c4.webp"
"MediaSize" => 58907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-2c2ce1fd36cdee79c6c6914eeaec98c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29856434_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/bd973410d4d4f330fcf4134b58b2178d.webp"
"MediaSize" => 60234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-bd973410d4d4f330fcf4134b58b2178d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29856434_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/b4f804c2b9788e99e3302643a7ada625.webp"
"MediaSize" => 136410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-b4f804c2b9788e99e3302643a7ada625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29856434_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/64e0863e07535fc5ec3d83f2f26c32ef.webp"
"MediaSize" => 105127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-64e0863e07535fc5ec3d83f2f26c32ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29856434_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29856434/075fb8ab0a6fe760fc92769264a74e5c.webp"
"MediaSize" => 96576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29856434/thumbnail-075fb8ab0a6fe760fc92769264a74e5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13242798"
"ResourceRecordKey" => "29856434"
"ModificationTimestamp" => "2026-06-04T20:57:05.4Z"
]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856434')"
+"ID": "1496309"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 280225" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24713
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2154241" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24717
+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 '29856434'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25180
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29856434'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25193
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25196
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31319600"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T12:00:00Z"
+"OpenHouseEndTime": "2026-06-06T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T05:18:55Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31319600')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31319601"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T12:00:00Z"
+"OpenHouseEndTime": "2026-06-07T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T09:50:59Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31319601')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31369955"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T12:00:00Z"
+"OpenHouseEndTime": "2026-06-07T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-08T04:02:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31369955')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31385962"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T01:47:25Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31385962')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25197
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31385963"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T10:52:21Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31385963')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31481137"
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-15T05:12:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31481137')"
}
]
+success: true
+page_size: 6
+page_count: 1
+count: 6
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29856434' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.907264 43.320201)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1539021"
+post_author: 1
+"ListingKey": "29915426"
+"ListingId": "X13455236"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:10:13Z"
+"RFModificationTimestamp": "2026-06-17T16:21:43Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J9"
+"UnparsedAddress": "178 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L8B0J9"
+"Coordinates": array:2 [
0 => -79.903351
1 => 43.332329
]
+"Latitude": 43.332329
+"Longitude": -79.903351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Freehold semi-detached home on child-friendly street in desirable Waterdown! This very clean and bright brick home with a covered front porch features an open-concept kitchen and dining area overlooking the family room with a cozy gas fireplace. Walk out to the generous backyard with large decks and plenty of green space for kids and pets to enjoy. The spacious Primary bedroom offers a 4-piece ensuite and a walk-in closet with built-in organizers, complemented by Closets by Design organizers in the foyer and all other bedrooms. Recent upgrades include: appliances, backyard deck, engineered hardwood flooring throughout the upper level, updated stair carpeting, front door blinds, and Kohler toilets with bidet assemblies in both the ensuite and main bathroom. The home is also equipped with an alarm system featuring a doorbell camera, front and rear exterior cameras, garage sensors, and three door sensors for peace of mind. Fantastic location within walking distance to Memorial Park with splash pad, baseball diamonds, and year-round skating. Surrounded by the Greenbelt and close to parks, trails, the farmers' market, schools, YMCA, shopping, restaurants, and everyday amenities. Just 10 minutes to Aldershot GO Station with quick access to the 403, 407, and QEW. This home is a real gem! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Alarm System"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:21:32.702523+00:00"
+"Directions": "Cross Streets: ROCKHAVEN LN AND SEGWUN RD. ** Directions: DUNDAS ST E, HAMILTON ST N, WHITE OAK DR, CHUDLEIGH ST."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972724"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "26.3 x 119.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T15:03:10Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:03:10Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "178"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5646"
+"VirtualTourURLUnbranded": "https://youriguide.com/178_chudleigh_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1661166053"
"RoomType" => "Foyer"
"ListingId" => "X13455236"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29915426"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
1 => array:11 [
"RoomKey" => "1661166054"
"RoomType" => "Utility room"
"ListingId" => "X13455236"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29915426"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
2 => array:11 [
"RoomKey" => "1661166055"
"RoomType" => "Laundry room"
"ListingId" => "X13455236"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29915426"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
3 => array:11 [
"RoomKey" => "1661166056"
"RoomType" => "Bathroom"
"ListingId" => "X13455236"
"RoomLevel" => "Main level"
"RoomWidth" => 1.86
"ListingKey" => "29915426"
"RoomLength" => 1.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
4 => array:11 [
"RoomKey" => "1661166057"
"RoomType" => "Kitchen"
"ListingId" => "X13455236"
"RoomLevel" => "Main level"
"RoomWidth" => 2.85
"ListingKey" => "29915426"
"RoomLength" => 5.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
5 => array:11 [
"RoomKey" => "1661166058"
"RoomType" => "Living room"
"ListingId" => "X13455236"
"RoomLevel" => "Main level"
"RoomWidth" => 3.39
"ListingKey" => "29915426"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
6 => array:11 [
"RoomKey" => "1661166059"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13455236"
"RoomLevel" => "Second level"
"RoomWidth" => 4.24
"ListingKey" => "29915426"
"RoomLength" => 6.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
7 => array:11 [
"RoomKey" => "1661166060"
"RoomType" => "Bedroom 2"
"ListingId" => "X13455236"
"RoomLevel" => "Second level"
"RoomWidth" => 2.88
"ListingKey" => "29915426"
"RoomLength" => 5.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
8 => array:11 [
"RoomKey" => "1661166061"
"RoomType" => "Bedroom 3"
"ListingId" => "X13455236"
"RoomLevel" => "Second level"
"RoomWidth" => 2.93
"ListingKey" => "29915426"
"RoomLength" => 3.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.63Z"
]
9 => array:11 [
"RoomKey" => "1661166062"
"RoomType" => "Bathroom"
"ListingId" => "X13455236"
"RoomLevel" => "Second level"
"RoomWidth" => 2.2
"ListingKey" => "29915426"
"RoomLength" => 2.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.64Z"
]
10 => array:11 [
"RoomKey" => "1661166063"
"RoomType" => "Other"
"ListingId" => "X13455236"
"RoomLevel" => "Basement"
"RoomWidth" => 5.96
"ListingKey" => "29915426"
"RoomLength" => 7.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.64Z"
]
11 => array:11 [
"RoomKey" => "1661166064"
"RoomType" => "Other"
"ListingId" => "X13455236"
"RoomLevel" => "Basement"
"RoomWidth" => 3.21
"ListingKey" => "29915426"
"RoomLength" => 4.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T15:03:10.64Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915426/178-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"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": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-06-17T15:03:10.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1259714"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29915426_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/1cbd726a7b61befd9b7428c61d039fda.webp"
"MediaSize" => 205827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-1cbd726a7b61befd9b7428c61d039fda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29915426_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/f8f0217d36eb4c4c28be46bee67f84ad.webp"
"MediaSize" => 214006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-f8f0217d36eb4c4c28be46bee67f84ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29915426_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/1b069308d11d3f95c1e92fdc0b42e1cc.webp"
"MediaSize" => 196534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-1b069308d11d3f95c1e92fdc0b42e1cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29915426_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/805d036e39869d3081fff9faa02e8075.webp"
"MediaSize" => 83608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-805d036e39869d3081fff9faa02e8075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29915426_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/5b1517e55cc2675959c4c574e744e2cd.webp"
"MediaSize" => 62486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-5b1517e55cc2675959c4c574e744e2cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29915426_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/1967fff85adb23700b53ff0f13e4d91e.webp"
"MediaSize" => 64195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-1967fff85adb23700b53ff0f13e4d91e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29915426_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/6efeba6cc8e2b7e29acf84b6da08aa17.webp"
"MediaSize" => 80074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-6efeba6cc8e2b7e29acf84b6da08aa17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29915426_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/3d21ab5739bd58a95678817925ef8206.webp"
"MediaSize" => 106718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-3d21ab5739bd58a95678817925ef8206.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29915426_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/74a79098b7298d96d169db9ba1c418d1.webp"
"MediaSize" => 99843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-74a79098b7298d96d169db9ba1c418d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29915426_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/eb325726f9fde2e7be3a86c30ba0e2c3.webp"
"MediaSize" => 101260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-eb325726f9fde2e7be3a86c30ba0e2c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29915426_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/d8e2bf0c9a50624a652917ff50d2ccc7.webp"
"MediaSize" => 101779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-d8e2bf0c9a50624a652917ff50d2ccc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29915426_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/a954e7af0d5bf38f1ffe172dce37e665.webp"
"MediaSize" => 99360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-a954e7af0d5bf38f1ffe172dce37e665.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29915426_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/a0b62d8165d074f239537298ea48e1ef.webp"
"MediaSize" => 99133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-a0b62d8165d074f239537298ea48e1ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29915426_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/4096ead04ebb78074dcacbff6b09bff2.webp"
"MediaSize" => 115518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-4096ead04ebb78074dcacbff6b09bff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
"ResourceRecordKey" => "29915426"
"ModificationTimestamp" => "2026-06-17T15:03:10.59Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29915426_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915426/8687835bbbea392bf3b1f324756cb054.webp"
"MediaSize" => 123836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915426/thumbnail-8687835bbbea392bf3b1f324756cb054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13455236"
…2
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915426')"
+"ID": "1539021"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1539022"
+post_author: 1
+"ListingKey": "29915305"
+"ListingId": "40840565"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:00:14Z"
+"RFModificationTimestamp": "2026-06-17T15:29:58Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1571.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0J9"
+"UnparsedAddress": "178 CHUDLEIGH Street, Waterdown, Ontario L8B0J9"
+"Coordinates": array:2 [
0 => -79.9036966
1 => 43.3324243
]
+"Latitude": 43.3324243
+"Longitude": -79.9036966
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Freehold semi-detached home on child-friendly street in desirable Waterdown! This very clean and bright brick home with a covered front porch features an open-concept kitchen and dining area overlooking the family room with a cozy gas fireplace. Walk out to the generous backyard with large decks and plenty of green space for kids and pets to enjoy. The spacious Primary bedroom offers a 4-piece ensuite and a walk-in closet with built-in organizers, complemented by Closets by Design organizers in the foyer and all other bedrooms. Recent upgrades include: appliances, backyard deck, engineered hardwood flooring throughout the upper level, updated stair carpeting, front door blinds, and Kohler toilets with bidet assemblies in both the ensuite and main bathroom. The home is also equipped with an alarm system featuring a doorbell camera, front and rear exterior cameras, garage sensors, and three door sensors for peace of mind.Fantastic location within walking distance to Memorial Park with splash pad, baseball diamonds, and year-round skating. Surrounded by the Greenbelt and close to parks, trails, the farmers' market, schools, YMCA, shopping, restaurants, and everyday amenities. Just 10 minutes to Aldershot GO Station with quick access to the 403, 407, and QEW. This home is a real gem! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T15:29:52.383369+00:00"
+"Directions": "Dundas St E, Hamilton St N, White Oak Dr, Chudleigh St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1628616"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T14:50:43Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T14:50:43Z"
+"Stories": "2.0"
+"StreetName": "CHUDLEIGH"
+"StreetNumber": "178"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5646"
+"VirtualTourURLUnbranded": "https://youriguide.com/178_chudleigh_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29915305/178-chudleigh-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1571
+"OriginalEntryTimestamp": "2026-06-17T14:50:43.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1162038"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915305')"
+"ID": "1539022"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24800
+post_id: "1538263"
+post_author: 1
+"ListingKey": "29914285"
+"ListingId": "40840409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:00:01Z"
+"RFModificationTimestamp": "2026-06-17T13:57:35Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1826.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L3"
+"UnparsedAddress": "29 SUNNYCROFT Court, Waterdown, Ontario L8B0L3"
+"Coordinates": array:2 [
0 => -79.8987212
1 => 43.3270654
]
+"Latitude": 43.3270654
+"Longitude": -79.8987212
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 29 Sunnycroft Court, a beautifully maintained freehold semi-detached home nestled on a quiet court in one of Waterdown's most sought-after neighbourhoods. Backing onto greenspace with no rear neighbours, this home offers the perfect blend of privacy, convenience, and low-maintenance living—with no condo or road fees. Built in 2005 and thoughtfully designed with timeless finishes, the main floor features 9-foot ceilings, abundant natural light, hardwood flooring, and an inviting open-concept layout ideal for everyday living and entertaining. The upgraded kitchen is equipped with tall cabinetry, crown moulding, granite countertops, stainless steel appliances, a gas stove, and a breakfast bar overlooking the spacious great room with gas fireplace and backyard views. Step outside to a large elevated deck surrounded by mature landscaping, creating the perfect setting to enjoy your morning coffee or unwind while overlooking the peaceful greenspace beyond while soaking in the hot tub. Upstairs, the spacious primary retreat features a 4-piece ensuite and dual closets, while two additional bedrooms are served by a convenient Jack-and-Jill style full bathroom. The finished lower level adds valuable living space with a versatile bright rec room, 2-piece bathroom, laundry area, and plenty of storage. Additional highlights include inside garage access, a private two-car driveway, covered front porch entrance with transom windows, and a freshly painted interior throughout. Upgrades include brand new furnace and light fixtures April 2026, and roof shingles replaced in 2018. Ideally located just steps to downtown Waterdown's shops, restaurants, library, public transit, and scenic escarpment trails, this is an exceptional opportunity to enjoy executive-style living in a mature, family-friendly community. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:57:23.234946+00:00"
+"Directions": "Take Dundas St E. to Sunnycroft Court and head East. Property will be on your left hand side."
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072395"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T11:50:12Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T11:50:12Z"
+"Stories": "2.0"
+"StreetName": "SUNNYCROFT"
+"StreetNumber": "29"
+"StreetSuffix": "Court"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5412.52"
+"VirtualTourURLUnbranded": "https://youriguide.com/29_sunnycroft_ct_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914285/29-sunnycroft-court-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1289
+"BelowGradeFinishedArea": 537
+"OriginalEntryTimestamp": "2026-06-17T11:50:12.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1347564"
+"ListOfficeNationalAssociationId": "1408460"
+"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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914285')"
+"ID": "1538263"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1534978"
+post_author: 1
+"ListingKey": "29910671"
+"ListingId": "X13451454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T00:05:09Z"
+"RFModificationTimestamp": "2026-06-17T00:07:00Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0K2H6"
+"UnparsedAddress": "100 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L0K2H6"
+"Coordinates": array:2 [
0 => -79.900192
1 => 43.331966
]
+"Latitude": 43.331966
+"Longitude": -79.900192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Tucked into an established, tree-lined pocket with rare walkability, 100 Chudleigh Street is a mature-lot Waterdown home with the main floor opened up and reimagined for how families actually live now. This beautifully updated 4-bedroom, 2.5-bath home has over 2,800 sq. ft of living space that perfectly blends the open, connected layout buyers love in newer builds with the privacy, greenery, and lot size of an established neighbourhood. The main floor feels bright, warm, and easy, with designer touches throughout, a cozy fireplace, new luxury vinyl flooring, and a large kitchen featuring quartz counters, quartz backsplash, refreshed cabinetry, and generous space to gather. Carpet-free living continues throughout, with four comfortable bedrooms upstairs and a finished lower level that creates a huge suite-style retreat for teens, guests, long-staying in-laws, movie nights, or play space - with room for the wine collection tucked in too. Outside, the backyard is lush and surprisingly private, surrounded by mature greenery with no rear residential neighbours. Steps to everyday amenities, schools, trails, the YMCA, library, restaurants, shopping, Dairy Queen, and the summer farmers market - this is Waterdown family living with space, style, privacy, and true walkability. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:56:25.167411+00:00"
+"Directions": "Cross Streets: Hamilton & Dundas. ** Directions: Hamilton, Weston on White Oak Dr., Left on Chudleigh."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038275"
+"ListOfficeKey": "280499"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "50 x 125 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-16T17:26:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T23:56:45Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "100"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6718"
+"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": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29910671/100-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-16T17:26:56.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314465"
+"ListOfficeNationalAssociationId": "1314683"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910671')"
+"ID": "1534978"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1531843"
+post_author: 1
+"ListingKey": "29905680"
+"ListingId": "X13446596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS CRESCENT, Hamilton (Waterdown), Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.892899
1 => 43.326881
]
+"Latitude": 43.326881
+"Longitude": -79.892899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on one of Waterdown's most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well-proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard and private, tranquil green space. Enjoy summer evenings on the expansive composite deck, gather with friends friend and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town's most sought-after areas. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:35.932384+00:00"
+"Directions": "Cross Streets: Howard Blvd. ** Directions: South of Dundas St E on Howard Blvd, turn ontoMays Cres."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101938"
+"ListOfficeKey": "288807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "72.2 x 196.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:52Z"
+"Stories": "2.0"
+"StreetName": "Mays"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9061.67"
+"VirtualTourURLUnbranded": "https://listings.webbify.ca/5-Mays-Crescent-Hamilton-ON-L8B-0G4-Canada"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905680/5-mays-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 72.2
+"OriginalEntryTimestamp": "2026-06-15T18:56:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371767"
+"ListOfficeNationalAssociationId": "1371723"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24816
+post_id: "1531736"
+post_author: 1
+"ListingKey": "29905626"
+"ListingId": "40830994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:20:02Z"
+"RFModificationTimestamp": "2026-06-17T12:22:53Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2804.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK Place, Waterdown, Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.9103799
1 => 43.3224782
]
+"Latitude": 43.3224782
+"Longitude": -79.9103799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous “site lines” enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer’s dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:51:15.502458+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1751064"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:52:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:11:17Z"
+"Stories": "2.0"
+"StreetName": "FENWICK"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7011.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/17_fenwick_pl_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905626/17-fenwick-place-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1950
+"BelowGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2026-06-15T18:52:03.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1181610"
+"ListOfficeNationalAssociationId": "1344653"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905626')"
+"ID": "1531736"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1531326"
+post_author: 1
+"ListingKey": "29906158"
+"ListingId": "X13446970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:25:11Z"
+"RFModificationTimestamp": "2026-06-17T13:29:42Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK PLACE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.910126
1 => 43.322235
]
+"Latitude": 43.322235
+"Longitude": -79.910126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous "site lines" enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer's dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:56:14.701422+00:00"
+"Directions": "Hollybush/Fenwick"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981607"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 121.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:46Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:18:55Z"
+"Stories": "2.0"
+"StreetName": "Fenwick"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7011"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17_fenwick_pl_hamilton_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906158/17-fenwick-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:46.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267040"
+"ListOfficeNationalAssociationId": "1344892"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906158')"
+"ID": "1531326"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1530966"
+post_author: 1
+"ListingKey": "29904850"
+"ListingId": "40839710"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:00:17Z"
+"RFModificationTimestamp": "2026-06-15T19:26:25Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.33
+"LivingArea": 3344.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS Crescent, Waterdown, Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.8932325
1 => 43.3271885
]
+"Latitude": 43.3271885
+"Longitude": -79.8932325
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on one of Waterdown’s most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well- proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard as well as the private, tranquil green space behind. Enjoy summer evenings on the expansive composite deck, gather with friends and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town’s most sought-after areas. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:26:11.527080+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032649"
+"ListOfficeKey": "286831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.33"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:51:41Z"
+"Stories": "2.0"
+"StreetName": "MAYS"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9061.67"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904850/5-mays-crescent-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 2098
+"BelowGradeFinishedArea": 1246
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1309851"
+"ListOfficeNationalAssociationId": "1364228"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904850')"
+"ID": "1530966"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1530774"
+post_author: 1
+"ListingKey": "29905119"
+"ListingId": "X13446180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:40:13Z"
+"RFModificationTimestamp": "2026-06-16T18:47:14Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7C5"
+"UnparsedAddress": "37 MELISSA CRESCENT, Hamilton (Waterdown), Ontario L9H7C5"
+"Coordinates": array:2 [
0 => -79.905585
1 => 43.32541
]
+"Latitude": 43.32541
+"Longitude": -79.905585
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully renovated bungalow nestled on a quiet, highly sought-after crescent in the heart of Waterdown. Offering over 2,500 sq. ft. of finished living space, this fully renovated, turn-key home features 3+1 bedrooms and 2 full bathrooms, thoughtfully updated with quality finishes and timeless style throughout. The bright and inviting main level offers large rooms designed for comfortable everyday living, while the fully finished lower level provides versatile additional space for family, guests, a home office, or recreation. Step outside to your private backyard retreat, complete with a hot tub, and a large tiered deck perfect for entertaining, outdoor dining, and enjoying warm summer evenings. Located within walking distance to scenic trails, parks, and Waterdown's vibrant downtown core, this home offers the perfect balance of nature, convenience, and community. A rare opportunity to own a move-in-ready bungalow in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:24:46.422319+00:00"
+"Directions": "Cross Streets: Scott Street. ** Directions: Riley St to Scott St to Melissa Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"LotSizeDimensions": "55 x 119 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:58:08Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:32:55Z"
+"Stories": "1.0"
+"StreetName": "Melissa"
+"StreetNumber": "37"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7384"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/-My3LeJd9kI"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905119/37-melissa-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"OriginalEntryTimestamp": "2026-06-15T17:58:08.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355945"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905119')"
+"ID": "1530774"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 100
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]