45-075 Waikalua Rd, Unit Q

2,931 Sq. Ft.
$606 / Sq. Ft.
2,931
Sq. Ft.
$606
per Sq. Ft.

Description

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
...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!
  1. Listed by Audrey M Alessi • License #RS-80748 • Keller Williams Honolulu • (808) 596-2888

Property Details for 45-075 Waikalua Road, Unit Q

Architectural Style
CPR, Detach Single Family
View
Coastline, Mountain, Ocean, Sunrise, Sunset
Zoning
05 - R-5 Residential District
Neighbourhood
WAIKALUA
Flood Zone
Zone X
Stories/Levels
Two
Land Tenure
FS - Fee Simple
LISTING UPDATED: 03/27/2025 09:03 PM

Property Details for 45-075 Waikalua Road, Unit Q

StatusSold
MLS #202501150
Days on Market52
Taxes$382 / month
HOA Fees$1,060 / month
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family
Year Built2017
Lot Size0.16 AC / 6,762 SF
CountyHonolulu County

Location

Listing Courtesy of Keller Williams Honolulu, Audrey M Alessi, License #RS-80748

Sold By eXp Realty, Ana Maria Contis, License #RB-22216

Add your commute

Building Information for 45-075 Waikalua Road, Unit Q

Stories-Year Built2017Building Size-Lot Size0.16 AC / 6,762 SF

Payment Calculator

$10,380 per month

30 year fixed, 6.46% Interest

Principal and Interest

$8,938

Property Taxes

$382

HOA Dues

$1,060

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 45-075 Waikalua Road, Unit Q

Summary
Location and General Information
  • Topography: Down Slope
  • City: Kaneohe
  • County Or Parish: Oahu
  • State Or Province: HI
  • Location: Corner, Cul-De-Sac
Taxes and HOA Information
  • Association Community Name: Associa
  • Association Fee 2 Includes: None
  • Association Fee Total: $1,060
  • Tax Amount: $382.37
  • Tax Assessed Value: $1,431,000.00
  • Tax Assessed Value Improvements: $706,300.00
  • Tax Assessed Value Land: $724,700.00
  • Tax Excemption Owner Occupancy: 120000
  • Tax Year: 2024
  • Parcel Number: 1-4-5-005-059-0014
  • HOA YN: Yes
Parking
  • Parking Features: 2 Car, Driveway, Garage
  • Parking Total: 2
Property
Lot Information
  • Property Frontage: Ocean, Stream/Canal, Waterfront
  • Property Sub Type: Single Family
  • Property Type: Single Family
  • Road Frontage: Paved Rd
  • SQFT Garage Carport: 506.0
  • Open Other Spaces Total: 608.0
  • SQFT Roofed Living: 2931.0
  • Sqft Total: 3539.0
  • Land Recorded: Regular System
  • Lot Features: Other
  • Lot Size Area: 6762.0
  • Year Built: 2017
Property and Assessments
  • Appliances: AC Split, Auto Garage Door Opener, Cable TV, Chandelier, Dishwasher, Disposal, Dryer, Range/Oven, Refrigerator, Washer, Water Heater
  • Photo Count: 1
  • New Development Construction: No
  • Property Condition: Excellent, Above Average
  • Special Listing Conditions: None
  • Disclosures: Pets Allowed (Verify), Property Disclosure Stmt
  • Foreclosure: No
  • Fractional Ownership: No
  • Condo Property Regime: Yes
  • Set Backs: C&C
  • Supplement Count: 0
  • TMK Area: 145
  • TMK Condo Property Regime Number: 14
  • TMK Division: 1
  • TMK Parcel: 59
  • TMKPLAT: 5
  • TMK Section: 5
  • TMK Zone: 4
Utilities
  • Utilities: Public Water
Interior and Exterior Features
Exterior Features
  • Amenities: Full Bath on 1st Floor, Landscaped, Patio/Deck, Playground
  • Construction Materials: Double Wall, Wood Frame
  • Easements: Drainage
  • Flooring: Ceramic Tile, W/W Carpet
  • Pool Features: None
  • Roof: Asphalt Shingle
Interior Features
  • Baths Full: 3
  • Baths Half: 1
  • Baths Total: 3.01
  • Beds Total: 3.0
  • Furnished: None
  • Room Count: 0
Multi Family
Multi-Family Information
  • Unit Number: Q
Income & Expenses
  • Maintenance Fee Amount: $1,060.00
Agent
Sale and Listing
  • Active Open House Count: 0
  • DOM: 52
  • Immoviewer: No
  • Listing Service: Full Service
  • Management Company Name: 8088360911
  • MLS: HI Central
  • MLS Area Major: Kaneohe
  • Open House Count: 1
  • Status: Sold
  • Public Remarks: 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!
  • Possession: At Closing
Showing and Remarks
  • Showing Instructions: <8 Hrs Notice Reqd
Rental
Rent Information
  • Occupant Type: Vacant

Property History for 45-075 Waikalua Road, Unit Q

DateEvent & SourcePriceAppreciation
Mar 27, 2025

Sold

HICENTRAL #202501150

$1,775,000
Mar 27, 2025

Contract Signed

HICENTRAL #202501150

Feb 28, 2025

Contract Out

HICENTRAL #202501150

DateEvent & SourcePrice
03/27/2025

Sold

HICENTRAL #202501150

$1,775,000
03/27/2025

Contract Signed

HICENTRAL #202501150

02/28/2025

Contract Out

HICENTRAL #202501150

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 45-075 Waikalua Road, Unit Q

Taxable ValueLand$744,300Additions$878,100Total$1,622,400
Tax Record2026$4,927 ($411 / month)
Home Facts
Beds3Baths3.5Total Finished SqFt2,931 SqFtAbove Grade Finished SqFt2,931 SqFtStories1Lot Size6,762 SqFtStyleCondominiumYear Built2016Year Renovated2017ZoningR-5 RESIDENTICountyHONOLULUAPN1-4-5-005-059-0014

Schools near 45-075 Waikalua Road, Unit Q

This home is within Hawaii Department Of Education.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 8
Public - 9 to 12
Public - 6
Rating
School
Distance
Reverend Benjamin Parker Elementary School
PublicPK to 6

Castle High School
Public9 to 12

Kulia Academy
Public6

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Keller Williams Honolulu, Audrey M Alessi, License #RS-80748

Based on information from one of the following Multiple Listing Services: Hawaii HIS, MAUI MLS and Hi Central. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Hawaii HIS, MAUI MLS and Hi Central is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.