47-775 Hui Ulili Street Kaneohe, HI 96744

Listing
Overview

Price: $1,895,000
Area: CLUB VIEW ESTATE
Status: Active

Make this home your forever family residence. First time on the market in 44 years. This home is unique in the Club View-Ahuimanu area. Large 14,000 sq. ft. lot, large 4-bedroom 3 bath, multiple high-end upgrades. First floor primary suite, with private sitting room-office. Brazilian cherry wood engineered flooring. Large kitchen, two covered lanais. enclosed garage, swimming pool, standing seam metal roof, fully fenced, fully landscaped and private setting that makes this home a true family entertainment dream. There is no home in the area that compared to the lifestyle that this home affords to the new family. Possible seller interest rate buy-down for the qualified buyer. Listing by: Locations LLC (808) 679-1714 

array(46) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202317655"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-775"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Hui Ulili"
  }
  ["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) "1895000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1895000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(16) "CLUB VIEW ESTATE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(683) "Make this home your forever family residence. First time on the market in 44 years. This home is unique in the Club View-Ahuimanu area. Large 14,000 sq. ft. lot, large 4-bedroom 3 bath, multiple high-end upgrades. First floor primary suite, with private sitting room-office. Brazilian cherry wood engineered flooring. Large kitchen, two covered lanais. enclosed garage, swimming pool, standing seam metal roof, fully fenced, fully landscaped and private setting that makes this home a true family entertainment dream. There is no home in the area that compared to the lifestyle that this home affords to the new family. Possible seller interest rate buy-down for the qualified buyer."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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(8) "14045.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2857"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1969"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(30) "Garden,Mountain,Sunrise,Sunset"
  }
  ["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) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(31) "Sandie.Choe@LocationsHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 679-1714"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(20) "Sandie Choe-Yamasato"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-23T08:11:50.080"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17474736"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-03T08:48:04.510"
  }
  ["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) "25900906"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25900906"
    [1]=>
    string(8) "25900907"
    [2]=>
    string(8) "25900908"
    [3]=>
    string(8) "25900909"
    [4]=>
    string(8) "25900910"
    [5]=>
    string(8) "25900911"
    [6]=>
    string(8) "25900912"
    [7]=>
    string(8) "25900913"
    [8]=>
    string(8) "25900914"
    [9]=>
    string(8) "25900915"
    [10]=>
    string(8) "25900916"
    [11]=>
    string(8) "25900917"
    [12]=>
    string(8) "25900918"
    [13]=>
    string(8) "25900919"
    [14]=>
    string(8) "25900920"
    [15]=>
    string(8) "25900921"
    [16]=>
    string(8) "25900922"
    [17]=>
    string(8) "25900923"
    [18]=>
    string(8) "25900924"
    [19]=>
    string(8) "25900925"
    [20]=>
    string(8) "25900926"
    [21]=>
    string(8) "25900927"
    [22]=>
    string(8) "25900928"
    [23]=>
    string(8) "25900929"
    [24]=>
    string(8) "25900930"
    [25]=>
    string(8) "25900931"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "08:11:50.080"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202317655
        )

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

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

    [StreetName] => Array
        (
            [0] => Hui Ulili
        )

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

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

    [Neighbourhood] => Array
        (
            [0] => CLUB VIEW ESTATE
        )

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

    [PublicRemarks] => Array
        (
            [0] => Make this home your forever family residence. First time on the market in 44 years. This home is unique in the Club View-Ahuimanu area. Large 14,000 sq. ft. lot, large 4-bedroom 3 bath, multiple high-end upgrades. First floor primary suite, with private sitting room-office. Brazilian cherry wood engineered flooring. Large kitchen, two covered lanais. enclosed garage, swimming pool, standing seam metal roof, fully fenced, fully landscaped and private setting that makes this home a true family entertainment dream. There is no home in the area that compared to the lifestyle that this home affords to the new family. Possible seller interest rate buy-down for the qualified buyer.
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

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

    [View] => Array
        (
            [0] => Garden,Mountain,Sunrise,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Sandie.Choe@LocationsHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 679-1714
        )

    [ListAgentFullName] => Array
        (
            [0] => Sandie Choe-Yamasato
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-10-23T08:11:50.080
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-08-03T08:48:04.510
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25900906
            [1] => 25900907
            [2] => 25900908
            [3] => 25900909
            [4] => 25900910
            [5] => 25900911
            [6] => 25900912
            [7] => 25900913
            [8] => 25900914
            [9] => 25900915
            [10] => 25900916
            [11] => 25900917
            [12] => 25900918
            [13] => 25900919
            [14] => 25900920
            [15] => 25900921
            [16] => 25900922
            [17] => 25900923
            [18] => 25900924
            [19] => 25900925
            [20] => 25900926
            [21] => 25900927
            [22] => 25900928
            [23] => 25900929
            [24] => 25900930
            [25] => 25900931
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 08:11:50.080
        )

)

  • BedsTotal: 4
  • Full Baths: 3
  • Land Area (sf): 14,045 sf
  • Living (sf): 2,857
  • Year Built: 1969

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Garden,Mountain,Sunrise,Sunset
  • Listing Office: Locations LLC

  • Land Tenure: FS - Fee Simple

  • Elementary School: Ahuimanu
  • Middle School: King
  • High School: Castle

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on October 23, 2023 - 8:11 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.