NOT LISTED FOR SALE

Estimated Value: $3,545,709

3 Beds
2.5 Baths
3,159 Sq Ft
$1,122/Sq Ft Est. Value

Highlights

  • Ocean Front
  • Private Pool
  • Marble Flooring
  • Aina Haina Elementary School Rated A-
  • Solar Power System
  • 1-minute walk to Nehu Mini Park

About This Home

As of April 2024

Oceanfront Villa on Niu Beach offered for rent April 16 through December 16, 2024. (minimum 30 day rental) The home is a gated, secure tropical retreat. This is a special, fully furnished, 3bdrm/3bath home with a sparkling tiled pool and outdoor lanai to complement the spacious home that features a chef kitchen, a large primary suite (walk in closet, double sink, spa bathtub), office den, laundry room and large driveway. Solar hot water PV electric help power the second floor bedrooms split ACs at minimal cost. The ocean beckons you to surf Toes/Secrets or take a stab at the best bone fishing on the island. Not a wave rider? enjoy the covered lanai next to the pool, lounge poolside for sunbathing or take a kayak for a spin. No smoking, furnished, tenant to pay for electric and water. (lowered by solar panels) Includes GE tax, yard and pool service,security system and wifi. Tenant to pay for professional cleaning, renter’s. Home is fully furnished. No pets please. Owner reserves the garage for their own use. Lots of parking on the gated driveway. Live the dream of living on the ocean in Hawaii nei.

Last Agent to Rent the Property

Katherine Ingoglia

Aloha Realty Group LLC License #RB-15137 Listed on: 03/12/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,638

Year Built

  • Built in 1990 | Remodeled in 2024

Lot Details

  • 0.25 Acre Lot
  • Ocean Front
  • Fenced
  • Private Yard
  • Property is in excellent condition

Property Views

  • Ocean
  • Coastline
  • City
  • Mountain
  • Diamond Head
  • Garden

Home Design

  • Split Level Home

Interior Spaces

  • 3,159 Sq Ft Home
  • 2-Story Property
  • Furnished
  • Ceiling Fan
  • Chandelier
  • Drapes & Rods
  • Blinds

Kitchen

  • Convection Oven
  • Built-In Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Marble
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Bathroom on Main Level

Laundry

  • Dryer
  • Washer

Home Security

  • Home Security System
  • Fire and Smoke Detector

Parking

  • 3 Parking Spaces
  • 3 Open Parking Spaces
  • Secure Parking

Eco-Friendly Details

  • Solar Power System
  • Solar Water Heater

Outdoor Features

  • Private Pool
  • Patio
  • Lanai

Schools

  • Aina Haina Elementary School
  • Niu Valley Middle School
  • Kalani High School

Utilities

  • Mini Split Air Conditioners

Community Details

  • Pool Services

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,638

Year Built

Built in 1990 | Remodeled in 2024

Lot Details

0

Listing Details

  • Architectural Style: Detach Single Family
  • PropertyFrontage: Ocean, Waterfront
  • Prop. Type: Rental
  • Sq Ft RoofedLiving: 3159
  • Fill Sq Ft Total: 3159
  • Stories Type: Two
  • Year Built: 1990
  • Year Renovated: 2024
  • Attribution Contact: (808) 741-2490
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Amenities: Patio/Deck, Pool on Property, Private Yard
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Flooring: Ceramic Tile, Marble/Granite, W/W Carpet
  • Furnished: Full
  • Unit Features: AC Split, Blinds, Book Shelves, Ceiling Fan, Chandelier, Convection Oven, Dishwasher, Disposal, Drapes, Dryer, Full Bath on 1st Floor, Fenced, Kitchenware, Lanai, Linens, Microwave Hood, Microwave, Multi Level, Range/Oven, Refrigerator, Security System, Smoke Detector, Solar Electric, Solar Water, Split Level, Washer, Yard

Exterior Features

  • Flood Zone: Zone AE
  • Property Condition: Excellent
  • View: City, Coastline, Diamond Head, Garden, Mountain, Ocean, Sunrise, Sunset

Garage/Parking

  • Parking Features: Open - 3+, Open, Secured Entry
  • Total Parking Spaces: 3
  • Sq Ft GarageCarport: 500

Utilities

  • Utilities: Parking, Pool Service, Yard Service

Schools

  • Elementary School: Aina Haina
  • Middle School: Niu Valley
  • High School: Kalani
  • Elementary School: Aina Haina
  • High School: Kalani
  • Middle Or Junior School: Niu Valley

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 20, 2017
Sold by
Bertram John Scott and Bertram Cathy Ellen Cramer
Bought by
Bertram John Scott and Bertram Cathy Ellen Cramer
Current Estimated Value
$3,545,709

Purchase Details

Closed on
Mar 6, 2012
Sold by
Bertram John Scott and Bertram Cathy Cramer
Bought by
Bertram John S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$625,000
Outstanding Balance
$263,096
Interest Rate
3.83%
Mortgage Type
New Conventional
Estimated Equity
$3,282,613

Purchase Details

Closed on
Mar 14, 2005
Sold by
Bertram John Scott and Bertram Cathy Cramer
Bought by
Bertram John S and John S Bertram Living Trust

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$800,000
Interest Rate
5.61%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Feb 26, 1994
Sold by
Bertram John Scott and Bertram Cathy Cramer
Bought by
Bertram John S and Bertram Cathy Cramer
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
Bertram John Scott -- None Available
Bertram John Scott -- None Available
Bertram John Scott -- None Available
Bertram John Scott -- None Available
Bertram John S -- Accommodation
Bertram John Scott -- First American Title Co Inc
Bertram John S -- Accommodation
Bertram John Scott -- First American Title Co Inc
Bertram John S -- --
Bertram John Scott -- --
Bertram John S -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bertram John S $100,000
Open Bertram John Scott $625,000
Closed Bertram John Scott $625,000
Closed Bertram John S $670,000
Closed Bertram John Scott $80,000
Closed Bertram John Scott $800,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/26/2024 04/26/24 Rented $8,300 -4.6% --
04/14/2024 04/14/24 Price Changed $8,700 -6.5% $3 / Sq Ft
03/12/2024 03/12/24 For Rent $9,300 +9.4% --
05/22/2023 05/22/23 Off Market $8,500 -- --
05/20/2023 05/20/23 Rented $8,500 0.0% --
05/02/2023 05/02/23 Price Changed $8,500 -15.0% $3 / Sq Ft
03/28/2023 03/28/23 For Rent $10,000 +28.2% --
01/03/2022 01/03/22 Rented $7,800 0.0% --
01/03/2022 01/03/22 For Rent $7,800 -- --
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,638 $3,412,600 $2,850,600 $562,000
2024 $11,638 $3,485,100 $2,850,600 $634,500
2023 $10,864 $3,343,900 $2,850,600 $493,300
2022 $10,856 $3,241,800 $2,708,100 $533,700
2021 $9,136 $2,750,200 $2,158,300 $591,900
2020 $12,319 $3,659,600 $3,013,500 $646,100
2019 $12,040 $3,559,900 $2,932,100 $627,800
2018 $12,452 $3,677,800 $2,748,800 $929,000
2017 $11,903 $3,520,800 $3,054,200 $466,600
2016 $13,718 $4,039,400 $3,004,800 $1,034,600
2015 $14,893 $4,375,200 $2,590,300 $1,784,900
2014 $9,118 $3,615,400 $2,036,200 $1,579,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202406259

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-3-7-001-004-0000