Listing
Overview
Price: $1,850,000
Area: DIAMOND HEAD
Status: Active
Enjoy the O'ahu Gold Coast experience from this impeccably and completely remodeled oceanfront condo with stunning views of the ocean and sunset! Features include new cabinets, quartz countertops, luxury vinyl floors, automatic blinds, new appliances, washer and dryer inside the unit, smooth ceilings (no popcorn) and crown molding. This waterfront jewel is offered fully furnished. Building is secured, it has ocean access and Kapiolani park across the way, minutes from world class shopping, boutiques, and fine dining. 2016 Toyota Tacoma (8700 miles) included in the sale. Listing by: BHGRE Advantage Realty (808) 218-9196
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202225676"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "2999"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Kalakaua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "202"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(137) "https://www.zillow.com/view-imx/1d68f0d6-eb51-4c89-9db8-5373f1311265?setAttribution=mls&wl=true&initialViewType=pano&utm_source=dashboard"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1850000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "DIAMOND HEAD"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(577) "Enjoy the O'ahu Gold Coast experience from this impeccably and completely remodeled oceanfront condo with stunning views of the ocean and sunset! Features include new cabinets, quartz countertops, luxury vinyl floors, automatic blinds, new appliances, washer and dryer inside the unit, smooth ceilings (no popcorn) and crown molding. This waterfront jewel is offered fully furnished. Building is secured, it has ocean access and Kapiolani park across the way, minutes from world class shopping, boutiques, and fine dining. 2016 Toyota Tacoma (8700 miles) included in the sale."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "755"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1957"
}
["BuildingName"]=>
array(1) {
[0]=>
string(14) "Tahitienne Inc"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(12) "Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "939.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "KrisztinaK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 218-9196"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Krisztina Kollo"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-03T17:00:01.580"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17042157"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-12-16T12:53:19.507"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25835058"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25835058"
[1]=>
string(8) "25835059"
[2]=>
string(8) "25835060"
[3]=>
string(8) "25835061"
[4]=>
string(8) "25835062"
[5]=>
string(8) "25835063"
[6]=>
string(8) "25835064"
[7]=>
string(8) "25835065"
[8]=>
string(8) "25835066"
[9]=>
string(8) "25835067"
[10]=>
string(8) "25835068"
[11]=>
string(8) "25835069"
[12]=>
string(8) "25835070"
[13]=>
string(8) "25835071"
[14]=>
string(8) "25835072"
[15]=>
string(8) "25835073"
[16]=>
string(8) "25835074"
[17]=>
string(8) "25835075"
[18]=>
string(8) "25835076"
[19]=>
string(8) "25835077"
[20]=>
string(8) "25835078"
[21]=>
string(8) "25835079"
[22]=>
string(8) "25835080"
[23]=>
string(8) "25835081"
[24]=>
string(8) "25835082"
[25]=>
string(8) "25835083"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202225676
)
[StreetNumber] => Array
(
[0] => 2999
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kalakaua
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 202
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.zillow.com/view-imx/1d68f0d6-eb51-4c89-9db8-5373f1311265?setAttribution=mls&wl=true&initialViewType=pano&utm_source=dashboard
)
[ListPrice] => Array
(
[0] => 1850000.00
)
[CurrentPrice] => Array
(
[0] => 1850000.00
)
[Neighbourhood] => Array
(
[0] => DIAMOND HEAD
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Enjoy the O'ahu Gold Coast experience from this impeccably and completely remodeled oceanfront condo with stunning views of the ocean and sunset! Features include new cabinets, quartz countertops, luxury vinyl floors, automatic blinds, new appliances, washer and dryer inside the unit, smooth ceilings (no popcorn) and crown molding. This waterfront jewel is offered fully furnished. Building is secured, it has ocean access and Kapiolani park across the way, minutes from world class shopping, boutiques, and fine dining. 2016 Toyota Tacoma (8700 miles) included in the sale.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 755
)
[YearBuilt] => Array
(
[0] => 1957
)
[BuildingName] => Array
(
[0] => Tahitienne Inc
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 939.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => KrisztinaK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 218-9196
)
[ListAgentFullName] => Array
(
[0] => Krisztina Kollo
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-03T17:00:01.580
)
[Matrix_Unique_ID] => Array
(
[0] => 17042157
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-12-16T12:53:19.507
)
[_thumbnail_id] => Array
(
[0] => 25835058
)
[listing_image] => Array
(
[0] => 25835058
[1] => 25835059
[2] => 25835060
[3] => 25835061
[4] => 25835062
[5] => 25835063
[6] => 25835064
[7] => 25835065
[8] => 25835066
[9] => 25835067
[10] => 25835068
[11] => 25835069
[12] => 25835070
[13] => 25835071
[14] => 25835072
[15] => 25835073
[16] => 25835074
[17] => 25835075
[18] => 25835076
[19] => 25835077
[20] => 25835078
[21] => 25835079
[22] => 25835080
[23] => 25835081
[24] => 25835082
[25] => 25835083
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 755
- Year Built: 1957
- Building Name: Tahitienne Inc
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Ocean,Sunset
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $939
- Land Tenure: FS - Fee Simple