Listing
Overview
Price: $934,888
Area: WEST MARINA
Status: Active
This rare gem is the fully remodeled, open-concept, 2-bedroom Esplanade unit currently on the market. Beautifully transformed from top to bottom. Discover elegance with African Mahogany cabinets, refined granite countertops, stainless steel appliances. New carpet and travertine throughout, plantation shutters and 2 fully remodeled bathrooms. The unit boasts smooth ceilings contributing to its sophisticated appeal. Wake up to stunning marina views from the living room to the bedroom as well as gorgeous sun coming up over Koko head from y our kitchen. This unit is fully furnished and offers a truly turnkey, move in ready opportunity. The unit has 2 covered parking stalls with ample storage in them as well as your own EV charger. Features include boat slips, tennis courts, a saltwater lap pool, well equipped exercise room and barbecue areas. This is your chance to love where you live! Listing by: Damon HI Pac Intl Prop LLC (808) 358-2331
array(48) {
["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) "934888.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(903) "This rare gem is the fully remodeled, open-concept, 2-bedroom Esplanade unit currently on the market. Beautifully transformed from top to bottom. Discover elegance with African Mahogany cabinets, refined granite countertops, stainless steel appliances. New carpet and travertine throughout, plantation shutters and 2 fully remodeled bathrooms. The unit boasts smooth ceilings contributing to its sophisticated appeal. Wake up to stunning marina views from the living room to the bedroom as well as gorgeous sun coming up over Koko head from y our kitchen. This unit is fully furnished and offers a truly turnkey, move in ready opportunity. The unit has 2 covered parking stalls with ample storage in them as well as your own EV charger. Features include boat slips, tennis courts, a saltwater lap pool, well equipped exercise room and barbecue areas. This is your chance to love where you live!"
}
["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) "1286.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) 358-2331"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Damon B Rhys"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-19T17:00:01.717"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18350055"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Marina,Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_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"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-08"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.717"
}
}
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] => 934888.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WEST MARINA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This rare gem is the fully remodeled, open-concept, 2-bedroom Esplanade unit currently on the market. Beautifully transformed from top to bottom. Discover elegance with African Mahogany cabinets, refined granite countertops, stainless steel appliances. New carpet and travertine throughout, plantation shutters and 2 fully remodeled bathrooms. The unit boasts smooth ceilings contributing to its sophisticated appeal. Wake up to stunning marina views from the living room to the bedroom as well as gorgeous sun coming up over Koko head from y our kitchen. This unit is fully furnished and offers a truly turnkey, move in ready opportunity. The unit has 2 covered parking stalls with ample storage in them as well as your own EV charger. Features include boat slips, tennis courts, a saltwater lap pool, well equipped exercise room and barbecue areas. This is your chance to love where you live!
)
[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] => 1286.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) 358-2331
)
[ListAgentFullName] => Array
(
[0] => Damon B Rhys
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-19T17:00:01.717
)
[Matrix_Unique_ID] => Array
(
[0] => 18350055
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] => Marina,Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_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
)
[ListingContractDate] => Array
(
[0] => 2024-11-08
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.717
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 205,821 sf
- 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,286
- Land Tenure: FS - Fee Simple
- Elementary School: Koko Head
- Middle School: Niu Valley
- High School: Kaiser
