47-509 Hui Iwa Street Kaneohe, HI 96744
Listing
Overview
Price: $1,450,000
Area: CLUB VIEW ESTATE
Status: Active
REDUCED PRICE!! Not only is this home in the best neighborhood, tranquil and serene, but price is now reduced to $1,450,000.
Don't forget this home boasts 16 Solar (PV) panels (owned) with a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! 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 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 beautiful Koolau mountains, where soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more embellish the property.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. Must see to believe. 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) "1450000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "CLUB VIEW ESTATE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1109) "REDUCED PRICE!! Not only is this home in the best neighborhood, tranquil and serene, but price is now reduced to $1,450,000.
Don't forget this home boasts 16 Solar (PV) panels (owned) with a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! 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 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 beautiful Koolau mountains, where soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more embellish the property.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. Must see to believe."
}
["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-07T14:55:56.063"
}
["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] => 1450000.00
)
[CurrentPrice] => Array
(
[0] => 1450000.00
)
[Neighbourhood] => Array
(
[0] => CLUB VIEW ESTATE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => REDUCED PRICE!! Not only is this home in the best neighborhood, tranquil and serene, but price is now reduced to $1,450,000.
Don't forget this home boasts 16 Solar (PV) panels (owned) with a transferable HECO net-metering agreement, keeping electric bills to a minimum. No HOA fees! No Maintenance fees! 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 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 beautiful Koolau mountains, where soft breezes, the gentle song of birds, and the rustling of treasured fruit trees, mountain apple, guava, avocado, banana, papaya and more embellish the property.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. Must see to believe.
)
[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-07T14:55:56.063
)
[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
