Listing
Overview
Price: $939,000
Area: WEST MARINA
Status: Active
This rare gem is the only fully remodeled, open-concept 2-bedroom Esplanade unit currently on the market, beautifully transformed from top to bottom. Step inside to discover elegance, travertine flooring, sleek modern cabinetry in the kitchen and bathrooms, and refined granite countertops. The unit boasts smooth ceilings and stainless-steel appliances, all contributing to its sophisticated appeal. Wake up to stunning marina views from your bed and enjoy the captivating sight of Koko Head from the kitchen. With negotiable furniture, this condo offers a truly turnkey, move-in-ready opportunity. Additionally, it features an EV charging station and boat slips, providing the convenience of docking your boat just a short stroll away. The Esplanade's impressive amenities include tennis courts, a saltwater lap pool, a well-equipped exercise room, and barbecue areas. Unit 25C offers remarkable value in today’s market—come see it for yourself! Listing by: Damon HI Pac Intl Prop LLC (808) 468-1838
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424788"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "500"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(13) "Lunalilo Home"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "25C"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96825"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(54) "https://player.vimeo.com/video/1027887021?h=715211af94"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "939000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "939000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(951) "This rare gem is the only fully remodeled, open-concept 2-bedroom Esplanade unit currently on the market, beautifully transformed from top to bottom. Step inside to discover elegance, travertine flooring, sleek modern cabinetry in the kitchen and bathrooms, and refined granite countertops. The unit boasts smooth ceilings and stainless-steel appliances, all contributing to its sophisticated appeal. Wake up to stunning marina views from your bed and enjoy the captivating sight of Koko Head from the kitchen. With negotiable furniture, this condo offers a truly turnkey, move-in-ready opportunity. Additionally, it features an EV charging station and boat slips, providing the convenience of docking your boat just a short stroll away. The Esplanade's impressive amenities include tennis courts, a saltwater lap pool, a well-equipped exercise room, and barbecue areas. Unit 25C offers remarkable value in today’s market—come see it for yourself!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Damon HI Pac Intl Prop LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "205821.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1183"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "Esplanade"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(41) "Diamond Head,Garden,Marina/Canal,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1200.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Koko Head"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kaiser"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "DAHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "damon@hawaiidamon.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 468-1838"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Damon B Rhys"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-24T17:30:01.273"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18350055"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-07T18:08:04.580"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Marina,Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26761827"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26761827"
[1]=>
string(8) "26761828"
[2]=>
string(8) "26761829"
[3]=>
string(8) "26761830"
[4]=>
string(8) "26761831"
[5]=>
string(8) "26761832"
[6]=>
string(8) "26761833"
[7]=>
string(8) "26761834"
[8]=>
string(8) "26761835"
[9]=>
string(8) "26761836"
[10]=>
string(8) "26761837"
[11]=>
string(8) "26761838"
[12]=>
string(8) "26761839"
[13]=>
string(8) "26761840"
[14]=>
string(8) "26761841"
[15]=>
string(8) "26761842"
[16]=>
string(8) "26761843"
[17]=>
string(8) "26761844"
[18]=>
string(8) "26761845"
[19]=>
string(8) "26761846"
[20]=>
string(8) "26761847"
[21]=>
string(8) "26761848"
[22]=>
string(8) "26761849"
[23]=>
string(8) "26761850"
[24]=>
string(8) "26761851"
[25]=>
string(8) "26761867"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424788
)
[StreetNumber] => Array
(
[0] => 500
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lunalilo Home
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 25C
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96825
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1027887021?h=715211af94
)
[ListPrice] => Array
(
[0] => 939000.00
)
[CurrentPrice] => Array
(
[0] => 939000.00
)
[Neighbourhood] => Array
(
[0] => WEST MARINA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This rare gem is the only fully remodeled, open-concept 2-bedroom Esplanade unit currently on the market, beautifully transformed from top to bottom. Step inside to discover elegance, travertine flooring, sleek modern cabinetry in the kitchen and bathrooms, and refined granite countertops. The unit boasts smooth ceilings and stainless-steel appliances, all contributing to its sophisticated appeal. Wake up to stunning marina views from your bed and enjoy the captivating sight of Koko Head from the kitchen. With negotiable furniture, this condo offers a truly turnkey, move-in-ready opportunity. Additionally, it features an EV charging station and boat slips, providing the convenience of docking your boat just a short stroll away. The Esplanade's impressive amenities include tennis courts, a saltwater lap pool, a well-equipped exercise room, and barbecue areas. Unit 25C offers remarkable value in today’s market—come see it for yourself!
)
[ListOfficeName] => Array
(
[0] => Damon HI Pac Intl Prop LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 205821.00
)
[SqftTotal] => Array
(
[0] => 1183
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Esplanade
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Diamond Head,Garden,Marina/Canal,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1200.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Koko Head
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kaiser
)
[ListOfficeMLSID] => Array
(
[0] => DAHI
)
[ListAgentEmail] => Array
(
[0] => damon@hawaiidamon.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 468-1838
)
[ListAgentFullName] => Array
(
[0] => Damon B Rhys
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-24T17:30:01.273
)
[Matrix_Unique_ID] => Array
(
[0] => 18350055
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-07T18:08:04.580
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] => Marina,Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26761827
)
[listing_image] => Array
(
[0] => 26761827
[1] => 26761828
[2] => 26761829
[3] => 26761830
[4] => 26761831
[5] => 26761832
[6] => 26761833
[7] => 26761834
[8] => 26761835
[9] => 26761836
[10] => 26761837
[11] => 26761838
[12] => 26761839
[13] => 26761840
[14] => 26761841
[15] => 26761842
[16] => 26761843
[17] => 26761844
[18] => 26761845
[19] => 26761846
[20] => 26761847
[21] => 26761848
[22] => 26761849
[23] => 26761850
[24] => 26761851
[25] => 26761867
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 205,821
- Living (sf): 1,183
- Year Built: 1973
- Building Name: Esplanade
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Diamond Head,Garden,Marina/Canal,Mountain
- Listing Office: Damon HI Pac Intl Prop LLC
- Maintenance Fees: $1,200
- Land Tenure: FS - Fee Simple
- Elementary School: Koko Head
- Middle School: Niu Valley
- High School: Kaiser
