T
Seller's Agent in 2023
Tracy Allen
Coldwell Banker Realty
(808) 927-6415
10 in this area
163 Total Sales
3919 Noela Place Honolulu, HI 96815
Diamond Head-Kapahula-Saint Louis NeighborhoodEstimated Value: $8,555,151 - $9,179,000
5
Beds
7.5
Baths
8,709
Sq Ft
$1,005/Sq Ft
Est. Value
Highlights
- Ocean View
- In Ground Pool
- Maid or Guest Quarters
- Waikiki Elementary School Rated A-
- 19,832 Sq Ft lot
- Marble Flooring
About This Home
As of September 2023Villa Leahi, an architecturally designed estate nestled amidst the backdrop of iconic Diamond HD, is situated on an oversized 19,832 sf lot w/in one of Honolulu’s most coveted neighborhoods. Sprawling 5 BD HM offers generous living spaces of 8,000+ sf + lanais/sundecks ideal for HI’s indoor/outdoor lifestyle. The Great Rm, w/dramatic archways & grand custom doors is the hub of the HM w/fireplace, wetbar & hm theater component w/floating screen & surround sound. Sizable dining area w/dramatic lighting & display shelving is ideal for large gatherings. Kitchen w/prof appliances, gas range, dual sinks, central island + sit down counter seating & walk in pantry is a dream! Primary Bdrm Suite, offers the ultimate luxury & connects to a roof top deck w/ stunning views. Dual baths w/ beautiful sleek white marble, walk in standard & steam showers + soaking tub, all provide for a luxurious spa like experience. Generous secondary bdrm suites are complete w/ lovely baths, walk in closets & study areas. HM gym w/adjacent full bath overlooks the pool/spa deck, outdoor lounge spaces, fire pit & BBQ trellis. Expansive grounds w/ flowering trees & garden areas complete this striking private HM.
Last Agent to Sell the Property
Coldwell Banker Realty License #RS-46610 Listed on: 12/23/2022
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $26,361
Year Built
- Built in 1979 | Remodeled in 2022
Lot Details
- 0.46 Acre Lot
- Fenced
- Landscaped
- Terraced Lot
- Cleared Lot
- Property is in excellent condition
Property Views
- Ocean
- City
- Mountain
- Diamond Head
- Garden
Home Design
- Slab Foundation
- Wood Frame Construction
- Masonry
Interior Spaces
- 8,709 Sq Ft Home
- 3-Story Property
- Ceiling Fan
- Chandelier
- Fireplace
- Drapes & Rods
- Blinds
Kitchen
- Convection Oven
- Range Hood
- Microwave
- Dishwasher
- Wine Refrigerator
- Disposal
Flooring
- Wood
- Marble
- Ceramic Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Main Floor Bedroom
- Maid or Guest Quarters
- Bathroom on Main Level
Laundry
- Dryer
- Washer
Home Security
- Home Security System
- Intercom
- Fire and Smoke Detector
Parking
- 2 Car Garage
- Automatic Garage Door Opener
- Driveway
- On-Street Parking
Pool
- In Ground Pool
- Pool Tile
Outdoor Features
- Outdoor Gas Grill
Schools
- Waikiki Elementary School
- Washington Middle School
- Kaimuki High School
Utilities
- Central Air
- Mini Split Air Conditioners
- Underground Utilities
- Gas Available
- Private Water Source
- Water Heater
- Sewer Tap Fee
- Internet Available
- Phone Available
- Cable TV Available
Community Details
- Community Storage Space
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Dec 23, 2022
Closed on
Aug 24, 2023
Sold by
Johanna R K Geicke Revocable Living Trus
Bought by
Central Pacific Land Llc
Seller's Agent
Tracy Allen
Coldwell Banker Realty
Buyer's Agent
Sandra Mann-Hawkins
Honolulu Property Advisors LLC
List Price
$8,985,000
Sold Price
$8,700,000
Premium/Discount to List
-$285,000
-3.17%
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
$121,381
Avg. Annual Appreciation
-0.28%
Purchase Details
Listed on
Nov 18, 2019
Closed on
Nov 18, 2020
Sold by
Oyster Jeffery A and Jeffery A Oyster Revocable Tru
Bought by
Geicke Johanna R K and Geicke Johanna R
Seller's Agent
Tracy Allen
Coldwell Banker Realty
Buyer's Agent
Tracy Allen
Coldwell Banker Realty
List Price
$5,995,000
Sold Price
$5,895,000
Premium/Discount to List
-$100,000
-1.67%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
15.09%
Purchase Details
Closed on
Jun 29, 2007
Sold by
Hirschhorn Karl W and Hirschhorn Erin F
Bought by
Oyster Jeffery A and Jeffery A Oyster Revocable Trust
Purchase Details
Closed on
May 15, 2007
Sold by
Hirschhorn Karl W and Hirschhorn Erin F
Bought by
Oyster Jeffery A and Jeffery A Oyster Revocable Trust
Purchase Details
Closed on
Apr 7, 2006
Sold by
Nicholson Thomas Q
Bought by
Hirschhorn Karl W and Hirschhorn Erin F
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
6.1%
Mortgage Type
Fannie Mae Freddie Mac
Purchase Details
Closed on
Dec 3, 2004
Sold by
Salirathvibhaga Pirapan
Bought by
Nicholson Thomas Q
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$3,060,000
Interest Rate
5.76%
Mortgage Type
Construction
Purchase Details
Closed on
Feb 18, 1997
Sold by
Bradley Richard John and Bradley Monene Price
Bought by
Salirathavibhaga Pirapan
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Central Pacific Land Llc | -- | Tge | |
| Geicke Johanna R K | $5,895,000 | Tg | |
| Geicke Johanna R K | $5,895,000 | Tg | |
| Oyster Jeffery A | -- | Tg | |
| Oyster Jeffery A | $5,030,000 | Tg | |
| Hirschhorn Karl W | $5,200,000 | Tg | |
| Nicholson Thomas Q | $2,700,000 | -- | |
| Salirathavibhaga Pirapan | $2,900,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Hirschhorn Karl W | $1,000,000 | |
| Previous Owner | Nicholson Thomas Q | $3,060,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 09/02/2023 09/02/23 | Off Market | $8,700,000 | -- | -- |
| 09/01/2023 09/01/23 | Sold | $8,700,000 | -3.2% | $999 / Sq Ft |
| 08/19/2023 08/19/23 | Pending | -- | -- | -- |
| 12/23/2022 12/23/22 | For Sale | $8,985,000 | +52.4% | $1,032 / Sq Ft |
| 11/24/2020 11/24/20 | Sold | $5,895,000 | -1.7% | $677 / Sq Ft |
| 10/25/2020 10/25/20 | Pending | -- | -- | -- |
| 11/18/2019 11/18/19 | For Sale | $5,995,000 | -- | $688 / 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 | $75,202 | $8,258,500 | $3,579,800 | $4,678,700 |
| 2024 | $75,202 | $7,245,800 | $3,624,600 | $3,621,200 |
| 2023 | $24,340 | $7,154,200 | $3,490,300 | $3,663,900 |
| 2022 | $26,361 | $7,631,600 | $3,087,600 | $4,544,000 |
| 2021 | $17,777 | $5,179,100 | $2,496,900 | $2,682,200 |
| 2020 | $17,680 | $5,151,500 | $2,550,600 | $2,600,900 |
| 2019 | $16,272 | $4,933,300 | $2,617,800 | $2,315,500 |
| 2018 | $16,272 | $4,729,000 | $2,410,400 | $2,318,600 |
| 2017 | $16,042 | $4,663,300 | $2,696,800 | $1,966,500 |
| 2016 | $16,234 | $4,718,400 | $2,911,600 | $1,806,800 |
| 2015 | $18,571 | $5,386,000 | $2,851,900 | $2,534,100 |
| 2014 | $15,265 | $5,931,200 | $4,191,300 | $1,739,900 |
Source: Public Records
Agents Affiliated with this Home
-
-
S
Buyer's Agent in 2023
Sandra Mann-Hawkins
Honolulu Property Advisors LLC
(808) 222-6266
1 in this area
21 Total Sales
Map
Source: HiCentral MLS (Honolulu Board of REALTORS®)
MLS Number: 202225821
APN: 1-3-1-029-022-0000
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
- 3124 Noela Dr
- 3824 Leahi Ave Unit 215
- 3061 Pualei Cir Unit 105
- 3027 Pualei Cir Unit 208
- 3027 Pualei Cir Unit 106
- 3071 Pualei Cir Unit 201
- 3030 Pualei Cir Unit 101
- 3030 Pualei Cir Unit 311
- 3006 Pualei Cir Unit A102
- 3731 Kanaina Ave Unit 240
- 3721 Kanaina Ave Unit 201
- 3002 Diamond Head Rd
- 2877 Kalakaua Ave Unit 804
- 2877 Kalakaua Ave Unit 801/802
- 2877 Kalakaua Ave Unit 306
- 2877 Kalakaua Ave Unit 305
- 2877 Kalakaua Ave Unit 1105
- 2877 Kalakaua Ave Unit 805
- 2957 Kalakaua Ave Unit 415
- 2957 Kalakaua Ave Unit 306