Listing
Overview
Price: $2,400,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) 738-3600
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) "2400000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2400000.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) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Allan E Crooks"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-08T17:21:04.407"
}
["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] => 2400000.00
)
[CurrentPrice] => Array
(
[0] => 2400000.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) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Allan E Crooks
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-08T17:21:04.407
)
[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