57-0 Lalo Kuilima Way Unit 55 Kahuku, HI 96731
Listing
Overview
Price: $795,000
Area: KUILIMA
Status: Active Under Contract
About $57,000 lower than assessed value and even much lower than the fair market price! Amazing opportunity to own and design your own dream house in the highly desirable Kulima Estates East. Luxury North Shore gated community and steps away from the Turtle Bay Resort and golf course. This studio unit is in very fair condition and needs TLC but with good imagination, it can be transformed into a dream tropical home or even into a great investment vacation rental in the preferred North Shore neighborhood! Resortlike amenities such as 2 world-class golf courses, 2 KEE pools, tennis court, pickleball court, clubhouse and BBQ area are at your fingertips as well as all the dining, beaches, hiking, and other activities that Kahuku has to offer. Don't wait before it's too late! To be sold As-Is. Listing by: New Star Hawaii Top Realty (808) 386-2277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415205"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "57-0"
}
["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(2) "55"
}
["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(9) "795000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "795000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(799) "About $57,000 lower than assessed value and even much lower than the fair market price! Amazing opportunity to own and design your own dream house in the highly desirable Kulima Estates East. Luxury North Shore gated community and steps away from the Turtle Bay Resort and golf course. This studio unit is in very fair condition and needs TLC but with good imagination, it can be transformed into a dream tropical home or even into a great investment vacation rental in the preferred North Shore neighborhood! Resortlike amenities such as 2 world-class golf courses, 2 KEE pools, tennis court, pickleball court, clubhouse and BBQ area are at your fingertips as well as all the dining, beaches, hiking, and other activities that Kahuku has to offer. Don't wait before it's too late! To be sold As-Is."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "New Star Hawaii Top 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) "647519.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "667"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests East"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(18) "Garden,Golf Course"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "615.07"
}
["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) "HTOP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "jyu@newstarhtoprealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 386-2277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Jeannie Yu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-07T12:11:00.720"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18103185"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-19T10:53:10.717"
}
["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) "26628566"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26628566"
[1]=>
string(8) "26628567"
[2]=>
string(8) "26628568"
[3]=>
string(8) "26628569"
[4]=>
string(8) "26628570"
[5]=>
string(8) "26628571"
[6]=>
string(8) "26628572"
[7]=>
string(8) "26628573"
[8]=>
string(8) "26628574"
[9]=>
string(8) "26628575"
[10]=>
string(8) "26628576"
[11]=>
string(8) "26628577"
[12]=>
string(8) "26628578"
[13]=>
string(8) "26628579"
[14]=>
string(8) "26628580"
[15]=>
string(8) "26628581"
[16]=>
string(8) "26628582"
[17]=>
string(8) "26628583"
[18]=>
string(8) "26628584"
[19]=>
string(8) "26628585"
[20]=>
string(8) "26628586"
[21]=>
string(8) "26628587"
[22]=>
string(8) "26628938"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415205
)
[StreetNumber] => Array
(
[0] => 57-0
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lalo Kuilima
)
[StreetSuffix] => Array
(
[0] => Way
)
[UnitNumber] => Array
(
[0] => 55
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 795000.00
)
[CurrentPrice] => Array
(
[0] => 795000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => About $57,000 lower than assessed value and even much lower than the fair market price! Amazing opportunity to own and design your own dream house in the highly desirable Kulima Estates East. Luxury North Shore gated community and steps away from the Turtle Bay Resort and golf course. This studio unit is in very fair condition and needs TLC but with good imagination, it can be transformed into a dream tropical home or even into a great investment vacation rental in the preferred North Shore neighborhood! Resortlike amenities such as 2 world-class golf courses, 2 KEE pools, tennis court, pickleball court, clubhouse and BBQ area are at your fingertips as well as all the dining, beaches, hiking, and other activities that Kahuku has to offer. Don't wait before it's too late! To be sold As-Is.
)
[ListOfficeName] => Array
(
[0] => New Star Hawaii Top Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 647519.00
)
[SqftTotal] => Array
(
[0] => 667
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Kuilima Ests East
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Golf Course
)
[MaintenanceExpense] => Array
(
[0] => 615.07
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HTOP
)
[ListAgentEmail] => Array
(
[0] => jyu@newstarhtoprealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 386-2277
)
[ListAgentFullName] => Array
(
[0] => Jeannie Yu
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-07T12:11:00.720
)
[Matrix_Unique_ID] => Array
(
[0] => 18103185
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-19T10:53:10.717
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Golf Course
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26628566
)
[listing_image] => Array
(
[0] => 26628566
[1] => 26628567
[2] => 26628568
[3] => 26628569
[4] => 26628570
[5] => 26628571
[6] => 26628572
[7] => 26628573
[8] => 26628574
[9] => 26628575
[10] => 26628576
[11] => 26628577
[12] => 26628578
[13] => 26628579
[14] => 26628580
[15] => 26628581
[16] => 26628582
[17] => 26628583
[18] => 26628584
[19] => 26628585
[20] => 26628586
[21] => 26628587
[22] => 26628938
)
)
- Full Baths: 1
- Land Area (sf): 647,519
- Living (sf): 667
- Year Built: 1975
- Building Name: Kuilima Ests East
- Property Condition: Fair
- Number of Parking Spaces: 1
- View: Garden,Golf Course
- Listing Office: New Star Hawaii Top Realty
- Maintenance Fees: $615
- Land Tenure: FS - Fee Simple
