4-690 Queen St, Honolulu HI

1634 properties and 2045 residents found on Queen St, Honolulu, HI. Find out more information with RadioAwards Address Directory.


Queen St, Honolulu HI street index

Block Buildings Properties Businesses Residents
1-699 4-690 1046 714 1317
700-899 700-894 68 347 144

Residents

Who has lived here

Resident Phone Number Additional info
Thomas J Williams
808-526-****

Who has lived here

Resident Phone Number Additional info
Robert Ballard

Who has lived here

Resident Phone Number Additional info
David L Monroy

Who has lived here

Resident Phone Number Additional info
Sara R Harvey
808-548-****

Alternative address: 66 Queen St, Hon, HI 96813-4410

  • Harbor Court Residences
66 Queen St, Honolulu, HI 96813-4410
For Sale $929,000

Who has lived here

Resident Phone Number Additional info
Type of Business:
Domestic Profit Corporation
See Details
Industry:
Environmental & General Contracting
Inactive:
19980310
See Details
Type of Business:
Domestic Limited Partnership
See Details
Industry:
Management And Image ConsultingManagement Consulting ServicesManagement Consulting Services Business Consulting Services Nec
Inactive:
20170328
See Details
Industry:
Factoring Company
Inactive:
20120304
See Details

Who has lived here

Resident Phone Number Additional info
Timothy M Howlin

Who has lived here

Resident Phone Number Additional info
808-591-****
808-593-****
Industry:
ChemicalsExterminating & Pest Control Svcs
SIC:
7342 - Disinfecting and Pest Control Services
SIC6:
734201 - Pest Control
Site:
kamaainatermite.com
See Details

Who has lived here

Resident Phone Number Additional info
Maurice M Cavaco
  • Aloha Realty Bldg

Who has lived here

Resident Phone Number Additional info
Industry:
Loan Broker
See Details
Industry:
Sale Of Computer Hardware And Software
Type of Business:
Domestic Profit Corporation
See Details
808-447-****
Industry:
Computer Related Services Mfg Computer Terminals
See Details
808-234-****
Categories:
Airlines
Industry:
Travel Agency
See Details
Industry:
Real Estate Sales
Inactive:
19910930
See Details

Who has lived here

Resident Phone Number Additional info
Rose Mcdermott
  • Lot: 3,036 sqft

Facts

Lot size: 3,036 sqft

Who has lived here

Resident Phone Number Additional info
Industry:
To Promote The Study Of Buddhism And Related Cultural Programs;
Type of Business:
Domestic Nonprofit Corporation
See Details

Who has lived here

Resident Phone Number Additional info
Julius C Alim

Who has lived here

Resident Phone Number Additional info
Michael Panzica
Michael Whitman

Alternative address: 225 Queen St, Hon, HI 96813-4600

  • Town Tower
  • 2 beds
  • 2 baths
  • Lot: 825 sqft
225 Queen St, Honolulu, HI 96813-4600
For Sale $385,000

Who has lived here

Resident Phone Number Additional info
Industry:
Creative Consultants For Multi Media And Interior & Exterior Designing
Type of Business:
General Domestic Partnership
See Details
Industry:
Watchman Service For A Construction Site
Inactive:
19980408
See Details
Industry:
Investment And Capital Counseling And Placements
Type of Business:
General Domestic Partnership
See Details
Type of Business:
Domestic Limited Liability Company (LLC)
See Details
Industry:
Planning Events, Promotional, Parties, Selling Related Merchandise
Inactive:
20161105
See Details

    Who has lived here

    Resident Phone Number Additional info
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details

    Who has lived here

    Resident Phone Number Additional info
    David L Ventzke
    808-534-****

    Who has lived here

    Resident Phone Number Additional info
    Sunny G Mitsui

    Who has lived here

    Resident Phone Number Additional info
    Jasmin M Ng
    Terence K Omori
    Carl H Osaki Age: 65
    808-528-****
    Mark W Sparks Age: 73
    David E Thompson
    • Melim Bldg

    Who has lived here

    Resident Phone Number Additional info
    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
    Type of Business:
    Domestic Profit Corporation
    See Details
    Industry:
    Real Estate Investment
    Inactive:
    19901203
    See Details
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Industry:
    Gas Production/Distribution
    See Details
    Industry:
    To Transact A Wholesale/retail Business And Its Related Service Business;
    Type of Business:
    Domestic Profit Corporation
    See Details

    Alternative address: 345 Queen St, Hon, HI 96813-4701

    • Media Five Plaza

    Who has lived here

    Resident Phone Number Additional info
    Industry:
    Professional Design Services
    Type of Business:
    Domestic Profit Corporation
    See Details
    Industry:
    Owning Redeveloping And Operating An Office Building
    Type of Business:
    General Domestic Partnership
    See Details
    Industry:
    Nonclassifiable Establishments
    Type of Business:
    Domestic Limited Liability Company (LLC)
    See Details
    Industry:
    Golf LessonNonclassifiable Establishments
    Type of Business:
    Domestic Profit Corporation
    See Details
    Industry:
    Trade
    Type of Business:
    Domestic Profit Corporation
    See Details

    Who has lived here

    Resident Phone Number Additional info
    Mary V Coulter

    Who has lived here

    Resident Phone Number Additional info
    808-586-****
    808-586-****
    Categories:
    Government ContractorsLegal Counsel & ProsecutionState Government Offices
    Site:
    allstateguttershi.com
    See Details
    808-586-****
    808-586-****
    808-586-****
    808-586-****
    808-586-****
    808-586-****
    808-587-****
    808-586-****
    808-586-****
    Industry:
    Attorney General's OfficeLegal Counsel/ProsecutionAttorney GeneralState Tax AdministrationState Attorney General
    See Details
    808-587-****
    Categories:
    Attorneys
    See Details
    Attorney General's office
    Categories:
    Other
    Industry:
    Renewables & Environment
    See Details

      Who has lived here

      Resident Phone Number Additional info
      808-539-****
      Categories:
      State Government Offices
      Site:
      court.statehi.us
      See Details
      Commission On Judicial Conduct
      808-539-****
      808-539-****
      Categories:
      State Government Offices
      See Details
      Honorable Katherine G Leonard
      808-539-****
      808-539-****
      808-539-****
      Industry:
      CourtGeneral GovernmentState Court
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Richard Y Kurahara

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Manufacturing Soft Goods
      Inactive:
      19900505
      See Details
      808-566-****
      Industry:
      Youth Social Service
      See Details
      808-528-****
      808-545-****
      Industry:
      Religious Organization
      SIC:
      8661 - Religious Organizations
      Site:
      wordoflifehawaii.com
      See Details
      Arturo K Sepulveda Age: 64
      808-528-****
      Art K Sepulveda
      808-262-****
      808-545-****
      Organization:
      Word of Life Christian Ctr
      Title:
      Religious Leader
      Industry:
      Religious Organization
      Site:
      wordoflifehawaii.com

      Alternative address: 545 Queen St, Hon, HI 96813-5048

      • 1 bath
      • 510 sqft
      • Built in 1995

      Facts

      Rooms: 2

      Stories: 7 story

      Exterior walls: Combination

      Air conditioning: Central

      Parking: Carport, Garage - Attached, Garage - Detached

      545 Queen St, Honolulu, HI 96813-5048
      For Sale $379,000

      Who has lived here

      Resident Phone Number Additional info
      Type of Business:
      Domestic Limited Liability Company (LLC)
      See Details
      Type of Business:
      Domestic Profit Corporation
      See Details
      Industry:
      Ceramic Tile & Natural Stone Installation
      Inactive:
      20120923
      See Details
      Industry:
      Taxi Service
      Inactive:
      20181111
      See Details
      Industry:
      Music Production
      Type of Business:
      Domestic Limited Liability Company (LLC)
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Chad Morita

      Who has lived here

      Resident Phone Number Additional info
      Tomoko Kanna

      Who has lived here

      Resident Phone Number Additional info
      SIC:
      6324 - Hospital and Medical Service Plans
      See Details
      Industry:
      InactiveNonclassifiable Establishments
      Type of Business:
      Domestic Profit Corporation
      See Details
      Industry:
      Nonprofit Organization ManagementNonclassifiable Establishments
      Site:
      life360network.com
      See Details
      Industry:
      Purchase & Wholesale & Retail Sales
      Type of Business:
      Domestic Profit Corporation
      See Details
      808-441-****
      Industry:
      Religious Organizations
      SIC:
      8661 - Religious Organizations
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Fire Protection
      See Details
      808-536-****
      Categories:
      Fire Departments
      See Details
      Honolulu Fire Station
      808-536-****

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Marketing Cruise Vacations
      Inactive:
      19900921
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Sherlyn David
      808-585-****
      Jesse S Lum Age: 84

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      The Kakaako Community Oversight Of Government Spending To Insure That Our Taxpayer Dollars Are Spent In A Responsible And Prudent Manner
      Type of Business:
      Domestic Nonprofit Corporation
      See Details
      James H Myoung

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      General Auto Repair
      See Details
      Industry:
      Auto Club, Travel Agency
      Type of Business:
      Foreign Nonprofit Corporation
      See Details
      808-528-****
      Industry:
      Copies
      See Details
      808-528-****
      808-528-****
      Specialties:
      Color CopiesDigital Color PrintingFedEx Package Pick upsLarge Format PrintingPackaging & ShippingPoster Printing
      Categories:
      Copying & Duplicating ServicesPackaging & Shipping ServicesPrinting ServicesShipping & Receiving ServicesSign Printing
      Site:
      local.fedex.com
      See Details
      • Keola Lai
      • 2 beds
      • 2 baths
      • 934 sqft
      • Built in 2008
      600 Queen St, Honolulu, HI 96813-5115
      For Sale $639,000

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Nonclassifiable Establishments
      Type of Business:
      Domestic Limited Liability Company (LLC)
      See Details
      Industry:
      Real Estate Development And Construction Project Management Consulting
      Type of Business:
      Domestic Limited Liability Company (LLC)
      See Details
      Industry:
      Eating Place
      See Details
      Industry:
      Business Services at Non-Commercial SiteNonclassifiable Establishments
      See Details
      808-521-****
      Industry:
      Whol Nondurable GoodsWhol Souvenir Items
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Dean K Ortiz
      Pele Toomata
      808-534-****
      Men of War
      808-566-****
      O L Word
      808-524-****

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Wholesaling - Sandwiches
      Inactive:
      19940131
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Importing, Retailing, Tuning, Repairing And Servicing Of Pia Nos And Piano Accessories
      Inactive:
      19891102
      See Details

      Who has lived here

      Resident Phone Number Additional info
      Franklin Menor

      Who has lived here

      Resident Phone Number Additional info
      Haruko I Lim
      808-833-****

      Who has lived here

      Resident Phone Number Additional info
      Industry:
      Ceramic Manufacturing And Wholesale
      Type of Business:
      General Domestic Partnership
      See Details

      Who has lived here

      Resident Phone Number Additional info
      808-237-****
      808-237-****
      808-237-****
      Categories:
      Telecommunications Equipment - DisabilityPhone Communications ServicesPhone Communications Services ResidentialPhone Equipment & Systems Parts & SuppliesPhone Equipment & Systems W...
      Industry:
      Electrical Repair Business Consulting Services
      See Details

        Who has lived here

        Resident Phone Number Additional info
        808-941-****
        808-596-****
        Industry:
        RETAIL & WHOLESALE JEWELRY & GIFTSRet Gifts & Jewelry
        Type of Business:
        Domestic Profit Corporation
        See Details
        808-593-****
        808-593-****
        Categories:
        Women's Accessories Retail
        SIC:
        5632 - Women's Accessory and Specialty Stores
        Site:
        asseenontvhawaii.com
        See Details
        808-593-****
        808-591-****
        808-596-****
        Categories:
        General Merchandise - RetailGift Shops
        Industry:
        Retail/wholesaleWhol Nondurable GoodsNovelty StoreRadio/Television RepairGift Shops
        Type of Business:
        Domestic Profit Corporation
        Site:
        asseenontvhawaii.com
        See Details
        Industry:
        Engage In Any Lawful Business For Which A Corporation May Be Organized Under Chapter 415
        Type of Business:
        Domestic Profit Corporation
        See Details
        808-592-****
        Industry:
        Camera and Photographic Supplies Stores
        SIC:
        5946 - Camera and Photographic Supply Stores
        See Details
        • 2 beds
        • 2 baths
        • 1,650 sqft

        Facts

        Parking: Garage

        Who has lived here

        Resident Phone Number Additional info
        Snapshot Photo
        808-593-****
        Categories:
        ArtElectronics
        James A Ferbrache Age: 59
        Jerry Y Fujioka Age: 79
        808-262-****
        Shinako Fujioka Age: 58
        • 141,210 sqft
        • Built in 1991

        Facts

        Lot size: 0.26 acres

        Who has lived here

        Resident Phone Number Additional info
        808-587-****
        808-587-****
        Categories:
        State Government Offices
        See Details
        808-587-****
        Categories:
        State Government Offices
        See Details
        808-587-****
        Categories:
        Employee Benefit & Compensation Plans
        See Details
        808-587-****
        Industry:
        Individual/Family ServicesInvestment Advisory Service Administrative Social/Manpower ProgramsAdministrative Social/Manpower ProgramsInvestment Advisory ServiceChild Day Care Services
        See Details
        808-587-****
        Industry:
        Other Human Resource Programs Administration
        SIC:
        9441 - Administration of Social, Human Resource and Income Maintenance Programs
        Site:
        doe.k12.hi.us
        See Details

        Who has lived here

        Resident Phone Number Additional info
        808-536-****
        808-536-****
        Categories:
        Architects' SuppliesReprographic Services
        Industry:
        Photocopying Service
        See Details
        808-536-****
        808-536-****
        Categories:
        Copy & Duplicating Service
        Industry:
        Blueprinting ServicesCopiesGraphic Design SvcsBlueprintingOther Business Service Centers (including Copy Shops)Other Professional Equipment and Supplies Merchant Wholesale
        SIC:
        7336 - Commercial Art and Graphic Design
        SIC6:
        733617 - Reprographic Services
        Site:
        theblueprintcompany.com
        See Details
        Industry:
        Nonclassifiable Establishments
        See Details
        Industry:
        Sewing Machines, Vacuums, And Related Products Including Fabrics
        Inactive:
        20000321
        See Details
        Viking & White Sewing Centers
        808-521-****
        Categories:
        Department Stores

        Who has lived here

        Resident Phone Number Additional info
        Industry:
        General Auto Repair
        See Details

        Market Activities

        To date, we have no information about market activities in 2025
        Oct 2024 Listed for sale
        987 Queen St #1915
        Price history :
        • Condo/Townhouse
        • 877 sqft
        • 2 beds
        • 2 baths
        Oct 2024 Listed for sale
        987 Queen St #2604
        Price history :
        • Condo/Townhouse
        • 624 sqft
        • 1 bed
        • 1 bath
        Oct 2024 Listed for sale
        225 Queen St #21E
        Price history :
        • Condo/Townhouse
        • 725 sqft
        • 2 beds
        • 2 baths
        Oct 2024 Listed for sale
        987 Queen St #2516
        Price history :
        • Condo/Townhouse
        • 347 sqft
        • 1 bath
        Oct 2024 Listed for sale
        987 Queen St #2601
        Price history :
        • Condo/Townhouse
        • 927 sqft
        • 2 beds
        • 2 baths
        Oct 2024 Sold
        1177 Queen St #501
        Price history :
        • Condo/Townhouse
        • 1,374 sqft
        • 3 beds
        • 2 baths
        Oct 2024 Listed for sale
        987 Queen St #2808
        Price history :
        • Condo/Townhouse
        • 410 sqft
        • 1 bath
        Oct 2024 Listed for sale
        600 Queen St #1611
        Price history :
        • Condo/Townhouse
        • 686 sqft
        • 1 bed
        • 1 bath
        Oct 2024 Listed for sale
        225 Queen St #8D
        Price history :
        • Condo/Townhouse
        • 590 sqft
        • 1 bed
        • 1 bath
        Oct 2024 Sold
        1001 Queen St #2108
        Price history :
        • Condo/Townhouse
        • 653 sqft
        • 1 bed
        • 1 bath
        Oct 2024 Listed for sale
        987 Queen St #2808
        Price history :
        • Condo/Townhouse
        • 410 sqft
        • 1 bath
        Oct 2024 Listed for sale
        1177 Queen St #3002
        Price history :
        • Condo/Townhouse
        • 1,561 sqft
        • 3 beds
        • 2 baths
        Oct 2024 Sold
        1001 Queen St #1708
        Price history :
        • Condo/Townhouse
        • 653 sqft
        • 1 bed
        • 1 bath
        Sep 2024 Listed for sale
        1001 Queen St #909
        Price history :
        • Condo/Townhouse
        • 494 sqft
        • 1 bed
        • 1 bath
        Sep 2024 Sold
        66 Queen St #2901
        Price history :
        • Condo/Townhouse
        • 1,574 sqft
        • 2 beds
        • 2 baths
        Sep 2024 Listed for sale
        987 Queen St #3500
        Price history :
        • Condo/Townhouse
        • 600 sqft
        • 1 bed
        • 1 bath
        Sep 2024 Listed for sale
        1177 Queen St #4509
        Price history :
        • Condo/Townhouse
        • 1,392 sqft
        • 3 beds
        • 2 baths
        Sep 2024 Listed for sale
        1001 Queen St #1407
        Price history :
        • Condo/Townhouse
        • 416 sqft
        • 1 bath
        Sep 2024 Sold
        600 Queen St #3608
        Price history :
        • Condo/Townhouse
        • 1,138 sqft
        • 2 beds
        • 2 baths
        Sep 2024 Listed for sale
        225 Queen St #10G
        Price history :
        • Condo/Townhouse
        • 740 sqft
        • 2 beds
        • 2 baths

        View more

        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.
        • 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

        View more

        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

        View more

        Comparison graphs

        House prices on 4-690 Queen St, Honolulu HI

        66222225545600House Number$0$1.0M$2.0M$3.0M$4.0M$5.0M$6.0M$7.0M$8.0M$9.0M$10.0M$11.0M$12.0M$13.0M$14.0MPrices

        Lot size and building area (in sqft) on 4-690 Queen St, Honolulu HI

        222225545600676677House Number010,00020,00030,00040,00050,00060,00070,00080,00090,000100,000110,000120,000130,000140,000150,000Area (in sqft)Lot sizeLiving area

        Where is Queen St, Honolulu HI located on map?