Listing
Overview
Price: $2,500,000
Area: GOVT/AG
Status: Active
Wall-to-wall ocean views and daily sunsets from your 7.72 acre farm or ranch. Great opportunity to build a farm dwelling and live there. Yes this AG land allows for a Farm Dwelling, in a legacy master development of over 1,400 pristine North Shore acres. Includes 2 lots. A Kuleana lot approx. 1.62 acre (TMK# 1-6-4-001:004) which allows for a farm dwelling (you can live there) and accessory AG structures (greenhouses, warehouse, sheds, equipment storage, processing facilities, and more) and a farm lot approx. 6.1 acre which allow for Accessory Agriculture Structures and no farm dwellings (TMK# 1-6-4-001-014-0004). This will be a part of the up-and-coming Laukiha’a Farms Community, situated in the heart of historic and cultural Haleiwa Town near the North Shore Marketplace. This is the most strategic stop along the Kamehameha Hwy, close to the beautiful beaches, and easy freeway access to town. Enjoy the convenience of shopping, dining, and all the water activities that North Shore has to offer. Prime location to create your own piece of paradise in a farm-to-table-designed development and help feed a growing economy! Listing by: Hawaii Homes International (808) 949-0020
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202127164"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "64-486"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "4-A"
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(36) "http://youtube.com/embed/39NQLoy0VDQ"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2500000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "GOVT/AG"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1141) "Wall-to-wall ocean views and daily sunsets from your 7.72 acre farm or ranch. Great opportunity to build a farm dwelling and live there. Yes this AG land allows for a Farm Dwelling, in a legacy master development of over 1,400 pristine North Shore acres. Includes 2 lots. A Kuleana lot approx. 1.62 acre (TMK# 1-6-4-001:004) which allows for a farm dwelling (you can live there) and accessory AG structures (greenhouses, warehouse, sheds, equipment storage, processing facilities, and more) and a farm lot approx. 6.1 acre which allow for Accessory Agriculture Structures and no farm dwellings (TMK# 1-6-4-001-014-0004). This will be a part of the up-and-coming Laukiha’a Farms Community, situated in the heart of historic and cultural Haleiwa Town near the North Shore Marketplace. This is the most strategic stop along the Kamehameha Hwy, close to the beautiful beaches, and easy freeway access to town. Enjoy the convenience of shopping, dining, and all the water activities that North Shore has to offer. Prime location to create your own piece of paradise in a farm-to-table-designed development and help feed a growing economy!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Hawaii Homes International"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "336632.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(14) "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) "REEW"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bgwvrdr@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 949-0020"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Ralph S Gray"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-01-26T16:57:22.433"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16259289"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2021-11-05T12:41:05.980"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25869255"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "25869255"
[1]=>
string(8) "25869256"
[2]=>
string(8) "25869257"
[3]=>
string(8) "25869258"
[4]=>
string(8) "25869259"
[5]=>
string(8) "25869260"
[6]=>
string(8) "25869261"
[7]=>
string(8) "25869262"
[8]=>
string(8) "25869263"
[9]=>
string(8) "25869264"
[10]=>
string(8) "25869265"
[11]=>
string(8) "25869266"
[12]=>
string(8) "25869267"
[13]=>
string(8) "25869268"
[14]=>
string(8) "25869269"
[15]=>
string(8) "25869270"
[16]=>
string(8) "25869271"
[17]=>
string(8) "25869272"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202127164
)
[StreetNumber] => Array
(
[0] => 64-486
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 4-A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => http://youtube.com/embed/39NQLoy0VDQ
)
[ListPrice] => Array
(
[0] => 2500000.00
)
[CurrentPrice] => Array
(
[0] => 2500000.00
)
[Neighbourhood] => Array
(
[0] => GOVT/AG
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Wall-to-wall ocean views and daily sunsets from your 7.72 acre farm or ranch. Great opportunity to build a farm dwelling and live there. Yes this AG land allows for a Farm Dwelling, in a legacy master development of over 1,400 pristine North Shore acres. Includes 2 lots. A Kuleana lot approx. 1.62 acre (TMK# 1-6-4-001:004) which allows for a farm dwelling (you can live there) and accessory AG structures (greenhouses, warehouse, sheds, equipment storage, processing facilities, and more) and a farm lot approx. 6.1 acre which allow for Accessory Agriculture Structures and no farm dwellings (TMK# 1-6-4-001-014-0004). This will be a part of the up-and-coming Laukiha’a Farms Community, situated in the heart of historic and cultural Haleiwa Town near the North Shore Marketplace. This is the most strategic stop along the Kamehameha Hwy, close to the beautiful beaches, and easy freeway access to town. Enjoy the convenience of shopping, dining, and all the water activities that North Shore has to offer. Prime location to create your own piece of paradise in a farm-to-table-designed development and help feed a growing economy!
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 336632.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => REEW
)
[ListAgentEmail] => Array
(
[0] => bgwvrdr@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 949-0020
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-01-26T16:57:22.433
)
[Matrix_Unique_ID] => Array
(
[0] => 16259289
)
[OriginalEntryTimestamp] => Array
(
[0] => 2021-11-05T12:41:05.980
)
[_thumbnail_id] => Array
(
[0] => 25869255
)
[listing_image] => Array
(
[0] => 25869255
[1] => 25869256
[2] => 25869257
[3] => 25869258
[4] => 25869259
[5] => 25869260
[6] => 25869261
[7] => 25869262
[8] => 25869263
[9] => 25869264
[10] => 25869265
[11] => 25869266
[12] => 25869267
[13] => 25869268
[14] => 25869269
[15] => 25869270
[16] => 25869271
[17] => 25869272
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- View: Mountain,Ocean
- Listing Office: Hawaii Homes International
- Land Tenure: FS - Fee Simple
