Seller's Agent in 2026
Rotem Lindenberg
Keller Williams Town Life
(646) 321-0186
55 Total Sales
589 Piermont Rd Demarest, NJ 07627
Estimated Value: $2,665,000 - $2,970,000
2
Beds
2
Baths
--
Sq Ft
21,344
Sq Ft Lot
Highlights
- In Ground Pool
- Views to the East
- Central Air
- County Road Elementary School Rated A-
- En-Suite Primary Bedroom
- Baseboard Heating
About This Home
As of December 2023New Construction Luxury Residence | Elevated Family Living | Resort-Style Lifestyle | Heated Swimming Pool Set on an expansive 0.5 acre property in one of Demarestâ€TMs most desirable locations, this exceptional new-construction residence offers approximately 4000 square feet plus 1400 square feet above ground basement of thoughtfully designed living space. The home seamlessly blends architectural presence, high-end finishes, and family-focused functionality, creating a refined yet welcoming lifestyle. Featuring 5 bedrooms, 5 full bathrooms, Sun room, Home office, guest Bedroom, dramatic ceiling heights, and expansive indoor–outdoor flow, this residence is designed for modern luxury living. Anticipated occupancy: March–April.
Last Agent to Sell the Property
Prominent Properties Sotheby's International Realty-Alpine Listed on: 10/17/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $16,298
Lot Details
- 0.49 Acre Lot
- Rectangular Lot
Parking
- 1 Car Garage
Home Design
- Brick Exterior Construction
Bedrooms and Bathrooms
- 2 Bedrooms
- En-Suite Primary Bedroom
- 2 Full Bathrooms
Schools
- County Road Elementary School
- Demarest Middle School
- Northern Valley Reg. High School
Utilities
- Central Air
- Baseboard Heating
- Heating System Uses Natural Gas
Additional Features
- Views to the East
- Basement Fills Entire Space Under The House
- In Ground Pool
Listing and Financial Details
- Legal Lot and Block 00006 / 00076
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 17, 2023
Closed on
Dec 2, 2023
Sold by
Aibel Donald J
Bought by
Lindenberg Nir
Seller's Agent
Dennis McCormack
Prominent Properties Sotheby's International Realty-Alpine
Buyer's Agent
Orly Chen
RE/MAX Properties Plus
List Price
$799,000
Sold Price
$799,000
Views
20
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$2,071,303
Avg. Annual Appreciation
76.99%
Original Mortgage
$560,000
Outstanding Balance
$550,597
Interest Rate
7.44%
Mortgage Type
New Conventional
Estimated Equity
$2,319,706
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 |
|---|---|---|---|
| Lindenberg Nir | $800,000 | Old Republic National Title | |
| Lindenberg Nir | $800,000 | Old Republic National Title |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Lindenberg Nir | $560,000 | |
| Closed | Lindenberg Nir | $560,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 01/13/2026 01/13/26 | For Sale | $3,000,000 | +275.5% | -- |
| 12/15/2023 12/15/23 | Sold | $799,000 | 0.0% | -- |
| 11/01/2023 11/01/23 | Pending | -- | -- | -- |
| 10/17/2023 10/17/23 | For Sale | $799,000 | -- | -- |
Source: New Jersey MLS
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 | $17,994 | $987,900 | $766,100 | $221,800 |
| 2024 | $17,175 | $588,600 | $403,200 | $185,400 |
| 2023 | $16,710 | $588,600 | $403,200 | $185,400 |
| 2022 | $16,710 | $588,600 | $403,200 | $185,400 |
| 2021 | $16,298 | $588,600 | $403,200 | $185,400 |
| 2020 | $15,916 | $588,600 | $403,200 | $185,400 |
| 2019 | $15,457 | $588,600 | $403,200 | $185,400 |
| 2018 | $14,980 | $588,600 | $403,200 | $185,400 |
| 2017 | $14,621 | $588,600 | $403,200 | $185,400 |
| 2016 | $14,391 | $588,600 | $403,200 | $185,400 |
| 2015 | $14,197 | $588,600 | $403,200 | $185,400 |
| 2014 | $13,891 | $588,600 | $403,200 | $185,400 |
Source: Public Records
Agents Affiliated with this Home
-
Rotem Lindenberg
-
Dennis McCormack
Seller's Agent in 2023
Dennis McCormack
Prominent Properties Sotheby's International Realty-Alpine
(201) 320-8787
4 in this area
55 Total Sales
-
Orly Chen
Buyer's Agent in 2023
Orly Chen
RE/MAX
(480) 200-5994
31 in this area
349 Total Sales
Map
Source: New Jersey MLS
MLS Number: 23032148
APN: 09-00076-0000-00006-02
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.
© 2026 New Jersey Multiple Listing Service Inc. All rights reserved.
Nearby Homes
- 41 Orchard Rd
- 22 Northwood Ave
- 232 County Rd
- 3 Central Ave
- 7 Central Ave
- 40 County Rd
- 543 Closter Dock Rd
- 11 Stone Bridge Ct
- 24 Stone Bridge Ct
- 2 Stone Bridge Ct
- 351 Closter Dock Rd
- 39 Drury Ln
- 504 High St
- 16 Poplar Rd
- 106 Prescott St
- 31 Madison Ave
- 22 Maplewood Rd
- 21 Meadow St
- 25 Maple Ave
- 52 Edward St
Your Personal Tour Guide
Ask me questions while you tour the home.