Listing
Overview
Price: $749,000
Area: EWA GEN TERRAZZA
Status: Active
Calling all investors...seller will consider all offers. Solid tenants with good cash-flow and lease through 3/29/2024.
This is the detached single family home in Terrazza in Ewa by Gentry that you’ve been looking for. Large fully fenced corner lot with spacious 2 car garage and a driveway big enough for 2 more cars directly across from a small community park and adjacent to guest parking. This home features tile floors downstairs with beautiful wood laminate floors upstairs, freshly painted inside and out with new window blinds and new ceiling fans in 2020. This model has the coveted second floor laundry room and an enormous master suite with sitting room (4th bedroom on some models) that could make an ideal home office or nursery. This home is currently tenant occupied and requires 48 hours advance notice for showings. Listing by: Hawaii Sands Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202313987"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "91-234"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Makalea"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(51) "https://my.matterport.com/show/?m=7dKpx1L8FAS&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "EWA GEN TERRAZZA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(835) "Calling all investors...seller will consider all offers. Solid tenants with good cash-flow and lease through 3/29/2024.
This is the detached single family home in Terrazza in Ewa by Gentry that you’ve been looking for. Large fully fenced corner lot with spacious 2 car garage and a driveway big enough for 2 more cars directly across from a small community park and adjacent to guest parking. This home features tile floors downstairs with beautiful wood laminate floors upstairs, freshly painted inside and out with new window blinds and new ceiling fans in 2020. This model has the coveted second floor laundry room and an enormous master suite with sitting room (4th bedroom on some models) that could make an ideal home office or nursery. This home is currently tenant occupied and requires 48 hours advance notice for showings."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "Hawaii Sands Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3863.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1590"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2002"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(12) "Garden,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "513.32"
}
["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) "HSAN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "dmoyer@hawaiisands.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "David L Moyer"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-11T17:24:45.740"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17390724"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-24T16:35:20.160"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25858574"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "25858574"
[1]=>
string(8) "25858575"
[2]=>
string(8) "25858576"
[3]=>
string(8) "25858577"
[4]=>
string(8) "25858578"
[5]=>
string(8) "25858579"
[6]=>
string(8) "25858580"
[7]=>
string(8) "25858581"
[8]=>
string(8) "25858582"
[9]=>
string(8) "25858583"
[10]=>
string(8) "25858584"
[11]=>
string(8) "25858585"
[12]=>
string(8) "25858586"
[13]=>
string(8) "25858587"
[14]=>
string(8) "25858588"
[15]=>
string(8) "25858589"
[16]=>
string(8) "25858590"
[17]=>
string(8) "25858591"
[18]=>
string(8) "25858592"
[19]=>
string(8) "25858593"
[20]=>
string(8) "25858594"
[21]=>
string(8) "25858595"
[22]=>
string(8) "25858596"
[23]=>
string(8) "25858597"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(8) "Ewaplain"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202313987
)
[StreetNumber] => Array
(
[0] => 91-234
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Makalea
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Ewa Beach
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96706
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=7dKpx1L8FAS&mls=1
)
[ListPrice] => Array
(
[0] => 749000.00
)
[CurrentPrice] => Array
(
[0] => 749000.00
)
[Neighbourhood] => Array
(
[0] => EWA GEN TERRAZZA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Calling all investors...seller will consider all offers. Solid tenants with good cash-flow and lease through 3/29/2024.
This is the detached single family home in Terrazza in Ewa by Gentry that you’ve been looking for. Large fully fenced corner lot with spacious 2 car garage and a driveway big enough for 2 more cars directly across from a small community park and adjacent to guest parking. This home features tile floors downstairs with beautiful wood laminate floors upstairs, freshly painted inside and out with new window blinds and new ceiling fans in 2020. This model has the coveted second floor laundry room and an enormous master suite with sitting room (4th bedroom on some models) that could make an ideal home office or nursery. This home is currently tenant occupied and requires 48 hours advance notice for showings.
)
[ListOfficeName] => Array
(
[0] => Hawaii Sands Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3863.00
)
[SqftTotal] => Array
(
[0] => 1590
)
[YearBuilt] => Array
(
[0] => 2002
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Other
)
[MaintenanceExpense] => Array
(
[0] => 513.32
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HSAN
)
[ListAgentEmail] => Array
(
[0] => dmoyer@hawaiisands.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => David L Moyer
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-11T17:24:45.740
)
[Matrix_Unique_ID] => Array
(
[0] => 17390724
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-24T16:35:20.160
)
[_thumbnail_id] => Array
(
[0] => 25858574
)
[listing_image] => Array
(
[0] => 25858574
[1] => 25858575
[2] => 25858576
[3] => 25858577
[4] => 25858578
[5] => 25858579
[6] => 25858580
[7] => 25858581
[8] => 25858582
[9] => 25858583
[10] => 25858584
[11] => 25858585
[12] => 25858586
[13] => 25858587
[14] => 25858588
[15] => 25858589
[16] => 25858590
[17] => 25858591
[18] => 25858592
[19] => 25858593
[20] => 25858594
[21] => 25858595
[22] => 25858596
[23] => 25858597
)
[MLSAreaMajor] => Array
(
[0] => Ewaplain
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 3,863
- Living (sf): 1,590
- Year Built: 2002
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Garden,Other
- Listing Office: Hawaii Sands Realty
- Maintenance Fees: $513
- Land Tenure: FS - Fee Simple
