54-229A Kamehameha Highway Hauula, HI 96717
Listing
Overview
Price: $759,900
Area: HAUULA
Status: Active Under Contract
Rare opportunity to own this ocean front detached single family property in Hauula. With a little elbow grease and lots of imagination, you can turn this hidden gem, into the perfect getaway home. Submit your offer now and wake up, with a view of the ocean right in your backyard. Property is bank owned. City and County Code violations exist, which may be substantial. Buyers are encouraged to do their due diligence prior to bidding. Buyer will be required to sign a Hold Harmless agreement accepting the code violations and fines. Listing by: Vylla Home (808) 799-9699
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202310824"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "54-229A"
}
["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) "759900.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "759900.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(533) "Rare opportunity to own this ocean front detached single family property in Hauula. With a little elbow grease and lots of imagination, you can turn this hidden gem, into the perfect getaway home. Submit your offer now and wake up, with a view of the ocean right in your backyard. Property is bank owned. City and County Code violations exist, which may be substantial. Buyers are encouraged to do their due diligence prior to bidding. Buyer will be required to sign a Hold Harmless agreement accepting the code violations and fines."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "Vylla Home"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8903.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1234"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1937"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(24) "Coastline,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "VYLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "edyton.tumbaga@vylla.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 799-9699"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(20) "Edyton F Tumbaga Jr."
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-08T10:42:27.580"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17320425"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-15T09:38:12.300"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25849322"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "25849322"
[1]=>
string(8) "25849323"
[2]=>
string(8) "25849324"
[3]=>
string(8) "25849325"
[4]=>
string(8) "25849326"
[5]=>
string(8) "25849327"
[6]=>
string(8) "25849328"
[7]=>
string(8) "25849329"
[8]=>
string(8) "25849330"
[9]=>
string(8) "25849331"
[10]=>
string(8) "25849332"
[11]=>
string(8) "25849333"
[12]=>
string(8) "25849334"
[13]=>
string(8) "25849335"
[14]=>
string(8) "25849336"
[15]=>
string(8) "25849337"
[16]=>
string(8) "25849338"
[17]=>
string(8) "25849339"
[18]=>
string(8) "25849340"
[19]=>
string(8) "25849341"
[20]=>
string(8) "25849342"
[21]=>
string(8) "25849343"
[22]=>
string(8) "25849344"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(10) "Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(11) "Lender Sale"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202310824
)
[StreetNumber] => Array
(
[0] => 54-229A
)
[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] => 759900.00
)
[CurrentPrice] => Array
(
[0] => 759900.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Rare opportunity to own this ocean front detached single family property in Hauula. With a little elbow grease and lots of imagination, you can turn this hidden gem, into the perfect getaway home. Submit your offer now and wake up, with a view of the ocean right in your backyard. Property is bank owned. City and County Code violations exist, which may be substantial. Buyers are encouraged to do their due diligence prior to bidding. Buyer will be required to sign a Hold Harmless agreement accepting the code violations and fines.
)
[ListOfficeName] => Array
(
[0] => Vylla Home
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8903.00
)
[SqftTotal] => Array
(
[0] => 1234
)
[YearBuilt] => Array
(
[0] => 1937
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => VYLL
)
[ListAgentEmail] => Array
(
[0] => edyton.tumbaga@vylla.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 799-9699
)
[ListAgentFullName] => Array
(
[0] => Edyton F Tumbaga Jr.
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-08T10:42:27.580
)
[Matrix_Unique_ID] => Array
(
[0] => 17320425
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-05-15T09:38:12.300
)
[_thumbnail_id] => Array
(
[0] => 25849322
)
[listing_image] => Array
(
[0] => 25849322
[1] => 25849323
[2] => 25849324
[3] => 25849325
[4] => 25849326
[5] => 25849327
[6] => 25849328
[7] => 25849329
[8] => 25849330
[9] => 25849331
[10] => 25849332
[11] => 25849333
[12] => 25849334
[13] => 25849335
[14] => 25849336
[15] => 25849337
[16] => 25849338
[17] => 25849339
[18] => 25849340
[19] => 25849341
[20] => 25849342
[21] => 25849343
[22] => 25849344
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Waterfront
)
[SpecialListingConditions] => Array
(
[0] => Lender Sale
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 8,903
- Living (sf): 1,234
- Year Built: 1937
- Property Condition: Fair
- Number of Parking Spaces: 3
- View: Coastline,Mountain,Ocean
- Listing Office: Vylla Home
- Land Tenure: FS - Fee Simple
