47-411 Mapumapu Road Kaneohe, HI 96744
Listing
Overview
Price: $2,825,000
Area: WAIHEE
Status: Sold
Introducing this remarkable and rarely available country estate, situated on 5.49 acres of sprawling land, where you can indulge in the beautiful landscape overlooking the ocean views and surrounded by the Ko'olau mountain range. Here, you can engage in farming or cultivate an extensive garden. In addition, this estate features a charming kama'aina-style home that has been tastefully remodeled, breathing new life into the residence and creating a place where classic design meets modern comfort. Another standout feature of this property is the lush and thriving mountain apple, avocado, and mango trees during the season. You'll truly enjoy this serene and idyllic setting, just minutes from Windward Mall, farmers' markets, restaurants, movie theaters, He'eia Kea Boat Harbor with various activities offered, and more. Come... breathe, unwind, and savor the simple pleasures of this lifestyle. You won't want to miss this one! Please see the attached property video, floor plan and boundary survey. Tax records do not match actual property details. Listing by: Coldwell Banker Island Prop (808) 875-7000
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202410459"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-411"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Mapumapu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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) "2900000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2825000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "WAIHEE"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1054) "Introducing this remarkable and rarely available country estate, situated on 5.49 acres of sprawling land, where you can indulge in the beautiful landscape overlooking the ocean views and surrounded by the Ko'olau mountain range. Here, you can engage in farming or cultivate an extensive garden. In addition, this estate features a charming kama'aina-style home that has been tastefully remodeled, breathing new life into the residence and creating a place where classic design meets modern comfort. Another standout feature of this property is the lush and thriving mountain apple, avocado, and mango trees during the season. You'll truly enjoy this serene and idyllic setting, just minutes from Windward Mall, farmers' markets, restaurants, movie theaters, He'eia Kea Boat Harbor with various activities offered, and more. Come... breathe, unwind, and savor the simple pleasures of this lifestyle. You won't want to miss this one! Please see the attached property video, floor plan and boundary survey. Tax records do not match actual property details."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Coldwell Banker Island Prop"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "239187.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1784"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1962"
}
["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(15) "One,Split Level"
}
["View"]=>
array(1) {
[0]=>
string(29) "City,Coastline,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Kahaluu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBIP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "susan@susanborochov.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 875-7000"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Susan Borochov"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2024-10-01"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-01T10:03:14.933"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17983509"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-02T16:14:09.790"
}
["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) "26188823"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26188823"
[1]=>
string(8) "26188824"
[2]=>
string(8) "26188825"
[3]=>
string(8) "26188826"
[4]=>
string(8) "26188827"
[5]=>
string(8) "26188828"
[6]=>
string(8) "26188829"
[7]=>
string(8) "26188830"
[8]=>
string(8) "26188831"
[9]=>
string(8) "26188832"
[10]=>
string(8) "26188833"
[11]=>
string(8) "26188834"
[12]=>
string(8) "26188835"
[13]=>
string(8) "26188836"
[14]=>
string(8) "26188837"
[15]=>
string(8) "26188838"
[16]=>
string(8) "26188839"
[17]=>
string(8) "26188840"
[18]=>
string(8) "26188841"
[19]=>
string(8) "26188842"
[20]=>
string(8) "26188843"
[21]=>
string(8) "26188844"
[22]=>
string(8) "26188845"
[23]=>
string(8) "26188846"
[24]=>
string(8) "26188847"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202410459
)
[StreetNumber] => Array
(
[0] => 47-411
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mapumapu
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2900000.00
)
[CurrentPrice] => Array
(
[0] => 2825000.00
)
[Neighbourhood] => Array
(
[0] => WAIHEE
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Introducing this remarkable and rarely available country estate, situated on 5.49 acres of sprawling land, where you can indulge in the beautiful landscape overlooking the ocean views and surrounded by the Ko'olau mountain range. Here, you can engage in farming or cultivate an extensive garden. In addition, this estate features a charming kama'aina-style home that has been tastefully remodeled, breathing new life into the residence and creating a place where classic design meets modern comfort. Another standout feature of this property is the lush and thriving mountain apple, avocado, and mango trees during the season. You'll truly enjoy this serene and idyllic setting, just minutes from Windward Mall, farmers' markets, restaurants, movie theaters, He'eia Kea Boat Harbor with various activities offered, and more. Come... breathe, unwind, and savor the simple pleasures of this lifestyle. You won't want to miss this one! Please see the attached property video, floor plan and boundary survey. Tax records do not match actual property details.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Island Prop
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 239187.00
)
[SqftTotal] => Array
(
[0] => 1784
)
[YearBuilt] => Array
(
[0] => 1962
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => One,Split Level
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahaluu
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => CBIP04
)
[ListAgentEmail] => Array
(
[0] => susan@susanborochov.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 875-7000
)
[ListAgentFullName] => Array
(
[0] => Susan Borochov
)
[CloseDate] => Array
(
[0] => 2024-10-01
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-01T10:03:14.933
)
[Matrix_Unique_ID] => Array
(
[0] => 17983509
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-02T16:14:09.790
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26188823
)
[listing_image] => Array
(
[0] => 26188823
[1] => 26188824
[2] => 26188825
[3] => 26188826
[4] => 26188827
[5] => 26188828
[6] => 26188829
[7] => 26188830
[8] => 26188831
[9] => 26188832
[10] => 26188833
[11] => 26188834
[12] => 26188835
[13] => 26188836
[14] => 26188837
[15] => 26188838
[16] => 26188839
[17] => 26188840
[18] => 26188841
[19] => 26188842
[20] => 26188843
[21] => 26188844
[22] => 26188845
[23] => 26188846
[24] => 26188847
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 239,187
- Living (sf): 1,784
- Year Built: 1962
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: City,Coastline,Mountain,Ocean
- Listing Office: Coldwell Banker Island Prop
- Land Tenure: FS - Fee Simple
- Elementary School: Kahaluu
- Middle School: King
- High School: Castle
