OahuRE Search

Property Search | Show Search Form | Hide Search Form | Clear Search Form

Print selected listings to PDF without photos or with 2 photos or with all photos

Driving directions on Google Maps for up to 15 homes

Status

Regions

	Min	Max
Price:
Living:
Lanai:
Beds:
Bath:
Year:
Floor:
Fees:

Options 1

Options 2

Condition

Hide Columns

Results Screen: Comparison Large Photo Small Photo Google Maps Google Earth Activity Print to PDF

Land: Fee Simple Leasehold Buy Fee

Help video on searching by the Popular Options

If you know the Neighborhoods enter them below. To select Neighborhoods by Region click on a Region below.

A wildcard is inserted at the end. For example entering Ewa Gen finds all neighborhoods starting with Ewa Gen.

Central, Diamond Head, Ewa Plain, Hawaii Kai, Kailua, Kaneohe, Leeward, Makakilo, Metro, North Shore, Pearl City, Waipahu

Type the first 1 to 3 letters of the Neighborhood and a drop down list will appear showing you the Neighborhoods.

Neighborhood:
Neighborhood:
Neighborhood:

Help video on searching by Neighborhood

Building Name Type the first 1 to 3 letters of the Building Name and a drop down list will appear showing you the Building Names. Use a % sign at the end of the Building Name as a wildcard. For example, entering Parkview% will find all buildings that start with Parkview.

View	Frontage	Style	Parking	Amenities	Zoning

Description:


Restrict your search results to a specific area using Google Maps by clicking a link below.
Diamond Head	Downtown	Ewa	Hawaii Kai	Kailua	Kaneohe	Lanikai	Leeward
Makakilo	Metro	Mililani	North Shore	Oahu	Pearl City	Waikiki	Waipahu

Latitude		to
Longitude		to

Help video on searching by Google Maps

Street Name - Do not enter the Street # such as 112 or the suffix such as Street, Place.

Type the first 1 to 3 letters of the Street Name and a drop down list will appear showing you the Street Names.

Schools

Type the first 1 to 3 letters of the School Name and a drop down list will appear showing you the School Names.

Elementary:
Middle:
High:

MLS Number and Parcel Number

MLS #:
MLS # Removed:
	TMK should be entered in the following format: 1-9-8-031-024-0000. All Oahu TMKs start with 1. Also entering just 1-9-8 finds all TMKs starting with 1-9-8. The tax website writes the TMK without the 1 and with no dashes, so 1-9-8-031-024-0000 is 980310240000 on their website.
TMK / Parcel #:
Zip Code:

	Minimum	Maximum
Sold Date:
Sold Days on Market:
Sold Original Ratio:
Sold Price:

The Sold Filter Restricts Results to Sold Properties

Remember to add this search to your browser's bookmarks or favorites for easy access later or get a short link to send to via Email.

PropertyType='Condo/Townhouse' AND (BuildingName LIKE "TERRAZZA") AND ListingContractDate >= '2022-05-18'

6	Legend	Compare	Photos	Status	MLS#	Price	Original Price	Region	Neighborhood	Building	Address	Sold Price	Sold Date	Sold Ratio	Orig Ratio	Beds	Baths	Living Sq Ft	Avg. Living	Park	Lanai	Pets	Owner Occup.	FL	Year	Year Rem	List Date	Days	Condition	Tax	Fees	Assessed Land	Assessed Improve	Assessed Total	Assessed Ratio	Elementary	Junior	High	Zoning	Seller`s Agent	Buyer`s Agent	View	Frontage	Parking
1	FS\|CPR	1 * 2 * 3	View 9	Active	202406822	$420,000	$445,000	Metro	Punchbowl Area	Terrazza	1020 Green Street PH3					1	1/0	727	$578	1	22	Yes	56%	4	1958	2020	03-21-2024	58	Excellent	$54	$779	$96,300	$288,900	$385,200	109%	Lincoln	Stevenson	Roosevelt	12 - A-2 Medium Density Apartme			City	Other	Assigned, Open - 1
2	FS\|CPR	1 * 2 * 3	View 15	Cancelled	202311244	$299,000	$299,000	Metro	Punchbowl Area	TERRAZZA	1020 Green Street 310					1	1/0	524	$571	0	0	Yes	80%	3	1958	2019	05-17-2023	53	Excellent	$67	$513	$67,300	$193,200	$260,500	115%	Lincoln	Stevenson	Mckinley	12 - A-2 Medium Density Apartme			City, Garden, Other	Other	None, Street
3	FS\|CPR	1 * 2 * 3	View 15	Pending	202404371	$378,200	$378,200	Metro	Punchbowl Area	Terrazza	1020 Green Street 209					1	1/0	569	$665	1	0	Yes	56%	2	1958	2020	03-01-2024	59	Excellent	$54	$592	$73,100	$267,200	$340,300	111%	Lincoln	Stevenson	Roosevelt	12 - A-2 Medium Density Apartme			Garden		Assigned, Open - 1, Street
4	FS\|CPR	1 * 2 * 3	View 25	Sold	202317626	$319,000	$319,000	Metro	Punchbowl Area	Terrazza	1020 Green Street 201	$340,000	10-03-2023	107%	107%	1	1/0	410	$778	1	88	Yes	59%	2	1958	2023	08-02-2023	9	Excellent	$77	$503	$63,800	$201,200	$265,000	120%				12 - A-2 Medium Density Apartme	Justin K Taparra	Dollcy D Gebauer	None		Assigned, Covered - 1, Street
5	FS\|CPR	1 * 2 * 3	View 21	Sold	202316725	$299,000	$299,000	Metro	Punchbowl Area	Terrazza	1020 Green Street 310-B	$309,000	08-31-2023	103%	103%	1	1/0	524	$571	0	0	Yes	80%	3	1958		07-25-2023	6	Above Average	$66	$513	$67,300	$193,200	$260,500	115%	Lincoln	Stevenson	Roosevelt	12 - A-2 Medium Density Apartme	Will Tanaka	Sheldon Jacobs Storms	City, Garden		None
6	FS\|CPR	1 * 2 * 3	View 23	Sold	202310394	$279,000	$279,000	Metro	Punchbowl Area	Terrazza	1020 Green Street 204	$279,000	06-22-2023	100%	100%	1	1/0	410	$680	0	88	Yes	57%	2	1958	2018	05-07-2023	8	Above Average	$59	$503	$61,400	$142,200	$203,600	137%				12 - A-2 Medium Density Apartme	Patsy Vasquez	Alesia D Barnes	City, Garden		Street

Show All
Legend
Compare
Photos
Status
MLS#
Original Price
Price
Region
Neighborhood
Address
Sold Price
Sold Date
Sold Ratio
Original Ratio
Beds
Baths
Land Sq Ft
Average Land
Living Sq Ft
Average Living
Year
Year Remodeled
ListDate
Days
Condition
Tax
Fees
Assessed Land
Assessed Improve
Assessed Total
Assessed Ratio
Elementary
Junior
High
Zoning
View
Frontage
Pool
Parking