Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
Listing
Price: $420,000Area: WAIPAHU-LOWERStatus: Active
This charming 3-bedroom, 1-bath apartment is located close to grocery stores, food eateries and on ramp to freeway. This lovely unit features a spacious living room that overlooks the inviting pool, creating a serene and relaxing atmosphere. Inside, you'll find beautiful, durable flooring that adds both style and functionality, along with the convenience of an on-site community laundry space. With 1 assigned parking space this unit is perfect for families or anyone seeking a convenient lifestyle in Hawaii! Don’t miss out on this wonderful opportunity! Listing by: BHGRE Advantage Realty (808) 217-7753
array(44) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428513"
}
["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) "E306"
}
["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(60) "https://my.matterport.com/show/?m=K32rfwtws6i&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "420000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(559) "This charming 3-bedroom, 1-bath apartment is located close to grocery stores, food eateries and on ramp to freeway. This lovely unit features a spacious living room that overlooks the inviting pool, creating a serene and relaxing atmosphere. Inside, you'll find beautiful, durable flooring that adds both style and functionality, along with the convenience of an on-site community laundry space. With 1 assigned parking space this unit is perfect for families or anyone seeking a convenient lifestyle in Hawaii! Don’t miss out on this wonderful opportunity!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "868"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Leolua Regent"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "803.25"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "TahitiR@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 217-7753"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Tahiti V Reed"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-23T09:46:35.743"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18444881"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-23"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26814447"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26814447"
[1]=>
string(8) "26814448"
[2]=>
string(8) "26814449"
[3]=>
string(8) "26814450"
[4]=>
string(8) "26814451"
[5]=>
string(8) "26814452"
[6]=>
string(8) "26814453"
[7]=>
string(8) "26814454"
[8]=>
string(8) "26814455"
[9]=>
string(8) "26814456"
[10]=>
string(8) "26814457"
[11]=>
string(8) "26814458"
[12]=>
string(8) "26814459"
[13]=>
string(8) "26814460"
[14]=>
string(8) "26814461"
[15]=>
string(8) "26814462"
[16]=>
string(8) "26814463"
[17]=>
string(8) "26814464"
[18]=>
string(8) "26814465"
[19]=>
string(8) "26814466"
[20]=>
string(8) "26814467"
[21]=>
string(8) "26814468"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428513
)
[StreetNumber] => Array
(
[0] => 94-246
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Leoku
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E306
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=K32rfwtws6i&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 420000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This charming 3-bedroom, 1-bath apartment is located close to grocery stores, food eateries and on ramp to freeway. This lovely unit features a spacious living room that overlooks the inviting pool, creating a serene and relaxing atmosphere. Inside, you'll find beautiful, durable flooring that adds both style and functionality, along with the convenience of an on-site community laundry space. With 1 assigned parking space this unit is perfect for families or anyone seeking a convenient lifestyle in Hawaii! Don’t miss out on this wonderful opportunity!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 868
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] => Leolua Regent
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 803.25
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => TahitiR@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 217-7753
)
[ListAgentFullName] => Array
(
[0] => Tahiti V Reed
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-23T09:46:35.743
)
[Matrix_Unique_ID] => Array
(
[0] => 18444881
)
[ListingContractDate] => Array
(
[0] => 2024-12-23
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26814447
)
[listing_image] => Array
(
[0] => 26814447
[1] => 26814448
[2] => 26814449
[3] => 26814450
[4] => 26814451
[5] => 26814452
[6] => 26814453
[7] => 26814454
[8] => 26814455
[9] => 26814456
[10] => 26814457
[11] => 26814458
[12] => 26814459
[13] => 26814460
[14] => 26814461
[15] => 26814462
[16] => 26814463
[17] => 26814464
[18] => 26814465
[19] => 26814466
[20] => 26814467
[21] => 26814468
)
)
BedsTotal: 3Full Baths: 1Living (sf): 868Year Built: 1969Building Name: Leolua Regent
Property Condition: Above Average,AverageNumber of Parking Spaces: 1View: NoneListing Office: BHGRE Advantage Realty
Maintenance Fees: $803Land Tenure: FS - Fee Simple
