54-233 Kamehameha Highway Hauula, HI 96717
Listing
Overview
Price: $799,000
Area: HAUULA
Status: Sold
Back on Market! This almost beach front two story home with spacious covered lanai's in Hauula has many possibilities In addition, ocean views and magnificent sunrises to enjoy with your early morning cup of coffee. Upstairs has 3 bedrooms two baths with a full kitchen and downstairs two recreation rooms, a bath and a wet bar with an option for a full kitchen. The property is close to the Polynesian Cultural Center, BYU and a short drive to Turtle Bay and the North Shore. There are hiking trails and beautiful beaches to enjoy, too.
The property to be sold in "as is" condition. Listing by: Fidelity Properties (808) 239-3961
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415240"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-233"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["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) "799000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "799000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(593) "Back on Market! This almost beach front two story home with spacious covered lanai's in Hauula has many possibilities In addition, ocean views and magnificent sunrises to enjoy with your early morning cup of coffee. Upstairs has 3 bedrooms two baths with a full kitchen and downstairs two recreation rooms, a bath and a wet bar with an option for a full kitchen. The property is close to the Polynesian Cultural Center, BYU and a short drive to Turtle Bay and the North Shore. There are hiking trails and beautiful beaches to enjoy, too.
The property to be sold in "as is" condition."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "Fidelity Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1536"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1935"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(22) "Mountain,Ocean,Sunrise"
}
["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) "FIDE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "Gail@FidelityPropertiesHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 239-3961"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Gail A Kosiorek"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-02-06"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-06T08:56:25.953"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18104137"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-05T09:18:37.483"
}
["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) "26611198"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26611198"
[1]=>
string(8) "26611199"
[2]=>
string(8) "26611200"
[3]=>
string(8) "26611201"
[4]=>
string(8) "26611202"
[5]=>
string(8) "26611203"
[6]=>
string(8) "26611204"
[7]=>
string(8) "26611205"
[8]=>
string(8) "26611206"
[9]=>
string(8) "26611207"
[10]=>
string(8) "26611208"
[11]=>
string(8) "26611209"
[12]=>
string(8) "26611210"
[13]=>
string(8) "26611211"
[14]=>
string(8) "26611212"
[15]=>
string(8) "26611213"
[16]=>
string(8) "26611214"
[17]=>
string(8) "26611215"
[18]=>
string(8) "26611216"
[19]=>
string(8) "26611217"
[20]=>
string(8) "26611218"
[21]=>
string(8) "26611219"
[22]=>
string(8) "26611220"
[23]=>
string(8) "26611221"
[24]=>
string(8) "26611222"
[25]=>
string(8) "26611223"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-07-05"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:56:25.953"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415240
)
[StreetNumber] => Array
(
[0] => 54-233
)
[PropertyType] => Array
(
[0] => Single Family
)
[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] => 799000.00
)
[CurrentPrice] => Array
(
[0] => 799000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Back on Market! This almost beach front two story home with spacious covered lanai's in Hauula has many possibilities In addition, ocean views and magnificent sunrises to enjoy with your early morning cup of coffee. Upstairs has 3 bedrooms two baths with a full kitchen and downstairs two recreation rooms, a bath and a wet bar with an option for a full kitchen. The property is close to the Polynesian Cultural Center, BYU and a short drive to Turtle Bay and the North Shore. There are hiking trails and beautiful beaches to enjoy, too.
The property to be sold in "as is" condition.
)
[ListOfficeName] => Array
(
[0] => Fidelity Properties
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5000.00
)
[SqftTotal] => Array
(
[0] => 1536
)
[YearBuilt] => Array
(
[0] => 1935
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hauula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => FIDE
)
[ListAgentEmail] => Array
(
[0] => Gail@FidelityPropertiesHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 239-3961
)
[ListAgentFullName] => Array
(
[0] => Gail A Kosiorek
)
[CloseDate] => Array
(
[0] => 2025-02-06
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-06T08:56:25.953
)
[Matrix_Unique_ID] => Array
(
[0] => 18104137
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-05T09:18:37.483
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26611198
)
[listing_image] => Array
(
[0] => 26611198
[1] => 26611199
[2] => 26611200
[3] => 26611201
[4] => 26611202
[5] => 26611203
[6] => 26611204
[7] => 26611205
[8] => 26611206
[9] => 26611207
[10] => 26611208
[11] => 26611209
[12] => 26611210
[13] => 26611211
[14] => 26611212
[15] => 26611213
[16] => 26611214
[17] => 26611215
[18] => 26611216
[19] => 26611217
[20] => 26611218
[21] => 26611219
[22] => 26611220
[23] => 26611221
[24] => 26611222
[25] => 26611223
)
[ListingContractDate] => Array
(
[0] => 2024-07-05
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:56:25.953
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,000 sf
- Living (sf): 1,536
- Year Built: 1935
- Property Condition: Above Average,Average
- Number of Parking Spaces: 3
- View: Mountain,Ocean,Sunrise
- Listing Office: Fidelity Properties
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
