Property Attributes
- MLS#202606526
- TypeSingle Family
- Listing Status Active
- CountyOahu
- CityHaleiwa
- AreaNorth Shore
- NeighborhoodPUPUKEA
- Zip96712
- Style
- Year Built2002
- Taxes$ 7860
- Price$ 3,500,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage2820
- Lot Size1 Acres
Data Source:
HiCentral MLS (HICMLS)
Property Description
Impeccably built by Jeff Denman, Architect design by Chris Moorland, this is a rare offering to purchase an impeccably maintained residence with an attached, approx. 800 sq. ft. STUDIO apartment. The studio offers a wet bar & full bath on the lower level that spills out to the Xtra-Large covered lanai, perfect for extended family or guests. BONUS DETACHED PERMITTED REC ROOM on the grounds for many possibilities + plans for permitted additions to the dwellings. High-end finishes grace every room, such as wainscoting, hardwood flooring, granite counter tops, and luxury tile flooring. Gourmet chef's kitchen with WOLF & SUB ZERO appliances. Open concept living & dining area. A tankless water heater was recently added to upgrade this home's efficiency. 2-car GARAGE includes an oversized STORGE ROOM/WORKSHOP, laundry room & shoot and covered entry to the house. There is plenty of room to flow outside on the manicured lawn, sprinkled with mature citrus, lychee, and starfruit trees. Fenced for privacy and security, the driveway can accommodate multiple vehicles/BOAT. This home has it all.. Seller to participate in a 1031 Exchange.
| Elementary School | Middle School | High School |
|---|---|---|
| Haleiwa Elementary School | Kahuku Middle School | Kahuku High School |
| Price History | |
|---|---|
| 5/1/2026 | Listed $3,500,000 |
General Features
| Utilities | Cable Available,Natural Gas Available,High Speed Internet Available,Other,Phone Available,Septic Available,Water Available |
|---|---|
| Architectural Style | Cottage,Detached,Studio |
| Security Features | Key Card Entry |
| View | Coastline,Ocean,Sunset |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Community Features | Deck/Porch,Patio,Storage Facilities |
| County | Oahu |
| New Construction | false |
| Property Type | Residential |
| Subdivision Name | PUPUKEA |
| Garage Y/N | true |
| Full Baths | 3 |
| Status | Active |
| ModificationTimestamp | 2026-07-29T20:38:55.963-00:00 |
| City | Haleiwa |
| MLS Area | North Shore |
| Property Condition | Excellent,Good Condition,Updated/Remodeled |
| Standard Status | Active |
| Tax Assessed Value | 2247600 |
| PostalCity | Haleiwa |
| AttributionContact | (800) 667-5028 |
| Pool Features | None |
| Year Built | 2002 |
| Year Built Effective | 2012 |
| High School | Kahuku |
| Disclosures | 1031 Exchange,Principal is Real Estate Licensed |
| Elementary School | Haleiwa |
| Zoning Description | 56 - Country District |
| Middle/Junior High School | Kahuku |
| Sewer | Septic Tank |
| Construction Materials | Double Wall,Concrete,Wood Frame |
| Land Tenure | FeeSimple |
| Island | Oahu |
| Tax Annual Amount | 7860 |
| Topography | Level,Sloping |
| Virtual Tour | https://player.vimeo.com/video/1182083009 |
| Other Structures | Workshop |
Interior Features
| Interior Amenities | Bedroom on Main Level,Full Bath on Main Level |
|---|---|
| Flooring | Ceramic Tile,Hardwood |
| Furnished Y/N | Negotiable |
| Half Baths | 1 |
| Total Bedrooms | 4 |
| Total Baths | 4 |
| Room Type | Guest Quarters |
Exterior Features
| Parking Features | Boat,Driveway,Garage,Three or more Spaces,On Street |
|---|---|
| Lot Features | Cleared,Other,Level |
| Total Parking | 10 |
| Lot Size Area | 45259 |
| Building Area Total | 3906 |
| Exterior Amenities | Landscaping |
| Fencing | Fenced,Wall |
| Water Source | Public |
| Inclusions | Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Gas Grill,Microwave,Range/Oven,Refrigerator,Smoke Detector,TV Antenna,Washer,Water Heater |
| Foundation Details | Slab |
| Road Frontage Type | County Road |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
© 2011 HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on September 22, 2026 2:30 PM UTC Some of the active listings appearing on this site may be listed by other REALTORS®. We are only showing FEE SIMPLE, ACTIVE listings on this website.