54-251 Honomu Street Hauula, HI 96717
Listing
Overview
Price: $997,000
Area: HAUULA
Status: Active
Tucked away from the main road, this wonderfully renovated home is the best kept secret you do not want to miss out on! Completely renovated from studs in 2021, this home proudly features new flooring, plumbing, electrical, roofing and a Leased PV contract with Installation scheduled for December. With a wrap around lanai encompassing half of the upper level, ocean and mountain breezes flow through this open concept area freely. Displaying a partial ocean view, the 3 bedroom, 2 bathroom upper level home is bright and airy with a view that is perfect for your morning sunrise fruit bowl or a cool evening BBQ. On the lower level there is a 1 bedroom unit with a full bathroom, and a studio with kitchenette and full bathroom. These units are a definite plus for additional monthly income. Close proximity to Tamura's, Longs Drugs, Post Office, and Hau'ula Elementary School make this is a great location. Listing by: Coldwell Banker Realty (808) 589-6042
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202317085"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-251"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Honomu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "997000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "997000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(915) "Tucked away from the main road, this wonderfully renovated home is the best kept secret you do not want to miss out on! Completely renovated from studs in 2021, this home proudly features new flooring, plumbing, electrical, roofing and a Leased PV contract with Installation scheduled for December. With a wrap around lanai encompassing half of the upper level, ocean and mountain breezes flow through this open concept area freely. Displaying a partial ocean view, the 3 bedroom, 2 bathroom upper level home is bright and airy with a view that is perfect for your morning sunrise fruit bowl or a cool evening BBQ. On the lower level there is a 1 bedroom unit with a full bathroom, and a studio with kitchenette and full bathroom. These units are a definite plus for additional monthly income. Close proximity to Tamura's, Longs Drugs, Post Office, and Hau'ula Elementary School make this is a great location."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6690.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2487"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1965"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(12) "Basement,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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "taniamichelle.mahoni@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 589-6042"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Tania M Mahoni"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-28T10:00:31.413"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17459122"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-24T23:04:40.620"
}
["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) "25883389"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25883389"
[1]=>
string(8) "25883390"
[2]=>
string(8) "25883391"
[3]=>
string(8) "25883392"
[4]=>
string(8) "25883393"
[5]=>
string(8) "25883394"
[6]=>
string(8) "25883395"
[7]=>
string(8) "25883396"
[8]=>
string(8) "25883397"
[9]=>
string(8) "25883398"
[10]=>
string(8) "25883399"
[11]=>
string(8) "25883400"
[12]=>
string(8) "25954672"
[13]=>
string(8) "25954673"
[14]=>
string(8) "25954674"
[15]=>
string(8) "25954675"
[16]=>
string(8) "25954676"
[17]=>
string(8) "25954677"
[18]=>
string(8) "25954678"
[19]=>
string(8) "25954798"
[20]=>
string(8) "25954799"
[21]=>
string(8) "25954800"
[22]=>
string(8) "25954801"
[23]=>
string(8) "25954802"
[24]=>
string(8) "25954803"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202317085
)
[StreetNumber] => Array
(
[0] => 54-251
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Honomu
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 997000.00
)
[CurrentPrice] => Array
(
[0] => 997000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Tucked away from the main road, this wonderfully renovated home is the best kept secret you do not want to miss out on! Completely renovated from studs in 2021, this home proudly features new flooring, plumbing, electrical, roofing and a Leased PV contract with Installation scheduled for December. With a wrap around lanai encompassing half of the upper level, ocean and mountain breezes flow through this open concept area freely. Displaying a partial ocean view, the 3 bedroom, 2 bathroom upper level home is bright and airy with a view that is perfect for your morning sunrise fruit bowl or a cool evening BBQ. On the lower level there is a 1 bedroom unit with a full bathroom, and a studio with kitchenette and full bathroom. These units are a definite plus for additional monthly income. Close proximity to Tamura's, Longs Drugs, Post Office, and Hau'ula Elementary School make this is a great location.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6690.00
)
[SqftTotal] => Array
(
[0] => 2487
)
[YearBuilt] => Array
(
[0] => 1965
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Basement,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] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => taniamichelle.mahoni@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 589-6042
)
[ListAgentFullName] => Array
(
[0] => Tania M Mahoni
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-28T10:00:31.413
)
[Matrix_Unique_ID] => Array
(
[0] => 17459122
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-24T23:04:40.620
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25883389
)
[listing_image] => Array
(
[0] => 25883389
[1] => 25883390
[2] => 25883391
[3] => 25883392
[4] => 25883393
[5] => 25883394
[6] => 25883395
[7] => 25883396
[8] => 25883397
[9] => 25883398
[10] => 25883399
[11] => 25883400
[12] => 25954672
[13] => 25954673
[14] => 25954674
[15] => 25954675
[16] => 25954676
[17] => 25954677
[18] => 25954678
[19] => 25954798
[20] => 25954799
[21] => 25954800
[22] => 25954801
[23] => 25954802
[24] => 25954803
)
)
- BedsTotal: 3
- Full Baths: 4
- Land Area (sf): 6,690
- Living (sf): 2,487
- Year Built: 1965
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain,Ocean,Sunrise
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
