array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29913910 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1537737"
+post_author: 1
+"ListingKey": "29913910"
+"ListingId": "40840573"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:14Z"
+"RFModificationTimestamp": "2026-06-17T04:02:45Z"
+"ListPrice": 649990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1362.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "90 SKINNER Road Unit# 6, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8792313
1 => 43.3374704
]
+"Latitude": 43.3374704
+"Longitude": -79.8792313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to SOL Stacked Towns, a brand-new community in sought-after Waterdown. This thoughtfully designed 3-bedroom, 2.5-bathroom townhome offers 1,362 sq. ft. of modern living space featuring an open-concept layout, contemporary vinyl plank flooring throughout, stone kitchen countertops, and 1 garage parking space. Enjoy the convenience of low-maintenance living in a vibrant neighbourhood close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. An exceptional opportunity to own in one of Waterdown's newest communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "246"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T04:02:38.416681+00:00"
+"Directions": "Dundas St E. to Burke St. to Kenesky Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T02:31:47Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:31:47Z"
+"Stories": "3.0"
+"StreetName": "SKINNER"
+"StreetNumber": "90"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1660925544"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.08Z"
]
1 => array:11 [
"RoomKey" => "1660925545"
"RoomType" => "Bedroom"
"ListingId" => "40840573"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.09Z"
]
2 => array:11 [
"RoomKey" => "1660925546"
"RoomType" => "Bedroom"
"ListingId" => "40840573"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.09Z"
]
3 => array:11 [
"RoomKey" => "1660925547"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840573"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.1Z"
]
4 => array:11 [
"RoomKey" => "1660925548"
"RoomType" => "Full bathroom"
"ListingId" => "40840573"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.1Z"
]
5 => array:11 [
"RoomKey" => "1660925549"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840573"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.11Z"
]
6 => array:11 [
"RoomKey" => "1660925550"
"RoomType" => "Living room"
"ListingId" => "40840573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.11Z"
]
7 => array:11 [
"RoomKey" => "1660925551"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40840573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913910"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.12Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29913910/90-skinner-road-unit-6-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "RC-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1362
+"OriginalEntryTimestamp": "2026-06-17T02:31:46.89Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29913910_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913910/1f8852d4472a3df660b671967a7847d1.webp"
"MediaSize" => 69637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913910/thumbnail-1f8852d4472a3df660b671967a7847d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840573"
"ResourceRecordKey" => "29913910"
"ModificationTimestamp" => "2026-06-17T02:31:46.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29913910_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913910/9720864fbd15006410a0a9db6463bf59.webp"
"MediaSize" => 68990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913910/thumbnail-9720864fbd15006410a0a9db6463bf59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840573"
"ResourceRecordKey" => "29913910"
"ModificationTimestamp" => "2026-06-17T02:31:46.9Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913910')"
+"ID": "1537737"
}
]
+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 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24621
+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 2007461" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24618
+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 '29913910'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25038
+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 '29913910'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25054
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29913910' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8792313 43.3374704)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25107
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25101
+post_id: "1537794"
+post_author: 1
+"ListingKey": "29914078"
+"ListingId": "40840582"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T03:55:09Z"
+"RFModificationTimestamp": "2026-06-17T04:32:06Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 853.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 336, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8784192
1 => 43.3443494
]
+"Latitude": 43.3443494
+"Longitude": -79.8784192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 2 underground parking spaces! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station. Book your private showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"CreationDate": "2026-06-17T04:32:05.599995+00:00"
+"Directions": "Dundas St E to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T03:51:49Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T03:51:49Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4363"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1660961634"
"RoomType" => "Bedroom"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.53Z"
]
1 => array:11 [
"RoomKey" => "1660961635"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.53Z"
]
2 => array:11 [
"RoomKey" => "1660961636"
"RoomType" => "Den"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.53Z"
]
3 => array:11 [
"RoomKey" => "1660961637"
"RoomType" => "Kitchen"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.53Z"
]
4 => array:11 [
"RoomKey" => "1660961638"
"RoomType" => "Great room"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.54Z"
]
5 => array:11 [
"RoomKey" => "1660961639"
"RoomType" => "Bedroom"
"ListingId" => "40840582"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914078"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T03:50:02.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914078/10-mallard-trail-unit-336-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 853
+"OriginalEntryTimestamp": "2026-06-17T03:50:02.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914078_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/76c58ac280b9f9cd1bd107085d0e65e5.webp"
"MediaSize" => 94607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-76c58ac280b9f9cd1bd107085d0e65e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:40.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914078_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/10bc91001a278eb8cf7bd8e5a0bd35ac.webp"
"MediaSize" => 54877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-10bc91001a278eb8cf7bd8e5a0bd35ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.68Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914078_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/2b02f8e515a057f1630b5b8708d1753d.webp"
"MediaSize" => 45043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-2b02f8e515a057f1630b5b8708d1753d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.68Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914078_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/f09e497becde4201f63d24f1eafb5f34.webp"
"MediaSize" => 45649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-f09e497becde4201f63d24f1eafb5f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.68Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914078_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/ced26f1b4546c16d21fed8f10261bd24.webp"
"MediaSize" => 43960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-ced26f1b4546c16d21fed8f10261bd24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.69Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914078_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/4a1110dbe7b56ce1179d0b829552ee45.webp"
"MediaSize" => 45512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-4a1110dbe7b56ce1179d0b829552ee45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914078_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/86fb95eb1566fd888f4cf0f2692de06f.webp"
"MediaSize" => 46004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-86fb95eb1566fd888f4cf0f2692de06f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.68Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914078_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/f3751513fa43781fb1bea87ee24d8318.webp"
"MediaSize" => 40206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-f3751513fa43781fb1bea87ee24d8318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.69Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914078_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/e95f1db4a2db45417df3fdb30499a3fe.webp"
"MediaSize" => 33009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-e95f1db4a2db45417df3fdb30499a3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914078_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/a3a52dedfa69540774f0813513ddc7a1.webp"
"MediaSize" => 37032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-a3a52dedfa69540774f0813513ddc7a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:43.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914078_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/aaf62fea6c71c4b930a67a17d5e2e501.webp"
"MediaSize" => 40290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-aaf62fea6c71c4b930a67a17d5e2e501.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914078_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/e240b7306f2b952476aecb09b5f07f58.webp"
"MediaSize" => 29088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-e240b7306f2b952476aecb09b5f07f58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914078_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/6e800edde018296179290490adb9e611.webp"
"MediaSize" => 38987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-6e800edde018296179290490adb9e611.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914078_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/92abeac0eab413aed0c8c92026e5484a.webp"
"MediaSize" => 36395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-92abeac0eab413aed0c8c92026e5484a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914078_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/8f6b9e160d23421ec58909d9dbf85a37.webp"
"MediaSize" => 38173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-8f6b9e160d23421ec58909d9dbf85a37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914078_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/43d634b031b00da8d14da38f9356eff8.webp"
"MediaSize" => 41398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-43d634b031b00da8d14da38f9356eff8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914078_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/62bf3be97d1a07feeea233cad87563c6.webp"
"MediaSize" => 36698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-62bf3be97d1a07feeea233cad87563c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.91Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914078_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/be0a365033be9bb1db6df816ce21dd36.webp"
"MediaSize" => 36540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-be0a365033be9bb1db6df816ce21dd36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914078_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/7d2eb391b8d957b9e0b5e73fcc19835e.webp"
"MediaSize" => 37930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-7d2eb391b8d957b9e0b5e73fcc19835e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:49.35Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914078_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/edd1c4b929ce0859c267f205adc1f07c.webp"
"MediaSize" => 42000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-edd1c4b929ce0859c267f205adc1f07c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914078_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/2ef8bf8f28adebd5e893fc535db09c6c.webp"
"MediaSize" => 39006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-2ef8bf8f28adebd5e893fc535db09c6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:45.81Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914078_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/4265477303fe4078e2df04d40f80ce8b.webp"
"MediaSize" => 39314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-4265477303fe4078e2df04d40f80ce8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:49.34Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914078_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914078/b280b69470fbbd3a7da881dbb1f75eb1.webp"
"MediaSize" => 36402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914078/thumbnail-b280b69470fbbd3a7da881dbb1f75eb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840582"
"ResourceRecordKey" => "29914078"
"ModificationTimestamp" => "2026-06-17T03:51:49.41Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914078')"
+"ID": "1537794"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25103
+post_id: "1537738"
+post_author: 1
+"ListingKey": "29913869"
+"ListingId": "40840566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:14Z"
+"RFModificationTimestamp": "2026-06-17T02:46:40Z"
+"ListPrice": 689990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1362.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "173 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8801075
1 => 43.3378942
]
+"Latitude": 43.3378942
+"Longitude": -79.8801075
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to SOL Stacked Towns, a brand-new community in sought-after Waterdown. This thoughtfully designed 3-bedroom, 2.5-bathroom townhome offers 1,362 sq. ft. of modern living space featuring an open-concept layout, contemporary vinyl plank flooring throughout, stone kitchen countertops, 1 garage & 1 driveway space. Enjoy the convenience of low-maintenance living in a vibrant neighbourhood close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. An exceptional opportunity to own in one of Waterdown's newest communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "246"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T02:46:35.140507+00:00"
+"Directions": "Dundas St E. to Burke St. to Kenesky Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T02:12:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:31:47Z"
+"Stories": "3.0"
+"StreetName": "BURKE"
+"StreetNumber": "173"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1660925560"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840566"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.93Z"
]
1 => array:11 [
"RoomKey" => "1660925561"
"RoomType" => "Bedroom"
"ListingId" => "40840566"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.93Z"
]
2 => array:11 [
"RoomKey" => "1660925562"
"RoomType" => "Bedroom"
"ListingId" => "40840566"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.94Z"
]
3 => array:11 [
"RoomKey" => "1660925563"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840566"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.94Z"
]
4 => array:11 [
"RoomKey" => "1660925564"
"RoomType" => "Full bathroom"
"ListingId" => "40840566"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.94Z"
]
5 => array:11 [
"RoomKey" => "1660925565"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840566"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.95Z"
]
6 => array:11 [
"RoomKey" => "1660925566"
"RoomType" => "Living room"
"ListingId" => "40840566"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.95Z"
]
7 => array:11 [
"RoomKey" => "1660925567"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40840566"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913869"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:31:47.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29913869/173-burke-street-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "RC-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1362
+"OriginalEntryTimestamp": "2026-06-17T02:09:48.54Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29913869_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/43ff32a235155c85121d7891bdd0ddf5.webp"
"MediaSize" => 69637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-43ff32a235155c85121d7891bdd0ddf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29913869_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/dbbe3c3895dc04eca13c69b5f1a11f49.webp"
"MediaSize" => 73414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-dbbe3c3895dc04eca13c69b5f1a11f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29913869_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/e3592ef3767ca279c85dd380042f3af8.webp"
"MediaSize" => 82085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-e3592ef3767ca279c85dd380042f3af8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29913869_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/6674e8ddacd5d8eef756319757a1e460.webp"
"MediaSize" => 76055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-6674e8ddacd5d8eef756319757a1e460.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:18.38Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29913869_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/f3a42b5080aa9e50c2bf58bcf7f82742.webp"
"MediaSize" => 73673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-f3a42b5080aa9e50c2bf58bcf7f82742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:18.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29913869_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/cd03ef762cc11d622565788c6b95760f.webp"
"MediaSize" => 46840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-cd03ef762cc11d622565788c6b95760f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29913869_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/e84e3e6c927f3af496add2033f6ed886.webp"
"MediaSize" => 75329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-e84e3e6c927f3af496add2033f6ed886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29913869_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/fc58fb4da7671ccd1eba7a09cd9b4e73.webp"
"MediaSize" => 63738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-fc58fb4da7671ccd1eba7a09cd9b4e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:18.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29913869_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/c1362d6283278cd5fb209b5a3001fc34.webp"
"MediaSize" => 66968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-c1362d6283278cd5fb209b5a3001fc34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29913869_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/7b4dc89a3baea32f44d6827842e01e34.webp"
"MediaSize" => 54033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-7b4dc89a3baea32f44d6827842e01e34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29913869_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/b29ab19bf142de72f9e43cff28c09a12.webp"
"MediaSize" => 65506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-b29ab19bf142de72f9e43cff28c09a12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29913869_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/0db288b021beb3c3f472a06ea05f08b0.webp"
"MediaSize" => 58598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-0db288b021beb3c3f472a06ea05f08b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29913869_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/1df453cffa65ee86871a2006004e47b2.webp"
"MediaSize" => 52418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-1df453cffa65ee86871a2006004e47b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29913869_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/f591c24abbf128774dbb979fbc57544c.webp"
"MediaSize" => 49020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-f591c24abbf128774dbb979fbc57544c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:18.4Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29913869_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/ceeafd74d459d4e86a4e3209c6ce858e.webp"
"MediaSize" => 47969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-ceeafd74d459d4e86a4e3209c6ce858e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:21.18Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29913869_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/62732a23430464f95ddbcd59ddb8b48a.webp"
"MediaSize" => 75730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-62732a23430464f95ddbcd59ddb8b48a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29913869_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/1fba8728c8bcfad14dcf4c265dffc1b5.webp"
"MediaSize" => 66584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-1fba8728c8bcfad14dcf4c265dffc1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.22Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29913869_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/ca8b5544e4910b8c21cffee56a3a034f.webp"
"MediaSize" => 69087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-ca8b5544e4910b8c21cffee56a3a034f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29913869_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/0a549a8fa7e08d40a485cb6fa751eeae.webp"
"MediaSize" => 82420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-0a549a8fa7e08d40a485cb6fa751eeae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.69Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29913869_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/12a2f11e6fb49e0994353ef4d3898af6.webp"
"MediaSize" => 57210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-12a2f11e6fb49e0994353ef4d3898af6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.12Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29913869_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/cb0f213dc42073f6126d717f0282fb35.webp"
"MediaSize" => 46156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-cb0f213dc42073f6126d717f0282fb35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.58Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29913869_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/6b20842ac34be080b17d08f6523d6e13.webp"
"MediaSize" => 41105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-6b20842ac34be080b17d08f6523d6e13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.69Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29913869_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/8f1ddbdddb9a00416b161c17bd7d75ac.webp"
"MediaSize" => 62461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-8f1ddbdddb9a00416b161c17bd7d75ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:21.12Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29913869_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/2ce239fbe37f0c7a11c0ea2573216917.webp"
"MediaSize" => 57601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-2ce239fbe37f0c7a11c0ea2573216917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.58Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29913869_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/1e5ec2155e85ef5d7e9926ed85f6a975.webp"
"MediaSize" => 54729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-1e5ec2155e85ef5d7e9926ed85f6a975.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.17Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29913869_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/debdc4405dba61db7080f7dccb73b644.webp"
"MediaSize" => 39594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-debdc4405dba61db7080f7dccb73b644.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.22Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29913869_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/da4156a9f864c63c436240c0c1ff53fd.webp"
"MediaSize" => 49984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-da4156a9f864c63c436240c0c1ff53fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.69Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29913869_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/2e99470e3fc3268a0b329284c2e80d09.webp"
"MediaSize" => 55331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-2e99470e3fc3268a0b329284c2e80d09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.15Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29913869_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/16b5cc55d9412d2601b246e92565e6e7.webp"
"MediaSize" => 34171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-16b5cc55d9412d2601b246e92565e6e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.61Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29913869_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/1917569a4d5fcc3ada343b5ebb8f09a8.webp"
"MediaSize" => 50563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-1917569a4d5fcc3ada343b5ebb8f09a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.19Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29913869_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/ca39d6c4cba67ddbdc897dbd6d56c99b.webp"
"MediaSize" => 62647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-ca39d6c4cba67ddbdc897dbd6d56c99b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:19.8Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29913869_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/daac13381568525cd9a926c0043af531.webp"
"MediaSize" => 61678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-daac13381568525cd9a926c0043af531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.62Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29913869_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/69cc53a34d8e0cbfae4d74c56afac793.webp"
"MediaSize" => 43097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913869/thumbnail-69cc53a34d8e0cbfae4d74c56afac793.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840566"
"ResourceRecordKey" => "29913869"
"ModificationTimestamp" => "2026-06-17T02:12:20.62Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29913869_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913869/8dbdeaac6f36375829f213ba34d3427e.webp"
"MediaSize" => 37446
"MediaType" => "webp"
…8
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913869')"
+"ID": "1537738"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25100
+post_id: "1537265"
+post_author: 1
+"ListingKey": "29913010"
+"ListingId": "X13453332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:30:06Z"
+"RFModificationTimestamp": "2026-06-17T00:36:47Z"
+"ListPrice": 395000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "604 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8787922
1 => 43.343573
]
+"Latitude": 43.343573
+"Longitude": -79.8787922
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T00:36:45.583991+00:00"
+"Directions": "Cross Streets: Dundas St E/Mallard. ** Directions: Dundas."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036737"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:25:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:25:02Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2592.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/604_470_dundas_st_e_hamilton_on/"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29913010/604-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T22:25:02.55Z"
+"ListAgentNationalAssociationId": "1313206"
+"ListOfficeNationalAssociationId": "1300540"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913010')"
+"ID": "1537265"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25104
+post_id: "1535992"
+post_author: 1
+"ListingKey": "29911949"
+"ListingId": "40840369"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:00:08Z"
+"RFModificationTimestamp": "2026-06-16T20:34:46Z"
+"ListPrice": 395000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 515.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 604, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786396
1 => 43.3439185
]
+"Latitude": 43.3439185
+"Longitude": -79.8786396
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.125636+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1647189"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T19:53:05Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:53:05Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2592.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911949/470-dundas-street-e-unit-604-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1568615"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "103841"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 515
+"OriginalEntryTimestamp": "2026-06-16T19:50:58.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1283810"
+"ListOfficeNationalAssociationId": "1325050"
+"CoListAgentNationalAssociationId": "1150320"
+"CoListOfficeNationalAssociationId": "1165450"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911949')"
+"ID": "1535992"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25102
+post_id: "1534978"
+post_author: 1
+"ListingKey": "29910671"
+"ListingId": "X13451454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T00:05:09Z"
+"RFModificationTimestamp": "2026-06-17T00:07:00Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0K2H6"
+"UnparsedAddress": "100 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L0K2H6"
+"Coordinates": array:2 [
0 => -79.900192
1 => 43.331966
]
+"Latitude": 43.331966
+"Longitude": -79.900192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Tucked into an established, tree-lined pocket with rare walkability, 100 Chudleigh Street is a mature-lot Waterdown home with the main floor opened up and reimagined for how families actually live now. This beautifully updated 4-bedroom, 2.5-bath home has over 2,800 sq. ft of living space that perfectly blends the open, connected layout buyers love in newer builds with the privacy, greenery, and lot size of an established neighbourhood. The main floor feels bright, warm, and easy, with designer touches throughout, a cozy fireplace, new luxury vinyl flooring, and a large kitchen featuring quartz counters, quartz backsplash, refreshed cabinetry, and generous space to gather. Carpet-free living continues throughout, with four comfortable bedrooms upstairs and a finished lower level that creates a huge suite-style retreat for teens, guests, long-staying in-laws, movie nights, or play space - with room for the wine collection tucked in too. Outside, the backyard is lush and surprisingly private, surrounded by mature greenery with no rear residential neighbours. Steps to everyday amenities, schools, trails, the YMCA, library, restaurants, shopping, Dairy Queen, and the summer farmers market - this is Waterdown family living with space, style, privacy, and true walkability. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:56:25.167411+00:00"
+"Directions": "Cross Streets: Hamilton & Dundas. ** Directions: Hamilton, Weston on White Oak Dr., Left on Chudleigh."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038275"
+"ListOfficeKey": "280499"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "50 x 125 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-16T17:26:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T23:56:45Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "100"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6718"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29910671/100-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-16T17:26:56.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314465"
+"ListOfficeNationalAssociationId": "1314683"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910671')"
+"ID": "1534978"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25097
+post_id: "1534315"
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"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/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": "1534315"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1534027"
+post_author: 1
+"ListingKey": "29908612"
+"ListingId": "40840175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:11:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street Unit# 709, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792813
1 => 43.3435237
]
+"Latitude": 43.3435237
+"Longitude": -79.8792813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to elevated condo living in the heart of East Waterdown! This beautifully upgraded 1-bedroom + oversized den condo offers modern style, functional space, and thoughtful design throughout. Currently used as an additional sleeping area, the spacious den offers exceptional flexibility and could easily function as a guest room, home office, nursery, fitness space, or multi-purpose retreat to suit your lifestyle. The open-concept layout is ideal for both everyday living and entertaining, highlighted by a stunning upgraded kitchen featuring a sleek granite waterfall peninsula, extended cabinetry for added storage, upgraded stainless steel appliances, and a contemporary single-basin sink. Premium upgraded flooring flows seamlessly throughout, complemented by smooth ceilings that create a clean, refined finish. Adding to the value and convenience, geothermal heating is included in the condo fees, offering efficient year-round comfort and reduced monthly utility costs. This well-appointed building also offers exceptional amenities including a stylish party room complete with a pool table, fireplace, comfortable seating area, and full kitchen, along with an exercise room, bicycle storage room, storage locker, underground parking space, and an outdoor terrace featuring seating areas and BBQs—perfect for entertaining and enjoying the community atmosphere. Ideally located in desirable East Waterdown, enjoy quick access to major highways while being close to parks, shopping, dining, and the natural beauty of the nearby Niagara Escarpment and surrounding trails—offering the perfect blend of urban convenience and outdoor living. Move in and enjoy stylish, low-maintenance living in one of Waterdown’s most sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:29.675759+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021739"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:17Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3007.36"
+"VirtualTourURLUnbranded": "https://youtu.be/U-fSD3T-vSs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908612/460-e-dundas-street-unit-709-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-16T12:50:17.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1301652"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908612')"
+"ID": "1534027"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25105
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:15:22Z"
+"ListPrice": 454900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:51:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25106
+post_id: "1531843"
+post_author: 1
+"ListingKey": "29905680"
+"ListingId": "X13446596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS CRESCENT, Hamilton (Waterdown), Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.892899
1 => 43.326881
]
+"Latitude": 43.326881
+"Longitude": -79.892899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on one of Waterdown's most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well-proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard and private, tranquil green space. Enjoy summer evenings on the expansive composite deck, gather with friends friend and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town's most sought-after areas. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:35.932384+00:00"
+"Directions": "Cross Streets: Howard Blvd. ** Directions: South of Dundas St E on Howard Blvd, turn ontoMays Cres."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101938"
+"ListOfficeKey": "288807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "72.2 x 196.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:52Z"
+"Stories": "2.0"
+"StreetName": "Mays"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9061.67"
+"VirtualTourURLUnbranded": "https://listings.webbify.ca/5-Mays-Crescent-Hamilton-ON-L8B-0G4-Canada"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905680/5-mays-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 72.2
+"OriginalEntryTimestamp": "2026-06-15T18:56:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371767"
+"ListOfficeNationalAssociationId": "1371723"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 185
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]