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 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) 738-3600
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) "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(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) 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:24:46.823"
}
["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] => 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 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) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Allan E Crooks
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-08T17:24:46.823
)
[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
)
)
- View: None
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple