Listing
Overview
Price: $1,950,000
Area: WAIALUA
Status: Active
BEACHFRONT, DEVELOPMENT OPPORTUNITY, APARTMENT ZONED! Attention Developers this is the moment you have been waiting for! This incredibly rare opportunity to own TWO A-1 APARTMENT ZONED OCEANFRONT PARCELS totaling 15,610 SQ feet on Oahu's famous North Shore. This is a fantastic property special zoning allows many different types of building possibilities. A-1 allows for Low Rise Condominium, Duplex, Multifamily, or Single Family Homes. One of the last vacant land oceanfront A-1 parcels on the north shore. The lots have been well taken care of and are fenced in and cleared out. The views from this oceanfront lot are unparalled boasting white sandy beach and views of sunrise, sunset and mountains...this property has all the features one could want. This is a two parcel CPR both lots A&B TMK: 1-6-8-011-045-0001 & 1-6-8-011-045-0002 are being sold together for a combined price of $3,900,000. *** Parcel has been divided into two lots however CPR needs to be finalized and completed prior to sale if the lots are to be sold individually. Listing by: Berkshire Hathaway HmSvc HI RE (808) 306-9742
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416867"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-133"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(2) "Au"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "A"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(81) "https://player.vimeo.com/video/991934117?h=3afd7c59b3&title=0&byline=0&portrait=0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1045) "BEACHFRONT, DEVELOPMENT OPPORTUNITY, APARTMENT ZONED! Attention Developers this is the moment you have been waiting for! This incredibly rare opportunity to own TWO A-1 APARTMENT ZONED OCEANFRONT PARCELS totaling 15,610 SQ feet on Oahu's famous North Shore. This is a fantastic property special zoning allows many different types of building possibilities. A-1 allows for Low Rise Condominium, Duplex, Multifamily, or Single Family Homes. One of the last vacant land oceanfront A-1 parcels on the north shore. The lots have been well taken care of and are fenced in and cleared out. The views from this oceanfront lot are unparalled boasting white sandy beach and views of sunrise, sunset and mountains...this property has all the features one could want. This is a two parcel CPR both lots A&B TMK: 1-6-8-011-045-0001 & 1-6-8-011-045-0002 are being sold together for a combined price of $3,900,000. *** Parcel has been divided into two lots however CPR needs to be finalized and completed prior to sale if the lots are to be sold individually."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "Berkshire Hathaway HmSvc HI RE"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7909.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(45) "Coastline,Mountain,Ocean,Other,Sunrise,Sunset"
}
["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(6) "BHHR02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "brittanyf@bhhshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 306-9742"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Brittany V Fee"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-01T14:18:20.303"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18150555"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-30T11:24:46.443"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26641355"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26641355"
[1]=>
string(8) "26641356"
[2]=>
string(8) "26641357"
[3]=>
string(8) "26641358"
[4]=>
string(8) "26641359"
[5]=>
string(8) "26641360"
[6]=>
string(8) "26641361"
[7]=>
string(8) "26641362"
[8]=>
string(8) "26641363"
[9]=>
string(8) "26641364"
[10]=>
string(8) "26641365"
[11]=>
string(8) "26641366"
[12]=>
string(8) "26641367"
[13]=>
string(8) "26641368"
[14]=>
string(8) "26641369"
[15]=>
string(8) "26641370"
[16]=>
string(8) "26641371"
[17]=>
string(8) "26641372"
[18]=>
string(8) "26641373"
[19]=>
string(8) "26641374"
[20]=>
string(8) "26644350"
[21]=>
string(8) "26644351"
[22]=>
string(8) "26644352"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416867
)
[StreetNumber] => Array
(
[0] => 68-133
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/991934117?h=3afd7c59b3&title=0&byline=0&portrait=0
)
[ListPrice] => Array
(
[0] => 1950000.00
)
[CurrentPrice] => Array
(
[0] => 1950000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => BEACHFRONT, DEVELOPMENT OPPORTUNITY, APARTMENT ZONED! Attention Developers this is the moment you have been waiting for! This incredibly rare opportunity to own TWO A-1 APARTMENT ZONED OCEANFRONT PARCELS totaling 15,610 SQ feet on Oahu's famous North Shore. This is a fantastic property special zoning allows many different types of building possibilities. A-1 allows for Low Rise Condominium, Duplex, Multifamily, or Single Family Homes. One of the last vacant land oceanfront A-1 parcels on the north shore. The lots have been well taken care of and are fenced in and cleared out. The views from this oceanfront lot are unparalled boasting white sandy beach and views of sunrise, sunset and mountains...this property has all the features one could want. This is a two parcel CPR both lots A&B TMK: 1-6-8-011-045-0001 & 1-6-8-011-045-0002 are being sold together for a combined price of $3,900,000. *** Parcel has been divided into two lots however CPR needs to be finalized and completed prior to sale if the lots are to be sold individually.
)
[ListOfficeName] => Array
(
[0] => Berkshire Hathaway HmSvc HI RE
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 7909.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Other,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => BHHR02
)
[ListAgentEmail] => Array
(
[0] => brittanyf@bhhshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 306-9742
)
[ListAgentFullName] => Array
(
[0] => Brittany V Fee
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-01T14:18:20.303
)
[Matrix_Unique_ID] => Array
(
[0] => 18150555
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-30T11:24:46.443
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26641355
)
[listing_image] => Array
(
[0] => 26641355
[1] => 26641356
[2] => 26641357
[3] => 26641358
[4] => 26641359
[5] => 26641360
[6] => 26641361
[7] => 26641362
[8] => 26641363
[9] => 26641364
[10] => 26641365
[11] => 26641366
[12] => 26641367
[13] => 26641368
[14] => 26641369
[15] => 26641370
[16] => 26641371
[17] => 26641372
[18] => 26641373
[19] => 26641374
[20] => 26644350
[21] => 26644351
[22] => 26644352
)
)
- View: Coastline,Mountain,Ocean,Other,Sunrise,Sunset
- Listing Office: Berkshire Hathaway HmSvc HI RE
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 1, 2024 - 2:18 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.
