- 5 beds
- 5 baths
- 6,217 sqft
- ~3/4 acre lot
- $289 per sqft
- 2001 build
- – on site
Welcome to Grand Vista, a stunning 5-bedroom, 5-bath custom home offering 100+ feet of private frontage on beautiful Farrington Lake. With over 5,000 sq ft of finished living space, this lakefront gem combines luxury, comfort, and breathtaking views all just minutes from shopping, dining, and major commuter routes. Step into a grand entry with vaulted ceilings and panoramic lake views through dramatic Pella windows in the fireside family room. The elegant dining room and open-concept kitchen with a sunny breakfast area flow out to a raised deck perfect for lakeside dining or morning coffee. The main floor features a private guest suite with a fireplace and full bath. The walk-out lower level offers a state-of-the-art home theater, a second family room, library, full bedroom, two baths, and a bonus room ideal for a gym or office. Upstairs, the primary suite is a peaceful retreat with a sitting area, two walk-in closets, and spa-style bath, all overlooking the lake. Outside, enjoy a landscaped patio, direct lake access, and plenty of space to relax or entertain. Grand Vista is a rare opportunity to own a luxurious, move-in-ready lakefront home with every amenity. Schedule your private tour today!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 24, 2025
•
MLS# 3970651 —
This home is listed in more than one place. See it here.
The Building
-
Construction Date/Year Built:Standing
-
Construction Date/Year Built:2001
-
Style:Contemporary, Colonial, Custom Home
-
Primary Style:Contemporary
-
Roof Description:Asphalt Shingle
-
Exterior Description:Stucco
-
Basement:Yes
-
Handicap Modified:No
Interior
-
Interior Features:Carbon Monoxide Detector, Cathedral Ceiling, High Ceilings, Smoke Detector, Walk-In Closet, Window Treatments
-
Flooring:Carpeting, Tile, Wood
-
# of Rooms:23
-
Level 1 Rooms:3 Bedrooms, Attic, Bath(s) Other, Laundry Room, Storage Room
-
Level 2 Rooms:Attic
-
Level 3 Rooms:Attic
-
Kitchen Level:First
-
Kitchen Area:Center Island, Separate Dining Area
-
Living Room Level:First
-
Dining Room Level:First
-
Family Room Level:First
-
Basement Level Rooms:1 Bedroom, Bath(s) Other, Exercise Room, Media Room, Utility Room, Walkout
-
Basement Description:Finished, Walkout
-
Other Room 1 Level:First
-
Other Room 1:Great Room
-
Other Room 2 Level:Basement
-
Other Room 2:Media Room
-
Other Room 3 Level:First
-
Other Room 3:Laundry Room
-
Other Room 4 Level:First
-
Other Room 4:Foyer
-
Ground Level Rooms:1 Bedroom, Bath(s) Other, Dining Room, Family Room, Kitchen, Living Room
-
# of Fireplaces:1
-
Fireplace Description:Bedroom 1, Family Room
Room Dimensions
-
Living Room Dimensions:13x15
-
Kitchen Dimensions:16x26
-
Dining Room Dimensions:13x22
-
Family Room Dimensions:37 Sqft
-
Bedroom 1 Dimensions:16x24
-
Bedroom 2 Dimensions:14 Sqft
-
Bedroom 3 Dimensions:18x21
-
Bedroom 4 Dimensions:17x14
-
Other Room 1 Dimensions:28x18
-
Other Room 2 Dimensions:17x12
-
Other Room 3 Dimensions:11x8
-
Other Room 4 Dimensions:11x20
Financial & Terms
-
Possession:At Closing
Location
-
Directions:Route 130 To Washington, Right on Miriam, Left on Pershing
-
Latitude:40.43951
-
Longitude:-74.46914
The Property
-
Property Subtype:Single Family
-
Approx Lot Size:131 Sqft
-
Lot Description:Cul-De-Sac, Lake Front, Waterfront
-
Approx SqFt:6,217 Sqft
-
Total Acres:0 Sqft
-
Lot Identifier:32.07
-
Zoning:R1
-
Exterior Features:Curbs, Deck, Open Porch(es), Patio, Storm Door(s), Storm Window(s)
-
Easements:Unknown
-
Assessment Land:150000
-
Assess Amount Land Tax:*
Listing Agent
- Contact info:
- Agent phone:
- (732) 752-2222
- Office phone:
- (908) 654-6666
Taxes
-
Tax ID:*
-
Tax ID For Property:2114-00227-0000-00032-0007-
-
Tax Year:2024
-
Tax Year:*
-
Tax Rate:*
-
Tax Rate Year:2024
-
Tax Rate Amount:6.336
-
Tax Amount:$25,344
-
Tax Amount:$*
-
Lot ID Tax:*
-
Lot Size Tax:*
-
Acres Tax:$*
-
Block ID Tax:*
-
City Tax:$*
-
City Code Tax:*
-
County Tax:$*
-
County Code Tax:*
-
Zip Code Tax:*
Beds
-
# of Bedrooms:5
-
Master Bedroom Description:1st Floor, Dressing Room, Fireplace, Full Bath, Sitting Room, Walk-In Closet
-
Bedroom 1 Level:Second
-
Bedroom 2 Level:Second
-
Bedroom 3 Level:Second
-
Bedroom 4 Level:Ground
Baths
-
# of Baths:5.00
-
# of Full Baths:5
-
Master Bath Features:Jetted Tub, Stall Shower And Tub
Heating & Cooling
-
Cooling:Attic Fan, Ceiling Fan, Central Air, Multi-Zone Cooling
-
Heating:Forced Hot Air, Multi-Zone
-
Water Heater:Gas
Utilities
-
Utilities:All Underground
-
Water:Public Water
-
Fuel Type:Gas-Natural
-
Sewer:Public Sewer
Appliances
-
Appliances:Carbon Monoxide Detector, Cooktop - Gas, Dishwasher, Dryer, Jennaire Type, Kitchen Exhaust Fan, Microwave Oven, Range/Oven-Gas, Sump Pump, Trash Compactor, Wall Oven(s) - Electric, Washer
Schools
-
High School:N.BRUNSWK
The Community
-
Section/Subdiv/Development:Cedar Manor Estates
-
Community Living:No
-
Services:Cable TV, Garbage Included
-
Amenities:Exercise Room, Lake Privileges
-
Assessment Total:400000
-
Assessment Total Tax:*
-
Assessment Bldg:250000
-
Assess Amount Building Tax:*
Parking
-
# of Garage Spaces:3
-
Garage Description:Attached Garage, Garage Door Opener, Garage Parking, Oversize Garage
-
# of Parking Spaces:8
-
Parking/Driveway Description:Blacktop
Extra Units
-
In-Law Suite:No
Monthly cost estimate

Asking price
$1,799,999
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$9,638
|
Taxes | N/A |
Insurance | $494 |
Utilities | $266 See report |
Total | $10,398/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/20/25
Jun 20, 2025
|
Listed / Active | GSMLS | $1,799,999 | |
6/19/25
Jun 19, 2025
|
Coming Soon | GSMLS | $1,799,999 | |
3/23/24
Mar 23, 2024
|
Listed / Active | GSMLS |