array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30017446 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1612639"
+post_author: 1
+"ListingKey": "30017446"
+"ListingId": "40845410"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T17:20:09Z"
+"RFModificationTimestamp": "2026-07-14T19:29:25Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1904.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0J4"
+"UnparsedAddress": "137 CHUDLEIGH Street, Waterdown, Ontario L8B0J4"
+"Coordinates": array:2 [
0 => -79.9021193
1 => 43.3329445
]
+"Latitude": 43.3329445
+"Longitude": -79.9021193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to Waterdown living! This immaculate, carpet-free semi-detached home is completely turn-key and located in a highly desirable, family-friendly neighbourhood. Excellent curb appeal welcomes you with beautiful landscaping, a two-car driveway, and a new garage door (2025). Inside, the main level features a bright kitchen complete with stone countertops, stainless steel appliances, and a large walk-in pantry. The upper level offers 3 spacious bedrooms, while the fully finished basement provides excellent bonus space for a family room, home office, or gym. Step outside to a low-maintenance backyard featuring a concrete patio, perfect for summer BBQs and entertaining. Move in with total peace of mind thanks to a brand-new furnace (2026). (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:04:58.252532+00:00"
+"Directions": "Hamilton Street North to White Oak Drive, right on Chudleigh"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105573"
+"ListOfficeKey": "287105"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T16:13:33Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T17:13:33Z"
+"Stories": "2.0"
+"StreetName": "CHUDLEIGH"
+"StreetNumber": "137"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4985.9"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/KacvkQGgjMk"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1684124865"
"RoomType" => "Utility room"
"ListingId" => "40845410"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
1 => array:11 [
"RoomKey" => "1684124866"
"RoomType" => "Storage"
"ListingId" => "40845410"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "5'7'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
2 => array:11 [
"RoomKey" => "1684124867"
"RoomType" => "Recreation room"
"ListingId" => "40845410"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "27'6'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
3 => array:11 [
"RoomKey" => "1684124868"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845410"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
4 => array:11 [
"RoomKey" => "1684124869"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845410"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
5 => array:11 [
"RoomKey" => "1684124870"
"RoomType" => "Bedroom"
"ListingId" => "40845410"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
6 => array:11 [
"RoomKey" => "1684124871"
"RoomType" => "Bedroom"
"ListingId" => "40845410"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.35Z"
]
7 => array:11 [
"RoomKey" => "1684124872"
"RoomType" => "Pantry"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
8 => array:11 [
"RoomKey" => "1684124873"
"RoomType" => "Foyer"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
9 => array:11 [
"RoomKey" => "1684124874"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
10 => array:11 [
"RoomKey" => "1684124875"
"RoomType" => "Kitchen"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
11 => array:11 [
"RoomKey" => "1684124876"
"RoomType" => "Dining room"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
12 => array:11 [
"RoomKey" => "1684124877"
"RoomType" => "Living room"
"ListingId" => "40845410"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017446"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-14T17:13:33.36Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/30017446/137-chudleigh-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1334
+"BelowGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-07-10T16:13:33.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1374845"
+"ListOfficeNationalAssociationId": "1366533"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017446_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/14fc823ea1b0cd4c604cc492ad9610a3.webp"
"MediaSize" => 132643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-14fc823ea1b0cd4c604cc492ad9610a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017446_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/c1e6032c85eef173989732ec11e00e41.webp"
"MediaSize" => 120757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-c1e6032c85eef173989732ec11e00e41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017446_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/cd30ede5a69559dafd91704e4d6ae18a.webp"
"MediaSize" => 146529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-cd30ede5a69559dafd91704e4d6ae18a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017446_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/724f44dcceb3045f0fc7d6141107add4.webp"
"MediaSize" => 146726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-724f44dcceb3045f0fc7d6141107add4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30017446_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/84ea3239753f702232e3872a0eb3371f.webp"
"MediaSize" => 151941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-84ea3239753f702232e3872a0eb3371f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30017446_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/ae0b4b3a9fcd3bb77d1e643342641389.webp"
"MediaSize" => 144369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-ae0b4b3a9fcd3bb77d1e643342641389.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30017446_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/0353bb59b1b5c0824afc13ba0cef293d.webp"
"MediaSize" => 145528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-0353bb59b1b5c0824afc13ba0cef293d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30017446_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/e1cbfd48d37a9f8ca252fc101865e39f.webp"
"MediaSize" => 154551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-e1cbfd48d37a9f8ca252fc101865e39f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30017446_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/7103b848dab86d45e8da9ddb99115f7a.webp"
"MediaSize" => 124181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-7103b848dab86d45e8da9ddb99115f7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30017446_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/957380b7ff4c0b8767522c3242743ac0.webp"
"MediaSize" => 149718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-957380b7ff4c0b8767522c3242743ac0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30017446_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/2f1fadbb4754c16b50e6c94c13471ab4.webp"
"MediaSize" => 117420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-2f1fadbb4754c16b50e6c94c13471ab4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30017446_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/26d0cb3ebbc75b1bfff395f982e8ced6.webp"
"MediaSize" => 59153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-26d0cb3ebbc75b1bfff395f982e8ced6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30017446_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/fa0351a1cb52d0bc55a91136f551932a.webp"
"MediaSize" => 76167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-fa0351a1cb52d0bc55a91136f551932a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30017446_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/ac71676f2af111c56add2bf0c01771c9.webp"
"MediaSize" => 74895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-ac71676f2af111c56add2bf0c01771c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30017446_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/e759433c4cb0c9bd112f914ee6d92897.webp"
"MediaSize" => 78454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-e759433c4cb0c9bd112f914ee6d92897.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30017446_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/c075be6c7ff2fdb4303a2ff1cc74d11b.webp"
"MediaSize" => 62423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-c075be6c7ff2fdb4303a2ff1cc74d11b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30017446_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/2e8b8c5002c6c755d54917838b8612ab.webp"
"MediaSize" => 80312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-2e8b8c5002c6c755d54917838b8612ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30017446_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/9a58807f6c014ec32e26279a4ce075f5.webp"
"MediaSize" => 87212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-9a58807f6c014ec32e26279a4ce075f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30017446_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/349b99633ea9e2f9a5a4081cf360e124.webp"
"MediaSize" => 91571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-349b99633ea9e2f9a5a4081cf360e124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30017446_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/7f649b7450402c90019ed5141f022fe1.webp"
"MediaSize" => 78627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-7f649b7450402c90019ed5141f022fe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30017446_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/e30f7428ab0fdd21213cd9f803921114.webp"
"MediaSize" => 97751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-e30f7428ab0fdd21213cd9f803921114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30017446_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/bb00648b315921b333ccf165cad64369.webp"
"MediaSize" => 69758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-bb00648b315921b333ccf165cad64369.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30017446_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/22cf20e86101e6c42c66d8e06839ea24.webp"
"MediaSize" => 62704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-22cf20e86101e6c42c66d8e06839ea24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30017446_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/f7ce3ff5700d75e1c387bdd34306a4ad.webp"
"MediaSize" => 98654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-f7ce3ff5700d75e1c387bdd34306a4ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30017446_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/9df6f7ff9aba163a8d3e8a62bd63e6b0.webp"
"MediaSize" => 67183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-9df6f7ff9aba163a8d3e8a62bd63e6b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30017446_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/0748bd78e90e70840277dfbf65f1dbf1.webp"
"MediaSize" => 70811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-0748bd78e90e70840277dfbf65f1dbf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30017446_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/ff73c828f6661cc45964b4e967c50514.webp"
"MediaSize" => 73296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-ff73c828f6661cc45964b4e967c50514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30017446_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/1e9e39f6aa33910cbba7a16965421648.webp"
"MediaSize" => 93699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-1e9e39f6aa33910cbba7a16965421648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30017446_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/1bd54ec4b1eb88ff338d8a7f505e3c9a.webp"
"MediaSize" => 77369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-1bd54ec4b1eb88ff338d8a7f505e3c9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30017446_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/ad741a2599c0dde9a9c9c087b84fa9b8.webp"
"MediaSize" => 60492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-ad741a2599c0dde9a9c9c087b84fa9b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30017446_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/3dcd20a3ea6f4b39b4bc633d7d6cb7c2.webp"
"MediaSize" => 55472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-3dcd20a3ea6f4b39b4bc633d7d6cb7c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30017446_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/3300db3a92e490f31b20776bfb049086.webp"
"MediaSize" => 71642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-3300db3a92e490f31b20776bfb049086.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30017446_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/81bbe2885edd4842fae580354a4c88d2.webp"
"MediaSize" => 82204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-81bbe2885edd4842fae580354a4c88d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30017446_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/b3a7ee25e2e867abb912e0330496fd99.webp"
"MediaSize" => 80841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-b3a7ee25e2e867abb912e0330496fd99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30017446_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/863f1a402ca9a7b95579fb940eecaaa6.webp"
"MediaSize" => 83573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-863f1a402ca9a7b95579fb940eecaaa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30017446_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/d66c84c01f33605d9b9622fe985a0727.webp"
"MediaSize" => 71418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-d66c84c01f33605d9b9622fe985a0727.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30017446_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/c33c632c58f45e41535defb0d89996d8.webp"
"MediaSize" => 181548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-c33c632c58f45e41535defb0d89996d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30017446_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/ab514828b4cccd6a0a4de291c94e7e14.webp"
"MediaSize" => 132460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-ab514828b4cccd6a0a4de291c94e7e14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30017446_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/04a7f961658bb905f9f2f893a12846c5.webp"
"MediaSize" => 136150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-04a7f961658bb905f9f2f893a12846c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30017446_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/45b37d845071e59e3749a1e845539d2a.webp"
"MediaSize" => 146055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-45b37d845071e59e3749a1e845539d2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30017446_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/c260c7b0e9745ec952dcdcac1618bacc.webp"
"MediaSize" => 138902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-c260c7b0e9745ec952dcdcac1618bacc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30017446_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/08c1fcc59ef41024e3e739a4c6d3878a.webp"
"MediaSize" => 149966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-08c1fcc59ef41024e3e739a4c6d3878a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30017446_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/aff26e00b37b0b9cad8de9ae7da375d0.webp"
"MediaSize" => 157943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-aff26e00b37b0b9cad8de9ae7da375d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30017446_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017446/7613c0242b8ded4fe95b52503f31213d.webp"
"MediaSize" => 149400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017446/thumbnail-7613c0242b8ded4fe95b52503f31213d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845410"
"ResourceRecordKey" => "30017446"
"ModificationTimestamp" => "2026-07-10T16:13:33.77Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30017446_4890_45"
…11
]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017446')"
+"ID": "1612639"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 287105" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25002
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24947
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Century 21 Heritage House LTD"
+"OfficeEmail": null
+"OfficePhone": "519-758-2121"
+"OfficeMlsId": "BR22000232"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "287105"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "505 Park Rd N., Suite #216"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Brantford"
+"OfficePostalCode": "N3R7K8"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Brantford"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1366533"
+"OriginalEntryTimestamp": "2020-07-16T17:12:00Z"
+"OfficeAORKey": "41"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1366534"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('287105')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2105573" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24898
+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 '30017446'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25315
+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 '30017446' AND OpenHouseDate ge '2026-07-14'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25333
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31984084"
+"ListingKey": "30017446"
+"ListingId": "40845410"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-16"
+"OpenHouseStartTime": "2026-07-16T17:00:00Z"
+"OpenHouseEndTime": "2026-07-16T19:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-15T15:34:59Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31984084')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30017446' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9021193 43.3329445)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25423
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+post_id: "1626132"
+post_author: 1
+"ListingKey": "30034489"
+"ListingId": "X13564610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T05:10:00Z"
+"RFModificationTimestamp": "2026-07-15T06:45:20Z"
+"ListPrice": 795900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K3"
+"UnparsedAddress": "34 KILDONAN CRESCENT, Hamilton (Waterdown), Ontario L8B0K3"
+"Coordinates": array:2 [
0 => -79.912882
1 => 43.321118
]
+"Latitude": 43.321118
+"Longitude": -79.912882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 34 Kildonan Crescent, a beautifully maintained home situated on a quiet, family-friendly crescent in one of Waterdown's most desirable neighbourhoods. Backing directly ontoscenic trails and green space with no rear neighbours, this property offers exceptionalprivacy and a peaceful natural setting.Inside, you'll find a bright and inviting layout featuring hardwood flooring, pot lightsthroughout, spacious principal rooms, and abundant natural light. The primary bedroom includesa ceiling fan for added comfort. Smart-home enthusiasts will appreciate the impressivetechnology package, including a 15-inch Alexa control centre, smart switches, smart lightingon all levels, and a smart front-door lock with fingerprint entry.Extensively updated and move-in ready, this home features a new patio door (2020), owned airconditioner (2021), renovated washrooms (2022), front door and second-floor windows (2022),energy-efficient main-level windows (2025), a newly reconstructed backyard deck (2025), and anew refrigerator (2025). The furnace, air conditioner, and water heater are all fully owned,providing added value and eliminating rental costs.Step outside to your private backyard retreat overlooking mature greenery and walking trails -perfect for entertaining, relaxing, or enjoying nature year-round. Conveniently located nearparks, schools, shopping, dining, and commuter routes, this meticulously cared-for home offersan exceptional opportunity to enjoy the best of Waterdown living. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T06:45:14.695233+00:00"
+"Directions": "Cross Streets: Dundas Street East & Burke Street. ** Directions: Hwy 403 to Hwy 6 North, exit at Dundas St. E., right on Burke St., left on Kildonan Crescent."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074363"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "26.3 x 133.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T05:03:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T05:03:02Z"
+"Stories": "2.0"
+"StreetName": "Kildonan"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4880.37"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/oNxwtfAeCQA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30034489/34-kildonan-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-07-15T05:03:02.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1349557"
+"ListOfficeNationalAssociationId": "1336201"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034489')"
+"ID": "1626132"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1621732"
+post_author: 1
+"ListingKey": "30028166"
+"ListingId": "X13558984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T22:45:02Z"
+"RFModificationTimestamp": "2026-07-14T01:10:34Z"
+"ListPrice": 849999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "205 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.912066
1 => 43.335242
]
+"Latitude": 43.335242
+"Longitude": -79.912066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spacious freehold end-unit townhouse offering approximately 1,890 sq. ft. ofbeautifully maintained living space in the heart of Waterdown.Designed for both comfortable everyday living and effortless entertaining, this bright open-concept home features large windows that fill the space with natural light while showcasingpeaceful views of the private backyard oasis.Step outside and enjoy the serene backyard backing onto a school - an ideal setting forfamilies seeking a safe, family-friendly neighbourhood with added privacy and convenience.The second floor offers 3 spacious bedrooms, including a generous primary suite complete witha walk-in closet, additional his closet, and a private ensuite bathroom. A second full bathroom provides added comfort for family and guests.Ideally located within walking distance to all schools from kindergarten through Grade 12, aswell as parks, shopping, dining, and the community centre. Commuters will appreciate the easyaccess to Hwy 6, 403, 407, the QEW, and Aldershot GO Station.This gorgeous townhouse presents an incredible opportunity for first-time home buyers, growing families, or anyone looking to settle into one of Waterdown's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T01:10:25.622227+00:00"
+"Directions": "Nisbet Blvd and Cathedral CRT"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055502"
+"ListOfficeKey": "277399"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T22:38:23Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T22:38:23Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "205"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5601"
+"View": "View"
+"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/30028166/205-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-13T22:38:23.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1330819"
+"ListOfficeNationalAssociationId": "1282815"
+"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('30028166')"
+"ID": "1621732"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1620942"
+post_author: 1
+"ListingKey": "30027846"
+"ListingId": "X13558740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T14:50:06Z"
+"RFModificationTimestamp": "2026-07-15T14:54:16Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.891184
1 => 43.331196
]
+"Latitude": 43.331196
+"Longitude": -79.891184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:43:18.555618+00:00"
+"Directions": "Cross Streets: Flamboro St. and Barton St. ** Directions: Take Highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Flat site"
3 => "Carpet Free"
]
+"LotSizeDimensions": "68.1 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T21:40:18Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T14:40:50Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30027846/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-13T21:40:18.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T13:55:22Z"
+"RFModificationTimestamp": "2026-07-15T13:57:31Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8912452
1 => 43.3312034
]
+"Latitude": 43.3312034
+"Longitude": -79.8912452
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T21:46:37.455766+00:00"
+"Directions": "Take highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024789"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-13T21:18:11Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T13:48:40Z"
+"Stories": "1.0"
+"StreetName": "FLAMBORO"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027582/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2026-07-13T21:18:11.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304516"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063598"
+"CoListOfficeNationalAssociationId": "1325425"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1619363"
+post_author: 1
+"ListingKey": "30025665"
+"ListingId": "X13556592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T12:20:11Z"
+"RFModificationTimestamp": "2026-07-14T12:27:22Z"
+"ListPrice": 1579990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "156 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.911159
1 => 43.336589
]
+"Latitude": 43.336589
+"Longitude": -79.911159
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set in a quiet, established Waterdown neighbourhood just down the street from Allan A. Greenleaf Elementary & Waterdown District High School, this beautifully cared-for home offers the kind of location, quality, and lifestyle that families rarely find all in one place. Inside, every space reflects pride of ownership and thoughtful investment. The custom 2025 kitchen sets the tone with tailored cabinetry, quartz counters, royal brass hardware, under-cabinet lighting, custom storage, a built-in bay-window bench, and a chef's island with wraparound seating that naturally becomes the heart of the home. Elegant living & dining areas, a renovated powder room, and a custom laundry room continue the refined main-floor feel. The mid-level family room is a standout retreat with a custom media wall, Napoleon electric fireplace, built-in cabinetry, a 75" LG TV, and a walkout to a covered front balcony. Upstairs, the primary suite features a double-door entry, dual walk-in closets and a beautifully renovated 5-piece ensuite. The impeccably finished lower level adds 1025 square feet of impressive flexibility with a large rec room, den or guest space, luxurious second kitchen, second laundry area, 5-pc spa-inspired bathroom, oversized walk-in closet, and above-grade windows. Out back, the property transforms into a private resort. A heated saltwater pool with a sheer-descent waterfall, interlocking patio, mature trees, landscape irrigation, and lounging & entertaining zones create an outdoor setting designed for summer days, quiet evenings, and unforgettable gatherings. Major recent updates include a $70,000 Nordik windows & doors package in 2025 with triple-pane glass & a 25-year transferable warranty; a high-efficiency furnace in 2023; a Jandy pool heater in 2025 & iAquaLink pool control. This is a home that needs to be experienced in person to fully appreciate the quality, care, and attention found in every detail. (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Cooktop"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:25:19.484551+00:00"
+"Directions": "Cross Streets: Hamilton St N/Parkside Dr. ** Directions: Hamilton St N to Nisbet Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959027"
+"ListOfficeKey": "50325"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Carpet Free"
4 => "Gazebo"
]
+"LotSizeDimensions": "48.8 x 88.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:08Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T12:07:04Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "8495"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/156_nisbet_blvd_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025665/156-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1962563"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50325"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 48.9
+"OriginalEntryTimestamp": "2026-07-13T16:40:08.57Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249697"
+"ListOfficeNationalAssociationId": "1285004"
+"CoListAgentNationalAssociationId": "1252070"
+"CoListOfficeNationalAssociationId": "1285004"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025665')"
+"ID": "1619363"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25396
+post_id: "1619412"
+post_author: 1
+"ListingKey": "30024405"
+"ListingId": "40846567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T14:05:26Z"
+"RFModificationTimestamp": "2026-07-13T17:14:32Z"
+"ListPrice": 1670000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2935.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7H5"
+"UnparsedAddress": "53 ROCKCLIFFE Road, Waterdown, Ontario L9H7H5"
+"Coordinates": array:2 [
0 => -79.8990405
1 => 43.3247123
]
+"Latitude": 43.3247123
+"Longitude": -79.8990405
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Just steps from the Niagara Escarpment and its spectacular trails where nature meets elevated living, you'll find the highly sought-after Rockcliffe community. Surrounded by an exceptional collection of both timeless and contemporary homes, this custom built bungalow is being offered for sale for the first time. Designed with quality, comfort and functionality in mind, this impressive home features a 3 car garage- large enough to host 2 SUV's and a compact car, exposed aggregate driveway, walkways and rear patio, exquisite masonry, award-winning gardens, and an in-ground sprinkler system. Inside, the welcoming front foyer opens to a thoughtfully designed open-concept floor plan with beautiful sightlines throughout the principal living spaces. A private den or home office offers flexibility to be converted into a 2nd main floor bedroom. The spacious primary suite features a private ensuite, while the elegant formal dining room is highlighted by a tray ceiling. The expansive family room is anchored by a cozy gas fireplace and framed by large windows overlooking the beautifully landscaped backyard. The kitchen has been designed to maximize every inch of space, offering abundant cabinetry and workspace as well as a central vacuum floor sweep for any crumbs! The kitchen walkout leads directly to the exposed aggregate patio, complete with the included natural gas BBQ making outdoor entertaining effortless. Adjacent to the kitchen is a well-appointed laundry room, a 2 piece bath and direct access to the garage. The lower level offers incredible flexibility with being a walk out. It could be ideal for extended family or a private guest suite. It features a finished recreation room with a gas fireplace, two bedrooms, a full bathroom, in- floor heating, ample unfinished space for storage or future customization and lastly there is the incredible rear patio surrounded by lush gardens and armour stone for an inviting peaceful retreat. Your wish list is granted! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:14:19.110786+00:00"
+"Directions": "Dundas St E to Dennis Ave to Overdale to Rockcliffe"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1669976"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T13:58:47Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T13:58:47Z"
+"Stories": "1.0"
+"StreetName": "ROCKCLIFFE"
+"StreetNumber": "53"
+"StreetSuffix": "Road"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9848.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_rockcliffe_rd_waterdown_on"
+"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/30024405/53-rockcliffe-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "01-1, R1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 77.0
+"AboveGradeFinishedArea": 2035
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-07-13T13:58:47.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1170081"
+"ListOfficeNationalAssociationId": "1003546"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024405')"
+"ID": "1619412"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1619021"
+post_author: 1
+"ListingKey": "30025187"
+"ListingId": "40843193"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T23:25:19Z"
+"RFModificationTimestamp": "2026-07-13T23:27:36Z"
+"ListPrice": 1579990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3749.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0S8"
+"UnparsedAddress": "156 NISBET Boulevard, Waterdown, Ontario L8B0S8"
+"Coordinates": array:2 [
0 => -79.9111284
1 => 43.3365682
]
+"Latitude": 43.3365682
+"Longitude": -79.9111284
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in a quiet, established Waterdown neighbourhood just down the street from Allan A. Greenleaf Elementary & Waterdown District High School, this beautifully cared-for home offers the kind of location, quality, and lifestyle that families rarely find all in one place. Inside, every space reflects pride of ownership and thoughtful investment. The custom 2025 kitchen sets the tone with tailored cabinetry, quartz counters, royal brass hardware, under-cabinet lighting, custom storage, a built-in bay-window bench, and a chef’s island with wraparound seating that naturally becomes the heart of the home. Elegant living & dining areas, a renovated powder room, and a custom laundry room continue the refined main-floor feel. The mid-level family room is a standout retreat with a custom media wall, Napoleon electric fireplace, built-in cabinetry, a 75” LG TV, and a walkout to a covered front balcony. Upstairs, the primary suite features a double-door entry, dual walk-in closets and a beautifully renovated 5-piece ensuite. The impeccably finished lower level adds 1025 square feet of impressive flexibility with a large rec room, den or guest space, luxurious second kitchen, second laundry area, 5-pc spa-inspired bathroom, oversized walk-in closet, and above-grade windows. Out back, the property transforms into a private resort. A heated saltwater pool with a sheer-descent waterfall, interlocking patio, mature trees, landscape irrigation, and lounging & entertaining zones create an outdoor setting designed for summer days, quiet evenings, and unforgettable gatherings. Major recent updates include a $70,000 Nordik windows & doors package in 2025 with triple-pane glass & a 25-year transferable warranty; a high-efficiency furnace in 2023; a Jandy pool heater in 2025 & iAquaLink pool control. This is a home that needs to be experienced in person to fully appreciate the quality, care, and attention found in every detail. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T16:34:50.295541+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237332"
+"ListOfficeKey": "94300"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Corner Site"
2 => "Conservation/green belt"
3 => "Gazebo"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T15:48:37Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T23:18:42Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8495"
+"VirtualTourURLUnbranded": "https://youtu.be/7wZQy7nQEJA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30025187/156-nisbet-boulevard-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2237557"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "94300"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2640
+"BelowGradeFinishedArea": 1109
+"OriginalEntryTimestamp": "2026-07-13T15:48:37.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1475144"
+"ListOfficeNationalAssociationId": "1188651"
+"CoListAgentNationalAssociationId": "1475444"
+"CoListOfficeNationalAssociationId": "1188651"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025187')"
+"ID": "1619021"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+post_id: "1616966"
+post_author: 1
+"ListingKey": "30021444"
+"ListingId": "X13552446"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T12:15:17Z"
+"RFModificationTimestamp": "2026-07-11T19:04:31Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 10.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L4B1W8"
+"UnparsedAddress": "44 GOLDEN HAWK DRIVE, Hamilton (Waterdown), Ontario L4B1W8"
+"Coordinates": array:2 [
0 => -79.8808833
1 => 43.3336484
]
+"Latitude": 43.3336484
+"Longitude": -79.8808833
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "unique opportunity for a family looking for an upgraded quality home in an exceptional and mature neighbourhood! Excellent layout 5 bedroom, 4 bathroom home, with a w/o basement backing onto a pond!150k spent on upgrades.10-foot ceilings, Modern Kitchen with S/S Appliances, Quartz countertop &Backsplash, Central Island, Open Concept living/Dinning with Pot Lights & Crown Moulding,Hardwood Floor, New Upgrade Bathrooms,freshly Painted, new light fixtures, gas fireplace, Shangri-La Curtains, Interlock Driveway,R-In Cvac etc. Basement potential rent $2200/month.Very Private Backyard, No Sidewalk. Close To Go Train,407/QEW,school,park. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Dryer"
2 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-11T19:04:11.527911+00:00"
+"Directions": "Cross Streets: Dundas St E/Burke St. ** Directions: Dundas st to Burke st toGolden Hawk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1639389"
+"ListOfficeKey": "91727"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "46.9 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T12:06:39Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T12:06:39Z"
+"Stories": "2.0"
+"StreetName": "Golden Hawk"
+"StreetNumber": "44"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10393.89"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021444/44-golden-hawk-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-07-11T12:06:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1164665"
+"ListOfficeNationalAssociationId": "1155942"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021444')"
+"ID": "1616966"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1615240"
+post_author: 1
+"ListingKey": "30019447"
+"ListingId": "X13550690"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T20:10:02Z"
+"RFModificationTimestamp": "2026-07-10T23:08:53Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "83 BOULDING AVENUE, Hamilton (Waterdown), Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.884312
1 => 43.342764
]
+"Latitude": 43.342764
+"Longitude": -79.884312
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well-maintained, all-brick detached home situated in the desirable east-end of Waterdown, located just minutes to QEW, 407, Go Stations, Burlington waterfront, grocery, schools, parks, trails, and more. Built in 1986, w/ various improvements, this home offers approximately 1950 ft of finished living space, including a finished basement. On a generous 50x117 lot, this property combines comfort, functionality, and an exceptional location, w/ a large backyard bordering a city park. The main level features a bright eat-in kitchen, spacious living room, and separate dining room. A convenient mudroom w/ storage & direct access to the attached 2-car garage, adds practicality for busy families. Upstairs, you'll find 3 spacious bedrooms and a 4-pc bath, w/ a walk-in closet in the primary bedroom. The fully finished basement expands the living space, including a 3-pc bath, laundry room, and ample room for a recreation area, home office, or additional family living space. The large private backyard backs onto a city park, creating a peaceful setting w/ no immediate rear neighbours. A rare opportunity to purchase a meticulously maintained home. *For Additional Property Details Click The Brochure Icon Below* (id:62650)"
+"Appliances": array:2 [
0 => "Central Vacuum"
1 => "Blinds"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T23:08:34.041882+00:00"
+"Directions": "Cross Streets: Dundas Street & Pamela Street. ** Directions: From the east:Travel west on Dundas Street, past Brant Street.Turn right on Pamela Street.Turn right on Boulding Avenue."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1851727"
+"ListOfficeKey": "273408"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.5 x 117.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T20:04:05Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T20:04:05Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "83"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6331.3"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30019447/83-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 49.6
+"OriginalEntryTimestamp": "2026-07-10T20:04:05.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1199331"
+"ListOfficeNationalAssociationId": "1250460"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019447')"
+"ID": "1615240"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 138
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]