2630 Waiomao Road Honolulu, HI 96816

Listing
Overview

Price: $6,000,000
Area: PALOLO
Status: Active

Fantastic opportunity to invest in a large estate conveniently located within minutes of the University of Hawaii, Kaimuki, Waikiki Beach and Ala Moana Center. Come and explore the possibilities of this 8.78 acre property in upper Palolo Valley consisting of approx. 3.4 acres zoned R-5 and approx. 5.37 acres preservation hillside. Currently an orchid farm, the property includes two homes: a 4 bedroom/2 bath with finished basement and outdoor shower, and a 2 bedroom/2 bath across the driveway. The third structure is a workshop with 1 bath on the ground level, and office spaces, storage room, kitchenette and bathroom on the top floor. Multiple greenhouses cover the remaining flat area. Waiomao Stream separates the rear part of the lot from the property's mountainside. The orchid business is available for purchase separately. The number of bedrooms and bathrooms shown in MLS do not match tax records. Offering price of $6,000,000.00 is firm. Listing by: Coldwell Banker Realty (808) 738-3904

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202222137"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2630"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waiomao"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["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) "6000000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "6000000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "PALOLO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(951) "Fantastic opportunity to invest in a large estate conveniently located within minutes of the University of Hawaii, Kaimuki, Waikiki Beach and Ala Moana Center. Come and explore the possibilities of this 8.78 acre property in upper Palolo Valley consisting of approx. 3.4 acres zoned R-5 and approx. 5.37 acres preservation hillside. Currently an orchid farm, the property includes two homes: a 4 bedroom/2 bath with finished basement and outdoor shower, and a 2 bedroom/2 bath across the driveway. The third structure is a workshop with 1 bath on the ground level, and office spaces, storage room, kitchenette and bathroom on the top floor. Multiple greenhouses cover the remaining flat area. Waiomao Stream separates the rear part of the lot from the property's mountainside. The orchid business is available for purchase separately. The number of bedrooms and bathrooms shown in MLS do not match tax records. Offering price of $6,000,000.00 is firm."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "382647.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "5912"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1951"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(2) "20"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "perry.kunishige@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3904"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Perry Kunishige"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-06T12:24:14.483"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "16962061"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-10-26T08:30:30.927"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25833400"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "25833400"
    [1]=>
    string(8) "25833401"
    [2]=>
    string(8) "25833402"
    [3]=>
    string(8) "25833403"
    [4]=>
    string(8) "25833404"
    [5]=>
    string(8) "25833405"
    [6]=>
    string(8) "25833406"
    [7]=>
    string(8) "25833407"
    [8]=>
    string(8) "25833408"
    [9]=>
    string(8) "25833409"
    [10]=>
    string(8) "25833410"
    [11]=>
    string(8) "25833411"
    [12]=>
    string(8) "25833412"
    [13]=>
    string(8) "25833413"
    [14]=>
    string(8) "25833414"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(18) "Other,Stream/Canal"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202222137
        )

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

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

    [StreetName] => Array
        (
            [0] => Waiomao
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

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

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96816
        )

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

    [ListPrice] => Array
        (
            [0] => 6000000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 6000000.00
        )

    [Neighbourhood] => Array
        (
            [0] => PALOLO
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Fantastic opportunity to invest in a large estate conveniently located within minutes of the University of Hawaii, Kaimuki, Waikiki Beach and Ala Moana Center. Come and explore the possibilities of this 8.78 acre property in upper Palolo Valley consisting of approx. 3.4 acres zoned R-5 and approx. 5.37 acres preservation hillside. Currently an orchid farm, the property includes two homes: a 4 bedroom/2 bath with finished basement and outdoor shower, and a 2 bedroom/2 bath across the driveway. The third structure is a workshop with 1 bath on the ground level, and office spaces, storage room, kitchenette and bathroom on the top floor. Multiple greenhouses cover the remaining flat area. Waiomao Stream separates the rear part of the lot from the property's mountainside. The orchid business is available for purchase separately. The number of bedrooms and bathrooms shown in MLS do not match tax records. Offering price of $6,000,000.00 is firm.
        )

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

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain
        )

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

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

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

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

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

    [ListOfficeMLSID] => Array
        (
            [0] => CBPP02
        )

    [ListAgentEmail] => Array
        (
            [0] => perry.kunishige@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3904
        )

    [ListAgentFullName] => Array
        (
            [0] => Perry Kunishige
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-10-06T12:24:14.483
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2022-10-26T08:30:30.927
        )

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

    [listing_image] => Array
        (
            [0] => 25833400
            [1] => 25833401
            [2] => 25833402
            [3] => 25833403
            [4] => 25833404
            [5] => 25833405
            [6] => 25833406
            [7] => 25833407
            [8] => 25833408
            [9] => 25833409
            [10] => 25833410
            [11] => 25833411
            [12] => 25833412
            [13] => 25833413
            [14] => 25833414
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Other,Stream/Canal
        )

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

)

  • BedsTotal: 10
  • Full Baths: 6
  • Land Area (sf): 382,647
  • Living (sf): 5,912
  • Year Built: 1951

  • Property Condition: Above Average,Average
  • Number of Parking Spaces: 20
  • View: Mountain
  • Listing Office: Coldwell Banker Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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