53-672 Kamehameha Highway Hauula, HI 96717
Listing
Overview
Price: $498,000
Area: PUNALUU
Status: Active Under Contract
This is a once in a lifetime opportunity to create your dream home! Situated in a countryside town called Hauula on Oahu's North Eastern Shore, that features endless beaches with azure waters. There is a small community center with a few shops and a supermarket in close proximity. Hauula Forest Reserve and many hiking trails are in this area. The 5,977 sqft. lot is surrounded by Koolau Mountains and the beauty of the Pacific Ocean across the street. Listing by: Stott Real Estate, Inc. (808) 254-1515
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414480"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "53-672"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96717"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "498000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "498000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUNALUU"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(453) "This is a once in a lifetime opportunity to create your dream home! Situated in a countryside town called Hauula on Oahu's North Eastern Shore, that features endless beaches with azure waters. There is a small community center with a few shops and a supermarket in close proximity. Hauula Forest Reserve and many hiking trails are in this area. The 5,977 sqft. lot is surrounded by Koolau Mountains and the beauty of the Pacific Ocean across the street."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Stott Real Estate, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5977.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(21) "Mountain,Ocean,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) "SOLD"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "traceystottkelley@stott.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 254-1515"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Tracey Anne Stott Kelley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-25T16:37:23.523"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18078279"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-18T16:31:44.260"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26590432"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26590432"
[1]=>
string(8) "26590433"
[2]=>
string(8) "26590434"
[3]=>
string(8) "26590435"
[4]=>
string(8) "26590436"
[5]=>
string(8) "26590437"
[6]=>
string(8) "26590438"
[7]=>
string(8) "26590439"
[8]=>
string(8) "26590440"
[9]=>
string(8) "26590441"
[10]=>
string(8) "26590442"
[11]=>
string(8) "26590443"
[12]=>
string(8) "26590444"
[13]=>
string(8) "26590445"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414480
)
[StreetNumber] => Array
(
[0] => 53-672
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 498000.00
)
[CurrentPrice] => Array
(
[0] => 498000.00
)
[Neighbourhood] => Array
(
[0] => PUNALUU
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => This is a once in a lifetime opportunity to create your dream home! Situated in a countryside town called Hauula on Oahu's North Eastern Shore, that features endless beaches with azure waters. There is a small community center with a few shops and a supermarket in close proximity. Hauula Forest Reserve and many hiking trails are in this area. The 5,977 sqft. lot is surrounded by Koolau Mountains and the beauty of the Pacific Ocean across the street.
)
[ListOfficeName] => Array
(
[0] => Stott Real Estate, Inc.
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 5977.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => SOLD
)
[ListAgentEmail] => Array
(
[0] => traceystottkelley@stott.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 254-1515
)
[ListAgentFullName] => Array
(
[0] => Tracey Anne Stott Kelley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-25T16:37:23.523
)
[Matrix_Unique_ID] => Array
(
[0] => 18078279
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-18T16:31:44.260
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26590432
)
[listing_image] => Array
(
[0] => 26590432
[1] => 26590433
[2] => 26590434
[3] => 26590435
[4] => 26590436
[5] => 26590437
[6] => 26590438
[7] => 26590439
[8] => 26590440
[9] => 26590441
[10] => 26590442
[11] => 26590443
[12] => 26590444
[13] => 26590445
)
)
- View: Mountain,Ocean,Sunset
- Listing Office: Stott Real Estate, Inc.
- Land Tenure: FS - Fee Simple