array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29158906/Property?$select=ALL&$top=20&$filter=ListingKey eq 29158906&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29158906/Property?$select=ALL&$top=20&$filter=ListingKey eq 29158906&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23660
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23662
+post_id: "460173"
+post_author: 1
+"ListingKey": "29158906"
+"ListingId": "40791682"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T17:45:53Z"
+"RFModificationTimestamp": "2025-12-03T18:11:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1474.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "219 DUNDAS Street E Unit# 8, Waterdown, Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.8997755
1 => 43.3271399
]
+"Latitude": 43.3271399
+"Longitude": -79.8997755
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the vibrant heart of Waterdown, this modern 3-level townhome offers an urban oasis with exclusive CTOR rooftop terrace. Perfectly positioned for convenience, The Tannery is steps from local dining, shops, parks, and the library, ideal for those desiring upscale amenities with a charming small-town ambiance. Easy access to 407/403/QEW & Aldershot GO Station. The open-concept main floor is designed for seamless entertaining, featuring a spacious layout and an eat-in kitchen equipped w SS appliances & expansive island/breakfast bar. Retreat to the upper floors where two sizable bedrooms await, each with W/I closets. The master boasts a Juliet balcony with sliding doors & ensuite bath. A convenient in-suite laundry & 2nd full bathroom add to the thoughtful layout. The pinnacle of this unique property is the private rooftop terrace. Enjoy serene evenings under a partially covered area. Including 1 parking space. The perfect package for stylish, convenient living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T18:11:10.805363+00:00"
+"Directions": "Hamilton St. N to Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-03T17:38:24Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T17:38:24Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1544279078"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791682"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
1 => array:11 [
"RoomKey" => "1544279079"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791682"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
2 => array:11 [
"RoomKey" => "1544279080"
"RoomType" => "Bedroom"
"ListingId" => "40791682"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
3 => array:11 [
"RoomKey" => "1544279081"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791682"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
4 => array:11 [
"RoomKey" => "1544279082"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791682"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
5 => array:11 [
"RoomKey" => "1544279083"
"RoomType" => "Living room"
"ListingId" => "40791682"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
6 => array:11 [
"RoomKey" => "1544279084"
"RoomType" => "Kitchen"
"ListingId" => "40791682"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
7 => array:11 [
"RoomKey" => "1544279085"
"RoomType" => "Dining room"
"ListingId" => "40791682"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29158906"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-03T17:38:24.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29158906/219-dundas-street-e-unit-8-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2109591"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "HC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1474
+"OriginalEntryTimestamp": "2025-12-03T17:38:24.56Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6353725641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/19390c166bfa5a9d780f3a8eee943868.webp"
"MediaSize" => 143326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-19390c166bfa5a9d780f3a8eee943868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6353725676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/b2f21b347c4ebb1985ebf7a6200d1dd0.webp"
"MediaSize" => 96599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-b2f21b347c4ebb1985ebf7a6200d1dd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6353725749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/0240cd9f2f89954637010539049b3dea.webp"
"MediaSize" => 83562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-0240cd9f2f89954637010539049b3dea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6353725826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/e554b9b9301f76f3d4be8258cff3eeee.webp"
"MediaSize" => 107723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-e554b9b9301f76f3d4be8258cff3eeee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6353725841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/42bf2a17fa453daceb78c7054d81a79b.webp"
"MediaSize" => 157972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-42bf2a17fa453daceb78c7054d81a79b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6353725931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/fe8779fd62f2ed29e262d649b21ee884.webp"
"MediaSize" => 94385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-fe8779fd62f2ed29e262d649b21ee884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6353725984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/4e253b4df090847685d7d45f1d922f3a.webp"
"MediaSize" => 142619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-4e253b4df090847685d7d45f1d922f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6353726050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/c88f7a2980934ba4f0bd37cd54fed826.webp"
"MediaSize" => 112593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-c88f7a2980934ba4f0bd37cd54fed826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6353726118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/68ee120868f511f13f2ca9912f100dd0.webp"
"MediaSize" => 89430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-68ee120868f511f13f2ca9912f100dd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6353726191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/5980abe5f2137909d7da1b89f38870de.webp"
"MediaSize" => 109600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-5980abe5f2137909d7da1b89f38870de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6353726266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/c1ec10f180e2ce66ec8a9cee95cb3c1d.webp"
"MediaSize" => 68155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-c1ec10f180e2ce66ec8a9cee95cb3c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6353726284"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/88371cc77705ee2c88275097f3ca74ee.webp"
"MediaSize" => 123767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-88371cc77705ee2c88275097f3ca74ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6353726353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/1a168953fbc073cfbc976fd41a49fbf4.webp"
"MediaSize" => 54347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-1a168953fbc073cfbc976fd41a49fbf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6353726400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/f5eb22603242416af68e94acfa36be1f.webp"
"MediaSize" => 103437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-f5eb22603242416af68e94acfa36be1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6353726458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/079ab13e14c51ccc257ea0a654df72de.webp"
"MediaSize" => 96386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-079ab13e14c51ccc257ea0a654df72de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6353726525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/55773d62086315aef657d498803e79df.webp"
"MediaSize" => 55561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-55773d62086315aef657d498803e79df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6353726544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/e882fbdf4642f6ea355adebf32899acd.webp"
"MediaSize" => 130614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-e882fbdf4642f6ea355adebf32899acd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6353726590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/7a26e180e79a720a80c86b65ece8b5b0.webp"
"MediaSize" => 75799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-7a26e180e79a720a80c86b65ece8b5b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6353726644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/d2e0b0aeb68c5b5756156683019c09af.webp"
"MediaSize" => 94844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-d2e0b0aeb68c5b5756156683019c09af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6353726670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/c1e23833a610dbfbb6c2890b2175f507.webp"
"MediaSize" => 83126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-c1e23833a610dbfbb6c2890b2175f507.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6353726702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/7618513695b120b2d0563135f96e5f16.webp"
"MediaSize" => 62850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-7618513695b120b2d0563135f96e5f16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6353726741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/440360e2e84d9f817ae314e0adf9c0f3.webp"
"MediaSize" => 110838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-440360e2e84d9f817ae314e0adf9c0f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6353726768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/1ca2a849fbc7c5dc8ffe3910f94297ff.webp"
"MediaSize" => 61456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-1ca2a849fbc7c5dc8ffe3910f94297ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6353726791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/7473670685d229a9c1aca16d225e30d3.webp"
"MediaSize" => 164123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-7473670685d229a9c1aca16d225e30d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6353726796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/d7084f0ca4bef4f5e24d0e4b5ce32525.webp"
"MediaSize" => 171523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-d7084f0ca4bef4f5e24d0e4b5ce32525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6353726807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/54968ebc628e47b277e63ec537dedb4f.webp"
"MediaSize" => 85070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-54968ebc628e47b277e63ec537dedb4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6353726812"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/2b4931cec2d059089e7e49c625a975f6.webp"
"MediaSize" => 88318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-2b4931cec2d059089e7e49c625a975f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6353726815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/ef80ed8fca2043530e6ce2eba413d3d1.webp"
"MediaSize" => 56577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-ef80ed8fca2043530e6ce2eba413d3d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6353726818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/5c9d5318b7272d1bdcaddf56194edbdf.webp"
"MediaSize" => 120202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-5c9d5318b7272d1bdcaddf56194edbdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6353726822"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/89f12b1e58b1720a4763e134ea6d1835.webp"
"MediaSize" => 92180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-89f12b1e58b1720a4763e134ea6d1835.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6353726825"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/1509a05096d64e5b4b3f0a96f1afa562.webp"
"MediaSize" => 83544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-1509a05096d64e5b4b3f0a96f1afa562.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6353726830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/c3801d6410f55a3de0e2e3cb665c296a.webp"
"MediaSize" => 99214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-c3801d6410f55a3de0e2e3cb665c296a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6353726833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/fe49f32ea150bdfd8cf6fe59ce953217.webp"
"MediaSize" => 113806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-fe49f32ea150bdfd8cf6fe59ce953217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6353726837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/b7c6a5b0d102f252f890e03786c9af13.webp"
"MediaSize" => 127345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-b7c6a5b0d102f252f890e03786c9af13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6353726839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29158906/69d9105e19848e6d02b7e65a93a66050.webp"
"MediaSize" => 93126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29158906/thumbnail-69d9105e19848e6d02b7e65a93a66050.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791682"
"ResourceRecordKey" => "29158906"
"ModificationTimestamp" => "2025-12-03T17:38:24.56Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Cathy Rocca"
"MemberFirstName" => "Cathy"
"MemberLastName" => "Rocca"
"MemberMlsId" => "HBROCCACA"
"OriginatingSystemName" => 26
"MemberKey" => "1567201"
"ModificationTimestamp" => "2025-10-28T23:19:41Z"
"MemberStatus" => "Active"
"OfficeKey" => "283099"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "905-335-1659"
"MemberCity" => "Burlington"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-335-3042"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1149561"
"OfficeNationalAssociationId" => "1324631"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "Royal LePage Burloak Real Estate Services"
"OfficePhone" => "905-335-3042"
"OfficeMlsId" => "HBRLPBURMNY2"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283099"
"ModificationTimestamp" => "2025-07-09T18:16:49Z"
"OfficeAddress1" => "3060 Mainway Suite 200A"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7M1A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "905-335-1659"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-02-28T20:54:00Z"
"OfficeNationalAssociationId" => "1324631"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1196412"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29158906')"
+"ID": "460173"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25505
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25507
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Burloak Real Estate Services"
+"OfficeEmail": null
+"OfficePhone": "905-335-3042"
+"OfficeMlsId": "HBRLPBURMNY2"
+"ModificationTimestamp": "2025-07-09T18:16:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283099"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "3060 Mainway Suite 200A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M1A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1324631"
+"OriginalEntryTimestamp": "2018-02-28T20:54:00Z"
+"OfficeFax": "905-335-1659"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439607"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283099"
"SocialMediaUrlOrId" => "https://www.royallepageburlington.ca/"
"ModificationTimestamp" => "2025-07-09T18:06:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1196412"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283099')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1567201/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1567201&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1567201/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1567201&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25510
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29158906" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25101
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29158906/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29158906&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29158906/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29158906&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29158906 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8997755 43.3271399)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29158906 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8997755 43.3271399)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29158906 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8997755 43.3271399)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29158906 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8997755 43.3271399)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25354
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "470906"
+post_author: 1
+"ListingKey": "29174288"
+"ListingId": "X12612860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T22:00:41Z"
+"RFModificationTimestamp": "2025-12-09T22:06:45Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T3"
+"UnparsedAddress": "61 BOUSFIELD RISE, Hamilton (Waterdown), Ontario L8B0T3"
+"Coordinates": array:2 [
0 => -79.9218276
1 => 43.3275486
]
+"Latitude": 43.3275486
+"Longitude": -79.9218276
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**Absolutely Beautiful** Spacious Semi-Detached Premium Lot Backing onto Greenspace. Open concept with over 2200SF of Finished Living Space, nestled in a quiet area of Waterdown. This turnkey home is move in ready with tons of upgrades, California Shutters (2023), Retractable Zebra Shutter (2023), Closet Organizers (2022), Finished Laundry Rm with Floating shelves & Stainless-steel sink (2024), Bathrooms on Upper Fl with quartz vanities (2024), Toilets (2022), Bidets in bathrooms. Hardwood Flr in Bdrms (2020), Updated Kitchen Cabinets (2020) Kitchen appliances, Upgraded Windows & Frosted windows in Upper bathrooms (2022 & 2024), Entire yard fully Landscaped (2023), Sump pump with backup generator (2024), Bsmt carpet (2020), Furnace & AC (2025), Weather Proofing Inside & Out (2024), Driveway (2023). Hardwood Floors, Stainless Steel Appliances, Oak Staircase with Wrought Iron Spindles, Finished Basement with Rough in bathroom. Finished Laundry room with built in Floating Shelves. Close to Hwy 403, 6, 401. Schools, Shopping, Ymca, Library. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T18:45:23.617260+00:00"
+"Directions": "Cross Streets: Parkside/Sadielou. ** Directions: Parkside and Sadielou."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417041"
+"ListOfficeKey": "51273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
]
+"LotSizeDimensions": "26.9 x 99.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T17:46:07Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T21:45:41Z"
+"Stories": "2.0"
+"StreetName": "Bousfield"
+"StreetNumber": "61"
+"StreetSuffix": "Rise"
+"TaxAnnualAmount": "5928.61"
+"VirtualTourURLUnbranded": "https://tours.sf-photography-photographer.com/61-bousfield-rise-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1547199960"
"RoomType" => "Family room"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29174288"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
1 => array:11 [
"RoomKey" => "1547199961"
"RoomType" => "Kitchen"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 2.56
"ListingKey" => "29174288"
"RoomLength" => 5.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
2 => array:11 [
"RoomKey" => "1547199962"
"RoomType" => "Dining room"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29174288"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
3 => array:11 [
"RoomKey" => "1547199963"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.77
"ListingKey" => "29174288"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
4 => array:11 [
"RoomKey" => "1547199964"
"RoomType" => "Bedroom 2"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.66
"ListingKey" => "29174288"
"RoomLength" => 3.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
5 => array:11 [
"RoomKey" => "1547199965"
"RoomType" => "Bedroom 3"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.71
"ListingKey" => "29174288"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
6 => array:11 [
"RoomKey" => "1547199966"
"RoomType" => "Laundry room"
"ListingId" => "X12612860"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.88
"ListingKey" => "29174288"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
7 => array:11 [
"RoomKey" => "1547199967"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12612860"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.99
"ListingKey" => "29174288"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29174288/61-bousfield-rise-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2025-12-09T17:46:07.53Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362888228"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/0dd13fafa73e64ad24634c2736ea35c3.webp"
"MediaSize" => 233376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-0dd13fafa73e64ad24634c2736ea35c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362888240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ceb985d0413eaa1cdcaa973a6b99f0c6.webp"
"MediaSize" => 216993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ceb985d0413eaa1cdcaa973a6b99f0c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362888255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/4304dd1ea799b28ec79c04bfb8993308.webp"
"MediaSize" => 259688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-4304dd1ea799b28ec79c04bfb8993308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362888266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/cca114e5e0a4798241e8bf6f3e08cff7.webp"
"MediaSize" => 227266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-cca114e5e0a4798241e8bf6f3e08cff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362888281"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/1fe9d53413789c30d24b075bfe2163f4.webp"
"MediaSize" => 187106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-1fe9d53413789c30d24b075bfe2163f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362888294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ba9a1c14bf82066ce3dffc5d03004ba6.webp"
"MediaSize" => 86857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ba9a1c14bf82066ce3dffc5d03004ba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362888310"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/2263eb9de499f02ab032d1505fb1b02b.webp"
"MediaSize" => 65972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-2263eb9de499f02ab032d1505fb1b02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362888316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/76398dded3a888a13265332436fa73f4.webp"
"MediaSize" => 97217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-76398dded3a888a13265332436fa73f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362888336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ff29bdbf4c20ef5ff8c708523eb61877.webp"
"MediaSize" => 80767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ff29bdbf4c20ef5ff8c708523eb61877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362888358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ed17564bf229e71fd003af6286f40fae.webp"
"MediaSize" => 64984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ed17564bf229e71fd003af6286f40fae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362888390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/005c978ab127a527fba9c3483ed44315.webp"
"MediaSize" => 78828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-005c978ab127a527fba9c3483ed44315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362888400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/020fbe52de07e8441da603e48b9c64ce.webp"
"MediaSize" => 89355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-020fbe52de07e8441da603e48b9c64ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362888436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/44c2a94c5094fa8992f70972af1f5054.webp"
"MediaSize" => 105041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-44c2a94c5094fa8992f70972af1f5054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362888446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/5e3cfebce9028fde9875718d7c07a73a.webp"
"MediaSize" => 108211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-5e3cfebce9028fde9875718d7c07a73a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362888462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/b37a561c582b86436c42f40d337e98be.webp"
"MediaSize" => 121755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-b37a561c582b86436c42f40d337e98be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362888483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/3cc24bb6e1480f72f238d81aaf3c77d2.webp"
"MediaSize" => 104750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-3cc24bb6e1480f72f238d81aaf3c77d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362888497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ac9bd49e7a2ad4a354c2112386c1b2a8.webp"
"MediaSize" => 80319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ac9bd49e7a2ad4a354c2112386c1b2a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362888506"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/57261b344fa050a3aaea9027f750a977.webp"
"MediaSize" => 111759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-57261b344fa050a3aaea9027f750a977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362888523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/6adf6daa3ca7bf9f3b83514924c56d3f.webp"
"MediaSize" => 95878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-6adf6daa3ca7bf9f3b83514924c56d3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362888574"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/93684491135852b5d242592b807d1ed7.webp"
"MediaSize" => 106617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-93684491135852b5d242592b807d1ed7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6362888589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/8eb09954eab1cb4834d870e36118028a.webp"
"MediaSize" => 95570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-8eb09954eab1cb4834d870e36118028a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6362888604"
…11
]
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174288')"
+"ID": "470906"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "468273"
+post_author: 1
+"ListingKey": "29169820"
+"ListingId": "X12608304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T19:25:23Z"
+"RFModificationTimestamp": "2025-12-07T22:51:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "BASEMENT - 7 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8831437
1 => 43.3349547
]
+"Latitude": 43.3349547
+"Longitude": -79.8831437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully renovated, this bright and spacious 2 bed, 1 bath basement apartment features a private entrance and a prime location in Waterdown, just minutes from parks, major highways, downtown Burlington, and the lake. Enjoy the convenience of a Ensuite laundry room, driveway parking for one vehicle, and ample street parking. Located close to Aldershot GO Station for easy commuting. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-07T22:51:07.326532+00:00"
+"Directions": "Dundas & Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157654"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "11.9 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-07T19:17:30Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T19:17:30Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169820/basement-7-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1529658"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "84654"
+"GeocodeManualYN": false
+"TotalActualRent": 2150
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 11.9
+"OriginalEntryTimestamp": "2025-12-07T19:17:30.06Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169820')"
+"ID": "468273"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "465887"
+post_author: 1
+"ListingKey": "29167450"
+"ListingId": "X12605800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T19:30:29Z"
+"RFModificationTimestamp": "2025-12-08T19:36:06Z"
+"ListPrice": 734000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T1"
+"UnparsedAddress": "154 TRUEDELL CIRCLE, Hamilton (Waterdown), Ontario L8B0T1"
+"Coordinates": array:2 [
0 => -79.9070855
1 => 43.3377516
]
+"Latitude": 43.3377516
+"Longitude": -79.9070855
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Carpet-Free Freehold Townhome on a Quiet Cul-de-Sac! Rare opportunity to own a freehold townhouse with no maintenance fees in one of Waterdown's most desirable neighborhoods. This elegantly updated home features solid oak stairs spanning all three levels, and a bright, spacious layout perfect for modern living. Enjoy a large open-concept kitchen with stainless steel appliances and plenty of counter space- ideal for cooking and entertaining. The inviting living and dining areas offer seamless flow and abundant natural light. Step outside to a huge covered deck, perfect for year-round BBQs and gatherings with family and friends. Upstairs, the oversized primary bedroom boasts a large walk-in closet and convenient Ensuite access. Additional highlights include a modern washer and dryer, 1-car garage and 2-car driveway, providing excellent parking for guests. Located just minutes from shopping, banks, restaurants, Hwy 6, Mapleview, Costco and IKEA - this home offers comfort, convenience and truly move-in-ready lifestyle. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Garage door opener"
2 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T22:59:07.141069+00:00"
+"Directions": "Hamilton St/Nisbet/Truedell"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1882220"
+"ListOfficeKey": "50479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "19.7 x 51.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T19:20:03Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T19:20:03Z"
+"Stories": "3.0"
+"StreetName": "Truedell"
+"StreetNumber": "154"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "4380.37"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29167450/154-truedell-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-12-05T21:21:07.93Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167450')"
+"ID": "465887"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+post_id: "465641"
+post_author: 1
+"ListingKey": "29165840"
+"ListingId": "X12604156"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:55:38Z"
+"RFModificationTimestamp": "2025-12-07T21:59:30Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S5"
+"UnparsedAddress": "24 MACBEAN CRESCENT, Hamilton (Waterdown), Ontario L8B0S5"
+"Coordinates": array:2 [
0 => -79.9148351
1 => 43.3358708
]
+"Latitude": 43.3358708
+"Longitude": -79.9148351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 24 Macbean Crescent where elegance meets sophistication, a testament to the ultimate design in every detail. This meticulously maintained 2 Storey home with a gorgeous exterior facade and a double car garage will have you falling in love, not to mention the professionally installed stamped concrete front porch and steps (2021). Over 3000 sq ft of finished living space, 4 spacious bedrooms, 5 updated bathrooms, it truly offers all that you desire! As you enter the home through the upgraded front entrance door (2020), you will appreciate the bright and open foyer with lovely floor tiles (2019) and custom built in cabinets. Next is the luxurious living room, the shiny and bright pot lights that complement the coffered ceilings so seamlessly to the opulent brick veneer wall (2022) and custom built in cabinetry for those memorable family photos. Let's make our way to the exquisite kitchen (2019) with gorgeous cabinetry and cedar stone countertops to add that unique touch. With newer appliances, stylish fixtures, an oversized kitchen island and large sliding doors that lead to the backyard, what more could you ask for? Speaking of the backyard, check that oasis out. Some notable features are the canopy awning (2023) and the exposed aggregate concrete (2023). As we head upstairs you will appreciate that the carpets have been removed & replaced with newer flooring in all the bedrooms. There are 4 spacious bedrooms & 3 bathrooms. Two of the bedrooms have updated ensuites. The primary bedroom has a huge walk-in closet and a 5pc ensuite! All the bedrooms have CUSTOM closet organizers (2023) that were specifically designed for each closet. WOW! The finished basement (2019) provides a kitchenette, a 3-pc bathroom, family area for those get-togethers, and a spacious room that could be used as a gym or office, you decide! This beautiful home is within steps to the conservation area and parks. All other amenities are conveniently located near you. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T20:08:14.985128+00:00"
+"Directions": "Cross Streets: Macbean & Nisbet. ** Directions: PARKSIDE DR., WINBERLEY AVE, NISBET BLVD, MACBEAN."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238085"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 88.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T16:25:12Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:41:19Z"
+"Stories": "2.0"
+"StreetName": "Macbean"
+"StreetNumber": "24"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8735.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29165840/24-macbean-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2025-12-05T16:25:12.31Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165840')"
+"ID": "465641"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24989
+post_id: "465136"
+post_author: 1
+"ListingKey": "29165443"
+"ListingId": "40792547"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:26:03Z"
+"RFModificationTimestamp": "2025-12-07T21:28:21Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2814.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0S5"
+"UnparsedAddress": "24 MACBEAN Crescent, Waterdown, Ontario L8B0S5"
+"Coordinates": array:2 [
0 => -79.9138217
1 => 43.3358699
]
+"Latitude": 43.3358699
+"Longitude": -79.9138217
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 24 Macbean Crescent where elegance meets sophistication, a testament to the ultimate design in every detail. This meticulously maintained 2 Storey home with a gorgeous exterior facade and a double car garage will have you falling in love, not to mention the professionally installed stamped concrete front porch and steps (2021). Over 3000 sq ft of finished living space, 4 spacious bedrooms, 5 updated bathrooms, it truly offers all that you desire! As you enter the home through the upgraded front entrance door (2020), you will appreciate the bright and open foyer with lovely floor tiles (2019) and custom built in cabinets. Next is the luxurious living room, the shiny and bright pot lights that complement the coffered ceilings so seamlessly to the opulent brick veneer wall (2022) and custom built in cabinetry for those memorable family photos. Let’s make our way to the exquisite kitchen (2019) with gorgeous cabinetry and cedar stone countertops to add that unique touch. With newer appliances, stylish fixtures, an oversized kitchen island and large sliding doors that lead to the backyard, what more could you ask for? Speaking of the backyard, check that oasis out. Some notable features are the canopy awning (2023) and the exposed aggregate concrete (2023). As we head upstairs you will appreciate that the carpets have been removed & replaced with newer flooring in all the bedrooms. There are 4 spacious bedrooms & 3 bathrooms. Two of the bedrooms have updated ensuites. The primary bedroom has a huge walk-in closet and a 5pc ensuite! All the bedrooms have CUSTOM closet organizers (2023) that were specifically designed for each closet. WOW! The finished basement (2019) provides a kitchenette, a 3-pc bathroom, family area for those get-togethers, and a spacious room that could be used as a gym or office, you decide! This beautiful home is within steps to the conservation area and parks. All other amenities are conveniently located near you. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T17:14:21.584969+00:00"
+"Directions": "PARKSIDE DR., WINBERLEY AVE, NISBET BLVD, MACBEAN"
+"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": "2159089"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T15:08:43Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:11:27Z"
+"Stories": "2.0"
+"StreetName": "MACBEAN"
+"StreetNumber": "24"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8735.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29165443/24-macbean-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-31"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2814
+"OriginalEntryTimestamp": "2025-12-05T15:08:43.47Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165443')"
+"ID": "465136"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "464308"
+post_author: 1
+"ListingKey": "29164823"
+"ListingId": "X12603202"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T01:55:24Z"
+"RFModificationTimestamp": "2025-12-05T03:38:03Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.886026
1 => 43.331229
]
+"Latitude": 43.331229
+"Longitude": -79.886026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. Potential to assemble with property next door. VTB FINANCING AVAILABLE. Consider the possibilities for your dream home or as an investment. (id:62650)"
+"CreationDate": "2025-12-05T03:37:47.851068+00:00"
+"Directions": "Cross Streets: Dundas Street. ** Directions: Mill St. S. is Waterdown Rd. south of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "61.88 x 124 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T01:47:01Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T01:47:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3773"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29164823/191-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 61.1
+"OriginalEntryTimestamp": "2025-12-05T01:47:01.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29164823')"
+"ID": "464308"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23674
+post_id: "463014"
+post_author: 1
+"ListingKey": "29161684"
+"ListingId": "40792230"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T15:05:56Z"
+"RFModificationTimestamp": "2025-12-04T21:13:14Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.428
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL Street S, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8859059
1 => 43.3312732
]
+"Latitude": 43.3312732
+"Longitude": -79.8859059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. VTB FINANCING AVAILABLE. Newly severed Lot. Consider the possibilities for your dream home or as an investment. Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-04T21:12:51.956561+00:00"
+"Directions": "Mill St. S. is Waterdown Rd., S of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "284639"
+"LotSizeDimensions": "0.428"
+"PhotosChangeTimestamp": "2025-12-04T14:59:58Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T14:59:57Z"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3773"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161684/191-mill-street-s-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "O1, CM"
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2025-12-04T14:59:57.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161684')"
+"ID": "463014"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "463015"
+post_author: 1
+"ListingKey": "29161927"
+"ListingId": "40791925"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T19:40:25Z"
+"RFModificationTimestamp": "2025-12-09T19:42:39Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1682.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "383 DUNDAS Street E Unit# 21, Waterdown, Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.8875746
1 => 43.3386557
]
+"Latitude": 43.3386557
+"Longitude": -79.8875746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown’s family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:40:54.576685+00:00"
+"Directions": "Dundas St E to complex."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:00:37Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T19:28:54Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4053.09"
+"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"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161927/383-dundas-street-e-unit-21-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2059038"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "HC-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1682
+"OriginalEntryTimestamp": "2025-12-04T16:00:37.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161927')"
+"ID": "463015"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "463016"
+post_author: 1
+"ListingKey": "29161992"
+"ListingId": "40792282"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T21:40:21Z"
+"RFModificationTimestamp": "2025-12-06T21:44:46Z"
+"ListPrice": 1388000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3029.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "20 VINEGAR Hill, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8900722
1 => 43.3362821
]
+"Latitude": 43.3362821
+"Longitude": -79.8900722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional 3,000+ sq ft custom-built 4-bedroom home on a rare 60-foot-wide lot in one of Waterdown's most desirable neighbourhoods. Just a 4-minute stroll to Waterdown's historic village and downtown amenities, this property showcases quality craftsmanship, a thoughtful floor plan, and features that set it apart from a standard subdivision home. The main level offers a spacious formal living/dining room, a dedicated den/home office, a large eat-in kitchen with high-end appliances, and an inviting family room filled with natural light. Upstairs, you'll find four oversized bedrooms, including a primary suite with a walk-in closet and 5-pc ensuite. The second bedroom also includes its own private 4-pc ensuite - an ideal setup for multigenerational living. A skylit landing and walkout to a charming balcony add distinctive architectural character. Excellent versatility continues on the lower level, with two staircases and a separate entrance, offering potential for an in-law suite, teen retreat, or income-generating unit. Perfectly located within walking distance to Waterdown's historic village and local conveniences, and just minutes from the Bruce Trail, Smokey Hollow Waterfall, parks, and scenic ravine paths. Easy access to major highways and Aldershot GO Station. A rare opportunity on a street where homes seldom come to market. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:02:18.932559+00:00"
+"Directions": "Dundas St & Vinegar Hill"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:11:05Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T21:29:16Z"
+"Stories": "2.0"
+"StreetName": "VINEGAR"
+"StreetNumber": "20"
+"StreetSuffix": "Hill"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7324"
+"VirtualTourURLUnbranded": "https://youtu.be/TeI63sfVOxE"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161992/20-vinegar-hill-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 3029
+"OriginalEntryTimestamp": "2025-12-04T16:09:19.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:41 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161992')"
+"ID": "463016"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 125
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]