The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
Listing Overview
Price: $550,000
Area: MAILI
Status: Active
Minutes from Mermaid Cave, world-class beaches and Ko'olina resort, this lovingly maintained 4 full bedroom and 3 bath home with full bedroom and bath on primary level is a hidden gem. Upstairs deck offers views of the ocean and is a great place to chill. There is a second deck off the ceramic tiled living area that give you access to the pet-friendly yard. A great community with a refreshing pool. Enjoy the white sandy beaches. This is a must-see. VA and USDA approved. Listing by: Soldier To Soldier HI Realty (808) 389-0489
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417183"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "87-176"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Maipalaoa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "MN29"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96792"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(35) "https://view.property/2265546?idx=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "550000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(475) "Minutes from Mermaid Cave, world-class beaches and Ko'olina resort, this lovingly maintained 4 full bedroom and 3 bath home with full bedroom and bath on primary level is a hidden gem. Upstairs deck offers views of the ocean and is a great place to chill. There is a second deck off the ceramic tiled living area that give you access to the pet-friendly yard. A great community with a refreshing pool. Enjoy the white sandy beaches. This is a must-see. VA and USDA approved."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Soldier To Soldier HI Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3868.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1865"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2012"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Maili Beach Place"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "632.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) "STSH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "KenGines@FlatFee5000Hawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 389-0489"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Ken Gines"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-28T08:44:37.527"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18159827"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Leeward"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26642295"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26642295"
[1]=>
string(8) "26642296"
[2]=>
string(8) "26642297"
[3]=>
string(8) "26642298"
[4]=>
string(8) "26642299"
[5]=>
string(8) "26642300"
[6]=>
string(8) "26642301"
[7]=>
string(8) "26642302"
[8]=>
string(8) "26642303"
[9]=>
string(8) "26642304"
[10]=>
string(8) "26642305"
[11]=>
string(8) "26642306"
[12]=>
string(8) "26642307"
[13]=>
string(8) "26642308"
[14]=>
string(8) "26642309"
[15]=>
string(8) "26642310"
[16]=>
string(8) "26642311"
[17]=>
string(8) "26642312"
[18]=>
string(8) "26642313"
[19]=>
string(8) "26642314"
[20]=>
string(8) "26642315"
[21]=>
string(8) "26642316"
[22]=>
string(8) "26642317"
[23]=>
string(8) "26642318"
[24]=>
string(8) "26642319"
[25]=>
string(8) "26642320"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-07-30"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:44:37.527"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417183
)
[StreetNumber] => Array
(
[0] => 87-176
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Maipalaoa
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => MN29
)
[City] => Array
(
[0] => Waianae
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96792
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://view.property/2265546?idx=1
)
[ListPrice] => Array
(
[0] => 550000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Minutes from Mermaid Cave, world-class beaches and Ko'olina resort, this lovingly maintained 4 full bedroom and 3 bath home with full bedroom and bath on primary level is a hidden gem. Upstairs deck offers views of the ocean and is a great place to chill. There is a second deck off the ceramic tiled living area that give you access to the pet-friendly yard. A great community with a refreshing pool. Enjoy the white sandy beaches. This is a must-see. VA and USDA approved.
)
[ListOfficeName] => Array
(
[0] => Soldier To Soldier HI Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 3868.00
)
[SqftTotal] => Array
(
[0] => 1865
)
[YearBuilt] => Array
(
[0] => 2012
)
[BuildingName] => Array
(
[0] => Maili Beach Place
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 632.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => STSH
)
[ListAgentEmail] => Array
(
[0] => KenGines@FlatFee5000Hawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 389-0489
)
[ListAgentFullName] => Array
(
[0] => Ken Gines
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-28T08:44:37.527
)
[Matrix_Unique_ID] => Array
(
[0] => 18159827
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26642295
)
[listing_image] => Array
(
[0] => 26642295
[1] => 26642296
[2] => 26642297
[3] => 26642298
[4] => 26642299
[5] => 26642300
[6] => 26642301
[7] => 26642302
[8] => 26642303
[9] => 26642304
[10] => 26642305
[11] => 26642306
[12] => 26642307
[13] => 26642308
[14] => 26642309
[15] => 26642310
[16] => 26642311
[17] => 26642312
[18] => 26642313
[19] => 26642314
[20] => 26642315
[21] => 26642316
[22] => 26642317
[23] => 26642318
[24] => 26642319
[25] => 26642320
)
[ListingContractDate] => Array
(
[0] => 2024-07-30
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:44:37.527
)
)
BedsTotal: 4
Full Baths: 3
Land Area (sf): 3,868 sf
Living (sf): 1,865
Year Built: 2012
Building Name: Maili Beach Place
Property Condition: Excellent
Number of Parking Spaces: 2
View: Mountain,Ocean
Listing Office: Soldier To Soldier HI Realty
Maintenance Fees: $632
Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 28, 2024 - 8:44 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.