NOT LISTED FOR SALE

Waikiki Skytower 2410 Cleghorn St Unit 2504 Honolulu, HI 96815

Waikiki Neighborhood

Estimated Value: $474,871 - $508,000

1 Bed
1 Bath
585 Sq Ft
$1,081/mo HOA Fee

Last Sold November 07, 2024

Last sale price $497,000 $850 Per Sq Ft

Current estimated payment $3,956/month

47 Days on Market

Highlights

  • Ocean View
  • 22,041 Sq Ft lot
  • Building Patio
  • Heated Pool
  • Sauna
  • Card or Code Access

About This Home

As of November 2024

Property Id: 1659806

Experience the vibrant heart of Waikiki from this fully furnished 1-bedroom apartment located in the highly sought-after Waikiki Skytower. With modern amenities, Ocean views, and a prime location.

Ideal for extended stays with a 30-night minimum requirement.
Bedroom: King-size bed with ample closet space, flatscreen TV.
Living Room: Comfortable sofa bed (sleeps 1-2), dining area for 4, and access to a private lanai.
Max Occupancy of 4.
Cook like a pro with a stove, oven, dishwasher, microwave, and full fridge/freezer.
Includes all the essentials: cookware, dishes, cutlery, juicer and a coffee maker with burr grinder for your morning brew.
Washer/Dryer in-unit for your convenience.
A/C for a cool and comfortable stay.
Heated Swimming Pool, Sauna, Sun Deck & BBQ Area,
Secure Entry with Elevators.

Pets 25lb max. 2 animal total max.

Experience the perfect blend of luxury and convenience in this prime location.

Last Agent to Sell the Property

Melissa Filek

Coldwell Banker Realty Brokerage Phone: (808) 791-2923 License #RB-24028 Listed on: 09/19/2024

Coldwell Banker Realty

Last Buyer's Agent

Cammie Fawcett

Compass License #RS-85543

Compass

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $1,714

Year Built

  • Built in 1978

Lot Details

  • 0.51

HOA Fees

  • $1,081 Monthly HOA Fees

Property Views

  • Ocean
  • Coastline

Interior Spaces

  • 585 Sq Ft Home
  • 1-Story Property
  • Ceramic Tile Flooring
  • Closed Circuit Camera

Bedrooms and Bathrooms

  • 1 Bedroom
  • Bathroom on Main Level
  • 1 Full Bathroom

Parking

  • 2 Car Garage
  • Assigned Parking

Additional Features

  • Heated Pool
  • Property is in excellent condition

Listing and Financial Details

  • Assessor Parcel Number 1-2-6-024-053-0077

Community Details

Overview

  • Association fees include common areas, cable TV, hot water, internet, sewer, water
  • Waikiki Skytower Condos
  • Waikiki Subdivision

Amenities

  • Building Patio
  • Community Barbecue Grill
  • Community Deck or Porch
  • Sauna
  • Trash Chute

Recreation

  • Community Pool

Pet Policy

  • Call for details about the types of pets allowed

Security

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

Property Details

Home Type

Condominium

Est. Annual Taxes

$1,714

Year Built

Built in 1978

Lot Details

0

HOA Fees

$1,081 per month

Listing Details

  • Architectural Style: High Rise
  • Building Name: Waikiki Skytower
  • Inclusions: AC Window Unit,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Kitchenware,Linens,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Year Built: 1978
  • Attribution Contact: (808) 791-2923
  • CommunityFeatures: Barbecue, Community Pool, Deck/Porch, Other, Patio, Pool, Sauna, Trash Chute
  • SecurityFeatures: Closed Circuit Camera(s), Elevator Secured, Key Card Entry
  • Association Amenities: Management
  • Pets Allowed: Call
  • MLS Status: Closed
  • Subdivision Name: WAIKIKI
  • Entry Level: 15
  • Interior Features: Bedroom on Main Level, Full Bath on Main Level
  • Unit Levels: One
  • Living Area: 585.0
  • New Construction: No
  • Tax Year: 2024
  • Special Features: None

Interior Features

  • Flooring: Ceramic Tile
  • Furnished: Furnished
  • Full Bathrooms: 1
  • Total Bedrooms: 1

Exterior Features

  • Construction Type: Concrete
  • Pool Features: Heated
  • Property Condition: Excellent, Good Condition, Updated/Remodeled
  • View: Coastline, City, Ocean, Sunset
  • View: Yes
  • Disclosures: Seller Disclosure

Garage/Parking

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

Condo/Co-op/Association

  • Association Fee: 1081.0

Fee Information

  • Association Fee Includes: Common Areas, Cable TV, Hot Water, Internet, Sewer, Water

Lot Info

  • Parcel Number: 1-2-6-024-053-0077
  • Zoning Description: X2 - Apartment Precinct

Multi Family

  • Maintenance Expense: 1081.0

Tax Info

  • Tax Annual Amount: 1713.96

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 19, 2024
Closed on
Oct 28, 2024
Sold by
Bartrim Aaron John and Bartrim Jacqueline
Bought by
Michael Angelo Supplemental Needs Trust and Fawcett
Seller's Agent
Melissa Filek
Coldwell Banker Realty
Buyer's Agent
Cammie Fawcett
Compass
List Price
$539,000
Sold Price
$497,000
Premium/Discount to List
-$42,000
-7.79%
Views
6
Current Estimated Value
$494,647

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$2,353
Avg. Annual Appreciation
-0.94%

Purchase Details

Listed on
Mar 3, 2023
Closed on
Mar 21, 2023
Sold by
Koerner Larry Paul and Koerner Lynne Anne
Bought by
Bartrim Aaron John and Bartrim Jacqueline
Seller's Agent
Jerry Adamany
Keller Williams Honolulu
Buyer's Agent
Hanah Kim
Real Broker, LLC
List Price
$489,000
Sold Price
$489,000
Views
141

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.01%

Purchase Details

Closed on
Jun 9, 2015
Sold by
Association Of Apartment Owners Of Waiki
Bought by
Koerner Larry Paul and Koerner Lynne Anne
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
Michael Angelo Supplemental Needs Trust -- Fam
Bartrim Aaron John -- Fidelity National Title
Koerner Larry Paul -- Tg
Koerner Larry Paul -- Tg
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/30/2024 11/30/24 Off Market $3,400 -- --
11/21/2024 11/21/24 For Rent $3,400 0.0% --
11/07/2024 11/07/24 Sold $497,000 -7.8% $850 / Sq Ft
11/05/2024 11/05/24 Pending -- -- --
09/19/2024 09/19/24 For Sale $539,000 +10.2% $921 / Sq Ft
03/29/2023 03/29/23 Off Market $489,000 -- --
03/28/2023 03/28/23 Sold $489,000 0.0% $836 / Sq Ft
03/20/2023 03/20/23 Pending -- -- --
03/03/2023 03/03/23 For Sale $489,000 +105.9% $836 / Sq Ft
04/18/2012 04/18/12 Sold $237,500 +5.6% $406 / Sq Ft
03/19/2012 03/19/12 Pending -- -- --
03/12/2012 03/12/12 For Sale $225,000 -- $385 / Sq Ft
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 $1,714 $487,100 $72,300 $414,800
2024 $1,714 $489,800 $72,300 $417,500
2023 $1,142 $466,200 $71,300 $394,900
2022 $1,351 $386,000 $69,300 $316,700
2021 $1,519 $434,000 $69,300 $364,700
2020 $1,637 $467,800 $65,300 $402,500
2019 $1,689 $482,700 $63,300 $419,400
2018 $1,605 $458,700 $62,400 $396,300
2017 $1,515 $432,800 $59,400 $373,400
2016 $1,469 $419,800 $54,400 $365,400
2015 $1,407 $401,900 $51,600 $350,300
2014 -- $383,200 $44,500 $338,700
Source: Public Records

Agents Affiliated with this Home

  • Melissa Filek

    Seller's Agent in 2024

    Melissa Filek

    Coldwell Banker Realty

    (808) 791-2923

    103 in this area

    146 Total Sales

    Section Image
  • Cammie Fawcett

    Buyer's Agent in 2024

    Cammie Fawcett

    Compass

    (808) 825-4277

    6 in this area

    20 Total Sales

    Section Image
  • Jerry Adamany

    Seller's Agent in 2023

    Jerry Adamany

    Keller Williams Honolulu

    (808) 208-5065

    18 in this area

    104 Total Sales

    Section Image

  • H

    Buyer's Agent in 2023

    Hanah Kim

    Real Broker, LLC

    (855) 450-0442

    14 in this area

    39 Total Sales

    Section Image

  • E

    Buyer Co-Listing Agent in 2023

    Erica Yoon

    Real Broker, LLC

    (808) 561-2673

    30 in this area

    170 Total Sales

    Section Image
  • Lisa Van Den Heuvel

    Seller's Agent in 2012

    Lisa Van Den Heuvel

    Coldwell Banker Realty

    (808) 381-4412

    3 in this area

    9 Total Sales

    Section Image
See All Agents

About Waikiki Skytower

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202421348

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-2-6-024-053-0077

Hawaii Honolulu County Honolulu 96815 Waikiki

2410 Cleghorn St Unit 2504, Honolulu, HI

This home is located at 2410 Cleghorn St Unit 2504, Honolulu, HI 96815 since 19 September 2024 and is currently estimated at $492,468, approximately $841 per square foot. This property was built in 1978. 2410 Cleghorn St Unit 2504 is a home located in Honolulu County with nearby schools including President Thomas Jefferson Elementary School, President George Washington Middle School, and Kaimuki 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