Sign Up Login
Back to search
Share
Save
Saved
Contact Agent
Login Join
Share
Save
Saved
Share
1 of 23
RENTED 03/11/2021
To see all RENTED property photos, please log in or create an account, as per Honolulu Board of Realtors rules
67-404 Aikaula Street Waialua - Rental - photo 1 of 23
view 1 image
67-404 Aikaula Street, Waialua, HI, 96791
Photos
About
Details
Open Houses
Neighborhood
Amenties & Features
Prices
Schools
Price history
Activity
Taxes
Tour report
Recently sold
Save
Saved
Map View
Virtual Tour

67-404 Aikaula Street, Waialua, HI 96791

$2,900 Rental rented 4 beds 2 baths 1,590 sqft Neighborhood:  Waialua Rented
4 min walk to Kamamalu Neighborhood Park
6 min drive to Haleiwa
About lifestyles
Wonderful, cool and clean Brick home in Waialua, close to St. Michael's Church. SPACIOUS 4/2 WITH FENCED YARD. Small garden area in back yard! 2 Car Garage! Parking for 2 more cars in front of garage. All new Appliances, including a Washer/Dryer in the garage! CLOSE ACCESS TO FARRINGTON HIGHWAY, Mokuleia beaches. Minutes from Schofield, Wheeler and Wahiawa. About 40 minutes to Honolulu. 10 minutes to Haleiwa Town. Walk to the Sugar Mill Farmers Market every Saturday morning. Owners prefer no pets, but will consider a small dog no more than 25 pounds. Owners prefer one year lease. Call Monta R Koch, RS Sterman Realty, Ltd, for showings. 24 hour notice. 808-222-6336; montakoch@gmail.com
Read more

Rental details

1,590 sqft interior area
  • Year Built 1993
  • Year Remodeled 2000
  • Original list price $2,900
  • Days on market 1154
  • Price per sqft $2/sqft
  • Baths 2
  • Beds 4
  • Address

    67-404 Aikaula Street, Waialua, HI, 96791

  • Total area 1,590 sqft
  • Neighborhood Waialua
  • Land SqFt 5,300 sqft
  • Furnished Type Partial
  • Rental Type Long Term
  • Date Available February 26, 2021
  • View Garden, Mountain
  • Pets allowed No data
  • Virtual Tour View (external link)

Open Houses

No upcoming open houses

Neighborhood: Waialua

Oahu
North Shore
Waialua
Nearby & commute
Walkability
Coffee shops
—
no data
Bus stop
—
no data
Supermarket
—
no data
Costco
—
no data
Hospital
—
no data
Park
—
no data
Beach
—
no data
Elementary school
—
no data
Middle school
—
no data
High school
—
no data
Local airport
—
no data
15 / 20
Very walkable
►
18-20
Most Walkable
15-18
Very walkable
10-15
Somewhat walkable
1-10
Car dependent
Walkability according to the National Walkability Index

Amenities & Features

3 parking places, Ceramic Tile floors
Floors
Ceramic Tile
Furnished
Partial
Security
Key
Utilities
None, Yard Service
Property Condition
Average
No. of Floors in Unit
1
No. of Parking Stalls
3
Building Style
Detach Single Family
View
Garden, Mountain
Amenities
Private Yard
Unit features
Auto Garage Door Opener, Chandelier, Drapes, Dryer, Fenced, Range/Oven, Refrigerator, Smoke Detector, Washer, Yard

Waialua prices

Average price $958.33k
Neighborhood average sales price*
$958.33k
Neighborhood median sales price*
$890k
Number or sales*
3
*last 6 months

About Waialua

Waialua real estate for sale and lifestyle. A Hidden Gem on Oahu's North Shore Nestled on the idyllic North Shore of Oahu, the charming town of Waialua offers a unique blend of laid-back island living and vibrant outdoor adventures. With its picturesque l Read more

Schools

15 schools with rating up to 8
School rating Distance
NR
 St Michael School
67-340 Haona Street, Waialua, HI 96791
Elementary School
0.062mi
NR
 St Michael School
67-340 Haona Street, Waialua, HI 96791
Middle School
0.062mi
5
out of 10 		Waialua High & Intermediate School
67160 Farrington Hwy, Waialua, HI 96791
High School
0.281mi
School rating Distance
NR
 St Michael School
67-340 Haona Street, Waialua, HI 96791
 0.062mi
8
out of 10 		Waialua Elementary School
67020 Waialua Beach Rd, Waialua, HI 96791
 0.546mi
5
out of 10 		Haleiwa Elementary School
66505 Haleiwa Rd, Haleiwa, HI 96712
 1.244mi
2
out of 10 		Sergeant Samuel K Solomon Elementary School
2875 Waianae Uka Avenue, Wahiawa, HI 96786
 6.237mi
3
out of 10 		Hale Kula Elementary School
Waianae and Ayres Ave, Wahiawa, HI 96786
 6.401mi
School rating Distance
NR
 St Michael School
67-340 Haona Street, Waialua, HI 96791
 0.062mi
5
out of 10 		Waialua High & Intermediate School
67160 Farrington Hwy, Waialua, HI 96791
 0.281mi
8
out of 10 		Waialua Elementary School
67020 Waialua Beach Rd, Waialua, HI 96791
 0.546mi
5
out of 10 		Haleiwa Elementary School
66505 Haleiwa Rd, Haleiwa, HI 96712
 1.244mi
NR
 Maranatha Christian Church & Academy
127 N Circle Mauka Street, Wahiawa, HI 96786
 7.713mi
School rating Distance
5
out of 10 		Waialua High & Intermediate School
67160 Farrington Hwy, Waialua, HI 96791
 0.281mi
NR
 Maranatha Christian Church & Academy
127 N Circle Mauka Street, Wahiawa, HI 96786
 7.713mi
6
out of 10 		Leilehua High School
1515 California Ave, Wahiawa, HI 96786
 8.422mi
1
out of 10 		Kamaile Academy
85180 Ala Akau St, Waianae, HI 96792
 9.003mi
3
out of 10 		Waianae High School
85251 Farrington Hwy, Waianae, HI 96792
 9.278mi
School ratings provided by Greatschools.org © 2023. All rights reserved.

Price history

Rented Mar 11, 2021
Date Event Price $/sqft Source
Mar 11, 2021 Rented $2,900 $1.82 MLS #202104502
Feb 26, 2021 New Listing rental $2,900 -3.33% $1.82 MLS #202104502
Jan 30, 2021 Rented $3,000 $1.89 MLS #202032092
Dec 14, 2020 New Listing rental $3,000 $1.89 MLS #202032092
Show more Show less

Tax & MLS details 67-404 Aikaula Street, Waialua, HI, 96791

04 - R-7.5 Residential District zoning / MLS #202104502
TMK
1-6-7-005-059-0000
Zoning
04 - R-7.5 Residential District
Flood Zone
Zone X
Lease renegotiation date
Apr 1, 2021
Listed by
Sterman Realty
MLS #
202104502
Hawaii House tour report for this rental
No reviews yet
Stunning views
Ocean views
Open floorplan
Needs Work
Street noise
Show more Show less
We do not have a Hawaii House tour report for this listing yet.
As soon as we do, we post it here.
About Hawaii House tour report

Recently sold nearby 67-404 Aikaula Street in Waialua

SOLD 04/23/2024
$975,000
2 beds · 1 baths · 768 sqft
Home sold
66-667 Haleiwa Road unit 6
Haleiwa, HI
SOLD 04/18/2024
$1,224,000
3 beds · 2 baths · 1,200 sqft
Home sold
66-145 Waialua Beach Road
Haleiwa, HI
SOLD 04/17/2024
$1,025,000
2 beds · 2 baths · 1,199 sqft
Condo sold for $1,025,000
Konane Kai
68-155 Au Street unit 303
Waialua, HI
SOLD 03/18/2024
$800,000
3 beds · 1 full + 1 half baths · 1,495 sqft
Home sold
67-004 Kaimanu Place
Waialua, HI
SOLD 03/13/2024
$1,012,500
2 beds · 2 baths · 1,199 sqft
Condo sold for $1,012,500
Konane Kai
68-159 Au Street unit 310
Waialua, HI
SOLD 03/05/2024
$845,000
1 bed · 2 baths · 893 sqft
Condo sold for $845,000
Konane Kai
68-151 Au Street unit 308
Waialua, HI

Frequently asked questions for 67-404 Aikaula Street

When was this rental built and last sold?

This house was build in 1993 and sold in 2021.

What is the full address of this rental?

67-404 Aikaula Street, Waialua, HI, 96791.

Are there beaches near 67-404 Aikaula Street?

No, there aren't.

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Copyright 2024 by HiCentral Mls, Ltd. Listing courtesy of Sterman Realty. Some active listings appearing on this site may be listed by other REALTORS®. 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. Hawaii House Inc. is a real estate brokerage firm licensed to conduct business in the State of Hawaii. Information deemed reliable, but not guaranteed.

Listings last updated on March 11, 2021.
Hawaii House Last checked 1 minute ago.

Waialua & nearby Neighborhoods
More
Less
Nearby Zip Codes
More
Less
Waialua Property Types
More
Less
Unavailable 67-404 Aikaula Street, Waialua, HI, 96791 4 beds | 2 baths | 1,590 sqft Save House Remove from Saved