Previous Next

94-245 Leowahine Street Unit 3006 Waipahu, HI 96797

Listing
Overview

Price: $278,000
Area: WAIPAHU-LOWER
Status: Sold (Limited photos per MLS privacy policy)

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510350"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-245"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Leowahine"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "3006"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "278000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPAHU-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(457) "AMAZING INVESTMENT OPPORTUNITY! Equity and cash flow combination all in one. Motivated seller! SU CASA in Waipahu. Spacious 3 bedroom, 1 bath, 1 parking condo in three story walk-up. Located on top floor, corner end unit near stairway. New paint, floors, range/oven and refrigerator. Fantastic value for first time buyer or investor. Gated entry. Located near shopping, freeway access, and public transportation. Community Laundry. On-site building manager."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(15) "Affinity Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "165746.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "799"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1968"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Su Casa"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(5) "Three"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "540.21"
  }
  ["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) "AFFI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "Karen@Affinity1.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 748-8800"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Karen Y Uehara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-29"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18699074"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-29T10:33:02.170"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-18"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "10:33:02.170"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26964400"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "26964400"
    [1]=>
    string(8) "26964401"
    [2]=>
    string(8) "26964402"
    [3]=>
    string(8) "26964403"
    [4]=>
    string(8) "26964404"
    [5]=>
    string(8) "26964405"
    [6]=>
    string(8) "26964406"
    [7]=>
    string(8) "26964407"
    [8]=>
    string(8) "26964408"
    [9]=>
    string(8) "26964409"
    [10]=>
    string(8) "26964410"
    [11]=>
    string(8) "26964411"
    [12]=>
    string(8) "26964412"
    [13]=>
    string(8) "26964413"
    [14]=>
    string(8) "26964414"
    [15]=>
    string(8) "26964415"
    [16]=>
    string(8) "26964416"
    [17]=>
    string(8) "26964417"
    [18]=>
    string(8) "26964418"
    [19]=>
    string(8) "26964419"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510350
        )

    [StreetNumber] => Array
        (
            [0] => 94-245
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIPAHU-LOWER
        )

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

    [PublicRemarks] => Array
        (
            [0] => AMAZING INVESTMENT OPPORTUNITY! Equity and cash flow combination all in one. Motivated seller! SU CASA in Waipahu. Spacious 3 bedroom, 1 bath, 1 parking condo in three story walk-up. Located on top floor, corner end unit near stairway. New paint, floors, range/oven and refrigerator. Fantastic value for first time buyer or investor. Gated entry. Located near shopping, freeway access, and public transportation. Community Laundry. On-site building manager.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Karen@Affinity1.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 748-8800
        )

    [ListAgentFullName] => Array
        (
            [0] => Karen Y Uehara
        )

    [CloseDate] => Array
        (
            [0] => 2025-08-29
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-29T10:33:02.170
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:33:02.170
        )

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

    [listing_image] => Array
        (
            [0] => 26964400
            [1] => 26964401
            [2] => 26964402
            [3] => 26964403
            [4] => 26964404
            [5] => 26964405
            [6] => 26964406
            [7] => 26964407
            [8] => 26964408
            [9] => 26964409
            [10] => 26964410
            [11] => 26964411
            [12] => 26964412
            [13] => 26964413
            [14] => 26964414
            [15] => 26964415
            [16] => 26964416
            [17] => 26964417
            [18] => 26964418
            [19] => 26964419
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 1
• Land Area (sf): 165,746 sf
• Living (sf): 799
• Year Built: 1968
• Building Name: Su Casa

KEY FEATURES

• Property Condition: Average
• Number of Parking Spaces: 1
• View: None
• Listing Office: Affinity Realty

FINANCIAL INFO

• Maintenance Fees: $540
• 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 August 29, 2025 - 10:33 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.