Price: $795,000 Area: WAHIAWA HEIGHTS Status: Active
Nestled on the corner of California Avenue and Hoomaha Street, this single-family dwelling in Wahiawa Heights, formerly known as Marigold Acres, sits on an expansive 8,459 sqft corner lot. This property presents an exceptional opportunity for buyers with a passion for restoration and design. Whether you envision building a duplex or an accessory dwelling unit (ADU), the potential here is extraordinary. Breathe new life into this once-stunning property, transforming it into a masterpiece that reflects your unique vision. With a comprehensive remodel, you can unleash your creativity and craft a home that embodies your personal style and preferences. Collaborate with trusted contractors to reimagine every detail and bring your dream home to fruition. This property is a rare chance to shape the future of a distinguished residence in Wahiawa Heights. Contact your favorite Realtor for a private tour and take the first step in this exciting journey. No open houses, private viewings only. Listing by: Dream Home Realty Hawaii LLC (808) 384-8173
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428384"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1691"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "California"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96786"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(50) "https://www.hirephoto.com/1691california/slideshow"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "795000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAHIAWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(995) "Nestled on the corner of California Avenue and Hoomaha Street, this single-family dwelling in Wahiawa Heights, formerly known as Marigold Acres, sits on an expansive 8,459 sqft corner lot. This property presents an exceptional opportunity for buyers with a passion for restoration and design. Whether you envision building a duplex or an accessory dwelling unit (ADU), the potential here is extraordinary. Breathe new life into this once-stunning property, transforming it into a masterpiece that reflects your unique vision. With a comprehensive remodel, you can unleash your creativity and craft a home that embodies your personal style and preferences. Collaborate with trusted contractors to reimagine every detail and bring your dream home to fruition. This property is a rare chance to shape the future of a distinguished residence in Wahiawa Heights. Contact your favorite Realtor for a private tour and take the first step in this exciting journey. No open houses, private viewings only."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Dream Home Realty Hawaii LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8458.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1917"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1945"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(18) "Needs Major Repair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["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) "DHRH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(16) "tricia@dhrhi.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 384-8173"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Tricia Nekota"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18441445"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-09T21:07:56.787"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-07"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "21:07:56.787"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26830834"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26830834"
[1]=>
string(8) "26830835"
[2]=>
string(8) "26830836"
[3]=>
string(8) "26830837"
[4]=>
string(8) "26830838"
[5]=>
string(8) "26830839"
[6]=>
string(8) "26830840"
[7]=>
string(8) "26830841"
[8]=>
string(8) "26830842"
[9]=>
string(8) "26830843"
[10]=>
string(8) "26830844"
[11]=>
string(8) "26830845"
[12]=>
string(8) "26830846"
[13]=>
string(8) "26830847"
[14]=>
string(8) "26830848"
[15]=>
string(8) "26830849"
[16]=>
string(8) "26830850"
[17]=>
string(8) "26830851"
[18]=>
string(8) "26830852"
[19]=>
string(8) "26830853"
[20]=>
string(8) "26830854"
[21]=>
string(8) "26830855"
[22]=>
string(8) "26830856"
[23]=>
string(8) "26830857"
[24]=>
string(8) "26830858"
[25]=>
string(8) "26830859"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428384
)
[StreetNumber] => Array
(
[0] => 1691
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => California
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Wahiawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96786
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.hirephoto.com/1691california/slideshow
)
[ListPrice] => Array
(
[0] => 795000.00
)
[Neighbourhood] => Array
(
[0] => WAHIAWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled on the corner of California Avenue and Hoomaha Street, this single-family dwelling in Wahiawa Heights, formerly known as Marigold Acres, sits on an expansive 8,459 sqft corner lot. This property presents an exceptional opportunity for buyers with a passion for restoration and design. Whether you envision building a duplex or an accessory dwelling unit (ADU), the potential here is extraordinary. Breathe new life into this once-stunning property, transforming it into a masterpiece that reflects your unique vision. With a comprehensive remodel, you can unleash your creativity and craft a home that embodies your personal style and preferences. Collaborate with trusted contractors to reimagine every detail and bring your dream home to fruition. This property is a rare chance to shape the future of a distinguished residence in Wahiawa Heights. Contact your favorite Realtor for a private tour and take the first step in this exciting journey. No open houses, private viewings only.
)
[ListOfficeName] => Array
(
[0] => Dream Home Realty Hawaii LLC
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8458.00
)
[SqftTotal] => Array
(
[0] => 1917
)
[YearBuilt] => Array
(
[0] => 1945
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Needs Major Repair
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[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] => DHRH
)
[ListAgentEmail] => Array
(
[0] => tricia@dhrhi.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 384-8173
)
[ListAgentFullName] => Array
(
[0] => Tricia Nekota
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18441445
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-09T21:07:56.787
)
[ListingContractDate] => Array
(
[0] => 2025-01-07
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 21:07:56.787
)
[_thumbnail_id] => Array
(
[0] => 26830834
)
[listing_image] => Array
(
[0] => 26830834
[1] => 26830835
[2] => 26830836
[3] => 26830837
[4] => 26830838
[5] => 26830839
[6] => 26830840
[7] => 26830841
[8] => 26830842
[9] => 26830843
[10] => 26830844
[11] => 26830845
[12] => 26830846
[13] => 26830847
[14] => 26830848
[15] => 26830849
[16] => 26830850
[17] => 26830851
[18] => 26830852
[19] => 26830853
[20] => 26830854
[21] => 26830855
[22] => 26830856
[23] => 26830857
[24] => 26830858
[25] => 26830859
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on January 9, 2025 - 9:07 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
