MODERN SECOND LEVEL UNIT ON TRENDY HISTORICAL OTTAWA STREET. Includes utilities & TMI. Over 500 sq ft of space equipped with 2 x private offices and spacious flex space; unit adapts seamlessly to diverse business needs. Enjoy the convenience of a vast city parking lot at the rear, ensuring effortless access for you and your clients. Benefit from keyless entry
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 29483569 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23361 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23363 +post_id: "1231238" +post_author: 1 +"ListingKey": "29483569" +"ListingId": "40813088" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:05:36Z" +"RFModificationTimestamp": "2026-06-02T17:22:10Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 536.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H3Z9" +"UnparsedAddress": "294 OTTAWA Street N Unit# UPPER B, Hamilton, Ontario L8H3Z9" +"Coordinates": array:2 [ 0 => -79.8165424 1 => 43.2504259 ] +"Latitude": 43.2504259 +"Longitude": -79.8165424 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "MODERN SECOND LEVEL UNIT ON TRENDY HISTORICAL OTTAWA STREET. Includes utilities & TMI. Over 500 sq ft of space equipped with 2 x private offices and spacious flex space; unit adapts seamlessly to diverse business needs. Enjoy the convenience of a vast city parking lot at the rear, ensuring effortless access for you and your clients. Benefit from keyless entry access and video surveillance, ensuring the safety and security of your business. Command attention with prime visibility, capturing the gaze of passersbys and potential customers in an area renowned for significant foot traffic. Explore the vibrant local scene, surrounded by trendy shops, boutiques, and cultural attractions that make Ottawa Street a favored destination for locals and visitors alike. Seize the opportunity to become a part of Ottawa Street's legacy. Elevate your business in a space where history meets innovation. Podcast room accessible to Balla Media with notice. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2026-03-18T07:18:36.986859+00:00" +"Directions": "Off Red Hl Vly Pkwy, take the Queenston Road (Hwy 8) exit. At the roundabout, take the 3rd exit and stay on Queenston Road (Hwy 8). Turn right onto Ottawa St N." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2051963" +"ListOfficeKey": "292301" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-05-31T15:03:56Z" +"PhotosCount": 18 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:49:27Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "OTTAWA" +"StreetNumber": "294" +"StreetSuffix": "Street" +"SubdivisionName": "201 - Crown Point" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29483569/294-ottawa-street-n-unit-upper-b-hamilton" +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 1500 +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ExistingLeaseType": array:1 [ 0 => "Gross" ] +"ZoningDescription": "C5a" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 22.0 +"OriginalEntryTimestamp": "2026-03-18T00:30:05.22Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1327222" +"ListOfficeNationalAssociationId": "1410382" +"Media": array:18 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29483569_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/6397a66edc5819ab43e156f7843bb0cf.webp" "MediaSize" => 95585 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-6397a66edc5819ab43e156f7843bb0cf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T03:20:49.39Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29483569_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/cffd7bc72c61d1e739496092703f655d.webp" "MediaSize" => 117840 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-cffd7bc72c61d1e739496092703f655d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unit Flex Space" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01.02Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29483569_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/9f6efec9d203386dc64b7cac00dcd4e9.webp" "MediaSize" => 54749 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-9f6efec9d203386dc64b7cac00dcd4e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unit Flex Space" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:00.94Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29483569_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/97289bdeb345f24f5ee94535c01aea4f.webp" "MediaSize" => 46544 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-97289bdeb345f24f5ee94535c01aea4f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unit Flex Space" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01.03Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29483569_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/b805da76b0cebf1ef3561c2e4635788b.webp" "MediaSize" => 50577 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-b805da76b0cebf1ef3561c2e4635788b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unit Flex Space" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:00.94Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29483569_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/12728e82c61d8075b06d4006287f32a3.webp" "MediaSize" => 55970 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-12728e82c61d8075b06d4006287f32a3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private Office 1" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29483569_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/e418e1f383241a446f934696b245c456.webp" "MediaSize" => 53324 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-e418e1f383241a446f934696b245c456.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private Office 1" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01.02Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29483569_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/d99817e562fa8eeec0e8bc2f61b55e43.webp" "MediaSize" => 54566 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-d99817e562fa8eeec0e8bc2f61b55e43.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private Office 2" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:00.94Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29483569_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/b8e7b7fb5b54e04726dba0eb507f2303.webp" "MediaSize" => 50726 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-b8e7b7fb5b54e04726dba0eb507f2303.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private Office 2" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29483569_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/4ddc81899457fb64e9981e20d15f4d10.webp" "MediaSize" => 44865 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-4ddc81899457fb64e9981e20d15f4d10.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private Office 2" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01.02Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29483569_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/a2f3f4b264b6f3b1045ab061bbcd65c8.webp" "MediaSize" => 40124 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-a2f3f4b264b6f3b1045ab061bbcd65c8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unit Flex Space" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:00.95Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29483569_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/370dd4ba0456c53ba3b42b3d907a6c69.webp" "MediaSize" => 33195 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-370dd4ba0456c53ba3b42b3d907a6c69.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Podcast Room" "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-30T16:01:01Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29483569_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/140e8ec014619da39d66eab5b43a8626.webp" "MediaSize" => 35727 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-140e8ec014619da39d66eab5b43a8626.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:08.22Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29483569_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/9cf7f160a466374c12b3ac4864d11236.webp" "MediaSize" => 55121 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-9cf7f160a466374c12b3ac4864d11236.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:08.2Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29483569_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/76c9f64aaab35e32d9356ab4c8df02dd.webp" "MediaSize" => 44484 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-76c9f64aaab35e32d9356ab4c8df02dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:08.2Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29483569_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/9cb205dc7cc76235b0dc95d06af2b834.webp" "MediaSize" => 34415 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-9cb205dc7cc76235b0dc95d06af2b834.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:20.25Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29483569_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/48a8a0a53bb055d3e8b174ee772b43ce.webp" "MediaSize" => 129692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-48a8a0a53bb055d3e8b174ee772b43ce.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:08.16Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29483569_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29483569/a641ad11480e2f345c6a0738f3084df0.webp" "MediaSize" => 130380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29483569/thumbnail-a641ad11480e2f345c6a0738f3084df0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813088" "ResourceRecordKey" => "29483569" "ModificationTimestamp" => "2026-05-31T14:51:08.15Z" ] ] +"DaysOnMarket": 88 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29483569')" +"ID": "1231238" } ] +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 292301" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24755 +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 2051963" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24728 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.27 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29483569'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25047 +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 '29483569'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25063 +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 '29483569' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.8165424 43.2504259)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25110 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]