Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
67-243 Kaui Street Waialua, HI 96791
Listing Overview
Price: $1,250,000 Area: WAIALUA Status: Active
NEW PRICE! Welcome to 67-243 Kaui Street in Waialua, HI! This charming 3-bedroom, 1.5-bath home offers 1,220 square feet of cozy country living. Sitting on a 5,217-square-foot lot, this property is perfect for those who appreciate the simple joys of island life. Step inside to discover a welcoming layout that includes a fully enclosed lanai, providing additional space for relaxation or entertainment, offering a world of possibilities currently set as a 4th bedroom. Outside, you'll find a private outdoor space ideal for gardening, barbecues, or simply soaking up the sun. This home has a variety of fruit trees, including tangerine, key lime, Mexican guava, papaya, coconuts, pomegranate, avocado, and Banana trees. Located just minutes from Historic Haleiwa Town, you’ll be close to parks and beaches, making it easy to enjoy the area's natural beauty. Whether you want to unwind or explore, this home offers the perfect blend of comfort and convenience. Don’t miss out on this slice of paradise—schedule a showing today! Listing by: Compass (808) 825-4277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421059"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-243"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Kaui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1250000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1033) "NEW PRICE! Welcome to 67-243 Kaui Street in Waialua, HI! This charming 3-bedroom, 1.5-bath home offers 1,220 square feet of cozy country living. Sitting on a 5,217-square-foot lot, this property is perfect for those who appreciate the simple joys of island life. Step inside to discover a welcoming layout that includes a fully enclosed lanai, providing additional space for relaxation or entertainment, offering a world of possibilities currently set as a 4th bedroom. Outside, you'll find a private outdoor space ideal for gardening, barbecues, or simply soaking up the sun. This home has a variety of fruit trees, including tangerine, key lime, Mexican guava, papaya, coconuts, pomegranate, avocado, and Banana trees. Located just minutes from Historic Haleiwa Town, you’ll be close to parks and beaches, making it easy to enjoy the area's natural beauty. Whether you want to unwind or explore, this home offers the perfect blend of comfort and convenience. Don’t miss out on this slice of paradise—schedule a showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5217.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1280"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1976"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "giovanni.rendon@compass.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(21) "Giovanni Rendon Lopez"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-17T17:00:01.000"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18261682"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-18T12:56:41.957"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26736741"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "26736741"
[1]=>
string(8) "26736742"
[2]=>
string(8) "26736743"
[3]=>
string(8) "26736744"
[4]=>
string(8) "26736745"
[5]=>
string(8) "26736746"
[6]=>
string(8) "26736747"
[7]=>
string(8) "26736748"
[8]=>
string(8) "26736749"
[9]=>
string(8) "26736750"
[10]=>
string(8) "26736751"
[11]=>
string(8) "26736752"
[12]=>
string(8) "26736753"
[13]=>
string(8) "26736754"
[14]=>
string(8) "26736755"
[15]=>
string(8) "26736756"
[16]=>
string(8) "26736757"
[17]=>
string(8) "26736758"
[18]=>
string(8) "26736759"
[19]=>
string(8) "26736760"
[20]=>
string(8) "26736761"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421059
)
[StreetNumber] => Array
(
[0] => 67-243
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaui
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1250000.00
)
[CurrentPrice] => Array
(
[0] => 1250000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => NEW PRICE! Welcome to 67-243 Kaui Street in Waialua, HI! This charming 3-bedroom, 1.5-bath home offers 1,220 square feet of cozy country living. Sitting on a 5,217-square-foot lot, this property is perfect for those who appreciate the simple joys of island life. Step inside to discover a welcoming layout that includes a fully enclosed lanai, providing additional space for relaxation or entertainment, offering a world of possibilities currently set as a 4th bedroom. Outside, you'll find a private outdoor space ideal for gardening, barbecues, or simply soaking up the sun. This home has a variety of fruit trees, including tangerine, key lime, Mexican guava, papaya, coconuts, pomegranate, avocado, and Banana trees. Located just minutes from Historic Haleiwa Town, you’ll be close to parks and beaches, making it easy to enjoy the area's natural beauty. Whether you want to unwind or explore, this home offers the perfect blend of comfort and convenience. Don’t miss out on this slice of paradise—schedule a showing today!
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5217.00
)
[SqftTotal] => Array
(
[0] => 1280
)
[YearBuilt] => Array
(
[0] => 1976
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => giovanni.rendon@compass.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Giovanni Rendon Lopez
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-17T17:00:01.000
)
[Matrix_Unique_ID] => Array
(
[0] => 18261682
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-18T12:56:41.957
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26736741
)
[listing_image] => Array
(
[0] => 26736741
[1] => 26736742
[2] => 26736743
[3] => 26736744
[4] => 26736745
[5] => 26736746
[6] => 26736747
[7] => 26736748
[8] => 26736749
[9] => 26736750
[10] => 26736751
[11] => 26736752
[12] => 26736753
[13] => 26736754
[14] => 26736755
[15] => 26736756
[16] => 26736757
[17] => 26736758
[18] => 26736759
[19] => 26736760
[20] => 26736761
)
)