array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29961749 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1572570"
+post_author: 1
+"ListingKey": "29961749"
+"ListingId": "X13496704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T00:50:04Z"
+"RFModificationTimestamp": "2026-06-27T01:10:26Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.882882
1 => 43.329912
]
+"Latitude": 43.329912
+"Longitude": -79.882882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Burlington's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T01:10:19.307439+00:00"
+"Directions": "Cross Streets: Mountain Brow Road. ** Directions: Waterdown Road to Mountain Brow Road."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047588"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "256.3 x 127.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T00:44:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T00:44:49Z"
+"Stories": "1.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://344mountainbrowroad.marketingrmx.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1669011499"
"RoomType" => "Kitchen"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29961749"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
1 => array:11 [
"RoomKey" => "1669011500"
"RoomType" => "Bathroom"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29961749"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
2 => array:11 [
"RoomKey" => "1669011501"
"RoomType" => "Bedroom 3"
"ListingId" => "X13496704"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29961749"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
3 => array:11 [
"RoomKey" => "1669011502"
"RoomType" => "Great room"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 6.05
"ListingKey" => "29961749"
"RoomLength" => 6.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
4 => array:11 [
"RoomKey" => "1669011503"
"RoomType" => "Den"
"ListingId" => "X13496704"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29961749"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
5 => array:11 [
"RoomKey" => "1669011504"
"RoomType" => "Loft"
"ListingId" => "X13496704"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29961749"
"RoomLength" => 5.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
6 => array:11 [
"RoomKey" => "1669011505"
"RoomType" => "Bathroom"
"ListingId" => "X13496704"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29961749"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.87Z"
]
7 => array:11 [
"RoomKey" => "1669011506"
"RoomType" => "Sunroom"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29961749"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
8 => array:11 [
"RoomKey" => "1669011507"
"RoomType" => "Dining room"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29961749"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
9 => array:11 [
"RoomKey" => "1669011508"
"RoomType" => "Living room"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "29961749"
"RoomLength" => 5.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
10 => array:11 [
"RoomKey" => "1669011509"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 4.14
"ListingKey" => "29961749"
"RoomLength" => 6.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
11 => array:11 [
"RoomKey" => "1669011510"
"RoomType" => "Bathroom"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29961749"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
12 => array:11 [
"RoomKey" => "1669011511"
"RoomType" => "Bedroom 2"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 4.04
"ListingKey" => "29961749"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
13 => array:11 [
"RoomKey" => "1669011512"
"RoomType" => "Bathroom"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29961749"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
14 => array:11 [
"RoomKey" => "1669011513"
"RoomType" => "Laundry room"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29961749"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
15 => array:11 [
"RoomKey" => "1669011514"
"RoomType" => "Other"
"ListingId" => "X13496704"
"RoomLevel" => "Main level"
"RoomWidth" => 1.32
"ListingKey" => "29961749"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-27T00:44:49.88Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961749/344-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 256.3
+"OriginalEntryTimestamp": "2026-06-27T00:44:49.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323031"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29961749_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/502d1e5fc6672c436fe577de2be16b08.webp"
"MediaSize" => 497274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-502d1e5fc6672c436fe577de2be16b08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29961749_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/47d91b224ff8d81ada93d89bb07d5174.webp"
"MediaSize" => 474054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-47d91b224ff8d81ada93d89bb07d5174.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29961749_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/5e145228aa24f66e67237d1fa6e23b90.webp"
"MediaSize" => 560072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-5e145228aa24f66e67237d1fa6e23b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29961749_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/0604f046358f593bf5b390467c09504e.webp"
"MediaSize" => 518553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-0604f046358f593bf5b390467c09504e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29961749_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/269b0c51eb3fd7a6e6ae8bf9e769ef64.webp"
"MediaSize" => 173699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-269b0c51eb3fd7a6e6ae8bf9e769ef64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29961749_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/f907ed719c180010e121cb39ebd4a4a8.webp"
"MediaSize" => 278396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-f907ed719c180010e121cb39ebd4a4a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29961749_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/96e5af5d5ab97c07cea0cb5fa6eaa3c2.webp"
"MediaSize" => 177650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-96e5af5d5ab97c07cea0cb5fa6eaa3c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29961749_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/e5e50cdb78cff87d10a53c82a9cfce28.webp"
"MediaSize" => 219234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-e5e50cdb78cff87d10a53c82a9cfce28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29961749_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/04897f71fbedef1adc041581b1a46c8a.webp"
"MediaSize" => 249488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-04897f71fbedef1adc041581b1a46c8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29961749_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/c6edfa7699ad73f4ffeb82f178326e64.webp"
"MediaSize" => 234295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-c6edfa7699ad73f4ffeb82f178326e64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29961749_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/011aed78892cd5694f412b644ec95475.webp"
"MediaSize" => 198806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-011aed78892cd5694f412b644ec95475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29961749_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/6d678cc02f6ab45c3865941826118b6b.webp"
"MediaSize" => 195129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-6d678cc02f6ab45c3865941826118b6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29961749_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/49074017cff5685b53a7d8399c167cc7.webp"
"MediaSize" => 231047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-49074017cff5685b53a7d8399c167cc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29961749_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/e3bd74ec4d5d116c22f25f722b325319.webp"
"MediaSize" => 226506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-e3bd74ec4d5d116c22f25f722b325319.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29961749_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/484ad7ef0a868f0d9337c46b9ad1af2b.webp"
"MediaSize" => 306348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-484ad7ef0a868f0d9337c46b9ad1af2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29961749_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/2a8dfe396cd7d93e65d9a730bddb696e.webp"
"MediaSize" => 294264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-2a8dfe396cd7d93e65d9a730bddb696e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29961749_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/07a524015a0d96dce905562426af7dbf.webp"
"MediaSize" => 319570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-07a524015a0d96dce905562426af7dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29961749_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/4bbd3dd120e57fc8964fb323f112665c.webp"
"MediaSize" => 266623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-4bbd3dd120e57fc8964fb323f112665c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29961749_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/1efbc588b9b4fd7d66c431217cec9ab1.webp"
"MediaSize" => 233422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-1efbc588b9b4fd7d66c431217cec9ab1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29961749_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/bdba9f5689c33af2e558323f9cfbfacd.webp"
"MediaSize" => 112750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-bdba9f5689c33af2e558323f9cfbfacd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29961749_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/bd980f04d998471249400cced54236f9.webp"
"MediaSize" => 222149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-bd980f04d998471249400cced54236f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29961749_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/2e9cb6a0ad5cd33bf8ffdef3f61821a9.webp"
"MediaSize" => 175242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-2e9cb6a0ad5cd33bf8ffdef3f61821a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29961749_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/55937556fdfcaae38f1d5d545702a193.webp"
"MediaSize" => 222919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-55937556fdfcaae38f1d5d545702a193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29961749_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/4960645c57e9292b47af4f6a59cdf9fa.webp"
"MediaSize" => 255837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-4960645c57e9292b47af4f6a59cdf9fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29961749_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/eb08b8d7c528130c9f77ec0090999e55.webp"
"MediaSize" => 280949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-eb08b8d7c528130c9f77ec0090999e55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29961749_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/e3688f876a5578998a5837c5b909ade2.webp"
"MediaSize" => 171052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-e3688f876a5578998a5837c5b909ade2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29961749_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/a561bc68dc9d8ad5c269e85abbc8250c.webp"
"MediaSize" => 157541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-a561bc68dc9d8ad5c269e85abbc8250c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29961749_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/8cb79b95f468d434f53c034f786dbb64.webp"
"MediaSize" => 329863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-8cb79b95f468d434f53c034f786dbb64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29961749_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/83a4329736923d83dc34839caae538b8.webp"
"MediaSize" => 363079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-83a4329736923d83dc34839caae538b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29961749_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/b413174bcd6d007c35def4d53ddcbb47.webp"
"MediaSize" => 336104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-b413174bcd6d007c35def4d53ddcbb47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29961749_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/2475fbe9e5212a232d9fdc3d8623a977.webp"
"MediaSize" => 182312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-2475fbe9e5212a232d9fdc3d8623a977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29961749_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/25c1f7ac7a24f3c2cc23c354ada18c93.webp"
"MediaSize" => 219424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-25c1f7ac7a24f3c2cc23c354ada18c93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29961749_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/21c724cfdbb0f715f2ed10502832860e.webp"
"MediaSize" => 227070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-21c724cfdbb0f715f2ed10502832860e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29961749_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/5aa2407239a85334b71f55f8e6f379f2.webp"
"MediaSize" => 193414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-5aa2407239a85334b71f55f8e6f379f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29961749_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/ed85b97491501a3ef2e022c94da45f5f.webp"
"MediaSize" => 159220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-ed85b97491501a3ef2e022c94da45f5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29961749_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/b83e0bdc47789276ad27beb0ab294105.webp"
"MediaSize" => 171181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-b83e0bdc47789276ad27beb0ab294105.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29961749_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/117322ad961eeb059c3ad3dc0c7edc87.webp"
"MediaSize" => 178463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-117322ad961eeb059c3ad3dc0c7edc87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29961749_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/d32e09ffef32e1328c51eeef4a8270f8.webp"
"MediaSize" => 273884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-d32e09ffef32e1328c51eeef4a8270f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29961749_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/cccddcd168f58ebb6db61de446aadf4a.webp"
"MediaSize" => 386650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-cccddcd168f58ebb6db61de446aadf4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29961749_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/8de1411f6027f781a9e73a763ef8b996.webp"
"MediaSize" => 422453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-8de1411f6027f781a9e73a763ef8b996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29961749_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/9331846073270be4167e29d0e241be7e.webp"
"MediaSize" => 377695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-9331846073270be4167e29d0e241be7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29961749_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/1cc4b0de49b61277c5b6f56a5a2eabdc.webp"
"MediaSize" => 373149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-1cc4b0de49b61277c5b6f56a5a2eabdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29961749_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/5eaa8e924ff0480ebc27f1bfc83ae7fe.webp"
"MediaSize" => 359810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-5eaa8e924ff0480ebc27f1bfc83ae7fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29961749_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/6d923fcfe48ecbeb74f53ab5a5fe2ef4.webp"
"MediaSize" => 293896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-6d923fcfe48ecbeb74f53ab5a5fe2ef4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29961749_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/32289df5a8fa052b9560dda908c33ef6.webp"
"MediaSize" => 360053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-32289df5a8fa052b9560dda908c33ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29961749_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/d0c1aac89357be19518b02fade3e3921.webp"
"MediaSize" => 441886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-d0c1aac89357be19518b02fade3e3921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29961749_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/7010412d661f16044a12b683b3b43192.webp"
"MediaSize" => 593863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-7010412d661f16044a12b683b3b43192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29961749_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/7f203aa78fb7da7664b586ec015198fb.webp"
"MediaSize" => 441811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-7f203aa78fb7da7664b586ec015198fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29961749_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/8bb35f5713d8724f2f5e2c0189839342.webp"
"MediaSize" => 252205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-8bb35f5713d8724f2f5e2c0189839342.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29961749_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29961749/99cafa39fa457f23c5cdecfb166d7755.webp"
"MediaSize" => 95664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29961749/thumbnail-99cafa39fa457f23c5cdecfb166d7755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13496704"
"ResourceRecordKey" => "29961749"
"ModificationTimestamp" => "2026-06-27T00:44:49.84Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961749')"
+"ID": "1572570"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 266588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24921
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2047588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24890
+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 '29961749'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+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 '29961749'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29961749' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.882882 43.329912)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25397
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1571912"
+post_author: 1
+"ListingKey": "29960542"
+"ListingId": "X13495616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:02Z"
+"RFModificationTimestamp": "2026-06-26T23:04:46Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X1"
+"UnparsedAddress": "14 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X1"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained and move-in-ready corner-unit townhouse offering approximately 1,800 sq. ft. of bright and functional living space. This spacious home features 3+1 bedrooms, 3 bathrooms, a double-car garage, plus 2 additional driveway parking spaces. The desirable corner location allows for an abundance of natural light through numerous windows throughout the home. Enjoy an open-concept kitchen overlooking the dining area, complete with a large pantry and excellent storage space. The well-designed layout includes generously sized bedrooms and a primary suite with an ensuite bath. An unfinished basement offers exceptional potential for future customization and added living space while providing ample storage. Relax on the private balcony with gas hookups and enjoy comfortable, low-maintenance living in a sought-after, family-friendly community. Ideally located with exceptional accessibility, this home is just minutes from major highways, shopping centres, schools, parks, restaurants, and all everyday amenities, making it a perfect choice for families seeking both convenience and comfort. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:04:38.815915+00:00"
+"Directions": "Hamilton St N / Dundas St E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946962"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:00Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:00Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6356.58"
+"View": "View"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960542/14-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1892161"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 905-540-8800"
+"CoListOfficeKey": "50236"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "R6-33"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T20:48:00.12Z"
+"ListAgentNationalAssociationId": "1241888"
+"ListOfficeNationalAssociationId": "1002993"
+"CoListAgentNationalAssociationId": "1212143"
+"CoListOfficeNationalAssociationId": "1002993"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29960542_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/85e36632dca1380886f7f93b23e05535.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960542')"
+"ID": "1571912"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1571505"
+post_author: 1
+"ListingKey": "29961017"
+"ListingId": "40843479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:55:08Z"
+"RFModificationTimestamp": "2026-06-26T22:37:17Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.75
+"LivingArea": 3492.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW Road, Waterdown, Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.8823409
1 => 43.3299879
]
+"Latitude": 43.3299879
+"Longitude": -79.8823409
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Burlington's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:2 [
0 => "Window Coverings"
1 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:10.046221+00:00"
+"Directions": "WATERDOWN ROAD TO MOUNTAIN BROW ROAD"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"LotSizeDimensions": "0.75"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:50:06Z"
+"Stories": "1.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204661223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961017/344-mountain-brow-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 256.0
+"AboveGradeFinishedArea": 3492
+"OriginalEntryTimestamp": "2026-06-26T21:50:06.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961017')"
+"ID": "1571505"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1570187"
+post_author: 1
+"ListingKey": "29958286"
+"ListingId": "X13493838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:30:18Z"
+"RFModificationTimestamp": "2026-06-26T18:29:29Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z8"
+"UnparsedAddress": "446 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1Z8"
+"Coordinates": array:2 [
0 => -79.87188
1 => 43.345646
]
+"Latitude": 43.345646
+"Longitude": -79.87188
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the family-oriented Waterdown community, 446 Humphrey St is an exceptional 5-bedroom, 4-bathroom executive residence that blends refined finishes and functionality across its 3,474 sq ft above-grade layout.The main level introduces itself with a grand double-door entry, an elegant tiled foyer, rich hardwood flooring, and expansive principal spaces designed for both everyday comfort and sophisticated entertaining. A private main-floor office provides exceptional flexibility for remote work or a potential 6th bedroom. The chef-inspired kitchen is thoughtfully curated with quartz countertops, a sleek quartz backsplash, premium Samsung appliances, and a dedicated servery designed with extensive cabinetry for staging, serving, and discreet storage. The adjoining breakfast area and family room are flooded with natural light and anchored by a fireplace, creating a warm and inviting atmosphere overlooking the backyard. The second level unfolds with intention, featuring five generously proportioned bedrooms, all complete with walk-in closets. The primary retreat is a true sanctuary with a spacious walk-in closet and a spa-inspired 5-piece ensuite featuring dual vanities and elegant finishes. Secondary bedrooms are exceptionally well-sized and connected through thoughtfully designed Jack & Jill bathroom layouts, creating both privacy and functionality for growing families. A dedicated upper-level laundry room further enhances convenience. The unfinished lower level presents extraordinary future potential with oversized windows, expansive open-concept space, a cold room, and the flexibility to design a custom recreation space, gym, home theatre, or in-law suite tailored to your lifestyle. Outdoors, the backyard awaits transformation into a private outdoor retreat, while the home is located in close proximity to major highways, top-rated schools, shopping, restaurants, conservation areas, golf courses, and scenic walking trails. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:29:21.625328+00:00"
+"Directions": "Cross Streets: Dundas St E & Skinner Rd. ** Directions: Dundas St E to Skinner Rd to Humphrey St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417634"
+"ListOfficeKey": "270338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Guest Suite"
]
+"LotSizeDimensions": "57.1 x 97.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T16:21:49Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:21:49Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "446"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9900"
+"VirtualTourURLUnbranded": "https://vimeo.com/1190320791?share=copy&fl=sv&fe=ci"
+"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/29958286/446-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2222228"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269129"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.1
+"OriginalEntryTimestamp": "2026-06-26T16:21:49.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1035732"
+"ListOfficeNationalAssociationId": "1235224"
+"CoListAgentNationalAssociationId": "1465862"
+"CoListOfficeNationalAssociationId": "1231804"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958286')"
+"ID": "1570187"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1568946"
+post_author: 1
+"ListingKey": "29957771"
+"ListingId": "X13493364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:00:10Z"
+"RFModificationTimestamp": "2026-06-26T17:03:02Z"
+"ListPrice": 969990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "26 GRANITE RIDGE TRAIL, Hamilton (Waterdown), Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.878616
1 => 43.337201
]
+"Latitude": 43.337201
+"Longitude": -79.878616
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2,400 sq. ft. home offering 4 bedrooms and 3.5 bathrooms in one of Waterdown's most sought-after family neighbourhoods. Built in 2021 and well cared for by the original owners, this home is beautifully upgraded throughout. The open-concept main floor features vinyl plank flooring, hardwood stairs, California shutters, a private office, and a bright living room with a gas fireplace. The kitchen features custom Barzotti cabinetry, quartz countertops, a large island, and a subway tile backsplash. The second level offers four spacious bedrooms, including two with private ensuites. The primary suite features his-and-hers walk-in closets, a double vanity, and a frameless glass shower. Additional features include upper-level laundry, a gas BBQ line, and a basement bathroom rough-in for future potential. Ideally located close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T16:04:01.229257+00:00"
+"Directions": "Cross Streets: Kenesky Dr. ** Directions: Dundas St E - Burke St - Kenesky Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T15:21:44Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:53:39Z"
+"Stories": "2.0"
+"StreetName": "Granite Ridge"
+"StreetNumber": "26"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7254.63"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29957771/26-granite-ridge-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-06-26T15:21:44.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957771')"
+"ID": "1568946"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1567703"
+post_author: 1
+"ListingKey": "29956107"
+"ListingId": "X13491700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T00:50:21Z"
+"RFModificationTimestamp": "2026-06-26T05:00:06Z"
+"ListPrice": 510000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "502 - 470 DUNDAS STREET, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 470 Dundas St E, Unit 502 - a bright corner two-bedroom condo with rare side-by-side parking and unobstructed sunset views. This modern suite features 10-foot ceilings,floor-to-ceiling windows, vinyl flooring, custom roller blinds, and an oversized balcony perfect for relaxing or entertaining. Enjoy the added convenience of two parking spots near the elevator and a same-floor storage locker. Building amenities include fitness centres, party rooms, rooftop terraces with BBQs, on-site management, and a superintendent. Conveniently located near highways, GO Transit, parks, trails, and everyday amenities. Ideally situated with quick access to major highways, the GO Train, nearby parks, trails, shopping, and everyday conveniences, this condo is a fantastic option for commuters, downsizers, and anyone looking for modern condo living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Barbeque"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"AssociationFee": "634.77"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-26T04:59:56.667005+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203994"
+"ListOfficeKey": "282937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-26T00:45:10Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T00:45:10Z"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2020"
+"View": "City view"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956107/502-470-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-26T00:45:10.04Z"
+"ListAgentNationalAssociationId": "1452632"
+"ListOfficeNationalAssociationId": "1323558"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956107')"
+"ID": "1567703"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1567003"
+post_author: 1
+"ListingKey": "29946398"
+"ListingId": "X13482892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:00:19Z"
+"RFModificationTimestamp": "2026-06-26T03:23:48Z"
+"ListPrice": 1325000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J6"
+"UnparsedAddress": "31 COMMANDO COURT, Hamilton (Waterdown), Ontario L8B0J6"
+"Coordinates": array:2 [
0 => -79.903711
1 => 43.329889
]
+"Latitude": 43.329889
+"Longitude": -79.903711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "If you have been looking for an exclusive court enclave in Waterdown, we have the perfect opportunity for you! 31 Commando Court, nestled in a quiet part of town, offers privacy and excellent walkability. This 4-bedroom, 2.5-bath home boasts over 2,500 sq ft of finished living space, an unfinished basement awaiting your final touches, and a double-car garage. Step inside to discover a beautiful staircase, open-concept layout, and gleaming strip hardwood flooring throughout the main level. Designed for comfort and functionality, this floor features a formal dining room, spacious eat-in kitchen, inviting living area, and a front-facing office perfect for working from home or a playroom. The dining room connects seamlessly to the family room through elegant pocket doors, creating an ideal space for entertaining. The updated eat-in kitchen showcases white cabinetry, quartz countertops, tile backsplash, peninsula seating, and a walkout to the concrete patio. Open to the living room, this space is highlighted by a stunning stone fireplace and expansive windows overlooking the private backyard and desirable court setting. The upper level features a thoughtfully designed split floor plan, providing the primary retreat with exceptional privacy. This inviting space includes a large built-in wall closet, front-facing picture windows, and a spa-like 4-piece ensuite. Three additional bedrooms offer hardwood flooring, picture windows, and double closets. A spacious 4-piece main bath, double linen closet, and convenient upper-level laundry add to this well-designed floor's functionality. The unfinished basement presents an excellent opportunity to create additional living space, complete with a rough-in for a future bathroom. Outdoors, enjoy a large stamped concrete patio, iron fencing, and ample space for a pool, play area, or other amenities. Situated on one of Waterdown's most sought-after streets, this exceptional property offers the perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:22:28.727807+00:00"
+"Directions": "Hamilton St N & Parkside Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "302161"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "48.3 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T14:51:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:51:08Z"
+"Stories": "2.0"
+"StreetName": "Commando"
+"StreetNumber": "31"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "8000"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/31-commando-ct-hamilton-on-l8b-0j6-25408789/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946398/31-commando-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-24"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 48.3
+"OriginalEntryTimestamp": "2026-06-24T14:51:08.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246196"
+"ListOfficeNationalAssociationId": "1499250"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946398')"
+"ID": "1567003"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1565694"
+post_author: 1
+"ListingKey": "29954208"
+"ListingId": "40843154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:40:04Z"
+"RFModificationTimestamp": "2026-06-26T01:25:03Z"
+"ListPrice": 969990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "26 GRANITE RIDGE Trail, Waterdown, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.8786022
1 => 43.3372225
]
+"Latitude": 43.3372225
+"Longitude": -79.8786022
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2,400 sq. ft. home offering 4 bedrooms and 3.5 bathrooms in one of Waterdown's most sought-after family neighbourhoods. Built in 2021 and well cared for by the original owners, this home is beautifully upgraded throughout. The open-concept main floor features vinyl plank flooring, hardwood stairs, California shutters, a private office, and a bright living room with a gas fireplace. The kitchen features custom Barzotti cabinetry, quartz countertops, a large island, and a subway tile backsplash. The second level offers four spacious bedrooms, including two with private ensuites. The primary suite features his-and-hers walk-in closets, a double vanity, and a frameless glass shower. Additional features include upper-level laundry, a gas BBQ line, and a basement bathroom rough-in for future potential. Ideally located close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. Call to book your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"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-06-26T01:24:56.281861+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:31:01Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:31:01Z"
+"Stories": "2.0"
+"StreetName": "GRANITE RIDGE"
+"StreetNumber": "26"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7254.63"
+"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/29954208/26-granite-ridge-trail-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2400
+"OriginalEntryTimestamp": "2026-06-25T19:31:01.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954208')"
+"ID": "1565694"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1565408"
+post_author: 1
+"ListingKey": "29954379"
+"ListingId": "40843052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:42:15Z"
+"ListPrice": 1649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1908.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "17 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8821102
1 => 43.3322944
]
+"Latitude": 43.3322944
+"Longitude": -79.8821102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A custom-built Branthaven bungalow nestled on spectacular 66' x 162' ravine lot, where mature trees & natural surroundings create a peaceful, private retreat in one of Waterdown's most desirable neighbourhoods. Backing directly onto the renowned Bruce Trail, this exceptional property offers a rare opportunity to enjoy nature from your own backyard. Step inside to a welcoming foyer opening to spacious great room w/ vaulted ceiling, floor-to-ceiling FP, & abundant natural light. Dining area walks out to a raised deck overlooking the ravine setting—perfect for morning coffee, outdoor dining, or unwinding to the peaceful sounds of birds & nature. Updated kitchen w/ high-end SS appliances, breakfast bar, & large windows bringing the beauty of the outdoors in. Whether preparing gourmet meals for family gatherings or hosting friends, this space is as functional as it is inviting. Main level offers spacious primary suite w/ backyard views & updated 4pc ensuite w/ soaker tub & glass shower w/ steam sauna. 2 addtl generously sized bedrooms & updated 3pc bath complete the level. Heated floors in all bathrooms. Impressive walkout lower level expands the living space w/ large recreation & games room, family room w/ FP, den, 4th bedroom, 4pc updated bath w/ steam sauna, laundry area, & ample storage. With direct backyard access, this level offers exceptional flexibility for multi-generational living, working from home, relaxing, or entertaining. Pool-sized backyard offers endless possibilities for children, pets, gardening enthusiasts, or creating your dream outdoor oasis. Ideal for downsizers seeking main-floor living without compromise or growing families looking for a forever home w/ room to live, work, & play. Located in a prestigious Waterdown enclave known for executive homes, schools, parks, & strong sense of community, w/ convenient access to shopping, dining, major highways, & Aldershot GO Station. A truly special home where nature, comfort, & convenience come together. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:42:07.112139+00:00"
+"Directions": "MOUNTAIN BROW ROAD TO FLANDERS DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:10:55Z"
+"Stories": "1.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "17"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8661.19"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204278829"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954379/17-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1908
+"OriginalEntryTimestamp": "2026-06-25T19:50:37.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954379')"
+"ID": "1565408"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25396
+post_id: "1562606"
+post_author: 1
+"ListingKey": "29953558"
+"ListingId": "X13487868"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:12Z"
+"RFModificationTimestamp": "2026-06-25T21:11:05Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9B1A9"
+"UnparsedAddress": "311 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to a truly rare offering-this top-floor, end-unit condo delivers an exceptional level of privacy, quiet, and space that is seldom found. With no neighbours above or beside, this home offers a peaceful, almost penthouse-like experience (without the penthouse price tag), tucked away in a private section of a solid, well-built building. Thoughtfully renovated from top to bottom, this spacious unit features a flexible layout with 3 bedrooms or 2 bedrooms plus a den-ideal for families, downsizers, or anyone seeking room to live and work comfortably. The openconcept kitchen has been beautifully updated with modern cabinetry and appliances, seamlessly connecting to the bright living and dining areas. Soaring ceilings and large south-facing windows flood the space with natural light, while patio doors lead to two private balconies overlooking mature trees-creating a serene, retreat-like atmosphere rarely found in condo living. The home continues to impress with new hardwood floors, updated bathrooms (including an ensuite), in-suite laundry, large bedrooms, and a walk-in closet. Storage is exceptional, highlighted by an unusually large storage locker-perfect for seasonal items, sports equipment, or downsizing without compromise. Additional features include two underground parking spaces, access to a common room for gatherings, and low-maintenance living with landscaping, maintenance, and snow removal all taken care of. Located in a highly convenient, walkable neighbourhood close to shopping, downtown, and parks including Memorial Park, this home offers the perfect balance of tranquility and accessibility. Rarely do units like this become available-quiet, private, spacious, and move-in ready. A unique opportunity for those seeking the ease of condo living without sacrificing space, light, or lifestyle. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"AssociationFee": "845"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:10:52.008176+00:00"
+"Directions": "Cross Streets: HWY 6 and Dundas. ** Directions: Main and Dundas."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132710"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Street"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:25Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:36:25Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4594.34"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953558/311-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-25T18:36:25.58Z"
+"ListAgentNationalAssociationId": "1385379"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953558')"
+"ID": "1562606"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 208
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]