array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29797829 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+post_id: "1455305"
+post_author: 1
+"ListingKey": "29797829"
+"ListingId": "40833059"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:40:05Z"
+"RFModificationTimestamp": "2026-06-17T17:53:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1536.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7B5"
+"UnparsedAddress": "59 GRINDSTONE Way, Waterdown, Ontario L9H7B5"
+"Coordinates": array:2 [
0 => -79.9077618
1 => 43.3185864
]
+"Latitude": 43.3185864
+"Longitude": -79.9077618
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brick two-storey home situated in the desirable Waterdown West neighborhood. Updated open kitchen and sitting area,Fire place in the family room. three good sized bedrooms. The primary suite has private 4-piece ensuite. The finished lower level features a recreation room. Backyard features a wood deck. steps away from the Niagara Escarpment and the Bruce Trail, close to schools, local parks, and family-friendly restaurants. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-24T22:19:08.937876+00:00"
+"Directions": "Dundas to Howland Milles Drive to Grindstone Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-24T20:19:53Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:32:23Z"
+"Stories": "2.0"
+"StreetName": "GRINDSTONE"
+"StreetNumber": "59"
+"StreetSuffix": "Way"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1661316413"
"RoomType" => "1pc Bathroom"
"ListingId" => "40833059"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
1 => array:11 [
"RoomKey" => "1661316414"
"RoomType" => "Laundry room"
"ListingId" => "40833059"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
2 => array:11 [
"RoomKey" => "1661316415"
"RoomType" => "Office"
"ListingId" => "40833059"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
3 => array:11 [
"RoomKey" => "1661316416"
"RoomType" => "Recreation room"
"ListingId" => "40833059"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
4 => array:11 [
"RoomKey" => "1661316417"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833059"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
5 => array:11 [
"RoomKey" => "1661316418"
"RoomType" => "Bedroom"
"ListingId" => "40833059"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
6 => array:11 [
"RoomKey" => "1661316419"
"RoomType" => "Bedroom"
"ListingId" => "40833059"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.39Z"
]
7 => array:11 [
"RoomKey" => "1661316420"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833059"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.4Z"
]
8 => array:11 [
"RoomKey" => "1661316421"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833059"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.4Z"
]
9 => array:11 [
"RoomKey" => "1661316422"
"RoomType" => "2pc Bathroom"
"ListingId" => "40833059"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.4Z"
]
10 => array:11 [
"RoomKey" => "1661316423"
"RoomType" => "Kitchen"
"ListingId" => "40833059"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.4Z"
]
11 => array:11 [
"RoomKey" => "1661316424"
"RoomType" => "Living room/Dining room"
"ListingId" => "40833059"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29797829"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T17:32:23.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29797829/59-grindstone-way-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3300
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1536
+"OriginalEntryTimestamp": "2026-05-24T20:19:53.52Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1129428"
+"ListOfficeNationalAssociationId": "1426403"
+"Media": array:18 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29797829_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/e3b3cef6e031b18b3fc8320648bcec0e.webp"
"MediaSize" => 171864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-e3b3cef6e031b18b3fc8320648bcec0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick facade with light-colored siding accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29797829_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/553924b7eb3806a87094f3fd7cc1e62c.webp"
"MediaSize" => 103844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-553924b7eb3806a87094f3fd7cc1e62c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior space featuring a stone-faced fireplace with a white mantel, recessed firebox, and a built-in shelf unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29797829_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/b7dbc35da703801a1099046cbaf81040.webp"
"MediaSize" => 78125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-b7dbc35da703801a1099046cbaf81040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring white cabinetry with dark hardware, black appliances, dark countertops, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29797829_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/c8a78a01cf6bef9bb8c43ddd53918a21.webp"
"MediaSize" => 79287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-c8a78a01cf6bef9bb8c43ddd53918a21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, black countertops, a black refrigerator, a black range with a stainless steel vent hood, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29797829_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/c34d93b224726a9e2ff1e90676227485.webp"
"MediaSize" => 82359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-c34d93b224726a9e2ff1e90676227485.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring white cabinetry, dark countertops, tiled flooring, stainless steel appliances, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29797829_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/bcb9d2d145645be799f59e9a53c2fb21.webp"
"MediaSize" => 99819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-bcb9d2d145645be799f59e9a53c2fb21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and multiple windows with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29797829_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/c4567f9722cbb306e7bd5d1c475eb84d.webp"
"MediaSize" => 101077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-c4567f9722cbb306e7bd5d1c475eb84d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, neutral gray walls, a window with outdoor greenery, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29797829_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/920c6cfb7cb23f4fade54363e2a9fe4a.webp"
"MediaSize" => 105758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-920c6cfb7cb23f4fade54363e2a9fe4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a ceiling fan with integrated lighting, a window with curtains, and wall-to-wall carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29797829_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/fb807669167392b9a0d72e027fdb4fcb.webp"
"MediaSize" => 107126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-fb807669167392b9a0d72e027fdb4fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring neutral-toned carpeting and a sloped ceiling detail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29797829_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/7024f42e831af7223bf1fc0e21427d4f.webp"
"MediaSize" => 99621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-7024f42e831af7223bf1fc0e21427d4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a built-in sink, dark countertop, and decorative mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29797829_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/5cc1238f90722d3af611793271017976.webp"
"MediaSize" => 54408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-5cc1238f90722d3af611793271017976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29797829_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/0e34b72d538887ee5d6e75180d390b9b.webp"
"MediaSize" => 86643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-0e34b72d538887ee5d6e75180d390b9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a window with exterior brick exposure, a ceiling fan with integrated lighting, and painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29797829_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/b4a2ffd99fc17fd21d0d7de5b6db246b.webp"
"MediaSize" => 121919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-b4a2ffd99fc17fd21d0d7de5b6db246b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring carpeted flooring and three windows with white frames"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29797829_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/6f93511ece799db0549443751f31e15f.webp"
"MediaSize" => 95466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-6f93511ece799db0549443751f31e15f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vanity with an integrated white sink and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29797829_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/a33079b2a9d06975f6984748e225b591.webp"
"MediaSize" => 87645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-a33079b2a9d06975f6984748e225b591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement room featuring recessed lighting, a window, and light-toned carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29797829_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/7e315deba153a58b79cf110ad0e2b56e.webp"
"MediaSize" => 111773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-7e315deba153a58b79cf110ad0e2b56e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted interior space with a recessed lighting system"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29797829_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/6abdecd3cc6c4703ed0f197b93d81d67.webp"
"MediaSize" => 108303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-6abdecd3cc6c4703ed0f197b93d81d67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated utility area featuring a pair of front-loading laundry machines and a utility sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29797829_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29797829/d00827f5c7d9bf3147a67f6212a4c274.webp"
"MediaSize" => 180163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29797829/thumbnail-d00827f5c7d9bf3147a67f6212a4c274.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck featuring a slatted pergola structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833059"
"ResourceRecordKey" => "29797829"
"ModificationTimestamp" => "2026-05-24T20:19:53.53Z"
]
]
+"DaysOnMarket": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29797829')"
+"ID": "1455305"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293386" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24750
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24837
+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 '29797829'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25130
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29797829'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25146
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29797829' 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.9077618 43.3185864)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25199
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1546777"
+post_author: 1
+"ListingKey": "29926450"
+"ListingId": "X13465022"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:55:19Z"
+"RFModificationTimestamp": "2026-06-19T04:50:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K9"
+"UnparsedAddress": "33 STRATHROY CRESCENT, Hamilton (Waterdown), Ontario L8B0K9"
+"Coordinates": array:2 [
0 => -79.916092
1 => 43.327793
]
+"Latitude": 43.327793
+"Longitude": -79.916092
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 3 bedrooms exec. double garage detached house 2566 sq. ft. (converted from 4 bedroom plan) on a premium 131' deeppie-shaped lot that is 61' wide across back of the house! Main floor has a bright & airy high ceiling foyer. New upgraded staircase andnew wood flooring 2nd floor and landing areas (2026), upgraded wide-plank hardwood floors, formal liv. room with bay window,spacious dining room w/coffered ceiling & wainscotting, large family room w/rustic wood feature wall, gas fireplace w/porcelain tilesurround & sliding door walk-out to sun room with skylight & walk-outs to back yard. Completely renovated designer kitchenw/custom white cabinetry, quartz counters, high-end built-in S/S appliances, large island with breakfast bar, open to family room. Theprofessionally landscaped backyard oasis with covered interlock stone patio, BBQ area, lighting & inground heated saltwater poolw/newer liner (2019), new pool heater & pool pump (2025),great for time spend w/family & friends. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T04:50:20.832923+00:00"
+"Directions": "Parkside/Hollybush/Strathroy"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
3 => "Carpeted"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562528"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "41 x 131.2 FT ; Irregular"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T01:47:24Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T01:47:23Z"
+"Stories": "2.0"
+"StreetName": "Strathroy"
+"StreetNumber": "33"
+"StreetSuffix": "Crescent"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/33-strathroy-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1662654776"
"RoomType" => "Living room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29926450"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
1 => array:11 [
"RoomKey" => "1662654777"
"RoomType" => "Other"
"ListingId" => "X13465022"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
2 => array:11 [
"RoomKey" => "1662654778"
"RoomType" => "Sunroom"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
3 => array:11 [
"RoomKey" => "1662654779"
"RoomType" => "Dining room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 4.55
"ListingKey" => "29926450"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
4 => array:11 [
"RoomKey" => "1662654780"
"RoomType" => "Family room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 5.21
"ListingKey" => "29926450"
"RoomLength" => 6.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
5 => array:11 [
"RoomKey" => "1662654781"
"RoomType" => "Kitchen"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29926450"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
6 => array:11 [
"RoomKey" => "1662654782"
"RoomType" => "Laundry room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 1.85
"ListingKey" => "29926450"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
7 => array:11 [
"RoomKey" => "1662654783"
"RoomType" => "Foyer"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
8 => array:11 [
"RoomKey" => "1662654784"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 5.18
"ListingKey" => "29926450"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
9 => array:11 [
"RoomKey" => "1662654785"
"RoomType" => "Bedroom 2"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29926450"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
10 => array:11 [
"RoomKey" => "1662654786"
"RoomType" => "Bedroom 3"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29926450"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
11 => array:11 [
"RoomKey" => "1662654787"
"RoomType" => "Cold room"
"ListingId" => "X13465022"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926450/33-strathroy-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4300
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-06-19T01:47:23.93Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1138252"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29926450_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/43ee55fd0fcd39ba161f178a44bd1450.webp"
"MediaSize" => 83230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-43ee55fd0fcd39ba161f178a44bd1450.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29926450_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/5b422953de77be56f8e020b2fd5c1936.webp"
"MediaSize" => 101566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-5b422953de77be56f8e020b2fd5c1936.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29926450_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/13475a0dd02dbc264fbef3bb8d9b64fe.webp"
"MediaSize" => 123880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-13475a0dd02dbc264fbef3bb8d9b64fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29926450_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/fe43da8eed85fee457d3c6dfbd8007b0.webp"
"MediaSize" => 45347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-fe43da8eed85fee457d3c6dfbd8007b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29926450_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/dfa969d9d36bc0c61443cfc3d5c086ca.webp"
"MediaSize" => 62009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-dfa969d9d36bc0c61443cfc3d5c086ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29926450_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/6a459f166582fcf19edc5e716bdd4a67.webp"
"MediaSize" => 57638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-6a459f166582fcf19edc5e716bdd4a67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29926450_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/752fe4f557d8c67d51ceb7856b46df6d.webp"
"MediaSize" => 53729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-752fe4f557d8c67d51ceb7856b46df6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29926450_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/efeb540030590908cbd5ad292750aaed.webp"
"MediaSize" => 64508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-efeb540030590908cbd5ad292750aaed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29926450_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/09c74cc558c2fa337ac95a69bd8a4dda.webp"
"MediaSize" => 59554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-09c74cc558c2fa337ac95a69bd8a4dda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29926450_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/cf1b6f3bd1ea71d5687b32806ca785a7.webp"
"MediaSize" => 64677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-cf1b6f3bd1ea71d5687b32806ca785a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29926450_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/210b51d089e55833e1b05d8db0910d5c.webp"
"MediaSize" => 63802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-210b51d089e55833e1b05d8db0910d5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29926450_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/57698bbd7ae5f812b61ee0d1d02a45c9.webp"
"MediaSize" => 64951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-57698bbd7ae5f812b61ee0d1d02a45c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29926450_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/dcc164974c8272f89db9ef3573d1567e.webp"
"MediaSize" => 59030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-dcc164974c8272f89db9ef3573d1567e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29926450_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/70b95afaff246ce9b8136037ef2b87d5.webp"
"MediaSize" => 54499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-70b95afaff246ce9b8136037ef2b87d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29926450_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/8146a0557904aec06f64052609045604.webp"
"MediaSize" => 60637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-8146a0557904aec06f64052609045604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29926450_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/296917fae425120b76483a01b6dba319.webp"
"MediaSize" => 54880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-296917fae425120b76483a01b6dba319.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29926450_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/274cd977b64467d105597a88f0a493bd.webp"
"MediaSize" => 58319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-274cd977b64467d105597a88f0a493bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29926450_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/8af03ffd5992d49473413de0f35310ad.webp"
"MediaSize" => 54658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-8af03ffd5992d49473413de0f35310ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29926450_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/4217e6ec3eb05e678fd3e54f77702b75.webp"
"MediaSize" => 55991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-4217e6ec3eb05e678fd3e54f77702b75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29926450_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/bc72154de4ee43c416cf087daeb75a95.webp"
"MediaSize" => 53161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-bc72154de4ee43c416cf087daeb75a95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29926450_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/e3a29561e8761ab6b82a200d5f27fd75.webp"
"MediaSize" => 54859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-e3a29561e8761ab6b82a200d5f27fd75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29926450_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/bf3324b5c087965bb425b84dec77ac7d.webp"
"MediaSize" => 49726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-bf3324b5c087965bb425b84dec77ac7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29926450_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/07464e1a12d4945dd6ba25cb45eae3eb.webp"
"MediaSize" => 48863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-07464e1a12d4945dd6ba25cb45eae3eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29926450_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/fb8ab672e3e78566b6bdcac5d16269e9.webp"
…10
]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926450')"
+"ID": "1546777"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919819')"
+"ID": "1542427"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919882')"
+"ID": "1542434"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25196
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919163')"
+"ID": "1541752"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891241')"
+"ID": "1521720"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+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": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851063')"
+"ID": "1492866"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1490988"
+post_author: 1
+"ListingKey": "29845806"
+"ListingId": "W13232756"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T19:00:29Z"
+"RFModificationTimestamp": "2026-06-03T19:06:14Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Grindstone)"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "597 OLD YORK ROAD, Burlington (Grindstone), Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.896058
1 => 43.309163
]
+"Latitude": 43.309163
+"Longitude": -79.896058
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "AMAZING! Custom Bungaloft nestled on a spectacular 12-acre property in Burlington. Featuring 5+1 bedrooms, 6 full bathrooms and 2 half baths with an attached triple car garage AND detached double car garage with storage loft! Boasting over 5,400 square feet PLUS an additional 4,300 square feet in the finished lower level. Resort-style exterior with a pool, hot tub, pond, cabana, outdoor kitchen, full bar, built in BBQ area, golf green, two firepits, a fireplace and 5+ forested acres! The main floor offers DUAL primary bedrooms- each with ensuite baths and large walk-in closets. There is also a main floor office and oversized dining room. The kitchen features a large island, stainless steel appliances and a walk-in pantry. The kitchen is open to the living room- which features 12' ceilings and a stunning wood burning fireplace. There is also an oversized mudroom / laundry room with garage access and two powder rooms. The 2nd level of the home includes 3 large bedrooms and a 5-piece bathroom. The lower level (accessible by stairs OR elevator) features an amazing rec/family room, 6th bedroom, second kitchen, 2 full bathrooms, a wine cellar, gym, sauna, wet bar and plenty of storage! This home was custom built by Glen Oak Homes in 2016 and a main floor addition with full basement was added in 2024. The entire property was fully landscaped in 2023/2024. Interior and exterior 'smart' features throughout, highly efficient and fully private- a true paradise. Luxury Certified (id:62783)"
+"Appliances": array:6 [
0 => "Water purifier"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Barbeque"
4 => "Oven - Built-In"
5 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T15:28:32.905185+00:00"
+"Directions": "York Rd & Old York Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994690"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "In suite Laundry"
3 => "Gazebo"
4 => "In-Law Suite"
5 => "Sauna"
]
+"LotSizeDimensions": "319.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T14:57:23Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T18:52:33Z"
+"Stories": "1.5"
+"StreetName": "Old York"
+"StreetNumber": "597"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://vimeo.com/1114044764"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:27 [
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]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Grindstone"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29845806/597-old-york-road-burlington-grindstone-grindstone"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 15000
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 100000
+"LivingAreaMinimum": 5000
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 319.1
+"OriginalEntryTimestamp": "2026-06-03T14:57:23.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1277672"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29845806')"
+"ID": "1490988"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25197
+post_id: "1488402"
+post_author: 1
+"ListingKey": "29845095"
+"ListingId": "40834769"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T14:05:32Z"
+"RFModificationTimestamp": "2026-06-03T14:09:00Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 9764.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "597 OLD YORK Road, Burlington, Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.8967514
1 => 43.3098462
]
+"Latitude": 43.3098462
+"Longitude": -79.8967514
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AMAZING! Custom Bungaloft nestled on a spectacular 12-acre property in Burlington. Featuring 5+1 bedrooms, 6 full bathrooms and 2 half baths with an attached triple car garage AND detached double car garage with storage loft! Boasting over 5,400 square feet PLUS an additional 4,300 square feet in the finished lower level. Resort-style exterior with a pool, hot tub, pond, cabana, outdoor kitchen, full bar, built in BBQ area, golf green, two firepits, a fireplace and 5+ forested acres! The main floor offers DUAL primary bedrooms- each with ensuite baths and large walk-in closets. There is also a main floor office and oversized dining room. The kitchen features a large island, stainless steel appliances and a walk-in pantry. The kitchen is open to the living room- which features 12’ ceilings and a stunning wood burning fireplace. There is also an oversized mudroom / laundry room with garage access and two powder rooms. The 2nd level of the home includes 3 large bedrooms and a 5-piece bathroom. The lower level (accessible by stairs OR elevator) features an amazing rec/family room, 6th bedroom, second kitchen, 2 full bathrooms, a wine cellar, gym, sauna, wet bar and plenty of storage! This home was custom built by Glen Oak Homes in 2016 and a main floor addition with full basement was added in 2024. The entire property was fully landscaped in 2023/2024. Interior and exterior ‘smart’ features throughout, highly efficient and fully private- a true paradise. Luxury Certified (id:62650)"
+"Appliances": array:6 [
0 => "Water purifier"
1 => "Water softener"
2 => "Sauna"
3 => "Central Vacuum"
4 => "Oven - Built-In"
5 => "Wet Bar"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeIncludes": array:1 [
0 => "Exterior Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T13:53:20.776195+00:00"
+"Directions": "York Rd to Old York Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875327"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Wet bar"
3 => "Paved driveway"
4 => "Gazebo"
5 => "Automatic Garage Door Opener"
6 => "In-Law Suite"
]
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T13:23:13Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T13:59:52Z"
+"Stories": "1.5"
+"StreetName": "OLD YORK"
+"StreetNumber": "597"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"VirtualTourURLUnbranded": "https://vimeo.com/1114044764"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:27 [
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]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29845095/597-old-york-road-burlington"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1953176"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"TotalActualRent": 15000
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RNA1, O3-196, DNA"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 320.0
+"AboveGradeFinishedArea": 5434
+"BelowGradeFinishedArea": 4330
+"OriginalEntryTimestamp": "2026-06-03T13:20:17.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1204050"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1246540"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29845095')"
+"ID": "1488402"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
+post_id: "1464957"
+post_author: 1
+"ListingKey": "29812484"
+"ListingId": "X13192382"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-27T17:30:52Z"
+"RFModificationTimestamp": "2026-05-27T18:03:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "307 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.893998
1 => 43.330366
]
+"Latitude": 43.330366
+"Longitude": -79.893998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This gorgeous, upscale modern unit boasts many stylish upgrades and features! It features a one-bedroom plus a full-size den with a feature wall, a spacious kitchen with all-new cabinetry, and numerous space-maximizing touches throughout. There's even a brand-new live-edge breakfast bar for extra seating. The living room has a modern acoustic feature wall, and the primary bedroom has easy access to a large four-piece washroom and laundry. The building is trendy and offers all the best amenities. There's an exercise room, bike room, main and sixth-floor common terraces, a pet washing station, a party room, a car charging station, and a real concierge. Convenient storage lockers are available on the same floor as the condo, and there's an underground parking space with plenty of visitor parking for your guests. (id:62783)"
+"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-05-27T18:03:15.392888+00:00"
+"Directions": "Dundas St E / Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533526"
+"ListOfficeKey": "247988"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Level"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-05-27T16:59:58Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-27T16:59:58Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29812484/307-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-27T16:59:58.47Z"
+"ListAgentNationalAssociationId": "1177439"
+"ListOfficeNationalAssociationId": "1243257"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29812484')"
+"ID": "1464957"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 11
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]