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(45) {
["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"
}
}
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
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 5,549
- 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
