4730 Halehoola Place Honolulu, HI 96816
Listing
Overview
Price: $1,099,000
Area: MAUNALANI HEIGHTS
Status: Active
Imagine your custom designed home nestled on the slopes of Maunalani Heights. You will be mesmerized by postcard perfect views from this rare estate sized parcel overlooking Waikiki, the sparkling Pacific Ocean, Palolo Valley, Ko'olau Mountains and spectacular sunsets. Just 4.2 miles to beaches of Diamond Head's Gold Coast with a short commute to Hawaii's financial center, trendy Waialae Avenue, restaurants, boutique shops & major hospitals. Private cul-de-sac close to public transportation & Maunalani community Park with tennis court & recreation center. Street frontage parcel of 3,000 sq ft is zoned residential (R-10). Remaining acreage with preservation zoning (P-1) may allow construction of one residential structure. Buyer to do independent due diligence. Bring your favorite architect, contractor or developer & visionary ideas. Listing by: Coldwell Banker Realty (808) 738-3904
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202222302"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "4730"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Halehoola"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1099000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1099000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(17) "MAUNALANI HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(844) "Imagine your custom designed home nestled on the slopes of Maunalani Heights. You will be mesmerized by postcard perfect views from this rare estate sized parcel overlooking Waikiki, the sparkling Pacific Ocean, Palolo Valley, Ko'olau Mountains and spectacular sunsets. Just 4.2 miles to beaches of Diamond Head's Gold Coast with a short commute to Hawaii's financial center, trendy Waialae Avenue, restaurants, boutique shops & major hospitals. Private cul-de-sac close to public transportation & Maunalani community Park with tennis court & recreation center. Street frontage parcel of 3,000 sq ft is zoned residential (R-10). Remaining acreage with preservation zoning (P-1) may allow construction of one residential structure. Buyer to do independent due diligence. Bring your favorite architect, contractor or developer & visionary ideas."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "594031.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(36) "City,Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialae"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "lisav@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(21) "Lisa F Van Den Heuvel"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-07T14:59:50.610"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16966722"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-10-28T17:04:40.953"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25869427"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "25869427"
[1]=>
string(8) "25869428"
[2]=>
string(8) "25869429"
[3]=>
string(8) "25869430"
[4]=>
string(8) "25869431"
[5]=>
string(8) "25869432"
[6]=>
string(8) "25869433"
[7]=>
string(8) "25869434"
[8]=>
string(8) "25869435"
[9]=>
string(8) "25869436"
[10]=>
string(8) "25869437"
[11]=>
string(8) "25869438"
[12]=>
string(8) "25869439"
[13]=>
string(8) "25869440"
[14]=>
string(8) "25869441"
[15]=>
string(8) "25869442"
[16]=>
string(8) "25869443"
[17]=>
string(8) "25869444"
[18]=>
string(8) "25869445"
[19]=>
string(8) "25869446"
[20]=>
string(8) "25869447"
[21]=>
string(8) "25869448"
[22]=>
string(8) "25869449"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(25) "Conservation,Preservation"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202222302
)
[StreetNumber] => Array
(
[0] => 4730
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Halehoola
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1099000.00
)
[CurrentPrice] => Array
(
[0] => 1099000.00
)
[Neighbourhood] => Array
(
[0] => MAUNALANI HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Imagine your custom designed home nestled on the slopes of Maunalani Heights. You will be mesmerized by postcard perfect views from this rare estate sized parcel overlooking Waikiki, the sparkling Pacific Ocean, Palolo Valley, Ko'olau Mountains and spectacular sunsets. Just 4.2 miles to beaches of Diamond Head's Gold Coast with a short commute to Hawaii's financial center, trendy Waialae Avenue, restaurants, boutique shops & major hospitals. Private cul-de-sac close to public transportation & Maunalani community Park with tennis court & recreation center. Street frontage parcel of 3,000 sq ft is zoned residential (R-10). Remaining acreage with preservation zoning (P-1) may allow construction of one residential structure. Buyer to do independent due diligence. Bring your favorite architect, contractor or developer & visionary ideas.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 594031.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialae
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kaimuki
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => lisav@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Lisa F Van Den Heuvel
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-07T14:59:50.610
)
[Matrix_Unique_ID] => Array
(
[0] => 16966722
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-10-28T17:04:40.953
)
[_thumbnail_id] => Array
(
[0] => 25869427
)
[listing_image] => Array
(
[0] => 25869427
[1] => 25869428
[2] => 25869429
[3] => 25869430
[4] => 25869431
[5] => 25869432
[6] => 25869433
[7] => 25869434
[8] => 25869435
[9] => 25869436
[10] => 25869437
[11] => 25869438
[12] => 25869439
[13] => 25869440
[14] => 25869441
[15] => 25869442
[16] => 25869443
[17] => 25869444
[18] => 25869445
[19] => 25869446
[20] => 25869447
[21] => 25869448
[22] => 25869449
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Conservation,Preservation
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- View: City,Coastline,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waialae
- Middle School: Kaimuki
- High School: Kalani
