Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
54-298 Hauula Homestead Road Unit B Hauula, HI 96717
Listing
Price: $1,399,000Area: HAUULAStatus: Active
Don't miss out! Beautiful and spacious this home is truly a treasure. Home has granite countertops in kitchen, bathrooms, and office, with maple flooring and walnut cabinetry. Enjoy mountain and ocean views from the upstairs and lanai. Great feature for those hot summer months home has central AC with 30 solar panels. Master bedroom includes a great walk in closet, master bath with handcrafted features, jacuzzi bath and shower. 5 bedroom 4 full bath differs from Tax Records. Possible rental opportunity as well. This property is a must see! Listing by: Prestige Realty LLC (808) 721-8886
array(43) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428649"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-298"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(16) "Hauula Homestead"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "B"
}
["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(10) "1399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(545) "Don't miss out! Beautiful and spacious this home is truly a treasure. Home has granite countertops in kitchen, bathrooms, and office, with maple flooring and walnut cabinetry. Enjoy mountain and ocean views from the upstairs and lanai. Great feature for those hot summer months home has central AC with 30 solar panels. Master bedroom includes a great walk in closet, master bath with handcrafted features, jacuzzi bath and shower. 5 bedroom 4 full bath differs from Tax Records. Possible rental opportunity as well. This property is a must see!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "Prestige Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5300.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3540"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2006"
}
["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) "Two"
}
["View"]=>
array(1) {
[0]=>
string(20) "Mountain,Ocean,Other"
}
["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) "PSTG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(14) "kchen@prllc.us"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 721-8886"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Jianu Chen"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-22T17:00:02.410"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18448740"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-20"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26813786"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26813786"
[1]=>
string(8) "26813787"
[2]=>
string(8) "26813788"
[3]=>
string(8) "26813789"
[4]=>
string(8) "26813790"
[5]=>
string(8) "26813791"
[6]=>
string(8) "26813792"
[7]=>
string(8) "26813793"
[8]=>
string(8) "26813794"
[9]=>
string(8) "26813795"
[10]=>
string(8) "26813796"
[11]=>
string(8) "26813797"
[12]=>
string(8) "26813798"
[13]=>
string(8) "26813799"
[14]=>
string(8) "26813800"
[15]=>
string(8) "26813801"
[16]=>
string(8) "26813802"
[17]=>
string(8) "26813803"
[18]=>
string(8) "26813804"
[19]=>
string(8) "26813805"
[20]=>
string(8) "26813806"
[21]=>
string(8) "26813807"
[22]=>
string(8) "26813808"
[23]=>
string(8) "26813809"
[24]=>
string(8) "26813810"
[25]=>
string(8) "26813811"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428649
)
[StreetNumber] => Array
(
[0] => 54-298
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hauula Homestead
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => B
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1399000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Don't miss out! Beautiful and spacious this home is truly a treasure. Home has granite countertops in kitchen, bathrooms, and office, with maple flooring and walnut cabinetry. Enjoy mountain and ocean views from the upstairs and lanai. Great feature for those hot summer months home has central AC with 30 solar panels. Master bedroom includes a great walk in closet, master bath with handcrafted features, jacuzzi bath and shower. 5 bedroom 4 full bath differs from Tax Records. Possible rental opportunity as well. This property is a must see!
)
[ListOfficeName] => Array
(
[0] => Prestige Realty LLC
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5300.00
)
[SqftTotal] => Array
(
[0] => 3540
)
[YearBuilt] => Array
(
[0] => 2006
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => PSTG
)
[ListAgentEmail] => Array
(
[0] => kchen@prllc.us
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 721-8886
)
[ListAgentFullName] => Array
(
[0] => Jianu Chen
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-22T17:00:02.410
)
[Matrix_Unique_ID] => Array
(
[0] => 18448740
)
[ListingContractDate] => Array
(
[0] => 2024-12-20
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26813786
)
[listing_image] => Array
(
[0] => 26813786
[1] => 26813787
[2] => 26813788
[3] => 26813789
[4] => 26813790
[5] => 26813791
[6] => 26813792
[7] => 26813793
[8] => 26813794
[9] => 26813795
[10] => 26813796
[11] => 26813797
[12] => 26813798
[13] => 26813799
[14] => 26813800
[15] => 26813801
[16] => 26813802
[17] => 26813803
[18] => 26813804
[19] => 26813805
[20] => 26813806
[21] => 26813807
[22] => 26813808
[23] => 26813809
[24] => 26813810
[25] => 26813811
)
)
BedsTotal: 5Full Baths: 4Land Area (sf): 5,300 sfLiving (sf): 3,540Year Built: 2006
Property Condition: Above Average,AverageNumber of Parking Spaces: 3View: Mountain,Ocean,OtherListing Office: Prestige Realty LLC
Land Tenure: FS - Fee Simple
