array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29820475 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23412
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23414
+post_id: "1471590"
+post_author: 1
+"ListingKey": "29820475"
+"ListingId": "40834567"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:40:09Z"
+"RFModificationTimestamp": "2026-06-16T18:42:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 692.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 333, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8793671
1 => 43.3434238
]
+"Latitude": 43.3434238
+"Longitude": -79.8793671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Recently built 1 bedroom + Den condo comes with one underground parking spot, one storage locker and a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low!!! Enjoy the open concept kitchen and living room with stainless steel appliances, a breakfast bar and a walk-out to your private balcony. The primary bedroom is spacious and bright with a walk-in closet. The condo is complete with a 4 piece bathroom and in suite laundry. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T20:33:14.260454+00:00"
+"Directions": "Waterdown St - Dundas St"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-05-28T20:09:49Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:33:53Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1660653287"
"RoomType" => "Den"
"ListingId" => "40834567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29820475"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:33:53.14Z"
]
1 => array:11 [
"RoomKey" => "1660653288"
"RoomType" => "4pc Bathroom"
"ListingId" => "40834567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29820475"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:33:53.14Z"
]
2 => array:11 [
"RoomKey" => "1660653289"
"RoomType" => "Bedroom"
"ListingId" => "40834567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29820475"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:33:53.14Z"
]
3 => array:11 [
"RoomKey" => "1660653290"
"RoomType" => "Great room"
"ListingId" => "40834567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29820475"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:33:53.14Z"
]
4 => array:11 [
"RoomKey" => "1660653291"
"RoomType" => "Kitchen"
"ListingId" => "40834567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29820475"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:33:53.14Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29820475/460-dundas-street-e-unit-333-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 692
+"OriginalEntryTimestamp": "2026-05-28T20:09:49.03Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1379041"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29820475_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/4bc3ee60047b4eb5179e5bae07ebf7c9.webp"
"MediaSize" => 103470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-4bc3ee60047b4eb5179e5bae07ebf7c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29820475_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/0f4bfebe7f16cc042f3afdc8393526fe.webp"
"MediaSize" => 90746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-0f4bfebe7f16cc042f3afdc8393526fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29820475_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/5a1c02c209357fa8175cebad6118ff69.webp"
"MediaSize" => 41109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-5a1c02c209357fa8175cebad6118ff69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29820475_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/98803a311e71932713992e40ac4dc0d0.webp"
"MediaSize" => 42069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-98803a311e71932713992e40ac4dc0d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29820475_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/f5de0bc2ae3cc846c87b83605f59314f.webp"
"MediaSize" => 41307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-f5de0bc2ae3cc846c87b83605f59314f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29820475_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/9426d386fe163c26de670a55fa0765b4.webp"
"MediaSize" => 50795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-9426d386fe163c26de670a55fa0765b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29820475_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/df774594a35089e3f4763ea1d39ae098.webp"
"MediaSize" => 40574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-df774594a35089e3f4763ea1d39ae098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29820475_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/e3b2b16b19c6f30149b44d4d3ebc4597.webp"
"MediaSize" => 37898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-e3b2b16b19c6f30149b44d4d3ebc4597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29820475_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/720cc4f05a6bf7211c18b9d962d875bd.webp"
"MediaSize" => 45303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-720cc4f05a6bf7211c18b9d962d875bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29820475_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/d7d689de4f469661e13a6ef778755c9f.webp"
"MediaSize" => 42155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-d7d689de4f469661e13a6ef778755c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29820475_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/91327dcbd7285a625a75d84e414f9da2.webp"
"MediaSize" => 44899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-91327dcbd7285a625a75d84e414f9da2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29820475_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/2122b1db0f4e26e65b0fb5776372f12e.webp"
"MediaSize" => 116515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-2122b1db0f4e26e65b0fb5776372f12e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29820475_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/9258bf730708978be7d0cada936665dd.webp"
"MediaSize" => 46796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-9258bf730708978be7d0cada936665dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29820475_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/df1fbd0808a951e2f09a550fc56d0573.webp"
"MediaSize" => 26491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-df1fbd0808a951e2f09a550fc56d0573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29820475_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/c8ca6894176ad925d6abeb4702323300.webp"
"MediaSize" => 43050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-c8ca6894176ad925d6abeb4702323300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29820475_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/b3f4b74eff7fc92d86185d8936d179d3.webp"
"MediaSize" => 37631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-b3f4b74eff7fc92d86185d8936d179d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29820475_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/279aa77be4881358655f4a47d4a81bc6.webp"
"MediaSize" => 32537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-279aa77be4881358655f4a47d4a81bc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29820475_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/9c2d97a40699524b80d804c0e12b4fc1.webp"
"MediaSize" => 35869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-9c2d97a40699524b80d804c0e12b4fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29820475_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/ae8ade3f4b58dc045004b75c6a2c2247.webp"
"MediaSize" => 27627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-ae8ade3f4b58dc045004b75c6a2c2247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29820475_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/dfa72a56d3891eff0e6bb0df5bbaa124.webp"
"MediaSize" => 30102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-dfa72a56d3891eff0e6bb0df5bbaa124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29820475_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820475/1d0d2b7f957e5811948d7c3fd4933883.webp"
"MediaSize" => 25899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820475/thumbnail-1d0d2b7f957e5811948d7c3fd4933883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834567"
"ResourceRecordKey" => "29820475"
"ModificationTimestamp" => "2026-05-28T20:09:49.04Z"
]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820475')"
+"ID": "1471590"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 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 {#24874
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2007461" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24848
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29820475'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160
+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 '29820475'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25176
+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 '29820475' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-79.8793671 43.3434238)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: "1552104"
+post_author: 1
+"ListingKey": "29933268"
+"ListingId": "X13471118"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T17:30:03Z"
+"RFModificationTimestamp": "2026-06-20T18:51:14Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8Y1B5"
+"UnparsedAddress": "36 GRANITE RIDGE TRAIL, Hamilton (Waterdown), Ontario L8Y1B5"
+"Coordinates": array:2 [
0 => -79.877671
1 => 43.336869
]
+"Latitude": 43.336869
+"Longitude": -79.877671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic opportunity to rent a beautiful semi in Waterdown! Featuring 3 spacious bedrooms and 21/2 bathrooms 9 ft Ceiling height on both floors is the perfect place to call home! Boasting a generous and functional layout the main floor of this home features laminate floors and tiles, great room with fireplace, spacious kitchen with breakfast room and inside garage access. The upper level boasts master bedroom with walk in closet and ensuite 2 other good size bedroom, main bath and laundry room. painted in natural tone paint color. Conveniently located close to all major amenities, minutes to the highway 403 / go train. Commuters dream. tenant to pay all utilities including water heater rent and water bill. Pictures were taken when house was vacant. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T18:51:09.369937+00:00"
+"Directions": "Cross Streets: Dundas/Burke. ** Directions: Dundas to Burke to Kenesky to Granite Ridge."
+"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": "2032582"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T17:18:18Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T17:18:18Z"
+"Stories": "2.0"
+"StreetName": "Granite Ridge"
+"StreetNumber": "36"
+"StreetSuffix": "Trail"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1663984540"
"RoomType" => "Bathroom"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29933268"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
1 => array:11 [
"RoomKey" => "1663984541"
"RoomType" => "Great room"
"ListingId" => "X13471118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.56
"ListingKey" => "29933268"
"RoomLength" => 6.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
2 => array:11 [
"RoomKey" => "1663984542"
"RoomType" => "Kitchen"
"ListingId" => "X13471118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29933268"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
3 => array:11 [
"RoomKey" => "1663984543"
"RoomType" => "Eating area"
"ListingId" => "X13471118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29933268"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
4 => array:11 [
"RoomKey" => "1663984544"
"RoomType" => "Bathroom"
"ListingId" => "X13471118"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29933268"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
5 => array:11 [
"RoomKey" => "1663984545"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.45
"ListingKey" => "29933268"
"RoomLength" => 4.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
6 => array:11 [
"RoomKey" => "1663984546"
"RoomType" => "Bedroom 2"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29933268"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
7 => array:11 [
"RoomKey" => "1663984547"
"RoomType" => "Bedroom 3"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.15
"ListingKey" => "29933268"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
8 => array:11 [
"RoomKey" => "1663984548"
"RoomType" => "Laundry room"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29933268"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
9 => array:11 [
"RoomKey" => "1663984549"
"RoomType" => "Bathroom"
"ListingId" => "X13471118"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29933268"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T17:18:18.71Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29933268/36-granite-ridge-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3200
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-20T17:18:18.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1309804"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29933268_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/84fc773087f955e96f6cff1b361359e0.webp"
"MediaSize" => 115886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-84fc773087f955e96f6cff1b361359e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29933268_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/c5bc8a6e637357c6425e593eefdf88bc.webp"
"MediaSize" => 52356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-c5bc8a6e637357c6425e593eefdf88bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29933268_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/7d56a22047337a892f23670bc9fbd177.webp"
"MediaSize" => 37638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-7d56a22047337a892f23670bc9fbd177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29933268_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/0e2a50c9c91a130f4256cda68e0a9905.webp"
"MediaSize" => 35184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-0e2a50c9c91a130f4256cda68e0a9905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29933268_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/e4b79636e0850e05a750004c51c13d5d.webp"
"MediaSize" => 50921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-e4b79636e0850e05a750004c51c13d5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29933268_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/6c6d7e10a4f460f01c6001fc8e5779e7.webp"
"MediaSize" => 36886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-6c6d7e10a4f460f01c6001fc8e5779e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29933268_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/66deacfc9e18b36bd24f78d5cd6d8522.webp"
"MediaSize" => 34962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-66deacfc9e18b36bd24f78d5cd6d8522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29933268_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/4f9a5e0d64e5e191421ce3b383a3c623.webp"
"MediaSize" => 40667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-4f9a5e0d64e5e191421ce3b383a3c623.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29933268_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/00f1080d0d143d1000a2fb9ac7d68eb3.webp"
"MediaSize" => 35433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-00f1080d0d143d1000a2fb9ac7d68eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29933268_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/44c757255f6892057ba37605871fb729.webp"
"MediaSize" => 29808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-44c757255f6892057ba37605871fb729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29933268_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/f333780eb6025d9002f057b5138262e4.webp"
"MediaSize" => 19767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-f333780eb6025d9002f057b5138262e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29933268_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/9766ba495c647b63def18ed32143faa2.webp"
"MediaSize" => 36058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-9766ba495c647b63def18ed32143faa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29933268_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/af782ece815b72468dbcc44bd9be362a.webp"
"MediaSize" => 25396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-af782ece815b72468dbcc44bd9be362a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29933268_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/e564157fc69e684e09fcf4a7e5f9eadf.webp"
"MediaSize" => 27166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-e564157fc69e684e09fcf4a7e5f9eadf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29933268_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/20e097251ddba6a4c53e6b6ec43c4aa1.webp"
"MediaSize" => 26292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-20e097251ddba6a4c53e6b6ec43c4aa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29933268_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29933268/331df964786cbd1b2fada07543533f9e.webp"
"MediaSize" => 23260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29933268/thumbnail-331df964786cbd1b2fada07543533f9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13471118"
"ResourceRecordKey" => "29933268"
"ModificationTimestamp" => "2026-06-20T17:18:18.68Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29933268')"
+"ID": "1552104"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1551575"
+post_author: 1
+"ListingKey": "29932824"
+"ListingId": "40841416"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:20:33Z"
+"RFModificationTimestamp": "2026-06-20T20:24:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 501.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 314, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8787182
1 => 43.3439258
]
+"Latitude": 43.3439258
+"Longitude": -79.8787182
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This bright and move-in-ready 1-bedroom, 1-bathroom condo features hardwood flooring throughout, premium upgrades, a modern kitchen with beautiful countertops and stainless steel appliances, and an open-concept layout filled with natural light. Enjoy the convenience of in-suite laundry, one surface parking space, and one locker. Residents enjoy exceptional amenities including a rooftop terrace with BBQs , gym, and party room. Ideally located close to hiking and biking trails, Aldershot GO Station, and just a short drive to Ontario's renowned wineries, this stylish condo offers the perfect blend of comfort and convenience. This condo offers the perfect blend of urban convenience and outdoor lifestyle. Comfortable, contemporary, and beautifully maintained, this is one you won't want to miss! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:55:47.276434+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2229909"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-20T13:51:32Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:10:13Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1664128794"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841416"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932824"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T20:10:13.28Z"
]
1 => array:11 [
"RoomKey" => "1664128795"
"RoomType" => "Living room/Dining room"
"ListingId" => "40841416"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932824"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T20:10:13.29Z"
]
2 => array:11 [
"RoomKey" => "1664128796"
"RoomType" => "Bedroom"
"ListingId" => "40841416"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932824"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T20:10:13.29Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29932824/470-dundas-street-e-unit-314-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 501
+"OriginalEntryTimestamp": "2026-06-20T13:50:00.08Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1470988"
+"ListOfficeNationalAssociationId": "1114492"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932824_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/53623def8764c5f92082854e60e93707.webp"
"MediaSize" => 159585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-53623def8764c5f92082854e60e93707.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.13Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932824_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/c9dd34c8010cf072dd053cd8b4d66624.webp"
"MediaSize" => 122059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-c9dd34c8010cf072dd053cd8b4d66624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932824_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/0dc93d2acbda80e31d57ef2cc340714d.webp"
"MediaSize" => 153442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-0dc93d2acbda80e31d57ef2cc340714d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:27.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932824_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/3ff6947620f00c710e20ee9a4304bacd.webp"
"MediaSize" => 135012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-3ff6947620f00c710e20ee9a4304bacd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.16Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932824_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/4f7763b66a93de501631e5c74da69e49.webp"
"MediaSize" => 69394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-4f7763b66a93de501631e5c74da69e49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932824_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/740adaecf1a65514f6431ad4bbd2e6e8.webp"
"MediaSize" => 68138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-740adaecf1a65514f6431ad4bbd2e6e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:27.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932824_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/77f54e1f52e600242c64ec403ac63500.webp"
"MediaSize" => 52109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-77f54e1f52e600242c64ec403ac63500.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.16Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932824_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/0e21cb4160ddd41f8feb0507732c5064.webp"
"MediaSize" => 75149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-0e21cb4160ddd41f8feb0507732c5064.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932824_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/58713495aed80161d2d71be60308a404.webp"
"MediaSize" => 76453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-58713495aed80161d2d71be60308a404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932824_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/26bd5da1e564431281bd9b8e300af5f4.webp"
"MediaSize" => 59913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-26bd5da1e564431281bd9b8e300af5f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932824_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/8638e1621a63d08be927c0987c352e13.webp"
"MediaSize" => 68215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-8638e1621a63d08be927c0987c352e13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.12Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932824_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/9081a3ba99c65740574fc3a53a4f7a21.webp"
"MediaSize" => 57440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-9081a3ba99c65740574fc3a53a4f7a21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932824_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/8c9931b9c36f7bd3f55770956e21ceef.webp"
"MediaSize" => 58446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-8c9931b9c36f7bd3f55770956e21ceef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932824_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/8dd5f851c954fc934f074c5c34772d79.webp"
"MediaSize" => 59246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-8dd5f851c954fc934f074c5c34772d79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.12Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932824_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/49a20414e96fe8228076134147a9e647.webp"
"MediaSize" => 47058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-49a20414e96fe8228076134147a9e647.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:24.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932824_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/78217a555ddf3d300238e19f8a928771.webp"
"MediaSize" => 44975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-78217a555ddf3d300238e19f8a928771.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:31.97Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932824_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/784ad0df3f281fb500d4b9572021b301.webp"
"MediaSize" => 46100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-784ad0df3f281fb500d4b9572021b301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:31.97Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29932824_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/c55efb0e660610d68ac2b6db7e028abb.webp"
"MediaSize" => 94340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-c55efb0e660610d68ac2b6db7e028abb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:32.24Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29932824_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/2e344d1e1ab9b3b450e38e227808e5ac.webp"
"MediaSize" => 73553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-2e344d1e1ab9b3b450e38e227808e5ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.5Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29932824_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/5ac9d60a364bd27ed38f8e542c3a74b4.webp"
"MediaSize" => 57163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-5ac9d60a364bd27ed38f8e542c3a74b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29932824_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/b3f60e84078594f579c3ff69cd0f4654.webp"
"MediaSize" => 42640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-b3f60e84078594f579c3ff69cd0f4654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:31.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29932824_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/9ada0112bda6d94a276037e83ee01ea2.webp"
"MediaSize" => 25984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-9ada0112bda6d94a276037e83ee01ea2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:31.97Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29932824_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/8679695e732eb9a82a7d64f3ec7ed584.webp"
"MediaSize" => 47146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-8679695e732eb9a82a7d64f3ec7ed584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29932824_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/39614aa3bf987db95e2bb4f325df9888.webp"
"MediaSize" => 46438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-39614aa3bf987db95e2bb4f325df9888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.5Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29932824_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/910ca2c7a544714fc5116378220178fc.webp"
"MediaSize" => 100768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-910ca2c7a544714fc5116378220178fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.5Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29932824_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932824/cd8d4d4a16a62906060dba18ad4a1152.webp"
"MediaSize" => 106688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932824/thumbnail-cd8d4d4a16a62906060dba18ad4a1152.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841416"
"ResourceRecordKey" => "29932824"
"ModificationTimestamp" => "2026-06-20T13:51:30.51Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932824')"
+"ID": "1551575"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1551572"
+post_author: 1
+"ListingKey": "29932962"
+"ListingId": "40840956"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T15:10:14Z"
+"RFModificationTimestamp": "2026-06-20T16:45:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "20 RIDGESIDE Lane, Waterdown, Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.8744358
1 => 43.3429594
]
+"Latitude": 43.3429594
+"Longitude": -79.8744358
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Home to a modern 2 bedroom + loft, 2 Bathroom 3 Storey stacked townhouse. Recently upgraded featuring new paint, kitchen sink, countertop, quartz backsplash, hardwood floors on second floor and bedroom level. Close to shopping centers, highways, and schools. No smoking or pets permitted and AAA credit preferred. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:45:28.024081+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1936273"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T15:01:55Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T15:01:55Z"
+"Stories": "3.0"
+"StreetName": "RIDGESIDE"
+"StreetNumber": "20"
+"StreetSuffix": "Lane"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1663877787"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840956"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
1 => array:11 [
"RoomKey" => "1663877788"
"RoomType" => "Loft"
"ListingId" => "40840956"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
2 => array:11 [
"RoomKey" => "1663877789"
"RoomType" => "Bedroom"
"ListingId" => "40840956"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
3 => array:11 [
"RoomKey" => "1663877790"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840956"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
4 => array:11 [
"RoomKey" => "1663877791"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840956"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
5 => array:11 [
"RoomKey" => "1663877792"
"RoomType" => "Kitchen"
"ListingId" => "40840956"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
6 => array:11 [
"RoomKey" => "1663877793"
"RoomType" => "Great room"
"ListingId" => "40840956"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.62Z"
]
7 => array:11 [
"RoomKey" => "1663877794"
"RoomType" => "Dining room"
"ListingId" => "40840956"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.63Z"
]
8 => array:11 [
"RoomKey" => "1663877795"
"RoomType" => "Storage"
"ListingId" => "40840956"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.63Z"
]
9 => array:11 [
"RoomKey" => "1663877796"
"RoomType" => "Recreation room"
"ListingId" => "40840956"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932962"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T15:01:55.63Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29932962/20-ridgeside-lane-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1358
+"OriginalEntryTimestamp": "2026-06-20T15:01:55.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1235068"
+"ListOfficeNationalAssociationId": "1114492"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932962_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/b76841b3c3e4162dbafa5513b3db4acf.webp"
"MediaSize" => 129951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-b76841b3c3e4162dbafa5513b3db4acf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932962_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/a0f7227f0dd2a674bcf131bd125e7d9e.webp"
"MediaSize" => 69633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-a0f7227f0dd2a674bcf131bd125e7d9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932962_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/e0355cc519bc7940ec8199623810be7d.webp"
"MediaSize" => 38418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-e0355cc519bc7940ec8199623810be7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932962_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/2a4707631bd1793e7b1ba72339f356c8.webp"
"MediaSize" => 41880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-2a4707631bd1793e7b1ba72339f356c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932962_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/82409ecdb8b7d7b6730377f652299c80.webp"
"MediaSize" => 38102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-82409ecdb8b7d7b6730377f652299c80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932962_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932962/f80e0a1696578a9842d6253c7fab5f7d.webp"
"MediaSize" => 39028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932962/thumbnail-f80e0a1696578a9842d6253c7fab5f7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840956"
"ResourceRecordKey" => "29932962"
"ModificationTimestamp" => "2026-06-20T15:01:55.55Z"
]
6 => array:13 [
"Order" => 7
…12
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932962')"
+"ID": "1551572"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1550150"
+post_author: 1
+"ListingKey": "29931778"
+"ListingId": "X13469760"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T23:40:22Z"
+"RFModificationTimestamp": "2026-06-19T23:44:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "501 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.8964742
1 => 43.3310512
]
+"Latitude": 43.3310512
+"Longitude": -79.8964742
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Are You Looking for a spacious 2-bedroom, 2 Bathroom Suite with designer finishes and a functional layout? This 1,025 SF suite has been completely transformed with over $47,000 in luxurious upgrades - and it shows the moment you walk through the door. Enjoy the bright open-concept layout with a large Chef's Kitchen with custom cabinetry, stone countertops, a large centre island with seating, an Induction Cooktop, Premium Appliances, upgraded lighting, and tiles that were selected with care. The living area flows to your private balcony through a sliding door, with motorized roller shades that let you control light and privacy at the touch of a button. North exposure means open, unobstructed views to enjoy your private 72 SF Balcony. Both bedrooms are generously sized, with the primary retreat complete with a large walk-in closet fitted with custom built-ins and a private ensuite bath and double vanity. The second bedroom is genuinely usable as a guest room, home office or gym, served by the main four-piece bathroom. Custom California Closet organizers throughout, with modern, low-maintenance vinyl plank flooring in the main living areas and bedrooms. Everything is move-in ready. In-suite laundry, one underground parking space, and one locker included. Available Starting September 1st! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Microwave"
6 => "Cooktop"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T23:43:55.261845+00:00"
+"Directions": "Cross Streets: Dundas St/ Hamilton St. N. ** Directions: North of Dundas St, West side of Hamilton St. N."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1616151"
+"ListOfficeKey": "51182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-19T22:48:21Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T23:18:37Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/DWvqeTDAehg"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931778/501-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild 905.575.3636"
+"GeocodeManualYN": true
+"TotalActualRent": 2900
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T22:48:21.23Z"
+"ListAgentNationalAssociationId": "1159607"
+"ListOfficeNationalAssociationId": "1003183"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931778')"
+"ID": "1550150"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+post_id: "1548944"
+post_author: 1
+"ListingKey": "29930131"
+"ListingId": "X13468170"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:10:09Z"
+"RFModificationTimestamp": "2026-06-19T20:28:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "407 - 470 DUNDAS STREET S, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "TWO PARKING SPACES! Make this stylish new condo your home. 2 Bedroom 1 Bathroom. 737 Square feet. Modern finishes. Plenty of amenities with a gym, party room, media room walking trails and more. This condo is located in the heart of Waterdown just a 5 min drive the Aldershot Go station. Available to be moved into Immediately. Available August 15th 2026. (id:62783)"
+"AssociationFee": "1"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:28:19.677107+00:00"
+"Directions": "Cross Streets: Mallard Tri & Dundas. ** Directions: Turn onto Riverwalk. Lots of guest parking."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145642"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-19T18:57:17Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T18:57:17Z"
+"StreetDirSuffix": "South"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"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/29930131/407-470-dundas-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2750
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T18:57:17.27Z"
+"ListAgentNationalAssociationId": "1397064"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930131')"
+"ID": "1548944"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1548975"
+post_author: 1
+"ListingKey": "29929506"
+"ListingId": "40840194"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:10:06Z"
+"RFModificationTimestamp": "2026-06-19T20:14:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 737.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 407, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786066
1 => 43.3439068
]
+"Latitude": 43.3439068
+"Longitude": -79.8786066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "TWO PARKING SPACES! Make this stylish new condo your home. 2 Bedrooms 1 Bathroom. 737 square feet. Modern finishes. Plenty of amenities with a gym, party room, media room, walking trails and more. This condo is located in the heart of Waterdown just a 5 minute drive from the Aldershot GO station. Available to be moved into immediately. Available August 15, 2026 (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:13:53.372420+00:00"
+"Directions": "Turn on riverwak"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074429"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T17:52:45Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:52:45Z"
+"Stories": "4.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"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/29929506/470-dundas-street-e-unit-407-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 737
+"OriginalEntryTimestamp": "2026-06-19T17:52:45.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1349609"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929506')"
+"ID": "1548975"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23425
+post_id: "1545508"
+post_author: 1
+"ListingKey": "29925516"
+"ListingId": "X13464294"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:47:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 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": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 1 underground parking space! 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. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-18T22:47:17.903956+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:15Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:15Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925516/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T21:59:15.14Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925516')"
+"ID": "1545508"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1542420"
+post_author: 1
+"ListingKey": "29920334"
+"ListingId": "X13459650"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T05:25:16Z"
+"RFModificationTimestamp": "2026-06-18T07:32:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "114 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautifully appointed ground-floor condo offers style, comfort, and convenience in one of Waterdown's most sought-after communities.Ideally located within walking distance to shopping, restaurants, parks, and everyday amenities, this home also offers easy access to major highways and public transit, making commuting a breeze.Step inside to discover a bright open-concept layout featuring elegant flooring throughout. The modern kitchen is designed to impress with quartz countertops, stainless steel appliances, an undermount sink, and a peninsula with breakfast bar seating, perfect for casual dining, entertaining, or your morning coffee.The sun-filled living area opens onto a private balcony, providing the perfect space to relax and enjoy the outdoors. The spacious bedroom features floor-to-ceiling windows and a peaceful atmosphere, while the stylish 4-piece bathroom showcases contemporary finishes. In-suite laundry, one owned parking space, and a storage locker add to the everyday convenience.Residents enjoy access to exceptional building amenities, including a fitness centre, party room, rooftop terrace and garden, community BBQ area, bicycle storage, and a welcoming lobby lounge.Just minutes from Burlington's vibrant waterfront, restaurants, and entertainment district, this move-in-ready condo offers an outstanding opportunity to enter the market and enjoy modern condo living in a prime location.Some photos have been virtually staged to illustrate the property's potential layout and use of space. Furnishings and decor shown in these images may not be present at the property. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T07:32:08.554747+00:00"
+"Directions": "Dundas/ Mallard/ Riverwalk"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011104"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T05:15:47Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T05:15:47Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"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/29920334/114-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T05:15:47.01Z"
+"ListAgentNationalAssociationId": "1292549"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920334')"
+"ID": "1542420"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1539053"
+post_author: 1
+"ListingKey": "29915901"
+"ListingId": "X13455876"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:35:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1102 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"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": "Welcome to the Trend Community in Waterdown, overlooking the welcoming greenery of North Burlington from the window of your Condo. This Brand New Stunning 2 Beds, 2 Baths 880 sqft unit boasts an abundance of natural light with windows throughout with the amazing views of lush green Waterdown and glimpses of Lake Ontario. Automated Neutrally Colored Blinds compliments windows of the Apartment all through allowing control of how much Natural light is allowed in. The Open concept Kitchen has rich upgraded white cabinets with beautiful quartz countertops and High-end upgraded Stainless steel appliances. The Spacious Primary Bedroom has its own 3 piece Ensuite with stunning glass shower, quartz cabinet top, upgraded ceramic tiles and upgraded under mount sink. Second room is very conveniently sized, Living room and second 4 piece bath are rich with upgraded tiles and Laminate floorings. Your convenience is assured with Ensuite Laundry that has upgraded extra load stacked Washer and Dryer, 1 underground parking spot and 1 spot storage Locker. The Amenities include Fitness Centre, Rooftop Patio, Bike storage, Party room. This amazing unit located in the Waterdown Neighborhood is surrounded by excellent dining options, shopping, schools and parks. Don't miss this great opportunity, it won't last long. This Condo is 5 minutes to reach the Aldershot Go station, 10 minutes to Downtown Burlington, 15 minutes to Downtown Hamilton and 20 minutes to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:35:18.173461+00:00"
+"Directions": "Dundas Street East and Mallard"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109403"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:54Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:54Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915901/1102-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-17T15:57:54.32Z"
+"ListAgentNationalAssociationId": "1378246"
+"ListOfficeNationalAssociationId": "1328652"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915901')"
+"ID": "1539053"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 52
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]