array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30024405 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+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 [
"RoomKey" => "1683008060"
"RoomType" => "Utility room"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 20'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
1 => array:11 [
"RoomKey" => "1683008061"
"RoomType" => "Storage"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
2 => array:11 [
"RoomKey" => "1683008062"
"RoomType" => "Storage"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "22'11'' x 22'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
3 => array:11 [
"RoomKey" => "1683008063"
"RoomType" => "Recreation room"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 22'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
4 => array:11 [
"RoomKey" => "1683008064"
"RoomType" => "Cold room"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 6'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
5 => array:11 [
"RoomKey" => "1683008065"
"RoomType" => "Bedroom"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
6 => array:11 [
"RoomKey" => "1683008066"
"RoomType" => "Bedroom"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
7 => array:11 [
"RoomKey" => "1683008067"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846567"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
8 => array:11 [
"RoomKey" => "1683008068"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
9 => array:11 [
"RoomKey" => "1683008069"
"RoomType" => "Office"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
10 => array:11 [
"RoomKey" => "1683008070"
"RoomType" => "Living room"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "18'1'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
11 => array:11 [
"RoomKey" => "1683008071"
"RoomType" => "Laundry room"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.77Z"
]
12 => array:11 [
"RoomKey" => "1683008072"
"RoomType" => "Kitchen"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
13 => array:11 [
"RoomKey" => "1683008073"
"RoomType" => "Foyer"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
14 => array:11 [
"RoomKey" => "1683008074"
"RoomType" => "Dining room"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
15 => array:11 [
"RoomKey" => "1683008075"
"RoomType" => "Breakfast"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
16 => array:11 [
"RoomKey" => "1683008076"
"RoomType" => "Full bathroom"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
17 => array:11 [
"RoomKey" => "1683008077"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024405"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:47.78Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30024405_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/67823ea6c477007a32a98d14d4f89205.webp"
"MediaSize" => 188705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-67823ea6c477007a32a98d14d4f89205.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30024405_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/b1573cea6325494dbed59c9a7bccc9a0.webp"
"MediaSize" => 164243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-b1573cea6325494dbed59c9a7bccc9a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30024405_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/bcbaf68b3210493c28315317aa8fc58b.webp"
"MediaSize" => 151622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-bcbaf68b3210493c28315317aa8fc58b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30024405_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/2ccb7e6774d8ebcb8352be60c8ba2819.webp"
"MediaSize" => 176792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-2ccb7e6774d8ebcb8352be60c8ba2819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30024405_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/e530f149c1bf9dc94f6d147c4d14d2df.webp"
"MediaSize" => 96601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-e530f149c1bf9dc94f6d147c4d14d2df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30024405_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/bde2edf3be57237810184fc65e55438a.webp"
"MediaSize" => 89201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-bde2edf3be57237810184fc65e55438a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30024405_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/d0fd4339fab7736754c6d5188870c5d3.webp"
"MediaSize" => 78792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-d0fd4339fab7736754c6d5188870c5d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30024405_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/6888a9f8c7e17af843406578aa8dc22e.webp"
"MediaSize" => 89931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-6888a9f8c7e17af843406578aa8dc22e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30024405_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/98460d38f0b2f8b1d6f81e054a749c36.webp"
"MediaSize" => 96269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-98460d38f0b2f8b1d6f81e054a749c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30024405_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/60791cb0b37a7253c3549c34db66ffee.webp"
"MediaSize" => 101310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-60791cb0b37a7253c3549c34db66ffee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30024405_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/2cf50a90b06a9476da3fcf3c9bcfa5c1.webp"
"MediaSize" => 98963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-2cf50a90b06a9476da3fcf3c9bcfa5c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30024405_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/2f73654fc02a65466497389965531ca0.webp"
"MediaSize" => 82621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-2f73654fc02a65466497389965531ca0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30024405_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/6ca6677974c600716c83f73a06de4a38.webp"
"MediaSize" => 96632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-6ca6677974c600716c83f73a06de4a38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30024405_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/b22fd2c7aeed28a3835f82e4e38bb903.webp"
"MediaSize" => 108416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-b22fd2c7aeed28a3835f82e4e38bb903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30024405_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/a25aad09116f0a18df60ed644c06d519.webp"
"MediaSize" => 88715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-a25aad09116f0a18df60ed644c06d519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30024405_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/6bbb3995c79a77183395688a726fa2e4.webp"
"MediaSize" => 88707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-6bbb3995c79a77183395688a726fa2e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30024405_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/d8ae0ece22cf9280e40603c0c5c12e92.webp"
"MediaSize" => 81947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-d8ae0ece22cf9280e40603c0c5c12e92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30024405_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/b3c669a8c7b10816ad68c39019ae29d4.webp"
"MediaSize" => 83840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-b3c669a8c7b10816ad68c39019ae29d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30024405_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/3ebbfcbd1a09a9ea3ae3dc814d17e747.webp"
"MediaSize" => 89842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-3ebbfcbd1a09a9ea3ae3dc814d17e747.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30024405_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/44336a42c57db4f09e36c7be5d195546.webp"
"MediaSize" => 101539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-44336a42c57db4f09e36c7be5d195546.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30024405_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/23c2d9f8cc2e95d6072334c79bfafaa9.webp"
"MediaSize" => 102698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-23c2d9f8cc2e95d6072334c79bfafaa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30024405_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/385d4b391922ff8f1adf2f7824bc5bce.webp"
"MediaSize" => 100619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-385d4b391922ff8f1adf2f7824bc5bce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30024405_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/1a6d62d8d773236af0f10936f3fd320c.webp"
"MediaSize" => 97722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-1a6d62d8d773236af0f10936f3fd320c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30024405_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/598d040124a4cd8672f94b3804570891.webp"
"MediaSize" => 72196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-598d040124a4cd8672f94b3804570891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30024405_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/4a815192454087236b7cc3775bc068ba.webp"
"MediaSize" => 85554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-4a815192454087236b7cc3775bc068ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30024405_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/1e04a169680494052a8fc3314edd4680.webp"
"MediaSize" => 60381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-1e04a169680494052a8fc3314edd4680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30024405_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/095b87ca5b06ec4d660f51289a8939fd.webp"
"MediaSize" => 71984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-095b87ca5b06ec4d660f51289a8939fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30024405_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/ee20b8985571f35a1e9ed2d8133b922b.webp"
"MediaSize" => 83530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-ee20b8985571f35a1e9ed2d8133b922b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30024405_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/b4c602eff75706bb4661d97e08be012e.webp"
"MediaSize" => 91278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-b4c602eff75706bb4661d97e08be012e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30024405_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/e7aa3821aed8997299284fbd3ec58b87.webp"
"MediaSize" => 67783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-e7aa3821aed8997299284fbd3ec58b87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30024405_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/9ef3c0b75ae454ecd5af21a3d3840bda.webp"
"MediaSize" => 60857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-9ef3c0b75ae454ecd5af21a3d3840bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30024405_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/38d716910af3f265b0ca77641b28adb9.webp"
"MediaSize" => 66587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-38d716910af3f265b0ca77641b28adb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30024405_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/470853066dc990fa10dee901e45bcb26.webp"
"MediaSize" => 72910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-470853066dc990fa10dee901e45bcb26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30024405_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/1a8b677842b15c6d47b90d20fc6a3c31.webp"
"MediaSize" => 90474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-1a8b677842b15c6d47b90d20fc6a3c31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30024405_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/edb105fd413076dfecc8d8e837bc1979.webp"
"MediaSize" => 89250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-edb105fd413076dfecc8d8e837bc1979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30024405_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/a27783d44c33f33377c40c0415604309.webp"
"MediaSize" => 89055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-a27783d44c33f33377c40c0415604309.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30024405_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/f8c2464a3476b4d47da6994f0faede32.webp"
"MediaSize" => 64380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-f8c2464a3476b4d47da6994f0faede32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30024405_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/ec70a79be599d4f96ef1c44e2f1306cd.webp"
"MediaSize" => 84173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-ec70a79be599d4f96ef1c44e2f1306cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30024405_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/03de435d3e961515b78024d456604f8f.webp"
"MediaSize" => 90378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-03de435d3e961515b78024d456604f8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846567"
"ResourceRecordKey" => "30024405"
"ModificationTimestamp" => "2026-07-13T13:58:47.74Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30024405_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024405/715f1c0e5049bb499f36a668bb21b121.webp"
"MediaSize" => 182796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024405/thumbnail-715f1c0e5049bb499f36a668bb21b121.webp"
…7
]
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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024405')"
+"ID": "1619412"
}
]
+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 55164" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25005
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24949
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Burloak Real Estate Services"
+"OfficeEmail": null
+"OfficePhone": "905-335-3042"
+"OfficeMlsId": "HBROYBURLM"
+"ModificationTimestamp": "2025-07-09T18:17:42Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55164"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "Suite#200-3060 Mainway"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M1A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003546"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-335-1659"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1196412"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('55164')"
}
]
+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 1669976" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24959
+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 '30024405'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+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 '30024405' AND OpenHouseDate ge '2026-07-13'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25330
+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 '30024405' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8990405 43.3247123)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25403
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028166')"
+"ID": "1621732"
}
1 => 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-13T21:50:04Z"
+"RFModificationTimestamp": "2026-07-13T22:43:29Z"
+"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-13T21:40:18Z"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25396
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:25:18Z"
+"RFModificationTimestamp": "2026-07-13T21:46:42Z"
+"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-13T21:18:11Z"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025665')"
+"ID": "1619363"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25398
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025187')"
+"ID": "1619021"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25393
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021444')"
+"ID": "1616966"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1614668"
+post_author: 1
+"ListingKey": "30019661"
+"ListingId": "X13550936"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T21:15:04Z"
+"RFModificationTimestamp": "2026-07-11T21:16:36Z"
+"ListPrice": 859999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X2"
+"UnparsedAddress": "9 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X2"
+"Coordinates": array:2 [
0 => -79.901279
1 => 43.32707
]
+"Latitude": 43.32707
+"Longitude": -79.901279
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stylish executive townhome spanning 1885 SF above-grade and delivers exceptional functionality across a spacious multi-level layout. Step inside through the tiled foyer to discover a versatile ground-level bedroom complete with a private 4-piece ensuite, ideal for guests, multigenerational living, or a sophisticated home office. Ascend to the main level where rich hardwood flooring, oversized windows, recessed lighting, and an airy open-concept design create an inviting atmosphere throughout. The contemporary kitchen is thoughtfully equipped with stainless steel appliances, extensive cabinetry, a generous centre island with breakfast seating, and a walk-in pantry, seamlessly connecting to the spacious dining area designed for both everyday living and effortless entertaining. Walk out to the expansive private balcony , which offers the perfect setting for summer dining, morning coffee, or evenings spent unwinding outdoors. The adjoining living room provides a warm and welcoming retreat, anchored by natural light and ample space for gathering with family and friends. The upper level features three well-appointed bedrooms, including the serene primary suite complete with a walk-in closet and private 3-piece ensuite. Two additional bedrooms, a full 4-piece bathroom, and convenient upper-level laundry complete the well-designed interior. An unfinished lower level offers additional storage and future potential to customize the space to suit your lifestyle. Additional highlights include a double car garage with interior access and garage door remotes, and maintenance fees covering snow removal, garbage pickup, lawn and garden care, and exterior building upkeep for true lock-and-leave convenience. This exceptional location places you close to the scenic Smokey Hollow trails, scenic parks, excellent schools, and convenient commuter access to Burlington, Hamilton, and the GTA. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T21:06:58.907922+00:00"
+"Directions": "Cross Streets: Hamilton St N / Dundas St E. ** Directions: via Dundas St E/Hamilton Regional Rd 5."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417634"
+"ListOfficeKey": "270338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "In suite Laundry"
2 => "Guest Suite"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T20:39:06Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T21:08:38Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6036"
+"VirtualTourURLUnbranded": "https://vimeo.com/share/fe3475d8-67a5-4a2a-bcf5-fa02edb01796?share=copy&fl=sv&fe=ci"
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30019661/9-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-07-10T20:39:06.7Z"
+"ListAgentNationalAssociationId": "1035732"
+"ListOfficeNationalAssociationId": "1235224"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019661')"
+"ID": "1614668"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1612639"
+post_author: 1
+"ListingKey": "30017446"
+"ListingId": "40845410"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T20:20:07Z"
+"RFModificationTimestamp": "2026-07-12T20:24:03Z"
+"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-12T20:13:31Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "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 [ …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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017446')"
+"ID": "1612639"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1610402"
+post_author: 1
+"ListingKey": "30013506"
+"ListingId": "40846843"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T20:25:24Z"
+"RFModificationTimestamp": "2026-07-12T20:28:50Z"
+"ListPrice": 2399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.274
+"LivingArea": 4887.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "81 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8849311
1 => 43.334616
]
+"Latitude": 43.334616
+"Longitude": -79.8849311
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Inspired by timeless European architecture, this distinguished residence pairs classic character with beautifully reimagined interiors, creating a home that feels both refined and effortlessly livable. Set on one of Waterdown's most coveted tree-lined streets, surrounded by mature homes and an established sense of community, it offers more than 4800 sq ft of finished living space. Step inside and your eye is immediately drawn to the elegant central staircase—an architectural focal point that anchors the home. From the kitchen to the dining area and into the inviting living rm, each space flows naturally into the next, creating the perfect setting for everything from quiet weekday mornings to lively holiday celebrations. A versatile main-floor office offers the flexibility to work from home, create a children's playroom, or design a cozy lounge tailored to your lifestyle. Then, almost seamlessly, the indoors give way to the outdoors. Open the doors from the sunroom and discover a backyard designed for entertaining on every scale. The saltwater pool becomes the centerpiece of summer, while the pergola creates an inviting space to dine, unwind, or gather with friends long after sunset. Framed by mature landscaping and exceptional privacy, it's a backyard that feels like a private retreat without ever leaving home. The second level is equally impressive, offering four spacious bdrms, the convenience of bdrm-level laundry, and a thoughtfully designed primary retreat complete with its own walk-in dressing rm and a beautifully appointed five-pc ensuite. Completing the home is a fully finished lower lvl, providing exceptional flexibility for family movie nights, a home gym, games room, or additional living space as your needs evolve. Timeless in its architecture, exceptional in its design, and perfectly positioned within one of Waterdown's most sought-after neighbourhoods, this is more than a home-it's where everyday living is elevated and lasting memories are made. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T21:49:32.478193+00:00"
+"Directions": "MOUNTAIN BROW RD TO FLANDERS DR"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043485"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Recreational"
]
+"LotSizeDimensions": "0.274"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T20:02:31Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T20:18:20Z"
+"Stories": "2.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "81"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "18628"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30013506/81-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 3845
+"BelowGradeFinishedArea": 1042
+"OriginalEntryTimestamp": "2026-07-09T19:59:21.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1319320"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013506')"
+"ID": "1610402"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 123
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]