45-578 Keaahala Road Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $2,600,000
Area: HALEKAUWILA
Status: Active

Attention Investors or Buyers looking for a large estate! Great opportunity to own an R-5 zoned 31,295 sq ft level to gently sloping parcel in desirable Kaneohe! Three 3 bedroom 1 bath homes on property are in need of major repair. A 4th home has since been demolished. Great location near Kaneohe Town with quick access to the freeway! Buyer to do their own due diligence. Please do not walk on property without an appointment! Listing by: BHGRE Advantage Realty (808) 330-6725

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202415495"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "45-578"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Keaahala"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(59) "https://listings.hetproductions.com/sites/zejmnjw/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2600000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2600000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "HALEKAUWILA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(435) "Attention Investors or Buyers looking for a large estate!  Great opportunity to own an R-5 zoned 31,295 sq ft level to gently sloping parcel in desirable Kaneohe!  Three 3  bedroom 1 bath homes on property are in need of major repair.  A 4th home has since been demolished. Great location near Kaneohe Town with quick access to the freeway!   Buyer to do their own due diligence.  Please do not walk on property without an appointment!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "31295.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(4) "None"
  }
  ["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(4) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "AllanC@BetterHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 330-6725"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Allan E Crooks"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-10T14:59:39.180"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18111284"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-10T14:59:39.180"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26617046"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26617046"
    [1]=>
    string(8) "26617047"
    [2]=>
    string(8) "26617048"
    [3]=>
    string(8) "26617049"
    [4]=>
    string(8) "26617050"
    [5]=>
    string(8) "26617051"
    [6]=>
    string(8) "26617052"
    [7]=>
    string(8) "26617053"
    [8]=>
    string(8) "26617054"
    [9]=>
    string(8) "26617055"
    [10]=>
    string(8) "26617056"
    [11]=>
    string(8) "26617057"
    [12]=>
    string(8) "26617058"
    [13]=>
    string(8) "26617059"
    [14]=>
    string(8) "26617060"
    [15]=>
    string(8) "26617061"
    [16]=>
    string(8) "26617062"
    [17]=>
    string(8) "26617063"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202415495
        )

    [StreetNumber] => Array
        (
            [0] => 45-578
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/zejmnjw/unbranded
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Attention Investors or Buyers looking for a large estate!  Great opportunity to own an R-5 zoned 31,295 sq ft level to gently sloping parcel in desirable Kaneohe!  Three 3  bedroom 1 bath homes on property are in need of major repair.  A 4th home has since been demolished. Great location near Kaneohe Town with quick access to the freeway!   Buyer to do their own due diligence.  Please do not walk on property without an appointment!
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => AllanC@BetterHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 330-6725
        )

    [ListAgentFullName] => Array
        (
            [0] => Allan E Crooks
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-07-10T14:59:39.180
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-07-10T14:59:39.180
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26617046
            [1] => 26617047
            [2] => 26617048
            [3] => 26617049
            [4] => 26617050
            [5] => 26617051
            [6] => 26617052
            [7] => 26617053
            [8] => 26617054
            [9] => 26617055
            [10] => 26617056
            [11] => 26617057
            [12] => 26617058
            [13] => 26617059
            [14] => 26617060
            [15] => 26617061
            [16] => 26617062
            [17] => 26617063
        )

)

  • Land Area (sf): 31,295

  • View: None
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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