NOT LISTED FOR SALE

47-540 Hui Kelu St Kaneohe, HI 96744

Estimated Value: $1,656,000 - $1,826,530

4 Beds
3.5 Baths
2,594 Sq Ft
$680/Sq Ft Est. Value

Last Sold August 18, 2021

Last sale price $1,725,000 $665 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $9,680/month

12 Days on Market

Highlights

  • Ohana Dwelling
  • Maid or Guest Quarters
  • Main Floor Bedroom
  • Mountain View
  • Wood Flooring
  • Furnished

About This Home

As of August 2021

Your search for the perfect home ends here, where you will find this exquisite one of a kind, turnkey, fully furnished home, which was thoughtfully designed w/ carefully curated materials & finishes chosen by Philpotts Interiors & sits below the majestic Koolaus. Vaulted ceilings & expansive windows greet you as you enter the great room featuring a perfectly placed punee & Suar wood mantel. The kitchen is welcoming & encourages guests to take a seat & relax around the Esmerelda granite island. The attached office space features dual built in desks on either side of an additional punee, creating a flexible space for work or entertaining. The primary bdr. features customized teak cabinetry, a space for lounging & an elegant bathroom with walk in shower. Built in 2015, the addition includes elevated materials throughout, sweeping windows & a spa like bathroom w/skylight. The well thought out layout in the bdr. comes w/ a built-in marble desk & a walkout patio to enjoy the peekaboo sunrise views. Use the additional space as part of your floorplan or close the doors & turn it into an amazing vacation retreat for your visitors. An island sense of place, this home is a must see.

Last Agent to Sell the Property

Hillary Sibley

Windward Properties License #RB-20139 Listed on: 07/07/2021

Co-Listed By

Karen Riley

Keller Williams Honolulu License #RS-83826

Last Buyer's Agent

Rachel Barnette

REMAX Hawaii License #RB-22505

REMAX Hawaii

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,414

Year Built

  • Built in 1993 | Remodeled in 2020

Lot Details

  • 7,669 Sq Ft Lot
  • Landscaped
  • Level Lot
  • Cleared Lot
  • Property is in excellent condition

Property Views

  • Mountain
  • Garden

Home Design

  • Wood Frame Construction

Interior Spaces

  • 2,594 Sq Ft Home
  • 2-Story Property
  • Furnished
  • Ceiling Fan
  • Attic Fan

Kitchen

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

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Maid or Guest Quarters
  • Bathroom on Main Level

Laundry

  • Dryer
  • Washer

Home Security

  • Home Security System
  • Fire and Smoke Detector

Parking

  • 3 Car Garage
  • Automatic Garage Door Opener
  • Driveway
  • On-Street Parking

Schools

  • Ahuimanu Elementary School
  • King Middle School
  • Castle High School

Utilities

  • Underground Utilities
  • Water Heater
  • Sewer Tap Fee
  • Internet Available
  • Cable TV Available

Additional Features

  • Ohana Dwelling
  • Patio

Community Details

  • Community Storage Space

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,414

Year Built

Built in 1993 | Remodeled in 2020

Lot Details

0

Listing Details

  • Architectural Style: Detach Single Family, Multiple Dwellings, Ohana Dwelling
  • Inclusions: Attic Fan, Auto Garage Door Opener, Book Shelves, Ceiling Fan, Dishwasher, Disposal, Dryer, Microwave Hood, Range/Oven, Refrigerator, Security System, Smoke Detector, Washer, Water Heater
  • Property Sub Type: Single Family
  • Prop. Type: Single Family
  • Sq Ft RoofedLiving: 2594
  • Fill Sq Ft Total: 2975
  • Stories Type: Two
  • Year Built: 1993
  • Year Renovated: 2020
  • Special Features: None
  • Stories: 2

Interior Features

  • Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Maids/Guest Qrters, Patio/Deck, Storage
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Flooring: Ceramic Tile, Hardwood, Other
  • Furnished: Full

Exterior Features

  • Construction Type: Above Ground, Double Wall, Wood Frame
  • Easements: Drainage, Sewer
  • Flood Zone: Zone D
  • Lot Features: Clear
  • Pool Features: None
  • Property Condition: Excellent
  • Topography: Level
  • View: Garden, Mountain, Sunrise

Garage/Parking

  • Parking Features: 3 Car+, Driveway, Garage, Street
  • Total Parking Spaces: 4
  • Sq Ft GarageCarport: 400

Utilities

  • Utilities: Cable, Connected, Internet, Public Water, Sewer Fee, Underground Electricity, Water

Schools

  • Elementary School: Ahuimanu
  • High School: Castle
  • Middle Or Junior School: King

Tax Info

  • Tax Annual Amount: 3414.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2021
Closed on
Aug 2, 2021
Sold by
Ruiz Cole Jacob and Ruiz Cole Jacob
Bought by
Acevedo Cross Andres David and Acevedo Cross Justina
Seller's Agent
Hillary Sibley
Windward Properties
Buyer's Agent
Rachel Barnette
REMAX Hawaii
List Price
$1,725,000
Sold Price
$1,725,000
Current Estimated Value
$1,764,133

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$39,133
Avg. Annual Appreciation
0.54%
Original Mortgage
$1,080,000
Outstanding Balance
$982,055
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$782,079

Purchase Details

Closed on
May 16, 2008
Sold by
Younghanse Ramona Denise
Bought by
Ruiz Cole Jacob and Ruiz Holly Boling

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
5.88%
Mortgage Type
Unknown

Purchase Details

Closed on
Mar 21, 2007
Sold by
Younghanse John Max and Younghanse Ramona Denise
Bought by
Younghanse Ramona Denise

Purchase Details

Closed on
Jul 25, 2005
Sold by
Ching Rodney Kui Fong and Ching Dawn Marie
Bought by
Younghanse John Max and Younghanse Ramona Denise

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$648,000
Interest Rate
5.37%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Jul 19, 1994
Sold by
Ahuimanu Joint Venture
Bought by
Ching Rodney Kui Fong and Ching Dawn Marie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$470,000
Interest Rate
8.25%
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
Acevedo Cross Andres David $1,725,000 Or
Ruiz Cole Jacob $830,000 Pat
Younghanse Ramona Denise -- None Available
Younghanse John Max $810,000 Tg
Ching Rodney Kui Fong $480,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Acevedo Cross Andres David $1,080,000
Previous Owner Ruiz Cole Jacob $550,000
Previous Owner Younghanse John Max $648,000
Previous Owner Ching Rodney Kui Fong $470,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/18/2021 08/18/21 Sold $1,725,000 0.0% $665 / Sq Ft
07/19/2021 07/19/21 Pending -- -- --
07/07/2021 07/07/21 For Sale $1,725,000 -- $665 / 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 $4,813 $1,565,600 $950,300 $615,300
2024 $4,813 $1,495,000 $905,100 $589,900
2023 $4,783 $1,566,500 $859,800 $706,700
2022 $4,038 $1,253,700 $663,700 $590,000
2021 $3,556 $1,116,000 $663,700 $452,300
2020 $3,415 $1,075,600 $603,400 $472,200
2019 $3,252 $1,074,800 $626,000 $448,800
2018 $3,252 $1,009,000 $512,900 $496,100
2017 $3,209 $996,900 $505,300 $491,600
2016 $2,568 $813,800 $460,100 $353,700
2015 $2,575 $815,800 $452,500 $363,300
2014 -- $765,800 $452,500 $313,300
Source: Public Records

Agents Affiliated with this Home

  • Hillary Sibley

    Seller's Agent in 2021

    Hillary Sibley

    Windward Properties

    (808) 348-1086

    6 in this area

    13 Total Sales

    Hillary Sibley
    Section Image
  • Karen Riley

    Seller Co-Listing Agent in 2021

    Karen Riley

    Keller Williams Honolulu

    (808) 829-8290

    4 in this area

    18 Total Sales

    Karen Riley
    Section Image

  • R

    Buyer's Agent in 2021

    Rachel Barnette

    REMAX Hawaii

    (808) 224-5886

    10 in this area

    69 Total Sales

    Rachel Barnette
    Section Image
See All Agents

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202116691

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-4-7-056-102-0000

Hawaii Honolulu County Kaneohe 96744

47-540 Hui Kelu St, Kaneohe, HI

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