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 sqft level to gently sloping parcel in desirable Kaneohe! Three 3 bedroom 1 bath homes on property are in need of major repair. A fourth 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 appointment! Listing by: BHGRE Advantage Realty (808) 330-6725

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202415491"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "45-578"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["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(436) "Attention Investors or Buyers looking for a large estate!  Great opportunity to own an R-5 zoned 31,295 sqft level to gently sloping parcel in desirable Kaneohe!  Three 3  bedroom 1 bath homes on property are in need of major repair.  A fourth 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 appointment!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "31295.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2160"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(28) "Needs Major Repair,Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["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(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:57:04.640"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18111222"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-10T14:57:04.640"
  }
  ["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) "26617001"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26617001"
    [1]=>
    string(8) "26617002"
    [2]=>
    string(8) "26617003"
    [3]=>
    string(8) "26617004"
    [4]=>
    string(8) "26617005"
    [5]=>
    string(8) "26617006"
    [6]=>
    string(8) "26617007"
    [7]=>
    string(8) "26617008"
    [8]=>
    string(8) "26617009"
    [9]=>
    string(8) "26617010"
    [10]=>
    string(8) "26617011"
    [11]=>
    string(8) "26617012"
    [12]=>
    string(8) "26617013"
    [13]=>
    string(8) "26617014"
    [14]=>
    string(8) "26617015"
    [15]=>
    string(8) "26617016"
    [16]=>
    string(8) "26617017"
    [17]=>
    string(8) "26617018"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202415491
        )

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

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

    [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 sqft level to gently sloping parcel in desirable Kaneohe!  Three 3  bedroom 1 bath homes on property are in need of major repair.  A fourth 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 appointment!
        )

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

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Needs Major Repair,Tear Down
        )

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

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

    [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] => 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:57:04.640
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-07-10T14:57:04.640
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26617001
            [1] => 26617002
            [2] => 26617003
            [3] => 26617004
            [4] => 26617005
            [5] => 26617006
            [6] => 26617007
            [7] => 26617008
            [8] => 26617009
            [9] => 26617010
            [10] => 26617011
            [11] => 26617012
            [12] => 26617013
            [13] => 26617014
            [14] => 26617015
            [15] => 26617016
            [16] => 26617017
            [17] => 26617018
        )

)

  • BedsTotal: 9
  • Full Baths: 3
  • Land Area (sf): 31,295
  • Living (sf): 2,160
  • Year Built: 1965

  • Property Condition: Needs Major Repair,Tear Down
  • Number of Parking Spaces: 2
  • View: Mountain
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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