The office will be closed on Monday in observance of President's Day and will re-open on Tuesday.
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
)
)