47-532 Lulani Street Kaneohe, HI 96744

Take a Virtual Tour

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446