94-519 Lumiaina Street Unit J104 Waipahu, HI 96797
Listing
Overview
Price: $550,000
Area: WAIKELE
Status: Active
This stunning single-level 2-bedroom, 1-bath townhome in the heart of Waikele offers a perfect blend of modern upgrades and prime location. Recently renovated, the unit features brand new cabinets, elegant quartz countertops, and stylish vinyl flooring throughout, creating a fresh and contemporary living space. Enjoy the privacy of your enclosed, fenced yard, complete with a covered lanai - ideal for outdoor dining, gardening, or simply relaxing. With two convenient parking stalls and ample guest parking just steps away, you'll have easy access to your home and the surrounding amenities. Centrally located in Waikele, this townhome is just 15 minutes from the airport, 30 minutes from the North Shore and 20 minutes to Downtown Honolulu. Plus, you're only a short drive away from the Waikele Premium Outlets, offering shopping, dining, and entertainment right at your fingertips. Listing by: Coldwell Banker Realty (808) 947-8165
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419300"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-519"
}
["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) "J104"
}
["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) "550000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "550000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(893) "This stunning single-level 2-bedroom, 1-bath townhome in the heart of Waikele offers a perfect blend of modern upgrades and prime location. Recently renovated, the unit features brand new cabinets, elegant quartz countertops, and stylish vinyl flooring throughout, creating a fresh and contemporary living space. Enjoy the privacy of your enclosed, fenced yard, complete with a covered lanai - ideal for outdoor dining, gardening, or simply relaxing. With two convenient parking stalls and ample guest parking just steps away, you'll have easy access to your home and the surrounding amenities. Centrally located in Waikele, this townhome is just 15 minutes from the airport, 30 minutes from the North Shore and 20 minutes to Downtown Honolulu. Plus, you're only a short drive away from the Waikele Premium Outlets, offering shopping, dining, and entertainment right at your fingertips."
}
["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(9) "504425.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "657"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1993"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Mahi Ko At Waikele"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "395.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waikele"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP09"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "lucienb@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 947-8165"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Lucien Breault Jr."
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-15T17:00:01.380"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18230634"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-03T13:02:21.870"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26680708"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "26680708"
[1]=>
string(8) "26680709"
[2]=>
string(8) "26680710"
[3]=>
string(8) "26680711"
[4]=>
string(8) "26680712"
[5]=>
string(8) "26680713"
[6]=>
string(8) "26680714"
[7]=>
string(8) "26680715"
[8]=>
string(8) "26680716"
[9]=>
string(8) "26680717"
[10]=>
string(8) "26680718"
[11]=>
string(8) "26680719"
[12]=>
string(8) "26680720"
[13]=>
string(8) "26680721"
[14]=>
string(8) "26680722"
[15]=>
string(8) "26680723"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419300
)
[StreetNumber] => Array
(
[0] => 94-519
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lumiaina
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => J104
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 550000.00
)
[CurrentPrice] => Array
(
[0] => 550000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This stunning single-level 2-bedroom, 1-bath townhome in the heart of Waikele offers a perfect blend of modern upgrades and prime location. Recently renovated, the unit features brand new cabinets, elegant quartz countertops, and stylish vinyl flooring throughout, creating a fresh and contemporary living space. Enjoy the privacy of your enclosed, fenced yard, complete with a covered lanai - ideal for outdoor dining, gardening, or simply relaxing. With two convenient parking stalls and ample guest parking just steps away, you'll have easy access to your home and the surrounding amenities. Centrally located in Waikele, this townhome is just 15 minutes from the airport, 30 minutes from the North Shore and 20 minutes to Downtown Honolulu. Plus, you're only a short drive away from the Waikele Premium Outlets, offering shopping, dining, and entertainment right at your fingertips.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 504425.00
)
[SqftTotal] => Array
(
[0] => 657
)
[YearBuilt] => Array
(
[0] => 1993
)
[BuildingName] => Array
(
[0] => Mahi Ko At Waikele
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 395.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waikele
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => CBPP09
)
[ListAgentEmail] => Array
(
[0] => lucienb@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 947-8165
)
[ListAgentFullName] => Array
(
[0] => Lucien Breault Jr.
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-15T17:00:01.380
)
[Matrix_Unique_ID] => Array
(
[0] => 18230634
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-03T13:02:21.870
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26680708
)
[listing_image] => Array
(
[0] => 26680708
[1] => 26680709
[2] => 26680710
[3] => 26680711
[4] => 26680712
[5] => 26680713
[6] => 26680714
[7] => 26680715
[8] => 26680716
[9] => 26680717
[10] => 26680718
[11] => 26680719
[12] => 26680720
[13] => 26680721
[14] => 26680722
[15] => 26680723
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 504,425
- Living (sf): 657
- Year Built: 1993
- Building Name: Mahi Ko At Waikele
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: None
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $395
- Land Tenure: FS - Fee Simple
- Elementary School: Waikele
- Middle School: Waipahu
- High School: Waipahu
