Our office will be closed on Monday, November 11th, 2024.
1042 Hui Street Kailua, HI 96734
Listing Overview
Price: $1,275,000 Area: KEOLU HILLS Status: Active
Discover the charm of this 4-bed, 2-bath Kailua home located in Keolu Hills and 16 owned PV panels. This traditional three-bedroom, one-bath residence offers a peaceful retreat with much of the original hardwood flooring throughout. The kitchen features the original hardwood cabinets and a classic cooktop, adding a touch of nostalgia. For added convenience, a generously sized enclosed patio off the kitchen and carport provides a versatile space for entertaining or relaxation. Enjoy the comfort of an additional bathroom in the rec room area, ensuring privacy for homeowners and guests. Upstairs, the fourth bedroom offers breathtaking views of the Hillside and across Enchanted Lake. Step outside the rec room to a fully-fenced yard with a workshop/storage and ample space for gardening and plant rearing. The yard space provides an outdoor haven for enjoying an indoor/outdoor lifestyle. This fabulous location is close to stores and restaurants in the Enchanted Lake & Keolu Shopping Centers and provides easy access to highways. Customize this timeless home with solid construction! Notes: The property is being sold as is, property tax and MLS records do not match, and this is a trust sale. Listing by: Homes of Hawai'i Real Estate (808) 284-2076
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421308"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1042"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(3) "Hui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96734"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1275000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1275000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "KEOLU HILLS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Discover the charm of this 4-bed, 2-bath Kailua home located in Keolu Hills and 16 owned PV panels. This traditional three-bedroom, one-bath residence offers a peaceful retreat with much of the original hardwood flooring throughout. The kitchen features the original hardwood cabinets and a classic cooktop, adding a touch of nostalgia. For added convenience, a generously sized enclosed patio off the kitchen and carport provides a versatile space for entertaining or relaxation. Enjoy the comfort of an additional bathroom in the rec room area, ensuring privacy for homeowners and guests. Upstairs, the fourth bedroom offers breathtaking views of the Hillside and across Enchanted Lake. Step outside the rec room to a fully-fenced yard with a workshop/storage and ample space for gardening and plant rearing. The yard space provides an outdoor haven for enjoying an indoor/outdoor lifestyle. This fabulous location is close to stores and restaurants in the Enchanted Lake & Keolu Shopping Centers and provides easy access to highways. Customize this timeless home with solid construction! Notes: The property is being sold as is, property tax and MLS records do not match, and this is a trust sale."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Homes of Hawai'i Real Estate"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7511.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2111"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["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) "HHRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "jillward808@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 284-2076"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Jill M Ward"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-13T17:00:01.657"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18269020"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-25T13:11:00.387"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(12) "Lien Release"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26707527"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26707527"
[1]=>
string(8) "26707528"
[2]=>
string(8) "26707529"
[3]=>
string(8) "26707530"
[4]=>
string(8) "26707531"
[5]=>
string(8) "26707532"
[6]=>
string(8) "26707533"
[7]=>
string(8) "26707534"
[8]=>
string(8) "26707535"
[9]=>
string(8) "26707536"
[10]=>
string(8) "26707537"
[11]=>
string(8) "26707538"
[12]=>
string(8) "26707539"
[13]=>
string(8) "26707540"
[14]=>
string(8) "26707541"
[15]=>
string(8) "26707542"
[16]=>
string(8) "26707543"
[17]=>
string(8) "26707544"
[18]=>
string(8) "26707545"
[19]=>
string(8) "26707546"
[20]=>
string(8) "26707547"
[21]=>
string(8) "26707548"
[22]=>
string(8) "26707549"
[23]=>
string(8) "26707550"
[24]=>
string(8) "26707551"
[25]=>
string(8) "26707552"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421308
)
[StreetNumber] => Array
(
[0] => 1042
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hui
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kailua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96734
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1275000.00
)
[CurrentPrice] => Array
(
[0] => 1275000.00
)
[Neighbourhood] => Array
(
[0] => KEOLU HILLS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the charm of this 4-bed, 2-bath Kailua home located in Keolu Hills and 16 owned PV panels. This traditional three-bedroom, one-bath residence offers a peaceful retreat with much of the original hardwood flooring throughout. The kitchen features the original hardwood cabinets and a classic cooktop, adding a touch of nostalgia. For added convenience, a generously sized enclosed patio off the kitchen and carport provides a versatile space for entertaining or relaxation. Enjoy the comfort of an additional bathroom in the rec room area, ensuring privacy for homeowners and guests. Upstairs, the fourth bedroom offers breathtaking views of the Hillside and across Enchanted Lake. Step outside the rec room to a fully-fenced yard with a workshop/storage and ample space for gardening and plant rearing. The yard space provides an outdoor haven for enjoying an indoor/outdoor lifestyle. This fabulous location is close to stores and restaurants in the Enchanted Lake & Keolu Shopping Centers and provides easy access to highways. Customize this timeless home with solid construction! Notes: The property is being sold as is, property tax and MLS records do not match, and this is a trust sale.
)
[ListOfficeName] => Array
(
[0] => Homes of Hawai'i Real Estate
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7511.00
)
[SqftTotal] => Array
(
[0] => 2111
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HHRE
)
[ListAgentEmail] => Array
(
[0] => jillward808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 284-2076
)
[ListAgentFullName] => Array
(
[0] => Jill M Ward
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-13T17:00:01.657
)
[Matrix_Unique_ID] => Array
(
[0] => 18269020
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-25T13:11:00.387
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => Lien Release
)
[_thumbnail_id] => Array
(
[0] => 26707527
)
[listing_image] => Array
(
[0] => 26707527
[1] => 26707528
[2] => 26707529
[3] => 26707530
[4] => 26707531
[5] => 26707532
[6] => 26707533
[7] => 26707534
[8] => 26707535
[9] => 26707536
[10] => 26707537
[11] => 26707538
[12] => 26707539
[13] => 26707540
[14] => 26707541
[15] => 26707542
[16] => 26707543
[17] => 26707544
[18] => 26707545
[19] => 26707546
[20] => 26707547
[21] => 26707548
[22] => 26707549
[23] => 26707550
[24] => 26707551
[25] => 26707552
)
)
