Harbor Square 225 Queen St Unit 9G Honolulu, HI 96813
Downtown Honolulu Neighborhood
2
Beds
2
Baths
624
Sq Ft
$1,167/mo
HOA Fee
Highlights
- City View
- End Unit
- Building Patio
- 67,910 Sq Ft lot
- Community Pool
- 3-minute walk to Walker Park
About This Home
As of October 2024Be a part of the downtown renaissance! Welcome to Harbor Square, your urban oasis in downtown Honolulu. This beautifully renovated and fully furnished 2/2 corner end unit is truly turnkey. Every part of the unit was touched during the 2022 renovation, from the smooth ceilings to the luxury vinyl plank flooring, all new modern light fixtures, and new central AC and electric panel. Other features include an open kitchen with eat in counter, all new cabinetry, Samsung appliances and TV, closet organizers, and adjustable beds in both bedrooms. Floor to ceiling windows bathe the unit in natural light, and you can enjoy the cityscape and harbor view from the spacious lanai. A storage locker just down the hall is included for your convenience. Building amenities include a pool, barbecue area, community laundry on premises, and 24 hour security. HOA fee covers ALL utilities including cable and internet. With everything you need within walking distance, this prime location offers the perfect blend of work, play, and relaxation. For those that need it, on-site parking is available for rent. Don't miss the opportunity to own this stunning condo in Honolulu--an incredible value!
Last Agent to Sell the Property
Coldwell Banker Realty Brokerage Phone: (808) 738-3904 License #RB-24527 Listed on: 08/28/2024
Property Details
Home Type
- Condominium
Est. Annual Taxes
- $2,728
Year Built
- Built in 1971
Lot Details
- End Unit
- Property is in excellent condition
HOA Fees
- $1,167 Monthly HOA Fees
Interior Spaces
- 624 Sq Ft Home
- 1-Story Property
- Storage
- Vinyl Flooring
- Closed Circuit Camera
Bedrooms and Bathrooms
- 2 Bedrooms
- 2 Full Bathrooms
Schools
- Royal Elementary School
- Keelikolani Middle School
- Mckinley High School
Utilities
- Central Air
Listing and Financial Details
- Assessor Parcel Number 1-2-1-016-015-0023
Community Details
Overview
- Association fees include common areas, cable TV, electricity, HVAC, hot water, internet, sewer, water
- Harbor Square Condos
- Downtown Subdivision
Amenities
- Building Patio
- Community Barbecue Grill
- Community Deck or Porch
- Trash Chute
- Laundry Facilities
- Community Storage Space
Recreation
- Community Pool
- Recreational Area
Security
- Security Guard
- Resident Manager or Management On Site
- Card or Code Access
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 28, 2024
Closed on
Oct 18, 2024
Sold by
Aaron J Ramirez Revocable Trust and Ramirez Aaron J
Bought by
Smith Michael Richard
Seller's Agent
Laurie Chang Murphy
Coldwell Banker Realty
Buyer's Agent
Elisha Wallace-Enos
Keller Williams Honolulu
List Price
$457,500
Sold Price
$450,000
Premium/Discount to List
-$7,500
-1.64%
Views
27
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$13,470
Avg. Annual Appreciation
-3.55%
Original Mortgage
$459,675
Outstanding Balance
$455,629
Interest Rate
6.2%
Mortgage Type
VA
Estimated Equity
-$19,099
Purchase Details
Listed on
Jan 27, 2022
Closed on
May 19, 2022
Sold by
Quon Kim Dennis Sau
Bought by
Aaron J Ramirez Revocable Trust
Seller's Agent
Melanie Mitsunaga
Coldwell Banker Realty
Buyer's Agent
Laurie Chang Murphy
Coldwell Banker Realty
List Price
$415,000
Sold Price
$400,000
Premium/Discount to List
-$15,000
-3.61%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.03%
Original Mortgage
$295,000
Interest Rate
4.4%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 12, 2005
Sold by
Association Of Apartment Owners Of Harbo
Bought by
Kim Dennis Sau Quon and Shaw Kim Ardis
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$120,000
Interest Rate
6.35%
Mortgage Type
Fannie Mae Freddie Mac
Similar Homes in Honolulu, HI
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | -- | Fidelity National Title | |
| Deed | -- | Fidelity National Title | |
| Deed | -- | Fidelity National Title | |
| Deed | -- | Fidelity National Title | |
| Deed | -- | Fidelity National Title | |
| Deed | -- | Fidelity National Title | |
| Limited Warranty Deed | $59,866 | Tg |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $459,675 | VA | |
| Closed | $459,675 | VA | |
| Previous Owner | $295,000 | New Conventional | |
| Previous Owner | $295,000 | No Value Available | |
| Previous Owner | $120,000 | Fannie Mae Freddie Mac |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 10/23/2024 10/23/24 | Sold | $450,000 | -1.6% | $721 / Sq Ft |
| 08/28/2024 08/28/24 | For Sale | $457,500 | +14.4% | $733 / Sq Ft |
| 06/01/2022 06/01/22 | Off Market | $400,000 | -- | -- |
| 05/31/2022 05/31/22 | Sold | $400,000 | -3.6% | $641 / Sq Ft |
| 04/11/2022 04/11/22 | Pending | -- | -- | -- |
| 03/31/2022 03/31/22 | For Sale | $415,000 | 0.0% | $665 / Sq Ft |
| 02/28/2022 02/28/22 | Pending | -- | -- | -- |
| 01/27/2022 01/27/22 | For Sale | $415,000 | -- | $665 / Sq Ft |
Source: HiCentral MLS (Honolulu Board of REALTORS®)
Tax History Compared to Growth
Tax History
| 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 |
|---|---|---|---|---|
| 2025 | $1,110 | $415,700 | $39,800 | $375,900 |
| 2024 | $1,110 | $437,000 | $41,800 | $395,200 |
| 2023 | $816 | $433,100 | $46,600 | $386,500 |
| 2022 | $1,248 | $356,700 | $46,600 | $310,100 |
| 2021 | $1,110 | $317,200 | $46,600 | $270,600 |
| 2020 | $1,158 | $330,900 | $43,700 | $287,200 |
| 2019 | $1,103 | $332,100 | $41,800 | $290,300 |
| 2018 | $1,103 | $315,100 | $40,800 | $274,300 |
| 2017 | $1,033 | $295,200 | $40,800 | $254,400 |
| 2016 | $1,021 | $291,800 | $39,800 | $252,000 |
| 2015 | $964 | $275,300 | $37,900 | $237,400 |
| 2014 | $821 | $254,400 | $35,900 | $218,500 |
Source: Public Records
Agents Affiliated with this Home
-
Laurie Chang Murphy
L
Seller's Agent in 2024
Laurie Chang Murphy
Coldwell Banker Realty
(808) 738-3904
6 in this area
41 Total Sales
-
Elisha Wallace-Enos
E
Buyer's Agent in 2024
Elisha Wallace-Enos
Keller Williams Honolulu
(808) 596-2888
1 in this area
34 Total Sales
-
Melanie Mitsunaga
M
Seller's Agent in 2022
Melanie Mitsunaga
Coldwell Banker Realty
(808) 676-7200
1 in this area
15 Total Sales
About Harbor Square
Map
Source: HiCentral MLS (Honolulu Board of REALTORS®)
MLS Number: 202418801
APN: 1-2-1-016-015-0023
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.
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 2025 HiCentral MLS, Ltd
Nearby Homes
- 700 Richards St Unit 1602
- 700 Richards St Unit 1709
- 225 Queen St Unit 14A
- 700 Richards St Unit 2101
- 700 Richards St Unit 807
- 225 Queen St Unit 8C
- 700 Richards St Unit 2403
- 225 Queen St Unit 22E
- 700 Richards St Unit 2203
- 66 Queen St Unit 1704
- 66 Queen St Unit 2802
- 66 Queen St Unit 2904
- 66 Queen St Unit 2501
- 66 Queen St Unit 1903
- 66 Queen St Unit 2103
- 1088 Bishop St Unit 1812
- 1088 Bishop St Unit 1607
- 1088 Bishop St Unit 1124
- 1088 Bishop St Unit 3711
- 1088 Bishop St Unit 3011