NOT LISTED FOR SALE

Estimated Value: $3,949,332 - $5,109,000

5 Beds
10 Baths
12,426 Sq Ft
$352/Sq Ft Est. Value

Last Sold May 06, 2020

Last sale price $3,450,000 $278 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $27,275/month

131 Days on Market

Highlights

  • Primary Bedroom Suite
  • Colonial Architecture
  • Formal Dining Room
  • Myra S. Barnes Intermediate School 24 Rated A
  • Fireplace in Primary Bedroom
  • Balcony

About This Home

As of May 2020

ENTERTAIN YOUR MOST DISCRIMINATING GUESTS IN THIS MAJESTIC ALL BRICK NEO COLONIAL GEORGIAN ARCHITECTURAL MASTERPIECE THAT FEATURES VOLUME CEILINGS (10' FIRST FLOOR/9' SECOND FLOOR) DOUBLE STORY GRAND FOYER WITH CINDERELLA DUAL STAIRCASE PERFECT FOR ENTERTAINING, SEPARATE REAR STAIRCASE. LUXURIOUS MARBLE FLOORING & BRAZILIAN CHERRY W/CUSTOM INLAYS,RADIANT HEAT ON ALL TILED SURFACES. COFFERED CEILINGS IN DINING ROOM,LIVING ROOM, ALL MAHOGANY LIBRARY W/BUILT IN BOOK CASES, CUSTOM MOLDINGS AND WAINSCOATING THROUGHOUT. CHEFS DREAM KITCHEN W/PROFESSIONAL APPLIANCES, GRANITE COUNTER TOPS & LARGE CENTER ISLAND .BUTLERS PANTRY & SEPARATE DINETTE W/TURRET CEILINGS. DUAL LAUNDRY FACILITIES ON 1ST & SECOND FLOORS, GAS BURNING FIREPLACES IN DINING ROOM ,DOUBLE FORMAL LIVING ROOMS & MASTER SUITE SPACIOUS FAMILY RM W/WOOD BURNING FIREPLACE PROFESSIONAL GRANITE WET BAR, CUSTOM DESIGNED PIANO ROOM,FIRST LEVEL FEATURES TWO HALF BATHS AND ONE FULL BATH OFF THE STUDY,SECOND LEVEL FEATURES 5 BEDROOMS ,EACH HAS THEIR OWN FULL BATH, LAVISH MASTER SUITE W/LARGE HIS & HERS WALK IN CLOSETS W/CUSTOM SHELVING,BONUS LOFT ABOVE MASTER BEDROOM,FULLY FINISHED BASEMENT W/RADIANT HEAT, HOME THEATRE ROOM,STEAM ROOM, WINE CELLAR ,3 CAR GARAGE, PAVERED SEMI-CIRCULAR DRIVEWAY W/SEPARATE SERVICE ENTRANCE & MUDROOM, CABANA BATH W/SHOWER,REAR YARD FEATURES CUSTOM GAS GRILL W/GAS GRILL LINE HOOKUP, NILES HOME AUDIO SYSTEM & SECURITY CAMERAS.EVERY DETAIL HAS BEEN METICULOUSLY CRAFTED, ABSOLUTELY BREATHTAKING.

Last Listed By

Joann Dellarocca

Connie Profaci Realty License #30DE0539539 Listed on: 09/06/2019

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,006

Year Built

  • Built in 2007

Lot Details

  • 0.42 Acre Lot
  • Lot Dimensions are 175 x 100
  • Fenced
  • Sprinkler System
  • Back, Front, and Side Yard
  • Property is zoned R-3X

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • On-Street Parking
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 12,426 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Living Room with Fireplace
  • Formal Dining Room
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Microwave
  • Freezer
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Balcony
  • Patio
  • Outdoor Gas Grill

Utilities

  • Heating System Uses Natural Gas
  • Hot Water Baseboard Heater
  • 220 Volts

Listing and Financial Details

  • Legal Lot and Block 0052 / 00876
  • Assessor Parcel Number 00876-0052

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,006

Year Built

Built in 2007

Lot Details

0

Parking

3

Listing Details

  • Property Sub Type: Single Family - Detached
  • Prop. Type: Residential
  • Lot Size Acres: 0.42
  • Lot Size: 175 X 100
  • Modification Timestamp: 2024-09-21
  • Directions: TODT HILL/CIRCLE ROAD
  • Architectural Style: Colonial
  • Garage Yn: Yes
  • New Construction: No
  • Building Stories: 2
  • Year Built Details: Approx
  • Year Built: 2007
  • General Property Info:Style2: Colonial
  • General Property Info:_three_4 Baths: 1
  • General Property Info:Half Baths: 2
  • General Property Info:Public Remarks3: ENTERTAIN YOUR MOST DISCRIMINATING GUESTS IN THIS MAJESTIC ALL BRICK NEO COLONIAL GEORGIAN ARCHITECTURAL MASTERPIECE THAT FEATURES VOLUME CEILINGS (10' FIRST FLOOR/9' SECOND FLOOR) DOUBLE STORY GRAND FOYER WITH CINDERELLA DUAL STAIRCASE PERFECT FOR ENTERTAINING, SEPARATE REAR STAIRCASE. LUXURIOUS MARBLE FLOORING & BRAZILIAN CHERRY W/CUSTOM INLAYS,RADIANT HEAT ON ALL TILED SURFACES. COFFERED CEILINGS IN DINING ROOM,LIVING ROOM, ALL MAHOGANY LIBRARY W/BUILT IN BOOK CASES, CUSTOM MOLDINGS AND WAINSCOATING THROUGHOUT. CHEFS DREAM KITCHEN W/PROFESSIONAL APPLIANCES, GRANITE COUNTER TOPS & LARGE CENTER ISLAND .BUTLERS PANTRY & SEPARATE DINETTE W/TURRET CEILINGS. DUAL LAUNDRY FACILITIES ON 1ST & SECOND FLOORS, GAS BURNING FIREPLACES IN DINING ROOM ,DOUBLE FORMAL LIVING ROOMS & MASTER SUITE
  • ContractLocation Information:List PriceSqFt2: 313.78
  • ContractLocation Information:End Unit: No
  • General Property Info:Tax Abated: No
  • General Property Info:Year Built Description: Approx
  • General Property Info:Condition: Excellent
  • General Property Info:Fireplace: Yes
  • Appliances Refrigerators: Yes
  • Appliances Dryer: Yes
  • Appliances Microwave: Yes
  • Washers: Yes
  • General Property Info Bldg Dimensions: 109 X 57
  • General Property Info Handicap Access: No
  • Special Features: None
  • Stories: 2
  • Year Built: 2007

Interior Features

  • Appliances: Dishwasher, Dryer, Freezer, Gas Grill, Microwave, Refrigerator, Washer
  • Full Bathrooms: 7
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Living Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: Central Vac, Fireplace, Security System, Walk-in Closet, Wet Bar, Walk-In Closet(s)
  • General Property Info:Stories2: 2.0
  • General Property Info:Total Rooms Main Unit: 12
  • General Property Info:Basement Type: Full
  • Kitchen:Eat In: Yes
  • Main Bath:Full Bath: Yes
  • Dining Room:Separate: Yes
  • Living Room:Separate2: Yes
  • Appliances Dishwasher: Yes
  • Dining Room:Formal: Yes
  • Interior:Walk-in Closet: Yes
  • Living Room:Formal2: Yes
  • Interior:Wet Bar: Yes
  • Interior:Fireplace5: Yes
  • Interior:Security System: Yes
  • Living Room:Fireplace3: Yes
  • Appliances:Gas Grill: Yes
  • Interior:Central Vac: Yes
  • Appliances:Freezer: Yes
  • Primary Bedroom:Walk-In Closet2: Yes
  • Primary Bedroom Private Bath: Yes
  • Primary Bedroom Suite: Yes
  • Primary Bedroom Jacuzzi: Yes
  • Primary Bedroom Fireplace4: Yes
  • General Property Info Basement Desc: Finished

Exterior Features

  • Lot Features: Back, Front, Side
  • Construction Type: Brick
  • Exterior Features: Balcony, Fence, Garage Door Opener, Grill, Patio, Sprinkler System
  • General Property Info:Waterview: No
  • Exterior:Fence: Yes
  • Yard:Back: Yes
  • Yard:Side: Yes
  • Siding:Brick: Yes
  • Yard:Front: Yes
  • Exterior:Balcony: Yes
  • Exterior:Grill: Yes
  • Exterior:Patio: Yes
  • Exterior:Sprinkler System: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features: Off Street, On Street
  • General Property Info:Garage Location: Built-in
  • Parking:Off Street: Yes
  • Garage Location:Built-in: Yes
  • Parking:On Street: Yes
  • Exterior:Garage Door Opener: Yes

Utilities

  • Heating: Hot Water, Natural Gas
  • Heating Yn: Yes
  • Electric: 220 Volts
  • Sewer: City
  • General Property Info:No of Heating Units: 2.0
  • General Property Info:Air Conditioner: Central
  • Sewer:City3: Yes
  • Electric:_two_20: Yes
  • Heat Source:Gas2: Yes
  • Heat System:Hot Water2: Yes
  • General Property Info Cable: Yes
  • General Property Info Cooling: Yes

Lot Info

  • Lot Size Sq Ft: 18250.0
  • Lot Size Units: Square Feet
  • Parcel #: 00876-0052
  • Zoning: R-3X
  • ResoLotSizeUnits: SquareFeet
  • General Property Info:Lot Size SqFt: 18250.0
  • General Property Info:Lot Dim: 175 X 100

Rental Info

  • General Property Info Main Unit Lease: No

Tax Info

  • Tax Annual Amount: 27006.0
  • Tax Block: 00876
  • Tax Lot: 0052
  • General Property Info:Taxes2: 27006.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 6, 2019
Closed on
May 5, 2020
Sold by
Berman Keith and Berman Urmilla Dookhan
Bought by
Friedhoff Jason A and Friedhoff Jessica M
Seller's Agent
Joann Dellarocca
Connie Profaci Realty
Buyer's Agent
John Vernazza
Casandra Properties, Inc
List Price
$3,899,000
Sold Price
$3,450,000
Premium/Discount to List
-$449,000
-11.52%
Total Days on Market
131
Current Estimated Value
$4,368,833

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$918,833
Avg. Annual Appreciation
3.93%
Original Mortgage
$3,104,655
Outstanding Balance
$2,788,228
Interest Rate
3.2%
Mortgage Type
New Conventional
Estimated Equity
$1,402,742

Purchase Details

Closed on
Sep 27, 2004
Sold by
Laforgia Joseph and Laforgia Frank
Bought by
Berman Keith S and Dookhan Urmilla D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
5.68%
Mortgage Type
Unknown

Range of Values:

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
Friedhoff Jason A $3,450,000 Amtrust Title Insurance Co
Berman Keith S $1,400,000 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Friedhoff Jason A $3,104,655
Previous Owner Berman Keith S $1,000,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/06/2020 05/06/20 Sold $3,450,000 -11.5% $278 / Sq Ft
01/15/2020 01/15/20 Pending -- -- --
09/06/2019 09/06/19 For Sale $3,899,000 -- $314 / Sq Ft
Source: Staten Island Multiple Listing Service

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
2024 $33,846 $247,980 $22,588 $225,392
2023 $32,286 $158,976 $21,121 $137,855
2022 $31,736 $250,020 $33,240 $216,780
2021 $33,206 $207,000 $33,240 $173,760
2020 $31,508 $248,760 $33,240 $215,520
2019 $29,376 $216,240 $33,240 $183,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Staten Island Multiple Listing Service

MLS Number: 1132022

Staten Island Multiple Listing Service

APN: 00876-0052