Previous Next

95-014 Waihonu Street Unit E204 Mililani, HI 96789

Listing
Overview

Price: $249,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Sold (Limited photos per MLS privacy policy)

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202517026"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-014"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waihonu"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "E204"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96789"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "249000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(831) "Don’t miss this fantastic opportunity to own a one-bedroom, one-bath condo with one assigned parking stall in the highly desirable Cathedral Point community in Mililani. This freshly painted second-floor unit enjoys cool island breezes, an open layout, and a private covered lanai—perfect for morning coffee or evening unwinding. This home is priced to sell and offers incredible potential to create your ideal space or investment property.

Whether you're a first-time homebuyer looking to break into the Mililani market or an investor seeking rental income, this unit is a smart choice. Conveniently located near Mililani Town Center, shopping, dining, schools, parks, and easy freeway access. Enjoy the best of central Oahu living in a community known for its quality of life. Bring your vision and make this one your own!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Plumeria Hawaii Properties LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "704"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(21) "Cathedral Pt-Melemanu"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "759.63"
  }
  ["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) "ARIA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "tiffany.agpaoa@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 729-6006"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Tiffany Agpaoa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-10"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18894952"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-10T10:17:27.923"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-30"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "10:17:27.923"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27088314"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27088314"
    [1]=>
    string(8) "27088315"
    [2]=>
    string(8) "27088316"
    [3]=>
    string(8) "27088317"
    [4]=>
    string(8) "27088318"
    [5]=>
    string(8) "27088319"
    [6]=>
    string(8) "27088320"
    [7]=>
    string(8) "27088321"
    [8]=>
    string(8) "27088322"
    [9]=>
    string(8) "27088323"
    [10]=>
    string(8) "27088324"
    [11]=>
    string(8) "27088325"
    [12]=>
    string(8) "27088326"
    [13]=>
    string(8) "27088327"
    [14]=>
    string(8) "27088328"
    [15]=>
    string(8) "27088329"
    [16]=>
    string(8) "27088330"
    [17]=>
    string(8) "27088331"
    [18]=>
    string(8) "27088332"
    [19]=>
    string(8) "27088333"
    [20]=>
    string(8) "27088334"
    [21]=>
    string(8) "27088335"
    [22]=>
    string(8) "27088336"
    [23]=>
    string(8) "27088337"
    [24]=>
    string(8) "27088338"
    [25]=>
    string(8) "27088339"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202517026
        )

    [StreetNumber] => Array
        (
            [0] => 95-014
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Waihonu
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => E204
        )

    [City] => Array
        (
            [0] => Mililani
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96789
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 249000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

    [Status] => Array
        (
            [0] => Sold
        )

    [PublicRemarks] => Array
        (
            [0] => Don’t miss this fantastic opportunity to own a one-bedroom, one-bath condo with one assigned parking stall in the highly desirable Cathedral Point community in Mililani. This freshly painted second-floor unit enjoys cool island breezes, an open layout, and a private covered lanai—perfect for morning coffee or evening unwinding. This home is priced to sell and offers incredible potential to create your ideal space or investment property.

Whether you're a first-time homebuyer looking to break into the Mililani market or an investor seeking rental income, this unit is a smart choice. Conveniently located near Mililani Town Center, shopping, dining, schools, parks, and easy freeway access. Enjoy the best of central Oahu living in a community known for its quality of life. Bring your vision and make this one your own!
        )

    [ListOfficeName] => Array
        (
            [0] => Plumeria Hawaii Properties LLC
        )

    [BedsTotal] => Array
        (
            [0] => 1
        )

    [BathsFull] => Array
        (
            [0] => 1
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 
        )

    [SqftTotal] => Array
        (
            [0] => 704
        )

    [YearBuilt] => Array
        (
            [0] => 1973
        )

    [BuildingName] => Array
        (
            [0] => Cathedral Pt-Melemanu
        )

    [PropertyCondition] => Array
        (
            [0] => Average
        )

    [ParkingTotal] => Array
        (
            [0] => 1
        )

    [StoriesType] => Array
        (
            [0] => 4-7
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 759.63
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => ARIA
        )

    [ListAgentEmail] => Array
        (
            [0] => tiffany.agpaoa@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 729-6006
        )

    [ListAgentFullName] => Array
        (
            [0] => Tiffany Agpaoa
        )

    [CloseDate] => Array
        (
            [0] => 2025-10-10
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18894952
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-10T10:17:27.923
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-07-30
        )

    [MLSAreaMajor] => Array
        (
            [0] => Central
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 10:17:27.923
        )

    [_thumbnail_id] => Array
        (
            [0] => 27088314
        )

    [listing_image] => Array
        (
            [0] => 27088314
            [1] => 27088315
            [2] => 27088316
            [3] => 27088317
            [4] => 27088318
            [5] => 27088319
            [6] => 27088320
            [7] => 27088321
            [8] => 27088322
            [9] => 27088323
            [10] => 27088324
            [11] => 27088325
            [12] => 27088326
            [13] => 27088327
            [14] => 27088328
            [15] => 27088329
            [16] => 27088330
            [17] => 27088331
            [18] => 27088332
            [19] => 27088333
            [20] => 27088334
            [21] => 27088335
            [22] => 27088336
            [23] => 27088337
            [24] => 27088338
            [25] => 27088339
        )

)

PROPERTY INFO

• BedsTotal: 1
• Full Baths: 1
• Living (sf): 704
• Year Built: 1973
• Building Name: Cathedral Pt-Melemanu

KEY FEATURES

• Property Condition: Average
• Number of Parking Spaces: 1
• View: None
• Listing Office: Plumeria Hawaii Properties LLC

FINANCIAL INFO

• Maintenance Fees: $760
• Land Tenure: FS - Fee Simple

SCHOOLS

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 October 10, 2025 - 10:17 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.