Previous Next

47-738 Hui Ulili Street Kaneohe, HI 96744

Listing
Overview

Price: $1,195,000
Area: CLUB VIEW ESTATE
Status: Sold

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202508216"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-738"
  }
  ["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) "1195000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(16) "CLUB VIEW ESTATE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1189) "Nestled in the heart of Ahuimanu, this stunning single-family home offers breathtaking views of the majestic Ko‘olau Mountain Range. Set in a lush tropical setting, the property boasts a serene and private atmosphere, surrounded by vibrant foliage and mature landscaping. The inviting front entrance courtyard sets the tone for a warm and welcoming home. Step inside to discover a bright and airy open layout with soaring high ceilings and brand-new flooring throughout.  The spacious living and dining areas flow seamlessly, perfect for entertaining or simply enjoying the natural beauty that surrounds you. A highlight of this home is the enclosed sunroom, adjacent to the generous deck—ideal for relaxing or hosting gatherings while taking in the tranquil outdoor scenery. The expansive primary suite provides a private retreat, while 2 additional bedrooms and full bath on the first floor offer flexible living options for guests or a home office. Experience the best of island living in this Ahuimanu gem—where comfort, space, and breathtaking views come together in perfect harmony. Make sure to ask about the VA assumable loan rate of 2.476% and low monthly payment available!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8413.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1855"
  }
  ["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) "4"
  }
  ["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(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "heather@surfhawaiianhomes.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 282-1764"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Heather Selvitelle"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-09"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18656691"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-09T15:52:46.740"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-04"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:52:46.740"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26946215"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26946215"
    [1]=>
    string(8) "26946216"
    [2]=>
    string(8) "26946217"
    [3]=>
    string(8) "26946218"
    [4]=>
    string(8) "26946219"
    [5]=>
    string(8) "26946220"
    [6]=>
    string(8) "26946221"
    [7]=>
    string(8) "26946222"
    [8]=>
    string(8) "26946223"
    [9]=>
    string(8) "26946224"
    [10]=>
    string(8) "26946225"
    [11]=>
    string(8) "26946226"
    [12]=>
    string(8) "26946227"
    [13]=>
    string(8) "26946228"
    [14]=>
    string(8) "26946229"
    [15]=>
    string(8) "26946230"
    [16]=>
    string(8) "26946231"
    [17]=>
    string(8) "26946232"
    [18]=>
    string(8) "26946233"
    [19]=>
    string(8) "26946234"
    [20]=>
    string(8) "26946235"
    [21]=>
    string(8) "26946236"
    [22]=>
    string(8) "26946237"
    [23]=>
    string(8) "26946238"
    [24]=>
    string(8) "26946239"
    [25]=>
    string(8) "26946240"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202508216
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Nestled in the heart of Ahuimanu, this stunning single-family home offers breathtaking views of the majestic Ko‘olau Mountain Range. Set in a lush tropical setting, the property boasts a serene and private atmosphere, surrounded by vibrant foliage and mature landscaping. The inviting front entrance courtyard sets the tone for a warm and welcoming home. Step inside to discover a bright and airy open layout with soaring high ceilings and brand-new flooring throughout.  The spacious living and dining areas flow seamlessly, perfect for entertaining or simply enjoying the natural beauty that surrounds you. A highlight of this home is the enclosed sunroom, adjacent to the generous deck—ideal for relaxing or hosting gatherings while taking in the tranquil outdoor scenery. The expansive primary suite provides a private retreat, while 2 additional bedrooms and full bath on the first floor offer flexible living options for guests or a home office. Experience the best of island living in this Ahuimanu gem—where comfort, space, and breathtaking views come together in perfect harmony. Make sure to ask about the VA assumable loan rate of 2.476% and low monthly payment available!
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => heather@surfhawaiianhomes.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 282-1764
        )

    [ListAgentFullName] => Array
        (
            [0] => Heather Selvitelle
        )

    [CloseDate] => Array
        (
            [0] => 2025-05-09
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-09T15:52:46.740
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:52:46.740
        )

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

    [listing_image] => Array
        (
            [0] => 26946215
            [1] => 26946216
            [2] => 26946217
            [3] => 26946218
            [4] => 26946219
            [5] => 26946220
            [6] => 26946221
            [7] => 26946222
            [8] => 26946223
            [9] => 26946224
            [10] => 26946225
            [11] => 26946226
            [12] => 26946227
            [13] => 26946228
            [14] => 26946229
            [15] => 26946230
            [16] => 26946231
            [17] => 26946232
            [18] => 26946233
            [19] => 26946234
            [20] => 26946235
            [21] => 26946236
            [22] => 26946237
            [23] => 26946238
            [24] => 26946239
            [25] => 26946240
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 8,413 sf
• Living (sf): 1,855
• Year Built: 1969

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 4
• View: Garden,Mountain,Sunrise,Sunset
• Listing Office: List Sotheby's Int'l Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

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 May 9, 2025 - 3:52 PM 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.