47-358 Mahakea Road Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $1,790,000
Area: KAALAEA
Status: Active

Welcome to your private oasis in the lush Kaalaea in Kaneohe. This stunning + expansive property sits on nearly an acre of serene and private land in a desirable and rarely available neighborhood. Meticulously renovated to the highest level, this home seamlessly blends modern design with the tranquility of island living. The home is adorned with contemporary finishes, showcasing a keen attention to detail that elevates every room. Designed with versatility in mind, this property includes a 3-bedroom 3-bath home plus a separate two-bedroom, one-bathroom living area with its own entrance and wet bar. Whether you envision a space for multigenerational living or seek potential rental income, this flexible option caters to a variety of lifestyles and needs. Outside, the expansive lot offers privacy and more than enough space for a garden or farm. The upper level of the lot + country zoning offers the possibility for an additional dwelling with ocean views. Surrounded by lush greenery, the possibilities are endless for expansion and enjoying the outdoors. Listing by: Compass (808) 825-4277

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202423495"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-358"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Mahakea"
  }
  ["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(98) "https://player.vimeo.com/video/1017532359?badge=0&autopause=0&player_id=0&app_id=58479"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1790000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1790000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAALAEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1071) "Welcome to your private oasis in the lush Kaalaea in Kaneohe. This stunning + expansive property sits on nearly an acre of serene and private land in a desirable and rarely available neighborhood. Meticulously renovated to the highest level, this home seamlessly blends modern design with the tranquility of island living.

The home is adorned with contemporary finishes, showcasing a keen attention to detail that elevates every room. Designed with versatility in mind, this property includes a 3-bedroom 3-bath home plus a separate two-bedroom, one-bathroom living area with its own entrance and wet bar. Whether you envision a space for multigenerational living or seek potential rental income, this flexible option caters to a variety of lifestyles and needs.

Outside, the expansive lot offers privacy and more than enough space for a garden or farm. The upper level of the lot + country zoning offers the possibility for an additional dwelling with ocean views. Surrounded by lush greenery, the possibilities are endless for expansion and enjoying the outdoors."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "43551.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["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) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "sean@yanogroup.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Sean S Yano"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-24T17:00:01.623"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18312555"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-08T15:11:30.370"
  }
  ["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) "26723519"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26723519"
    [1]=>
    string(8) "26723520"
    [2]=>
    string(8) "26723521"
    [3]=>
    string(8) "26723522"
    [4]=>
    string(8) "26723523"
    [5]=>
    string(8) "26723524"
    [6]=>
    string(8) "26723525"
    [7]=>
    string(8) "26723526"
    [8]=>
    string(8) "26723527"
    [9]=>
    string(8) "26723528"
    [10]=>
    string(8) "26723529"
    [11]=>
    string(8) "26723530"
    [12]=>
    string(8) "26723531"
    [13]=>
    string(8) "26723532"
    [14]=>
    string(8) "26723533"
    [15]=>
    string(8) "26723534"
    [16]=>
    string(8) "26723535"
    [17]=>
    string(8) "26723536"
    [18]=>
    string(8) "26723537"
    [19]=>
    string(8) "26723538"
    [20]=>
    string(8) "26723539"
    [21]=>
    string(8) "26723540"
    [22]=>
    string(8) "26723541"
    [23]=>
    string(8) "26723542"
    [24]=>
    string(8) "26723543"
    [25]=>
    string(8) "26723544"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202423495
        )

    [StreetNumber] => Array
        (
            [0] => 47-358
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Mahakea
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Kaneohe
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96744
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1017532359?badge=0&autopause=0&player_id=0&app_id=58479
        )

    [ListPrice] => Array
        (
            [0] => 1790000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 1790000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAALAEA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to your private oasis in the lush Kaalaea in Kaneohe. This stunning + expansive property sits on nearly an acre of serene and private land in a desirable and rarely available neighborhood. Meticulously renovated to the highest level, this home seamlessly blends modern design with the tranquility of island living.

The home is adorned with contemporary finishes, showcasing a keen attention to detail that elevates every room. Designed with versatility in mind, this property includes a 3-bedroom 3-bath home plus a separate two-bedroom, one-bathroom living area with its own entrance and wet bar. Whether you envision a space for multigenerational living or seek potential rental income, this flexible option caters to a variety of lifestyles and needs.

Outside, the expansive lot offers privacy and more than enough space for a garden or farm. The upper level of the lot + country zoning offers the possibility for an additional dwelling with ocean views. Surrounded by lush greenery, the possibilities are endless for expansion and enjoying the outdoors.
        )

    [ListOfficeName] => Array
        (
            [0] => Compass
        )

    [BedsTotal] => Array
        (
            [0] => 5
        )

    [BathsFull] => Array
        (
            [0] => 4
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 43551.00
        )

    [SqftTotal] => Array
        (
            [0] => 2006
        )

    [YearBuilt] => Array
        (
            [0] => 1961
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => Mountain,Ocean
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => COHI
        )

    [ListAgentEmail] => Array
        (
            [0] => sean@yanogroup.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 825-4277
        )

    [ListAgentFullName] => Array
        (
            [0] => Sean S Yano
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-24T17:00:01.623
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18312555
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-08T15:11:30.370
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kaneohe
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26723519
        )

    [listing_image] => Array
        (
            [0] => 26723519
            [1] => 26723520
            [2] => 26723521
            [3] => 26723522
            [4] => 26723523
            [5] => 26723524
            [6] => 26723525
            [7] => 26723526
            [8] => 26723527
            [9] => 26723528
            [10] => 26723529
            [11] => 26723530
            [12] => 26723531
            [13] => 26723532
            [14] => 26723533
            [15] => 26723534
            [16] => 26723535
            [17] => 26723536
            [18] => 26723537
            [19] => 26723538
            [20] => 26723539
            [21] => 26723540
            [22] => 26723541
            [23] => 26723542
            [24] => 26723543
            [25] => 26723544
        )

)

  • BedsTotal: 5
  • Full Baths: 4
  • Land Area (sf): 43,551
  • Living (sf): 2,006
  • Year Built: 1961

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Mountain,Ocean
  • Listing Office: Compass

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446