47-509 Hui Iwa Street Kaneohe, HI 96744
Listing
Overview
Price: $1,499,999
Area: CLUB VIEW ESTATE
Status: Active
Nestled in the embrace of the majestic Koolau Mountains sits the perfect home for you, whose landscaping was featured in the Star-Advertiser as the "garden of joy and happiness," July 15, 2013. This 4 bedroom, 3 bath home with 1 bedroom and bath on the main floor, has a large windowed living room with vaulted ceilings, allowing a grand view of the mountains, soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more. Its remodeled kitchen, bathrooms, and Custom Closet Organizers add value along with a BRAND NEW oven and dishwasher. The Rec room is an added bonus for play, work, hobbies, or even hosting Super-Bowl parties and the like. This home boasts 16 Solar (PV) panels (owned) and a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! The Koolau Shopping Center, a City bus stop across Hui Iwa Street, world-class beaches, hiking trails and recreational parks are just a stone throw away, yet never upset the tranquility of this sacred space. FIRST OPEN HOUSE is Sunday 4/28 1-4pm. House is being sold “as is.” Listing by: 20 Degrees North Real Estate (808) 778-9776
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407877"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-509"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Hui Iwa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1499999.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1499999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "CLUB VIEW ESTATE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1167) "Nestled in the embrace of the majestic Koolau Mountains sits the perfect home for you, whose landscaping was featured in the Star-Advertiser as the "garden of joy and happiness," July 15, 2013. This 4 bedroom, 3 bath home with 1 bedroom and bath on the main floor, has a large windowed living room with vaulted ceilings, allowing a grand view of the mountains, soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more. Its remodeled kitchen, bathrooms, and Custom Closet Organizers add value along with a BRAND NEW oven and dishwasher. The Rec room is an added bonus for play, work, hobbies, or even hosting Super-Bowl parties and the like. This home boasts 16 Solar (PV) panels (owned) and a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! The Koolau Shopping Center, a City bus stop across Hui Iwa Street, world-class beaches, hiking trails and recreational parks are just a stone throw away, yet never upset the tranquility of this sacred space. FIRST OPEN HOUSE is Sunday 4/28 1-4pm. House is being sold “as is.”"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "20 Degrees North Real Estate"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6317.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2000"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1978"
}
["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) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "DGRS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "Ui@20DegreesN.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 778-9776"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Cynthia Milles"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-06T09:40:08.910"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17928890"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-25T11:08:21.933"
}
["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) "26179389"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "26179389"
[1]=>
string(8) "26179390"
[2]=>
string(8) "26181101"
[3]=>
string(8) "26181102"
[4]=>
string(8) "26181103"
[5]=>
string(8) "26181104"
[6]=>
string(8) "26181105"
[7]=>
string(8) "26181106"
[8]=>
string(8) "26181107"
[9]=>
string(8) "26181108"
[10]=>
string(8) "26181109"
[11]=>
string(8) "26181110"
[12]=>
string(8) "26181111"
[13]=>
string(8) "26181112"
[14]=>
string(8) "26181113"
[15]=>
string(8) "26181114"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407877
)
[StreetNumber] => Array
(
[0] => 47-509
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hui Iwa
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1499999.00
)
[CurrentPrice] => Array
(
[0] => 1499999.00
)
[Neighbourhood] => Array
(
[0] => CLUB VIEW ESTATE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled in the embrace of the majestic Koolau Mountains sits the perfect home for you, whose landscaping was featured in the Star-Advertiser as the "garden of joy and happiness," July 15, 2013. This 4 bedroom, 3 bath home with 1 bedroom and bath on the main floor, has a large windowed living room with vaulted ceilings, allowing a grand view of the mountains, soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more. Its remodeled kitchen, bathrooms, and Custom Closet Organizers add value along with a BRAND NEW oven and dishwasher. The Rec room is an added bonus for play, work, hobbies, or even hosting Super-Bowl parties and the like. This home boasts 16 Solar (PV) panels (owned) and a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! The Koolau Shopping Center, a City bus stop across Hui Iwa Street, world-class beaches, hiking trails and recreational parks are just a stone throw away, yet never upset the tranquility of this sacred space. FIRST OPEN HOUSE is Sunday 4/28 1-4pm. House is being sold “as is.”
)
[ListOfficeName] => Array
(
[0] => 20 Degrees North Real Estate
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6317.00
)
[SqftTotal] => Array
(
[0] => 2000
)
[YearBuilt] => Array
(
[0] => 1978
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Ahuimanu
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => DGRS
)
[ListAgentEmail] => Array
(
[0] => Ui@20DegreesN.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 778-9776
)
[ListAgentFullName] => Array
(
[0] => Cynthia Milles
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-06T09:40:08.910
)
[Matrix_Unique_ID] => Array
(
[0] => 17928890
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-25T11:08:21.933
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26179389
)
[listing_image] => Array
(
[0] => 26179389
[1] => 26179390
[2] => 26181101
[3] => 26181102
[4] => 26181103
[5] => 26181104
[6] => 26181105
[7] => 26181106
[8] => 26181107
[9] => 26181108
[10] => 26181109
[11] => 26181110
[12] => 26181111
[13] => 26181112
[14] => 26181113
[15] => 26181114
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 6,317
- Living (sf): 2,000
- Year Built: 1978
- Property Condition: Fair
- Number of Parking Spaces: 3
- View: Mountain
- Listing Office: 20 Degrees North Real Estate
- Land Tenure: FS - Fee Simple
- Elementary School: Ahuimanu
- Middle School: King
- High School: Castle
