94-246 Leoku Street Unit G323 Waipahu, HI 96797
Listing
Overview
Price: $399,000
Area: WAIPAHU-LOWER
Status: Active
CONVENIENCE at its best. Come home to this 3rd floor unit at Leolua Regent.
The home features a very spacious living area with 2 bedrooms, 1 full bath and 1 assigned parking. The flooring is equipped with hardwood throughout the home, and plenty of storage space. The complex offers a community pool perfect for relaxing poolside or cooling off in the water, and a community laundry. Walking distance from one of the Honolulu Skyline Rail Stations. This home is adjacent to Seafood City, shopping centers, many grocery stores, eateries, schools, public transportations, and has easy freeway access. SELLERS ARE OFFERING CONCESSIONS TO BUYERS. Listing by: Ohana Investment Realty LLC (808) 206-4867
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202502279"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-246"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Leoku"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "G323"
}
["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) "399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(646) "CONVENIENCE at its best. Come home to this 3rd floor unit at Leolua Regent.
The home features a very spacious living area with 2 bedrooms, 1 full bath and 1 assigned parking. The flooring is equipped with hardwood throughout the home, and plenty of storage space. The complex offers a community pool perfect for relaxing poolside or cooling off in the water, and a community laundry. Walking distance from one of the Honolulu Skyline Rail Stations. This home is adjacent to Seafood City, shopping centers, many grocery stores, eateries, schools, public transportations, and has easy freeway access. SELLERS ARE OFFERING CONCESSIONS TO BUYERS."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Ohana Investment Realty LLC"
}
["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) "166878.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "712"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Leolua Regent"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "760.00"
}
["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) "ROIC"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(32) "contact@vincenthawaiirealtor.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 206-4867"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(20) "Vincent Santabarbara"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18500479"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-02T17:00:01.510"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-20"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.510"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26847627"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26847627"
[1]=>
string(8) "26847628"
[2]=>
string(8) "26847629"
[3]=>
string(8) "26847630"
[4]=>
string(8) "26847631"
[5]=>
string(8) "26847632"
[6]=>
string(8) "26847633"
[7]=>
string(8) "26847634"
[8]=>
string(8) "26847635"
[9]=>
string(8) "26847636"
[10]=>
string(8) "26847637"
[11]=>
string(8) "26847638"
[12]=>
string(8) "26847639"
[13]=>
string(8) "26847640"
[14]=>
string(8) "26847641"
[15]=>
string(8) "26847642"
[16]=>
string(8) "26847643"
[17]=>
string(8) "26847644"
[18]=>
string(8) "26847645"
[19]=>
string(8) "26847646"
[20]=>
string(8) "26847647"
[21]=>
string(8) "26847648"
[22]=>
string(8) "26847649"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202502279
)
[StreetNumber] => Array
(
[0] => 94-246
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Leoku
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => G323
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 399000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => CONVENIENCE at its best. Come home to this 3rd floor unit at Leolua Regent.
The home features a very spacious living area with 2 bedrooms, 1 full bath and 1 assigned parking. The flooring is equipped with hardwood throughout the home, and plenty of storage space. The complex offers a community pool perfect for relaxing poolside or cooling off in the water, and a community laundry. Walking distance from one of the Honolulu Skyline Rail Stations. This home is adjacent to Seafood City, shopping centers, many grocery stores, eateries, schools, public transportations, and has easy freeway access. SELLERS ARE OFFERING CONCESSIONS TO BUYERS.
)
[ListOfficeName] => Array
(
[0] => Ohana Investment Realty LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 166878.00
)
[SqftTotal] => Array
(
[0] => 712
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] => Leolua Regent
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 760.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ROIC
)
[ListAgentEmail] => Array
(
[0] => contact@vincenthawaiirealtor.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 206-4867
)
[ListAgentFullName] => Array
(
[0] => Vincent Santabarbara
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18500479
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-02T17:00:01.510
)
[ListingContractDate] => Array
(
[0] => 2025-01-20
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.510
)
[_thumbnail_id] => Array
(
[0] => 26847627
)
[listing_image] => Array
(
[0] => 26847627
[1] => 26847628
[2] => 26847629
[3] => 26847630
[4] => 26847631
[5] => 26847632
[6] => 26847633
[7] => 26847634
[8] => 26847635
[9] => 26847636
[10] => 26847637
[11] => 26847638
[12] => 26847639
[13] => 26847640
[14] => 26847641
[15] => 26847642
[16] => 26847643
[17] => 26847644
[18] => 26847645
[19] => 26847646
[20] => 26847647
[21] => 26847648
[22] => 26847649
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 166,878 sf
- Living (sf): 712
- Year Built: 1969
- Building Name: Leolua Regent
- Property Condition: Average
- Number of Parking Spaces: 1
- View: None
- Listing Office: Ohana Investment Realty LLC
- Maintenance Fees: $760
- Land Tenure: FS - Fee Simple
