array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30040031 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1630083"
+post_author: 1
+"ListingKey": "30040031"
+"ListingId": "X13569656"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T02:15:08Z"
+"RFModificationTimestamp": "2026-07-16T04:48:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "155 TRUEDELL CIRCLE, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.9067199
1 => 43.3375649
]
+"Latitude": 43.3375649
+"Longitude": -79.9067199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "STUNNING 3-BED, 4-BATH SEMI-DETACHED WITH WALKOUT BASEMENT - MOVE-IN READY! Welcome to modern luxury living! This beautifully updated semi-detached home offers 3 spacious bedrooms, 4 bathrooms, and a FULLY FINISHED WALKOUT BASEMENT-perfect for extra living space, a home office, or guest suite. Attractive curb appeal with select plantings and stamped concrete walkway and covered porch. Step inside to the spacious foyer with a large, double door hall closet. The open-concept main level offers 9-foot ceilings, pot lights, and refinished hardwood floors. The gourmet kitchen is a chef's dream, featuring stainless steel appliances, sleek quartz countertops, and a breakfast bar for casual dining. The adjoining dining area boasts built-in seating with storage cabinets-ideal for family meals or entertaining.Walk out from the dining area to a raised deck overlooking the backyard - your private oasis for morning coffee or evening relaxation. The upstairs level offers three large bedrooms. The primary suite is spacious with a walk in closet and upgraded ensuite bathroom with a double sink vanity, bathtub and large, separate shower stall. The fully-finished, walk-out basement level offers yet another full bathroom, and space that can be the 4th bedroom/guest suite, home office area, play room or a recreation/movie/games room - the choice is yours! Conveniently located with easy access to Aldershot GO Station and Highway 403, this home is minutes from top-rated schools, shopping, restaurants, scenic nature trails, and breathtaking waterfalls. Book your showing today and make this dream home yours! Don't Miss This One! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"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-07-16T04:48:16.980376+00:00"
+"Directions": "Cross Streets: Hamilton St N/Nisbet/Truedell. ** Directions: Hamilton St N >Nisbet >Truedell."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960251"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "22 x 115 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T02:09:30Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T02:09:29Z"
+"Stories": "2.0"
+"StreetName": "Truedell"
+"StreetNumber": "155"
+"StreetSuffix": "Circle"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1685559500"
"RoomType" => "Great room"
"ListingId" => "X13569656"
"RoomLevel" => "Main level"
"RoomWidth" => 4.04
"ListingKey" => "30040031"
"RoomLength" => 5.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.56Z"
]
1 => array:11 [
"RoomKey" => "1685559501"
"RoomType" => "Bathroom"
"ListingId" => "X13569656"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30040031"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.57Z"
]
2 => array:11 [
"RoomKey" => "1685559502"
"RoomType" => "Kitchen"
"ListingId" => "X13569656"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "30040031"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.57Z"
]
3 => array:11 [
"RoomKey" => "1685559503"
"RoomType" => "Dining room"
"ListingId" => "X13569656"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "30040031"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.57Z"
]
4 => array:11 [
"RoomKey" => "1685559504"
"RoomType" => "Laundry room"
"ListingId" => "X13569656"
"RoomLevel" => "Main level"
"RoomWidth" => 1.96
"ListingKey" => "30040031"
"RoomLength" => 2.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.58Z"
]
5 => array:11 [
"RoomKey" => "1685559505"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13569656"
"RoomLevel" => "Second level"
"RoomWidth" => 3.51
"ListingKey" => "30040031"
"RoomLength" => 6.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.58Z"
]
6 => array:11 [
"RoomKey" => "1685559506"
"RoomType" => "Bedroom 2"
"ListingId" => "X13569656"
"RoomLevel" => "Second level"
"RoomWidth" => 2.49
"ListingKey" => "30040031"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.59Z"
]
7 => array:11 [
"RoomKey" => "1685559507"
"RoomType" => "Bedroom 3"
"ListingId" => "X13569656"
"RoomLevel" => "Second level"
"RoomWidth" => 2.41
"ListingKey" => "30040031"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.59Z"
]
8 => array:11 [
"RoomKey" => "1685559508"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13569656"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30040031"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.59Z"
]
9 => array:11 [
"RoomKey" => "1685559509"
"RoomType" => "Partial bathroom"
"ListingId" => "X13569656"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30040031"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.6Z"
]
10 => array:11 [
"RoomKey" => "1685559510"
"RoomType" => "Bathroom"
"ListingId" => "X13569656"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "30040031"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T02:09:29.6Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30040031/155-truedell-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3350
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2026-07-16T02:09:29.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1250476"
+"ListOfficeNationalAssociationId": "1328651"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30040031_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/5c8dd9d0d4ff769aeb1b7def74c80c2a.webp"
"MediaSize" => 448780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-5c8dd9d0d4ff769aeb1b7def74c80c2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 155 Truedell Circle, Waterdown"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30040031_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/8a373b0b42a96025f1499ba4606dfbd6.webp"
"MediaSize" => 445753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-8a373b0b42a96025f1499ba4606dfbd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gorgeous, Upgraded Semi-Detached"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30040031_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/476d5a1f5d72dc96b26fe15e19464553.webp"
"MediaSize" => 534953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-476d5a1f5d72dc96b26fe15e19464553.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great Curb Appeal"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30040031_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/312aa31168fedb7cef1c45d29a0478c9.webp"
"MediaSize" => 399889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-312aa31168fedb7cef1c45d29a0478c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Park 3 cars"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30040031_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/fc55c7ab45ac6dcf375a6958507ec27f.webp"
"MediaSize" => 339244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-fc55c7ab45ac6dcf375a6958507ec27f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered Porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30040031_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/b05bd26174b6b0ecff6da9b8c025f6e4.webp"
"MediaSize" => 77026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-b05bd26174b6b0ecff6da9b8c025f6e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30040031_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/54eb659820ed64838ca6882b11af786f.webp"
"MediaSize" => 88450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-54eb659820ed64838ca6882b11af786f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30040031_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/dda51310e410d1472c212dd44c1cc462.webp"
"MediaSize" => 80551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-dda51310e410d1472c212dd44c1cc462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30040031_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/3c9dabb609b0b7d8c0b0eb1b0d45f2e8.webp"
"MediaSize" => 53773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-3c9dabb609b0b7d8c0b0eb1b0d45f2e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30040031_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/8a33547b5b13272a4682a1c859c1f57a.webp"
"MediaSize" => 83212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-8a33547b5b13272a4682a1c859c1f57a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upgraded Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30040031_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/afa12e309b907b82894194a8e32399c7.webp"
"MediaSize" => 77040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-afa12e309b907b82894194a8e32399c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upgraded Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30040031_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/b7410663cb08b5dc180023ad5baf8408.webp"
"MediaSize" => 77173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-b7410663cb08b5dc180023ad5baf8408.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upgraded Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30040031_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/0c8e2246d1fbf6d7009301f4f1bec524.webp"
"MediaSize" => 87535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-0c8e2246d1fbf6d7009301f4f1bec524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30040031_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/5146208f47c07713f4d79917228ec43b.webp"
"MediaSize" => 79927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-5146208f47c07713f4d79917228ec43b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30040031_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/cbfd3b3fff74410929654ef071ba86cf.webp"
"MediaSize" => 387937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-cbfd3b3fff74410929654ef071ba86cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "W/O to Raised Deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30040031_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/ad05066bd0404682234b05539d6fe63f.webp"
"MediaSize" => 138956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-ad05066bd0404682234b05539d6fe63f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30040031_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/64e0f7462c7b20efc1ecef7f3c360417.webp"
"MediaSize" => 139440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-64e0f7462c7b20efc1ecef7f3c360417.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30040031_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/18499aa439eaa9635ac4132a796d2545.webp"
"MediaSize" => 141082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-18499aa439eaa9635ac4132a796d2545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30040031_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/6d5d5f232347edd9caac91984148bceb.webp"
"MediaSize" => 72030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-6d5d5f232347edd9caac91984148bceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30040031_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/6250d7074bd06f9a7bcae869cacf0f06.webp"
"MediaSize" => 61920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-6250d7074bd06f9a7bcae869cacf0f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30040031_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/8082614cfec361e4eb4db5bfec801368.webp"
"MediaSize" => 78785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-8082614cfec361e4eb4db5bfec801368.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom with W/I closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30040031_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/222a672031a62b39a95d04ae89c2b47a.webp"
"MediaSize" => 66181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-222a672031a62b39a95d04ae89c2b47a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom with W/I closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30040031_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/476bc50357d4eb18526c377f2a20c3e3.webp"
"MediaSize" => 60037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-476bc50357d4eb18526c377f2a20c3e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite 5 pc bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30040031_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/c62a9ef9b3cf3ec4b38255c6d0cf4761.webp"
"MediaSize" => 66398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-c62a9ef9b3cf3ec4b38255c6d0cf4761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite 5 pc bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30040031_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/fde6ee55bc45baf23e93d3cd2415495c.webp"
"MediaSize" => 58060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-fde6ee55bc45baf23e93d3cd2415495c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30040031_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/56994b4c7b46fa40a127d201e04114d3.webp"
"MediaSize" => 136717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-56994b4c7b46fa40a127d201e04114d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30040031_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/380264c53b55db6d768f42309d83d017.webp"
"MediaSize" => 63511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-380264c53b55db6d768f42309d83d017.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom Full 4 pc"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30040031_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/32690bd3ec48b571f694f20593026607.webp"
"MediaSize" => 78582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-32690bd3ec48b571f694f20593026607.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement W/O to Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30040031_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/c2c71d94ac7604de39688186bd4531e9.webp"
"MediaSize" => 75500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-c2c71d94ac7604de39688186bd4531e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fully Finished Basement"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30040031_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/33c6305355f45f0e0b2bcf514fecc267.webp"
"MediaSize" => 60130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-33c6305355f45f0e0b2bcf514fecc267.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom Full 3 pc"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30040031_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/2173e6a13c060b9dea2ca78d09437b8a.webp"
"MediaSize" => 76258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-2173e6a13c060b9dea2ca78d09437b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fully Finished Basement"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30040031_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/0cf442a5b414765fc3895f3835629d48.webp"
"MediaSize" => 85552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-0cf442a5b414765fc3895f3835629d48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement W/O to Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30040031_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/71045a950673d612527b33bd8cedeee4.webp"
"MediaSize" => 380935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-71045a950673d612527b33bd8cedeee4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered Stamped Concrete Patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30040031_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/d56687e24618ce84785f32234a87f236.webp"
"MediaSize" => 439773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-d56687e24618ce84785f32234a87f236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30040031_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/ac0d53d8bb2f981226da9ed9d313e69d.webp"
"MediaSize" => 494152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-ac0d53d8bb2f981226da9ed9d313e69d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30040031_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040031/e6f341f0778bb4d2584f194e610e2795.webp"
"MediaSize" => 391069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040031/thumbnail-e6f341f0778bb4d2584f194e610e2795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered Stamped Concrete Patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13569656"
"ResourceRecordKey" => "30040031"
"ModificationTimestamp" => "2026-07-16T02:09:29.18Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040031')"
+"ID": "1630083"
}
]
+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=OfficeKey eq 283410" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24980
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24924
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD."
+"OfficeEmail": null
+"OfficePhone": "905-338-3737"
+"OfficeMlsId": "519012"
+"ModificationTimestamp": "2026-03-11T19:21:54Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283410"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "251 NORTH SERVICE RD #102"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "OAKVILLE"
+"OfficePostalCode": "L6M3E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1328651"
+"OriginalEntryTimestamp": "2018-04-27T00:19:00Z"
+"OfficeFax": "905-338-7351"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1059676"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283410')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1960251" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24934
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30040031'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+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 '30040031' AND OpenHouseDate ge '2026-07-15'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25392
+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 '30040031' 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.9067199 43.3375649)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1612309"
+post_author: 1
+"ListingKey": "30011803"
+"ListingId": "X13543826"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T21:15:03Z"
+"RFModificationTimestamp": "2026-07-11T21:16:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R3"
+"UnparsedAddress": "74 COLE STREET, Hamilton (Waterdown), Ontario L8B0R3"
+"Coordinates": array:2 [
0 => -79.907465
1 => 43.336608
]
+"Latitude": 43.336608
+"Longitude": -79.907465
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful freehold semi-detached home in the highly sought-after west end of Waterdown! This bright, open-concept home features dark hardwood flooring throughout the main level, stainless steel appliances, a stylish backsplash, crown moulding, and a walk-out to the deck-perfect for indoor-outdoor living. The hardwood staircase is accented with elegant wrought iron spindles, while large windows fill the home with an abundance of natural light. The spacious primary bedroom offers ensuite privilege, and the house has been freshly painted with new floors on the upstairs level. The finished basement includes a bedroom with its own ensuite bathroom, ideal for guests or extended family. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:43:51.688171+00:00"
+"Directions": "Cross Streets: Parkside Dr & Hamilton St. ** Directions: Parkside Dr to Cole st."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027012"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T02:09:26Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T21:08:34Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "74"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011803/74-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T16:41:10.09Z"
+"ListAgentNationalAssociationId": "1306463"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30011803_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/27724ed74d5f259053e3214b35a243da.webp"
"MediaSize" => 306281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-27724ed74d5f259053e3214b35a243da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30011803_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/74a7220fda57f02f05a2ac667bc4351b.webp"
"MediaSize" => 87133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-74a7220fda57f02f05a2ac667bc4351b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30011803_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/4c07f066bb54914884f9fc328ae8f91c.webp"
"MediaSize" => 92691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-4c07f066bb54914884f9fc328ae8f91c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30011803_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/ac41c2797bac98e0c43f0f3c403cd4b1.webp"
"MediaSize" => 162301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-ac41c2797bac98e0c43f0f3c403cd4b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30011803_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e1529e463e092aad3b11e00d8f6e14eb.webp"
"MediaSize" => 111689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e1529e463e092aad3b11e00d8f6e14eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30011803_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/20a10a41252dfd2c8de2b8056d5582e4.webp"
"MediaSize" => 127638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-20a10a41252dfd2c8de2b8056d5582e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30011803_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/15d7b8c88ce5f60f78af77c7cd8a66f1.webp"
"MediaSize" => 145036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-15d7b8c88ce5f60f78af77c7cd8a66f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30011803_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e384afacb869c7dbfed3cb50cbc96984.webp"
"MediaSize" => 153823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e384afacb869c7dbfed3cb50cbc96984.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30011803_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/dc48383441ad2d482241a101515d5498.webp"
"MediaSize" => 82628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-dc48383441ad2d482241a101515d5498.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30011803_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2e1d93e4f407b6b83b9be6f9823b4bdd.webp"
"MediaSize" => 75853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2e1d93e4f407b6b83b9be6f9823b4bdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30011803_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/12ceb6f62322151ffbe0dd3765d91d19.webp"
"MediaSize" => 141843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-12ceb6f62322151ffbe0dd3765d91d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30011803_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/f92514a25dda71436074fd8cb7524108.webp"
"MediaSize" => 129069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-f92514a25dda71436074fd8cb7524108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30011803_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2e17610ea152ba5f29b7ca65f4a65e04.webp"
"MediaSize" => 111012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2e17610ea152ba5f29b7ca65f4a65e04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30011803_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2692f015d1f85967331c9acef698a7b3.webp"
"MediaSize" => 133671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2692f015d1f85967331c9acef698a7b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30011803_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/112571d04af844562dcab07c14bf284b.webp"
"MediaSize" => 165313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-112571d04af844562dcab07c14bf284b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30011803_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/fd61552861a38c76186d740d3bb16a40.webp"
"MediaSize" => 110132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-fd61552861a38c76186d740d3bb16a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30011803_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/8ba4ba744154be29880b011bfb366687.webp"
"MediaSize" => 118202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-8ba4ba744154be29880b011bfb366687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30011803_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/8bbebca17d26ac3404be9030a2bef53e.webp"
"MediaSize" => 96556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-8bbebca17d26ac3404be9030a2bef53e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30011803_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/045aa58dd1d8c481b802f0fc9443a281.webp"
"MediaSize" => 126433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-045aa58dd1d8c481b802f0fc9443a281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30011803_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/37b1c4686abce829959f139b10b42283.webp"
"MediaSize" => 112047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-37b1c4686abce829959f139b10b42283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30011803_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/68fcf7a18972de1e2e58d2450e5e4d22.webp"
"MediaSize" => 96308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-68fcf7a18972de1e2e58d2450e5e4d22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30011803_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/dca1343bfd58b6c6c684beb13a01e33e.webp"
"MediaSize" => 111103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-dca1343bfd58b6c6c684beb13a01e33e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30011803_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e6872b795cb844331b2a6cd0a8ea1c3a.webp"
"MediaSize" => 106678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e6872b795cb844331b2a6cd0a8ea1c3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.47Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30011803_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/a57fdd640d9683e0b2998ec4c6752fa7.webp"
"MediaSize" => 103282
"MediaType" => "webp"
…8
]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011803')"
+"ID": "1612309"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1559429"
+post_author: 1
+"ListingKey": "29943943"
+"ListingId": "X13480968"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T21:00:17Z"
+"RFModificationTimestamp": "2026-06-23T22:22:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "76 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Townhome 2 Bed & 3 Bath In The Heart Of Waterdown!! Large Open Concept Living & Dining Rooms, Upgraded Kitchen With Stainless Steel Appliances!! New Paint Throughout the the house! Huge Roof Top Terrace(27 x 18 sq. ft). 2 Parking. Walking Distance To Downtown Waterdown, Minutes To Go Train, School, Restaurants, Shopping. Easy Access To Hwys 403 & 407. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:22:31.407514+00:00"
+"Directions": "First Street/ Dundas Street East"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947489"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T20:53:42Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:53:42Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"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/29943943/76-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1918183"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Management Inc."
+"CoListOfficeKey": "164016"
+"GeocodeManualYN": false
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-23T20:53:42.78Z"
+"ListAgentNationalAssociationId": "1243138"
+"ListOfficeNationalAssociationId": "1184644"
+"CoListAgentNationalAssociationId": "1225816"
+"CoListOfficeNationalAssociationId": "1184644"
+"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": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943943')"
+"ID": "1559429"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1550150"
+post_author: 1
+"ListingKey": "29931778"
+"ListingId": "X13469760"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:35Z"
+"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. Located in the heart of Waterdown's downtown core, you are steps from restaurants, cafés, grocery stores, schools, and transit - with quick access to Hwy 6, Hwy 403, the QEW, Burlington and Aldershot GO Station. 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-23T14:21:07Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:21:07Z"
+"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:18 [
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]
]
+"DaysOnMarket": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931778')"
+"ID": "1550150"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1542427"
+post_author: 1
+"ListingKey": "29919819"
+"ListingId": "40840666"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:45:18Z"
+"RFModificationTimestamp": "2026-06-18T03:48:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK Circle, Hamilton, Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.9185268
1 => 43.3322591
]
+"Latitude": 43.3322591
+"Longitude": -79.9185268
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you’ll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown’s charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown’s most desirable communities. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T03:48:13.994444+00:00"
+"Directions": "Parkside to Mosaic"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110665"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T00:40:03Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:40:03Z"
+"Stories": "3.0"
+"StreetName": "BORERS CREEK"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"SubdivisionName": "460 - Waterdown West"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29919819/141-borers-creek-circle-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "R6-38"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2200
+"OriginalEntryTimestamp": "2026-06-18T00:40:03.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1379232"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"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": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919819')"
+"ID": "1542427"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1542434"
+post_author: 1
+"ListingKey": "29919882"
+"ListingId": "X13459338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T01:35:11Z"
+"RFModificationTimestamp": "2026-06-18T01:49:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK CIRCLE, Hamilton (Waterdown), Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.918643
1 => 43.332392
]
+"Latitude": 43.332392
+"Longitude": -79.918643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you'll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown's charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T01:49:36.409059+00:00"
+"Directions": "Mosaic Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955536"
+"ListOfficeKey": "205316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:26:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T01:26:28Z"
+"Stories": "3.0"
+"StreetName": "Borers Creek"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919882/141-borers-creek-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"TotalActualRent": 3800
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T01:26:28.3Z"
+"ListAgentNationalAssociationId": "1247407"
+"ListOfficeNationalAssociationId": "1264489"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"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": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919882')"
+"ID": "1542434"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1541752"
+post_author: 1
+"ListingKey": "29919163"
+"ListingId": "X13458862"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:35:12Z"
+"RFModificationTimestamp": "2026-06-18T00:26:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafted custom bungalow, situated on animpressive 0.45-acre lot just minutes from downtown Waterdown. This home offers nearly 5,000sq. ft. of living space, featuring 5 bedrooms (3 on the main floor and 2 in the lower level)and 6 bathrooms (3 on the main floor and 3 in the lower level). Home can come furnished and available for a 1 year lease.As you approach the property, you'll be greeted by oversized trees and thoughtfully designed landscaping, complemented by ample parking and stone pillars with lights. The main entrance features custom doors and a covered front entry with iron railings, leading into a main floor that overlooks the sunken great room, which has French doors opening to the flagstone patio with an awning. The main floor also includes a private office, perfect for remote work, as well as a separate formal dining room. The open-concept kitchen and family room create an entertainer's delight, equipped with large glass sliders that lead to a bright sunroom. Thefamily room features a stunning wall of granite stone and a gas fireplace.The modern lower level is finished to perfection, featuring 2 spacious bedrooms, each with walk-in closets and personal 3-piece en-suites. The open-concept kitchen and family room flow seamlessly to a walkout patio, providing an excellent setting for relaxation. With a separate entrance and privacy. Step outside to your own backyard oasis, complete with a cozy fire pit area and multi-level patios made of flagstone and interlock, all enclosed by a fully fenced yard for your private enjoyment. The professionally landscaped exterior features natural rockery and mature gardens, enhancing the home's impressive curb appeal.Additional highlights:- Utilities & Cable/Internet not included in lease price- 2 kitchens and 2 laundry rooms- 2.5 car garage- A full-house generator- Tenant insurance required- AAA Tenants only. (id:62783)"
+"Appliances": array:9 [
0 => "Water purifier"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Range"
4 => "Oven - Built-In"
5 => "Water Treatment"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:10 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "Walk out"
5 => "Walk-up"
6 => "N/A"
7 => "N/A"
8 => "N/A"
9 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:26:39.515315+00:00"
+"Directions": "Dundas St. East & Riley"
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wheelchair access"
1 => "Carpet Free"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T22:26:20Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:26:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919163/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 6500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-17T22:26:19.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919163')"
+"ID": "1541752"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1521720"
+post_author: 1
+"ListingKey": "29891241"
+"ListingId": "X13433690"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:40:08Z"
+"RFModificationTimestamp": "2026-06-11T20:42:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "601 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.894191
1 => 43.330175
]
+"Latitude": 43.330175
+"Longitude": -79.894191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 601 at 30 Hamilton St S - a stunning 1 Bed + Den sixth-floor residence in the heart of Waterdown where thoughtful design meets an unbeatable location. This spacious 700 sq ft layout offers the perfect blend of comfort and versatility. Step out onto your private balcony and be greeted by sweeping views that remind you why you chose to call Waterdown home. Just seconds away, the building's Sky Deck takes it further - panoramic sight-lines stretching across the Niagara Escarpment, the Hamilton skyline, the iconic Skyway Bridge, and the shimmering expanse of Lake Ontario. Few residences anywhere in the region can match this vantage point. Convenience is built right into the neighbourhood. Everything you need is within walking distance - groceries, restaurants, pharmacies, banks, and gas stations are all just steps from your front door, making everyday errands effortless. And for those who commute, Aldershot GO Station is just a 5-minute drive away, putting Toronto and the entire GO network well within reach.This isn't just a unit to rent - it's a home you'll be proud to come back to every day. From the sixth-floor elevation that sets you above the noise to the community-focused charm of Waterdown's village streets below, Unit 601 offers a lifestyle as elevated as its views. Whether you're a professional seeking a seamless commute, a couple looking for a stylish and functional space, or anyone who simply refuses to settle for ordinary - this is the one. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:42:18.338679+00:00"
+"Directions": "Cross Streets: Hamilton St S @ Barton St. ** Directions: Hamilton St S to Barton Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068660"
+"ListOfficeKey": "85099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T20:33:06Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:33:06Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"View": "City view,Lake view,View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_601_30_hamilton_st_s_hamilton_on/"
+"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": "OnePoint"
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891241/601-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2375
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.65Z"
+"ListAgentNationalAssociationId": "1343730"
+"ListOfficeNationalAssociationId": "1187791"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 34
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891241')"
+"ID": "1521720"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1492866"
+post_author: 1
+"ListingKey": "29851063"
+"ListingId": "X13237920"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T21:05:11Z"
+"RFModificationTimestamp": "2026-06-04T21:31:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "UPPER LEVEL (ONLY) - 184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Turn-key custom-built bungalow main floor only, fully furnished. Situated on an impressive 0.45-acre lot just minutes from downtown Waterdown. This home offers 2350 sq. ft. Featuring 3 bedrooms and 3 bathrooms. Home comes furnished and available for a 1-year lease. Lower-level walkout is tenanted with separate entrance.As you approach the property, you'll be greeted by oversized trees and thoughtfully designed landscaping, complemented by ample parking and stone pillars with lights. The main entrance features custom doors and a covered front entry with iron railings, leading into a main floor that overlooks the sunken great room, which has French doors opening to the flagstone patio with an awning. The main floor also includes a private office, perfect for remote work, as well as a separate formal dining room. The open-concept kitchen and family room create an entertainer's delight, equipped with large glass sliders that lead to a bright sunroom. The family room features a stunning wall of granite stone fireplace with gas. Step outside to your own backyard oasis, flagstone and interlock, all enclosed by a fully fenced yard for your private enjoyment. The professionally landscaped exterior features natural rockery and mature gardens, enhancing the home's impressive curb appeal. Upper Garden Level only. Additional highlights:- Utilities & Cable/Internet/propety taxes/ garden matinance/ grass cutting- 1 car garage + 2 exterior spots- A full-house generator- Tenant insurance required- AAA Tenants only.+ 2025 Notice of Assessment. The tenant is in agreement that the home can be offered for sale and shown 60 days prior to the end of the lease term. (id:62783)"
+"Appliances": array:16 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Range"
7 => "Oven"
8 => "Dryer"
9 => "Microwave"
10 => "Freezer"
11 => "Oven - Built-In"
12 => "Water Treatment"
13 => "Garage door opener remote(s)"
14 => "Water Heater - Tankless"
15 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:10 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "Walk out"
5 => "Walk-up"
6 => "N/A"
7 => "N/A"
8 => "N/A"
9 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T04:43:05.623413+00:00"
+"Directions": "Cross Streets: Dundas St. East & Riley. ** Directions: Highway #6 East to 3rd TrafficLight."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Wheelchair access"
2 => "Carpet Free"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-04T20:56:46Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T20:56:46Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29851063/upper-level-only-184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-04T02:26:13.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"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": 42
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851063')"
+"ID": "1492866"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1468087"
+post_author: 1
+"ListingKey": "29816068"
+"ListingId": "40834238"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:56Z"
+"RFModificationTimestamp": "2026-06-02T16:35:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 948.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "22 MILL Street S Unit# 203, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8913622
1 => 43.3338403
]
+"Latitude": 43.3338403
+"Longitude": -79.8913622
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home in the heart of Waterdown! This spacious 1+ bedroom apartment, just under 1000 sq ft, offers a versatile layout with a living room, family room, and an additional room that can serve as a dining area, second bedroom, or a den/office. Conveniently located with public transportation right at your doorstep, you'll also enjoy easy access to nearby hiking and walking trails. Plus, downtown is just a short stroll away, making this the perfect blend of comfort and convenience. Great value at $2,290/month, includes heat & hydro. 1 parking spot available. 2nd parking spot is $75/month. Laundry is $40/month. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
]
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-28T04:02:54.529577+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-05-28T18:40:14Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:14:04Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "22"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"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/29816068/22-mill-street-s-unit-203-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1982606"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"TotalActualRent": 2290
+"ZoningDescription": "C5a"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 115.0
+"AboveGradeFinishedArea": 948
+"OriginalEntryTimestamp": "2026-05-28T03:39:05.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063775"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1267853"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 49
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816068')"
+"ID": "1468087"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]