When Viewing This Property On Realtor.ca Please Click On The Multimedia or Virtual Tour Link For More Property Info.Looking for a professional and spacious office space in one of Saint Johns busiest commercial corridors? This 6, 200 SF two-level office at 479 Rothesay Avenue offers everything your business needs to thrive in a prime location surrounded by shopping, dining, and
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 29028779 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: "896218" +post_author: 1 +"ListingKey": "29028779" +"ListingId": "NB129108" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-24T16:11:02Z" +"RFModificationTimestamp": "2025-10-24T16:37:00Z" +"ListPrice": 15.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1886.0 +"LivingArea": 6200.0 +"BuildingAreaTotal": 0 +"City": "Saint John" +"PostalCode": "E2J2C6" +"UnparsedAddress": "479 Rothesay Avenue, Saint John, New Brunswick E2J2C6" +"Coordinates": array:2 [ 0 => -66.0305557 1 => 45.3086281 ] +"Latitude": 45.3086281 +"Longitude": -66.0305557 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "New Brunswick Real Estate Board" +"PublicRemarks": "When Viewing This Property On Realtor.ca Please Click On The Multimedia or Virtual Tour Link For More Property Info.Looking for a professional and spacious office space in one of Saint Johns busiest commercial corridors? This 6,200 SF two-level office at 479 Rothesay Avenue offers everything your business needs to thrive in a prime location surrounded by shopping, dining, and essential services. Features: Elegant Executive Office with boardroom Inviting Reception Area to welcome your clients Boardroom for meetings and presentations 10 Private Offices for your leadership team and staff Large Open Area ideal for cubicles or collaborative workspaces Nice Employee Lunchroom for staff comfort and convenience On-Site Parking for staff and clients Prestigious Location in the retail and services hub of Saint John Whether you're a professional services firm, tech company, or growing organization, this well-maintained office space offers both function and impressive style. (id:62650)" +"BusinessType": "Other" +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-10-24T16:36:41.194582+00:00" +"Directions": "Trans Can hwy to NB-100 (Rothesay Ave)" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1902460" +"ListOfficeKey": "278411" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "1886" +"ParcelNumber": "303701" +"PhotosChangeTimestamp": "2025-10-24T16:03:23Z" +"PhotosCount": 1 +"StateOrProvince": "New Brunswick" +"StatusChangeTimestamp": "2025-10-24T16:03:23Z" +"TaxAnnualAmount": "35370" +"VirtualTourURLUnbranded": "https://listi.ca/listing/view/5479" +"ListAOR": "New Brunswick" +"ListAORKey": "84" +"ListingURL": "www.realtor.ca/real-estate/29028779/479-rothesay-avenue-saint-john" +"LeaseAmount": 15 +"LeasePerUnit": "square feet" +"CommonInterest": "Freehold" +"AboveGradeFinishedArea": 6200 +"OriginalEntryTimestamp": "2025-10-24T16:03:23.53Z" +"MapCoordinateVerifiedYN": false +"AboveGradeFinishedAreaUnits": "square feet" +"Media": array:1 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6271807464" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29028779/06595b0f849ee3c0a0febc4becee2165.webp" "MediaSize" => 87664 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29028779/thumbnail-06595b0f849ee3c0a0febc4becee2165.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "NB129108" "ResourceRecordKey" => "29028779" "ModificationTimestamp" => "2025-10-24T16:03:23.54Z" ] ] +"DaysOnMarket": 264 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29028779')" +"ID": "896218" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 278411" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24844 +post_id: ? mixed +post_author: ? mixed +"OfficeName": "PG Direct Realty Ltd." +"OfficeEmail": null +"OfficePhone": "877-709-0027" +"OfficeMlsId": "18540" +"ModificationTimestamp": "2026-03-03T12:05:49Z" +"OriginatingSystemName": "CREA" +"OfficeKey": "278411" +"IDXOfficeParticipationYN": null +"MainOfficeKey": null +"MainOfficeMlsId": null +"OfficeAddress1": "607 St. George Street, unit B02" +"OfficeAddress2": null +"OfficeBrokerKey": null +"OfficeCity": "Moncton" +"OfficePostalCode": "E1E2C2" +"OfficePostalCodePlus4": null +"OfficeStateOrProvince": "New Brunswick" +"OfficeStatus": "Active" +"OfficeAOR": "Saint John" +"OfficeType": "Firm" +"OfficePhoneExt": null +"OfficeNationalAssociationId": "1293345" +"OriginalEntryTimestamp": "2016-06-09T18:16:00Z" +"OfficeAORKey": "84" +"OfficeBrokerNationalAssociationId": "1218157" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('278411')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1902460" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24854 +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 '29028779'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25161 +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 '29028779' AND OpenHouseDate ge '2026-07-15'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177 +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 '29028779' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial+Lease' AND geo.distance(Coordinates, POINT(-66.0305557 45.3086281)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25224 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]