Listing
Overview
Price: $1,995,000
Area: UALAKAA
Status: Active Under Contract
Discover the perfect canvas for your dream home in the prestigious and coveted Ualakaa neighborhood of Makiki, which is just minutes away from Punahou School! This single-level residence with in-ground pool offers endless potential for a full remodel or even a rebuild, allowing you to tailor every aspect to your unique vision and lifestyle. Nestled within one of Makiki’s premier communities, this property allows for a modern oasis, a traditional retreat, or something entirely different. The expansive lot and convenient layout provide the ideal foundation for your design aspirations. Imagine crafting an open-concept floor plan flooded with natural light, incorporating luxurious amenities and high-end finishes throughout. Outside, the lush surroundings offer a serene backdrop for outdoor living and entertaining. From manicured gardens to tranquil patio spaces, there’s limitless potential to create your own private paradise allowing this property to turn your vison into reality! **NOTE: # of bathrooms do not match tax records** Listing by: BHGRE Advantage Realty (808) 271-9333
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417083"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1949"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Ualakaa"
}
["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) "96822"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/pnnxonq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "UALAKAA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1045) "Discover the perfect canvas for your dream home in the prestigious and coveted Ualakaa neighborhood of Makiki, which is just minutes away from Punahou School! This single-level residence with in-ground pool offers endless potential for a full remodel or even a rebuild, allowing you to tailor every aspect to your unique vision and lifestyle. Nestled within one of Makiki’s premier communities, this property allows for a modern oasis, a traditional retreat, or something entirely different. The expansive lot and convenient layout provide the ideal foundation for your design aspirations. Imagine crafting an open-concept floor plan flooded with natural light, incorporating luxurious amenities and high-end finishes throughout. Outside, the lush surroundings offer a serene backdrop for outdoor living and entertaining. From manicured gardens to tranquil patio spaces, there’s limitless potential to create your own private paradise allowing this property to turn your vison into reality! **NOTE: # of bathrooms do not match tax records**"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10373.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2766"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Fair,Needs Major Repair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(13) "City,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Lincoln"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Stevenson"
}
["HighSchool"]=>
array(1) {
[0]=>
string(9) "Roosevelt"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "MichelleN@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-9333"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(23) "Michelle K Nouchi Ogata"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-27T04:22:05.150"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18157109"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-09T11:14:10.057"
}
["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) "26653578"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26653578"
[1]=>
string(8) "26653579"
[2]=>
string(8) "26653580"
[3]=>
string(8) "26653581"
[4]=>
string(8) "26653582"
[5]=>
string(8) "26653583"
[6]=>
string(8) "26653584"
[7]=>
string(8) "26653585"
[8]=>
string(8) "26653586"
[9]=>
string(8) "26653587"
[10]=>
string(8) "26653588"
[11]=>
string(8) "26653589"
[12]=>
string(8) "26653590"
[13]=>
string(8) "26653591"
[14]=>
string(8) "26653592"
[15]=>
string(8) "26653593"
[16]=>
string(8) "26653594"
[17]=>
string(8) "26653595"
[18]=>
string(8) "26653596"
[19]=>
string(8) "26653597"
[20]=>
string(8) "26653598"
[21]=>
string(8) "26653599"
[22]=>
string(8) "26653600"
[23]=>
string(8) "26653601"
[24]=>
string(8) "26653602"
[25]=>
string(8) "26653603"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417083
)
[StreetNumber] => Array
(
[0] => 1949
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ualakaa
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96822
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/pnnxonq/unbranded
)
[ListPrice] => Array
(
[0] => 1995000.00
)
[CurrentPrice] => Array
(
[0] => 1995000.00
)
[Neighbourhood] => Array
(
[0] => UALAKAA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Discover the perfect canvas for your dream home in the prestigious and coveted Ualakaa neighborhood of Makiki, which is just minutes away from Punahou School! This single-level residence with in-ground pool offers endless potential for a full remodel or even a rebuild, allowing you to tailor every aspect to your unique vision and lifestyle. Nestled within one of Makiki’s premier communities, this property allows for a modern oasis, a traditional retreat, or something entirely different. The expansive lot and convenient layout provide the ideal foundation for your design aspirations. Imagine crafting an open-concept floor plan flooded with natural light, incorporating luxurious amenities and high-end finishes throughout. Outside, the lush surroundings offer a serene backdrop for outdoor living and entertaining. From manicured gardens to tranquil patio spaces, there’s limitless potential to create your own private paradise allowing this property to turn your vison into reality! **NOTE: # of bathrooms do not match tax records**
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10373.00
)
[SqftTotal] => Array
(
[0] => 2766
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair,Needs Major Repair
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Lincoln
)
[MiddleOrJuniorSchool] => Array
(
[0] => Stevenson
)
[HighSchool] => Array
(
[0] => Roosevelt
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => MichelleN@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-9333
)
[ListAgentFullName] => Array
(
[0] => Michelle K Nouchi Ogata
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-27T04:22:05.150
)
[Matrix_Unique_ID] => Array
(
[0] => 18157109
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-09T11:14:10.057
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26653578
)
[listing_image] => Array
(
[0] => 26653578
[1] => 26653579
[2] => 26653580
[3] => 26653581
[4] => 26653582
[5] => 26653583
[6] => 26653584
[7] => 26653585
[8] => 26653586
[9] => 26653587
[10] => 26653588
[11] => 26653589
[12] => 26653590
[13] => 26653591
[14] => 26653592
[15] => 26653593
[16] => 26653594
[17] => 26653595
[18] => 26653596
[19] => 26653597
[20] => 26653598
[21] => 26653599
[22] => 26653600
[23] => 26653601
[24] => 26653602
[25] => 26653603
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 10,373
- Living (sf): 2,766
- Year Built: 1956
- Property Condition: Fair,Needs Major Repair
- Number of Parking Spaces: 2
- View: City,Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Lincoln
- Middle School: Stevenson
- High School: Roosevelt
