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