Previous Next

47-223 Hui Aeko Street Kaneohe, HI 96744

Listing
Overview

Price: $1,200,000
Area: AHUIMANU AREA
Status: Pending

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202528208"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-223"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Hui Aeko"
  }
  ["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) "1200000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(7) "Pending"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(292) "Beautiful corner-lot home with the backdrop of the Ko'olau Moutains. Home has been cared for by the same family for decades. Conveniently located close to Ko'olau Shopping Center and Windward Mall. Right across the St. from Ahuimanu Elementary school. Only about 15 minutes drive to Honolulu."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(28) "Hawaii Real Estate Ohana LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6011.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2475"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1980"
  }
  ["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(8) "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) "CJRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "danieljames.ra@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 542-2165"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Daniel James"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19179137"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-21T22:22:13.720"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-19"
  }
  ["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) "22:22:13.720"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27251566"
  }
  ["listing_image"]=>
  array(2) {
    [0]=>
    string(8) "27251566"
    [1]=>
    string(8) "27251567"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202528208
        )

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Beautiful corner-lot home with the backdrop of the Ko'olau Moutains. Home has been cared for by the same family for decades. Conveniently located close to Ko'olau Shopping Center and Windward Mall. Right across the St. from Ahuimanu Elementary school. Only about 15 minutes drive to Honolulu.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Real Estate Ohana LLC
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => 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] => CJRE
        )

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 542-2165
        )

    [ListAgentFullName] => Array
        (
            [0] => Daniel James
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-21T22:22:13.720
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-12-19
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 22:22:13.720
        )

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

    [listing_image] => Array
        (
            [0] => 27251566
            [1] => 27251567
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 6,011 sf
• Living (sf): 2,475
• Year Built: 1980

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Mountain
• Listing Office: Hawaii Real Estate Ohana LLC

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 December 21, 2025 - 10:22 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.