Listing
Overview
Price: $850,000
Area: WAHIAWA HEIGHTS
Status: Active
Nestled on the corner of California Avenue and Hoomaha Street on a 8,459 sqft. lot, this single-family dwelling in Wahiawa Heights formerly known as Marigold Acres, beckons buyers with a passion for restoration and design. Embrace the chance to breathe new life into this once exquisite home, transforming it into a masterpiece that reflects your unique vision. Unleash your creativity and bring your dream home to fruition with a comprehensive remodel and renovation. Collaborate with your trusted contractors to revitalize every corner of this property, crafting a space that resonates with your personal style and preferences. Don't miss out on this incredible opportunity to shape the future of this distinguished residence. Seize the moment and embark on a journey of transformation in Wahiawa Heights. Please note that there is no electricty or running water. Contact your favorite Realtor who can be your trusted guide through this process. No Open Houses, only private tours. Listing by: Dream Home Realty Hawaii LLC (808) 384-8173
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415373"
}
["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(36) "https://hirephoto.com/1691california"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAHIAWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(983) "Nestled on the corner of California Avenue and Hoomaha Street on a 8,459 sqft. lot, this single-family dwelling in Wahiawa Heights formerly known as Marigold Acres, beckons buyers with a passion for restoration and design. Embrace the chance to breathe new life into this once exquisite home, transforming it into a masterpiece that reflects your unique vision. Unleash your creativity and bring your dream home to fruition with a comprehensive remodel and renovation. Collaborate with your trusted contractors to revitalize every corner of this property, crafting a space that resonates with your personal style and preferences. Don't miss out on this incredible opportunity to shape the future of this distinguished residence. Seize the moment and embark on a journey of transformation in Wahiawa Heights. Please note that there is no electricty or running water. Contact your favorite Realtor who can be your trusted guide through this process. No Open Houses, only private tours."
}
["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) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-07-02T13:57:01.677"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18108015"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-02T13:57:01.677"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26608198"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26608198"
[1]=>
string(8) "26608199"
[2]=>
string(8) "26608200"
[3]=>
string(8) "26608201"
[4]=>
string(8) "26608202"
[5]=>
string(8) "26608203"
[6]=>
string(8) "26608204"
[7]=>
string(8) "26608205"
[8]=>
string(8) "26608206"
[9]=>
string(8) "26608207"
[10]=>
string(8) "26608208"
[11]=>
string(8) "26608209"
[12]=>
string(8) "26608210"
[13]=>
string(8) "26608211"
[14]=>
string(8) "26608212"
[15]=>
string(8) "26608213"
[16]=>
string(8) "26608214"
[17]=>
string(8) "26608215"
[18]=>
string(8) "26608216"
[19]=>
string(8) "26608217"
[20]=>
string(8) "26608218"
[21]=>
string(8) "26608219"
[22]=>
string(8) "26608220"
[23]=>
string(8) "26608221"
[24]=>
string(8) "26608222"
[25]=>
string(8) "26608223"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415373
)
[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://hirephoto.com/1691california
)
[ListPrice] => Array
(
[0] => 850000.00
)
[CurrentPrice] => Array
(
[0] => 850000.00
)
[Neighbourhood] => Array
(
[0] => WAHIAWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled on the corner of California Avenue and Hoomaha Street on a 8,459 sqft. lot, this single-family dwelling in Wahiawa Heights formerly known as Marigold Acres, beckons buyers with a passion for restoration and design. Embrace the chance to breathe new life into this once exquisite home, transforming it into a masterpiece that reflects your unique vision. Unleash your creativity and bring your dream home to fruition with a comprehensive remodel and renovation. Collaborate with your trusted contractors to revitalize every corner of this property, crafting a space that resonates with your personal style and preferences. Don't miss out on this incredible opportunity to shape the future of this distinguished residence. Seize the moment and embark on a journey of transformation in Wahiawa Heights. Please note that there is no electricty or running water. Contact your favorite Realtor who can be your trusted guide through this process. No Open Houses, only private tours.
)
[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] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-07-02T13:57:01.677
)
[Matrix_Unique_ID] => Array
(
[0] => 18108015
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-02T13:57:01.677
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26608198
)
[listing_image] => Array
(
[0] => 26608198
[1] => 26608199
[2] => 26608200
[3] => 26608201
[4] => 26608202
[5] => 26608203
[6] => 26608204
[7] => 26608205
[8] => 26608206
[9] => 26608207
[10] => 26608208
[11] => 26608209
[12] => 26608210
[13] => 26608211
[14] => 26608212
[15] => 26608213
[16] => 26608214
[17] => 26608215
[18] => 26608216
[19] => 26608217
[20] => 26608218
[21] => 26608219
[22] => 26608220
[23] => 26608221
[24] => 26608222
[25] => 26608223
)
)
- BedsTotal: 5
- Full Baths: 2
- Land Area (sf): 8,458
- Living (sf): 1,917
- Year Built: 1945
- Property Condition: Needs Major Repair
- Number of Parking Spaces: 2
- View: None
- Listing Office: Dream Home Realty Hawaii LLC
- Land Tenure: FS - Fee Simple
