94-523 Lumiaina Street Unit G102 Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $535,000
Area: WAIKELE
Status: Active

Discover this remarkable single-level 2-bedroom, 1-bath ground floor townhome nestled in the vibrant heart of Waikele, where modern finishes meets an unbeatable location. Renovated in 2021, this residence boasts brand-new cabinetry, sophisticated quartz countertops, and luxury vinyl plank flooring throughout, resulting in a bright and contemporary atmosphere. The private enclosed yard features a covered lanai, perfect for outdoor dining, gardening, or unwinding in tranquility. Centrally situated in Waikele, Mahi Ko at Waikele is a charming community that is pet friendly (buyer verify) and a mere 15 minutes from the airport, 30 minutes from the stunning North Shore, and just 20 minutes to the lively Downtown Honolulu. Plus, the renowned Waikele Premium Outlets, brimming with shopping, dining, and entertainment options, are just a short drive away, putting everything you need right within reach. Listing by: Coldwell Banker Realty (808) 499-7019

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202427749"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-523"
  }
  ["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) "G102"
  }
  ["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(131) "https://player.vimeo.com/video/1036381711?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "535000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(906) "Discover this remarkable single-level 2-bedroom, 1-bath ground floor townhome nestled in the vibrant heart of Waikele, where modern finishes meets an unbeatable location. Renovated in 2021, this residence boasts brand-new cabinetry, sophisticated quartz countertops, and luxury vinyl plank flooring throughout, resulting in a bright and contemporary atmosphere. The private enclosed yard features a covered lanai, perfect for outdoor dining, gardening, or unwinding in tranquility. Centrally situated in Waikele, Mahi Ko at Waikele is a charming community that is pet friendly (buyer verify) and a mere 15 minutes from the airport, 30 minutes from the stunning North Shore, and just 20 minutes to the lively Downtown Honolulu. Plus, the renowned Waikele Premium Outlets, brimming with shopping, dining, and entertainment options, are just a short drive away, putting everything you need right within reach."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "743"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Mahi Ko At Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "394.86"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(34) "jordyn.beltrolnavarro@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 499-7019"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(22) "Jordyn Beltrol Navarro"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-12T17:00:01.160"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18414076"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-12-09"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26801889"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "26801889"
    [1]=>
    string(8) "26801890"
    [2]=>
    string(8) "26801891"
    [3]=>
    string(8) "26801892"
    [4]=>
    string(8) "26801893"
    [5]=>
    string(8) "26801894"
    [6]=>
    string(8) "26801895"
    [7]=>
    string(8) "26801896"
    [8]=>
    string(8) "26801897"
    [9]=>
    string(8) "26801898"
    [10]=>
    string(8) "26801899"
    [11]=>
    string(8) "26801900"
    [12]=>
    string(8) "26801901"
    [13]=>
    string(8) "26801902"
    [14]=>
    string(8) "26801903"
    [15]=>
    string(8) "26801904"
    [16]=>
    string(8) "26801905"
    [17]=>
    string(8) "26801906"
    [18]=>
    string(8) "26801907"
    [19]=>
    string(8) "26801908"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:00:01.160"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202427749
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1036381711?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Discover this remarkable single-level 2-bedroom, 1-bath ground floor townhome nestled in the vibrant heart of Waikele, where modern finishes meets an unbeatable location. Renovated in 2021, this residence boasts brand-new cabinetry, sophisticated quartz countertops, and luxury vinyl plank flooring throughout, resulting in a bright and contemporary atmosphere. The private enclosed yard features a covered lanai, perfect for outdoor dining, gardening, or unwinding in tranquility. Centrally situated in Waikele, Mahi Ko at Waikele is a charming community that is pet friendly (buyer verify) and a mere 15 minutes from the airport, 30 minutes from the stunning North Shore, and just 20 minutes to the lively Downtown Honolulu. Plus, the renowned Waikele Premium Outlets, brimming with shopping, dining, and entertainment options, are just a short drive away, putting everything you need right within reach.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jordyn.beltrolnavarro@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 499-7019
        )

    [ListAgentFullName] => Array
        (
            [0] => Jordyn Beltrol Navarro
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-12T17:00:01.160
        )

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

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

    [ListingContractDate] => Array
        (
            [0] => 2024-12-09
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26801889
            [1] => 26801890
            [2] => 26801891
            [3] => 26801892
            [4] => 26801893
            [5] => 26801894
            [6] => 26801895
            [7] => 26801896
            [8] => 26801897
            [9] => 26801898
            [10] => 26801899
            [11] => 26801900
            [12] => 26801901
            [13] => 26801902
            [14] => 26801903
            [15] => 26801904
            [16] => 26801905
            [17] => 26801906
            [18] => 26801907
            [19] => 26801908
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.160
        )

)

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

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446