Listing
Overview
Price: $650,000
Area: LULANI OCEAN
Status: Active
PANORAMIC KO'OLAU MOUNTAIN VIEWS!!! Build your majestic dream home up high on this large 10,914sf corner lot in the beautiful Lulani Ocean neighborhood! Previous 2-story home was demolished with concrete footings remaining as it may be possible to reuse. Many of the tall trees and foliage have also been cut and trimmed in readying the property for a new build. The location feels like country living yet it is a short drive from Kaneohe Town and close to freeway access. This special property with a multitude of possibilities awaits your vision and imagination! Please DO NOT ENTER the property without making an appointment and signing a Liability Waiver. Listing by: Query Properties LLC (808) 551-2617
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202400490"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-532"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Lulani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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(54) "https://shoots.styronphoto.com/sites/dqgmwlo/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "650000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "698000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "LULANI OCEAN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(662) "PANORAMIC KO'OLAU MOUNTAIN VIEWS!!! Build your majestic dream home up high on this large 10,914sf corner lot in the beautiful Lulani Ocean neighborhood! Previous 2-story home was demolished with concrete footings remaining as it may be possible to reuse. Many of the tall trees and foliage have also been cut and trimmed in readying the property for a new build. The location feels like country living yet it is a short drive from Kaneohe Town and close to freeway access. This special property with a multitude of possibilities awaits your vision and imagination! Please DO NOT ENTER the property without making an appointment and signing a Liability Waiver."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Query Properties LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10914.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(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Kahaluu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "QUER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "colleen@queryproperties.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 551-2617"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Colleen Query"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-11T19:03:39.983"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17763880"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-01-12T16:15:06.723"
}
["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) "26065639"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26065639"
[1]=>
string(8) "26065640"
[2]=>
string(8) "26065641"
[3]=>
string(8) "26065642"
[4]=>
string(8) "26065643"
[5]=>
string(8) "26065644"
[6]=>
string(8) "26065645"
[7]=>
string(8) "26065646"
[8]=>
string(8) "26065647"
[9]=>
string(8) "26065648"
[10]=>
string(8) "26065649"
[11]=>
string(8) "26065650"
[12]=>
string(8) "26065651"
[13]=>
string(8) "26065652"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "19:03:39.983"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-01-12"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202400490
)
[StreetNumber] => Array
(
[0] => 47-532
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Lulani
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/dqgmwlo/unbranded
)
[ListPrice] => Array
(
[0] => 650000.00
)
[CurrentPrice] => Array
(
[0] => 698000.00
)
[Neighbourhood] => Array
(
[0] => LULANI OCEAN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PANORAMIC KO'OLAU MOUNTAIN VIEWS!!! Build your majestic dream home up high on this large 10,914sf corner lot in the beautiful Lulani Ocean neighborhood! Previous 2-story home was demolished with concrete footings remaining as it may be possible to reuse. Many of the tall trees and foliage have also been cut and trimmed in readying the property for a new build. The location feels like country living yet it is a short drive from Kaneohe Town and close to freeway access. This special property with a multitude of possibilities awaits your vision and imagination! Please DO NOT ENTER the property without making an appointment and signing a Liability Waiver.
)
[ListOfficeName] => Array
(
[0] => Query Properties LLC
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 10914.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahaluu
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => QUER
)
[ListAgentEmail] => Array
(
[0] => colleen@queryproperties.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 551-2617
)
[ListAgentFullName] => Array
(
[0] => Colleen Query
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-11T19:03:39.983
)
[Matrix_Unique_ID] => Array
(
[0] => 17763880
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-01-12T16:15:06.723
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26065639
)
[listing_image] => Array
(
[0] => 26065639
[1] => 26065640
[2] => 26065641
[3] => 26065642
[4] => 26065643
[5] => 26065644
[6] => 26065645
[7] => 26065646
[8] => 26065647
[9] => 26065648
[10] => 26065649
[11] => 26065650
[12] => 26065651
[13] => 26065652
)
[MatrixModifiedTime] => Array
(
[0] => 19:03:39.983
)
[ListingContractDate] => Array
(
[0] => 2024-01-12
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
)
- Land Area (sf): 10,914 sf
- View: Mountain
- Listing Office: Query Properties LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Kahaluu
- Middle School: King
- High School: Castle
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on January 11, 2025 - 7:03 PM
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.
