Home
 Favorites
Single Family
Condos
Multi-Family
Land
MLS#
 Google CS Menu
Contact
Site Maps - Single Family, Condos, Multi-Family, Land, Stats, Resources, For Search Engines
       

We rebate buyers 20% of our commission and
charge seller’s just 1% to sell their home.

2 lots Haleiwa Beach Road Haleiwa HI 96712 North Shore Region Waialua Neighborhood Detail View - 1 Vacant Land Properties Found

Your Search Criteria:

MLS#: 2803855

Automatically Email me when this search is updated.

Email
CMA
 Details Details All Photos
Photos
Photos2
Map
 Directions
Print
 Export Print1 Print2

Photo Count: 10 - Click on photo below to see additional photos

Sell a home like this through OahuRE and save approximately $113,800 – Read More

Add this property to my Watch List

For information on this property or to schedule a showing contact OahuRE.com

MLS#:
Land:
 531,954
Address:
 2 lots Haleiwa Beach Road Haleiwa HI 96712
Status:
 Withdrawn
Average:
 $10.70
Region:
 North Shore
Price:
 $5,690,000 $34,140 Buyer's Rebate
Acres:
 12.2120
Neighborhood:
 Waialua, Statistics
 
Original:
 $5,690,000
Days:
 295 List Date: 03-04-2008
Monthly Tax:
 $0 Year: 2007
Change:
 $0   0.00%
Zoning:
 51 - AG-1 RESTRICTED AGRICULTUR
Land:
 FS - FEE SIMPLE
TMK:
 1-6-6-015-003-0000
View:
 Mountain, Other, Sunset
Frontage:
 Stream/canal, Waterfront
 
Remarks:
 Almost 30 acres with over 1,200 lineal feet of waterfront (on navicable river). Two Parcels; One on Haleiwa Beach Road just north of 'Long Bridge' conisting of 12.212 Acres (tmk 1/6/6/15/3) w/adjacent lot off Aukai Ln consisting of 15.867 Acres (tmk 1/6/6/15/4). Some Ag-Use may be required upon completion of Farm Dwellings. Sale must be of both parcels together. Utilities: Electric, Overhead Electricity, Public Water, Telephone Disclosures: Listor Owner, Property Disclosure Stmt Listing Courtesy: Sterman Realty
 
Sold Price:
 $0
Land:
 $0
Flood Zone:
 V
Closed:
Improvements:
 $0
Land Use:
Agricultural
Sold Ratio:
 0%
Assessed Total:
 $0
Possible Use:
Farm, Nursery, Single Family
   
Assessed Ratio:
0%
Improvements:
 Access Rd
 
Elementary:
 Haleiwa
Lot Desc.
Wooded
Location:
 CORNER, DEAD END, OTHER
Middle:
 Waialua
Number of Lots:
Subdivide Possible, Two
Restrictions:
 51 - AG-1 RESTRICTED AGRICULTUR
High:
 Waialua
Road Frontage:
County Rd, Graded, Paved Rd
Set-Backs:
 C&C, SPECIAL
 
Structures:
Land Recorded:
 Land Court
Easements:
 Drainage
St. Width:
Lot #:
Terms:
 Cash, Conventional
Lot Dim.
   
Topography:
 Gentle Slope, Level
 
Nearby
 Neighborhoods: Kawailoa, Haleiwa, Pupukea, Paalaakai, Sunset/velzy, Sunset Area, Mokuleia
Comparables: Neighborhood, Neighborhood & Land Sq. Ft.
Links:
 Map, Schools, Hospitals, Restaurants, Gyms, Tax, Parcel, Permits, Tax Map, Sex Offender, Census, Local Schools, Zillow
Commuting:
 Waikiki, Downtown, Ala Moana, Airport, Kapolei, Hawaii Kai, Kailua Town, Windward Mall, Waikele, North Shore

For information on this property or to schedule a showing contact OahuRE.com

Printer Friendly View with Photo or without a photo.

Top  Previous  

History for this MLS#: 2803855

Date Field Name Old Value New Value
March 4, 2008, 11:20 am Status Not Listed Active
December 23, 2008, 11:13 am Status Active Withdrawn

History of other MLS#'s for this property since January 2004:

List Date MLS# TMK Status Days Original Price Sold
February 21, 2007 1-6-6-015-003-0000 EXPIRED 366 $5,690,000 $5,690,000 $0

Add this property to my Watch List * View Mortgage Spreadsheet * Top of Page

Copy and paste the links below into your Email to send this property to anyone.

http://www.OahuRE.com/MLSNUM2803855P4 * http://www.OahuRE.com/mobile/MLSNUM2803855P4

History of Sales from Honolulu Property Tax


Page Navigation: << Prev  1 Next >>


Sorted by LISTSTATUS ASC, LISTPRICE ASC Records Found: 1

Copy these links to send this page via Email: View properties on OahuRE.com * View properties on OahuRE.com Mobile

Searching for MLSNUM IN ('2803855')

Printer friendly view with photos or without photos. * Remember you can add this search to your Favorites / Bookmarks

Page Navigation: << Prev  1 Next >>

Averages for 1 WITHDRAWN Listings
Days on Market:
 295
Assessed Improvements:
 $0
List Price:
 $5,690,000
Assessed Land:
 $0
Sold Price / Ratio:
 $0 / 0.00%
Assessed Value:
 $0
Land:
 531,954
Assessed Ratio:
 0.00%
Interior:
 0
Tax:
 $0
Year Built:
 0
Beds:
 0
Average Land:
 $11
Average Interior:
 $0


Contact

Website Designed and Built by Bryn Kaufman



Information is based on data available to the associate, including county records. The information has not been verified by the associate and should be verified by the buyer.

Based on the information from the Multiple Listing Service of the Honolulu Board of REALTORS® active listings last updated on 01.09.09. Information is deemed reliable but not guaranteed. Copyright: 2007 by the Honolulu Board of REALTORS®.

IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

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.