1537 St Louis Drive Honolulu, HI 96816

Listing
Overview

Price: $1,549,000
Area: ST. LOUIS
Status: Active

Welcome to your dream home!!! This 3 bed/2 bath single level home in desirable Saint Louis with beautiful ocean and Diamond Head mountain views. This home has been fully renovated. Features an open floor plan, designer kitchen, quartz counter tops, brand new appliances, split AC throughout, all new fixtures. New roof, plumbing and electrical. Also upgraded 200 amp electrical. A covered lanai space perfect for entertaining and relaxing. A large backyard where you could create a beautiful garden. Enjoy the Prime location with easy city access, to restaurants and shopping in trendy Kaimuki and Kapahulu. Close to UH, Waikiki, Kahala and very easy access to H-1 the ultimate in convenience. Listing by: Five Star Realty, Inc. (808) 365-9232

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202424243"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1537"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "St Louis"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["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) "96816"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1549000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1549000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "ST. LOUIS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(695) "Welcome to your dream home!!! This 3 bed/2 bath single level home in desirable Saint Louis with beautiful ocean and Diamond Head mountain views. This home has been fully renovated. Features an open floor plan, designer kitchen, quartz counter tops, brand new appliances, split AC throughout, all new fixtures. New roof, plumbing and electrical. Also upgraded  200 amp electrical. A covered lanai space perfect for entertaining and relaxing.  A large backyard where you could create a beautiful garden. Enjoy the Prime location with easy city access, to restaurants and shopping in trendy Kaimuki and Kapahulu. Close to UH, Waikiki, Kahala and very easy access to H-1 the ultimate in convenience."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6150.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1684"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1948"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(31) "City,Diamond Head,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(8) "Hokulani"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Jarrett"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "FIVE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "joyxieinet@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 365-9232"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Joy L Xie"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-18T20:38:28.893"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18334192"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-20T20:21:40.750"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26741842"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26741842"
    [1]=>
    string(8) "26741843"
    [2]=>
    string(8) "26741844"
    [3]=>
    string(8) "26741845"
    [4]=>
    string(8) "26741846"
    [5]=>
    string(8) "26741847"
    [6]=>
    string(8) "26741848"
    [7]=>
    string(8) "26741849"
    [8]=>
    string(8) "26741850"
    [9]=>
    string(8) "26741851"
    [10]=>
    string(8) "26741852"
    [11]=>
    string(8) "26741853"
    [12]=>
    string(8) "26741854"
    [13]=>
    string(8) "26741855"
    [14]=>
    string(8) "26741856"
    [15]=>
    string(8) "26741857"
    [16]=>
    string(8) "26741858"
    [17]=>
    string(8) "26741859"
    [18]=>
    string(8) "26741860"
    [19]=>
    string(8) "26741861"
    [20]=>
    string(8) "26741862"
    [21]=>
    string(8) "26741863"
    [22]=>
    string(8) "26741864"
    [23]=>
    string(8) "26741865"
    [24]=>
    string(8) "26741866"
    [25]=>
    string(8) "26775079"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202424243
        )

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

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

    [StreetName] => Array
        (
            [0] => St Louis
        )

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => ST. LOUIS
        )

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to your dream home!!! This 3 bed/2 bath single level home in desirable Saint Louis with beautiful ocean and Diamond Head mountain views. This home has been fully renovated. Features an open floor plan, designer kitchen, quartz counter tops, brand new appliances, split AC throughout, all new fixtures. New roof, plumbing and electrical. Also upgraded  200 amp electrical. A covered lanai space perfect for entertaining and relaxing.  A large backyard where you could create a beautiful garden. Enjoy the Prime location with easy city access, to restaurants and shopping in trendy Kaimuki and Kapahulu. Close to UH, Waikiki, Kahala and very easy access to H-1 the ultimate in convenience.
        )

    [ListOfficeName] => Array
        (
            [0] => Five Star Realty, Inc.
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Diamond Head,Ocean,Sunrise
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => joyxieinet@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 365-9232
        )

    [ListAgentFullName] => Array
        (
            [0] => Joy L Xie
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-18T20:38:28.893
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-20T20:21:40.750
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26741842
            [1] => 26741843
            [2] => 26741844
            [3] => 26741845
            [4] => 26741846
            [5] => 26741847
            [6] => 26741848
            [7] => 26741849
            [8] => 26741850
            [9] => 26741851
            [10] => 26741852
            [11] => 26741853
            [12] => 26741854
            [13] => 26741855
            [14] => 26741856
            [15] => 26741857
            [16] => 26741858
            [17] => 26741859
            [18] => 26741860
            [19] => 26741861
            [20] => 26741862
            [21] => 26741863
            [22] => 26741864
            [23] => 26741865
            [24] => 26741866
            [25] => 26775079
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 6,150
  • Living (sf): 1,684
  • Year Built: 1948

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Diamond Head,Ocean,Sunrise
  • Listing Office: Five Star Realty, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Hokulani
  • Middle School: Jarrett
  • High School: Kaimuki

CONTACT US

Marcus Realty

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