Listing
Overview
Price: $1,295,000
Area: MAUNALANI HEIGHTS
Status: Active Under Contract
WOW, full panoramic ocean, Diamond Head, coastline & city views from this prime neighborhood in the heart of Town, just minutes to Kahala Mall, Kaimuki, Waikiki & Ala Moana! Ideal gentle down-slope house/lot in the desirable Maunalani Heights w/wide streets, underground utilities, curbs and guttters in this beautifully maintained neighborhood.
If you are looking for to build your dream view home in Town, or are looking to do major rehab/renovations to bring this "Jewel on the Hill" back to it's former glory...Look No Further...this IS it!
Don't Miss-Out on this Great Opportunity!! Listing by: Hawaii Living LLC (808) 372-2274
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202504728"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3847"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Mariposa"
}
["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(72) "https://dmiscmedia.aryeo.com/videos/0194f4fa-c431-72b1-94c5-339b98a4650f"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1295000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(17) "MAUNALANI HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(594) "WOW, full panoramic ocean, Diamond Head, coastline & city views from this prime neighborhood in the heart of Town, just minutes to Kahala Mall, Kaimuki, Waikiki & Ala Moana! Ideal gentle down-slope house/lot in the desirable Maunalani Heights w/wide streets, underground utilities, curbs and guttters in this beautifully maintained neighborhood.
If you are looking for to build your dream view home in Town, or are looking to do major rehab/renovations to bring this "Jewel on the Hill" back to it's former glory...Look No Further...this IS it!
Don't Miss-Out on this Great Opportunity!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Hawaii Living LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6072.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2186"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1943"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(28) "Needs Major Repair,Tear Down"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(82) "City,Coastline,Diamond Head,Golf Course,Marina/Canal,Mountain,Ocean,Sunrise,Sunset"
}
["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) "HOHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "Tracy@HawaiiLiving.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 372-2274"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Tracy Yamato"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18548664"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-21T18:24:05.547"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:24:05.547"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26881429"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "26881429"
[1]=>
string(8) "26881430"
[2]=>
string(8) "26881431"
[3]=>
string(8) "26881432"
[4]=>
string(8) "26881433"
[5]=>
string(8) "26881434"
[6]=>
string(8) "26881435"
[7]=>
string(8) "26881436"
[8]=>
string(8) "26881437"
[9]=>
string(8) "26881438"
[10]=>
string(8) "26881439"
[11]=>
string(8) "26881440"
[12]=>
string(8) "26881441"
[13]=>
string(8) "26881442"
[14]=>
string(8) "26881443"
[15]=>
string(8) "26881444"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202504728
)
[StreetNumber] => Array
(
[0] => 3847
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mariposa
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://dmiscmedia.aryeo.com/videos/0194f4fa-c431-72b1-94c5-339b98a4650f
)
[ListPrice] => Array
(
[0] => 1295000.00
)
[Neighbourhood] => Array
(
[0] => MAUNALANI HEIGHTS
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => WOW, full panoramic ocean, Diamond Head, coastline & city views from this prime neighborhood in the heart of Town, just minutes to Kahala Mall, Kaimuki, Waikiki & Ala Moana! Ideal gentle down-slope house/lot in the desirable Maunalani Heights w/wide streets, underground utilities, curbs and guttters in this beautifully maintained neighborhood.
If you are looking for to build your dream view home in Town, or are looking to do major rehab/renovations to bring this "Jewel on the Hill" back to it's former glory...Look No Further...this IS it!
Don't Miss-Out on this Great Opportunity!!
)
[ListOfficeName] => Array
(
[0] => Hawaii Living LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6072.00
)
[SqftTotal] => Array
(
[0] => 2186
)
[YearBuilt] => Array
(
[0] => 1943
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Needs Major Repair,Tear Down
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Golf Course,Marina/Canal,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HOHI
)
[ListAgentEmail] => Array
(
[0] => Tracy@HawaiiLiving.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 372-2274
)
[ListAgentFullName] => Array
(
[0] => Tracy Yamato
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18548664
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-21T18:24:05.547
)
[ListingContractDate] => Array
(
[0] => 2025-02-14
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:24:05.547
)
[_thumbnail_id] => Array
(
[0] => 26881429
)
[listing_image] => Array
(
[0] => 26881429
[1] => 26881430
[2] => 26881431
[3] => 26881432
[4] => 26881433
[5] => 26881434
[6] => 26881435
[7] => 26881436
[8] => 26881437
[9] => 26881438
[10] => 26881439
[11] => 26881440
[12] => 26881441
[13] => 26881442
[14] => 26881443
[15] => 26881444
)
)
- BedsTotal: 4
- Full Baths: 1
- Land Area (sf): 6,072 sf
- Living (sf): 2,186
- Year Built: 1943
- Property Condition: Needs Major Repair,Tear Down
- Number of Parking Spaces: 1
- View: City,Coastline,Diamond Head,Golf Course,Marina/Canal,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Hawaii Living LLC
- Land Tenure: FS - Fee Simple
