Listing
Overview
Price: $875,000
Area: WEST MARINA
Status: Active
New Price! The Esplanade is paradise in the heart of Hawaii Kai. This two-bed/two-bath condo is a stunning, move-in-ready, gem located right on the water, and boasts breathtaking views. The open layout is flooded with natural light, enhanced by cool tradewind breezes creating a refreshing ambiance. This turn-key property is impeccably clean and beautifully maintained, promising not to disappoint. The recently remodeled kitchen and bathrooms feature elegant granite countertops and high-quality real wood cabinets offering both style and function. Additional features include new central A/C, custom-tiled showers, and automated blinds in each room. The private 119 sf screened lanai overlooking the marina and the garden grounds go perfect with your morning coffee. The well-run HOA includes resort-like amenities including private boat docks, a saltwater pool, jacuzzi, full gym, sauna, tennis/pickleball courts, 5 BBQ grottos, party room, secure bike and surfboard lockers, security, putting green/driving range cage, ample guest parking, and more. This pet-friendly waterfront retreat is ready for you to call home. It's VA assumable at 2.275%! Come and see, you will not be disappointed. Listing by: American Dream Realty LLC (808) 258-2436
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202511799"
}
["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) "22G"
}
["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(82) "https://hommati.tours/tour/2375799?play=no&mls=yes
Honolulu-Hi-96825--HPI53543230"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "875000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1195) "New Price! The Esplanade is paradise in the heart of Hawaii Kai. This two-bed/two-bath condo is a stunning, move-in-ready, gem located right on the water, and boasts breathtaking views. The open layout is flooded with natural light, enhanced by cool tradewind breezes creating a refreshing ambiance. This turn-key property is impeccably clean and beautifully maintained, promising not to disappoint. The recently remodeled kitchen and bathrooms feature elegant granite countertops and high-quality real wood cabinets offering both style and function. Additional features include new central A/C, custom-tiled showers, and automated blinds in each room. The private 119 sf screened lanai overlooking the marina and the garden grounds go perfect with your morning coffee. The well-run HOA includes resort-like amenities including private boat docks, a saltwater pool, jacuzzi, full gym, sauna, tennis/pickleball courts, 5 BBQ grottos, party room, secure bike and surfboard lockers, security, putting green/driving range cage, ample guest parking, and more. This pet-friendly waterfront retreat is ready for you to call home. It's VA assumable at 2.275%! Come and see, you will not be disappointed."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(25) "American Dream Realty 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) "1202"
}
["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(28) "Garden,Marina/Canal,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1287.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) "ADRL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "gregstudt@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 258-2436"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Gregory D Studt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18740168"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-08-18T16:30:01.970"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-12"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(30) "Marina,Stream/Canal,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:30:01.970"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26992854"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26992854"
[1]=>
string(8) "26992855"
[2]=>
string(8) "26992856"
[3]=>
string(8) "26992857"
[4]=>
string(8) "26992858"
[5]=>
string(8) "26992859"
[6]=>
string(8) "26992860"
[7]=>
string(8) "26992861"
[8]=>
string(8) "26992862"
[9]=>
string(8) "26992863"
[10]=>
string(8) "26992864"
[11]=>
string(8) "26992865"
[12]=>
string(8) "26992866"
[13]=>
string(8) "26992867"
[14]=>
string(8) "26992868"
[15]=>
string(8) "26992869"
[16]=>
string(8) "26992870"
[17]=>
string(8) "26992871"
[18]=>
string(8) "26992872"
[19]=>
string(8) "26992873"
[20]=>
string(8) "26992874"
[21]=>
string(8) "26992875"
[22]=>
string(8) "26992876"
[23]=>
string(8) "26992877"
[24]=>
string(8) "26992878"
[25]=>
string(8) "26992879"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202511799
)
[StreetNumber] => Array
(
[0] => 500
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lunalilo Home
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 22G
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96825
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2375799?play=no&mls=yes
Honolulu-Hi-96825--HPI53543230
)
[ListPrice] => Array
(
[0] => 875000.00
)
[Neighbourhood] => Array
(
[0] => WEST MARINA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => New Price! The Esplanade is paradise in the heart of Hawaii Kai. This two-bed/two-bath condo is a stunning, move-in-ready, gem located right on the water, and boasts breathtaking views. The open layout is flooded with natural light, enhanced by cool tradewind breezes creating a refreshing ambiance. This turn-key property is impeccably clean and beautifully maintained, promising not to disappoint. The recently remodeled kitchen and bathrooms feature elegant granite countertops and high-quality real wood cabinets offering both style and function. Additional features include new central A/C, custom-tiled showers, and automated blinds in each room. The private 119 sf screened lanai overlooking the marina and the garden grounds go perfect with your morning coffee. The well-run HOA includes resort-like amenities including private boat docks, a saltwater pool, jacuzzi, full gym, sauna, tennis/pickleball courts, 5 BBQ grottos, party room, secure bike and surfboard lockers, security, putting green/driving range cage, ample guest parking, and more. This pet-friendly waterfront retreat is ready for you to call home. It's VA assumable at 2.275%! Come and see, you will not be disappointed.
)
[ListOfficeName] => Array
(
[0] => American Dream Realty LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 205821.00
)
[SqftTotal] => Array
(
[0] => 1202
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Esplanade
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Garden,Marina/Canal,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1287.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Koko Head
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kaiser
)
[ListOfficeMLSID] => Array
(
[0] => ADRL
)
[ListAgentEmail] => Array
(
[0] => gregstudt@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 258-2436
)
[ListAgentFullName] => Array
(
[0] => Gregory D Studt
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18740168
)
[MatrixModifiedDT] => Array
(
[0] => 2025-08-18T16:30:01.970
)
[ListingContractDate] => Array
(
[0] => 2025-05-12
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] => Marina,Stream/Canal,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:30:01.970
)
[_thumbnail_id] => Array
(
[0] => 26992854
)
[listing_image] => Array
(
[0] => 26992854
[1] => 26992855
[2] => 26992856
[3] => 26992857
[4] => 26992858
[5] => 26992859
[6] => 26992860
[7] => 26992861
[8] => 26992862
[9] => 26992863
[10] => 26992864
[11] => 26992865
[12] => 26992866
[13] => 26992867
[14] => 26992868
[15] => 26992869
[16] => 26992870
[17] => 26992871
[18] => 26992872
[19] => 26992873
[20] => 26992874
[21] => 26992875
[22] => 26992876
[23] => 26992877
[24] => 26992878
[25] => 26992879
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 205,821 sf
- Living (sf): 1,202
- Year Built: 1973
- Building Name: Esplanade
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Garden,Marina/Canal,Mountain
- Listing Office: American Dream Realty LLC
- Maintenance Fees: $1,287
- Land Tenure: FS - Fee Simple
- Elementary School: Koko Head
- Middle School: Niu Valley
- High School: Kaiser
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 18, 2025 - 4:30 PM
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.
© Marcus Realty. All Rights Reserved.
