array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29060037/Property?$select=ALL&$top=20&$filter=ListingKey eq 29060037&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29060037/Property?$select=ALL&$top=20&$filter=ListingKey eq 29060037&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23276
+post_id: "382727"
+post_author: 1
+"ListingKey": "29060037"
+"ListingId": "X12502326"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-03T19:50:50Z"
+"RFModificationTimestamp": "2025-11-03T19:51:25Z"
+"ListPrice": 1395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S5"
+"UnparsedAddress": "24 MACBEAN CRESCENT, Hamilton (Waterdown), Ontario L8B0S5"
+"Coordinates": array:2 [
0 => -79.9148351
1 => 43.3358708
]
+"Latitude": 43.3358708
+"Longitude": -79.9148351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 24 Macbean Crescent where elegance meets sophistication, a testament to the ultimate design in every detail. This meticulously maintained 2 Storey home with a gorgeous exterior facade and a double car garage will have you falling in love, not to mention the professionally installed stamped concrete front porch and steps (2021). Over 3000 sq ft of finished living space, 4 spacious bedrooms, 5 updated bathrooms, it truly offers all that you desire! As you enter the home through the upgraded front entrance door (2020), you will appreciate the bright and open foyer with lovely floor tiles (2019) and custom built in cabinets. Next is the luxurious living room, the shiny and bright pot lights that complement the coffered ceilings so seamlessly to the opulent brick veneer wall (2022) and custom built in cabinetry for those memorable family photos. Let's make our way to the exquisite kitchen (2019) with gorgeous cabinetry and cedar stone countertops to add that unique touch. With newer appliances, stylish fixtures, an oversized kitchen island and large sliding doors that lead to the backyard, what more could you ask for? Speaking of the backyard, check that oasis out. Some notable features are the canopy awning (2023) and the exposed aggregate concrete (2023). As we head upstairs you will appreciate that the carpets have been removed & replaced with newer flooring in all the bedrooms. There are 4 spacious bedrooms & 3 bathrooms. Two of the bedrooms have updated ensuites. The primary bedroom has a huge walk-in closet and a 5pc ensuite! All the bedrooms have CUSTOM closet organizers (2023) that were specifically designed for each closet. WOW! The finished basement (2019) provides a kitchenette, a 3-pc bathroom, family area for those get-togethers, and a spacious room that could be used as a gym or office, you decide! This beautiful home is within steps to the conservation area and parks. All other amenities are conveniently located near you. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-03T18:36:21.975234+00:00"
+"Directions": "Cross Streets: Macbean & Nisbet. ** Directions: PARKSIDE DR., WINBERLEY AVE, NISBET BLVD, MACBEAN."
+"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": "2238085"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 88.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-03T18:12:42Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-03T19:35:23Z"
+"Stories": "2.0"
+"StreetName": "Macbean"
+"StreetNumber": "24"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8735.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1529311904"
"RoomType" => "Foyer"
"ListingId" => "X12502326"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29060037"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.5Z"
]
1 => array:11 [
"RoomKey" => "1529311905"
"RoomType" => "Other"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 2.34
"ListingKey" => "29060037"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.5Z"
]
2 => array:11 [
"RoomKey" => "1529311906"
"RoomType" => "Bathroom"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 2.36
"ListingKey" => "29060037"
"RoomLength" => 2.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.5Z"
]
3 => array:11 [
"RoomKey" => "1529311907"
"RoomType" => "Kitchen"
"ListingId" => "X12502326"
"RoomLevel" => "Basement"
"RoomWidth" => 3.4
"ListingKey" => "29060037"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
4 => array:11 [
"RoomKey" => "1529311908"
"RoomType" => "Bathroom"
"ListingId" => "X12502326"
"RoomLevel" => "Basement"
"RoomWidth" => 1.24
"ListingKey" => "29060037"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
5 => array:11 [
"RoomKey" => "1529311909"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12502326"
"RoomLevel" => "Basement"
"RoomWidth" => 4.39
"ListingKey" => "29060037"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
6 => array:11 [
"RoomKey" => "1529311910"
"RoomType" => "Exercise room"
"ListingId" => "X12502326"
"RoomLevel" => "Basement"
"RoomWidth" => 4.52
"ListingKey" => "29060037"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
7 => array:11 [
"RoomKey" => "1529311911"
"RoomType" => "Other"
"ListingId" => "X12502326"
"RoomLevel" => "Basement"
"RoomWidth" => 2.95
"ListingKey" => "29060037"
"RoomLength" => 6.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
8 => array:11 [
"RoomKey" => "1529311912"
"RoomType" => "Dining room"
"ListingId" => "X12502326"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29060037"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
9 => array:11 [
"RoomKey" => "1529311913"
"RoomType" => "Kitchen"
"ListingId" => "X12502326"
"RoomLevel" => "Main level"
"RoomWidth" => 5.18
"ListingKey" => "29060037"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
10 => array:11 [
"RoomKey" => "1529311914"
"RoomType" => "Living room"
"ListingId" => "X12502326"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29060037"
"RoomLength" => 5.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
11 => array:11 [
"RoomKey" => "1529311915"
"RoomType" => "Bathroom"
"ListingId" => "X12502326"
"RoomLevel" => "Main level"
"RoomWidth" => 1.3
"ListingKey" => "29060037"
"RoomLength" => 1.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
12 => array:11 [
"RoomKey" => "1529311916"
"RoomType" => "Bedroom"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29060037"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
13 => array:11 [
"RoomKey" => "1529311917"
"RoomType" => "Bedroom 2"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 3.73
"ListingKey" => "29060037"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
14 => array:11 [
"RoomKey" => "1529311918"
"RoomType" => "Bedroom 3"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29060037"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
15 => array:11 [
"RoomKey" => "1529311919"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29060037"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
16 => array:11 [
"RoomKey" => "1529311920"
"RoomType" => "Bathroom"
"ListingId" => "X12502326"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29060037"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-03T19:35:23.51Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29060037/24-macbean-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2025-11-03T17:02:07.75Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6294546376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/a43e3bd9e1c6a682ee22e30366ce5d39.webp"
"MediaSize" => 129666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-a43e3bd9e1c6a682ee22e30366ce5d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6294546464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/a8888f0bf8ad4050dd6ef7bb271eff41.webp"
"MediaSize" => 157926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-a8888f0bf8ad4050dd6ef7bb271eff41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6294546557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/493ea71cac6d5c37a815dcb2473309ca.webp"
"MediaSize" => 147773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-493ea71cac6d5c37a815dcb2473309ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6294546696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/1732949731a1ebc759105575d76d9709.webp"
"MediaSize" => 67738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-1732949731a1ebc759105575d76d9709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6294546745"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/cf76070279d44471c966ed22c7ab8704.webp"
"MediaSize" => 55470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-cf76070279d44471c966ed22c7ab8704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6294546793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/c6d384b742af819996edc1320b6caf68.webp"
"MediaSize" => 97722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-c6d384b742af819996edc1320b6caf68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6294546909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/2e526f5af9787690c265dd4af9912354.webp"
"MediaSize" => 84721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-2e526f5af9787690c265dd4af9912354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6294547005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/5a4548f08295844652790a98fa5e6f55.webp"
"MediaSize" => 79294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-5a4548f08295844652790a98fa5e6f55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6294547080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/d1fe7689c39a965e8c9f42a7e627fea2.webp"
"MediaSize" => 54619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-d1fe7689c39a965e8c9f42a7e627fea2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6294547196"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/03d5ed250dc8abcebdb5debd302642ab.webp"
"MediaSize" => 56651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-03d5ed250dc8abcebdb5debd302642ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6294547280"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/36b539b0b5a78e88f3c17b6955f165c8.webp"
"MediaSize" => 80438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-36b539b0b5a78e88f3c17b6955f165c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6294547308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/70a81bccec428c868a53d2c2e42037d6.webp"
"MediaSize" => 74700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-70a81bccec428c868a53d2c2e42037d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6294547425"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/4ea3d94c70c4360596fbef3e14bc83a4.webp"
"MediaSize" => 73619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-4ea3d94c70c4360596fbef3e14bc83a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6294547469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/66993ed63eca6ee63e83edfe7db9ec38.webp"
"MediaSize" => 64661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-66993ed63eca6ee63e83edfe7db9ec38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6294547554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/abdcd70a533a98aab16f435e02240817.webp"
"MediaSize" => 81092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-abdcd70a533a98aab16f435e02240817.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6294547642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/b183e8e904594e9d70fd815a0c259b19.webp"
"MediaSize" => 76589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-b183e8e904594e9d70fd815a0c259b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6294547720"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/7b2ae9a184f0021d1eb2d40a0e4f5376.webp"
"MediaSize" => 106762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-7b2ae9a184f0021d1eb2d40a0e4f5376.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6294547762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/981e9296d9cb1c8f8cb595391d8dec84.webp"
"MediaSize" => 102035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-981e9296d9cb1c8f8cb595391d8dec84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6294547820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/a6da5b96abb2cd21650787e75a41b7f1.webp"
"MediaSize" => 92353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-a6da5b96abb2cd21650787e75a41b7f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6294547852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/1a1d8a8e6fe70451f6dd86b489f058a9.webp"
"MediaSize" => 67882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-1a1d8a8e6fe70451f6dd86b489f058a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6294547914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/e04ae348e091af60afffe9647dc3386d.webp"
"MediaSize" => 60736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-e04ae348e091af60afffe9647dc3386d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:38.11Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6294547939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/86ce5c1a0a02dcc837dea55ff2487b58.webp"
"MediaSize" => 83734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-86ce5c1a0a02dcc837dea55ff2487b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:41.48Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6294547996"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/35c9e5fab7e3de12c0bb7e50e3b380fc.webp"
"MediaSize" => 81159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-35c9e5fab7e3de12c0bb7e50e3b380fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:42.4Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6294548046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/7f6d8febeab85ba3dd00eb3878071c32.webp"
"MediaSize" => 75617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-7f6d8febeab85ba3dd00eb3878071c32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:42.55Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6294548088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/4fd12dfca969e52f6ccb8364999f039d.webp"
"MediaSize" => 114497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-4fd12dfca969e52f6ccb8364999f039d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:37.53Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6294548178"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/bffe3f0cccfa9fce628ae748f757cbe0.webp"
"MediaSize" => 64831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-bffe3f0cccfa9fce628ae748f757cbe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:37.97Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6294548250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/9a72fd605ddbdb98a55d13f2b1674264.webp"
"MediaSize" => 54512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-9a72fd605ddbdb98a55d13f2b1674264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:37.4Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6294548267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/60382c1f74e027fe761be4f5b5026957.webp"
"MediaSize" => 85560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-60382c1f74e027fe761be4f5b5026957.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:39.66Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6294548300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/bd7a733fc8892d6438920c0c7e8d9bdd.webp"
"MediaSize" => 83554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-bd7a733fc8892d6438920c0c7e8d9bdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:40.1Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6294548320"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/c76edd38ece70ea1787670fda6d4ad55.webp"
"MediaSize" => 84210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-c76edd38ece70ea1787670fda6d4ad55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:40.27Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6294548356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/3e709d8efb65028495873c7c0e8676a4.webp"
"MediaSize" => 82723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-3e709d8efb65028495873c7c0e8676a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:42.32Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6294548367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/0bcc5b4692731c4c8a0a4ca1e3de47dc.webp"
"MediaSize" => 69752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-0bcc5b4692731c4c8a0a4ca1e3de47dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:39.7Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6294548432"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/f82ab3e7fcce22227f7f911d47f5fbf9.webp"
"MediaSize" => 88545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-f82ab3e7fcce22227f7f911d47f5fbf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:41.46Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6294548481"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/c1fc8bd96d5794f835b2ff3f68c9c467.webp"
"MediaSize" => 98657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-c1fc8bd96d5794f835b2ff3f68c9c467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:39.22Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6294548519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/f8b7fd88acd7966d09ab2162b66eeb12.webp"
"MediaSize" => 64071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-f8b7fd88acd7966d09ab2162b66eeb12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T18:12:41.42Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6294548558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/3e94085261228c3c49bfccc4a8e6f405.webp"
"MediaSize" => 69285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-3e94085261228c3c49bfccc4a8e6f405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6294548596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/142ac26d40e9dd25e52a89a2d2c4363e.webp"
"MediaSize" => 71051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-142ac26d40e9dd25e52a89a2d2c4363e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6294548633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/3a954232b295dd5111bfeb9c0a619bbb.webp"
"MediaSize" => 47046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-3a954232b295dd5111bfeb9c0a619bbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6294548653"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/1fcf31fb450dc6a593d3ab56eca55d29.webp"
"MediaSize" => 98219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-1fcf31fb450dc6a593d3ab56eca55d29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6294548681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/e9cb963afce31a722e6958a6eb3b435a.webp"
"MediaSize" => 100931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-e9cb963afce31a722e6958a6eb3b435a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6294548700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/38ea56530ddde934bdd9a0e830faf31a.webp"
"MediaSize" => 81900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-38ea56530ddde934bdd9a0e830faf31a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6294548716"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/8de27cc9d82f91b368a00b16198bf213.webp"
"MediaSize" => 88359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-8de27cc9d82f91b368a00b16198bf213.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6294548740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/c5e42d4bbb947cd02fd0d75650baee1c.webp"
"MediaSize" => 97125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-c5e42d4bbb947cd02fd0d75650baee1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6294548752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/a984d6fb9278b5da7c15e143eb5d7b35.webp"
"MediaSize" => 102962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-a984d6fb9278b5da7c15e143eb5d7b35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6294548773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/46a922a14b4cf14cb6e0e55e8e27ddf8.webp"
"MediaSize" => 135922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-46a922a14b4cf14cb6e0e55e8e27ddf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6294548786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/53bc6c642b7ab4910bf95ee5e79badf6.webp"
"MediaSize" => 143792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-53bc6c642b7ab4910bf95ee5e79badf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12502326"
"ResourceRecordKey" => "29060037"
"ModificationTimestamp" => "2025-11-03T17:02:07.76Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6294548791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29060037/647bc015f5132578cef22f275c7633ce.webp"
"MediaSize" => 141313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29060037/thumbnail-647bc015f5132578cef22f275c7633ce.webp"
"ResourceName" => "Property"
…6
]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29060037')"
+"ID": "382727"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 279481/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279481&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279481/Office?$select=ALL&$top=10&$filter=OfficeKey eq 279481&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25142
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "KELLER WILLIAMS COMPLETE REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-308-8333"
+"OfficeMlsId": "270600"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "279481"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1044 CANNON ST EAST UNIT T"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "HAMILTON"
+"OfficePostalCode": "L8L2H7"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1304915"
+"OriginalEntryTimestamp": "2017-01-21T00:38:00Z"
+"Media": array:1 [
0 => array:10 [ …10]
]
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1230713"
+"OfficeBrokerNationalAssociationId": "1304916"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('279481')"
}
]
+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 2238085/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2238085&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2238085/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2238085&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25139
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2238085"
+"ModificationTimestamp": "2025-02-04T16:24:21Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2238085"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Member('2238085')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29060037" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24726
+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 29060037/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29060037&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29060037/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29060037&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24686
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29060037 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9148351 43.3358708)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29060037 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9148351 43.3358708)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29060037 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9148351 43.3358708)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29060037 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9148351 43.3358708)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24656
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25009
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
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 {#24616
+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 {#25011
+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 {#24998
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24615
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24994
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24674
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24991
+post_id: "427218"
+post_author: 1
+"ListingKey": "29114553"
+"ListingId": "X12555176"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-18T19:05:20Z"
+"RFModificationTimestamp": "2025-11-18T19:48:16Z"
+"ListPrice": 809000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "53 KILDONAN CRESCENT, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.911996
1 => 43.320786
]
+"Latitude": 43.320786
+"Longitude": -79.911996
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Meticulously maintained freehold end unit town by original owner! Linked only by garage and front bedroom to neighbour. Thousands in mature landscaping front and back giving you complete privacy and enjoying nature! Open concept layout between great room and kitchen! Upgraded bay window in dining room! Gas fireplace and upgraded plush broadloom throughout. Ideal for downsizers or start up with 2 large bedrooms and adjoining ensuite! Large closets with organizers. Recent updates include roof shingles 2014, garage door & opener, Carrier air conditioner, Kohler toilets, upgraded indoor & outdoor light fixtures and professionally painted throughout. Professionally finished basement with large rec room and plenty of storage! Impeccably maintained! Walk out to deck from living/dining! Inviting Front walkway interlock and stone porch! Gardeners delight with blue spruce tree, cherry tree, cedar trees, lilac tree, Japanese maple, snowball tree and lots of beautiful hydrangeas! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T19:47:55.290137+00:00"
+"Directions": "Cross Streets: Dundas/Hollybush. ** Directions: Dundas to Hollybush to Kildonan."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423588"
+"ListOfficeKey": "88210"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level"
]
+"LotSizeDimensions": "23 x 110.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T18:57:22Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-18T18:57:22Z"
+"Stories": "2.0"
+"StreetName": "Kildonan"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4745.39"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/53-kildonan-crescent-waterdown/"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29114553/53-kildonan-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 23.0
+"OriginalEntryTimestamp": "2025-11-18T18:57:22.8Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:46 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29114553')"
+"ID": "427218"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 84
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]