47-495 Hui Aeko Place Kaneohe, HI 96744
Listing
Overview
Price: $1,975,000
Area: AHUIMANU AREA
Status: Active
Lush, private, serene, Ko'olau gem. Fantastic entertaining home with multiple living room spaces & lots of lanais to take in the breeze and greenery. Structure 1 is the main house (3236 SQFT) with upgraded kitchen and bathrooms. The 3 bedroom, 3 bathroom house includes two additional rooms, perfect for guests or home office space. The kitchen was renovated awhile back but well kept by owners. Structure 2 (1728 SQFT), offers valuable potential cash flow with two separate 2/1 & 2/1.5 units behind main home. The two dwellings in the back of the property were just recently renovated in 2024 with brand new kitchens amongst other upgrades to these units. This property could also be a fabulous multigenerational home. Everyone could be together yet have private individual living spaces.
Tucked away at the end of a cul-de-sac this home boasts majestic views of the Ko'olau Mountains and gorgeous waterfalls. Tropical setting with stream at base of property. Property is situated in an ideal location, close to the school and shopping center. Many possibilities with this property, put this on your list to view! Listing by: One Source Realty LLC (808) 780-4190
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202505171"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-495"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Hui Aeko"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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) "1975000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "AHUIMANU AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1123) "Lush, private, serene, Ko'olau gem. Fantastic entertaining home with multiple living room spaces & lots of lanais to take in the breeze and greenery. Structure 1 is the main house (3236 SQFT) with upgraded kitchen and bathrooms. The 3 bedroom, 3 bathroom house includes two additional rooms, perfect for guests or home office space. The kitchen was renovated awhile back but well kept by owners. Structure 2 (1728 SQFT), offers valuable potential cash flow with two separate 2/1 & 2/1.5 units behind main home. The two dwellings in the back of the property were just recently renovated in 2024 with brand new kitchens amongst other upgrades to these units. This property could also be a fabulous multigenerational home. Everyone could be together yet have private individual living spaces.
Tucked away at the end of a cul-de-sac this home boasts majestic views of the Ko'olau Mountains and gorgeous waterfalls. Tropical setting with stream at base of property. Property is situated in an ideal location, close to the school and shopping center. Many possibilities with this property, put this on your list to view!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(21) "One Source Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "15699.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4964"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(21) "Garden,Mountain,Other"
}
["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(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ONES"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "OneSourceRealtyLLC@hotmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 780-4190"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Yan Scherman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18561919"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-23T00:00:01.990"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-18"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Stream/Canal"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "00:00:01.990"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26886983"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26886983"
[1]=>
string(8) "26886984"
[2]=>
string(8) "26886985"
[3]=>
string(8) "26886986"
[4]=>
string(8) "26886987"
[5]=>
string(8) "26886988"
[6]=>
string(8) "26886989"
[7]=>
string(8) "26886990"
[8]=>
string(8) "26886991"
[9]=>
string(8) "26886992"
[10]=>
string(8) "26886993"
[11]=>
string(8) "26886994"
[12]=>
string(8) "26886995"
[13]=>
string(8) "26886996"
[14]=>
string(8) "26886997"
[15]=>
string(8) "26886998"
[16]=>
string(8) "26886999"
[17]=>
string(8) "26887000"
[18]=>
string(8) "26887001"
[19]=>
string(8) "26887002"
[20]=>
string(8) "26887003"
[21]=>
string(8) "26887004"
[22]=>
string(8) "26887005"
[23]=>
string(8) "26887006"
[24]=>
string(8) "26887007"
[25]=>
string(8) "26887008"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202505171
)
[StreetNumber] => Array
(
[0] => 47-495
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hui Aeko
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1975000.00
)
[Neighbourhood] => Array
(
[0] => AHUIMANU AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Lush, private, serene, Ko'olau gem. Fantastic entertaining home with multiple living room spaces & lots of lanais to take in the breeze and greenery. Structure 1 is the main house (3236 SQFT) with upgraded kitchen and bathrooms. The 3 bedroom, 3 bathroom house includes two additional rooms, perfect for guests or home office space. The kitchen was renovated awhile back but well kept by owners. Structure 2 (1728 SQFT), offers valuable potential cash flow with two separate 2/1 & 2/1.5 units behind main home. The two dwellings in the back of the property were just recently renovated in 2024 with brand new kitchens amongst other upgrades to these units. This property could also be a fabulous multigenerational home. Everyone could be together yet have private individual living spaces.
Tucked away at the end of a cul-de-sac this home boasts majestic views of the Ko'olau Mountains and gorgeous waterfalls. Tropical setting with stream at base of property. Property is situated in an ideal location, close to the school and shopping center. Many possibilities with this property, put this on your list to view!
)
[ListOfficeName] => Array
(
[0] => One Source Realty LLC
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 6
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 15699.00
)
[SqftTotal] => Array
(
[0] => 4964
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Ahuimanu
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ONES
)
[ListAgentEmail] => Array
(
[0] => OneSourceRealtyLLC@hotmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 780-4190
)
[ListAgentFullName] => Array
(
[0] => Yan Scherman
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18561919
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-23T00:00:01.990
)
[ListingContractDate] => Array
(
[0] => 2025-02-18
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Stream/Canal
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 00:00:01.990
)
[_thumbnail_id] => Array
(
[0] => 26886983
)
[listing_image] => Array
(
[0] => 26886983
[1] => 26886984
[2] => 26886985
[3] => 26886986
[4] => 26886987
[5] => 26886988
[6] => 26886989
[7] => 26886990
[8] => 26886991
[9] => 26886992
[10] => 26886993
[11] => 26886994
[12] => 26886995
[13] => 26886996
[14] => 26886997
[15] => 26886998
[16] => 26886999
[17] => 26887000
[18] => 26887001
[19] => 26887002
[20] => 26887003
[21] => 26887004
[22] => 26887005
[23] => 26887006
[24] => 26887007
[25] => 26887008
)
)
- BedsTotal: 7
- Full Baths: 6
- Half Baths: 1
- Land Area (sf): 15,699 sf
- Living (sf): 4,964
- Year Built: 1979
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: Garden,Mountain,Other
- Listing Office: One Source Realty LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Ahuimanu
