Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
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
)
)