array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30071803 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1653708"
+post_author: 1
+"ListingKey": "30071803"
+"ListingId": "40850115"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:23Z"
+"RFModificationTimestamp": "2026-07-26T20:38:32Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 1.003
+"LivingArea": 2556.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1K4"
+"UnparsedAddress": "19 CONCESSION 5 E, Waterdown, Ontario L8B1K4"
+"Coordinates": array:2 [
0 => -79.9427302
1 => 43.3326276
]
+"Latitude": 43.3326276
+"Longitude": -79.9427302
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on a private one-acre lot just six minutes from the heart of Waterdown, this 2500+ square foot custom built bungalow offers an ideal combination of space, comfort and versatility. With four-plus-one bedrooms total, the property is well suited for families, downsizers or multi-generational living. The main home is warm and inviting, featuring an updated kitchen, cozy gas fireplace, abundant natural light, renovated bathrooms and stylish new flooring, creating a seamless blend of modern finishes and rural charm. The spacious primary suite is a true retreat, complete with a walk-in closet, private ensuite and walkout to a secluded hot tub area—offering a quiet space to relax and unwind. Outside, the expansive lot provides exceptional privacy surrounded by nature, making it ideal for entertaining, gardening or enjoying peaceful country living. A rare and highly valuable feature is the fully self-sufficient 800 square foot, one-and-a-half storey detached ADU. It includes a functional main level with full kitchen plus a large bedroom with a four-piece bathroom, private laundry and carport. This thoughtfully designed space offers complete independence for extended family or guests, while keeping everyone close - delivering the best of both worlds. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:9 [
0 => "Refrigerator"
1 => "Water purifier"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:53:59.894020+00:00"
+"Directions": "HY6 & CONCESSION 5 E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Shared Driveway"
2 => "Country residential"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "1.003"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T20:31:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CONCESSION 5"
+"StreetNumber": "19"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "10610"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019f8a06-4f70-7315-9a6f-3eb01ace19ec"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1694098091"
"RoomType" => "3pc Bathroom"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
1 => array:11 [
"RoomKey" => "1694098092"
"RoomType" => "Utility room"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
2 => array:11 [
"RoomKey" => "1694098093"
"RoomType" => "Bedroom"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
3 => array:11 [
"RoomKey" => "1694098094"
"RoomType" => "Gym"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
4 => array:11 [
"RoomKey" => "1694098095"
"RoomType" => "Office"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
5 => array:11 [
"RoomKey" => "1694098096"
"RoomType" => "Recreation room"
"ListingId" => "40850115"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
6 => array:11 [
"RoomKey" => "1694098097"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
7 => array:11 [
"RoomKey" => "1694098098"
"RoomType" => "Bedroom"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
8 => array:11 [
"RoomKey" => "1694098099"
"RoomType" => "Bedroom"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "21'1'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.12Z"
]
9 => array:11 [
"RoomKey" => "1694098100"
"RoomType" => "Full bathroom"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
10 => array:11 [
"RoomKey" => "1694098101"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 22'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
11 => array:11 [
"RoomKey" => "1694098102"
"RoomType" => "Laundry room"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
12 => array:11 [
"RoomKey" => "1694098103"
"RoomType" => "Family room"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "21'5'' x 22'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
13 => array:11 [
"RoomKey" => "1694098104"
"RoomType" => "Breakfast"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
14 => array:11 [
"RoomKey" => "1694098105"
"RoomType" => "Kitchen"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
15 => array:11 [
"RoomKey" => "1694098106"
"RoomType" => "Dining room"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
16 => array:11 [
"RoomKey" => "1694098107"
"RoomType" => "Living room"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
17 => array:11 [
"RoomKey" => "1694098108"
"RoomType" => "Foyer"
"ListingId" => "40850115"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30071803"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-26T20:29:27.13Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30071803/19-concession-5-e-waterdown"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 145.0
+"AboveGradeFinishedArea": 2556
+"OriginalEntryTimestamp": "2026-07-23T18:38:33.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30071803_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/f5332a4c95a55caf6c66a697cf9ab835.webp"
"MediaSize" => 136882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-f5332a4c95a55caf6c66a697cf9ab835.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30071803_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/3613d627b55e502782332d8471f8a555.webp"
"MediaSize" => 128987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-3613d627b55e502782332d8471f8a555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30071803_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/d727f61879a7effbac99067b2aa87cd5.webp"
"MediaSize" => 130752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-d727f61879a7effbac99067b2aa87cd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30071803_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/a9def6704fdc4ab366091ec661c5e892.webp"
"MediaSize" => 137222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-a9def6704fdc4ab366091ec661c5e892.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30071803_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/e987029670b9f874a71bb6811a56b639.webp"
"MediaSize" => 53683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-e987029670b9f874a71bb6811a56b639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30071803_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/fa2c3311cac3c54c28f45fa402ef27c8.webp"
"MediaSize" => 80162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-fa2c3311cac3c54c28f45fa402ef27c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30071803_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/8f45c8e7913a5796bfeb0d03c8111024.webp"
"MediaSize" => 89994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-8f45c8e7913a5796bfeb0d03c8111024.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30071803_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/ad7b838cbdc3f828bdaa7fe4e27cca52.webp"
"MediaSize" => 81443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-ad7b838cbdc3f828bdaa7fe4e27cca52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30071803_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/9c710407df4246b4aeb6c3b883e765e8.webp"
"MediaSize" => 69317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-9c710407df4246b4aeb6c3b883e765e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30071803_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/529c14ab7f6ccc89466dfe0d787d0a6d.webp"
"MediaSize" => 60347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-529c14ab7f6ccc89466dfe0d787d0a6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30071803_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/64c01abcf3137874ba64ba6fd69fb420.webp"
"MediaSize" => 65453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-64c01abcf3137874ba64ba6fd69fb420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30071803_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/2a09d72451e85f43cecf36108359fe50.webp"
"MediaSize" => 65412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-2a09d72451e85f43cecf36108359fe50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30071803_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/d12ef96b1997c881672b0218c8e6cff5.webp"
"MediaSize" => 76778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-d12ef96b1997c881672b0218c8e6cff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30071803_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/88142ffaa22bb7aa5162cb0e0d0826c7.webp"
"MediaSize" => 59977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-88142ffaa22bb7aa5162cb0e0d0826c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30071803_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/64a128447b352faa136e724358c1c80b.webp"
"MediaSize" => 83296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-64a128447b352faa136e724358c1c80b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30071803_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/f6a8dbb482a98b8b1584b69f40a0ae39.webp"
"MediaSize" => 65586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-f6a8dbb482a98b8b1584b69f40a0ae39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30071803_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/ed66f80b2e01f1f50a5084a178f7e289.webp"
"MediaSize" => 51492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-ed66f80b2e01f1f50a5084a178f7e289.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30071803_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/2a4efc12cd9cbc7eb824a02b53a2802d.webp"
"MediaSize" => 65104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-2a4efc12cd9cbc7eb824a02b53a2802d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30071803_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/f2f389a20f5ff976aa1a8f51f54215e5.webp"
"MediaSize" => 59358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-f2f389a20f5ff976aa1a8f51f54215e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30071803_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/193613c2d6ca04cc2dde0c5d6f66c31d.webp"
"MediaSize" => 55719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-193613c2d6ca04cc2dde0c5d6f66c31d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30071803_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/8e0a6f938fa883ebb1a69df703b8c4ef.webp"
"MediaSize" => 60700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-8e0a6f938fa883ebb1a69df703b8c4ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30071803_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/3830b6e889381c155c7535a5b27a6448.webp"
"MediaSize" => 45067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-3830b6e889381c155c7535a5b27a6448.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30071803_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/358543bd70fbbb6aade3d6c3dbf29b1b.webp"
"MediaSize" => 79369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-358543bd70fbbb6aade3d6c3dbf29b1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30071803_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/6e6954817730408715cce32406b6c4b4.webp"
"MediaSize" => 60705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-6e6954817730408715cce32406b6c4b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30071803_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/9e7d5a37ef4cf7119e877eed2be3e390.webp"
"MediaSize" => 52011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-9e7d5a37ef4cf7119e877eed2be3e390.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30071803_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/65e52f5d8e953a9cfea7daa2ee4d0421.webp"
"MediaSize" => 68167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-65e52f5d8e953a9cfea7daa2ee4d0421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30071803_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/03b7ffee394b139adb24e7a7472c1107.webp"
"MediaSize" => 52011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-03b7ffee394b139adb24e7a7472c1107.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30071803_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/288d9211aa88e63ddfb657da44b92412.webp"
"MediaSize" => 54479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-288d9211aa88e63ddfb657da44b92412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30071803_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/7cdee1cb8685946db1556a5c473ca5dc.webp"
"MediaSize" => 83485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-7cdee1cb8685946db1556a5c473ca5dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30071803_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/e03264f70731a5ce3e25df39dab8ac40.webp"
"MediaSize" => 69018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-e03264f70731a5ce3e25df39dab8ac40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30071803_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/05fb00015da52985be7bbb604c4f8300.webp"
"MediaSize" => 70763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-05fb00015da52985be7bbb604c4f8300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30071803_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/df0b9159a9d21c8b68235cd0815a4c05.webp"
"MediaSize" => 50632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-df0b9159a9d21c8b68235cd0815a4c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30071803_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/fcd0f1b74a49fcddddd65660478e7dc3.webp"
"MediaSize" => 52909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-fcd0f1b74a49fcddddd65660478e7dc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30071803_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/55a45ce3b0975ada133dcb537efe4550.webp"
"MediaSize" => 56627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-55a45ce3b0975ada133dcb537efe4550.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30071803_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/747f3f6e714cead409812186e8831bcb.webp"
"MediaSize" => 135526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-747f3f6e714cead409812186e8831bcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30071803_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/9e565d0b4a589ceb55d1167871c7826d.webp"
"MediaSize" => 81356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-9e565d0b4a589ceb55d1167871c7826d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30071803_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/2e8744063afd837790ee17303cb7637c.webp"
"MediaSize" => 83226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-2e8744063afd837790ee17303cb7637c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30071803_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/f902dc560da682bdce27b229de7c3f4b.webp"
"MediaSize" => 77109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-f902dc560da682bdce27b229de7c3f4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30071803_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/533774252a0f0b31fb15b9c34aee0870.webp"
"MediaSize" => 49686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-533774252a0f0b31fb15b9c34aee0870.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30071803_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/7cdf4b64baff193a9564e82c2a02d585.webp"
"MediaSize" => 57587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-7cdf4b64baff193a9564e82c2a02d585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30071803_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/21e14519cd5a5ecc4c06804eb40002aa.webp"
"MediaSize" => 78654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-21e14519cd5a5ecc4c06804eb40002aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30071803_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/5994215a0ccc34618c393df224609813.webp"
"MediaSize" => 52795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-5994215a0ccc34618c393df224609813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30071803_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/838626a48416f2f44c336f6bba1aee94.webp"
"MediaSize" => 161270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-838626a48416f2f44c336f6bba1aee94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30071803_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/e060a5d538a38f06534e75da33891610.webp"
"MediaSize" => 137772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-e060a5d538a38f06534e75da33891610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30071803_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/c3754ff777841b57b59692863ac15de5.webp"
"MediaSize" => 117534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-c3754ff777841b57b59692863ac15de5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30071803_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/7d672fb648c302f50476614b36e1396d.webp"
"MediaSize" => 109970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071803/thumbnail-7d672fb648c302f50476614b36e1396d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850115"
"ResourceRecordKey" => "30071803"
"ModificationTimestamp" => "2026-07-23T18:38:33.58Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30071803_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071803/9c4426e6bb1b22d590f629768bbc3870.webp"
"MediaSize" => 147707
…9
]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071803')"
+"ID": "1653708"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25103
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25046
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-689-9223"
+"OfficeMlsId": "HBRMXESCDUND"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293261"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#1B-493 Dundas Street E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterdown"
+"OfficePostalCode": "L0R2H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1424570"
+"OriginalEntryTimestamp": "2022-09-12T18:20:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293261')"
}
]
+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 1525426" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25126
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30071803'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25439
+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 '30071803' AND OpenHouseDate ge '2026-07-26'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25454
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25455
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32155675"
+"ListingKey": "30071803"
+"ListingId": "40850115"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-26"
+"OpenHouseStartTime": "2026-07-26T14:00:00Z"
+"OpenHouseEndTime": "2026-07-26T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-25T16:38:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32155675')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32179803"
+"ListingKey": "30071803"
+"ListingId": "40850115"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-26"
+"OpenHouseStartTime": "2026-07-26T14:00:00Z"
+"OpenHouseEndTime": "2026-07-26T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-26T18:58:53Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32179803')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30071803' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9427302 43.3326276)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25530
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25524
+post_id: "1658049"
+post_author: 1
+"ListingKey": "30077575"
+"ListingId": "X13604092"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T20:45:04Z"
+"RFModificationTimestamp": "2026-07-24T23:04:00Z"
+"ListPrice": 1075000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1K5"
+"UnparsedAddress": "162 5TH CONCESSION ROAD E, Hamilton, Ontario L8B1K5"
+"Coordinates": array:2 [
0 => -79.9298098
1 => 43.3413288
]
+"Latitude": 43.3413288
+"Longitude": -79.9298098
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautifully kept country home set just minutes from Waterdown and its full range of amenities. This charming two-storey residence blends character, comfort, and rare rural conveniences like natural gas and high-speed internet. Warm natural wood and gumwood trim frame the main floor, complemented by cared-for hardwood floors and a kitchen featuring a pantry, peninsula, gas stove, and a generous eating area. A handy main-floor 2-piece bath adds everyday practicality. Upstairs, two bright bedrooms are paired with a renovated 3-piece bath showcasing a large shower, updated vanity, and modern fixtures. The property includes a 24' x 32' double garage, ideal for vehicles, hobbies, or storage. Set on 2.92 acres, the property offers a park-like setting perfect for kids, pets, gatherings, or quiet enjoyment. The location is exceptional-East Flamborough, close to golf courses, minutes to many horse facilities, and just a short drive to a dog park, soccer fields, baseball diamonds, arenas, scenic hiking and biking trails and various Conservation areas. For commuters, highway access is quick and convenient. Whether enjoyed as-is, expanded, or considered as a potential estate building lot (subject to Conservation Authority review), this is a rare opportunity to secure a solid country home in a premium location. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T23:03:54.891283+00:00"
+"Directions": "Cross Streets: HIGHWAY 6. ** Directions: HWY 6 OR CENTRE RD TO 5TH CONC RD EAST. WEST FROM CENTRE RD."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080849"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Sloping"
2 => "Conservation/green belt"
3 => "Level"
]
+"LotSizeDimensions": "135 x 942 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T20:39:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T20:39:22Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "5TH CONCESSION"
+"StreetNumber": "162"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7220.19"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30077575/162-5th-concession-road-e-hamilton-rural-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 135.0
+"OriginalEntryTimestamp": "2026-07-24T20:39:22.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355767"
+"ListOfficeNationalAssociationId": "1243249"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077575')"
+"ID": "1658049"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25526
+post_id: "1657261"
+post_author: 1
+"ListingKey": "30077107"
+"ListingId": "40849326"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T13:50:00Z"
+"RFModificationTimestamp": "2026-07-26T13:53:42Z"
+"ListPrice": 1075000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.92
+"LivingArea": 1150.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L0R2H1"
+"UnparsedAddress": "162 5TH CONC Road E, Flamborough, Ontario L0R2H1"
+"Coordinates": array:2 [
0 => -79.9367712
1 => 43.3360493
]
+"Latitude": 43.3360493
+"Longitude": -79.9367712
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A beautifully kept country home set just minutes from Waterdown and its full range of amenities. This charming two-storey residence blends character, comfort, and rare rural conveniences like natural gas and high-speed internet. Warm natural wood and gumwood trim frame the main floor, complemented by cared-for hardwood floors and a kitchen featuring a pantry, peninsula, gas stove, and a generous eating area. A handy main-floor 2-piece bath adds everyday practicality. Upstairs, two bright bedrooms are paired with a renovated 3-piece bath showcasing a large shower, updated vanity, and modern fixtures. The property includes a 24' x 32' double garage, ideal for vehicles, hobbies, or storage. Set on 2.92 acres, the property offers a park-like setting perfect for kids, pets, gatherings, or quiet enjoyment. The location is exceptional—East Flamborough, close to golf courses, minutes to many horse facilities, and just a short drive to a dog park, soccer fields, baseball diamonds, arenas, scenic hiking and biking trails and various Conservation areas. For commuters, highway access is quick and convenient. Whether enjoyed as-is, expanded, or considered as a potential estate building lot (subject to Conservation Authority review), this is a rare opportunity to secure a solid country home in a premium location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:54:29.214398+00:00"
+"Directions": "HWY 6 OR CENTRE RD TO THE 5TH CONC RD EAST. WEST FROM CENTRE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "2.92"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-26T13:41:29Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T13:41:29Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "5TH CONC"
+"StreetNumber": "162"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "7220.19"
+"VirtualTourURLUnbranded": "https://youriguide.com/162_concession_5_rd_e_hamilton_on/"
+"WaterSource": array:1 [
0 => "Well"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30077107/162-5th-conc-road-e-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1525315"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1677992"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 1150
+"OriginalEntryTimestamp": "2026-07-24T19:29:40.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063775"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1089333"
+"CoListAgentNationalAssociationId2": "1171967"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077107')"
+"ID": "1657261"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25523
+post_id: "1656257"
+post_author: 1
+"ListingKey": "30074545"
+"ListingId": "40850829"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T13:45:03Z"
+"RFModificationTimestamp": "2026-07-24T17:30:08Z"
+"ListPrice": 817900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1707.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T5"
+"UnparsedAddress": "28 MCCURDY Avenue, Waterdown, Ontario L8B0T5"
+"Coordinates": array:2 [
0 => -79.9222125
1 => 43.3293489
]
+"Latitude": 43.3293489
+"Longitude": -79.9222125
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "New Construction! Backing onto the newly constructed Clear Skies Park, this end unit townhome is starting construction and will be available to move in early 2027. Featuring over 1,707 sq ft, 3 bedrooms, 2.5 baths, this home is spacious and offers ample room for a growing family. The main floor boasts a large great room and chef's kitchen, perfect for entertaining. The second level has 3 bedrooms including a large master bedroom with ensuite. There is still time to choose your own finishings! Don't miss out, this home will sell fast. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T17:30:00.194229+00:00"
+"Directions": "Sadie Lou Blvd & McCurdy Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523872"
+"ListOfficeKey": "54955"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T13:38:19Z"
+"PhotosCount": 4
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T13:38:19Z"
+"Stories": "2.0"
+"StreetName": "MCCURDY"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30074545/28-mccurdy-avenue-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1707
+"OriginalEntryTimestamp": "2026-07-24T13:38:19.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1063819"
+"ListOfficeNationalAssociationId": "1003569"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30074545')"
+"ID": "1656257"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25527
+post_id: "1653706"
+post_author: 1
+"ListingKey": "30069107"
+"ListingId": "40850435"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T01:10:03Z"
+"RFModificationTimestamp": "2026-07-25T01:19:40Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2022.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T3"
+"UnparsedAddress": "4 BOUSFIELD Court, Waterdown, Ontario L8B0T3"
+"Coordinates": array:2 [
0 => -79.9200053
1 => 43.3269474
]
+"Latitude": 43.3269474
+"Longitude": -79.9200053
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 4 Bousfield Court! Nestled on a cult de sac next to a pond. This beautifully updated 3-bedroom, 3-bath home offers luxury and privacy in one of Waterdown's most desirable neighbourhoods. The open-concept main floor is enhanced by rich hardwood flooring, custom lighting, and impressive coffered ceilings, a chef-inspired kitchen with granite countertops, gas stove and plenty of storage . Upstairs, the spacious primary suite offers a spa-like ensuite with heated honed marble floors, soaker tub and marble shower. Step outside to your professionally landscaped backyard complete with a pond, gazebo, and lush greenery. Additional highlights include an on-demand hot water system, 2nd floor laundry room with overflow drain, EV charger plug, and numerous updates throughout. Close to parks, schools, shopping, and commuter routes, this move-in-ready home truly has it all. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:57:19.869705+00:00"
+"Directions": "Parkside to Sadielou to Gundy to Bousfield"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917243"
+"ListOfficeKey": "264845"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T01:00:24Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T01:08:27Z"
+"Stories": "2.0"
+"StreetName": "BOUSFIELD"
+"StreetNumber": "4"
+"StreetSuffix": "Court"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7799"
+"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/30069107/4-bousfield-court-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2022
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-23T11:48:33.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1225588"
+"ListOfficeNationalAssociationId": "1225289"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069107')"
+"ID": "1653706"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25525
+post_id: "1653709"
+post_author: 1
+"ListingKey": "30071835"
+"ListingId": "X13598914"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T12:15:19Z"
+"RFModificationTimestamp": "2026-07-26T12:16:19Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1K4"
+"UnparsedAddress": "19 CONCESSION 5 E, Hamilton, Ontario L8B1K4"
+"Coordinates": array:2 [
0 => -79.942719
1 => 43.332634
]
+"Latitude": 43.332634
+"Longitude": -79.942719
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a private one-acre lot just six minutes from the heart of Waterdown, this 2500+ square foot custom built bungalow offers an ideal combination of space, comfort and versatility. With four-plus-one bedrooms total, the property is well suited for families, downsizers or multi-generational living. The main home is warm and inviting, featuring an updated kitchen, cozy gas fireplace, abundant natural light, renovated bathrooms and stylish new flooring, creating a seamless blend of modern finishes and rural charm. The spacious primary suite is a true retreat, complete with a walk-in closet, private ensuite and walkout to a secluded hot tub area-offering a quiet space to relax and unwind. Outside, the expansive lot provides exceptional privacy surrounded by nature, making it ideal for entertaining, gardening or enjoying peaceful country living. A rare and highly valuable feature is the fully self-sufficient 800 square foot, one-and-a-half storey detached ADU. It includes a functional main level with full kitchen plus a large bedroom with a four-piece bathroom, private laundry and carport. This thoughtfully designed space offers complete independence for extended family or guests, while keeping everyone close - delivering the best of both worlds. RSA. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:51:53.474845+00:00"
+"Directions": "Hwy 6 & Concession 5 E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Sump Pump"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "145 x 300 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T18:40:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T12:08:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Concession 5"
+"StreetNumber": "19"
+"TaxAnnualAmount": "10610"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019f8a06-4f70-7315-9a6f-3eb01ace19ec"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071835/19-concession-5-e-hamilton-rural-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 145.0
+"OriginalEntryTimestamp": "2026-07-23T18:40:15.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071835')"
+"ID": "1653709"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25520
+post_id: "1652191"
+post_author: 1
+"ListingKey": "30070596"
+"ListingId": "X13597778"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T19:45:03Z"
+"RFModificationTimestamp": "2026-07-24T19:53:40Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0L5"
+"UnparsedAddress": "420 CONCESSION 5 ROAD W, Hamilton, Ontario L8B0L5"
+"Coordinates": array:2 [
0 => -79.965365
1 => 43.334516
]
+"Latitude": 43.334516
+"Longitude": -79.965365
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 420 Concession Road 5 West! This beautiful raised bungalow is nestled on just under an acre of property. Featuring 3 Bedrooms, 2Bathrooms, and double car garage this home offers the perfect blend of comfort, space, and scenic beauty. The main level of this home offers a formal living room with strip hardwood, and beautiful front yard view, a spacious dining area adjacent to your eat-in kitchen area with maple cabinetry, and ample counter space. With an ideal layout this space is perfect for quiet family dinners, or a night of entertaining with an upper level balcony perfect for your morning coffee or a glass of wine at sunset. The main floor also features three spacious bedrooms all with double closets, and strip hardwood. The main 4 piece bath features an oversized vanity, shower/tub combination and is bright and functional.Downstairs, you'll find a cozy hosting area complete with a fireplace, perfect for gathering with family and friends. The convenient walk-out leads directly to the expansive backyard, offering ample room for yard games, gardening, or unwinding around a bonfire. The basement set up is perfect for additional recreation space, or make your own with a bonus bedroom! The large backyard offers ample space for activities, or to build your own dream workshop! Enjoy breathtaking sunsets and a peaceful backdrop of a neighbouring Christmas tree farm-this property delivers a tranquil rural lifestyle just waiting to be enjoyed. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:35:21.876362+00:00"
+"Directions": "Block Road & Concession 5 W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "302161"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "100 x 320 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T19:38:39Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T19:38:39Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "Concession 5"
+"StreetNumber": "420"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5111"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/420-concession-5-w-waterdown-on-l8b-0l5-24746939/branded"
+"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": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30070596/420-concession-5-road-w-hamilton-rural-flamborough"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-07-23T16:12:42.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246196"
+"ListOfficeNationalAssociationId": "1499250"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070596')"
+"ID": "1652191"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1638661"
+post_author: 1
+"ListingKey": "29940346"
+"ListingId": "X13477484"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T02:20:03Z"
+"RFModificationTimestamp": "2026-07-18T02:31:55Z"
+"ListPrice": 814900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "58 BORERS CREEK CIRCLE, Hamilton (Waterdown), Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.918335
1 => 43.332459
]
+"Latitude": 43.332459
+"Longitude": -79.918335
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional freehold townhome in one of Waterdown's most scenic, family-friendly communities. Perfectly positioned overlooking a tranquil pond and expansive greenspace, this beautifully maintained 3-storey home offers a rare blend of nature, space, and convenience. Surrounded by the picturesque Rockcliffe and Bruce Trails, enjoy stunning views, vibrant sunsets, and a peaceful setting right outside your door. Filled with natural light, this modern home features generous living space, 9-foot ceilings, an upgraded staircase and four private balconies designed to fully capture the breathtaking surroundings. An on-grade family room extends the living space, offering a comfortable retreat with a walkout to the backyard, ideal for relaxing or entertaining. The stylish kitchen showcases stone countertops, stainless-steel appliances, and a bright breakfast area with a walkout to a balcony overlooking the pond and green space. The primary bedroom includes a 3-piece en suite, while two additional spacious bedrooms and a well-appointed 4-piece bathroom complete the upper level. The unspoiled full basement is waiting for your personal touches, and there's also an entry to the garage from the family room level. Enjoy a low-maintenance lifestyle surrounded by nature while remaining close to schools, parks, Grindstone Creek, shopping, dining, and major highways. A rare opportunity to enjoy modern living in an exceptional natural setting. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T02:31:53.053836+00:00"
+"Directions": "Cross Streets: N Waterdown Dr & Mosaic Dr. ** Directions: N Waterdown Dr - Mosaic Dr - Borers Creek Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1411736"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Backs on greenbelt"
2 => "Flat site"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "18 x 73.8 FT"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-23T12:17:49Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T02:08:09Z"
+"Stories": "3.0"
+"StreetName": "Borers Creek"
+"StreetNumber": "58"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "5644"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29940346/58-borers-creek-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R6-38"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-23T12:17:48.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281029"
+"ListOfficeNationalAssociationId": "1328651"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 33
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940346')"
+"ID": "1638661"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25528
+post_id: "1637895"
+post_author: 1
+"ListingKey": "30041024"
+"ListingId": "40848417"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T19:00:05Z"
+"RFModificationTimestamp": "2026-07-22T19:01:33Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1617.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T4"
+"UnparsedAddress": "80 BOUSFIELD Rise, Waterdown, Ontario L8B0T4"
+"Coordinates": array:2 [
0 => -79.921961
1 => 43.3281576
]
+"Latitude": 43.3281576
+"Longitude": -79.921961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stylish, move-in ready, and perfectly located, this beautifully renovated freehold townhouse offers the ideal balance of modern living and everyday convenience in the heart of Waterdown. Featuring 3 bedrooms, 2.5 bathrooms, and a bright open-concept layout with high ceilings, this home is thoughtfully designed to maximize both space and natural light. The updated interior blends contemporary finishes with functional living, while the fully finished basement provides flexible space for a family room, home office, fitness area, or guest room. Step outside to a raised deck overlooking your private backyard, an inviting space to entertain, relax, or enjoy warm summer evenings. Complete with an attached garage, this home checks all the boxes. Situated just a short walk to downtown Waterdown, you'll enjoy easy access to local cafe's, restaurants, boutique shopping, parks, trails, and everyday amenities, making it easy to embrace the community's vibrant small-town atmosphere. Perfect for first-time buyers, young families, downsizers, or investors, this exceptional freehold townhouse offers a rare opportunity to enjoy turnkey living in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:26:27.403595+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T18:52:32Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T18:59:27Z"
+"Stories": "2.0"
+"StreetName": "BOUSFIELD"
+"StreetNumber": "80"
+"StreetSuffix": "Rise"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5394.8"
+"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/30041024/80-bousfield-rise-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-22"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1617
+"OriginalEntryTimestamp": "2026-07-16T14:18:20.58Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204077"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30041024')"
+"ID": "1637895"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25529
+post_id: "1632116"
+post_author: 1
+"ListingKey": "30042688"
+"ListingId": "X13572206"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T12:20:14Z"
+"RFModificationTimestamp": "2026-07-20T12:23:25Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 3
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T4"
+"UnparsedAddress": "80 BOUSFIELD RISE, Hamilton (Waterdown), Ontario L8B0T4"
+"Coordinates": array:2 [
0 => -79.9219751
1 => 43.3281623
]
+"Latitude": 43.3281623
+"Longitude": -79.9219751
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish, move-in ready, and perfectly located, this beautifully renovated freehold townhouse offers the ideal balance of modern living and everyday convenience in the heart of Waterdown. Featuring 3 bedrooms, 2.5 bathrooms, and a bright open-concept layout with high ceilings, this home is thoughtfully designed to maximize both space and natural light. The updated interior blends contemporary finishes with functional living, while the fully finished basement provides flexible space for a family room, home office, fitness area, or guest room. Step outside to a raised deck overlooking your private backyard, an inviting space to entertain, relax, or enjoy warm summer evenings. Complete with an attached garage, this home checks all the boxes. Situated just a short walk to downtown Waterdown, you'll enjoy easy access to local cafe's, restaurants, boutique shopping, parks, trails, and everyday amenities, making it easy to embrace the community's vibrant small-town atmosphere. Perfect for first-time buyers, young families, downsizers, or investors, this exceptional freehold townhouse offers a rare opportunity to enjoy turnkey living in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 3
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T19:25:54.305322+00:00"
+"Directions": "Cross Streets: Parkside Drive. ** Directions: Parkside Drive To Sadielou Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "23 x 85.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:39:39Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T12:11:26Z"
+"Stories": "2.0"
+"StreetName": "Bousfield"
+"StreetNumber": "80"
+"StreetSuffix": "Rise"
+"TaxAnnualAmount": "5394.8"
+"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/30042688/80-bousfield-rise-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 23.0
+"OriginalEntryTimestamp": "2026-07-16T17:10:02.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355945"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042688')"
+"ID": "1632116"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 12
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]