Previous Next

47-478 Ahuimanu Road Unit A Kaneohe, HI 96744

Listing
Overview

Price: $5,775,000
Area: AHUIMANU AREA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202615587"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-478"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["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) "5775000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(508) "This property has six homes. Each home has minimum lot size of 5,600 sq. ft. and up to 10,080 sq. ft. of land each with individual carports and hookups for full size washer and dryer. One house has 4 bedrooms, 2 baths; Two houses have 4 bedrooms, 2.5 baths; and Three houses have 3 bedrooms, 1 bath.  All 6 homes are very private and are 6 single family dwellings.  Driveway is shared by the 6 homes.  Each home is a CPR and may be sold separately.  Properties are in good condition and are currently rented."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(9) "JW REALTY"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "44867.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "6234"
  }
  ["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(2) "12"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["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) "Waiahole"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "JWRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "djwalden@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 306-9472"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Donna J Walden"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19646184"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-09-02T12:48:23.320"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-09-02"
  }
  ["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) "12:48:23.320"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27512267"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27512267"
    [1]=>
    string(8) "27512268"
    [2]=>
    string(8) "27512269"
    [3]=>
    string(8) "27512270"
    [4]=>
    string(8) "27512271"
    [5]=>
    string(8) "27512272"
    [6]=>
    string(8) "27512273"
    [7]=>
    string(8) "27512274"
    [8]=>
    string(8) "27512275"
    [9]=>
    string(8) "27512276"
    [10]=>
    string(8) "27512277"
    [11]=>
    string(8) "27512278"
    [12]=>
    string(8) "27512279"
    [13]=>
    string(8) "27512280"
    [14]=>
    string(8) "27512281"
    [15]=>
    string(8) "27512282"
    [16]=>
    string(8) "27512283"
    [17]=>
    string(8) "27512284"
    [18]=>
    string(8) "27512285"
    [19]=>
    string(8) "27512286"
    [20]=>
    string(8) "27512287"
    [21]=>
    string(8) "27512288"
    [22]=>
    string(8) "27512289"
    [23]=>
    string(8) "27512290"
    [24]=>
    string(8) "27512291"
    [25]=>
    string(8) "27512292"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202615587
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This property has six homes. Each home has minimum lot size of 5,600 sq. ft. and up to 10,080 sq. ft. of land each with individual carports and hookups for full size washer and dryer. One house has 4 bedrooms, 2 baths; Two houses have 4 bedrooms, 2.5 baths; and Three houses have 3 bedrooms, 1 bath.  All 6 homes are very private and are 6 single family dwellings.  Driveway is shared by the 6 homes.  Each home is a CPR and may be sold separately.  Properties are in good condition and are currently rented.
        )

    [ListOfficeName] => Array
        (
            [0] => JW REALTY
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 306-9472
        )

    [ListAgentFullName] => Array
        (
            [0] => Donna J Walden
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-09-02T12:48:23.320
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-09-02
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:48:23.320
        )

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

    [listing_image] => Array
        (
            [0] => 27512267
            [1] => 27512268
            [2] => 27512269
            [3] => 27512270
            [4] => 27512271
            [5] => 27512272
            [6] => 27512273
            [7] => 27512274
            [8] => 27512275
            [9] => 27512276
            [10] => 27512277
            [11] => 27512278
            [12] => 27512279
            [13] => 27512280
            [14] => 27512281
            [15] => 27512282
            [16] => 27512283
            [17] => 27512284
            [18] => 27512285
            [19] => 27512286
            [20] => 27512287
            [21] => 27512288
            [22] => 27512289
            [23] => 27512290
            [24] => 27512291
            [25] => 27512292
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 3
• Half Baths: 2
• Land Area (sf): 44,867 sf
• Living (sf): 6,234
• Year Built: 1969

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 12
• View: Mountain
• Listing Office: JW REALTY

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Waiahole
• 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 September 2, 2026 - 12:48 PM 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.