Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
PRIVATE FARMHOUSE ESTATE – A rare opportunity to own a stunning 3 bed / 2.5 bath, two-story 2,519 SF home on a picturesque 7-acre farm in the gated and serene Poamoho Estates on Oahu’s world-famous North Shore. Located at the end of a quiet cul-de-sac and bordered by a lush 100-foot ravine, this peaceful retreat offers both privacy and breathtaking natural beauty. Also included is a fully enclosed 1,250 SF workshop, complete with its own bathroom and office—perfect for use as a home gym, game room, creative studio, or agricultural utility space. The property features over 400 mature fruit trees, including mango, avocado, lychee, longan, citrus, papaya, and breadfruit—offering an abundance of fresh produce and incredible opportunity. From launching a farm-to-table business, CSA program, or local produce brand, the possibilities are truly limitless. Whether you're envisioning a working farm, private retreat, or community-supported agricultural venture, this unique estate blends lifestyle and potential—all just minutes from charming Haleiwa Town, surf breaks, and the heart of the North Shore. Don’t miss this one-of-a-kind opportunity—schedule your private showing today! Listing by: Five Star Realty, Inc. (808) 777-9523
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202510521"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "65-200"
}
["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(54) "https://unbranded.youriguide.com/65_200_poamoho_place/"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4350000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1199) "PRIVATE FARMHOUSE ESTATE – A rare opportunity to own a stunning 3 bed / 2.5 bath, two-story 2,519 SF home on a picturesque 7-acre farm in the gated and serene Poamoho Estates on Oahu’s world-famous North Shore. Located at the end of a quiet cul-de-sac and bordered by a lush 100-foot ravine, this peaceful retreat offers both privacy and breathtaking natural beauty. Also included is a fully enclosed 1,250 SF workshop, complete with its own bathroom and office—perfect for use as a home gym, game room, creative studio, or agricultural utility space. The property features over 400 mature fruit trees, including mango, avocado, lychee, longan, citrus, papaya, and breadfruit—offering an abundance of fresh produce and incredible opportunity. From launching a farm-to-table business, CSA program, or local produce brand, the possibilities are truly limitless. Whether you're envisioning a working farm, private retreat, or community-supported agricultural venture, this unique estate blends lifestyle and potential—all just minutes from charming Haleiwa Town, surf breaks, and the heart of the North Shore. Don’t miss this one-of-a-kind opportunity—schedule your private showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "308012.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(31) "Coastline,Garden,Mountain,Ocean"
}
["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) "FIVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "izzi@FiveStarRealty.org"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 777-9523"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Izzi Chan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18703981"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-14T15:32:19.370"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-04-07"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:32:19.370"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26968282"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26968282"
[1]=>
string(8) "26968283"
[2]=>
string(8) "26968284"
[3]=>
string(8) "26968285"
[4]=>
string(8) "26968286"
[5]=>
string(8) "26968287"
[6]=>
string(8) "26968288"
[7]=>
string(8) "26968289"
[8]=>
string(8) "26968290"
[9]=>
string(8) "26968291"
[10]=>
string(8) "26968292"
[11]=>
string(8) "26968293"
[12]=>
string(8) "26968294"
[13]=>
string(8) "26968295"
[14]=>
string(8) "26968296"
[15]=>
string(8) "26968297"
[16]=>
string(8) "26968298"
[17]=>
string(8) "26968299"
[18]=>
string(8) "26968300"
[19]=>
string(8) "26968301"
[20]=>
string(8) "26968302"
[21]=>
string(8) "26968303"
[22]=>
string(8) "26968304"
[23]=>
string(8) "26968305"
[24]=>
string(8) "26968306"
[25]=>
string(8) "26968307"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202510521
)
[StreetNumber] => Array
(
[0] => 65-200
)
[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://unbranded.youriguide.com/65_200_poamoho_place/
)
[ListPrice] => Array
(
[0] => 4350000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PRIVATE FARMHOUSE ESTATE – A rare opportunity to own a stunning 3 bed / 2.5 bath, two-story 2,519 SF home on a picturesque 7-acre farm in the gated and serene Poamoho Estates on Oahu’s world-famous North Shore. Located at the end of a quiet cul-de-sac and bordered by a lush 100-foot ravine, this peaceful retreat offers both privacy and breathtaking natural beauty. Also included is a fully enclosed 1,250 SF workshop, complete with its own bathroom and office—perfect for use as a home gym, game room, creative studio, or agricultural utility space. The property features over 400 mature fruit trees, including mango, avocado, lychee, longan, citrus, papaya, and breadfruit—offering an abundance of fresh produce and incredible opportunity. From launching a farm-to-table business, CSA program, or local produce brand, the possibilities are truly limitless. Whether you're envisioning a working farm, private retreat, or community-supported agricultural venture, this unique estate blends lifestyle and potential—all just minutes from charming Haleiwa Town, surf breaks, and the heart of the North Shore. Don’t miss this one-of-a-kind opportunity—schedule your private showing today!
)
[ListOfficeName] => Array
(
[0] => Five Star Realty, Inc.
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 308012.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
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => FIVE
)
[ListAgentEmail] => Array
(
[0] => izzi@FiveStarRealty.org
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 777-9523
)
[ListAgentFullName] => Array
(
[0] => Izzi Chan
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18703981
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-14T15:32:19.370
)
[ListingContractDate] => Array
(
[0] => 2025-04-07
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:32:19.370
)
[_thumbnail_id] => Array
(
[0] => 26968282
)
[listing_image] => Array
(
[0] => 26968282
[1] => 26968283
[2] => 26968284
[3] => 26968285
[4] => 26968286
[5] => 26968287
[6] => 26968288
[7] => 26968289
[8] => 26968290
[9] => 26968291
[10] => 26968292
[11] => 26968293
[12] => 26968294
[13] => 26968295
[14] => 26968296
[15] => 26968297
[16] => 26968298
[17] => 26968299
[18] => 26968300
[19] => 26968301
[20] => 26968302
[21] => 26968303
[22] => 26968304
[23] => 26968305
[24] => 26968306
[25] => 26968307
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 14, 2025 - 3:32 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
