Listing
Overview
Price: $899,000
Area: HAUULA
Status: Active Under Contract
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(45) {
["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(144) "https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fwepqwqg%2Funbranded/cUpU/L2q2AQ/AQ/f98691ab-a3b1-4cdd-9f1e-252c8c1872cc/3/E5DFHFSBEo"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "899000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "899000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(576) "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(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-28T09:25:01.433"
}
["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"
}
}
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] => https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fwepqwqg%2Funbranded/cUpU/L2q2AQ/AQ/f98691ab-a3b1-4cdd-9f1e-252c8c1872cc/3/E5DFHFSBEo
)
[ListPrice] => Array
(
[0] => 899000.00
)
[CurrentPrice] => Array
(
[0] => 899000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => 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] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-28T09:25:01.433
)
[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
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,000
- 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