Listing
Overview
Price: $825,000
Area: EWA GEN LAULANI-TIDES
Status: Active Under Contract
New price & VA assumable loan - 2.25%! Welcome to your dream home at Ewa Gentry Laulani-Tides! This well-maintained contemporary style 4 bedroom/2.5 bath single family residence features the perfect blend of comfort and style: an open floor plan with hardwood/tile/new upgraded carpet flooring, new solar water heater, sleek neutral color cabinetry with SS appliances & multiple closets. The primary bedroom is a generously sized room with a walk-n closet and an en-suite bathroom with modern fixtures. The additional three bedrooms with extra landing space offer versatility for guest rooms, home offices, or a playroom. The fenced private backyard with tropical landscaping is perfect for outdoor gatherings and relaxation. One of the highlights of this property is the extra parking, providing convenience for multiple vehicles. Extra guest parking is right around the corner. Pet friendly. Laulani-Tides offers convenient access to the community pool, schools, shopping centers, parks. Don't miss the opportunity to make this house your new home. Schedule your showing today and envision a vibrant lifestyle at Ewa Gentry! The property is virtually staged and photos are enhanced. Listing by: Coldwell Banker Realty (808) 676-7200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202404659"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "91-1001"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Keaunui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(2) "94"
}
["City"]=>
array(1) {
[0]=>
string(9) "Ewa Beach"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96706"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://s3.amazonaws.com/video.creativeedge.tv/782924-4.mp4"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "825000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "825000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(21) "EWA GEN LAULANI-TIDES"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1196) "New price & VA assumable loan - 2.25%! Welcome to your dream home at Ewa Gentry Laulani-Tides! This well-maintained contemporary style 4 bedroom/2.5 bath single family residence features the perfect blend of comfort and style: an open floor plan with hardwood/tile/new upgraded carpet flooring, new solar water heater, sleek neutral color cabinetry with SS appliances & multiple closets. The primary bedroom is a generously sized room with a walk-n closet and an en-suite bathroom with modern fixtures. The additional three bedrooms with extra landing space offer versatility for guest rooms, home offices, or a playroom. The fenced private backyard with tropical landscaping is perfect for outdoor gatherings and relaxation. One of the highlights of this property is the extra parking, providing convenience for multiple vehicles. Extra guest parking is right around the corner. Pet friendly. Laulani-Tides offers convenient access to the community pool, schools, shopping centers, parks. Don't miss the opportunity to make this house your new home. Schedule your showing today and envision a vibrant lifestyle at Ewa Gentry! The property is virtually staged and photos are enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3388.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1427"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2010"
}
["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(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "408.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(8) "Keoneula"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Ewa Makai"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Campbell"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP15"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "ValentinaD@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(31) "Valentina L Danilyuk-Drumheller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-22T16:11:58.813"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17858848"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-03-05T10:58:58.610"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(8) "Ewaplain"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26117640"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26117640"
[1]=>
string(8) "26117641"
[2]=>
string(8) "26117642"
[3]=>
string(8) "26117643"
[4]=>
string(8) "26117644"
[5]=>
string(8) "26117645"
[6]=>
string(8) "26117646"
[7]=>
string(8) "26117647"
[8]=>
string(8) "26117648"
[9]=>
string(8) "26117649"
[10]=>
string(8) "26117650"
[11]=>
string(8) "26117651"
[12]=>
string(8) "26117652"
[13]=>
string(8) "26117653"
[14]=>
string(8) "26117654"
[15]=>
string(8) "26117655"
[16]=>
string(8) "26117656"
[17]=>
string(8) "26117657"
[18]=>
string(8) "26117658"
[19]=>
string(8) "26117659"
[20]=>
string(8) "26117660"
[21]=>
string(8) "26117661"
[22]=>
string(8) "26117662"
[23]=>
string(8) "26117663"
[24]=>
string(8) "26117664"
[25]=>
string(8) "26117665"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202404659
)
[StreetNumber] => Array
(
[0] => 91-1001
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Keaunui
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 94
)
[City] => Array
(
[0] => Ewa Beach
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96706
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://s3.amazonaws.com/video.creativeedge.tv/782924-4.mp4
)
[ListPrice] => Array
(
[0] => 825000.00
)
[CurrentPrice] => Array
(
[0] => 825000.00
)
[Neighbourhood] => Array
(
[0] => EWA GEN LAULANI-TIDES
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => New price & VA assumable loan - 2.25%! Welcome to your dream home at Ewa Gentry Laulani-Tides! This well-maintained contemporary style 4 bedroom/2.5 bath single family residence features the perfect blend of comfort and style: an open floor plan with hardwood/tile/new upgraded carpet flooring, new solar water heater, sleek neutral color cabinetry with SS appliances & multiple closets. The primary bedroom is a generously sized room with a walk-n closet and an en-suite bathroom with modern fixtures. The additional three bedrooms with extra landing space offer versatility for guest rooms, home offices, or a playroom. The fenced private backyard with tropical landscaping is perfect for outdoor gatherings and relaxation. One of the highlights of this property is the extra parking, providing convenience for multiple vehicles. Extra guest parking is right around the corner. Pet friendly. Laulani-Tides offers convenient access to the community pool, schools, shopping centers, parks. Don't miss the opportunity to make this house your new home. Schedule your showing today and envision a vibrant lifestyle at Ewa Gentry! The property is virtually staged and photos are enhanced.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3388.00
)
[SqftTotal] => Array
(
[0] => 1427
)
[YearBuilt] => Array
(
[0] => 2010
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 408.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Keoneula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Ewa Makai
)
[HighSchool] => Array
(
[0] => Campbell
)
[ListOfficeMLSID] => Array
(
[0] => CBPP15
)
[ListAgentEmail] => Array
(
[0] => ValentinaD@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 676-7200
)
[ListAgentFullName] => Array
(
[0] => Valentina L Danilyuk-Drumheller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-22T16:11:58.813
)
[Matrix_Unique_ID] => Array
(
[0] => 17858848
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-03-05T10:58:58.610
)
[MLSAreaMajor] => Array
(
[0] => Ewaplain
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26117640
)
[listing_image] => Array
(
[0] => 26117640
[1] => 26117641
[2] => 26117642
[3] => 26117643
[4] => 26117644
[5] => 26117645
[6] => 26117646
[7] => 26117647
[8] => 26117648
[9] => 26117649
[10] => 26117650
[11] => 26117651
[12] => 26117652
[13] => 26117653
[14] => 26117654
[15] => 26117655
[16] => 26117656
[17] => 26117657
[18] => 26117658
[19] => 26117659
[20] => 26117660
[21] => 26117661
[22] => 26117662
[23] => 26117663
[24] => 26117664
[25] => 26117665
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 3,388
- Living (sf): 1,427
- Year Built: 2010
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: None
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $408
- Land Tenure: FS - Fee Simple
- Elementary School: Keoneula
- Middle School: Ewa Makai
- High School: Campbell
