array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29507111 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1248436"
+post_author: 1
+"ListingKey": "29507111"
+"ListingId": "X12912922"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T11:55:01Z"
+"RFModificationTimestamp": "2026-06-23T11:58:07Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "250 MILL STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.898513
1 => 43.339613
]
+"Latitude": 43.339613
+"Longitude": -79.898513
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 250 Mill Street North in the heart of Waterdown Village! Set on a spacious 68' x 146' corner lot, this detached two-storey home offers endless potential for renovators and builders alike with the R1 Zoning. Featuring four bedrooms, one four-piece bathroom, and a bright sunroom, this property provides 1,843 sq. ft. of above-grade finished living space. Located steps from Mary Hopkins Public School and Waterdown Memorial Park, this rare opportunity sits among tree-lined streets filled with character homes. Enjoy the small-town charm of this sought-after neighbourhood while being close to all of Waterdown's growing amenities! Property being sold as-is. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Oven - Built-In"
]
+"Basement": array:3 [
0 => "Unfinished"
1 => "Partial"
2 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-03-24T13:51:23.692875+00:00"
+"Directions": "Cross Streets: Parkside Drive and Mill Street. ** Directions: Parkside Drive to Mill Stree."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092571"
+"ListOfficeKey": "288501"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "68 x 146 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T11:49:30Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T11:49:30Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "Mill"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5072"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657441637"
"RoomType" => "Kitchen"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 7.1
"ListingKey" => "29507111"
"RoomLength" => 15.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
1 => array:11 [
"RoomKey" => "1657441638"
"RoomType" => "Laundry room"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 7.4
"ListingKey" => "29507111"
"RoomLength" => 8.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
2 => array:11 [
"RoomKey" => "1657441639"
"RoomType" => "Bathroom"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 7.3
"ListingKey" => "29507111"
"RoomLength" => 6.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
3 => array:11 [
"RoomKey" => "1657441640"
"RoomType" => "Family room"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 23.1
"ListingKey" => "29507111"
"RoomLength" => 14.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
4 => array:11 [
"RoomKey" => "1657441641"
"RoomType" => "Office"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 6.6
"ListingKey" => "29507111"
"RoomLength" => 11.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
5 => array:11 [
"RoomKey" => "1657441642"
"RoomType" => "Bedroom 2"
"ListingId" => "X12912922"
"RoomLevel" => "Second level"
"RoomWidth" => 7.0
"ListingKey" => "29507111"
"RoomLength" => 11.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
6 => array:11 [
"RoomKey" => "1657441643"
"RoomType" => "Bedroom 3"
"ListingId" => "X12912922"
"RoomLevel" => "Second level"
"RoomWidth" => 9.9
"ListingKey" => "29507111"
"RoomLength" => 7.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
7 => array:11 [
"RoomKey" => "1657441636"
"RoomType" => "Dining room"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 15.5
"ListingKey" => "29507111"
"RoomLength" => 15.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
8 => array:11 [
"RoomKey" => "1657441635"
"RoomType" => "Living room"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 16.1
"ListingKey" => "29507111"
"RoomLength" => 11.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.67Z"
]
9 => array:11 [
"RoomKey" => "1657441634"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12912922"
"RoomLevel" => "Second level"
"RoomWidth" => 17.0
"ListingKey" => "29507111"
"RoomLength" => 11.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.66Z"
]
10 => array:11 [
"RoomKey" => "1657441633"
"RoomType" => "Bedroom"
"ListingId" => "X12912922"
"RoomLevel" => "Main level"
"RoomWidth" => 9.11
"ListingKey" => "29507111"
"RoomLength" => 11.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T23:41:16.66Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29507111/250-mill-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2136173"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "287459"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 68.0
+"OriginalEntryTimestamp": "2026-03-24T12:11:06.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365119"
+"ListOfficeNationalAssociationId": "1368759"
+"CoListAgentNationalAssociationId": "1388412"
+"CoListOfficeNationalAssociationId": "1368246"
+"Media": array:46 [
0 => array:13 [
"Order" => 5
"MediaKey" => "6538457473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/271c1b07698030573062f4f348d63159.webp"
"MediaSize" => 310457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-271c1b07698030573062f4f348d63159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
1 => array:13 [
"Order" => 6
"MediaKey" => "6538457483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/46a432e14bf02b4ad0526f2b89cbd961.webp"
"MediaSize" => 327893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-46a432e14bf02b4ad0526f2b89cbd961.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
2 => array:13 [
"Order" => 7
"MediaKey" => "6538457516"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/60ef8aa2df9a7cbaa8b2a5284f3d3c0d.webp"
"MediaSize" => 87294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-60ef8aa2df9a7cbaa8b2a5284f3d3c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
3 => array:13 [
"Order" => 8
"MediaKey" => "6538457522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/6727e817750187a8c6cd22ceafccfa39.webp"
"MediaSize" => 192936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-6727e817750187a8c6cd22ceafccfa39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
4 => array:13 [
"Order" => 9
"MediaKey" => "6538457546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/d4208ad271b37a649f078e5c7447cba7.webp"
"MediaSize" => 293016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-d4208ad271b37a649f078e5c7447cba7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
5 => array:13 [
"Order" => 10
"MediaKey" => "6538457578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/95b39425ae5a7bacd6273854b4172603.webp"
"MediaSize" => 324838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-95b39425ae5a7bacd6273854b4172603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
6 => array:13 [
"Order" => 11
"MediaKey" => "6538457586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/922c332f54d9725cf891c5b460b343c2.webp"
"MediaSize" => 124278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-922c332f54d9725cf891c5b460b343c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
7 => array:13 [
"Order" => 12
"MediaKey" => "6538457612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/11cbff72a4f6f048955dfc9686707ffe.webp"
"MediaSize" => 209550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-11cbff72a4f6f048955dfc9686707ffe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
8 => array:13 [
"Order" => 13
"MediaKey" => "6538457629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/fb8237b1c544bcda6cea87c517a6ecd1.webp"
"MediaSize" => 297254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-fb8237b1c544bcda6cea87c517a6ecd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
9 => array:13 [
"Order" => 14
"MediaKey" => "6538457651"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/b6832aae954b295f45b22c9cf6b36c18.webp"
"MediaSize" => 297289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-b6832aae954b295f45b22c9cf6b36c18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
10 => array:13 [
"Order" => 15
"MediaKey" => "6538457675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/5a42dd7a5b49e5c67717b1a67f303129.webp"
"MediaSize" => 293918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-5a42dd7a5b49e5c67717b1a67f303129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
11 => array:13 [
"Order" => 16
"MediaKey" => "6538457684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/23cb7aae5362d146fc88063cd0e01954.webp"
"MediaSize" => 165845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-23cb7aae5362d146fc88063cd0e01954.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
12 => array:13 [
"Order" => 17
"MediaKey" => "6538457715"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/782e76fdb2eab6f9698445a55ac11478.webp"
"MediaSize" => 173781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-782e76fdb2eab6f9698445a55ac11478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
13 => array:13 [
"Order" => 18
"MediaKey" => "6538457742"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/30a14e87893dd50522b97787629b7a3e.webp"
"MediaSize" => 192060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-30a14e87893dd50522b97787629b7a3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
14 => array:13 [
"Order" => 19
"MediaKey" => "6538457773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/66f166649a5a69d0f4f112a76ee68d46.webp"
"MediaSize" => 293842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-66f166649a5a69d0f4f112a76ee68d46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
15 => array:13 [
"Order" => 20
"MediaKey" => "6538457794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/b47475a4731e862142656eb77c0b0eab.webp"
"MediaSize" => 131746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-b47475a4731e862142656eb77c0b0eab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
16 => array:13 [
"Order" => 21
"MediaKey" => "6538457824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/95e256471663690c26aac95abaec40ee.webp"
"MediaSize" => 175234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-95e256471663690c26aac95abaec40ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
17 => array:13 [
"Order" => 22
"MediaKey" => "6538457830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/b4c0c70c225dca983479d91b3cd116ab.webp"
"MediaSize" => 176785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-b4c0c70c225dca983479d91b3cd116ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
18 => array:13 [
"Order" => 23
"MediaKey" => "6538457837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/cd2d1c52c883f9137b2624a27a929532.webp"
"MediaSize" => 310312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-cd2d1c52c883f9137b2624a27a929532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
19 => array:13 [
"Order" => 24
"MediaKey" => "6538457855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/479eadb9d3125abe63b3de342f77a28b.webp"
"MediaSize" => 179804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-479eadb9d3125abe63b3de342f77a28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
20 => array:13 [
"Order" => 25
"MediaKey" => "6538457879"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/96d2f71f697773963c053333f8b79509.webp"
"MediaSize" => 160363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-96d2f71f697773963c053333f8b79509.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
21 => array:13 [
"Order" => 26
"MediaKey" => "6538457898"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/86450e5be637e7c8399c9c3cf24f92c5.webp"
"MediaSize" => 194115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-86450e5be637e7c8399c9c3cf24f92c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
22 => array:13 [
"Order" => 27
"MediaKey" => "6538457908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/282618d84f60de2fd98ca5e6df133a62.webp"
"MediaSize" => 275720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-282618d84f60de2fd98ca5e6df133a62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
23 => array:13 [
"Order" => 28
"MediaKey" => "6538457920"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/be2958a09dffe632d820b80ab33d4312.webp"
"MediaSize" => 324422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-be2958a09dffe632d820b80ab33d4312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
24 => array:13 [
"Order" => 29
"MediaKey" => "6538457926"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/aa149e03e7a2dc93c66aeb99388b1abd.webp"
"MediaSize" => 298611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-aa149e03e7a2dc93c66aeb99388b1abd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
25 => array:13 [
"Order" => 30
"MediaKey" => "6538457939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/f099840d4ec4dc9e8f5cbd079203e3a7.webp"
"MediaSize" => 328293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-f099840d4ec4dc9e8f5cbd079203e3a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
26 => array:13 [
"Order" => 31
"MediaKey" => "6538457950"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/4b8a5ad8b7c4a9431cb05cb0af9d60ac.webp"
"MediaSize" => 117998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-4b8a5ad8b7c4a9431cb05cb0af9d60ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
27 => array:13 [
"Order" => 32
"MediaKey" => "6538457965"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/82d8531e25ded0f679f4e0db25057ece.webp"
"MediaSize" => 324838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-82d8531e25ded0f679f4e0db25057ece.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
28 => array:13 [
"Order" => 33
"MediaKey" => "6538457976"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/2125c9c4b6633d1f8fcb745d19ed31c7.webp"
"MediaSize" => 161141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-2125c9c4b6633d1f8fcb745d19ed31c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
29 => array:13 [
"Order" => 34
"MediaKey" => "6538457981"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/aa88ff49a8a2b4c7c2ab6a9465c4af9a.webp"
"MediaSize" => 148299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-aa88ff49a8a2b4c7c2ab6a9465c4af9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
30 => array:13 [
"Order" => 35
"MediaKey" => "6538457993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/87df65bbf33829dcfc71d05d0ecd35a3.webp"
"MediaSize" => 185236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-87df65bbf33829dcfc71d05d0ecd35a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
31 => array:13 [
"Order" => 36
"MediaKey" => "6538458003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/553401b7e7ca827acb03f52c6f5b0f3b.webp"
"MediaSize" => 195712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-553401b7e7ca827acb03f52c6f5b0f3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
32 => array:13 [
"Order" => 37
"MediaKey" => "6538458015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/9b157a4b1f4c8bd0380e13914e9db6b0.webp"
"MediaSize" => 270955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-9b157a4b1f4c8bd0380e13914e9db6b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
33 => array:13 [
"Order" => 38
"MediaKey" => "6538458029"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/176d42aee66fdbf497d095a166530e9b.webp"
"MediaSize" => 153000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-176d42aee66fdbf497d095a166530e9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
34 => array:13 [
"Order" => 39
"MediaKey" => "6538458042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/2c9d733159e200d9985be101e54d7c44.webp"
"MediaSize" => 137603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-2c9d733159e200d9985be101e54d7c44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
35 => array:13 [
"Order" => 40
"MediaKey" => "6538458050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/27612d947a16df0ca361b7504b8d7abf.webp"
"MediaSize" => 174281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-27612d947a16df0ca361b7504b8d7abf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
36 => array:13 [
"Order" => 41
"MediaKey" => "6538458059"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/b05189093aa583df5a85e4ad1e8dffa8.webp"
"MediaSize" => 146188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-b05189093aa583df5a85e4ad1e8dffa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
37 => array:13 [
"Order" => 42
"MediaKey" => "6538458071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/1fc7d7d4769dffa9df6c871c068fc54d.webp"
"MediaSize" => 356601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-1fc7d7d4769dffa9df6c871c068fc54d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
38 => array:13 [
"Order" => 43
"MediaKey" => "6538458089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/fd1e6e2697fd8011726ee59a6a82bee2.webp"
"MediaSize" => 169738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-fd1e6e2697fd8011726ee59a6a82bee2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
39 => array:13 [
"Order" => 44
"MediaKey" => "6538458101"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/22683ca03ac475b9f5d55dc041f0ffa7.webp"
"MediaSize" => 188671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-22683ca03ac475b9f5d55dc041f0ffa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
40 => array:13 [
"Order" => 45
"MediaKey" => "6538458113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/eb398bcb981d56bc0b7263932920cd57.webp"
"MediaSize" => 298877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-eb398bcb981d56bc0b7263932920cd57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-03-24T12:11:06.23Z"
]
41 => array:13 [
"Order" => 1
"MediaKey" => "29507111_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/536bd4293f86cd6bc74e9529c95c0725.webp"
"MediaSize" => 324838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-536bd4293f86cd6bc74e9529c95c0725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-06-23T11:49:30.6Z"
]
42 => array:13 [
"Order" => 2
"MediaKey" => "29507111_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/fdbb61aa264f4ffc411381778df43756.webp"
"MediaSize" => 324422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-fdbb61aa264f4ffc411381778df43756.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-06-23T11:49:30.15Z"
]
43 => array:13 [
"Order" => 3
"MediaKey" => "29507111_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/055dd99cebd558099ad396eeb1c9b22f.webp"
"MediaSize" => 293016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-055dd99cebd558099ad396eeb1c9b22f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-06-23T11:49:30.41Z"
]
44 => array:13 [
"Order" => 4
"MediaKey" => "29507111_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/d49e1cd2d4664cbc76543a1637c813af.webp"
"MediaSize" => 298611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-d49e1cd2d4664cbc76543a1637c813af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-06-23T11:49:30.56Z"
]
45 => array:13 [
"Order" => 5
"MediaKey" => "29507111_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507111/45cf67cd0c1a91cfebd262355a4ed96b.webp"
"MediaSize" => 270955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507111/thumbnail-45cf67cd0c1a91cfebd262355a4ed96b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12912922"
"ResourceRecordKey" => "29507111"
"ModificationTimestamp" => "2026-06-23T11:49:30.12Z"
]
]
+"DaysOnMarket": 97
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29507111')"
+"ID": "1248436"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288501" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24876
+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 2092571" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24887
+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 '29507111'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29507111'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25354
+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 '29507111' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.898513 43.339613)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25309
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+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"
…2
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967190')"
+"ID": "1577313"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+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 [ …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/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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964718')"
+"ID": "1574963"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1574964"
+post_author: 1
+"ListingKey": "29964832"
+"ListingId": "40843093"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:10:11Z"
+"RFModificationTimestamp": "2026-06-29T14:12:46Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.322
+"LivingArea": 951.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 E DUNDAS Street E Unit# 315, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8960168
1 => 43.3299381
]
+"Latitude": 43.3299381
+"Longitude": -79.8960168
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Absolutely meticulously maintained 1+1 condo located in the heart of Waterdown. This spotless unit features 10 foot ceilings, crown molding, transom window, patio sliding doors to private balcony, ceiling fans, in-suite laundry room, and breakfast bar. This wonderful unit is bright and airy with a stunning open concept layout. Double French doors lead to a spacious office or second bedroom if required. Furnace and C/Air replaced 2022. The apartment is within walking distance to all amenities, transportation, and recreational parks and shops. Fantastic unit in a quite and safe location. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "733.54"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:47:04.205980+00:00"
+"Directions": "Dundas Street East to Hamilton Street South"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524989"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"LotSizeDimensions": "2.322"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T13:10:02Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:02:20Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3719.65"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364556"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964832/262-dundas-street-e-unit-315-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 510.0
+"AboveGradeFinishedArea": 951
+"OriginalEntryTimestamp": "2026-06-29T13:10:02.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063309"
+"ListOfficeNationalAssociationId": "1286675"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964832')"
+"ID": "1574964"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1572570"
+post_author: 1
+"ListingKey": "29961749"
+"ListingId": "X13496704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:40:12Z"
+"RFModificationTimestamp": "2026-06-29T14:45:49Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.882882
1 => 43.329912
]
+"Latitude": 43.329912
+"Longitude": -79.882882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Burlington's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room & a dedicated den/home office.Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning F/P.Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture & nature come together in perfect harmony. Luxury Certified (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T01:10:19.307439+00:00"
+"Directions": "Cross Streets: Mountain Brow Road. ** Directions: Waterdown Road to Mountain Brow Road."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047588"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "256.3 x 127.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T00:44:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:30:48Z"
+"Stories": "1.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://344mountainbrowroad.marketingrmx.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961749/344-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 256.3
+"OriginalEntryTimestamp": "2026-06-27T00:44:49.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323031"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961749')"
+"ID": "1572570"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23460
+post_id: "1571912"
+post_author: 1
+"ListingKey": "29960542"
+"ListingId": "X13495616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:02Z"
+"RFModificationTimestamp": "2026-06-26T23:04:46Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X1"
+"UnparsedAddress": "14 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X1"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained and move-in-ready corner-unit townhouse offering approximately 1,800 sq. ft. of bright and functional living space. This spacious home features 3+1 bedrooms, 3 bathrooms, a double-car garage, plus 2 additional driveway parking spaces. The desirable corner location allows for an abundance of natural light through numerous windows throughout the home. Enjoy an open-concept kitchen overlooking the dining area, complete with a large pantry and excellent storage space. The well-designed layout includes generously sized bedrooms and a primary suite with an ensuite bath. An unfinished basement offers exceptional potential for future customization and added living space while providing ample storage. Relax on the private balcony with gas hookups and enjoy comfortable, low-maintenance living in a sought-after, family-friendly community. Ideally located with exceptional accessibility, this home is just minutes from major highways, shopping centres, schools, parks, restaurants, and all everyday amenities, making it a perfect choice for families seeking both convenience and comfort. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:04:38.815915+00:00"
+"Directions": "Hamilton St N / Dundas St E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946962"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:00Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:00Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6356.58"
+"View": "View"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960542/14-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1892161"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 905-540-8800"
+"CoListOfficeKey": "50236"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "R6-33"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T20:48:00.12Z"
+"ListAgentNationalAssociationId": "1241888"
+"ListOfficeNationalAssociationId": "1002993"
+"CoListAgentNationalAssociationId": "1212143"
+"CoListOfficeNationalAssociationId": "1002993"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960542')"
+"ID": "1571912"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1571505"
+post_author: 1
+"ListingKey": "29961017"
+"ListingId": "40843479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:55:08Z"
+"RFModificationTimestamp": "2026-06-26T22:37:17Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.75
+"LivingArea": 3492.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW Road, Waterdown, Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.8823409
1 => 43.3299879
]
+"Latitude": 43.3299879
+"Longitude": -79.8823409
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Burlington's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:2 [
0 => "Window Coverings"
1 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:10.046221+00:00"
+"Directions": "WATERDOWN ROAD TO MOUNTAIN BROW ROAD"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"LotSizeDimensions": "0.75"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:50:06Z"
+"Stories": "1.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204661223"
+"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/29961017/344-mountain-brow-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 256.0
+"AboveGradeFinishedArea": 3492
+"OriginalEntryTimestamp": "2026-06-26T21:50:06.2Z"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961017')"
+"ID": "1571505"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+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"
}
]
+success: true
+page_size: 9
+page_count: 26
+count: 233
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]