Previous Next

1546/1548 Lehua Street Honolulu, HI 96819

Listing
Overview

Price: $1,150,000
Area: KALIHI-UPPER
Status: Active

array(46) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202418240"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(9) "1546/1548"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Lehua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96819"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1150000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "KALIHI-UPPER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(864) "Opportunity awaits with these TWO contiguous TMKs (13,178 sqft) – with an additional 3,000 sqft recorded easement – totaling 16,178 sqft Lot - offering you the perfect canvas in an up and coming neighborhood to build your dream home. Located at the end of a serene and peaceful cul-de-sac, this R-3.5 zoned property features ocean and mountain views and is just minutes from shopping, town, and the beach. New build renderings have been prepared and are available for a 3-bedroom, 3-bath residence with a bonus living room and an Ohana unit above the garage. Contact agent for custom building details. The property is sold as-is, with the buyer responsible for all aspects of construction, including permits, contractors, materials, and maintenance. Listing is for TWO TMKs:1-1-3-036-063 and 1-1-3-036-064. Lot lines are estimated and for visual purposes only."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "RE/MAX ALOHA HOMES"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "13178.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2300"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2024"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(26) "City,Mountain,Ocean,Sunset"
  }
  ["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) "RMXA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "stephanie@hawaiidreamhomes.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 773-9390"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Stephanie Rae Band"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-31T14:25:42.950"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18201369"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26662585"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26662585"
    [1]=>
    string(8) "26662586"
    [2]=>
    string(8) "26662587"
    [3]=>
    string(8) "26662588"
    [4]=>
    string(8) "26662589"
    [5]=>
    string(8) "26662590"
    [6]=>
    string(8) "26662591"
    [7]=>
    string(8) "26662592"
    [8]=>
    string(8) "26662593"
    [9]=>
    string(8) "26662594"
    [10]=>
    string(8) "26662595"
    [11]=>
    string(8) "26662596"
    [12]=>
    string(8) "26662597"
    [13]=>
    string(8) "26662598"
    [14]=>
    string(8) "26662599"
    [15]=>
    string(8) "26662600"
    [16]=>
    string(8) "26662601"
    [17]=>
    string(8) "26662602"
    [18]=>
    string(8) "26662603"
    [19]=>
    string(8) "26662604"
    [20]=>
    string(8) "26662657"
    [21]=>
    string(8) "26662658"
    [22]=>
    string(8) "26662659"
    [23]=>
    string(8) "26662660"
    [24]=>
    string(8) "26662661"
    [25]=>
    string(8) "26662662"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-08-17"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202418240
        )

    [StreetNumber] => Array
        (
            [0] => 1546/1548
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => KALIHI-UPPER
        )

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

    [PublicRemarks] => Array
        (
            [0] => Opportunity awaits with these TWO contiguous TMKs (13,178 sqft) – with an additional 3,000 sqft recorded easement – totaling 16,178 sqft Lot - offering you the perfect canvas in an up and coming neighborhood to build your dream home. Located at the end of a serene and peaceful cul-de-sac, this R-3.5 zoned property features ocean and mountain views and is just minutes from shopping, town, and the beach. New build renderings have been prepared and are available for a 3-bedroom, 3-bath residence with a bonus living room and an Ohana unit above the garage. Contact agent for custom building details. The property is sold as-is, with the buyer responsible for all aspects of construction, including permits, contractors, materials, and maintenance. Listing is for TWO TMKs:1-1-3-036-063 and 1-1-3-036-064. Lot lines are estimated and for visual purposes only.
        )

    [ListOfficeName] => Array
        (
            [0] => RE/MAX ALOHA HOMES
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Mountain,Ocean,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => stephanie@hawaiidreamhomes.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 773-9390
        )

    [ListAgentFullName] => Array
        (
            [0] => Stephanie Rae Band
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-31T14:25:42.950
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26662585
            [1] => 26662586
            [2] => 26662587
            [3] => 26662588
            [4] => 26662589
            [5] => 26662590
            [6] => 26662591
            [7] => 26662592
            [8] => 26662593
            [9] => 26662594
            [10] => 26662595
            [11] => 26662596
            [12] => 26662597
            [13] => 26662598
            [14] => 26662599
            [15] => 26662600
            [16] => 26662601
            [17] => 26662602
            [18] => 26662603
            [19] => 26662604
            [20] => 26662657
            [21] => 26662658
            [22] => 26662659
            [23] => 26662660
            [24] => 26662661
            [25] => 26662662
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-08-17
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 3
• Land Area (sf): 13,178 sf
• Living (sf): 2,300
• Year Built: 2024

KEY FEATURES

• Property Condition: Tear Down
• Number of Parking Spaces: 2
• View: City,Mountain,Ocean,Sunset
• Listing Office: RE/MAX ALOHA 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 October 31, 2024 - 2:25 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.