array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30069107 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1653706"
+post_author: 1
+"ListingKey": "30069107"
+"ListingId": "40850435"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T01:10:03Z"
+"RFModificationTimestamp": "2026-07-25T01:19:40Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2022.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T3"
+"UnparsedAddress": "4 BOUSFIELD Court, Waterdown, Ontario L8B0T3"
+"Coordinates": array:2 [
0 => -79.9200053
1 => 43.3269474
]
+"Latitude": 43.3269474
+"Longitude": -79.9200053
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 4 Bousfield Court! Nestled on a cult de sac next to a pond. This beautifully updated 3-bedroom, 3-bath home offers luxury and privacy in one of Waterdown's most desirable neighbourhoods. The open-concept main floor is enhanced by rich hardwood flooring, custom lighting, and impressive coffered ceilings, a chef-inspired kitchen with granite countertops, gas stove and plenty of storage . Upstairs, the spacious primary suite offers a spa-like ensuite with heated honed marble floors, soaker tub and marble shower. Step outside to your professionally landscaped backyard complete with a pond, gazebo, and lush greenery. Additional highlights include an on-demand hot water system, 2nd floor laundry room with overflow drain, EV charger plug, and numerous updates throughout. Close to parks, schools, shopping, and commuter routes, this move-in-ready home truly has it all. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:57:19.869705+00:00"
+"Directions": "Parkside to Sadielou to Gundy to Bousfield"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917243"
+"ListOfficeKey": "264845"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T01:00:24Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T01:08:27Z"
+"Stories": "2.0"
+"StreetName": "BOUSFIELD"
+"StreetNumber": "4"
+"StreetSuffix": "Court"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7799"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1692871977"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
1 => array:11 [
"RoomKey" => "1692871978"
"RoomType" => "Laundry room"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
2 => array:11 [
"RoomKey" => "1692871979"
"RoomType" => "Bedroom"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
3 => array:11 [
"RoomKey" => "1692871980"
"RoomType" => "Bedroom"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
4 => array:11 [
"RoomKey" => "1692871981"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
5 => array:11 [
"RoomKey" => "1692871982"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850435"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
6 => array:11 [
"RoomKey" => "1692871983"
"RoomType" => "Dinette"
"ListingId" => "40850435"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
7 => array:11 [
"RoomKey" => "1692871984"
"RoomType" => "Kitchen"
"ListingId" => "40850435"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
8 => array:11 [
"RoomKey" => "1692871985"
"RoomType" => "Great room"
"ListingId" => "40850435"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
9 => array:11 [
"RoomKey" => "1692871986"
"RoomType" => "2pc Bathroom"
"ListingId" => "40850435"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
10 => array:11 [
"RoomKey" => "1692871987"
"RoomType" => "Foyer"
"ListingId" => "40850435"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069107"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T01:08:27.03Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30069107/4-bousfield-court-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2022
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-23T11:48:33.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1225588"
+"ListOfficeNationalAssociationId": "1225289"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30069107_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/3825e57dde45329e55aa35cafa43ff0e.webp"
"MediaSize" => 133625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-3825e57dde45329e55aa35cafa43ff0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade residence featuring a two-car garage, covered porch entry, and mature front landscaping"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30069107_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/c69817be7e2fdfd6cc7c1688aedd5308.webp"
"MediaSize" => 152184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-c69817be7e2fdfd6cc7c1688aedd5308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade residence featuring a two-car garage, established landscaping, and a covered front porch with steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30069107_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/36c7bc6339ea4fcd65766f79a47aa2c1.webp"
"MediaSize" => 134529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-36c7bc6339ea4fcd65766f79a47aa2c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone exterior featuring a covered front porch with columns, a two-car garage with a panel door, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30069107_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/cf7f1f3888098bcbe039ae2e81243905.webp"
"MediaSize" => 62521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-cf7f1f3888098bcbe039ae2e81243905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring large format floor tiles, a dark wood staircase with wrought iron balusters, and a solid black entry door with frosted glass paneling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30069107_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/f1d683b177575fc11c61f9783deb2c4a.webp"
"MediaSize" => 65051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-f1d683b177575fc11c61f9783deb2c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30069107_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/5cb9b06c3c9fd206b2f47797407a2ceb.webp"
"MediaSize" => 84792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-5cb9b06c3c9fd206b2f47797407a2ceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry foyer featuring tile flooring, a dark-paneled door with glass inserts and transom, a recessed ceiling light, a dark wood staircase with wrought iron balusters, and a light-colored wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30069107_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/2475caa464b39f8f02d97f834304121e.webp"
"MediaSize" => 85018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-2475caa464b39f8f02d97f834304121e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting foyer featuring large format tile flooring, a dark wood staircase with wrought iron balusters, recessed lighting, and a white paneled door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30069107_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/be090a61b4a3f57b1f9569a6eaf144f2.webp"
"MediaSize" => 89366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-be090a61b4a3f57b1f9569a6eaf144f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring coffered ceilings with recessed lighting, dark wood-finish flooring, a large multi-pane window with white blinds, and a kitchen island with built-in storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30069107_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/929c6ea467e4f91610e0ed4816fcbcbd.webp"
"MediaSize" => 91836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-929c6ea467e4f91610e0ed4816fcbcbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring rich wood-finish flooring, recessed lighting, and a coffered ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30069107_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/f98e2b97c1f4f95851afdfa8eaaa6369.webp"
"MediaSize" => 83306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-f98e2b97c1f4f95851afdfa8eaaa6369.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright open-concept living space featuring coffered ceilings with recessed lighting, dark wood-finish flooring, a contemporary kitchen with white cabinetry, stainless steel appliances, and a central i"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30069107_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/c35c7bd5a23cb98411096fee9c3880a0.webp"
"MediaSize" => 90413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-c35c7bd5a23cb98411096fee9c3880a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring coffered ceilings, recessed lighting, and rich wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30069107_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/367bbf39e90224631d655985a461915c.webp"
"MediaSize" => 85466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-367bbf39e90224631d655985a461915c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring dark wood-finish flooring, a coffered ceiling with recessed lighting, a window with exterior grilles, and a light-toned wall finish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30069107_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/6a3fb65a1d1329cdce7794a0d8056519.webp"
"MediaSize" => 84726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-6a3fb65a1d1329cdce7794a0d8056519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, granite countertops, wood-finish flooring, and a built-in wine rack"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30069107_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/04fdc383ad837afdf68f6a82014668be.webp"
"MediaSize" => 78042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-04fdc383ad837afdf68f6a82014668be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry with gold-toned hardware, stainless steel appliances, speckled stone countertops, and dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30069107_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/778a5dea9240b96ea933411dc7f1bbe9.webp"
"MediaSize" => 69396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-778a5dea9240b96ea933411dc7f1bbe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry, a stainless steel refrigerator, a large island with a light-toned countertop, a tile backsplash, and dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30069107_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/7f65fa0e9c4c6b81ca2f6424846cac49.webp"
"MediaSize" => 98804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-7f65fa0e9c4c6b81ca2f6424846cac49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a dark wood-finish table, a drum chandelier with crystal accents, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30069107_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/7d15123ca3aafdc99899c3e8a6b358ea.webp"
"MediaSize" => 66714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-7d15123ca3aafdc99899c3e8a6b358ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a large island with a stainless steel sink and a contemporary pendant light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30069107_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/1e77935bf9039c49f736ad8ccc10297d.webp"
"MediaSize" => 90368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-1e77935bf9039c49f736ad8ccc10297d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a stainless steel farmhouse sink, integrated dishwasher, and granite countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30069107_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/18ab3eb0bb81046a099bbbb3f067aa8a.webp"
"MediaSize" => 37228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-18ab3eb0bb81046a099bbbb3f067aa8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White pedestal sink with a chrome faucet, set against a dark wall and topped with a round, framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30069107_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/8bd354701c189d1b435192a5de14e0a7.webp"
"MediaSize" => 94082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-8bd354701c189d1b435192a5de14e0a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30069107_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/6cc893a97989926898316646a0ed7fe7.webp"
"MediaSize" => 63663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-6cc893a97989926898316646a0ed7fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30069107_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/e0dde30b4ee2fde3468fd71c044b83ea.webp"
"MediaSize" => 76261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-e0dde30b4ee2fde3468fd71c044b83ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a ceiling fan, a window with blinds and drapes, and a sliding barn door entry to an adjacent space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30069107_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/1497d4d36e4b2e9693fc0d7d14813f94.webp"
"MediaSize" => 72601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-1497d4d36e4b2e9693fc0d7d14813f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious carpeted room featuring a ceiling fan with integrated lighting, a broad window with blinds, and a contrasting accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30069107_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/cfb27086b83e54786b407c103a1d57f7.webp"
"MediaSize" => 80228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-cfb27086b83e54786b407c103a1d57f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral wall paint, ceiling fan with dark wood-finish blades, and soft carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30069107_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/e9c8d7acc39940818926883fa4e70999.webp"
"MediaSize" => 55093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-e9c8d7acc39940818926883fa4e70999.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a dark wood-finish vanity with an integrated white sink, a frameless glass shower enclosure with striped wall tiling, a rectangular mirror with a textured frame, and li"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30069107_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/cb2602dd124e6b97c4736c829f0c943a.webp"
"MediaSize" => 75131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-cb2602dd124e6b97c4736c829f0c943a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern bathroom featuring a freestanding tub, dark wood-finish vanity with an integrated sink, and a large window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30069107_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/b0ff8edbe0125700fb3dcc8ccfa699ef.webp"
"MediaSize" => 71276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-b0ff8edbe0125700fb3dcc8ccfa699ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a frameless glass shower enclosure with a vertical mosaic tile accent, a rainfall showerhead, and a separate handheld shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30069107_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/77c0894efba67e095cfe6899758ecd5d.webp"
"MediaSize" => 71110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-77c0894efba67e095cfe6899758ecd5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light gray wall paint, light-colored carpeting, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30069107_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/ebc536e7c497b203a4dc4cb00d6baa5f.webp"
"MediaSize" => 63862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-ebc536e7c497b203a4dc4cb00d6baa5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring a large window with blinds and drapes, light-toned carpeting, a modern ceiling light fixture, and double panel doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30069107_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/d2f903ce7a487bc5435d3fb00ff4b9c5.webp"
"MediaSize" => 68897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-d2f903ce7a487bc5435d3fb00ff4b9c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a vessel sink, speckled countertop, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30069107_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/98d119ba8130867a05466086efd68e87.webp"
"MediaSize" => 156087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-98d119ba8130867a05466086efd68e87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30069107_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/4a87076e06c0ca42bc4aab4035bf5758.webp"
"MediaSize" => 180404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-4a87076e06c0ca42bc4aab4035bf5758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor patio area featuring a wooden deck, gravel ground cover, a large tree, and a pergola structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30069107_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/5b796e04e85fcae62fff7128ebecf831.webp"
"MediaSize" => 167082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-5b796e04e85fcae62fff7128ebecf831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor patio area featuring a wooden deck, gravel ground cover, a large tree, and a pergola structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30069107_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/5436f9a8f3c047cd558d6c29b82d8c02.webp"
"MediaSize" => 155012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-5436f9a8f3c047cd558d6c29b82d8c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor living area featuring a wooden deck with a built-in gazebo, stone patio, and mature landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30069107_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069107/b68002e9f99789ba3a94f210f542c930.webp"
"MediaSize" => 158892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069107/thumbnail-b68002e9f99789ba3a94f210f542c930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck area featuring light wood planks, a multi-level design, and a sliding glass door entry to the main structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850435"
"ResourceRecordKey" => "30069107"
"ModificationTimestamp" => "2026-07-23T11:48:33.55Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069107')"
+"ID": "1653706"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 264845" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25073
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25016
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "One Percent Realty Ltd."
+"OfficeEmail": null
+"OfficePhone": "888-966-3111"
+"OfficeMlsId": "HBONEPERCENT"
+"ModificationTimestamp": "2026-02-05T16:13:02Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "264845"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "177 West 23rd Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Hamilton"
+"OfficePostalCode": "L9C4V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1225289"
+"OriginalEntryTimestamp": "2011-07-04T17:31:00Z"
+"OfficeFax": "888-870-0411"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "454674"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "264845"
"SocialMediaUrlOrId" => "https://www.ontario.onepercentrealty.com/"
"ModificationTimestamp" => "2026-02-05T13:57:00Z"
]
]
+"FranchiseNationalAssociationId": "1240005"
+"OfficeBrokerNationalAssociationId": "1236903"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('264845')"
}
]
+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 1917243" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25096
+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 '30069107'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25394
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30069107' AND OpenHouseDate ge '2026-07-27'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25410
+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 '30069107' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9200053 43.3269474)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25463
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: "1658049"
+post_author: 1
+"ListingKey": "30077575"
+"ListingId": "X13604092"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T19:45:03Z"
+"RFModificationTimestamp": "2026-07-27T19:47:59Z"
+"ListPrice": 1075000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1K5"
+"UnparsedAddress": "162 5TH CONCESSION ROAD E, Hamilton, Ontario L8B1K5"
+"Coordinates": array:2 [
0 => -79.9298098
1 => 43.3413288
]
+"Latitude": 43.3413288
+"Longitude": -79.9298098
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautifully kept country home set just minutes from Waterdown and its full range of amenities. This charming two-storey residence blends character, comfort, and rare rural conveniences like natural gas and high-speed internet. Warm natural wood and gumwood trim frame the main floor, complemented by cared-for hardwood floors and a kitchen featuring a pantry, peninsula, gas stove, and a generous eating area. A handy main-floor 2-piece bath adds everyday practicality. Upstairs, two bright bedrooms are paired with a renovated 3-piece bath showcasing a large shower, updated vanity, and modern fixtures. The property includes a 24' x 32' double garage, ideal for vehicles, hobbies, or storage. Set on 2.92 acres, the property offers a park-like setting perfect for kids, pets, gatherings, or quiet enjoyment. The location is exceptional-East Flamborough, close to golf courses, minutes to many horse facilities, and just a short drive to a dog park, soccer fields, baseball diamonds, arenas, scenic hiking and biking trails and various Conservation areas. For commuters, highway access is quick and convenient. Whether enjoyed as-is, expanded, or considered as a potential estate building lot (subject to Conservation Authority review), this is a rare opportunity to secure a solid country home in a premium location. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T23:03:54.891283+00:00"
+"Directions": "Cross Streets: HIGHWAY 6. ** Directions: HWY 6 OR CENTRE RD TO 5TH CONC RD EAST. WEST FROM CENTRE RD."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080849"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Sloping"
2 => "Conservation/green belt"
3 => "Level"
]
+"LotSizeDimensions": "135 x 942 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T18:37:31Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T19:36:08Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "5TH CONCESSION"
+"StreetNumber": "162"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7220.19"
+"VirtualTourURLUnbranded": "https://youriguide.com/162_concession_5_rd_e_Flamborough_on/"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1694863244"
"RoomType" => "Living room"
"ListingId" => "X13604092"
"RoomLevel" => "Main level"
"RoomWidth" => 3.78
"ListingKey" => "30077575"
"RoomLength" => 5.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
1 => array:11 [
"RoomKey" => "1694863245"
"RoomType" => "Dining room"
"ListingId" => "X13604092"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "30077575"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
2 => array:11 [
"RoomKey" => "1694863246"
"RoomType" => "Kitchen"
"ListingId" => "X13604092"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "30077575"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
3 => array:11 [
"RoomKey" => "1694863247"
"RoomType" => "Bathroom"
"ListingId" => "X13604092"
"RoomLevel" => "Main level"
"RoomWidth" => 0.77
"ListingKey" => "30077575"
"RoomLength" => 1.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
4 => array:11 [
"RoomKey" => "1694863248"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13604092"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "30077575"
"RoomLength" => 6.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
5 => array:11 [
"RoomKey" => "1694863249"
"RoomType" => "Bedroom 2"
"ListingId" => "X13604092"
"RoomLevel" => "Second level"
"RoomWidth" => 4.71
"ListingKey" => "30077575"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
6 => array:11 [
"RoomKey" => "1694863250"
"RoomType" => "Bathroom"
"ListingId" => "X13604092"
"RoomLevel" => "Second level"
"RoomWidth" => 1.88
"ListingKey" => "30077575"
"RoomLength" => 2.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-27T19:36:08.5Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30077575/162-5th-concession-road-e-hamilton-rural-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 135.0
+"OriginalEntryTimestamp": "2026-07-24T20:39:22.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355767"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30077575_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/a11bfc57f053debd725948c5663d9318.webp"
"MediaSize" => 422074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-a11bfc57f053debd725948c5663d9318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30077575_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/35b0b1764a437a3aaea052a09a6e7fec.webp"
"MediaSize" => 470804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-35b0b1764a437a3aaea052a09a6e7fec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30077575_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/38fe231a633c36946165c670165974a7.webp"
"MediaSize" => 290462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-38fe231a633c36946165c670165974a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30077575_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/1167ff5c379b6c7fbe5f9f1d4c3e9475.webp"
"MediaSize" => 448639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-1167ff5c379b6c7fbe5f9f1d4c3e9475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30077575_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/a7448bbcff713dbff802c3cfb406cf78.webp"
"MediaSize" => 453623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-a7448bbcff713dbff802c3cfb406cf78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30077575_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/958afc46ead9236f6b9e377ee39ea980.webp"
"MediaSize" => 447246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-958afc46ead9236f6b9e377ee39ea980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604092"
"ResourceRecordKey" => "30077575"
"ModificationTimestamp" => "2026-07-24T20:39:22.32Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30077575_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077575/dd89dff13268fbc74ba172b1feff9c67.webp"
"MediaSize" => 326995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077575/thumbnail-dd89dff13268fbc74ba172b1feff9c67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077575')"
+"ID": "1658049"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25459
+post_id: "1657261"
+post_author: 1
+"ListingKey": "30077107"
+"ListingId": "40849326"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T19:20:05Z"
+"RFModificationTimestamp": "2026-07-27T19:24:36Z"
+"ListPrice": 1075000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.92
+"LivingArea": 1150.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L0R2H1"
+"UnparsedAddress": "162 5TH CONC Road E, Flamborough, Ontario L0R2H1"
+"Coordinates": array:2 [
0 => -79.9367712
1 => 43.3360493
]
+"Latitude": 43.3360493
+"Longitude": -79.9367712
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A beautifully kept country home set just minutes from Waterdown and its full range of amenities. This charming two-storey residence blends character, comfort, and rare rural conveniences like natural gas and high-speed internet. Warm natural wood and gumwood trim frame the main floor, complemented by cared-for hardwood floors and a kitchen featuring a pantry, peninsula, gas stove, and a generous eating area. A handy main-floor 2-piece bath adds everyday practicality. Upstairs, two bright bedrooms are paired with a renovated 3-piece bath showcasing a large shower, updated vanity, and modern fixtures. The property includes a 24' x 32' double garage, ideal for vehicles, hobbies, or storage. Set on 2.92 acres, the property offers a park-like setting perfect for kids, pets, gatherings, or quiet enjoyment. The location is exceptional—East Flamborough, close to golf courses, minutes to many horse facilities, and just a short drive to a dog park, soccer fields, baseball diamonds, arenas, scenic hiking and biking trails and various Conservation areas. For commuters, highway access is quick and convenient. Whether enjoyed as-is, expanded, or considered as a potential estate building lot (subject to Conservation Authority review), this is a rare opportunity to secure a solid country home in a premium location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:54:29.214398+00:00"
+"Directions": "HWY 6 OR CENTRE RD TO THE 5TH CONC RD EAST. WEST FROM CENTRE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "2.92"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T19:12:57Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T19:12:57Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "5TH CONC"
+"StreetNumber": "162"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "7220.19"
+"VirtualTourURLUnbranded": "https://youriguide.com/162_concession_5_rd_e_Flamborough_on/"
+"WaterSource": array:1 [
0 => "Well"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30077107/162-5th-conc-road-e-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1525315"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1677992"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 1150
+"OriginalEntryTimestamp": "2026-07-24T19:29:40.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063775"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1089333"
+"CoListAgentNationalAssociationId2": "1171967"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077107')"
+"ID": "1657261"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25456
+post_id: "1656257"
+post_author: 1
+"ListingKey": "30074545"
+"ListingId": "40850829"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T13:45:03Z"
+"RFModificationTimestamp": "2026-07-24T17:30:08Z"
+"ListPrice": 817900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1707.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T5"
+"UnparsedAddress": "28 MCCURDY Avenue, Waterdown, Ontario L8B0T5"
+"Coordinates": array:2 [
0 => -79.9222125
1 => 43.3293489
]
+"Latitude": 43.3293489
+"Longitude": -79.9222125
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "New Construction! Backing onto the newly constructed Clear Skies Park, this end unit townhome is starting construction and will be available to move in early 2027. Featuring over 1,707 sq ft, 3 bedrooms, 2.5 baths, this home is spacious and offers ample room for a growing family. The main floor boasts a large great room and chef's kitchen, perfect for entertaining. The second level has 3 bedrooms including a large master bedroom with ensuite. There is still time to choose your own finishings! Don't miss out, this home will sell fast. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T17:30:00.194229+00:00"
+"Directions": "Sadie Lou Blvd & McCurdy Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523872"
+"ListOfficeKey": "54955"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T13:38:19Z"
+"PhotosCount": 4
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T13:38:19Z"
+"Stories": "2.0"
+"StreetName": "MCCURDY"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30074545/28-mccurdy-avenue-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1707
+"OriginalEntryTimestamp": "2026-07-24T13:38:19.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1063819"
+"ListOfficeNationalAssociationId": "1003569"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30074545')"
+"ID": "1656257"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25460
+post_id: "1653708"
+post_author: 1
+"ListingKey": "30071803"
+"ListingId": "40850115"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:23Z"
+"RFModificationTimestamp": "2026-07-26T20:38:32Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 1.003
+"LivingArea": 2556.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1K4"
+"UnparsedAddress": "19 CONCESSION 5 E, Waterdown, Ontario L8B1K4"
+"Coordinates": array:2 [
0 => -79.9427302
1 => 43.3326276
]
+"Latitude": 43.3326276
+"Longitude": -79.9427302
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on a private one-acre lot just six minutes from the heart of Waterdown, this 2500+ square foot custom built bungalow offers an ideal combination of space, comfort and versatility. With four-plus-one bedrooms total, the property is well suited for families, downsizers or multi-generational living. The main home is warm and inviting, featuring an updated kitchen, cozy gas fireplace, abundant natural light, renovated bathrooms and stylish new flooring, creating a seamless blend of modern finishes and rural charm. The spacious primary suite is a true retreat, complete with a walk-in closet, private ensuite and walkout to a secluded hot tub area—offering a quiet space to relax and unwind. Outside, the expansive lot provides exceptional privacy surrounded by nature, making it ideal for entertaining, gardening or enjoying peaceful country living. A rare and highly valuable feature is the fully self-sufficient 800 square foot, one-and-a-half storey detached ADU. It includes a functional main level with full kitchen plus a large bedroom with a four-piece bathroom, private laundry and carport. This thoughtfully designed space offers complete independence for extended family or guests, while keeping everyone close - delivering the best of both worlds. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:9 [
0 => "Refrigerator"
1 => "Water purifier"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:53:59.894020+00:00"
+"Directions": "HY6 & CONCESSION 5 E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Shared Driveway"
2 => "Country residential"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "1.003"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T20:31:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CONCESSION 5"
+"StreetNumber": "19"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "10610"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019f8a06-4f70-7315-9a6f-3eb01ace19ec"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30071803/19-concession-5-e-waterdown"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 145.0
+"AboveGradeFinishedArea": 2556
+"OriginalEntryTimestamp": "2026-07-23T18:38:33.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071803')"
+"ID": "1653708"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25458
+post_id: "1653709"
+post_author: 1
+"ListingKey": "30071835"
+"ListingId": "X13598914"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T12:20:07Z"
+"RFModificationTimestamp": "2026-07-27T12:21:46Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1K4"
+"UnparsedAddress": "19 CONCESSION 5 E, Hamilton, Ontario L8B1K4"
+"Coordinates": array:2 [
0 => -79.942719
1 => 43.332634
]
+"Latitude": 43.332634
+"Longitude": -79.942719
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a private one-acre lot just six minutes from the heart of Waterdown, this 2500+ square foot custom built bungalow offers an ideal combination of space, comfort and versatility. With four-plus-one bedrooms total, the property is well suited for families, downsizers or multi-generational living. The main home is warm and inviting, featuring an updated kitchen, cozy gas fireplace, abundant natural light, renovated bathrooms and stylish new flooring, creating a seamless blend of modern finishes and rural charm. The spacious primary suite is a true retreat, complete with a walk-in closet, private ensuite and walkout to a secluded hot tub area-offering a quiet space to relax and unwind. Outside, the expansive lot provides exceptional privacy surrounded by nature, making it ideal for entertaining, gardening or enjoying peaceful country living. A rare and highly valuable feature is the fully self-sufficient 800 square foot, one-and-a-half storey detached ADU. It includes a functional main level with full kitchen plus a large bedroom with a four-piece bathroom, private laundry and carport. This thoughtfully designed space offers complete independence for extended family or guests, while keeping everyone close - delivering the best of both worlds. RSA. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:51:53.474845+00:00"
+"Directions": "Hwy 6 & Concession 5 E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Sump Pump"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "145 x 300 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T18:40:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T12:10:38Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Concession 5"
+"StreetNumber": "19"
+"TaxAnnualAmount": "10610"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019f8a06-4f70-7315-9a6f-3eb01ace19ec"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071835/19-concession-5-e-hamilton-rural-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 145.0
+"OriginalEntryTimestamp": "2026-07-23T18:40:15.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071835')"
+"ID": "1653709"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25453
+post_id: "1653711"
+post_author: 1
+"ListingKey": "30070675"
+"ListingId": "40850288"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:30:16Z"
+"RFModificationTimestamp": "2026-07-24T18:34:35Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3763.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL Crescent, Waterdown, Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.9054139
1 => 43.3203351
]
+"Latitude": 43.3203351
+"Longitude": -79.9054139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:42:14.280225+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:59Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:15:59Z"
+"Stories": "1.0"
+"StreetName": "WATERWHEEL"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9709.99"
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070675/54-waterwheel-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.0
+"AboveGradeFinishedArea": 2317
+"BelowGradeFinishedArea": 1446
+"OriginalEntryTimestamp": "2026-07-23T16:29:06.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070675')"
+"ID": "1653711"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1653718"
+post_author: 1
+"ListingKey": "30071102"
+"ListingId": "X13598280"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:05Z"
+"RFModificationTimestamp": "2026-07-24T18:51:37Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL CRESCENT, Hamilton (Waterdown), Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.905431
1 => 43.320341
]
+"Latitude": 43.320341
+"Longitude": -79.905431
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:19:28.284825+00:00"
+"Directions": "Dundas St E & Hollybush Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"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": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "82.3 x 105.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:28Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:28Z"
+"Stories": "1.0"
+"StreetName": "Waterwheel"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9707.99"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071102/54-waterwheel-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.3
+"OriginalEntryTimestamp": "2026-07-23T17:09:52.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071102')"
+"ID": "1653718"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25461
+post_id: "1649084"
+post_author: 1
+"ListingKey": "30066216"
+"ListingId": "X13593728"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:45:04Z"
+"RFModificationTimestamp": "2026-07-22T19:05:04Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907713
1 => 43.328158
]
+"Latitude": 43.328158
+"Longitude": -79.907713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"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-22T19:04:54.109562+00:00"
+"Directions": "Dundas St. N to Riley St. to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T17:37:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T17:37:22Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5374.8"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/24_braeheid_ave_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/30066216/24-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-22T17:37:22.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066216')"
+"ID": "1649084"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25462
+post_id: "1648557"
+post_author: 1
+"ListingKey": "30065389"
+"ListingId": "40850232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T16:15:08Z"
+"RFModificationTimestamp": "2026-07-22T16:36:51Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2392.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID Avenue, Waterdown, Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.9071668
1 => 43.3279388
]
+"Latitude": 43.3279388
+"Longitude": -79.9071668
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"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-22T16:36:38.024251+00:00"
+"Directions": "Dundas St N to Riley St to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198019"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T16:08:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T16:08:41Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5374.8"
+"VirtualTourURLUnbranded": "https://youriguide.com/24_braeheid_ave_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065389/24-braeheid-avenue-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1642
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2026-07-22T16:08:41.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446394"
+"ListOfficeNationalAssociationId": "1223032"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065389')"
+"ID": "1648557"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 76
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]