54-014 Haukoi Place Hauula, HI 96717
Listing
Overview
Price: $1,500,000
Area: HAUULA
Status: Active
This completely renovated Multi-Unit property totals 4,000+ s.f. w/private yards. A roof-top deck affords panoramic ocn & mtn views. Live in one “Unit” and rent out the others! Great rental income! Steps to the beach right-of-way w/access to incredible blue water and reef. Great fishing, diving and kayaking! Enjoy the sunrise and sunset from the roof-top deck or stroll on the beach to Pounders. Just minutes to BYUH and steps to shopping, post office and restaurants. Turtle Bay, golfing and the North Shore beaches are just around the corner! Perfect home for extended family, short &/or long-term Rentals! Fully Furnished~! Lovingly upgraded from top to button, this unique property is a “Must-See to Appreciate." Listing by: Sterman Realty (808) 277-1753
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202503056"
}
["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) "1500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(725) "This completely renovated Multi-Unit property totals 4,000+ s.f. w/private yards. A roof-top deck affords panoramic ocn & mtn views. Live in one “Unit” and rent out the others! Great rental income! Steps to the beach right-of-way w/access to incredible blue water and reef. Great fishing, diving and kayaking! Enjoy the sunrise and sunset from the roof-top deck or stroll on the beach to Pounders. Just minutes to BYUH and steps to shopping, post office and restaurants. Turtle Bay, golfing and the North Shore beaches are just around the corner! Perfect home for extended family, short &/or long-term Rentals! Fully Furnished~! Lovingly upgraded from top to button, this unique property 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) 277-1753"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sandra A Martin"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18520556"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-31T15:29:35.750"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-31"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:29:35.750"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26862904"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26862904"
[1]=>
string(8) "26862905"
[2]=>
string(8) "26862906"
[3]=>
string(8) "26862907"
[4]=>
string(8) "26862908"
[5]=>
string(8) "26862909"
[6]=>
string(8) "26862910"
[7]=>
string(8) "26862911"
[8]=>
string(8) "26862912"
[9]=>
string(8) "26862913"
[10]=>
string(8) "26862914"
[11]=>
string(8) "26862915"
[12]=>
string(8) "26862916"
[13]=>
string(8) "26862917"
[14]=>
string(8) "26862918"
[15]=>
string(8) "26862919"
[16]=>
string(8) "26862920"
[17]=>
string(8) "26862921"
[18]=>
string(8) "26862922"
[19]=>
string(8) "26862923"
[20]=>
string(8) "26862924"
[21]=>
string(8) "26862925"
[22]=>
string(8) "26862926"
[23]=>
string(8) "26862927"
[24]=>
string(8) "26862928"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202503056
)
[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] => 1500000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This completely renovated Multi-Unit property totals 4,000+ s.f. w/private yards. A roof-top deck affords panoramic ocn & mtn views. Live in one “Unit” and rent out the others! Great rental income! Steps to the beach right-of-way w/access to incredible blue water and reef. Great fishing, diving and kayaking! Enjoy the sunrise and sunset from the roof-top deck or stroll on the beach to Pounders. Just minutes to BYUH and steps to shopping, post office and restaurants. Turtle Bay, golfing and the North Shore beaches are just around the corner! Perfect home for extended family, short &/or long-term Rentals! Fully Furnished~! Lovingly upgraded from top to button, this unique property 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) 277-1753
)
[ListAgentFullName] => Array
(
[0] => Sandra A Martin
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18520556
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-31T15:29:35.750
)
[ListingContractDate] => Array
(
[0] => 2025-01-31
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:29:35.750
)
[_thumbnail_id] => Array
(
[0] => 26862904
)
[listing_image] => Array
(
[0] => 26862904
[1] => 26862905
[2] => 26862906
[3] => 26862907
[4] => 26862908
[5] => 26862909
[6] => 26862910
[7] => 26862911
[8] => 26862912
[9] => 26862913
[10] => 26862914
[11] => 26862915
[12] => 26862916
[13] => 26862917
[14] => 26862918
[15] => 26862919
[16] => 26862920
[17] => 26862921
[18] => 26862922
[19] => 26862923
[20] => 26862924
[21] => 26862925
[22] => 26862926
[23] => 26862927
[24] => 26862928
)
)
- BedsTotal: 4
- Full Baths: 5
- Half Baths: 1
- Land Area (sf): 8,105 sf
- 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
