4730 Halehoola Place Honolulu, HI 96816

Listing
Overview

Price: $1,000,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. With a growing emphasis on sustainable living, this property presents an ideal platform for environmentally-conscious development. Harness the abundant natural resources and embrace eco-friendly building practices to create a net-zero paradise. 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) "202222299"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "4730"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["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) "1000000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1000000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(17) "MAUNALANI HEIGHTS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1091) "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.  
With a growing emphasis on sustainable living, this property presents an ideal platform for environmentally-conscious development. Harness the abundant natural resources and embrace eco-friendly building practices to create a net-zero paradise. 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(1) "0"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "594031.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["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) "2024-06-03T12:40:57.543"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "16966682"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-10-28T16:59:03.300"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25833463"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "25833463"
    [1]=>
    string(8) "25833464"
    [2]=>
    string(8) "25833465"
    [3]=>
    string(8) "25833466"
    [4]=>
    string(8) "25833467"
    [5]=>
    string(8) "25833468"
    [6]=>
    string(8) "25833469"
    [7]=>
    string(8) "25833470"
    [8]=>
    string(8) "25833471"
    [9]=>
    string(8) "25833472"
    [10]=>
    string(8) "25833473"
    [11]=>
    string(8) "25833474"
    [12]=>
    string(8) "25833475"
    [13]=>
    string(8) "25833476"
    [14]=>
    string(8) "25833477"
    [15]=>
    string(8) "25833478"
    [16]=>
    string(8) "25833479"
    [17]=>
    string(8) "25833480"
    [18]=>
    string(8) "25833481"
    [19]=>
    string(8) "25833482"
    [20]=>
    string(8) "25833483"
    [21]=>
    string(8) "25833484"
    [22]=>
    string(8) "25833485"
    [23]=>
    string(8) "25833486"
    [24]=>
    string(8) "25833487"
  }
  ["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] => 202222299
        )

    [StreetNumber] => Array
        (
            [0] => 4730
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [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] => 1000000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 1000000.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.  
With a growing emphasis on sustainable living, this property presents an ideal platform for environmentally-conscious development. Harness the abundant natural resources and embrace eco-friendly building practices to create a net-zero paradise. Buyer to do independent due diligence. Bring your favorite architect, contractor or developer & visionary ideas.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [BedsTotal] => Array
        (
            [0] => 0
        )

    [BathsFull] => Array
        (
            [0] => 0
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 594031.00
        )

    [SqftTotal] => Array
        (
            [0] => 0
        )

    [YearBuilt] => Array
        (
            [0] => 0
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Average
        )

    [ParkingTotal] => Array
        (
            [0] => 0
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [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] => 2024-06-03T12:40:57.543
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 16966682
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2022-10-28T16:59:03.300
        )

    [_thumbnail_id] => Array
        (
            [0] => 25833463
        )

    [listing_image] => Array
        (
            [0] => 25833463
            [1] => 25833464
            [2] => 25833465
            [3] => 25833466
            [4] => 25833467
            [5] => 25833468
            [6] => 25833469
            [7] => 25833470
            [8] => 25833471
            [9] => 25833472
            [10] => 25833473
            [11] => 25833474
            [12] => 25833475
            [13] => 25833476
            [14] => 25833477
            [15] => 25833478
            [16] => 25833479
            [17] => 25833480
            [18] => 25833481
            [19] => 25833482
            [20] => 25833483
            [21] => 25833484
            [22] => 25833485
            [23] => 25833486
            [24] => 25833487
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

    [PropertyFrontage] => Array
        (
            [0] => Conservation,Preservation
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

)

  • Land Area (sf): 594,031

  • Property Condition: Average
  • 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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446