array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29968968 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1577559"
+post_author: 1
+"ListingKey": "29968968"
+"ListingId": "X13503168"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T02:55:14Z"
+"RFModificationTimestamp": "2026-06-30T02:57:13Z"
+"ListPrice": 890000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V3"
+"UnparsedAddress": "63 LUPO DRIVE, Hamilton (Waterdown), Ontario L8B0V3"
+"Coordinates": array:2 [
0 => -79.886278
1 => 43.348321
]
+"Latitude": 43.348321
+"Longitude": -79.886278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautifully refreshed 3-bedroom family home set on a premium deep lot in one of Waterdown's most desirable family-friendly communities. Vacant and offering immediate possession, this home is ideal for buyers looking to settle in without delay. attached only by the garage on one side, with the other side unattached, it offers rare privacy, space, and comfort. Step inside to a bright, spacious layout with fresh paint throughout, hardwood flooring on the first floor, brand-new upper-level carpet, modern, move-in-ready feel. The main floor offers comfortable living/dining areas for everyday family life, entertaining, and relaxing, while the Extra space on 2nd floor provides valuable extra space for a home office. The true standout is the exceptional backyard. Sitting on a deep premium lot, the outdoor space features , charming gazebo, storage shed, children's play area, and plenty of open green space for kids, pets, and gatherings. Close to schools, parks, shopping, restaurants, community amenities, and major commuter routes, this home delivers the perfect balance of privacy, family lifestyle, and Waterdown convenience. A rare opportunity to own a vacant, move-in-ready 3-bedroom home with a backyard that sets it apart. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T01:32:09.797975+00:00"
+"Directions": "Cross Streets: Dundas street/Spring Creek Drive. ** Directions: Dundas/Spring Creek."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994173"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.5 x 94 FT ; Irregular"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T00:50:29Z"
+"PhotosCount": 5
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T02:48:52Z"
+"Stories": "2.0"
+"StreetName": "Lupo"
+"StreetNumber": "63"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6582"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671664385"
"RoomType" => "Bedroom"
"ListingId" => "X13503168"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.96
"ListingKey" => "29968968"
"RoomLength" => 4.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
1 => array:11 [
"RoomKey" => "1671664386"
"RoomType" => "Bedroom 2"
"ListingId" => "X13503168"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.5
"ListingKey" => "29968968"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
2 => array:11 [
"RoomKey" => "1671664387"
"RoomType" => "Bedroom 3"
"ListingId" => "X13503168"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.36
"ListingKey" => "29968968"
"RoomLength" => 2.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
3 => array:11 [
"RoomKey" => "1671664388"
"RoomType" => "Living room"
"ListingId" => "X13503168"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29968968"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
4 => array:11 [
"RoomKey" => "1671664389"
"RoomType" => "Living room"
"ListingId" => "X13503168"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29968968"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
5 => array:11 [
"RoomKey" => "1671664390"
"RoomType" => "Kitchen"
"ListingId" => "X13503168"
"RoomLevel" => "Main level"
"RoomWidth" => 2.7
"ListingKey" => "29968968"
"RoomLength" => 3.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T02:48:52.88Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29968968/63-lupo-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-30T00:50:29.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1277260"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:5 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29968968_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968968/53fde47ef4311f58af008159e054b89c.webp"
"MediaSize" => 167099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968968/thumbnail-53fde47ef4311f58af008159e054b89c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13503168"
"ResourceRecordKey" => "29968968"
"ModificationTimestamp" => "2026-06-30T00:50:29.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29968968_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968968/fdba1a2d509c10d6bbbacef1efa52a3e.webp"
"MediaSize" => 183095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968968/thumbnail-fdba1a2d509c10d6bbbacef1efa52a3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503168"
"ResourceRecordKey" => "29968968"
"ModificationTimestamp" => "2026-06-30T00:50:29.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29968968_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968968/5099d28de9fe7e88e2aa9a365fe00489.webp"
"MediaSize" => 440318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968968/thumbnail-5099d28de9fe7e88e2aa9a365fe00489.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503168"
"ResourceRecordKey" => "29968968"
"ModificationTimestamp" => "2026-06-30T00:50:29.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29968968_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968968/e242dc28cfcabf55979695c73ad2eed6.webp"
"MediaSize" => 347471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968968/thumbnail-e242dc28cfcabf55979695c73ad2eed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503168"
"ResourceRecordKey" => "29968968"
"ModificationTimestamp" => "2026-06-30T00:50:29.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29968968_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968968/14a06bbd57eb546d6baacbfad4e513e2.webp"
"MediaSize" => 298975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968968/thumbnail-14a06bbd57eb546d6baacbfad4e513e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503168"
"ResourceRecordKey" => "29968968"
"ModificationTimestamp" => "2026-06-30T00:50:29.72Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968968')"
+"ID": "1577559"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 90198" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24794
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1994173" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24785
+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 '29968968'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25153
+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 '29968968'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25169
+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 '29968968' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.886278 43.348321)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25222
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1577313"
+post_author: 1
+"ListingKey": "29967190"
+"ListingId": "X13501524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:05:18Z"
+"RFModificationTimestamp": "2026-06-29T23:23:45Z"
+"ListPrice": 498000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "232 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedroom + 1 Bathroom Suite in the Trend Build Boutique Building. Split Floor Plan Layout With Each Good Sized Bedroom On Either Side of The Living room. Floor to Ceiling Windows, Light Flooring Throughout. Granite Countertops In The Kitchen With Stainless Steel Appliances And A Breakfast Bar. One Owned Underground Parking Space And One Owned Locker Conveniently Located on the Same Floor as the Suite. Residents Benefit From Multiple Fitness Facilities, Party Rooms, Rooftop Patio and Bike Storage All Accessed Without Leaving The Building. Geothermal Heating and Cooling System Keeps the Hydro Bill Low. Located Just Down The Street From The Quaint Downtown Waterdown Area With Specialty Shops and Restaurants, Parks and Schools. Aldershot Go Station Is A Short 10 Minute Drive As Is Brant Street Bringing You To Downtown Burlington. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "497.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
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": "2026-06-29T23:23:34.513341+00:00"
+"Directions": "Dundas & Mallard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049985"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T18:56:59Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:56:59Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "3083.88"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1671370607"
"RoomType" => "Kitchen"
"ListingId" => "X13501524"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29967190"
"RoomLength" => 2.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T18:56:59.62Z"
]
1 => array:11 [
"RoomKey" => "1671370608"
"RoomType" => "Living room"
"ListingId" => "X13501524"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29967190"
"RoomLength" => 3.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T18:56:59.62Z"
]
2 => array:11 [
"RoomKey" => "1671370609"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13501524"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29967190"
"RoomLength" => 2.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T18:56:59.62Z"
]
3 => array:11 [
"RoomKey" => "1671370610"
"RoomType" => "Bedroom 2"
"ListingId" => "X13501524"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29967190"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T18:56:59.62Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29967190/232-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-29T18:56:59.59Z"
+"ListAgentNationalAssociationId": "1325352"
+"ListOfficeNationalAssociationId": "1268183"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29967190_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/21bf5f6c1e53f8f51bd3c9ff55ba03d9.webp"
"MediaSize" => 241560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-21bf5f6c1e53f8f51bd3c9ff55ba03d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29967190_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/470020f5b6f43e90da04268d11e3566c.webp"
"MediaSize" => 117771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-470020f5b6f43e90da04268d11e3566c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29967190_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/b0c5ecc7695e79b0554635e5afcb5a1f.webp"
"MediaSize" => 139248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-b0c5ecc7695e79b0554635e5afcb5a1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29967190_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/b3deea5e09f054117d5428f1dd13ccf6.webp"
"MediaSize" => 130877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-b3deea5e09f054117d5428f1dd13ccf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29967190_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/7ed27e07a9f0d5f251284d349a8990b1.webp"
"MediaSize" => 145180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-7ed27e07a9f0d5f251284d349a8990b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29967190_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/251a63bb61836c92ab229648374b86c9.webp"
"MediaSize" => 166597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-251a63bb61836c92ab229648374b86c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29967190_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/890eabb73bf47cb66b3c2c17ce32cbe1.webp"
"MediaSize" => 153952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-890eabb73bf47cb66b3c2c17ce32cbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29967190_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/aecac4031fb7f66156136f2bccc7a4c4.webp"
"MediaSize" => 149698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-aecac4031fb7f66156136f2bccc7a4c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29967190_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/7db57a7460a1b382c1904c1f0ec39b38.webp"
"MediaSize" => 91503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-7db57a7460a1b382c1904c1f0ec39b38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29967190_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/ea7697e98d158a76e94aaf44310a3473.webp"
"MediaSize" => 167142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-ea7697e98d158a76e94aaf44310a3473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29967190_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/8a9b4db95d766fc92a93b646b26b4d59.webp"
"MediaSize" => 139519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-8a9b4db95d766fc92a93b646b26b4d59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29967190_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/2e330511114441b2db37c2194ef2c6e7.webp"
"MediaSize" => 93259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-2e330511114441b2db37c2194ef2c6e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29967190_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/cc344c4d8ce0364d796de1457922ff1b.webp"
"MediaSize" => 135519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-cc344c4d8ce0364d796de1457922ff1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29967190_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/73eb876cdbee8eddd153a5b792778cf8.webp"
"MediaSize" => 152980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-73eb876cdbee8eddd153a5b792778cf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29967190_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/70020543c985a8742c145e428385ad0a.webp"
"MediaSize" => 181021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-70020543c985a8742c145e428385ad0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29967190_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/46ad3d10d6e88a696c743f2b9eb0db43.webp"
"MediaSize" => 187602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-46ad3d10d6e88a696c743f2b9eb0db43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29967190_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/7b8421656a6dc7e40be60933e93db01f.webp"
"MediaSize" => 302146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-7b8421656a6dc7e40be60933e93db01f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29967190_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/dd03bcb6864139852e5cf65fcec1c3f7.webp"
"MediaSize" => 282783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-dd03bcb6864139852e5cf65fcec1c3f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29967190_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/9e2fce66dbb1d15386ca5eb1a271b511.webp"
"MediaSize" => 217102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-9e2fce66dbb1d15386ca5eb1a271b511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29967190_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967190/c9ef1e353fc6561ac343c6c371652f76.webp"
"MediaSize" => 185254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29967190/thumbnail-c9ef1e353fc6561ac343c6c371652f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13501524"
"ResourceRecordKey" => "29967190"
"ModificationTimestamp" => "2026-06-29T18:56:59.6Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967190')"
+"ID": "1577313"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1574963"
+post_author: 1
+"ListingKey": "29964718"
+"ListingId": "X13499420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:35:18Z"
+"RFModificationTimestamp": "2026-06-29T13:55:43Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "86 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.8776048
1 => 43.347112
]
+"Latitude": 43.347112
+"Longitude": -79.8776048
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional detached home in the highly sought-after community of Waterdown, offering nearly 3,000 sq. ft. of beautifully finished living space designed for modern family life and elegant entertaining. Situated on a premium corner lot, this impressive 4-bedroom, 4-bathroom residence showcases timeless finishes and meticulous attention to detail throughout. Step inside to discover 9-foot smooth ceilings, rich oak hardwood flooring, and elegant crown moulding that create a sophisticated and inviting atmosphere. At the heart of the home is the chef-inspired kitchen, featuring high-end cabinetry, a large centre island, stainless steel appliances, and an ideal layout for both everyday living and hosting family and friends. Spacious principal rooms provide plenty of room to gather, while large windows fill the home with natural light. Upstairs, you'll find four generously sized bedrooms, including a luxurious primary retreat complete with a spa-inspired 5 pc ensuite and 2 walk-in closets! The professionally finished basement extends your living space, offering endless possibilities for recreation, a home theatre, gym, office, or guest accommodations. Step outside to your professionally landscaped backyard oasis, with multiple deck areas, gazebo and shed - thoughtfully designed for outdoor enjoyment, relaxation, and entertaining. Ideally located with quick access to Burlington, major highways, and the GO Train, this home offers the perfect blend of small-town charm and commuter convenience. An outstanding opportunity to own a beautifully upgraded family home in one of Waterdown's most desirable neighbourhoods. See the MultiMedia Video Tour, then book your private tour before it's gone! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:55:31.363991+00:00"
+"Directions": "Cross Streets: Dundas/Spring Creek. ** Directions: Dundas to Spring Creek to Stillwater."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947927"
+"ListOfficeKey": "86922"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38.1 x 89.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T12:27:43Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:27:43Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "86"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7465.65"
+"VirtualTourURLUnbranded": "https://tour.shutterhouse.ca/vd/253689401"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1671063675"
"RoomType" => "Kitchen"
"ListingId" => "X13499420"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29964718"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
1 => array:11 [
"RoomKey" => "1671063676"
"RoomType" => "Dining room"
"ListingId" => "X13499420"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29964718"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
2 => array:11 [
"RoomKey" => "1671063677"
"RoomType" => "Living room"
"ListingId" => "X13499420"
"RoomLevel" => "Main level"
"RoomWidth" => 4.88
"ListingKey" => "29964718"
"RoomLength" => 3.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
3 => array:11 [
"RoomKey" => "1671063678"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13499420"
"RoomLevel" => "Second level"
"RoomWidth" => 4.57
"ListingKey" => "29964718"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
4 => array:11 [
"RoomKey" => "1671063679"
"RoomType" => "Bedroom 2"
"ListingId" => "X13499420"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29964718"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
5 => array:11 [
"RoomKey" => "1671063680"
"RoomType" => "Bedroom 3"
"ListingId" => "X13499420"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29964718"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
6 => array:11 [
"RoomKey" => "1671063681"
"RoomType" => "Bedroom 4"
"ListingId" => "X13499420"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29964718"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
7 => array:11 [
"RoomKey" => "1671063682"
"RoomType" => "Great room"
"ListingId" => "X13499420"
"RoomLevel" => "Basement"
"RoomWidth" => 6.1
"ListingKey" => "29964718"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:27:43.67Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964718/86-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-06-29T12:27:43.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267694"
+"ListOfficeNationalAssociationId": "1148953"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964718_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/9daa6c21152e09f16d68ddbea84c0716.webp"
"MediaSize" => 410687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-9daa6c21152e09f16d68ddbea84c0716.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964718_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/3b08db6d6932cecc83199aee8bb54688.webp"
"MediaSize" => 368770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-3b08db6d6932cecc83199aee8bb54688.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964718_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/a4bb046455d418b52835878c6e838dc9.webp"
"MediaSize" => 139481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-a4bb046455d418b52835878c6e838dc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964718_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/89184dc2a9d2ae3516739c6a7c620109.webp"
"MediaSize" => 248514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-89184dc2a9d2ae3516739c6a7c620109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964718_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/511a0a4415c6c9d70a62a09aca6af1d9.webp"
"MediaSize" => 231585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-511a0a4415c6c9d70a62a09aca6af1d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964718_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/662e265a8d086742f3018be62a03c9b8.webp"
"MediaSize" => 262648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-662e265a8d086742f3018be62a03c9b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964718_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/e53cf50a17cf48d7a930c2952cdef098.webp"
"MediaSize" => 218714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-e53cf50a17cf48d7a930c2952cdef098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964718_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/c32f2949ebc0ef64265906fecc9c125a.webp"
"MediaSize" => 203197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-c32f2949ebc0ef64265906fecc9c125a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964718_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/15cf892b524e65f1d829b6fb02d97588.webp"
"MediaSize" => 242357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-15cf892b524e65f1d829b6fb02d97588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964718_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/8c9287a061c170bbabbf936dbb05da0d.webp"
"MediaSize" => 233382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-8c9287a061c170bbabbf936dbb05da0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964718_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/5144f8c37f2402c76afb5ca66fcfc89d.webp"
"MediaSize" => 219039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-5144f8c37f2402c76afb5ca66fcfc89d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964718_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/447d2683f4b9ac53887f19935ef13921.webp"
"MediaSize" => 169871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-447d2683f4b9ac53887f19935ef13921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964718_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/a6fbbd26a9d6ebe2d546a6d7c4341c3d.webp"
"MediaSize" => 143477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-a6fbbd26a9d6ebe2d546a6d7c4341c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964718_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/27e9838991e27b18bcb6b4007326b5bd.webp"
"MediaSize" => 174192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-27e9838991e27b18bcb6b4007326b5bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964718_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/8c93fc12106bc4aa288c41f56da1e18b.webp"
"MediaSize" => 174990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-8c93fc12106bc4aa288c41f56da1e18b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964718_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/818d3d6d21019a6c0b9a96dbfc0deb3f.webp"
"MediaSize" => 194537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-818d3d6d21019a6c0b9a96dbfc0deb3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964718_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/57312d1d70189429f6d3c82c7a8ab2a4.webp"
"MediaSize" => 232255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-57312d1d70189429f6d3c82c7a8ab2a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964718_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/22e9f3f45d514952aca6475d0cc32eb3.webp"
"MediaSize" => 148811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-22e9f3f45d514952aca6475d0cc32eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964718_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/847da8911c59e2f970f35cd1fbda398c.webp"
"MediaSize" => 187712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-847da8911c59e2f970f35cd1fbda398c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29964718_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/01b1d6160ed6bd0ef78ead60bd872efc.webp"
"MediaSize" => 183551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-01b1d6160ed6bd0ef78ead60bd872efc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29964718_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/7e51c6aa9d5e8ea862dad9710aabd101.webp"
"MediaSize" => 178330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-7e51c6aa9d5e8ea862dad9710aabd101.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29964718_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/c3491fdc8ff536873b00084c2987946a.webp"
"MediaSize" => 150958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-c3491fdc8ff536873b00084c2987946a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29964718_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/6c0fbc5e3e72f381117d44a08df7bb22.webp"
"MediaSize" => 184847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-6c0fbc5e3e72f381117d44a08df7bb22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29964718_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/62c52c8c3659381611920bcf7d173173.webp"
"MediaSize" => 169392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-62c52c8c3659381611920bcf7d173173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29964718_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/654ff92e47501e421b1c82ee96d6bc84.webp"
"MediaSize" => 278416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-654ff92e47501e421b1c82ee96d6bc84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29964718_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/ba9b7eb622e92bc89a82e7161396dcac.webp"
"MediaSize" => 240919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-ba9b7eb622e92bc89a82e7161396dcac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29964718_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/23c4e584034144b2b2b5c299844d389b.webp"
"MediaSize" => 237552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-23c4e584034144b2b2b5c299844d389b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29964718_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/b5fe333a48bee94a923e3e2ba9f77099.webp"
"MediaSize" => 215568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-b5fe333a48bee94a923e3e2ba9f77099.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29964718_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/0c38c7e9ea6a94c4c7123f8e539a872e.webp"
"MediaSize" => 211625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-0c38c7e9ea6a94c4c7123f8e539a872e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29964718_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/ee15abf67dbfcdaa28b2808ec70983d1.webp"
"MediaSize" => 217437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-ee15abf67dbfcdaa28b2808ec70983d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29964718_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/5d51bf918ba7d9ce8ad050cd15f167af.webp"
"MediaSize" => 202650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-5d51bf918ba7d9ce8ad050cd15f167af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29964718_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964718/39e18b4f0a5fcc4254f1f724faf19080.webp"
"MediaSize" => 224912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964718/thumbnail-39e18b4f0a5fcc4254f1f724faf19080.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499420"
"ResourceRecordKey" => "29964718"
"ModificationTimestamp" => "2026-06-29T12:27:43.64Z"
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964718')"
+"ID": "1574963"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1574426"
+post_author: 1
+"ListingKey": "29963842"
+"ListingId": "X13498608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T14:50:13Z"
+"RFModificationTimestamp": "2026-06-28T16:21:44Z"
+"ListPrice": 389900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "612 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and sunny 1-bedroom condo with underground parking and locker in a well-managed, modern condo community. This stylish unit features an unobstructed balcony, upgraded flooring, sleek kitchen cabinetry, granite countertops, and upgraded stainless steel appliances. You'll also enjoy full-sized front-loading laundry, and a contemporary bathroom vanity with quartz finishes. The building offers top-tier amenities including a fully equipped gym, rooftop terrace with BBQs, elegant party room, and secure bike storage. Conveniently located just minutes from Aldershot GO, major highways, scenic trails, shops, and a short drive to Lake Ontario.The unit includes 1 underground parking space and 1 locker. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "518.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-28T16:21:38.959899+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Riverwalk. ** Directions: Dundas St E to Mallard Trail to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048285"
+"ListOfficeKey": "257079"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-28T14:43:29Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T14:43:29Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2600"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963842/612-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-28T14:43:29.33Z"
+"ListAgentNationalAssociationId": "1323624"
+"ListOfficeNationalAssociationId": "1213993"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963842')"
+"ID": "1574426"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1570187"
+post_author: 1
+"ListingKey": "29958286"
+"ListingId": "X13493838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:30:18Z"
+"RFModificationTimestamp": "2026-06-26T18:29:29Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z8"
+"UnparsedAddress": "446 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1Z8"
+"Coordinates": array:2 [
0 => -79.87188
1 => 43.345646
]
+"Latitude": 43.345646
+"Longitude": -79.87188
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the family-oriented Waterdown community, 446 Humphrey St is an exceptional 5-bedroom, 4-bathroom executive residence that blends refined finishes and functionality across its 3,474 sq ft above-grade layout.The main level introduces itself with a grand double-door entry, an elegant tiled foyer, rich hardwood flooring, and expansive principal spaces designed for both everyday comfort and sophisticated entertaining. A private main-floor office provides exceptional flexibility for remote work or a potential 6th bedroom. The chef-inspired kitchen is thoughtfully curated with quartz countertops, a sleek quartz backsplash, premium Samsung appliances, and a dedicated servery designed with extensive cabinetry for staging, serving, and discreet storage. The adjoining breakfast area and family room are flooded with natural light and anchored by a fireplace, creating a warm and inviting atmosphere overlooking the backyard. The second level unfolds with intention, featuring five generously proportioned bedrooms, all complete with walk-in closets. The primary retreat is a true sanctuary with a spacious walk-in closet and a spa-inspired 5-piece ensuite featuring dual vanities and elegant finishes. Secondary bedrooms are exceptionally well-sized and connected through thoughtfully designed Jack & Jill bathroom layouts, creating both privacy and functionality for growing families. A dedicated upper-level laundry room further enhances convenience. The unfinished lower level presents extraordinary future potential with oversized windows, expansive open-concept space, a cold room, and the flexibility to design a custom recreation space, gym, home theatre, or in-law suite tailored to your lifestyle. Outdoors, the backyard awaits transformation into a private outdoor retreat, while the home is located in close proximity to major highways, top-rated schools, shopping, restaurants, conservation areas, golf courses, and scenic walking trails. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:29:21.625328+00:00"
+"Directions": "Cross Streets: Dundas St E & Skinner Rd. ** Directions: Dundas St E to Skinner Rd to Humphrey St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417634"
+"ListOfficeKey": "270338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Guest Suite"
]
+"LotSizeDimensions": "57.1 x 97.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T16:21:49Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:21:49Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "446"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9900"
+"VirtualTourURLUnbranded": "https://vimeo.com/1190320791?share=copy&fl=sv&fe=ci"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958286/446-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2222228"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269129"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.1
+"OriginalEntryTimestamp": "2026-06-26T16:21:49.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1035732"
+"ListOfficeNationalAssociationId": "1235224"
+"CoListAgentNationalAssociationId": "1465862"
+"CoListOfficeNationalAssociationId": "1231804"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958286')"
+"ID": "1570187"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1568946"
+post_author: 1
+"ListingKey": "29957771"
+"ListingId": "X13493364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:35:18Z"
+"RFModificationTimestamp": "2026-06-29T12:38:44Z"
+"ListPrice": 969990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "26 GRANITE RIDGE TRAIL, Hamilton (Waterdown), Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.878616
1 => 43.337201
]
+"Latitude": 43.337201
+"Longitude": -79.878616
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2,400 sq. ft. home offering 4 bedrooms and 3.5 bathrooms in one of Waterdown's most sought-after family neighbourhoods. Built in 2021 and well cared for by the original owners, this home is beautifully upgraded throughout. The open-concept main floor features vinyl plank flooring, hardwood stairs, California shutters, a private office, and a bright living room with a gas fireplace. The kitchen features custom Barzotti cabinetry, quartz countertops, a large island, and a subway tile backsplash. The second level offers four spacious bedrooms, including two with private ensuites. The primary suite features his-and-hers walk-in closets, a double vanity, and a frameless glass shower. Additional features include upper-level laundry, a gas BBQ line, and a basement bathroom rough-in for future potential. Ideally located close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T16:04:01.229257+00:00"
+"Directions": "Cross Streets: Kenesky Dr. ** Directions: Dundas St E - Burke St - Kenesky Dr."
+"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": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T15:21:44Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:27:34Z"
+"Stories": "2.0"
+"StreetName": "Granite Ridge"
+"StreetNumber": "26"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7254.63"
+"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/29957771/26-granite-ridge-trail-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
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-06-26T15:21:44.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957771')"
+"ID": "1568946"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1567703"
+post_author: 1
+"ListingKey": "29956107"
+"ListingId": "X13491700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T19:25:16Z"
+"RFModificationTimestamp": "2026-06-27T19:30:48Z"
+"ListPrice": 510000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "502 - 470 DUNDAS STREET, 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": "Welcome to 470 Dundas St E, Unit 502 - a bright corner two-bedroom condo with rare side-by-side parking and unobstructed sunset views. This modern suite features 10-foot ceilings,floor-to-ceiling windows, vinyl flooring, custom roller blinds, and an oversized balcony perfect for relaxing or entertaining. Enjoy the added convenience of two parking spots near the elevator and a same-floor storage locker. Building amenities include fitness centres, party rooms, rooftop terraces with BBQs, on-site management, and a superintendent. Conveniently located near highways, GO Transit, parks, trails, and everyday amenities. Ideally situated with quick access to major highways, the GO Train, nearby parks, trails, shopping, and everyday conveniences, this condo is a fantastic option for commuters, downsizers, and anyone looking for modern condo living. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Barbeque"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"AssociationFee": "634.77"
+"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:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-26T04:59:56.667005+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203994"
+"ListOfficeKey": "282937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-26T00:45:10Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T19:18:02Z"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2020"
+"View": "City view"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956107/502-470-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1948582"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"CoListOfficeKey": "257504"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-26T00:45:10.04Z"
+"ListAgentNationalAssociationId": "1452632"
+"ListOfficeNationalAssociationId": "1323558"
+"CoListAgentNationalAssociationId": "1243082"
+"CoListOfficeNationalAssociationId": "1214882"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956107')"
+"ID": "1567703"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1565694"
+post_author: 1
+"ListingKey": "29954208"
+"ListingId": "40843154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:25Z"
+"RFModificationTimestamp": "2026-06-28T20:24:52Z"
+"ListPrice": 969990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "26 GRANITE RIDGE Trail, Waterdown, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.8786022
1 => 43.3372225
]
+"Latitude": 43.3372225
+"Longitude": -79.8786022
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2,400 sq. ft. home offering 4 bedrooms and 3.5 bathrooms in one of Waterdown's most sought-after family neighbourhoods. Built in 2021 and well cared for by the original owners, this home is beautifully upgraded throughout. The open-concept main floor features vinyl plank flooring, hardwood stairs, California shutters, a private office, and a bright living room with a gas fireplace. The kitchen features custom Barzotti cabinetry, quartz countertops, a large island, and a subway tile backsplash. The second level offers four spacious bedrooms, including two with private ensuites. The primary suite features his-and-hers walk-in closets, a double vanity, and a frameless glass shower. Additional features include upper-level laundry, a gas BBQ line, and a basement bathroom rough-in for future potential. Ideally located close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. Call to book your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:24:56.281861+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:31:01Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:10:32Z"
+"Stories": "2.0"
+"StreetName": "GRANITE RIDGE"
+"StreetNumber": "26"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7254.63"
+"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/29954208/26-granite-ridge-trail-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2400
+"OriginalEntryTimestamp": "2026-06-25T19:31:01.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954208')"
+"ID": "1565694"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: "1565408"
+post_author: 1
+"ListingKey": "29954379"
+"ListingId": "40843052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:42:15Z"
+"ListPrice": 1649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1908.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "17 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8821102
1 => 43.3322944
]
+"Latitude": 43.3322944
+"Longitude": -79.8821102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A custom-built Branthaven bungalow nestled on spectacular 66' x 162' ravine lot, where mature trees & natural surroundings create a peaceful, private retreat in one of Waterdown's most desirable neighbourhoods. Backing directly onto the renowned Bruce Trail, this exceptional property offers a rare opportunity to enjoy nature from your own backyard. Step inside to a welcoming foyer opening to spacious great room w/ vaulted ceiling, floor-to-ceiling FP, & abundant natural light. Dining area walks out to a raised deck overlooking the ravine setting—perfect for morning coffee, outdoor dining, or unwinding to the peaceful sounds of birds & nature. Updated kitchen w/ high-end SS appliances, breakfast bar, & large windows bringing the beauty of the outdoors in. Whether preparing gourmet meals for family gatherings or hosting friends, this space is as functional as it is inviting. Main level offers spacious primary suite w/ backyard views & updated 4pc ensuite w/ soaker tub & glass shower w/ steam sauna. 2 addtl generously sized bedrooms & updated 3pc bath complete the level. Heated floors in all bathrooms. Impressive walkout lower level expands the living space w/ large recreation & games room, family room w/ FP, den, 4th bedroom, 4pc updated bath w/ steam sauna, laundry area, & ample storage. With direct backyard access, this level offers exceptional flexibility for multi-generational living, working from home, relaxing, or entertaining. Pool-sized backyard offers endless possibilities for children, pets, gardening enthusiasts, or creating your dream outdoor oasis. Ideal for downsizers seeking main-floor living without compromise or growing families looking for a forever home w/ room to live, work, & play. Located in a prestigious Waterdown enclave known for executive homes, schools, parks, & strong sense of community, w/ convenient access to shopping, dining, major highways, & Aldershot GO Station. A truly special home where nature, comfort, & convenience come together. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:42:07.112139+00:00"
+"Directions": "MOUNTAIN BROW ROAD TO FLANDERS DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:10:55Z"
+"Stories": "1.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "17"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8661.19"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204278829"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954379/17-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1908
+"OriginalEntryTimestamp": "2026-06-25T19:50:37.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954379')"
+"ID": "1565408"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25221
+post_id: "1562607"
+post_author: 1
+"ListingKey": "29950035"
+"ListingId": "40842858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T14:20:13Z"
+"RFModificationTimestamp": "2026-06-25T21:06:00Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3216.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER Road, Waterdown, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8764861
1 => 43.3410353
]
+"Latitude": 43.3410353
+"Longitude": -79.8764861
+"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:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Window Coverings"
]
+"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-25T21:04:42.432242+00:00"
+"Directions": "DUNDAS ST E TO MALLARD TR TO SKINNER RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"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": "2026-06-24T23:49:53Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T14:11:08Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8117"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29950035/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
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-24T23:49:53.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950035')"
+"ID": "1562607"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 160
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
]