Listing
Overview
Price: $3,845,000
Area: DIAMOND HEAD
Status: Active
Completely remodeled in 2024, this single-family home is accompanied by additional 2-story 2nd dwelling totaling 6BD/4½BA, with frontage 3-car parking. Each dwelling is separately metered & indiv addressed as 3007 & 3007A Hibiscus. Step into the main residence with striking double-height glass entrance, enlightened by mother-of-pearl honeycomb chandeliers. Gourmet Thermador appliances featured with discreet walk-in pantry set aside from kitchen workspaces, adjacent to LIV & DIN rms divided by 2-sided electronic fireplace. On 2nd floor, the primary BD & ensuite combines with 2BD, 1BA + laundry rm. On lower level, 1BD + sep storage rm & ½BA are for your privacy & convenience. In 2nd dwelling, 1BD/1BA spaces are on each level, with upstairs private lanai. Dwellings collectively boast Fleetwood sliders, Cambria & Silestone countertops, hardwood flooring, Italian porcelain tiles + custom cabinets & closet systems. Mitsubishi AC installed throughout incl cassette, central & split systems. Famous beaches, multi leisure highlights & world-class shopping are steps away. A perfect combination of modern luxury & exquisite design exemplified in this inspiring & inviting residence to call home. Listing by: Agora Hawaii (808) 799-2834
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416358"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3007"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Hibiscus"
}
["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) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(40) "https://player.vimeo.com/video/990361590"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3845000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "DIAMOND HEAD"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1202) "Completely remodeled in 2024, this single-family home is accompanied by additional 2-story 2nd dwelling totaling 6BD/4½BA, with frontage 3-car parking. Each dwelling is separately metered & indiv addressed as 3007 & 3007A Hibiscus. Step into the main residence with striking double-height glass entrance, enlightened by mother-of-pearl honeycomb chandeliers. Gourmet Thermador appliances featured with discreet walk-in pantry set aside from kitchen workspaces, adjacent to LIV & DIN rms divided by 2-sided electronic fireplace. On 2nd floor, the primary BD & ensuite combines with 2BD, 1BA + laundry rm. On lower level, 1BD + sep storage rm & ½BA are for your privacy & convenience. In 2nd dwelling, 1BD/1BA spaces are on each level, with upstairs private lanai. Dwellings collectively boast Fleetwood sliders, Cambria & Silestone countertops, hardwood flooring, Italian porcelain tiles + custom cabinets & closet systems. Mitsubishi AC installed throughout incl cassette, central & split systems. Famous beaches, multi leisure highlights & world-class shopping are steps away. A perfect combination of modern luxury & exquisite design exemplified in this inspiring & inviting residence to call home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(12) "Agora Hawaii"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4920.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3872"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1981"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(12) "Basement,Two"
}
["View"]=>
array(1) {
[0]=>
string(12) "Diamond Head"
}
["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) "AGOR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "pauls@agorahawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 799-2834"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Paul D Sebastian"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-01T14:53:15.690"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18136403"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26629777"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26629777"
[1]=>
string(8) "26629778"
[2]=>
string(8) "26629779"
[3]=>
string(8) "26629780"
[4]=>
string(8) "26629781"
[5]=>
string(8) "26629782"
[6]=>
string(8) "26629783"
[7]=>
string(8) "26629784"
[8]=>
string(8) "26629785"
[9]=>
string(8) "26629786"
[10]=>
string(8) "26629787"
[11]=>
string(8) "26629788"
[12]=>
string(8) "26629789"
[13]=>
string(8) "26629790"
[14]=>
string(8) "26629791"
[15]=>
string(8) "26629792"
[16]=>
string(8) "26629793"
[17]=>
string(8) "26629794"
[18]=>
string(8) "26629795"
[19]=>
string(8) "26629796"
[20]=>
string(8) "26629797"
[21]=>
string(8) "26629798"
[22]=>
string(8) "26629799"
[23]=>
string(8) "26629800"
[24]=>
string(8) "26629801"
[25]=>
string(8) "26629802"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-07-20"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "14:53:15.690"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416358
)
[StreetNumber] => Array
(
[0] => 3007
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hibiscus
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/990361590
)
[ListPrice] => Array
(
[0] => 3845000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => DIAMOND HEAD
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Completely remodeled in 2024, this single-family home is accompanied by additional 2-story 2nd dwelling totaling 6BD/4½BA, with frontage 3-car parking. Each dwelling is separately metered & indiv addressed as 3007 & 3007A Hibiscus. Step into the main residence with striking double-height glass entrance, enlightened by mother-of-pearl honeycomb chandeliers. Gourmet Thermador appliances featured with discreet walk-in pantry set aside from kitchen workspaces, adjacent to LIV & DIN rms divided by 2-sided electronic fireplace. On 2nd floor, the primary BD & ensuite combines with 2BD, 1BA + laundry rm. On lower level, 1BD + sep storage rm & ½BA are for your privacy & convenience. In 2nd dwelling, 1BD/1BA spaces are on each level, with upstairs private lanai. Dwellings collectively boast Fleetwood sliders, Cambria & Silestone countertops, hardwood flooring, Italian porcelain tiles + custom cabinets & closet systems. Mitsubishi AC installed throughout incl cassette, central & split systems. Famous beaches, multi leisure highlights & world-class shopping are steps away. A perfect combination of modern luxury & exquisite design exemplified in this inspiring & inviting residence to call home.
)
[ListOfficeName] => Array
(
[0] => Agora Hawaii
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4920.00
)
[SqftTotal] => Array
(
[0] => 3872
)
[YearBuilt] => Array
(
[0] => 1981
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Basement,Two
)
[View] => Array
(
[0] => Diamond Head
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => AGOR
)
[ListAgentEmail] => Array
(
[0] => pauls@agorahawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 799-2834
)
[ListAgentFullName] => Array
(
[0] => Paul D Sebastian
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-01T14:53:15.690
)
[Matrix_Unique_ID] => Array
(
[0] => 18136403
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26629777
)
[listing_image] => Array
(
[0] => 26629777
[1] => 26629778
[2] => 26629779
[3] => 26629780
[4] => 26629781
[5] => 26629782
[6] => 26629783
[7] => 26629784
[8] => 26629785
[9] => 26629786
[10] => 26629787
[11] => 26629788
[12] => 26629789
[13] => 26629790
[14] => 26629791
[15] => 26629792
[16] => 26629793
[17] => 26629794
[18] => 26629795
[19] => 26629796
[20] => 26629797
[21] => 26629798
[22] => 26629799
[23] => 26629800
[24] => 26629801
[25] => 26629802
)
[ListingContractDate] => Array
(
[0] => 2024-07-20
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 14:53:15.690
)
)
- BedsTotal: 6
- Full Baths: 4
- Half Baths: 1
- Land Area (sf): 4,920 sf
- Living (sf): 3,872
- Year Built: 1981
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: Diamond Head
- Listing Office: Agora Hawaii
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on January 1, 2025 - 2:53 PM
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.
