Listing
Overview
Price: $490,000
Area: MILILANI AREA
Status: Pending
Welcome to this charming 2-bedroom, 1-bath condo located in the highly desirable Mililani Terrace. This second-floor unit showcases a well-maintained living space, complete with newer appliances and a new water heater. The remodeled bathroom features a walk-in shower, and the convenience of in-unit laundry that includes side-by-side washer and dryer. Enjoy the cool breezes with no buildings behind you. One of the two parking stalls is conveniently located right outside the unit, and there are plenty of guest stalls nearby. This home is near Mililani Town Center, theaters, restaurants, shopping, and more, making every day errands a breeze. Additionally, residents have full access to Mililani Town Association amenities, including a pool, gym, and tennis and basketball courts. This property offers a perfect setting for families in a friendly community with ample guest parking. Make coming home a dream in this delightful condo! Listing by: BHGRE Advantage Realty (808) 261-1800
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415122"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-654"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Hanile"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "D202"
}
["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(59) "https://listings.hetproductions.com/sites/aaawaxv/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "490000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "490000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "MILILANI AREA"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(937) "Welcome to this charming 2-bedroom, 1-bath condo located in the highly desirable Mililani Terrace. This second-floor unit showcases a well-maintained living space, complete with newer appliances and a new water heater. The remodeled bathroom features a walk-in shower, and the convenience of in-unit laundry that includes side-by-side washer and dryer. Enjoy the cool breezes with no buildings behind you. One of the two parking stalls is conveniently located right outside the unit, and there are plenty of guest stalls nearby. This home is near Mililani Town Center, theaters, restaurants, shopping, and more, making every day errands a breeze. Additionally, residents have full access to Mililani Town Association amenities, including a pool, gym, and tennis and basketball courts. This property offers a perfect setting for families in a friendly community with ample guest parking. Make coming home a dream in this delightful condo!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage 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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "723"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1986"
}
["BuildingName"]=>
array(1) {
[0]=>
string(16) "Mililani Terrace"
}
["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(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "493.91"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(14) "Mililani Waena"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "WendyT@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Wendy N Tenn"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-09T14:01:26.150"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18100812"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-19T11:53:09.547"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26628667"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26628667"
[1]=>
string(8) "26628668"
[2]=>
string(8) "26628669"
[3]=>
string(8) "26628670"
[4]=>
string(8) "26628671"
[5]=>
string(8) "26628672"
[6]=>
string(8) "26628673"
[7]=>
string(8) "26628674"
[8]=>
string(8) "26628675"
[9]=>
string(8) "26628676"
[10]=>
string(8) "26628677"
[11]=>
string(8) "26628678"
[12]=>
string(8) "26628679"
[13]=>
string(8) "26628680"
[14]=>
string(8) "26628681"
[15]=>
string(8) "26628682"
[16]=>
string(8) "26628683"
[17]=>
string(8) "26628684"
[18]=>
string(8) "26628685"
[19]=>
string(8) "26628686"
[20]=>
string(8) "26628687"
[21]=>
string(8) "26628688"
[22]=>
string(8) "26628689"
[23]=>
string(8) "26628690"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415122
)
[StreetNumber] => Array
(
[0] => 95-654
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Hanile
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => D202
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/aaawaxv/unbranded
)
[ListPrice] => Array
(
[0] => 490000.00
)
[CurrentPrice] => Array
(
[0] => 490000.00
)
[Neighbourhood] => Array
(
[0] => MILILANI AREA
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Welcome to this charming 2-bedroom, 1-bath condo located in the highly desirable Mililani Terrace. This second-floor unit showcases a well-maintained living space, complete with newer appliances and a new water heater. The remodeled bathroom features a walk-in shower, and the convenience of in-unit laundry that includes side-by-side washer and dryer. Enjoy the cool breezes with no buildings behind you. One of the two parking stalls is conveniently located right outside the unit, and there are plenty of guest stalls nearby. This home is near Mililani Town Center, theaters, restaurants, shopping, and more, making every day errands a breeze. Additionally, residents have full access to Mililani Town Association amenities, including a pool, gym, and tennis and basketball courts. This property offers a perfect setting for families in a friendly community with ample guest parking. Make coming home a dream in this delightful condo!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 723
)
[YearBuilt] => Array
(
[0] => 1986
)
[BuildingName] => Array
(
[0] => Mililani Terrace
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 493.91
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Mililani Waena
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ADVG02
)
[ListAgentEmail] => Array
(
[0] => WendyT@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 261-1800
)
[ListAgentFullName] => Array
(
[0] => Wendy N Tenn
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-09T14:01:26.150
)
[Matrix_Unique_ID] => Array
(
[0] => 18100812
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-19T11:53:09.547
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26628667
)
[listing_image] => Array
(
[0] => 26628667
[1] => 26628668
[2] => 26628669
[3] => 26628670
[4] => 26628671
[5] => 26628672
[6] => 26628673
[7] => 26628674
[8] => 26628675
[9] => 26628676
[10] => 26628677
[11] => 26628678
[12] => 26628679
[13] => 26628680
[14] => 26628681
[15] => 26628682
[16] => 26628683
[17] => 26628684
[18] => 26628685
[19] => 26628686
[20] => 26628687
[21] => 26628688
[22] => 26628689
[23] => 26628690
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 723
- Year Built: 1986
- Building Name: Mililani Terrace
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: None
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $494
- Land Tenure: FS - Fee Simple
- Elementary School: Mililani Waena
- Middle School: Mililani
- High School: Mililani
