Listing
Overview
Price: $1,050,000
Area: KUILIMA
Status: Active Under Contract
Stunning turn-key condo completely ready to host your first guest. This LEGAL short term vacation rental is currently generating over $100k in rental income annually. Located overlooking the world famous Arnold Palmer golf course on the grounds of the Ritz Carlton, Turtle Bay Resort, this condo is one of the only condos with a peek a boo ocean view from the living room and a fully legal permitted loft. It's steps away from the resort and top restaurants to include Roy's Beach House, Lei Lei's and Alaia. Enjoy beautiful sunsets, several hiking/biking trails from Kawela Bay to Kahuku Point, horseback riding, the resort spa or fitness center, helicopter rides, zip-lining and several secluded beaches within walking distance. The Kuilima Estates West Community offers resort style amenities to include 2 swimming pools, BBQ areas, tennis courts, basketball courts and pickleball. Kuilima Estates West is a safe gated community with 24 hour security. Listing by: eXp Realty (808) 554-2262
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426860"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "57-101"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kuilima"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "770F"
}
["City"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96731"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(64) "https://unbranded.youriguide.com/70_57_101_kuilima_dr_kahuku_hi/"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(954) "Stunning turn-key condo completely ready to host your first guest. This LEGAL short term vacation rental is currently generating over $100k in rental income annually. Located overlooking the world famous Arnold Palmer golf course on the grounds of the Ritz Carlton, Turtle Bay Resort, this condo is one of the only condos with a peek a boo ocean view from the living room and a fully legal permitted loft. It's steps away from the resort and top restaurants to include Roy's Beach House, Lei Lei's and Alaia. Enjoy beautiful sunsets, several hiking/biking trails from Kawela Bay to Kahuku Point, horseback riding, the resort spa or fitness center, helicopter rides, zip-lining and several secluded beaches within walking distance. The Kuilima Estates West Community offers resort style amenities to include 2 swimming pools, BBQ areas, tennis courts, basketball courts and pickleball. Kuilima Estates West is a safe gated community with 24 hour security."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "765523.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "621"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests West"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "453.20"
}
["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(26) "sherine@hawaiiluxhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 554-2262"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Sherine M Duncan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-01T15:00:02.063"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18389734"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26774562"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26774562"
[1]=>
string(8) "26774563"
[2]=>
string(8) "26774564"
[3]=>
string(8) "26774565"
[4]=>
string(8) "26774566"
[5]=>
string(8) "26774567"
[6]=>
string(8) "26774568"
[7]=>
string(8) "26774569"
[8]=>
string(8) "26774570"
[9]=>
string(8) "26774571"
[10]=>
string(8) "26774572"
[11]=>
string(8) "26774573"
[12]=>
string(8) "26774574"
[13]=>
string(8) "26774575"
[14]=>
string(8) "26774576"
[15]=>
string(8) "26774577"
[16]=>
string(8) "26774578"
[17]=>
string(8) "26774579"
[18]=>
string(8) "26774580"
[19]=>
string(8) "26774581"
[20]=>
string(8) "26774582"
[21]=>
string(8) "26774583"
[22]=>
string(8) "26774584"
[23]=>
string(8) "26774585"
[24]=>
string(8) "26774586"
[25]=>
string(8) "26774587"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-18"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426860
)
[StreetNumber] => Array
(
[0] => 57-101
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kuilima
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 770F
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://unbranded.youriguide.com/70_57_101_kuilima_dr_kahuku_hi/
)
[ListPrice] => Array
(
[0] => 1050000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Stunning turn-key condo completely ready to host your first guest. This LEGAL short term vacation rental is currently generating over $100k in rental income annually. Located overlooking the world famous Arnold Palmer golf course on the grounds of the Ritz Carlton, Turtle Bay Resort, this condo is one of the only condos with a peek a boo ocean view from the living room and a fully legal permitted loft. It's steps away from the resort and top restaurants to include Roy's Beach House, Lei Lei's and Alaia. Enjoy beautiful sunsets, several hiking/biking trails from Kawela Bay to Kahuku Point, horseback riding, the resort spa or fitness center, helicopter rides, zip-lining and several secluded beaches within walking distance. The Kuilima Estates West Community offers resort style amenities to include 2 swimming pools, BBQ areas, tennis courts, basketball courts and pickleball. Kuilima Estates West is a safe gated community with 24 hour security.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 765523.00
)
[SqftTotal] => Array
(
[0] => 621
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Kuilima Ests West
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Golf Course
)
[MaintenanceExpense] => Array
(
[0] => 453.20
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => sherine@hawaiiluxhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 554-2262
)
[ListAgentFullName] => Array
(
[0] => Sherine M Duncan
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-01T15:00:02.063
)
[Matrix_Unique_ID] => Array
(
[0] => 18389734
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Golf Course
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26774562
)
[listing_image] => Array
(
[0] => 26774562
[1] => 26774563
[2] => 26774564
[3] => 26774565
[4] => 26774566
[5] => 26774567
[6] => 26774568
[7] => 26774569
[8] => 26774570
[9] => 26774571
[10] => 26774572
[11] => 26774573
[12] => 26774574
[13] => 26774575
[14] => 26774576
[15] => 26774577
[16] => 26774578
[17] => 26774579
[18] => 26774580
[19] => 26774581
[20] => 26774582
[21] => 26774583
[22] => 26774584
[23] => 26774585
[24] => 26774586
[25] => 26774587
)
[ListingContractDate] => Array
(
[0] => 2024-11-18
)
)
- Full Baths: 1
- Land Area (sf): 765,523 sf
- Living (sf): 621
- Year Built: 1973
- Building Name: Kuilima Ests West
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Golf Course
- Listing Office: eXp Realty
- Maintenance Fees: $453
- Land Tenure: FS - Fee Simple