array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29100235/Property?$select=ALL&$top=20&$filter=ListingKey eq 29100235&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29100235/Property?$select=ALL&$top=20&$filter=ListingKey eq 29100235&$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: "418674"
+post_author: 1
+"ListingKey": "29100235"
+"ListingId": "X12541786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-13T20:51:07Z"
+"RFModificationTimestamp": "2025-11-17T10:39:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2C9"
+"UnparsedAddress": "27 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2C9"
+"Coordinates": array:2 [
0 => -79.900589
1 => 43.32762
]
+"Latitude": 43.32762
+"Longitude": -79.900589
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the vibrant heart of Waterdown at "The Tannery," this 1433 sqft, 2-bedroom, 2.5-bathroom modern townhome offers a true urban oasis. This quiet unit, set back from the road and in excellent condition with fresh paint and carpet, provides a practical main-floor foyer with a double closet and interior garage access. Ascend to the sunlit second level, where an open-concept living and dining area shines with bright windows and features french doors that open to a private balcony. This space flows seamlessly into the modern kitchen, which is well-appointed with a peninsula island, extended cabinets, and stainless steel appliances. The third level features the primary bedroom, which offers his & her closets and a private 4-piece ensuite. Completing this floor are a second bedroom, an additional 4-piece main bathroom, and the ultimate convenience of an upper-level laundry closet. This prime location blends upscale amenities with a charming small-town ambiance, placing you steps from local dining, shops, parks, the library, and Waterdown's numerous bike and walking trails, while still offering easy access for commuters to the 407, 403, QEW, and the Aldershot GO Station. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T10:39:39.751386+00:00"
+"Directions": "Dundas St E & Sunnycroft Ct"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154058"
+"ListOfficeKey": "283412"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-13T20:39:15Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-13T20:39:15Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://christianrajic.com/27-219-dundas-st-e-waterdown?fromCms=1"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1534984426"
"RoomType" => "Living room"
"ListingId" => "X12541786"
"RoomLevel" => "Second level"
"RoomWidth" => 6.53
"ListingKey" => "29100235"
"RoomLength" => 5.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-13T19:03:17.41Z"
]
1 => array:11 [
"RoomKey" => "1534984427"
"RoomType" => "Kitchen"
"ListingId" => "X12541786"
"RoomLevel" => "Second level"
"RoomWidth" => 4.42
"ListingKey" => "29100235"
"RoomLength" => 2.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-13T19:03:17.41Z"
]
2 => array:11 [
"RoomKey" => "1534984428"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12541786"
"RoomLevel" => "Third level"
"RoomWidth" => 4.44
"ListingKey" => "29100235"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-13T19:03:17.41Z"
]
3 => array:11 [
"RoomKey" => "1534984429"
"RoomType" => "Bedroom 2"
"ListingId" => "X12541786"
"RoomLevel" => "Third level"
"RoomWidth" => 3.45
"ListingKey" => "29100235"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-13T19:03:17.41Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29100235/27-219-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1976742"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild Inc - 905 575 3636"
+"CoListOfficeKey": "283412"
+"TotalActualRent": 2850
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-13T19:03:17.37Z"
+"MapCoordinateVerifiedYN": false
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29100235')"
+"ID": "418674"
}
]
+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 283412/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283412&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283412/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283412&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25026
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2154058/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2154058&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2154058/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2154058&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25028
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29100235" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24680
+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 29100235/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29100235&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29100235/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29100235&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24660
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29100235 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.900589 43.32762)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29100235 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.900589 43.32762)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29100235 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.900589 43.32762)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29100235 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.900589 43.32762)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24591
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504
+post_id: "447041"
+post_author: 1
+"ListingKey": "29139583"
+"ListingId": "X12579158"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T19:35:34Z"
+"RFModificationTimestamp": "2025-11-27T00:03:36Z"
+"ListPrice": 1299900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8817092
1 => 43.3352959
]
+"Latitude": 43.3352959
+"Longitude": -79.8817092
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T00:03:30.574559+00:00"
+"Directions": "Cross Streets: Dundas & Burke St. ** Directions: Burke St. South To Kenesky Dr. To Avanti Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991785"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "41 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:29:27Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:29:27Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1540533694"
"RoomType" => "Dining room"
"ListingId" => "X12579158"
"RoomLevel" => "Main level"
"RoomWidth" => 4.27
"ListingKey" => "29139583"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.78Z"
]
1 => array:11 [
"RoomKey" => "1540533695"
"RoomType" => "Kitchen"
"ListingId" => "X12579158"
"RoomLevel" => "Main level"
"RoomWidth" => 5.61
"ListingKey" => "29139583"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.78Z"
]
2 => array:11 [
"RoomKey" => "1540533696"
"RoomType" => "Family room"
"ListingId" => "X12579158"
"RoomLevel" => "Main level"
"RoomWidth" => 4.47
"ListingKey" => "29139583"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.78Z"
]
3 => array:11 [
"RoomKey" => "1540533697"
"RoomType" => "Laundry room"
"ListingId" => "X12579158"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29139583"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.78Z"
]
4 => array:11 [
"RoomKey" => "1540533698"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12579158"
"RoomLevel" => "Second level"
"RoomWidth" => 4.93
"ListingKey" => "29139583"
"RoomLength" => 6.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.79Z"
]
5 => array:11 [
"RoomKey" => "1540533699"
"RoomType" => "Bedroom 2"
"ListingId" => "X12579158"
"RoomLevel" => "Second level"
"RoomWidth" => 3.61
"ListingKey" => "29139583"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.79Z"
]
6 => array:11 [
"RoomKey" => "1540533700"
"RoomType" => "Bedroom 3"
"ListingId" => "X12579158"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29139583"
"RoomLength" => 4.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.79Z"
]
7 => array:11 [
"RoomKey" => "1540533701"
"RoomType" => "Bedroom 4"
"ListingId" => "X12579158"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29139583"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:29:27.79Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139583/107-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2025-11-26T19:29:27.72Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:43 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341368952"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/f5d9432f7ad8fa1610b291824f60e90b.webp"
"MediaSize" => 292842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-f5d9432f7ad8fa1610b291824f60e90b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341368988"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/e4960cef125888c10755aaff2cfad242.webp"
"MediaSize" => 363950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-e4960cef125888c10755aaff2cfad242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341369022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/258eab2424ca36134c0b73debaebf3d1.webp"
"MediaSize" => 305746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-258eab2424ca36134c0b73debaebf3d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341369040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/5d88320dabf7e50832d9d995d3ba6f76.webp"
"MediaSize" => 133557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-5d88320dabf7e50832d9d995d3ba6f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341369095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/dff7c78329e3432cd744505239e294d6.webp"
"MediaSize" => 150754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-dff7c78329e3432cd744505239e294d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341369152"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/1837e46a5ab138eac49a7ea168672d65.webp"
"MediaSize" => 168279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-1837e46a5ab138eac49a7ea168672d65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341369176"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/f617e93dcd66707c3116f26bd7864138.webp"
"MediaSize" => 135497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-f617e93dcd66707c3116f26bd7864138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341369230"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/a866ed5f462a9b476cb23ee92bb8aab1.webp"
"MediaSize" => 164852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-a866ed5f462a9b476cb23ee92bb8aab1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341369267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/70e84af9a1d5a81c22b64d6fbc8d5dac.webp"
"MediaSize" => 156248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-70e84af9a1d5a81c22b64d6fbc8d5dac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341369311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/e321ff619345eb063da3c2d9d4cf902c.webp"
"MediaSize" => 175133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-e321ff619345eb063da3c2d9d4cf902c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341369348"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/8f13a5e886db4fae6fb0aa04d3208bd9.webp"
"MediaSize" => 168420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-8f13a5e886db4fae6fb0aa04d3208bd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341369418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/1eda1087297d384df0970e5a9107dbc1.webp"
"MediaSize" => 168432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-1eda1087297d384df0970e5a9107dbc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341369472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/8cc49d27a922cb1a33af47ccfa7c8465.webp"
"MediaSize" => 143454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-8cc49d27a922cb1a33af47ccfa7c8465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341369505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/cb4366e465b2b012d00ccd5136b03b2b.webp"
"MediaSize" => 164671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-cb4366e465b2b012d00ccd5136b03b2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341369544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/99e9033439c97f7e194060bf94178737.webp"
"MediaSize" => 144325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-99e9033439c97f7e194060bf94178737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341369592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/3ae2d58bf0ba7b6644759b70f49e915c.webp"
"MediaSize" => 148095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-3ae2d58bf0ba7b6644759b70f49e915c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341369629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/919ace029d8ed034878e7df4e4ef33de.webp"
"MediaSize" => 165261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-919ace029d8ed034878e7df4e4ef33de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341369673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/e96885b9f4d9d628184463f1246cdbcf.webp"
"MediaSize" => 166259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-e96885b9f4d9d628184463f1246cdbcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341369713"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/9ba669248a58f4e717cdf626e802c229.webp"
"MediaSize" => 198455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-9ba669248a58f4e717cdf626e802c229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341369753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/ad8cf2ee86850af3e99396fdffc018af.webp"
"MediaSize" => 222874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-ad8cf2ee86850af3e99396fdffc018af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341369786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/4c087728f534971f983052a0ab98325b.webp"
"MediaSize" => 229357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-4c087728f534971f983052a0ab98325b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341369829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/fab8689c48f166c0caa73300007709f6.webp"
"MediaSize" => 108878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-fab8689c48f166c0caa73300007709f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341369857"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/201886384f411319eaa0a0ef18bbc89d.webp"
"MediaSize" => 156516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-201886384f411319eaa0a0ef18bbc89d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341369870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/96119c8642d1064a3a69fe96968ffdb9.webp"
"MediaSize" => 200607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-96119c8642d1064a3a69fe96968ffdb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341369927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/78bd8f0eff08fece29eea369be44940b.webp"
"MediaSize" => 159611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-78bd8f0eff08fece29eea369be44940b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341369943"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/30a04da41128044382e6475486a69584.webp"
"MediaSize" => 143994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-30a04da41128044382e6475486a69584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6341369986"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/da02653927633de53228908c33433d64.webp"
"MediaSize" => 170950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-da02653927633de53228908c33433d64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6341370013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/138384c2d6f5d8f8d7c0c5257a822297.webp"
"MediaSize" => 149485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-138384c2d6f5d8f8d7c0c5257a822297.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6341370051"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/32270e524f8a787d007bdb90c0a2d6a4.webp"
"MediaSize" => 153814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-32270e524f8a787d007bdb90c0a2d6a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6341370062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/7dfbffaaac219a108e50d4da4b50bfc2.webp"
"MediaSize" => 135204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-7dfbffaaac219a108e50d4da4b50bfc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6341370081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/a6d2dd57dad1bcfd5284216fb612ceb4.webp"
"MediaSize" => 152226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-a6d2dd57dad1bcfd5284216fb612ceb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6341370091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/51b59cc0cdbc0df613ee8c5ff7d5d171.webp"
"MediaSize" => 166581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-51b59cc0cdbc0df613ee8c5ff7d5d171.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6341370109"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/74ae475b460e5249d2d0c3877883534e.webp"
"MediaSize" => 161390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-74ae475b460e5249d2d0c3877883534e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6341370123"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/42ef3e5403713d562c428109aae4bdde.webp"
"MediaSize" => 171000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-42ef3e5403713d562c428109aae4bdde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6341370145"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/f3460a192a9b3c8cdfdc3997862accc9.webp"
"MediaSize" => 160217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-f3460a192a9b3c8cdfdc3997862accc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6341370158"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/771e872885bfbc390e3f047eb9f4d879.webp"
"MediaSize" => 153830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-771e872885bfbc390e3f047eb9f4d879.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6341370175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/5103a203d201a424bcce07eff3f793e9.webp"
"MediaSize" => 113962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-5103a203d201a424bcce07eff3f793e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6341370181"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/d5ad2a7625ce060be2ff2355831b40e9.webp"
"MediaSize" => 98165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-d5ad2a7625ce060be2ff2355831b40e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6341370195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/35c10a4b75babe8928cc0c2a7fa3e3b5.webp"
"MediaSize" => 149544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-35c10a4b75babe8928cc0c2a7fa3e3b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6341370208"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/9e3aba9ed3ec51f468b4831ffbeae37a.webp"
"MediaSize" => 159769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-9e3aba9ed3ec51f468b4831ffbeae37a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6341370214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/bf9939cb69c7fbd3a67d2f0dafc122d0.webp"
"MediaSize" => 305163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-bf9939cb69c7fbd3a67d2f0dafc122d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6341370224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/80ef44b9d0533f89f391e67c6750dbac.webp"
"MediaSize" => 383070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-80ef44b9d0533f89f391e67c6750dbac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6341370235"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139583/853e548bfa5a19a77baa97d22722b6cf.webp"
"MediaSize" => 381301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139583/thumbnail-853e548bfa5a19a77baa97d22722b6cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579158"
"ResourceRecordKey" => "29139583"
"ModificationTimestamp" => "2025-11-26T19:29:27.73Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139583')"
+"ID": "447041"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24491
+post_id: "446149"
+post_author: 1
+"ListingKey": "29139051"
+"ListingId": "40790678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:53Z"
+"RFModificationTimestamp": "2025-11-26T18:54:09Z"
+"ListPrice": 1299900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2870.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI Crescent, Waterdown, Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8819455
1 => 43.3353076
]
+"Latitude": 43.3353076
+"Longitude": -79.8819455
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:53:52.505254+00:00"
+"Directions": "Burke St. South To Kenesky Dr. To Avanti Cres"
+"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": "2062140"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:00:20Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:00:20Z"
+"Stories": "2.0"
+"StreetName": "AVANTI"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540488388"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.05Z"
]
1 => array:11 [
"RoomKey" => "1540488389"
"RoomType" => "5pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
2 => array:11 [
"RoomKey" => "1540488390"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
3 => array:11 [
"RoomKey" => "1540488391"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
4 => array:11 [
"RoomKey" => "1540488392"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
5 => array:11 [
"RoomKey" => "1540488393"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
6 => array:11 [
"RoomKey" => "1540488394"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
7 => array:11 [
"RoomKey" => "1540488395"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
8 => array:11 [
"RoomKey" => "1540488396"
"RoomType" => "Laundry room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
9 => array:11 [
"RoomKey" => "1540488397"
"RoomType" => "Family room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
10 => array:11 [
"RoomKey" => "1540488398"
"RoomType" => "Kitchen"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
11 => array:11 [
"RoomKey" => "1540488399"
"RoomType" => "Living room/Dining room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139051/107-avanti-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2085942"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "R1 - 64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 2870
+"OriginalEntryTimestamp": "2025-11-26T18:00:20.02Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:43 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341230006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/aad8bd606b5ead46ce8d0238cc6daaf4.webp"
"MediaSize" => 74997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-aad8bd606b5ead46ce8d0238cc6daaf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341230037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/c29672c735a88e1aea3e8508ea6d1106.webp"
"MediaSize" => 68398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-c29672c735a88e1aea3e8508ea6d1106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341230055"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/f81285eaf4a5ae8ec46eec1407337d84.webp"
"MediaSize" => 68270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-f81285eaf4a5ae8ec46eec1407337d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341230103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/575377ced9e47e62b7cfa7e3b04b76c8.webp"
"MediaSize" => 78218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-575377ced9e47e62b7cfa7e3b04b76c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341230112"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/7537a9b1274c1056361c6b8dfbe973ab.webp"
"MediaSize" => 75906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-7537a9b1274c1056361c6b8dfbe973ab.webp"
…7
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139051')"
+"ID": "446149"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24590
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24555
+post_id: "443334"
+post_author: 1
+"ListingKey": "29135418"
+"ListingId": "40790035"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T21:45:38Z"
+"RFModificationTimestamp": "2025-11-26T21:56:23Z"
+"ListPrice": 1379999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 2.38
+"LivingArea": 2550.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Z3"
+"UnparsedAddress": "1724 SNAKE Road, Burlington, Ontario L7P4Z3"
+"Coordinates": array:2 [
0 => -79.8901919
1 => 43.3116597
]
+"Latitude": 43.3116597
+"Longitude": -79.8901919
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on 2.4 acres in Burlington’s highly sought-after Aldershot community, this property offers the perfect blend of country charm and city convenience. Imagine starting your mornings in a beautifully updated 2,390 sq ft home, preparing breakfast in a chef’s kitchen with a sprawling island, rich cabinetry, and built-in appliances. The spacious family room invites gatherings, with a walk-out to a private patio where summer evenings can be savored. With three bedrooms and two full baths—including a spa-like retreat with soaker tub and oversized shower—comfort is at the heart of this home. Outside, there’s endless room for kids and pets to roam, while a 2 story barn provides space for hobbies or creative projects. Just minutes from major highways, commuting is effortless, yet weekends can be spent exploring nearby hiking and biking trails, conservation areas, or the Royal Botanical Gardens. The LaSalle Park Community Marina is also just a short drive away, perfect for boating enthusiasts. Shopping in Burlington or Waterdown is only minutes away, making this property a rare opportunity to enjoy country living without sacrificing urban amenities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Dryer"
3 => "Oven - Built-In"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T18:59:47.886506+00:00"
+"Directions": "OLD YORK RD TO SNAKE RD."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Sump Pump"
]
+"LotSizeDimensions": "2.38"
+"PhotosChangeTimestamp": "2025-11-25T18:01:39Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T21:30:31Z"
+"Stories": "2.0"
+"StreetName": "SNAKE"
+"StreetNumber": "1724"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"TaxAnnualAmount": "6084.38"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Cable"
2 => "Telephone"
]
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://youriguide.com/1724_snake_rd_burlington_on/"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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/29135418/1724-snake-road-burlington"
+"ParkingTotal": 20
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1525315"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1677992"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"ZoningDescription": "RNA1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 441.0
+"AboveGradeFinishedArea": 2550
+"OriginalEntryTimestamp": "2025-11-25T17:59:56.72Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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('29135418')"
+"ID": "443334"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24554
+post_id: "442148"
+post_author: 1
+"ListingKey": "29133031"
+"ListingId": "W12572990"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T21:55:36Z"
+"RFModificationTimestamp": "2025-11-25T01:58:45Z"
+"ListPrice": 2760000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Grindstone)"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "521 OLD YORK ROAD, Burlington (Grindstone), Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.8934767
1 => 43.3110383
]
+"Latitude": 43.3110383
+"Longitude": -79.8934767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*Magnificent 3600 Sq Ft Detached on 3 Acres of Land* This One of A Kind Beautiful Custom Living Retreat Offers a Perfect Blend of Comfort, Luxury and Natural Beauty. The Property Seamlessly Combines the Best of Both, Town and Country Lifestyles. This Special Home, Rebuilt From Foundation Up, Is Like No Other In The Neighbourhood. Step Outside To Enjoy the Fresh, Coastal Vibes With Peaceful Atmosphere and You Will Never Leave. The Kitchen is Chef's Dream, Equipped With South American Granite, Massive Centre Island, 36" Stove With Pot Filler Faucet and Stainless Steel Appliances. Overlooking The Kitchen is the "Great Room" with 22 Ft Cathedral Ceilings, Open Concept, Sunny Dining Room, Fireplace, Hardwood Flooring Adding Warmth and Charm to the Living Area. Many Large Windows Bring The Outside In. The End of the Main Floor Seamlessly Flows into 3-pc Bath, Laundry and Mudroom Area With Access to Garage. Two Bedrooms With Private Bathrooms are Located on the Upper Level But a Master Suite Also Features a Balcony. The Spectacular Lower Level Boasts a Large Family Room, Fireplace, Bedroom and 3-pc Baths. One of the Most Exciting Parts of this Home is a Private, Huge Backyard That Borders the Conservation Area. Nature Lovers Will Appreciate Its Enhanced Privacy Ensuring That Building Is Not Allowed Past the Tree Line and Preserving The Natural Beauty of the Area for Generations to Come. Step Outside on 2-Tiered Deck and Enjoy the Sunrise, Sunsets and All The Beauty The Scenic View Has to Offer! (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
3 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Partially finished"
1 => "None"
2 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T01:58:25.613438+00:00"
+"Directions": "Cross Streets: Plains Rd W. & Old York Rd. ** Directions: Hwy 6N to Old York Road."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Hardwood"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406474"
+"ListOfficeKey": "50914"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Hillside"
1 => "Irregular lot size"
2 => "Open space"
3 => "Dry"
]
+"LotSizeDimensions": "136.5 x 1017.5 FT ; 140.12Ftx970.84Ftx136.56Ftx1017.54Ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T21:49:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T21:49:48Z"
+"StreetName": "Old York"
+"StreetNumber": "521"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7455.64"
+"View": "View"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/436548/branded/18799"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Grindstone"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29133031/521-old-york-road-burlington-grindstone-grindstone"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "RNA1,03-196 DNA"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 136.6
+"OriginalEntryTimestamp": "2025-11-24T21:49:48.19Z"
+"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('29133031')"
+"ID": "442148"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24506
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+post_id: "436984"
+post_author: 1
+"ListingKey": "29127642"
+"ListingId": "40786336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T16:20:16Z"
+"RFModificationTimestamp": "2025-11-22T16:22:50Z"
+"ListPrice": 2299000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.53
+"LivingArea": 2705.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Y4"
+"UnparsedAddress": "1962 SNAKE Road, Burlington, Ontario L7P4Y4"
+"Coordinates": array:2 [
0 => -79.8907745
1 => 43.3237656
]
+"Latitude": 43.3237656
+"Longitude": -79.8907745
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your dream home awaits in this custom-built 2705 sq ft masterpiece on a half-acre lot. Natural light floods the home through skylights, while the spacious family room features a stunning vaulted ceiling—perfect for both relaxing and entertaining. The sun-drenched kitchen, with wall-to-wall windows, brings the beauty of nature indoors as you cook and gather. Upstairs, retreat to the luxurious primary suite with a five-piece ensuite and dual walk-in closets. Two additional bedrooms and a stylish four-piece bath complete the second floor. The fully finished walkout basement offers versatility with an extra bedroom and full bathroom, ideal for guests or a home office. Outside, enjoy your private oasis with a sparkling pool, hot tub, and cozy campfire spot—perfect for evenings under the stars. This home blends modern comfort with thoughtful design, creating the perfect balance of indoor luxury and outdoor living. This is your chance to call this exquisite property your own. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Microwave"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T23:13:04.435790+00:00"
+"Directions": "See map for directions."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2216487"
+"ListOfficeKey": "296698"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.53"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T21:09:33Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T16:09:42Z"
+"Stories": "1.5"
+"StreetName": "SNAKE"
+"StreetNumber": "1962"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"TaxAnnualAmount": "7168.9"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=2sK4MXveabb"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29127642/1962-snake-road-burlington"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "Nec Dev Control Area"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 2705
+"OriginalEntryTimestamp": "2025-11-21T21:09:33.76Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29127642')"
+"ID": "436984"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24556
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24586
+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"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 122
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]
