NOT LISTED FOR SALE

Ko'olani 1177 Queen St Unit 4202 Honolulu, HI 96814

Kakaako Neighborhood

Estimated Value: $1,638,432 - $1,819,000

3 Beds
2 Baths
1,527 Sq Ft
$1,396/ mo HOA Fee

Last Sold June 27, 2014

Last sale price $1,585,000 $1,038 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $10,756/month

201 Days on Market

Highlights

  • Ocean View
  • Clubhouse
  • Community Pool
  • Fitness Center
  • Marble Flooring
  • 1-minute walk to Kolowalu Park

About This Home

As of June 2014

High floor, most desirable "02" unit with spacious and functional floor plan. Enjoy breathtaking ocean and sunset views from your own private lanai. New paint and newer carpet, so this unit sparkles! World class amenities for replenishment and peace; a secluded retreat in the urban heart of Honolulu at the meeting point of Ala Moana & Ward complexes. Come experience the Renaissance!

Last Agent to Sell the Property

Michael Koyama

Locations LLC License #RB-14499 Listed on: 11/08/2013

Last Buyer's Agent

BJ Allen

DROP - 2015 License #RB-17694

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $3,888

Year Built

  • Built in 2006

Lot Details

  • Property is in excellent condition

HOA Fees

  • $1,396 Monthly HOA Fees

Property Views

  • Mountain

Home Design

  • Entry on the 42nd floor

Interior Spaces

  • 1,527 Sq Ft Home
  • 1-Story Property
  • Closed Circuit Camera

Flooring

  • Carpet
  • Marble

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Parking

  • 2 Car Garage
  • Secured Garage or Parking
  • Guest Parking
  • Assigned Parking

Schools

  • Kaahumanu Elementary School
  • Keelikolani Middle School
  • Mckinley High School

Listing and Financial Details

  • Assessor Parcel Number 1-2-3-006-014-0325

Community Details

Overview

  • Association fees include cable TV, gas, HVAC, water
  • High-Rise Condominium
  • Koolani Condos
  • Kakaako Subdivision

Amenities

  • Building Patio
  • Community Barbecue Grill
  • Community Deck or Porch
  • Trash Chute
  • Meeting Room
  • Community Storage Space

Recreation

  • Putting Green
  • Recreational Area

Pet Policy

  • Call for details about the types of pets allowed

Security

  • Security Guard
  • Resident Manager or Management On Site
  • Card or Code Access
  • Secure Elevator

Property Details

Home Type

Condominium

Est. Annual Taxes

$3,888

Year Built

Built in 2006

Lot Details

3.54 Acres

HOA Fees

$1,396 per month

Listing Details

  • Architectural Style: High Rise
  • Building Name: Koolani
  • Inclusions: AC Central,Blinds,Cable TV,Chandelier,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Year Built: 2006
  • CommunityFeatures: Barbecue, Clubhouse, Conference/Meeting Room, Deck/Porch, Fitness, Patio, Pool, Putting Green, Recreation Area, Storage Facilities, Tennis Court(s), Trash Chute
  • SecurityFeatures: Closed Circuit Camera(s), Elevator Secured, Key Card Entry, Security Guard
  • Association Amenities: Management
  • Pets Allowed: Call
  • MLS Status: Closed
  • Subdivision Name: KAKAAKO
  • Entry Level: 42
  • Unit Levels: One
  • Living Area: 1527.0
  • New Construction: No
  • Tax Year: 2013
  • Special Features: None

Interior Features

  • Flooring: Carpet, Marble
  • Full Bathrooms: 2
  • Total Bedrooms: 3

Exterior Features

  • Construction Type: Double Wall, Concrete
  • Property Condition: Excellent
  • View: Coastline, Mountain(s), Ocean, Sunset
  • View: Yes
  • Disclosures: Seller Disclosure

Garage/Parking

  • Parking Features: Assigned, Covered, Garage, Guest, Two Spaces, Secured
  • Total Parking Spaces: 2.0
  • Attached Garage: Yes

Condo/Co-op/Association

  • Association Fee: 1396.0

Fee Information

  • Association Fee Includes: Cable TV, Gas, HVAC, Water

Schools

  • Elementary School: Kaahumanu
  • High School: Mckinley
  • Middle Or Junior School: Keelikolani

Lot Info

  • Parcel Number: 1-2-3-006-014-0325
  • Zoning Description: 07 - R-3.5 Residential District

Multi Family

  • Maintenance Expense: 1396.0

Tax Info

  • Tax Annual Amount: 3888.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 8, 2013
Closed on
Jun 20, 2014
Sold by
Merner Cheryl A
Bought by
Okawa Grant Tetsuo and Lee Okawa Susan Huaming
Seller's Agent
Michael Koyama
Locations LLC
Buyer's Agent
BJ Allen
DROP - 2015
List Price
$1,650,000
Sold Price
$1,585,000
Premium/Discount to List
-$65,000
-3.94%
Current Estimated Value
$1,707,608

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$122,608
Avg. Annual Appreciation
0.64%
Original Mortgage
$158,500
Outstanding Balance
$120,412
Interest Rate
4.09%
Mortgage Type
Credit Line Revolving
Estimated Equity
$1,587,196

Purchase Details

Closed on
Aug 28, 2009
Sold by
Merner Marcus Scott and Merner Cheryl Ann
Bought by
Merner Cheryl A and Cheryl A Merner Trust

Purchase Details

Closed on
Feb 15, 2008
Sold by
Takata Richard Thomas and Takata Wanda Kay
Bought by
Merner Marcus Scott and Merner Cheryl Ann

Purchase Details

Closed on
Aug 25, 2006
Sold by
Tran Tam and Tran Tracy
Bought by
Takata Richard Thomas and Takata Wanda Kay

Purchase Details

Closed on
Apr 12, 2006
Sold by
Sunset Heights Hawaii Llc
Bought by
Tran Tam and Tran Tracy

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$952,000
Interest Rate
6.3%
Mortgage Type
Fannie Mae Freddie Mac
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

Date Buyer Sale Price Title Company
Okawa Grant Tetsuo $1,585,000 Fam
Okawa Grant Tetsuo $1,585,000 Fam
Merner Cheryl A -- None Available
Merner Marcus Scott $1,625,000 Itc
Takata Richard Thomas $1,300,000 Pat
Tran Tam $1,190,000 First American Title Co Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Okawa Grant Tetsuo $158,500
Closed Okawa Grant Tetsuo $158,500
Open Okawa Grant Tetsuo $1,188,750
Closed Okawa Grant Tetsuo $1,188,750
Previous Owner Tran Tam $952,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/27/2014 06/27/14 Sold $1,585,000 -3.9% $1,038 / Sq Ft
05/28/2014 05/28/14 Pending -- -- --
11/08/2013 11/08/13 For Sale $1,650,000 -- $1,081 / Sq Ft
Source: HiCentral MLS (Honolulu Board of REALTORS®)

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 $5,698 $1,812,100 $85,100 $1,727,000
2024 $5,698 $1,788,100 $85,100 $1,703,000
2023 $5,263 $1,743,600 $85,100 $1,658,500
2022 $5,079 $1,551,000 $76,400 $1,474,600
2021 $4,815 $1,475,800 $76,400 $1,399,400
2020 $4,957 $1,516,300 $72,900 $1,443,400
2019 $4,961 $1,497,300 $97,700 $1,399,600
2018 $4,886 $1,476,000 $86,600 $1,389,400
2017 $5,111 $1,540,400 $86,600 $1,453,800
2016 $4,873 $1,472,400 $75,500 $1,396,900
2015 $4,612 $1,397,700 $71,000 $1,326,700
2014 $3,709 $1,375,200 $68,800 $1,306,400
Source: Public Records

Agents Affiliated with this Home

  • Michael Koyama

    Seller's Agent in 2014

    Michael Koyama

    Locations LLC

    (808) 306-3649

    1 in this area

    20 Total Sales

    Michael Koyama
    Section Image

  • B

    Buyer's Agent in 2014

    BJ Allen

    DROP - 2015

    Section Image
See All Agents

About Ko'olani

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 201335235

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-2-3-006-014-0325

Hawaii Honolulu County Honolulu 96814 Kakaako

1177 Queen St Unit 4202, Honolulu, HI

Not Listed for Sale

Condos

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.