Listing
Overview
Price: $1,588,000
Area: ALEWA HEIGHTS
Status: Active
Spectacular, stunning, breathtaking Diamond Head, city & ocean views. This newly renovated home located in the desirable neighborhood of Alewa Heights boasts 5 bedrooms and 2 bathrooms. Upper level consist of 3 bedrooms, a bathroom, kitchen, living room and an outdoor lanai to sit and drink coffee in the morning or take in the view of the sunset in the evening. Enjoy the panoramic views while cooking your meals in the newly renovated kitchen. Recent upgrades include shaker cabinets, quartz countertops, stainless steel appliances, wine fridge, pantry, LVP, ceiling fans, split AC, and updated electrical & plumbing. Relax and enjoy amazing views in the primary room. The lower level offers the flexibility of multi-generational living, in-law suite or private guest quarter with 2 bedroom and a bathroom. The expansive and spacious outdoor area great for barbeque and entertainment with family and friends with fenced back yard. 2 car carport with extra street parking. Enjoy the peaceful and quiet neighborhood, minutes to downtown Honolulu, schools, parks, shops & restaurants. Listing by: MG Hawaii Realty, LLC (808) 489-5227
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424236"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1861"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kualono"
}
["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) "96817"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(79) "https://media.visionaryviewsllc.com/videos/0192e6f4-0973-726a-bca9-5c0054b693dc"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1588000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1588000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "ALEWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1084) "Spectacular, stunning, breathtaking Diamond Head, city & ocean views. This newly renovated home located in the desirable neighborhood of Alewa Heights boasts 5 bedrooms and 2 bathrooms. Upper level consist of 3 bedrooms, a bathroom, kitchen, living room and an outdoor lanai to sit and drink coffee in the morning or take in the view of the sunset in the evening. Enjoy the panoramic views while cooking your meals in the newly renovated kitchen. Recent upgrades include shaker cabinets, quartz countertops, stainless steel appliances, wine fridge, pantry, LVP, ceiling fans, split AC, and updated electrical & plumbing. Relax and enjoy amazing views in the primary room. The lower level offers the flexibility of multi-generational living, in-law suite or private guest quarter with 2 bedroom and a bathroom. The expansive and spacious outdoor area great for barbeque and entertainment with family and friends with fenced back yard. 2 car carport with extra street parking. Enjoy the peaceful and quiet neighborhood, minutes to downtown Honolulu, schools, parks, shops & restaurants."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(21) "MG Hawaii Realty, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6750.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1640"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(48) "City,Coastline,Diamond Head,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Maemae"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(11) "Kawananakoa"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mckinley"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "KMBL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "MGHawaiiRealty@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 489-5227"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Maribeth Agbayani George"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-14T10:00:01.663"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18334026"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-31T14:56:11.397"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26751847"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26751847"
[1]=>
string(8) "26751848"
[2]=>
string(8) "26751849"
[3]=>
string(8) "26751850"
[4]=>
string(8) "26751851"
[5]=>
string(8) "26751852"
[6]=>
string(8) "26751853"
[7]=>
string(8) "26751854"
[8]=>
string(8) "26751855"
[9]=>
string(8) "26751856"
[10]=>
string(8) "26751857"
[11]=>
string(8) "26751858"
[12]=>
string(8) "26751859"
[13]=>
string(8) "26751860"
[14]=>
string(8) "26751861"
[15]=>
string(8) "26751862"
[16]=>
string(8) "26751863"
[17]=>
string(8) "26751864"
[18]=>
string(8) "26751865"
[19]=>
string(8) "26751866"
[20]=>
string(8) "26751867"
[21]=>
string(8) "26751868"
[22]=>
string(8) "26751869"
[23]=>
string(8) "26751870"
[24]=>
string(8) "26751871"
[25]=>
string(8) "26751872"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424236
)
[StreetNumber] => Array
(
[0] => 1861
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kualono
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://media.visionaryviewsllc.com/videos/0192e6f4-0973-726a-bca9-5c0054b693dc
)
[ListPrice] => Array
(
[0] => 1588000.00
)
[CurrentPrice] => Array
(
[0] => 1588000.00
)
[Neighbourhood] => Array
(
[0] => ALEWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Spectacular, stunning, breathtaking Diamond Head, city & ocean views. This newly renovated home located in the desirable neighborhood of Alewa Heights boasts 5 bedrooms and 2 bathrooms. Upper level consist of 3 bedrooms, a bathroom, kitchen, living room and an outdoor lanai to sit and drink coffee in the morning or take in the view of the sunset in the evening. Enjoy the panoramic views while cooking your meals in the newly renovated kitchen. Recent upgrades include shaker cabinets, quartz countertops, stainless steel appliances, wine fridge, pantry, LVP, ceiling fans, split AC, and updated electrical & plumbing. Relax and enjoy amazing views in the primary room. The lower level offers the flexibility of multi-generational living, in-law suite or private guest quarter with 2 bedroom and a bathroom. The expansive and spacious outdoor area great for barbeque and entertainment with family and friends with fenced back yard. 2 car carport with extra street parking. Enjoy the peaceful and quiet neighborhood, minutes to downtown Honolulu, schools, parks, shops & restaurants.
)
[ListOfficeName] => Array
(
[0] => MG Hawaii Realty, LLC
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6750.00
)
[SqftTotal] => Array
(
[0] => 1640
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Maemae
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kawananakoa
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => KMBL
)
[ListAgentEmail] => Array
(
[0] => MGHawaiiRealty@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 489-5227
)
[ListAgentFullName] => Array
(
[0] => Maribeth Agbayani George
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-14T10:00:01.663
)
[Matrix_Unique_ID] => Array
(
[0] => 18334026
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-31T14:56:11.397
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26751847
)
[listing_image] => Array
(
[0] => 26751847
[1] => 26751848
[2] => 26751849
[3] => 26751850
[4] => 26751851
[5] => 26751852
[6] => 26751853
[7] => 26751854
[8] => 26751855
[9] => 26751856
[10] => 26751857
[11] => 26751858
[12] => 26751859
[13] => 26751860
[14] => 26751861
[15] => 26751862
[16] => 26751863
[17] => 26751864
[18] => 26751865
[19] => 26751866
[20] => 26751867
[21] => 26751868
[22] => 26751869
[23] => 26751870
[24] => 26751871
[25] => 26751872
)
)
- BedsTotal: 5
- Full Baths: 2
- Land Area (sf): 6,750
- Living (sf): 1,640
- Year Built: 1956
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: City,Coastline,Diamond Head,Ocean,Sunrise,Sunset
- Listing Office: MG Hawaii Realty, LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Maemae
- Middle School: Kawananakoa
- High School: Mckinley
