Previous Next

99-571 Pohue Street Aiea, HI 96701

Listing
Overview

Price: $1,480,000
Area: HALAWA
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202521759"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "99-571"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Pohue"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96701"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1480000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HALAWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1199) "CENTRAL w/ excellent LOCATION:   CORNER LOT, TWO (2) Separate Driveways, TWO (separate entry carports).  WELL DESIGNED Contractor's House.  Flows Well. Perfect for Multi-Family Use and / or partial or full Investment Property.  Newer UPSTAIRS ADDITION w/ wetbar (2008):  3 BEDROOM + 2 FULL BATH + 2 CARPORT (w/ extra 2 parking - tandem) WIDE Street across from large Mormon Church allows for ample street parking and bonus privacy.  ORIGINAL DOWNSTAIRS:  3 BEDROOM / 1.5 BATH OPEN CONCEPT DESIGN.  Covered Private Lanai with EXTRA outdoor Toilet has ONE (1) Carport and Two (2) additional parking space (open) + Garden.  Middle WASHING MACHINE / DRYER AREA allows for TWO SEPARATE systems as an option.  House is Well-Maintained and has a Flexible Design.  Convenient access to:  H-1, H-3, Moanalua Freeway. Centrally located, 5 min to:  Camp Smith, Stadium Mall, Target, NEX, Aiea Shopping Center, Young BBQ, Webling Elementary, Aiea Library; 10 min to Pearl Ridge Shopping Center, Best Buy, Tripler, Home Depot, Airport.  15 min to Kaneohe via H-3.  NEW Stainless Steel Appliances & New Front Loading Washer/Dryer:  Well-Maintained, Ready to Go! It's a Once in a Life-time Opportunity, A Must See!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Hara Realty, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6708.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2578"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1963"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(51) "City,Coastline,Garden,Mountain,Ocean,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Webling"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(4) "Aiea"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HBRR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "ginahara@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 941-2154"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Gina M Hara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19016163"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-09T11:44:59.580"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-03"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "PearlCity"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:44:59.580"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27174972"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27174972"
    [1]=>
    string(8) "27174973"
    [2]=>
    string(8) "27174974"
    [3]=>
    string(8) "27174975"
    [4]=>
    string(8) "27174976"
    [5]=>
    string(8) "27174977"
    [6]=>
    string(8) "27174978"
    [7]=>
    string(8) "27174979"
    [8]=>
    string(8) "27174980"
    [9]=>
    string(8) "27174981"
    [10]=>
    string(8) "27174982"
    [11]=>
    string(8) "27174983"
    [12]=>
    string(8) "27174984"
    [13]=>
    string(8) "27174985"
    [14]=>
    string(8) "27174986"
    [15]=>
    string(8) "27174987"
    [16]=>
    string(8) "27174988"
    [17]=>
    string(8) "27174989"
    [18]=>
    string(8) "27174990"
    [19]=>
    string(8) "27174991"
    [20]=>
    string(8) "27174992"
    [21]=>
    string(8) "27174993"
    [22]=>
    string(8) "27174994"
    [23]=>
    string(8) "27174995"
    [24]=>
    string(8) "27174996"
    [25]=>
    string(8) "27174997"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202521759
        )

    [StreetNumber] => Array
        (
            [0] => 99-571
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => HALAWA
        )

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

    [PublicRemarks] => Array
        (
            [0] => CENTRAL w/ excellent LOCATION:   CORNER LOT, TWO (2) Separate Driveways, TWO (separate entry carports).  WELL DESIGNED Contractor's House.  Flows Well. Perfect for Multi-Family Use and / or partial or full Investment Property.  Newer UPSTAIRS ADDITION w/ wetbar (2008):  3 BEDROOM + 2 FULL BATH + 2 CARPORT (w/ extra 2 parking - tandem) WIDE Street across from large Mormon Church allows for ample street parking and bonus privacy.  ORIGINAL DOWNSTAIRS:  3 BEDROOM / 1.5 BATH OPEN CONCEPT DESIGN.  Covered Private Lanai with EXTRA outdoor Toilet has ONE (1) Carport and Two (2) additional parking space (open) + Garden.  Middle WASHING MACHINE / DRYER AREA allows for TWO SEPARATE systems as an option.  House is Well-Maintained and has a Flexible Design.  Convenient access to:  H-1, H-3, Moanalua Freeway. Centrally located, 5 min to:  Camp Smith, Stadium Mall, Target, NEX, Aiea Shopping Center, Young BBQ, Webling Elementary, Aiea Library; 10 min to Pearl Ridge Shopping Center, Best Buy, Tripler, Home Depot, Airport.  15 min to Kaneohe via H-3.  NEW Stainless Steel Appliances & New Front Loading Washer/Dryer:  Well-Maintained, Ready to Go! It's a Once in a Life-time Opportunity, A Must See!
        )

    [ListOfficeName] => Array
        (
            [0] => Hara Realty, LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 941-2154
        )

    [ListAgentFullName] => Array
        (
            [0] => Gina M Hara
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-09T11:44:59.580
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-10-03
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:44:59.580
        )

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

    [listing_image] => Array
        (
            [0] => 27174972
            [1] => 27174973
            [2] => 27174974
            [3] => 27174975
            [4] => 27174976
            [5] => 27174977
            [6] => 27174978
            [7] => 27174979
            [8] => 27174980
            [9] => 27174981
            [10] => 27174982
            [11] => 27174983
            [12] => 27174984
            [13] => 27174985
            [14] => 27174986
            [15] => 27174987
            [16] => 27174988
            [17] => 27174989
            [18] => 27174990
            [19] => 27174991
            [20] => 27174992
            [21] => 27174993
            [22] => 27174994
            [23] => 27174995
            [24] => 27174996
            [25] => 27174997
        )

)

PROPERTY INFO

• BedsTotal: 6
• Full Baths: 3
• Half Baths: 2
• Land Area (sf): 6,708 sf
• Living (sf): 2,578
• Year Built: 1963

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 8
• View: City,Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
• Listing Office: Hara Realty, LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Webling
• Middle School: Aiea
• High School: Aiea

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 9, 2025 - 11:44 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.