Previous Next

59-555 Makana Road Haleiwa, HI 96712

Listing
Overview

Price: $2,400,000
Area: PUPUKEA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202518741"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-555"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Makana"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["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) "2400000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1172) "Incredible cedar home located in the peaceful and secluded “Sunset Hills” —a highly desired private community in Pupukea, on the North Shore of Oahu. This home sits on more than an acre of land, with beautiful tropical landscape, a 4-car garage, and a greenhouse. The property features a cemented driveway with ample parking space, and is secured by a gated entrance with private code access. The oversized garage is newly renovated with split ACs, large ceiling fans, full insulation, ample space, and a half bath —making it perfect for an indoor gym, workshop, or creative studio. This versatile space adds immense value to the property.
The home itself is equally impressive, with 3 bedrooms, 1 bathroom, kitchen, dining area, laundry room, and a lanai with ocean view. With vaulted ceilings and a warm, inviting, and well-kept space, you will love the cozy cabin feel of this home, as well as waking up to the sound of singing birds. With plenty of land, you’ll love the serenity and natural beauty surrounding this property. The lush, well-maintained lawn offers expansive open space perfect for gardening, entertaining, and room to build future additions."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "44561.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1454"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2001"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["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) "18944132"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-25T16:45:01.320"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-25"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "16:45:01.320"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27122518"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27122518"
    [1]=>
    string(8) "27122519"
    [2]=>
    string(8) "27122520"
    [3]=>
    string(8) "27122521"
    [4]=>
    string(8) "27122522"
    [5]=>
    string(8) "27122523"
    [6]=>
    string(8) "27122524"
    [7]=>
    string(8) "27122525"
    [8]=>
    string(8) "27122526"
    [9]=>
    string(8) "27122527"
    [10]=>
    string(8) "27122528"
    [11]=>
    string(8) "27122529"
    [12]=>
    string(8) "27122530"
    [13]=>
    string(8) "27122531"
    [14]=>
    string(8) "27122532"
    [15]=>
    string(8) "27122533"
    [16]=>
    string(8) "27122534"
    [17]=>
    string(8) "27122535"
    [18]=>
    string(8) "27122536"
    [19]=>
    string(8) "27122537"
    [20]=>
    string(8) "27122538"
    [21]=>
    string(8) "27122539"
    [22]=>
    string(8) "27122540"
    [23]=>
    string(8) "27122541"
    [24]=>
    string(8) "27122542"
    [25]=>
    string(8) "27122543"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202518741
        )

    [StreetNumber] => Array
        (
            [0] => 59-555
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Incredible cedar home located in the peaceful and secluded “Sunset Hills” —a highly desired private community in Pupukea, on the North Shore of Oahu. This home sits on more than an acre of land, with beautiful tropical landscape, a 4-car garage, and a greenhouse. The property features a cemented driveway with ample parking space, and is secured by a gated entrance with private code access. The oversized garage is newly renovated with split ACs, large ceiling fans, full insulation, ample space, and a half bath —making it perfect for an indoor gym, workshop, or creative studio. This versatile space adds immense value to the property.
The home itself is equally impressive, with 3 bedrooms, 1 bathroom, kitchen, dining area, laundry room, and a lanai with ocean view. With vaulted ceilings and a warm, inviting, and well-kept space, you will love the cozy cabin feel of this home, as well as waking up to the sound of singing birds. With plenty of land, you’ll love the serenity and natural beauty surrounding this property. The lush, well-maintained lawn offers expansive open space perfect for gardening, entertaining, and room to build future additions.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ElementarySchool] => Array
        (
            [0] => Sunset Beach
        )

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

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

    [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] => 18944132
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-25T16:45:01.320
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-25
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:45:01.320
        )

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

    [listing_image] => Array
        (
            [0] => 27122518
            [1] => 27122519
            [2] => 27122520
            [3] => 27122521
            [4] => 27122522
            [5] => 27122523
            [6] => 27122524
            [7] => 27122525
            [8] => 27122526
            [9] => 27122527
            [10] => 27122528
            [11] => 27122529
            [12] => 27122530
            [13] => 27122531
            [14] => 27122532
            [15] => 27122533
            [16] => 27122534
            [17] => 27122535
            [18] => 27122536
            [19] => 27122537
            [20] => 27122538
            [21] => 27122539
            [22] => 27122540
            [23] => 27122541
            [24] => 27122542
            [25] => 27122543
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 1
• Land Area (sf): 44,561 sf
• Living (sf): 1,454
• Year Built: 2001

KEY FEATURES

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

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Sunset Beach
• Middle School: Kahuku
• High School: Kahuku

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 August 25, 2025 - 4:45 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.