Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
3437 Campbell Avenue Honolulu, HI 96815
Listing Overview
Price: $975,000 Area: KAPAHULU Status: Active Under Contract
LOCATION! LOCATION! LOCATION! Great Opportunity to build your dream home in this popular Kapahulu neighborhood, so close to scenic Diamond Head, famous Waikiki Beach, Kapiolani Park, Honolulu Zoo, Ala Wai Golf Course, Kapiolani Community College and numerous shops and eateries. Priced well below assessed value, this level, corner home has lots of potential so bring your favorite contractor. Look for the large mango tree in the front yard. You're welcome to drive by but please do not step onto the property without an appointment and your realtor with you. No access is allowed into the house for safety reasons and is being sold AS IS, in tear down condition with the contents of the house inside/outside and Buyer and agent to perform their own DUE DILIGENCE. Property does not match public records and sale is subject to Probate Court Approval. Listing by: Locations LLC (808) 723-0630
array(47) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428431"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3437"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Campbell"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["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) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "975000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "KAPAHULU"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(857) "LOCATION! LOCATION! LOCATION! Great Opportunity to build your dream home in this popular Kapahulu neighborhood, so close to scenic Diamond Head, famous Waikiki Beach, Kapiolani Park, Honolulu Zoo, Ala Wai Golf Course, Kapiolani Community College and numerous shops and eateries. Priced well below assessed value, this level, corner home has lots of potential so bring your favorite contractor. Look for the large mango tree in the front yard. You're welcome to drive by but please do not step onto the property without an appointment and your realtor with you. No access is allowed into the house for safety reasons and is being sold AS IS, in tear down condition with the contents of the house inside/outside and Buyer and agent to perform their own DUE DILIGENCE. Property does not match public records and sale is subject to Probate Court Approval."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4182.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1236"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Tear Down"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(12) "Diamond Head"
}
["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) "LOCA03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "dancetta.feary@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0630"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Dancetta M Feary"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-23T08:09:09.657"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18442624"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-18"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26810549"
}
["listing_image"]=>
array(13) {
[0]=>
string(8) "26810549"
[1]=>
string(8) "26810550"
[2]=>
string(8) "26810551"
[3]=>
string(8) "26810552"
[4]=>
string(8) "26810553"
[5]=>
string(8) "26810554"
[6]=>
string(8) "26810555"
[7]=>
string(8) "26810556"
[8]=>
string(8) "26810557"
[9]=>
string(8) "26810558"
[10]=>
string(8) "26810559"
[11]=>
string(8) "26810560"
[12]=>
string(8) "26810561"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428431
)
[StreetNumber] => Array
(
[0] => 3437
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Campbell
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 975000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KAPAHULU
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => LOCATION! LOCATION! LOCATION! Great Opportunity to build your dream home in this popular Kapahulu neighborhood, so close to scenic Diamond Head, famous Waikiki Beach, Kapiolani Park, Honolulu Zoo, Ala Wai Golf Course, Kapiolani Community College and numerous shops and eateries. Priced well below assessed value, this level, corner home has lots of potential so bring your favorite contractor. Look for the large mango tree in the front yard. You're welcome to drive by but please do not step onto the property without an appointment and your realtor with you. No access is allowed into the house for safety reasons and is being sold AS IS, in tear down condition with the contents of the house inside/outside and Buyer and agent to perform their own DUE DILIGENCE. Property does not match public records and sale is subject to Probate Court Approval.
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 4182.00
)
[SqftTotal] => Array
(
[0] => 1236
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Tear Down
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Diamond Head
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOCA03
)
[ListAgentEmail] => Array
(
[0] => dancetta.feary@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 723-0630
)
[ListAgentFullName] => Array
(
[0] => Dancetta M Feary
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-23T08:09:09.657
)
[Matrix_Unique_ID] => Array
(
[0] => 18442624
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-18
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26810549
)
[listing_image] => Array
(
[0] => 26810549
[1] => 26810550
[2] => 26810551
[3] => 26810552
[4] => 26810553
[5] => 26810554
[6] => 26810555
[7] => 26810556
[8] => 26810557
[9] => 26810558
[10] => 26810559
[11] => 26810560
[12] => 26810561
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
)
