Search Open Houses Buyer's Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


621 Aipo Street Honolulu HI 96825

This property was withdrawn and is not for sale.

$1,039,000 | OahuRE Rebate $5,195 | Withdrawn

Price dropped on 04-17-2020. Original price was $1,049,000

Listed on 03-27-2020 * 33 Days until Withdrawn on 04-29-2020

4 Bedrooms, 2 Full Baths, 0 Half Baths, 4 Parking Spaces

1,656 Square Feet Living * 7,465 Square Feet Land

Sell for a $3,500 Flat Fee or 2% with full service.

Contact us for a showing.

View Virtual Tour

Property Last Viewed: 11/25/2021 12:18 PM, Total Views Today: 0, Total Views: 1,221, Viewed History

Save This Property to Receive Automatic Email Updates When the Status Changes

Comparables by Square Feet

Short Cuts

Update the default down payment and interest rate.



OahuRE.com Notes About This Property

View all new listings in the Koko Head Terrace neighborhood since this property was listed.

Listed previously on May 1, 2020 for $1,029,000. View Details

Listed previously on August 29, 2019 for $699,000. View Details

Fell out of escrow or Temporarily Withdrawn 1 time. View Details

Price Decreased 1 time. View Details

Withdrawn 1 time. View Details

Price trends for Koko Head Terrace.

There were 45 homes sold in the last 2 years in the Koko Head Terrace neighborhood.


621 Aipo Street

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

621 Aipo Street

Details * Showing Request * Top * 2 * Previous * Next

Learn More About Our Selling Options

621 Aipo Street

Details * Showing Request * Top * 3 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 4 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 5 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 6 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 7 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 8 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 9 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 10 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 11 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 12 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 13 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 14 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 15 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 16 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 17 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 18 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 19 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 20 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 21 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 22 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 23 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 24 * Previous * Next

621 Aipo Street

Details * Showing Request * Top * 25 * Previous

Older Photos From A Previous Listing

621 Aipo Street

621 Aipo Street

View additional older photos

Property Details

Top of Page * Showing Request * Questions?


MLS#: 202007173 * Questions?
Status: Withdrawn See History
Price: $1,039,000
Rebate: $ 5,195 from OahuRE.com.
Monthly: $ 4,201.11 Update the default down payment and interest rate
  Monthly payment estimate for $ 1,039,000 price, 10% down, 3.11% interest rate, 30 year loan, $ 203 taxes, and $ 0 fees. Insurance not included.
Beds: 4   Baths: 2   Half: 0  Parking Spaces: 4
Living Sq Ft: 1,656
Land Sq Ft: 7,465
Land Tenure: FS - Fee Simple
Address: 621 Aipo Street Honolulu HI 96825
Region: Hawaii Kai - Activity
Neighborhood: Koko Head Terrace - Activity * Koko Head Terrace Stats
Street: Aipo - Activity * Aipo Street Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $1,049,000
Change: $-10,000    -0.95%
Parcel#: 1-3-9-053-035-0000
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 29 days in Active or In Escrow Showing
Date: Listed: 03-27-2020
Date: Status Change: 04-29-2020
Year Built: 1968 Remodeled: 2019
View: Mountain
Frontage:
Monthly Tax: $203 Year: 2020
Land: FS - Fee Simple
Condition: Excellent

Top of Page * Showing Request * Questions?

Description:

NEW LISTING! FULLY RENOVATED home in Koko Head Terrace. Rarely available, single level 4 bdrm / 2 ba home feat. vaulted ceilings & 500+ sq ft of covered lanai space ideal for pets, workshop, or possible conversion into another room (buyer to verify). Situated on large 7,465 sq ft lot in private cul-de-sac w/ terraced backyard.

Executive kitchen is highlighted by a grand waterfall island and has been luxuriously upgraded with acrylic cabinets, calcutta quartz countertops, vinyl plank/tile flooring and brand new Whirlpool appliances w/ bonus wine fridge. Bdrms and baths renovated w/ vinyl & tile flooring, vinyl windows, ceiling fans, quartz countertops and new fixtures.

Freshly painted interior/exterior w/ brand new 36k BTU split AC in living room. In addition to the 2 car carport, driveway allows room for additional cars. Close proximity to Koko Marina & Hawaii Kai Towne Center with vendors like Longs, Petco, Costco, 24hr Fitness.

 
 
Inclusions: AC Split, Ceiling Fan, Dishwasher, Disposal, Dryer, Microwave Hood, Range/Oven, Refrigerator, Washer

Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor, Patio/Deck

Utilities: Connected, Public Water, Sewer Fee, Underground Electricity, Water Construction: Double Wall, Single Wall, Slab, Wood Frame Lot Features: Clear Floor: Ceramic Tile, Vinyl Disclosures: Listor Owner, Property Disclosure Stmt Land Recorded: Regular System Furnished: None

Possession: At Closing Terms: Cash, Conventional, VA Sale Conditions: None

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $689,100
Building: $89,900  
Assessed Total: $779,000  
Assessed Ratio: 133.38%
Pool: None
Location: Cul-De-Sac
Parking: 3 Car+, Carport, Driveway, Street

Top of Page * Showing Request * Questions?

District Locator: DOE Locator to Confirm District
Area Total: 7,465
Acres: 0.1714
Topography: Level, Terraced
Building Style: Detach Single Family
Building:
New Const: No

Top of Page * Showing Request * Questions?

Maint. Fee: $0
Assoc. Fee: $0
Other Fee: $0
Includes:
Total Fees: $0
Exemption: 0
Other: 240
Lanai Sq Ft: 283
Garage Sq Ft: 300
Avg Sq Ft Living: $627.42
Avg Sq Ft Land: $139.18
Security:
Rental Income: $0
Stories: One CPR: No
Zoning: 05 - R-5 Residential District
Flood Zone: Zone D * Check if this property is in a Flood Zone
Tsunami Zone: Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map
Roofing: Composition
Set-Backs: Of Record Roads: Paved Rd
Easements: None

Top of Page * Showing Request * Questions?

Links:
Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch
Commuting:
Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore
Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info
Closing Cost Calculators:
Buyer's Closing Cost Calculator to estimate the buyer's closing cost.
Seller's Closing Cost Calculator to estimate the seller's closing cost.

Listing courtesy of BHGRE Advantage Realty

Top of Page * Showing Request * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
06-23-2020 202009078 Sold Sold $1,029,000 $1,019,500 $779,000 $689,100 $89,900
06-12-2020 202009078 In Escrow Not Showing In Escrow Showing In Escrow Not Showing $1,029,000 $1,019,500 $779,000 $689,100 $89,900
05-07-2020 202009078 In Escrow Showing Active In Escrow Showing $1,029,000 $1,019,500 $779,000 $689,100 $89,900
05-01-2020 202009078 New Listing Active Active $1,029,000 $1,019,500 $779,000 $689,100 $89,900
04-29-2020 202007173 Withdrawn Active Withdrawn $1,039,000 $0 $779,000 $689,100 $89,900
04-17-2020 202007173 Price Decrease $1,049,000 $1,039,000 $1,039,000 $0 $779,000 $689,100 $89,900
04-12-2020 202007173 Back On Market In Escrow Showing Active $1,039,000 $0 $779,000 $689,100 $89,900
04-08-2020 202007173 In Escrow Showing Active In Escrow Showing $1,039,000 $0 $779,000 $689,100 $89,900
03-27-2020 202007173 New Listing Active Active $1,039,000 $0 $779,000 $689,100 $89,900
10-21-2019 201924356 Sold In Escrow Showing Sold $699,000 $640,000 $815,700 $679,500 $136,200
09-04-2019 201924356 In Escrow Showing Active In Escrow Showing $699,000 $640,000 $815,700 $679,500 $136,200
09-02-2019 201924356 Active $699,000 $699,000 $640,000 $815,700 $679,500 $136,200
09-02-2019 201924356 New Listing Active Active $699,000 $640,000 $815,700 $679,500 $136,200

Top of Page * Showing Request * Questions?


Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Going more years back returns closer matches.

Last 6 Months Sold

Last 1 Year Sold

Last 2 Years Sold

Last 3 Years Sold

Similar Properties Sorted by Smallest Price Difference First

Listings in Koko Head Terrace Neighborhood

View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles

Top of Page * Showing Request * Questions?


City and County Public Information Links

City and County Logo

Tax Info including a Plat Map PDF and GIS Parcel Map

Department of Planning & Permitting General Information

Department of Planning & Permitting All Permits

Dept. of Emergency Management Public Safety Info

Tax Records and Property History in this Neighborhood

Tax Records and Property History on this Street

Building Sketch

Top of Page * Showing Request * Questions?


Sex Offender Information

Attorney General Logo

View a map of Sex Offenders for this Zip Code

Top of Page * Showing Request * Questions?


Daily Watch List

Add to Daily Watch List by Parcel Number

Top of Page * Showing Request * Questions?



Google Maps

View this property's location * Top of Page

View Nearby Schools on Google Maps - Preschools, Elementary Schools, Middle Schools, or High Schools

View Nearby Parks, Farmer's Markets, and Best Restaurants on Google Maps

Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park

View nearby Airbnb locations.

View Koko Head Terrace Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the Hawaii Kai Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request * Questions?



Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

Top of Page * Showing Request * Questions?



View Directions on Google Maps to nearest Beach Access

View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info

Beach Access Map

Top of Page * Showing Request * Questions?





Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $22,243.31 of interest charges by adding an extra payment of $100 per month. View details from the link above.

Rate:
2.36% 2.61% 2.86% 3.11% 3.36% 3.61% 3.86% 4.11% 4.61%
0% Down
$4,030$4,165$4,302$4,442$4,585$4,730$4,877$5,026$5,333
3.5% Down
$3,889$4,019$4,152$4,287$4,424$4,564$4,706$4,851$5,146
10% Down
$3,627$3,748$3,872$3,998$4,126$4,257$4,389$4,524$4,799
20% Down
$3,224$3,332$3,442$3,554$3,668$3,784$3,901$4,021$4,266
30% Down
$2,821$2,915$3,012$3,110$3,209$3,311$3,414$3,519$3,733
40% Down
$2,418$2,499$2,581$2,665$2,751$2,838$2,926$3,016$3,200
50% Down
$2,015$2,082$2,151$2,221$2,292$2,365$2,438$2,513$2,666

Top of Page * Showing Request * Questions?



Crime Mapping

Last 7 days of crime (you can then change it to go back further)

Top of Page * Showing Request * Questions?



Yelp

Popular Yelp Links Sorted by Review Count Near 621 Aipo Street

Most Popular, Restaurants, Shopping, Arts & Entertainment, Active Life Activities

Top of Page * Showing Request * Questions?