array:5 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28981955/Property?$select=ALL&$top=20&$filter=ListingKey eq 28981955&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 28981955/Property?$select=ALL&$top=20&$filter=ListingKey eq 28981955&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#19823
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19825
+post_id: "188784"
+post_author: 1
+"ListingKey": "28981955"
+"ListingId": "X12458834"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-12T17:00:30Z"
+"RFModificationTimestamp": "2025-10-12T22:04:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H6"
+"UnparsedAddress": "104 ROCKHAVEN LANE, Hamilton (Waterdown), Ontario L0R2H6"
+"Coordinates": array:2 [
0 => -79.9035187
1 => 43.3329468
]
+"Latitude": 43.3329468
+"Longitude": -79.9035187
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "-a very nice 3-bedroom townhouse in convenient location for everything-sun filled bright living room and dining room to enjoy life-big master bedroom with 2-double closets and ensuite for convenience-south facing backyard with beautiful garden to enjoy-backyard has a big deck directly connected to dining room sliding door-outside gas line and concrete patio for convenient BBQ-owned hot water tank to save utilities-owner supplied high quality push grass mover to enjoy green summer without extra spence-2 parking spots suitable for professional working family-always arrange duct cleaning for new tenants*For Additional Property Details Click The Brochure Icon Below* (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-12T22:03:51.756541+00:00"
+"Directions": "Hamilton st"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1851727"
+"ListOfficeKey": "273408"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-12T16:51:45Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-12T16:51:45Z"
+"Stories": "2.0"
+"StreetName": "Rockhaven"
+"StreetNumber": "104"
+"StreetSuffix": "Lane"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1513235107"
"RoomType" => "Living room"
"ListingId" => "X12458834"
"RoomLevel" => "Main level"
"RoomWidth" => 4.0
"ListingKey" => "28981955"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
1 => array:11 [
"RoomKey" => "1513235108"
"RoomType" => "Kitchen"
"ListingId" => "X12458834"
"RoomLevel" => "Main level"
"RoomWidth" => 4.0
"ListingKey" => "28981955"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
2 => array:11 [
"RoomKey" => "1513235109"
"RoomType" => "Dining room"
"ListingId" => "X12458834"
"RoomLevel" => "Main level"
"RoomWidth" => 4.0
"ListingKey" => "28981955"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
3 => array:11 [
"RoomKey" => "1513235110"
"RoomType" => "Bedroom"
"ListingId" => "X12458834"
"RoomLevel" => "Upper Level"
"RoomWidth" => 4.0
"ListingKey" => "28981955"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
4 => array:11 [
"RoomKey" => "1513235111"
"RoomType" => "Bedroom 2"
"ListingId" => "X12458834"
"RoomLevel" => "Upper Level"
"RoomWidth" => 4.0
"ListingKey" => "28981955"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
5 => array:11 [
"RoomKey" => "1513235112"
"RoomType" => "Bedroom 3"
"ListingId" => "X12458834"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.5
"ListingKey" => "28981955"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.6Z"
]
6 => array:11 [
"RoomKey" => "1513235113"
"RoomType" => "Exercise room"
"ListingId" => "X12458834"
"RoomLevel" => "Basement"
"RoomWidth" => 8.0
"ListingKey" => "28981955"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-12T16:51:45.61Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28981955/104-rockhaven-lane-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 2900
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-10-12T16:51:45.58Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:19 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6238495546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/db4d3cc1e18e618a5b4b4b8892980654.webp"
"MediaSize" => 161272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-db4d3cc1e18e618a5b4b4b8892980654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6238495585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/8bf5c1ad3b545c37dc9952c70f6b1ffc.webp"
"MediaSize" => 143030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-8bf5c1ad3b545c37dc9952c70f6b1ffc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6238495610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/27b9648eec8b53402b1a8ad524ce9dba.webp"
"MediaSize" => 93865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-27b9648eec8b53402b1a8ad524ce9dba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6238495652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/3d776e744be078ddc76c333035d0bc36.webp"
"MediaSize" => 95283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-3d776e744be078ddc76c333035d0bc36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6238495707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/caad803f7b8d1427fa39a32366d1eea6.webp"
"MediaSize" => 264652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-caad803f7b8d1427fa39a32366d1eea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6238495775"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/144cf16ed3b1ee16f502a850994b0530.webp"
"MediaSize" => 181410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-144cf16ed3b1ee16f502a850994b0530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6238495813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/a9a6a37c2ea64c9f930cbc98ab12a32c.webp"
"MediaSize" => 184881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-a9a6a37c2ea64c9f930cbc98ab12a32c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6238495867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/aa3f9e151344936221e7f26a4c28edee.webp"
"MediaSize" => 204779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-aa3f9e151344936221e7f26a4c28edee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6238495933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/7cd9fa219690fe4a89553a4ef9a78415.webp"
"MediaSize" => 224469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-7cd9fa219690fe4a89553a4ef9a78415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6238495992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/d3a627bceb6807932181177e31fd6e98.webp"
"MediaSize" => 46095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-d3a627bceb6807932181177e31fd6e98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6238496005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/021ae7099922335024140bc6e499f857.webp"
"MediaSize" => 120253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-021ae7099922335024140bc6e499f857.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6238496024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/65631a38cffc39ab4cd2ab83aeae27ed.webp"
"MediaSize" => 207418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-65631a38cffc39ab4cd2ab83aeae27ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6238496092"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/6d9917a0415bbcd1a4328e6c039c6c68.webp"
"MediaSize" => 120492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-6d9917a0415bbcd1a4328e6c039c6c68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6238496154"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/1e44aca24792af5ced6f47890c18ae51.webp"
"MediaSize" => 106585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-1e44aca24792af5ced6f47890c18ae51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6238496216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/f6e7525a9057266f300696c34becd9e4.webp"
"MediaSize" => 80819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-f6e7525a9057266f300696c34becd9e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6238496252"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/dd3dc41c1545d728b3021392da465a1f.webp"
"MediaSize" => 91929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-dd3dc41c1545d728b3021392da465a1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6238496300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/6e8fa2b915de73c674eb659e4c756604.webp"
"MediaSize" => 269963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-6e8fa2b915de73c674eb659e4c756604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6238496353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/e8816f0b80d859a9b36dc1f44a8a6778.webp"
"MediaSize" => 423441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-e8816f0b80d859a9b36dc1f44a8a6778.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6238496408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28981955/cba5e610909819a28cdd37e172125056.webp"
"MediaSize" => 374429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28981955/thumbnail-cba5e610909819a28cdd37e172125056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12458834"
"ResourceRecordKey" => "28981955"
"ModificationTimestamp" => "2025-10-12T16:51:45.58Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28981955')"
+"ID": "188784"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.05 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 273408/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 273408&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 273408/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 273408&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21560
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.04 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1851727/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1851727&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1851727/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1851727&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21558
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.04 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 28981955" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21175
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.03 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28981955 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9035187 43.3329468)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28981955 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9035187 43.3329468)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28981955 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9035187 43.3329468)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28981955 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9035187 43.3329468)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#19837
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21602
+post_id: "184275"
+post_author: 1
+"ListingKey": "28976024"
+"ListingId": "X12455997"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-13T12:36:33Z"
+"RFModificationTimestamp": "2025-10-13T12:39:01Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "7 - 40 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8930435
1 => 43.3305779
]
+"Latitude": 43.3305779
+"Longitude": -79.8930435
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stylish townhome situated in an exclusive complex built by Chelten Homes. Perfectly located in the heart of Waterdown's charming downtown core, this home offers both convenience and community. At the front entry, a beautifully landscaped garden and covered porch create an ideal spot to relax and unwind. Inside, the bright and spacious foyer opens to a stunning open-concept main floor featuring 9 ceilings, modern dark hardwood, and a designer kitchen complete with granite countertops, island seating, and high-end appliances. The dining area opens through sliding doors to an inviting patio with a gorgeous oak tree ideal for relaxing or entertaining. Upstairs, you'll find three generous bedrooms filled with natural light. The king-sized primary suite includes a large walk-in closet and a sleek 3-piece ensuite with a large glass shower. Two additional bedrooms share a large 4-piece bath, ideal for family or guests. Custom window coverings throughout add both style and functionality. The unfinished lower level provides laundry facilities, abundant storage, and a rough-in for an additional bathroom, offering extended living space possibilities. The garage, with main hall entry, has been thoughtfully customized to optimize storage space. With its modern design, quality construction, and unbeatable location, this home is move-in ready and not to be missed! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Blinds"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "421.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pet Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-10T15:13:51.359367+00:00"
+"Directions": "Barton"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2111027"
+"ListOfficeKey": "284791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-10T23:53:57Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-13T12:18:35Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4796"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=69581"
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1513652344"
"RoomType" => "Foyer"
"ListingId" => "X12455997"
"RoomLevel" => "Main level"
"RoomWidth" => 1.8
"ListingKey" => "28976024"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.77Z"
]
1 => array:11 [
"RoomKey" => "1513652345"
"RoomType" => "Laundry room"
"ListingId" => "X12455997"
"RoomLevel" => "Basement"
"RoomWidth" => 1.0
"ListingKey" => "28976024"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.77Z"
]
2 => array:11 [
"RoomKey" => "1513652346"
"RoomType" => "Living room"
"ListingId" => "X12455997"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "28976024"
"RoomLength" => 5.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
3 => array:11 [
"RoomKey" => "1513652347"
"RoomType" => "Dining room"
"ListingId" => "X12455997"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "28976024"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
4 => array:11 [
"RoomKey" => "1513652348"
"RoomType" => "Kitchen"
"ListingId" => "X12455997"
"RoomLevel" => "Main level"
"RoomWidth" => 2.82
"ListingKey" => "28976024"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
5 => array:11 [
"RoomKey" => "1513652349"
"RoomType" => "Bathroom"
"ListingId" => "X12455997"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "28976024"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
6 => array:11 [
"RoomKey" => "1513652350"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12455997"
"RoomLevel" => "Second level"
"RoomWidth" => 3.84
"ListingKey" => "28976024"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
7 => array:11 [
"RoomKey" => "1513652351"
"RoomType" => "Bathroom"
"ListingId" => "X12455997"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "28976024"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
8 => array:11 [
"RoomKey" => "1513652352"
"RoomType" => "Bedroom 2"
"ListingId" => "X12455997"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "28976024"
"RoomLength" => 3.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
9 => array:11 [
"RoomKey" => "1513652353"
"RoomType" => "Bedroom 3"
"ListingId" => "X12455997"
"RoomLevel" => "Second level"
"RoomWidth" => 3.07
"ListingKey" => "28976024"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
10 => array:11 [
"RoomKey" => "1513652354"
"RoomType" => "Bathroom"
"ListingId" => "X12455997"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "28976024"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-13T12:18:35.78Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28976024/7-40-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-10-10T14:31:50.6Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:41 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6234704049"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/b3cfdf8579f8bd7d4ad3869ea1610827.webp"
"MediaSize" => 283634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-b3cfdf8579f8bd7d4ad3869ea1610827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6234704113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/46a767d129b6cf79806a5e45e7f39d79.webp"
"MediaSize" => 310592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-46a767d129b6cf79806a5e45e7f39d79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6234704147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/41f36f2862ecb0e0779b028e094147a1.webp"
"MediaSize" => 398828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-41f36f2862ecb0e0779b028e094147a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6234704188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/0900231492b82c1c394fd429e934df70.webp"
"MediaSize" => 320669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-0900231492b82c1c394fd429e934df70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6234704227"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/9fe803a316fd60496604632d45ec89e0.webp"
"MediaSize" => 324249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-9fe803a316fd60496604632d45ec89e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6234704290"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/1dd980512b0a94c99804cb68ac2c03c6.webp"
"MediaSize" => 169792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-1dd980512b0a94c99804cb68ac2c03c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6234704302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/4a9d6b950bdf50ae1fc3ef417d426b9c.webp"
"MediaSize" => 196526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-4a9d6b950bdf50ae1fc3ef417d426b9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6234704343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/9cfab7ea4b43ff4537696f23335ff253.webp"
"MediaSize" => 143031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-9cfab7ea4b43ff4537696f23335ff253.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6234704387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/afc905ea35d5fbed48182284718f7304.webp"
"MediaSize" => 269472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-afc905ea35d5fbed48182284718f7304.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6234704437"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/eae455f9d3d3cc2dd864efce40d075a1.webp"
"MediaSize" => 208244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-eae455f9d3d3cc2dd864efce40d075a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6234704464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/f1ce6f0a4cbcaae8250d124f84518709.webp"
"MediaSize" => 256376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-f1ce6f0a4cbcaae8250d124f84518709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6234704501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/8c85d231f1102ac37226af92129be278.webp"
"MediaSize" => 283839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-8c85d231f1102ac37226af92129be278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6234704539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/5c48f2364607128fc2e60f74864c94a4.webp"
"MediaSize" => 208570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-5c48f2364607128fc2e60f74864c94a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6234704543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/f34ec14a8e439b97a7060757f42f233a.webp"
"MediaSize" => 271062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-f34ec14a8e439b97a7060757f42f233a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6234704599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/c03ef8f6190880e20abb99075646880c.webp"
"MediaSize" => 214868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-c03ef8f6190880e20abb99075646880c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6234704641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/3152912780daa78d61c7be2c7c98e5b3.webp"
"MediaSize" => 269199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-3152912780daa78d61c7be2c7c98e5b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6234704652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/027c9aaa72f5087fd81a208de121aa0e.webp"
"MediaSize" => 197792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-027c9aaa72f5087fd81a208de121aa0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6234704658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/2d1ae8ef9719f03647e0f7676211078d.webp"
"MediaSize" => 189607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-2d1ae8ef9719f03647e0f7676211078d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6234704697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/4cf64c9753161f73c40a12ffff7dca74.webp"
"MediaSize" => 198647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-4cf64c9753161f73c40a12ffff7dca74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6234704723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/e1ff6b6561edf80d5819ef8c46f82946.webp"
"MediaSize" => 251069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-e1ff6b6561edf80d5819ef8c46f82946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6234704750"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/1ee97eff6eba9d37089ef9c0c5ade535.webp"
"MediaSize" => 218631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-1ee97eff6eba9d37089ef9c0c5ade535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6234704778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/5c53348bdd1198cd39684d4903573a64.webp"
"MediaSize" => 245841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-5c53348bdd1198cd39684d4903573a64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6234704800"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/69e4ed5968a0473c77c2038e7f4cc69f.webp"
"MediaSize" => 212730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-69e4ed5968a0473c77c2038e7f4cc69f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6234704826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/c448646d9e07fe756a6b6a25ae25d081.webp"
"MediaSize" => 110714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-c448646d9e07fe756a6b6a25ae25d081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6234704840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/44a93b73add8e57ea43d5881f7ed4a8a.webp"
"MediaSize" => 181048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-44a93b73add8e57ea43d5881f7ed4a8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6234704871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/266766760b6bf6749f8e5dc1644d1b4a.webp"
"MediaSize" => 219586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-266766760b6bf6749f8e5dc1644d1b4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6234704877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/ad2baf1f299e73da98823eb519c2c62f.webp"
"MediaSize" => 194458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-ad2baf1f299e73da98823eb519c2c62f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6234704891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/a7674006a2f07122e1bd70ddb1a97b6a.webp"
"MediaSize" => 108164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-a7674006a2f07122e1bd70ddb1a97b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6234704904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/2d445349c0ea50ecff932efb0e858560.webp"
"MediaSize" => 182682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-2d445349c0ea50ecff932efb0e858560.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6234704914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/fdabed4967ca41b7539867b66d09dd13.webp"
"MediaSize" => 184587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-fdabed4967ca41b7539867b66d09dd13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6234704927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/ed25b05c78788275d45e4b5b7d60ba65.webp"
"MediaSize" => 196153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-ed25b05c78788275d45e4b5b7d60ba65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6234704945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/5205b7bad1a907b71211fd8b6af4de44.webp"
"MediaSize" => 213037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-5205b7bad1a907b71211fd8b6af4de44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6234704957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/6c23ab304bfeaad171e0631edecb2157.webp"
"MediaSize" => 209368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-6c23ab304bfeaad171e0631edecb2157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6234704963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/83855f6671b61e6017ca2604d5098991.webp"
"MediaSize" => 246995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-83855f6671b61e6017ca2604d5098991.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6234704972"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/0c7c376a2c5357ee1cff25ef56c67b46.webp"
"MediaSize" => 217498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-0c7c376a2c5357ee1cff25ef56c67b46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6234704985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/606a81b0b12b7c7853d70a884fe05a10.webp"
"MediaSize" => 297154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-606a81b0b12b7c7853d70a884fe05a10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6234704995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/4d2c33c3f7194cbd07f6bbae1d46dd86.webp"
"MediaSize" => 242676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-4d2c33c3f7194cbd07f6bbae1d46dd86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6234705001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/a5615f72139d8775ce768f9cca1891e4.webp"
"MediaSize" => 363413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-a5615f72139d8775ce768f9cca1891e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6234705005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/05d4edfadef0e7596c5132340f1c6e6b.webp"
"MediaSize" => 387609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-05d4edfadef0e7596c5132340f1c6e6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6234705010"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/3f53184f340c968657b37b7ff1427b9b.webp"
"MediaSize" => 384700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-3f53184f340c968657b37b7ff1427b9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T14:31:50.61Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6235838383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28976024/fc021df7e6449d291ecdfe3246f24759.webp"
"MediaSize" => 176140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28976024/thumbnail-fc021df7e6449d291ecdfe3246f24759.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12455997"
"ResourceRecordKey" => "28976024"
"ModificationTimestamp" => "2025-10-10T23:27:28.78Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28976024')"
+"ID": "184275"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21604
+post_id: "183983"
+post_author: 1
+"ListingKey": "28975717"
+"ListingId": "40776994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-12T20:36:00Z"
+"RFModificationTimestamp": "2025-10-12T20:40:18Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1528.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "40 HAMILTON Street S Unit# 7, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.89328429
1 => 43.33066596
]
+"Latitude": 43.33066596
+"Longitude": -79.89328429
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stylish townhome situated in an exclusive complex built by Chelten Homes. Perfectly located in the heart of Waterdown’s charming downtown core, this home offers both convenience and community. At the front entry, a beautifully landscaped garden and covered porch create an ideal spot to relax and unwind. Inside, the bright and spacious foyer opens to a stunning open-concept main floor featuring 9’ ceilings, modern dark hardwood, and a designer kitchen complete with granite countertops, island seating, and high-end appliances. The dining area opens through sliding doors to an inviting patio with a gorgeous oak tree – ideal for relaxing or entertaining. Upstairs, you’ll find three generous bedrooms filled with natural light. The king-sized primary suite includes a large walk-in closet and a sleek 3-piece ensuite with a large glass shower. Two additional bedrooms share a large 4-piece bath, ideal for family or guests. Custom window coverings throughout add both style and functionality. The unfinished lower level provides laundry facilities, abundant storage, and a rough-in for an additional bathroom, offering extended living space possibilities. The garage, with main hall entry, has been thoughtfully customized to optimize storage space. With its modern design, quality construction, and unbeatable location, this home is move-in ready and not to be missed! (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum - Roughed In"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "421.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-10T13:42:25.198394+00:00"
+"Directions": "Hamilton St South of Dundas"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523707"
+"ListOfficeKey": "284622"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-10T23:19:27Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-12T20:20:13Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4796"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=69581"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1513358544"
"RoomType" => "Laundry room"
"ListingId" => "40776994"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.11Z"
]
1 => array:11 [
"RoomKey" => "1513358545"
"RoomType" => "4pc Bathroom"
"ListingId" => "40776994"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.11Z"
]
2 => array:11 [
"RoomKey" => "1513358546"
"RoomType" => "Bedroom"
"ListingId" => "40776994"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
3 => array:11 [
"RoomKey" => "1513358547"
"RoomType" => "Bedroom"
"ListingId" => "40776994"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
4 => array:11 [
"RoomKey" => "1513358548"
"RoomType" => "Full bathroom"
"ListingId" => "40776994"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
5 => array:11 [
"RoomKey" => "1513358549"
"RoomType" => "Primary Bedroom"
"ListingId" => "40776994"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
6 => array:11 [
"RoomKey" => "1513358550"
"RoomType" => "2pc Bathroom"
"ListingId" => "40776994"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
7 => array:11 [
"RoomKey" => "1513358551"
"RoomType" => "Eat in kitchen"
"ListingId" => "40776994"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
8 => array:11 [
"RoomKey" => "1513358552"
"RoomType" => "Dining room"
"ListingId" => "40776994"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
9 => array:11 [
"RoomKey" => "1513358553"
"RoomType" => "Living room"
"ListingId" => "40776994"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.12Z"
]
10 => array:11 [
"RoomKey" => "1513358554"
"RoomType" => "Foyer"
"ListingId" => "40776994"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28975717"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-12T20:20:13.13Z"
]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28975717/40-hamilton-street-s-unit-7-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"ZoningDescription": "R6-43, P5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1528
+"OriginalEntryTimestamp": "2025-10-10T13:18:58.72Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6235786960"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/c1859cd8b5ce452fa835837cb83cbef9.webp"
"MediaSize" => 115100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-c1859cd8b5ce452fa835837cb83cbef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6235787021"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/7e39ecbfda4a8cef303a1c0cb154102f.webp"
"MediaSize" => 124608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-7e39ecbfda4a8cef303a1c0cb154102f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.41Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6235787123"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/6d6dd48f310ba2137a94b56988ac7128.webp"
"MediaSize" => 151867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-6d6dd48f310ba2137a94b56988ac7128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.82Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6235787227"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/2447a328ab57d315c611813f15824e80.webp"
"MediaSize" => 120574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-2447a328ab57d315c611813f15824e80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.44Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6235787245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/dcd56e4d91e81a81bba21303fdf773ef.webp"
"MediaSize" => 128788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-dcd56e4d91e81a81bba21303fdf773ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.41Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6235787330"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/8128cf790d5fd6c33be2fff63a71ca49.webp"
"MediaSize" => 64866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-8128cf790d5fd6c33be2fff63a71ca49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.43Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6235787405"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/0c2399beb8aebb8f4866d8cbe279f404.webp"
"MediaSize" => 70666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-0c2399beb8aebb8f4866d8cbe279f404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.39Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6235787452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/d610cbabc154c5a2202f86b2f5bf3cb6.webp"
"MediaSize" => 59234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-d610cbabc154c5a2202f86b2f5bf3cb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.43Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6235787554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/f55be42732a034cb13c0d55bbfdfb532.webp"
"MediaSize" => 94419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-f55be42732a034cb13c0d55bbfdfb532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.41Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6235787610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/cd0e7d97aca11108a923996cc30daf88.webp"
"MediaSize" => 77738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-cd0e7d97aca11108a923996cc30daf88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.38Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6235787725"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/9587a6dcbe9dcdd8c01d8d89368a12bb.webp"
"MediaSize" => 90571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-9587a6dcbe9dcdd8c01d8d89368a12bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.41Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6235787810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/bcfc0be50a27b3a8bc96157929d3d589.webp"
"MediaSize" => 100052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-bcfc0be50a27b3a8bc96157929d3d589.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.43Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6235787878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/3b66433edca6e4deac6f3197d45284fb.webp"
"MediaSize" => 82661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-3b66433edca6e4deac6f3197d45284fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.38Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6235787944"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/78c32e5152216dbafd1b01a5e2dae187.webp"
"MediaSize" => 97019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-78c32e5152216dbafd1b01a5e2dae187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.38Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6235788017"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/a0ec97e31171e83b000da01a6d99433d.webp"
"MediaSize" => 78687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-a0ec97e31171e83b000da01a6d99433d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.76Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6235788042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/a791343aec1cbe6697061e7e9b1957ed.webp"
"MediaSize" => 99203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-a791343aec1cbe6697061e7e9b1957ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6235788134"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/60d660df26ac8e82baf41fb92bd0e8de.webp"
"MediaSize" => 75329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-60d660df26ac8e82baf41fb92bd0e8de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:36.44Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6235788223"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/f929bed2e74cb7e18031e9585d973909.webp"
"MediaSize" => 69878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-f929bed2e74cb7e18031e9585d973909.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6235788242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/5c8ab2d10fe66e20295fa5abb2e4aa2f.webp"
"MediaSize" => 86083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-5c8ab2d10fe66e20295fa5abb2e4aa2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.82Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6235788264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/3e87ec2efea358b5a9d511f3657ee797.webp"
"MediaSize" => 98278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-3e87ec2efea358b5a9d511f3657ee797.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6235788374"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/3b3e7897d237a71427ac95ca25f5fd11.webp"
"MediaSize" => 84442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-3b3e7897d237a71427ac95ca25f5fd11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6235788467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/536d0eabc58f5041fe717943232d4c17.webp"
"MediaSize" => 95251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-536d0eabc58f5041fe717943232d4c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.84Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6235788501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/ab29c2ad3d2e287d5a1fd1bb024763e8.webp"
"MediaSize" => 81374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-ab29c2ad3d2e287d5a1fd1bb024763e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.84Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6235788540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/c8ca4a10792c833ff14ec08d18185d8d.webp"
"MediaSize" => 37428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28975717/thumbnail-c8ca4a10792c833ff14ec08d18185d8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40776994"
"ResourceRecordKey" => "28975717"
"ModificationTimestamp" => "2025-10-10T23:11:31.78Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6235788626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28975717/b69ce45a66b6ade3177ed73847473d61.webp"
"MediaSize" => 60077
"MediaType" => "webp"
…8
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28975717')"
+"ID": "183983"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21601
+post_id: "184276"
+post_author: 1
+"ListingKey": "28973881"
+"ListingId": "X12455168"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-12T12:36:15Z"
+"RFModificationTimestamp": "2025-10-12T12:39:39Z"
+"ListPrice": 1949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "7 CARL CRESCENT, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.8910522
1 => 43.3260193
]
+"Latitude": 43.3260193
+"Longitude": -79.8910522
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 7 Carl Crescent, your perfect blend of design, comfort, and function on one Waterdown's most desirable streets. This 4+2 bed 3+1 home offers over 3,000 sq ft of sun-filled living with a chef's kitchen, quartz island, and premium appliances. A separate-entrance lower level with full kitchen and bath suits in-laws or income. Enjoy a pool-sized yard and heated studio steps from parks, schools, and commuter routes. Everything is Newly Upgraded throughout: engineered hardwood, skylights, and custom millwork. Chefs' kitchen with oversized quartz island, premium appliances, and smart layout. Separate entrance lower level with full suite, ideal for in-laws or income. Extras: Beautifully reimagined from top to bottom, this home features thoughtful upgrades throughout. Modern lighting, remote blinds, elegant millwork and custom storage solutions. The primary suite boasts a spa-inspired ensuite and walk-in closet, while skylights flood the upper level with natural light. Step outside to an entertainers dream: a landscaped, pool-sized yard with a heated studio perfect for a gym, office, or creative space. With a full in-law suite, smart home features, and ample parking, this property blends everyday luxury with exceptional flexibility in one of Waterdowns most connected neighborhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-09T21:47:06.730544+00:00"
+"Directions": "Thomson Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2034888"
+"ListOfficeKey": "257478"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "75 x 102.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-09T20:57:52Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-12T12:24:47Z"
+"Stories": "2.0"
+"StreetName": "Carl"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8441"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28973881/7-carl-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 75.0
+"OriginalEntryTimestamp": "2025-10-09T20:57:52.38Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28973881')"
+"ID": "184276"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21605
+post_id: "183740"
+post_author: 1
+"ListingKey": "28973907"
+"ListingId": "40777283"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-10T13:30:07Z"
+"RFModificationTimestamp": "2025-10-10T13:31:27Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 DUNDAS Street E Unit# 311, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.89594047
1 => 43.33012463
]
+"Latitude": 43.33012463
+"Longitude": -79.89594047
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious and beautifully refreshed 2 bedroom + den condo, offering over 1,300 sq. ft. of thoughtfully designed living space where history blends seamlessly with modern living. Freshly renovated with new hardwood flooring, pain, fixtures, updated bathrooms & open concept modern kitchen, this home radiates warmth and coziness from the moment you step inside. The open-concept layout features 10-foot ceilings and an abundance of natural sunlight, creating an inviting and airy atmosphere throughout. Enjoy two private balconies—perfect for morning coffee or evening relaxation and the convenience of in-suite laundry, a locker room, and two underground parking spots. Located in a highly desirable area, you’re just steps away from a vibrant mix of restaurants, grocery stores, and shops, and minutes to highways and top-rated schools. A perfect blend of comfort, space, and lifestyle—this condo truly feels like home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "740.63"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-09T21:43:28.777578+00:00"
+"Directions": "Hwy 6 & Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-10-09T21:02:30Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-10T13:18:56Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4594.34"
+"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": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28973907/262-dundas-street-e-unit-311-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1322
+"OriginalEntryTimestamp": "2025-10-09T21:00:20.97Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28973907')"
+"ID": "183740"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21603
+post_id: "184827"
+post_author: 1
+"ListingKey": "28972981"
+"ListingId": "X12454746"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-09T19:05:56Z"
+"RFModificationTimestamp": "2025-10-09T20:59:47Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7G8"
+"UnparsedAddress": "55 OVERDALE AVENUE, Hamilton (Waterdown), Ontario L9H7G8"
+"Coordinates": array:2 [
0 => -79.9002457
1 => 43.3245049
]
+"Latitude": 43.3245049
+"Longitude": -79.9002457
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Perched on one of Waterdown's most coveted streets, 55 Overdale Avenue captures everything that makes this pocket so special: a wide lot, mature trees and sweeping views of the escarpment that change with the seasons. Originally one of the model homes in the neighbourhood, this all-brick residence stands with quiet confidence on a 112 x 148 lot, surrounded by greenery and privacy. Inside, generous principal rooms unfold across a thoughtful layout, spaces that invite gathering, conversation, and the kind of ease that comes with a well-designed home. The lower level offers a walkout basement and a separate garage entrance, opening up a world of potential for extended family or an in-law suite. With its timeless exterior, double garage and a setting that feels more country estate than subdivision, 55 Overdale Avenue is a property that doesn't come along often. A rare opportunity to restore and reimagine a piece of Waterdown's history where timeless charm meets its next chapter. An extraordinary yet compelling find for end-users, investors, project-minded designers or dream-builders alike. RSA. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Partially finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CreationDate": "2025-10-09T20:59:12.065220+00:00"
+"Directions": "Dundas St E to Bayview Ave to Overdale Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "112 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-09T18:59:01Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-09T18:59:01Z"
+"Stories": "1.0"
+"StreetName": "Overdale"
+"StreetNumber": "55"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "8213"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28972981/55-overdale-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 112.0
+"OriginalEntryTimestamp": "2025-10-09T18:59:01.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28972981')"
+"ID": "184827"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21598
+post_id: "186150"
+post_author: 1
+"ListingKey": "28972766"
+"ListingId": "40777915"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-09T18:35:31Z"
+"RFModificationTimestamp": "2025-10-09T19:36:31Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1744.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7G8"
+"UnparsedAddress": "55 OVERDALE Avenue, Waterdown, Ontario L9H7G8"
+"Coordinates": array:2 [
0 => -79.90035184
1 => 43.32453823
]
+"Latitude": 43.32453823
+"Longitude": -79.90035184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched on one of Waterdown’s most coveted streets, 55 Overdale Avenue captures everything that makes this pocket so special: a wide lot, mature trees and sweeping views of the escarpment that change with the seasons. Originally one of the model homes in the neighbourhood, this all-brick residence stands with quiet confidence on a 112’ x 148’ lot, surrounded by greenery and privacy. Inside, generous principal rooms unfold across a thoughtful layout, spaces that invite gathering, conversation, and the kind of ease that comes with a well-designed home. The lower level offers a walkout basement and a separate garage entrance, opening up a world of potential for extended family or an in-law suite. With its timeless exterior, double garage and a setting that feels more country estate than subdivision, 55 Overdale Avenue is a property that doesn’t come along often. A rare opportunity to restore and reimagine a piece of Waterdown’s history – where timeless charm meets its next chapter. An extraordinary yet compelling find for end-users, investors, project-minded designers or dream-builders alike. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-10-09T19:36:11.774436+00:00"
+"Directions": "Dundas St E to Bayview Ave to Overdale Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-09T18:32:38Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-09T18:32:37Z"
+"Stories": "1.0"
+"StreetName": "OVERDALE"
+"StreetNumber": "55"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8213"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28972766/55-overdale-avenue-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R1-6"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 112.0
+"AboveGradeFinishedArea": 1744
+"OriginalEntryTimestamp": "2025-10-09T18:30:10.16Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28972766')"
+"ID": "186150"
}
]
+success: true
+page_size: 6
+page_count: 24
+count: 144
+after_key: ""
}
"RF Response Time" => "0.07 seconds"
]
]