Skip main navigation
Active
  • $960,000

    987 Queen St #3517, Honolulu, HI 96814

    1beds
    554sqft
    : 
    $6,455/mo
    Get pre-qualified
    Condominium
    Built in 2019
    -- sqft lot
    $-- Zestimate®
    $1,733/sqft
    $874/mo HOA

    What's special

    This gorgeous and immaculate high floor residence comes with more than $100,000 of upgrades including its own EV Outlet for the unit’s parking stall, specious Walk-in Storage Room (approx. 44 sq ft), two storage lockers all on level 6 conveniently located near the elevator, and Developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio! Enjoy cool breezes, panoramic mountains, and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It is Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park.
    126 days
    |
    24
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Hiromi Farmer 808-286-5118,

    Coldwell Banker Realty

    Source: HiCentral MLS,MLS#: 202606581MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 1
      • Bathrooms: 1
      • Full bathrooms: 1
      Features
      • Bedroom on Main Level, Full Bath on Main Level, Storage
      • Flooring: Carpet, Ceramic Tile, Hardwood
      • Furnished: Yes
      Interior area
      • Total structure area: 554
      • Total interior livable area: 554 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 1
      • Parking features: Assigned, Covered, Guest, Other, One Space, On Street, Secured
      Features
      • Levels: One
      • Spa features: Community
      • Fencing: Fenced,Wall
      • Has view: Yes
      • View description: City, Mountain(s), Sunrise
      • Frontage type: Other
      Details
      • Parcel number: 1230021070643
      • Zoning description: Kak – Kakaako Community Development Project
      • Special conditions: None

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: High Rise
      • Property subtype: Condominium
      Materials
      • Double Wall, Concrete, Steel Frame
      Condition
      • Excellent
      • New construction: No
      • Year built: 2019

      Community & HOA

      Community
      • Features: Barbecue, Clubhouse, Community Pool, Conference/Meeting Room, Deck/Porch, Dog Park, Fitness, Other, Patio, Pool, Recreation Area, Restaurant, Storage Facilities, Trash Chute
      • Security: Closed Circuit Camera(s), Elevator Secured, Key Card Entry, Fire Sprinkler System, Security Guard
      • Subdivision: Kakaako
      HOA
      • Amenities included: Management
      • Services included: Common Areas, Internet, Sewer, Water
      • HOA fee: $874 monthly
      • HOA name: Aalii
      Location
      • Region: Honolulu

      Financial & listing details

      • Price per square foot: $1,733/sqft
      • Tax assessed value: $778,200
      • Annual tax amount: $2,820
      • Date on market: 3/31/2026
      • Inclusions: AC Split, Auto Garage Door Opener, Dishwasher, Disposal, Drapes, Dryer, Kitchenware, Linens, Microwave Hood, Other, Range/Oven, Refrigerator, Smoke Detector, Washer, Water Heater

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        4/1/2026Listed for sale$960,000$1,733/sqft
        Source: HiCentral MLS #202606581 Report a problem
        1/26/2026Listing removed$960,000$1,733/sqft
        Source: HiCentral MLS #202427834 Report a problem
        12/6/2024Listed for sale$960,000-1.5%$1,733/sqft
        Source: HiCentral MLS #202427834 Report a problem
        9/17/2024Listing removed$975,000$1,760/sqft
        Source: HiCentral MLS #202320793 Report a problem
        9/11/2023Listed for sale$975,000$1,760/sqft
        Source: HiCentral MLS #202320793 Report a problem
        9/8/2023Listing removed$975,000$1,760/sqft
        Source: HiCentral MLS #202219075 Report a problem
        10/5/2022Listed for sale$975,000$1,760/sqft
        Source: HiCentral MLS #202219075 Report a problem
        9/27/2022Contingent$975,000$1,760/sqft
        Source: HiCentral MLS #202219075 Report a problem
        9/23/2022Listed for sale$975,000+8.6%$1,760/sqft
        Source: HiCentral MLS #202219075 Report a problem
        7/23/2022Listing removed$898,000$1,621/sqft
        Source: HiCentral MLS #202212128 Report a problem
        7/2/2022Listed for sale$898,000$1,621/sqft
        Source: HiCentral MLS #202212128 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$2,816 -1.7%$804,600 -1.7%
        2024$2,865 +5.8%$818,600 -6.3%
        2023$2,707 +167.7%$873,500 +202.4%
        2022$1,011 +51.7%$288,900 +51.7%
        2021$666 +122.1%$190,400 +724.2%
        2020$300 $23,100 -17.5%
        2019$300 +146.3%$28,000 -19.5%
        2018$122 $34,800
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Kakaako

        Getting around

        96 / 100
        Walker's Paradise
        77 / 100
        Excellent Transit
        61 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes