Skip main navigation
Closed
  • $398,000

    225 Queen St APT 24A, Honolulu, HI 96813

    2beds
    704sqft
    Condominium
    Built in 1971
    -- sqft lot
    $400,300 Zestimate®
    $565/sqft
    $3,280 Estimated rent

    Home value

    $400,300

    $372,000 - $428,000

    $3,280/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,280/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,280/mo

    Rent Zestimate®

    Refinance and save

    $1,775/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $1,775/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Located in the heart of downtown Honolulu, this beautiful condo in Harbor Square offers a perfect combination of convenience and comfort. With its prime location, this unit takes city living to the next level with close proximity to shops, dining & entertainment. Nestled on the higher 24th floor with excellent trade winds and mesmerizing ocean views, offering a perfect blend of island tranquility and modern comfort. Boasting freshly painted interior, central A/C (just inspected), all utilities included in maintenance fee and peace of mind with secured building entry. There is parking available at Autopark Hawaii, starting at $260 a month. The deck with pool & BBQ is currently under construction until June 2024. This is a wonderful opportunity for investors or first time home buyers. Some photos are virtually enhanced.

    Zillow last checked:

    Listing updated:

    Listed by:

    Tracey Anne Stott Kelley 808-286-3394,

    Stott Real Estate, Inc.

    Bought with:

    Melissa Marie McGuire, RB-69207

    Stott Real Estate, Inc.

    Source: HiCentral MLS,MLS#: 202401441MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    • Full bathrooms: 2
    Cooling
    • Central Air
    Features
    • Flooring: Carpet, Ceramic Tile
    • Common walls with other units/homes: End Unit
    Interior area
    • Total structure area: 825
    • Total interior livable area: 704 sqft

    Property

    Parking
    • Parking features: None
    Features
    • Has view: Yes
    • View description: City, Mountain(s), Ocean
    • Has water view: Yes
    • Water view: Ocean
    Details
    • Parcel number: 1210160150129
    • Zoning description: 34 - BMX-4 Central Business Mix
    • Special conditions: None

    Construction

    Type & style
    • Home type: Condo
    • Architectural style: High Rise
    • Property subtype: Condominium
    Materials
    • Masonry, Concrete, Stucco
    • Foundation: Slab
    Condition
    • Good Condition
    • New construction: No
    • Year built: 1971

    Community & HOA

    Community
    • Features: Barbecue, Community Pool, Deck/Porch, Laundry Facilities, Patio, Storage Facilities, Trash Chute
    • Security: Key Card Entry, Security Guard
    • Subdivision: Downtown
    HOA
    • Amenities included: Management
    • Services included: Cable TV, Electricity, Hot Water, Internet, None, Sewer, Water
    • HOA fee: $1,290 monthly
    Location
    • Region: Honolulu

    Financial & listing details

    • Price per square foot: $565/sqft
    • Tax assessed value: $427,200
    • Annual tax amount: $1,524
    • Date on market: 2/13/2024
    • Inclusions: AC Central, Dishwasher, Disposal, Range/Oven, Refrigerator, Smoke Detector
    • Total actual rent: 2200

    Price history

    DateEventPrice
    3/28/2024Sold$398,000$565/sqft
    Source: HiCentral MLS #202401441 Report a problem
    2/20/2024Contingent$398,000$565/sqft
    Source: HiCentral MLS #202401441 Report a problem
    2/13/2024Listed for sale$398,000+626.3%$565/sqft
    Source: HiCentral MLS #202401441 Report a problem
    4/23/2021Listing removed--
    Source: Zillow Rental Network Premium Report a problem
    4/2/2021Listed for rent$2,200+4.8%$3/sqft
    Source: Zillow Rental Network Premium Report a problem
    3/6/2020Listing removed$2,100$3/sqft
    Source: Stott Property Management, LLC Report a problem
    2/6/2020Listed for rent$2,100$3/sqft
    Source: Stott Property Management, LLC Report a problem
    9/8/2003Sold$54,800-44.5%$78/sqft
    Source: Public Record Report a problem
    3/13/2001Sold$98,800+4%$140/sqft
    Source: Public Record Report a problem
    7/13/2000Sold$95,000$135/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$1,075 -34.1%$427,200 -8.3%
    2024$1,631 +6.7%$465,900 +6.7%
    2023$1,528 +9.9%$436,600 +9.9%
    2022$1,390 +15.1%$397,100 +15.1%
    2021$1,208 -6.7%$345,100 -6.7%
    2020$1,294 -0.2%$369,800 -0.2%
    2019$1,297 +2.8%$370,500 +2.8%
    2018$1,261 +3.8%$360,300 +3.8%
    2017$1,215 +2.8%$347,000 +2.8%
    2016$1,181 -4.1%$337,500 -4.1%
    2015$1,232 +24.7%$352,000 +8.1%
    2014$988 $325,700
    Find assessor info on the county website

    Neighborhood: Downtown

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Royal
    • Middle: Keelikolani
    • High: Mckinley

    Source: HiCentral MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $400,300
    2% more
    +$8,006
    With Zillow Showcase(estimated)
    $408,306