94-529 Lumiaina Street Unit D103 Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $538,000
Area: WAIKELE
Status: Pending

Rare, Larger 2-bedroom "Corner End unit" floor plan in Mahi Ko at Waikele. This single-level, ground-floor unit features an expansive private yard off the living room and a covered patio with peekaboo ocean views. Interior includes space for a small kitchen table and comes with all major appliances: washer/dryer, refrigerator, stove, microwave hood, and dishwasher. One assigned parking stall is located right outside the front door (possible stalls for rent from association), with multiple guest stalls nearby. Pet-friendly complex (buyer to verify), VA-approved, with an on-site resident manager. Convenient access to H-1, military bases, Waikele Premium Outlets, dining, golfing, and more. Sought-after neighborhood known for its breezes and central location. Turn-Key & Priced well! 3D digital walkthrough available online. Listing by: Redfin Corporation (808) 201-2821

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510249"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-529"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lumiaina"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "D103"
  }
  ["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(51) "https://my.matterport.com/show/?m=x6shNor6MNe&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "538000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(7) "Pending"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(830) "Rare, Larger 2-bedroom "Corner End unit" floor plan in Mahi Ko at Waikele. This single-level, ground-floor unit features an expansive private yard off the living room and a covered patio with peekaboo ocean views. Interior includes space for a small kitchen table and comes with all major appliances: washer/dryer, refrigerator, stove, microwave hood, and dishwasher. One assigned parking stall is located right outside the front door (possible stalls for rent from association), with multiple guest stalls nearby. Pet-friendly complex (buyer to verify), VA-approved, with an on-site resident manager. Convenient access to H-1, military bases, Waikele Premium Outlets, dining, golfing, and more. Sought-after neighborhood known for its breezes and central location. Turn-Key & Priced well! 3D digital walkthrough available online."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Redfin Corporation"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "922"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Mahi Ko At Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "498.85"
  }
  ["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) "RFIN"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "gill.mara@redfin.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 201-2821"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Gill Mara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18696292"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-15T10:07:05.060"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-23"
  }
  ["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:07:05.060"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26969507"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26969507"
    [1]=>
    string(8) "26969508"
    [2]=>
    string(8) "26969509"
    [3]=>
    string(8) "26969510"
    [4]=>
    string(8) "26969511"
    [5]=>
    string(8) "26969512"
    [6]=>
    string(8) "26969513"
    [7]=>
    string(8) "26969514"
    [8]=>
    string(8) "26969515"
    [9]=>
    string(8) "26969516"
    [10]=>
    string(8) "26969517"
    [11]=>
    string(8) "26969518"
    [12]=>
    string(8) "26969519"
    [13]=>
    string(8) "26969520"
    [14]=>
    string(8) "26969521"
    [15]=>
    string(8) "26969522"
    [16]=>
    string(8) "26969523"
    [17]=>
    string(8) "26969524"
    [18]=>
    string(8) "26969525"
    [19]=>
    string(8) "26969526"
    [20]=>
    string(8) "26969527"
    [21]=>
    string(8) "26969528"
    [22]=>
    string(8) "26969529"
    [23]=>
    string(8) "26969530"
    [24]=>
    string(8) "26969531"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510249
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=x6shNor6MNe&mls=1
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rare, Larger 2-bedroom "Corner End unit" floor plan in Mahi Ko at Waikele. This single-level, ground-floor unit features an expansive private yard off the living room and a covered patio with peekaboo ocean views. Interior includes space for a small kitchen table and comes with all major appliances: washer/dryer, refrigerator, stove, microwave hood, and dishwasher. One assigned parking stall is located right outside the front door (possible stalls for rent from association), with multiple guest stalls nearby. Pet-friendly complex (buyer to verify), VA-approved, with an on-site resident manager. Convenient access to H-1, military bases, Waikele Premium Outlets, dining, golfing, and more. Sought-after neighborhood known for its breezes and central location. Turn-Key & Priced well! 3D digital walkthrough available online.
        )

    [ListOfficeName] => Array
        (
            [0] => Redfin Corporation
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Mahi Ko At Waikele
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => gill.mara@redfin.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 201-2821
        )

    [ListAgentFullName] => Array
        (
            [0] => Gill Mara
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-15T10:07:05.060
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:07:05.060
        )

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

    [listing_image] => Array
        (
            [0] => 26969507
            [1] => 26969508
            [2] => 26969509
            [3] => 26969510
            [4] => 26969511
            [5] => 26969512
            [6] => 26969513
            [7] => 26969514
            [8] => 26969515
            [9] => 26969516
            [10] => 26969517
            [11] => 26969518
            [12] => 26969519
            [13] => 26969520
            [14] => 26969521
            [15] => 26969522
            [16] => 26969523
            [17] => 26969524
            [18] => 26969525
            [19] => 26969526
            [20] => 26969527
            [21] => 26969528
            [22] => 26969529
            [23] => 26969530
            [24] => 26969531
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 922
  • Year Built: 1993
  • Building Name: Mahi Ko At Waikele

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: Redfin Corporation

  • Maintenance Fees: $499
  • Land Tenure: FS - Fee Simple

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 15, 2025 - 10:07 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.

© Marcus Realty. All Rights Reserved.