array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29859296 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23335
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23337
+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 [
"RoomKey" => "1652347835"
"RoomType" => "Bedroom"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.46Z"
]
1 => array:11 [
"RoomKey" => "1652347836"
"RoomType" => "Bedroom"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.46Z"
]
2 => array:11 [
"RoomKey" => "1652347837"
"RoomType" => "Bedroom"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.47Z"
]
3 => array:11 [
"RoomKey" => "1652347838"
"RoomType" => "Primary Bedroom"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.47Z"
]
4 => array:11 [
"RoomKey" => "1652347839"
"RoomType" => "Sitting room"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.47Z"
]
5 => array:11 [
"RoomKey" => "1652347840"
"RoomType" => "Living room"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 24'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.48Z"
]
6 => array:11 [
"RoomKey" => "1652347841"
"RoomType" => "3pc Bathroom"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.48Z"
]
7 => array:11 [
"RoomKey" => "1652347842"
"RoomType" => "Dining room"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.48Z"
]
8 => array:11 [
"RoomKey" => "1652347843"
"RoomType" => "Kitchen"
"ListingId" => "40836862"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859296"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T14:20:08.48Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29859296_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/bfbb6f1441eb496b6861608ed2a41ce1.webp"
"MediaSize" => 230111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-bfbb6f1441eb496b6861608ed2a41ce1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29859296_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/24caea6ac596e8ce1f851cf9351d66f2.webp"
"MediaSize" => 166676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-24caea6ac596e8ce1f851cf9351d66f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29859296_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/a16d3b7f15bb3506865cd38813706359.webp"
"MediaSize" => 216382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-a16d3b7f15bb3506865cd38813706359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29859296_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/7e12f0439059a200f2566a92fd284430.webp"
"MediaSize" => 246335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-7e12f0439059a200f2566a92fd284430.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29859296_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/4c24e23ae240ca1dc4c97e07b1c0e21e.webp"
"MediaSize" => 228554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-4c24e23ae240ca1dc4c97e07b1c0e21e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29859296_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/1eff6b19f8e0f31b783205d33dee1daa.webp"
"MediaSize" => 229156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-1eff6b19f8e0f31b783205d33dee1daa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29859296_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/7af7705ef87f2d22b958b316cb8bb85d.webp"
"MediaSize" => 216011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-7af7705ef87f2d22b958b316cb8bb85d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29859296_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/d4b34c6b5294907212c198b7e54a8183.webp"
"MediaSize" => 250563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-d4b34c6b5294907212c198b7e54a8183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29859296_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/6cd92df09db815080b1d130bc507acfa.webp"
"MediaSize" => 245825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-6cd92df09db815080b1d130bc507acfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29859296_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/0eb93fb022c208cddeb026f76da908db.webp"
"MediaSize" => 245696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-0eb93fb022c208cddeb026f76da908db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29859296_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/c337cf2bf504a73c2940bf22dd1dd1e1.webp"
"MediaSize" => 240030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-c337cf2bf504a73c2940bf22dd1dd1e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29859296_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/1f6e5265e10f2c7037af4beb0f75dd1a.webp"
"MediaSize" => 204017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-1f6e5265e10f2c7037af4beb0f75dd1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29859296_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/61d86e3ccd7859fe1635357786e484bb.webp"
"MediaSize" => 206701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-61d86e3ccd7859fe1635357786e484bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29859296_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/94ec0638472b5b15e9239388359c30cb.webp"
"MediaSize" => 126239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-94ec0638472b5b15e9239388359c30cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29859296_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/3158818e5322d786d93b518dc829df95.webp"
"MediaSize" => 104215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-3158818e5322d786d93b518dc829df95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29859296_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/a5b05098e18da2a6f42657141c58ed2e.webp"
"MediaSize" => 113329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-a5b05098e18da2a6f42657141c58ed2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29859296_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/f3cb71588f1296102e420a5f7573af60.webp"
"MediaSize" => 97677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-f3cb71588f1296102e420a5f7573af60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29859296_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/13500687b198c2658c973b3262882651.webp"
"MediaSize" => 123922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-13500687b198c2658c973b3262882651.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29859296_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/780abbfd5d9aa214f3352840ec52105a.webp"
"MediaSize" => 98779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-780abbfd5d9aa214f3352840ec52105a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29859296_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/b02edccefb8145a8f0889f3b7970b7f2.webp"
"MediaSize" => 119986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-b02edccefb8145a8f0889f3b7970b7f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29859296_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/d4047b5cd2a19bfe2ab4acf655353feb.webp"
"MediaSize" => 107917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-d4047b5cd2a19bfe2ab4acf655353feb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29859296_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/8126ec2bab9e2619c9a47b82486856b6.webp"
"MediaSize" => 121452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-8126ec2bab9e2619c9a47b82486856b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29859296_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/87ddb101414659e3080244f227c273bc.webp"
"MediaSize" => 158794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-87ddb101414659e3080244f227c273bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29859296_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/a8341b16006edb2c90cb2ccf960d66c1.webp"
"MediaSize" => 116554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-a8341b16006edb2c90cb2ccf960d66c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29859296_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/d770fb1b2030b08038dc8bf89ac0d35a.webp"
"MediaSize" => 85595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-d770fb1b2030b08038dc8bf89ac0d35a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 1"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29859296_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/37e7903a6741b34502737175838f78fe.webp"
"MediaSize" => 81831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-37e7903a6741b34502737175838f78fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29859296_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/26eac83ccfcf9ee2b8506970964a23cf.webp"
"MediaSize" => 85030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-26eac83ccfcf9ee2b8506970964a23cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29859296_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/539086841b12686a3ac6499d514d1eac.webp"
"MediaSize" => 90900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-539086841b12686a3ac6499d514d1eac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29859296_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/db183bbbb9b80a185826a10e27a4381d.webp"
"MediaSize" => 118539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-db183bbbb9b80a185826a10e27a4381d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29859296_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/576fbca2278f8a5ba31a06b3349f59c8.webp"
"MediaSize" => 101093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-576fbca2278f8a5ba31a06b3349f59c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29859296_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/ff7c7000e9e1de8d1220fa613937e2c2.webp"
"MediaSize" => 124697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-ff7c7000e9e1de8d1220fa613937e2c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29859296_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/6c83e9a5e42a46ee59cfb76f42250937.webp"
"MediaSize" => 117328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-6c83e9a5e42a46ee59cfb76f42250937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29859296_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/16db22819f78436c69e9bbe24c8850da.webp"
"MediaSize" => 248888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-16db22819f78436c69e9bbe24c8850da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29859296_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/05ddac27bf5d712881a80b50e9c4c968.webp"
"MediaSize" => 245836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-05ddac27bf5d712881a80b50e9c4c968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29859296_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/fdd81184c323db0a17da1f454e66f0a3.webp"
"MediaSize" => 225174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-fdd81184c323db0a17da1f454e66f0a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29859296_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/97966f2c1b85650d73c5f3c70813d0ae.webp"
"MediaSize" => 171534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-97966f2c1b85650d73c5f3c70813d0ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29859296_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/e9318ce160e3fba7596920ea3360e013.webp"
"MediaSize" => 164470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-e9318ce160e3fba7596920ea3360e013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29859296_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/d1d3730888dfb2ccd0a1b3d037f80b19.webp"
"MediaSize" => 155200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-d1d3730888dfb2ccd0a1b3d037f80b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29859296_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/7c72642c7d1ff35e0582d58a8fa5209d.webp"
"MediaSize" => 161622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-7c72642c7d1ff35e0582d58a8fa5209d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29859296_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/c86bd9de29fdae819f45b55160994c53.webp"
"MediaSize" => 214139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-c86bd9de29fdae819f45b55160994c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29859296_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/f1395b570f4318788e5d26d738bd0219.webp"
"MediaSize" => 197573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-f1395b570f4318788e5d26d738bd0219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29859296_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/ab14f5c3f36fa9336863e1a61273fa55.webp"
"MediaSize" => 215962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-ab14f5c3f36fa9336863e1a61273fa55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29859296_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/6f58e67c0eca63be4ae53e6dc36dda4c.webp"
"MediaSize" => 222752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-6f58e67c0eca63be4ae53e6dc36dda4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29859296_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/9ed217f2b62cd3a0ae2c2c7030dc9088.webp"
"MediaSize" => 142256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-9ed217f2b62cd3a0ae2c2c7030dc9088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29859296_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/8f9c706b2953d7aee47b16b58326f29b.webp"
"MediaSize" => 221103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-8f9c706b2953d7aee47b16b58326f29b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29859296_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/fe8166edeefae6055763bf2cce7f0c5a.webp"
"MediaSize" => 263424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-fe8166edeefae6055763bf2cce7f0c5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29859296_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/d1ecf280d828d8f11df957709120e54d.webp"
"MediaSize" => 271058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-d1ecf280d828d8f11df957709120e54d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29859296_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859296/aa603967b895249316a689e6b872348a.webp"
"MediaSize" => 233905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859296/thumbnail-aa603967b895249316a689e6b872348a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836862"
"ResourceRecordKey" => "29859296"
"ModificationTimestamp" => "2026-06-05T14:20:08.4Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859296')"
+"ID": "1498919"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291472" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24711
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524894" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29859296'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25124
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29859296'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29859296' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6348376 42.8370827)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1507717"
+post_author: 1
+"ListingKey": "29872752"
+"ListingId": "X13416978"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T22:05:44Z"
+"RFModificationTimestamp": "2026-06-08T22:08:43Z"
+"ListPrice": 3299000.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:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Stove"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Oven - Built-In"
8 => "Window Coverings"
9 => "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-06-08T21:51:47.617361+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-06-08T21:27:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T21:58:24Z"
+"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" => "1655294060"
"RoomType" => "Office"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29872752"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.28Z"
]
1 => array:11 [
"RoomKey" => "1655294061"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13416978"
"RoomLevel" => "Lower level"
"RoomWidth" => 9.78
"ListingKey" => "29872752"
"RoomLength" => 12.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.29Z"
]
2 => array:11 [
"RoomKey" => "1655294062"
"RoomType" => "Living room"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 6.32
"ListingKey" => "29872752"
"RoomLength" => 7.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.29Z"
]
3 => array:11 [
"RoomKey" => "1655294063"
"RoomType" => "Family room"
"ListingId" => "X13416978"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.22
"ListingKey" => "29872752"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.3Z"
]
4 => array:11 [
"RoomKey" => "1655294064"
"RoomType" => "Other"
"ListingId" => "X13416978"
"RoomLevel" => "Lower level"
"RoomWidth" => 8.84
"ListingKey" => "29872752"
"RoomLength" => 3.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.3Z"
]
5 => array:11 [
"RoomKey" => "1655294065"
"RoomType" => "Kitchen"
"ListingId" => "X13416978"
"RoomLevel" => "Flat"
"RoomWidth" => 3.15
"ListingKey" => "29872752"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.3Z"
]
6 => array:11 [
"RoomKey" => "1655294066"
"RoomType" => "Bedroom"
"ListingId" => "X13416978"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "29872752"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.31Z"
]
7 => array:11 [
"RoomKey" => "1655294067"
"RoomType" => "Bathroom"
"ListingId" => "X13416978"
"RoomLevel" => "Flat"
"RoomWidth" => 1.93
"ListingKey" => "29872752"
"RoomLength" => 2.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.32Z"
]
8 => array:11 [
"RoomKey" => "1655294068"
"RoomType" => "Sunroom"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "29872752"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.32Z"
]
9 => array:11 [
"RoomKey" => "1655294069"
"RoomType" => "Dining room"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 4.09
"ListingKey" => "29872752"
"RoomLength" => 6.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.32Z"
]
10 => array:11 [
"RoomKey" => "1655294070"
"RoomType" => "Kitchen"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 4.83
"ListingKey" => "29872752"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.33Z"
]
11 => array:11 [
"RoomKey" => "1655294071"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 4.47
"ListingKey" => "29872752"
"RoomLength" => 5.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.33Z"
]
12 => array:11 [
"RoomKey" => "1655294072"
"RoomType" => "Bedroom"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 4.39
"ListingKey" => "29872752"
"RoomLength" => 4.93
…4
]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "Dunnville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29872752/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-06-08T21:27:28.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1333075"
+"ListOfficeNationalAssociationId": "1337412"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872752')"
+"ID": "1507717"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 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 [ …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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863855')"
+"ID": "1502042"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1476534"
+post_author: 1
+"ListingKey": "29825850"
+"ListingId": "40833672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:45Z"
+"RFModificationTimestamp": "2026-06-06T20:48:03Z"
+"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:62783)"
+"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-06-06T20:22: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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825850')"
+"ID": "1476534"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1476536"
+post_author: 1
+"ListingKey": "29826169"
+"ListingId": "X13215362"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T12:31:21Z"
+"RFModificationTimestamp": "2026-06-07T12:56:05Z"
+"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:62783)"
+"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-06-07T12:21:09Z"
+"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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29826169')"
+"ID": "1476536"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1424566"
+post_author: 1
+"ListingKey": "29754707"
+"ListingId": "40830517"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:13Z"
+"RFModificationTimestamp": "2026-06-02T16:34:05Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W8"
+"UnparsedAddress": "277 BAYGROVE Line, Dunnville, Ontario N1A2W8"
+"Coordinates": array:2 [
0 => -79.651975
1 => 42.8440959
]
+"Latitude": 42.8440959
+"Longitude": -79.651975
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the peace & serenity of Baygrove Line! Located down a quiet private road, you will feel like you are in Muskoka as you hear the birds and the lake waves. Gorgeous views from the wall of lakeside windows will relax you immediately as you enter this renovated cottage/home. Open concept living, dining and kitchen with wood plank floors make the space feel airy and spacious. Enjoy the living room views and cozy up with the woodstove on the cooler nights. Fall asleep in the primary bedroom with the Lake Erie breeze and lapping of the water. An updated 3 pc bath and a second bedroom complete the main living area. ***BONUS - this property offers a 24 x 24 detached garage/workshop with a steel roof and a full finished loft area above for your guests (3rd bedrm). Attached to the garage is a shed and a pottery barn with large propane kiln. The waterfront yard offers a concrete patio and a 2018 constructed breakwall (Wilkenson). Enjoy both sunrise and sunsets on your patio! Book today to view and start living your waterfront dream! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Wine Fridge"
2 => "Stove"
3 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-14T22:57:43.445244+00:00"
+"Directions": "KINGS ROW TO BAYGROVE LINE"
+"ExteriorFeatures": array:1 [
0 => "Hardboard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Piled"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Stove"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523834"
+"ListOfficeKey": "283383"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Country residential"
]
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-05-14T20:34:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:23:42Z"
+"Stories": "1.0"
+"StreetName": "BAYGROVE"
+"StreetNumber": "277"
+"StreetSuffix": "Line"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "3440"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Telephone"
]
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/363633"
+"WaterBodyName": "Lake Erie"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29754707/277-baygrove-line-dunnville"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2109069"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283383"
+"GeocodeManualYN": true
+"ZoningDescription": "RL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-05-14T20:31:00.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1097711"
+"ListOfficeNationalAssociationId": "1328451"
+"CoListAgentNationalAssociationId": "1377857"
+"CoListOfficeNationalAssociationId": "1328451"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29754707')"
+"ID": "1424566"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1389901"
+post_author: 1
+"ListingKey": "29705753"
+"ListingId": "X13087430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:25:39Z"
+"RFModificationTimestamp": "2026-06-09T22:31:30Z"
+"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-09T22:17:25Z"
+"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": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29705753')"
+"ID": "1389901"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23349
+post_id: "1381821"
+post_author: 1
+"ListingKey": "29695123"
+"ListingId": "40826639"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T21:30:31Z"
+"RFModificationTimestamp": "2026-06-09T21:33:12Z"
+"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:62650)"
+"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-09T21:22:25Z"
+"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": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29695123')"
+"ID": "1381821"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1338088"
+post_author: 1
+"ListingKey": "29629301"
+"ListingId": "X13020128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-25T00:01:05Z"
+"RFModificationTimestamp": "2026-05-25T00:08:47Z"
+"ListPrice": 469900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W8"
+"UnparsedAddress": "282 BAYGROVE LINE, Haldimand (Dunnville), Ontario N1A2W8"
+"Coordinates": array:2 [
0 => -79.6528613
1 => 42.8444402
]
+"Latitude": 42.8444402
+"Longitude": -79.6528613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Charming year-round lakeside retreat in a serene & private setting! Welcome to 'cottage country south' - this two bedroom + loft retreat is ready for you to come and unwind. Just steps to the sandy shores of Lake Erie (including two right-of-ways), this beautifully renovated home (800sf) offers a tranquil lifestyle ideal for full-time living or a weekend getaway from the 'hustle & bustle' of the city! The property (75'x100') is fully fenced providing security, privacy, and a great space for kids and pets to play freely! Enjoy your morning coffee or evening nightcap on a spacious 12x26 south facing deck where gentle lake breezes & an array of birdsongs create a relaxing setting. Stepping inside, your eyes are immediately drawn to the open concept layout, the cleanliness, and the 'nautical' inspired décor & finishes. The main focal point is a 17x17 living room highlighted by a 10' cathedral ceiling lined with 'white-wash' t/g pine - pulled straight from a magazine! The same flawless laminate flooring leads you to a defined dining space drenched with natural light and seamless connected to a 'ultra' functional galley-style kitchen. An updated and spacious 3pc bath serves this cottage. Completing this cottage are the sleeping quarters - two practical sized bedrooms + bonus loft space with an extra bed - perfect for family/friends that are sure to visit you at the lake! Bonus: spray-foamed crawlspace '22, septic pumped in '25, hwt '21, 12x10 shed w/ hydro, 7x7 shed, metal roof '20, patio door '21, exterior paint '21, +++! Avoid the traffic and inflated prices in the north - and 'escape to the lake' in the south - 5 min to town and all its' amenities, close to golf & boat slip. There's 'no life like lake life'! (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-04-20T19:34:30.273217+00:00"
+"Directions": "KING'S ROW"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Wood/Piers"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Carpet Free"
]
+"LotSizeDimensions": "75 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-04-20T17:17:04Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T23:49:48Z"
+"Stories": "1.0"
+"StreetName": "BAYGROVE"
+"StreetNumber": "282"
+"StreetSuffix": "Line"
+"TaxAnnualAmount": "2107.58"
+"VirtualTourURLUnbranded": "https://track.pstmrk.it/3s/book.allisonmediaco.com%2Fsites%2Femondgak%2Funbranded/cUpU/CtPEAQ/AQ/8e59ee63-53d5-4456-b0b9-eefb0081ccf5/3/exxWRyWZyc"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29629301/282-baygrove-line-haldimand-dunnville-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 75.0
+"OriginalEntryTimestamp": "2026-04-20T17:17:04.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1243509"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 50
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29629301')"
+"ID": "1338088"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1335109"
+post_author: 1
+"ListingKey": "29628744"
+"ListingId": "40822189"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:30Z"
+"RFModificationTimestamp": "2026-06-02T17:43:38Z"
+"ListPrice": 469900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W8"
+"UnparsedAddress": "282 BAYGROVE Line, Dunnville, Ontario N1A2W8"
+"Coordinates": array:2 [
0 => -79.6526746
1 => 42.844507
]
+"Latitude": 42.844507
+"Longitude": -79.6526746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Charming year-round lakeside retreat in a serene & private setting! Welcome to ‘cottage country south’ – this two bedroom + loft retreat is ready for you to come and unwind. Just steps to the sandy shores of Lake Erie (including two right-of-ways), this beautifully renovated home (800sf) offers a tranquil lifestyle ideal for full-time living or a weekend getaway from the ‘hustle & bustle’ of the city! The property (75’x100’) is fully fenced providing security, privacy, and a great space for kids and pets to play freely! Enjoy your morning coffee or evening nightcap on a spacious 12x26 south facing deck where gentle lake breezes & an array of birdsongs create a relaxing setting. Stepping inside, your eyes are immediately drawn to the open concept layout, the cleanliness, and the ‘nautical’ inspired décor & finishes. The main focal point is a 17x17 living room highlighted by a 10’ cathedral ceiling lined with ‘white-wash’ t/g pine – pulled straight from a magazine! The same flawless laminate flooring leads you to a defined dining space drenched with natural light and seamless connected to a ‘ultra’ functional galley-style kitchen. An updated and spacious 3pc bath serves this cottage. Completing this cottage are the sleeping quarters – two practical sized bedrooms + bonus loft space with an extra bed – perfect for family/friends that are sure to visit you at the lake! Bonus: spray-foamed crawlspace ’22, septic pumped in ’25, hwt ’21, 12x10 shed w/ hydro, 7x7 shed, metal roof ’20, patio door ’21, exterior paint ’21, +++! Avoid the traffic and inflated prices in the north – and ‘escape to the lake’ in the south – 5 min to town and all its’ amenities, close to golf & boat slip. There’s ‘no life like lake life’! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-04-20T17:56:24.807930+00:00"
+"Directions": "SOUTH DOWN MARSHALL ROAD, RIGHT (WEST) ON KING'S ROW, SOUTH ON BAYGROVE LINE TOWARDS LAKE."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1984644"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Country residential"
]
+"PhotosChangeTimestamp": "2026-05-06T02:51:00Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:40:10Z"
+"Stories": "1.0"
+"StreetName": "BAYGROVE"
+"StreetNumber": "282"
+"StreetSuffix": "Line"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "2107.58"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29628744/282-baygrove-line-dunnville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D A6F2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 75.0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-04-20T16:31:48.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1269332"
+"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": 50
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29628744')"
+"ID": "1335109"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 16
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]
