Prime commercial space in the heart of the Quispamsis business district, offering high traffic exposure, excellent visibility, and ample on-site parking. This 1, 890 sq. ft. end unit features a spacious open-concept layout with commercial vinyl tile flooring throughout most of the space, plus a rear utility area with painted concrete flooring. The rear section includes a bathroom, storage area,
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 29817628 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474 +post_id: "1472668" +post_author: 1 +"ListingKey": "29817628" +"ListingId": "NB140560" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T16:20:28Z" +"RFModificationTimestamp": "2026-06-08T16:23:48Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1.0 +"LivingArea": 1890.0 +"BuildingAreaTotal": 0 +"City": "Quispamsis" +"PostalCode": "E2E3R6" +"UnparsedAddress": "26 Pettingill Road Unit# D, Quispamsis, New Brunswick E2E3R6" +"Coordinates": array:2 [ 0 => -65.972507 1 => 45.407664 ] +"Latitude": 45.407664 +"Longitude": -65.972507 +"YearBuilt": 2009 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "New Brunswick REALTORS®" +"PublicRemarks": "Prime commercial space in the heart of the Quispamsis business district, offering high traffic exposure, excellent visibility, and ample on-site parking. This 1,890 sq. ft. end unit features a spacious open-concept layout with commercial vinyl tile flooring throughout most of the space, plus a rear utility area with painted concrete flooring. The rear section includes a bathroom, storage area, back entrance, and a convenient overhead door measuring 7 ft. high by 6 ft. wide. An efficient heat pump provides year-round climate control. Tenant responsibilities include electricity and maintenance of the front entrance planters. Available immediately. Minimum 3-year lease required, with longer-term lease preferred. An additional adjoining unit (Unit C), also 1,890 sq. ft., is available for lease. The dividing wall between the two units could be removed to accommodate a tenant requiring a larger combined space. (id:62650)" +"BusinessType": "Retail and Wholesale" +"Cooling": array:2 [ 0 => "Central air conditioning" 1 => "Heat Pump" ] +"CreationDate": "2026-05-28T17:07:43.496608+00:00" +"Directions": "Hampton Rd to Pettingill Rd to #26 on the right" +"ExteriorFeatures": array:2 [ 0 => "Stone" 1 => "Vinyl" ] +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1734321" +"ListOfficeKey": "278983" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Visual exposure" 1 => "Door under 10 ft." ] +"LotSizeDimensions": "1" +"ParcelNumber": "30256200" +"PhotosChangeTimestamp": "2026-06-08T16:14:35Z" +"PhotosCount": 14 +"StateOrProvince": "New Brunswick" +"StatusChangeTimestamp": "2026-06-08T16:14:35Z" +"TaxAnnualAmount": "36773.45" +"ListAOR": "New Brunswick" +"ListAORKey": "84" +"ListingURL": "www.realtor.ca/real-estate/29817628/26-pettingill-road-unit-d-quispamsis" +"CommonInterest": "Freehold" +"GeocodeManualYN": false +"TotalActualRent": 3500 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 1890 +"OriginalEntryTimestamp": "2026-05-28T15:23:05.23Z" +"AboveGradeFinishedAreaUnits": "square feet" +"ListAgentNationalAssociationId": "1177621" +"ListOfficeNationalAssociationId": "1300025" +"Media": array:14 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29817628_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/135f3fa984d82d3ba98a5fe52e10bd71.webp" "MediaSize" => 150786 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-135f3fa984d82d3ba98a5fe52e10bd71.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "End unit, 1890 sqft" "PreferredPhotoYN" => true "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29817628_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/13dcae16f4fb7efbbb12753583230585.webp" "MediaSize" => 75986 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-13dcae16f4fb7efbbb12753583230585.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Back of Building" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29817628_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/ff7103d2b4615252c3e50436f69f9aab.webp" "MediaSize" => 80650 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-ff7103d2b4615252c3e50436f69f9aab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Rear Loading Door 7ft high" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29817628_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/1effa44f4fb8ca298f5e9472ebd1e109.webp" "MediaSize" => 126125 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-1effa44f4fb8ca298f5e9472ebd1e109.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Side" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29817628_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/2755f9cb4f62f9219e91babe492849c8.webp" "MediaSize" => 68671 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-2755f9cb4f62f9219e91babe492849c8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Heat Pump Compressor" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29817628_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/fd956f9b75d670766b00363d7bfa2db8.webp" "MediaSize" => 73183 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-fd956f9b75d670766b00363d7bfa2db8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Main Entrance Door" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-05-28T15:23:05.24Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29817628_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/d123e8b7334a0ee24f3c21673d243407.webp" "MediaSize" => 60860 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-d123e8b7334a0ee24f3c21673d243407.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:18.22Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29817628_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/5f13be6e8f68a34bff22f8233f64c05d.webp" "MediaSize" => 50950 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-5f13be6e8f68a34bff22f8233f64c05d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:14.44Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29817628_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/25bb7b2eb0cc7f55916d7c2188e9552d.webp" "MediaSize" => 41719 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-25bb7b2eb0cc7f55916d7c2188e9552d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:14.44Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29817628_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/d5af10006a4363b939942a895d945ba8.webp" "MediaSize" => 56700 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-d5af10006a4363b939942a895d945ba8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Doors to rear Utility/Storage Area" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:14.44Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29817628_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/4e0669f22e43321e9a29b44156c20413.webp" "MediaSize" => 44309 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-4e0669f22e43321e9a29b44156c20413.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:14.44Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29817628_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/ce2c3fd8b114ad9eb92dfcfc73b1bfd3.webp" "MediaSize" => 85226 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-ce2c3fd8b114ad9eb92dfcfc73b1bfd3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Door open" "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:18.22Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29817628_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/7e4cdc85bdd2a39b0c67380b6c7a1b95.webp" "MediaSize" => 70262 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-7e4cdc85bdd2a39b0c67380b6c7a1b95.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:18.22Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29817628_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817628/639c8a3d940afb4273861bce9416dfcc.webp" "MediaSize" => 148902 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817628/thumbnail-639c8a3d940afb4273861bce9416dfcc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB140560" "ResourceRecordKey" => "29817628" "ModificationTimestamp" => "2026-06-08T16:11:18.33Z" ] ] +"DaysOnMarket": 48 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817628')" +"ID": "1472668" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 278983" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24927 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871 +post_id: ? mixed +post_author: ? mixed +"OfficeName": "SUTTON GROUP AURORA REALTY LTD." +"OfficeEmail": null +"OfficePhone": "506-646-0289" +"OfficeMlsId": "S222" +"ModificationTimestamp": "2025-04-17T12:01:00Z" +"OriginatingSystemName": "CREA" +"OfficeKey": "278983" +"IDXOfficeParticipationYN": null +"MainOfficeKey": null +"MainOfficeMlsId": null +"OfficeAddress1": "9 Somerset Street, Suite 3" +"OfficeAddress2": null +"OfficeBrokerKey": null +"OfficeCity": "Saint John" +"OfficePostalCode": "E2K2X" +"OfficePostalCodePlus4": null +"OfficeStateOrProvince": "New Brunswick" +"OfficeStatus": "Active" +"OfficeAOR": "New Brunswick" +"OfficeType": "Firm" +"OfficePhoneExt": null +"OfficeNationalAssociationId": "1300025" +"OriginalEntryTimestamp": "2016-10-03T16:09:00Z" +"OfficeFax": "506-646-0912" +"OfficeAORKey": "84" +"OfficeCountry": "Canada" +"OfficeSocialMedia": array:1 [ 0 => array:6 [ "ResourceName" => "Office" "SocialMediaKey" => "348800" "SocialMediaType" => "Website" "ResourceRecordKey" => "278983" "SocialMediaUrlOrId" => "http://www.suttonnb.ca/" "ModificationTimestamp" => "2025-04-17T11:49:00Z" ] ] +"FranchiseNationalAssociationId": "1176600" +"OfficeBrokerNationalAssociationId": "1177621" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('278983')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1734321" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881 +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 '29817628'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25201 +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 '29817628' AND OpenHouseDate ge '2026-07-15'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29817628' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial+Lease' AND geo.distance(Coordinates, POINT(-65.972507 45.407664)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]