Landlord's Agent in 2025
Rosemarie Campi
Prominent Properties Sotheby's International Realty-Alpine
(201) 741-9939
8 in this area
34 Total Sales
38 Overlook Rd Alpine, NJ 07620
Estimated Value: $2,696,858 - $3,231,000
5
Beds
4.5
Baths
--
Sq Ft
2005
Built
Highlights
- Multiple Fireplaces
- En-Suite Primary Bedroom
- Washer and Dryer
- Alpine Elementary School Rated A+
- Baseboard Heating
About This Home
As of October 2025THIS STATELY COLONIAL IS LOCATED ON ONE OF ALPINE'S MOST DESIRABLE STREETS. THIS PRISTINE RESIDENCE SHOWCASES OVER 6500 SQUARE FEET OF LUXURIOUS LIVING SPACE COMPLELE WITH 12 ROOMS, 5 SPACIOUS BEDROOMS AND 4.5 BATHS. THE GRAND TWO STORY FOYER SETS THE TONE FOR THE FIRST LEVEL OFFERING A FORMAL LIVING ROOM WITH FIREPLACE, FAMILY ROOM WITH FIREPLACE, LIBRARY/OFFICE, BANQUET DINING ROOM, A TRUE GORMET KITCHEN WITH THE BREAKFAST ROOM OVERLOOKING THE PRIVATE GROUNDS AND A POWDER ROOM. THE SECOND LEVEL IS COMPLETE WITH A SERENE AND TRANQUEL PRIMARY SUITE WITH SITTING AREA/ FIREPLACE AND A LUXURIOUS ONYX BATH PLUS AN ENSUITE GUEST ROOM AND TWO LARGE BEDROOMS WITH A DUAL BATH. THE SUN-FILLED LOWER LEVEL OFFERS A RECREATION ROOM, MEDIA AREA, GYM AND BEDROOM AND BATH WITH EXIT OUT. COMPLETE WITH ALL AMENITIES, HIGH DETAILED CEILINGS, GLEAMING HARDWOOD FLOORS AND SECURITY SYSTEM. ENJOY THE PRIVATE GROUNDS AND PATIO. THIS HOME IS CONVENIENTLY LOCATED TO SCHOOLS, SHOPPING AND PARKS JUST 7 MILES FROM NEW YORK CITY.
Last Agent to Rent the Property
Prominent Properties Sotheby's International Realty-Alpine Listed on: 07/25/2025
Last Renter's Agent
Prominent Properties Sotheby's International Realty-Alpine Listed on: 07/25/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $16,705
Year Built
- 2005
Parking
- 4 Open Parking Spaces
- 3 Car Garage
Interior Spaces
- Multiple Fireplaces
- Gas Fireplace
- Washer and Dryer
Kitchen
- Gas Oven or Range
- Microwave
- Dishwasher
Bedrooms and Bathrooms
- 5 Bedrooms
- En-Suite Primary Bedroom
Utilities
- Cooling System Powered By Gas
- Baseboard Heating
- Heating System Uses Natural Gas
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 11, 2017
Sold by
Mahanian Parvanech
Bought by
Sharma Indu and Sharma Viveek
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,250,000
Outstanding Balance
$629,526
Interest Rate
3.78%
Mortgage Type
Unknown
Estimated Equity
$2,416,427
Purchase Details
Closed on
Sep 28, 2004
Sold by
Scrimmager Leon
Bought by
Mahanian Yaghoub and Mahanian Parvaneh
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$940,000
Interest Rate
5.85%
Purchase Details
Closed on
Sep 21, 2000
Bought by
Scrimmager Leon
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
7.81%
Purchase Details
Closed on
Feb 16, 1995
Sold by
Est Erwin & Marie Eckstein
Bought by
Scrimmager Leon and Scrimmager Arlene
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$396,000
Interest Rate
9.17%
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sharma Indu | $2,100,000 | -- | |
| Mahanian Yaghoub | $1,175,000 | -- | |
| Scrimmager Leon | -- | -- | |
| Scrimmager Leon | -- | -- | |
| Scrimmager Leon | $440,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Sharma Indu | $1,250,000 | |
| Previous Owner | Mahanian Yaghoub | $940,000 | |
| Previous Owner | Scrimmager Leon | $550,000 | |
| Previous Owner | Scrimmager Leon | $396,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 10/28/2025 10/28/25 | Rented | -- | -- | -- |
| 08/13/2025 08/13/25 | Price Changed | $12,995 | -7.2% | -- |
| 07/25/2025 07/25/25 | For Rent | $14,000 | -- | -- |
Source: New Jersey MLS
Tax History Compared to Growth
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 | $16,705 | $2,042,200 | $850,000 | $1,192,200 |
| 2024 | $16,133 | $2,042,200 | $850,000 | $1,192,200 |
| 2023 | $15,664 | $2,042,200 | $850,000 | $1,192,200 |
| 2022 | $15,664 | $2,042,200 | $850,000 | $1,192,200 |
| 2021 | $15,868 | $2,042,200 | $850,000 | $1,192,200 |
| 2020 | $15,500 | $2,042,200 | $850,000 | $1,192,200 |
| 2019 | $15,909 | $2,042,200 | $850,000 | $1,192,200 |
| 2018 | $15,847 | $2,042,200 | $850,000 | $1,192,200 |
| 2017 | $9,295 | $1,160,400 | $850,000 | $310,400 |
| 2016 | $8,912 | $1,160,400 | $850,000 | $310,400 |
| 2015 | $8,935 | $1,160,400 | $850,000 | $310,400 |
| 2014 | $8,599 | $1,160,400 | $850,000 | $310,400 |
Source: Public Records
Agents Affiliated with this Home
-
Rosemarie Campi
Map
Source: New Jersey MLS
MLS Number: 25026219
APN: 02-00075-0000-00015
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Ten-X are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website.
All information deemed reliable but not guaranteed. Source: New Jersey Multiple Listing, Inc.
© 2025 New Jersey Multiple Listing Service Inc. All rights reserved.
Nearby Homes
- 46 Overlook Rd
- 35 Old Dock Rd
- 982 Closter Dock Rd
- 978 Closter Dock Rd
- 27 Alpine Dr
- 5 Ellens Way
- 11 Schaffer Rd
- 28 Schaffer Rd
- 32 Schaffer Rd
- 28 Ellen's Way
- 76 Church St
- 7 Schaffer Rd
- 10 Berkery Place
- 6 Frick Dr
- 14 Church St
- 38 Cambridge Way
- 4 Duck Pond Rd
- 44 Robin Ln
- 1 Stone Bridge Ct
- 6 Stone Bridge Ct