Listing
Overview
Price: $2,350,000
Area: HALEIWA
Status: Active
Move-in ready with intentionally curated design, this fully renovated 3-bed, 3-bath home near Fresh Airs Beach and North Shore’s top surf breaks blends luxury, comfort, and modern coastal living. A chef’s kitchen perfect for entertaining featuring high-end appliances, two farmhouse sinks, two dishwashers, drink cooler and freezer drawers, quartzite waterfall island, and a large sliding glass door that connects the bright interior to a 390 sqft covered outdoor living area with beautiful cement slab flooring, two ceiling fans, and a pass-through window, creating a seamless indoor-outdoor flow. Two ensuite bedrooms with sizable walk-in closets plus a well appointed guest room and full guest bath with a Carrera marble walk-in shower. Additionally the private upstairs primary bedroom includes its own full sized washer/dryer, walk in shower and double sink vanity. The property also has a detached bonus office with window A/C, solar panels and generator hookup, ideal for creative space or remote work—even during power outages. Other highlights include outdoor shower, remote-controlled sliding gate, covered 2-car carport, grassy front yard, and an additional washer/dryer. Listing by: Sterman Realty (808) 371-4622
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202515145"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-024"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Alapii"
}
["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(60) "https://my.matterport.com/show/?m=kz3x5L716oi&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2350000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1188) "Move-in ready with intentionally curated design, this fully renovated 3-bed, 3-bath home near Fresh Airs Beach and North Shore’s top surf breaks blends luxury, comfort, and modern coastal living. A chef’s kitchen perfect for entertaining featuring high-end appliances, two farmhouse sinks, two dishwashers, drink cooler and freezer drawers, quartzite waterfall island, and a large sliding glass door that connects the bright interior to a 390 sqft covered outdoor living area with beautiful cement slab flooring, two ceiling fans, and a pass-through window, creating a seamless indoor-outdoor flow. Two ensuite bedrooms with sizable walk-in closets plus a well appointed guest room and full guest bath with a Carrera marble walk-in shower. Additionally the private upstairs primary bedroom includes its own full sized washer/dryer, walk in shower and double sink vanity. The property also has a detached bonus office with window A/C, solar panels and generator hookup, ideal for creative space or remote work—even during power outages. Other highlights include outdoor shower, remote-controlled sliding gate, covered 2-car carport, grassy front yard, and an additional washer/dryer."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5006.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1814"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1959"
}
["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(5) "Other"
}
["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) "18839160"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-13T17:00:02.093"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-07-02"
}
["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) "17:00:02.093"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27054270"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27054270"
[1]=>
string(8) "27054271"
[2]=>
string(8) "27054272"
[3]=>
string(8) "27054273"
[4]=>
string(8) "27054274"
[5]=>
string(8) "27054275"
[6]=>
string(8) "27054276"
[7]=>
string(8) "27054277"
[8]=>
string(8) "27054278"
[9]=>
string(8) "27054279"
[10]=>
string(8) "27054280"
[11]=>
string(8) "27054281"
[12]=>
string(8) "27054282"
[13]=>
string(8) "27054283"
[14]=>
string(8) "27054284"
[15]=>
string(8) "27054285"
[16]=>
string(8) "27054286"
[17]=>
string(8) "27054287"
[18]=>
string(8) "27054288"
[19]=>
string(8) "27054289"
[20]=>
string(8) "27054290"
[21]=>
string(8) "27054291"
[22]=>
string(8) "27054292"
[23]=>
string(8) "27054293"
[24]=>
string(8) "27054294"
[25]=>
string(8) "27054295"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202515145
)
[StreetNumber] => Array
(
[0] => 66-024
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Alapii
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=kz3x5L716oi&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 2350000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Move-in ready with intentionally curated design, this fully renovated 3-bed, 3-bath home near Fresh Airs Beach and North Shore’s top surf breaks blends luxury, comfort, and modern coastal living. A chef’s kitchen perfect for entertaining featuring high-end appliances, two farmhouse sinks, two dishwashers, drink cooler and freezer drawers, quartzite waterfall island, and a large sliding glass door that connects the bright interior to a 390 sqft covered outdoor living area with beautiful cement slab flooring, two ceiling fans, and a pass-through window, creating a seamless indoor-outdoor flow. Two ensuite bedrooms with sizable walk-in closets plus a well appointed guest room and full guest bath with a Carrera marble walk-in shower. Additionally the private upstairs primary bedroom includes its own full sized washer/dryer, walk in shower and double sink vanity. The property also has a detached bonus office with window A/C, solar panels and generator hookup, ideal for creative space or remote work—even during power outages. Other highlights include outdoor shower, remote-controlled sliding gate, covered 2-car carport, grassy front yard, and an additional washer/dryer.
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5006.00
)
[SqftTotal] => Array
(
[0] => 1814
)
[YearBuilt] => Array
(
[0] => 1959
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Other
)
[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] => 18839160
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-13T17:00:02.093
)
[ListingContractDate] => Array
(
[0] => 2025-07-02
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.093
)
[_thumbnail_id] => Array
(
[0] => 27054270
)
[listing_image] => Array
(
[0] => 27054270
[1] => 27054271
[2] => 27054272
[3] => 27054273
[4] => 27054274
[5] => 27054275
[6] => 27054276
[7] => 27054277
[8] => 27054278
[9] => 27054279
[10] => 27054280
[11] => 27054281
[12] => 27054282
[13] => 27054283
[14] => 27054284
[15] => 27054285
[16] => 27054286
[17] => 27054287
[18] => 27054288
[19] => 27054289
[20] => 27054290
[21] => 27054291
[22] => 27054292
[23] => 27054293
[24] => 27054294
[25] => 27054295
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,006 sf
- Living (sf): 1,814
- Year Built: 1959
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Other
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Haleiwa
- Middle School: Waialua
- High School: Waialua
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 13, 2025 - 5:00 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.
© Marcus Realty. All Rights Reserved.
