array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29141367/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141367&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141367/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141367&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23276
+post_id: "447914"
+post_author: 1
+"ListingKey": "29141367"
+"ListingId": "40790838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T05:45:32Z"
+"RFModificationTimestamp": "2025-11-27T06:47:46Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2085.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "30 KELLY Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.899403
1 => 43.338015
]
+"Latitude": 43.338015
+"Longitude": -79.899403
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Charming All Brick Bungalow in the coveted Core of Waterdown Village. Situated on quiet, dead end street just steps away from Memorial Park, Shopping and Restaurants. This property features a large private lot, backing onto Mary Hopkins Elementary School - the perfect starter HOME for a young family or perhaps the downsizer looking for simple, convinient one floor living. Main Floor features a cozy Gas Fireplace & Hardwood in the Living & Dining Rms, Original Kitchen open to LR & DR. 2 spacious Bedrms, main floor Bathroom and a walk out to the sprawling back yard complete with Garden Shed & Pond. Recent Updates include: Roof/Shingles, Furnace, A/C, Windows, Exterior Doors, Gas Fireplace, Repointed Chimney and a Gorgeous renovated 5pc Bath for your own personal SPA Retreat. Partially finished Basement offers loads of potential for additional living space. A solid build awaiting your finishing touches, this HOME offers great space, privacy, and convenience in a family-friendly location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T06:47:30.449065+00:00"
+"Directions": "MAIN STREET NORTH TO KELLY STREET"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533119"
+"ListOfficeKey": "279638"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-27T05:38:27Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T05:38:27Z"
+"Stories": "1.0"
+"StreetName": "KELLY"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5490"
+"VirtualTourURLUnbranded": "https://youriguide.com/30_kelly_st_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1540755236"
"RoomType" => "Utility room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
1 => array:11 [
"RoomKey" => "1540755237"
"RoomType" => "Storage"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
2 => array:11 [
"RoomKey" => "1540755238"
"RoomType" => "Laundry room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
3 => array:11 [
"RoomKey" => "1540755239"
"RoomType" => "Recreation room"
"ListingId" => "40790838"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 33'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
4 => array:11 [
"RoomKey" => "1540755240"
"RoomType" => "5pc Bathroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
5 => array:11 [
"RoomKey" => "1540755241"
"RoomType" => "Bedroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
6 => array:11 [
"RoomKey" => "1540755242"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
7 => array:11 [
"RoomKey" => "1540755243"
"RoomType" => "Kitchen"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
8 => array:11 [
"RoomKey" => "1540755244"
"RoomType" => "Dining room"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
9 => array:11 [
"RoomKey" => "1540755245"
"RoomType" => "Living room"
"ListingId" => "40790838"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141367"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T05:38:27.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141367/30-kelly-street-waterdown"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2075759"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284639"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1064
+"BelowGradeFinishedArea": 1021
+"OriginalEntryTimestamp": "2025-11-27T05:38:27.74Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342141253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/33b1c07194f45a53de2222a592190ff2.webp"
"MediaSize" => 173638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-33b1c07194f45a53de2222a592190ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342141346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/c4a08adbc3f76cee09257fbb8a032be8.webp"
"MediaSize" => 173554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-c4a08adbc3f76cee09257fbb8a032be8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342141455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/a11f14a2e1a3e3f5930a9f237d0ae159.webp"
"MediaSize" => 45014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-a11f14a2e1a3e3f5930a9f237d0ae159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342141547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fed042f15e27c253b3ffed4f87e89042.webp"
"MediaSize" => 64708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fed042f15e27c253b3ffed4f87e89042.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342141625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/27c69b349051f81e6d84aff34b577b8e.webp"
"MediaSize" => 89041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-27c69b349051f81e6d84aff34b577b8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342141682"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/88378fc29b6aba7165a2907e155a184c.webp"
"MediaSize" => 80839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-88378fc29b6aba7165a2907e155a184c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342141698"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/6702422fc18c2b1b75dd1aa52193706d.webp"
"MediaSize" => 79912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-6702422fc18c2b1b75dd1aa52193706d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342141799"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d51470092220f49b96f20afce169da0c.webp"
"MediaSize" => 79409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d51470092220f49b96f20afce169da0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342141877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/5dd3866d7c4d721d3178328581644295.webp"
"MediaSize" => 67355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-5dd3866d7c4d721d3178328581644295.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342141951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/7f5732a96bab1198dcb87c7183d25d81.webp"
"MediaSize" => 68016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-7f5732a96bab1198dcb87c7183d25d81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342142018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d75baacbbf9468f82ab05460e7572632.webp"
"MediaSize" => 88512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d75baacbbf9468f82ab05460e7572632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342142062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/724fe8fb95dfe24a56a1e5392b5d72b3.webp"
"MediaSize" => 89212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-724fe8fb95dfe24a56a1e5392b5d72b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342142105"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/e2ffff9a8a1411b7ffaa69bee00639df.webp"
"MediaSize" => 75170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-e2ffff9a8a1411b7ffaa69bee00639df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342142142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/23de4bbccba0bdd8e300065c813121ea.webp"
"MediaSize" => 77884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-23de4bbccba0bdd8e300065c813121ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342142231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/471aee9cf3c59aa02fa760b235cbf4a0.webp"
"MediaSize" => 73536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-471aee9cf3c59aa02fa760b235cbf4a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6342142253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/cbc68237f803010a4d7a36c0a37e185d.webp"
"MediaSize" => 71294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-cbc68237f803010a4d7a36c0a37e185d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6342142297"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/864028c3eb96630d2ae09c6bc712ff04.webp"
"MediaSize" => 71372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-864028c3eb96630d2ae09c6bc712ff04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6342142355"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/3405e0e853409689fdcf2d4ed65acbfd.webp"
"MediaSize" => 68286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-3405e0e853409689fdcf2d4ed65acbfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6342142381"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/9fbdc84e1be7e853ee8aa4b43c116241.webp"
"MediaSize" => 54006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-9fbdc84e1be7e853ee8aa4b43c116241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6342142403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/85fdd1700ac7747346693018f11a7a68.webp"
"MediaSize" => 55598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-85fdd1700ac7747346693018f11a7a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6342142429"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fb2738b1972c1666da431970855097b9.webp"
"MediaSize" => 57803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fb2738b1972c1666da431970855097b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6342142452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/be89c7851225b87358e39b0a12ea1bf2.webp"
"MediaSize" => 59656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-be89c7851225b87358e39b0a12ea1bf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6342142467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d848def7b6692e0f2301755ccf2e4434.webp"
"MediaSize" => 64909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d848def7b6692e0f2301755ccf2e4434.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6342142489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/d1beee7c1639805c08dd9393e21547a9.webp"
"MediaSize" => 51337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-d1beee7c1639805c08dd9393e21547a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6342142504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/f1f0c36c9554abc274d00b8022079ab6.webp"
"MediaSize" => 55855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-f1f0c36c9554abc274d00b8022079ab6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6342142520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/72bb933460a40cfe899bbc958578401b.webp"
"MediaSize" => 54596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-72bb933460a40cfe899bbc958578401b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6342142538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/a696975ba9fc6c7dc7d4b3e88c71fcf0.webp"
"MediaSize" => 60061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-a696975ba9fc6c7dc7d4b3e88c71fcf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6342142546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/411b1a18fa339137d8e78c0b8cbdf22f.webp"
"MediaSize" => 60841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-411b1a18fa339137d8e78c0b8cbdf22f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6342142562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/fbabe35a97b2bab89898e9eebfb1db02.webp"
"MediaSize" => 66060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-fbabe35a97b2bab89898e9eebfb1db02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6342142576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/da7a04fc0ca28dc97dd44951ac424378.webp"
"MediaSize" => 152623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-da7a04fc0ca28dc97dd44951ac424378.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6342142596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ab4069c981ab5346d4dde749d8e49ec1.webp"
"MediaSize" => 141252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ab4069c981ab5346d4dde749d8e49ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6342142600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ccde89c3d685fdb13559599035821ba7.webp"
"MediaSize" => 163615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ccde89c3d685fdb13559599035821ba7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6342142657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/ebc7abf4573984983d34942b71323fd8.webp"
"MediaSize" => 195982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-ebc7abf4573984983d34942b71323fd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6342142662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/df7390ecda63970f063f3a9b785ccb3a.webp"
"MediaSize" => 211583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-df7390ecda63970f063f3a9b785ccb3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6342142667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/28e934230ea3c9216f2be0dfdca49b2e.webp"
"MediaSize" => 198565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-28e934230ea3c9216f2be0dfdca49b2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6342142671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/968a4d74dac1868271c3ab37c3960e56.webp"
"MediaSize" => 203749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-968a4d74dac1868271c3ab37c3960e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6342142675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/48d91da1021153eae15a0ee345faa387.webp"
"MediaSize" => 191710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-48d91da1021153eae15a0ee345faa387.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6342142679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/993485b10fc2d65bd58739725f196820.webp"
"MediaSize" => 187267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-993485b10fc2d65bd58739725f196820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6342142681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/10ab60a45f894947517fbe83253e86ee.webp"
"MediaSize" => 40005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-10ab60a45f894947517fbe83253e86ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6342142683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141367/e7e6e41bd968f489d4e6328bd30a2c5b.webp"
"MediaSize" => 34502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141367/thumbnail-e7e6e41bd968f489d4e6328bd30a2c5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790838"
"ResourceRecordKey" => "29141367"
"ModificationTimestamp" => "2025-11-27T05:38:27.75Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141367')"
+"ID": "447914"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 279638/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279638&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279638/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279638&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "HBREMAXESC"
+"ModificationTimestamp": "2025-07-09T18:37:47Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "279638"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "502 Brant Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7R2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1306586"
+"OriginalEntryTimestamp": "2017-03-02T20:20:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6078384104"
"MediaURL" => "https://ddfcdn.realtor.ca/organization/en-ca/TS638876680200000000/highres/default/remaxoa.gif"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "HBREMAXESC"
"ResourceRecordKey" => "279638"
"ModificationTimestamp" => "2025-07-09T18:27:00Z"
]
]
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439639"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "279638"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-07-09T18:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1201589"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('279638')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1533119/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1533119&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1533119/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1533119&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25134
+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 29141367" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24723
+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 29141367/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141367&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141367/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141367&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24590
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141367 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.899403 43.338015)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141367 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.899403 43.338015)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141367 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.899403 43.338015)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141367 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.899403 43.338015)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24979
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24972
+post_id: "447353"
+post_author: 1
+"ListingKey": "29140356"
+"ListingId": "X12579976"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:10:24Z"
+"RFModificationTimestamp": "2025-11-27T01:33:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A3"
+"UnparsedAddress": "24 SAVAGE DRIVE, Hamilton (Waterdown), Ontario L8B0A3"
+"Coordinates": array:2 [
0 => -79.9086677
1 => 43.3393322
]
+"Latitude": 43.3393322
+"Longitude": -79.9086677
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedroom Freehold Townhome In An Unbeatable Location! Just Steps To Local Shopping, Parks, Schools And Ymca. Main Floor Offer Bright Airy Great Room With Walk-Out To Large Covered Balcony. Kitchen Features Stainless Steel Appliances, Lots Of Cabinetry And Workspace. Handy Breakfast Bar. Upper Level Offers 2 Spacious Bedrooms And Convenient Laundry. Ground Floor Entry With Lots Of Storage Space. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:33:36.526726+00:00"
+"Directions": "Cross Streets: Centre Rd. ** Directions: Parkside Dr & Centre Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1415763"
+"ListOfficeKey": "50737"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "19.7 x 49.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:21Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:00:21Z"
+"Stories": "3.0"
+"StreetName": "Savage"
+"StreetNumber": "24"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1540605075"
"RoomType" => "Great room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
1 => array:11 [
"RoomKey" => "1540605076"
"RoomType" => "Dining room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
2 => array:11 [
"RoomKey" => "1540605077"
"RoomType" => "Kitchen"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29140356"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
3 => array:11 [
"RoomKey" => "1540605078"
"RoomType" => "Laundry room"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29140356"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
4 => array:11 [
"RoomKey" => "1540605079"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 2.9
"ListingKey" => "29140356"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
5 => array:11 [
"RoomKey" => "1540605080"
"RoomType" => "Bedroom"
"ListingId" => "X12579976"
"RoomLevel" => "Third level"
"RoomWidth" => 3.43
"ListingKey" => "29140356"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140356/24-savage-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-11-26T22:00:21.78Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:19 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341638522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/7f44cc64fe916418b0fdc0b6ad218922.webp"
"MediaSize" => 91806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-7f44cc64fe916418b0fdc0b6ad218922.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341638548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/c537e98e8c19c7c697e74619c4fb4ca4.webp"
"MediaSize" => 135333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-c537e98e8c19c7c697e74619c4fb4ca4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341638549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/215ac4803c733e54cf24ada78f888679.webp"
"MediaSize" => 59387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-215ac4803c733e54cf24ada78f888679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341638562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/dfc61ac536a0480bdf039a8c6ac51b60.webp"
"MediaSize" => 98206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-dfc61ac536a0480bdf039a8c6ac51b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341638576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/45f128b338ddd305ceebd6a4e4e863fd.webp"
"MediaSize" => 111176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-45f128b338ddd305ceebd6a4e4e863fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341638589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/35529b55daf7206355dc2c22f4fd10ca.webp"
"MediaSize" => 98206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-35529b55daf7206355dc2c22f4fd10ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341638631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/4ceaa8a6793779511334a223409ea014.webp"
"MediaSize" => 84723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-4ceaa8a6793779511334a223409ea014.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341638664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/0c829b917f776490204e59c07c39c10a.webp"
"MediaSize" => 93726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-0c829b917f776490204e59c07c39c10a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341638672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/bc5dc0f701fc47576aa0e6b6ee4931b1.webp"
"MediaSize" => 104187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-bc5dc0f701fc47576aa0e6b6ee4931b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579976"
"ResourceRecordKey" => "29140356"
"ModificationTimestamp" => "2025-11-26T22:00:21.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341638738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140356/79bfccfd4516c417057d0f47cf7b018e.webp"
"MediaSize" => 120460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140356/thumbnail-79bfccfd4516c417057d0f47cf7b018e.webp"
…7
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140356')"
+"ID": "447353"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24974
+post_id: "447041"
+post_author: 1
+"ListingKey": "29139583"
+"ListingId": "X12579158"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T19:35:34Z"
+"RFModificationTimestamp": "2025-11-27T00:03:36Z"
+"ListPrice": 1299900.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:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T00:03:30.574559+00:00"
+"Directions": "Cross Streets: Dundas & Burke St. ** Directions: Burke St. South To Kenesky Dr. To Avanti Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991785"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "41 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:29:27Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:29:27Z"
+"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/29139583/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": "2025-11-26T19:29:27.72Z"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139583')"
+"ID": "447041"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24971
+post_id: "446148"
+post_author: 1
+"ListingKey": "29138861"
+"ListingId": "40790658"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:41:06Z"
+"RFModificationTimestamp": "2025-11-26T19:13:20Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2316.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER Road, Waterdown, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8764705
1 => 43.3410201
]
+"Latitude": 43.3410201
+"Longitude": -79.8764705
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don’t miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space — larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you’ll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite — complete with a full bath and bedroom for added convenience. Outside, you’ll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:13:10.094628+00:00"
+"Directions": "Dundas St E to Mallard Tr to Skinner Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:30:27Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:30:27Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7804"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/01985c82-00e4-7304-a6b8-ffaba5553267"
+"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/29138861/225-skinner-road-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 2316
+"OriginalEntryTimestamp": "2025-11-26T17:30:27.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138861')"
+"ID": "446148"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24975
+post_id: "445901"
+post_author: 1
+"ListingKey": "29139042"
+"ListingId": "X12578734"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:53Z"
+"RFModificationTimestamp": "2025-11-26T18:55:40Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8767129
1 => 43.3408287
]
+"Latitude": 43.3408287
+"Longitude": -79.8767129
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space - larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you'll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite - complete with a full bath and bedroom for added convenience. Outside, you'll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:54:54.519917+00:00"
+"Directions": "Dundas St E to Mallard Tr to Skinner Rd"
+"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": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:00:15Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:00:15Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7804"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139042/225-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2025-11-26T18:00:15.15Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139042')"
+"ID": "445901"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24973
+post_id: "446149"
+post_author: 1
+"ListingKey": "29139051"
+"ListingId": "40790678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:53Z"
+"RFModificationTimestamp": "2025-11-26T18:54:09Z"
+"ListPrice": 1299900.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": "2025-11-26T18:53:52.505254+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": "2025-11-26T18:00:20Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:00:20Z"
+"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/29139051/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": "2025-11-26T18:00:20.02Z"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139051')"
+"ID": "446149"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24611
+post_id: "445585"
+post_author: 1
+"ListingKey": "29138080"
+"ListingId": "X12577628"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T14:55:21Z"
+"RFModificationTimestamp": "2025-11-26T17:30:25Z"
+"ListPrice": 459900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "613 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2-bedroom, 1-bath end-unit condo in the sought-after Trend community of Waterdown. This bright, modern suite features 9 ft ceilings, floor-to-ceiling windows, quartz countertops, luxury laminate flooring, and large-format tile in the bath, entry, and laundry areas. Freshly painted with updated lighting throughout. Enjoy energy-efficient geothermal heating and cooling, full-size stainless steel appliances, and exceptional privacy with no neighbouring unit. Includes one underground parking space and a same-floor locker. Building amenities include a gym, party room, rooftop BBQ terrace, and bike storage. A perfect blend of style, comfort, and convenience. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "384.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:30:10.126885+00:00"
+"Directions": "Cross Streets: Dundas Street East and Mallard. ** Directions: Dundas Street East and MallardDundas Street East and Mallard."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970959"
+"ListOfficeKey": "299544"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-26T14:47:57Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T14:47:57Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3120.94"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/470-dundas-st-e-unit-613"
+"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/29138080/613-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2142995"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential Ontario - (416) 293-5900"
+"CoListOfficeKey": "299544"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "UC-12 - Residential"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-26T14:47:57.33Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138080')"
+"ID": "445585"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+post_id: "445160"
+post_author: 1
+"ListingKey": "29137642"
+"ListingId": "X12577214"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T03:40:38Z"
+"RFModificationTimestamp": "2025-11-26T03:42:44Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X2"
+"UnparsedAddress": "4 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X2"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained condo townhouse offering style, comfort, and convenience in every detail. The main level features an inviting open-concept layout with hardwood flooring and neutral paint tones that create a warm, modern feel. The gourmet kitchen boasts stainless steel appliances, a functional island, and plenty of counter space-perfect for cooking and entertaining. A custom built-in wall unit with charming shiplap & electric fireplace adds character and a cozy focal point to the living area. Upstairs, you'll find three generous-sized bedrooms, including a spacious primary suite complete with built-ins in the walk-in closet and its own 4-piece ensuite bathroom. An additional 4-piece bathroom serves guests or family. The second-floor laundry room has been tastefully updated, offering added convenience and style. The finished basement expands your living space with a versatile recreation room and ample storage options. A single-car garage provides secure parking and additional room for belongings. Move-in ready and thoughtfully updated, this home blends updated finishes with practical living spaces-perfect for families, professionals, or anyone seeking a low-maintenance lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "260.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T03:21:10.295086+00:00"
+"Directions": "Dundas St E/ Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235857"
+"ListOfficeKey": "280835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:53:38Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T03:20:42Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5639.1"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/4_215_dundas_st_e_hamilton_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137642/4-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1956613"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blair Blanchard"
+"CoListAgentKey2": "2235858"
+"CoListOfficeKey": "280835"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"CoListOfficeKey2": "280835"
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-11-26T02:53:38.32Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137642')"
+"ID": "445160"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24976
+post_id: "442976"
+post_author: 1
+"ListingKey": "29134742"
+"ListingId": "X12574358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T17:45:31Z"
+"RFModificationTimestamp": "2025-11-25T17:53:05Z"
+"ListPrice": 1429888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V3"
+"UnparsedAddress": "28 CELANO DRIVE, Hamilton (Waterdown), Ontario L8B1V3"
+"Coordinates": array:2 [
0 => -79.8817753
1 => 43.34823
]
+"Latitude": 43.34823
+"Longitude": -79.8817753
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 28 Celano Drive, a beautifully upgraded and meticulously maintained 4+1 bedroom, 4-bathroom home offering approximately 3,026 sq. ft. of finished living space, built in 2017 and ideally set directly on Cranberry Park with private park access. The bright main level features an open-concept layout with hardwood flooring, a custom kitchen with quartz countertops, upgraded cabinetry, KitchenAid stainless steel appliances, and complemented by a brand-new LG 36" refrigerator and Samsung dishwasher. A spacious Great Room with a fireplace and a separate den perfect for a home office complete the main floor. The second level offers new flooring, a primary bedroom with a 3-piece ensuite and walk-in closet, three additional bedrooms, second-floor laundry, and a generous family room. The fully finished basement includes an additional bedroom, full bathroom, and a recreational area,pantry, ideal for extended family or guests. The home is enhanced with new LED lighting throughout and marble and stone finishes in the kitchen and all bathrooms. The fully fenced backyard features a deck and an extra-large hot tub that doubles as a swimming pool, creating a private retreat backing onto Cranberry Park. Located in one of Waterdown's most desirable neighbourhoods, this move-in ready home is close to excellent schools, shopping, restaurants, parks, and major highways including the QEW, 403, and 407. A perfect opportunity to own a modern family home that blends comfort, style, and an exceptional setting. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T16:42:25.131851+00:00"
+"Directions": "Spring Creek Dr & Avonsyde Blv"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Laminate"
2 => "Stone"
3 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091988"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "39.1 x 89.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-25T16:39:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T17:35:12Z"
+"Stories": "2.0"
+"StreetName": "Celano"
+"StreetNumber": "28"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8044"
+"View": "View"
+"VirtualTourURLUnbranded": "https://view.spiro.media/28_celano_dr-2779?branding=false"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29134742/28-celano-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.1
+"OriginalEntryTimestamp": "2025-11-25T16:01:12.01Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134742')"
+"ID": "442976"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24978
+post_id: "441783"
+post_author: 1
+"ListingKey": "29133282"
+"ListingId": "X12573354"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T03:05:20Z"
+"RFModificationTimestamp": "2025-11-25T03:10:09Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R6"
+"UnparsedAddress": "67 GOLDEN IRIS CRESCENT, Hamilton (Waterdown), Ontario L8B0R6"
+"Coordinates": array:2 [
0 => -79.8821805
1 => 43.3467106
]
+"Latitude": 43.3467106
+"Longitude": -79.8821805
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover family-friendly bliss in East Waterdown! Step into 67 Golden Iris, a charming two-storey link home boasting more than 2,100 square feet of inviting living space, three spacious bedrooms, and three-and-a-half bathrooms, all complemented by stunning curb appeal. Nestled on a serene crescent, it's just moments from Cranberry Hill Park, top-rated schools, and everyday essentials.Freshly painted from top to bottom, the interior showcases an airy open-concept design with thoughtfully crafted areas. Host memorable gatherings in the generous dining room, while the warm family room flows seamlessly into the eat-in kitchen. Here, you'll love the extended white cabinetry featuring a bespoke coffee station and full-height storage, paired with sleek granite counters, premium black Maytag and Whirlpool appliances, and an elegant glass backsplash.Head upstairs to find three bedrooms with newly installed flooring (2024) and a convenient stackable washer-dryer setup. The luxurious primary bedroom offers a walk-in closet and a private ensuite bath complete with a relaxing soaker tub and glass-enclosed shower. A full four-piece bathroom rounds out this floor.The fully finished basement expands your options with a versatile rec room, another full bathroom, and ample storage. Step through sliding doors to the vast backyard oasis, highlighted by a spacious deck ideal for outdoor entertaining, lush gardens, and plenty of room for a potential swim spa.Outside, enjoy driveway parking for two vehicles plus an attached single garage. Located in the sought-after catchment for Mary Hopkins Elementary, Flamborough Centre School, and Waterdown District High School. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T01:31:47.795383+00:00"
+"Directions": "Cross Streets: Dundas St E to Spring Creek Dr to Hountrail Drive to Golden Iris Cr. ** Directions: Dundas St and Spring Creek Dr."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2107855"
+"ListOfficeKey": "294942"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.6 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T22:55:11Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T02:52:16Z"
+"Stories": "2.0"
+"StreetName": "Golden Iris"
+"StreetNumber": "67"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5193.61"
+"VirtualTourURLUnbranded": "https://tours.aisonphoto.com/idx/302359"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29133282/67-golden-iris-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2025-11-24T22:55:10.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29133282')"
+"ID": "441783"
}
]
+success: true
+page_size: 9
+page_count: 26
+count: 226
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]