Exceptional opportunity to own a highly visible 3-unit commercial building in the heart of Middletons business district. This well-maintained property offers strong income potential with long-term tenants and room to expand. The ground floor features two established businesses, a popular pizza shop and a busy hair salon, both with many years of successful operation. The third main-level unit is currently
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 29029162 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: "894622" +post_author: 1 +"ListingKey": "29029162" +"ListingId": "202526548" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-11T05:15:03Z" +"RFModificationTimestamp": "2026-06-11T05:25:52Z" +"ListPrice": 284900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.2945 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Middleton" +"PostalCode": "B0S1P0" +"UnparsedAddress": "284 Main Street, Middleton, Nova Scotia B0S1P0" +"Coordinates": array:2 [ 0 => -65.0685501 1 => 44.9422722 ] +"Latitude": 44.9422722 +"Longitude": -65.0685501 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Nova Scotia Association of REALTORS®" +"PublicRemarks": "Exceptional opportunity to own a highly visible 3-unit commercial building in the heart of Middletons business district. This well-maintained property offers strong income potential with long-term tenants and room to expand. The ground floor features two established businesses, a popular pizza shop and a busy hair salon, both with many years of successful operation. The third main-level unit is currently owner-occupied as an office space, offering flexibility for continued use or rental income. Upstairs, the spacious upper level has been completely gutted and is ready for development, ideal for additional office suites or conversion into residential apartments. There is also two small offices upstairs and a half bath, with potential for many more spaces. A new carrying beam has already been installed, making the renovation process easier for the next owner. The building is efficiently heated and cooled with a ducted heat pump system. Ample deeded parking is available for tenants and customers, along with a convenient storage shed at the rear of the property. With excellent Main Street exposure, strong existing tenants, and untapped potential for additional income, this property presents a rare investment opportunity in a prime location. (id:62650)" +"BusinessType": "Other,Personal Services" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"Cooling": array:1 [ 0 => "Heat Pump" ] +"CreationDate": "2025-10-25T01:39:21.056164+00:00" +"Directions": "Main Street, Middleton" +"Flooring": array:1 [ 0 => "Other" ] +"Heating": array:2 [ 0 => "Electric" 1 => "Wall Mounted Heat Pump" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1589056" +"ListOfficeKey": "52618" +"LotSizeDimensions": "0.2945" +"ParcelNumber": "05078969" +"ParkingFeatures": array:2 [ 0 => "Paved Yard" 1 => "Parking Space(s)" ] +"PhotosChangeTimestamp": "2026-04-20T19:43:34Z" +"PhotosCount": 47 +"StateOrProvince": "Nova Scotia" +"StatusChangeTimestamp": "2026-06-11T05:08:16Z" +"StreetName": "Main" +"StreetNumber": "284" +"StreetSuffix": "Street" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "NSAR" +"TaxYear": 2025 +"CityRegion": "Middleton" +"ListAORKey": "107" +"ListingURL": "www.realtor.ca/real-estate/29029162/284-main-street-middleton-middleton" +"CommonInterest": "Freehold" +"GeocodeManualYN": false +"BuildingFeatures": array:1 [ 0 => "Air Conditioning" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"AboveGradeFinishedArea": 5982 +"OriginalEntryTimestamp": "2025-10-24T17:00:10.93Z" +"AboveGradeFinishedAreaUnits": "square feet" +"ListAgentNationalAssociationId": "1155442" +"ListOfficeNationalAssociationId": "1007139" +"Media": array:47 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6295232937" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/0c6d2328c6bb57cf8959924037d16247.webp" "MediaSize" => 263512 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-0c6d2328c6bb57cf8959924037d16247.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:30.87Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6295232960" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/d71d9af64a123c5666f569c3051b08c8.webp" "MediaSize" => 307936 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-d71d9af64a123c5666f569c3051b08c8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:27.73Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6295232984" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/9797119c7f02c61b231d522be4323be9.webp" "MediaSize" => 358983 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-9797119c7f02c61b231d522be4323be9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:43.37Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6295233003" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/2e41ba18cbcb843ebec23cd41777d9e9.webp" "MediaSize" => 306403 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-2e41ba18cbcb843ebec23cd41777d9e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:55.4Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6295233011" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/81ccdc440ab4a5bf31490706c2491de9.webp" "MediaSize" => 337921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-81ccdc440ab4a5bf31490706c2491de9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:50.06Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6295233018" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/b1de0f33d5c3c9b0d2b93c0416e194ed.webp" "MediaSize" => 344474 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-b1de0f33d5c3c9b0d2b93c0416e194ed.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:54:27.28Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6295233024" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/395371b2c798f2cd9a60485a1d57a922.webp" "MediaSize" => 326236 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-395371b2c798f2cd9a60485a1d57a922.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:50.04Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6295233030" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/932589e36e3badb96b037721b16ff3a4.webp" "MediaSize" => 293676 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-932589e36e3badb96b037721b16ff3a4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:54:27.29Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6271942011" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/2f38658e04971ae66d00c28997cd31dc.webp" "MediaSize" => 173452 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-2f38658e04971ae66d00c28997cd31dc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-10-24T17:12:33.02Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6295233045" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/cb3adec052ea9aa6d4202378202d3e6d.webp" "MediaSize" => 167286 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-cb3adec052ea9aa6d4202378202d3e6d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:26.53Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6295233047" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/021a8aeabec904d65014f85c157c9152.webp" "MediaSize" => 162935 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-021a8aeabec904d65014f85c157c9152.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:30.77Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6295233052" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/29146d8a61308a5c60c61f1ddcc8aec0.webp" "MediaSize" => 171130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-29146d8a61308a5c60c61f1ddcc8aec0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:27.45Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6295233075" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/6ad9987779b0d8598a37fecde9004bdc.webp" "MediaSize" => 145632 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-6ad9987779b0d8598a37fecde9004bdc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:30.26Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6295233076" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/8b985cb953601e8ccdb08c13b7e5de0b.webp" "MediaSize" => 128721 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-8b985cb953601e8ccdb08c13b7e5de0b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:30.26Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6295233084" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/ad5963ad1fb7dfe33768bf4b860541c4.webp" "MediaSize" => 113372 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-ad5963ad1fb7dfe33768bf4b860541c4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:31.31Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6295233095" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/413cc65606e8440e757c12eda2b017af.webp" "MediaSize" => 164519 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-413cc65606e8440e757c12eda2b017af.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:50.27Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6295233102" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/4897b1fdd0d9d031cfa600b70361defa.webp" "MediaSize" => 177821 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-4897b1fdd0d9d031cfa600b70361defa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:31.26Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6295233112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/75478edc52c87de7d7e0770f1698a05e.webp" "MediaSize" => 169962 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-75478edc52c87de7d7e0770f1698a05e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:49.64Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6271942226" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/6eb96d215c5445bc30722a072565452b.webp" "MediaSize" => 166176 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-6eb96d215c5445bc30722a072565452b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-10-24T17:12:34.2Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6295233136" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/ed0cded6dca4b1d870071e15fe9535f6.webp" "MediaSize" => 126590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-ed0cded6dca4b1d870071e15fe9535f6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:47.9Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6295233151" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/d33d9d9c12523beab8700e26f0e89aba.webp" "MediaSize" => 155736 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-d33d9d9c12523beab8700e26f0e89aba.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:28.47Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6295233172" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/53a09f05a96fba5d39dac2ecd08f6c61.webp" "MediaSize" => 170626 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-53a09f05a96fba5d39dac2ecd08f6c61.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:49.19Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6295233198" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/87808b6e36467d9cf9f767c53e5ade3c.webp" "MediaSize" => 162374 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-87808b6e36467d9cf9f767c53e5ade3c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:32.43Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6295233218" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/bcd87f6da63e9a6ff8a6f2def214af6c.webp" "MediaSize" => 122481 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-bcd87f6da63e9a6ff8a6f2def214af6c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:50.43Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6295233222" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/3a86e30fd903719ebd6f2122407322de.webp" "MediaSize" => 155416 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-3a86e30fd903719ebd6f2122407322de.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:35.35Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6295233238" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/65f9a82d6e147fc9820e933c00e81407.webp" "MediaSize" => 170184 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-65f9a82d6e147fc9820e933c00e81407.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:51.31Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6295233241" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/d90252b23aab997019c618ab6d0fd837.webp" "MediaSize" => 104599 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-d90252b23aab997019c618ab6d0fd837.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:36.66Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6295233248" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/45f3cb7eaf03510ee3a0799a4853033a.webp" "MediaSize" => 106575 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-45f3cb7eaf03510ee3a0799a4853033a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:40.1Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6295233263" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/3195aa1ab7ca8eaa1b105c506a749acc.webp" "MediaSize" => 151400 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-3195aa1ab7ca8eaa1b105c506a749acc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:53.93Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6295233278" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/abf4eb54ef0235f77688eb6e22255c83.webp" "MediaSize" => 129431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-abf4eb54ef0235f77688eb6e22255c83.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:54.48Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6295233307" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/50371d72c714b7df6c0a4e3db146395c.webp" "MediaSize" => 83527 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-50371d72c714b7df6c0a4e3db146395c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:43.29Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6295233334" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/802d8b6ba8cf3d4f09238eae2139ebee.webp" "MediaSize" => 107375 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-802d8b6ba8cf3d4f09238eae2139ebee.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:54.44Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6295233356" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/4e0ac76189a2918ddcb0888f4e972986.webp" "MediaSize" => 129881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-4e0ac76189a2918ddcb0888f4e972986.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:43.32Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6295233382" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/3581792d0e3f25d33acc7563c9aa59cc.webp" "MediaSize" => 156053 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-3581792d0e3f25d33acc7563c9aa59cc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:54.48Z" ] 34 => array:13 [ "Order" => 34 "MediaKey" => "6295233399" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/118935db64d29c0e692c8df4c89cc075.webp" "MediaSize" => 145150 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-118935db64d29c0e692c8df4c89cc075.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:42.86Z" ] 35 => array:13 [ "Order" => 35 "MediaKey" => "6295233413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/ed90a477b3c9e78873881cc8eeae78fa.webp" "MediaSize" => 91590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-ed90a477b3c9e78873881cc8eeae78fa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:54.44Z" ] 36 => array:13 [ "Order" => 36 "MediaKey" => "6295233440" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/9bf4caef2340f12cae3184b74f3a66a2.webp" "MediaSize" => 149609 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-9bf4caef2340f12cae3184b74f3a66a2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:45.32Z" ] 37 => array:13 [ "Order" => 37 "MediaKey" => "6295233452" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/100c0921ea2d6f2de643af86196479bc.webp" "MediaSize" => 96789 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-100c0921ea2d6f2de643af86196479bc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:58.1Z" ] 38 => array:13 [ "Order" => 38 "MediaKey" => "6295233491" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/547b509574369e908a5be8bfbcc127e3.webp" "MediaSize" => 108782 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-547b509574369e908a5be8bfbcc127e3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:45.37Z" ] 39 => array:13 [ "Order" => 39 "MediaKey" => "6295233543" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/38c591eda6a3676e296eb2de5e28463b.webp" "MediaSize" => 118898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-38c591eda6a3676e296eb2de5e28463b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:48.71Z" ] 40 => array:13 [ "Order" => 40 "MediaKey" => "6295233584" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/786e5916a43cac2fc31a52ed42b68ffb.webp" "MediaSize" => 315814 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-786e5916a43cac2fc31a52ed42b68ffb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:54:47.84Z" ] 41 => array:13 [ "Order" => 41 "MediaKey" => "6295233622" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/f05a6be0e780f8ed5f44eac301eef420.webp" "MediaSize" => 279727 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-f05a6be0e780f8ed5f44eac301eef420.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:48.98Z" ] 42 => array:13 [ "Order" => 42 "MediaKey" => "6295233659" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/bf344f66ff586eb4b11c4f36248c03dd.webp" "MediaSize" => 309792 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-bf344f66ff586eb4b11c4f36248c03dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:54:31.41Z" ] 43 => array:13 [ "Order" => 43 "MediaKey" => "6295233665" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/ec5143bebf000d40d5bad7419aca1f29.webp" "MediaSize" => 245803 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-ec5143bebf000d40d5bad7419aca1f29.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:48.12Z" ] 44 => array:13 [ "Order" => 44 "MediaKey" => "6295233692" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/06b189801f805cf28ed2df12c1046ad9.webp" "MediaSize" => 255427 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-06b189801f805cf28ed2df12c1046ad9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:54:47.2Z" ] 45 => array:13 [ "Order" => 45 "MediaKey" => "6295233709" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/08875e12690d20d1d64c9e3283cbadcf.webp" "MediaSize" => 293308 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-08875e12690d20d1d64c9e3283cbadcf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:53:48.13Z" ] 46 => array:13 [ "Order" => 46 "MediaKey" => "6295233750" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29029162/3ab2a5fa8b00df89ad87841c04b63551.webp" "MediaSize" => 381453 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29029162/thumbnail-3ab2a5fa8b00df89ad87841c04b63551.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202526548" "ResourceRecordKey" => "29029162" "ModificationTimestamp" => "2025-11-04T15:55:02.89Z" ] ] +"DaysOnMarket": 253 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29029162')" +"ID": "894622" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 52618" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913 +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 1589056" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24871 +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 '29029162'" => 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: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29029162'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29029162' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-65.0685501 44.9422722)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25358 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]