NOT LISTED FOR SALE

Estimated Value: $1,290,000 - $1,459,000

4 Beds
2.5 Baths
1,114 Sq Ft
$1,219/Sq Ft Est. Value

Last Sold September 16, 2015

Last sale price $935,000 $839 Per Sq Ft

Est. 45% increase in value since last sale

Current estimated payment $7,436/month

335 Days on Market

Highlights

  • Ocean View
  • Maid or Guest Quarters
  • Building Patio
  • Hokulani Elementary School Rated A-
  • Wood Flooring
  • 4-minute walk to Kalaepohaku Park

About This Home

As of September 2015

This property is located on lower end of Bertram Street. Main house 3-bdrm/1.5-bath has panoramic views of Diamond Head to Ewa from deck. Downstairs has large 1-bdrm/1-bath with separate entrance, kitchenette, and 220V line. Lots of parking with 2 car carport and extra open parking on property. Walk up only 3-4 steps from carport to kitchen entrance or main house entrance. House recently re-roofed and repainted inside & outside.

Last Agent to Sell the Property

David Akamine

Drop - 2023 License #RS-34560 Listed on: 09/16/2014

Last Buyer's Agent

Patrick ONeill

Luxury Homes International License #RB-17241

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,861

Year Built

  • Built in 1962

Lot Details

  • 5,195 Sq Ft Lot
  • Zoning described as 05 - R-5 Residential District

Property Views

  • Ocean
  • Coastline
  • City

Home Design

  • Wood Frame Construction
  • Shingle Roof
  • Composition Roof
  • Asphalt Roof

Interior Spaces

  • 1,114 Sq Ft Home
  • 1-Story Property
  • Wood Flooring
  • Basement

Bedrooms and Bathrooms

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

Parking

  • 3 Parking Spaces
  • Carport

Listing and Financial Details

  • Assessor Parcel Number 1-3-3-051-034-0000

Community Details

Overview

  • St. Louis Subdivision

Amenities

  • Building Patio
  • Community Deck or Porch
  • Community Storage Space

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,861

Year Built

Built in 1962

Lot Details

0

Listing Details

  • Architectural Style: Cottage, Detached, Studio
  • Inclusions: Drapes,Dryer,Washer
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Year Built: 1962
  • CommunityFeatures: Deck/Porch, Patio, Storage Facilities
  • Road Surface Type: Paved
  • MLS Status: Closed
  • Subdivision Name: ST. LOUIS
  • Carport Y N: Yes
  • Interior Features: Bedroom on Main Level, Full Bath on Main Level
  • Unit Levels: One
  • Living Area: 1114.0
  • New Construction: No
  • Roof: Asphalt, Composition, Shingle
  • RoomType: Guest Quarters
  • Tax Year: 2014
  • Special Features: None

Interior Features

  • Flooring: Carpet, Hardwood, Other
  • Furnished: Unfurnished
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Stories: 1

Exterior Features

  • Construction Type: Double Wall, Single Wall, Wood Frame
  • Lot Features: Other, Level
  • Pool Features: None
  • Property Condition: Average Condition, Good Condition
  • Topography: Level,Sloping
  • View: Coastline, City, Mountain(s), Ocean, Sunset
  • View: Yes
  • Disclosures: Seller Disclosure

Garage/Parking

  • Parking Features: Carport, Three or more Spaces
  • Total Parking Spaces: 2.0

Utilities

  • Utilities: Above Ground Utilities, Cable Available, Electricity Available, High Speed Internet Available, Phone Available, Water Available
  • Water Source: Public

Lot Info

  • Parcel Number: 1-3-3-051-034-0000
  • Zoning Description: 05 - R-5 Residential District

Tax Info

  • Tax Annual Amount: 2860.56

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 17, 2022
Sold by
Schmeltz Family Trust
Bought by
Schmeltz Bremen Wolfgang
Current Estimated Value
$1,358,158

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$720,000
Outstanding Balance
$697,673
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$660,485

Purchase Details

Listed on
Sep 16, 2014
Closed on
Aug 27, 2015
Sold by
Suyemoto John Lyndon
Bought by
Schmeltz Family Trust and Schmeltz Margaret M
Seller's Agent
David Akamine
Drop - 2023
Buyer's Agent
Patrick ONeill
Luxury Homes International
List Price
$950,000
Sold Price
$935,000
Premium/Discount to List
-$15,000
-1.58%

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 10, 2009
Sold by
Suyemoto John L
Bought by
Suyemoto John Lyndon

Purchase Details

Closed on
Nov 25, 1998
Sold by
Suyemoto Marian A and Suyemoto Marian Asako
Bought by
Suyemoto Marian A and Suyemoto Marian Asako

Purchase Details

Closed on
Jul 8, 1994
Sold by
Suyemoto Barry Masaru and Suyemoto Barry M
Bought by
Suyemoto Barry M and Suyemoto Marian A
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
Schmeltz Bremen Wolfgang -- First American Mortgage Soluti
Schmeltz Family Trust $935,000 Fidelity Natl Title & Escrow
Schmeltz Family Trust $935,000 Fidelity Natl Title & Escrow
Suyemoto John Lyndon -- None Available
Suyemoto Marian A -- --
Suyemoto Barry M -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schmeltz Bremen Wolfgang $720,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/16/2015 09/16/15 Sold $935,000 -1.6% $839 / Sq Ft
08/17/2015 08/17/15 Pending -- -- --
09/16/2014 09/16/14 For Sale $950,000 -- $853 / 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 $3,919 $1,307,900 $1,009,800 $298,100
2024 $3,919 $1,239,800 $1,009,800 $230,000
2023 $6,584 $1,226,700 $959,300 $267,400
2022 $5,877 $1,131,100 $858,300 $272,800
2021 $5,265 $1,072,900 $823,000 $249,900
2020 $5,505 $1,095,700 $823,000 $272,700
2019 $4,924 $1,040,400 $823,000 $217,400
2018 $3,450 $985,600 $787,600 $198,000
2017 $3,297 $942,000 $742,200 $199,800
2016 $2,856 $816,100 $671,500 $144,600
2015 $3,126 $893,100 $737,100 $156,000
2014 $2,315 $817,300 $605,900 $211,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 201418226

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-3-3-051-034-0000