Our office will be closed on Monday, November 11th, 2024.
66-397 Waialua Beach Road Haleiwa, HI 96712
Listing Overview
Price: $1,260,000 Area: WAIALUA Status: Active
Discover the perfect blend of opportunity and lifestyle in this 4-bedroom, 2.5-bath, two-story home located in the historic beach town of Haleiwa on Oahu's North Shore. With its spacious design, this home offers flexibility for both investors and primary residents. The lower level features a large living/dining area with a wet bar, a bedroom, and a full bath, making it ideal for use as an in-law suite, work studio, or rental unit with a separate entrance—perfect for subsidizing your mortgage or generating dual income for investors. The second floor boasts stunning open wood beam ceilings, an office/den, a kitchen, and additional living and dining areas, all highlighted by a beautifully hand-painted stained glass entry door. Three spacious bedrooms are located upstairs, including a primary suite with a half bath, alongside a full bath for convenience. Enjoy outdoor living with a fenced backyard, a large patio and carport, all within minutes of world-class surf and swim beaches, eateries, grocery stores, a bike path, bus line, and schools. Don't miss this exceptional opportunity in the vibrant Haleiwa and Waialua country towns.One or more photos have been enhanced. Listing by: eXp Realty (808) 222-0478
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418226"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-397"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(13) "Waialua Beach"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1260000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1260000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1183) "Discover the perfect blend of opportunity and lifestyle in this 4-bedroom, 2.5-bath, two-story home located in the historic beach town of Haleiwa on Oahu's North Shore. With its spacious design, this home offers flexibility for both investors and primary residents. The lower level features a large living/dining area with a wet bar, a bedroom, and a full bath, making it ideal for use as an in-law suite, work studio, or rental unit with a separate entrance—perfect for subsidizing your mortgage or generating dual income for investors. The second floor boasts stunning open wood beam ceilings, an office/den, a kitchen, and additional living and dining areas, all highlighted by a beautifully hand-painted stained glass entry door. Three spacious bedrooms are located upstairs, including a primary suite with a half bath, alongside a full bath for convenience. Enjoy outdoor living with a fenced backyard, a large patio and carport, all within minutes of world-class surf and swim beaches, eateries, grocery stores, a bike path, bus line, and schools. Don't miss this exceptional opportunity in the vibrant Haleiwa and Waialua country towns.One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6055.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2205"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1964"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Other"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "matt.hirealtor@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 222-0478"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Matthew J Iannaccio"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-06T13:00:01.833"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18201072"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-26T08:31:09.253"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26708201"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26708201"
[1]=>
string(8) "26708202"
[2]=>
string(8) "26708203"
[3]=>
string(8) "26708204"
[4]=>
string(8) "26708205"
[5]=>
string(8) "26708206"
[6]=>
string(8) "26708207"
[7]=>
string(8) "26708208"
[8]=>
string(8) "26708209"
[9]=>
string(8) "26708210"
[10]=>
string(8) "26708211"
[11]=>
string(8) "26708212"
[12]=>
string(8) "26708213"
[13]=>
string(8) "26708214"
[14]=>
string(8) "26708215"
[15]=>
string(8) "26708216"
[16]=>
string(8) "26708217"
[17]=>
string(8) "26708218"
[18]=>
string(8) "26708219"
[19]=>
string(8) "26708220"
[20]=>
string(8) "26708221"
[21]=>
string(8) "26708222"
[22]=>
string(8) "26708223"
[23]=>
string(8) "26708224"
[24]=>
string(8) "26708225"
[25]=>
string(8) "26708226"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418226
)
[StreetNumber] => Array
(
[0] => 66-397
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waialua Beach
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1260000.00
)
[CurrentPrice] => Array
(
[0] => 1260000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the perfect blend of opportunity and lifestyle in this 4-bedroom, 2.5-bath, two-story home located in the historic beach town of Haleiwa on Oahu's North Shore. With its spacious design, this home offers flexibility for both investors and primary residents. The lower level features a large living/dining area with a wet bar, a bedroom, and a full bath, making it ideal for use as an in-law suite, work studio, or rental unit with a separate entrance—perfect for subsidizing your mortgage or generating dual income for investors. The second floor boasts stunning open wood beam ceilings, an office/den, a kitchen, and additional living and dining areas, all highlighted by a beautifully hand-painted stained glass entry door. Three spacious bedrooms are located upstairs, including a primary suite with a half bath, alongside a full bath for convenience. Enjoy outdoor living with a fenced backyard, a large patio and carport, all within minutes of world-class surf and swim beaches, eateries, grocery stores, a bike path, bus line, and schools. Don't miss this exceptional opportunity in the vibrant Haleiwa and Waialua country towns.One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 6055.00
)
[SqftTotal] => Array
(
[0] => 2205
)
[YearBuilt] => Array
(
[0] => 1964
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => matt.hirealtor@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 222-0478
)
[ListAgentFullName] => Array
(
[0] => Matthew J Iannaccio
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-06T13:00:01.833
)
[Matrix_Unique_ID] => Array
(
[0] => 18201072
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-26T08:31:09.253
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26708201
)
[listing_image] => Array
(
[0] => 26708201
[1] => 26708202
[2] => 26708203
[3] => 26708204
[4] => 26708205
[5] => 26708206
[6] => 26708207
[7] => 26708208
[8] => 26708209
[9] => 26708210
[10] => 26708211
[11] => 26708212
[12] => 26708213
[13] => 26708214
[14] => 26708215
[15] => 26708216
[16] => 26708217
[17] => 26708218
[18] => 26708219
[19] => 26708220
[20] => 26708221
[21] => 26708222
[22] => 26708223
[23] => 26708224
[24] => 26708225
[25] => 26708226
)
)
