Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
68-47 Apuhihi Street Unit 107 Waialua, HI 96791
Listing Overview
Price: $685,000 Area: WAIALUA Status: Sold
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(4) "Sold"
}
["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(10) "2024-11-07"
}
["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] => Sold
)
[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] => 2024-11-07
)
[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
)
)
