94-642 Lumiauau Street Unit B3 Waipahu, HI 96797
Listing
Overview
Price: $740,000
Area: WAIKELE
Status: Active Under Contract
Move in Ready!! This beautifully upgraded 2bdrm/2.5bath/2 car garage gem at the Village on the Green is now available. Step inside and be greeted by a spacious living room with Brand NEW flooring. Within the past three years, this home has undergone a remarkable transformation, including interior paint, upgraded countertops, new flooring throughout, and new kitchen appliances.
Indulge in the privacy of your own enclosed yard, providing a serene escape or a fantastic area for entertaining guests. Conveniently located near the guest parking area. You'll have effortless access to all the amenities this community has to offer. With the freeway and Waikele Premium Outlet Mall just minutes away, you'll have endless options for shopping, dining, and entertainment right at your fingertips. Don't miss out on this exceptional opportunity to own a meticulously maintained townhome in a highly sought-after location! Most of the photos have been virtually staged/enhanced. First Sunday Open House 7/16 2-5pm. Listing by: BHGRE Advantage Realty West (808) 670-2600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202311486"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-642"
}
["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(2) "B3"
}
["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) "740000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "740000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1010) "Move in Ready!! This beautifully upgraded 2bdrm/2.5bath/2 car garage gem at the Village on the Green is now available. Step inside and be greeted by a spacious living room with Brand NEW flooring. Within the past three years, this home has undergone a remarkable transformation, including interior paint, upgraded countertops, new flooring throughout, and new kitchen appliances.
Indulge in the privacy of your own enclosed yard, providing a serene escape or a fantastic area for entertaining guests. Conveniently located near the guest parking area. You'll have effortless access to all the amenities this community has to offer. With the freeway and Waikele Premium Outlet Mall just minutes away, you'll have endless options for shopping, dining, and entertainment right at your fingertips. Don't miss out on this exceptional opportunity to own a meticulously maintained townhome in a highly sought-after location! Most of the photos have been virtually staged/enhanced. First Sunday Open House 7/16 2-5pm."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "BHGRE Advantage Realty West"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1338"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2001"
}
["BuildingName"]=>
array(1) {
[0]=>
string(23) "Village On The Green 2B"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "661.61"
}
["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) "ADVW"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "asakon@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 670-2600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Asako Nishikawa"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-10-01T17:00:01.427"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17337532"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-12T08:29:23.867"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25851673"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25851673"
[1]=>
string(8) "25851674"
[2]=>
string(8) "25851675"
[3]=>
string(8) "25851676"
[4]=>
string(8) "25851677"
[5]=>
string(8) "25851678"
[6]=>
string(8) "25851679"
[7]=>
string(8) "25851680"
[8]=>
string(8) "25851681"
[9]=>
string(8) "25851682"
[10]=>
string(8) "25851683"
[11]=>
string(8) "25851684"
[12]=>
string(8) "25851685"
[13]=>
string(8) "25851686"
[14]=>
string(8) "25851687"
[15]=>
string(8) "25851688"
[16]=>
string(8) "25851689"
[17]=>
string(8) "25851690"
[18]=>
string(8) "25851691"
[19]=>
string(8) "25851692"
[20]=>
string(8) "25851693"
[21]=>
string(8) "25851694"
[22]=>
string(8) "25851695"
[23]=>
string(8) "25851696"
[24]=>
string(8) "25851697"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202311486
)
[StreetNumber] => Array
(
[0] => 94-642
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lumiauau
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => B3
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 740000.00
)
[CurrentPrice] => Array
(
[0] => 740000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Move in Ready!! This beautifully upgraded 2bdrm/2.5bath/2 car garage gem at the Village on the Green is now available. Step inside and be greeted by a spacious living room with Brand NEW flooring. Within the past three years, this home has undergone a remarkable transformation, including interior paint, upgraded countertops, new flooring throughout, and new kitchen appliances.
Indulge in the privacy of your own enclosed yard, providing a serene escape or a fantastic area for entertaining guests. Conveniently located near the guest parking area. You'll have effortless access to all the amenities this community has to offer. With the freeway and Waikele Premium Outlet Mall just minutes away, you'll have endless options for shopping, dining, and entertainment right at your fingertips. Don't miss out on this exceptional opportunity to own a meticulously maintained townhome in a highly sought-after location! Most of the photos have been virtually staged/enhanced. First Sunday Open House 7/16 2-5pm.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty West
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1338
)
[YearBuilt] => Array
(
[0] => 2001
)
[BuildingName] => Array
(
[0] => Village On The Green 2B
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 661.61
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVW
)
[ListAgentEmail] => Array
(
[0] => asakon@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 670-2600
)
[ListAgentFullName] => Array
(
[0] => Asako Nishikawa
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-10-01T17:00:01.427
)
[Matrix_Unique_ID] => Array
(
[0] => 17337532
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-12T08:29:23.867
)
[_thumbnail_id] => Array
(
[0] => 25851673
)
[listing_image] => Array
(
[0] => 25851673
[1] => 25851674
[2] => 25851675
[3] => 25851676
[4] => 25851677
[5] => 25851678
[6] => 25851679
[7] => 25851680
[8] => 25851681
[9] => 25851682
[10] => 25851683
[11] => 25851684
[12] => 25851685
[13] => 25851686
[14] => 25851687
[15] => 25851688
[16] => 25851689
[17] => 25851690
[18] => 25851691
[19] => 25851692
[20] => 25851693
[21] => 25851694
[22] => 25851695
[23] => 25851696
[24] => 25851697
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 2
- Full Baths: 2
- Half Baths: 1
- Living (sf): 1,338
- Year Built: 2001
- Building Name: Village On The Green 2B
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: None
- Listing Office: BHGRE Advantage Realty West
- Maintenance Fees: $662
- Land Tenure: FS - Fee Simple
