RENTED JUN 17, 2026

Harbor Square 225 Queen St Unit 21 Honolulu, HI 96813

Downtown Honolulu Neighborhood

Estimated Value: $300,000 - $342,000

2 Beds
2 Baths
624 Sq Ft
$514/Sq Ft Est. Value

Sale Details

Date Sold: February 29, 2024

Last sale price $429,000 $688 Per Sq Ft

Est. 25% decrease in value since last sale

Current estimated payment $1,862 / mo

Highlights

  • Ocean View
  • Floor-to-Ceiling Windows
  • Wood Flooring
  • 24-Hour Security
  • 67,910 Sq Ft lot
  • 3-minute walk to Walker Park

About This Home

As of June 2026

Experience the pinnacle of urban living in this highly desirable corner unit, featuring side facing bedroom windows that flood the space with natural light and refreshing cross breezes. Unwind on your spacious 116 sq. ft. lanai and take in breathtaking panoramic views spanning the lush Ko?olau Mountains, the dynamic cityscape, and the glittering Pacific Ocean. Beyond the unit, a resort style 7th floor rooftop amenity deck and pool await, perfect for solo relaxation or hosting friends for a BBQ. Best of all, this home offers unbeatable value and convenience with two parking stalls, a private storage closet right off the elevators, and all inclusive utilities (electricity, central A/C, water, sewer, and cable/internet). Situated just moments from downtown, Kaka?ako’s trendy dining and shopping, and the world famous Ala Moana beach and mall, this is Honolulu living at its finest. Please be advised of a plumbing assessment that is expected to take place sometime within the next year along with repairs to the elevators, building railings, vents, and drains. There may be some disruption.

Last Agent to Rent the Property

Miles Freeman

Hawaii Sands Realty Brokerage Phone: (808) 664-3084 License #RS-88073 Listed on: 06/12/2026

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1971

Lot Details

  • 1.56 Acre Lot
  • Property is in excellent condition

Property Views

  • Mountain

Interior Spaces

  • 624 Sq Ft Home
  • 1-Story Property
  • Partially Furnished
  • Blinds
  • Drapes & Rods
  • Floor-to-Ceiling Windows

Kitchen

  • Oven
  • Range

Flooring

  • Wood
  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Home Security

  • Closed Circuit Camera
  • Fire and Smoke Detector

Parking

  • 2 Parking Spaces
  • Parking Available
  • Covered Parking

Outdoor Features

  • Lanai

Utilities

  • Central Air
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Security Deposit $2,700
  • Property Available on 6/12/26
  • Tenant pays for application fee
  • Rent includes parking
  • 12 Month Lease Term
  • Assessor Parcel Number 1-2-1-016-015-0112

Community Details

Overview

  • High-Rise Community
  • Downtown Subdivision

Amenities

  • Building Patio
  • Community Barbecue Grill
  • Community Deck or Porch
  • Trash Chute
  • Laundry Facilities
  • Community Storage Space

Recreation

  • Recreational Area

Security

  • 24-Hour Security
  • Resident Manager or Management On Site
  • Card or Code Access

Home Details

Home Type

Single Family

Year Built

Built in 1971

Lot Details

1.56 Acres

Rental Info

  • Lease Term: 12 Months
  • Available Date: 2026-06-12

Listing Details

  • Architectural Style: High Rise
  • Building Name: Harbor Square
  • Prop. Type: Residential Lease
  • Year Built: 1971
  • Attribution Contact: (808) 664-3084
  • CommunityFeatures: Barbecue, Deck/Porch, Laundry Facilities, Patio, Property Manager On-Site, Pool, Recreation Area, Storage Facilities, Trash Chute
  • NAV29_Unit_1_Appliances: Microwave Hood Fan, Oven, Range, Refrigerator
  • SecurityFeatures: Closed Circuit Camera(s), 24 Hour Security, Key Card Entry, Smoke Detector(s), Security Guard
  • Association Amenities: Management
  • Pets Allowed: No
  • MLS Status: Closed
  • Subdivision Name: DOWNTOWN
  • Interior Features: Kitchen Exhaust Fan, Single Living Level, Cable TV, Window Treatments
  • Unit Levels: One
  • Living Area: 624.0
  • Window Features: Blinds, Drapes, Floor To Ceiling Window(s)
  • Security Deposit: 2700.0
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Flooring: Carpet, Hardwood, Laminate
  • Furnished: Partially
  • Full Bathrooms: 2
  • Total Bedrooms: 2
  • Stories: 1
  • Stories: 1

Exterior Features

  • Property Condition: Excellent, Good Condition
  • View: City, Mountain(s), Ocean, Sunset
  • View: Yes
  • Disclosures: No Smoking, Renters Insurance Required, See Remarks
  • Common Walls: End Unit
  • Patio And Porch Features: Lanai

Garage/Parking

  • Parking Features: Covered, Two Spaces, Parking Available
  • Total Parking Spaces: 2.0

Utilities

  • Utilities: Electricity Available, High Speed Internet Available, Sewer Available, Water Available
  • Cooling: Central Air
  • Cooling Y N: Yes

Condo/Co-op/Association

  • HOA Rent Includes: Parking

Lot Info

  • Parcel Number: 1-2-1-016-015-0112

Multi Family

  • Tenant Pays: Application Fee

Matterport 3D Tour

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 25, 2013
Closed on
Nov 25, 2013
Sold by
Bought by
Seller's Agent
Michael Riess
Foster Realty, Inc.
Buyer's Agent
Fran Villarmia-Kahawai
Lifehouse Realty
List Price
$305,000
Sold Price
$276,500
Premium/Discount to List
-$28,500
-9.34%
Current Estimated Value
$320,613

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$44,113
Avg. Annual Appreciation
1.18%
Original Mortgage
$220,000
Interest Rate
4.08%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 16, 2009
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$40,000
Interest Rate
5.31%
Mortgage Type
Unknown

Purchase Details

Closed on
Jun 2, 2009
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$40,000
Interest Rate
5.31%
Mortgage Type
Unknown
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$276,500 Tg
-- None Available
$220,000 Het
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $257,600
Closed $257,600
Closed $220,000
Previous Owner $14,500
Previous Owner $40,000
Previous Owner $164,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/17/2026 06/17/26 Rented $2,700 0.0% --
06/12/2026 06/12/26 For Rent $2,700 +50.0% --
06/17/2025 06/17/25 Rented $1,800 0.0% --
06/09/2025 06/09/25 For Rent $1,800 0.0% --
02/29/2024 02/29/24 Sold $429,000 0.0% $688 / Sq Ft View Prior Sale
12/03/2023 12/03/23 For Sale $429,000 +19.2% $688 / Sq Ft
06/25/2018 06/25/18 Sold $360,000 -12.2% $590 / Sq Ft View Prior Sale
05/26/2018 05/26/18 Pending -- -- --
05/15/2018 05/15/18 For Sale $410,000 +48.3% $672 / Sq Ft
11/29/2013 11/29/13 Sold $276,500 -9.3% $590 / Sq Ft View Prior Sale
10/30/2013 10/30/13 Pending -- -- --
06/25/2013 06/25/13 For Sale $305,000 -- $650 / Sq Ft
Source: HiCentral MLS (Honolulu Board of REALTORS®)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $1,223 $328,500 $29,100 $299,400
2025 $1,223 $349,500 $30,600 $318,900
2024 $1,341 $383,000 $32,100 $350,900
2023 $1,259 $359,800 $35,900 $323,900
2022 $504 $314,200 $35,900 $278,300
2021 $1,101 $314,600 $35,900 $278,700
2020 $1,130 $322,800 $33,600 $289,200
2019 $1,078 $308,000 $32,100 $275,900
2018 $990 $282,800 $31,400 $251,400
2017 $968 $276,700 $31,400 $245,300
2016 $923 $263,700 $30,600 $233,100
2015 $963 $275,000 $29,100 $245,900
2014 $300 $228,200 $27,600 $200,600
Source: Public Records

Agents Affiliated with this Home

  • M

    Landlord's Agent in 2026

    Miles Freeman

    Hawaii Sands Realty

    (808) 664-3084

    Miles Freeman
    Section Image
  • Eric Yamamoto

    Seller's Agent in 2025

    Eric Yamamoto

    BHGRE Refined

    (808) 348-1555

    6 in this area

    145 Total Sales

    Eric Yamamoto
    Section Image

  • J

    Seller's Agent in 2024

    Juniper Adler

    Drop - 2026

    Section Image
  • Jasper Cabiao

    Seller Co-Listing Agent in 2024

    Jasper Cabiao

    eXp Realty

    (808) 600-4998

    3 in this area

    11 Total Sales

    Jasper Cabiao
    Section Image

  • J

    Buyer's Agent in 2024

    Joshua Nelson

    Harcourts Island Real Estate

    (808) 282-5924

    1 in this area

    6 Total Sales

    Joshua Nelson
    Section Image

  • D

    Seller's Agent in 2018

    Darren Holbrook

    Formatic Property Mgmt., Inc.

    (808) 224-0344

    9 Total Sales

    Darren Holbrook
    Section Image
See All Agents

About Harbor Square

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202611421

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-2-1-016-015-0108

Hawaii Honolulu County Honolulu 96813 Downtown Honolulu

225 Queen St Unit 21, Honolulu, HI

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

HiCentral MLS (Honolulu Board of REALTORS®) Some of the active listings appearing on this site may be listed by other REALTORS(R). If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Copyright 2026 HiCentral MLS, Ltd

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.