#25011107, Charles Oppler, Listing Office: Prominent Properties Sothebys International Realty-Weehawken
#25009300·
Listing office: Prominent Properties Sothebys International Realty-Franklin Lakes·
Listing agent: Jamie A. Oakley·
Listing office phone: 201-848-4002
$3,799,000 List price
249 Terrace Rd Franklin Lakes, NJ 07417
5 beds
4 full, 1 partial
House
Property details
About 249 Terrace Rd
Stunning new construction set high atop Terrace Road with spectacular views. This custom home features 5 bedrooms, 4 and a half bathrooms, 3 car garage, an elevator, soaring 21 foot ceilings in the grand two story foyer and great room, a bridal staircase, 10 ft ceilings on the main floor, a luxurious primary suite, a finished basement and room for a pool. Roughly 6000 sq ft on the first and second floors and another 3000 sq ft on the lower level. You do not want to miss this one! Completion expected by early summer.
Highlights
Home typeSingle Family Residence
HeatingNatural Gas, Forced Air, Zoned
StatusActive
CoolingCentral Air
BasementYes
Year builtNew Const.
ParkingAttached
MLS #25009300
Attached garage3 spaces
Fireplace2 Fireplaces, Gas
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 4
- Basement: Yes
- Flooring Type: Hardwood
- Interior: Elevator
- Fireplace: 2 Fireplaces, Gas
- Total Bedroom Count: 5
- Garage Space: 3 spaces
- Attached Garage: Yes
- Parking: Attached
- Waterfront: None
- Exterior: Elevator
- Architectural Style: Colonial
- Heating: Natural Gas, Forced Air, Zoned
- Cooling: Central Air
- List Price: $3,799,000
- MLS Number: 25009300
- Office Name: Prominent Properties Sothebys International Realty-Franklin Lakes
- Office Phone: (201) 848-4002
- Listing Agent: Jamie A. Oakley
Disclaimer: 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 Rocket Homes Real Estate, LLC are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Information provided is for consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
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 Service, Inc. Copyright© 2025 New Jersey Multiple Listing Service, Inc. All rights reserved.
Rocket Homes Real Estate, 701 Griswold St, Suite 21, Detroit, MI 48226
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/4/2025, 9:45:34 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$3,799,000
249 Terrace Rd
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Jan 18, 2024 | Home Sold | $650,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $426,600 | $- |
History based on county public records data.
Nearby schools
8
Colonial Road School
Public District PK-5
0.8 mi
•749 Colonial Rd
5
High Mountain Road School
Public District PK-5
0.9 mi
•765 High Mountain Rd
7
Dogwood Hill Elementary School
Public District KG-5
1.7 mi
•25 Dogwood Dr
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $193,750. The most common annual income of people living in Franklin Lakes, NJ is $200k+. Residents typically live in married, no kids family. Typical level of education for residents in this area is post secondary degree.
How much money do the neighbors make?
3%
<35k
19%
35k-100k
31%
100k-200k
47%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
15%
Single, No Kids
4%
Single, with Kids
45%
Married, No Kids
36%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
15%
<11 yrs old
12%
12-17 yrs old
11%
18-34 yrs old
46%
35-64 yrs old
16%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
Men's Tennis- Tennis
Where do the neighbors shop?
Nordstrom
Bloomingdales
Brooks Brothers
Where do the neighbors go to eat?
California Pizza Kitchen
Bonefish Grill
Qdoba
What do the neighbors drive?
BMW
Lexus
Acura
What do the neighbors listen to?
Talk/Personality
News
Sports
All data provided by Home Junction and Claritas
Similar homes for sale
Tour
#24035347, Grazyna Ziarko, Listing Office: Christies International Real Estate Group-Franklin Lakes
#25002116, Gregory Earnshaw, Listing Office: Coldwell Banker, Wyckoff/Franklin Lakes
#3943517, Listing Office: COLDWELL BANKER REALTY WYK
#25016382, Tony Nabhan, Listing Office: Keller Williams City Views Realty
#25015725, Ellen Horowytz, Listing Office: Prominent Properties Sothebys International Realty-Franklin Lakes
Tour
#25000992, Grazyna Ziarko, Listing Office: Christies International Real Estate Group-Franklin Lakes
$10,000 Closing Credit¹
#25016601, Wendy Gronich, Listing Office: Compass New Jersey, LLC-Ridgewood
Tour
#25014914, Grazyna Ziarko, Listing Office: Christies International Real Estate Group-Franklin Lakes
6 days on Rocket
$10,000 Closing Credit¹
#25017882, Janine Fraser, Listing Office: Coldwell Banker, Allendale/Saddle River Valley
Frequently asked questions
About 249 Terrace Rd
The listing price of 249 Terrace Rd property is $3,799,000.
The property 249 Terrace Rd is a house located in Franklin Lakes, New Jersey, 07417.
Active Listing: 249 Terrace Rd is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 249 Terrace Rd are: Colonial Road School (GreatSchools Rating 8/10), High Mountain Road School (GreatSchools Rating 5/10), Dogwood Hill Elementary School (GreatSchools Rating 7/10), Franklin Avenue Middle School (GreatSchools Rating 9/10), Valley Middle School (GreatSchools Rating 7/10), Dwight D. Eisenhower Middle School (GreatSchools Rating 7/10), Indian Hills High School (GreatSchools Rating 6/10), Ramapo High School (GreatSchools Rating 8/10), Wayne Hills High School (GreatSchools Rating 8/10).
The last sale was on January 18, 2024 for $650,000 (source: MLS/tax record).
The property at 249 Terrace Rd has 5 bedrooms and 4 full and 1 half bathrooms.
This home is located at 249 Terrace Rd in Franklin Lakes, NJ and zip code 07417. Features: 5 bedrooms, 5 bathrooms. It has been listed on Rocket Homes since March 24, 2025 and is currently priced at $3,799,000.
While more than 2 listings in Franklin Lakes, NJ in May 2025 were sold above asking price, there were more than 1 listings sold at asking price, and more than 3 were sold below. The inventory of homes for sale in Franklin Lakes, NJ between April and May 2025 increased by 16.4%.
From Rocket Homes Real Estate and based on county public records data.