NOT LISTED FOR SALE

18 Yellow Brook Rd Holmdel, NJ 07733

Estimated Value: $1,427,000 - $1,838,000

4 Beds
3.5 Baths
3,787 Sq Ft
$424/Sq Ft Est. Value

Last Sold September 09, 2013

Last sale price $1,117,500 $295 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $10,235/month

26 Days on Market

Highlights

  • Bay View
  • Custom Home
  • Wood Flooring
  • Village School Rated A
  • New Kitchen
  • Whirlpool Bathtub

About This Home

As of September 2013

Spectacular Custom Home Rebuilt & Expanded in 2006! Looking for NEW in Holmdel..make this your first stop! Spectacular kitchen w/SS GE Monogram 6 burner stove, top of the line cabinetry, granite cnters, center island, Spacious dinette area, great room w/dramatic ceiling & gas FP. Master Suite w/ luxury bath & WI closet. Finished basement w full bath. No expense spared in the reconstruction of this beautiful home! Taken down to studs and tastefully redone. Bring your most discriminating buyer.

Last Agent to Sell the Property

Fran Judas

Coldwell Banker Realty Brokerage Phone: 732-673-0197 License #7936245 Listed on: 07/05/2013

Coldwell Banker Realty

Last Buyer's Agent

Laurin LaLima

C21/ Mack Morris Iris Lurie License #0344204

C21/ Mack Morris Iris Lurie

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,727

Lot Details

  • Oversized Lot
  • Sprinkler System

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener
  • Double-Wide Driveway
  • Off-Street Parking

Home Design

  • Custom Home
  • Colonial Architecture
  • Asphalt Rolled Roof
  • Cedar Shake Siding
  • Shake Siding
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • 2-Story Property
  • Crown Molding
  • Ceiling Fan
  • Recessed Lighting
  • Light Fixtures
  • 1 Fireplace
  • Thermal Windows
  • Blinds
  • Bay Window
  • Window Screens
  • Sliding Doors
  • Entrance Foyer
  • Family Room
  • Sunken Living Room
  • Breakfast Room
  • Dining Room
  • Home Office
  • Home Gym
  • Center Hall
  • Bay Views
  • Home Security System

Kitchen

  • New Kitchen
  • Eat-In Kitchen
  • Double Oven
  • Gas Cooktop
  • Stove
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Dual Vanity Sinks in Primary Bathroom
  • Whirlpool Bathtub
  • Primary Bathroom Bathtub Only
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Dryer
  • Washer

Basement

  • Heated Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

  • Village Elementary School
  • William R. Satz Middle School
  • Holmdel High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Well
  • Natural Gas Water Heater
  • Septic Tank
  • Septic System

Community Details

  • No Home Owners Association
  • Falcons Ridge Subdivision

Listing and Financial Details

  • Exclusions: DINING ROOM FIXTURE, DRAPES IN GREAT ROOM
  • Assessor Parcel Number 00025000300023

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,727

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Attribution Contact: 732-673-0197
  • ResoLotFeatures: Oversized
  • Inclusions: Outdoor Lighting, Washer, Blinds/Shades, Ceiling Fan(s), Dishwasher, Dryer, Double Oven, Light Fixtures, Microwave, Security System, Stove, Stove Hood, Refrigerator, Screens, Garage Door Opener, Gas Cooking
  • Subdivision Name: Falcons Ridge
  • Architectural Style: Custom, Colonial
  • Reso Flooring: Ceramic Tile, W/W Carpet, Wood
  • Reso Interior Features: Bay/Bow Window, Center Hall, Dec Molding, Fitness, Sliding Door, Recessed Lighting
  • General Property Info Waterview: No
  • General Property Info Fireplace: Yes
  • General Property Info Basement: Yes
  • General Property Info HOA: No
  • General Property Info Pool: No
  • Interior Sliding Door: Yes
  • Kitchen Center Island: Yes
  • ExteriorPatio: Yes
  • Garage Direct Entry: Yes
  • Location Middle School: William R. Satz
  • Living Room Floor - Wood2: Yes
  • Dining Room Floor - Wood3: Yes
  • WaterSewer Well: Yes
  • Kitchen Newer: Yes
  • Cooling Central Air: Yes
  • Rooms Living Room: Yes
  • Included Gas Cooking: Yes
  • Included Stove: Yes
  • WaterSewer Public Water: Yes
  • Floors Ceramic Tile: Yes
  • Floors Wood: Yes
  • Water Heater Natural Gas2: Yes
  • Parking Double Wide Drive: Yes
  • General Property Info Handicap Access: No
  • General Property Info # Fireplaces: 1.0
  • Interior Dec Molding: Yes
  • Interior Recessed Lighting: Yes
  • Included BlindsShades: Yes
  • Included Light Fixtures: Yes
  • Included Stove Hood: Yes
  • Exterior Sprinkler Under: Yes
  • Exterior Thermal Window: Yes
  • Included Ceiling Fan(s): Yes
  • Included Outdoor Lighting: Yes
  • Included Screens: Yes
  • Kitchen Floor - Ceramic4: Yes
  • Kitchen Sliding Door5: Yes
  • Interior BayBow Window: Yes
  • Dining Room Dec Molding4: Yes
  • Kitchen GraniteStone Counter: Yes
  • Roof Timberline: Yes
  • Included Double Oven: Yes
  • Living Room Dec Molding3: Yes
  • Kitchen Eat-In: Yes
  • Basement Heated: Yes
  • Parking Oversized2: Yes
  • Included Security System2: Yes
  • GreatFamily Room Floor - WW Carpet4: Yes
  • Foyer Floor - Ceramic: Yes
  • Rooms Breakfast: Yes
  • Living Room BayBow Window2: Yes
  • Dining Room BayBow Window3: Yes
  • SidingCedarShake: Yes
  • Interior Fitness: Yes
  • Foyer Dec Molding2: Yes
  • GreatFamily Room Sunken3: Yes
  • Cooling 2 Zoned AC: Yes
  • Heating 2 Zoned Heat: Yes
  • Special Features: None

Interior Features

  • Basement: Ceilings - High, Full Finished, Heated
  • Basement: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Stories: 2
  • Other Rooms:Dining Room: Yes
  • Other Rooms:Family Room: Yes
  • Appliances Included:Dishwasher: Yes
  • Appliances Included:Refrigerator: Yes
  • Appliances Included:Dryer: Yes
  • Appliances Included:Washer: Yes
  • Appliances Included:Microwave: Yes
  • Other Rooms:Foyer: Yes
  • Kitchen Pantry: Yes
  • Other Rooms:Office2: Yes
  • Primary Bedroom:Floor - WW Carpet3: Yes
  • Primary Bedroom Level:Second43: Yes
  • Primary Bedroom:Full Bath: Yes
  • Primary Bath:Shower Stall: Yes
  • Primary Bath:Tub: Yes
  • Primary Bedroom:Walk-in Closet: Yes
  • Primary Bath Double Sinks: Yes
  • Primary Bath Whirlpool: Yes

Exterior Features

  • Roof: Timberline
  • Waterfront: No
  • Exclusions: DINING ROOM FIXTURE, DRAPES IN GREAT ROOM
  • Construction Type: Shake Siding
  • Exterior Features: Patio, Sprinkler Under, Thermal Window
  • Construction:Siding - Vinyl: Yes
  • ConstructionSiding:Stone: Yes

Garage/Parking

  • Garage: Yes
  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features: Paved, Double Wide Drive, Driveway, Off Street, Direct Access
  • General Property Info:Garage: Yes
  • ParkingOffStreet: Yes
  • Parking Driveway: Yes
  • Parking:Paved: Yes
  • _pound_ AppliancesIncluded:Garage Door Opener: Yes

Utilities

  • Sewer: Septic Tank
  • Cooling: Central Air, 2 Zoned AC
  • Cooling Y N: Yes
  • Heating: Natural Gas, Forced Air, 2 Zoned Heat
  • HeatingYN: Yes
  • Water Source: Public, Well
  • Heating:Natural Gas: Yes
  • Water/Sewer/Septic: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Middle Or Junior School: William R. Satz

Lot Info

  • Parcel #: 00025000300023
  • Zoning Description: Residential

Tax Info

  • Tax Year: 2012
  • Tax Annual Amount: 17727.0

MLS Schools

  • Elementary School: Village School
  • High School: Holmdel

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 5, 2013
Closed on
Sep 6, 2013
Sold by
Castiglia Anthony and Castiglia Christine
Bought by
Maio William Di and Maio Tracie Di
Seller's Agent
Fran Judas
Coldwell Banker Realty
Buyer's Agent
Laurin LaLima
C21/ Mack Morris Iris Lurie
Sold Price
$1,117,500
Current Estimated Value
$1,605,494

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$487,994
Avg. Annual Appreciation
2.97%
Original Mortgage
$894,000
Outstanding Balance
$639,013
Interest Rate
3.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Estimated Equity
$966,481

Purchase Details

Closed on
Aug 4, 2005
Sold by
Giamanco Christian
Bought by
Castiglia Anthony and Castiglia Christine

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$935,000
Interest Rate
5.11%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Nov 15, 1994
Sold by
Devt Acqua
Bought by
Marchese Michael and Marchese Nancy

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$345,000
Interest Rate
8.81%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Maio William Di $1,117,500 None Available
Castiglia Anthony $955,000 --
Marchese Michael $433,310 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Maio William Di $894,000
Previous Owner Castiglia Anthony $935,000
Previous Owner Marchese Michael $345,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/09/2013 09/09/13 Sold $1,117,500 -- $295 / Sq Ft
Source: MOREMLS (Monmouth Ocean Regional REALTORS®)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $22,770 $1,511,500 $630,300 $881,200
2024 $22,244 $1,444,800 $643,700 $801,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MOREMLS (Monmouth Ocean Regional REALTORS®)

MLS Number: 21323370

MOREMLS (Monmouth Ocean Regional REALTORS®)

APN: 20-00025-03-00023