Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
68-133 Au Street Unit B Waialua, HI 96791
Listing Overview
Price: $1,499,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 with 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 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 $2,998,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: Compass (808) 306-9742
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428708"
}
["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) "B"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1499000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(973) "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 with 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 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 $2,998,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(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7701.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(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "brittany.fee@compass.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) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18450483"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-24T13:22:11.237"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-24"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:22:11.237"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26815512"
}
["listing_image"]=>
array(3) {
[0]=>
string(8) "26815512"
[1]=>
string(8) "26815513"
[2]=>
string(8) "26815514"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428708
)
[StreetNumber] => Array
(
[0] => 68-133
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => B
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1499000.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 with 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 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 $2,998,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] => Compass
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 7701.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] => COHI
)
[ListAgentEmail] => Array
(
[0] => brittany.fee@compass.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 306-9742
)
[ListAgentFullName] => Array
(
[0] => Brittany V Fee
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18450483
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-24T13:22:11.237
)
[ListingContractDate] => Array
(
[0] => 2024-12-24
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:22:11.237
)
[_thumbnail_id] => Array
(
[0] => 26815512
)
[listing_image] => Array
(
[0] => 26815512
[1] => 26815513
[2] => 26815514
)
)
