Listing
Overview
Price: $1,100,000
Area: KUILIMA
Status: Active Under Contract
Kuilima Estates West 148 is a fully-furnished, turn-key, nightly-rentable condo located within the Ritz Carlton Turtle Bay Resort on the North Shore of Oahu. Completely and fully renovated in 2022, this condo features all new flooring, a new kitchen, new bathroom, a renovated primary bedroom with a king size bed, and an additional 4 bunk bed beds in the living room for additional sleeping accommodations. The spacious open layout floor plan extends into the screened in lanai, which looks out onto the green grass of the Fazio Golf Course. Kuilima Estates West features 3 swimming pools, BBQ, tennis courts, basketball, and pickleball. A few hundred yards from the condo is the Ritz Carlton Turtle Bay Resort, a beautiful sandy beach cove, fine dining at Roy’s Beach House, Lei Lei’s, and Alaia, as well as swimming, surfing, horseback riding, and world class golf. Very easy to view on short notice between now and Thursday, September 5th. Welcome home to paradise! Listing by: HomeSmart Island Homes (808) 729-7643
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202410898"
}
["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) "148A"
}
["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(32) "https://vimeo.com/liveoahu/kw148"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1100000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1100000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(977) "Kuilima Estates West 148 is a fully-furnished, turn-key, nightly-rentable condo located within the Ritz Carlton Turtle Bay Resort on the North Shore of Oahu. Completely and fully renovated in 2022, this condo features all new flooring, a new kitchen, new bathroom, a renovated primary bedroom with a king size bed, and an additional 4 bunk bed beds in the living room for additional sleeping accommodations. The spacious open layout floor plan extends into the screened in lanai, which looks out onto the green grass of the Fazio Golf Course. Kuilima Estates West features 3 swimming pools, BBQ, tennis courts, basketball, and pickleball. A few hundred yards from the condo is the Ritz Carlton Turtle Bay Resort, a beautiful sandy beach cove, fine dining at Roy’s Beach House, Lei Lei’s, and Alaia, as well as swimming, surfing, horseback riding, and world class golf. Very easy to view on short notice between now and Thursday, September 5th. Welcome home to paradise!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "HomeSmart Island Homes"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "785"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests West"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(27) "Garden,Golf Course,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "649.48"
}
["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) "HSIH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "pmjavier@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 729-7643"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Paul M Javier"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-01T05:32:23.970"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17996255"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-09T15:30:29.770"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26197286"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26197286"
[1]=>
string(8) "26197287"
[2]=>
string(8) "26197288"
[3]=>
string(8) "26197289"
[4]=>
string(8) "26197290"
[5]=>
string(8) "26197291"
[6]=>
string(8) "26197292"
[7]=>
string(8) "26197293"
[8]=>
string(8) "26197294"
[9]=>
string(8) "26197295"
[10]=>
string(8) "26197296"
[11]=>
string(8) "26197297"
[12]=>
string(8) "26197298"
[13]=>
string(8) "26197299"
[14]=>
string(8) "26197300"
[15]=>
string(8) "26197301"
[16]=>
string(8) "26197302"
[17]=>
string(8) "26197303"
[18]=>
string(8) "26197304"
[19]=>
string(8) "26197305"
[20]=>
string(8) "26197306"
[21]=>
string(8) "26197307"
[22]=>
string(8) "26197308"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202410898
)
[StreetNumber] => Array
(
[0] => 57-101
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kuilima
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 148A
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://vimeo.com/liveoahu/kw148
)
[ListPrice] => Array
(
[0] => 1100000.00
)
[CurrentPrice] => Array
(
[0] => 1100000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Kuilima Estates West 148 is a fully-furnished, turn-key, nightly-rentable condo located within the Ritz Carlton Turtle Bay Resort on the North Shore of Oahu. Completely and fully renovated in 2022, this condo features all new flooring, a new kitchen, new bathroom, a renovated primary bedroom with a king size bed, and an additional 4 bunk bed beds in the living room for additional sleeping accommodations. The spacious open layout floor plan extends into the screened in lanai, which looks out onto the green grass of the Fazio Golf Course. Kuilima Estates West features 3 swimming pools, BBQ, tennis courts, basketball, and pickleball. A few hundred yards from the condo is the Ritz Carlton Turtle Bay Resort, a beautiful sandy beach cove, fine dining at Roy’s Beach House, Lei Lei’s, and Alaia, as well as swimming, surfing, horseback riding, and world class golf. Very easy to view on short notice between now and Thursday, September 5th. Welcome home to paradise!
)
[ListOfficeName] => Array
(
[0] => HomeSmart Island Homes
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 765523.00
)
[SqftTotal] => Array
(
[0] => 785
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Kuilima Ests West
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Golf Course,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 649.48
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahuku
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => HSIH
)
[ListAgentEmail] => Array
(
[0] => pmjavier@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 729-7643
)
[ListAgentFullName] => Array
(
[0] => Paul M Javier
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-01T05:32:23.970
)
[Matrix_Unique_ID] => Array
(
[0] => 17996255
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-09T15:30:29.770
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Golf Course
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26197286
)
[listing_image] => Array
(
[0] => 26197286
[1] => 26197287
[2] => 26197288
[3] => 26197289
[4] => 26197290
[5] => 26197291
[6] => 26197292
[7] => 26197293
[8] => 26197294
[9] => 26197295
[10] => 26197296
[11] => 26197297
[12] => 26197298
[13] => 26197299
[14] => 26197300
[15] => 26197301
[16] => 26197302
[17] => 26197303
[18] => 26197304
[19] => 26197305
[20] => 26197306
[21] => 26197307
[22] => 26197308
)
)
- BedsTotal: 1
- Full Baths: 1
- Land Area (sf): 765,523
- Living (sf): 785
- Year Built: 1973
- Building Name: Kuilima Ests West
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Garden,Golf Course,Mountain
- Listing Office: HomeSmart Island Homes
- Maintenance Fees: $649
- Land Tenure: FS - Fee Simple
- Elementary School: Kahuku
- Middle School: Kahuku
- High School: Kahuku
