Queen St, Honolulu HI street index
| Block | Buildings | Properties | Businesses | Residents |
|---|---|---|---|---|
| 700-899 | 700-894 | 68 | 347 | 144 |
| 900-5454 | 901-5454 | 465 | 272 | 492 |
Residents
- 3 beds
- 1 bath
- Lot: 7,500 sqft
- Built in 1913
Facts
Lot size: 7,500 sqft
Rooms: 5
Stories: 1 story with basement
Exterior walls: Wood
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
Roses Island
|
808-596-****
|
|
|
|
Cathy C Yamaguchi
|
808-566-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
|
Categories:
Upholsterers
|
See Details | |
|
Hula H Little
|
808-597-****
|
|
|
|
Angelique R Weed Age: 49
|
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Nonclassifiable Establishments
Type of Business:
Domestic Limited Liability Company (LLC)
|
See Details | |
|
|
Industry:
Financial ServicesRet Sporting Goods/Bicycles
Site:
tropicalblendsurf.com
|
See Details | |
|
Bonnie D Parsons
|
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Type of Business:
Domestic Profit Corporation
|
See Details |
Alternative address: 916 Queen St, Hon, HI 96814-3321
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
|
Categories:
Audiovisual Equipment Parts & Supplies Dealers
Industry:
Ret Misc Merchandise
|
See Details | |
|
808-593-****
|
Categories:
Auto Accessories
Site:
hawaii.com
|
See Details | |
|
Young Chu
|
808-593-****
|
Organization:
Car AudioTech
Site:
hawaii.com
President
Young Chol Chu
|
|
|
Car Audio Tech
|
808-593-****
|
|
|
|
|
Industry:
Manufacture, Retail Wholesale Of Furniture
Inactive:
20011123
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-594-****
808-593-****
800-293-****
|
Specialties:
HomesLots
Categories:
Banks
Site:
asbhawaii.com
|
See Details | |
|
808-594-****
808-597-****
|
SIC6:
603599 - Federal savings institutions, nec
|
See Details | |
|
Leland Matsuda
|
808-594-****
808-597-****
|
||
|
|
SIC:
6162 - Mortgage Bankers and Loan Correspondents
|
See Details | |
|
Brian H Egami
|
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
To Hold, Sell Or Otherwise Dispose Of All Or Any Part Of The Shares Of Common Stock Described In Paragraph 6 Of The Certi Ficate &/or To Hold, Operate, Improve Property (See Cert)
Type of Business:
Domestic Limited Partnership
|
See Details | |
|
|
Industry:
Hospital & Health Care
Site:
zhome.co.in
|
See Details | |
|
Dennis G Chun Age: 78
|
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-591-****
|
Industry:
Disinfecting/Pest Services
|
See Details | |
|
Kamaaina Termite & Pest Control
|
808-591-****
|
Categories:
Professional Services
|
|
|
Harry Kansaki
|
808-591-****
808-593-****
|
Organization:
Kama'aina Termite & Pest Control Inc.
Site:
kamaainatermite.com
President
Mr. Michael Miske Jr.
General Manager
Mr. David Melton
RME
Mr. Harry Kansaki
|
|
|
David Melton
|
808-591-****
808-593-****
|
Organization:
Kama'aina Termite & Pest Control Inc.
Site:
kamaainatermite.com
President
Mr. Michael Miske Jr.
General Manager
Mr. David Melton
RME
Mr. Harry Kansaki
|
|
|
808-597-****
808-597-****
|
Categories:
Pest Control Services
Industry:
Management ServicesPest Control
Site:
certifiedpesthawaii.com
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-597-****
808-593-****
|
Specialties:
Handicapped Fixtures
Categories:
Plumbing ContractorsGovernment Contractors
Industry:
AccountingPlumbing/Heating/Air Cond ContractorPlumbingRemodelingBathroom & Kitchen Remodeling
Site:
kamaainaplumbing.com
|
See Details | |
|
|
Industry:
Refuse System
|
See Details | |
|
Kamaaina Termite & Pest Control
|
808-591-****
|
|
|
|
Edward D Freitas
|
|
|
|
|
Kama'aina Rolloffs
|
808-591-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
808-593-****
|
Categories:
Interior Decorators & Designers
|
See Details | |
|
Jean Germain
|
808-593-****
|
Organization:
Design Galleria International
Owner
Jean Germain
|
|
|
|
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
|
Type of Business:
Domestic Profit Corporation
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
888-492-****
888-973-****
808-591-****
|
Categories:
Furniture
Industry:
Contract FurnishingsWhol FurnitureFurniture SalesFurniture Merchant WholsFurniture Merchant Wholesalers
Type of Business:
Domestic Profit Corporation
SIC:
5021 - Furniture
SIC6:
502112 - Office Furniture & Equip-Dealers (Whol)
Site:
api.citygridmedia.com
interior-showplace.com |
See Details | |
|
Interior Showplace Ltd
|
808-593-****
|
|
|
|
Linda S Kano
|
808-942-****
808-591-****
|
Email:
Organization:
Interior Showplace Ltd
Title:
President
Industry:
Furniture Merchant Whols
Site:
interior-showplace.com
|
|
|
808-596-****
|
Industry:
Fabricated Structural Metal Manufacturing
SIC:
3441 - Fabricated Structural Metal
SIC6:
502100 - Wholesaler of furniture
|
See Details | |
|
Robert Edgar
|
808-596-****
|
Email:
Organization:
The Lynch Co Inc
Title:
Executive Offr
Industry:
Fabricated Structural Metal Manufacturing
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
|
Categories:
Auto Parts & Supplies - Used & RebuiltAuto Repair - Mobile
Industry:
Automotive/torque Converter RebuildingAutomotive Rebuilder Of Torque ConvertersRebuilding Transmission Components General Auto RepairWhol Used Auto Parts
Type of Business:
Domestic Profit Corporation
Inactive:
20010413
|
See Details | |
|
808-593-****
|
Industry:
AUTOMOTIVE/TORQUE CONVERTER REBUILDINGAUTOMOTIVE REBUILDER OF TORQUE CONVERTERSWhol Used Auto Parts
Type of Business:
Domestic Profit Corporation
Inactive:
20010413
|
See Details | |
|
Gary Tamura
|
808-593-****
|
Organization:
Converter Factory, (The)
Organization alias:
Ray's Auto Service
Owner
Mr. Gary S. Tamura
|
|
|
808-591-****
|
Categories:
Transmissions - AutomobileAuto Service & RepairAuto TransmissionsPower Transmission Equipment Service & Repair
Industry:
Auto RepairGeneral Auto RepairTransmission Repair
Type of Business:
Domestic Limited Liability Company (LLC)
Inactive:
19951207
Site:
raystransmissionhi.com
|
See Details | |
|
Ray's Transmission Service Center LLC
|
808-591-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Furniture - Manufacturing & Retailing
Type of Business:
Domestic Profit Corporation
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
|
Categories:
Furniture StoresOutdoor Furniture Retail
Industry:
Ret FurnitureFurniture Sales
SIC:
1531 - Operative Builders
Site:
worldwidefurnishingshawaii.web.officelive.com
|
See Details | |
|
Worldwide Furnishings
|
808-593-****
|
|
|
|
Joseph Meccarello
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-593-****
808-591-****
808-591-****
|
Categories:
Food Products Wholesale & ManufacturersGovernment ContractorsManufacturers' Agents & Representatives
Industry:
Food BrokersWhol General Groceries Whol Fruits/Vegetables
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
Summac Hawaii LTD
|
808-593-****
|
|
|
|
808-591-****
|
Industry:
Warehousing And TruckingRefrigeration Warehouse/Storage Special Warehouse/Storage
Type of Business:
Domestic Profit Corporation
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Cleaning Carpets And Maintaining Them
Inactive:
19900914
|
See Details | |
|
808-593-****
808-591-****
|
Categories:
Cleaning Compounds Wholesale & ManufacturersGovernment Contractors
Industry:
Distributor Cleaning and Maintenance Equipment and SuppliesCleaning Compounds (Wholesale)Other Chemical Merchant WholsService Establishment Equipment and Supplies Merchant Wholes
SIC:
5169 - Chemicals and Allied Products, Not Elsewhere Classified
Site:
coast-products.com
|
See Details | |
|
James Garcia
|
808-593-****
|
Email:
Organization:
Coast Products Inc
Title:
President
Industry:
Service Establishment Equipment and Supplies Merchant Wholes
|
|
|
Jim Garcia
|
808-593-****
808-591-****
|
Email:
Organization:
Coast Products Inc
Title:
President
Industry:
Other Chemical Merchant Whols
Site:
coast-products.com
|
|
|
Coast Products Inc
|
808-593-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
Tropical Auto Paints
|
808-597-****
|
Categories:
Automotive
|
|
|
808-597-****
808-591-****
|
Categories:
Auto Body Equipment & Supplies RetailAuto Body Equipment & Supplies Wholesale & ManufacturersAuto Parts RetailMetal Finishing
Industry:
Whol Auto Supplies & Parts
|
See Details | |
|
Tropical Otto Parts
|
808-597-****
|
|
|
|
808-593-****
|
Categories:
Electric Equipment Service & RepairLamps Parts & Supplies Wholesale & ManufacturersLighting Fixtures Repair Maintenance & InstallationMetal Polishing Buffing & PlatingPolishes
|
See Details | |
|
Tropical Lamp & Shade Co
|
808-593-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Automotive Repair Services
Inactive:
20130324
|
See Details | |
|
|
Industry:
Auto Motive Glass & Radiator RepairAutomotive Glass & Radiator Repair
Inactive:
20011011
|
See Details | |
|
808-591-****
|
Industry:
Auto Repair
|
See Details | |
|
808-637-****
|
Categories:
Tattoos
|
See Details | |
|
808-596-****
|
Industry:
Auto Repair
|
See Details |
Sold
$1,285,300
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
To Protect The Rights Of Small Businesses And Landowners In KakaakoTo Protect The Rights Of Small Businesses And Landowners In Kaka'ako
Inactive:
20100517
|
See Details | |
|
Okada U & Company Limited
|
808-597-****
|
Categories:
GroceryRestaurants
|
|
|
808-597-****
808-591-****
|
Categories:
Fish & Seafood RetailGovernment ContractorsMeat ProcessingMeats
Industry:
Wholesaler Of FoodsWhol Packaged Frozen Goods
Type of Business:
Domestic Profit Corporation
SIC:
7389 - Business Services, Not Elsewhere Classified
|
See Details | |
|
U Okada & Co Ltd
|
808-597-****
|
|
|
|
Company Okada
|
808-597-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-597-****
808-593-****
|
Categories:
Grocery
Industry:
Retail & Wholesale Of Fresh And Prepared Seafoods
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
Jacob Hoopai
|
808-597-****
808-593-****
|
Organization:
Amy's Fish Market, Inc.
President
Mr. Jacob Hoopai
Secretary / Treasurer
Mr. Robin Leong
|
|
|
Robin Leong
|
808-597-****
808-593-****
|
Organization:
Amy's Fish Market, Inc.
President
Mr. Jacob Hoopai
Secretary / Treasurer
Mr. Robin Leong
|
|
|
Amy's Fish Market
|
808-597-****
|
|
- Lot: 5,000 sqft
- Built in 1956
Facts
Lot size: 5,000 sqft
Stories: 2 story
Exterior walls: Brick
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
Bete Boutique
|
|
Categories:
Other
|
|
|
DiverseART
|
|
Categories:
Other
|
|
|
808-596-****
808-593-****
|
Industry:
Book Stores
SIC:
5942 - Book Stores
Site:
honolulu.logosbookstores.com
|
See Details | |
|
Carl Ashizawa
|
808-596-****
808-593-****
|
Email:
Organization:
Logos Bookstore of Hawaii
Title:
Manager
Industry:
Book Stores
Site:
honolulu.logosbookstores.com
|
|
|
808-864-****
|
Site:
stillandmovingcenter.com
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-591-****
|
Categories:
Antique Dealers
|
See Details | |
|
808-592-****
808-842-****
|
Categories:
Document Imaging & Scanning ServiceCopiers & Copier SuppliesComputer & Equipment DealersCopying & Duplicating ServicesIndustrial Equipment & Supplies Wholesale & ManufacturersPrint...
Industry:
Ret & Repair Electronic Business Machines
Site:
kyoceramita.com
|
See Details | |
|
Electronic Business Machines
|
808-592-****
|
|
|
|
Ronald Shirai
|
808-592-****
|
Organization:
ELECTRONIC BUSINESS MACHINES, INC.
president/owner
Mr. Ronald Shirai
|
|
|
808-524-****
|
Categories:
Cultural Attractions Events & Facilities
Site:
honoluludancestudio.com
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-591-****
808-591-****
|
Categories:
Manufacturers Agents & RepresentativesHawaiian GoodsWholesalers & DistributorsClothing StoresWomen's Clothing Wholesale & Manufacturers
Industry:
Mfg Women's Dresses
Site:
betemuu.com
|
See Details | |
|
Linda Nahulu
|
808-591-****
|
Email:
Organization:
Bete MUU
Title:
Principal
Industry:
Women's and Girls' Cut and Sew Dress Manufacturing
|
|
|
Nola Nahulu
|
808-591-****
|
Email:
Organization:
Bete MUU
Title:
Principal
Industry:
Women's and Girls' Cut and Sew Dress Manufacturing
|
|
|
|
Industry:
Designing, Manufacturing, Marketing, Distributing Wholesaling And Retailing Its Patented Peelers(Bogo, Buy One-Get One Free Coupons)
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
|
Industry:
Commercial Photography And A Comprehensive Pre-Press Production Center
Inactive:
19980511
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Hotel & Resort Photography
Inactive:
20160405
|
See Details | |
|
808-591-****
808-591-****
|
Categories:
Manufacturers Agents & RepresentativesHawaiian GoodsWholesalers & DistributorsClothing StoresWomen's Clothing Wholesale & Manufacturers
Site:
betemuu.com
|
See Details | |
|
808-524-****
|
SIC:
6531 - Real Estate Agents and Managers
|
See Details | |
|
808-591-****
808-955-****
|
Categories:
Flags Flagpoles Banners & PennantsLaminating EquipmentPhotofinishing RetailPrinting ServicesSigns Wholesale & Manufacturers
Industry:
Home Builders
Site:
hawaiidigital.com
cheapbannershawaii.com |
See Details | |
|
808-955-****
808-591-****
|
Categories:
Signs
Industry:
Lithographic Commercial PrintingRemodeling
Site:
hawaiidigital.net
|
See Details |
- Lot: 1.3 acres
Facts
Lot size: 1.3 acres
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Advertising Agency
|
See Details | |
|
|
Industry:
Mfg Calculating Equipment
|
See Details | |
|
|
Industry:
Business Consulting Services
|
See Details | |
|
|
Industry:
Visual Effects, Animation And Compositing For Feature Films, Television Commercials And Music Videos
Inactive:
20091126
|
See Details | |
|
808-593-****
|
Industry:
Real Estate Agent/Manager
|
See Details |
- Koolani Condominium
For Sale
$1,100,000
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
808-943-****
|
Industry:
Boat Sales
Site:
alawaiyachtbrokerage.com
|
See Details | |
|
|
Industry:
To Own, Hold, Rent, Lease, Manage, Encumber, Improve, Exchange, Buy, And Sell Real Property, Collect Rents, And Do A General Real Estate Business; (See Articles For More)
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
|
Type of Business:
Domestic Limited Liability Company (LLC)
|
See Details | |
|
808-230-****
|
Industry:
Real Estate AppraisalsLegal Services Office
Inactive:
20170619
SIC:
6531 - Real Estate Agents and Managers
|
See Details | |
|
|
Type of Business:
Domestic Limited Liability Company (LLC)
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Type of Business:
Domestic for Profit Corporation
|
See Details | |
|
|
Industry:
Landscape Architectural DesignLandscape Services
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
Edward Y Asato Age: 80
|
808-531-****
|
|
|
|
Randolph F Y Ching
|
|
|
|
|
Angie L Ho
|
808-531-****
|
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Computer Games
|
See Details | |
|
808-536-****
|
Industry:
Nonresidential Building Operator
|
See Details | |
|
|
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
|
Industry:
Architectural Services
|
See Details | |
|
|
Industry:
Travel Agents
Type of Business:
Domestic Profit Corporation
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Interior Design
Type of Business:
Domestic Limited Liability Company (LLC)
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Industry:
Real Estate Investments
Type of Business:
Domestic Profit Corporation
|
See Details | |
|
|
Industry:
Elementary/Secondary School
|
See Details | |
|
808-524-****
|
Industry:
Architectural Services
SIC:
8712 - Architectural Services
|
See Details | |
|
Donald Fowler
|
808-524-****
|
Email:
Organization:
HYA Group Architect LLC
Title:
Manager
Industry:
Architectural Services
|
|
|
Howard Yoshino
|
808-524-****
|
Email:
Organization:
HYA Group Architect LLC
Title:
Manager
Industry:
Architectural Services
|
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
|
Type of Business:
Foreign For-Profit Corporation
|
See Details |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|
John H Waiolama
|
|
|
Market Activities
To date, we have no information about market activities in 2025
Oct 2024
Listed for sale
Oct 2024
Listed for sale
Oct 2024
Listed for sale
Oct 2024
Listed for sale
Oct 2024
Sold
Oct 2024
Listed for sale
Oct 2024
Sold
Oct 2024
Listed for sale
Oct 2024
Listed for sale
Oct 2024
Sold
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Listed for sale
Sep 2024
Sold
Sep 2024
Listed for sale
Sep 2024
Sold
Building Permits
To date, we have no information about building permits in 2025
Aug 31, 2006
953 Queen St
Description: Interior alteration to an existing restaurant (2006/ibp0694)
- Valuation: $4,900,000
- Client: Mc Donald's Restaurants Of Hawaii
- Parcel #: 23002059
- Permit #: 601445
Aug 3, 2005
945 Queen St
Description: Electrical for sign hook up.
- Contractor: Maks Electrical Contracting
- Valuation: $50,000
- Client: Furniture Haven
- Parcel #: 23002058
- Permit #: 583881
Mar 21, 2002
970 Queen St
Description: Elec new hanging sign (s2002-3-17)
- Valuation: $50,000
- Client: World Wide Furnishings
- Parcel #: 23003021
- Permit #: 532699
Sep 15, 1999
956 Queen St
Description: Interior showplace - al,el,pl,ot
- Valuation: $15,000,000
- Client: Interior Showplace Ltd
- Parcel #: 23003022
- Permit #: 436342
Jun 6, 1995
972 Queen St
Description: Sunmac hi - al,el
- Valuation: $4,250,000
- Client: Sunmac Hawaii Ltd
- Parcel #: 23003020
- Permit #: 370543
Fire Incident History
To date, we have no information about fire incidents in 2025
25 Apr 2019
Passenger vehicle fire
Property Use —
Vehicle parking area
Area of Origin —
Cargo/trunk area - all vehicles
First Ignition —
Non-upholstered chair, bench
06 Mar 2019
Passenger vehicle fire
Property Use —
Specialty shop
Area of Origin —
Operator/passenger area of transportation equip.
First Ignition —
Upholstered sofa, chair, vehicle seats
Heat Source —
Heat from other open flame or smoking materials
16 Feb 2019
Building fires
Property Use —
Multifamily dwellings
Area of Origin —
Wall surface: exterior
First Ignition —
Appliance housing or casing
Heat Source —
Arcing
23 Aug 2017
Building fires
Property Use —
Specialty shop
Area of Origin —
Other
First Ignition —
Insulation within structural area
Incidents registered in Federal Emergency Management Agency
To date, we have no information about incidents registered in FEMA in 2025
16 Aug 2015
Vehicle accident, general cleanup
Property Use —
Street or road in commercial area
01 Aug 2015
Cultivated trees or nursery stock fire
Property Use —
Residential street, road or residential driveway
30 Dec 2014
Arcing, shorted electrical equipment
Property Use —
Business office
09 Dec 2014
Cooking fire, confined to container
Property Use —
Multifamily dwellings