57-091 Lalo Kuilima Place Unit 60 Kahuku, HI 96731
Listing
Overview
Price: $1,750,000
Area: KUILIMA
Status: Active
Welcome to your fully renovated and one-of-a-kind treasures at the Turtle Bay Resort on Oahu’s North Shore! This newly completed interior has been renovated and reconstructed into a 2 bedroom, 2 bathroom luxury unit that's ready to go, INCLUDING ALL FURNISHINGS. There is no other unit in the entire complex with this custom layout which allows for many guests to enjoy. New plumbing, electrical, stainless-steel appliances, new furniture, and custom finishes throughout this gem (List of Improvements in Supplements). Kuilima Estates East is one of the only communities on the North Shore that allows for short-term nightly vacation rentals. Well-manicured, spacious grounds with amenities including several pools, tennis/pickleball courts, bbq, & just a short walk to white sandy beaches! If you want to explore resort amenities, you are close to the newly remodeled Turtle Bay Resort, the world class Arnold Palmer championship golf course, cuisine by award winning chef Roy Yamaguchi, horse stables, scenic paths & more! North Shore surf spots, fishing, and all water sports are close by. Square footage is approximate, and bedrooms do not match tax records. Buyer to do their own due diligence. Listing by: Coldwell Banker Realty (808) 224-1250
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407797"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "57-091"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(12) "Lalo Kuilima"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(2) "60"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1201) "Welcome to your fully renovated and one-of-a-kind treasures at the Turtle Bay Resort on Oahu’s North Shore! This newly completed interior has been renovated and reconstructed into a 2 bedroom, 2 bathroom luxury unit that's ready to go, INCLUDING ALL FURNISHINGS. There is no other unit in the entire complex with this custom layout which allows for many guests to enjoy. New plumbing, electrical, stainless-steel appliances, new furniture, and custom finishes throughout this gem (List of Improvements in Supplements). Kuilima Estates East is one of the only communities on the North Shore that allows for short-term nightly vacation rentals. Well-manicured, spacious grounds with amenities including several pools, tennis/pickleball courts, bbq, & just a short walk to white sandy beaches! If you want to explore resort amenities, you are close to the newly remodeled Turtle Bay Resort, the world class Arnold Palmer championship golf course, cuisine by award winning chef Roy Yamaguchi, horse stables, scenic paths & more! North Shore surf spots, fishing, and all water sports are close by. Square footage is approximate, and bedrooms do not match tax records. Buyer to do their own due diligence."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "957"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests East"
}
["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(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "beachhousehawaii@hotmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 224-1250"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Scott A Langford"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-29T15:25:15.103"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17926524"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-12T08:21:27.557"
}
["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) "26162974"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26162974"
[1]=>
string(8) "26162975"
[2]=>
string(8) "26162976"
[3]=>
string(8) "26162977"
[4]=>
string(8) "26162978"
[5]=>
string(8) "26162979"
[6]=>
string(8) "26162980"
[7]=>
string(8) "26162981"
[8]=>
string(8) "26162982"
[9]=>
string(8) "26162983"
[10]=>
string(8) "26162984"
[11]=>
string(8) "26162985"
[12]=>
string(8) "26162986"
[13]=>
string(8) "26162987"
[14]=>
string(8) "26162988"
[15]=>
string(8) "26162989"
[16]=>
string(8) "26162990"
[17]=>
string(8) "26162991"
[18]=>
string(8) "26162992"
[19]=>
string(8) "26162993"
[20]=>
string(8) "26162994"
[21]=>
string(8) "26162995"
[22]=>
string(8) "26162996"
[23]=>
string(8) "26162997"
[24]=>
string(8) "26183529"
[25]=>
string(8) "26183530"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407797
)
[StreetNumber] => Array
(
[0] => 57-091
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lalo Kuilima
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 60
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1750000.00
)
[CurrentPrice] => Array
(
[0] => 1750000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your fully renovated and one-of-a-kind treasures at the Turtle Bay Resort on Oahu’s North Shore! This newly completed interior has been renovated and reconstructed into a 2 bedroom, 2 bathroom luxury unit that's ready to go, INCLUDING ALL FURNISHINGS. There is no other unit in the entire complex with this custom layout which allows for many guests to enjoy. New plumbing, electrical, stainless-steel appliances, new furniture, and custom finishes throughout this gem (List of Improvements in Supplements). Kuilima Estates East is one of the only communities on the North Shore that allows for short-term nightly vacation rentals. Well-manicured, spacious grounds with amenities including several pools, tennis/pickleball courts, bbq, & just a short walk to white sandy beaches! If you want to explore resort amenities, you are close to the newly remodeled Turtle Bay Resort, the world class Arnold Palmer championship golf course, cuisine by award winning chef Roy Yamaguchi, horse stables, scenic paths & more! North Shore surf spots, fishing, and all water sports are close by. Square footage is approximate, and bedrooms do not match tax records. Buyer to do their own due diligence.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 0.00
)
[SqftTotal] => Array
(
[0] => 957
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Kuilima Ests East
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahuku
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => beachhousehawaii@hotmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 224-1250
)
[ListAgentFullName] => Array
(
[0] => Scott A Langford
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-29T15:25:15.103
)
[Matrix_Unique_ID] => Array
(
[0] => 17926524
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-12T08:21:27.557
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26162974
)
[listing_image] => Array
(
[0] => 26162974
[1] => 26162975
[2] => 26162976
[3] => 26162977
[4] => 26162978
[5] => 26162979
[6] => 26162980
[7] => 26162981
[8] => 26162982
[9] => 26162983
[10] => 26162984
[11] => 26162985
[12] => 26162986
[13] => 26162987
[14] => 26162988
[15] => 26162989
[16] => 26162990
[17] => 26162991
[18] => 26162992
[19] => 26162993
[20] => 26162994
[21] => 26162995
[22] => 26162996
[23] => 26162997
[24] => 26183529
[25] => 26183530
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 0
- Living (sf): 957
- Year Built: 1975
- Building Name: Kuilima Ests East
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Garden
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
- Elementary School: Kahuku
- Middle School: Kahuku
- High School: Kahuku
