array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29827779 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1476238"
+post_author: 1
+"ListingKey": "29827779"
+"ListingId": "40834864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T20:40:05Z"
+"RFModificationTimestamp": "2026-06-14T20:43:56Z"
+"ListPrice": 2399900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.28
+"LivingArea": 5318.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "9 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8823441
1 => 43.3323597
]
+"Latitude": 43.3323597
+"Longitude": -79.8823441
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 9 Flanders Drive—an exceptional executive residence nestled in one of Waterdown’s most coveted and established neighbourhoods. Offering over 5,200 sq/ft of beautifully finished living space, this stunning home blends timeless elegance with modern comfort, ideal for families seeking both luxury and functionality. Boasting 4+1 spacious bedrooms and 4.5 bathrooms, this home is thoughtfully designed with generous principal rooms, refined finishes, and a layout that effortlessly accommodates both everyday living and entertaining. The heart of the home features an inviting kitchen and living space, complemented by elegant formal areas and abundant natural light throughout. Step outside to your own private backyard retreat—professionally landscaped and designed for enjoyment. The show-stopping concrete pool is surrounded by lush greenery and ample space for lounging, creating the perfect setting for summer entertaining or quiet relaxation. Located in a prestigious Waterdown pocket known for its executive homes, top-rated schools, parks, and community feel, this is a rare opportunity to own a truly remarkable property in a prime location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T23:07:59.143567+00:00"
+"Directions": "Waterdown Rd to Mountain Brow Rd to Flanders Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991807"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.28"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T22:39:23Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T20:34:52Z"
+"Stories": "2.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "9"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "16675"
+"VirtualTourURLUnbranded": "https://calibre-media.aryeo.com/sites/9-flanders-dr-hamilton-on-l8b-0g6-23287586/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1659438907"
"RoomType" => "Storage"
"ListingId" => "40834864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "23'5'' x 24'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.39Z"
]
1 => array:11 [
"RoomKey" => "1659438908"
"RoomType" => "3pc Bathroom"
"ListingId" => "40834864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
2 => array:11 [
"RoomKey" => "1659438909"
"RoomType" => "Bedroom"
"ListingId" => "40834864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 27'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
3 => array:11 [
"RoomKey" => "1659438910"
"RoomType" => "3pc Bathroom"
"ListingId" => "40834864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
4 => array:11 [
"RoomKey" => "1659438911"
"RoomType" => "Recreation room"
"ListingId" => "40834864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "27'4'' x 34'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
5 => array:11 [
"RoomKey" => "1659438912"
"RoomType" => "5pc Bathroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
6 => array:11 [
"RoomKey" => "1659438913"
"RoomType" => "Bedroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "20'9'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
7 => array:11 [
"RoomKey" => "1659438914"
"RoomType" => "Bedroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
8 => array:11 [
"RoomKey" => "1659438915"
"RoomType" => "Bedroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
9 => array:11 [
"RoomKey" => "1659438916"
"RoomType" => "Sitting room"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.4Z"
]
10 => array:11 [
"RoomKey" => "1659438917"
"RoomType" => "Full bathroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
11 => array:11 [
"RoomKey" => "1659438918"
"RoomType" => "Primary Bedroom"
"ListingId" => "40834864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "20'3'' x 25'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
12 => array:11 [
"RoomKey" => "1659438919"
"RoomType" => "Laundry room"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
13 => array:11 [
"RoomKey" => "1659438920"
"RoomType" => "2pc Bathroom"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
14 => array:11 [
"RoomKey" => "1659438921"
"RoomType" => "Dining room"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "17'3'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
15 => array:11 [
"RoomKey" => "1659438922"
"RoomType" => "Kitchen"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
16 => array:11 [
"RoomKey" => "1659438923"
"RoomType" => "Breakfast"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
17 => array:11 [
"RoomKey" => "1659438924"
"RoomType" => "Sunroom"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
18 => array:11 [
"RoomKey" => "1659438925"
"RoomType" => "Family room"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "24'4'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
19 => array:11 [
"RoomKey" => "1659438926"
"RoomType" => "Office"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
20 => array:11 [
"RoomKey" => "1659438927"
"RoomType" => "Living room"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "17'10'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.41Z"
]
21 => array:11 [
"RoomKey" => "1659438928"
"RoomType" => "Foyer"
"ListingId" => "40834864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29827779"
"RoomLength" => null
"RoomDimensions" => "20'11'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:34:52.42Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29827779/9-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 75.0
+"AboveGradeFinishedArea": 4010
+"BelowGradeFinishedArea": 1308
+"OriginalEntryTimestamp": "2026-05-29T22:39:23.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1275275"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29827779_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/873eaeb8bb31aee8273351cd604fa4c7.webp"
"MediaSize" => 122999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-873eaeb8bb31aee8273351cd604fa4c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29827779_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/3bef39f08c59ee5cd80cdb08a0caf4e4.webp"
"MediaSize" => 134035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-3bef39f08c59ee5cd80cdb08a0caf4e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring a patio, a pergola, an outdoor pool, and stone siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29827779_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/9c864619fd76f0076adf7b19447c7386.webp"
"MediaSize" => 181965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-9c864619fd76f0076adf7b19447c7386.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade with stone siding and a front yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29827779_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/37c957b0d625759f3c52145c4d774668.webp"
"MediaSize" => 138961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-37c957b0d625759f3c52145c4d774668.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of property and surrounding area featuring a forest"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29827779_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/c690d6a061b0e633066cf6680186356c.webp"
"MediaSize" => 96359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-c690d6a061b0e633066cf6680186356c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29827779_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/1a518a4751dde9bc95d02cbad45a6b40.webp"
"MediaSize" => 98737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-1a518a4751dde9bc95d02cbad45a6b40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29827779_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/5fa22c9351af9a7d6daeca2b8b8a5940.webp"
"MediaSize" => 80597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-5fa22c9351af9a7d6daeca2b8b8a5940.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29827779_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/7cb4339652d2a3c97af9b23211a9d5ae.webp"
"MediaSize" => 74348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-7cb4339652d2a3c97af9b23211a9d5ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29827779_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/5e4875d719e16400c627372b62a292af.webp"
"MediaSize" => 86072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-5e4875d719e16400c627372b62a292af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29827779_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/12cb199df6812de4091990876e0d7815.webp"
"MediaSize" => 111465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-12cb199df6812de4091990876e0d7815.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29827779_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/9f7de0107466971ada6744af1a99d360.webp"
"MediaSize" => 117125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-9f7de0107466971ada6744af1a99d360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29827779_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/59877e341c3a7f9003818966155990bc.webp"
"MediaSize" => 111750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-59877e341c3a7f9003818966155990bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29827779_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/4b33cd0fb8f7495d0cbc0db9436dc15c.webp"
"MediaSize" => 91403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-4b33cd0fb8f7495d0cbc0db9436dc15c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sunroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29827779_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/0ad06a88cfa7d26cc036b392781c6616.webp"
"MediaSize" => 117534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-0ad06a88cfa7d26cc036b392781c6616.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29827779_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/8e7bb1abb0f084bbbf855d8b4ebc3046.webp"
"MediaSize" => 101299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-8e7bb1abb0f084bbbf855d8b4ebc3046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29827779_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/c36fb58a0231b2e291908876045394cc.webp"
"MediaSize" => 82438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-c36fb58a0231b2e291908876045394cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29827779_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/96aac1609126ce2a40a048a04de8ca71.webp"
"MediaSize" => 99381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-96aac1609126ce2a40a048a04de8ca71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29827779_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/ade54fe59c1f65bb6ea2f1347171c83c.webp"
"MediaSize" => 91830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-ade54fe59c1f65bb6ea2f1347171c83c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29827779_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/fd1315a90726762827e72c4d93bd41d7.webp"
"MediaSize" => 88793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-fd1315a90726762827e72c4d93bd41d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29827779_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/a46a31100a46be7a5740fcbdc201e066.webp"
"MediaSize" => 86386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-a46a31100a46be7a5740fcbdc201e066.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29827779_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/3af9699c60273b1b4e6affe0a67d2e38.webp"
"MediaSize" => 84059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-3af9699c60273b1b4e6affe0a67d2e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29827779_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/7a6861222b4e35bf105e91ba3e543f45.webp"
"MediaSize" => 95582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-7a6861222b4e35bf105e91ba3e543f45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29827779_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/3707f94a91a41462b1f5aad51e8100ce.webp"
"MediaSize" => 117638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-3707f94a91a41462b1f5aad51e8100ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Located in Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29827779_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/5dcf07ff5c52229777eeaad160ee5e8e.webp"
"MediaSize" => 74417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-5dcf07ff5c52229777eeaad160ee5e8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29827779_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/72b436b6a4b83cee34f42129c94636bc.webp"
"MediaSize" => 83905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-72b436b6a4b83cee34f42129c94636bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29827779_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/8c2855fef68d224fbd1b1838f24a4757.webp"
"MediaSize" => 65018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-8c2855fef68d224fbd1b1838f24a4757.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29827779_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/98a93209866dc04bd2996bf463b284f4.webp"
"MediaSize" => 67185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-98a93209866dc04bd2996bf463b284f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29827779_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/76c0b710e72dff55b99e425a5c064307.webp"
"MediaSize" => 70739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-76c0b710e72dff55b99e425a5c064307.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29827779_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/710e5ed0f9493e1141ff04176ccde801.webp"
"MediaSize" => 69049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-710e5ed0f9493e1141ff04176ccde801.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29827779_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/286b46b9c719ee67a82102f826ed2839.webp"
"MediaSize" => 66283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-286b46b9c719ee67a82102f826ed2839.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Digitally staged (currently exercise room)"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29827779_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/40c26717418ffed2aeabec114e3b7b66.webp"
"MediaSize" => 72285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-40c26717418ffed2aeabec114e3b7b66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29827779_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/da8451cd38c68b628846715d05e11315.webp"
"MediaSize" => 63466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-da8451cd38c68b628846715d05e11315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29827779_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/41bc1b7d2648593a2713aab66665ce64.webp"
"MediaSize" => 77526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-41bc1b7d2648593a2713aab66665ce64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29827779_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/3469d5ceb2b655af8377916a66879043.webp"
"MediaSize" => 63173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-3469d5ceb2b655af8377916a66879043.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29827779_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/316b335c0e5298fbcecfd2d55b7b7130.webp"
"MediaSize" => 80571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-316b335c0e5298fbcecfd2d55b7b7130.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29827779_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/faaf7304601638e90e4ab295c99f8e6e.webp"
"MediaSize" => 56274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-faaf7304601638e90e4ab295c99f8e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29827779_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/fc2288f5f3392c7cbff6a17d6eb755e4.webp"
"MediaSize" => 57166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-fc2288f5f3392c7cbff6a17d6eb755e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29827779_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/59e5c752d847103f008546b1323c8313.webp"
"MediaSize" => 56781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-59e5c752d847103f008546b1323c8313.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite in Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29827779_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/6e730e0ffcb2c30dce8475a9367422e2.webp"
"MediaSize" => 72402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-6e730e0ffcb2c30dce8475a9367422e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29827779_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/aedf114b7ccc5151e71a1a7d01c45dd9.webp"
"MediaSize" => 66631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-aedf114b7ccc5151e71a1a7d01c45dd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29827779_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/500f1769f6f00f3c2f5887e3b9dbb419.webp"
"MediaSize" => 133952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-500f1769f6f00f3c2f5887e3b9dbb419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29827779_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/437bf4fea7e9da1e831fb6c02166c7f8.webp"
"MediaSize" => 144275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-437bf4fea7e9da1e831fb6c02166c7f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29827779_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/9b964fe4a7b5d0bfe025fe29a7d23b2e.webp"
"MediaSize" => 164133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-9b964fe4a7b5d0bfe025fe29a7d23b2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29827779_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/49e36a7902b6e03eea9a61a2bc7d264a.webp"
"MediaSize" => 128181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-49e36a7902b6e03eea9a61a2bc7d264a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29827779_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/35b0cc0d3b56451d64fbf7970019f272.webp"
"MediaSize" => 182000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-35b0cc0d3b56451d64fbf7970019f272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29827779_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/c537a43beb6587249edd2f2d294e1373.webp"
"MediaSize" => 184588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-c537a43beb6587249edd2f2d294e1373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29827779_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/78f7e065c678f85068b15122effa820b.webp"
"MediaSize" => 171873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-78f7e065c678f85068b15122effa820b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29827779_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/f5de7d842711c46983c6d3ef50292d28.webp"
"MediaSize" => 165860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-f5de7d842711c46983c6d3ef50292d28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29827779_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29827779/079354ffe60def2e95b64bf63c75ede8.webp"
"MediaSize" => 33678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29827779/thumbnail-079354ffe60def2e95b64bf63c75ede8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834864"
"ResourceRecordKey" => "29827779"
"ModificationTimestamp" => "2026-05-29T22:39:23.65Z"
]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29827779')"
+"ID": "1476238"
}
]
+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 292150" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824
+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 1991807" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24797
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29827779'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25147
+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 '29827779'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25166
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31231932"
+"ListingKey": "29827779"
+"ListingId": "40834864"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T17:49:36Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31231932')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31309076"
+"ListingKey": "29827779"
+"ListingId": "40834864"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T18:55:36Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31309076')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31447155"
+"ListingKey": "29827779"
+"ListingId": "40834864"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T20:00:58Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31447155')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29827779' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8823441 43.3323597)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25242
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:15:03Z"
+"RFModificationTimestamp": "2026-06-16T00:38:53Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:09:52Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660191163"
"RoomType" => "Bedroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
…6
]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1531843"
+post_author: 1
+"ListingKey": "29905680"
+"ListingId": "X13446596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS CRESCENT, Hamilton (Waterdown), Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.892899
1 => 43.326881
]
+"Latitude": 43.326881
+"Longitude": -79.892899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on one of Waterdown's most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well-proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard and private, tranquil green space. Enjoy summer evenings on the expansive composite deck, gather with friends friend and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town's most sought-after areas. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:35.932384+00:00"
+"Directions": "Cross Streets: Howard Blvd. ** Directions: South of Dundas St E on Howard Blvd, turn ontoMays Cres."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101938"
+"ListOfficeKey": "288807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "72.2 x 196.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:52Z"
+"Stories": "2.0"
+"StreetName": "Mays"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9061.67"
+"VirtualTourURLUnbranded": "https://listings.webbify.ca/5-Mays-Crescent-Hamilton-ON-L8B-0G4-Canada"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905680/5-mays-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 72.2
+"OriginalEntryTimestamp": "2026-06-15T18:56:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371767"
+"ListOfficeNationalAssociationId": "1371723"
+"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('29905680')"
+"ID": "1531843"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1530966"
+post_author: 1
+"ListingKey": "29904850"
+"ListingId": "40839710"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:00:17Z"
+"RFModificationTimestamp": "2026-06-15T19:26:25Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.33
+"LivingArea": 3344.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS Crescent, Waterdown, Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.8932325
1 => 43.3271885
]
+"Latitude": 43.3271885
+"Longitude": -79.8932325
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on one of Waterdown’s most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well- proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard as well as the private, tranquil green space behind. Enjoy summer evenings on the expansive composite deck, gather with friends and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town’s most sought-after areas. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:26:11.527080+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032649"
+"ListOfficeKey": "286831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.33"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:51:41Z"
+"Stories": "2.0"
+"StreetName": "MAYS"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9061.67"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904850/5-mays-crescent-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 2098
+"BelowGradeFinishedArea": 1246
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1309851"
+"ListOfficeNationalAssociationId": "1364228"
+"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('29904850')"
+"ID": "1530966"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1525931"
+post_author: 1
+"ListingKey": "29898285"
+"ListingId": "X13439700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:40:08Z"
+"RFModificationTimestamp": "2026-06-12T23:51:00Z"
+"ListPrice": 2395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "345 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.870648
1 => 43.339359
]
+"Latitude": 43.339359
+"Longitude": -79.870648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 3-acres (per MPAC) this property overlooks the breathtaking natural landscape of Smokey Hollow and backs directly onto the iconic Bruce Trail. This remarkable gated estate offers a rare opportunity to acquire one of the area's most picturesque and private estates. A graceful, swooping driveway leads through expansive, awe-inspiring grounds, creating a dramatic sense of arrival while remaining discreet and private from the road. The 2.5-storey residence offers 7 bedrooms and 5 bathrooms, along with a library with a fireplace. The home in its current state needs to be renovated. Outdoor features include an inground swimming pool and a detached double-car garage, all set within the property's remarkable estate setting. For those with a vision for transformation, a new house rendering design by SMPL Design Studio offers inspiration for a spectacular modern residence. Ideally located just minutes from downtown Waterdown, Burlington, and the convenient Aldershot GO Station, providing easy access to amenities and commuting options. Property and all structures are being sold in AS-IS condition. Floor plans and a survey are available. Either renovate the existing house or build a new one. Exterior photos are current and from a few years ago. Interior photos and new home renderings are for creative / illustrative purposes only. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-12T23:50:55.953773+00:00"
+"Directions": "Cross Streets: Waterdown Rd / Mountain Brow Rd. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529018"
+"ListOfficeKey": "291562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.8 x 579.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:31:41Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:31:41Z"
+"Stories": "2.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "17408"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898285/345-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1743890"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 7
+"FrontageLengthNumeric": 151.9
+"OriginalEntryTimestamp": "2026-06-12T21:31:41.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140630"
+"ListOfficeNationalAssociationId": "1400240"
+"CoListAgentNationalAssociationId": "1292982"
+"CoListOfficeNationalAssociationId": "1400240"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898285')"
+"ID": "1525931"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1522008"
+post_author: 1
+"ListingKey": "29892469"
+"ListingId": "X13434412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:25:12Z"
+"RFModificationTimestamp": "2026-06-12T14:28:02Z"
+"ListPrice": 519998.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom units available. Located on the 6th floor, this unit offers spacious, modern living with 1 bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the Great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 makingfor an easier commute. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "551.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:02:54.162610+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:56Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:19:15Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3700"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892469/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-11T21:53:56.23Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1521037"
+post_author: 1
+"ListingKey": "29891435"
+"ListingId": "X13433494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:06Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "4 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.9062491
1 => 43.3361384
]
+"Latitude": 43.3361384
+"Longitude": -79.9062491
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained freehold townhouse in sought-after Waterdown offering approximately 1470 sq. ft. of above ground finished living space. This 3-bedroom, 4-bathroom home features a bright open-concept layout with 9-ft ceilings on the main floor, a finished basement, and numerous quality upgrades throughout. Major updates include new basement/staircase carpeting (2021); kitchen countertops, backsplash, sinks, faucets, microwave, bathroom countertops, sinks and faucets, primary ensuite glass shower door, pot lights throughout the main and second floors, basement light fixtures, automated garage door opener, and humidifier (2022); new furnace, water softener, drinking water filtration system, and smart door lock (2023); plus a smart thermostat and Google video doorbell (2020).The functional layout offers spacious principal rooms, a modernized kitchen with ample cabinetry and workspace, and a finished lower level ideal for recreation, work-from-home space, or extended family living. Attached garage and private driveway parking add everyday convenience. Ideally located close to schools, the YMCA, Park, playgrounds, public transit, and a full-service shopping plaza featuring Fortinos, Tim Hortons, McDonald's, restaurants, daycare services, family medical and dental offices, convenience stores, and more. Move-in ready and thoughtfully updated, this home offers exceptional comfort, convenience, and value in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Humidifier"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:54.750046+00:00"
+"Directions": "Parkside Dr/Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072378"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 100.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:52Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:52Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://homes.motionstudio.ca/listings/DsjdOGEOX8hCTJ3iwqUy/website/basic/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891435/4-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2190178"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2130691"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "282777"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:52.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347560"
+"ListOfficeNationalAssociationId": "1321336"
+"CoListAgentNationalAssociationId": "1439294"
+"CoListAgentNationalAssociationId2": "1383597"
+"CoListOfficeNationalAssociationId": "1470118"
+"CoListOfficeNationalAssociationId2": "1321336"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1520592"
+post_author: 1
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T11:50:15Z"
+"RFModificationTimestamp": "2026-06-15T11:53:37Z"
+"ListPrice": 1589000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "194 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.901709
1 => 43.325096
]
+"Latitude": 43.325096
+"Longitude": -79.901709
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to charming Waterdown where this estate style property feels like the country but has all the perks of in-town-living! This raised bungalow features over 2600 square feet of finished living space with 5 bedrooms and 3 bathrooms combined on both levels. Tons of room for a growing family or set it up with a nanny/income suite in the lower level with a separate walk out to the backyard. Sitting on over half an acre, you've got excellent space to play and entertain. Fully fenced backyard with saltwater inground pool, deck and gas bbq line. Invite all your friends because there's parking for 15 vehicles! Recent upgrades include basement flooring with R4 thermal subfloor (2026), furnace (2025), upper front windows (2024), main bath (2022), ensuite (2022), roof (2022). Please see the attached feature sheet for a complete list of features and upgrades. Fireplace not currently operational. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:33:51.597596+00:00"
+"Directions": "Cross Streets: Dundas/Hamilton. ** Directions: On the south side of Dundas just east of Riley."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004228"
+"ListOfficeKey": "285613"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Sloping"
1 => "Flat site"
2 => "Carpet Free"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "110.4 x 207.4 FT ; 110.44 x 207.42 x 110.21 x 214.83"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T11:35:12Z"
+"PhotosCount": 42
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:35:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "194"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9299.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/194_dundas_street_east_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29887232/194-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1841558"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285613"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.4
+"OriginalEntryTimestamp": "2026-06-11T11:35:11.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287388"
+"ListOfficeNationalAssociationId": "1352696"
+"CoListAgentNationalAssociationId": "1197719"
+"CoListOfficeNationalAssociationId": "1352696"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887232')"
+"ID": "1520592"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1520053"
+post_author: 1
+"ListingKey": "29888470"
+"ListingId": "X13430622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:07Z"
+"RFModificationTimestamp": "2026-06-12T07:20:20Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Rarely offered, this exceptional property delivers the feeling of cottage living in the city while offering the convenience of one of Waterdown's most sought after neighbourhoods. Situated on an incredible lot of nearly 10,000 sq. ft., this beautifully updated bungalow offers approximately 2,360 sq. ft. of finished living space with 3+2 bedrooms and 3 full bathrooms.The stunning open concept layout is anchored by a beautifully renovated kitchen featuring a massive centre island, stainless steel appliances, a 5 burner gas range, pot lights, and seamless flow into the living and dining areas. Bright, sun filled rooms throughout allow for an abundance of natural light, while updated railings, renovated closet spaces, and thoughtful improvements create a home that is both stylish and functional.The fully finished lower level offers incredible versatility with two additional bedrooms, a living area with a fireplace, and a relaxing 4 person infrared sauna for all your health/detox needs.Step outside and enjoy your own private backyard oasis. Surrounded by newer fencing for enhanced privacy, this expansive outdoor space features two gazebos, an extended patio, and a fire pit area, providing the perfect setting for entertaining, relaxing, and enjoying the outdoors.Major updates include a recently replaced roof and updated appliances within the last few years, providing peace of mind for years to come. With parking for 5 vehicles and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this move in ready home offers a lifestyle that is truly hard to find.VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:21:30.107435+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:54Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:54Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888470/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1518137"
+post_author: 1
+"ListingKey": "29887094"
+"ListingId": "X13429540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:50:27Z"
+"RFModificationTimestamp": "2026-06-11T05:58:26Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "905 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern Trend Living condo with 9-ft ceilings and an open-concept layout. Features ceramic tile flooring and bright LED lighting throughout. The stylish kitchen offers custom cabinetry, designer faucet, and laminate countertops with a backsplash, while the bathrooms boast quartz countertops and spa-inspired premium fixtures. Enjoy a feature wall for your TV, a French balcony, and an owned locker for extra convenience. Pet-friendly in both living areas and bedrooms. This energy-efficient building includes geothermal heating/cooling, secure entry, 2 owned underground parking spaces, rooftop terrace, and professional management. Freshly painted and perfectly located near parks, shopping, restaurants, and major highways. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "497.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T05:58:17.496106+00:00"
+"Directions": "Dundas St/ Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036997"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T04:42:09Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:42:09Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3952.38"
+"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/29887094/905-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T04:42:09.45Z"
+"ListAgentNationalAssociationId": "1313436"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887094')"
+"ID": "1518137"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 189
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]