array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29224821/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224821&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224821/Property?$select=ALL&$top=20&$filter=ListingKey eq 29224821&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23467
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23469
+post_id: "516915"
+post_author: 1
+"ListingKey": "29224821"
+"ListingId": "40796743"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T17:40:10Z"
+"RFModificationTimestamp": "2026-01-07T19:21:59Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1772.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T5"
+"UnparsedAddress": "42 MCCURDY Avenue, Waterdown, Ontario L8B0T5"
+"Coordinates": array:2 [
0 => -79.921779
1 => 43.3296174
]
+"Latitude": 43.3296174
+"Longitude": -79.921779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Choose your Finishings! This charming semi-detached home in sought after Waterdown is ready for your finishing touches. Backing onto the newly constructed Clear Sky Park, this location has it all. Featuring 3 spacious bedrooms, a large kitchen with bright windows and open concept great room, there is plenty of room for a growing family. The Builder is currently offering quartz countertops through out the home and vinyl flooring on the main floor. Don't miss out! (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum - Roughed In"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:21:50.256035+00:00"
+"Directions": "Parkside & Sadielou"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523872"
+"ListOfficeKey": "54955"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T17:29:21Z"
+"PhotosCount": 4
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T17:29:21Z"
+"Stories": "2.0"
+"StreetName": "MCCURDY"
+"StreetNumber": "42"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1557602208"
"RoomType" => "Laundry room"
"ListingId" => "40796743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
1 => array:11 [
"RoomKey" => "1557602209"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
2 => array:11 [
"RoomKey" => "1557602210"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
3 => array:11 [
"RoomKey" => "1557602211"
"RoomType" => "Bedroom"
"ListingId" => "40796743"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
4 => array:11 [
"RoomKey" => "1557602212"
"RoomType" => "Bedroom"
"ListingId" => "40796743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
5 => array:11 [
"RoomKey" => "1557602213"
"RoomType" => "Full bathroom"
"ListingId" => "40796743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
6 => array:11 [
"RoomKey" => "1557602214"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796743"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
7 => array:11 [
"RoomKey" => "1557602215"
"RoomType" => "Kitchen"
"ListingId" => "40796743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
8 => array:11 [
"RoomKey" => "1557602216"
"RoomType" => "Dining room"
"ListingId" => "40796743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.46Z"
]
9 => array:11 [
"RoomKey" => "1557602217"
"RoomType" => "Great room"
"ListingId" => "40796743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.47Z"
]
10 => array:11 [
"RoomKey" => "1557602218"
"RoomType" => "Foyer"
"ListingId" => "40796743"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29224821"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-07T17:29:21.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29224821/42-mccurdy-avenue-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1772
+"OriginalEntryTimestamp": "2026-01-07T17:29:21.39Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:4 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6395556647"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224821/27b109dd0328bd2ae802f1a2777910d2.webp"
"MediaSize" => 54092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224821/thumbnail-27b109dd0328bd2ae802f1a2777910d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796743"
"ResourceRecordKey" => "29224821"
"ModificationTimestamp" => "2026-01-07T17:29:21.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6395556665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224821/43658ee827d7e929a2da26304239e2a3.webp"
"MediaSize" => 26560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224821/thumbnail-43658ee827d7e929a2da26304239e2a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796743"
"ResourceRecordKey" => "29224821"
"ModificationTimestamp" => "2026-01-07T17:29:21.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6395556676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224821/7ab411f847470100406a6d0e8f57292f.webp"
"MediaSize" => 31360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224821/thumbnail-7ab411f847470100406a6d0e8f57292f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796743"
"ResourceRecordKey" => "29224821"
"ModificationTimestamp" => "2026-01-07T17:29:21.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6395556684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29224821/5754e8f603e7dbec565bbc32a32f0c09.webp"
"MediaSize" => 29806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29224821/thumbnail-5754e8f603e7dbec565bbc32a32f0c09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796743"
"ResourceRecordKey" => "29224821"
"ModificationTimestamp" => "2026-01-07T17:29:21.4Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Lawrence Chettle"
"MemberFirstName" => "Lawrence"
"MemberLastName" => "Chettle"
"MemberMlsId" => "HBCHETTLA"
"OriginatingSystemName" => 26
"MemberKey" => "1523872"
"ModificationTimestamp" => "2025-12-10T21:14:34Z"
"MemberMiddleName" => "Edward"
"MemberStatus" => "Active"
"OfficeKey" => "54955"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberCity" => "Beamsville"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-572-0121"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1063819"
"OfficeNationalAssociationId" => "1003569"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Chettle House Realty Inc."
"OfficePhone" => "905-333-3028"
"OfficeMlsId" => "HBCHETTLE"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "54955"
"ModificationTimestamp" => "2025-08-01T17:05:04Z"
"OfficeAddress1" => "4251 King Street"
"OfficeCity" => "Beamsville"
"OfficePostalCode" => "L0R1B"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "905-333-5310"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1003569"
"OfficeBrokerNationalAssociationId" => "1063819"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29224821')"
+"ID": "516915"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 54955/Office?$select=ALL&$top=10&$filter=OfficeKey eq 54955&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 54955/Office?$select=ALL&$top=10&$filter=OfficeKey eq 54955&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25236
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Chettle House Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-333-3028"
+"OfficeMlsId": "HBCHETTLE"
+"ModificationTimestamp": "2025-08-01T17:05:04Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "54955"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "4251 King Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Beamsville"
+"OfficePostalCode": "L0R1B"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003569"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-333-5310"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "440980"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "54955"
"SocialMediaUrlOrId" => "https://chettle.ca/chettlehouserealty/"
"ModificationTimestamp" => "2025-08-01T15:06:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1063819"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('54955')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523872/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523872&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523872/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523872&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25241
+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 29224821" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24889
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224821/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224821&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224821/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29224821&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224821 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.921779 43.3296174)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224821 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.921779 43.3296174)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224821 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.921779 43.3296174)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29224821 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.921779 43.3296174)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24818
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24824
+post_id: "523068"
+post_author: 1
+"ListingKey": "29233329"
+"ListingId": "X12679884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:50:09Z"
+"RFModificationTimestamp": "2026-01-09T16:58:07Z"
+"ListPrice": 699800.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "53 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.907957
1 => 43.3367114
]
+"Latitude": 43.3367114
+"Longitude": -79.907957
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning semi-detached home located in one of the best pockets of Waterdown! This beautifully updated home offers an open concept main floor area with hardwood floors, custom millwork, pot lights and a bay window overlooking the rear gardens. Gourmet kitchen boasts granite counters, an oversized island, upgraded cabinetry with mouldings and stainless steel appliances. Walk-out from the kitchen to deck and fully fenced private backyard. Two bright & spacious bedrooms and a spa-inspired bathroom complete the upper level. The unspoiled basement awaits your personal touch and includes a rough-in for a 3-piece bathroom. This family-friendly community is conveniently located within close proximity to shopping, great schools, the YMCA and fabulous parks. Welcome home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T16:57:42.402755+00:00"
+"Directions": "Parkside Dr & Hamilton St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1414333"
+"ListOfficeKey": "275900"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T15:42:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:42:55Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "53"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/53_cole_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1558266016"
"RoomType" => "Living room"
"ListingId" => "X12679884"
"RoomLevel" => "Main level"
"RoomWidth" => 5.51
"ListingKey" => "29233329"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T15:42:55.63Z"
]
1 => array:11 [
"RoomKey" => "1558266017"
"RoomType" => "Dining room"
"ListingId" => "X12679884"
"RoomLevel" => "Main level"
"RoomWidth" => 2.01
"ListingKey" => "29233329"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T15:42:55.63Z"
]
2 => array:11 [
"RoomKey" => "1558266018"
"RoomType" => "Kitchen"
"ListingId" => "X12679884"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "29233329"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T15:42:55.63Z"
]
3 => array:11 [
"RoomKey" => "1558266019"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12679884"
"RoomLevel" => "Second level"
"RoomWidth" => 3.42
"ListingKey" => "29233329"
"RoomLength" => 4.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T15:42:55.63Z"
]
4 => array:11 [
"RoomKey" => "1558266020"
"RoomType" => "Bedroom"
"ListingId" => "X12679884"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29233329"
"RoomLength" => 4.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T15:42:55.64Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29233329/53-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2026-01-09T15:42:55.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:32 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6397866848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/5956153384f6e88d67759e74e818bcfd.webp"
"MediaSize" => 120883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-5956153384f6e88d67759e74e818bcfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6397866865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/9e02a77f6976cbd869e018ef77e06352.webp"
"MediaSize" => 119483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-9e02a77f6976cbd869e018ef77e06352.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6397866884"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/0617d7949fac5b661390320ef5cc0c7d.webp"
"MediaSize" => 64327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-0617d7949fac5b661390320ef5cc0c7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6397866909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/749d617858b1d82070c13086a6ea45f2.webp"
"MediaSize" => 70684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-749d617858b1d82070c13086a6ea45f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6397866916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/c6732ce639c22b9c8a5e5ca35780a62a.webp"
"MediaSize" => 56280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-c6732ce639c22b9c8a5e5ca35780a62a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6397866939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/b62674f766c221643f484328fe36ea1e.webp"
"MediaSize" => 93089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-b62674f766c221643f484328fe36ea1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6397866947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/f178ef6dba28b31d439f32fa3ad13a03.webp"
"MediaSize" => 91210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-f178ef6dba28b31d439f32fa3ad13a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6397866973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/153366880f7d352092c185302a1a75fa.webp"
"MediaSize" => 94427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-153366880f7d352092c185302a1a75fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6397867020"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/9dc25bd70d7cd5e4105c67ca9ab8d029.webp"
"MediaSize" => 92403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-9dc25bd70d7cd5e4105c67ca9ab8d029.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6397867050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/10e76dbfe6d6cf72ff923f41ebed3a8f.webp"
"MediaSize" => 105893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-10e76dbfe6d6cf72ff923f41ebed3a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6397867077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/5850ce3ee4169a660a07447e197762ab.webp"
"MediaSize" => 86898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-5850ce3ee4169a660a07447e197762ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6397867118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/20cfc12736b31e77ab7722cc66a93cd1.webp"
"MediaSize" => 81235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-20cfc12736b31e77ab7722cc66a93cd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6397867151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/9c3c4632e945fe4ba42ab3c4c1e72037.webp"
"MediaSize" => 76457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-9c3c4632e945fe4ba42ab3c4c1e72037.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6397867167"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/04ffbf20428d8bc35df00b82b11ecad0.webp"
"MediaSize" => 88465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-04ffbf20428d8bc35df00b82b11ecad0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6397867191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/d88d561e61fb0092c9f0d3ef1ea27906.webp"
"MediaSize" => 93098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-d88d561e61fb0092c9f0d3ef1ea27906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6397867213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/1881e59ae46dfbffd68ba8f3627b559f.webp"
"MediaSize" => 90305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-1881e59ae46dfbffd68ba8f3627b559f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6397867226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/eb4744d9c48f9a91b4c4450be3f66721.webp"
"MediaSize" => 80765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-eb4744d9c48f9a91b4c4450be3f66721.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6397867248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/c7502af8e0dcab356f69ac2aaa8118f0.webp"
"MediaSize" => 83225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-c7502af8e0dcab356f69ac2aaa8118f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6397867269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/7b2dd10d5f7812f5d9fcd9af9fb40741.webp"
"MediaSize" => 66933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-7b2dd10d5f7812f5d9fcd9af9fb40741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6397867294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/b73c42c0a133f3a44c2133628b6149cc.webp"
"MediaSize" => 79668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-b73c42c0a133f3a44c2133628b6149cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6397867315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/bf4331f3f1090eec9c9e59f984e49c94.webp"
"MediaSize" => 82417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-bf4331f3f1090eec9c9e59f984e49c94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6397867346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/e14df5bc5c91d6159accf430c0d67b8b.webp"
"MediaSize" => 90319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-e14df5bc5c91d6159accf430c0d67b8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6397867364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/45058d5501898418a25d15d72316b375.webp"
"MediaSize" => 80395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-45058d5501898418a25d15d72316b375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6397867383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/1370e14d8a43877cd74d48cbf2f89c5d.webp"
"MediaSize" => 87460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-1370e14d8a43877cd74d48cbf2f89c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6397867402"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/82fc3f26e9f109e5b4b6116986f6bfdd.webp"
"MediaSize" => 75448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-82fc3f26e9f109e5b4b6116986f6bfdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6397867423"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/86005ea94260eea383cace0180acbf76.webp"
"MediaSize" => 60088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-86005ea94260eea383cace0180acbf76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6397867443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/dab88f41315eba7a941ad211522e69f7.webp"
"MediaSize" => 174209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-dab88f41315eba7a941ad211522e69f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6397867465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/ebb310ebd972f319636ca260bca18542.webp"
"MediaSize" => 144868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-ebb310ebd972f319636ca260bca18542.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6397867491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/fcf472e3b19da201eaa01653671d0671.webp"
"MediaSize" => 178655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-fcf472e3b19da201eaa01653671d0671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6397867517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/effe3391143934321852d294a520a783.webp"
"MediaSize" => 190479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-effe3391143934321852d294a520a783.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6397867523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/81863977398c7c37f89074a7e2687c00.webp"
"MediaSize" => 162535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-81863977398c7c37f89074a7e2687c00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6397867536"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29233329/244102d9108ebadbcdff66a7167cdeb9.webp"
"MediaSize" => 175123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29233329/thumbnail-244102d9108ebadbcdff66a7167cdeb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12679884"
"ResourceRecordKey" => "29233329"
"ModificationTimestamp" => "2026-01-09T15:42:55.62Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "LUISA PICCIRILLI"
"MemberFirstName" => "LUISA"
"MemberLastName" => "PICCIRILLI"
"MemberMlsId" => "2723143"
"OriginatingSystemName" => 26
"MemberKey" => "1414333"
"ModificationTimestamp" => "2024-09-26T20:43:41Z"
"MemberStatus" => "Active"
"OfficeKey" => "275900"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberAOR" => "Toronto"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:4 [ …4]
"MemberOfficePhone" => "416-760-0600"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "416-728-4663"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1105896"
"OfficeNationalAssociationId" => "1269109"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX WEST REALTY INC."
"OfficePhone" => "416-760-0600"
"OfficeMlsId" => "494708"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "275900"
"ModificationTimestamp" => "2024-09-26T21:27:47Z"
"OfficeAddress1" => "2234 BLOOR STREET WEST"
"OfficeAddress2" => "104524"
"OfficeCity" => "TORONTO"
"OfficePostalCode" => "M6S1N6"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "416-760-0900"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2014-12-20T00:44:00Z"
"OfficeNationalAssociationId" => "1269109"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1056117"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233329')"
+"ID": "523068"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24822
+post_id: "518980"
+post_author: 1
+"ListingKey": "29228819"
+"ListingId": "X12675804"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T15:51:09Z"
+"RFModificationTimestamp": "2026-01-08T16:06:08Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V9"
+"UnparsedAddress": "181 SPRINGVIEW DRIVE, Hamilton (Waterdown), Ontario L8B0V9"
+"Coordinates": array:2 [
0 => -79.9159008
1 => 43.3298005
]
+"Latitude": 43.3298005
+"Longitude": -79.9159008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your dream home featuring a premium lot & an entertainer's paradise in the backyard! Enjoy your private outdoor retreat complete with stamped concrete patio, elevated deck, beautifully landscaped grounds, vinyl fencing, gas line for BBQ & an incredible 17 ft Hydro pool. This versatile Hydro pool includes tranquil waterfalls, a convenient roll-up cover & functions as a swim spa, oversized hot tub, or refreshing summer pool. Upgrades in 2025 make this home truly move-in ready: Fully finished walk-out basement with bedroom, 3-pc bath, den, rec room & kitchenette - perfect for in-laws or guests. Engineered hardwood flooring throughout the bedroom level. Custom built-ins throughout provide exceptional storage and style. Quartz countertops in the kitchen & upstairs bathrooms. Brand new appliances (2025) included. Plus, anew shed for extra storage. This home combines luxury, functionality &outdoor living at its finest. RSA. SQFTA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T16:04:54.730500+00:00"
+"Directions": "Cross Streets: Parkside Dr & Mosaic Dr. ** Directions: Parkside Dr to Mosaic Dr, to Painter Terrace and right on Springview Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132248"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "32.2 x 138.4 FT ; 32.23ft x 114.82ft x 78.26ft x 138.41ft"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-08T15:44:43Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T15:44:42Z"
+"Stories": "2.0"
+"StreetName": "Springview"
+"StreetNumber": "181"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8471.23"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360094"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1557924047"
"RoomType" => "Bathroom"
"ListingId" => "X12675804"
"RoomLevel" => "Main level"
"RoomWidth" => 1.57
"ListingKey" => "29228819"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
1 => array:11 [
"RoomKey" => "1557924048"
"RoomType" => "Bedroom"
"ListingId" => "X12675804"
"RoomLevel" => "Second level"
"RoomWidth" => 3.91
"ListingKey" => "29228819"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
2 => array:11 [
"RoomKey" => "1557924049"
"RoomType" => "Bathroom"
"ListingId" => "X12675804"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29228819"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
3 => array:11 [
"RoomKey" => "1557924050"
"RoomType" => "Bedroom"
"ListingId" => "X12675804"
"RoomLevel" => "Basement"
"RoomWidth" => 3.17
"ListingKey" => "29228819"
"RoomLength" => 4.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
4 => array:11 [
"RoomKey" => "1557924051"
"RoomType" => "Bathroom"
"ListingId" => "X12675804"
"RoomLevel" => "Basement"
"RoomWidth" => 1.19
"ListingKey" => "29228819"
"RoomLength" => 2.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
5 => array:11 [
"RoomKey" => "1557924052"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12675804"
"RoomLevel" => "Basement"
"RoomWidth" => 4.83
"ListingKey" => "29228819"
"RoomLength" => 6.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
6 => array:11 [
"RoomKey" => "1557924053"
"RoomType" => "Den"
"ListingId" => "X12675804"
"RoomLevel" => "Basement"
"RoomWidth" => 4.62
"ListingKey" => "29228819"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.94Z"
]
7 => array:11 [
"RoomKey" => "1557924054"
"RoomType" => "Kitchen"
"ListingId" => "X12675804"
"RoomLevel" => "Main level"
"RoomWidth" => 5.03
"ListingKey" => "29228819"
"RoomLength" => 5.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.95Z"
]
8 => array:11 [
"RoomKey" => "1557924055"
"RoomType" => "Dining room"
"ListingId" => "X12675804"
"RoomLevel" => "Main level"
"RoomWidth" => 4.8
"ListingKey" => "29228819"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-08T15:44:42.95Z"
]
9 => array:11 [
"RoomKey" => "1557924056"
"RoomType" => "Living room"
…9
]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29228819/181-springview-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-48"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.2
+"OriginalEntryTimestamp": "2026-01-08T15:44:42.9Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228819')"
+"ID": "518980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24825
+post_id: "516691"
+post_author: 1
+"ListingKey": "29224801"
+"ListingId": "X12672002"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T22:55:59Z"
+"RFModificationTimestamp": "2026-01-08T23:04:17Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 5
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K1"
+"UnparsedAddress": "8 KEEWAYDIN STREET, Hamilton (Waterdown), Ontario L8B0K1"
+"Coordinates": array:2 [
0 => -79.906109
1 => 43.3329847
]
+"Latitude": 43.3329847
+"Longitude": -79.906109
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully upgraded 4+1 bedroom, 3+2 bath home offering nearly 2,900 sqft of total finished living space on a generous 45 x 151 ft lot. Designed with versatility and modern living in mind, this property is ideal for growing families or multi-generational living. The newly renovated main floor (2023) features an open concept living and dining space, chef's kitchen with premium stainless steel appliances, including a gas stove and Bosch refrigerator, and ample cabinetry for storage. Convenient inside entry from the double garage adds everyday functionality. The finished basement impresses with a full in-law suite, featuring a custom kitchen/bar with granite countertops, modern black stainless steel appliances, glass display cabinets, and a stylish stone accent wall framing a gas fireplace. Upstairs, the primary suite offers a true retreat with an expanded walk-in closet and a spa-inspired 5-piece ensuite, showcasing his-and-hers sinks, a glass shower, and a luxurious soaker tub. Three additional spacious bedrooms and a full bathroom provide plenty of room for family, guests, or a dedicated home office. Perfectly situated close to Waterdown's downtown, schools, and local trails, this home combines modern comfort, thoughtful design, and a fantastic location. This is not one to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Other, See Remarks"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 5
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:23:25.377276+00:00"
+"Directions": "Cross Streets: Parkside Drive. ** Directions: Parkside Drive To Keewaydin Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "44.5 x 150.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T17:24:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T22:41:19Z"
+"Stories": "2.0"
+"StreetName": "Keewaydin"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7574.94"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29224801/8-keewaydin-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.6
+"OriginalEntryTimestamp": "2026-01-07T17:24:36.91Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29224801')"
+"ID": "516691"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24821
+post_id: "515923"
+post_author: 1
+"ListingKey": "29223561"
+"ListingId": "40795992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T13:45:04Z"
+"RFModificationTimestamp": "2026-01-07T17:41:14Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2300.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0K1"
+"UnparsedAddress": "8 KEEWAYDIN Street, Waterdown, Ontario L8B0K1"
+"Coordinates": array:2 [
0 => -79.9062482
1 => 43.3330811
]
+"Latitude": 43.3330811
+"Longitude": -79.9062482
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded 4+1 bedroom, 3+2 bath home offering nearly 2,900 sqft of total finished living space on a generous 45 x 151 ft lot. Designed with versatility and modern living in mind, this property is ideal for growing families or multi-generational living. The newly renovated main floor (2023) features an open concept living and dining space, chef's kitchen with premium stainless steel appliances, including a gas stove and Bosch refrigerator, and ample cabinetry for storage. Convenient inside entry from the double garage adds everyday functionality. The finished basement impresses with a full in-law suite, featuring a custom kitchen/bar with granite countertops, modern black stainless steel appliances, glass display cabinets, and a stylish stone accent wall framing a gas fireplace. Upstairs, the primary suite offers a true retreat with an expanded walk-in closet and a spa-inspired 5-piece ensuite, showcasing his-and-hers sinks, a glass shower, and a luxurious soaker tub. Three additional spacious bedrooms and a full bathroom provide plenty of room for family, guests, or a dedicated home office. Perfectly situated close to Waterdown’s downtown, schools, and local trails, this home combines modern comfort, thoughtful design, and a fantastic location. This is not one to miss! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T17:40:58.529783+00:00"
+"Directions": "Parkside Drive To Keewaydin Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Automatic Garage Door Opener"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T13:40:53Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T13:40:53Z"
+"Stories": "2.0"
+"StreetName": "KEEWAYDIN"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7574.94"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29223561/8-keewaydin-street-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2300
+"OriginalEntryTimestamp": "2026-01-07T13:38:28.51Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223561')"
+"ID": "515923"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24823
+post_id: "515924"
+post_author: 1
+"ListingKey": "29223969"
+"ListingId": "40796620"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T15:50:08Z"
+"RFModificationTimestamp": "2026-01-07T16:09:42Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3515.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0V9"
+"UnparsedAddress": "181 SPRINGVIEW Drive, Waterdown, Ontario L8B0V9"
+"Coordinates": array:2 [
0 => -79.915886
1 => 43.3297686
]
+"Latitude": 43.3297686
+"Longitude": -79.915886
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream home featuring a premium lot & an entertainer's paradise in the backyard! Enjoy your private outdoor retreat complete with stamped concrete patio, elevated deck, beautifully landscaped grounds, vinyl fencing, gas line for BBQ & an incredible 17 ft Hydropool. This versatile Hydropool includes tranquil waterfalls, a convenient roll-up cover & functions as a swim spa, oversized hot tub, or refreshing summer pool. Upgrades in 2025 make this home truly move-in ready: Fully finished walk-out basement with bedroom, 3-pc bath, den, rec room & kitchenette - perfect for in-laws or guests. Engineered hardwood flooring throughout the bedroom level. Custom built-ins throughout provide exceptional storage and style. Quartz countertops in the kitchen & upstairs bathrooms. Brand new appliances (2025) included. Plus, a new shed for extra storage. This home combines luxury, functionality & outdoor living at its finest. RSA. SQFTA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T16:09:18.790674+00:00"
+"Directions": "Parkside Dr to Mosaic Dr, to Painter Terrace and right on Springview Dr"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1616311"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T15:38:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T15:38:30Z"
+"Stories": "2.0"
+"StreetName": "SPRINGVIEW"
+"StreetNumber": "181"
+"StreetSuffix": "Drive"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8471.23"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360094"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29223969/181-springview-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523858"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55026"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R1-48"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2598
+"BelowGradeFinishedArea": 917
+"OriginalEntryTimestamp": "2026-01-07T15:38:30.56Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223969')"
+"ID": "515924"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24828
+post_id: "515591"
+post_author: 1
+"ListingKey": "29223648"
+"ListingId": "X12670922"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T16:30:31Z"
+"RFModificationTimestamp": "2026-01-08T20:24:07Z"
+"ListPrice": 989000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C8"
+"UnparsedAddress": "4 FENTON DRIVE, Hamilton (Waterdown), Ontario L8B0C8"
+"Coordinates": array:2 [
0 => -79.9107521
1 => 43.3294749
]
+"Latitude": 43.3294749
+"Longitude": -79.9107521
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Set on a quiet, established street in the charming town of Waterdown, 4 Fenton Drive is a meticulously maintained family home that has been extensively updated with a clear focus on quality, function, and long-term livability. The main floor offers a welcoming foyer, formal living and dining rooms, and a thoughtfully renovated kitchen with solid-wood counters, a handcrafted tile backsplash, modern lighting, and a bright breakfast area. Stepping down a few stairs, the family room is anchored by a wood-burning fireplace and opens directly onto a large deck with a pergola and a hot tub, and steps down to a private garden framed by mature trees. This level also includes a dedicated laundry area and a two-piece bathroom, keeping daily routines conveniently close to the main living spaces. The upper floors are equally well considered. Two generous bedrooms and a four-piece bathroom occupy the second floor, while the third level is reserved for the primary suite with a fully renovated walk-in closet and a five-piece ensuite. The finished lower level adds valuable flexibility, with a large recreation room suited for play, fitness, or work-from-home use, along with a fourth bedroom and excellent storage. Extensive upgrades throughout, including updated windows and doors, flooring, lighting, and modernized bathrooms, reflect a home that has been carefully and comprehensively improved. Ideally located within walking distance of schools, parks, trails, the YMCA, and Waterdown's vibrant village core, this is a refined, move-in-ready offering with space to grow and updates already in place. (id:62650)"
+"Appliances": array:2 [
0 => "Central Vacuum"
1 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Partial"
2 => "Crawl space"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T15:48:20.750107+00:00"
+"Directions": "Cross Streets: Braeheid Ave & Fenton Dr. ** Directions: Parkside Dr, Braeheid Ave, Fenton Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1980564"
+"ListOfficeKey": "205041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Lighting"
1 => "Carpet Free"
2 => "Gazebo"
]
+"LotSizeDimensions": "40.4 x 99.7 FT ; 40.43 ft x 99.93 ft x 40.43 ft x 99.92"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T14:26:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T16:15:46Z"
+"StreetName": "Fenton"
+"StreetNumber": "4"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6104.82"
+"VirtualTourURLUnbranded": "https://engelbrechtassociates.com/properties/7191472432902435518-4-Fenton-Drive"
+"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": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29223648/4-fenton-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2154195"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "205041"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.4
+"OriginalEntryTimestamp": "2026-01-07T14:26:26.82Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223648')"
+"ID": "515591"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+post_id: "512601"
+post_author: 1
+"ListingKey": "29219145"
+"ListingId": "40796289"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T15:10:15Z"
+"RFModificationTimestamp": "2026-01-06T17:43:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2100.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "71 FINGLAND Crescent, Waterdown, Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.9129117
1 => 43.3370961
]
+"Latitude": 43.3370961
+"Longitude": -79.9129117
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious 3-Bedroom Townhome for Lease in Waterdown, Ontario! This stunning 3-bedroom, 2.5-bathroom townhome offers about 2,100 square feet of living space on the ground and upper floors, plus and unfinished basement. This is the perfect home for families or professionals looking for a peaceful yet convenient location. The open-concept layout features a bright and airy living room that flows seamlessly into the dining area and modern kitchen, creating the ideal space for entertaining or relaxing. Upstairs, you'll find three spacious bedrooms, including a luxurious primary suite complete with an ensuite bathroom. The additional bedrooms offer plenty of space for family, guests, or even a home office. With two and a half bathrooms throughout, mornings are a breeze, ensuring everyone has the space they need. One of the standout features of this townhome is its serene location. Situated directly across from a beautiful forest, you'll enjoy natural views and a tranquil setting right outside your door. The home also includes a single-car garage and additional driveway parking, offering convenience and ease. Located in the desirable Waterdown area, you're just minutes away from parks, trails, schools, shopping, and all the amenities this charming community has to offer. This townhome is available for lease now don't miss your chance to make it your new home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:43:44.421891+00:00"
+"Directions": "Centre>Nesbit>Fingland"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1531239"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T15:00:41Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-06T15:00:41Z"
+"Stories": "2.0"
+"StreetName": "FINGLAND"
+"StreetNumber": "71"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"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/29219145/71-fingland-crescent-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "R6-14"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2100
+"OriginalEntryTimestamp": "2026-01-06T15:00:41.65Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:18 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29219145')"
+"ID": "512601"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24820
+post_id: "510736"
+post_author: 1
+"ListingKey": "29215932"
+"ListingId": "X12662404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-05T18:50:08Z"
+"RFModificationTimestamp": "2026-01-05T19:24:47Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S1"
+"UnparsedAddress": "6 BORERS CREEK CIRCLE S, Hamilton (Waterdown), Ontario L8B0S1"
+"Coordinates": array:2 [
0 => -79.9190203
1 => 43.3313572
]
+"Latitude": 43.3313572
+"Longitude": -79.9190203
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern, Sun-Filled Townhome in Prime Waterdown Location - Move-In Ready, Welcome to this beautifully maintained, move-in-ready 3-storey townhouse offering just under 2,000 sq. ft. of thoughtfully designed living space, perfectly suited for first-time home buyers, downsizers, and savvy investors. Ideally located steps from a serene pond and scenic walking trails, this freshly painted 3-bedroom, 2.5-bath home features brand-new laminate flooring, 9-foot ceilings, and an abundance of natural light throughout. Situated in the heart of Waterdown's vibrant and family-friendly community, enjoy walking distance to shops, parks, and schools, with quick access to major highways-making it an excellent choice for commuters and tenants alike. The versatile ground level offers a flexible space ideal as a bedroom, recreation room, or private home office, complete with a walkout to the patio and deck, plus direct access to the attached garage. An unfinished basement provides ample storage or future customization potential-perfect for added value.The open-concept main floor is designed for everyday living and entertaining, featuring a bright living and dining area with large windows and pot lights. The modern kitchen boasts quartz countertops, a contemporary backsplash, stainless steel appliances, and a walkout to a Juliette balcony. A convenient powder room completes this level. Upstairs, the spacious primary retreat offers a walk-in closet, a luxurious 4-piece ensuite with glass walk-in shower, and private balcony access. Two additional bedrooms provide flexibility for family, guests, or work-from-home needs. Upper-level laundry adds everyday convenience. All builder upgrades included.A perfect blend of location, functionality, and modern design, this home presents an excellent opportunity to live comfortably, downsize smartly, or invest confidently in one of Waterdown's most desirable neighbourhoods.Don't miss this exceptional opportunity. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "94.16"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-01-05T19:24:34.317708+00:00"
+"Directions": "Parkside Dr/Mosaic Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1866190"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "18 x 75.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-05T18:44:24Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-05T18:44:24Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "Borers Creek"
+"StreetNumber": "6"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "5451"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.relavix.com/6-borers-creek-circle-waterdown/?unbranded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29215932/6-borers-creek-circle-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-01-05T18:44:24.58Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29215932')"
+"ID": "510736"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: "508166"
+post_author: 1
+"ListingKey": "29212760"
+"ListingId": "X12659138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-03T23:45:42Z"
+"RFModificationTimestamp": "2026-01-04T00:48:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 3
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "71 FINGLAND CRESCENT, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.9129568
1 => 43.3371492
]
+"Latitude": 43.3371492
+"Longitude": -79.9129568
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 3-Bedroom Townhome for Lease in Waterdown, Ontario! This stunning 3-bedroom, 2.5-bathroom townhome offers about 2,100 square feet of living space on the ground and upper floors, plus and unfinished basement. This is the perfect home for families or professionals looking for a peaceful yet convenient location. The open-concept layout features a bright and airy living room that flows seamlessly into the dining area and modern kitchen, creating the ideal space for entertaining or relaxing. Upstairs, you'll find three spacious bedrooms, including a luxurious primary suite complete with an ensuite bathroom. The additional bedrooms offer plenty of space for family, guests, or even a home office. With two and a half bathrooms throughout, mornings are a breeze, ensuring everyone has the space they need. One of the standout features of this townhome is its serene location. Situated directly across from a beautiful forest, you'll enjoy natural views and a tranquil setting right outside your door. The home also includes a single-car garage and additional driveway parking, offering convenience and ease. Located in the desirable Waterdown area, you're just minutes away from parks, trails, schools, shopping, and all the amenities this charming community has to offer. This townhome is available for lease now don't miss your chance to make it your new home! (id:62650)"
+"Appliances": array:3 [
0 => "Water meter"
1 => "Garage door opener remote(s)"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 3
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-04T00:47:55.790394+00:00"
+"Directions": "Cross Streets: Centre>Nesbit>Fingland. ** Directions: Nisbet to Fingland."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1642057"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Ravine"
2 => "Level"
3 => "In suite Laundry"
]
+"LotSizeDimensions": "24.7 x 88.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-03T23:39:59Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-03T23:39:59Z"
+"Stories": "2.0"
+"StreetName": "Fingland"
+"StreetNumber": "71"
+"StreetSuffix": "Crescent"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29212760/71-fingland-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.8
+"OriginalEntryTimestamp": "2026-01-03T23:39:59.35Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:27 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29212760')"
+"ID": "508166"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 47
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
]