87-176 Maipalaoa Road Unit MN29 Waianae, HI 96792

Take a Virtual Tour

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

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.