Whether you’re searching for a thriving turnkey vacation rental, a family cottage, or a year-round home by the sea, this exceptional waterfront property offers a lifestyle few can match. Nestled at the end of a quiet lane and perched right on the ocean’s edge, this stunning four-bedroom, three-bathroom home was completely renovated just five years ago with a design focused
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29612586 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445 +post_id: "1338584" +post_author: 1 +"ListingKey": "29612586" +"ListingId": "1296257" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-16T16:45:13Z" +"RFModificationTimestamp": "2026-06-16T16:47:52Z" +"ListPrice": 249000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1448.0 +"BuildingAreaTotal": 0 +"City": "Herring Neck" +"PostalCode": "A0G2R0" +"UnparsedAddress": "4 Main Street, Herring Neck, Newfoundland & Labrador A0G2R0" +"Coordinates": array:2 [ 0 => -54.614803 1 => 49.642093 ] +"Latitude": 49.642093 +"Longitude": -54.614803 +"YearBuilt": 1940 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®" +"PublicRemarks": "Whether you're searching for a thriving turnkey vacation rental, a family cottage, or a year-round home by the sea, this exceptional waterfront property offers a lifestyle few can match. Nestled at the end of a quiet lane and perched right on the ocean's edge, this stunning four-bedroom, three-bathroom home was completely renovated just five years ago with a design focused on showcasing the spectacular natural surroundings. Large windows throughout the home frame panoramic ocean views, allowing you to enjoy the beauty of Newfoundland's coastline from nearly every room. The kitchen, living room, games room, and bedrooms all offer front-row seats to an ever-changing seascape filled with whales, seals, icebergs, bald eagles, seabirds, and fishing boats. Inside, modern comforts blend seamlessly with original character, creating a warm and inviting atmosphere that feels both stylish and authentic. Thoughtfully updated and impeccably maintained, the home is ready to be enjoyed from day one. Step outside to experience true waterfront living. Gather around the oceanside fire pit, relax in the outdoor lounge area, or stroll down to your private wharf and enjoy direct access to the water. Whether you're entertaining guests or enjoying a quiet evening by the sea, the setting is nothing short of extraordinary. Located in the picturesque outport community of Herring Neck, this property offers peace, privacy, and breathtaking scenery while being only minutes from the vibrant tourist destination of Twillingate, known for its world-class iceberg viewing, whale watching, hiking trails, and coastal culture. With its proven appeal as a vacation rental and its unmatched waterfront setting, this property presents a rare opportunity to own a piece of Newfoundland's coastline—whether as an investment, family getaway, or your own private oceanfront retreat. (id:62650)" +"BusinessType": "Accommodation" +"CreationDate": "2026-04-16T17:38:28.732430+00:00" +"Flooring": array:1 [ 0 => "Mixed Flooring" ] +"Heating": array:1 [ 0 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2066615" +"ListOfficeKey": "290304" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "1200 sq ft" +"PhotosChangeTimestamp": "2026-04-16T13:03:04Z" +"PhotosCount": 43 +"StateOrProvince": "Newfoundland & Labrador" +"StatusChangeTimestamp": "2026-06-16T16:38:27Z" +"StreetName": "Main" +"StreetNumber": "4" +"StreetSuffix": "Street" +"TaxAnnualAmount": "380" +"VirtualTourURLUnbranded": "https://youtu.be/rMBdNGQVnkk, https://youtu.be/3xVOMeLnD7M" +"ListAOR": "Newfoundland & Labrador" +"ListAORKey": "117" +"ListingURL": "www.realtor.ca/real-estate/29612586/4-main-street-herring-neck" +"StructureType": array:1 [ 0 => "Special Purpose" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "Res." +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"OriginalEntryTimestamp": "2026-04-16T13:03:03.93Z" +"ListAgentNationalAssociationId": "1341703" +"ListOfficeNationalAssociationId": "1385593" +"Media": array:43 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6602665433" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/678a2d2485a9178db8be5898177eb882.webp" "MediaSize" => 217427 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-678a2d2485a9178db8be5898177eb882.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6602665534" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/83afbad53ad23c8e24475d92a8181d6d.webp" "MediaSize" => 224692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-83afbad53ad23c8e24475d92a8181d6d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6602665596" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/bb7223449b3175759985a58aa2c39f64.webp" "MediaSize" => 212597 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-bb7223449b3175759985a58aa2c39f64.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "6602665667" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/1221434e4fafe2d51d6b31de14c87dbf.webp" "MediaSize" => 236977 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-1221434e4fafe2d51d6b31de14c87dbf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "6602665745" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/28fc3ddd641d8c5b6e31ca2739f9fbfa.webp" "MediaSize" => 172356 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-28fc3ddd641d8c5b6e31ca2739f9fbfa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "6602665804" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/a12313576b8e0de8a90bf6b028189a60.webp" "MediaSize" => 222322 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-a12313576b8e0de8a90bf6b028189a60.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "6602665882" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/338c5ad2ef7775f9b6a6584c43c7c54b.webp" "MediaSize" => 158163 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-338c5ad2ef7775f9b6a6584c43c7c54b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "6602665955" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/dd7b065d127543012b4f95124fa0342d.webp" "MediaSize" => 285085 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-dd7b065d127543012b4f95124fa0342d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "6602666023" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/885f553055454698bf6ab2647fee5057.webp" "MediaSize" => 213416 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-885f553055454698bf6ab2647fee5057.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "6602666036" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/e90e76a2c284974712c90baa7c85b95a.webp" "MediaSize" => 220588 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-e90e76a2c284974712c90baa7c85b95a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "6602666107" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/75ef33d501df2c2e9254a60bd682f215.webp" "MediaSize" => 188284 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-75ef33d501df2c2e9254a60bd682f215.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "6602666200" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/0dbcad686b5776e199e53d108061e436.webp" "MediaSize" => 208199 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-0dbcad686b5776e199e53d108061e436.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "6602666287" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/f69e7f909303f2bb1f9739e71846527d.webp" "MediaSize" => 225863 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-f69e7f909303f2bb1f9739e71846527d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "6602666370" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/08ea7e7449cd680b56f4c5dcd97a33eb.webp" "MediaSize" => 103466 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-08ea7e7449cd680b56f4c5dcd97a33eb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "6602666410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/61bb0643d539214c07383d0476b6a6c7.webp" "MediaSize" => 162053 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-61bb0643d539214c07383d0476b6a6c7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "6602666437" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/fd33b1b6fce37b59c9b5b0b476a52206.webp" "MediaSize" => 209724 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-fd33b1b6fce37b59c9b5b0b476a52206.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "6602666502" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/1d05b72a632ba9a4af667b54518470e2.webp" "MediaSize" => 188305 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-1d05b72a632ba9a4af667b54518470e2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "6602666586" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/154c1c2d6634f2272f7d6c4857d49a36.webp" "MediaSize" => 107531 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-154c1c2d6634f2272f7d6c4857d49a36.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "6602666612" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/6bba9c90d34d69d672cb3cb61a629fa0.webp" "MediaSize" => 317344 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-6bba9c90d34d69d672cb3cb61a629fa0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "6602666666" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/af52d05bc081e005c46d9f440d7b7e1b.webp" "MediaSize" => 126241 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-af52d05bc081e005c46d9f440d7b7e1b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "6602666673" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/22dc99bb941c50f59df5b4a9137260a5.webp" "MediaSize" => 116362 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-22dc99bb941c50f59df5b4a9137260a5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "6602666689" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/3cdb5ea10f8034cf6086481712a4384c.webp" "MediaSize" => 315810 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-3cdb5ea10f8034cf6086481712a4384c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "6602666766" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/9d4f9d5c68d7564139436647fbb82a0e.webp" "MediaSize" => 246879 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-9d4f9d5c68d7564139436647fbb82a0e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "6602666830" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/40b0c04cd1fc1b114c1e60f335265b8c.webp" "MediaSize" => 92784 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-40b0c04cd1fc1b114c1e60f335265b8c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "6602666876" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/6c3e78932b421c4db62ccb81f747507e.webp" "MediaSize" => 178065 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-6c3e78932b421c4db62ccb81f747507e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "6602666917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/b7d2a35fca4aeffd76e7d279bc466111.webp" "MediaSize" => 160678 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-b7d2a35fca4aeffd76e7d279bc466111.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "6602666933" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/58010c6c7b5b9d10bb69e5265a26ec9b.webp" "MediaSize" => 180421 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-58010c6c7b5b9d10bb69e5265a26ec9b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "6602666963" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/549aa6f7a96b92d88cce318c66d1c3a3.webp" "MediaSize" => 145208 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-549aa6f7a96b92d88cce318c66d1c3a3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "6602666986" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/65d957927a34afae84aabdc7af24c9dd.webp" "MediaSize" => 85614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-65d957927a34afae84aabdc7af24c9dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "6602667007" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/b43186f074fe3f9674da4e43eb3a5f71.webp" "MediaSize" => 185146 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-b43186f074fe3f9674da4e43eb3a5f71.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "6602667049" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/a98c0f119345357f1ab9139b6aa0eda0.webp" "MediaSize" => 173500 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-a98c0f119345357f1ab9139b6aa0eda0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "6602667076" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/8d3f1258f7e30a0a05801de3169beb3c.webp" "MediaSize" => 141719 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-8d3f1258f7e30a0a05801de3169beb3c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "6602667097" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/c681eb0d91fafc60ae77d0b708264b96.webp" "MediaSize" => 201594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-c681eb0d91fafc60ae77d0b708264b96.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "6602667109" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/581189e81b1ff2001bc4ec65e0d1a663.webp" "MediaSize" => 199551 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-581189e81b1ff2001bc4ec65e0d1a663.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "6602667125" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/832102efe64db76250b2803f38033884.webp" "MediaSize" => 98190 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-832102efe64db76250b2803f38033884.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "6602667156" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/51ff8cbea367c8b53984802275873ff9.webp" "MediaSize" => 175672 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-51ff8cbea367c8b53984802275873ff9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "6602667169" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/c7d2c21c6cb5130dc73ece76f84c3575.webp" "MediaSize" => 209192 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-c7d2c21c6cb5130dc73ece76f84c3575.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "6602667193" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/e21a514ea03273c6e4029ddbca6f249f.webp" "MediaSize" => 93898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-e21a514ea03273c6e4029ddbca6f249f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "6602667212" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/53a0cec907321ced2f22954aab2f897f.webp" "MediaSize" => 252220 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-53a0cec907321ced2f22954aab2f897f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 39 => array:13 [ "Order" => 40 "MediaKey" => "6602667230" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/97b4b3e0daec71fec7bd6208a725be36.webp" "MediaSize" => 205707 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-97b4b3e0daec71fec7bd6208a725be36.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 40 => array:13 [ "Order" => 41 "MediaKey" => "6602667256" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/9e858304bfe58dee29bafba18a99a1df.webp" "MediaSize" => 233105 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-9e858304bfe58dee29bafba18a99a1df.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 41 => array:13 [ "Order" => 42 "MediaKey" => "6602667276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/a332dca937352856eb02f4eb8ba782f5.webp" "MediaSize" => 258927 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-a332dca937352856eb02f4eb8ba782f5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] 42 => array:13 [ "Order" => 43 "MediaKey" => "6602667291" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29612586/bb246e3446e3b77de2434df1600d9310.webp" "MediaSize" => 134805 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29612586/thumbnail-bb246e3446e3b77de2434df1600d9310.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1296257" "ResourceRecordKey" => "29612586" "ModificationTimestamp" => "2026-04-16T13:03:03.94Z" ] ] +"DaysOnMarket": 78 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29612586')" +"ID": "1338584" } ] +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 290304" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901 +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 2066615" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24859 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29612586'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29612586'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275 +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 '29612586' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-54.614803 49.642093)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25322 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] ]