47-571 Hakuhale Street Kaneohe, HI 96744

Listing
Overview

Price: $1,450,000
Area: AHUIMANU AREA
Status: Active

A must see home at the end of a quiet cul de sac. Escape to this beautiful and tranquil place in Ahuimanu where you can relax and be intrigued by breath-taking views of the Koolau Mountain Range and the sights and sounds of Kahalu’u Stream below. Stepping inside this charming home you will be drawn into the large open living, dining, den areas. Just off the well appointed kitchen is a bonus room, perfect for an office or craft area, opening to a large deck for entertaining family and guests. You’ll find personalized design features in every aspect of the home including unique custom cabinetry throughout, lower level hardwood floors, 34 PV panels on the Net Energy Metering system plus Tabuchi storage battery, solar water heating, whole home Quiet Cool fan, ceiling fans and louvre windows to keep the tradewinds flowing. Dream kitchen includes walk-in pantry, large island, bay window overlooking Kahalu’u stream, travertine flooring, venting skylight, oversized separate refrigerator and freezer. Upstairs find all 3 bedrooms and 2 full baths. Master bedroom has large walk-in closet, double vanity, walk-in shower, and small balcony overlooking the stream and private forested area Listing by: Vineyard Investment Realty LLC (808) 421-9513

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417601"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-571"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Hakuhale"
  }
  ["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(13) "AHUIMANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1198) "A must see home at the end of a quiet cul de sac. Escape to this beautiful and tranquil place in Ahuimanu where you can relax and be intrigued by breath-taking views of the Koolau Mountain Range and the sights and sounds of Kahalu’u Stream below. Stepping inside this charming home you will be drawn into the large open living, dining, den areas. Just off the well appointed kitchen is a bonus room, perfect for an office or craft area, opening to a large deck for entertaining family and guests. You’ll find personalized design features in every aspect of the home including unique custom cabinetry throughout, lower level hardwood floors, 34 PV panels on the Net Energy Metering system plus Tabuchi storage battery, solar water heating, whole home Quiet Cool fan, ceiling fans and louvre windows to keep the tradewinds flowing. Dream kitchen includes walk-in pantry, large island, bay window overlooking Kahalu’u stream, travertine flooring, venting skylight, oversized separate refrigerator and freezer. Upstairs find all 3 bedrooms and 2 full baths. Master bedroom has large walk-in closet, double vanity, walk-in shower, and small balcony overlooking the stream and private forested area"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Vineyard Investment Realty LLC"
  }
  ["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(7) "6300.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2974"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["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(8) "Mountain"
  }
  ["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(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "VINE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(16) "kanani@vine2.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 421-9513"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Kanani P Adams"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-22T17:00:01.720"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18182275"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-07T09:45:18.927"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26650618"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26650618"
    [1]=>
    string(8) "26650619"
    [2]=>
    string(8) "26650620"
    [3]=>
    string(8) "26650621"
    [4]=>
    string(8) "26650622"
    [5]=>
    string(8) "26650623"
    [6]=>
    string(8) "26650624"
    [7]=>
    string(8) "26650625"
    [8]=>
    string(8) "26650626"
    [9]=>
    string(8) "26650627"
    [10]=>
    string(8) "26650628"
    [11]=>
    string(8) "26650629"
    [12]=>
    string(8) "26650630"
    [13]=>
    string(8) "26650631"
    [14]=>
    string(8) "26650632"
    [15]=>
    string(8) "26650633"
    [16]=>
    string(8) "26650634"
    [17]=>
    string(8) "26650635"
    [18]=>
    string(8) "26650636"
    [19]=>
    string(8) "26650637"
    [20]=>
    string(8) "26650638"
    [21]=>
    string(8) "26650639"
    [22]=>
    string(8) "26650640"
    [23]=>
    string(8) "26650641"
    [24]=>
    string(8) "26650642"
    [25]=>
    string(8) "26650643"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417601
        )

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

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

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

    [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] => AHUIMANU AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => A must see home at the end of a quiet cul de sac. Escape to this beautiful and tranquil place in Ahuimanu where you can relax and be intrigued by breath-taking views of the Koolau Mountain Range and the sights and sounds of Kahalu’u Stream below. Stepping inside this charming home you will be drawn into the large open living, dining, den areas. Just off the well appointed kitchen is a bonus room, perfect for an office or craft area, opening to a large deck for entertaining family and guests. You’ll find personalized design features in every aspect of the home including unique custom cabinetry throughout, lower level hardwood floors, 34 PV panels on the Net Energy Metering system plus Tabuchi storage battery, solar water heating, whole home Quiet Cool fan, ceiling fans and louvre windows to keep the tradewinds flowing. Dream kitchen includes walk-in pantry, large island, bay window overlooking Kahalu’u stream, travertine flooring, venting skylight, oversized separate refrigerator and freezer. Upstairs find all 3 bedrooms and 2 full baths. Master bedroom has large walk-in closet, double vanity, walk-in shower, and small balcony overlooking the stream and private forested area
        )

    [ListOfficeName] => Array
        (
            [0] => Vineyard Investment Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => kanani@vine2.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 421-9513
        )

    [ListAgentFullName] => Array
        (
            [0] => Kanani P Adams
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-22T17:00:01.720
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-07T09:45:18.927
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Stream/Canal
        )

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

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

    [listing_image] => Array
        (
            [0] => 26650618
            [1] => 26650619
            [2] => 26650620
            [3] => 26650621
            [4] => 26650622
            [5] => 26650623
            [6] => 26650624
            [7] => 26650625
            [8] => 26650626
            [9] => 26650627
            [10] => 26650628
            [11] => 26650629
            [12] => 26650630
            [13] => 26650631
            [14] => 26650632
            [15] => 26650633
            [16] => 26650634
            [17] => 26650635
            [18] => 26650636
            [19] => 26650637
            [20] => 26650638
            [21] => 26650639
            [22] => 26650640
            [23] => 26650641
            [24] => 26650642
            [25] => 26650643
        )

)

  • BedsTotal: 3
  • Full Baths: 3
  • Land Area (sf): 6,300
  • Living (sf): 2,974
  • Year Built: 1988

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Mountain
  • Listing Office: Vineyard Investment Realty LLC

  • Land Tenure: FS - Fee Simple

  • Elementary School: Kahaluu
  • High School: Castle

CONTACT US

Marcus Realty

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