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

Listing
Overview

Price: $598,000
Area: WAIKELE
Status: Active Under Contract

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) 228-9912

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(21) "Active Under Contract"
  }
  ["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) 228-9912"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "John Quindara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18488803"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-04T14:28:19.840"
  }
  ["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:28:19.840"
  }
  ["_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] => Active Under Contract
        )

    [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) 228-9912
        )

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-04T14:28:19.840
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:28:19.840
        )

    [_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