Previous Next

47-578 Hua Place Kaneohe, HI 96744

Listing
Overview

Price: $1,750,000
Area: AHUIMANU HILLS
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202609927"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-578"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(3) "Hua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["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) "1750000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(14) "AHUIMANU HILLS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(701) "Tucked at the end of a peaceful cul-de-sac in Ahuimanu Hills, this completely renovated 4 bedroom, 3.5 bath home offers sweeping Ko'olau mountain views and a rare sense of privacy. Two primary suites offer flexibility for families, guests, and multigenerational living, and the large main-floor primary is perfect for aging in place. Open concept with new stainless steel kitchen appliances, new bathrooms, and beautiful finishes throughout. New split AC system installed throughout the home. Situated on a private flag lot with quick access to H-3 and Likelike Highway for easy commutes to Honolulu and military bases. Move-in ready and in amazing condition! Bath count does not match public records."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8543.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2422"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1981"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "brandonchin827@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 888-9072"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Brandon Chin"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19471164"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-22T09:12:43.757"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-05-22"
  }
  ["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) "09:12:43.757"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27400788"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27400788"
    [1]=>
    string(8) "27400789"
    [2]=>
    string(8) "27400790"
    [3]=>
    string(8) "27400791"
    [4]=>
    string(8) "27400792"
    [5]=>
    string(8) "27400793"
    [6]=>
    string(8) "27400794"
    [7]=>
    string(8) "27400795"
    [8]=>
    string(8) "27400796"
    [9]=>
    string(8) "27400797"
    [10]=>
    string(8) "27400798"
    [11]=>
    string(8) "27400799"
    [12]=>
    string(8) "27400800"
    [13]=>
    string(8) "27400801"
    [14]=>
    string(8) "27400802"
    [15]=>
    string(8) "27400803"
    [16]=>
    string(8) "27400804"
    [17]=>
    string(8) "27400805"
    [18]=>
    string(8) "27400806"
    [19]=>
    string(8) "27400807"
    [20]=>
    string(8) "27400808"
    [21]=>
    string(8) "27400809"
    [22]=>
    string(8) "27400810"
    [23]=>
    string(8) "27400811"
    [24]=>
    string(8) "27400812"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202609927
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => AHUIMANU HILLS
        )

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

    [PublicRemarks] => Array
        (
            [0] => Tucked at the end of a peaceful cul-de-sac in Ahuimanu Hills, this completely renovated 4 bedroom, 3.5 bath home offers sweeping Ko'olau mountain views and a rare sense of privacy. Two primary suites offer flexibility for families, guests, and multigenerational living, and the large main-floor primary is perfect for aging in place. Open concept with new stainless steel kitchen appliances, new bathrooms, and beautiful finishes throughout. New split AC system installed throughout the home. Situated on a private flag lot with quick access to H-3 and Likelike Highway for easy commutes to Honolulu and military bases. Move-in ready and in amazing condition! Bath count does not match public records.
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => brandonchin827@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 888-9072
        )

    [ListAgentFullName] => Array
        (
            [0] => Brandon Chin
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-22T09:12:43.757
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-05-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:12:43.757
        )

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

    [listing_image] => Array
        (
            [0] => 27400788
            [1] => 27400789
            [2] => 27400790
            [3] => 27400791
            [4] => 27400792
            [5] => 27400793
            [6] => 27400794
            [7] => 27400795
            [8] => 27400796
            [9] => 27400797
            [10] => 27400798
            [11] => 27400799
            [12] => 27400800
            [13] => 27400801
            [14] => 27400802
            [15] => 27400803
            [16] => 27400804
            [17] => 27400805
            [18] => 27400806
            [19] => 27400807
            [20] => 27400808
            [21] => 27400809
            [22] => 27400810
            [23] => 27400811
            [24] => 27400812
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 3
• Half Baths: 1
• Land Area (sf): 8,543 sf
• Living (sf): 2,422
• Year Built: 1981

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 4
• View: Garden,Mountain
• Listing Office: eXp Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• 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 May 22, 2026 - 9:12 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.