Listing
Overview
Price: $1,795,000
Area: ST. LOUIS
Status: Active
Sweeping Diamond Head & Ocean views! This 4 bedroom/4 bathroom home in St. Louis Heights offers incredible flexibility with endless options and excellent investment potential! Enjoy as a primary residence OR take advantage of the possibility of three separate rental units: a 1 bedroom/1 bathroom unit on the bottom floor, an expansive 2 bedroom/2 bathroom unit on the middle level, and a Studio/1 bathroom unit on the top level. Purchase the property and rent all three units individually; live in one unit and rent the other two; or reconnect the three units to create one large single-family residence again! The home has both interior and exterior stairs to travel between floors. A carport at street level fits two vehicles and a tropical backyard with an expansive flat grassy lawn and mature trees bordering the property. The opportunities are endless AND the views are stunning! Layout and square footage may not match property tax records. Portions of this property are tenant-occupied, please do not disturb the tenants. Listing by: Hawaii Life (808) 221-8889
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407864"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1649"
}
["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(40) "https://player.vimeo.com/video/942941702"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1795000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1795000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "ST. LOUIS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1030) "Sweeping Diamond Head & Ocean views! This 4 bedroom/4 bathroom home in St. Louis Heights offers incredible flexibility with endless options and excellent investment potential! Enjoy as a primary residence OR take advantage of the possibility of three separate rental units: a 1 bedroom/1 bathroom unit on the bottom floor, an expansive 2 bedroom/2 bathroom unit on the middle level, and a Studio/1 bathroom unit on the top level. Purchase the property and rent all three units individually; live in one unit and rent the other two; or reconnect the three units to create one large single-family residence again! The home has both interior and exterior stairs to travel between floors. A carport at street level fits two vehicles and a tropical backyard with an expansive flat grassy lawn and mature trees bordering the property. The opportunities are endless AND the views are stunning! Layout and square footage may not match property tax records. Portions of this property are tenant-occupied, please do not disturb the tenants."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6040.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3168"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1942"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["View"]=>
array(1) {
[0]=>
string(39) "City,Diamond Head,Garden,Mountain,Ocean"
}
["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) "HLRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "noelshaw@hawaiilife.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 221-8889"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Noel Pietsch Shaw"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-15T11:00:01.297"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17928652"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-04T16:42:53.840"
}
["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) "26191328"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26191328"
[1]=>
string(8) "26191329"
[2]=>
string(8) "26191330"
[3]=>
string(8) "26191331"
[4]=>
string(8) "26191332"
[5]=>
string(8) "26191333"
[6]=>
string(8) "26191334"
[7]=>
string(8) "26191335"
[8]=>
string(8) "26191336"
[9]=>
string(8) "26191337"
[10]=>
string(8) "26191338"
[11]=>
string(8) "26191928"
[12]=>
string(8) "26191929"
[13]=>
string(8) "26191930"
[14]=>
string(8) "26191931"
[15]=>
string(8) "26191932"
[16]=>
string(8) "26191933"
[17]=>
string(8) "26191934"
[18]=>
string(8) "26191935"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407864
)
[StreetNumber] => Array
(
[0] => 1649
)
[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://player.vimeo.com/video/942941702
)
[ListPrice] => Array
(
[0] => 1795000.00
)
[CurrentPrice] => Array
(
[0] => 1795000.00
)
[Neighbourhood] => Array
(
[0] => ST. LOUIS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Sweeping Diamond Head & Ocean views! This 4 bedroom/4 bathroom home in St. Louis Heights offers incredible flexibility with endless options and excellent investment potential! Enjoy as a primary residence OR take advantage of the possibility of three separate rental units: a 1 bedroom/1 bathroom unit on the bottom floor, an expansive 2 bedroom/2 bathroom unit on the middle level, and a Studio/1 bathroom unit on the top level. Purchase the property and rent all three units individually; live in one unit and rent the other two; or reconnect the three units to create one large single-family residence again! The home has both interior and exterior stairs to travel between floors. A carport at street level fits two vehicles and a tropical backyard with an expansive flat grassy lawn and mature trees bordering the property. The opportunities are endless AND the views are stunning! Layout and square footage may not match property tax records. Portions of this property are tenant-occupied, please do not disturb the tenants.
)
[ListOfficeName] => Array
(
[0] => Hawaii Life
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6040.00
)
[SqftTotal] => Array
(
[0] => 3168
)
[YearBuilt] => Array
(
[0] => 1942
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => City,Diamond Head,Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HLRE
)
[ListAgentEmail] => Array
(
[0] => noelshaw@hawaiilife.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 221-8889
)
[ListAgentFullName] => Array
(
[0] => Noel Pietsch Shaw
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-15T11:00:01.297
)
[Matrix_Unique_ID] => Array
(
[0] => 17928652
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-04T16:42:53.840
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26191328
)
[listing_image] => Array
(
[0] => 26191328
[1] => 26191329
[2] => 26191330
[3] => 26191331
[4] => 26191332
[5] => 26191333
[6] => 26191334
[7] => 26191335
[8] => 26191336
[9] => 26191337
[10] => 26191338
[11] => 26191928
[12] => 26191929
[13] => 26191930
[14] => 26191931
[15] => 26191932
[16] => 26191933
[17] => 26191934
[18] => 26191935
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 6,040
- Living (sf): 3,168
- Year Built: 1942
- Property Condition: Average
- Number of Parking Spaces: 2
- View: City,Diamond Head,Garden,Mountain,Ocean
- Listing Office: Hawaii Life
- Land Tenure: FS - Fee Simple
