array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30017283 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23509
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23511
+post_id: "1615392"
+post_author: 1
+"ListingKey": "30017283"
+"ListingId": "X13548772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T19:40:06Z"
+"RFModificationTimestamp": "2026-07-20T19:55:51Z"
+"ListPrice": 2995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "515 SANDY BAY ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.621485
1 => 42.84342
]
+"Latitude": 42.84342
+"Longitude": -79.621485
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Behind a gated entrance and down a winding tree-lined driveway sits a lakefront estate along the shores of Lake Erie in the community of Dunnville. Welcome to 515 Sandy Bay. Set on over 5.5 acres with more than 270 feet of shoreline, this sprawling bungalow blends contemporary design with natural materials including stacked stone, wood accents, exposed beams and steel structural elements. The layout captures lake views from the main living areas. From the foyer, sightlines extend through the kitchen and dining area toward the water. The kitchen features black cabinetry, suede granite countertops, a large island with seating, pebble stone backsplash, Wolf gas range, double built-in ovens, custom panel refrigerator and a walk-in pantry accessed through a repurposed horse stable door. The main level is divided into two wings. One side includes the bedrooms and bathrooms, while the other opens to the living room, glass sunroom & home office. Vaulted ceilings, exposed beams and stone fireplaces frame the lake views while large windows provide natural light. The primary suite features a walk-in closet and an ensuite with tin ceilings, floating wood vanity with chain detail, walk-in glass shower and black soaker tub positioned toward the lake. The fully finished lower level is accessed by a steel beam staircase with wood capping. Stone feature walls and an electric fireplace are featured throughout. Bedrooms include barn doors, wood and log feature walls, a custom lake mural and a converted wine cellar now used as a children's bedroom. Exterior features include a gated entrance, winding driveway with lighting, fruit trees, raised garden beds and a fenced yard. Massive stone walkways, a fire pit area and rock steps lead to the shoreline. A covered patio off the kitchen provides space for outdoor dining and entertaining. A detached shop offers space for storage, boats or hobbies and includes a finished one-bedroom apartment ideal for guests or extended family. (id:62650)"
+"Appliances": array:3 [
0 => "Central Vacuum"
1 => "Oven - Built-In"
2 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-10T16:41:30.188962+00:00"
+"Directions": "Cross Streets: Johnson Rd. ** Directions: Johnson Rd to Sandy Bay Rd."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2057954"
+"ListOfficeKey": "283968"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "261.8 x 942.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T15:53:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T19:34:26Z"
+"Stories": "1.0"
+"StreetName": "Sandy Bay"
+"StreetNumber": "515"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "16670"
+"View": "Lake view,View,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://youtu.be/TvRlJijupng"
+"WaterBodyName": "Lake Erie"
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1689475967"
"RoomType" => "Office"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "30017283"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.79Z"
]
1 => array:11 [
"RoomKey" => "1689475968"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13548772"
"RoomLevel" => "Lower level"
"RoomWidth" => 9.78
"ListingKey" => "30017283"
"RoomLength" => 12.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.79Z"
]
2 => array:11 [
"RoomKey" => "1689475969"
"RoomType" => "Family room"
"ListingId" => "X13548772"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.22
"ListingKey" => "30017283"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
3 => array:11 [
"RoomKey" => "1689475970"
"RoomType" => "Other"
"ListingId" => "X13548772"
"RoomLevel" => "Lower level"
"RoomWidth" => 8.84
"ListingKey" => "30017283"
"RoomLength" => 3.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
4 => array:11 [
"RoomKey" => "1689475971"
"RoomType" => "Kitchen"
"ListingId" => "X13548772"
"RoomLevel" => "Flat"
"RoomWidth" => 3.15
"ListingKey" => "30017283"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
5 => array:11 [
"RoomKey" => "1689475972"
"RoomType" => "Living room"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 6.32
"ListingKey" => "30017283"
"RoomLength" => 7.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
6 => array:11 [
"RoomKey" => "1689475973"
"RoomType" => "Bedroom"
"ListingId" => "X13548772"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "30017283"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
7 => array:11 [
"RoomKey" => "1689475974"
"RoomType" => "Bathroom"
"ListingId" => "X13548772"
"RoomLevel" => "Flat"
"RoomWidth" => 1.93
"ListingKey" => "30017283"
"RoomLength" => 2.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
8 => array:11 [
"RoomKey" => "1689475975"
"RoomType" => "Sunroom"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "30017283"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
9 => array:11 [
"RoomKey" => "1689475976"
"RoomType" => "Dining room"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 4.09
"ListingKey" => "30017283"
"RoomLength" => 6.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
10 => array:11 [
"RoomKey" => "1689475977"
"RoomType" => "Kitchen"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 4.83
"ListingKey" => "30017283"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
11 => array:11 [
"RoomKey" => "1689475978"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 4.47
"ListingKey" => "30017283"
"RoomLength" => 5.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.8Z"
]
12 => array:11 [
"RoomKey" => "1689475979"
"RoomType" => "Bedroom"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 4.39
"ListingKey" => "30017283"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.81Z"
]
13 => array:11 [
"RoomKey" => "1689475980"
"RoomType" => "Laundry room"
"ListingId" => "X13548772"
"RoomLevel" => "Main level"
"RoomWidth" => 2.51
"ListingKey" => "30017283"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.81Z"
]
14 => array:11 [
"RoomKey" => "1689475981"
"RoomType" => "Bedroom"
"ListingId" => "X13548772"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.94
"ListingKey" => "30017283"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.81Z"
]
15 => array:11 [
"RoomKey" => "1689475982"
"RoomType" => "Bedroom"
"ListingId" => "X13548772"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.53
"ListingKey" => "30017283"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-20T19:34:26.81Z"
]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "Dunnville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/30017283/515-sandy-bay-road-haldimand-dunnville-dunnville"
+"ParkingTotal": 46
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "D A7F2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 261.9
+"OriginalEntryTimestamp": "2026-07-10T15:53:27.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1333075"
+"ListOfficeNationalAssociationId": "1337412"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017283_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c402f10eeca54cc7e5352f7e99e2f7ca.webp"
"MediaSize" => 353707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c402f10eeca54cc7e5352f7e99e2f7ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017283_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/80b0a58b73475f9404fd5670850db7d5.webp"
"MediaSize" => 293136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-80b0a58b73475f9404fd5670850db7d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017283_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9d64970499a5a0739e6a55abbc56c2a1.webp"
"MediaSize" => 378619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9d64970499a5a0739e6a55abbc56c2a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017283_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/86b99ab63df933486ce88906c404151c.webp"
"MediaSize" => 244123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-86b99ab63df933486ce88906c404151c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30017283_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/3b907203c0ebb76e95f6f75783e5e93a.webp"
"MediaSize" => 244373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-3b907203c0ebb76e95f6f75783e5e93a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30017283_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/fcd9582ddff11172e8645a9748bbe783.webp"
"MediaSize" => 210592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-fcd9582ddff11172e8645a9748bbe783.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30017283_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9960a77cabbf167c8c8c7050191532ee.webp"
"MediaSize" => 242166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9960a77cabbf167c8c8c7050191532ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30017283_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/a687a9853e790b9b43dab31bbdf7b532.webp"
"MediaSize" => 237583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-a687a9853e790b9b43dab31bbdf7b532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30017283_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/48476022304a666660e18709ac89f4a2.webp"
"MediaSize" => 234155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-48476022304a666660e18709ac89f4a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30017283_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c894125b75a53002426cdd6a95aaedc4.webp"
"MediaSize" => 222972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c894125b75a53002426cdd6a95aaedc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30017283_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/2771f03225c4d2158530c69994a5a928.webp"
"MediaSize" => 241284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-2771f03225c4d2158530c69994a5a928.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30017283_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9db5bdc35f495ec796592aaaf4c83415.webp"
"MediaSize" => 260360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9db5bdc35f495ec796592aaaf4c83415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30017283_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/dff4573a7218d19f2a421b6ae211e71b.webp"
"MediaSize" => 342640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-dff4573a7218d19f2a421b6ae211e71b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30017283_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/a72b4c332e9533e1bd6a5a554ef13034.webp"
"MediaSize" => 313790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-a72b4c332e9533e1bd6a5a554ef13034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30017283_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/255ec7425b522c276efd51bf423d1e4f.webp"
"MediaSize" => 206197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-255ec7425b522c276efd51bf423d1e4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30017283_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/0f25cdcf9d082e66f37bdc8eb69f5278.webp"
"MediaSize" => 339056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-0f25cdcf9d082e66f37bdc8eb69f5278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30017283_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/4bb08f6bfe6eeb8f978d1482eacd6cf4.webp"
"MediaSize" => 341923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-4bb08f6bfe6eeb8f978d1482eacd6cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30017283_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/2115bf67d52bebb91e3f6f4004e2ab28.webp"
"MediaSize" => 298113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-2115bf67d52bebb91e3f6f4004e2ab28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30017283_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9bb487ec7f1a8ecfdaefbd90a0907140.webp"
"MediaSize" => 342508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9bb487ec7f1a8ecfdaefbd90a0907140.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30017283_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/91680626363299f0067194ba7c1ad5b5.webp"
"MediaSize" => 274413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-91680626363299f0067194ba7c1ad5b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30017283_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/a6f1133f0eee386faf255b2795fd7dd2.webp"
"MediaSize" => 295010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-a6f1133f0eee386faf255b2795fd7dd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30017283_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/476ba83403ed614d5a5286d7d0e280c3.webp"
"MediaSize" => 229312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-476ba83403ed614d5a5286d7d0e280c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30017283_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c859c46db9b9d9a55d679e7d9144564e.webp"
"MediaSize" => 194035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c859c46db9b9d9a55d679e7d9144564e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30017283_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9efc0aac3ef5ec1403b1e3307ecfa203.webp"
"MediaSize" => 332310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9efc0aac3ef5ec1403b1e3307ecfa203.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30017283_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/f6bd0acde9c55d86deaec7ad14ae945a.webp"
"MediaSize" => 298799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-f6bd0acde9c55d86deaec7ad14ae945a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30017283_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/0142916f0e2b9e26b75134cbc9c77c78.webp"
"MediaSize" => 233706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-0142916f0e2b9e26b75134cbc9c77c78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30017283_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/e4320e018bc8fc1da1aa8b0e85c44b79.webp"
"MediaSize" => 241626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-e4320e018bc8fc1da1aa8b0e85c44b79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30017283_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/9afab3484a3922a1a6d69a1f4bfc4d8b.webp"
"MediaSize" => 237186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-9afab3484a3922a1a6d69a1f4bfc4d8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30017283_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/64915a02cb894c427d1415bfbf6dfd7c.webp"
"MediaSize" => 285954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-64915a02cb894c427d1415bfbf6dfd7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30017283_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/99beeede84479bfa844602efd8c8a920.webp"
"MediaSize" => 262586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-99beeede84479bfa844602efd8c8a920.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30017283_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/822b251face9da239840431f772a1b9d.webp"
"MediaSize" => 237573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-822b251face9da239840431f772a1b9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30017283_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/ff39634cde3cd67151334dd6fc3ff0ad.webp"
"MediaSize" => 413995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-ff39634cde3cd67151334dd6fc3ff0ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30017283_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/37fe9416c5516d5b7fab9c6682f0b6f5.webp"
"MediaSize" => 369153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-37fe9416c5516d5b7fab9c6682f0b6f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30017283_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c165ffdacd9ddb1dea522b627b66eb40.webp"
"MediaSize" => 355503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c165ffdacd9ddb1dea522b627b66eb40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30017283_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/1d7d92830daedea82b6bad548d22b799.webp"
"MediaSize" => 347666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-1d7d92830daedea82b6bad548d22b799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30017283_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/4e49f478a303b559ef251871e5d0c2be.webp"
"MediaSize" => 360470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-4e49f478a303b559ef251871e5d0c2be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30017283_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c37fee30f4475a1fc6d41f79d883e543.webp"
"MediaSize" => 282033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c37fee30f4475a1fc6d41f79d883e543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30017283_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/cda38361317c618fc49dfee46cecf832.webp"
"MediaSize" => 349372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-cda38361317c618fc49dfee46cecf832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30017283_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c1360bcd728b1a13874c0f07125c52ac.webp"
"MediaSize" => 364804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c1360bcd728b1a13874c0f07125c52ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30017283_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/a2196b96c49b666ddf4c4a24e32368e6.webp"
"MediaSize" => 278452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-a2196b96c49b666ddf4c4a24e32368e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30017283_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/2d7dcc19c61e949ac760f8b8515a5be0.webp"
"MediaSize" => 276230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-2d7dcc19c61e949ac760f8b8515a5be0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30017283_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/7e3aea010d96c9473dd9f7b65f92f9e1.webp"
"MediaSize" => 239613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-7e3aea010d96c9473dd9f7b65f92f9e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30017283_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/fbe37149348ba7fecdafd749d3d44ec9.webp"
"MediaSize" => 243843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-fbe37149348ba7fecdafd749d3d44ec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30017283_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/626782b38ab9e9a21fdddf9da06c7169.webp"
"MediaSize" => 239691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-626782b38ab9e9a21fdddf9da06c7169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30017283_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/975fa36cd7768e300c0bc4137abf1bb7.webp"
"MediaSize" => 229709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-975fa36cd7768e300c0bc4137abf1bb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30017283_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/1826f7c66d5afea9617139ecea7fc089.webp"
"MediaSize" => 305139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-1826f7c66d5afea9617139ecea7fc089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30017283_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/74a2b44596aa1409715f820808cef5db.webp"
"MediaSize" => 384571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-74a2b44596aa1409715f820808cef5db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "30017283_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/c0ac5df50999c6222ea9f9be3d7bcbb0.webp"
"MediaSize" => 343756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-c0ac5df50999c6222ea9f9be3d7bcbb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "30017283_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/5a3d8143928ac028fb11ced4dcaca58f.webp"
"MediaSize" => 376188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-5a3d8143928ac028fb11ced4dcaca58f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "30017283_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017283/f332ecc4c70f28fa698dc0bd275d71bb.webp"
"MediaSize" => 86274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017283/thumbnail-f332ecc4c70f28fa698dc0bd275d71bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548772"
"ResourceRecordKey" => "30017283"
"ModificationTimestamp" => "2026-07-10T15:53:27.75Z"
]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017283')"
+"ID": "1615392"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283968" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25051
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24996
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX HENDRIKS TEAM REALTY"
+"OfficeEmail": null
+"OfficePhone": "289-723-2132"
+"OfficeMlsId": "467900"
+"ModificationTimestamp": "2026-04-22T08:11:02Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283968"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "145 King Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "ST. CATHARINES"
+"OfficePostalCode": "L2R3J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Niagara"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1337412"
+"OriginalEntryTimestamp": "2018-09-20T15:29:00Z"
+"OfficeAORKey": "114"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "377539"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283968"
"SocialMediaUrlOrId" => "http://www.niagarahomes.com/"
"ModificationTimestamp" => "2026-04-22T05:23:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1066650"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283968')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2057954" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24947
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30017283'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25367
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30017283' AND OpenHouseDate ge '2026-07-20'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25385
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32100348"
+"ListingKey": "30017283"
+"ListingId": "X13548772"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-25"
+"OpenHouseStartTime": "2026-07-25T14:00:00Z"
+"OpenHouseEndTime": "2026-07-25T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-21T07:36:08Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32100348')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30017283' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.621485 42.84342)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25475
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25452
+post_id: "1612831"
+post_author: 1
+"ListingKey": "30016950"
+"ListingId": "40846689"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T15:30:05Z"
+"RFModificationTimestamp": "2026-07-10T17:08:49Z"
+"ListPrice": 249000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 97.74
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "32 JOHNSON Road, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6134689
1 => 42.8481715
]
+"Latitude": 42.8481715
+"Longitude": -79.6134689
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover the perfect opportunity to build your dream home on this beautiful 1-acre country lot at 32 Johnson Road in Dunnville. Offering an impressive 105-foot frontage and 424-foot depth, this spacious property provides ample room to design the custom home you've always envisioned, with plenty of space for outdoor living, gardens, or a workshop. Enjoy the peace and privacy of country living while remaining just minutes from the shores of Lake Erie, local golf courses, parks, marinas, and everyday amenities. Whether you're looking to create your forever home or invest in a fantastic piece of land, this is an exceptional opportunity in a desirable rural setting. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-10T17:08:28.552796+00:00"
+"Directions": "Port Maitland/ King Row/ Johnson"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"LotSizeDimensions": "97.74"
+"PhotosChangeTimestamp": "2026-07-10T15:18:17Z"
+"PhotosCount": 2
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T15:18:17Z"
+"StreetName": "JOHNSON"
+"StreetNumber": "32"
+"StreetSuffix": "Road"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "185"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30016950/32-johnson-road-dunnville"
+"CoListAgentKey": "1903929"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "D A7F2"
+"FrontageLengthNumeric": 105.0
+"OriginalEntryTimestamp": "2026-07-10T15:18:17.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1219014"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30016950_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016950/10de9b872f0dc9f98587797c8802b964.webp"
"MediaSize" => 120925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016950/thumbnail-10de9b872f0dc9f98587797c8802b964.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846689"
"ResourceRecordKey" => "30016950"
"ModificationTimestamp" => "2026-07-10T15:18:17.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30016950_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016950/c13b8589ec7aa06489c5b75564db5a34.webp"
"MediaSize" => 108410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016950/thumbnail-c13b8589ec7aa06489c5b75564db5a34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846689"
"ResourceRecordKey" => "30016950"
"ModificationTimestamp" => "2026-07-10T15:18:17.46Z"
]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30016950')"
+"ID": "1612831"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25471
+post_id: "1612841"
+post_author: 1
+"ListingKey": "30017417"
+"ListingId": "X13548756"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:30:03Z"
+"RFModificationTimestamp": "2026-07-10T17:06:56Z"
+"ListPrice": 249000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "32 JOHNSON ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.612955
1 => 42.848208
]
+"Latitude": 42.848208
+"Longitude": -79.612955
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover the perfect opportunity to build your dream home on this beautiful 1-acre country lot at 32 Johnson Road in Dunnville. Offering an impressive 105-foot frontage and 424-foot depth, this spacious property provides ample room to design the custom home you've always envisioned, with plenty of space for outdoor living, gardens, or a workshop. Enjoy the peace and privacy of country living while remaining just minutes from the shores of Lake Erie, local golf courses, parks, marinas, and everyday amenities. Whether you're looking to create your forever home or invest in a fantastic piece of land, this is an exceptional opportunity in a desirable rural setting. (id:62650)"
+"CreationDate": "2026-07-10T17:06:43.748269+00:00"
+"Directions": "Cross Streets: Lighthouse Drive. ** Directions: Port Maitland/ King Row/ Johnson."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LotSizeDimensions": "105 x 424 FT"
+"PhotosChangeTimestamp": "2026-07-10T16:10:19Z"
+"PhotosCount": 2
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T16:10:19Z"
+"StreetName": "Johnson"
+"StreetNumber": "32"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "185"
+"Utilities": array:1 [
0 => "Electricity"
]
+"ListAOR": "Toronto"
+"CityRegion": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30017417/32-johnson-road-haldimand-dunnville-dunnville"
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 105.0
+"OriginalEntryTimestamp": "2026-07-10T16:10:19.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017417_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017417/71a5e00315823b433f44e74f752b01b7.webp"
"MediaSize" => 154854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017417/thumbnail-71a5e00315823b433f44e74f752b01b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13548756"
"ResourceRecordKey" => "30017417"
"ModificationTimestamp" => "2026-07-10T16:10:19.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017417_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017417/2198e425fa0a224fed44e85116b60f62.webp"
"MediaSize" => 125575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017417/thumbnail-2198e425fa0a224fed44e85116b60f62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13548756"
"ResourceRecordKey" => "30017417"
"ModificationTimestamp" => "2026-07-10T16:10:19.66Z"
]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017417')"
+"ID": "1612841"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25451
+post_id: "1502042"
+post_author: 1
+"ListingKey": "29863855"
+"ListingId": "X13259434"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T22:00:35Z"
+"RFModificationTimestamp": "2026-06-05T22:48:04Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "689 SANDY BAY ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.634687
1 => 42.837192
]
+"Latitude": 42.837192
+"Longitude": -79.634687
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spectacular waterfront location with stunning lake views that stretch for miles. This fabulous property is nestled among mature towering oak trees, providing natural shade and ultimate privacy. Located on a quiet dead-end road this spacious 4-bedroom home offers the perfect retreat from city life. The bright and airy open concept living area features a wall of windows that captures spectacular water views from the main living spaces. Outside, enjoy a large private lot with plenty of room for children and pets to play, armour stone break wall protection, and steps leading down to the shoreline. Just steps away from Freedom Oaks Golf Club's semi-private 18-hole course and restaurant, and only minutes to town, this property offers an exceptional blend of recreation, relaxation, and natural beauty. Bonus detached garage located on the south side of the road provides additional storage for vehicles, water toys, or workshop space. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-05T22:48:01.023366+00:00"
+"Directions": "Cross Streets: Johnson Rd. ** Directions: Johnson Road to Sandy Bay Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235081"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "126 x 219.5 FT ; irreg depth+small parcel on N side of Rd"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T21:53:57Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T21:53:56Z"
+"Stories": "1.0"
+"StreetName": "Sandy Bay"
+"StreetNumber": "689"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4800"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Wireless"
2 => "Natural Gas Available"
3 => "Electricity Connected"
]
+"View": "Lake view,View,View of water,Direct Water View"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1652709174"
"RoomType" => "Kitchen"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29863855"
"RoomLength" => 2.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
1 => array:11 [
"RoomKey" => "1652709175"
"RoomType" => "Dining room"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 2.46
"ListingKey" => "29863855"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
2 => array:11 [
"RoomKey" => "1652709176"
"RoomType" => "Bathroom"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 1.78
"ListingKey" => "29863855"
"RoomLength" => 2.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
3 => array:11 [
"RoomKey" => "1652709177"
"RoomType" => "Living room"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 3.45
"ListingKey" => "29863855"
"RoomLength" => 7.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
4 => array:11 [
"RoomKey" => "1652709178"
"RoomType" => "Sitting room"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 1.88
"ListingKey" => "29863855"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
5 => array:11 [
"RoomKey" => "1652709179"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29863855"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.96Z"
]
6 => array:11 [
"RoomKey" => "1652709180"
"RoomType" => "Bedroom"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 2.46
"ListingKey" => "29863855"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.97Z"
]
7 => array:11 [
"RoomKey" => "1652709181"
"RoomType" => "Bedroom"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "29863855"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.97Z"
]
8 => array:11 [
"RoomKey" => "1652709182"
"RoomType" => "Bedroom"
"ListingId" => "X13259434"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29863855"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T21:53:56.97Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29863855/689-sandy-bay-road-haldimand-dunnville-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "D A7F1"
+"BedroomsAboveGrade": 4
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 126.0
+"OriginalEntryTimestamp": "2026-06-05T21:53:56.93Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472900"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:46 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29863855_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29863855/1fdb11bbee732a64509b523e6689359a.webp"
"MediaSize" => 483815
"MediaType" => "webp"
…8
]
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]
]
+"DaysOnMarket": 45
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863855')"
+"ID": "1502042"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25472
+post_id: "1498919"
+post_author: 1
+"ListingKey": "29859296"
+"ListingId": "40836862"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T14:30:17Z"
+"RFModificationTimestamp": "2026-06-05T15:03:16Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.656
+"LivingArea": 1071.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "689 SANDY BAY Road, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6348376
1 => 42.8370827
]
+"Latitude": 42.8370827
+"Longitude": -79.6348376
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spectacular waterfront location with stunning lake views that stretch for miles. This fabulous property is nestled among mature towering oak trees, providing natural shade and ultimate privacy. Located on a quiet dead-end road this spacious 4-bedroom home offers the perfect retreat from city life. The bright and airy open concept living area features a wall of windows that captures spectacular water views from the main living spaces. Outside, enjoy a large private lot with plenty of room for children and pets to play, armour stone break wall protection, and steps leading down to the shoreline. Just steps away from Freedom Oaks Golf Club's semi-private 18-hole course and restaurant, and only minutes to town, this property offers an exceptional blend of recreation, relaxation, and natural beauty. Bonus detached garage located on the south side of the road provides additional storage for vehicles, water toys, or workshop space. (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-05T15:03:12.324770+00:00"
+"Directions": "Johnson Road to Sandy Bay Road"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524894"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Country residential"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.656"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T14:20:08Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T14:20:08Z"
+"Stories": "1.0"
+"StreetName": "SANDY BAY"
+"StreetNumber": "689"
+"StreetSuffix": "Road"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "4800"
+"View": "Lake view"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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/29859296/689-sandy-bay-road-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D A7F1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 126.0
+"AboveGradeFinishedArea": 1071
+"OriginalEntryTimestamp": "2026-06-05T14:20:08.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064311"
+"ListOfficeNationalAssociationId": "1398404"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 45
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859296')"
+"ID": "1498919"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25453
+post_id: "1476534"
+post_author: 1
+"ListingKey": "29825850"
+"ListingId": "40833672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T19:25:10Z"
+"RFModificationTimestamp": "2026-07-18T19:32:38Z"
+"ListPrice": 380000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.121
+"LivingArea": 661.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "716 SANDY BAY Road, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6370458
1 => 42.8368715
]
+"Latitude": 42.8368715
+"Longitude": -79.6370458
+"YearBuilt": 1935
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Escape to one of Lake Erie's most sought-after waterfront communities! 4 Season Cottage where Beaching, Boating & Golfing are all steps away! Only a short stroll to the sandy shoreline, a couple doors down from Freedom Oaks Golf Club, and downtown shopping and restaurants is only a 10 minute drive. This cottage is perfect as a year-round home, weekend getaway, or investment opportunity. Deceptively spacious inside, the smart layout makes it feel much larger than it appears. One level living offering 2 cozy bedrooms, renovated kitchen with stainless steel appliances, a walk-in pantry, laundry and bonus loft storage. After a day at the beach or golf course, unwind on the large entertainment deck perfect for hosting, morning coffee, or relaxing evenings by the lake breeze. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-29T19:44:54.010986+00:00"
+"Directions": "West on Sandy Bay Rd from Johnson Rd"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031329"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Crushed stone driveway"
1 => "Country residential"
]
+"LotSizeDimensions": "0.121"
+"PhotosChangeTimestamp": "2026-05-29T18:32:51Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T19:19:15Z"
+"Stories": "1.0"
+"StreetName": "SANDY BAY"
+"StreetNumber": "716"
+"StreetSuffix": "Road"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "1672.46"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youriguide.com/716_sandy_bay_rd_haldimand_on/"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29825850/716-sandy-bay-road-dunnville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1740256"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "RL, IPZ, IPZ"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 661
+"OriginalEntryTimestamp": "2026-05-29T18:32:51.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1308823"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1178878"
+"CoListOfficeNationalAssociationId": "1324631"
+"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]
]
+"DaysOnMarket": 52
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825850')"
+"ID": "1476534"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25448
+post_id: "1476536"
+post_author: 1
+"ListingKey": "29826169"
+"ListingId": "X13215362"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T12:15:07Z"
+"RFModificationTimestamp": "2026-07-19T12:20:07Z"
+"ListPrice": 380000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "716 SANDY BAY ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.637039
1 => 42.836678
]
+"Latitude": 42.836678
+"Longitude": -79.637039
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Escape to one of Lake Erie's most sought-after waterfront communities! 4 Season Cottage where Beaching, Boating & Golfing are all steps away! Only a short stroll to the sandy shoreline, a couple doors down from Freedom Oaks Golf Club, and downtown shopping and restaurants is only a 10 minute drive. This cottage is perfect as a year-round home, weekend getaway, or investment opportunity. Deceptively spacious inside, the smart layout makes it feel much larger than it appears. One level living offering 2 cozy bedrooms, renovated kitchen with stainless steel appliances, a walk-in pantry, laundry and bonus loft storage. After a day at the beach or golf course, unwind on the large entertainment deck perfect for hosting, morning coffee, or relaxing evenings by the lake breeze. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-29T19:28:23.194818+00:00"
+"Directions": "Cross Streets: Johnson Rd / Sandy Bay Rd. ** Directions: West on Sandy Bay Rd from Johnson Rd."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Wood/Piers"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041842"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "60.8 x 85.5 FT ; 60.82ft x 56.16ft x 95.42ft x 85.48ft"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T19:15:23Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T12:06:36Z"
+"Stories": "1.0"
+"StreetName": "Sandy Bay"
+"StreetNumber": "716"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1672.46"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youriguide.com/716_sandy_bay_rd_haldimand_on/"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29826169/716-sandy-bay-road-haldimand-dunnville-dunnville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 60.9
+"OriginalEntryTimestamp": "2026-05-29T18:57:47.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1317741"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 52
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29826169')"
+"ID": "1476536"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23523
+post_id: "1389901"
+post_author: 1
+"ListingKey": "29705753"
+"ListingId": "X13087430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T12:30:10Z"
+"RFModificationTimestamp": "2026-06-14T12:43:17Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "803 SANDY BAY ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6367799
1 => 42.836697
]
+"Latitude": 42.836697
+"Longitude": -79.6367799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to beautiful Sandy Bay - Lake Erie's hidden treasure where you find 2 TURN-KEY COTTAGES - for the PRICE OF ONE - situated on 0.17 ac terraced lot enjoying 50.46ft of frontage on quiet dead-end road - w/18 hole golf course & boat launch nearby- nestled 10 mins sw of Dunnville near Port Maitland's unique eco-biosphere - a haven for wildlife & migratory birds alike - 45-55 min to Hamilton. These 2 darling homes feature large waterfront decks - incredible venue to savor hypnotic sunrises & breathtaking western sunsets overlooking glistening Sandy Bay! If aquatic adventures are what your looking for - this place as it all - follow metal stairs fastened to armour stone break-wall & indulge yourself into hundreds of feet of waist deep water while your feet are soothed by the golden sand bottom - swim, paddle board, kayak, canoe, boat, jet-ski or fish at your doorstep - simply the BEST! EAST cottage affectionately known as "SUNRISE" - introduces 484sf of nautical inspired, totally renovated (2012-2013) living area offers open concept living/dining room/kitchen design ftrs functional 118sf loft, vaulted pine ceilings, newer stone fireplace, double patio door wo to low profile lakefront entertainment deck - continues w/2 bedrooms & modern 3pc bath. "SUNSET" - the larger WEST cottage - incs 502sf of bright, beautifully renovated (2010-2011) living space ftrs living/dining room/kitchen, spacious primary bedroom & 3pc bath - complimented w/gorgeous rustic original plank wood flooring, vaulted pine ceilings, double patio door lake front walk-out, new ductless heat/cool HVAC system-2025. Both cottages offer R-16 walls & R-20 attic insulation - serviced w/1400gal water cistern, 3000gal holding tank, natural gas, fibre internet, newer matching vinyl siding exterior, vinyl windows, concrete pier foundation, flag stone street facing patio, all appliances, furnishings & kitchen utensils. "Perfect" Multi-Generational situation, rental income potential or personal Lake Esca (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Microwave"
2 => "Two stoves"
3 => "Water Heater"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-06T01:39:49.769327+00:00"
+"Directions": "JOHNSON RD"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Wood/Piers"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2137360"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Waterway"
]
+"LotSizeDimensions": "50.5 x 131.3 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-06T00:41:20Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T12:21:21Z"
+"Stories": "1.0"
+"StreetName": "Sandy Bay"
+"StreetNumber": "803"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3059.38"
+"View": "Lake view,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/357890"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29705753/803-sandy-bay-road-haldimand-dunnville-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 50.6
+"OriginalEntryTimestamp": "2026-05-06T00:41:20.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389450"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 76
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29705753')"
+"ID": "1389901"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25473
+post_id: "1381821"
+post_author: 1
+"ListingKey": "29695123"
+"ListingId": "40826639"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T19:50:02Z"
+"RFModificationTimestamp": "2026-06-13T19:51:20Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.17
+"LivingArea": 986.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "803 SANDY BAY Road, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6421243
1 => 42.838891
]
+"Latitude": 42.838891
+"Longitude": -79.6421243
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to beautiful Sandy Bay - Lake Erie’s hidden treasure where you find 2 TURN-KEY COTTAGES - for the PRICE OF ONE - situated on 0.17 ac terraced lot enjoying 50.46ft of frontage on quiet dead-end road - w/18 hole golf course & boat launch nearby- nestled 10 mins sw of Dunnville near Port Maitland’s unique eco-biosphere - a haven for wildlife & migratory birds alike - 45-55 min to Hamilton. These 2 darling homes feature large waterfront decks - incredible venue to savor hypnotic sunrises & breathtaking western sunsets overlooking glistening Sandy Bay! If aquatic adventures are what your looking for - this place as it all - follow metal stairs fastened to armour stone break-wall & indulge yourself into hundreds of feet of waist deep water while your feet are soothed by the golden sand bottom - swim, paddle board, kayak, canoe, boat, jet-ski or fish at your doorstep - simply the BEST! EAST cottage affectionately known as “SUNRISE” - introduces 484sf of nautical inspired, totally renovated (2012-2013) living area offers open concept living/dining room/kitchen design ftrs functional 118sf loft, vaulted pine ceilings, newer stone fireplace, double patio door wo to low profile lakefront entertainment deck - continues w/2 bedrooms & modern 3pc bath. “SUNSET” - the larger WEST cottage - incs 502sf of bright, beautifully renovated (2010-2011) living space ftrs living/dining room/kitchen, spacious primary bedroom & 3pc bath - complimented w/gorgeous rustic original plank wood flooring, vaulted pine ceilings, double patio door lake front walk-out, new ductless heat/cool HVAC system-2025. Both cottages offer R-16 walls & R-20 attic insulation - serviced w/1400gal water cistern, 3000gal holding tank, natural gas, fibre internet, newer matching vinyl siding exterior, vinyl windows, concrete pier foundation, flag stone street facing patio, all appliances, furnishings & kitchen utensils. “Perfect” Multi-Generational situation, rental income potential or personal Lake Escape! (id:62783)"
+"Appliances": array:1 [
0 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"CreationDate": "2026-05-04T16:43:19.285802+00:00"
+"Directions": "JOHNSON ROAD TO SANDY BAY RD"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524319"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Visual exposure"
1 => "Crushed stone driveway"
2 => "Lot with lake"
3 => "Country residential"
]
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-05-04T16:10:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T19:41:01Z"
+"Stories": "1.0"
+"StreetName": "SANDY BAY"
+"StreetNumber": "803"
+"StreetSuffix": "Road"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "3059.38"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/357890"
+"WaterBodyName": "LAKE ERIE"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29695123/803-sandy-bay-road-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RL, IPZ"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 986
+"OriginalEntryTimestamp": "2026-05-04T16:10:44.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1111114"
+"ListOfficeNationalAssociationId": "1344650"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 77
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29695123')"
+"ID": "1381821"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25474
+post_id: "1160855"
+post_author: 1
+"ListingKey": "29372581"
+"ListingId": "40805858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T00:00:48Z"
+"RFModificationTimestamp": "2026-06-10T00:03:55Z"
+"ListPrice": 774900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.33
+"LivingArea": 1940.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "735 SANDY BAY Road, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6390382
1 => 42.8365092
]
+"Latitude": 42.8365092
+"Longitude": -79.6390382
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional Waterfront Living! Renovated and ready to move in as this lovely property comes Fully Furnished! Ample parking for family and guests, garage for boat storage, bunkie for outdoor toys, tiered decking and patios to maximize exposure to expansive waterfront views, a home that provides space for dining, games on rainy days, cozy fireplace gatherings and generous kitchen for meal prep, this property provides all the check and balances for a weekend getaways or year round living. 3 sliding doors waterside to patio and 2 skylights generate all the natural light possible. Income generation makes this a practical option for self-sustaining option or one that can be partially income supported. A new metal roof getting installed prior to closing. Located just a km away from Freedom Oaks Golf Club, 10 mins from Dunnville and 45 mins to Hamilton this gem will give you all the feels right from the start! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-02-18T19:09:21.793242+00:00"
+"Directions": "Port Maitland Rd, right on Johnson, right on Sandy Bay"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Crushed stone driveway"
1 => "Skylight"
2 => "Country residential"
3 => "Recreational"
]
+"LotSizeDimensions": "0.33"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-04-23T03:02:45Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:52:24Z"
+"Stories": "2.0"
+"StreetName": "SANDY BAY"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "4392"
+"View": "Lake view"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29372581/735-sandy-bay-road-dunnville"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RL, IPZ"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 1940
+"OriginalEntryTimestamp": "2026-02-18T17:19:23.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 152
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29372581')"
+"ID": "1160855"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]