Listing
Overview
Price: $3,995,000
Area: WAIALUA
Status: Active Under Contract
AVAILABLE NOW! Priced $360k under appraised value (in supplements). Exceptional chance to acquire a 5-acre haven in the seldom-available ,gated community of Poamoho Estates in Waialua. With just a short drive from
Haleiwa Town and Oahu's finest surf spots and beaches and direct route to Honolulu that bypasses the notorious
North Shore traffic. Poamoho Estates has coastline views against the backdrop of beautiful mountains. Every
detail reflects a meticulous blend of elegance and comfort, highlighted by high ceilings that create an airy and
seamless connection with the natural environment. Step onto the vast covered lanai to be captivated by
panoramic views, turning into a private retreat surrounded by lush palms and diverse fruit trees, with fencing and
gates for peace of mind. The well-maintained pasture and barn offer limitless possibilities for equestrian pursuits,
complemented by a greenhouse and processing center catering to agricultural activities. Whether your desire is a
tranquil haven for relaxation or an inspiring oasis, this property has it all. Certified Pre-Owned. Buyer will earn
instant equity. Listing by: Keller Williams Honolulu (808) 227-2703
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414423"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "65-340"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Poamoho"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(51) "https://my.matterport.com/show/?m=kaHp4NU6yro&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1134) "AVAILABLE NOW! Priced $360k under appraised value (in supplements). Exceptional chance to acquire a 5-acre haven in the seldom-available ,gated community of Poamoho Estates in Waialua. With just a short drive from
Haleiwa Town and Oahu's finest surf spots and beaches and direct route to Honolulu that bypasses the notorious
North Shore traffic. Poamoho Estates has coastline views against the backdrop of beautiful mountains. Every
detail reflects a meticulous blend of elegance and comfort, highlighted by high ceilings that create an airy and
seamless connection with the natural environment. Step onto the vast covered lanai to be captivated by
panoramic views, turning into a private retreat surrounded by lush palms and diverse fruit trees, with fencing and
gates for peace of mind. The well-maintained pasture and barn offer limitless possibilities for equestrian pursuits,
complemented by a greenhouse and processing center catering to agricultural activities. Whether your desire is a
tranquil haven for relaxation or an inspiring oasis, this property has it all. Certified Pre-Owned. Buyer will earn
instant equity."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "217886.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "380.00"
}
["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) "KWPP01"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "adrienne@teamlally.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 227-2703"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Adrienne W Lally"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-07-30T11:55:12.483"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18076487"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-17T13:28:45.810"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26588548"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26588548"
[1]=>
string(8) "26588549"
[2]=>
string(8) "26588550"
[3]=>
string(8) "26588551"
[4]=>
string(8) "26588552"
[5]=>
string(8) "26588553"
[6]=>
string(8) "26588554"
[7]=>
string(8) "26588555"
[8]=>
string(8) "26588556"
[9]=>
string(8) "26588557"
[10]=>
string(8) "26588558"
[11]=>
string(8) "26588559"
[12]=>
string(8) "26588560"
[13]=>
string(8) "26588561"
[14]=>
string(8) "26588562"
[15]=>
string(8) "26588563"
[16]=>
string(8) "26588564"
[17]=>
string(8) "26588565"
[18]=>
string(8) "26588566"
[19]=>
string(8) "26588567"
[20]=>
string(8) "26588568"
[21]=>
string(8) "26588569"
[22]=>
string(8) "26588570"
[23]=>
string(8) "26588571"
[24]=>
string(8) "26588572"
[25]=>
string(8) "26588573"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414423
)
[StreetNumber] => Array
(
[0] => 65-340
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Poamoho
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=kaHp4NU6yro&mls=1
)
[ListPrice] => Array
(
[0] => 3995000.00
)
[CurrentPrice] => Array
(
[0] => 3995000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => AVAILABLE NOW! Priced $360k under appraised value (in supplements). Exceptional chance to acquire a 5-acre haven in the seldom-available ,gated community of Poamoho Estates in Waialua. With just a short drive from
Haleiwa Town and Oahu's finest surf spots and beaches and direct route to Honolulu that bypasses the notorious
North Shore traffic. Poamoho Estates has coastline views against the backdrop of beautiful mountains. Every
detail reflects a meticulous blend of elegance and comfort, highlighted by high ceilings that create an airy and
seamless connection with the natural environment. Step onto the vast covered lanai to be captivated by
panoramic views, turning into a private retreat surrounded by lush palms and diverse fruit trees, with fencing and
gates for peace of mind. The well-maintained pasture and barn offer limitless possibilities for equestrian pursuits,
complemented by a greenhouse and processing center catering to agricultural activities. Whether your desire is a
tranquil haven for relaxation or an inspiring oasis, this property has it all. Certified Pre-Owned. Buyer will earn
instant equity.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 217886.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 380.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP01
)
[ListAgentEmail] => Array
(
[0] => adrienne@teamlally.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 227-2703
)
[ListAgentFullName] => Array
(
[0] => Adrienne W Lally
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-07-30T11:55:12.483
)
[Matrix_Unique_ID] => Array
(
[0] => 18076487
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-17T13:28:45.810
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26588548
)
[listing_image] => Array
(
[0] => 26588548
[1] => 26588549
[2] => 26588550
[3] => 26588551
[4] => 26588552
[5] => 26588553
[6] => 26588554
[7] => 26588555
[8] => 26588556
[9] => 26588557
[10] => 26588558
[11] => 26588559
[12] => 26588560
[13] => 26588561
[14] => 26588562
[15] => 26588563
[16] => 26588564
[17] => 26588565
[18] => 26588566
[19] => 26588567
[20] => 26588568
[21] => 26588569
[22] => 26588570
[23] => 26588571
[24] => 26588572
[25] => 26588573
)
)
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Keller Williams Honolulu
- Maintenance Fees: $380
- Land Tenure: FS - Fee Simple
