array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29048128 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23333
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23335
+post_id: "917755"
+post_author: 1
+"ListingKey": "29048128"
+"ListingId": "X12490526"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T07:15:30Z"
+"RFModificationTimestamp": "2025-12-15T07:19:38Z"
+"ListPrice": 585000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "4 DEARDEN LANE, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.61452
1 => 42.842645
]
+"Latitude": 42.842645
+"Longitude": -79.61452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover the perfect opportunity to build your dream retreat on a private lane along the shores of Lake Erie. This impressive 0.68 acre property offers 101 feet of breathtaking lake frontage and a beautiful flat rock beach - ideal for relaxing, swimming, or watching the sunset. Enjoy the peaceful setting just minutes from Freedom Oaks Golf Course, Sandy Bay and Port Maitland Village. Current owner has obtained floorpans and grading plan. (id:62650)"
+"CreationDate": "2025-10-30T23:24:55.839312+00:00"
+"Directions": "Cross Streets: Johnson Rd. ** Directions: Port Maitland Rd to Johnson Rd to Dearden Lane."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235081"
+"ListOfficeKey": "291490"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "35.45 x 371 FT"
+"PhotosChangeTimestamp": "2025-10-30T16:18:14Z"
+"PhotosCount": 30
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T07:03:27Z"
+"StreetName": "Dearden"
+"StreetNumber": "4"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "2814.63"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "View of water,Direct Water View"
+"WaterBodyName": "Lake Erie"
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29048128/4-dearden-lane-haldimand-dunnville-dunnville"
+"GeocodeManualYN": false
+"ZoningDescription": "D A7F2"
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 35.5
+"OriginalEntryTimestamp": "2025-10-30T16:18:14.79Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6285736024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/99641345ace2c95a34244e597783bccb.webp"
"MediaSize" => 260999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-99641345ace2c95a34244e597783bccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6285736027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/c9e26785461d199c50db5c65400faa7a.webp"
"MediaSize" => 216329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-c9e26785461d199c50db5c65400faa7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lot lines approximate"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6285736030"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/a278f0dcf853a179caef065310157e62.webp"
"MediaSize" => 169203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-a278f0dcf853a179caef065310157e62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6285736031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/8b9b1370935eca816f6710c643b5e42a.webp"
"MediaSize" => 141966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-8b9b1370935eca816f6710c643b5e42a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6285736034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/3435dc9525c29805efa051d2222e933e.webp"
"MediaSize" => 172134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-3435dc9525c29805efa051d2222e933e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6285736036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/26181759d03e6e74b6d7c8b30d1eb64f.webp"
"MediaSize" => 214232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-26181759d03e6e74b6d7c8b30d1eb64f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6285736039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/8b697ef7a91fbc8beba5fde9acf8c34f.webp"
"MediaSize" => 202470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-8b697ef7a91fbc8beba5fde9acf8c34f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6285736040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/efd2126cf17ea377620f2b996ce5221a.webp"
"MediaSize" => 181691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-efd2126cf17ea377620f2b996ce5221a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6285736043"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/e3028290ad04bf730ab92554410a8840.webp"
"MediaSize" => 198566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-e3028290ad04bf730ab92554410a8840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6285736046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/98c9a5aadc6e5f41a7dde5e72bb6adfc.webp"
"MediaSize" => 199021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-98c9a5aadc6e5f41a7dde5e72bb6adfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6285736048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/6e261cefabc5fe8d2c750e57588a46ff.webp"
"MediaSize" => 200149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-6e261cefabc5fe8d2c750e57588a46ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6285736051"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/60d86e6a1c6e3093394e5f99f6457d5a.webp"
"MediaSize" => 187628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-60d86e6a1c6e3093394e5f99f6457d5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6285736054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/61dbc783c3e8a5bcbf184801745111bb.webp"
"MediaSize" => 189343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-61dbc783c3e8a5bcbf184801745111bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6285736056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/9e3a232955978d2564c66937792691fb.webp"
"MediaSize" => 183498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-9e3a232955978d2564c66937792691fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6285736059"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/ab2a97282d4a3e95e34c01c0a82adbc6.webp"
"MediaSize" => 185451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-ab2a97282d4a3e95e34c01c0a82adbc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6285736061"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/8075bd6d7836f7cd6d591364b0433400.webp"
"MediaSize" => 189222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-8075bd6d7836f7cd6d591364b0433400.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6285736064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/8599643f7b59078cb9b6023363b50592.webp"
"MediaSize" => 220037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-8599643f7b59078cb9b6023363b50592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6285736066"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/d8ac74a888a49cf0ee19d785f4c563a4.webp"
"MediaSize" => 212701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-d8ac74a888a49cf0ee19d785f4c563a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6285736072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/540ae2479542dfcc333f81391b24ba9f.webp"
"MediaSize" => 222218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-540ae2479542dfcc333f81391b24ba9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6285736076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/65305e1d50fa91a549c3354c83e8116a.webp"
"MediaSize" => 204958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-65305e1d50fa91a549c3354c83e8116a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6285736080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/c4064cf20326a3b394d44aeaaca149ca.webp"
"MediaSize" => 198283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-c4064cf20326a3b394d44aeaaca149ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6285736084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/5bb27250dd2180e223edce6c81bf78d5.webp"
"MediaSize" => 186574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-5bb27250dd2180e223edce6c81bf78d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6285736088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/89184925cf966a3ae39cc6b539e4c044.webp"
"MediaSize" => 153343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-89184925cf966a3ae39cc6b539e4c044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6285736092"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/efc2123f755c69e14f02312ad6b0bfc9.webp"
"MediaSize" => 154885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-efc2123f755c69e14f02312ad6b0bfc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6285736096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/65abb4c370941c974c0d2e08b74df959.webp"
"MediaSize" => 156803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-65abb4c370941c974c0d2e08b74df959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6285736100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/d3dfe0e17b84f368c70d131c810b2b25.webp"
"MediaSize" => 155945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-d3dfe0e17b84f368c70d131c810b2b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6285736104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/1fa491ffb09eb757255bb20c770b43b8.webp"
"MediaSize" => 161367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-1fa491ffb09eb757255bb20c770b43b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6285736110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/c61fee57dac9d6e92b1e825fec3be830.webp"
"MediaSize" => 166922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-c61fee57dac9d6e92b1e825fec3be830.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6285736114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/ad4d0529f4b134c9b5d4905a65e728be.webp"
"MediaSize" => 143099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-ad4d0529f4b134c9b5d4905a65e728be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6285736119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29048128/aa79e6a07bb95decff22f43e3378d3ad.webp"
"MediaSize" => 154903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29048128/thumbnail-aa79e6a07bb95decff22f43e3378d3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12490526"
"ResourceRecordKey" => "29048128"
"ModificationTimestamp" => "2025-10-30T16:18:14.8Z"
]
]
+"DaysOnMarket": 222
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29048128')"
+"ID": "917755"
}
]
+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 291490" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24664
+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 2235081" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24677
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24749
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2235081"
+"ModificationTimestamp": "2024-12-02T23:09:53Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2235081"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2235081')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29048128'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25060
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29048128'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25076
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29048128' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.61452 42.842645)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25123
+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
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.34Z"
]
13 => array:11 [
"RoomKey" => "1655294073"
"RoomType" => "Laundry room"
"ListingId" => "X13416978"
"RoomLevel" => "Main level"
"RoomWidth" => 2.51
"ListingKey" => "29872752"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.34Z"
]
14 => array:11 [
"RoomKey" => "1655294074"
"RoomType" => "Bedroom"
"ListingId" => "X13416978"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.94
"ListingKey" => "29872752"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.35Z"
]
15 => array:11 [
"RoomKey" => "1655294075"
"RoomType" => "Bedroom"
"ListingId" => "X13416978"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.53
"ListingKey" => "29872752"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T21:58:24.35Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29872752_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/6d9d32e9aa6b76ff319fc97a3fc2522b.webp"
"MediaSize" => 353707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-6d9d32e9aa6b76ff319fc97a3fc2522b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29872752_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/2328d078466bf1c900529d3e7457f2ce.webp"
"MediaSize" => 293136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-2328d078466bf1c900529d3e7457f2ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29872752_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/904bf71178b0a6f5c7b8036f50693d6e.webp"
"MediaSize" => 378619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-904bf71178b0a6f5c7b8036f50693d6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29872752_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/38cc16c662e73f08e5bdf4905dab318b.webp"
"MediaSize" => 244123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-38cc16c662e73f08e5bdf4905dab318b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29872752_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/be0da1d5ec332105f96400f3eea7017a.webp"
"MediaSize" => 244373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-be0da1d5ec332105f96400f3eea7017a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29872752_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/a48ecc399fd308f51e8178873ed7d16e.webp"
"MediaSize" => 210592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-a48ecc399fd308f51e8178873ed7d16e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29872752_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/30a77f852cf1e79d08069a0e603f68b5.webp"
"MediaSize" => 242166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-30a77f852cf1e79d08069a0e603f68b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29872752_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/56ce364a94d9fea5fa302be329324ebc.webp"
"MediaSize" => 237583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-56ce364a94d9fea5fa302be329324ebc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29872752_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/a2950c21e0752c3763674d8da6e18a68.webp"
"MediaSize" => 234155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-a2950c21e0752c3763674d8da6e18a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29872752_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/ba90384dd564e165ee3790ed98a75b11.webp"
"MediaSize" => 222972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-ba90384dd564e165ee3790ed98a75b11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29872752_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/aff9eed8b5b4807a75f0685728775a35.webp"
"MediaSize" => 241284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-aff9eed8b5b4807a75f0685728775a35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29872752_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/e39b939bb31d7a3634cdc5e0efd7b1e1.webp"
"MediaSize" => 260360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-e39b939bb31d7a3634cdc5e0efd7b1e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29872752_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/142e6ab9019917e6a7efc61976ef1c45.webp"
"MediaSize" => 342640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-142e6ab9019917e6a7efc61976ef1c45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29872752_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/6750d887ebe4dc2f5b6f81682a12da3d.webp"
"MediaSize" => 313790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-6750d887ebe4dc2f5b6f81682a12da3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29872752_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/bc358b9308f10d9013bce792fcac2c2e.webp"
"MediaSize" => 206197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-bc358b9308f10d9013bce792fcac2c2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29872752_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/11bc8ef2728f37dc1cd0b8f2cbd7ec9a.webp"
"MediaSize" => 339056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-11bc8ef2728f37dc1cd0b8f2cbd7ec9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29872752_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/8388e5674eb5c2e36622bc2fd2c681de.webp"
"MediaSize" => 341923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-8388e5674eb5c2e36622bc2fd2c681de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29872752_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/44081a3f980851e155be5b5133e10d01.webp"
"MediaSize" => 298113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-44081a3f980851e155be5b5133e10d01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29872752_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/7ee65aa8e6c75fb60187c5c441f4da2f.webp"
"MediaSize" => 342508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-7ee65aa8e6c75fb60187c5c441f4da2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29872752_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/e3fd595714dd33126730b6a5a10b5325.webp"
"MediaSize" => 274413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-e3fd595714dd33126730b6a5a10b5325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29872752_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/22511174fa56fe2a788e03730f85c87c.webp"
"MediaSize" => 295010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-22511174fa56fe2a788e03730f85c87c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29872752_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872752/2d1daa39cb294f5f17dac37492d5793e.webp"
"MediaSize" => 229312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872752/thumbnail-2d1daa39cb294f5f17dac37492d5793e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416978"
"ResourceRecordKey" => "29872752"
"ModificationTimestamp" => "2026-06-08T21:27:28.06Z"
]
22 => array:13 [
"Order" => 23
…12
]
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 {#25125
+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 {#25122
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859296')"
+"ID": "1498919"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25124
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25119
+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 {#23347
+post_id: "1360295"
+post_author: 1
+"ListingKey": "29664096"
+"ListingId": "40824657"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T20:30:42Z"
+"RFModificationTimestamp": "2026-06-08T20:42:08Z"
+"ListPrice": 979900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3221.0
+"BuildingAreaTotal": 0
+"City": "Dunnville"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "401 LIGHTHOUSE Drive, Dunnville, Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.612621
1 => 42.8453029
]
+"Latitude": 42.8453029
+"Longitude": -79.612621
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your family’s next chapter, just a short stroll from the shores of Lake Erie, nestled in a peaceful enclave of beautiful homes on spacious half-acre+ lots. This thoughtfully designed custom home offers the perfect blend of comfort, style, and room to grow. With 3+3 bedrooms and 3 full bathrooms, there’s space for everyone; whether it’s busy mornings, cozy evenings, or hosting loved ones. The bright, open-concept main floor features soaring vaulted ceilings, elegant stone countertops, and a warm custom fireplace with a solid wood mantle, an inviting place to gather and make memories. A convenient mudroom and attached 2-car garage help keep everyday life running smoothly. Step outside to a generous 16 x 14 covered porch, ideal for family barbecues, morning coffee, or simply relaxing while the kids play in the expansive backyard. Downstairs, the fully finished basement offers even more room to unwind, complete with theatre-style seating: perfect for movie nights and family time. Additional features include a fully paved driveway with ample parking (room for 10+ vehicles), side space for a boat, RV, or trailer, a large backyard shed, and practical upgrades like a 6000-gallon cistern, rainwater recapture system, and UV water filtration. All of this, just a short 10-minute drive to town—giving you the tranquility of country living with everyday conveniences close by. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-28T01:41:51.295045+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1921671"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Country residential"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T20:10:25Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T20:21:42Z"
+"Stories": "1.0"
+"StreetName": "LIGHTHOUSE"
+"StreetNumber": "401"
+"StreetSuffix": "Drive"
+"SubdivisionName": "602 - Dunn"
+"TaxAnnualAmount": "5181"
+"VirtualTourURLUnbranded": "https://youtu.be/D8rj6kejldI"
+"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/29664096/401-lighthouse-drive-dunnville"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1908303"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "RL (H)"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1621
+"BelowGradeFinishedArea": 1600
+"OriginalEntryTimestamp": "2026-04-28T00:19:19.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1227109"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1221214"
+"CoListOfficeNationalAssociationId": "1324631"
+"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": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29664096')"
+"ID": "1360295"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "1360395"
+post_author: 1
+"ListingKey": "29664202"
+"ListingId": "X13050650"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T21:00:14Z"
+"RFModificationTimestamp": "2026-06-08T21:03:04Z"
+"ListPrice": 979900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "401 LIGHTHOUSE DRIVE, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6127243
1 => 42.8454552
]
+"Latitude": 42.8454552
+"Longitude": -79.6127243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your family's next chapter, just a short stroll from the shores of Lake Erie, nestled in a peaceful enclave of beautiful homes on spacious half-acre+ lots. This thoughtfully designed custom home offers the perfect blend of comfort, style, and room to grow. With 3+3 bedrooms and 3 full bathrooms, there's space for everyone; whether it's busy mornings, cozy evenings, or hosting loved ones. The bright, open-concept main floor features soaring vaulted ceilings, elegant stone countertops, and a warm custom fireplace with a solid wood mantle, an inviting place to gather and make memories. A convenient mudroom and attached 2-car garage help keep everyday life running smoothly. Step outside to a generous 16 x 14 covered porch, ideal for family barbecues, morning coffee, or simply relaxing while the kids play in the expansive backyard. Downstairs, the fully finished basement offers even more room to unwind, complete with theatre-style seating: perfect for movie nights and family time. Additional features include a fully paved driveway with ample parking (room for 10+ vehicles), side space for a boat, RV, or trailer, a large backyard shed, and practical upgrades like a 6000-gallon cistern, rainwater recapture system, and UV water filtration. All of this, just a short 10-minute drive to town-giving you the tranquility of country living with everyday conveniences close by. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-04-28T01:39:35.279598+00:00"
+"Directions": "Cross Streets: Johnson Rd. ** Directions: Just across the bridge in Dunnville, Turn LEFT at the Esso on Port Maitland Rd (11) and then RIGHT onto Johnson Rd, then LEFT onto Lighthouse."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2030076"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "100 x 282 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-28T00:43:44Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T20:52:19Z"
+"Stories": "1.0"
+"StreetName": "Lighthouse"
+"StreetNumber": "401"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5181"
+"VirtualTourURLUnbranded": "https://youtu.be/D8rj6kejldI"
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Dunnville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29664202/401-lighthouse-drive-haldimand-dunnville-dunnville"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2235995"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-04-28T00:43:43.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307779"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1473974"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29664202')"
+"ID": "1360395"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25128
+post_id: "1324982"
+post_author: 1
+"ListingKey": "29615612"
+"ListingId": "X13008248"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T12:05:14Z"
+"RFModificationTimestamp": "2026-06-08T12:07:34Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand (Dunnville)"
+"PostalCode": "N1A2W6"
+"UnparsedAddress": "17 STONEHAVEN ROAD, Haldimand (Dunnville), Ontario N1A2W6"
+"Coordinates": array:2 [
0 => -79.6105205
1 => 42.844614
]
+"Latitude": 42.844614
+"Longitude": -79.6105205
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Custom bungalow in Dunnville set on a beautifully landscaped 100' x 282' lot, offering true country living just steps from Lake Erie. Enjoy the peace and privacy of rural surroundings with the convenience of nearby shoreline access, parks, and small-town amenities. This well-built home features 1825 sq ft plus a fully finished basement, 3+2 bedrooms and 3.5 bathrooms. The bright open-concept main floor includes a white kitchen with quartz countertops, backsplash, and generous workspace, flowing into a cathedral-ceiling living room with patio doors to both front and rear decks. Main floor laundry adds everyday convenience. The fully finished basement offers a spacious rec room, family room, additional bedroom and full bath. Above the oversized double garage is a separate loft/in-law suite with its own entrance, 3pc bath, and fireplace-ideal for guests or multigenerational living. Additional features include 3 gas fireplaces, Generac system, water filtration, abundant storage, and ample parking. New composite decking (2025) Bathroom renovations (2024) Central Air (2025) UV water filter (2022) A rare blend of country tranquility and Lake Erie lifestyle-perfect for those seeking space, privacy, and a relaxed rural setting close to the water. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-16T21:38:48.334165+00:00"
+"Directions": "Cross Streets: Johnson Rd. ** Directions: From Dunnville bridge/ Haldimand Rd 3, take Port Maitland Rd/Regional Rd 11, then turn onto Johnson Rd. Follow Johnson Rd to Stonehaven Rd. Turn left and continue to 17 Stonehaven Rd near Lake Erie in Dunnville."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147969"
+"ListOfficeKey": "300053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Carpet Free"
2 => "Guest Suite"
]
+"LotSizeDimensions": "100 x 282 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-18T17:25:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T11:57:40Z"
+"Stories": "1.0"
+"StreetName": "Stonehaven"
+"StreetNumber": "17"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5140"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Telephone"
2 => "Wireless"
3 => "Natural Gas Available"
]
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/QqmlH_iiVpo?feature=share"
+"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": "Niagara"
+"TaxYear": 2025
+"CityRegion": "Dunnville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29615612/17-stonehaven-road-haldimand-dunnville-dunnville"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-04-16T18:36:44.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1399007"
+"ListOfficeNationalAssociationId": "1482107"
+"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": 54
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29615612')"
+"ID": "1324982"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]