array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29069932/Property?$select=ALL&$top=20&$filter=ListingKey eq 29069932&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29069932/Property?$select=ALL&$top=20&$filter=ListingKey eq 29069932&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23282
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23284
+post_id: "392398"
+post_author: 1
+"ListingKey": "29069932"
+"ListingId": "40785574"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-05T16:41:09Z"
+"RFModificationTimestamp": "2025-11-06T00:56:27Z"
+"ListPrice": 899999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2505.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C8"
+"UnparsedAddress": "128 BRIAN Boulevard, Waterdown, Ontario L8B0C8"
+"Coordinates": array:2 [
0 => -79.90983455
1 => 43.3281
]
+"Latitude": 43.3281
+"Longitude": -79.90983455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 128 Brian Boulevard, Waterdown – Your Dream Home Awaits! Discover this beautifully maintained, move-in-ready residence nestled in one of Waterdown's most sought-after, mature neighborhoods, Waterdown West. This charming home offers 1,610 square feet of thoughtfully designed living space, featuring 4 spacious bedrooms and 3 modern bathrooms — perfect for families and entertaining alike. Step inside to a bright and airy atmosphere with a stunning, massive dining room bathed in natural light, complete with a cozy fireplace mantel that creates a warm, inviting ambiance for gatherings. The large living room provides ample space for relaxing with loved ones or hosting guests. Enjoy the convenience of a finished basement, with an additional bedroom, bathroom and office, withe loads of extra space ideal for a home theater, gym, or additional recreational area. The home boasts numerous updates throughout, reflecting care and attention to detail, ensuring comfort and peace of mind. Backing directly onto a school, this location offers unmatched convenience and tranquility, with lush greenery and a peaceful setting. Whether you're looking for a family-friendly community or a stylish space to call home, 128 Brian Boulevard combines all the essentials with exceptional updates and an unbeatable location. Don’t miss your chance to own this outstanding property in Waterdown’s premier neighborhood. Schedule your private showing today! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-06T00:56:14.935670+00:00"
+"Directions": "Parkside to Braeheid to Brian Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082813"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-05T16:30:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-05T16:30:20Z"
+"Stories": "2.0"
+"StreetName": "BRIAN"
+"StreetNumber": "128"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6524.1"
+"VirtualTourURLUnbranded": "https://sites.cathykoop.ca/128brianboulevard"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1529659112"
"RoomType" => "3pc Bathroom"
"ListingId" => "40785574"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.69Z"
]
1 => array:11 [
"RoomKey" => "1529659113"
"RoomType" => "Bedroom"
"ListingId" => "40785574"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.69Z"
]
2 => array:11 [
"RoomKey" => "1529659114"
"RoomType" => "Laundry room"
"ListingId" => "40785574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.69Z"
]
3 => array:11 [
"RoomKey" => "1529659115"
"RoomType" => "4pc Bathroom"
"ListingId" => "40785574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.69Z"
]
4 => array:11 [
"RoomKey" => "1529659116"
"RoomType" => "Bedroom"
"ListingId" => "40785574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
5 => array:11 [
"RoomKey" => "1529659117"
"RoomType" => "Bedroom"
"ListingId" => "40785574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
6 => array:11 [
"RoomKey" => "1529659118"
"RoomType" => "Primary Bedroom"
"ListingId" => "40785574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
7 => array:11 [
"RoomKey" => "1529659119"
"RoomType" => "2pc Bathroom"
"ListingId" => "40785574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 2'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
8 => array:11 [
"RoomKey" => "1529659120"
"RoomType" => "Kitchen"
"ListingId" => "40785574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
9 => array:11 [
"RoomKey" => "1529659121"
"RoomType" => "Dining room"
"ListingId" => "40785574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
10 => array:11 [
"RoomKey" => "1529659122"
"RoomType" => "Living room"
"ListingId" => "40785574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29069932"
"RoomLength" => null
"RoomDimensions" => "23'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-05T16:30:20.7Z"
]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29069932/128-brian-boulevard-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2235651"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1980775"
+"CoListOfficeKey": "283099"
+"CoListOfficeKey2": "283099"
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1675
+"BelowGradeFinishedArea": 830
+"OriginalEntryTimestamp": "2025-11-05T16:30:20.63Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6296609148"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/ceae10c3ec4c7170181b8a1218e4a0e9.webp"
"MediaSize" => 137516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-ceae10c3ec4c7170181b8a1218e4a0e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6296609184"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/567387fe35acba190ce967cddd4b9a6c.webp"
"MediaSize" => 146115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-567387fe35acba190ce967cddd4b9a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6296609204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/e651073e199df1fb173f1f20c204b251.webp"
"MediaSize" => 130036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-e651073e199df1fb173f1f20c204b251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6296609232"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/0ca9754b96c95ba0ce024f9b9c13306e.webp"
"MediaSize" => 64046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-0ca9754b96c95ba0ce024f9b9c13306e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6296609274"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/b2268ca2718b2827301a240a3c3f6cff.webp"
"MediaSize" => 50132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-b2268ca2718b2827301a240a3c3f6cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6296609311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/4bf6816a3bbbec3767384a07483448bd.webp"
"MediaSize" => 46722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-4bf6816a3bbbec3767384a07483448bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6296609364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/45589f8ac931e257aed451e58179175f.webp"
"MediaSize" => 61990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-45589f8ac931e257aed451e58179175f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6296609400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/454e2a482e807c65d858b2d371be5a39.webp"
"MediaSize" => 50615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-454e2a482e807c65d858b2d371be5a39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6296609446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/9cf04ebb13e2aa1bb4fa50e461d37e7b.webp"
"MediaSize" => 57578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-9cf04ebb13e2aa1bb4fa50e461d37e7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6296609475"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/5303e25d4cb4b390ad48d86cb7067fda.webp"
"MediaSize" => 67729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-5303e25d4cb4b390ad48d86cb7067fda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6296609566"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/5280c18cd0e9b44f4a3881c6166b8823.webp"
"MediaSize" => 56759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-5280c18cd0e9b44f4a3881c6166b8823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6296609596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/e6f85a0c509150489795fbb209a77439.webp"
"MediaSize" => 71792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-e6f85a0c509150489795fbb209a77439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6296609636"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/d2bd80bee262c347e5d7566aebb5ce91.webp"
"MediaSize" => 23329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-d2bd80bee262c347e5d7566aebb5ce91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6296609691"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/dcca6f71c70780e83b1694a2367cc707.webp"
"MediaSize" => 71865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-dcca6f71c70780e83b1694a2367cc707.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6296609751"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/1fdefe4e3566a59950ffe11bc7fa6fd7.webp"
"MediaSize" => 69598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-1fdefe4e3566a59950ffe11bc7fa6fd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6296609792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/c823486bf8d14b958e8b25f3c270548a.webp"
"MediaSize" => 41381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-c823486bf8d14b958e8b25f3c270548a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6296609868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/3b48da00d03c8cc9e51cc1bdd9da066c.webp"
"MediaSize" => 68021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-3b48da00d03c8cc9e51cc1bdd9da066c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6296609873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/becb87ee91f5bb9ea464ac4037a65cf4.webp"
"MediaSize" => 48591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-becb87ee91f5bb9ea464ac4037a65cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6296609909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/efa6cdf9a0670031f3de55b8c8da5354.webp"
"MediaSize" => 73695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-efa6cdf9a0670031f3de55b8c8da5354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6296609939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/5a7b56a79e357b204f45380ecbd68a5f.webp"
"MediaSize" => 55738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-5a7b56a79e357b204f45380ecbd68a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6296609992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/b494582eb8e72ced8da0933ecdd102ac.webp"
"MediaSize" => 68924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-b494582eb8e72ced8da0933ecdd102ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6296609999"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/efa8873e745c6253f9ba3614dbfca0ca.webp"
"MediaSize" => 62374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-efa8873e745c6253f9ba3614dbfca0ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6296610024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/dbfb044e71aae53b453f51c569a2471b.webp"
"MediaSize" => 70334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-dbfb044e71aae53b453f51c569a2471b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6296610041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/36b8255fa7bc5a97f656f5b098c49355.webp"
"MediaSize" => 68512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-36b8255fa7bc5a97f656f5b098c49355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6296610090"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/7d0c6b05ea939a65ffba539168165d4e.webp"
"MediaSize" => 80015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-7d0c6b05ea939a65ffba539168165d4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6296610126"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/bf66d3287b8e3e107b01f03eb340b3b1.webp"
"MediaSize" => 58694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-bf66d3287b8e3e107b01f03eb340b3b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6296610167"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/2e8141f4daee29d5d7bdcb810cf15cc3.webp"
"MediaSize" => 60656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-2e8141f4daee29d5d7bdcb810cf15cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6296610213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/0d16738294f0344892304d7896134a36.webp"
"MediaSize" => 59104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-0d16738294f0344892304d7896134a36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6296610246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/49165664c7524038fd0a5c8360108391.webp"
"MediaSize" => 51371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-49165664c7524038fd0a5c8360108391.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6296610314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/146b1f097128b2f22e7427f8b2380405.webp"
"MediaSize" => 57471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-146b1f097128b2f22e7427f8b2380405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6296610356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/9820d12f15abbf24513a0d36f51f75ec.webp"
"MediaSize" => 49085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-9820d12f15abbf24513a0d36f51f75ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6296610376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/807850a1c3ffac3ed3b7d04fe79da186.webp"
"MediaSize" => 32304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-807850a1c3ffac3ed3b7d04fe79da186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6296610409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/0f4fd545e13dba65399b4789dc67c256.webp"
"MediaSize" => 55770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-0f4fd545e13dba65399b4789dc67c256.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6296610419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/d6d6daba1684a7ca48c5204430a7326d.webp"
"MediaSize" => 57402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-d6d6daba1684a7ca48c5204430a7326d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6296610428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/b2fe5d3eae93043137be9617cf878ed5.webp"
"MediaSize" => 67377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-b2fe5d3eae93043137be9617cf878ed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6296610433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/7176ee5251004cbb084b1b64508e9ab9.webp"
"MediaSize" => 37541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-7176ee5251004cbb084b1b64508e9ab9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6296610450"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/4b9988f1b7ecfd50920879644c9be080.webp"
"MediaSize" => 48712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-4b9988f1b7ecfd50920879644c9be080.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6296610460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/1aa0b89cd286262cc05650d88f02aa15.webp"
"MediaSize" => 60108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-1aa0b89cd286262cc05650d88f02aa15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6296610467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/ca9953e368e1d776076064ad7bac960a.webp"
"MediaSize" => 59938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-ca9953e368e1d776076064ad7bac960a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6296610483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/2175279def081965a7ae88baf3ab453e.webp"
"MediaSize" => 48971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-2175279def081965a7ae88baf3ab453e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6296610491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/d69122c3dbc8923e6f7d9041679d7cca.webp"
"MediaSize" => 41420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-d69122c3dbc8923e6f7d9041679d7cca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6296610503"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/dacd9876cec62213245f41f6a0ccac87.webp"
"MediaSize" => 140841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-dacd9876cec62213245f41f6a0ccac87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6296610512"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/f2a2b40c19c0095823f8a4238b23115b.webp"
"MediaSize" => 161063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-f2a2b40c19c0095823f8a4238b23115b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6296610523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/0e58314f77301f020d9882b7329253a8.webp"
"MediaSize" => 180912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-0e58314f77301f020d9882b7329253a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6296610538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/f997cc7cf2eb3bb8804a9a56f0997490.webp"
"MediaSize" => 168573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-f997cc7cf2eb3bb8804a9a56f0997490.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6296610549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/3883995d273f882cbcde92c1935424ef.webp"
"MediaSize" => 179799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-3883995d273f882cbcde92c1935424ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6296610560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/7c68e27e44aa7663f10fc78813443f3d.webp"
"MediaSize" => 188031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-7c68e27e44aa7663f10fc78813443f3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6296610568"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/c319836da56389412a4806a595d92cb0.webp"
"MediaSize" => 181422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-c319836da56389412a4806a595d92cb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6296610575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/0389f3db8ed8768f17115017283768ce.webp"
"MediaSize" => 179475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-0389f3db8ed8768f17115017283768ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6296610582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069932/6dbcb28f852656d42f4c093fab963ca1.webp"
"MediaSize" => 172551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069932/thumbnail-6dbcb28f852656d42f4c093fab963ca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785574"
"ResourceRecordKey" => "29069932"
"ModificationTimestamp" => "2025-11-05T16:30:20.64Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29069932')"
+"ID": "392398"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283099&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25153
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Burloak Real Estate Services"
+"OfficeEmail": null
+"OfficePhone": "905-335-3042"
+"OfficeMlsId": "HBRLPBURMNY2"
+"ModificationTimestamp": "2025-07-09T18:16:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283099"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "3060 Mainway Suite 200A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M1A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1324631"
+"OriginalEntryTimestamp": "2018-02-28T20:54:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6078377651"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/office-283099/6b926984fe2a679911de20a55eff4f42.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "HBRLPBURMNY2"
"ResourceRecordKey" => "283099"
"ModificationTimestamp" => "2025-07-09T18:06:00Z"
]
]
+"OfficeFax": "905-335-1659"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439607"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283099"
"SocialMediaUrlOrId" => "https://www.royallepageburlington.ca/"
"ModificationTimestamp" => "2025-07-09T18:06:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1196412"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283099')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2082813/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2082813&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2082813/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2082813&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25158
+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 29069932" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24737
+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 29069932/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29069932&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29069932/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29069932&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24699
+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 29069932 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.90983455 43.3281)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29069932 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.90983455 43.3281)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29069932 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.90983455 43.3281)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29069932 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.90983455 43.3281)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25001
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25021
+post_id: "447353"
+post_author: 1
+"ListingKey": "29140356"
+"ListingId": "X12579976"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:10:24Z"
+"RFModificationTimestamp": "2025-11-27T01:33:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A3"
+"UnparsedAddress": "24 SAVAGE DRIVE, Hamilton (Waterdown), Ontario L8B0A3"
+"Coordinates": array:2 [
0 => -79.9086677
1 => 43.3393322
]
+"Latitude": 43.3393322
+"Longitude": -79.9086677
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedroom Freehold Townhome In An Unbeatable Location! Just Steps To Local Shopping, Parks, Schools And Ymca. Main Floor Offer Bright Airy Great Room With Walk-Out To Large Covered Balcony. Kitchen Features Stainless Steel Appliances, Lots Of Cabinetry And Workspace. Handy Breakfast Bar. Upper Level Offers 2 Spacious Bedrooms And Convenient Laundry. Ground Floor Entry With Lots Of Storage Space. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:33:36.526726+00:00"
+"Directions": "Cross Streets: Centre Rd. ** Directions: Parkside Dr & Centre Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1415763"
+"ListOfficeKey": "50737"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "19.7 x 49.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:21Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:00:21Z"
+"Stories": "3.0"
+"StreetName": "Savage"
+"StreetNumber": "24"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1540605075"
"RoomType" => "Great room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
1 => array:11 [
"RoomKey" => "1540605076"
"RoomType" => "Dining room"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29140356"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:00:21.82Z"
]
2 => array:11 [
"RoomKey" => "1540605077"
"RoomType" => "Kitchen"
"ListingId" => "X12579976"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29140356"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
…2
]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140356/24-savage-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-11-26T22:00:21.78Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:19 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140356')"
+"ID": "447353"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24625
+post_id: "445160"
+post_author: 1
+"ListingKey": "29137642"
+"ListingId": "X12577214"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T03:40:38Z"
+"RFModificationTimestamp": "2025-11-26T03:42:44Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X2"
+"UnparsedAddress": "4 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X2"
+"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 condo townhouse offering style, comfort, and convenience in every detail. The main level features an inviting open-concept layout with hardwood flooring and neutral paint tones that create a warm, modern feel. The gourmet kitchen boasts stainless steel appliances, a functional island, and plenty of counter space-perfect for cooking and entertaining. A custom built-in wall unit with charming shiplap & electric fireplace adds character and a cozy focal point to the living area. Upstairs, you'll find three generous-sized bedrooms, including a spacious primary suite complete with built-ins in the walk-in closet and its own 4-piece ensuite bathroom. An additional 4-piece bathroom serves guests or family. The second-floor laundry room has been tastefully updated, offering added convenience and style. The finished basement expands your living space with a versatile recreation room and ample storage options. A single-car garage provides secure parking and additional room for belongings. Move-in ready and thoughtfully updated, this home blends updated finishes with practical living spaces-perfect for families, professionals, or anyone seeking a low-maintenance lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "260.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T03:21:10.295086+00:00"
+"Directions": "Dundas St E/ Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235857"
+"ListOfficeKey": "280835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:53:38Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T03:20:42Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5639.1"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/4_215_dundas_st_e_hamilton_on/"
+"Rooms": array:14 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137642/4-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1956613"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blair Blanchard"
+"CoListAgentKey2": "2235858"
+"CoListOfficeKey": "280835"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"CoListOfficeKey2": "280835"
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-11-26T02:53:38.32Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137642')"
+"ID": "445160"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25007
+post_id: "440067"
+post_author: 1
+"ListingKey": "29130694"
+"ListingId": "X12570684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T17:45:39Z"
+"RFModificationTimestamp": "2025-11-24T19:18:59Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0E1"
+"UnparsedAddress": "3 LONGYEAR DRIVE, Hamilton (Waterdown), Ontario L8B0E1"
+"Coordinates": array:2 [
0 => -79.912484
1 => 43.328148
]
+"Latitude": 43.328148
+"Longitude": -79.912484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A Rare Opportunity Awaits Your Visit In The Heart Of Waterdown, Ontario! With The Utmost Excitement We Bring To You 3 Longyear Drive, Situated On A Breathtaking Lot Offering You Comfort And A Full Retreat Experience - All In One. Its Unique Interior Offers Traditional Finishing W/ A Touch Of Modern Design; Features 3 Bedrooms, 3 Washrooms, & A Fully Finished Basement. Step Inside To A Bright, Inviting Main Floor Highlighted By An Impressive Open-To-Above Living Area Featuring Soaring Ceilings And A Cozy Wood-Burning Fireplace, Creating A Stunning Focal Point For The Home! The Open-Concept Layout Continues W/ A Spacious Living/Dining Area (Large Bay-Window Overlooking The Backyard) & A Well-Appointed Kitchen Offering Ample Counter Space & Storage - Perfect For Everyday Living/Entertaining. Upstairs, You'll Find Three Generously Sized Bedrooms, Including A Primary Suite W/ A Walk-In Closet And Private Ensuite. An Additional Full Bathroom On The Upper-Level, And Overall, It's Functional Layout Make It Ideal For Families Of All Sizes. The Finished Basement Adds Valuable Living Space With A Large Recreation Area, Perfect For Movie Nights, Kids' Play Space, A Home Gym, Or A Comfortable Work-From-Home Setup - Along With Plenty Of Storage. All Of This Is Set In An Unbeatable Location, Walking Distance To Waterdown's Vibrant New Hub Of Shops, Dining, And Services, Plus Schools, Parks, And Trails Just Around The Corner. This Is More Than Just A Home, Its A Lifestyle. Rarely Does A Property Combine Such An Exceptional Layout/Size & Backyard With City Convenience; Plus A Walking Trail Directly Out Front (Open Area W/ A Ravine)! Don't Miss This Opportunity, Book Your Showing Today! (id:62650)"
+"Appliances": array:9 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T07:31:36.649788+00:00"
+"Directions": "Hwy 5 To Hollybush To Longyear"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110997"
+"ListOfficeKey": "274537"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42 x 95.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T06:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T17:34:59Z"
+"Stories": "2.0"
+"StreetName": "Longyear"
+"StreetNumber": "3"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6400"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/3-longyear-drive-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29130694/3-longyear-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2128727"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "274537"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2025-11-24T06:50:05.94Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29130694')"
+"ID": "440067"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24626
+post_id: "436984"
+post_author: 1
+"ListingKey": "29127642"
+"ListingId": "40786336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T16:20:16Z"
+"RFModificationTimestamp": "2025-11-22T16:22:50Z"
+"ListPrice": 2299000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.53
+"LivingArea": 2705.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Y4"
+"UnparsedAddress": "1962 SNAKE Road, Burlington, Ontario L7P4Y4"
+"Coordinates": array:2 [
0 => -79.8907745
1 => 43.3237656
]
+"Latitude": 43.3237656
+"Longitude": -79.8907745
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your dream home awaits in this custom-built 2705 sq ft masterpiece on a half-acre lot. Natural light floods the home through skylights, while the spacious family room features a stunning vaulted ceiling—perfect for both relaxing and entertaining. The sun-drenched kitchen, with wall-to-wall windows, brings the beauty of nature indoors as you cook and gather. Upstairs, retreat to the luxurious primary suite with a five-piece ensuite and dual walk-in closets. Two additional bedrooms and a stylish four-piece bath complete the second floor. The fully finished walkout basement offers versatility with an extra bedroom and full bathroom, ideal for guests or a home office. Outside, enjoy your private oasis with a sparkling pool, hot tub, and cozy campfire spot—perfect for evenings under the stars. This home blends modern comfort with thoughtful design, creating the perfect balance of indoor luxury and outdoor living. This is your chance to call this exquisite property your own. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Microwave"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T23:13:04.435790+00:00"
+"Directions": "See map for directions."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2216487"
+"ListOfficeKey": "296698"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.53"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T21:09:33Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T16:09:42Z"
+"Stories": "1.5"
+"StreetName": "SNAKE"
+"StreetNumber": "1962"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"TaxAnnualAmount": "7168.9"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=2sK4MXveabb"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29127642/1962-snake-road-burlington"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "Nec Dev Control Area"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 2705
+"OriginalEntryTimestamp": "2025-11-21T21:09:33.76Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29127642')"
+"ID": "436984"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25019
+post_id: "435678"
+post_author: 1
+"ListingKey": "29125383"
+"ListingId": "X12565450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T22:05:12Z"
+"RFModificationTimestamp": "2025-11-25T22:14:10Z"
+"ListPrice": 979000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "160 MILL STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.895992
1 => 43.337802
]
+"Latitude": 43.337802
+"Longitude": -79.895992
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 160 Mill St N, a charming 1.5-storey detached home set on a PREMIUM TREED 66 x 147 ft lot with In Ground Pool in the heart of Downtown Waterdown. Offering 2+1 bedrooms, 2 full bathrooms, a partially finished basement, and a detached 1.5 car garage, this property blends character, functionality, and space. The main floor features a large eat-in kitchen with walkout to the mudroom, a cozy living room with an electric fireplace, and a spacious family room with a gas fireplace, perfect for everyday living and entertaining. A beautifully updated 4-piece bathroom and main floor bedroom complete the level. Upstairs, the private primary retreat offers a generous walk-in closet and a stylish 3-piece ensuite, creating a serene space to unwind. A separate entrance from the backyard to the basement provides excellent potential for an in-law suite. With a large existing bedroom with an electric fireplace feature wall, the lower level is ready for your finishing touches. Step outside to your private backyard oasis, lined with mature trees and featuring a fully fenced in-ground pool, green space, a spacious deck, hot tub, and a storage shed. Enjoy all-day sun and a true retreat-like setting. Centrally located in Old Waterdown near top-rated schools, parks, trails, and every major amenity, this home combines small-town charm with unbeatable convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2025-11-21T15:52:11.397118+00:00"
+"Directions": "Cross Streets: John St E. ** Directions: Dundas St to Mill St."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:5 [
0 => "Forced air"
1 => "Not known"
2 => "Not known"
3 => "Electric"
4 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "286765"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "66.2 x 146.9 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T14:55:41Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T21:54:53Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "Mill"
+"StreetNumber": "160"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5200"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/160-mill-st-n-waterdown-on-l0r-2h0-20322421/branded"
+"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"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29125383/160-mill-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 66.2
+"OriginalEntryTimestamp": "2025-11-21T14:55:41.58Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29125383')"
+"ID": "435678"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25003
+post_id: "434141"
+post_author: 1
+"ListingKey": "29123661"
+"ListingId": "40789516"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T21:05:30Z"
+"RFModificationTimestamp": "2025-11-20T23:20:24Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2093.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "20 PENTLAND Road, Waterdown, Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.908762
1 => 43.320363
]
+"Latitude": 43.320363
+"Longitude": -79.908762
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity Knocks! Work from home in your own private space/sunroom addition with separate entrance and entry to main house! This amazing family 3+1 bedroom home is complete with a fully finished basement, hot tub, and large pie-shaped yard! Main floor features a living room/dining room combination, family room with electric fireplace (currently used as a dining room), laundry/mud room, and a large eat-in white kitchen with walk-out to large, gorgeous, private sunroom/workspace/second family room, with heated floors, overlooking the beautiful backyard, complete with hot tub, shed, and gazebo! Upper level features 3 large bedrooms, master ensuite, walk-in closet, and additional 4-piece bath. Bamboo flooring on main and second level. Basement features family room, home theatre/gym area, and separate bedroom with 2-piece bathroom. Double garage, cozy front porch, fenced yard, and great neighbours - what more could you ask for?! Located on a great family street in one of Waterdown's most desirable areas, and close to schools, parks, transit, shopping and highways, don't miss your opportunity to call this your new home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T23:20:05.875707+00:00"
+"Directions": "Dundas to Hollybush to Dalrymple to Pentland"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1389772"
+"ListOfficeKey": "294854"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T20:59:59Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T20:59:59Z"
+"Stories": "2.0"
+"StreetName": "PENTLAND"
+"StreetNumber": "20"
+"StreetSuffix": "Road"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5264.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29123661/20-pentland-road-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2093
+"OriginalEntryTimestamp": "2025-11-20T20:59:59.24Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29123661')"
+"ID": "434141"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23295
+post_id: "430991"
+post_author: 1
+"ListingKey": "29119294"
+"ListingId": "X12559530"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T13:40:58Z"
+"RFModificationTimestamp": "2025-11-24T13:45:36Z"
+"ListPrice": 964000.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.8915404
1 => 43.3312884
]
+"Latitude": 43.3312884
+"Longitude": -79.8915404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming 3+1 bedroom, 2-bathroom home in the heart of Waterdown's original village, perfectly positioned for both convenience and community living. Nestled in a mature, tree-lined neighbourhood, this bright and inviting home is just steps from downtown shops, restaurants, parks, and scenic trails, and only a 4-minute walk to Sealey Park. Commuters will appreciate the easy access to major highways and the Aldershot GO Station, just a 7-minute drive away. Inside, the home features a warm and functional layout filled with natural light. The large, bright finished basement offers an additional bedroom or flexible living space, complete with ample storage, making it ideal for guests, a home office, a playroom, or a cozy family room. Outside, enjoy the generous backyard, providing plenty of space to relax, entertain, or garden-perfect for families or anyone seeking a peaceful outdoor retreat. With excellent schools nearby and a vibrant, walkable village at your doorstep, this property is an outstanding opportunity for young families, downsizers, or anyone looking to enjoy the best of Waterdown living. Don't miss the opportunity to make this your next home! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T21:46:10.455324+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": "2025-11-19T20:33:31Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:24:25Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/75_flamboro_st_waterdown_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"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29119294/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2025-11-19T20:33:31.67Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29119294')"
+"ID": "430991"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25008
+post_id: "430661"
+post_author: 1
+"ListingKey": "29118904"
+"ListingId": "40788601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-23T21:45:47Z"
+"RFModificationTimestamp": "2025-11-23T21:46:56Z"
+"ListPrice": 964000.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.8912109
1 => 43.331207
]
+"Latitude": 43.331207
+"Longitude": -79.8912109
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming 3+1 bedroom, 2-bathroom home in the heart of Waterdown’s original village, perfectly positioned for both convenience and community living. Nestled in a mature, tree-lined neighbourhood, this bright and inviting home is just steps from downtown shops, restaurants, parks, and scenic trails, and only a 4-minute walk to Sealey Park. Commuters will appreciate the easy access to major highways and the Aldershot GO Station, just a 7-minute drive away. Inside, the home features a warm and functional layout filled with natural light. The large, bright finished basement offers an additional bedroom or flexible living space, complete with ample storage, making it ideal for guests, a home office, a playroom, or a cozy family room. Outside, enjoy the generous backyard, providing plenty of space to relax, entertain, or garden—perfect for families or anyone seeking a peaceful outdoor retreat. With excellent schools nearby and a vibrant, walkable village at your doorstep, this property is an outstanding opportunity for young families, downsizers, or anyone looking to enjoy the best of Waterdown living. Don't miss the opportunity to make this your next home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:55:08.825021+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": "2025-11-19T19:30:14Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-23T21:30:48Z"
+"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"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/75_flamboro_st_waterdown_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118904/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2025-11-19T19:30:13.92Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118904')"
+"ID": "430661"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24684
+post_id: "428063"
+post_author: 1
+"ListingKey": "29115808"
+"ListingId": "40789002"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T14:55:51Z"
+"RFModificationTimestamp": "2025-11-19T14:59:32Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1609.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "40 HAMILTON Street S Unit# 31, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8935382
1 => 43.3299256
]
+"Latitude": 43.3299256
+"Longitude": -79.8935382
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover this stunning executive townhome perfectly situated in the charming and vibrant community of Waterdown. With an unbeatable location, you’re just steps away from trendy shops, cozy cafés, restaurants, pubs and every convenience imaginable. Nature lovers will also appreciate being within walking distance of scenic trails and the breathtaking Smokey Hollow Waterfalls. Inside, this beautifully designed home features an open-concept main level complete with pot lighting, elegant granite countertops and luxury vinyl flooring. Step through the walkout to your spacious deck (with gas line for a BBQ) overlooking a tranquil ravine; the perfect backdrop for relaxing or entertaining. Upstairs, the primary bedroom offers a generous walk-in closet and a lovely ensuite, complemented by two additional bedrooms, a full main bath and the convenience of second-floor laundry. The bright, spacious basement with large windows is ready for your personal touch. Features the convenience of a car charger, easy access to the GO Train, Highways 407, 403 and 6, and just a short stroll to every amenity, this home truly has it all. Experience comfort, convenience and style — welcome home to St. Thomas Walk! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "421.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T23:58:28.606906+00:00"
+"Directions": "Dundas Street E to Hamilton Street S"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T14:41:16Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T14:41:16Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "5968.08"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=69637"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29115808/40-hamilton-street-s-unit-31-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"ZoningDescription": "R6-43, P5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1609
+"OriginalEntryTimestamp": "2025-11-18T22:30:26.64Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29115808')"
+"ID": "428063"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 97
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]
