NOT LISTED FOR SALE

Keola La'i 600 Queen St Unit 2903 Honolulu, HI 96813

Downtown Honolulu Neighborhood

Estimated Value: $767,958 - $895,000

2 Beds
3 Baths
953 Sq Ft
$863/Sq Ft Est. Value

Highlights

  • Ocean View
  • Home Gym
  • 1-Story Property
  • Private Pool
  • Ceramic Tile Flooring
  • 3-minute walk to Mother Waldron Neighborhood Park

About This Home

As of July 2024

Enjoy living in this partially furnished, 2 bedroom, 2 bathroom, 2 pkg condo at Keola La’i in Honolulu. This unit is near schools, shopping ctrs, parks, and the beach. Beautiful mountain, ocean and city view.

See our website at www.cornerstonehawaii.com for more information.

AMENITIES:
Elevator
Pool
Hot Tub
Rec Area / Pavilion
Fitness Center
Car Wash Area
BBQ
24-Hr Security Guard
Secured Access

UTILITIES:
Included: Water/sewer
Tenant Responsibility: Electricity, cable, internet, phone, pest, & gas (if applicable).

LEASE TERMS:
No smoking
No pets
Professional cleaning required upon move out by an approved vendor of Cornerstone Properties (CSP)
Renter's insurance required: with $300,000 liability coverage and CSP listed as additionally insured
All adults 18+ must apply
App fee: $30 (Non-refundable)

Visit www.cornerstonehawaii.com to apply.
Email: info@cornerstonehawaii.com
CODE: 1258TAR
Cornerstone Properties, LLC: RB-20789

*DISCLAIMER: CSP is not responsible for any inaccuracies or misprints on this website or other subsequent websites and reserves the right to make changes without notice. Please call our office to inquire.

Last Agent to Rent the Property

Carl Frazier

Cornerstone Properties LLC License #RB-16043 Listed on: 06/13/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,775

Year Built

  • Built in 2008

Lot Details

  • 2.69

Property Views

  • Ocean
  • Mountain

Interior Spaces

  • 953 Sq Ft Home
  • 1-Story Property
  • Partially Furnished
  • Ceiling Fan
  • Blinds
  • Home Gym
  • Fire and Smoke Detector

Kitchen

  • Oven or Range
  • Range Hood
  • Built-In Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Garage
  • Assigned Parking

Outdoor Features

  • Private Pool
  • Outdoor Grill

Additional Features

  • Property is in excellent condition
  • Central Air

Community Details

  • High-Rise Condominium

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,775

Year Built

Built in 2008

Lot Details

0

Listing Details

  • Architectural Style: High-Rise 7+ Stories
  • Building Name: Keola Lai
  • Prop. Type: Rental
  • Sq Ft RoofedLiving: 953
  • Fill Sq Ft Total: 953
  • Stories Type: One
  • Year Built: 2008
  • Attribution Contact: (808) 484-1211
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Amenities: BBQ, Exercise Room, Other, Pool on Property, Recreation Area
  • Full Bathrooms: 3
  • Total Bedrooms: 2
  • Flooring: Ceramic Tile, W/W Carpet
  • Furnished: Partial
  • Unit Features: Blinds, Ceiling Fan, Central AC, Dishwasher, Disposal, Dryer, Microwave Hood, Microwave, Odd# Unit, Range Hood, Range/Oven, Refrigerator, Smoke Detector, Washer

Exterior Features

  • Flood Zone: Zone X
  • Property Condition: Excellent
  • View: City, Mountain, Ocean

Garage/Parking

  • Parking Features: Assigned, Covered - 2, Garage
  • Total Parking Spaces: 2

Utilities

  • Utilities: Sewer, Water

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 12, 2009
Sold by
Dang Ryan Keola and Lee Christina You Joo
Bought by
Tarape Michael Paul Lazo and Tarape Corazon Lazo
Current Estimated Value
$821,990

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$559,675
Interest Rate
5.17%
Mortgage Type
FHA

Purchase Details

Closed on
Mar 4, 2008
Sold by
A & B Kakaako Llc
Bought by
Dang Ryan Keola and Lee Christina You Joo

Home Financials for this Owner

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

Range of Values:

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
Tarape Michael Paul Lazo $570,000 Fntic
Dang Ryan Keola $510,000 Tg
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tarape Michael Paul Lazo $175,000
Open Tarape Michael Paul Lazo $548,184
Closed Tarape Michael Paul Lazo $559,675
Previous Owner Dang Ryan Keola $408,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/10/2024 07/10/24 Rented $3,300 0.0% --
06/13/2024 06/13/24 For Rent $3,300 +3.1% --
07/16/2022 07/16/22 Off Market $3,200 -- --
07/15/2022 07/15/22 Rented $3,200 0.0% --
07/12/2022 07/12/22 For Rent $3,200 +8.5% --
06/08/2021 06/08/21 Rented $2,950 0.0% --
06/08/2021 06/08/21 For Rent $2,950 -- --
Source: HiCentral MLS (Honolulu Board of REALTORS®)

Tax History Compared to Growth

Source: Public Records

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 $2,775 $787,500 $84,000 $703,500
2024 $2,775 $792,800 $80,300 $712,500
2023 $2,917 $833,400 $80,300 $753,100
2022 $2,609 $745,500 $77,900 $667,600
2021 $2,480 $708,700 $74,200 $634,500
2020 $2,077 $733,500 $73,000 $660,500
2019 $2,184 $744,000 $73,000 $671,000
2018 $2,447 $699,000 $50,000 $649,000
2017 $2,485 $710,100 $50,000 $660,100
2016 $2,520 $719,900 $43,500 $676,400
2015 $2,318 $662,300 $41,000 $621,300
2014 $2,080 $643,600 $39,700 $603,900
Source: Public Records

Agents Affiliated with this Home

  • C

    Landlord's Agent in 2024

    Carl Frazier

    Cornerstone Properties LLC

    (808) 375-1211

    Section Image
See All Agents

About Keola La'i

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202414197

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-2-1-048-008-0236

Hawaii Honolulu County Honolulu 96813 Downtown Honolulu

600 Queen St Unit 2903, Honolulu, HI

This home is located at 600 Queen St Unit 2903, Honolulu, HI 96813 since 13 June 2024 and is currently priced at $821,990. This property was built in 2008. 600 Queen St Unit 2903 is a home located in Honolulu County with nearby schools including Royal Elementary School, Princess Ruth Ke'elikolani Middle School, and President William McKinley High School.

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 2025 HiCentral MLS, Ltd

Nearby Homes