Listing
Overview
Price: $1,475,000
Area: HALEIWA
Status: Active
First Open House 2-5pm. Sunday, 5/19/2024. Location, Location, Location! Live in the heart of Haleiwa town with shopping, restaurants, art galleries, and entertainment just outside your door! This unique property has two points of entry, one from Kilioe pl (low traffic cul-de-sac) and another from Kamehameha Hwy. Current owners intended to change the zoning from Residential to Mix Business Residential but never found the time to begin the process.
Four bedrooms, two bathrooms and HUGE bonus room offer plenty of space to grow, expand, or have your home office/workshop. Two car garage (needs door installed) was recently upgraded with new framing and concrete floor. Relax on your covered porch with views of the Waianae mountain range or venture out to the Kamehameha hwy side of the property to watch the world go by!
*Check with your lawyer to see if converting the property zoning from residential to another class is possible and how the process works.
**MLS square footage doesn't match tax records. Buyer to do due diligence. Listing by: Seaside Realty LLC (808) 271-4142
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411356"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-490"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Kilioe"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(50) "https://hommati.tours/tour/2146567?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1475000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1043) "First Open House 2-5pm. Sunday, 5/19/2024. Location, Location, Location! Live in the heart of Haleiwa town with shopping, restaurants, art galleries, and entertainment just outside your door! This unique property has two points of entry, one from Kilioe pl (low traffic cul-de-sac) and another from Kamehameha Hwy. Current owners intended to change the zoning from Residential to Mix Business Residential but never found the time to begin the process.
Four bedrooms, two bathrooms and HUGE bonus room offer plenty of space to grow, expand, or have your home office/workshop. Two car garage (needs door installed) was recently upgraded with new framing and concrete floor. Relax on your covered porch with views of the Waianae mountain range or venture out to the Kamehameha hwy side of the property to watch the world go by!
*Check with your lawyer to see if converting the property zoning from residential to another class is possible and how the process works.
**MLS square footage doesn't match tax records. Buyer to do due diligence."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Seaside Realty 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) "8386.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1868"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1974"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(19) "City,Mountain,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "SSRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "ericainhawaii@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-4142"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Erica J Lehmkuhl"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-30T13:01:39.670"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18008679"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26210754"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26210754"
[1]=>
string(8) "26210755"
[2]=>
string(8) "26210756"
[3]=>
string(8) "26210757"
[4]=>
string(8) "26210758"
[5]=>
string(8) "26210759"
[6]=>
string(8) "26210760"
[7]=>
string(8) "26210761"
[8]=>
string(8) "26210762"
[9]=>
string(8) "26210763"
[10]=>
string(8) "26210764"
[11]=>
string(8) "26210765"
[12]=>
string(8) "26210766"
[13]=>
string(8) "26210767"
[14]=>
string(8) "26210768"
[15]=>
string(8) "26210769"
[16]=>
string(8) "26210770"
[17]=>
string(8) "26210771"
[18]=>
string(8) "26210772"
[19]=>
string(8) "26210773"
[20]=>
string(8) "26210774"
[21]=>
string(8) "26210775"
[22]=>
string(8) "26210776"
[23]=>
string(8) "26210777"
[24]=>
string(8) "26210778"
[25]=>
string(8) "26210779"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-05-16"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411356
)
[StreetNumber] => Array
(
[0] => 66-490
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kilioe
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2146567?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 1475000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => First Open House 2-5pm. Sunday, 5/19/2024. Location, Location, Location! Live in the heart of Haleiwa town with shopping, restaurants, art galleries, and entertainment just outside your door! This unique property has two points of entry, one from Kilioe pl (low traffic cul-de-sac) and another from Kamehameha Hwy. Current owners intended to change the zoning from Residential to Mix Business Residential but never found the time to begin the process.
Four bedrooms, two bathrooms and HUGE bonus room offer plenty of space to grow, expand, or have your home office/workshop. Two car garage (needs door installed) was recently upgraded with new framing and concrete floor. Relax on your covered porch with views of the Waianae mountain range or venture out to the Kamehameha hwy side of the property to watch the world go by!
*Check with your lawyer to see if converting the property zoning from residential to another class is possible and how the process works.
**MLS square footage doesn't match tax records. Buyer to do due diligence.
)
[ListOfficeName] => Array
(
[0] => Seaside Realty LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8386.00
)
[SqftTotal] => Array
(
[0] => 1868
)
[YearBuilt] => Array
(
[0] => 1974
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Haleiwa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => SSRE
)
[ListAgentEmail] => Array
(
[0] => ericainhawaii@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-4142
)
[ListAgentFullName] => Array
(
[0] => Erica J Lehmkuhl
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-30T13:01:39.670
)
[Matrix_Unique_ID] => Array
(
[0] => 18008679
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26210754
)
[listing_image] => Array
(
[0] => 26210754
[1] => 26210755
[2] => 26210756
[3] => 26210757
[4] => 26210758
[5] => 26210759
[6] => 26210760
[7] => 26210761
[8] => 26210762
[9] => 26210763
[10] => 26210764
[11] => 26210765
[12] => 26210766
[13] => 26210767
[14] => 26210768
[15] => 26210769
[16] => 26210770
[17] => 26210771
[18] => 26210772
[19] => 26210773
[20] => 26210774
[21] => 26210775
[22] => 26210776
[23] => 26210777
[24] => 26210778
[25] => 26210779
)
[ListingContractDate] => Array
(
[0] => 2024-05-16
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 8,386 sf
- Living (sf): 1,868
- Year Built: 1974
- Property Condition: Average
- Number of Parking Spaces: 6
- View: City,Mountain,Other
- Listing Office: Seaside Realty LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Haleiwa
- Middle School: Waialua
- High School: Waialua
