Search Open Houses Buyer's Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


Do Not Use 62150 Emerson Road Unit B2 Haleiwa HI 96712

This property was withdrawn and is not for sale.

$499,000 | OahuRE Rebate $2,994 | VA Loan 1% Rebate $4,990 | Withdrawn

Listed on 06-08-2005 * 34 Days until Withdrawn on 07-12-2005

1 Bedroom, 1 Full Bath, 0 Half Baths, 1 Parking Spaces

440 Square Feet Living * 4,312 Square Feet Land

Sell for a $3,500 Flat Fee or 2% with full service.

Contact us for a showing.

Property Last Viewed: 06/16/2021 03:32 PM, Total Views Today: 0, Total Views: 155, Viewed History

Save This Property to Receive Automatic Email Updates When the Status Changes

Short Cuts

Update the default down payment and interest rate.



OahuRE.com Notes About This Property

View all new listings in the Haleiwa neighborhood since this property was listed.

Listed previously on April 27, 2020 for $628,000. View Details

Listed previously on April 27, 2020 for $628,000. View Details

Listed previously on January 13, 2017 for $595,000. View Details

Listed previously on May 7, 2009 for $389,000. View Details

Listed previously on August 25, 2005 for $369,000. View Details

Listed previously on October 6, 2004 for $225,000. View Details

Withdrawn previously on December 7, 2020 after 125 days on market. View Details

Fell out of escrow 2 times. View Details

Price Decreased 7 times. View Details

Withdrawn 3 times. View Details

Expired 2 times. View Details

Price trends for Haleiwa.

There were 12 homes sold in the last 2 years in the Haleiwa neighborhood.


Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 2 * Previous * Next

Learn More About Our Selling Options

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 3 * Previous * Next

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 4 * Previous * Next

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 5 * Previous * Next

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 6 * Previous * Next

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 7 * Previous * Next

Do Not Use 62150 Emerson Road  Unit B2

Details * Showing Request * Top * 8 * Previous

Older Photos From A Previous Listing

Do Not Use 62150 Emerson Road  Unit B2

Do Not Use 62150 Emerson Road  Unit B2

View additional older photos

Property Details

Top of Page * Showing Request * Questions?


MLS#: 2507913 * Questions?
Status: Withdrawn
Price: $499,000
Rebate: $ 2,994 from OahuRE.com. * VA Loan 1% Rebate 2,994
Monthly: $ 2,010.17 Update the default down payment and interest rate
  Monthly payment estimate for $ 499,000 price, 10% down, 3.11% interest rate, 30 year loan, $ 90 taxes, and $ 0 fees. Insurance not included.
Beds: 1   Baths: 1   Half: 0  Parking Spaces: 1
Living Sq Ft: 440
Land Sq Ft: 4,312
Land Tenure: FS - Fee Simple
Address: 62150 Emerson Road B2 Haleiwa HI 96712
Region: North Shore - Activity
Neighborhood: Haleiwa - Activity * Haleiwa Stats
Street: Emerson - Activity * Emerson Road Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $492,000
Change: $7,000    1.42%
Parcel#: 1-6-2-012-009-0004
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 35 days in Active or In Escrow Showing
Date: Listed: 06-08-2005
Date: Status Change: 07-12-2005
Year Built: 1939 Remodeled: 2005
View: Mountain
Frontage: Stream/Canal
Monthly Tax: $90 Year: 2005
Land: FS - Fee Simple
Condition: Above Average

Top of Page * Showing Request * Questions?

Description:

NORTH SHORE - Haleiwa Town - walk to Matsumoto shave ice, beach: centrally located. Private backyard off the Anahulu River; tropical front yard and deck area. New wood floors. Super cozy attached house - BEST DEAL ON OAHU! Note: has a CPR but no management company, maint. fee, assoc., etc. Listed as Single Family Home as well. There will be a $2,000 credit for new windows.

 
 
Inclusions: Cable TV, Ceiling Fan, Range/Oven, Refrigerator

Amenities: None

Utilities: Construction: Wood Frame Lot Features: Floor: Hardwood, W/W Carpet Disclosures: Inactive Licensed Owner, Property Disclosure Stmt Land Recorded: Land Court Furnished: None

Possession: At Closing Terms: Cash, Conventional Sale Conditions:

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $243,500
Building: $43,100  
Assessed Total: $286,600  
Assessed Ratio: 174.11%
Pool:
Location:
Parking: Assigned

Top of Page * Showing Request * Questions?

District Locator: DOE Locator to Confirm District
Area Total: 4,312
Acres: 0.0990
Topography:
Building Style: No Unit Above or Below
Building: Do not use
New Const: No

Top of Page * Showing Request * Questions?

Maint. Fee: $0
Assoc. Fee: $0
Other Fee: $0
Includes: Other Common Expenses
Total Fees: $0
Exemption: 0
Other: 0
Lanai Sq Ft: 170
Garage Sq Ft: 0
Avg Sq Ft Living: $1,134.09
Avg Sq Ft Land: $115.72
Security:
Rental Income: $0
Stories: CPR: No
Zoning:
Flood Zone: Zone X * Check if this property is in a Flood Zone
Tsunami Zone: Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map
Roofing:
Set-Backs: Roads:
Easements:

Top of Page * Showing Request * Questions?

Links:
Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch
Commuting:
Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore
Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info
Closing Cost Calculators:
Buyer's Closing Cost Calculator to estimate the buyer's closing cost.
Seller's Closing Cost Calculator to estimate the seller's closing cost.

Listing courtesy of Doug Davis Realty Inc.

Top of Page * Showing Request * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
12-07-2020 202008805 Withdrawn Active Withdrawn $628,000 $0 $517,500 $408,700 $10,880
12-07-2020 202008805 Back On Market Active Active $628,000 $0 $517,500 $408,700 $10,880
11-12-2020 202008804 Sold Active Sold $628,000 $541,000 $517,500 $408,700 $10,880
08-30-2020 202008804 In Escrow Not Showing Active In Escrow Not Showing $628,000 $541,000 $517,500 $408,700 $10,880
08-30-2020 202008805 In Escrow Not Showing Active In Escrow Not Showing $628,000 $0 $517,500 $408,700 $10,880
04-27-2020 202008805 New Listing Active Active $628,000 $0 $517,500 $408,700 $10,880
04-27-2020 202008804 New Listing Active Active $628,000 $541,000 $517,500 $408,700 $10,880
05-14-2017 201700627 Expired Active Expired $595,000 $0 $352,800 $298,000 $54,800
01-13-2017 201700627 New Listing Active Active $595,000 $0 $352,800 $298,000 $54,800
05-08-2010 2906330 Expired Active Expired $429,000 $0 $337,100 $305,600 $31,500
08-05-2009 2906330 Price Increase $384,000 $429,000 $429,000 $0 $337,100 $305,600 $31,500
06-05-2009 2906330 Price Decrease $389,000 $384,000 $429,000 $0 $337,100 $305,600 $31,500
05-07-2009 2906330 New Listing $389,000 Active $429,000 $0 $337,100 $305,600 $31,500
01-05-2006 2513950 Sold In Escrow Showing Sold $319,000 $329,000 $286,600 $243,500 $43,100
09-29-2005 2513950 In Escrow Showing Active In Escrow Showing $319,000 $329,000 $286,600 $243,500 $43,100
09-19-2005 2513950 Price Decrease $349,000 $319,000 $319,000 $329,000 $286,600 $243,500 $43,100
09-12-2005 2513950 Price Decrease $369,000 $349,000 $319,000 $329,000 $286,600 $243,500 $43,100
08-25-2005 2513950 New Listing $369,000 Active $319,000 $329,000 $286,600 $243,500 $43,100
07-12-2005 2507913 Withdrawn Active Withdrawn $499,000 $0 $286,600 $243,500 $43,100
07-12-2005 2507913 Price Increase $382,000 $499,000 $499,000 $0 $286,600 $243,500 $43,100
07-12-2005 2507913 Back On Market Withdrawn Active $499,000 $0 $286,600 $243,500 $43,100
07-12-2005 2507913 Price Decrease $499,000 $382,000 $499,000 $0 $286,600 $243,500 $43,100
07-08-2005 2507913 Withdrawn Active Withdrawn $499,000 $0 $286,600 $243,500 $43,100
07-07-2005 2507913 Price Increase $389,000 $499,000 $499,000 $0 $286,600 $243,500 $43,100
07-01-2005 2507913 Price Decrease $395,000 $389,000 $499,000 $0 $286,600 $243,500 $43,100
06-16-2005 2507913 Price Decrease $420,000 $395,000 $499,000 $0 $286,600 $243,500 $43,100
06-01-2005 2507913 Price Decrease $492,000 $420,000 $499,000 $0 $286,600 $243,500 $43,100
05-23-2005 2507913 New Listing $492,000 Active $499,000 $0 $286,600 $243,500 $43,100
12-07-2004 2415830 Sold $492,000 Sold $225,000 $225,000 $119,100 $105,600 $13,500

Top of Page * Showing Request * Questions?


Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Going more years back returns closer matches.

Last 6 Months Sold

Last 1 Year Sold

Last 2 Years Sold

Last 3 Years Sold

Similar Properties Sorted by Smallest Price Difference First

Listings in Do not use

Listings in Haleiwa Neighborhood

View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles

Top of Page * Showing Request * Questions?


City and County Public Information Links

City and County Logo

Tax Info including a Plat Map PDF and GIS Parcel Map

Department of Planning & Permitting General Information

Department of Planning & Permitting All Permits

Dept. of Emergency Management Public Safety Info

Tax Records and Property History in this Neighborhood

Tax Records and Property History on this Street

Building Sketch

Top of Page * Showing Request * Questions?


Sex Offender Information

Attorney General Logo

View a map of Sex Offenders for this Zip Code

Top of Page * Showing Request * Questions?


Daily Watch List

Add to Daily Watch List by Parcel Number

Top of Page * Showing Request * Questions?



Google Maps

View this property's location * Top of Page

View Nearby Schools on Google Maps - Preschools, Elementary Schools, Middle Schools, or High Schools

View Nearby Parks, Farmer's Markets, and Best Restaurants on Google Maps

Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park

View nearby Airbnb locations.

View Haleiwa Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the North Shore Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request * Questions?



Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

Top of Page * Showing Request * Questions?



View Directions on Google Maps to nearest Beach Access

View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info

Beach Access Map

Top of Page * Showing Request * Questions?



Google Earth

Neighborhoods Near Haleiwa Shown on Google Earth
 
Googe Earth View

Top of Page * Showing Request * Questions?



Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $21,063.93 of interest charges by adding an extra payment of $100 per month. View details from the link above.

Rate:
2.36% 2.61% 2.86% 3.11% 3.36% 3.61% 3.86% 4.11% 4.61%
0% Down
$1,936$2,000$2,066$2,134$2,202$2,271$2,342$2,414$2,561
3.5% Down
$1,868$1,930$1,994$2,059$2,125$2,192$2,260$2,330$2,471
10% Down
$1,742$1,800$1,860$1,920$1,982$2,044$2,108$2,173$2,305
20% Down
$1,548$1,600$1,653$1,707$1,762$1,817$1,874$1,931$2,049
30% Down
$1,355$1,400$1,446$1,493$1,541$1,590$1,640$1,690$1,793
40% Down
$1,161$1,200$1,240$1,280$1,321$1,363$1,405$1,448$1,537
50% Down
$968$1,000$1,033$1,067$1,101$1,136$1,171$1,207$1,281

Top of Page * Showing Request * Questions?



Crime Mapping

Last 7 days of crime (you can then change it to go back further)

Top of Page * Showing Request * Questions?



Yelp

Popular Yelp Links Sorted by Review Count Near Do Not Use 62150 Emerson Road Unit B2

Most Popular, Restaurants, Shopping, Arts & Entertainment, Active Life Activities

Top of Page * Showing Request * Questions?