94-670 Lumiauau Street Unit YY/203 Waipahu, HI 96797

Listing
Overview

Price: $598,000
Area: WAIKELE
Status: Sold

Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment property. Contact your agent today! Listing by: Locations LLC (808) 488-7700

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202501857"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-670"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(6) "YY/203"
  }
  ["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) "598000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(498) "Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size
open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and
constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping
center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment
property. Contact your agent today!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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(4) "0.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "811"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1998"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(23) "Village on the Green 2A"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(13) "City,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "517.91"
  }
  ["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(6) "LOCA03"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(33) "John.Quindara@LocationsHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 488-7700"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "John Quindara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-19"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18488803"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-03-19T14:15:02.180"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-01-13"
  }
  ["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) "14:15:02.180"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26838613"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26838613"
    [1]=>
    string(8) "26838614"
    [2]=>
    string(8) "26838615"
    [3]=>
    string(8) "26838616"
    [4]=>
    string(8) "26838617"
    [5]=>
    string(8) "26838618"
    [6]=>
    string(8) "26838619"
    [7]=>
    string(8) "26838620"
    [8]=>
    string(8) "26838621"
    [9]=>
    string(8) "26838622"
    [10]=>
    string(8) "26838623"
    [11]=>
    string(8) "26838624"
    [12]=>
    string(8) "26838625"
    [13]=>
    string(8) "26838626"
    [14]=>
    string(8) "26838627"
    [15]=>
    string(8) "26838628"
    [16]=>
    string(8) "26838629"
    [17]=>
    string(8) "26838630"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202501857
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => YY/203
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size
open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and
constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping
center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment
property. Contact your agent today!
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Village on the Green 2A
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => John.Quindara@LocationsHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 488-7700
        )

    [ListAgentFullName] => Array
        (
            [0] => John Quindara
        )

    [CloseDate] => Array
        (
            [0] => 2025-03-19
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-03-19T14:15:02.180
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-01-13
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:15:02.180
        )

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

    [listing_image] => Array
        (
            [0] => 26838613
            [1] => 26838614
            [2] => 26838615
            [3] => 26838616
            [4] => 26838617
            [5] => 26838618
            [6] => 26838619
            [7] => 26838620
            [8] => 26838621
            [9] => 26838622
            [10] => 26838623
            [11] => 26838624
            [12] => 26838625
            [13] => 26838626
            [14] => 26838627
            [15] => 26838628
            [16] => 26838629
            [17] => 26838630
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Land Area (sf): 0 sf
  • Living (sf): 811
  • Year Built: 1998
  • Building Name: Village on the Green 2A

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: City,Mountain
  • Listing Office: Locations LLC

  • Maintenance Fees: $518
  • 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 March 19, 2025 - 2:15 PM 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.