array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29603570 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: "1317294"
+post_author: 1
+"ListingKey": "29603570"
+"ListingId": "X12997474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T15:50:01Z"
+"RFModificationTimestamp": "2026-06-13T15:51:47Z"
+"ListPrice": 1080000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "166 BOULDING AVENUE, Hamilton (Waterdown), Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.8890567
1 => 43.3478228
]
+"Latitude": 43.3478228
+"Longitude": -79.8890567
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your perfect Waterdown home! Highly sought-after East Waterdown location. Filled with natural light, this carpet-free home features hardwood flooring throughout, with durable finishes right down into the basement - perfect for family living. The bright, updated white kitchen offers stainless steel appliances and plenty of workspace on the black granite counters, flowing seamlessly into the main living areas, making the main level great for everyday life as well as for entertaining groups. The main floor laundry room adds to the home's everyday functionality. Upstairs, you'll find three spacious bedrooms, including the large primary retreat that offers a walk in closet and large ensuite bathroom with separate soaker tub and shower. A Standout Feature is the expansive second floor Great Room, with its vaulted ceilings and Palladian-Style windows - an extremely versatile space that could easily function as a fourth bedroom, playroom, or additional living area. The fully finished basement is perfect for the kids to play, for entertaining, or for extended family living, with wet bar, den, play room, full bathroom and ample storage space. Located in a fantastic family neighbourhood, this home is a quick jaunt to schools, parks, and shopping, with quick highway access and easy GO Train connectivity for commuters. Plus you're only minutes from Burlington, Carlisle, and you have the perfect blend of city living while having easy proximity to country amenities. This location is the perfect blend of community and convenience. A move-in ready home with space, style and flexibility - this one has it all! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-15T02:29:31.721746+00:00"
+"Directions": "Cross Streets: Parkside to Boulding. ** Directions: From Parkside turn onto Boulding and it's on your left."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092596"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "40 x 114.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-14T19:51:07Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T15:44:06Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "166"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "7395"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019d8c68-9143-7294-8505-621c226bdde7"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1658573098"
"RoomType" => "Living room"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 4.42
"ListingKey" => "29603570"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.94Z"
]
1 => array:11 [
"RoomKey" => "1658573099"
"RoomType" => "Bedroom 3"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 3.53
"ListingKey" => "29603570"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.94Z"
]
2 => array:11 [
"RoomKey" => "1658573100"
"RoomType" => "Bathroom"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29603570"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.95Z"
]
3 => array:11 [
"RoomKey" => "1658573101"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12997474"
"RoomLevel" => "Basement"
"RoomWidth" => 579.0
"ListingKey" => "29603570"
"RoomLength" => 6.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.95Z"
]
4 => array:11 [
"RoomKey" => "1658573102"
"RoomType" => "Den"
"ListingId" => "X12997474"
"RoomLevel" => "Basement"
"RoomWidth" => 2.31
"ListingKey" => "29603570"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.95Z"
]
5 => array:11 [
"RoomKey" => "1658573103"
"RoomType" => "Bathroom"
"ListingId" => "X12997474"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29603570"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.95Z"
]
6 => array:11 [
"RoomKey" => "1658573104"
"RoomType" => "Other"
"ListingId" => "X12997474"
"RoomLevel" => "Basement"
"RoomWidth" => 2.77
"ListingKey" => "29603570"
"RoomLength" => 2.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.96Z"
]
7 => array:11 [
"RoomKey" => "1658573105"
"RoomType" => "Dining room"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29603570"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.97Z"
]
8 => array:11 [
"RoomKey" => "1658573106"
"RoomType" => "Kitchen"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29603570"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.97Z"
]
9 => array:11 [
"RoomKey" => "1658573107"
"RoomType" => "Eating area"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "29603570"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.98Z"
]
10 => array:11 [
"RoomKey" => "1658573108"
"RoomType" => "Laundry room"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29603570"
"RoomLength" => 2.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.98Z"
]
11 => array:11 [
"RoomKey" => "1658573109"
"RoomType" => "Bathroom"
"ListingId" => "X12997474"
"RoomLevel" => "Main level"
"RoomWidth" => 0.1
"ListingKey" => "29603570"
"RoomLength" => 0.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.98Z"
]
12 => array:11 [
"RoomKey" => "1658573110"
"RoomType" => "Family room"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 6.02
"ListingKey" => "29603570"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:06.99Z"
]
13 => array:11 [
"RoomKey" => "1658573111"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29603570"
"RoomLength" => 6.22
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:07Z"
]
14 => array:11 [
"RoomKey" => "1658573112"
"RoomType" => "Bathroom"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29603570"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:07.01Z"
]
15 => array:11 [
"RoomKey" => "1658573113"
"RoomType" => "Bedroom 2"
"ListingId" => "X12997474"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29603570"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-13T15:44:07.01Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29603570/166-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-04-14T19:51:06.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365158"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6597177087"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/7a65e6e91a418c7917338b599d460a58.webp"
"MediaSize" => 390410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-7a65e6e91a418c7917338b599d460a58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6597176188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/c4cef21f7dada4ffac68c3d6ebd3dd2b.webp"
"MediaSize" => 272782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-c4cef21f7dada4ffac68c3d6ebd3dd2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6597176672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/e827b0ea9fe57e102c2bc1b5eced1171.webp"
"MediaSize" => 407300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-e827b0ea9fe57e102c2bc1b5eced1171.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6597176932"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/9b821a42fd543931030e350a933d3bd3.webp"
"MediaSize" => 179904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-9b821a42fd543931030e350a933d3bd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6597176311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/f46f49a252a9c471426226e443c79fb2.webp"
"MediaSize" => 193084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-f46f49a252a9c471426226e443c79fb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6597176352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/20f107a73bf212eb0ee3fcda0c1765e1.webp"
"MediaSize" => 225727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-20f107a73bf212eb0ee3fcda0c1765e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6597176924"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/e501cb887818e2876653e5ead37784f0.webp"
"MediaSize" => 160886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-e501cb887818e2876653e5ead37784f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6597176129"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/66034e8e6667ffcaece3048bf489e7bf.webp"
"MediaSize" => 163924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-66034e8e6667ffcaece3048bf489e7bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6597176624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/828242b6c70598cd0c82cfa9b4e98ceb.webp"
"MediaSize" => 173735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-828242b6c70598cd0c82cfa9b4e98ceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6597177312"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/331eaa062676d77427ad92cd059aed35.webp"
"MediaSize" => 166272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-331eaa062676d77427ad92cd059aed35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6597177483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/0a1403c9e6a3575935af20f365943310.webp"
"MediaSize" => 215041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-0a1403c9e6a3575935af20f365943310.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6597176440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/9d81d5699bc667d3fbb4b24077449eec.webp"
"MediaSize" => 236990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-9d81d5699bc667d3fbb4b24077449eec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6597177249"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/4de230e2d47267cbfc70839d614551c7.webp"
"MediaSize" => 249085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-4de230e2d47267cbfc70839d614551c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6597177470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/96574d867247edc198d6f8987a550b14.webp"
"MediaSize" => 191760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-96574d867247edc198d6f8987a550b14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6597177071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/d314d129855d1889bd1142054b3be037.webp"
"MediaSize" => 175414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-d314d129855d1889bd1142054b3be037.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6597177404"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/b5290c1dba747bb88e097fb57677a127.webp"
"MediaSize" => 167162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-b5290c1dba747bb88e097fb57677a127.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6597177432"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/5742fb5336d86a0c385c376e1c9dc056.webp"
"MediaSize" => 171274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-5742fb5336d86a0c385c376e1c9dc056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6597175327"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/ec9fa9a9f290a8b3d81206f4cc0e3fc1.webp"
"MediaSize" => 155655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-ec9fa9a9f290a8b3d81206f4cc0e3fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged to show family room setup"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6597175944"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/a98e15fe80922f7c8a48dbd66422cc72.webp"
"MediaSize" => 147740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-a98e15fe80922f7c8a48dbd66422cc72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged to show bedroom setup"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6597175431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/8dd25237b6d903d0ac2d1d8044cb6362.webp"
"MediaSize" => 182388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-8dd25237b6d903d0ac2d1d8044cb6362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Master bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6597176847"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/b83734786b9d5cad549a04c87d089eb0.webp"
"MediaSize" => 136135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-b83734786b9d5cad549a04c87d089eb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6597177426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/b0d39c3d75bfb7f325991596fcc7ae7a.webp"
"MediaSize" => 138669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-b0d39c3d75bfb7f325991596fcc7ae7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6597176959"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/fb68743d11d765393f2c5a4a1613a73e.webp"
"MediaSize" => 143435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-fb68743d11d765393f2c5a4a1613a73e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6597175068"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/a688885deaf7be1b48391ab6064c9ea0.webp"
"MediaSize" => 104188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-a688885deaf7be1b48391ab6064c9ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor powder room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6597176014"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/9599f29dcb8c3d1eb78304ea68229ee6.webp"
"MediaSize" => 137190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-9599f29dcb8c3d1eb78304ea68229ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6597175523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/5fac137d2131701a7b00699206630ff1.webp"
"MediaSize" => 120769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-5fac137d2131701a7b00699206630ff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6597175072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/60d704967d46844193a97537965ce5b9.webp"
"MediaSize" => 120916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-60d704967d46844193a97537965ce5b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6597175218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/67a7677b8b251190c86bef4ae40e8666.webp"
"MediaSize" => 118354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-67a7677b8b251190c86bef4ae40e8666.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6597175534"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/10b2ee876ebab26bbca1fd219a82e838.webp"
"MediaSize" => 125575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-10b2ee876ebab26bbca1fd219a82e838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "basement bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6597177353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/28a258f3259e9b506f824ac26167d9e1.webp"
"MediaSize" => 114316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-28a258f3259e9b506f824ac26167d9e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6597175766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/2641209e2f2e093dc5c7d40b78490a70.webp"
"MediaSize" => 150921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-2641209e2f2e093dc5c7d40b78490a70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6597176550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/331b9c85563cd4ec67f4e2debcf045a5.webp"
"MediaSize" => 158107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-331b9c85563cd4ec67f4e2debcf045a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6597177332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/44bf7b0a352da717be436f86579cffd3.webp"
"MediaSize" => 148198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-44bf7b0a352da717be436f86579cffd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6597175670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/fc4774d8cf4cd07b2123ae4f46f83bb8.webp"
"MediaSize" => 94333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-fc4774d8cf4cd07b2123ae4f46f83bb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6597176993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/a3ccacad6cd474fee6afeeeccf49a950.webp"
"MediaSize" => 99544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-a3ccacad6cd474fee6afeeeccf49a950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6597177173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/21a3ae7d226a9f4b0548e251c8b0dd5e.webp"
"MediaSize" => 99849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-21a3ae7d226a9f4b0548e251c8b0dd5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6597175839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/89c278046f6c827f991cc883a1b6918d.webp"
"MediaSize" => 413952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-89c278046f6c827f991cc883a1b6918d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6597176810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/cb00f6079332a9a8409cc2e12ff2c41b.webp"
"MediaSize" => 387550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-cb00f6079332a9a8409cc2e12ff2c41b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6597177206"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/834d0e98857c4b948dc87727312c0e17.webp"
"MediaSize" => 414633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-834d0e98857c4b948dc87727312c0e17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6597177500"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/98b535f8c2cf1713341bb59dce5b9465.webp"
"MediaSize" => 359468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-98b535f8c2cf1713341bb59dce5b9465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6597176707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/405d67d04121ffb63778d4efc436c523.webp"
"MediaSize" => 88018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-405d67d04121ffb63778d4efc436c523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6597177124"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/a0f0099a264c884a8ebfbd556b0595d3.webp"
"MediaSize" => 89461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-a0f0099a264c884a8ebfbd556b0595d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "6597177520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/f354362b502cc5be99d1e8e127040bc0.webp"
"MediaSize" => 80247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-f354362b502cc5be99d1e8e127040bc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "6597177034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603570/810f12cfb830579c17cb80ad34544222.webp"
"MediaSize" => 102187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603570/thumbnail-810f12cfb830579c17cb80ad34544222.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997474"
"ResourceRecordKey" => "29603570"
"ModificationTimestamp" => "2026-04-14T19:51:06.67Z"
]
]
+"DaysOnMarket": 62
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29603570')"
+"ID": "1317294"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288936" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2092596" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24787
+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 '29603570'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25132
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29603570'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25150
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31443785"
+"ListingKey": "29603570"
+"ListingId": "X12997474"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T16:00:00Z"
+"OpenHouseEndTime": "2026-06-13T17:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T12:11:31Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31443785')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29603570' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8890567 43.3478228)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25223
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: 1534978
+post_author: 1
+"ListingKey": "29910671"
+"ListingId": "X13451454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:35:22Z"
+"RFModificationTimestamp": "2026-06-16T17:56:35Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0K2H6"
+"UnparsedAddress": "100 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L0K2H6"
+"Coordinates": array:2 [
0 => -79.900192
1 => 43.331966
]
+"Latitude": 43.331966
+"Longitude": -79.900192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Tucked into an established, tree-lined pocket with rare walkability, 100 Chudleigh Street is a mature-lot Waterdown home with the main floor opened up and reimagined for how families actually live now. This beautifully updated 4-bedroom, 2.5-bath home blends the open, connected layout buyers love in newer builds with the privacy, greenery, and lot size of an established neighbourhood. The main floor feels bright, warm, and easy, with designer touches throughout, a cozy fireplace, new luxury vinyl flooring, and a large kitchen featuring quartz counters, quartz backsplash, refreshed cabinetry, and generous space to gather. Carpet-free living continues throughout, with four comfortable bedrooms upstairs and a finished lower level that creates a huge suite-style retreat for teens, guests, long-staying in-laws, movie nights, or play space - with room for the wine collection tucked in too. Outside, the backyard is lush and surprisingly private, surrounded by mature greenery with no rear residential neighbours. Steps to everyday amenities, schools, trails, the YMCA, library, restaurants, shopping, Dairy Queen, and the summer farmers market - this is Waterdown family living with space, style, privacy, and true walkability. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:56:25.167411+00:00"
+"Directions": "Cross Streets: Hamilton & Dundas. ** Directions: Hamilton, Weston on White Oak Dr., Left on Chudleigh."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038275"
+"ListOfficeKey": "280499"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "50 x 125 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-16T17:26:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:26:57Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "100"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6718"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1660606398"
"RoomType" => "Kitchen"
"ListingId" => "X13451454"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29910671"
"RoomLength" => 5.22
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
1 => array:11 [
"RoomKey" => "1660606399"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13451454"
"RoomLevel" => "Basement"
"RoomWidth" => 6.29
"ListingKey" => "29910671"
"RoomLength" => 8.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
2 => array:11 [
"RoomKey" => "1660606400"
"RoomType" => "Bedroom 5"
"ListingId" => "X13451454"
"RoomLevel" => "Basement"
"RoomWidth" => 3.23
"ListingKey" => "29910671"
"RoomLength" => 7.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
3 => array:11 [
"RoomKey" => "1660606401"
"RoomType" => "Cold room"
"ListingId" => "X13451454"
"RoomLevel" => "Basement"
"RoomWidth" => 1.6
"ListingKey" => "29910671"
"RoomLength" => 1.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
4 => array:11 [
"RoomKey" => "1660606402"
"RoomType" => "Great room"
"ListingId" => "X13451454"
"RoomLevel" => "Main level"
"RoomWidth" => 5.82
"ListingKey" => "29910671"
"RoomLength" => 5.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
5 => array:11 [
"RoomKey" => "1660606403"
"RoomType" => "Dining room"
"ListingId" => "X13451454"
"RoomLevel" => "Main level"
"RoomWidth" => 3.11
"ListingKey" => "29910671"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.06Z"
]
6 => array:11 [
"RoomKey" => "1660606404"
"RoomType" => "Laundry room"
"ListingId" => "X13451454"
"RoomLevel" => "Main level"
"RoomWidth" => 1.85
"ListingKey" => "29910671"
"RoomLength" => 2.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
7 => array:11 [
"RoomKey" => "1660606405"
"RoomType" => "Partial bathroom"
"ListingId" => "X13451454"
"RoomLevel" => "Main level"
"RoomWidth" => 1.38
"ListingKey" => "29910671"
"RoomLength" => 1.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
8 => array:11 [
"RoomKey" => "1660606406"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13451454"
"RoomLevel" => "Second level"
"RoomWidth" => 3.25
"ListingKey" => "29910671"
"RoomLength" => 4.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
9 => array:11 [
"RoomKey" => "1660606407"
"RoomType" => "Bathroom"
"ListingId" => "X13451454"
"RoomLevel" => "Second level"
"RoomWidth" => 1.61
"ListingKey" => "29910671"
"RoomLength" => 2.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
10 => array:11 [
"RoomKey" => "1660606408"
"RoomType" => "Bedroom 2"
"ListingId" => "X13451454"
"RoomLevel" => "Second level"
"RoomWidth" => 3.03
"ListingKey" => "29910671"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
11 => array:11 [
"RoomKey" => "1660606409"
"RoomType" => "Bedroom 3"
"ListingId" => "X13451454"
"RoomLevel" => "Second level"
"RoomWidth" => 3.03
"ListingKey" => "29910671"
"RoomLength" => 3.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
12 => array:11 [
"RoomKey" => "1660606410"
"RoomType" => "Bedroom 4"
"ListingId" => "X13451454"
"RoomLevel" => "Second level"
"RoomWidth" => 2.8
"ListingKey" => "29910671"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:26:57.07Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29910671/100-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-16T17:26:56.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314465"
+"ListOfficeNationalAssociationId": "1314683"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29910671_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29910671/64852db9f3bd8302226f58dd43f1b580.webp"
"MediaSize" => 490123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29910671/thumbnail-64852db9f3bd8302226f58dd43f1b580.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13451454"
"ResourceRecordKey" => "29910671"
"ModificationTimestamp" => "2026-06-16T17:26:56.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29910671_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29910671/50291f3c1f165cdf3393dff2cfdbac02.webp"
"MediaSize" => 308580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29910671/thumbnail-50291f3c1f165cdf3393dff2cfdbac02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13451454"
"ResourceRecordKey" => "29910671"
"ModificationTimestamp" => "2026-06-16T17:26:56.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29910671_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29910671/59f4fbe641643ac98b3e6588689d3721.webp"
"MediaSize" => 387808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29910671/thumbnail-59f4fbe641643ac98b3e6588689d3721.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13451454"
"ResourceRecordKey" => "29910671"
"ModificationTimestamp" => "2026-06-16T17:26:56.96Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29910671_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29910671/f1d6ce5117f8d8f3dd42b8a86c95a71c.webp"
"MediaSize" => 345132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29910671/thumbnail-f1d6ce5117f8d8f3dd42b8a86c95a71c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13451454"
"ResourceRecordKey" => "29910671"
"ModificationTimestamp" => "2026-06-16T17:26:56.96Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29910671_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29910671/405d6cee816a6e4dd1f0a10dd244e234.webp"
"MediaSize" => 186656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29910671/thumbnail-405d6cee816a6e4dd1f0a10dd244e234.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13451454"
…2
]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910671')"
+"ID": 1534978
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1534315"
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"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/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": "1534315"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25196
+post_id: "1534027"
+post_author: 1
+"ListingKey": "29908612"
+"ListingId": "40840175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:11:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street Unit# 709, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792813
1 => 43.3435237
]
+"Latitude": 43.3435237
+"Longitude": -79.8792813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to elevated condo living in the heart of East Waterdown! This beautifully upgraded 1-bedroom + oversized den condo offers modern style, functional space, and thoughtful design throughout. Currently used as an additional sleeping area, the spacious den offers exceptional flexibility and could easily function as a guest room, home office, nursery, fitness space, or multi-purpose retreat to suit your lifestyle. The open-concept layout is ideal for both everyday living and entertaining, highlighted by a stunning upgraded kitchen featuring a sleek granite waterfall peninsula, extended cabinetry for added storage, upgraded stainless steel appliances, and a contemporary single-basin sink. Premium upgraded flooring flows seamlessly throughout, complemented by smooth ceilings that create a clean, refined finish. Adding to the value and convenience, geothermal heating is included in the condo fees, offering efficient year-round comfort and reduced monthly utility costs. This well-appointed building also offers exceptional amenities including a stylish party room complete with a pool table, fireplace, comfortable seating area, and full kitchen, along with an exercise room, bicycle storage room, storage locker, underground parking space, and an outdoor terrace featuring seating areas and BBQs—perfect for entertaining and enjoying the community atmosphere. Ideally located in desirable East Waterdown, enjoy quick access to major highways while being close to parks, shopping, dining, and the natural beauty of the nearby Niagara Escarpment and surrounding trails—offering the perfect blend of urban convenience and outdoor living. Move in and enjoy stylish, low-maintenance living in one of Waterdown’s most sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:29.675759+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021739"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:17Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3007.36"
+"VirtualTourURLUnbranded": "https://youtu.be/U-fSD3T-vSs"
+"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/29908612/460-e-dundas-street-unit-709-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-16T12:50:17.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1301652"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908612')"
+"ID": "1534027"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:15:22Z"
+"ListPrice": 454900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:51:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1525931"
+post_author: 1
+"ListingKey": "29898285"
+"ListingId": "X13439700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:40:08Z"
+"RFModificationTimestamp": "2026-06-12T23:51:00Z"
+"ListPrice": 2395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "345 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.870648
1 => 43.339359
]
+"Latitude": 43.339359
+"Longitude": -79.870648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 3-acres (per MPAC) this property overlooks the breathtaking natural landscape of Smokey Hollow and backs directly onto the iconic Bruce Trail. This remarkable gated estate offers a rare opportunity to acquire one of the area's most picturesque and private estates. A graceful, swooping driveway leads through expansive, awe-inspiring grounds, creating a dramatic sense of arrival while remaining discreet and private from the road. The 2.5-storey residence offers 7 bedrooms and 5 bathrooms, along with a library with a fireplace. The home in its current state needs to be renovated. Outdoor features include an inground swimming pool and a detached double-car garage, all set within the property's remarkable estate setting. For those with a vision for transformation, a new house rendering design by SMPL Design Studio offers inspiration for a spectacular modern residence. Ideally located just minutes from downtown Waterdown, Burlington, and the convenient Aldershot GO Station, providing easy access to amenities and commuting options. Property and all structures are being sold in AS-IS condition. Floor plans and a survey are available. Either renovate the existing house or build a new one. Exterior photos are current and from a few years ago. Interior photos and new home renderings are for creative / illustrative purposes only. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-12T23:50:55.953773+00:00"
+"Directions": "Cross Streets: Waterdown Rd / Mountain Brow Rd. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529018"
+"ListOfficeKey": "291562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.8 x 579.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:31:41Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:31:41Z"
+"Stories": "2.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "17408"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898285/345-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1743890"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 7
+"FrontageLengthNumeric": 151.9
+"OriginalEntryTimestamp": "2026-06-12T21:31:41.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140630"
+"ListOfficeNationalAssociationId": "1400240"
+"CoListAgentNationalAssociationId": "1292982"
+"CoListOfficeNationalAssociationId": "1400240"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898285')"
+"ID": "1525931"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1522007"
+post_author: 1
+"ListingKey": "29891787"
+"ListingId": "40839144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:40:07Z"
+"RFModificationTimestamp": "2026-06-16T14:43:38Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 33, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9069775
1 => 43.3380781
]
+"Latitude": 43.3380781
+"Longitude": -79.9069775
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and stylish townhome featuring low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral décor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:27:27.209917+00:00"
+"Directions": "Hamilton St N to Nisbet Blvd, right into complex"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933651"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:39:39Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:31:48Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4900"
+"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/29891787/54-nisbet-boulevard-unit-33-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1408
+"OriginalEntryTimestamp": "2026-06-11T20:39:39.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1233597"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891787')"
+"ID": "1522007"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1522008"
+post_author: 1
+"ListingKey": "29892469"
+"ListingId": "X13434412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:25:12Z"
+"RFModificationTimestamp": "2026-06-12T14:28:02Z"
+"ListPrice": 519998.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom units available. Located on the 6th floor, this unit offers spacious, modern living with 1 bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the Great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 makingfor an easier commute. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "551.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:02:54.162610+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:56Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:19:15Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3700"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892469/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-11T21:53:56.23Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25221
+post_id: "1522009"
+post_author: 1
+"ListingKey": "29892584"
+"ListingId": "X13434636"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:05:08Z"
+"RFModificationTimestamp": "2026-06-16T16:10:29Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "33 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and stylish townhome offering low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral decor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T22:54:28.009574+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: Hamilton St N to Nisbet Blvd, right into complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2222832"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "24.2 x 53.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T22:19:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:37Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://visithome.ai/XDtEMoVHECyeZNFcEfNpdF?mu=ft"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892584/33-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.2
+"OriginalEntryTimestamp": "2026-06-11T22:19:47.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466475"
+"ListOfficeNationalAssociationId": "1274323"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892584')"
+"ID": "1522009"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1521037"
+post_author: 1
+"ListingKey": "29891435"
+"ListingId": "X13433494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:06Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "4 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.9062491
1 => 43.3361384
]
+"Latitude": 43.3361384
+"Longitude": -79.9062491
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained freehold townhouse in sought-after Waterdown offering approximately 1470 sq. ft. of above ground finished living space. This 3-bedroom, 4-bathroom home features a bright open-concept layout with 9-ft ceilings on the main floor, a finished basement, and numerous quality upgrades throughout. Major updates include new basement/staircase carpeting (2021); kitchen countertops, backsplash, sinks, faucets, microwave, bathroom countertops, sinks and faucets, primary ensuite glass shower door, pot lights throughout the main and second floors, basement light fixtures, automated garage door opener, and humidifier (2022); new furnace, water softener, drinking water filtration system, and smart door lock (2023); plus a smart thermostat and Google video doorbell (2020).The functional layout offers spacious principal rooms, a modernized kitchen with ample cabinetry and workspace, and a finished lower level ideal for recreation, work-from-home space, or extended family living. Attached garage and private driveway parking add everyday convenience. Ideally located close to schools, the YMCA, Park, playgrounds, public transit, and a full-service shopping plaza featuring Fortinos, Tim Hortons, McDonald's, restaurants, daycare services, family medical and dental offices, convenience stores, and more. Move-in ready and thoughtfully updated, this home offers exceptional comfort, convenience, and value in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Humidifier"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:54.750046+00:00"
+"Directions": "Parkside Dr/Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072378"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 100.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:52Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:52Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://homes.motionstudio.ca/listings/DsjdOGEOX8hCTJ3iwqUy/website/basic/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891435/4-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2190178"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2130691"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "282777"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:52.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347560"
+"ListOfficeNationalAssociationId": "1321336"
+"CoListAgentNationalAssociationId": "1439294"
+"CoListAgentNationalAssociationId2": "1383597"
+"CoListOfficeNationalAssociationId": "1470118"
+"CoListOfficeNationalAssociationId2": "1321336"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 179
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]