Businesses
| Organization | More Info |
|---|---|
| 345 QUEEN STREET BUILDING, LLC |
Business type:
Domestic Limited Liability Company (LLC)
|
| Clifford B Hunt |
Categories:
Attorneys
|
| Hunt, Clifford B Attorney at Law |
Industry:
Legal Services Office
|
| Diamond Head Papaya Co |
Categories:
Electronic CommerceFruit BasketsGift Baskets & Packs Retail
Industry:
Medical PracticeMfg Frozen Fruits/VegetablesGift Shops
|
| Hawaii Starlanes, Inc |
Industry:
Holding Company
|
| Executive Office of The State of Hawaii |
Industry:
Regulation/Administrative Transportation
|
| First American Title Company Inc |
Industry:
Real Estate Escrow AgentInsurance Agencies and Brokerages
SIC:
6411 - Insurance Agents, Brokers, and Service
|
| Jonathan Bryant |
Email:
Organization:
First American Title Co
Title:
CTO
Industry:
Insurance Agencies and Brokerages
|
| Hart, Brook Attorney |
Categories:
AttorneysCriminal Law Attorneys
|
| Law Offices of Brook Hart |
Industry:
Legal Services Office
|
| Brook L Hart, 83 |
Email:
Organization:
Brook Hart Attorney At Law A Law Corporation
Title:
President
Industry:
Offices of Lawyers
Site:
hart-law.net
|
| Hawaii Dept of Land and Natural Resources |
Industry:
Regulates Small BoatsState Recreation Agency
|
| David Parsons |
Email:
Organization:
Boating and Ocean Recreation Div
Title:
Manager
Industry:
Regulation and Administration of Transportation Programs
|
| Ichishita Brian K CPA |
Categories:
Professional Services
|
| Paul T Kuramoto |
Email:
Organization:
Tokomoto, Yamamoto, Ichishita
Title:
President
|
| Carl K Yamamoto, 71 |
Email:
Organization:
Tokumoto Yamamoto and Ichishita
Title:
President
Industry:
Health and Welfare Funds
|
| INTERNATIONAL INSTITUTE-BODY |
Industry:
Real Estate Agents
|
| LAW OFFICE OF JOHN SCHUM, LLLC |
Industry:
Legal ServicesLegal Services Office
Business type:
Domestic Limited Liability Company (LLC)
|
| MELIM SERVICE CTR |
Industry:
Car Washes
|
| NEW TECH IMAGING |
Industry:
CopiesBook Publishers
SIC:
2741 - Miscellaneous Publishing
|
| Newtech Imaging Inc |
Industry:
Printing & Copying CommercialCommercial Lithographic PrintingOther Commercial Printing
SIC:
2752 - Commercial Printing, Lithographic
|
| Professional Image Inc |
Categories:
BlueprintingCopying & Duplicating ServicesPortrait StudiosPrinting ServicesSigns Wholesale & Manufacturers
Industry:
Photocopy and Duplicating Services
|
| Helen Godwin |
Email:
Organization:
Newtech Imaging Inc
Title:
President
Industry:
Other Commercial Printing
|
| Cindy Manago |
Email:
Organization:
New Tech Imaging
Title:
Manager
Industry:
Book Publishers
|
| Mark Mitsui |
Email:
Organization:
Newtech Imaging Inc
Title:
Manager
Industry:
Commercial Lithographic Printing
|
| Jeffrey Mussro |
Email:
Organization:
New Tech Imaging
Title:
Manager
Industry:
Book Publishers
|
| Leni Davis |
Organization:
Northstar Alliance Inc
Site:
nstaralliance.com
Marketing Manager
Ms. Leni Davis
|
| Bob Pila |
Organization:
NORTHSTAR ENTERPRISES
Title:
RE APPRAISER
|
| Northstar O'Hana, Inc |
Industry:
Nonclassifiable Establishments
|
| Okudara & Associate Inc |
Categories:
Business Consultants & Advisors
Industry:
Business Consulting Services
|
| OKUDARA & ASSOCIATES, INC |
Industry:
Consulting
Business type:
Domestic Profit Corporation
|
| Osumi, Paul S Jr A I A Inc |
Categories:
Architects
Industry:
Architectural ServicesArchitectArchitectural Svcs
SIC:
8712 - Architectural Services
Site:
onmarchitects.com
|
| Pacific Fish Inc |
Industry:
Offices of Lawyers
SIC:
8111 - Legal Services
|
| David Ushio |
Email:
Organization:
Pacific Fish Inc
Title:
CEO
Industry:
Offices of Lawyers
|
| Pacific Technologies LLC |
Industry:
Noncommercial Research Organization
|
| Ron K Watanabe |
Email:
Organization:
Used Bikes Hawaii
Title:
President
Industry:
Offices of Lawyers
|
| S G Lam |
Categories:
Customs Brokers & Consultants
Industry:
Custom Brokers & Freight Forwarding
Site:
sglam.com
|
| Shim & Chang Attorney at Law A Law Corporation |
Industry:
Legal Services Office
|
| Harvey M Demetrakopoulos |
Organization:
Shim & Chang, Attorneys at Law
Specialties:
Hotel AccidentsTourist InjuriesPersonal InjuryAutomobile AccidentsMedical MalpracticeBirth InjuriesWrongful DeathDefective ProductsAviation AccidentsDog BitesSwimming Pool and Beac...
Site:
shimchanglawyers.com
|
| Shim & Chang Attys A Law Corp |
Industry:
Legal Services Office
|
| Jerleen Bingo |
Email:
Organization:
Mango Mango
Title:
Manager
Industry:
Other Grocery and Related Products Merchant Wholesalers
|
| Johanna Bugarin |
Organization:
Platinum Mortgage
Organization alias:
Hightechlending Inc.
Site:
pmphi.com
MEM
Ms. Johanna Bugarin
|
| Michael Dias |
Organization:
Platinum Mortgage
Organization alias:
Hightechlending Inc.
Site:
pmphi.com
MEM
Ms. Johanna Bugarin
|
| Sara Harvey |
Email:
Organization:
Waihee John
Title:
Owner
Industry:
Offices of Lawyers
|
| Renton L Nip |
Email:
Organization:
Used Bikes Hawaii
Title:
Executive
Industry:
Offices of Lawyers
|
| Lisa Kim |
Email:
Organization:
Matrix Marketing Research Group
Title:
COO
Site:
garlicfestivalhawaii.com
|
| Richard N Wurdeman | |
| Michael Parrish |
Email:
Organization:
Attorney General-Medicaid Inv
Title:
Executive Director
Industry:
Other Human Resource Programs Administration
Site:
hawaii.gov
|
| Kuramoto Paul |
Email:
Organization:
Tokomoto, Yamamoto, Ichishita Cpa, Inc.
Title:
Chief Executive
|
| Richard Rice |
Email:
Organization:
HI St Govt
Title:
Administrator Executive
Industry:
Administration of Conservation Programs
|
| Stephen Thompson |
Email:
Organization:
HI St Govt
Title:
Manager
Industry:
Administration of Conservation Programs
|
| Gary Senaga | |
| Dawn Shigezawa | |
| David White |
Organization:
Platinum Mortgage Partners
Title:
Loan Officer
Specialties:
Purchase LoanRefinancingHome EquityMortgage Planning
|
Business resident history
| Organization | More Info |
|---|---|
| 1031 EXCHANGE, INC |
Industry:
To Act As The Accommodation Party In Tax-Deferred Exchanges Under Section 1031 Of The Internal Revenue Code; To Engage In Real Estate Investments
Business type:
Domestic Profit Corporation
|
| 190 KEAWE STREET |
Industry:
Real Estate Investment
Inactive:
19901203
|
| 3P Mdu LLC |
Industry:
Gas Production/Distribution
|
| AQUASOURCE, INC |
Industry:
To Transact A Wholesale/retail Business And Its Related Service Business;
Business type:
Domestic Profit Corporation
|
| B & B Mini Market LLC |
Industry:
Ret Groceries
|
| CARPOWERED PARKING SYSTEMS, INC |
Industry:
To Engage In The Marketing And Distribution Or Leasing Of Elevated Parking And Relate Machinery And Equipment Of All Kinds
Business type:
Domestic Profit Corporation
|
| CASTLE DESIGNS |
Industry:
Import And Sale Of General Merchandise
Inactive:
19911208
|
| CHALK HILL VINEYARDS |
Business type:
Articles of Incorporation
|
| Cheap Car Rental Honolulu |
Industry:
Equipment Rental/Leasing
|
| COLONIAL PACIFIC INNS, INC |
Business type:
Domestic Profit Corporation
|
| THE COPY CENTER |
Industry:
Copying, Printing, Desktop Publishing, Typesetting
Inactive:
19900816
|
| CROWN TUDOR CORPORATION |
Business type:
Statement & Designation By Foreign Corporation
|
| CTE HAWAII CORPORATION |
Industry:
Financial Management Consultants
Business type:
Domestic Profit Corporation
|
| DESTINSELL, LTD |
Business type:
Domestic Profit Corporation
|
| MELIM BUILDING |
Categories:
Auto Cleaning & DetailingAuto Service & RepairParkingParking GaragesParking Services
Industry:
Building Ownership And Management
Inactive:
20180131
Site:
abm.com
|
| EAT, LLC |
Business type:
Domestic Limited Liability Company (LLC)
|
| Growingtime, Inc |
Industry:
Nonclassifiable Establishments
|
| HOMELESS ALOHA* |
Industry:
Community Service Organization
Business type:
Domestic Nonprofit Corporation
|
| John Waihee Atty |
Industry:
Legal Services Office
|
| KARAOKE III, INC |
Industry:
To Introduce, Erect, Operate, Conduct, Manage, Maintain, And Carry On A Restaurant, Cafe, Discotheque And Cabaret Business
Business type:
Domestic Profit Corporation
|
| KENS HAWAII ASSOCIATES |
Industry:
Real Estate
Inactive:
19961019
|
| KH HOLDING, INC |
Industry:
Inactive
Business type:
Domestic Profit Corporation
|
| MANGO MANGO! LLC |
Industry:
Retail Trade/food Establishment (Juice Bar)
Business type:
Domestic Limited Liability Company (LLC)
|
| MCCONNELL & HIROKAWA |
Industry:
The Practice Of Law
Business type:
General Domestic Partnership
|
| MELIM SERVICE CENTER |
Specialties:
classic
Categories:
Auto Repair & ServiceAuto DetailingAuto Cleaning & Detailing
Industry:
AUTO REPAIRS, MAINTENANCE AND DETAILData Processing/Preparation
Inactive:
20000726
Site:
melimservicecenter.com
|
| MIM INDUSTRIES INTERNATIONAL LLC |
Business type:
Domestic Limited Liability Company (LLC)
|
| NEBGE, INC |
Business type:
Domestic Profit Corporation
|
| THE NIE COMPANIES, LLC |
Business type:
Domestic Limited Liability Company (LLC)
|
| NORTHSTAR ALLIANCE INC |
Categories:
Mortgage Brokers
Industry:
Mortgage Banker/CorrespondentMortgage Broker
Business type:
Stock
Site:
nstaralliance.com
|
| NORTHSTAR ALLIANCE, INC., DOING BUSINESS IN CALIFORNIA AS NORTHSTAR ALLIANCE MORTGAGE, INC |
Business type:
Statement & Designation By Foreign Corporation
|
| Northstar Mortgage Alliance, Inc |
Business type:
Foreign for Profit Corporation
|
| PATT PATTERSON & ASSOCIATES, INC |
Business type:
Statement & Designation By Foreign Corporation
|
| PEPEEKEO PAPAYA, INC |
Industry:
To Engage In Any Lawful Business For Which A Corporation May Be Organized Under Chapter 415 Of The Hawaii Revised Statutes;
Business type:
Domestic Profit Corporation
|
| PLATINUM MORTGAGE PARTNERS, LLC |
Industry:
Mortgage Broker
Business type:
Domestic Limited Liability Company (LLC)
|
| Plaza Home Mortgage Inc |
Industry:
Mortgage Banker/Correspondent
|
| PLUG AND PLAY NETWORKS, LLC |
Business type:
Domestic Limited Liability Company (LLC)
|
| PRISM DESIGNS |
Industry:
Fabric And Fabric Design
Inactive:
19901001
|
| RETAIL FOCUS, INC |
Business type:
Domestic Profit Corporation
|
| Ric 3802, LLC |
Industry:
Nonclassifiable Establishments
|
| ROBERT I. TAKEUCHI & ASSOCIATES, INC |
Business type:
Domestic Profit Corporation
|
| RON WATANABE & ASSOCIATES, INC |
Industry:
To Provide Hospitality And Real Estate Consulting Services To Owners, Lenders, Management, Attorneys And OthersReal Estate BrokerBusiness Consulting Services
Business type:
Domestic Profit Corporation
|
| SENTINEL ESCROW OF HAWAII |
Industry:
Escrow Services
Inactive:
20000109
|
| SHANGRI-LA DISTRIBUTORS |
Industry:
Import, Export, Wholesale And Retail Of Goods Of All Kinds
Inactive:
19911115
|
| TDT ASSOCIATES |
Industry:
Investments Including Acquisition & Sale Of Real Property, S Tocks, Bonds, Options & Commodities
Business type:
General Domestic Partnership
|
| TGB, INC |
Industry:
Retail Gifts
Business type:
Domestic Profit Corporation
|
| VH, INC |
Industry:
Real Estate Development
Business type:
Domestic Profit Corporation
|
| WIRELESS EXPRESS, INC |
Industry:
RetailBusiness Services Misc PublishingMisc Publishing
Business type:
Domestic Profit Corporation
|
| YANO & MATSUMOTO, ATTORNEYS AT LAW |
Industry:
Law Practice
Business type:
General Domestic Partnership
|
Incident history
Fire Incident History
25 Apr 2019
Passenger vehicle fire
Property Use —
Vehicle parking area
Actions Taken —
Extinguish
Area of Origin —
Cargo/trunk area - all vehicles
First Ignition —
Non-upholstered chair, bench
General use truck, dump truck, fire apparatus :
GMC (General Motors)
License Plate :
849TSE
VIN :
1GDHG31R8X1016847
Property Loss :
$10,000
Contents Loss :
$10,000
Property Value :
$10,000
Contents Value :
$10,000
Incidents registered in Federal Emergency Management Agency
16 Aug 2015
Vehicle accident, general cleanup
Property Use —
Street or road in commercial area
Actions Taken —
Hazardous materials spill control and confinement
333 Queen St incidents registered in Federal Emergency Management Agency
15 Jun 2000
Hazmat release investigation w/ no hazmat
Property Use —
Street or road in commercial area
Actions Taken —
Investigate
Houses for sale near 333 QUEEN ST, Honolulu, HI 96813
Single Family
More property photos
$9,600,000
For Sale
Single Family
- 6 beds
- 8 baths
- Floor size: 6,616 sqft
Condo/Townhouse
More property photos
$998,000
For Sale
Condo/Townhouse
- 2 beds
- 2 baths
- Floor size: 1,139 sqft
Single Family Residential
More property photos
$4,200,777
For Sale
Single Family Residential
- 5 beds
- 3 baths
- Floor size: 2,721 sqft
Multi-Family Home
More property photos
$1,978,000
For Sale
Multi-Family Home
- 6 beds
- 4 baths
- Floor size: 2,930 sqft
Condo/Townhouse
More property photos
$215,000
For Sale
Condo/Townhouse
- 1 bath
- Floor size: 307 sqft
Condo/Townhouse
More property photos
$135,000
For Sale
Condo/Townhouse
- 1 bed
- 1 bath
- Floor size: 392 sqft
Newest Listings on Queen Street
Newest Homes for Sale in Queen Street (135)
Foreclosure listings in Queen Street (12)
Additional Services
Relocation
Advertisement
Home Warranty
Avoid Unexpected Home Repair Bills! Get $50 Off + Your First Month is Free! Get Your Free Quote Now!
Advertisement
Schools nearby
| Name | Type | Grade | Distance |
|---|---|---|---|
| Elementary school | |||
|
Queen Kaahumanu Elementary School
1141 Kinau St, Honolulu, HI 96814 |
Public | K-5 | 1.3 |
Browse homes in Honolulu, HI
| Street Address |
|---|
FAQ
- What is the architectural style or type of the house located at 333 Queen St, Honolulu, HI?
- The property located at 333 Queen St, Honolulu, HI is classified as a High Rise residential dwelling.
- Have there been any fire-related events in close proximity to the house located at 333 Queen St, Honolulu, HI?
- The most recent fire incident involving the house at 333 Queen St, Honolulu, HI occurred in 2019. Additional fire incidents related to this property can be accessed through the provided link.
- Have there been any reported FEMA incidents at 333 Queen St, Honolulu, HI?
- The most recent recorded FEMA incident at 333 Queen St, Honolulu, HI took place in 2015. Additional FEMA incidents on Queen St can be found through the provided link.