array:6 [
"RF Cache Key: e32f61408c299fba21d5b6fec6fad428241cdcacdb0c01836430c5b1308c4219" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#1887
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29168655"
+"ListingId": "40792313"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T01:50:57Z"
+"RFModificationTimestamp": "2025-12-15T01:54:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1503.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y3"
+"UnparsedAddress": "112 SKINNER Road, Hamilton, Ontario L8B1Y3"
+"Coordinates": array:2 [
0 => -79.879877
1 => 43.338415
]
+"Latitude": 43.338415
+"Longitude": -79.879877
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Like new immaculately maintained Semi Detached house in Waterdown's most desirable neighbourhood. Beautifully landscaped backyard. Single car garage plus widened driveway. 3 Bedrooms & 3 Baths, Open Concept Main Level with quality Laminate Floors & 9' Ceilings, Modern Kitchen with central island and Stainless Steel Appliances. Primary Bedroom with 4 Pc Ensuite, Minutes To Hwy 407, Qew & Go Stations, 15 Minutes To Mcmaster, Close To Shopping & Schools. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T16:40:35.261842+00:00"
+"Directions": "Dundas St. E. to Burke St. to Skinner Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T22:00:10Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T01:38:30Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "112"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1549171872"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792313"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "1' x 1'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.01Z"
]
1 => array:11 [
"RoomKey" => "1549171873"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792313"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "1' x 1'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.02Z"
]
2 => array:11 [
"RoomKey" => "1549171874"
"RoomType" => "Bedroom"
"ListingId" => "40792313"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.02Z"
]
3 => array:11 [
"RoomKey" => "1549171875"
"RoomType" => "Bedroom"
"ListingId" => "40792313"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.02Z"
]
4 => array:11 [
"RoomKey" => "1549171876"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792313"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.03Z"
]
5 => array:11 [
"RoomKey" => "1549171877"
"RoomType" => "2pc Bathroom"
"ListingId" => "40792313"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "1' x 1'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.03Z"
]
6 => array:11 [
"RoomKey" => "1549171878"
"RoomType" => "Breakfast"
"ListingId" => "40792313"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "9' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.04Z"
]
7 => array:11 [
"RoomKey" => "1549171879"
"RoomType" => "Kitchen"
"ListingId" => "40792313"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.04Z"
]
8 => array:11 [
"RoomKey" => "1549171880"
"RoomType" => "Great room"
"ListingId" => "40792313"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29168655"
"RoomLength" => null
"RoomDimensions" => "10' x 19'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T01:38:30.05Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29168655/112-skinner-road-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1503
+"OriginalEntryTimestamp": "2025-12-06T14:30:04.25Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6358486039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/554219da540716d58302babb24db07f2.webp"
"MediaSize" => 99122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-554219da540716d58302babb24db07f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade with asphalt driveway, brick siding, a porch, and an attached garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-06T14:30:04.26Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6361909984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/e67ac38aa2d4f8558c574d6af08178bb.webp"
"MediaSize" => 102353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-e67ac38aa2d4f8558c574d6af08178bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with light wood finished floors and a raised ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.29Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6361910006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/208c3eda22a24c05e2eaa7af2a3a7fc2.webp"
"MediaSize" => 104879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-208c3eda22a24c05e2eaa7af2a3a7fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a chandelier and dark wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.37Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6361910054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/cd20de2e72ad621135e5eb7f7997494f.webp"
"MediaSize" => 58126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-cd20de2e72ad621135e5eb7f7997494f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, pendant lighting, a chandelier, under cabinet range hood, and a center island"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.36Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6361910135"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/bb7b882c18ae578e372b061e6f9bbbb2.webp"
"MediaSize" => 95600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-bb7b882c18ae578e372b061e6f9bbbb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space with light tile patterned floors and healthy amount of natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.34Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6361910211"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/e6c50e5d05a80a3c0b1fae02bb6cb5dc.webp"
"MediaSize" => 92210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-e6c50e5d05a80a3c0b1fae02bb6cb5dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with appliances with stainless steel finishes, a center island, light tile patterned floors, under cabinet range hood, and decorative light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.37Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6361910277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/19d4c5c6d91aa1fd48ee512800f11a47.webp"
"MediaSize" => 52954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-19d4c5c6d91aa1fd48ee512800f11a47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall with stairs, light wood-style floors, and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.34Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6361910331"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/0ec56fe285cf3fb298be6e766c451527.webp"
"MediaSize" => 44675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-0ec56fe285cf3fb298be6e766c451527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring light tile patterned floors and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.32Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6361910399"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/62ecdae570fae9ad7844ce3d4521083d.webp"
"MediaSize" => 39628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-62ecdae570fae9ad7844ce3d4521083d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring light tile patterned flooring and shower / tub combination"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.22Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6361910436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/49cfc578c3c09e0c2e7cfd80fe9b3157.webp"
"MediaSize" => 37483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-49cfc578c3c09e0c2e7cfd80fe9b3157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with vanity, light tile patterned floors, and shower combination"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.36Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6361910496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/67bf56cbd819ca72a48b52a939d072b5.webp"
"MediaSize" => 36703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-67bf56cbd819ca72a48b52a939d072b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bath featuring vanity and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.32Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6361910568"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/d654ef1a56ae2090938a7ab0226e8984.webp"
"MediaSize" => 40006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-d654ef1a56ae2090938a7ab0226e8984.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite bathroom featuring shower / tub combo with curtain and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.37Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6361910571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/82035256d61c42ce2f1694396e9af9a7.webp"
"MediaSize" => 74969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-82035256d61c42ce2f1694396e9af9a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space featuring light colored carpet and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.33Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6361910603"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/df22827e421992b87c9e0c1a6a0d7969.webp"
"MediaSize" => 71246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-df22827e421992b87c9e0c1a6a0d7969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring light wood finished floors, stairs, and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.33Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6361910650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/23dd054e25ae550ef71247d63a602e8d.webp"
"MediaSize" => 52947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-23dd054e25ae550ef71247d63a602e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with a textured ceiling and light colored carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.36Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6361910666"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/8423523a3b1836ef86ec12b19d882f20.webp"
"MediaSize" => 57832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-8423523a3b1836ef86ec12b19d882f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with a nursery area and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.23Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6361910744"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/564b39c47a5029b652d02acd20e96144.webp"
"MediaSize" => 49434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-564b39c47a5029b652d02acd20e96144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space featuring a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.36Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6361910756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/b6d27fabd6fdd74d0d01ecfca38719b0.webp"
"MediaSize" => 110280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-b6d27fabd6fdd74d0d01ecfca38719b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of below grade area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.36Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6361910789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/4fa3c7135cf74278ae5f1337ec35af51.webp"
"MediaSize" => 78817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-4fa3c7135cf74278ae5f1337ec35af51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of unfinished below grade area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:23.62Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6361910858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/324ae6925ee5e986083c059190f20ae7.webp"
"MediaSize" => 185124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-324ae6925ee5e986083c059190f20ae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden terrace with a residential view and a fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.27Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6361910904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29168655/46719fa219b118f234aee079c262f660.webp"
"MediaSize" => 170394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29168655/thumbnail-46719fa219b118f234aee079c262f660.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with a patio and a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792313"
"ResourceRecordKey" => "29168655"
"ModificationTimestamp" => "2025-12-08T21:51:22.29Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Ying Liu"
"MemberFirstName" => "Ying"
"MemberLastName" => "Liu"
"MemberMlsId" => "HBLIUYI"
"OriginatingSystemName" => 26
"MemberKey" => "1524541"
"ModificationTimestamp" => "2025-10-28T23:12:53Z"
"MemberStatus" => "Active"
"OfficeKey" => "293386"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Burlington"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-923-9753"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1129428"
"OfficeNationalAssociationId" => "1426403"
]
]
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "Leaf King Realty Ltd."
"OfficePhone" => "905-319-1896"
"OfficeMlsId" => "HBLEAFKINGRL"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293386"
"ModificationTimestamp" => "2025-07-09T18:36:53Z"
"OfficeAddress1" => "2220 Tiger Road"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7M4X"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2022-10-11T19:36:00Z"
"OfficeNationalAssociationId" => "1426403"
"OfficeBrokerNationalAssociationId" => "1292588"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168655')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293386/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293386&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293386/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293386&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25386
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25388
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Leaf King Realty Ltd."
+"OfficeEmail": null
+"OfficePhone": "905-319-1896"
+"OfficeMlsId": "HBLEAFKINGRL"
+"ModificationTimestamp": "2025-07-09T18:36:53Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293386"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2220 Tiger Road"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M4X"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1426403"
+"OriginalEntryTimestamp": "2022-10-11T19:36:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1292588"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293386')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524541/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524541&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524541/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524541&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25391
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29168655" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25028
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29168655/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29168655&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29168655/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29168655&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25010
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29168655 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.879877 43.338415)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29168655 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.879877 43.338415)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29168655 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.879877 43.338415)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29168655 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.879877 43.338415)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24924
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: "545177"
+post_author: 1
+"ListingKey": "29265095"
+"ListingId": "X12708588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-19T16:25:53Z"
+"RFModificationTimestamp": "2026-01-19T20:07:38Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "74 - 22 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.87842
1 => 43.34543
]
+"Latitude": 43.34543
+"Longitude": -79.87842
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "End Unit Mattamy Build Hannon End 3+1 Br, 3 Wr - 1824 Sqft Townhouse, Very Good Size Terrace. Modern Kitchen With Breakfast Bar, Granite Counter Top, Backsplash, Stainless Steel Appliances& Additional Walk In Pantry. Nov. 2018 Laminate Throughout House, 2 Full Bathrooms In Bedroom Area Upstairs. Close To Shopping, Aldershot Go, Hwy 403 Or 407. 15 Minute Drive To McMaster University. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-19T20:07:12.649730+00:00"
+"Directions": "Dundas & Spring Creek Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967588"
+"ListOfficeKey": "74308"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "25.5 x 62.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-19T16:14:17Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-19T16:14:17Z"
+"Stories": "3.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5652"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1562250038"
"RoomType" => "Office"
"ListingId" => "X12708588"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "29265095"
"RoomLength" => 3.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
1 => array:11 [
"RoomKey" => "1562250039"
"RoomType" => "Kitchen"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 2.47
"ListingKey" => "29265095"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
2 => array:11 [
"RoomKey" => "1562250040"
"RoomType" => "Eating area"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "29265095"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
3 => array:11 [
"RoomKey" => "1562250041"
"RoomType" => "Family room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "29265095"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
4 => array:11 [
"RoomKey" => "1562250042"
"RoomType" => "Living room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
5 => array:11 [
"RoomKey" => "1562250043"
"RoomType" => "Dining room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
6 => array:11 [
"RoomKey" => "1562250044"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.84
"ListingKey" => "29265095"
"RoomLength" => 4.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
7 => array:11 [
"RoomKey" => "1562250045"
"RoomType" => "Bedroom 2"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.77
"ListingKey" => "29265095"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
8 => array:11 [
"RoomKey" => "1562250046"
"RoomType" => "Bedroom 3"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29265095/74-22-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 25.6
+"OriginalEntryTimestamp": "2026-01-19T16:14:16.99Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6410659818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/36a359313980773152ae1c1cf808182d.webp"
"MediaSize" => 61734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-36a359313980773152ae1c1cf808182d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6410659837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/a7a4d60a5a65092eedc84017792fa217.webp"
"MediaSize" => 32452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-a7a4d60a5a65092eedc84017792fa217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6410659845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/601498a42c12a23c26b803ae916a984f.webp"
"MediaSize" => 31728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-601498a42c12a23c26b803ae916a984f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6410659869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/f74a1dbe5cb77d27582b15c6657fb317.webp"
"MediaSize" => 27641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-f74a1dbe5cb77d27582b15c6657fb317.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6410659894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/b5d8ed0b82ae617e7d3e0ef25a795545.webp"
"MediaSize" => 32045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-b5d8ed0b82ae617e7d3e0ef25a795545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6410659935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/136b7e03c39fbc7d85d4c4d5c6cd624e.webp"
"MediaSize" => 33402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-136b7e03c39fbc7d85d4c4d5c6cd624e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6410659973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/1c0058964d339c7e27c9f3a9eb6d06a6.webp"
"MediaSize" => 29863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-1c0058964d339c7e27c9f3a9eb6d06a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6410660002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/5da5fb7e27f93b20407bb30ab544a3f0.webp"
"MediaSize" => 24611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-5da5fb7e27f93b20407bb30ab544a3f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6410660006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/cd2de39dd96e7816b7aab8fbf18d2d56.webp"
"MediaSize" => 25285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-cd2de39dd96e7816b7aab8fbf18d2d56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6410660047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/5801c2bbeed64d99acc8f8c7fa10b185.webp"
"MediaSize" => 30965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-5801c2bbeed64d99acc8f8c7fa10b185.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6410660081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/baa126496269d0d2f8af472799ceeae1.webp"
"MediaSize" => 28855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-baa126496269d0d2f8af472799ceeae1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6410660121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/3add034dc64ce8e3614160546da97c9f.webp"
"MediaSize" => 24995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-3add034dc64ce8e3614160546da97c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6410660147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/e402b003ff90e86668c670ace23f6eca.webp"
"MediaSize" => 21056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-e402b003ff90e86668c670ace23f6eca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6410660185"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/76c17674383fec9e610607dbf69503e2.webp"
"MediaSize" => 23889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-76c17674383fec9e610607dbf69503e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6410660247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/0f35100348a49031f715e451a04f41cd.webp"
"MediaSize" => 29041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-0f35100348a49031f715e451a04f41cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6410660281"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/d088cec68040be077f119b05bd433f36.webp"
"MediaSize" => 22911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-d088cec68040be077f119b05bd433f36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6410660332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/49fd7f8d06eeb8d162f72a829b6d1565.webp"
"MediaSize" => 27200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-49fd7f8d06eeb8d162f72a829b6d1565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6410660367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/79a531465ab9206d2afbfdbef82d85f1.webp"
"MediaSize" => 28392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-79a531465ab9206d2afbfdbef82d85f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6410660412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/43a981448f615cb5f4851fedef6aabc2.webp"
"MediaSize" => 21717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-43a981448f615cb5f4851fedef6aabc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6410660459"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/75755ec02a6d1c86ed32a21b7ee59f61.webp"
"MediaSize" => 59031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-75755ec02a6d1c86ed32a21b7ee59f61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "IHAB BASHA"
"MemberFirstName" => "IHAB"
"MemberLastName" => "BASHA"
"MemberMlsId" => "9556823"
"OriginatingSystemName" => 26
"MemberKey" => "1967588"
"ModificationTimestamp" => "2025-12-15T06:03:50Z"
"MemberStatus" => "Active"
"OfficeKey" => "74308"
"MemberAOR" => "Toronto"
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "647-700-0316"
"MemberSocialMedia" => array:3 [ …3]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2013-12-04T00:58:00Z"
"MemberNationalAssociationId" => "1255452"
"OfficeNationalAssociationId" => "1004451"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "ROYAL LEPAGE REALTY PLUS"
"OfficePhone" => "905-828-6550"
"OfficeMlsId" => "65800"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "74308"
"ModificationTimestamp" => "2025-01-12T14:00:57Z"
"OfficeAddress1" => "2575 DUNDAS STREET WEST"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5K2M"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-828-1511"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeNationalAssociationId" => "1004451"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1062073"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29265095')"
+"ID": "545177"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "543745"
+post_author: 1
+"ListingKey": "29263985"
+"ListingId": "X12707442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-18T22:51:03Z"
+"RFModificationTimestamp": "2026-01-18T23:00:12Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "503 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.896456
1 => 43.331203
]
+"Latitude": 43.331203
+"Longitude": -79.896456
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This bright and modern unit features neutral colors throughout, quartz countertops, and pot lights creating a warm and inviting atmosphere. Step out onto your private balcony to enjoy the afternoon sun. This open-concept unit features upgraded appliances and lighting throughout. The kitchen features a new ceramic backsplash and large island that offers seating and well as additional storage. Upgraded cabinetry throughout. In-suite laundry with upgraded washer and dryer is also included. Adjacent to the primary bedroom you will find a large walk-in closet and spacious 4-piece ensuite with oversized shower, upgraded counter-height vanities with quartz tops, LED mirrors and double sinks. A heated underground parking space and a storage locker are included. The building features a party room and bike room for secure storage. Enjoy the convenience of living at 5 Hamilton Condos, perfectly situated in the vibrant Waterdown core. Just steps away from your front door you'll enjoy local shops, services and restaurants including a pharmacy and grocery stores. Within walking distance, you will discover the charm of Waterdown including scenic trails, Smokey Hollow Waterfall, and Memorial Park. With shopping and services nearby and easy access to highways, this location offers both convenience and connectivity. This condo offers the perfect balance of comfort, convenience, and low maintenance living in one of Waterdown's most desirable locations. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater - Tankless"
]
+"AssociationFee": "475.88"
+"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-01-18T22:59:56.260050+00:00"
+"Directions": "Cross Streets: Dundas St E & Hamilton St N. ** Directions: 5 Hamilton St N."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "Not known"
2 => "Natural gas"
3 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059353"
+"ListOfficeKey": "283746"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-18T22:40:29Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-18T22:40:29Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3839.11"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1561929794"
"RoomType" => "Kitchen"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 2.95
"ListingKey" => "29263985"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.77Z"
]
1 => array:11 [
"RoomKey" => "1561929795"
"RoomType" => "Living room"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 4.67
"ListingKey" => "29263985"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.77Z"
]
2 => array:11 [
"RoomKey" => "1561929796"
"RoomType" => "Dining room"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 5.59
"ListingKey" => "29263985"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
3 => array:11 [
"RoomKey" => "1561929797"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 3.15
"ListingKey" => "29263985"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
4 => array:11 [
"RoomKey" => "1561929798"
"RoomType" => "Bedroom"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 2.74
"ListingKey" => "29263985"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29263985/503-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C5"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-18T22:40:29.71Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:30 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6409660358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/246c518ce8b1a87a90837c16371d9d27.webp"
"MediaSize" => 328307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-246c518ce8b1a87a90837c16371d9d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6409660361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/a947659c881349d6c2d9261f075d7e38.webp"
"MediaSize" => 314581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-a947659c881349d6c2d9261f075d7e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6409660364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/194150345f959f0177dd5084b43a174e.webp"
"MediaSize" => 152110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-194150345f959f0177dd5084b43a174e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6409660367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/c4363a3af3a5139e24dc8c19ae1cdfe6.webp"
"MediaSize" => 132067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-c4363a3af3a5139e24dc8c19ae1cdfe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6409660370"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/5c9448bab8e59cda9a8c310f4d40e051.webp"
"MediaSize" => 130042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-5c9448bab8e59cda9a8c310f4d40e051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6409660374"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/09f0a349721df9633fc26f3679880be5.webp"
"MediaSize" => 145726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-09f0a349721df9633fc26f3679880be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6409660376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/1948c0f42e0318b88f02ec46efb8d045.webp"
"MediaSize" => 130361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-1948c0f42e0318b88f02ec46efb8d045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6409660379"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/909f4e8c8c2178eb37d958cf7f8909db.webp"
"MediaSize" => 121988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-909f4e8c8c2178eb37d958cf7f8909db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6409660380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/5ed92e70cf05ca3e00bca2f631665c0a.webp"
"MediaSize" => 132189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-5ed92e70cf05ca3e00bca2f631665c0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6409660382"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/1c81e505afab7bd7d249ebad85197d19.webp"
"MediaSize" => 127452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-1c81e505afab7bd7d249ebad85197d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6409660384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/4a48da3c3e72f1ccc8a6dcb6c00fb57e.webp"
"MediaSize" => 105818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-4a48da3c3e72f1ccc8a6dcb6c00fb57e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6409660387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/adf2ccb8a9cf3b0237e652b7bc5fb30a.webp"
"MediaSize" => 153617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-adf2ccb8a9cf3b0237e652b7bc5fb30a.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29263985')"
+"ID": "543745"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24909
+post_id: "543746"
+post_author: 1
+"ListingKey": "29263951"
+"ListingId": "40798680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-18T22:30:37Z"
+"RFModificationTimestamp": "2026-01-18T22:34:17Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1025.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "5 HAMILTON Street N Unit# 503, Waterdown, Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.8964452
1 => 43.3313139
]
+"Latitude": 43.3313139
+"Longitude": -79.8964452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This bright and modern unit features neutral colors throughout, quartz countertops, and pot lights creating a warm and inviting atmosphere. Step out onto your private balcony to enjoy the afternoon sun. This open-concept unit features upgraded appliances and lighting throughout. The kitchen features a new ceramic backsplash and large island that offers seating and well as additional storage. Upgraded cabinetry throughout. In-suite laundry with upgraded washer and dryer is also included. Adjacent to the primary bedroom you will find a large walk-in closet and spacious 4-piece ensuite with oversized shower, upgraded counter-height vanities with quartz tops, LED mirrors and double sinks. A heated underground parking space and a storage locker are included. The building features a party room and bike room for secure storage. Enjoy the convenience of living at 5 Hamilton Condos, perfectly situated in the vibrant Waterdown core. Just steps away from your front door you’ll enjoy local shops, services and restaurants including a pharmacy and grocery stores. Within walking distance, you will discover the charm of Waterdown including scenic trails, Smokey Hollow Waterfall, and Memorial Park. With shopping and services nearby and easy access to highways, this location offers both convenience and connectivity. This condo offers the perfect balance of comfort, convenience, and low maintenance living in one of Waterdown’s most desirable locations. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "475.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-18T22:33:57.274340+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523819"
+"ListOfficeKey": "272222"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-18T21:38:28Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-18T22:18:35Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "HAMILTON"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3839.11"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29263951/5-hamilton-street-n-unit-503-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1523818"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "272222"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "C5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1025
+"OriginalEntryTimestamp": "2026-01-18T21:38:28.27Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29263951')"
+"ID": "543746"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "541859"
+post_author: 1
+"ListingKey": "29260381"
+"ListingId": "X12704084"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:50:56Z"
+"RFModificationTimestamp": "2026-01-16T23:42:24Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "909 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning Corner Condo with Expansive Private Rooftop Terrace, a storage locker and two parking spots! Discover a one-of-a-kind opportunity to own this beautiful corner unit with breathtaking views and a massive private terrace-your very own rooftop retreat. Whether you love to entertain, need a play space, or simply want to bask in the sun, this outdoor oasis is a rare find. Inside, the open concept living space is designed for both style and functionality. The upgraded kitchen boasts ample cabinetry, quartz countertops, and high-end finishes, perfect for cooking and hosting. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy ambiance. Step into the primary bedroom and enjoy expansive windows and a spacious walk-in closet. The second bedroom, also featuring a walk-in closet and floor-to-ceiling windows, is ideal as a guest room or home office. The sleek, upgraded bathroom includes a stunning walk-in shower with a waterfall showerhead for a spa-like experience. Located in a prime area, you'll be within walking distance of restaurants and shops, with easy access to highways and the GO Station for commuters. Residents enjoy top-tier amenities, including a state-of-the-art fitness center, an elegant party room, and a rooftop deck with a community BBQ area. Don't miss this rare opportunity to own a beautiful, modern condo with a private rooftop terrace that truly sets it apart. Schedule your viewing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "440.93"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T23:41:50.671688+00:00"
+"Directions": "Dundas St. E"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192347"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:42:05Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:42:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3297.86"
+"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/29260381/909-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Separate Heating Controls"
4 => "Party Room"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-16T19:42:05.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:31 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260381')"
+"ID": "541859"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "541750"
+post_author: 1
+"ListingKey": "29260620"
+"ListingId": "X12704262"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T20:30:57Z"
+"RFModificationTimestamp": "2026-01-16T23:28:21Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "233 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Sun-filled corner unit One Bedroom + Den condo comes with one underground parking spot, one storage locker, and features a State Of The Art Geothermal Heating and Cooling system which keeps the hydro bills low!!! Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "417.99"
+"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-01-16T23:27:52.729556+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Waterdown Road - Dundas ST E - Mallard Trail."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T20:18:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T20:18:44Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "3146.83"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29260620/233-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-16T20:18:44.1Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260620')"
+"ID": "541750"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24921
+post_id: "540495"
+post_author: 1
+"ListingKey": "29260071"
+"ListingId": "40799183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:25:17Z"
+"RFModificationTimestamp": "2026-01-16T19:30:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 233, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8795131
1 => 43.3431207
]
+"Latitude": 43.3431207
+"Longitude": -79.8795131
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sun-filled corner unit one bedroom + Den condo comes with one underground parking spot, one storage locker, and features a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low!!!\u{A0} Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T19:30:13.709623+00:00"
+"Directions": "Waterdown Rd - Dundas St E - Mallard Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:19:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:19:44Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29260071/10-mallard-trail-unit-233-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"TotalActualRent": 2375
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "UC-13"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 728
+"OriginalEntryTimestamp": "2026-01-16T18:59:53.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260071')"
+"ID": "540495"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23512
+post_id: "540288"
+post_author: 1
+"ListingKey": "29259992"
+"ListingId": "40799165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:25:17Z"
+"RFModificationTimestamp": "2026-01-16T19:28:04Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 233, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8795253
1 => 43.3431313
]
+"Latitude": 43.3431313
+"Longitude": -79.8795253
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sun-filled corner unit one bedroom + Den condo comes with one underground parking spot, one storage locker, and features a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low!!!\u{A0} Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T19:28:00.739172+00:00"
+"Directions": "Waterdown Rd - Dundas St E - Mallard Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:19:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:19:44Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3146.83"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29259992/10-mallard-trail-unit-233-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "UC-13"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 728
+"OriginalEntryTimestamp": "2026-01-16T18:49:12.13Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29259992')"
+"ID": "540288"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "537032"
+post_author: 1
+"ListingKey": "29255398"
+"ListingId": "X12699852"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T18:30:35Z"
+"RFModificationTimestamp": "2026-01-15T20:00:18Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "604 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "335.34"
+"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-01-15T20:00:05.314321+00:00"
+"Directions": "Dundas/Mallard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036737"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T18:23:32Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T18:23:32Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2592.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/604_470_dundas_st_e_hamilton_on/"
+"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/29255398/604-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-15T18:23:32.47Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29255398')"
+"ID": "537032"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24865
+post_id: "535565"
+post_author: 1
+"ListingKey": "29252282"
+"ListingId": "X12697348"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T22:50:54Z"
+"RFModificationTimestamp": "2026-01-15T01:06:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G7"
+"UnparsedAddress": "545 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0G7"
+"Coordinates": array:2 [
0 => -79.872959
1 => 43.348888
]
+"Latitude": 43.348888
+"Longitude": -79.872959
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Opportunity To Lease A Versatile 3.2-Acre Property With Commercial Zoning. Ideal For Entrepreneurs, Creatives, Or Business Owners Seeking A Live-Work Environment. This Partially Finished Residence Offers Four Spacious Bedrooms, Including A Main-Floor Primary Suite With Ensuite, Providing Both Comfort And Functionality. The Expansive Lot Provides Ample Parking And Outdoor Space, Making It Suitable For A Wide Range Of Permitted Business Uses. Whether You're Looking To Operate A Studio, Professional Office, Creative Workspace, Or Home-Based Business, Tenants Are Encouraged To Verify Zoning To Suit Their Needs. Conveniently Located Just 10 Minutes From Downtown Waterdown And Close To Major Routes And Amenities, This Property Offers The Perfect Balance Of Accessibility, Privacy, And Commercial Potential. A Unique Opportunity For Those Looking To Work And Live In One Exceptional Space. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-01-15T01:06:01.459321+00:00"
+"Directions": "Dundas St E & Evans Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1971659"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "386.5 x 351 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T22:43:43Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T22:43:43Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "545"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252282/545-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 386.6
+"OriginalEntryTimestamp": "2026-01-14T22:43:43.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252282')"
+"ID": "535565"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 162
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]