array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30027582 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:25:18Z"
+"RFModificationTimestamp": "2026-07-13T21:46:42Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8912452
1 => 43.3312034
]
+"Latitude": 43.3312034
+"Longitude": -79.8912452
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T21:46:37.455766+00:00"
+"Directions": "Take highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024789"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-13T21:18:11Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T21:18:11Z"
+"Stories": "1.0"
+"StreetName": "FLAMBORO"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1683408904"
"RoomType" => "Laundry room"
"ListingId" => "40847601"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
1 => array:11 [
"RoomKey" => "1683408905"
"RoomType" => "3pc Bathroom"
"ListingId" => "40847601"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
2 => array:11 [
"RoomKey" => "1683408906"
"RoomType" => "Utility room"
"ListingId" => "40847601"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 26'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
3 => array:11 [
"RoomKey" => "1683408907"
"RoomType" => "Bedroom"
"ListingId" => "40847601"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
4 => array:11 [
"RoomKey" => "1683408908"
"RoomType" => "Recreation room"
"ListingId" => "40847601"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
5 => array:11 [
"RoomKey" => "1683408909"
"RoomType" => "Living room"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
6 => array:11 [
"RoomKey" => "1683408910"
"RoomType" => "Dining room"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
7 => array:11 [
"RoomKey" => "1683408911"
"RoomType" => "Kitchen"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
8 => array:11 [
"RoomKey" => "1683408912"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
9 => array:11 [
"RoomKey" => "1683408913"
"RoomType" => "Bedroom"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
10 => array:11 [
"RoomKey" => "1683408914"
"RoomType" => "Bedroom"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
11 => array:11 [
"RoomKey" => "1683408915"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847601"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30027582"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T21:18:11.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027582/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2026-07-13T21:18:11.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304516"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063598"
+"CoListOfficeNationalAssociationId": "1325425"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30027582_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/8f031750eb261595de597e1676b58a44.webp"
"MediaSize" => 181630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-8f031750eb261595de597e1676b58a44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30027582_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/10bee83dbfe7b0dd66339fbc66109245.webp"
"MediaSize" => 165222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-10bee83dbfe7b0dd66339fbc66109245.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30027582_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/a7b1ec197dcc90b07c5bf19bdf3845ee.webp"
"MediaSize" => 61465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-a7b1ec197dcc90b07c5bf19bdf3845ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30027582_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/fa03ec28782e2d16213ca0f80e56bfda.webp"
"MediaSize" => 67680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-fa03ec28782e2d16213ca0f80e56bfda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30027582_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/4accf15abbdd909c8d3436cc565755c5.webp"
"MediaSize" => 87629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-4accf15abbdd909c8d3436cc565755c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30027582_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/931aa9c0c1f734f91690145d9491dfeb.webp"
"MediaSize" => 99678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-931aa9c0c1f734f91690145d9491dfeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30027582_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/fa2cf2e0a1d8ad4d9374ce7ae5da3807.webp"
"MediaSize" => 97887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-fa2cf2e0a1d8ad4d9374ce7ae5da3807.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30027582_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/97211f9b087b7586e59f5c6b27aa9c36.webp"
"MediaSize" => 74688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-97211f9b087b7586e59f5c6b27aa9c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30027582_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/314ad0b0e13ff0ce759852df745814ec.webp"
"MediaSize" => 80967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-314ad0b0e13ff0ce759852df745814ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30027582_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/23bb86683c63d769da8eacfe17ed9547.webp"
"MediaSize" => 67029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-23bb86683c63d769da8eacfe17ed9547.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30027582_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/8b82b7dbb705f3cd5f4f2824d00abd28.webp"
"MediaSize" => 97786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-8b82b7dbb705f3cd5f4f2824d00abd28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30027582_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/54d1c241f29e20b323b1bc371eb4ace0.webp"
"MediaSize" => 89081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-54d1c241f29e20b323b1bc371eb4ace0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30027582_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/07b9c9278263bb14635539a6a460f899.webp"
"MediaSize" => 80533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-07b9c9278263bb14635539a6a460f899.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30027582_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/50213e0c9ca5185a831fcc957a86ecbc.webp"
"MediaSize" => 96755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-50213e0c9ca5185a831fcc957a86ecbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30027582_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/a9081cfe262bdd8e8592b9cd12e92817.webp"
"MediaSize" => 89269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-a9081cfe262bdd8e8592b9cd12e92817.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30027582_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/91875d0d138bb88249ab929526357ce4.webp"
"MediaSize" => 76350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-91875d0d138bb88249ab929526357ce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30027582_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/1da02b5ba38338e64649dfbb562a9d65.webp"
"MediaSize" => 61974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-1da02b5ba38338e64649dfbb562a9d65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30027582_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/40ae16fe0819b78a2d849495f7d176fc.webp"
"MediaSize" => 77389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-40ae16fe0819b78a2d849495f7d176fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30027582_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/84c95e988e198f162111db5f165757fd.webp"
"MediaSize" => 74798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-84c95e988e198f162111db5f165757fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30027582_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/d2b8eb2386175b692e420d4ea2ecffb6.webp"
"MediaSize" => 71983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-d2b8eb2386175b692e420d4ea2ecffb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30027582_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/33f2a1e0c483d2e2e7892bc6872735f3.webp"
"MediaSize" => 76738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-33f2a1e0c483d2e2e7892bc6872735f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30027582_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/ee1db2d2ebd981f97221de86606c9e43.webp"
"MediaSize" => 89761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-ee1db2d2ebd981f97221de86606c9e43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30027582_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/8ad14275974a71c2e787b0be15490d61.webp"
"MediaSize" => 85018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-8ad14275974a71c2e787b0be15490d61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30027582_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/075ee599d47e46e630dc73e5ebb29f72.webp"
"MediaSize" => 106452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-075ee599d47e46e630dc73e5ebb29f72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30027582_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/405a5d1e3930fc6db9ace08c8f50bd04.webp"
"MediaSize" => 81076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-405a5d1e3930fc6db9ace08c8f50bd04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30027582_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/381602d4dff357c60bff33ca6c06136c.webp"
"MediaSize" => 87602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-381602d4dff357c60bff33ca6c06136c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30027582_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/aa7ccf2b4e3af15ad64dda76567803fc.webp"
"MediaSize" => 86092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-aa7ccf2b4e3af15ad64dda76567803fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30027582_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/78a99e8a46687cc1307778cd09a02b15.webp"
"MediaSize" => 79480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-78a99e8a46687cc1307778cd09a02b15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30027582_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/4789021533c785761c02a6c1ff9df9b6.webp"
"MediaSize" => 63938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-4789021533c785761c02a6c1ff9df9b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30027582_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/b26979f650075f56930ea4a88ce25778.webp"
"MediaSize" => 56282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-b26979f650075f56930ea4a88ce25778.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30027582_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/731b72630f67c75adeb478838a1f735d.webp"
"MediaSize" => 71456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-731b72630f67c75adeb478838a1f735d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30027582_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/21d4f711b1292ad7d3b1eb6b67fea9a4.webp"
"MediaSize" => 172618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-21d4f711b1292ad7d3b1eb6b67fea9a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30027582_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/1f14e18f0ed1ce667b4a7e2246b4da7e.webp"
"MediaSize" => 190263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-1f14e18f0ed1ce667b4a7e2246b4da7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30027582_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/f2087d1f2488da1612a9925df278085e.webp"
"MediaSize" => 176323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-f2087d1f2488da1612a9925df278085e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30027582_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/f6a2447728a723d7f4af39658ee9c531.webp"
"MediaSize" => 191881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-f6a2447728a723d7f4af39658ee9c531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30027582_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30027582/57194175fe29df291dbd6c7dc8ddb445.webp"
"MediaSize" => 198210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30027582/thumbnail-57194175fe29df291dbd6c7dc8ddb445.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847601"
"ResourceRecordKey" => "30027582"
"ModificationTimestamp" => "2026-07-13T21:18:11.16Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283187" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24979
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24923
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Burloak Real Estate Services"
+"OfficeEmail": null
+"OfficePhone": "905-634-7755"
+"OfficeMlsId": "HBRLPBURLLAA"
+"ModificationTimestamp": "2026-02-17T23:14:29Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283187"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2025 Maria Street Unit 4A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7R0G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1325425"
+"OriginalEntryTimestamp": "2018-03-15T13:35:00Z"
+"OfficeFax": "905-639-1683"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439637"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283187"
"SocialMediaUrlOrId" => "https://www.royallepageburlington.ca/"
"ModificationTimestamp" => "2026-02-17T22:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1121809"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283187')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2024789" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24933
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30027582'" => 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.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30027582' AND OpenHouseDate ge '2026-07-13'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30027582' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8912452 43.3312034)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25344
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+post_id: "1622277"
+post_author: 1
+"ListingKey": "30029200"
+"ListingId": "X13559688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "904 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 bed, 1 bath condo showcasing a bright, open-concept design with modern finishes throughout. Featuring an upgraded kitchen with stainless steel appliances, a spacious island with built-in storage, and elegant pendant lighting, this unit flows effortlessly into the sun-filled living area with expansive windows and beautiful views. The generous bedroom is complemented by a contemporary 4-piece bath and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Enjoy premium building amenities including a party room, gym, rooftop patios, and bike storage. Ideally located in the sought-after Waterdown community, just minutes to dining, shopping, parks, and a quick 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-14T06:44:12.429132+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1683787670"
"RoomType" => "Bedroom"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "30029200"
"RoomLength" => 2.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
1 => array:11 [
"RoomKey" => "1683787671"
"RoomType" => "Great room"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 5.92
"ListingKey" => "30029200"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
2 => array:11 [
"RoomKey" => "1683787672"
"RoomType" => "Kitchen"
"ListingId" => "X13559688"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "30029200"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T05:07:37.28Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029200/904-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentia"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.26Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30029200_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a5fbd58071f9ee559ada8f443103c4f0.webp"
"MediaSize" => 221553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a5fbd58071f9ee559ada8f443103c4f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30029200_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/238c77be84a5a934016e90a9a957bf15.webp"
"MediaSize" => 205608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-238c77be84a5a934016e90a9a957bf15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30029200_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a13611ec1b2ccd0fcc9cb08ec598bdfe.webp"
"MediaSize" => 206558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a13611ec1b2ccd0fcc9cb08ec598bdfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30029200_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/dbe9fd4a63e2286b1314bca98af3b813.webp"
"MediaSize" => 176913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-dbe9fd4a63e2286b1314bca98af3b813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30029200_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/6c7cd0094c63d7cf51aee7a4a4d84c15.webp"
"MediaSize" => 147361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-6c7cd0094c63d7cf51aee7a4a4d84c15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30029200_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/cf138a0f8630de6094ec34fc105c8b43.webp"
"MediaSize" => 119587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-cf138a0f8630de6094ec34fc105c8b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30029200_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/831f72d64cfec68920d67c299c179d5b.webp"
"MediaSize" => 107254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-831f72d64cfec68920d67c299c179d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30029200_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/a7d36eebe17e3e9955e566f34c249486.webp"
"MediaSize" => 113240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-a7d36eebe17e3e9955e566f34c249486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30029200_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/9fe12c8fd404c0f09242c47834a959e1.webp"
"MediaSize" => 97970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-9fe12c8fd404c0f09242c47834a959e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30029200_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/34bde3859efdee862f502b1de8f9d040.webp"
"MediaSize" => 142439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-34bde3859efdee862f502b1de8f9d040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30029200_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/efc9c2d804f7a70e6879c70ce0b27b03.webp"
"MediaSize" => 96334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30029200/thumbnail-efc9c2d804f7a70e6879c70ce0b27b03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559688"
"ResourceRecordKey" => "30029200"
"ModificationTimestamp" => "2026-07-14T05:07:37.26Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30029200_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30029200/918d6f5bfd88efddfd5ca1890819f11c.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029200')"
+"ID": "1622277"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1622278"
+post_author: 1
+"ListingKey": "30029198"
+"ListingId": "X13559668"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "804 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 1 bed, 1 bath condo offering a bright, open-concept layout with modern finishes throughout. The stylish kitchen features stainless steel appliances, a breakfast bar, and contemporary cabinetry, flowing effortlessly into the spacious living area with large windows and plenty of natural light. The well-sized bedroom offers comfort and great views, complemented by a sleek 4-piece bathroom and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Residents have access to excellent amenities including a party room, gym, rooftop patios, and bike storage. Located in the highly desirable Waterdown community, close to dining, shopping, schools, parks, and just a 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-14T06:44:11.804722+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029198/804-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029198')"
+"ID": "1622278"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1621732"
+post_author: 1
+"ListingKey": "30028166"
+"ListingId": "X13558984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T22:45:02Z"
+"RFModificationTimestamp": "2026-07-14T01:10:34Z"
+"ListPrice": 849999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "205 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.912066
1 => 43.335242
]
+"Latitude": 43.335242
+"Longitude": -79.912066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spacious freehold end-unit townhouse offering approximately 1,890 sq. ft. ofbeautifully maintained living space in the heart of Waterdown.Designed for both comfortable everyday living and effortless entertaining, this bright open-concept home features large windows that fill the space with natural light while showcasingpeaceful views of the private backyard oasis.Step outside and enjoy the serene backyard backing onto a school - an ideal setting forfamilies seeking a safe, family-friendly neighbourhood with added privacy and convenience.The second floor offers 3 spacious bedrooms, including a generous primary suite complete witha walk-in closet, additional his closet, and a private ensuite bathroom. A second full bathroom provides added comfort for family and guests.Ideally located within walking distance to all schools from kindergarten through Grade 12, aswell as parks, shopping, dining, and the community centre. Commuters will appreciate the easyaccess to Hwy 6, 403, 407, the QEW, and Aldershot GO Station.This gorgeous townhouse presents an incredible opportunity for first-time home buyers, growing families, or anyone looking to settle into one of Waterdown's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
12 => "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-07-14T01:10:25.622227+00:00"
+"Directions": "Nisbet Blvd and Cathedral CRT"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055502"
+"ListOfficeKey": "277399"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T22:38:23Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T22:38:23Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "205"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5601"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30028166/205-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-13T22:38:23.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1330819"
+"ListOfficeNationalAssociationId": "1282815"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028166')"
+"ID": "1621732"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: "1620942"
+post_author: 1
+"ListingKey": "30027846"
+"ListingId": "X13558740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:50:04Z"
+"RFModificationTimestamp": "2026-07-13T22:43:29Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.891184
1 => 43.331196
]
+"Latitude": 43.331196
+"Longitude": -79.891184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:43:18.555618+00:00"
+"Directions": "Cross Streets: Flamboro St. and Barton St. ** Directions: Take Highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Flat site"
3 => "Carpet Free"
]
+"LotSizeDimensions": "68.1 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T21:40:18Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T21:40:18Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"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": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30027846/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-13T21:40:18.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: "1619363"
+post_author: 1
+"ListingKey": "30025665"
+"ListingId": "X13556592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T12:20:11Z"
+"RFModificationTimestamp": "2026-07-14T12:27:22Z"
+"ListPrice": 1579990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "156 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.911159
1 => 43.336589
]
+"Latitude": 43.336589
+"Longitude": -79.911159
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set in a quiet, established Waterdown neighbourhood just down the street from Allan A. Greenleaf Elementary & Waterdown District High School, this beautifully cared-for home offers the kind of location, quality, and lifestyle that families rarely find all in one place. Inside, every space reflects pride of ownership and thoughtful investment. The custom 2025 kitchen sets the tone with tailored cabinetry, quartz counters, royal brass hardware, under-cabinet lighting, custom storage, a built-in bay-window bench, and a chef's island with wraparound seating that naturally becomes the heart of the home. Elegant living & dining areas, a renovated powder room, and a custom laundry room continue the refined main-floor feel. The mid-level family room is a standout retreat with a custom media wall, Napoleon electric fireplace, built-in cabinetry, a 75" LG TV, and a walkout to a covered front balcony. Upstairs, the primary suite features a double-door entry, dual walk-in closets and a beautifully renovated 5-piece ensuite. The impeccably finished lower level adds 1025 square feet of impressive flexibility with a large rec room, den or guest space, luxurious second kitchen, second laundry area, 5-pc spa-inspired bathroom, oversized walk-in closet, and above-grade windows. Out back, the property transforms into a private resort. A heated saltwater pool with a sheer-descent waterfall, interlocking patio, mature trees, landscape irrigation, and lounging & entertaining zones create an outdoor setting designed for summer days, quiet evenings, and unforgettable gatherings. Major recent updates include a $70,000 Nordik windows & doors package in 2025 with triple-pane glass & a 25-year transferable warranty; a high-efficiency furnace in 2023; a Jandy pool heater in 2025 & iAquaLink pool control. This is a home that needs to be experienced in person to fully appreciate the quality, care, and attention found in every detail. (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Cooktop"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:25:19.484551+00:00"
+"Directions": "Cross Streets: Hamilton St N/Parkside Dr. ** Directions: Hamilton St N to Nisbet Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959027"
+"ListOfficeKey": "50325"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Carpet Free"
4 => "Gazebo"
]
+"LotSizeDimensions": "48.8 x 88.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:08Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T12:07:04Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "8495"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/156_nisbet_blvd_hamilton_on/"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025665/156-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1962563"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50325"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 48.9
+"OriginalEntryTimestamp": "2026-07-13T16:40:08.57Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249697"
+"ListOfficeNationalAssociationId": "1285004"
+"CoListAgentNationalAssociationId": "1252070"
+"CoListOfficeNationalAssociationId": "1285004"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025665')"
+"ID": "1619363"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1619412"
+post_author: 1
+"ListingKey": "30024405"
+"ListingId": "40846567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T14:05:26Z"
+"RFModificationTimestamp": "2026-07-13T17:14:32Z"
+"ListPrice": 1670000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2935.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7H5"
+"UnparsedAddress": "53 ROCKCLIFFE Road, Waterdown, Ontario L9H7H5"
+"Coordinates": array:2 [
0 => -79.8990405
1 => 43.3247123
]
+"Latitude": 43.3247123
+"Longitude": -79.8990405
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Just steps from the Niagara Escarpment and its spectacular trails where nature meets elevated living, you'll find the highly sought-after Rockcliffe community. Surrounded by an exceptional collection of both timeless and contemporary homes, this custom built bungalow is being offered for sale for the first time. Designed with quality, comfort and functionality in mind, this impressive home features a 3 car garage- large enough to host 2 SUV's and a compact car, exposed aggregate driveway, walkways and rear patio, exquisite masonry, award-winning gardens, and an in-ground sprinkler system. Inside, the welcoming front foyer opens to a thoughtfully designed open-concept floor plan with beautiful sightlines throughout the principal living spaces. A private den or home office offers flexibility to be converted into a 2nd main floor bedroom. The spacious primary suite features a private ensuite, while the elegant formal dining room is highlighted by a tray ceiling. The expansive family room is anchored by a cozy gas fireplace and framed by large windows overlooking the beautifully landscaped backyard. The kitchen has been designed to maximize every inch of space, offering abundant cabinetry and workspace as well as a central vacuum floor sweep for any crumbs! The kitchen walkout leads directly to the exposed aggregate patio, complete with the included natural gas BBQ making outdoor entertaining effortless. Adjacent to the kitchen is a well-appointed laundry room, a 2 piece bath and direct access to the garage. The lower level offers incredible flexibility with being a walk out. It could be ideal for extended family or a private guest suite. It features a finished recreation room with a gas fireplace, two bedrooms, a full bathroom, in- floor heating, ample unfinished space for storage or future customization and lastly there is the incredible rear patio surrounded by lush gardens and armour stone for an inviting peaceful retreat. Your wish list is granted! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:14:19.110786+00:00"
+"Directions": "Dundas St E to Dennis Ave to Overdale to Rockcliffe"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1669976"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T13:58:47Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T13:58:47Z"
+"Stories": "1.0"
+"StreetName": "ROCKCLIFFE"
+"StreetNumber": "53"
+"StreetSuffix": "Road"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9848.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_rockcliffe_rd_waterdown_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024405/53-rockcliffe-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "01-1, R1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 77.0
+"AboveGradeFinishedArea": 2035
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-07-13T13:58:47.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1170081"
+"ListOfficeNationalAssociationId": "1003546"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024405')"
+"ID": "1619412"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1619021"
+post_author: 1
+"ListingKey": "30025187"
+"ListingId": "40843193"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T23:25:19Z"
+"RFModificationTimestamp": "2026-07-13T23:27:36Z"
+"ListPrice": 1579990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3749.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0S8"
+"UnparsedAddress": "156 NISBET Boulevard, Waterdown, Ontario L8B0S8"
+"Coordinates": array:2 [
0 => -79.9111284
1 => 43.3365682
]
+"Latitude": 43.3365682
+"Longitude": -79.9111284
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in a quiet, established Waterdown neighbourhood just down the street from Allan A. Greenleaf Elementary & Waterdown District High School, this beautifully cared-for home offers the kind of location, quality, and lifestyle that families rarely find all in one place. Inside, every space reflects pride of ownership and thoughtful investment. The custom 2025 kitchen sets the tone with tailored cabinetry, quartz counters, royal brass hardware, under-cabinet lighting, custom storage, a built-in bay-window bench, and a chef’s island with wraparound seating that naturally becomes the heart of the home. Elegant living & dining areas, a renovated powder room, and a custom laundry room continue the refined main-floor feel. The mid-level family room is a standout retreat with a custom media wall, Napoleon electric fireplace, built-in cabinetry, a 75” LG TV, and a walkout to a covered front balcony. Upstairs, the primary suite features a double-door entry, dual walk-in closets and a beautifully renovated 5-piece ensuite. The impeccably finished lower level adds 1025 square feet of impressive flexibility with a large rec room, den or guest space, luxurious second kitchen, second laundry area, 5-pc spa-inspired bathroom, oversized walk-in closet, and above-grade windows. Out back, the property transforms into a private resort. A heated saltwater pool with a sheer-descent waterfall, interlocking patio, mature trees, landscape irrigation, and lounging & entertaining zones create an outdoor setting designed for summer days, quiet evenings, and unforgettable gatherings. Major recent updates include a $70,000 Nordik windows & doors package in 2025 with triple-pane glass & a 25-year transferable warranty; a high-efficiency furnace in 2023; a Jandy pool heater in 2025 & iAquaLink pool control. This is a home that needs to be experienced in person to fully appreciate the quality, care, and attention found in every detail. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T16:34:50.295541+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237332"
+"ListOfficeKey": "94300"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Corner Site"
2 => "Conservation/green belt"
3 => "Gazebo"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T15:48:37Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T23:18:42Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8495"
+"VirtualTourURLUnbranded": "https://youtu.be/7wZQy7nQEJA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30025187/156-nisbet-boulevard-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2237557"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "94300"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2640
+"BelowGradeFinishedArea": 1109
+"OriginalEntryTimestamp": "2026-07-13T15:48:37.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1475144"
+"ListOfficeNationalAssociationId": "1188651"
+"CoListAgentNationalAssociationId": "1475444"
+"CoListOfficeNationalAssociationId": "1188651"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025187')"
+"ID": "1619021"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1616966"
+post_author: 1
+"ListingKey": "30021444"
+"ListingId": "X13552446"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T12:15:17Z"
+"RFModificationTimestamp": "2026-07-11T19:04:31Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 10.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L4B1W8"
+"UnparsedAddress": "44 GOLDEN HAWK DRIVE, Hamilton (Waterdown), Ontario L4B1W8"
+"Coordinates": array:2 [
0 => -79.8808833
1 => 43.3336484
]
+"Latitude": 43.3336484
+"Longitude": -79.8808833
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "unique opportunity for a family looking for an upgraded quality home in an exceptional and mature neighbourhood! Excellent layout 5 bedroom, 4 bathroom home, with a w/o basement backing onto a pond!150k spent on upgrades.10-foot ceilings, Modern Kitchen with S/S Appliances, Quartz countertop &Backsplash, Central Island, Open Concept living/Dinning with Pot Lights & Crown Moulding,Hardwood Floor, New Upgrade Bathrooms,freshly Painted, new light fixtures, gas fireplace, Shangri-La Curtains, Interlock Driveway,R-In Cvac etc. Basement potential rent $2200/month.Very Private Backyard, No Sidewalk. Close To Go Train,407/QEW,school,park. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Dryer"
2 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-11T19:04:11.527911+00:00"
+"Directions": "Cross Streets: Dundas St E/Burke St. ** Directions: Dundas st to Burke st toGolden Hawk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1639389"
+"ListOfficeKey": "91727"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "46.9 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T12:06:39Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T12:06:39Z"
+"Stories": "2.0"
+"StreetName": "Golden Hawk"
+"StreetNumber": "44"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10393.89"
+"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"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30021444/44-golden-hawk-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-07-11T12:06:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1164665"
+"ListOfficeNationalAssociationId": "1155942"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021444')"
+"ID": "1616966"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1616967"
+post_author: 1
+"ListingKey": "30021880"
+"ListingId": "40847301"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T16:25:16Z"
+"RFModificationTimestamp": "2026-07-11T19:00:18Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2184.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "22 SPRING CREEK Drive Unit# 33, Waterdown, Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.8789989
1 => 43.3464788
]
+"Latitude": 43.3464788
+"Longitude": -79.8789989
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful freehold end-unit townhome in Waterdown, where thoughtful upgrades, generous living space, and everyday comfort come together perfectly. Offering 3 bedrooms and 2.5 bathrooms, this impressive home features a separate formal dining room and a bright, inviting great room with a dedicated breakfast area. Hardwood flooring, elegant crown moulding, and California shutters add warmth and character throughout the main level. At the heart of the home is a stunning kitchen designed to impress, complete with quartz countertops, a stylish backsplash, and under-cabinet lighting. Upstairs, retreat to the spacious primary bedroom featuring a spa-inspired ensuite with a double-sink quartz vanity, walk-in shower, and relaxing soaker tub. Two additional bedrooms and convenient upper-level laundry complete the second floor. The finished basement provides valuable additional living space with custom storage cabinetry, while the beautifully landscaped backyard features a premium 16' x 16' composite deck, perfect for entertaining or unwinding outdoors. Ideally located close to trails, parks, the GO Station, and major highways including the 403, 407, and QEW, this is the perfect opportunity to enjoy the charm of Waterdown with exceptional commuter convenience. A stylish, spacious, move-in-ready home you don't want to miss! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T19:00:11.638969+00:00"
+"Directions": "Dundas St. to Spring Creek Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2169171"
+"ListOfficeKey": "283890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-11T16:18:14Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T16:18:14Z"
+"Stories": "2.0"
+"StreetName": "SPRING CREEK"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6860"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "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/30021880/22-spring-creek-drive-unit-33-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-42"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1884
+"BelowGradeFinishedArea": 300
+"OriginalEntryTimestamp": "2026-07-11T16:18:14.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419828"
+"ListOfficeNationalAssociationId": "1336415"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30021880')"
+"ID": "1616967"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 215
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]