array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29887232 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23339
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23341
+post_id: "1520592"
+post_author: 1
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:05:09Z"
+"RFModificationTimestamp": "2026-06-11T16:34:04Z"
+"ListPrice": 1589000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "194 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.901709
1 => 43.325096
]
+"Latitude": 43.325096
+"Longitude": -79.901709
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to charming Waterdown where this estate style property feels like the country but has all the perks of in-town-living! This raised bungalow features over 2600 square feet of finished living space with 5 bedrooms and 3 bathrooms combined on both levels. Tons of room for a growing family or set it up with a nanny/income suite in the lower level with a separate walk out to the backyard. Sitting on over half an acre, you've got excellent space to play and entertain. Fully fenced backyard with saltwater inground pool, deck and gas bbq line. Invite all your friends because there's parking for 15 vehicles! Recent upgrades include basement flooring with R4 thermal subfloor (2026), furnace (2025), upper front windows (2024), main bath (2022), ensuite (2022), roof (2022). Please see the attached feature sheet for a complete list of features and upgrades. Fireplace not currently operational. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:33:51.597596+00:00"
+"Directions": "Cross Streets: Dundas/Hamilton. ** Directions: On the south side of Dundas just east of Riley."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004228"
+"ListOfficeKey": "285613"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Sloping"
1 => "Flat site"
2 => "Carpet Free"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "110.4 x 207.4 FT ; 110.44 x 207.42 x 110.21 x 214.83"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T11:35:12Z"
+"PhotosCount": 42
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:56:47Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "194"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9299.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/194_dundas_street_east_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1657127829"
"RoomType" => "Living room"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 5.7
"ListingKey" => "29887232"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
1 => array:11 [
"RoomKey" => "1657127830"
"RoomType" => "Dining room"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29887232"
"RoomLength" => 3.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
2 => array:11 [
"RoomKey" => "1657127831"
"RoomType" => "Kitchen"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 4.53
"ListingKey" => "29887232"
"RoomLength" => 3.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
3 => array:11 [
"RoomKey" => "1657127832"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 4.24
"ListingKey" => "29887232"
"RoomLength" => 3.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
4 => array:11 [
"RoomKey" => "1657127833"
"RoomType" => "Bedroom 2"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 3.01
"ListingKey" => "29887232"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
5 => array:11 [
"RoomKey" => "1657127834"
"RoomType" => "Bedroom 3"
"ListingId" => "X13429762"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29887232"
"RoomLength" => 2.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
6 => array:11 [
"RoomKey" => "1657127835"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13429762"
"RoomLevel" => "Lower level"
"RoomWidth" => 6.83
"ListingKey" => "29887232"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
7 => array:11 [
"RoomKey" => "1657127836"
"RoomType" => "Kitchen"
"ListingId" => "X13429762"
"RoomLevel" => "Lower level"
"RoomWidth" => 5.12
"ListingKey" => "29887232"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
8 => array:11 [
"RoomKey" => "1657127837"
"RoomType" => "Bedroom 4"
"ListingId" => "X13429762"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.86
"ListingKey" => "29887232"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
9 => array:11 [
"RoomKey" => "1657127838"
"RoomType" => "Bedroom 5"
"ListingId" => "X13429762"
"RoomLevel" => "Lower level"
"RoomWidth" => 5.12
"ListingKey" => "29887232"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T15:56:47.98Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29887232/194-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1841558"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285613"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.4
+"OriginalEntryTimestamp": "2026-06-11T11:35:11.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287388"
+"ListOfficeNationalAssociationId": "1352696"
+"CoListAgentNationalAssociationId": "1197719"
+"CoListOfficeNationalAssociationId": "1352696"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29887232_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/884dc250256fb8fe237746478ff3c951.webp"
"MediaSize" => 217551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-884dc250256fb8fe237746478ff3c951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29887232_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/7b1d7d9a4d5c75bb0dca7c59115516f4.webp"
"MediaSize" => 188598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-7b1d7d9a4d5c75bb0dca7c59115516f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29887232_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/35d089ea8e600f79b674d00bd7774a0d.webp"
"MediaSize" => 229469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-35d089ea8e600f79b674d00bd7774a0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29887232_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/785d9e9d6b7d0c670345cccc6b7f68af.webp"
"MediaSize" => 113653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-785d9e9d6b7d0c670345cccc6b7f68af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29887232_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/310439625829dba25c39de30eee3540d.webp"
"MediaSize" => 123100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-310439625829dba25c39de30eee3540d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29887232_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/4f138db97afa4bbf7aaee7d2e122054f.webp"
"MediaSize" => 114320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-4f138db97afa4bbf7aaee7d2e122054f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29887232_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/5abf292e036714a8e25934d99e9e7c9c.webp"
"MediaSize" => 109801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-5abf292e036714a8e25934d99e9e7c9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29887232_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/bbe98cd4d600ec069d4d297c84692503.webp"
"MediaSize" => 103984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-bbe98cd4d600ec069d4d297c84692503.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29887232_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/4346b5b9b9b4ecd0f7dc3c4459b47355.webp"
"MediaSize" => 130663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-4346b5b9b9b4ecd0f7dc3c4459b47355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29887232_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/40eca0dcf22a439a40dc6f7fd19fd122.webp"
"MediaSize" => 118313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-40eca0dcf22a439a40dc6f7fd19fd122.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29887232_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/225effe339c9695a1bb018d891ba17e2.webp"
"MediaSize" => 122282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-225effe339c9695a1bb018d891ba17e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29887232_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/851d7a9c63b371315039d9e0a2ec35ad.webp"
"MediaSize" => 99007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-851d7a9c63b371315039d9e0a2ec35ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29887232_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/9be677b7b4ce4f9255a99fc73ea4d82c.webp"
"MediaSize" => 116601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-9be677b7b4ce4f9255a99fc73ea4d82c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29887232_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/d6842203498af4b9405b52e0a81292da.webp"
"MediaSize" => 107353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-d6842203498af4b9405b52e0a81292da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29887232_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/0db6c0f1b4ae965e858bdec573026461.webp"
"MediaSize" => 98749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-0db6c0f1b4ae965e858bdec573026461.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29887232_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/d4fbaa76a7bdf6fc865360ef9181134c.webp"
"MediaSize" => 95951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-d4fbaa76a7bdf6fc865360ef9181134c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29887232_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/4eb06f9a4c9f6c679f55bcecde0afbff.webp"
"MediaSize" => 88693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-4eb06f9a4c9f6c679f55bcecde0afbff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29887232_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/0893d9f78c9b24cef661cb3b2ed9dcf1.webp"
"MediaSize" => 102258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-0893d9f78c9b24cef661cb3b2ed9dcf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29887232_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/c00b77a42ebfc1a5a0a47210224735df.webp"
"MediaSize" => 95404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-c00b77a42ebfc1a5a0a47210224735df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29887232_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/5ec3dbe6ae3fc31949a0c5b40bf33612.webp"
"MediaSize" => 93196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-5ec3dbe6ae3fc31949a0c5b40bf33612.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29887232_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/2c405b9989d60acf0f3f24f854773625.webp"
"MediaSize" => 89037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-2c405b9989d60acf0f3f24f854773625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29887232_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/009243e7cbdc306d3e8bc642ead9526a.webp"
"MediaSize" => 103085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-009243e7cbdc306d3e8bc642ead9526a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29887232_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/daf26c1749eb148230b2f1bdfe034144.webp"
"MediaSize" => 96451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-daf26c1749eb148230b2f1bdfe034144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29887232_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/3cdafd3d0db6f78cbb99455eb15592a3.webp"
"MediaSize" => 96972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-3cdafd3d0db6f78cbb99455eb15592a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29887232_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/e8fdd22f2e8cec53fe12294514945126.webp"
"MediaSize" => 110272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-e8fdd22f2e8cec53fe12294514945126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29887232_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/2f6e26ff0f17c012bfad535289c8d6d7.webp"
"MediaSize" => 103059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-2f6e26ff0f17c012bfad535289c8d6d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29887232_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/0078836536d38ec0b956926d293621c2.webp"
"MediaSize" => 100064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-0078836536d38ec0b956926d293621c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29887232_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/cdd34973b1accc2a7b4070b4dd82918c.webp"
"MediaSize" => 94684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-cdd34973b1accc2a7b4070b4dd82918c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29887232_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/c09ad8043f1596682085ed6e9bb05934.webp"
"MediaSize" => 85105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-c09ad8043f1596682085ed6e9bb05934.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29887232_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/bdbcd2dd3d76c19ae855b1c4a93da8e9.webp"
"MediaSize" => 83921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-bdbcd2dd3d76c19ae855b1c4a93da8e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29887232_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/8166d62808ed61b5a9192cb77e6e92d8.webp"
"MediaSize" => 89056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-8166d62808ed61b5a9192cb77e6e92d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29887232_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/16ff90438ab12f04951234e7d3d2edc9.webp"
"MediaSize" => 102775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-16ff90438ab12f04951234e7d3d2edc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29887232_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/44cedcbbb9e998f0ac126f60892f1614.webp"
"MediaSize" => 175549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-44cedcbbb9e998f0ac126f60892f1614.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29887232_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/7c8a9bdb1da3dfdf17c2af42afd1eadc.webp"
"MediaSize" => 197246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-7c8a9bdb1da3dfdf17c2af42afd1eadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29887232_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/28664d7a98a2f02435eda42a893065dd.webp"
"MediaSize" => 211207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-28664d7a98a2f02435eda42a893065dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29887232_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/448d0775c3ec356771c251823f56798e.webp"
"MediaSize" => 236428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-448d0775c3ec356771c251823f56798e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29887232_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/08758998d4adf15f6347df7687bbb792.webp"
"MediaSize" => 210834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-08758998d4adf15f6347df7687bbb792.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29887232_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/4af18e133d6655009b4cb532cf1e3f78.webp"
"MediaSize" => 218750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-4af18e133d6655009b4cb532cf1e3f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29887232_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/8244ad8c0d67896ffa3d47593e07a33e.webp"
"MediaSize" => 237607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-8244ad8c0d67896ffa3d47593e07a33e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29887232_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/a182adc357788f29019fa0770f9f4a39.webp"
"MediaSize" => 203137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-a182adc357788f29019fa0770f9f4a39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29887232_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/268cf6232797a2b1d7de31c54ad3cd0c.webp"
"MediaSize" => 232626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-268cf6232797a2b1d7de31c54ad3cd0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29887232_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887232/2f4ba4820d5ed28ac1da7723f67d889d.webp"
"MediaSize" => 221888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887232/thumbnail-2f4ba4820d5ed28ac1da7723f67d889d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429762"
"ResourceRecordKey" => "29887232"
"ModificationTimestamp" => "2026-06-11T11:35:11.98Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887232')"
+"ID": "1520592"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285613" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24788
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2004228" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24764
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29887232'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25107
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29887232'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31428193"
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T17:58:16Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31428193')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31428192"
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T17:58:16Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31428192')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29887232' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.901709 43.325096)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25145
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
+post_id: "1524109"
+post_author: 1
+"ListingKey": "29896100"
+"ListingId": "X13437788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T18:40:09Z"
+"RFModificationTimestamp": "2026-06-12T18:44:46Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "36 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907654
1 => 43.328335
]
+"Latitude": 43.328335
+"Longitude": -79.907654
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to own a detached 3-bedroom family home in one of Waterdown's most sought-after neighbourhoods. Located directly across from Guy B. Brown Elementary School, a highly regarded school offering a French Immersion program, this home is perfect for young families looking to put down roots in a fantastic community.Offering solid bones and endless potential, this property is an ideal opportunity for buyers looking to renovate, personalize, and build equity in their forever home. Enjoy a family-friendly location, and the chance to create a space that truly reflects your style and needs.Conveniently located close to parks, trails, shopping, restaurants, and all the amenities Waterdown has to offer, this is your chance to get into a detached home in a premium location for under $800,000. Don't miss this incredible opportunity to unlock the potential of this family home and make it your own (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:24:02.957529+00:00"
+"Directions": "Cross Streets: Parkside Dr. ** Directions: Parkside Drive to Braeheid Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024918"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:38Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T18:33:48Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "36"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5126"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/36-Braeheid-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1657888103"
"RoomType" => "Kitchen"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29896100"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
1 => array:11 [
"RoomKey" => "1657888104"
"RoomType" => "Dining room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
2 => array:11 [
"RoomKey" => "1657888105"
"RoomType" => "Living room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29896100"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
3 => array:11 [
"RoomKey" => "1657888106"
"RoomType" => "Laundry room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29896100"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
4 => array:11 [
"RoomKey" => "1657888107"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29896100"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
5 => array:11 [
"RoomKey" => "1657888108"
"RoomType" => "Bedroom 2"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
6 => array:11 [
"RoomKey" => "1657888109"
"RoomType" => "Bedroom 3"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29896100"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
7 => array:11 [
"RoomKey" => "1657888110"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13437788"
"RoomLevel" => "Basement"
"RoomWidth" => 5.49
"ListingKey" => "29896100"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
8 => array:11 [
"RoomKey" => "1657888111"
"RoomType" => "Den"
"ListingId" => "X13437788"
"RoomLevel" => "Basement"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896100/36-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-06-12T17:01:38.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304615"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29896100_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/4ad1c2a26f57e9170fe1a82b6686021d.webp"
"MediaSize" => 339607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-4ad1c2a26f57e9170fe1a82b6686021d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29896100_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/302b04d97d179c9fd20bd4139416f4cf.webp"
"MediaSize" => 289259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-302b04d97d179c9fd20bd4139416f4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29896100_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/b065fb1d32ef425ddcfc14447872e3e2.webp"
"MediaSize" => 145928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-b065fb1d32ef425ddcfc14447872e3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29896100_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/be6bc53cf7ddb714f33ee06a34a478b0.webp"
"MediaSize" => 134599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-be6bc53cf7ddb714f33ee06a34a478b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896100')"
+"ID": "1524109"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
+post_id: "1523612"
+post_author: 1
+"ListingKey": "29895204"
+"ListingId": "40838264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:00:11Z"
+"RFModificationTimestamp": "2026-06-12T17:02:11Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "36 BRAEHEID Avenue, Waterdown, Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.9072948
1 => 43.3279506
]
+"Latitude": 43.3279506
+"Longitude": -79.9072948
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing opportunity to own a detached 3-bedroom, 2.5 bath family home in one of Waterdown's most sought-after neighbourhoods. Located directly across from Guy B. Brown Elementary School, a highly regarded school offering a French Immersion program, this home is perfect for young families looking to put down roots in a fantastic community.Offering solid bones and endless potential, this property is an ideal opportunity for buyers looking to renovate, personalize, and build equity in their forever home. Enjoy a family-friendly location, and the chance to create a space that truly reflects your style and needs.Conveniently located close to parks, trails, shopping, restaurants, and all the amenities Waterdown has to offer, this is your chance to get into a detached home in a premium location for under $800,000. Don't miss this incredible opportunity to unlock the potential of this family home and make it your own (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Central Vacuum - Roughed In"
8 => "Wet Bar"
9 => "Hood Fan"
10 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T16:26:08.539471+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991807"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T16:32:55Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:52:00Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "36"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5126"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/36-Braeheid-Ave"
+"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/29895204/36-braeheid-avenue-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1435
+"OriginalEntryTimestamp": "2026-06-12T15:31:50.93Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1275275"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895204')"
+"ID": "1523612"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
+post_id: "1522007"
+post_author: 1
+"ListingKey": "29891787"
+"ListingId": "40839144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:45:04Z"
+"RFModificationTimestamp": "2026-06-12T01:28:39Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 33, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9069775
1 => 43.3380781
]
+"Latitude": 43.3380781
+"Longitude": -79.9069775
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and stylish townhome featuring low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral décor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:27:27.209917+00:00"
+"Directions": "Hamilton St N to Nisbet Blvd, right into complex"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933651"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:39:39Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:39:39Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29891787/54-nisbet-boulevard-unit-33-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1408
+"OriginalEntryTimestamp": "2026-06-11T20:39:39.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1233597"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891787')"
+"ID": "1522007"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+post_id: "1522009"
+post_author: 1
+"ListingKey": "29892584"
+"ListingId": "X13434636"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:25:10Z"
+"RFModificationTimestamp": "2026-06-11T22:54:34Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "33 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and stylish townhome offering low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral decor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T22:54:28.009574+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: Hamilton St N to Nisbet Blvd, right into complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2222832"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "24.2 x 53.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T22:19:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T22:19:47Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://visithome.ai/XDtEMoVHECyeZNFcEfNpdF?mu=ft"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892584/33-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.2
+"OriginalEntryTimestamp": "2026-06-11T22:19:47.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466475"
+"ListOfficeNationalAssociationId": "1274323"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892584')"
+"ID": "1522009"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25140
+post_id: "1521037"
+post_author: 1
+"ListingKey": "29891435"
+"ListingId": "X13433494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:06Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "4 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.9062491
1 => 43.3361384
]
+"Latitude": 43.3361384
+"Longitude": -79.9062491
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained freehold townhouse in sought-after Waterdown offering approximately 1470 sq. ft. of above ground finished living space. This 3-bedroom, 4-bathroom home features a bright open-concept layout with 9-ft ceilings on the main floor, a finished basement, and numerous quality upgrades throughout. Major updates include new basement/staircase carpeting (2021); kitchen countertops, backsplash, sinks, faucets, microwave, bathroom countertops, sinks and faucets, primary ensuite glass shower door, pot lights throughout the main and second floors, basement light fixtures, automated garage door opener, and humidifier (2022); new furnace, water softener, drinking water filtration system, and smart door lock (2023); plus a smart thermostat and Google video doorbell (2020).The functional layout offers spacious principal rooms, a modernized kitchen with ample cabinetry and workspace, and a finished lower level ideal for recreation, work-from-home space, or extended family living. Attached garage and private driveway parking add everyday convenience. Ideally located close to schools, the YMCA, Park, playgrounds, public transit, and a full-service shopping plaza featuring Fortinos, Tim Hortons, McDonald's, restaurants, daycare services, family medical and dental offices, convenience stores, and more. Move-in ready and thoughtfully updated, this home offers exceptional comfort, convenience, and value in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Humidifier"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:54.750046+00:00"
+"Directions": "Parkside Dr/Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072378"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 100.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:52Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:52Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://homes.motionstudio.ca/listings/DsjdOGEOX8hCTJ3iwqUy/website/basic/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891435/4-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2190178"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2130691"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "282777"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:52.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347560"
+"ListOfficeNationalAssociationId": "1321336"
+"CoListAgentNationalAssociationId": "1439294"
+"CoListAgentNationalAssociationId2": "1383597"
+"CoListOfficeNationalAssociationId": "1470118"
+"CoListOfficeNationalAssociationId2": "1321336"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25135
+post_id: "1521038"
+post_author: 1
+"ListingKey": "29889732"
+"ListingId": "X13432108"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:35:13Z"
+"RFModificationTimestamp": "2026-06-11T19:14:32Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V6"
+"UnparsedAddress": "156 GUNBY BOULEVARD, Hamilton (Waterdown), Ontario L8B0V6"
+"Coordinates": array:2 [
0 => -79.917048
1 => 43.330745
]
+"Latitude": 43.330745
+"Longitude": -79.917048
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 156 Gunby Blvd, a move in ready all brick detached home located in a highly desirable neighbourhood. From the moment you arrive, you'll appreciate the home's inviting curb appeal and well-maintained exterior. Step inside to discover a thoughtfully designed layout featuring 9-foot ceilings on the main level, a stunning solid wood staircase, and an abundance of natural light throughout.The spacious kitchen is ideal for both everyday living and entertaining, offering built-in oven and microwave and stainless steel appliances, quartz countertops, a large centre island with breakfast bar, and seamless flow into the welcoming family room complete with a cozy fireplace. A convenient laundry/mudroom provides direct access to the double-car garage.Upstairs, you'll find three generously sized bedrooms and two full bathrooms, including a spacious primary retreat featuring a walk-in closet and ensuite privileges.The bright, fully finished basement expands your living space with large windows, an open-concept recreation room, a 3-piece bathroom with stand-up shower, and a versatile bonus room perfect for guests, a home office, or extended family. Step outside and enjoy your private backyard oasis, complete with a large two-tier wood deck and relaxing hot tub-perfect for entertaining or unwinding after a long day.Ideally situated close to shopping, schools, the YMCA, and major commuter routes including Highways 403, 407, and the QEW, this exceptional home offers comfort, convenience, and lifestyle all in one package. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:00:11.265398+00:00"
+"Directions": "Cross Streets: Centre Rd / Parkside. ** Directions: Parkside Dr > Mosaic Dr> Gunby Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024328"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "33 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T16:58:28Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T18:21:21Z"
+"Stories": "2.0"
+"StreetName": "Gunby"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "6608.33"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/156-gunby-boulevard-waterdown/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29889732/156-gunby-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-11T16:58:28.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304065"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889732')"
+"ID": "1521038"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23353
+post_id: "1520053"
+post_author: 1
+"ListingKey": "29888470"
+"ListingId": "X13430622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:07Z"
+"RFModificationTimestamp": "2026-06-12T07:20:20Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Rarely offered, this exceptional property delivers the feeling of cottage living in the city while offering the convenience of one of Waterdown's most sought after neighbourhoods. Situated on an incredible lot of nearly 10,000 sq. ft., this beautifully updated bungalow offers approximately 2,360 sq. ft. of finished living space with 3+2 bedrooms and 3 full bathrooms.The stunning open concept layout is anchored by a beautifully renovated kitchen featuring a massive centre island, stainless steel appliances, a 5 burner gas range, pot lights, and seamless flow into the living and dining areas. Bright, sun filled rooms throughout allow for an abundance of natural light, while updated railings, renovated closet spaces, and thoughtful improvements create a home that is both stylish and functional.The fully finished lower level offers incredible versatility with two additional bedrooms, a living area with a fireplace, and a relaxing 4 person infrared sauna for all your health/detox needs.Step outside and enjoy your own private backyard oasis. Surrounded by newer fencing for enhanced privacy, this expansive outdoor space features two gazebos, an extended patio, and a fire pit area, providing the perfect setting for entertaining, relaxing, and enjoying the outdoors.Major updates include a recently replaced roof and updated appliances within the last few years, providing peace of mind for years to come. With parking for 5 vehicles and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this move in ready home offers a lifestyle that is truly hard to find.VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:21:30.107435+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:54Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:54Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888470/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: "1517601"
+post_author: 1
+"ListingKey": "29885712"
+"ListingId": "40838647"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T22:10:06Z"
+"RFModificationTimestamp": "2026-06-11T02:18:48Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1415.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0H1"
+"UnparsedAddress": "6 WOODCROFT Crescent, Waterdown, Ontario L8B0H1"
+"Coordinates": array:2 [
0 => -79.9100683
1 => 43.3271614
]
+"Latitude": 43.3271614
+"Longitude": -79.9100683
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a beautifully maintained three-bedroom, two and a half-bathroom, five-level backsplit in one of Waterdown’s most sought-after west-end neighbourhoods, offering a perfect blend of comfort, style and versatility for modern family living. The main floor features a bright, white kitchen with quartz countertops and a French door leading to a spacious deck, ideal for outdoor dining and entertaining, along with a formal dining room with hardwood flooring, convenient main-floor laundry with garage access and a beautifully updated powder room (2026). A few steps up, the inviting living room showcases vaulted ceilings, a cozy natural gas fireplace and an open view over the kitchen and dining areas, creating a warm, light-filled atmosphere. Upstairs, the generous primary suite includes a five-piece ensuite and walk-in closet, complemented by two additional bedrooms and a refreshed four-piece main bathroom. The lower level offers large above-grade windows and a bright, flexible space currently used as a home office, perfect as well for a family room or play area, while the unfinished basement provides ample storage and potential for additional living space. Set on a fantastic pie-shaped lot (35.07 x 141.93), the oversized backyard is lined with mature cedar trees for exceptional privacy and features a large wood deck perfect for relaxing or entertaining. Situated on a quiet crescent in a family-friendly community, this home is within walking distance to schools, the YMCA, parks, shopping and everyday amenities, making it an exceptional opportunity for anyone seeking both convenience and lifestyle. Don’t be TOO LATE*! *REG TM. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T02:18:40.740911+00:00"
+"Directions": "HOLLYBUSH DRIVE TO RYANS WAY TO WOODCROFT CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T22:01:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T22:01:05Z"
+"Stories": "3.0"
+"StreetName": "WOODCROFT"
+"StreetNumber": "6"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5908.42"
+"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/29885712/6-woodcroft-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-1-A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1415
+"OriginalEntryTimestamp": "2026-06-10T22:01:04.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885712')"
+"ID": "1517601"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+post_id: "1517602"
+post_author: 1
+"ListingKey": "29886079"
+"ListingId": "X13428790"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T23:00:11Z"
+"RFModificationTimestamp": "2026-06-11T02:08:27Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0H1"
+"UnparsedAddress": "6 WOODCROFT CRESCENT, Hamilton (Waterdown), Ontario L8B0H1"
+"Coordinates": array:2 [
0 => -79.910071
1 => 43.327197
]
+"Latitude": 43.327197
+"Longitude": -79.910071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a beautifully maintained three-bedroom, two and a half-bathroom, five-level backsplit in one of Waterdown's most sought-after west-end neighbourhoods, offering a perfect blend of comfort, style and versatility for modern family living. The main floor features a bright, white kitchen with quartz countertops and a French door leading to a spacious deck, ideal for outdoor dining and entertaining, along with a formal dining room with hardwood flooring, convenient main-floor laundry with garage access and a beautifully updated powder room (2026). A few steps up, the inviting living room showcases vaulted ceilings, a cozy natural gas fireplace and an open view over the kitchen and dining areas, creating a warm, light-filled atmosphere. Upstairs, the generous primary suite includes a five-piece ensuite and walk-in closet, complemented by two additional bedrooms and a refreshed four-piece main bathroom. The lower level offers large above-grade windows and a bright, flexible space currently used as a home office, perfect as well for a family room or play area, while the unfinished basement provides ample storage and potential for additional living space. Set on a fantastic pie-shaped lot (35.07 x 141.93), the oversized backyard is lined with mature cedar trees for exceptional privacy and features a large wood deck perfect for relaxing or entertaining. Situated on a quiet crescent in a family-friendly community, this home is within walking distance to schools, the YMCA, parks, shopping and everyday amenities, making it an exceptional opportunity for anyone seeking both convenience and lifestyle. RSA. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T02:08:21.636219+00:00"
+"Directions": "Cross Streets: Ryans Way. ** Directions: HOLLYBUSH DR TO RYANS WAY TO WOODCROFT CRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "35.1 x 141.9 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-10T22:50:12Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T22:50:12Z"
+"StreetName": "Woodcroft"
+"StreetNumber": "6"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5908.42"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886079/6-woodcroft-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1-1-A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 35.1
+"OriginalEntryTimestamp": "2026-06-10T22:50:12.58Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886079')"
+"ID": "1517602"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 126
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]