Listing
Overview
Price: $1,480,000
Area: KUILIMA
Status: Active
Discover the allure of Oahu's north shore, where each sunrise paints the sky in golden hues and every wave whispers tales of adventure. Nestled beside the newly revamped Turtle Bay resort, this sanctuary offers the essence of Hawaiian paradise. Indulge in sun-soaked days and golf escapades on the Fazio course. Retreat to a spacious one-bedroom, two-bathroom haven with a loft featuring three full-size beds. Feel the tropical breeze and savor ocean dips just steps away. Enjoy gated security, manicured landscapes, pools, BBQ’s, tennis courts, and all overseen by a resident manager. One of the few legal vacation rentals on the North Shore, primed for short-term stays. Vaulted ceiling leaves room for a generous-sized loft sleeping area. This unit is booked regularly and challenging to get into. Added bonus, bedroom and bath can be a separate lockout unit. Total square footage is approximately 1,169, this includes the 322 s.q. ft. loft, non-permitted. Financials upon request. Listing by: Coldwell Banker Realty (808) 738-3904
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423857"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "57-120"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(12) "Lalo Kuilima"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(3) "Way"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "110"
}
["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(87) "https://url.usb.m.mimecastprotect.com/s/LI8UCA8E7ZIZoAYQXt86lEI?domain=player.vimeo.com"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1480000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1480000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(986) "Discover the allure of Oahu's north shore, where each sunrise paints the sky in golden hues and every wave whispers tales of adventure. Nestled beside the newly revamped Turtle Bay resort, this sanctuary offers the essence of Hawaiian paradise. Indulge in sun-soaked days and golf escapades on the Fazio course. Retreat to a spacious one-bedroom, two-bathroom haven with a loft featuring three full-size beds. Feel the tropical breeze and savor ocean dips just steps away. Enjoy gated security, manicured landscapes, pools, BBQ’s, tennis courts, and all overseen by a resident manager. One of the few legal vacation rentals on the North Shore, primed for short-term stays. Vaulted ceiling leaves room for a generous-sized loft sleeping area. This unit is booked regularly and challenging to get into. Added bonus, bedroom and bath can be a separate lockout unit. Total square footage is approximately 1,169, this includes the 322 s.q. ft. loft, non-permitted. Financials upon request."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "865"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests East"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "837.90"
}
["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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "darcy@homesbythesea.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "D'Arcy S Kerrigan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-16T08:10:06.550"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18322915"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-14T14:40:58.117"
}
["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) "26730690"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26730690"
[1]=>
string(8) "26730691"
[2]=>
string(8) "26730692"
[3]=>
string(8) "26730693"
[4]=>
string(8) "26730694"
[5]=>
string(8) "26730695"
[6]=>
string(8) "26730696"
[7]=>
string(8) "26730697"
[8]=>
string(8) "26730698"
[9]=>
string(8) "26730699"
[10]=>
string(8) "26730700"
[11]=>
string(8) "26730701"
[12]=>
string(8) "26730702"
[13]=>
string(8) "26730703"
[14]=>
string(8) "26730704"
[15]=>
string(8) "26730705"
[16]=>
string(8) "26730706"
[17]=>
string(8) "26730707"
[18]=>
string(8) "26730708"
[19]=>
string(8) "26730709"
[20]=>
string(8) "26730710"
[21]=>
string(8) "26730711"
[22]=>
string(8) "26730712"
[23]=>
string(8) "26730713"
[24]=>
string(8) "26730714"
[25]=>
string(8) "26730715"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423857
)
[StreetNumber] => Array
(
[0] => 57-120
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lalo Kuilima
)
[StreetSuffix] => Array
(
[0] => Way
)
[UnitNumber] => Array
(
[0] => 110
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://url.usb.m.mimecastprotect.com/s/LI8UCA8E7ZIZoAYQXt86lEI?domain=player.vimeo.com
)
[ListPrice] => Array
(
[0] => 1480000.00
)
[CurrentPrice] => Array
(
[0] => 1480000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the allure of Oahu's north shore, where each sunrise paints the sky in golden hues and every wave whispers tales of adventure. Nestled beside the newly revamped Turtle Bay resort, this sanctuary offers the essence of Hawaiian paradise. Indulge in sun-soaked days and golf escapades on the Fazio course. Retreat to a spacious one-bedroom, two-bathroom haven with a loft featuring three full-size beds. Feel the tropical breeze and savor ocean dips just steps away. Enjoy gated security, manicured landscapes, pools, BBQ’s, tennis courts, and all overseen by a resident manager. One of the few legal vacation rentals on the North Shore, primed for short-term stays. Vaulted ceiling leaves room for a generous-sized loft sleeping area. This unit is booked regularly and challenging to get into. Added bonus, bedroom and bath can be a separate lockout unit. Total square footage is approximately 1,169, this includes the 322 s.q. ft. loft, non-permitted. Financials upon request.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 865
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Kuilima Ests East
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Golf Course
)
[MaintenanceExpense] => Array
(
[0] => 837.90
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => darcy@homesbythesea.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => D'Arcy S Kerrigan
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-16T08:10:06.550
)
[Matrix_Unique_ID] => Array
(
[0] => 18322915
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-14T14:40:58.117
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Golf Course
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26730690
)
[listing_image] => Array
(
[0] => 26730690
[1] => 26730691
[2] => 26730692
[3] => 26730693
[4] => 26730694
[5] => 26730695
[6] => 26730696
[7] => 26730697
[8] => 26730698
[9] => 26730699
[10] => 26730700
[11] => 26730701
[12] => 26730702
[13] => 26730703
[14] => 26730704
[15] => 26730705
[16] => 26730706
[17] => 26730707
[18] => 26730708
[19] => 26730709
[20] => 26730710
[21] => 26730711
[22] => 26730712
[23] => 26730713
[24] => 26730714
[25] => 26730715
)
)
- BedsTotal: 1
- Full Baths: 2
- Living (sf): 865
- Year Built: 1975
- Building Name: Kuilima Ests East
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Golf Course
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $838
- Land Tenure: FS - Fee Simple
