Previous Next

33 Lakeview Circle Wahiawa, HI 96786

Listing
Overview

Price: $679,000
Area: WILIKINA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202501099"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(2) "33"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lakeview"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Circle"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Wahiawa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96786"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "679000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "WILIKINA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(374) "One of three available continguous lots  All three available lots (33, 41 and 61 Lakeview Circle) are zoned A-2 (apartment medium density).  Minutes from Schofield Barracks and Wahiawa Town with restaurants, shops and medical facilities.
Priced WAY below current assessment. 

Buyer to perform their own due diligence regarding the development potential of this property."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Aloha Island Homes"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8850.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(4) "None"
  }
  ["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) "JONI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "jonihawaii@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-8035"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Joni Ann Shiraishi"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18469479"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-02T14:55:47.590"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-01-01"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "14:55:47.590"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26824222"
  }
  ["listing_image"]=>
  array(5) {
    [0]=>
    string(8) "26824222"
    [1]=>
    string(8) "26824223"
    [2]=>
    string(8) "26824224"
    [3]=>
    string(8) "26824225"
    [4]=>
    string(8) "26824226"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202501099
        )

    [StreetNumber] => Array
        (
            [0] => 33
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

    [StreetName] => Array
        (
            [0] => Lakeview
        )

    [StreetSuffix] => Array
        (
            [0] => Circle
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Wahiawa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96786
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 679000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WILIKINA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => One of three available continguous lots  All three available lots (33, 41 and 61 Lakeview Circle) are zoned A-2 (apartment medium density).  Minutes from Schofield Barracks and Wahiawa Town with restaurants, shops and medical facilities.
Priced WAY below current assessment. 

Buyer to perform their own due diligence regarding the development potential of this property.
        )

    [ListOfficeName] => Array
        (
            [0] => Aloha Island Homes
        )

    [BedsTotal] => Array
        (
            [0] => 
        )

    [BathsFull] => Array
        (
            [0] => 
        )

    [BathsHalf] => Array
        (
            [0] => 
        )

    [LotSizeArea] => Array
        (
            [0] => 8850.00
        )

    [SqftTotal] => Array
        (
            [0] => 
        )

    [YearBuilt] => Array
        (
            [0] => 
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => 
        )

    [ParkingTotal] => Array
        (
            [0] => 
        )

    [StoriesType] => Array
        (
            [0] => 
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => JONI
        )

    [ListAgentEmail] => Array
        (
            [0] => jonihawaii@hotmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-8035
        )

    [ListAgentFullName] => Array
        (
            [0] => Joni Ann Shiraishi
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18469479
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-02T14:55:47.590
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-01-01
        )

    [MLSAreaMajor] => Array
        (
            [0] => Central
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 14:55:47.590
        )

    [_thumbnail_id] => Array
        (
            [0] => 26824222
        )

    [listing_image] => Array
        (
            [0] => 26824222
            [1] => 26824223
            [2] => 26824224
            [3] => 26824225
            [4] => 26824226
        )

)

PROPERTY INFO

• Land Area (sf): 8,850 sf

KEY FEATURES

• View: None
• Listing Office: Aloha Island Homes

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on January 2, 2025 - 2:55 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.