68-665 Hoomana Place Waialua, HI 96791
Listing
Overview
Price: $2,495,000
Area: MOKULEIA
Status: Active
Private beachfront oasis awaits tucked in a quaint Mokuleia neighborhood. This 4 bedroom / 2 bath home has commanding views of aqua blue green waters. Perfect for entertaining or relaxing. Ideally situated for adventure including kiteboarding, surfing and incredible hiking trails. Completely remodeled in 2024. Includes modern luxury updates and furnishings. Current long term corporate lease ($8000/month) allows new buyer multiple months of turnkey use of property. Reliable income and 3-5 months of exclusive use with leasing entity responsible for maintaining property. This unique situation makes for an exceptional second home opportunity. I look forward to discussing details on how this could be an easy and beneficial way to own, enjoy and produce income on an amazing one of a kind property. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426166"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-665"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Hoomana"
}
["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) "2495000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2495000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(802) "Private beachfront oasis awaits tucked in a quaint Mokuleia neighborhood. This 4 bedroom / 2 bath home has commanding views of aqua blue green waters. Perfect for entertaining or relaxing. Ideally situated for adventure including kiteboarding, surfing and incredible hiking trails. Completely remodeled in 2024. Includes modern luxury updates and furnishings. Current long term corporate lease ($8000/month) allows new buyer multiple months of turnkey use of property. Reliable income and 3-5 months of exclusive use with leasing entity responsible for maintaining property. This unique situation makes for an exceptional second home opportunity. I look forward to discussing details on how this could be an easy and beneficial way to own, enjoy and produce income on an amazing one of a kind property."
}
["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) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7774.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1598"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1961"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(29) "Mountain,Ocean,Sunrise,Sunset"
}
["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) "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-11-24T15:00:01.307"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18370022"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-07T15:26:09.960"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26759885"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26759885"
[1]=>
string(8) "26759886"
[2]=>
string(8) "26759887"
[3]=>
string(8) "26759888"
[4]=>
string(8) "26759889"
[5]=>
string(8) "26759890"
[6]=>
string(8) "26759891"
[7]=>
string(8) "26759892"
[8]=>
string(8) "26759893"
[9]=>
string(8) "26759894"
[10]=>
string(8) "26759895"
[11]=>
string(8) "26759896"
[12]=>
string(8) "26759897"
[13]=>
string(8) "26759898"
[14]=>
string(8) "26759899"
[15]=>
string(8) "26759900"
[16]=>
string(8) "26759901"
[17]=>
string(8) "26759902"
[18]=>
string(8) "26759903"
[19]=>
string(8) "26759904"
[20]=>
string(8) "26759905"
[21]=>
string(8) "26759906"
[22]=>
string(8) "26759907"
[23]=>
string(8) "26759908"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426166
)
[StreetNumber] => Array
(
[0] => 68-665
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hoomana
)
[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] => 2495000.00
)
[CurrentPrice] => Array
(
[0] => 2495000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Private beachfront oasis awaits tucked in a quaint Mokuleia neighborhood. This 4 bedroom / 2 bath home has commanding views of aqua blue green waters. Perfect for entertaining or relaxing. Ideally situated for adventure including kiteboarding, surfing and incredible hiking trails. Completely remodeled in 2024. Includes modern luxury updates and furnishings. Current long term corporate lease ($8000/month) allows new buyer multiple months of turnkey use of property. Reliable income and 3-5 months of exclusive use with leasing entity responsible for maintaining property. This unique situation makes for an exceptional second home opportunity. I look forward to discussing details on how this could be an easy and beneficial way to own, enjoy and produce income on an amazing one of a kind property.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7774.00
)
[SqftTotal] => Array
(
[0] => 1598
)
[YearBuilt] => Array
(
[0] => 1961
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[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-11-24T15:00:01.307
)
[Matrix_Unique_ID] => Array
(
[0] => 18370022
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-07T15:26:09.960
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26759885
)
[listing_image] => Array
(
[0] => 26759885
[1] => 26759886
[2] => 26759887
[3] => 26759888
[4] => 26759889
[5] => 26759890
[6] => 26759891
[7] => 26759892
[8] => 26759893
[9] => 26759894
[10] => 26759895
[11] => 26759896
[12] => 26759897
[13] => 26759898
[14] => 26759899
[15] => 26759900
[16] => 26759901
[17] => 26759902
[18] => 26759903
[19] => 26759904
[20] => 26759905
[21] => 26759906
[22] => 26759907
[23] => 26759908
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 7,774
- Living (sf): 1,598
- Year Built: 1961
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Mountain,Ocean,Sunrise,Sunset
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua