Calling all investors and entrepreneurs! This prime commercial/residential property in Kingston offers excellent exposure, strong tenancy, and future growth potential. The commercial building, approximately 3, 000 sq. ft., is currently rented to Needs & Starks Headquarters, both reliable long-term tenants. Situated on a ½ acre lot with high traffic visibility, this location provides excellent advertising potential and accessibility, only minutes
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 28949960 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443 +post_id: "822866" +post_author: 1 +"ListingKey": "28949960" +"ListingId": "202525101" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-11T05:15:03Z" +"RFModificationTimestamp": "2026-06-11T05:25:52Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.487 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "B0P1R0" +"UnparsedAddress": "796 & 800 Main Street, Kingston, Nova Scotia B0P1R0" +"Coordinates": array:2 [ 0 => -64.9397202 1 => 44.9908485 ] +"Latitude": 44.9908485 +"Longitude": -64.9397202 +"YearBuilt": 1998 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Nova Scotia Association of REALTORS®" +"PublicRemarks": "Calling all investors and entrepreneurs! This prime commercial/residential property in Kingston offers excellent exposure, strong tenancy, and future growth potential. The commercial building, approximately 3,000 sq. ft., is currently rented to Needs & Starks Headquarters, both reliable long-term tenants. Situated on a ½ acre lot with high traffic visibility, this location provides excellent advertising potential and accessibility, only minutes from Highway 101 and Kingston amenities. Adding even more value, the property includes a well-kept 4-bedroom, 2-bath home with a vacant 3-bedroom, 1-bath basement apartment. This gives buyers the opportunity to live on-site or expand their rental portfolio. This property offers the rare chance to combine steady commercial income with residential opportunity the best of both worlds for savvy investors. Dining room in main house can easily be converted to an additional bedroom. Main house has in the past had a strong rental history when it was a triplex. Needs tenants have been in place for 27 years. Stark has been in place fo 16 years. (id:62650)" +"BusinessType": "Other" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"ConstructionMaterials": array:1 [ 0 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Air Conditioned" ] +"CreationDate": "2025-10-03T22:12:51.436348+00:00" +"Directions": "Exit 17 left on Maple to stop sign, second driveway to the left side road on Main Street beside Tim Hortons." +"Flooring": array:1 [ 0 => "Other" ] +"Heating": array:4 [ 0 => "Heat Pump" 1 => "Baseboard heaters" 2 => "Electric" 3 => "Ductless" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2068015" +"ListOfficeKey": "279398" +"LotSizeDimensions": "0.487" +"ParcelNumber": "55521405" +"ParkingFeatures": array:2 [ 0 => "Paved Yard" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-06-04T14:50:04Z" +"PhotosCount": 47 +"StateOrProvince": "Nova Scotia" +"StatusChangeTimestamp": "2026-06-11T05:08:13Z" +"StreetName": "Main" +"StreetNumber": "796" +"StreetSuffix": "Street" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"ListAOR": "NSAR" +"CityRegion": "Kingston" +"ListAORKey": "107" +"ListingURL": "www.realtor.ca/real-estate/28949960/796-800-main-street-kingston-kingston" +"CoListAgentKey": "2253980" +"CommonInterest": "Freehold" +"CoListOfficeKey": "52624" +"GeocodeManualYN": false +"BuildingFeatures": array:1 [ 0 => "Air Conditioning" ] +"SecurityFeatures": array:2 [ 0 => "Alarm system" 1 => "Smoke Detectors" ] +"AboveGradeFinishedArea": 2944 +"OriginalEntryTimestamp": "2025-10-03T20:34:14.54Z" +"AboveGradeFinishedAreaUnits": "square feet" +"ListAgentNationalAssociationId": "1343083" +"ListOfficeNationalAssociationId": "1304053" +"CoListAgentNationalAssociationId": "1493001" +"CoListOfficeNationalAssociationId": "1007156" +"Media": array:47 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6296079326" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/f554d28c557edf06e2b47ad51825e1f6.webp" "MediaSize" => 156440 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-f554d28c557edf06e2b47ad51825e1f6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6296079340" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/73575a8dff1cb8267f4fa494b6e309ea.webp" "MediaSize" => 148803 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-73575a8dff1cb8267f4fa494b6e309ea.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6296079357" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/2bda9098c135e70e7f59de54fa74668d.webp" "MediaSize" => 152690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-2bda9098c135e70e7f59de54fa74668d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "6296079358" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/394a89512e5bd59350830c1293163f21.webp" "MediaSize" => 154663 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-394a89512e5bd59350830c1293163f21.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "6296079373" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/b4858dae864fea22581f2d7b068c7eeb.webp" "MediaSize" => 142570 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-b4858dae864fea22581f2d7b068c7eeb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "6296079379" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/ec7f010058c973c906856b7372a1e690.webp" "MediaSize" => 133284 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-ec7f010058c973c906856b7372a1e690.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "6296079387" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/134172fe6b487dc0931ebbeeaaceb37e.webp" "MediaSize" => 146859 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-134172fe6b487dc0931ebbeeaaceb37e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "6296079404" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/eb2c9815b875399a0e6cceff93f9334e.webp" "MediaSize" => 95075 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-eb2c9815b875399a0e6cceff93f9334e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "6296079414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/73a513888091c413e488a1f8d360b2ba.webp" "MediaSize" => 94535 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-73a513888091c413e488a1f8d360b2ba.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "6296079431" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/d30a4a619b629232312d04c0c2e3be8e.webp" "MediaSize" => 119543 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-d30a4a619b629232312d04c0c2e3be8e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "6296079435" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/3f89e8e7ce7927ec67a703eb9fb5f5c0.webp" "MediaSize" => 97337 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-3f89e8e7ce7927ec67a703eb9fb5f5c0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "6296079448" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/22e18bd29839b5f054f234a2c660cb12.webp" "MediaSize" => 70769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-22e18bd29839b5f054f234a2c660cb12.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "6296079459" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/e9a9fa9f9546da7115ca9702e7580d42.webp" "MediaSize" => 81133 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-e9a9fa9f9546da7115ca9702e7580d42.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "6296079464" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/489dd2bf36d5b922c29d58c96c88431b.webp" "MediaSize" => 144272 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-489dd2bf36d5b922c29d58c96c88431b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "6296079466" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/fa73a6633fe15c1c82ee5598521ab6da.webp" "MediaSize" => 320171 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-fa73a6633fe15c1c82ee5598521ab6da.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "6296079470" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/6a4a0b979ccb1eec43480d2a245ccdf1.webp" "MediaSize" => 173847 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-6a4a0b979ccb1eec43480d2a245ccdf1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "6296079473" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/4262c9794111815d512799d9fa2a4491.webp" "MediaSize" => 349333 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-4262c9794111815d512799d9fa2a4491.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "6296079478" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/7c567701ca42b2173bf7b9844e51c2bc.webp" "MediaSize" => 96403 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-7c567701ca42b2173bf7b9844e51c2bc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "6296079487" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/fa15280f4b17a2b89f49e95a77f6036c.webp" "MediaSize" => 211285 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-fa15280f4b17a2b89f49e95a77f6036c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "6296079498" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/f025f4d58cdb7c5e19dd56aa9bdfcbcb.webp" "MediaSize" => 221062 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-f025f4d58cdb7c5e19dd56aa9bdfcbcb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "6296079507" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/aa05475b0f6222b46c998d10ac6657c3.webp" "MediaSize" => 247203 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-aa05475b0f6222b46c998d10ac6657c3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "6296079519" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/acf2be496202ac614b396eaba2d1a1ab.webp" "MediaSize" => 94401 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-acf2be496202ac614b396eaba2d1a1ab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "6296079554" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/b99da98f6a9190ee65e8a8e94c79b1be.webp" "MediaSize" => 145261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-b99da98f6a9190ee65e8a8e94c79b1be.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "6296079564" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/91c1d5156776301b7bd2c72c08912cac.webp" "MediaSize" => 150120 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-91c1d5156776301b7bd2c72c08912cac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "6296079588" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/b14035d47243e7ef43524c138a29acfe.webp" "MediaSize" => 174234 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-b14035d47243e7ef43524c138a29acfe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "6296079597" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/a97d9b16fdfa4b54fb1b9fe2a7b5fb80.webp" "MediaSize" => 185310 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-a97d9b16fdfa4b54fb1b9fe2a7b5fb80.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "6296079602" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/5ad3528507075252539e8fbb2688311a.webp" "MediaSize" => 119583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-5ad3528507075252539e8fbb2688311a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "6296079623" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/6b1c82b345ffaf7b71dfe1d53cb50454.webp" "MediaSize" => 107713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-6b1c82b345ffaf7b71dfe1d53cb50454.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "6296079628" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/4b9121ab30c5ff81ab1b51e05416bbfa.webp" "MediaSize" => 184761 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-4b9121ab30c5ff81ab1b51e05416bbfa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "6296079632" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/52436243506115734d8714c804e0c74f.webp" "MediaSize" => 236410 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-52436243506115734d8714c804e0c74f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "6296079637" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/2f32f57fd4d9968cfc81c8450615a78c.webp" "MediaSize" => 117122 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-2f32f57fd4d9968cfc81c8450615a78c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "6296079642" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/2aefc7fc3b602ab621b8a58269db1a20.webp" "MediaSize" => 112658 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-2aefc7fc3b602ab621b8a58269db1a20.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "6296079648" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/c9d794bcf042aa4608738c18f24a5eac.webp" "MediaSize" => 124157 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-c9d794bcf042aa4608738c18f24a5eac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "6296079650" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/6a1e7d89f27c51dfed8b1e5867cd1877.webp" "MediaSize" => 120547 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-6a1e7d89f27c51dfed8b1e5867cd1877.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "6296079658" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/b4e89e0610f46eb08351da4871535998.webp" "MediaSize" => 127894 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-b4e89e0610f46eb08351da4871535998.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "6296079661" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/bda81024aa435a9837c5bda180323f20.webp" "MediaSize" => 367544 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-bda81024aa435a9837c5bda180323f20.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "6296079682" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/e98e2f5fe784bb21f4939dcbbf93eca1.webp" "MediaSize" => 134481 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-e98e2f5fe784bb21f4939dcbbf93eca1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "6296079696" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/73d50837b9f305c6f3d70ad895408a15.webp" "MediaSize" => 155823 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-73d50837b9f305c6f3d70ad895408a15.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "6296079757" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/1ec809602132f7968f19f2ff4112c169.webp" "MediaSize" => 127677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-1ec809602132f7968f19f2ff4112c169.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 39 => array:13 [ "Order" => 40 "MediaKey" => "6296079773" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/ef7b403cc855711133b312b9cabb72ed.webp" "MediaSize" => 258513 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-ef7b403cc855711133b312b9cabb72ed.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 40 => array:13 [ "Order" => 41 "MediaKey" => "6296079804" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/5e89218958ba6aa4572ab1a4c5ca4042.webp" "MediaSize" => 486356 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-5e89218958ba6aa4572ab1a4c5ca4042.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 41 => array:13 [ "Order" => 42 "MediaKey" => "6296079812" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/de51a2254231f81238623edba08006ef.webp" "MediaSize" => 366085 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-de51a2254231f81238623edba08006ef.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 42 => array:13 [ "Order" => 43 "MediaKey" => "6296079826" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/74467d61120d44ae06f82c48573b3800.webp" "MediaSize" => 337451 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-74467d61120d44ae06f82c48573b3800.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 43 => array:13 [ "Order" => 44 "MediaKey" => "6296079872" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/9f518166459d9a25c969c9723763f900.webp" "MediaSize" => 389991 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-9f518166459d9a25c969c9723763f900.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 44 => array:13 [ "Order" => 45 "MediaKey" => "6296079878" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/d293da79a41782bfe0d4b47059d8dca3.webp" "MediaSize" => 415404 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-d293da79a41782bfe0d4b47059d8dca3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 45 => array:13 [ "Order" => 46 "MediaKey" => "6296079899" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/1b9a10cfd7e5ff2ec25ef41a767fd888.webp" "MediaSize" => 214254 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-1b9a10cfd7e5ff2ec25ef41a767fd888.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] 46 => array:13 [ "Order" => 47 "MediaKey" => "6296079931" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28949960/ff48728053d7e37571b972aba1743f0e.webp" "MediaSize" => 264141 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28949960/thumbnail-ff48728053d7e37571b972aba1743f0e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "202525101" "ResourceRecordKey" => "28949960" "ModificationTimestamp" => "2025-10-03T20:34:14.55Z" ] ] +"DaysOnMarket": 270 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28949960')" +"ID": "822866" } ] +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 279398" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24911 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2068015" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869 +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 '28949960'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.09 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '28949960'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25289 +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 '28949960' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-64.9397202 44.9908485)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25356 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] ]