47-688 Lamaula Road Kaneohe, HI 96744
Listing
Overview
Price: $1,750,000
Area: KAALAEA
Status: Active
One Acre of cleared beautiful lot with Ocean Views. All gated, private. Build your dream home (this home is major repair with termite damage , can not walk inside part of the home sold as-is). Sustainable lot with many fruit trees -Avacado, dragon Fruit, limes, bananas, Mountain Apple,Lilikoi,Sour Sap and More!!!!No sign on Property. AG Land only 1 Home plus sheds. Just passt Ahuimanu .
Close to Freeways , Schools and Shopping. Locked Gate with long Driveway for many cars and a Boat!!! Listing by: Help-U-Sell Honolulu Prop. (808) 228-0661
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417107"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-688"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Lamaula"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAALAEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(491) "One Acre of cleared beautiful lot with Ocean Views. All gated, private. Build your dream home (this home is major repair with termite damage , can not walk inside part of the home sold as-is). Sustainable lot with many fruit trees -Avacado, dragon Fruit, limes, bananas, Mountain Apple,Lilikoi,Sour Sap and More!!!!No sign on Property. AG Land only 1 Home plus sheds. Just passt Ahuimanu .
Close to Freeways , Schools and Shopping. Locked Gate with long Driveway for many cars and a Boat!!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Help-U-Sell Honolulu Prop."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "43996.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1984"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1971"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(21) "Garden,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(8) "Waiahole"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HUSH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "debbyoung@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-0661"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Debbie L Young"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-26T09:39:34.190"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18157815"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-30T21:02:47.997"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26642440"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26642440"
[1]=>
string(8) "26642441"
[2]=>
string(8) "26642442"
[3]=>
string(8) "26642443"
[4]=>
string(8) "26642444"
[5]=>
string(8) "26642445"
[6]=>
string(8) "26642446"
[7]=>
string(8) "26642447"
[8]=>
string(8) "26642448"
[9]=>
string(8) "26642449"
[10]=>
string(8) "26642450"
[11]=>
string(8) "26642451"
[12]=>
string(8) "26642452"
[13]=>
string(8) "26642453"
[14]=>
string(8) "26642454"
[15]=>
string(8) "26642455"
[16]=>
string(8) "26642456"
[17]=>
string(8) "26642457"
[18]=>
string(8) "26642458"
[19]=>
string(8) "26642459"
[20]=>
string(8) "26642460"
[21]=>
string(8) "26642461"
[22]=>
string(8) "26648056"
[23]=>
string(8) "26656989"
[24]=>
string(8) "26656990"
[25]=>
string(8) "26656991"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417107
)
[StreetNumber] => Array
(
[0] => 47-688
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Lamaula
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1750000.00
)
[CurrentPrice] => Array
(
[0] => 1750000.00
)
[Neighbourhood] => Array
(
[0] => KAALAEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => One Acre of cleared beautiful lot with Ocean Views. All gated, private. Build your dream home (this home is major repair with termite damage , can not walk inside part of the home sold as-is). Sustainable lot with many fruit trees -Avacado, dragon Fruit, limes, bananas, Mountain Apple,Lilikoi,Sour Sap and More!!!!No sign on Property. AG Land only 1 Home plus sheds. Just passt Ahuimanu .
Close to Freeways , Schools and Shopping. Locked Gate with long Driveway for many cars and a Boat!!!
)
[ListOfficeName] => Array
(
[0] => Help-U-Sell Honolulu Prop.
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 43996.00
)
[SqftTotal] => Array
(
[0] => 1984
)
[YearBuilt] => Array
(
[0] => 1971
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waiahole
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => HUSH
)
[ListAgentEmail] => Array
(
[0] => debbyoung@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-0661
)
[ListAgentFullName] => Array
(
[0] => Debbie L Young
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-26T09:39:34.190
)
[Matrix_Unique_ID] => Array
(
[0] => 18157815
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-30T21:02:47.997
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26642440
)
[listing_image] => Array
(
[0] => 26642440
[1] => 26642441
[2] => 26642442
[3] => 26642443
[4] => 26642444
[5] => 26642445
[6] => 26642446
[7] => 26642447
[8] => 26642448
[9] => 26642449
[10] => 26642450
[11] => 26642451
[12] => 26642452
[13] => 26642453
[14] => 26642454
[15] => 26642455
[16] => 26642456
[17] => 26642457
[18] => 26642458
[19] => 26642459
[20] => 26642460
[21] => 26642461
[22] => 26648056
[23] => 26656989
[24] => 26656990
[25] => 26656991
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 43,996 sf
- Living (sf): 1,984
- Year Built: 1971
- Property Condition: Average
- Number of Parking Spaces: 6
- View: Garden,Mountain,Ocean
- Listing Office: Help-U-Sell Honolulu Prop.
- Land Tenure: FS - Fee Simple
- Elementary School: Waiahole
- Middle School: King
- High School: Castle
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 26, 2024 - 9:39 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
