array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29979743 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1586195"
+post_author: 1
+"ListingKey": "29979743"
+"ListingId": "40844661"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:45:15Z"
+"RFModificationTimestamp": "2026-07-02T19:49:46Z"
+"ListPrice": 674900.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.907499
1 => 43.3386765
]
+"Latitude": 43.3386765
+"Longitude": -79.907499
+"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 modern 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 4 piece 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. Low monthly maintenance fee! 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"
]
+"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-07-02T19:49:35.253127+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-07-02T19:32:26Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:32:26Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/videos/019f211a-dac1-71e1-b095-2d22e9a68bf6?v=298"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1673540068"
"RoomType" => "Recreation room"
"ListingId" => "40844661"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "30'8'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
1 => array:11 [
"RoomKey" => "1673540069"
"RoomType" => "Laundry room"
"ListingId" => "40844661"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
2 => array:11 [
"RoomKey" => "1673540070"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844661"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
3 => array:11 [
"RoomKey" => "1673540071"
"RoomType" => "Bedroom"
"ListingId" => "40844661"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
4 => array:11 [
"RoomKey" => "1673540072"
"RoomType" => "Full bathroom"
"ListingId" => "40844661"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
5 => array:11 [
"RoomKey" => "1673540073"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844661"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "21'9'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
6 => array:11 [
"RoomKey" => "1673540074"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844661"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
7 => array:11 [
"RoomKey" => "1673540075"
"RoomType" => "Living room"
"ListingId" => "40844661"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
8 => array:11 [
"RoomKey" => "1673540076"
"RoomType" => "Dining room"
"ListingId" => "40844661"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.58Z"
]
9 => array:11 [
"RoomKey" => "1673540077"
"RoomType" => "Kitchen"
"ListingId" => "40844661"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.59Z"
]
10 => array:11 [
"RoomKey" => "1673540078"
"RoomType" => "Foyer"
"ListingId" => "40844661"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29979743"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T19:32:26.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29979743/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-07-02T17:51:18.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1233597"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29979743_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/c90b721af98a4650006fd02ced5736c3.webp"
"MediaSize" => 133747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-c90b721af98a4650006fd02ced5736c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence with stone accenting and dark gray shutters"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:42.35Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29979743_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/fccb1dcf2b32e23b14bec96c0f5e90c6.webp"
"MediaSize" => 130163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-fccb1dcf2b32e23b14bec96c0f5e90c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29979743_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/96f03447186ca4bfffb366fec1ae9305.webp"
"MediaSize" => 123767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-96f03447186ca4bfffb366fec1ae9305.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade with stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29979743_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/2624120439ea561776ae22722af11d5a.webp"
"MediaSize" => 64331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-2624120439ea561776ae22722af11d5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29979743_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/42b61bf5db4148123463e383cf945a25.webp"
"MediaSize" => 54214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-42b61bf5db4148123463e383cf945a25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29979743_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/52e0d278579f88d53c25d919f77e40fe.webp"
"MediaSize" => 68207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-52e0d278579f88d53c25d919f77e40fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen island with integrated sink, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:42.54Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29979743_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/87ad343fe3e08ea8e854471d23ed5599.webp"
"MediaSize" => 81460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-87ad343fe3e08ea8e854471d23ed5599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring rich wood-finish flooring, a large window with horizontal blinds, and light-toned wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29979743_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/6408d48c3bb4b2ca70fb02610475b420.webp"
"MediaSize" => 83614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-6408d48c3bb4b2ca70fb02610475b420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a tiled kitchen area with a central island, and a visible staircase with wood railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.13Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29979743_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/24596cf74a489053f6d2c8ed7be68d86.webp"
"MediaSize" => 70869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-24596cf74a489053f6d2c8ed7be68d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with dark wood-finish flooring, light blue walls, and a large window featuring horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29979743_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/b96448f16af2e1c4cafd6202cbf9be6a.webp"
"MediaSize" => 75651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-b96448f16af2e1c4cafd6202cbf9be6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen features a central island with a stone countertop and seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29979743_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/adc855caf1624c751d3c27ad3aa8e63b.webp"
"MediaSize" => 83937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-adc855caf1624c751d3c27ad3aa8e63b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, stainless steel appliances, a tile backsplash, and granite countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29979743_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/8371bae3f1a69dcdd0e363cd903ce0f0.webp"
"MediaSize" => 74183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-8371bae3f1a69dcdd0e363cd903ce0f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood cabinetry, stainless steel appliances, a tiled backsplash, and a granite island with breakfast bar seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29979743_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/38c3741dfe67f43590df7231d0e899dc.webp"
"MediaSize" => 65733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-38c3741dfe67f43590df7231d0e899dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring light-toned tile flooring, light-toned wall paint, and a large window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29979743_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/35b6aef5b19711c48e6f5419d48cd7cb.webp"
"MediaSize" => 72810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-35b6aef5b19711c48e6f5419d48cd7cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29979743_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/9d6498dbdde1f5f49f839fe5afbcc1d0.webp"
"MediaSize" => 51767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-9d6498dbdde1f5f49f839fe5afbcc1d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29979743_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/8ac5c10364abccea2825c927b8cf2b9f.webp"
"MediaSize" => 53720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-8ac5c10364abccea2825c927b8cf2b9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a pedestal sink with chrome faucet, a contemporary round mirror, and dark-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29979743_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/ddd1d7424fe67bf81477c402d6cbe905.webp"
"MediaSize" => 53838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-ddd1d7424fe67bf81477c402d6cbe905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted hallway featuring light gray walls, white baseboards, and white two-panel interior doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29979743_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/1cb5fed2d679bcbb885ad4da90f4f8c5.webp"
"MediaSize" => 53477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-1cb5fed2d679bcbb885ad4da90f4f8c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring stacked front-load machines, a utility sink, and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:42.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29979743_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/ad7c367d5e43318b889788231ccfac2d.webp"
"MediaSize" => 90036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-ad7c367d5e43318b889788231ccfac2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.84Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29979743_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/843054be72d72b46aa59453987ec267a.webp"
"MediaSize" => 37546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-843054be72d72b46aa59453987ec267a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.27Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29979743_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/fdf16f8129a09018a17a99a799be9e24.webp"
"MediaSize" => 57119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-fdf16f8129a09018a17a99a799be9e24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright bedroom featuring a ceiling fan, light-toned walls, and a built-in white storage unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:42.47Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29979743_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/10779327821eb27db0d3075d210275cc.webp"
"MediaSize" => 43968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-10779327821eb27db0d3075d210275cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.83Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29979743_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/5796e5edd850bfa79a3be1bee40e7476.webp"
"MediaSize" => 66685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-5796e5edd850bfa79a3be1bee40e7476.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bedroom featuring light grey wall paint and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.84Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29979743_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/b0c952c8faf25e4ea97e0c2950f9ddc0.webp"
"MediaSize" => 28690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-b0c952c8faf25e4ea97e0c2950f9ddc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned wall with framed abstract art"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.15Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29979743_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/8094b494761295ff785089a0f10091d5.webp"
"MediaSize" => 65690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-8094b494761295ff785089a0f10091d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light-colored carpet flooring and a neutral color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29979743_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/486687c0b5e8f59435a29222eb20f9ea.webp"
"MediaSize" => 37266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-486687c0b5e8f59435a29222eb20f9ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway with neutral carpet, white baseboards, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.6Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29979743_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/da4e57b5573e3dc7eab3e430fa10a793.webp"
"MediaSize" => 55530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-da4e57b5573e3dc7eab3e430fa10a793.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white oval undermount sink, a chrome faucet, and a light-toned speckled countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.52Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29979743_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/82a9b0f49373535f01a827aee4a1b7cc.webp"
"MediaSize" => 45676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-82a9b0f49373535f01a827aee4a1b7cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dual vanity with undermount sinks, speckled countertop, and dark wood-finish cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.82Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29979743_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/69ab865e23d49d35b878fced275c55d7.webp"
"MediaSize" => 42224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-69ab865e23d49d35b878fced275c55d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dual vanity with dark wood-finish cabinetry, light-toned countertop, and two oval framed mirrors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29979743_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/da7a234476c5c954948e5a51639d1afc.webp"
"MediaSize" => 70222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-da7a234476c5c954948e5a51639d1afc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a bright accent wall, a multi-pane window with white trim, and light-colored carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29979743_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/9d07f42b7e775dc7475e21b5e8a50258.webp"
"MediaSize" => 64824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-9d07f42b7e775dc7475e21b5e8a50258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a large multi-pane window, a built-in desk, a white modular shelving unit, and a blue accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.83Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29979743_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/a723dad9eee416ac5358e652f374b5a4.webp"
"MediaSize" => 64786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-a723dad9eee416ac5358e652f374b5a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a bold blue accent wall and plush carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.09Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29979743_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/5fa6d7adc428f62ebce94ce412a981c8.webp"
"MediaSize" => 78067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-5fa6d7adc428f62ebce94ce412a981c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a gold-framed mirror, a single vanity with an integrated sink and laminate countertop, wood-finish cabinetry, and a shower-tub combination with tiled walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29979743_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/c8da4659700473bc060553f024e863ad.webp"
"MediaSize" => 108076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-c8da4659700473bc060553f024e863ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor balcony featuring wood-finish decking, white privacy fencing, and white railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:41.69Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29979743_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/0f29c8468db0773f40117ef82dc73f44.webp"
"MediaSize" => 124699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-0f29c8468db0773f40117ef82dc73f44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor balcony featuring wood decking, brick exterior, and a glass-paned door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29979743_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/08722086c55bcc77ac8f7c0d430ead5b.webp"
"MediaSize" => 117332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-08722086c55bcc77ac8f7c0d430ead5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.82Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29979743_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/b14bd49689c3238580c85981809251ba.webp"
"MediaSize" => 50952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-b14bd49689c3238580c85981809251ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.83Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29979743_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/d018e967caed851199fd3189e0b837f3.webp"
"MediaSize" => 145249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-d018e967caed851199fd3189e0b837f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhouse community with brick and siding exteriors, offering multi-car garages and private balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29979743_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/d2404d4039e48aa01fb2fe8e962d6e3f.webp"
"MediaSize" => 148751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-d2404d4039e48aa01fb2fe8e962d6e3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a row of townhomes with brick and siding exteriors, dark shingle roofs, and white balcony railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:45.2Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29979743_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979743/87fd7f56b913605e2912497db9cd8bf7.webp"
"MediaSize" => 138335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979743/thumbnail-87fd7f56b913605e2912497db9cd8bf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential community with varied architectural styles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844661"
"ResourceRecordKey" => "29979743"
"ModificationTimestamp" => "2026-07-02T19:31:44.82Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979743')"
+"ID": "1586195"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283666" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24904
+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 1933651" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+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 '29979743'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29979743'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29979743' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.907499 43.3386765)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25348
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1590269"
+post_author: 1
+"ListingKey": "29986990"
+"ListingId": "40845073"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:10:10Z"
+"RFModificationTimestamp": "2026-07-03T20:18:57Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "8 NORTHLAWN Avenue, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.906227
1 => 43.340693
]
+"Latitude": 43.340693
+"Longitude": -79.906227
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare Opportunity to Build Your Dream Home in One of East Waterdown's Most Established Neighbourhoods! This newly created 50' x 160' premium building lot is one of three parcels recently severed from an original estate property, offering the perfect canvas for a custom home tailored to your lifestyle. Two additional lots (both 80' x 103') are also available and offered for sale separately, presenting a unique opportunity for families, friends or investors looking to build side by side. Nestled on a quiet, tree-lined street just steps to parks, top-rated schools, shopping, restaurants, trails and everyday conveniences, you'll enjoy the charm and character of a mature neighbourhood with the freedom to build new. The generous 80-foot frontage offers exceptional flexibility for a stunning custom residence with spacious outdoor living or expansive landscaping. Bring your own builder and create the home you've always envisioned in one of Waterdown's most sought-after, family-friendly communities with convenient access to Burlington, minutes to Aldershot GO Transit and major highways. Rarely do opportunities like this become available! Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-03T20:18:52.740301+00:00"
+"Directions": "Centre Road to Northlawn Avenue"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "289630"
+"PhotosChangeTimestamp": "2026-07-03T19:58:58Z"
+"PhotosCount": 8
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:58:58Z"
+"StreetName": "NORTHLAWN"
+"StreetNumber": "8"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986990/8-northlawn-avenue-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-14"
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-03T19:58:58.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1250393"
+"ListOfficeNationalAssociationId": "1379683"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986990_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/fb05f4ffa42e16acb898fb0b5a7e51e3.webp"
"MediaSize" => 193512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-fb05f4ffa42e16acb898fb0b5a7e51e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "There are 3 lots available side by side creating a unique opportunity for families, friends or investors looking to build side by side. Lot lines are not to scale."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986990_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/bb76c0cf2d4b7499c847eed437ca17ea.webp"
"MediaSize" => 189669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-bb76c0cf2d4b7499c847eed437ca17ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Build your Dream Home in one of Easter Waterdown's most established neighbourhoods. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986990_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/81ee3b20d7ee0d00f478ca82e62125bf.webp"
"MediaSize" => 187148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-81ee3b20d7ee0d00f478ca82e62125bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "8 Northlawn Avenue - severed new lot 50'w x 160'd. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986990_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/7fa2f2f8624ba5ab2f266f79db7b0414.webp"
"MediaSize" => 186331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-7fa2f2f8624ba5ab2f266f79db7b0414.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fantastic location close to shops, schools & amenities. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986990_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/7ee772da14c884e1a8a949887d4ba9c2.webp"
"MediaSize" => 198921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-7ee772da14c884e1a8a949887d4ba9c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lot lies are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986990_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/b6f31ab5a682ee6a837bd3c2c10e566e.webp"
"MediaSize" => 209431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-b6f31ab5a682ee6a837bd3c2c10e566e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lot lines are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986990_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/d18037c3ff34f3a09b71997f1bf3d419.webp"
"MediaSize" => 208318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-d18037c3ff34f3a09b71997f1bf3d419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986990_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/09ff1dbd454e8547b4a50e496aed29eb.webp"
"MediaSize" => 189669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-09ff1dbd454e8547b4a50e496aed29eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bring your own Builder and create the home you've always envisioned in one of Waterdown's most sought after, family friendly communities. Lot lines are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986990')"
+"ID": "1590269"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1589791"
+post_author: 1
+"ListingKey": "29985393"
+"ListingId": "40844589"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:10:10Z"
+"RFModificationTimestamp": "2026-07-03T18:59:55Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1499.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "219 DUNDAS Street E Unit# 29, Waterdown, Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.9001162
1 => 43.3280419
]
+"Latitude": 43.3280419
+"Longitude": -79.9001162
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5 wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you’ll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:59:19.033948+00:00"
+"Directions": "Enter on North side Of Dundas."
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988755"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:48:27Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:00:07Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5065.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1674286335"
"RoomType" => "Laundry room"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
1 => array:11 [
"RoomKey" => "1674286336"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
2 => array:11 [
"RoomKey" => "1674286337"
"RoomType" => "Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
3 => array:11 [
"RoomKey" => "1674286338"
"RoomType" => "Full bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
4 => array:11 [
"RoomKey" => "1674286339"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
5 => array:11 [
"RoomKey" => "1674286340"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
6 => array:11 [
"RoomKey" => "1674286341"
"RoomType" => "Kitchen"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
7 => array:11 [
"RoomKey" => "1674286342"
"RoomType" => "Dining room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
8 => array:11 [
"RoomKey" => "1674286343"
"RoomType" => "Living room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
9 => array:11 [
"RoomKey" => "1674286344"
"RoomType" => "Foyer"
"ListingId" => "40844589"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985393/219-dundas-street-e-unit-29-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1562390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55164"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "HC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1499
+"OriginalEntryTimestamp": "2026-07-03T16:48:27.09Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1272793"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1148234"
+"CoListOfficeNationalAssociationId": "1003546"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29985393_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/054bc8973faece78defe1f7e0ff63a11.webp"
"MediaSize" => 128775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-054bc8973faece78defe1f7e0ff63a11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29985393_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/3fdc437a85d9b9e59e690772a56d9855.webp"
"MediaSize" => 77326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-3fdc437a85d9b9e59e690772a56d9855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29985393_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"MediaSize" => 132036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29985393_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f8afda4081f28fbeab7bc5c6fc350867.webp"
"MediaSize" => 151903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-f8afda4081f28fbeab7bc5c6fc350867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29985393_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/53f914f77d326497dfd69fbb725e69d2.webp"
"MediaSize" => 113187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-53f914f77d326497dfd69fbb725e69d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29985393_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f6194f0bd97e7da1ac9604e5e57390a0.webp"
"MediaSize" => 41833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-f6194f0bd97e7da1ac9604e5e57390a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29985393_4890_7"
…11
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985393')"
+"ID": "1589791"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1589421"
+post_author: 1
+"ListingKey": "29985763"
+"ListingId": "X13519154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:50:04Z"
+"RFModificationTimestamp": "2026-07-03T19:53:15Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7H8"
+"UnparsedAddress": "29 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7H8"
+"Coordinates": array:2 [
0 => -79.90059
1 => 43.327623
]
+"Latitude": 43.327623
+"Longitude": -79.90059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5" wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you'll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:11:05.119669+00:00"
+"Directions": "Cross Streets: Dundas & Sunnycroft. ** Directions: Entry to complex on North side of Dundas."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031562"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:40:21Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5065.04"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985763/29-219-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Guild Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.41Z"
+"ListAgentNationalAssociationId": "1309006"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985763')"
+"ID": "1589421"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1589422"
+post_author: 1
+"ListingKey": "29985762"
+"ListingId": "X13519138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:55:19Z"
+"RFModificationTimestamp": "2026-07-03T18:10:49Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN LANE, Hamilton (Waterdown), Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904144
1 => 43.333008
]
+"Latitude": 43.333008
+"Longitude": -79.904144
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard-ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:10:41.052691+00:00"
+"Directions": "Cross Streets: Segwun Rd. ** Directions: Hamilton St N to Rockhaven Lane."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089558"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Sump Pump"
]
+"LotSizeDimensions": "31.2 x 127.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:41:39Z"
+"Stories": "2.0"
+"StreetName": "Rockhaven"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985762/84-rockhaven-lane-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 31.2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1362909"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985762')"
+"ID": "1589422"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1589372"
+post_author: 1
+"ListingKey": "29984029"
+"ListingId": "40843518"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T14:25:13Z"
+"RFModificationTimestamp": "2026-07-03T17:46:27Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1932.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN Lane, Waterdown, Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904394
1 => 43.3326997
]
+"Latitude": 43.3326997
+"Longitude": -79.904394
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard—ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:46:17.621941+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524975"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:30Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T14:18:30Z"
+"Stories": "2.0"
+"StreetName": "ROCKHAVEN"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984029/84-rockhaven-lane-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975579"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2172717"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1589
+"BelowGradeFinishedArea": 343
+"OriginalEntryTimestamp": "2026-07-03T14:18:30.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1063275"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1262231"
+"CoListAgentNationalAssociationId2": "1423204"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984029')"
+"ID": "1589372"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1586194"
+post_author: 1
+"ListingKey": "29981424"
+"ListingId": "X13515302"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:25:08Z"
+"RFModificationTimestamp": "2026-07-02T21:44:30Z"
+"ListPrice": 674900.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.907686
1 => 43.338233
]
+"Latitude": 43.338233
+"Longitude": -79.907686
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and stylish townhome featuring low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral decor and thoughtful design throughout. Sleek modern 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 4 piece 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. Low monthly maintenance fee! 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-07-02T21:44:20.993686+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-07-02T20:56:13Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:16:18Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/videos/019f211a-dac1-71e1-b095-2d22e9a68bf6?v=298"
+"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/29981424/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-07-02T20:56:12.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466475"
+"ListOfficeNationalAssociationId": "1274323"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981424')"
+"ID": "1586194"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1574964"
+post_author: 1
+"ListingKey": "29964832"
+"ListingId": "40843093"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:10:11Z"
+"RFModificationTimestamp": "2026-06-29T14:12:46Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.322
+"LivingArea": 951.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 E DUNDAS Street E Unit# 315, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8960168
1 => 43.3299381
]
+"Latitude": 43.3299381
+"Longitude": -79.8960168
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Absolutely meticulously maintained 1+1 condo located in the heart of Waterdown. This spotless unit features 10 foot ceilings, crown molding, transom window, patio sliding doors to private balcony, ceiling fans, in-suite laundry room, and breakfast bar. This wonderful unit is bright and airy with a stunning open concept layout. Double French doors lead to a spacious office or second bedroom if required. Furnace and C/Air replaced 2022. The apartment is within walking distance to all amenities, transportation, and recreational parks and shops. Fantastic unit in a quite and safe location. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "733.54"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:47:04.205980+00:00"
+"Directions": "Dundas Street East to Hamilton Street South"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524989"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"LotSizeDimensions": "2.322"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T13:10:02Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:02:20Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3719.65"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364556"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"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/29964832/262-dundas-street-e-unit-315-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 510.0
+"AboveGradeFinishedArea": 951
+"OriginalEntryTimestamp": "2026-06-29T13:10:02.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063309"
+"ListOfficeNationalAssociationId": "1286675"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964832')"
+"ID": "1574964"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1571912"
+post_author: 1
+"ListingKey": "29960542"
+"ListingId": "X13495616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:02Z"
+"RFModificationTimestamp": "2026-06-26T23:04:46Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X1"
+"UnparsedAddress": "14 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X1"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained and move-in-ready corner-unit townhouse offering approximately 1,800 sq. ft. of bright and functional living space. This spacious home features 3+1 bedrooms, 3 bathrooms, a double-car garage, plus 2 additional driveway parking spaces. The desirable corner location allows for an abundance of natural light through numerous windows throughout the home. Enjoy an open-concept kitchen overlooking the dining area, complete with a large pantry and excellent storage space. The well-designed layout includes generously sized bedrooms and a primary suite with an ensuite bath. An unfinished basement offers exceptional potential for future customization and added living space while providing ample storage. Relax on the private balcony with gas hookups and enjoy comfortable, low-maintenance living in a sought-after, family-friendly community. Ideally located with exceptional accessibility, this home is just minutes from major highways, shopping centres, schools, parks, restaurants, and all everyday amenities, making it a perfect choice for families seeking both convenience and comfort. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:04:38.815915+00:00"
+"Directions": "Hamilton St N / Dundas St E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946962"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:00Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:00Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6356.58"
+"View": "View"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960542/14-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1892161"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 905-540-8800"
+"CoListOfficeKey": "50236"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "R6-33"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T20:48:00.12Z"
+"ListAgentNationalAssociationId": "1241888"
+"ListOfficeNationalAssociationId": "1002993"
+"CoListAgentNationalAssociationId": "1212143"
+"CoListOfficeNationalAssociationId": "1002993"
+"Media": array:34 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960542')"
+"ID": "1571912"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1567003"
+post_author: 1
+"ListingKey": "29946398"
+"ListingId": "X13482892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:14Z"
+"RFModificationTimestamp": "2026-07-02T15:05:20Z"
+"ListPrice": 1325000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J6"
+"UnparsedAddress": "31 COMMANDO COURT, Hamilton (Waterdown), Ontario L8B0J6"
+"Coordinates": array:2 [
0 => -79.903711
1 => 43.329889
]
+"Latitude": 43.329889
+"Longitude": -79.903711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "If you have been looking for an exclusive court enclave in Waterdown, we have the perfect opportunity for you! 31 Commando Court, nestled in a quiet part of town, offers privacy and excellent walkability. This 4-bedroom, 2.5-bath home boasts over 2,500 sq ft of finished living space, an unfinished basement awaiting your final touches, and a double-car garage. Step inside to discover a beautiful staircase, open-concept layout, and gleaming strip hardwood flooring throughout the main level. Designed for comfort and functionality, this floor features a formal dining room, spacious eat-in kitchen, inviting living area, and a front-facing office perfect for working from home or a playroom. The dining room connects seamlessly to the family room through elegant pocket doors, creating an ideal space for entertaining. The updated eat-in kitchen showcases white cabinetry, quartz countertops, tile backsplash, peninsula seating, and a walkout to the concrete patio. Open to the living room, this space is highlighted by a stunning stone fireplace and expansive windows overlooking the private backyard and desirable court setting. The upper level features a thoughtfully designed split floor plan, providing the primary retreat with exceptional privacy. This inviting space includes a large built-in wall closet, front-facing picture windows, and a spa-like 4-piece ensuite. Three additional bedrooms offer hardwood flooring, picture windows, and double closets. A spacious 4-piece main bath, double linen closet, and convenient upper-level laundry add to this well-designed floor's functionality. The unfinished basement presents an excellent opportunity to create additional living space, complete with a rough-in for a future bathroom. Outdoors, enjoy a large stamped concrete patio, iron fencing, and ample space for a pool, play area, or other amenities. Situated on one of Waterdown's most sought-after streets, this exceptional property offers the perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:22:28.727807+00:00"
+"Directions": "Hamilton St N & Parkside Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "302161"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "48.3 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:50:35Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:50:35Z"
+"Stories": "2.0"
+"StreetName": "Commando"
+"StreetNumber": "31"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "8000"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/31-commando-ct-hamilton-on-l8b-0j6-25408789/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946398/31-commando-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-24"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 48.3
+"OriginalEntryTimestamp": "2026-06-24T14:51:08.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246196"
+"ListOfficeNationalAssociationId": "1499250"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946398')"
+"ID": "1567003"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 122
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]