Listing
Overview
Price: $1,625,000
Area: PUOHALA VILLAGE
Status: Active
Welcome to your stunning 4 bed 2 bath home with a legal attached 2 bed 1 bath ADU. Nestled within a serene and tranquil neighborhood, you will discover the home of your dreams where island charm meets modern luxury. This gem of a home has been fully renovated from top to bottom with thoughtful attention to detail and quality craftsmanship. As you enter through the front door, you will be welcomed with an open floor concept and an exquisite new kitchen that is a chef’s delight. This gorgeous residence boasts high ceiling in the living room, recessed lighting throughout, all new luxury vinyl planks, quartz countertops, elegant cabinets with soft close, a kitchen island, stainless steel appliances, convection oven/microwave, a pantry, split a/c, a primary suite with a walk-in closet, solar water heater, and 2 electric meters. The brand new pristine ADU can be utilized either as an in-law suite or for rental income opportunity to offset your mortgage. Enjoy your spacious private backyard for outdoor activities or family gatherings. After a hard day’s work, relax on your open lanai and take a sip of your favorite drink as you marvel at the beauty of the breathtaking Ko'olau Mountains. Listing by: Alonso Agency LLC (808) 282-2003
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202513804"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-420"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(12) "Pua Makahala"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(58) "https://www.youtube.com/embed/qHVF6SImz2A?modestbranding=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "PUOHALA VILLAGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1202) "Welcome to your stunning 4 bed 2 bath home with a legal attached 2 bed 1 bath ADU. Nestled within a serene and tranquil neighborhood, you will discover the home of your dreams where island charm meets modern luxury. This gem of a home has been fully renovated from top to bottom with thoughtful attention to detail and quality craftsmanship. As you enter through the front door, you will be welcomed with an open floor concept and an exquisite new kitchen that is a chef’s delight. This gorgeous residence boasts high ceiling in the living room, recessed lighting throughout, all new luxury vinyl planks, quartz countertops, elegant cabinets with soft close, a kitchen island, stainless steel appliances, convection oven/microwave, a pantry, split a/c, a primary suite with a walk-in closet, solar water heater, and 2 electric meters. The brand new pristine ADU can be utilized either as an in-law suite or for rental income opportunity to offset your mortgage. Enjoy your spacious private backyard for outdoor activities or family gatherings. After a hard day’s work, relax on your open lanai and take a sip of your favorite drink as you marvel at the beauty of the breathtaking Ko'olau Mountains."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Alonso Agency LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7776.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2272"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1951"
}
["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) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["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) "ALON"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "jo@thealonsoteam.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 282-2003"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Josephine A Alonso"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18799068"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-06-14T08:20:21.720"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-06-13"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:20:21.720"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27030247"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27030247"
[1]=>
string(8) "27030248"
[2]=>
string(8) "27030249"
[3]=>
string(8) "27030250"
[4]=>
string(8) "27030251"
[5]=>
string(8) "27030252"
[6]=>
string(8) "27030253"
[7]=>
string(8) "27030254"
[8]=>
string(8) "27030255"
[9]=>
string(8) "27030256"
[10]=>
string(8) "27030257"
[11]=>
string(8) "27030258"
[12]=>
string(8) "27030259"
[13]=>
string(8) "27030260"
[14]=>
string(8) "27030261"
[15]=>
string(8) "27030262"
[16]=>
string(8) "27030263"
[17]=>
string(8) "27030264"
[18]=>
string(8) "27030265"
[19]=>
string(8) "27030266"
[20]=>
string(8) "27030267"
[21]=>
string(8) "27030268"
[22]=>
string(8) "27030269"
[23]=>
string(8) "27030270"
[24]=>
string(8) "27030271"
[25]=>
string(8) "27030272"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202513804
)
[StreetNumber] => Array
(
[0] => 45-420
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Pua Makahala
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/qHVF6SImz2A?modestbranding=1
)
[ListPrice] => Array
(
[0] => 1625000.00
)
[Neighbourhood] => Array
(
[0] => PUOHALA VILLAGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your stunning 4 bed 2 bath home with a legal attached 2 bed 1 bath ADU. Nestled within a serene and tranquil neighborhood, you will discover the home of your dreams where island charm meets modern luxury. This gem of a home has been fully renovated from top to bottom with thoughtful attention to detail and quality craftsmanship. As you enter through the front door, you will be welcomed with an open floor concept and an exquisite new kitchen that is a chef’s delight. This gorgeous residence boasts high ceiling in the living room, recessed lighting throughout, all new luxury vinyl planks, quartz countertops, elegant cabinets with soft close, a kitchen island, stainless steel appliances, convection oven/microwave, a pantry, split a/c, a primary suite with a walk-in closet, solar water heater, and 2 electric meters. The brand new pristine ADU can be utilized either as an in-law suite or for rental income opportunity to offset your mortgage. Enjoy your spacious private backyard for outdoor activities or family gatherings. After a hard day’s work, relax on your open lanai and take a sip of your favorite drink as you marvel at the beauty of the breathtaking Ko'olau Mountains.
)
[ListOfficeName] => Array
(
[0] => Alonso Agency LLC
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7776.00
)
[SqftTotal] => Array
(
[0] => 2272
)
[YearBuilt] => Array
(
[0] => 1951
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ALON
)
[ListAgentEmail] => Array
(
[0] => jo@thealonsoteam.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 282-2003
)
[ListAgentFullName] => Array
(
[0] => Josephine A Alonso
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18799068
)
[MatrixModifiedDT] => Array
(
[0] => 2025-06-14T08:20:21.720
)
[ListingContractDate] => Array
(
[0] => 2025-06-13
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:20:21.720
)
[_thumbnail_id] => Array
(
[0] => 27030247
)
[listing_image] => Array
(
[0] => 27030247
[1] => 27030248
[2] => 27030249
[3] => 27030250
[4] => 27030251
[5] => 27030252
[6] => 27030253
[7] => 27030254
[8] => 27030255
[9] => 27030256
[10] => 27030257
[11] => 27030258
[12] => 27030259
[13] => 27030260
[14] => 27030261
[15] => 27030262
[16] => 27030263
[17] => 27030264
[18] => 27030265
[19] => 27030266
[20] => 27030267
[21] => 27030268
[22] => 27030269
[23] => 27030270
[24] => 27030271
[25] => 27030272
)
)
- BedsTotal: 6
- Full Baths: 3
- Land Area (sf): 7,776 sf
- Living (sf): 2,272
- Year Built: 1951
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: Alonso Agency LLC
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 14, 2025 - 8:20 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.