Listing
Overview
Price: $1,880,000
Area: ST. LOUIS
Status: Active
Located at the top of St Louis Hts, this 3 bedroom/2.5 bath single family home has spectacular views of Diamond Head, Pacific ocean, Waikiki, and the Honolulu Skyline! Enjoy the views from the 280 sq ft covered lanai! Built to last with redwood, the home features hardwood floors, ceramic tiles, and fresh interior and exterior paint. Natural light fills the home from skylights and sliding vinyl windows from all around the home. Spend quality time in the spacious living room and dining room with family and friends. The lush garden is a fruit lovers delight with peach trees, red dragon fruit, rosemary, apple banana trees, lime trees and much more. The home is located near Wa'ahila Ridge Trail, University of Hawaii at Manoa, Chaminade University, Queens Medical Center, Waikiki and Downtown Honolulu. Listing by: BHGRE Advantage Realty (808) 425-3737
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202319036"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1952"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Bertram"
}
["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) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(56) "https://listings.hetproductions.com/v2/DZQJVGN/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1880000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1880000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "ST. LOUIS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(806) "Located at the top of St Louis Hts, this 3 bedroom/2.5 bath single family home has spectacular views of Diamond Head, Pacific ocean, Waikiki, and the Honolulu Skyline! Enjoy the views from the 280 sq ft covered lanai! Built to last with redwood, the home features hardwood floors, ceramic tiles, and fresh interior and exterior paint. Natural light fills the home from skylights and sliding vinyl windows from all around the home. Spend quality time in the spacious living room and dining room with family and friends. The lush garden is a fruit lovers delight with peach trees, red dragon fruit, rosemary, apple banana trees, lime trees and much more. The home is located near Wa'ahila Ridge Trail, University of Hawaii at Manoa, Chaminade University, Queens Medical Center, Waikiki and Downtown Honolulu."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5549.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2469"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1955"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(30) "City,Diamond Head,Ocean,Sunset"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "DanielB@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 425-3737"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Daniel Bae Lee"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-08-17T08:42:35.500"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17495382"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-08-17T08:42:35.500"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25921059"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25921059"
[1]=>
string(8) "25921060"
[2]=>
string(8) "25921061"
[3]=>
string(8) "25921062"
[4]=>
string(8) "25921063"
[5]=>
string(8) "25921064"
[6]=>
string(8) "25921065"
[7]=>
string(8) "25921066"
[8]=>
string(8) "25921067"
[9]=>
string(8) "25921068"
[10]=>
string(8) "25921069"
[11]=>
string(8) "25921070"
[12]=>
string(8) "25921071"
[13]=>
string(8) "25921072"
[14]=>
string(8) "25921073"
[15]=>
string(8) "25921074"
[16]=>
string(8) "25921075"
[17]=>
string(8) "25921076"
[18]=>
string(8) "25921077"
[19]=>
string(8) "25921078"
[20]=>
string(8) "25921079"
[21]=>
string(8) "25921080"
[22]=>
string(8) "25921081"
[23]=>
string(8) "25921082"
[24]=>
string(8) "25921083"
[25]=>
string(8) "25921084"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:42:35.500"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202319036
)
[StreetNumber] => Array
(
[0] => 1952
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Bertram
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/v2/DZQJVGN/unbranded
)
[ListPrice] => Array
(
[0] => 1880000.00
)
[CurrentPrice] => Array
(
[0] => 1880000.00
)
[Neighbourhood] => Array
(
[0] => ST. LOUIS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Located at the top of St Louis Hts, this 3 bedroom/2.5 bath single family home has spectacular views of Diamond Head, Pacific ocean, Waikiki, and the Honolulu Skyline! Enjoy the views from the 280 sq ft covered lanai! Built to last with redwood, the home features hardwood floors, ceramic tiles, and fresh interior and exterior paint. Natural light fills the home from skylights and sliding vinyl windows from all around the home. Spend quality time in the spacious living room and dining room with family and friends. The lush garden is a fruit lovers delight with peach trees, red dragon fruit, rosemary, apple banana trees, lime trees and much more. The home is located near Wa'ahila Ridge Trail, University of Hawaii at Manoa, Chaminade University, Queens Medical Center, Waikiki and Downtown Honolulu.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5549.00
)
[SqftTotal] => Array
(
[0] => 2469
)
[YearBuilt] => Array
(
[0] => 1955
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Diamond Head,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hokulani
)
[MiddleOrJuniorSchool] => Array
(
[0] => Jarrett
)
[HighSchool] => Array
(
[0] => Kaimuki
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => DanielB@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 425-3737
)
[ListAgentFullName] => Array
(
[0] => Daniel Bae Lee
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-08-17T08:42:35.500
)
[Matrix_Unique_ID] => Array
(
[0] => 17495382
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-08-17T08:42:35.500
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25921059
)
[listing_image] => Array
(
[0] => 25921059
[1] => 25921060
[2] => 25921061
[3] => 25921062
[4] => 25921063
[5] => 25921064
[6] => 25921065
[7] => 25921066
[8] => 25921067
[9] => 25921068
[10] => 25921069
[11] => 25921070
[12] => 25921071
[13] => 25921072
[14] => 25921073
[15] => 25921074
[16] => 25921075
[17] => 25921076
[18] => 25921077
[19] => 25921078
[20] => 25921079
[21] => 25921080
[22] => 25921081
[23] => 25921082
[24] => 25921083
[25] => 25921084
)
[MatrixModifiedTime] => Array
(
[0] => 08:42:35.500
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 5,549 sf
- Living (sf): 2,469
- Year Built: 1955
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: City,Diamond Head,Ocean,Sunset
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Hokulani
- Middle School: Jarrett
- High School: Kaimuki
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 17, 2023 - 8:42 AM
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.
