Welcome to your luxurious oceanfront retreat, newly built in 2017 on a rare corner lot on Kaneohe Bay, where the
beauty of island living meets modern convenience. Step into a formal living room that flows seamlessly into a
modern kitchen and dining area. Downstairs, an extra-large second family room provides ample space for relaxation
with a premium German audiophile home theater setup. This 3-bedroom, 3.5-bath residence offers full AC, double-
pane windows, and an unobstructed ocean view without power lines. With two expansive lanais, you’ll enjoy
breathtaking views of Kaneohe Bay and the Koolau Mountains, plus unforgettable sunrises over the water. A two-car
garage with a Gator storage system adds practicality, and the nearby boat ramp allows you to launch your
paddle board or performance-grade ocean kayak right from your backyard. Complete with a French hot water heating
system, this home is ideal for ocean enthusiasts. With shopping, parks, dining, and easy access to Likelike and H1
highways, it’s an effortless commute to Honolulu. Discover ultimate waterfront living on Oahu—make every day a
getaway in this exceptional home!
Closed
$1,775,000
45-075 Waikalua Rd #Q, Kaneohe, HI 96744
3beds
2,931sqft
Single Family Residence
Built in 2017
-- sqft lot
$1,726,500 Zestimate®
$606/sqft
$6,575 Estimated rent
Home value
$1,726,500
$1.61M - $1.86M
$6,575/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$6,575/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$6,575/mo
Rent Zestimate®
Refinance and save
$9,953/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$9,953/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: March 28, 2025 at 12:04am
Listed by:
Audrey M Alessi 970-846-7201,
Keller Williams Honolulu
Bought with:
Ana Maria Contis, RB-22216
eXp Realty
Source: HiCentral MLS,MLS#: 202501150
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Features
- Full Bath on Main Level
- Flooring: Carpet, Ceramic Tile
Interior area
- Total structure area: 3,539
- Total interior livable area: 2,931 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Garage, Two Car Garage, Two Spaces
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Exterior features: Landscaping
- Pool features: None
- Has view: Yes
- View description: Coastline, Mountain(s), Ocean, Sunset, Sunrise
- Has water view: Yes
- Water view: Coastline,Ocean
- Frontage type: Canal,Oceanfront,Waterfront
Lot
- Features: Corner Lot, Cul-De-Sac, Other
- Topography: Sloping
Details
- Parcel number: 1450050590014
- Zoning description: 05 - R-5 Residential District
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Detached
- Property subtype: Single Family Residence
Materials
- Double Wall, Wood Frame
Condition
- Excellent,Good Condition
- New construction: No
- Year built: 2017
Utilities & green energy
- Water: Public
- Utilities for property: Water Available
Community & neighborhood
Community
- Community features: Deck/Porch, Playground, Patio
Location
- Region: Kaneohe
- Subdivision: Waikalua
HOA & financial
HOA
- Services included: None
- Association name: Associa
- Second HOA fee: $1,060 monthly
Price history
| Date | Event | Price |
|---|---|---|
| 3/27/2025 | Sold | $1,775,000-5.1%$606/sqft |
Source:  HiCentral MLS #202501150 Report a problem | ||
| 3/18/2025 | Listing removed | $7,600$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/24/2025 | Listed for rent | $7,600$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/24/2025 | Listing removed | $1,870,000$638/sqft |
Source: HiCentral MLS #202501150 Report a problem | ||
| 2/4/2025 | Price change | $1,870,000-0.3%$638/sqft |
Source: HiCentral MLS #202501150 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 96744
Nearby schools
GreatSchools rating
- 5/10Reverend Benjamin Parker Elementary SchoolGrades: PK-6Distance: 0.7 mi
- 3/10Governor Samuel Wilder King Intermediate SchoolGrades: 7-8Distance: 1.4 mi
- 5/10Castle High SchoolGrades: 9-12Distance: 0.9 mi
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$1,726,500
2% more
+$34,530
With Zillow Showcase(estimated)
$1,761,030
- Hawaii
- Honolulu County
- Kaneohe
- 96744
- 45-075 Waikalua Rd Unit Q