Second-floor office space available for sublease with all Furniture in a highly visible corner building. The unit currently consists of five rooms, with three already occupied by tenants and two vacant rooms ready for immediate use. This space offers an excellent opportunity for a business owner or investor to assume the existing tenants while utilizing the remaining offices for their
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 29727617 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364 +post_id: "1405737" +post_author: 1 +"ListingKey": "29727617" +"ListingId": "X13106670" +"PropertyType": "Commercial Sale" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-15T22:00:55Z" +"RFModificationTimestamp": "2026-05-19T09:18:09Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1500.0 +"LivingArea": 1500.0 +"BuildingAreaTotal": 0 +"City": "Niagara Falls (Downtown)" +"PostalCode": "L2E2M3" +"UnparsedAddress": "202 - 4786 QUEEN STREET, Niagara Falls (Downtown), Ontario L2E2M3" +"Coordinates": array:2 [ 0 => -79.07289 1 => 43.106406 ] +"Latitude": 43.106406 +"Longitude": -79.07289 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Toronto Regional Real Estate Board" +"PublicRemarks": "Second-floor office space available for sublease with all Furniture in a highly visible corner building. The unit currently consists of five rooms, with three already occupied by tenants and two vacant rooms ready for immediate use. This space offers an excellent opportunity for a business owner or investor to assume the existing tenants while utilizing the remaining offices for their own operations. Enjoy very attractive rental rates, ample on-site parking, and a location that is easy to find and benefits from strong exposure. Ideal for professionals seeking a well-maintained and conveniently located workspace. Option to Buy Business Practice. (id:62650)" +"Appliances": array:1 [ 0 => "Furniture" ] +"BusinessType": "Other" +"Cooling": array:1 [ 0 => "Fully air conditioned" ] +"CreationDate": "2026-05-09T14:03:46.767523+00:00" +"Directions": "Cross Streets: Victoria and Queen. ** Directions: Corner of Queen and Victoria." +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2133501" +"ListOfficeKey": "270960" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Elevator" ] +"LotSizeDimensions": "1500" +"PhotosChangeTimestamp": "2026-05-09T13:44:38Z" +"PhotosCount": 12 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-05-15T21:52:28Z" +"StreetName": "Queen" +"StreetNumber": "4786" +"StreetSuffix": "Street" +"VirtualTourURLUnbranded": "https://www.zolo.ca/niagara-falls-real-estate/4786-queen-street/202#virtual-tour" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Toronto" +"TaxYear": 2025 +"CityRegion": "210 - Downtown" +"ListAORKey": "82" +"ListingURL": "www.realtor.ca/real-estate/29727617/202-4786-queen-street-niagara-falls-downtown-210-downtown" +"StructureType": array:1 [ 0 => "Offices" ] +"GeocodeManualYN": false +"TotalActualRent": 2471.11 +"ZoningDescription": "CB" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 138.8 +"OriginalEntryTimestamp": "2026-05-09T13:44:38.5Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1385995" +"ListOfficeNationalAssociationId": "1237096" +"Media": array:12 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29727617_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/927081bdfc7e597ed068edf3df997c60.webp" "MediaSize" => 50289 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-927081bdfc7e597ed068edf3df997c60.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29727617_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/aee99d6ec1327fb1642bce675748f675.webp" "MediaSize" => 53991 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-aee99d6ec1327fb1642bce675748f675.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29727617_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/f988b008f4352a2700d2d1613c9bdd39.webp" "MediaSize" => 55119 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-f988b008f4352a2700d2d1613c9bdd39.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29727617_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/60e50402b19a205d8c5dda11c01e0ebb.webp" "MediaSize" => 55827 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-60e50402b19a205d8c5dda11c01e0ebb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29727617_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/8bca5156d079ca2f5068a27faef55453.webp" "MediaSize" => 34833 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-8bca5156d079ca2f5068a27faef55453.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29727617_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/ac36956b434bbf5ee7ea34c9279e2f5a.webp" "MediaSize" => 46494 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-ac36956b434bbf5ee7ea34c9279e2f5a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29727617_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/ca79d50a5032050ca3254ab6db7d36e9.webp" "MediaSize" => 41912 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-ca79d50a5032050ca3254ab6db7d36e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29727617_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/1323ccf62d29a1ffd6babd9e0eebce9a.webp" "MediaSize" => 41956 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-1323ccf62d29a1ffd6babd9e0eebce9a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29727617_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/0313f629a6a299f3622aacbda8bcad22.webp" "MediaSize" => 70391 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-0313f629a6a299f3622aacbda8bcad22.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29727617_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/c74674419a48a65d50b763dbad588bb1.webp" "MediaSize" => 45349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-c74674419a48a65d50b763dbad588bb1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29727617_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/b47b7c5c4092719c0213deba3ddaa0cb.webp" "MediaSize" => 70122 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-b47b7c5c4092719c0213deba3ddaa0cb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29727617_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29727617/8b2005d7332661e02b9f7fcf4d224ddc.webp" "MediaSize" => 37687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29727617/thumbnail-8b2005d7332661e02b9f7fcf4d224ddc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13106670" "ResourceRecordKey" => "29727617" "ModificationTimestamp" => "2026-05-09T13:44:38.51Z" ] ] +"DaysOnMarket": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29727617')" +"ID": "1405737" } ] +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=OfficeMlsId eq 270960" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24714 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2133501" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24799 +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 '29727617'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25088 +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 '29727617'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25104 +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 '29727617' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-79.07289 43.106406)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25151 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]