Previous Next

66-471 Pikai Street Haleiwa, HI 96712

Listing
Overview

Price: $3,195,000
Area: HALEIWA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202616719"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "66-471"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Pikai"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "3195000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1107) "Rare oceanfront legal duplex on Oahu’s legendary North Shore. Set on a spacious 7,786 sq ft beachfront parcel in Haleiwa’s “Fresh Airs” community, this coastal sanctuary captures sweeping ocean, mountain, and sunset views, with world-class surf just beyond the lawn. Fully updated with permitted improvements throughout, the property features two legal residences with separate addresses—ideal for multi-generational living or a luxury rental/investment opportunity. The main home (66-471 Pikai) offers 3 bedrooms, 2 full baths, open-concept living, and expansive dual oceanfront lanais for effortless indoor/outdoor island living. The attached second home (66-469 Pikai) features 2 bedrooms, 1 bath, complete privacy, and its own entrance. Upgrades include a new pitched roof, dual-meter electrical enclosure with new subpanels, EV charger, refreshed plumbing, rebuilt oceanfront lanai decking, premium Pella 250 Series impact-rated windows and sliders, designer appliances, and fresh coastal paint. A turnkey beachfront trophy offering rare dual-residence versatility and pure North Shore magic."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7786.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3256"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1969"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(31) "Coastline,Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(17) "david@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-4622"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "David J Sterman"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19679620"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-09-09T08:30:35.373"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-09-08"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "08:30:35.373"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27518335"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27518335"
    [1]=>
    string(8) "27518336"
    [2]=>
    string(8) "27518337"
    [3]=>
    string(8) "27518338"
    [4]=>
    string(8) "27518339"
    [5]=>
    string(8) "27518340"
    [6]=>
    string(8) "27518341"
    [7]=>
    string(8) "27518342"
    [8]=>
    string(8) "27518343"
    [9]=>
    string(8) "27518344"
    [10]=>
    string(8) "27518345"
    [11]=>
    string(8) "27518346"
    [12]=>
    string(8) "27518347"
    [13]=>
    string(8) "27518348"
    [14]=>
    string(8) "27518349"
    [15]=>
    string(8) "27518350"
    [16]=>
    string(8) "27518351"
    [17]=>
    string(8) "27518352"
    [18]=>
    string(8) "27518353"
    [19]=>
    string(8) "27518354"
    [20]=>
    string(8) "27518355"
    [21]=>
    string(8) "27518356"
    [22]=>
    string(8) "27518357"
    [23]=>
    string(8) "27518358"
    [24]=>
    string(8) "27518359"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202616719
        )

    [StreetNumber] => Array
        (
            [0] => 66-471
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Pikai
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Haleiwa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96712
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 3195000.00
        )

    [Neighbourhood] => Array
        (
            [0] => HALEIWA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Rare oceanfront legal duplex on Oahu’s legendary North Shore. Set on a spacious 7,786 sq ft beachfront parcel in Haleiwa’s “Fresh Airs” community, this coastal sanctuary captures sweeping ocean, mountain, and sunset views, with world-class surf just beyond the lawn. Fully updated with permitted improvements throughout, the property features two legal residences with separate addresses—ideal for multi-generational living or a luxury rental/investment opportunity. The main home (66-471 Pikai) offers 3 bedrooms, 2 full baths, open-concept living, and expansive dual oceanfront lanais for effortless indoor/outdoor island living. The attached second home (66-469 Pikai) features 2 bedrooms, 1 bath, complete privacy, and its own entrance. Upgrades include a new pitched roof, dual-meter electrical enclosure with new subpanels, EV charger, refreshed plumbing, rebuilt oceanfront lanai decking, premium Pella 250 Series impact-rated windows and sliders, designer appliances, and fresh coastal paint. A turnkey beachfront trophy offering rare dual-residence versatility and pure North Shore magic.
        )

    [ListOfficeName] => Array
        (
            [0] => Sterman Realty
        )

    [BedsTotal] => Array
        (
            [0] => 5
        )

    [BathsFull] => Array
        (
            [0] => 3
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 7786.00
        )

    [SqftTotal] => Array
        (
            [0] => 3256
        )

    [YearBuilt] => Array
        (
            [0] => 1969
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => Coastline,Mountain,Ocean,Sunset
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Haleiwa
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Waialua
        )

    [HighSchool] => Array
        (
            [0] => Waialua
        )

    [ListOfficeMLSID] => Array
        (
            [0] => STER
        )

    [ListAgentEmail] => Array
        (
            [0] => david@sterman.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-4622
        )

    [ListAgentFullName] => Array
        (
            [0] => David J Sterman
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 19679620
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-09-09T08:30:35.373
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-09-08
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 08:30:35.373
        )

    [_thumbnail_id] => Array
        (
            [0] => 27518335
        )

    [listing_image] => Array
        (
            [0] => 27518335
            [1] => 27518336
            [2] => 27518337
            [3] => 27518338
            [4] => 27518339
            [5] => 27518340
            [6] => 27518341
            [7] => 27518342
            [8] => 27518343
            [9] => 27518344
            [10] => 27518345
            [11] => 27518346
            [12] => 27518347
            [13] => 27518348
            [14] => 27518349
            [15] => 27518350
            [16] => 27518351
            [17] => 27518352
            [18] => 27518353
            [19] => 27518354
            [20] => 27518355
            [21] => 27518356
            [22] => 27518357
            [23] => 27518358
            [24] => 27518359
        )

)

PROPERTY INFO

• BedsTotal: 5
• Full Baths: 3
• Land Area (sf): 7,786 sf
• Living (sf): 3,256
• Year Built: 1969

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: Coastline,Mountain,Ocean,Sunset
• Listing Office: Sterman Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Haleiwa
• Middle School: Waialua
• High School: Waialua

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 9, 2026 - 8:30 AM Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd.
Some of the 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.