NOT LISTED FOR SALE

417 Keolu Dr Kailua, HI 96734

Estimated Value: $1,809,000 - $2,100,000

4 Beds
3.5 Baths
2,316 Sq Ft
$831/Sq Ft Est. Value

Last Sold May 19, 2023

Last sale price $1,800,000 $777 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $11,157/month

116 Days on Market

Highlights

  • Ocean View
  • Parking available for a boat
  • Property is adjacent to nature preserve
  • Ka'elepulu Elementary School Rated A-
  • Maid or Guest Quarters
  • Wood Flooring

About This Home

As of May 2023

Reduced Price by $25K! ! First Open House 10/16/22, - 2 to 5 PM. VA ASSUMABLE LOAN AT 2.25% INT. Gorgeous "Kailua Lakeview Villa" custom-built newer house in prestigious neighborhood. Permitted Rec Room/wet-bar with separate entrance. Make it a Studio, Guest Quarters or mother-in-law unit, New split A/C's in ea. room. Professionally landscaped, gated private yard, new Stainless Steel cable fencing for increased airflow & expansive views. Large side yard, ideal for your boat, Jet ski, etc. Spacious backyard with lush vegetation & lawn area, includes custom storage shed. Ideal for entertaining, open floor concept from living room/kitchen area to the private back yard and covered lanai. Master bedroom & upstairs bedroom ea. have their own private balcony with spectacular views of Enchanted Lake, the canal, bird sanctuary, the mountains and beyond. Enjoy the coastal breeze and breathtaking views as you sip your morning coffee. Bonus: "Owned 32 Photovoltaic panels" & Solar water heater for energy conservation and huge electric bill savings. Includes EV charger! Oversized driveway 4+ vehicles. Click on "movie reel" to view spectacular Aerial Video Tour. No overhead utility lines!

Last Agent to Sell the Property

Gloria Almendares

Realty By The Sea License #RB-20405 Listed on: 08/05/2022

Last Buyer's Agent

Debra Addessi

Drop - 2024 License #RS-78010

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,792

Year Built

  • Built in 2001 | Remodeled in 2021

Lot Details

  • 5,835 Sq Ft Lot
  • Home fronts a stream
  • Property is adjacent to nature preserve
  • Fenced
  • Landscaped
  • Level Lot
  • Cleared Lot
  • Property is in excellent condition

Property Views

  • Ocean
  • Marina
  • Mountain
  • Garden

Home Design

  • Cottage
  • Steel Frame
  • Masonry

Interior Spaces

  • 2,316 Sq Ft Home
  • 2-Story Property
  • Partially Furnished
  • Ceiling Fan
  • Blinds
  • Fire and Smoke Detector

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

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

Laundry

  • Dryer
  • Washer

Parking

  • 3 Parking Spaces
  • Driveway
  • On-Street Parking
  • Parking available for a boat

Eco-Friendly Details

  • Solar owned by seller
  • Solar Heating System

Outdoor Features

  • Patio

Schools

  • Kaelepulu Elementary School
  • Kailua Middle School
  • Kailua High School

Utilities

  • Mini Split Air Conditioners
  • Underground Utilities
  • Sewer Tap Fee
  • Internet Available
  • Phone Available
  • Cable TV Available

Community Details

  • Community Storage Space

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,792

Year Built

Built in 2001 | Remodeled in 2021

Lot Details

0

Listing Details

  • Architectural Style: Detach Single Family, Studio Cottage
  • Inclusions: AC Split, Blinds, Cable TV, Ceiling Fan, Dishwasher, Disposal, Dryer, Microwave, Photovoltaic - Owned, Range/Oven, Refrigerator, Smoke Detector, Solar Heater, Washer
  • PropertyFrontage: Preservation, Stream/Canal, Waterfront
  • Property Sub Type: Single Family
  • Prop. Type: Single Family
  • Sq Ft RoofedLiving: 2316
  • Fill Sq Ft Total: 2680
  • Stories Type: Two
  • Year Built: 2001
  • Year Renovated: 2021
  • Attribution Contact: (808) 292-6019
  • Special Features: None
  • Stories: 2

Interior Features

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

Exterior Features

  • Construction Type: Double Wall, Masonry/Stucco, Steel Frame
  • Easements: None
  • Flood Zone: Zone X
  • Lot Features: Clear
  • Pool Features: None
  • Property Condition: Excellent
  • Topography: Level
  • View: Garden, Marina/Canal, Mountain, Ocean, Sunrise

Garage/Parking

  • Parking Features: 3 Car+, Boat, Driveway, Street
  • Total Parking Spaces: 4

Utilities

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

Association/Amenities

  • AssociationFee2Includes: None

Schools

  • Elementary School: Kaelepulu
  • High School: Kailua
  • Middle Or Junior School: Kailua

Tax Info

  • Tax Annual Amount: 3792.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 5, 2022
Closed on
May 15, 2023
Sold by
Schultz Michael Tadashi and Mcmanus Karen Houghton
Bought by
Hayes Ramsey and Hayes Mhairi
Seller's Agent
Gloria Almendares
Realty By The Sea
Buyer's Agent
Debra Addessi
Drop - 2024
List Price
$1,850,000
Sold Price
$1,800,000
Premium/Discount to List
-$50,000
-2.7%
Current Estimated Value
$1,946,435

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$146,435
Avg. Annual Appreciation
2.79%
Original Mortgage
$1,252,420
Outstanding Balance
$1,216,892
Interest Rate
6.28%
Mortgage Type
New Conventional
Estimated Equity
$708,735

Purchase Details

Listed on
Sep 6, 2020
Closed on
Oct 19, 2020
Sold by
Laudise Stephen Anthony and Laudise Dawn Leilani
Bought by
Schultz Michael Tadashi and Mcmanus Karen Houghton
Seller's Agent
Leon Mosher
Coldwell Banker Realty
Buyer's Agent
Gloria Almendares
Realty By The Sea
List Price
$1,395,000
Sold Price
$1,375,000
Premium/Discount to List
-$20,000
-1.43%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.09%
Original Mortgage
$1,252,290
Interest Rate
2.8%
Mortgage Type
VA

Purchase Details

Closed on
Nov 9, 2009
Sold by
Laudise Stephen Anthony and Laudise Dawn Leilani
Bought by
Laudise Stephen Anthony and Laudise Dawn Leilani

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$375,000
Interest Rate
4.83%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 16, 2005
Sold by
Laudise Stephen Anthony and Laudise Dawn Leilani
Bought by
Laudise Stephen Anthony and Laudise Dawn Leilani

Purchase Details

Closed on
Nov 17, 1999
Sold by
Bek Inc
Bought by
Laudise Stephen Anthony and Laudise Dawn Leilani

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$322,500
Interest Rate
7.82%

Purchase Details

Closed on
Mar 30, 1998
Sold by
Lee James Alfred
Bought by
Bek Inc
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
Hayes Ramsey $1,800,000 Old Republic Title
Schultz Michael Tadashi $1,375,000 Or
Schultz Michael Tadashi $1,375,000 Or
Laudise Stephen Anthony -- Or
Laudise Stephen Anthony -- --
Laudise Stephen Anthony $367,500 --
Bek Inc $125,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hayes Ramsey $1,252,420
Previous Owner Schultz Michael Tadashi $1,252,290
Previous Owner Laudise Stephen Anthony $375,000
Previous Owner Laudise Stephen Anthony $322,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/19/2023 05/19/23 Sold $1,800,000 0.0% $777 / Sq Ft
01/01/2023 01/01/23 Off Market $1,800,000 -- --
11/29/2022 11/29/22 Pending -- -- --
11/22/2022 11/22/22 For Sale $1,850,000 0.0% $799 / Sq Ft
10/26/2022 10/26/22 Pending -- -- --
10/11/2022 10/11/22 Price Changed $1,850,000 -1.3% $799 / Sq Ft
08/05/2022 08/05/22 For Sale $1,875,000 0.0% $810 / Sq Ft
10/04/2021 10/04/21 Rented $6,000 0.0% --
10/04/2021 10/04/21 For Rent $6,000 0.0% --
10/26/2020 10/26/20 Sold $1,375,000 -1.4% $594 / Sq Ft View Prior Sale
09/26/2020 09/26/20 Pending -- -- --
09/06/2020 09/06/20 For Sale $1,395,000 -- $602 / 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 $11,387 $1,492,000 $1,067,500 $424,500
2024 $11,387 $1,648,000 $1,067,500 $580,500
2023 $5,274 $1,706,800 $1,067,500 $639,300
2022 $4,984 $1,524,100 $965,900 $558,200
2021 $3,791 $1,223,100 $782,900 $440,200
2020 $3,547 $1,153,400 $772,700 $380,700
2019 $3,498 $1,106,600 $772,700 $333,900
2018 $3,498 $1,079,500 $726,900 $352,600
2017 $3,393 $1,049,500 $655,800 $393,700
2016 $2,965 $927,100 $620,200 $306,900
2015 $2,997 $936,400 $538,900 $397,500
2014 $2,470 $875,700 $498,200 $377,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202213657

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-4-2-089-121-0000