54-014 Haukoi Place Hauula, HI 96717
Listing
Overview
Price: $1,775,000
Area: HAUULA
Status: Active
Price reduced by $100k. Sellers says SELL! This beautiful renovated home has nearly 4,000 square feet of interior space and large segregated yards. A bonus is the rooftop storage which has a 360 degree view. This multi-generation property allows you to reside in an owner’s quarters and rent out the other spaces as it generate excellent rental income. Complete with separate laundry, bathroom and culinary facilities. Steps to the beach right of way the shore includes access to an outer reef with various species of marine life to include monk seals and turtles. Kid friendly and family oriented as there are areas to entertain play, fish as well as to enjoy the sunrises and sunsets from the rooftop deck. A leisure stroll to Pounders Beach and just minutes to the Polynesian Cultural Center and BYUH. Close to shopping, post office and restaurants. Short drive to Turtle Bay Resort, golfing and the famous surfing beaches of the North Shore. Perfect home for extended family visitors or tenants.The possibilities are endless. Lovingly upgraded from top to button, this unique,“as is,”custom renovated home is a must see to appreciate. Listing by: Sterman Realty (808) 637-6200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415625"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-014"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Haukoi"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(10) "1775000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1775000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1144) "Price reduced by $100k. Sellers says SELL! This beautiful renovated home has nearly 4,000 square feet of interior space and large segregated yards. A bonus is the rooftop storage which has a 360 degree view. This multi-generation property allows you to reside in an owner’s quarters and rent out the other spaces as it generate excellent rental income. Complete with separate laundry, bathroom and culinary facilities. Steps to the beach right of way the shore includes access to an outer reef with various species of marine life to include monk seals and turtles. Kid friendly and family oriented as there are areas to entertain play, fish as well as to enjoy the sunrises and sunsets from the rooftop deck. A leisure stroll to Pounders Beach and just minutes to the Polynesian Cultural Center and BYUH. Close to shopping, post office and restaurants. Short drive to Turtle Bay Resort, golfing and the famous surfing beaches of the North Shore. Perfect home for extended family visitors or tenants.The possibilities are endless. Lovingly upgraded from top to button, this unique,“as is,”custom renovated home is a must see to appreciate."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8105.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4625"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1967"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(52) "Coastline,Garden,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(6) "Hauula"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "Sandra@Sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 637-6200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sandra A Martin"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-22T06:29:01.300"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18116036"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-09T17:49:12.227"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26615899"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26615899"
[1]=>
string(8) "26615900"
[2]=>
string(8) "26615901"
[3]=>
string(8) "26615902"
[4]=>
string(8) "26615903"
[5]=>
string(8) "26615904"
[6]=>
string(8) "26615905"
[7]=>
string(8) "26615906"
[8]=>
string(8) "26615907"
[9]=>
string(8) "26615908"
[10]=>
string(8) "26615909"
[11]=>
string(8) "26615910"
[12]=>
string(8) "26615911"
[13]=>
string(8) "26615912"
[14]=>
string(8) "26615913"
[15]=>
string(8) "26615914"
[16]=>
string(8) "26615915"
[17]=>
string(8) "26615916"
[18]=>
string(8) "26615917"
[19]=>
string(8) "26615918"
[20]=>
string(8) "26615919"
[21]=>
string(8) "26615920"
[22]=>
string(8) "26615921"
[23]=>
string(8) "26615922"
[24]=>
string(8) "26615923"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415625
)
[StreetNumber] => Array
(
[0] => 54-014
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Haukoi
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1775000.00
)
[CurrentPrice] => Array
(
[0] => 1775000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Price reduced by $100k. Sellers says SELL! This beautiful renovated home has nearly 4,000 square feet of interior space and large segregated yards. A bonus is the rooftop storage which has a 360 degree view. This multi-generation property allows you to reside in an owner’s quarters and rent out the other spaces as it generate excellent rental income. Complete with separate laundry, bathroom and culinary facilities. Steps to the beach right of way the shore includes access to an outer reef with various species of marine life to include monk seals and turtles. Kid friendly and family oriented as there are areas to entertain play, fish as well as to enjoy the sunrises and sunsets from the rooftop deck. A leisure stroll to Pounders Beach and just minutes to the Polynesian Cultural Center and BYUH. Close to shopping, post office and restaurants. Short drive to Turtle Bay Resort, golfing and the famous surfing beaches of the North Shore. Perfect home for extended family visitors or tenants.The possibilities are endless. Lovingly upgraded from top to button, this unique,“as is,”custom renovated home is a must see to appreciate.
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 8105.00
)
[SqftTotal] => Array
(
[0] => 4625
)
[YearBuilt] => Array
(
[0] => 1967
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 7
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Other,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hauula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => Sandra@Sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 637-6200
)
[ListAgentFullName] => Array
(
[0] => Sandra A Martin
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-22T06:29:01.300
)
[Matrix_Unique_ID] => Array
(
[0] => 18116036
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-09T17:49:12.227
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26615899
)
[listing_image] => Array
(
[0] => 26615899
[1] => 26615900
[2] => 26615901
[3] => 26615902
[4] => 26615903
[5] => 26615904
[6] => 26615905
[7] => 26615906
[8] => 26615907
[9] => 26615908
[10] => 26615909
[11] => 26615910
[12] => 26615911
[13] => 26615912
[14] => 26615913
[15] => 26615914
[16] => 26615915
[17] => 26615916
[18] => 26615917
[19] => 26615918
[20] => 26615919
[21] => 26615920
[22] => 26615921
[23] => 26615922
[24] => 26615923
)
)
- BedsTotal: 4
- Full Baths: 5
- Half Baths: 1
- Land Area (sf): 8,105
- Living (sf): 4,625
- Year Built: 1967
- Property Condition: Excellent
- Number of Parking Spaces: 7
- View: Coastline,Garden,Mountain,Ocean,Other,Sunrise,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
