Listing
Overview
Price: $1,450,000
Area: WAIALUA
Status: Active Under Contract
Charming and Upgraded Legal Duplex in Waialua! This delightful 4-bedroom, 2-bathroom property (2/1 each side) offers two beautifully refreshed homes on one incredible lot. Featuring 12 PV panels, a Tesla power wall, high speed EV car charging, new flooring throughout, and even a designated spot for jet ski parking! This place is a must see. The spacious yard, surrounded by tropical trees, creates incredible jungle vibes, perfect for outdoor gatherings or a peaceful retreat. For the fruit lovers, the property offers meyer lemon, banana, papaya, sugarcane, and juvenile coconut palm amongst other things. And if you are into plants and lei making then there is pikake, white and sunset plumeria, song of India, read and green ti leaves, lobster claw and big red heliconia, monstera, pohinahina, and many more incredible species. Also, enjoy the convenience of an outdoor shower and two storage sheds. Located just steps from the beach with easy access to the highway, Waialua District park, and Haleiwa town, this property is a dream for both investors and new homeowners. Live in one unit while renting out the other—come explore the endless possibilities this unique home has to offer! Listing by: Real Broker, LLC (855) 450-0442
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420910"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-253"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kiapoko"
}
["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(41) "https://player.vimeo.com/video/1009045076"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "Charming and Upgraded Legal Duplex in Waialua! This delightful 4-bedroom, 2-bathroom property (2/1 each side) offers two beautifully refreshed homes on one incredible lot. Featuring 12 PV panels, a Tesla power wall, high speed EV car charging, new flooring throughout, and even a designated spot for jet ski parking! This place is a must see. The spacious yard, surrounded by tropical trees, creates incredible jungle vibes, perfect for outdoor gatherings or a peaceful retreat. For the fruit lovers, the property offers meyer lemon, banana, papaya, sugarcane, and juvenile coconut palm amongst other things. And if you are into plants and lei making then there is pikake, white and sunset plumeria, song of India, read and green ti leaves, lobster claw and big red heliconia, monstera, pohinahina, and many more incredible species. Also, enjoy the convenience of an outdoor shower and two storage sheds. Located just steps from the beach with easy access to the highway, Waialua District park, and Haleiwa town, this property is a dream for both investors and new homeowners. Live in one unit while renting out the other—come explore the endless possibilities this unique home has to offer!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7830.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1672"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1965"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "Lex@lifeonoahu.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(855) 450-0442"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Lex Ferguson"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-25T20:40:20.423"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18257404"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-11T17:44:32.133"
}
["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) "26699011"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26699011"
[1]=>
string(8) "26699012"
[2]=>
string(8) "26699013"
[3]=>
string(8) "26699014"
[4]=>
string(8) "26699015"
[5]=>
string(8) "26699016"
[6]=>
string(8) "26699017"
[7]=>
string(8) "26699018"
[8]=>
string(8) "26699019"
[9]=>
string(8) "26699020"
[10]=>
string(8) "26699021"
[11]=>
string(8) "26699022"
[12]=>
string(8) "26699023"
[13]=>
string(8) "26699024"
[14]=>
string(8) "26699025"
[15]=>
string(8) "26699026"
[16]=>
string(8) "26699027"
[17]=>
string(8) "26699028"
[18]=>
string(8) "26699029"
[19]=>
string(8) "26699030"
[20]=>
string(8) "26699031"
[21]=>
string(8) "26699032"
[22]=>
string(8) "26699033"
[23]=>
string(8) "26699034"
[24]=>
string(8) "26699035"
[25]=>
string(8) "26699036"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420910
)
[StreetNumber] => Array
(
[0] => 67-253
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kiapoko
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1009045076
)
[ListPrice] => Array
(
[0] => 1450000.00
)
[CurrentPrice] => Array
(
[0] => 1450000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Charming and Upgraded Legal Duplex in Waialua! This delightful 4-bedroom, 2-bathroom property (2/1 each side) offers two beautifully refreshed homes on one incredible lot. Featuring 12 PV panels, a Tesla power wall, high speed EV car charging, new flooring throughout, and even a designated spot for jet ski parking! This place is a must see. The spacious yard, surrounded by tropical trees, creates incredible jungle vibes, perfect for outdoor gatherings or a peaceful retreat. For the fruit lovers, the property offers meyer lemon, banana, papaya, sugarcane, and juvenile coconut palm amongst other things. And if you are into plants and lei making then there is pikake, white and sunset plumeria, song of India, read and green ti leaves, lobster claw and big red heliconia, monstera, pohinahina, and many more incredible species. Also, enjoy the convenience of an outdoor shower and two storage sheds. Located just steps from the beach with easy access to the highway, Waialua District park, and Haleiwa town, this property is a dream for both investors and new homeowners. Live in one unit while renting out the other—come explore the endless possibilities this unique home has to offer!
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7830.00
)
[SqftTotal] => Array
(
[0] => 1672
)
[YearBuilt] => Array
(
[0] => 1965
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => Lex@lifeonoahu.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (855) 450-0442
)
[ListAgentFullName] => Array
(
[0] => Lex Ferguson
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-25T20:40:20.423
)
[Matrix_Unique_ID] => Array
(
[0] => 18257404
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-11T17:44:32.133
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26699011
)
[listing_image] => Array
(
[0] => 26699011
[1] => 26699012
[2] => 26699013
[3] => 26699014
[4] => 26699015
[5] => 26699016
[6] => 26699017
[7] => 26699018
[8] => 26699019
[9] => 26699020
[10] => 26699021
[11] => 26699022
[12] => 26699023
[13] => 26699024
[14] => 26699025
[15] => 26699026
[16] => 26699027
[17] => 26699028
[18] => 26699029
[19] => 26699030
[20] => 26699031
[21] => 26699032
[22] => 26699033
[23] => 26699034
[24] => 26699035
[25] => 26699036
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 7,830
- Living (sf): 1,672
- Year Built: 1965
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Garden
- Listing Office: Real Broker, LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
