95-020 WAIHONU Street Unit C1002 Mililani, HI 96789
Listing
Overview
Price: $310,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active Under Contract
Investor Special – Top-Floor Fixer-Upper! Don’t miss this opportunity to transform a cool, breezy top-floor 2-bedroom, 1-bath condo into your dream property. With plenty of potential and a prime location, this unit is ready for your personal touch. Whether you're an experienced investor or looking for a rewarding project, this is your chance to create a space that truly stands out. Take advantage of the natural airflow and top-floor privacy while designing a home that suits your vision. Located in a desirable neighborhood, near to shopping, dining, and major highways, tree top panoramic view, short drive to historic Haleiwa town and north shore beaches. This property offers convenience and investment potential. Act fast—opportunities like this don't stay on the market for long! Listing by: Fahrni Realty (808) 780-1948
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501925"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-020"
}
["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(5) "C1002"
}
["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) "310000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(794) "Investor Special – Top-Floor Fixer-Upper! Don’t miss this opportunity to transform a cool, breezy top-floor 2-bedroom, 1-bath condo into your dream property. With plenty of potential and a prime location, this unit is ready for your personal touch. Whether you're an experienced investor or looking for a rewarding project, this is your chance to create a space that truly stands out. Take advantage of the natural airflow and top-floor privacy while designing a home that suits your vision. Located in a desirable neighborhood, near to shopping, dining, and major highways, tree top panoramic view, short drive to historic Haleiwa town and north shore beaches. This property offers convenience and investment potential. Act fast—opportunities like this don't stay on the market for long!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Fahrni Realty"
}
["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) "182124.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "896"
}
["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(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "959.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Kipapa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "FAHR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(29) "jerome@fahrnirealtyhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 780-1948"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Jerome Edayan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18490306"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-08T08:18:36.990"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:18:36.990"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26839393"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26839393"
[1]=>
string(8) "26839394"
[2]=>
string(8) "26839395"
[3]=>
string(8) "26839396"
[4]=>
string(8) "26839397"
[5]=>
string(8) "26839398"
[6]=>
string(8) "26839399"
[7]=>
string(8) "26839400"
[8]=>
string(8) "26839401"
[9]=>
string(8) "26839402"
[10]=>
string(8) "26839403"
[11]=>
string(8) "26839404"
[12]=>
string(8) "26839405"
[13]=>
string(8) "26839406"
[14]=>
string(8) "26839407"
[15]=>
string(8) "26839408"
[16]=>
string(8) "26839409"
[17]=>
string(8) "26839410"
[18]=>
string(8) "26839411"
[19]=>
string(8) "26839412"
[20]=>
string(8) "26839413"
[21]=>
string(8) "26839414"
[22]=>
string(8) "26839415"
[23]=>
string(8) "26839416"
[24]=>
string(8) "26839417"
[25]=>
string(8) "26839418"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501925
)
[StreetNumber] => Array
(
[0] => 95-020
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => WAIHONU
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => C1002
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 310000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Investor Special – Top-Floor Fixer-Upper! Don’t miss this opportunity to transform a cool, breezy top-floor 2-bedroom, 1-bath condo into your dream property. With plenty of potential and a prime location, this unit is ready for your personal touch. Whether you're an experienced investor or looking for a rewarding project, this is your chance to create a space that truly stands out. Take advantage of the natural airflow and top-floor privacy while designing a home that suits your vision. Located in a desirable neighborhood, near to shopping, dining, and major highways, tree top panoramic view, short drive to historic Haleiwa town and north shore beaches. This property offers convenience and investment potential. Act fast—opportunities like this don't stay on the market for long!
)
[ListOfficeName] => Array
(
[0] => Fahrni Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 182124.00
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Cathedral Pt-Melemanu
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 959.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => FAHR
)
[ListAgentEmail] => Array
(
[0] => jerome@fahrnirealtyhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 780-1948
)
[ListAgentFullName] => Array
(
[0] => Jerome Edayan
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18490306
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-08T08:18:36.990
)
[ListingContractDate] => Array
(
[0] => 2025-01-14
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:18:36.990
)
[_thumbnail_id] => Array
(
[0] => 26839393
)
[listing_image] => Array
(
[0] => 26839393
[1] => 26839394
[2] => 26839395
[3] => 26839396
[4] => 26839397
[5] => 26839398
[6] => 26839399
[7] => 26839400
[8] => 26839401
[9] => 26839402
[10] => 26839403
[11] => 26839404
[12] => 26839405
[13] => 26839406
[14] => 26839407
[15] => 26839408
[16] => 26839409
[17] => 26839410
[18] => 26839411
[19] => 26839412
[20] => 26839413
[21] => 26839414
[22] => 26839415
[23] => 26839416
[24] => 26839417
[25] => 26839418
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 182,124 sf
- Living (sf): 896
- Year Built: 1973
- Building Name: Cathedral Pt-Melemanu
- Property Condition: Average
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: Fahrni Realty
- Maintenance Fees: $959
- Land Tenure: FS - Fee Simple
- Elementary School: Kipapa
- Middle School: Mililani
- High School: Mililani
