67-374 Alahaka Place Waialua, HI 96791
Listing
Overview
Price: $1,300,000
Area: WAIALUA
Status: Active
Experience the charm of Northshore country living in the tranquil neighborhood of Waialua, rich in plantation history.This delightful property offers the opportunity to personalize a 3-bedrm/1bath home with an additional family room and an outdoor room w/a full bath. Situated on a generous 8,299 lot on a cul-de-sac directly across a peaceful neighborhood park.The large recreation room offers ample space for entertainment! A covered workroom w/additional storage adds functionality to the property. Located just minutes from sandy beaches, renowned surf spots, and historical Hale'iwa Town, easy access to dining, shopping and local amenities.Nearby, you will find hiking trails, polo field, and Ka'ena State Park. Plus, it's only a 45 drive to the airport, making it an ideal location for both convenience and island living. This property is ready for your creative vision-bring your ideas and make it your own. Don't miss out on the opportunity to own a piece of Northshore Paradise. Listing by: TLC Realty LLC (808) 722-3040
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426072"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-374"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Alahaka"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1300000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(988) "Experience the charm of Northshore country living in the tranquil neighborhood of Waialua, rich in plantation history.This delightful property offers the opportunity to personalize a 3-bedrm/1bath home with an additional family room and an outdoor room w/a full bath. Situated on a generous 8,299 lot on a cul-de-sac directly across a peaceful neighborhood park.The large recreation room offers ample space for entertainment! A covered workroom w/additional storage adds functionality to the property. Located just minutes from sandy beaches, renowned surf spots, and historical Hale'iwa Town, easy access to dining, shopping and local amenities.Nearby, you will find hiking trails, polo field, and Ka'ena State Park. Plus, it's only a 45 drive to the airport, making it an ideal location for both convenience and island living. This property is ready for your creative vision-bring your ideas and make it your own. Don't miss out on the opportunity to own a piece of Northshore Paradise."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "TLC Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8299.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2842"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1960"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "TLCT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "mlyons7734@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 722-3040"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Marilee Y Lyons"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-08T10:58:46.343"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18367590"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-05T16:02:55.773"
}
["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) "26756973"
}
["listing_image"]=>
array(4) {
[0]=>
string(8) "26756973"
[1]=>
string(8) "26756974"
[2]=>
string(8) "26756975"
[3]=>
string(8) "26756976"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426072
)
[StreetNumber] => Array
(
[0] => 67-374
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Alahaka
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1300000.00
)
[CurrentPrice] => Array
(
[0] => 1300000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience the charm of Northshore country living in the tranquil neighborhood of Waialua, rich in plantation history.This delightful property offers the opportunity to personalize a 3-bedrm/1bath home with an additional family room and an outdoor room w/a full bath. Situated on a generous 8,299 lot on a cul-de-sac directly across a peaceful neighborhood park.The large recreation room offers ample space for entertainment! A covered workroom w/additional storage adds functionality to the property. Located just minutes from sandy beaches, renowned surf spots, and historical Hale'iwa Town, easy access to dining, shopping and local amenities.Nearby, you will find hiking trails, polo field, and Ka'ena State Park. Plus, it's only a 45 drive to the airport, making it an ideal location for both convenience and island living. This property is ready for your creative vision-bring your ideas and make it your own. Don't miss out on the opportunity to own a piece of Northshore Paradise.
)
[ListOfficeName] => Array
(
[0] => TLC Realty LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8299.00
)
[SqftTotal] => Array
(
[0] => 2842
)
[YearBuilt] => Array
(
[0] => 1960
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => TLCT
)
[ListAgentEmail] => Array
(
[0] => mlyons7734@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 722-3040
)
[ListAgentFullName] => Array
(
[0] => Marilee Y Lyons
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-08T10:58:46.343
)
[Matrix_Unique_ID] => Array
(
[0] => 18367590
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-05T16:02:55.773
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26756973
)
[listing_image] => Array
(
[0] => 26756973
[1] => 26756974
[2] => 26756975
[3] => 26756976
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 8,299
- Living (sf): 2,842
- Year Built: 1960
- Property Condition: Average
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: TLC Realty LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
