array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29931299 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23408
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23410
+post_id: "1549761"
+post_author: 1
+"ListingKey": "29931299"
+"ListingId": "X13469334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:50:02Z"
+"RFModificationTimestamp": "2026-06-19T22:34:22Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "16 - 4 VICTORIA STREET, Hamilton (Waterdown), Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924317
1 => 43.3358632
]
+"Latitude": 43.3358632
+"Longitude": -79.8924317
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Water Heater"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:34:14.813512+00:00"
+"Directions": "Cross Streets: Mill St N and Church Street. ** Directions: Mill St N to right on Church."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972710"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:30:44Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:30:44Z"
+"Stories": "2.0"
+"StreetName": "Victoria"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6109"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1663309919"
"RoomType" => "Living room"
"ListingId" => "X13469334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29931299"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.3Z"
]
1 => array:11 [
"RoomKey" => "1663309920"
"RoomType" => "Dining room"
"ListingId" => "X13469334"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "29931299"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.3Z"
]
2 => array:11 [
"RoomKey" => "1663309921"
"RoomType" => "Kitchen"
"ListingId" => "X13469334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29931299"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.3Z"
]
3 => array:11 [
"RoomKey" => "1663309922"
"RoomType" => "Bedroom"
"ListingId" => "X13469334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.71
"ListingKey" => "29931299"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.31Z"
]
4 => array:11 [
"RoomKey" => "1663309923"
"RoomType" => "Bedroom 2"
"ListingId" => "X13469334"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29931299"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.31Z"
]
5 => array:11 [
"RoomKey" => "1663309924"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13469334"
"RoomLevel" => "Second level"
"RoomWidth" => 4.65
"ListingKey" => "29931299"
"RoomLength" => 4.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.31Z"
]
6 => array:11 [
"RoomKey" => "1663309925"
"RoomType" => "Family room"
"ListingId" => "X13469334"
"RoomLevel" => "Basement"
"RoomWidth" => 3.71
"ListingKey" => "29931299"
"RoomLength" => 5.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.31Z"
]
7 => array:11 [
"RoomKey" => "1663309926"
"RoomType" => "Office"
"ListingId" => "X13469334"
"RoomLevel" => "Basement"
"RoomWidth" => 2.77
"ListingKey" => "29931299"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:30:44.31Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931299/16-4-victoria-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T21:30:44.27Z"
+"ListAgentNationalAssociationId": "1259751"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931299_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931299/564ec5f9a5f9211b9c0de8704314e35e.webp"
"MediaSize" => 439647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931299/thumbnail-564ec5f9a5f9211b9c0de8704314e35e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13469334"
"ResourceRecordKey" => "29931299"
"ModificationTimestamp" => "2026-06-19T21:30:44.28Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931299')"
+"ID": "1549761"
}
]
+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 269164" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24827
+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 1972710" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24800
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29931299'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25100
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29931299'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29931299' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8924317 43.3358632)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25169
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1549995"
+post_author: 1
+"ListingKey": "29930842"
+"ListingId": "40841314"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:55:03Z"
+"RFModificationTimestamp": "2026-06-19T22:57:37Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2300.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "4 VICTORIA Street Unit# 16, Waterdown, Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924343
1 => 43.3359233
]
+"Latitude": 43.3359233
+"Longitude": -79.8924343
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:57:27.905655+00:00"
+"Directions": "Mill St & Dundas Street E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944754"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:32:02Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:32:02Z"
+"Stories": "2.0"
+"StreetName": "VICTORIA"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6109"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1663260747"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.45Z"
]
1 => array:11 [
"RoomKey" => "1663260748"
"RoomType" => "5pc Bathroom"
"ListingId" => "40841314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.45Z"
]
2 => array:11 [
"RoomKey" => "1663260749"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.45Z"
]
3 => array:11 [
"RoomKey" => "1663260750"
"RoomType" => "Family room"
"ListingId" => "40841314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.45Z"
]
4 => array:11 [
"RoomKey" => "1663260751"
"RoomType" => "Office"
"ListingId" => "40841314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
5 => array:11 [
"RoomKey" => "1663260752"
"RoomType" => "Bedroom"
"ListingId" => "40841314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
6 => array:11 [
"RoomKey" => "1663260753"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
7 => array:11 [
"RoomKey" => "1663260754"
"RoomType" => "Bedroom"
"ListingId" => "40841314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
8 => array:11 [
"RoomKey" => "1663260755"
"RoomType" => "Living room"
"ListingId" => "40841314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
9 => array:11 [
"RoomKey" => "1663260756"
"RoomType" => "Dining room"
"ListingId" => "40841314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.46Z"
]
10 => array:11 [
"RoomKey" => "1663260757"
"RoomType" => "Kitchen"
"ListingId" => "40841314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930842"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:02.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930842/4-victoria-street-unit-16-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1700
+"BelowGradeFinishedArea": 600
+"OriginalEntryTimestamp": "2026-06-19T20:32:02.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1303128"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930842_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930842/8d20617f40b327cbbd37465c09613810.webp"
"MediaSize" => 182030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930842/thumbnail-8d20617f40b327cbbd37465c09613810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841314"
"ResourceRecordKey" => "29930842"
"ModificationTimestamp" => "2026-06-19T20:32:02.42Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930842')"
+"ID": "1549995"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: "1547964"
+post_author: 1
+"ListingKey": "29928453"
+"ListingId": "X13466818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:40:11Z"
+"RFModificationTimestamp": "2026-06-19T17:43:02Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "404 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "523.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-19T16:57:01.019811+00:00"
+"Directions": "Cross Streets: Riverwalk Dr. ** Directions: Dundas to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106841"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:09Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:34:04Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2988"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663068577"
"RoomType" => "Bedroom"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "29928453"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
1 => array:11 [
"RoomKey" => "1663068578"
"RoomType" => "Bathroom"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29928453"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
2 => array:11 [
"RoomKey" => "1663068579"
"RoomType" => "Living room"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29928453"
"RoomLength" => 5.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
3 => array:11 [
"RoomKey" => "1663068580"
"RoomType" => "Kitchen"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29928453"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
4 => array:11 [
"RoomKey" => "1663068581"
"RoomType" => "Laundry room"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29928453"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928453/404-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential Ontario"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T15:59:09.75Z"
+"ListAgentNationalAssociationId": "1375881"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:19 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29928453_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/1aa50504cde0b3ae3ff957121740e732.webp"
"MediaSize" => 147680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-1aa50504cde0b3ae3ff957121740e732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928453_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/2f37d6df72d21908c85571edaadce8d2.webp"
"MediaSize" => 104192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-2f37d6df72d21908c85571edaadce8d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928453_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/45c26f47551100d49b50f67e1a981140.webp"
"MediaSize" => 112275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-45c26f47551100d49b50f67e1a981140.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928453_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/2abd60bb2bf5ac6d4fc16fb318769971.webp"
"MediaSize" => 121429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-2abd60bb2bf5ac6d4fc16fb318769971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928453_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/c10093c3f6a84c8c41e44e4599c33c90.webp"
"MediaSize" => 165748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-c10093c3f6a84c8c41e44e4599c33c90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928453_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/a1a621798c076f28ced3d0d09a4175cf.webp"
"MediaSize" => 143703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-a1a621798c076f28ced3d0d09a4175cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928453_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/b1dc6be592094a93e281154bef928b25.webp"
"MediaSize" => 177292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-b1dc6be592094a93e281154bef928b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928453_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/648be71e9bdb34230b8e1529e576cc30.webp"
"MediaSize" => 104571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-648be71e9bdb34230b8e1529e576cc30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928453_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/44898e735f0ac185860610cd34315cf2.webp"
"MediaSize" => 113386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-44898e735f0ac185860610cd34315cf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928453_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/72c5db5af37734da4f4d68ae8900d58e.webp"
"MediaSize" => 66554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-72c5db5af37734da4f4d68ae8900d58e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928453_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/79fefd26283662a1ca4feab5cfacaf62.webp"
"MediaSize" => 50705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-79fefd26283662a1ca4feab5cfacaf62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928453_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/53edd291dfb53056d96a3e42b649d279.webp"
"MediaSize" => 116076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-53edd291dfb53056d96a3e42b649d279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928453_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/d16bac0b8a0e3735c702386cfef3e3e4.webp"
"MediaSize" => 123218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-d16bac0b8a0e3735c702386cfef3e3e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928453_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/e7a880394b3c4877f4d835ad14741222.webp"
"MediaSize" => 138785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-e7a880394b3c4877f4d835ad14741222.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928453_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/d96604aa3c3f5b6b3e420c2cee3731c5.webp"
"MediaSize" => 110583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-d96604aa3c3f5b6b3e420c2cee3731c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928453_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/634611fa0ba0fd51c0d8ecb1140adae9.webp"
"MediaSize" => 132175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-634611fa0ba0fd51c0d8ecb1140adae9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928453_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/1df6e42ba68b998e7630622ffd93e4d1.webp"
"MediaSize" => 115492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-1df6e42ba68b998e7630622ffd93e4d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928453_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/d57a60018e4a73f1ab90745e18a0f12d.webp"
"MediaSize" => 124387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-d57a60018e4a73f1ab90745e18a0f12d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928453_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928453/0240ec60bf8860e8e7187fca361e8984.webp"
"MediaSize" => 139708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928453/thumbnail-0240ec60bf8860e8e7187fca361e8984.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466818"
"ResourceRecordKey" => "29928453"
"ModificationTimestamp" => "2026-06-19T15:59:09.76Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928453')"
+"ID": "1547964"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: "1547714"
+post_author: 1
+"ListingKey": "29927387"
+"ListingId": "40840891"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:30:41Z"
+"RFModificationTimestamp": "2026-06-19T20:12:26Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 587.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 404, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.879919
1 => 43.342805
]
+"Latitude": 43.342805
+"Longitude": -79.879919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low-maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "523.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T14:50:15.014895+00:00"
+"Directions": "Dundas to Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1829888"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-19T14:33:52Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:50:39Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2988"
+"VirtualTourURLUnbranded": "https://paulandadam.com/listing/404-450-dundas-st-e-2/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663033223"
"RoomType" => "Laundry room"
"ListingId" => "40840891"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29927387"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:39.15Z"
]
1 => array:11 [
"RoomKey" => "1663033224"
"RoomType" => "Kitchen"
"ListingId" => "40840891"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29927387"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:39.15Z"
]
2 => array:11 [
"RoomKey" => "1663033225"
"RoomType" => "Living room"
"ListingId" => "40840891"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29927387"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:39.16Z"
]
3 => array:11 [
"RoomKey" => "1663033226"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840891"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29927387"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:39.16Z"
]
4 => array:11 [
"RoomKey" => "1663033227"
"RoomType" => "Bedroom"
"ListingId" => "40840891"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29927387"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:39.17Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927387/450-dundas-street-e-unit-404-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1756268"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 587
+"OriginalEntryTimestamp": "2026-06-19T13:51:29.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1195588"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1183377"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29927387_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/3b9177b3764f7a2326024b851ad8ed9a.webp"
"MediaSize" => 196526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-3b9177b3764f7a2326024b851ad8ed9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29927387_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/328bda6f4d390d796158f3af0ac701fe.webp"
"MediaSize" => 137374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-328bda6f4d390d796158f3af0ac701fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29927387_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/6cc0865ff28b9ad00509829f94018d05.webp"
"MediaSize" => 50657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-6cc0865ff28b9ad00509829f94018d05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29927387_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/b965830d43ab3cc1e9d4d40cf72518b1.webp"
"MediaSize" => 54555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-b965830d43ab3cc1e9d4d40cf72518b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29927387_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/5df50a5066184387e50dcba8ca698033.webp"
"MediaSize" => 59894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-5df50a5066184387e50dcba8ca698033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29927387_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/131a2ba603f1a7177f83f8c014335f10.webp"
"MediaSize" => 74952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-131a2ba603f1a7177f83f8c014335f10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29927387_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/8c566af140c07c125023785528e2c188.webp"
"MediaSize" => 67867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-8c566af140c07c125023785528e2c188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29927387_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/ade61cc534351ff74ceb072df0c21d23.webp"
"MediaSize" => 76064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-ade61cc534351ff74ceb072df0c21d23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.69Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29927387_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/9b9eb9bd800b6bc1182990bd0ea0902f.webp"
"MediaSize" => 48794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-9b9eb9bd800b6bc1182990bd0ea0902f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29927387_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/e44bb43327ccb459701aaa969123fe2e.webp"
"MediaSize" => 52327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-e44bb43327ccb459701aaa969123fe2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29927387_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/e738f7115225ac900a82acc2fce0429a.webp"
"MediaSize" => 56809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-e738f7115225ac900a82acc2fce0429a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29927387_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/86b4461b7cbc866825e77ccb125b2cc3.webp"
"MediaSize" => 23975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-86b4461b7cbc866825e77ccb125b2cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29927387_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/c6d02d3f5a80dcdeb70f89587c3ba126.webp"
"MediaSize" => 112805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-c6d02d3f5a80dcdeb70f89587c3ba126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29927387_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/b9cb159bd60d27ab46daa95f4317ba4b.webp"
"MediaSize" => 120677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-b9cb159bd60d27ab46daa95f4317ba4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.77Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29927387_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/38dfaec1f66602fc2148fbbad661d51d.webp"
"MediaSize" => 136123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-38dfaec1f66602fc2148fbbad661d51d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.52Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29927387_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/e6a893cd0fdb35de0b4b59bb1f08557a.webp"
"MediaSize" => 107450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-e6a893cd0fdb35de0b4b59bb1f08557a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29927387_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/98fe4fae12370ef749b1743ea2142d4b.webp"
"MediaSize" => 130166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-98fe4fae12370ef749b1743ea2142d4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.68Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29927387_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/f2da6662b52df308ae0d193b71935582.webp"
"MediaSize" => 113735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-f2da6662b52df308ae0d193b71935582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29927387_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/66cb9e1d04d5c2d49489bf27cd6584fb.webp"
"MediaSize" => 121977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-66cb9e1d04d5c2d49489bf27cd6584fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.64Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29927387_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/7dd42c1b7c2fbd0b5d0eff0ba9e34f83.webp"
"MediaSize" => 79901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-7dd42c1b7c2fbd0b5d0eff0ba9e34f83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.66Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29927387_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/392a045cfce4776cb06b085fa2827f82.webp"
"MediaSize" => 137749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-392a045cfce4776cb06b085fa2827f82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:22.64Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29927387_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927387/e30178ea3eae864b356a872b6a8bef44.webp"
"MediaSize" => 126733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927387/thumbnail-e30178ea3eae864b356a872b6a8bef44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840891"
"ResourceRecordKey" => "29927387"
"ModificationTimestamp" => "2026-06-19T14:22:23.52Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927387')"
+"ID": "1547714"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1546802"
+post_author: 1
+"ListingKey": "29926451"
+"ListingId": "X13465026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:55:19Z"
+"RFModificationTimestamp": "2026-06-19T04:50:46Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "37 - 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": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today's busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you're purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown's most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T04:50:35.310980+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102522"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Flat site"
]
+"LotSizeDimensions": "19.7 x 52.3 FT"
+"ParkingFeatures": array:4 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
3 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-06-19T01:47:24Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T01:47:24Z"
+"Stories": "3.0"
+"StreetName": "Nisbet"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4319"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662654788"
"RoomType" => "Foyer"
"ListingId" => "X13465026"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.57
"ListingKey" => "29926451"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.15Z"
]
1 => array:11 [
"RoomKey" => "1662654789"
"RoomType" => "Laundry room"
"ListingId" => "X13465026"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.57
"ListingKey" => "29926451"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
2 => array:11 [
"RoomKey" => "1662654790"
"RoomType" => "Bathroom"
"ListingId" => "X13465026"
"RoomLevel" => "Second level"
"RoomWidth" => 0.79
"ListingKey" => "29926451"
"RoomLength" => 1.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
3 => array:11 [
"RoomKey" => "1662654791"
"RoomType" => "Kitchen"
"ListingId" => "X13465026"
"RoomLevel" => "Second level"
"RoomWidth" => 3.18
"ListingKey" => "29926451"
"RoomLength" => 3.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
4 => array:11 [
"RoomKey" => "1662654792"
"RoomType" => "Dining room"
"ListingId" => "X13465026"
"RoomLevel" => "Second level"
"RoomWidth" => 2.64
"ListingKey" => "29926451"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
5 => array:11 [
"RoomKey" => "1662654794"
"RoomType" => "Living room"
"ListingId" => "X13465026"
"RoomLevel" => "Second level"
"RoomWidth" => 4.64
"ListingKey" => "29926451"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
6 => array:11 [
"RoomKey" => "1662654796"
"RoomType" => "Bathroom"
"ListingId" => "X13465026"
"RoomLevel" => "Third level"
"RoomWidth" => 1.51
"ListingKey" => "29926451"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
7 => array:11 [
"RoomKey" => "1662654797"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13465026"
"RoomLevel" => "Third level"
"RoomWidth" => 5.35
"ListingKey" => "29926451"
"RoomLength" => 3.12
…4
]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926451/37-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-19T01:47:24.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372275"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926451')"
+"ID": "1546802"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1546295"
+post_author: 1
+"ListingKey": "29925650"
+"ListingId": "X13464400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:30:05Z"
+"RFModificationTimestamp": "2026-06-19T01:17:17Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 2 underground parking spaces! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-19T01:17:14.633197+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T22:21:55Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:21:55Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4363"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925650/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T22:21:55.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925650')"
+"ID": "1546295"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: "1546054"
+post_author: 1
+"ListingKey": "29925894"
+"ListingId": "40840606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:00:08Z"
+"RFModificationTimestamp": "2026-06-19T01:45:59Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1439.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 37, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9076836
1 => 43.3385672
]
+"Latitude": 43.3385672
+"Longitude": -79.9076836
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today’s busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you’re purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown’s most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:09:05.929659+00:00"
+"Directions": "HAMILTON ST. 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": "1525003"
+"ListOfficeKey": "284639"
+"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-18T22:52:08Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T00:50:34Z"
+"Stories": "3.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4919"
+"VirtualTourURLUnbranded": "https://youtu.be/YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29925894/54-nisbet-boulevard-unit-37-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1439
+"OriginalEntryTimestamp": "2026-06-18T22:51:09.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1063779"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925894')"
+"ID": "1546054"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1545200"
+post_author: 1
+"ListingKey": "29924409"
+"ListingId": "40840763"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:05:42Z"
+"RFModificationTimestamp": "2026-06-19T20:11:05Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2815.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G3"
+"UnparsedAddress": "34 HOWARD Boulevard, Burlington, Ontario L8B0G3"
+"Coordinates": array:2 [
0 => -79.8940271
1 => 43.3276387
]
+"Latitude": 43.3276387
+"Longitude": -79.8940271
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this wonderful family home in one of Waterdown’s most sought-after neighborhoods! Beautifully landscaped gardens and an inviting flagstone staircase create exceptional curb appeal from the moment you arrive. Inside, you'll find gorgeous hardwood floors, a warm and welcoming family room with a gas fireplace, and a spacious kitchen offering abundant cabinetry, pantry storage, and plenty of room for family gatherings. The beautifully updated bathrooms add a touch of modern elegance, while the versatile lower level features a separate exterior entrance—ideal for an in-law suite, teenage retreat, or home office. Backing onto a tranquil ravine, there is a walk out from the main level to the private backyard which boasts a newer two-tier deck, perfect for entertaining or simply enjoying the natural surroundings. Conveniently located close to shopping, cafés, restaurants, pubs, walking trails, and the scenic Smokey Hollow Waterfall, this home also offers easy access to the Burlington GO Station, Highway 6, Highway 403, and Highway 407, making commuting a breeze. A perfect blend of comfort, convenience, and lifestyle—this is a home you won’t want to miss! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T20:24:33.992597+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:01Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:32:05Z"
+"Stories": "2.0"
+"StreetName": "HOWARD"
+"StreetNumber": "34"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8743"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70321"
+"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/29924409/34-howard-boulevard-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CM, R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 79.0
+"AboveGradeFinishedArea": 2025
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-18T19:51:01.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064859"
+"ListOfficeNationalAssociationId": "1306309"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924409')"
+"ID": "1545200"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1544376"
+post_author: 1
+"ListingKey": "29922718"
+"ListingId": "X13462164"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:01Z"
+"RFModificationTimestamp": "2026-06-18T18:33:13Z"
+"ListPrice": 1750000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafter custom bungalow, situated on animpressive .45 acre lot just minutes from downtown Waterdown. Exterior features the following:full house generator, sprinkler system, 2 hammer head paved parking spaces, landscaped gardenswith rockery, front light pillars. large trees for privacy. wrought iron front porch withdouble custom doors with side lights and separate door for the lower level also. 2.5 car garagewith work bench. fully fenced yard. flag stone patio and stairs, garden shed, fire pit. Theupper level with 3 bedroom/2 ensuites and powder room. sunken family room overlooking rearflagstone/gardens and awning. Separate office, dining room and garden room with an open conceptfloor plan. Along with the lower level being wonderful for in-laws or multi generation familywith its own walk out patio to walk up yard. The home has 2 laundry rooms, 2 full stainlessappliance kitchens with islands.Please note that the listing agent is related to the seller. (id:62783)"
+"Appliances": array:20 [
0 => "All"
1 => "Washer"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Range"
9 => "Oven"
10 => "Dryer"
11 => "Microwave"
12 => "Freezer"
13 => "Oven - Built-In"
14 => "Water Treatment"
15 => "Window Coverings"
16 => "Garage door opener remote(s)"
17 => "Water Heater - Tankless"
18 => "Water Heater"
19 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:8 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "Walk-up"
5 => "N/A"
6 => "N/A"
7 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:33:08.954267+00:00"
+"Directions": "Cross Streets: Dundas Street East & Riley. ** Directions: Hwy 6 & Dundas Street East to the 3rd stoplightin intersection."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Lighting"
2 => "Wheelchair access"
3 => "Carpet Free"
4 => "Sump Pump"
5 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-18T16:56:27Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:56:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10000"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29922718/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-18T16:56:27.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922718')"
+"ID": "1544376"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: "1542841"
+post_author: 1
+"ListingKey": "29921322"
+"ListingId": "40841038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:00:08Z"
+"RFModificationTimestamp": "2026-06-18T15:45:26Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1663.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H6"
+"UnparsedAddress": "46 HARNESWORTH Crescent, Waterdown, Ontario L0R2H6"
+"Coordinates": array:2 [
0 => -79.9053216
1 => 43.3341711
]
+"Latitude": 43.3341711
+"Longitude": -79.9053216
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**4 bedrooms, 3 washrooms, finished basement and a renovated kitchen! Welcome to 46 Harnesworth Crescent, located in one of Waterdown's most desirable neighbourhoods. This lovely semi-detached home features a beautifully upgraded custom kitchen, a renovated primary ensuite, an outdoor gas line for BBQs, and an exposed aggregate driveway and backyard patio pad. Boasting a fantastic layout, this home offers four generously sized bedrooms and a professionally finished basement, providing the perfect extra space for family living, entertaining, or a home office setup. Ideally situated within walking distance to grocery stores, plazas, and parks, and just minutes from the YMCA and schools, this home is perfectly located for growing families and active lifestyles. Set in a wonderful, family-friendly neighbourhood, this is an exceptional opportunity to enjoy comfort, convenience, and community all in one place. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:45:22.122250+00:00"
+"Directions": "Hamilton to Rockhaven to Harnesworth"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946034"
+"ListOfficeKey": "78242"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:52:51Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:52:51Z"
+"Stories": "2.0"
+"StreetName": "HARNESWORTH"
+"StreetNumber": "46"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4971.97"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_harnesworth_crescent_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921322/46-harnesworth-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1663
+"OriginalEntryTimestamp": "2026-06-18T14:52:50.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303132"
+"ListOfficeNationalAssociationId": "1137129"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921322')"
+"ID": "1542841"
}
]
+success: true
+page_size: 9
+page_count: 27
+count: 243
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]
