Listing
Overview
Price: $3,620,000
Area: WAIALUA
Status: Active
Large white sandy beachfront property, located in one of the most desired neighborhoods.
The property offers privacy, beauty and lots of space. This 2 bedroom, 2 bath home sits on an amazing 28,793 square foot lot with 84 linear feet of beach frontage. Great ocean views! Spacious kitchen with lots of cabinets and counter spaces. The front and back yards are fully landscaped with tropical plants and flowers creating a serene oceanfront oasis. This property is not only a dream home, but also a smart investment. The lot is very spacious and has a lot of potential for development (at least 2 homes via a CPR or subdivision, subject to approvals).
On new Bike-Path and close to Waialua and Historic Haleiwa Town. Surf, Windsurf, Diving, Boating, Mountain Biking, Horseback Riding and Polo just minutes away. Listing by: Sterman Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202312939"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-393"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(13) "Waialua Beach"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(36) "https://order.akphawaii.com/x1002395"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3620000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3620000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(814) "Large white sandy beachfront property, located in one of the most desired neighborhoods.
The property offers privacy, beauty and lots of space. This 2 bedroom, 2 bath home sits on an amazing 28,793 square foot lot with 84 linear feet of beach frontage. Great ocean views! Spacious kitchen with lots of cabinets and counter spaces. The front and back yards are fully landscaped with tropical plants and flowers creating a serene oceanfront oasis. This property is not only a dream home, but also a smart investment. The lot is very spacious and has a lot of potential for development (at least 2 homes via a CPR or subdivision, subject to approvals).
On new Bike-Path and close to Waialua and Historic Haleiwa Town. Surf, Windsurf, Diving, Boating, Mountain Biking, Horseback Riding and Polo just minutes away."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "28793.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1436"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["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(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "David J Sterman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-29T12:37:49.773"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17362418"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-09T11:23:22.653"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25853493"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25853493"
[1]=>
string(8) "25853494"
[2]=>
string(8) "25853495"
[3]=>
string(8) "25853496"
[4]=>
string(8) "25853497"
[5]=>
string(8) "25853498"
[6]=>
string(8) "25853499"
[7]=>
string(8) "25853500"
[8]=>
string(8) "25853501"
[9]=>
string(8) "25853502"
[10]=>
string(8) "25853503"
[11]=>
string(8) "25853504"
[12]=>
string(8) "25853505"
[13]=>
string(8) "25853506"
[14]=>
string(8) "25853507"
[15]=>
string(8) "25853508"
[16]=>
string(8) "25853509"
[17]=>
string(8) "25853510"
[18]=>
string(8) "25853511"
[19]=>
string(8) "25853512"
[20]=>
string(8) "25853513"
[21]=>
string(8) "25853514"
[22]=>
string(8) "25853515"
[23]=>
string(8) "25853516"
[24]=>
string(8) "25853517"
[25]=>
string(8) "25853518"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202312939
)
[StreetNumber] => Array
(
[0] => 67-393
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waialua Beach
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://order.akphawaii.com/x1002395
)
[ListPrice] => Array
(
[0] => 3620000.00
)
[CurrentPrice] => Array
(
[0] => 3620000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Large white sandy beachfront property, located in one of the most desired neighborhoods.
The property offers privacy, beauty and lots of space. This 2 bedroom, 2 bath home sits on an amazing 28,793 square foot lot with 84 linear feet of beach frontage. Great ocean views! Spacious kitchen with lots of cabinets and counter spaces. The front and back yards are fully landscaped with tropical plants and flowers creating a serene oceanfront oasis. This property is not only a dream home, but also a smart investment. The lot is very spacious and has a lot of potential for development (at least 2 homes via a CPR or subdivision, subject to approvals).
On new Bike-Path and close to Waialua and Historic Haleiwa Town. Surf, Windsurf, Diving, Boating, Mountain Biking, Horseback Riding and Polo just minutes away.
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 28793.00
)
[SqftTotal] => Array
(
[0] => 1436
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => david@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => David J Sterman
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-29T12:37:49.773
)
[Matrix_Unique_ID] => Array
(
[0] => 17362418
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-09T11:23:22.653
)
[_thumbnail_id] => Array
(
[0] => 25853493
)
[listing_image] => Array
(
[0] => 25853493
[1] => 25853494
[2] => 25853495
[3] => 25853496
[4] => 25853497
[5] => 25853498
[6] => 25853499
[7] => 25853500
[8] => 25853501
[9] => 25853502
[10] => 25853503
[11] => 25853504
[12] => 25853505
[13] => 25853506
[14] => 25853507
[15] => 25853508
[16] => 25853509
[17] => 25853510
[18] => 25853511
[19] => 25853512
[20] => 25853513
[21] => 25853514
[22] => 25853515
[23] => 25853516
[24] => 25853517
[25] => 25853518
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 28,793
- Living (sf): 1,436
- Year Built: 1956
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: Coastline,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
