Listing
Overview
Price: $3,880,000
Area: AINA HAINA BEACH
Status: Active
AUCTION: BID 22–31 OCTOBER. Originally Listed For $5.9M. Starting Bid at Auction is now $2.5M. Rare Opportunity To Own Almost 1 Acre Oceanfront – Priced Under Tax Assessor's Value! This unique property features a charming Oceanside Cottage that was fully remodeled in 2020, and also a 29,000 sq ft Commercial Structure that has been home to many historic schools – including The Waldorf School and The Academy – offering versatile space for a variety of creative uses. With the flexibility to enjoy both the cottage and the historic structure, this R-10 zoned lot also offers the potential to reimagine this property into a custom luxury oceanfront estate, or even multiple homes of your design. When you start with an amazing Pacific Ocean view – extending from Aina Haina all the way to Portlock and Hanauma Bay Ridge – the possibilities are endless! Because the commercial structure is non-conforming, the buyer must do all due diligence on permits, zoning capabilities, and acquiring appropriate non-conforming use certificates. Additionally, the actual property configuration does not agree with the public record data, the buyer must do their own due diligence. This property is sold As-Is. Listing by: Aloha Homes LLC (808) 825-4277
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414534"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "5257"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(12) "Kalanianaole"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(130) "https://player.vimeo.com/video/957875297?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3880000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5900000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "AINA HAINA BEACH"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1208) "AUCTION: BID 22–31 OCTOBER. Originally Listed For $5.9M. Starting Bid at Auction is now $2.5M. Rare Opportunity To Own Almost 1 Acre Oceanfront – Priced Under Tax Assessor's Value! This unique property features a charming Oceanside Cottage that was fully remodeled in 2020, and also a 29,000 sq ft Commercial Structure that has been home to many historic schools – including The Waldorf School and The Academy – offering versatile space for a variety of creative uses. With the flexibility to enjoy both the cottage and the historic structure, this R-10 zoned lot also offers the potential to reimagine this property into a custom luxury oceanfront estate, or even multiple homes of your design. When you start with an amazing Pacific Ocean view – extending from Aina Haina all the way to Portlock and Hanauma Bay Ridge – the possibilities are endless! Because the commercial structure is non-conforming, the buyer must do all due diligence on permits, zoning capabilities, and acquiring appropriate non-conforming use certificates. Additionally, the actual property configuration does not agree with the public record data, the buyer must do their own due diligence. This property is sold As-Is."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(15) "Aloha Homes LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "39235.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(22) "Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "stephanie@hawaiidreamhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Stephanie Rae Band"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-03-10T11:36:40.890"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18079518"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-19T09:59:49.223"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26594094"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26594094"
[1]=>
string(8) "26594095"
[2]=>
string(8) "26594096"
[3]=>
string(8) "26594097"
[4]=>
string(8) "26594098"
[5]=>
string(8) "26594099"
[6]=>
string(8) "26594100"
[7]=>
string(8) "26594101"
[8]=>
string(8) "26594102"
[9]=>
string(8) "26594103"
[10]=>
string(8) "26594104"
[11]=>
string(8) "26594105"
[12]=>
string(8) "26594106"
[13]=>
string(8) "26594107"
[14]=>
string(8) "26594108"
[15]=>
string(8) "26594109"
[16]=>
string(8) "26594110"
[17]=>
string(8) "26594111"
[18]=>
string(8) "26594112"
[19]=>
string(8) "26594113"
[20]=>
string(8) "26594114"
[21]=>
string(8) "26594115"
[22]=>
string(8) "26594116"
[23]=>
string(8) "26594117"
[24]=>
string(8) "26594118"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-06-21"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "11:36:40.890"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414534
)
[StreetNumber] => Array
(
[0] => 5257
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kalanianaole
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/957875297?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0
)
[ListPrice] => Array
(
[0] => 3880000.00
)
[CurrentPrice] => Array
(
[0] => 5900000.00
)
[Neighbourhood] => Array
(
[0] => AINA HAINA BEACH
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => AUCTION: BID 22–31 OCTOBER. Originally Listed For $5.9M. Starting Bid at Auction is now $2.5M. Rare Opportunity To Own Almost 1 Acre Oceanfront – Priced Under Tax Assessor's Value! This unique property features a charming Oceanside Cottage that was fully remodeled in 2020, and also a 29,000 sq ft Commercial Structure that has been home to many historic schools – including The Waldorf School and The Academy – offering versatile space for a variety of creative uses. With the flexibility to enjoy both the cottage and the historic structure, this R-10 zoned lot also offers the potential to reimagine this property into a custom luxury oceanfront estate, or even multiple homes of your design. When you start with an amazing Pacific Ocean view – extending from Aina Haina all the way to Portlock and Hanauma Bay Ridge – the possibilities are endless! Because the commercial structure is non-conforming, the buyer must do all due diligence on permits, zoning capabilities, and acquiring appropriate non-conforming use certificates. Additionally, the actual property configuration does not agree with the public record data, the buyer must do their own due diligence. This property is sold As-Is.
)
[ListOfficeName] => Array
(
[0] => Aloha Homes LLC
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 39235.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RMXA
)
[ListAgentEmail] => Array
(
[0] => stephanie@hawaiidreamhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Stephanie Rae Band
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-03-10T11:36:40.890
)
[Matrix_Unique_ID] => Array
(
[0] => 18079518
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-19T09:59:49.223
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26594094
)
[listing_image] => Array
(
[0] => 26594094
[1] => 26594095
[2] => 26594096
[3] => 26594097
[4] => 26594098
[5] => 26594099
[6] => 26594100
[7] => 26594101
[8] => 26594102
[9] => 26594103
[10] => 26594104
[11] => 26594105
[12] => 26594106
[13] => 26594107
[14] => 26594108
[15] => 26594109
[16] => 26594110
[17] => 26594111
[18] => 26594112
[19] => 26594113
[20] => 26594114
[21] => 26594115
[22] => 26594116
[23] => 26594117
[24] => 26594118
)
[ListingContractDate] => Array
(
[0] => 2024-06-21
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:36:40.890
)
)
- Land Area (sf): 39,235 sf
- View: Mountain,Ocean,Sunrise
- Listing Office: Aloha Homes LLC
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on March 10, 2025 - 11:36 AM
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.
