array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29816494 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: "1470036"
+post_author: 1
+"ListingKey": "29816494"
+"ListingId": "40833964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:57Z"
+"RFModificationTimestamp": "2026-06-02T16:35:41Z"
+"ListPrice": 6999000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 9764.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "597 OLD YORK Road, Burlington, Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.8968094
1 => 43.309999
]
+"Latitude": 43.309999
+"Longitude": -79.8968094
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AMAZING! Custom Bungaloft nestled on a spectacular 12-acre property in Burlington. Featuring 5+1 bedrooms, 6 full bathrooms and 2 half baths with an attached triple car garage AND detached double car garage with storage loft! Boasting over 5,400 square feet PLUS an additional 4,300 square feet in the finished lower level. Resort-style exterior with a pool, hot tub, pond, cabana, outdoor kitchen, full bar, built in BBQ area, golf green, two firepits, a fireplace and 5+ forested acres! The main floor offers DUAL primary bedrooms- each with ensuite baths and large walk-in closets. There is also a main floor office and oversized dining room. The kitchen features a large island, stainless steel appliances and a walk-in pantry. The kitchen is open to the living room- which features 12’ ceilings and a stunning wood burning fireplace. There is also an oversized mudroom / laundry room with garage access and two powder rooms. The 2nd level of the home includes 3 large bedrooms and a 5-piece bathroom. The lower level (accessible by stairs OR elevator) features an amazing rec/family room, 6th bedroom, second kitchen, 2 full bathrooms, a wine cellar, gym, sauna, wet bar and plenty of storage! This home was custom built by Glen Oak Homes in 2016 and a main floor addition with full basement was added in 2024. The entire property was fully landscaped in 2023/2024. Interior and exterior ‘smart’ features throughout, highly efficient and fully private- a true paradise. Luxury Certified (id:62650)"
+"Appliances": array:6 [
0 => "Water purifier"
1 => "Water softener"
2 => "Sauna"
3 => "Central Vacuum"
4 => "Oven - Built-In"
5 => "Wet Bar"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T19:20:29.618491+00:00"
+"Directions": "York Rd to Old York Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875327"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Wet bar"
3 => "Paved driveway"
4 => "Gazebo"
5 => "Automatic Garage Door Opener"
6 => "In-Law Suite"
]
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T12:31:34Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:14:41Z"
+"Stories": "1.5"
+"StreetName": "OLD YORK"
+"StreetNumber": "597"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"TaxAnnualAmount": "21840.18"
+"VirtualTourURLUnbranded": "https://vimeo.com/1114044764"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:27 [
0 => array:11 [
"RoomKey" => "1649790047"
"RoomType" => "Storage"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "23'4'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.97Z"
]
1 => array:11 [
"RoomKey" => "1649790048"
"RoomType" => "Utility room"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
2 => array:11 [
"RoomKey" => "1649790049"
"RoomType" => "Kitchen"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
3 => array:11 [
"RoomKey" => "1649790050"
"RoomType" => "Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
4 => array:11 [
"RoomKey" => "1649790051"
"RoomType" => "3pc Bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
5 => array:11 [
"RoomKey" => "1649790053"
"RoomType" => "Sauna"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
6 => array:11 [
"RoomKey" => "1649790055"
"RoomType" => "3pc Bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
7 => array:11 [
"RoomKey" => "1649790056"
"RoomType" => "Gym"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "25'10'' x 23'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
8 => array:11 [
"RoomKey" => "1649790057"
"RoomType" => "Utility room"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 13'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
9 => array:11 [
"RoomKey" => "1649790058"
"RoomType" => "Wine Cellar"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
10 => array:11 [
"RoomKey" => "1649790059"
"RoomType" => "Recreation room"
"ListingId" => "40833964"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 52'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
11 => array:11 [
"RoomKey" => "1649790060"
"RoomType" => "Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
12 => array:11 [
"RoomKey" => "1649790061"
"RoomType" => "Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
13 => array:11 [
"RoomKey" => "1649790062"
"RoomType" => "5pc Bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
14 => array:11 [
"RoomKey" => "1649790063"
"RoomType" => "Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "21'8'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
15 => array:11 [
"RoomKey" => "1649790064"
"RoomType" => "2pc Bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.98Z"
]
16 => array:11 [
"RoomKey" => "1649790065"
"RoomType" => "Mud room"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
17 => array:11 [
"RoomKey" => "1649790066"
"RoomType" => "Breakfast"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
18 => array:11 [
"RoomKey" => "1649790067"
"RoomType" => "Kitchen"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "18'2'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
19 => array:11 [
"RoomKey" => "1649790068"
"RoomType" => "Dining room"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
20 => array:11 [
"RoomKey" => "1649790069"
"RoomType" => "Family room"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "19'6'' x 25'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
21 => array:11 [
"RoomKey" => "1649790070"
"RoomType" => "Full bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
22 => array:11 [
"RoomKey" => "1649790071"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
23 => array:11 [
"RoomKey" => "1649790072"
"RoomType" => "2pc Bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
24 => array:11 [
"RoomKey" => "1649790073"
"RoomType" => "Full bathroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
25 => array:11 [
"RoomKey" => "1649790074"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "23'5'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
26 => array:11 [
"RoomKey" => "1649790075"
"RoomType" => "Office"
"ListingId" => "40833964"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816494"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:14:41.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29816494/597-old-york-road-burlington"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1953176"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RNA1, O3-196, DNA"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 320.0
+"AboveGradeFinishedArea": 5434
+"BelowGradeFinishedArea": 4330
+"OriginalEntryTimestamp": "2026-05-28T12:31:33.85Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1204050"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1246540"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29816494_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/b7b9117a444ba780b0b10043d4442ebd.webp"
"MediaSize" => 107048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-b7b9117a444ba780b0b10043d4442ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29816494_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/30669e7ea65746b3a4aa57f21cc46d9d.webp"
"MediaSize" => 150939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-30669e7ea65746b3a4aa57f21cc46d9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29816494_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/5d50106e7c84e4704f8527867d45392a.webp"
"MediaSize" => 151114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-5d50106e7c84e4704f8527867d45392a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29816494_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/8aa686293d04c456ba69f76833c59dcf.webp"
"MediaSize" => 77734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-8aa686293d04c456ba69f76833c59dcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dinning Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29816494_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/ad58321075e17d38c4d0c6883a59293c.webp"
"MediaSize" => 109136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-ad58321075e17d38c4d0c6883a59293c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29816494_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/6a821acba2a12d27475a86af5e5b82a8.webp"
"MediaSize" => 99826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-6a821acba2a12d27475a86af5e5b82a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family Rooom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29816494_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/04383dd617bbc9abee712ab6204a44c4.webp"
"MediaSize" => 86636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-04383dd617bbc9abee712ab6204a44c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29816494_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/fd4134798c44cbe880e2c6910a6ad7c1.webp"
"MediaSize" => 90694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-fd4134798c44cbe880e2c6910a6ad7c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29816494_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/d22c15cd6ae030477a852cdb67608826.webp"
"MediaSize" => 101263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-d22c15cd6ae030477a852cdb67608826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29816494_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/ca65469eb8102e9e1182b48ef4446d5b.webp"
"MediaSize" => 90942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-ca65469eb8102e9e1182b48ef4446d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary suite niche with bar fridge"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29816494_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/1bd36e69a14d70c4cd29f113b4046e23.webp"
"MediaSize" => 106705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-1bd36e69a14d70c4cd29f113b4046e23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29816494_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/7df11055522738e3187b8eb8c8582284.webp"
"MediaSize" => 96679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-7df11055522738e3187b8eb8c8582284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29816494_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/a04b0efce3496ae2d5f83744712fef04.webp"
"MediaSize" => 113406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-a04b0efce3496ae2d5f83744712fef04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29816494_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/2041bd293fe831285a6f10fd87ddaa83.webp"
"MediaSize" => 69787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-2041bd293fe831285a6f10fd87ddaa83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29816494_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/211c5243b4f4282882914211f8be507f.webp"
"MediaSize" => 56908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-211c5243b4f4282882914211f8be507f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29816494_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/fb45800a3b57ed3b694cf8072072b43e.webp"
"MediaSize" => 93513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-fb45800a3b57ed3b694cf8072072b43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Suite Exertior Access"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29816494_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/910b010e7fcd97d6efc302671d0ba84d.webp"
"MediaSize" => 85639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-910b010e7fcd97d6efc302671d0ba84d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Elevator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29816494_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/6f909c73ca8825ef3ee3f41333d3e580.webp"
"MediaSize" => 71256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-6f909c73ca8825ef3ee3f41333d3e580.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Primary Bedroom Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29816494_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/ab8ca6aedb38d3eef2f22e91757de195.webp"
"MediaSize" => 78049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-ab8ca6aedb38d3eef2f22e91757de195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29816494_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/78a2d9d583a30e5242a5a5c1730826ad.webp"
"MediaSize" => 75713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-78a2d9d583a30e5242a5a5c1730826ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Primary Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29816494_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/7179b1b1655d7e550d903d2bfd396f9d.webp"
"MediaSize" => 88461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-7179b1b1655d7e550d903d2bfd396f9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Primary Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29816494_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/ee665c2bf2156198ed542e40cc047aad.webp"
"MediaSize" => 73431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-ee665c2bf2156198ed542e40cc047aad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Primary Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29816494_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/7fd46bff550533d09bbd37f8025ee905.webp"
"MediaSize" => 57840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-7fd46bff550533d09bbd37f8025ee905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29816494_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/57f38b0f3a629ff7d458cf6292531dd1.webp"
"MediaSize" => 71611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-57f38b0f3a629ff7d458cf6292531dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29816494_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/0b677d7bfddf32b7aec2c0d4cdf3b033.webp"
"MediaSize" => 62154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-0b677d7bfddf32b7aec2c0d4cdf3b033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29816494_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/8c1d7a9d319dcc37f5d83e2f354882e7.webp"
"MediaSize" => 63692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-8c1d7a9d319dcc37f5d83e2f354882e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Loft Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29816494_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/93f340e84705d6b9f0ca1133e90413b6.webp"
"MediaSize" => 73748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-93f340e84705d6b9f0ca1133e90413b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Loft Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29816494_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/120f91bd038d1764dcee6bde50f691bd.webp"
"MediaSize" => 65975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-120f91bd038d1764dcee6bde50f691bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Loft Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29816494_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/69ba929ba629242db252363546c5ba51.webp"
"MediaSize" => 75406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-69ba929ba629242db252363546c5ba51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Loft Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29816494_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/35ed5baf11411eadd7433e789c5c35f9.webp"
"MediaSize" => 94136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-35ed5baf11411eadd7433e789c5c35f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreation Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29816494_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/3343b8e56ec75a093b4fd0e2e05d5c6d.webp"
"MediaSize" => 90396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-3343b8e56ec75a093b4fd0e2e05d5c6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreation Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29816494_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/d70fa9389a83ba118d709fe285120c69.webp"
"MediaSize" => 97449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-d70fa9389a83ba118d709fe285120c69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreation Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29816494_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/bd90aa5553d605747bf5e47507e4d8b0.webp"
"MediaSize" => 69748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-bd90aa5553d605747bf5e47507e4d8b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29816494_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/4c15e7b173161b9f845480adbc94a576.webp"
"MediaSize" => 175968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-4c15e7b173161b9f845480adbc94a576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29816494_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/ca638f256e55e740f269a178a926ea06.webp"
"MediaSize" => 55356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-ca638f256e55e740f269a178a926ea06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29816494_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/50a399dabea6b743c35fefd629da1af2.webp"
"MediaSize" => 56100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-50a399dabea6b743c35fefd629da1af2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29816494_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/3c5c9e08c0823563a1b02fa4ccfeec84.webp"
"MediaSize" => 92508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-3c5c9e08c0823563a1b02fa4ccfeec84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29816494_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/caf323c52e9aab0528b836128f175fc5.webp"
"MediaSize" => 85560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-caf323c52e9aab0528b836128f175fc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29816494_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/4c6dbef7ab6ddaf4e4aa018f004b1fd3.webp"
"MediaSize" => 95022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-4c6dbef7ab6ddaf4e4aa018f004b1fd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29816494_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/695aa8ab297940ef1312d7c5c4a78d18.webp"
"MediaSize" => 83954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816494/thumbnail-695aa8ab297940ef1312d7c5c4a78d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833964"
"ResourceRecordKey" => "29816494"
"ModificationTimestamp" => "2026-05-28T12:31:33.85Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29816494_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816494/655d79ee383952810b5c50bdcf665dc2.webp"
"MediaSize" => 126915
…9
]
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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816494')"
+"ID": "1470036"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24748
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1875327" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24742
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29816494'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25157
+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 '29816494'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25173
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29816494' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8968094 43.309999)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1531736"
+post_author: 1
+"ListingKey": "29905626"
+"ListingId": "40830994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:00:17Z"
+"RFModificationTimestamp": "2026-06-15T21:51:19Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2804.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK Place, Waterdown, Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.9103799
1 => 43.3224782
]
+"Latitude": 43.3224782
+"Longitude": -79.9103799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous “site lines” enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer’s dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:51:15.502458+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1751064"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:52:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:52:03Z"
+"Stories": "2.0"
+"StreetName": "FENWICK"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7011.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/17_fenwick_pl_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905626/17-fenwick-place-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1950
+"BelowGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2026-06-15T18:52:03.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1181610"
+"ListOfficeNationalAssociationId": "1344653"
+"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('29905626')"
+"ID": "1531736"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1531326"
+post_author: 1
+"ListingKey": "29906158"
+"ListingId": "X13446970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:17Z"
+"RFModificationTimestamp": "2026-06-15T20:56:18Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK PLACE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.910126
1 => 43.322235
]
+"Latitude": 43.322235
+"Longitude": -79.910126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous "site lines" enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer's dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:56:14.701422+00:00"
+"Directions": "Hollybush/Fenwick"
+"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": "1981607"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 121.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:46Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:01Z"
+"Stories": "2.0"
+"StreetName": "Fenwick"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7011"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17_fenwick_pl_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906158/17-fenwick-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:46.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267040"
+"ListOfficeNationalAssociationId": "1344892"
+"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('29906158')"
+"ID": "1531326"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904850')"
+"ID": "1530966"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1530774"
+post_author: 1
+"ListingKey": "29905119"
+"ListingId": "X13446180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:40:13Z"
+"RFModificationTimestamp": "2026-06-16T18:47:14Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7C5"
+"UnparsedAddress": "37 MELISSA CRESCENT, Hamilton (Waterdown), Ontario L9H7C5"
+"Coordinates": array:2 [
0 => -79.905585
1 => 43.32541
]
+"Latitude": 43.32541
+"Longitude": -79.905585
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully renovated bungalow nestled on a quiet, highly sought-after crescent in the heart of Waterdown. Offering over 2,500 sq. ft. of finished living space, this fully renovated, turn-key home features 3+1 bedrooms and 2 full bathrooms, thoughtfully updated with quality finishes and timeless style throughout. The bright and inviting main level offers large rooms designed for comfortable everyday living, while the fully finished lower level provides versatile additional space for family, guests, a home office, or recreation. Step outside to your private backyard retreat, complete with a hot tub, and a large tiered deck perfect for entertaining, outdoor dining, and enjoying warm summer evenings. Located within walking distance to scenic trails, parks, and Waterdown's vibrant downtown core, this home offers the perfect balance of nature, convenience, and community. A rare opportunity to own a move-in-ready bungalow in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:24:46.422319+00:00"
+"Directions": "Cross Streets: Scott Street. ** Directions: Riley St to Scott St to Melissa Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"LotSizeDimensions": "55 x 119 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:58:08Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:32:55Z"
+"Stories": "1.0"
+"StreetName": "Melissa"
+"StreetNumber": "37"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7384"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/-My3LeJd9kI"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905119/37-melissa-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"OriginalEntryTimestamp": "2026-06-15T17:58:08.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355945"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905119')"
+"ID": "1530774"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1530367"
+post_author: 1
+"ListingKey": "29904015"
+"ListingId": "40839637"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:15:45Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2660.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7C5"
+"UnparsedAddress": "37 MELISSA Crescent, Waterdown, Ontario L9H7C5"
+"Coordinates": array:2 [
0 => -79.9054306
1 => 43.3255289
]
+"Latitude": 43.3255289
+"Longitude": -79.9054306
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated bungalow nestled on a quiet, highly sought-after crescent in the heart of Waterdown. Offering over 2,500 sq. ft. of finished living space, this fully renovated, turn-key home features 3+1 bedrooms and 2 full bathrooms, thoughtfully updated with quality finishes and timeless style throughout. The bright and inviting main level offers large rooms designed for comfortable everyday living, while the fully finished lower level provides versatile additional space for family, guests, a home office, or recreation. Step outside to your private backyard retreat, complete with a hot tub, and a large tiered deck perfect for entertaining, outdoor dining, and enjoying warm summer evenings. Located within walking distance to scenic trails, parks, and Waterdown's vibrant downtown core, this home offers the perfect balance of nature, convenience, and community. A rare opportunity to own a move-in-ready bungalow in one of Waterdown's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T17:29:31.396162+00:00"
+"Directions": "Riley St to Scott St to Melissa Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:12:37Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:51:22Z"
+"Stories": "1.0"
+"StreetName": "MELISSA"
+"StreetNumber": "37"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7384"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/-My3LeJd9kI?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904015/37-melissa-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1500
+"BelowGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2026-06-15T16:11:56.41Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204077"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904015')"
+"ID": "1530367"
}
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-16T15:05:03Z"
+"RFModificationTimestamp": "2026-06-16T15:10:14Z"
+"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-16T14:56:23Z"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887232')"
+"ID": "1520592"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1496309"
+post_author: 1
+"ListingKey": "29856434"
+"ListingId": "X13242798"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T12:50:01Z"
+"RFModificationTimestamp": "2026-06-16T12:52:58Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7N3"
+"UnparsedAddress": "9 - 122 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7N3"
+"Coordinates": array:2 [
0 => -79.907264
1 => 43.320201
]
+"Latitude": 43.320201
+"Longitude": -79.907264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish spacious 3-bedroom townhome nestled in the heart of Waterdown, ideal for first-time buyers and young professionals. Thoughtfully designed layout offers bright, open-concept living with contemporary finishes throughout. Modern kitchen with ample cabinetry and prep space flows seamlessly into the living and dining areas, perfect for entertaining. Generous bedrooms provide comfort and flexibility for work-from-home or guest space. Large comfortable primary suite with a 4-piece ensuite. Outdoor patio area extends your living space for summer evenings and morning coffee. Well-managed complex with visitor parking and a strong sense of community. Conveniently located close to Rockcliffe trails, shops, cafes, parks, and everyday amenities. Easy access to major highways makes commuting effortless. A fantastic opportunity to enter the market in one of Waterdown's most in-demand neighbourhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "239.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T21:21:06.676709+00:00"
+"Directions": "Cross Streets: Dundas & Hollybush. ** Directions: South off Dundas."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154241"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T13:03:34Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:41:55Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "122"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3788"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/9_122_dundas_st_e_waterdown_on/"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29856434/9-122-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Arthex Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R6-36"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-04T20:57:05.39Z"
+"ListAgentNationalAssociationId": "1405758"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856434')"
+"ID": "1496309"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1484026"
+post_author: 1
+"ListingKey": "29838790"
+"ListingId": "40834320"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T14:41:01Z"
+"RFModificationTimestamp": "2026-06-03T14:43:45Z"
+"ListPrice": 993000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1890.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7G2"
+"UnparsedAddress": "18 DENNIS Avenue, Waterdown, Ontario L9H7G2"
+"Coordinates": array:2 [
0 => -79.9060199
1 => 43.3216787
]
+"Latitude": 43.3216787
+"Longitude": -79.9060199
+"YearBuilt": 1965
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional value in this detached 3-bedroom home located in a desirable, mature neighborhood close to everyday conveniences and scenic escarpment trails. The front yard features beautiful perennial gardens, a variety of fruit trees and a front porch that creates welcoming curb appeal. Inside, this updated home is tastefully decorated in neutral tones and features hardwood flooring throughout. The kitchen is equipped with stainless steel appliances, and abundant storage with espresso-stained cabinetry. Patio doors from the dining room lead to a spacious deck with gazebos overlooking the private fenced backyard — perfect for relaxing or entertaining. The lower level features a fully finished games room with a practical walk-up entrance from the rear yard. The basement also includes the added convenience of a full bathroom and flexible space ideal for a home office, guest area, workshop, or whatever best suits your family’s needs. Additional highlights include: storm shutters on all windows, electric patio door shutter, all season gazebos w/eaves troughs, mosquito screens and solar lighting, 2 large sheds with lights and outlets, security camera, pond with electrical connection, gas line for BBQ, Moen shower faucet, reverse osmosis filtration and water softener, leaf guard filter, garage w/cabinetry and 200 amp service. A wonderful opportunity to own a move-in ready home in a sought-after Waterdown location. -- (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T14:54:24.505039+00:00"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1669054"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T14:13:22Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T14:32:43Z"
+"Stories": "2.0"
+"StreetName": "DENNIS"
+"StreetNumber": "18"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5928"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29838790/18-dennis-avenue-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-35"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 1890
+"OriginalEntryTimestamp": "2026-06-02T14:20:24.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1169833"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838790')"
+"ID": "1484026"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 36
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]