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
