67-419 Waialua Beach Road Waialua, HI 96791
Listing
Overview
Price: $3,475,000
Area: WAIALUA
Status: Active Under Contract
Take a glimpse at this private oceanfront estate in the heart of Waialua with a sandy beach just steps from your door. After a long day surfing and swimming in the ocean or pool, escape upstairs and enjoy this large, spacious home with ocean and mountain views from every room and plenty of space for privacy. Watch the sunset into the horizon from the front deck. If it happens to be raining outside and a pool day isn't possible put your feet up and a movie on in the home theater. This home is the perfect escape for anyone. This will be sold together with the neighboring parcel TMK: 1-6-7-13-32, MLS # 202310636. Don't miss the plat map in the supplements section. Total lot square footage of both TMK's is 24,890. Listing by: BHGRE Advantage Realty N Shore
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202310638"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-419"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3475000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3475000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(726) "Take a glimpse at this private oceanfront estate in the heart of Waialua with a sandy beach just steps from your door. After a long day surfing and swimming in the ocean or pool, escape upstairs and enjoy this large, spacious home with ocean and mountain views from every room and plenty of space for privacy. Watch the sunset into the horizon from the front deck. If it happens to be raining outside and a pool day isn't possible put your feet up and a movie on in the home theater. This home is the perfect escape for anyone. This will be sold together with the neighboring parcel TMK: 1-6-7-13-32, MLS # 202310636. Don't miss the plat map in the supplements section. Total lot square footage of both TMK's is 24,890."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "BHGRE Advantage Realty N Shore"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "12782.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3434"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1992"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(22) "Coastline,Garden,Ocean"
}
["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) "ADNS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "MemeM@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Meme Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-08-28T09:47:31.633"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17315191"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-10T17:14:11.330"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25848729"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "25848729"
[1]=>
string(8) "25848730"
[2]=>
string(8) "25848731"
[3]=>
string(8) "25848732"
[4]=>
string(8) "25848733"
[5]=>
string(8) "25848734"
[6]=>
string(8) "25848735"
[7]=>
string(8) "25848736"
[8]=>
string(8) "25848737"
[9]=>
string(8) "25848738"
[10]=>
string(8) "25848739"
[11]=>
string(8) "25848740"
[12]=>
string(8) "25848741"
[13]=>
string(8) "25848742"
[14]=>
string(8) "25848743"
[15]=>
string(8) "25848744"
[16]=>
string(8) "25848745"
[17]=>
string(8) "25848746"
[18]=>
string(8) "25848747"
[19]=>
string(8) "25848748"
[20]=>
string(8) "25848749"
[21]=>
string(8) "25848750"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202310638
)
[StreetNumber] => Array
(
[0] => 67-419
)
[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] =>
)
[ListPrice] => Array
(
[0] => 3475000.00
)
[CurrentPrice] => Array
(
[0] => 3475000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Take a glimpse at this private oceanfront estate in the heart of Waialua with a sandy beach just steps from your door. After a long day surfing and swimming in the ocean or pool, escape upstairs and enjoy this large, spacious home with ocean and mountain views from every room and plenty of space for privacy. Watch the sunset into the horizon from the front deck. If it happens to be raining outside and a pool day isn't possible put your feet up and a movie on in the home theater. This home is the perfect escape for anyone. This will be sold together with the neighboring parcel TMK: 1-6-7-13-32, MLS # 202310636. Don't miss the plat map in the supplements section. Total lot square footage of both TMK's is 24,890.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty N Shore
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 12782.00
)
[SqftTotal] => Array
(
[0] => 3434
)
[YearBuilt] => Array
(
[0] => 1992
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => MemeM@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Meme Moody
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-08-28T09:47:31.633
)
[Matrix_Unique_ID] => Array
(
[0] => 17315191
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-05-10T17:14:11.330
)
[_thumbnail_id] => Array
(
[0] => 25848729
)
[listing_image] => Array
(
[0] => 25848729
[1] => 25848730
[2] => 25848731
[3] => 25848732
[4] => 25848733
[5] => 25848734
[6] => 25848735
[7] => 25848736
[8] => 25848737
[9] => 25848738
[10] => 25848739
[11] => 25848740
[12] => 25848741
[13] => 25848742
[14] => 25848743
[15] => 25848744
[16] => 25848745
[17] => 25848746
[18] => 25848747
[19] => 25848748
[20] => 25848749
[21] => 25848750
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 3
- Full Baths: 4
- Land Area (sf): 12,782
- Living (sf): 3,434
- Year Built: 1992
- Property Condition: Above Average,Average
- Number of Parking Spaces: 4
- View: Coastline,Garden,Ocean
- Listing Office: BHGRE Advantage Realty N Shore
- Land Tenure: FS - Fee Simple
