68-47 Apuhihi Street Unit 107 Waialua, HI 96791
Listing
Overview
Price: $685,000
Area: WAIALUA
Status: Pending
Waialua Dreams do come true. Over 800 Sq ft of Newly remodeled townhome only steps to the beach. 2 bedroom 1 and a half bath with private landscaped and fenced yard. Outdoor shower, covered lanai and lots of space for BBQ's with friends, surfboards, beach cruisers and ocean toys. Your Country lifestyle awaits with the world class surf of the North Shore, bike paths, hiking trails and secluded beaches. Location has easy access to Charming Haleiwa Town, Waialua Sugar Mill shops and Mililani town with Walmart and Costco. Only 15 minutes drive to Schofield Barracks and less than an hour to Honolulu and the international airport. Due to the unit being an end unit sharing so few walls, with such a great yard the home lives like a house. Great opportunity to get into Waialua for way less than the 1 million that single family homes are currently selling for. Assessment to be paid by owners in escrow at closing. Assessment is due to expire November of 2025. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421109"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(5) "68-47"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Apuhihi"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "107"
}
["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(9) "685000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "685000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(962) "Waialua Dreams do come true. Over 800 Sq ft of Newly remodeled townhome only steps to the beach. 2 bedroom 1 and a half bath with private landscaped and fenced yard. Outdoor shower, covered lanai and lots of space for BBQ's with friends, surfboards, beach cruisers and ocean toys. Your Country lifestyle awaits with the world class surf of the North Shore, bike paths, hiking trails and secluded beaches. Location has easy access to Charming Haleiwa Town, Waialua Sugar Mill shops and Mililani town with Walmart and Costco. Only 15 minutes drive to Schofield Barracks and less than an hour to Honolulu and the international airport. Due to the unit being an end unit sharing so few walls, with such a great yard the home lives like a house. Great opportunity to get into Waialua for way less than the 1 million that single family homes are currently selling for. Assessment to be paid by owners in escrow at closing. Assessment is due to expire November of 2025."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10934.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "915"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1987"
}
["BuildingName"]=>
array(1) {
[0]=>
string(22) "Mokuleia Country Homes"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "677.00"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "jason@oahuhomerealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Jason Subt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-08T18:21:42.813"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18263544"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-15T09:37:42.560"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26695508"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26695508"
[1]=>
string(8) "26695509"
[2]=>
string(8) "26695510"
[3]=>
string(8) "26695511"
[4]=>
string(8) "26695512"
[5]=>
string(8) "26695513"
[6]=>
string(8) "26695514"
[7]=>
string(8) "26695515"
[8]=>
string(8) "26695516"
[9]=>
string(8) "26695517"
[10]=>
string(8) "26695518"
[11]=>
string(8) "26695519"
[12]=>
string(8) "26695520"
[13]=>
string(8) "26695521"
[14]=>
string(8) "26695522"
[15]=>
string(8) "26695523"
[16]=>
string(8) "26695524"
[17]=>
string(8) "26695525"
[18]=>
string(8) "26695526"
[19]=>
string(8) "26695527"
[20]=>
string(8) "26695528"
[21]=>
string(8) "26695529"
[22]=>
string(8) "26695530"
[23]=>
string(8) "26695531"
[24]=>
string(8) "26695532"
[25]=>
string(8) "26695533"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421109
)
[StreetNumber] => Array
(
[0] => 68-47
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 107
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 685000.00
)
[CurrentPrice] => Array
(
[0] => 685000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Waialua Dreams do come true. Over 800 Sq ft of Newly remodeled townhome only steps to the beach. 2 bedroom 1 and a half bath with private landscaped and fenced yard. Outdoor shower, covered lanai and lots of space for BBQ's with friends, surfboards, beach cruisers and ocean toys. Your Country lifestyle awaits with the world class surf of the North Shore, bike paths, hiking trails and secluded beaches. Location has easy access to Charming Haleiwa Town, Waialua Sugar Mill shops and Mililani town with Walmart and Costco. Only 15 minutes drive to Schofield Barracks and less than an hour to Honolulu and the international airport. Due to the unit being an end unit sharing so few walls, with such a great yard the home lives like a house. Great opportunity to get into Waialua for way less than the 1 million that single family homes are currently selling for. Assessment to be paid by owners in escrow at closing. Assessment is due to expire November of 2025.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10934.00
)
[SqftTotal] => Array
(
[0] => 915
)
[YearBuilt] => Array
(
[0] => 1987
)
[BuildingName] => Array
(
[0] => Mokuleia Country Homes
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 677.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => jason@oahuhomerealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Jason Subt
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-08T18:21:42.813
)
[Matrix_Unique_ID] => Array
(
[0] => 18263544
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-15T09:37:42.560
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26695508
)
[listing_image] => Array
(
[0] => 26695508
[1] => 26695509
[2] => 26695510
[3] => 26695511
[4] => 26695512
[5] => 26695513
[6] => 26695514
[7] => 26695515
[8] => 26695516
[9] => 26695517
[10] => 26695518
[11] => 26695519
[12] => 26695520
[13] => 26695521
[14] => 26695522
[15] => 26695523
[16] => 26695524
[17] => 26695525
[18] => 26695526
[19] => 26695527
[20] => 26695528
[21] => 26695529
[22] => 26695530
[23] => 26695531
[24] => 26695532
[25] => 26695533
)
)
- BedsTotal: 2
- Full Baths: 1
- Half Baths: 1
- Land Area (sf): 10,934
- Living (sf): 915
- Year Built: 1987
- Building Name: Mokuleia Country Homes
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: eXp Realty
- Maintenance Fees: $677
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
