Redfin is joining Rocket

Discover how we're simplifying your journey home.

$999,000

247 N Main St Lambertville, NJ 08530

3 beds
2 full
3,270 sqft
0.08 acres
$306 / sqft
House

Property details

About 247 N Main St

Introducing The Pews at 247 N Main Street — an exquisitely restored and re-envisioned antique church, offering approximately 3,000 square feet of luminous, open interiors in the heart of Lambertville's enchanting and art-rich district. Originally built with masterful architectural detailing, this iconic brick property underwent a full-scale renovation in 2023, blending its historic character with refined modern design. While currently operating as a sophisticated office and studio space, The Pews presents an extraordinary opportunity for residential conversion. Zoned Residential (R-2), it is fully permitted for transformation into a single-family home. Imagine a truly one-of-a-kind residence, where original arched windows, soaring ceilings, skylines and curated finishes create an inspiring, light-filled sanctuary. The layout and existing infrastructure offer abundant flexibility to reimagine the interior into a spacious primary residence, live-work space, or creative retreat. Features include updated wood and tile flooring, expansive rooms drenched in natural light, and a dramatic glass-walled rear space — ideal as a future great room, dining atrium, or indoor-outdoor lounge. A secluded large backyard and a modernized kitchenette add to its home conversion potential, while the serene ambiance of the structure invites both quiet living and entertaining. All utilities, services, hvac, bathrooms, roof, windows, walls, etc. have been fully updated. Whether preserved in its current artistic form or reborn as a truly bespoke home, this revenue-generating property holds remarkable upside potential. Nestled in one of New Jersey’s most scenic and culturally celebrated towns, Lambertville offers a charming lifestyle rich in history and creativity. Located along the Delaware River, just a short stroll from the towpath, New Hope bridge, and vibrant downtown filled with art galleries, boutiques, eateries, and community events — 247 N Main Street stands as a rare chance to craft an iconic residence with character, soul, and endless inspiration.

Highlights

Home typeSingle Family Residence
HeatingForced Air
StatusActive
(ACTIVE)
CoolingWall Unit(s)
Size3,270 sqft
BasementYes
Lot size0.08 Acres
Year built1890
ParkingParking Lot
MLS #NJHT2004026

Summary

  • Full Bathrooms: 2
  • Basement: Yes
  • Total Bedroom Count: 3
  • Parking: Parking Lot
  • Architectural Style: Other
  • Heating: Forced Air
  • Cooling: Wall Unit(s)
  • List Price: $999,000
  • Price/SqFt: $305
  • Directions: Public parking in front of building
  • Year Built: 1890
  • Living Area: 3,270 SqFt
  • Municipality: Lambertville City
  • Lot Size: 0.08 Acres
  • MLS Number: NJHT2004026
  • MLS Name: BRIGHT
  • Office Name: Addison Wolfe Real Estate
  • Office Phone: (215) 862-5500
  • Office Email: legal@addisonwolfe.com
  • Listing Agent: Revi M Haviv
  • Agent Phone: (845) 492-1315
  • Agent Email: revimichele@gmail.com

IDX Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which participates, and is provided by BRIGHT through a licensing agreement.

The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on this website may no longer be available because they are under contract, have sold or are no longer being offered for sale. Some real estate firms do not participate in IDX and their listings do not appear on this website. Some properties listed with participating firms do not appear on this website at the request of the seller. This home sale information is not to be construed as an appraisal and may not be used as such for any purpose.

BRIGHT MLS is the (or a) provider of this home sale information and has compiled content from various sources. Some properties represented may not have actually sold due to reporting errors. ©2025 BrightMLS. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/16/2025, 4:45:30 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

DateEventPrice
Mar 22, 2019
Home Sold
$195,000
Mar 22, 2019
Home Sold
$195,000

Tax history

We're sorry, we currently don't have tax history data for this listing.

History based on county public records data.

Nearby schools

5

Lambertville Public School

Public District PK-6

0.1 mi

200 N Main St

6

Upper Elementary School

Public District 3-5

0.8 mi

186 W Bridge St

7

West Amwell Township School

Public District KG-6

1.6 mi

1417 Route 179

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $77,056. Residents of Lambertville, NJ typically earn between $35k-100k each year. The majority of families are single, no kids. The most common level of education of people living in this area is post secondary degree.

How much money do the neighbors make?

16%
<35k
50%
35k-100k
27%
100k-200k
7%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree
Doctorate

What types of families live nearby?

63%
Single, No Kids
6%
Single, with Kids
19%
Married, No Kids
12%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

10%
<11 yrs old
4%
12-17 yrs old
22%
18-34 yrs old
47%
35-64 yrs old
17%
65+ yrs old

What do the neighbors do for fun?

  • Skiing/snowboardingSkiing/snowboarding
  • PGA/LPGAPGA/LPGA
  • College FootballCollege Football

Where do the neighbors shop?

  • BJs Wholesale ClubBJs Wholesale Club
  • Stein MartStein Mart
  • Express/Express For MenExpress/Express For Men

Where do the neighbors go to eat?

  • PaneraPanera
  • Cracker BarrelCracker Barrel
  • SonicSonic

What do the neighbors drive?

  • InfinitiInfiniti
  • LexusLexus
  • KiaKia

What do the neighbors listen to?

  • Adult HitsAdult Hits
  • OldiesOldies
  • New CountryNew Country
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

About 247 N Main St

The listing price of 247 N Main St property is $999,000.

The property 247 N Main St is a house located in Lambertville, New Jersey, 08530.

Active Listing: 247 N Main St is For Sale (Active/New) which means the seller is accepting offers.

The nearby schools for 247 N Main St are: Lambertville Public School (GreatSchools Rating 5/10), Upper Elementary School (GreatSchools Rating 6/10), West Amwell Township School (GreatSchools Rating 7/10), New Hope-Solebury Middle School (GreatSchools Rating 7/10), Delaware Township School (GreatSchools Rating 6/10), East Amwell Township School (GreatSchools Rating 8/10), New Hope-Solebury High School (GreatSchools Rating 9/10), South Hunterdon Regional High School (GreatSchools Rating 4/10), Central Bucks High School East (GreatSchools Rating 9/10).

The last sale was on March 22, 2019 for $195,000 (source: MLS/tax record).

The property at 247 N Main St has 3 bedrooms and 2 bathrooms.

The property 247 N Main St is 3,270 SqFt (source: MLS/tax record).

The year of construction for 247 N Main St is 1890.

This home is located at 247 N Main St in Lambertville, NJ and zip code 08530. This 3,270 square foot home, which was built in 1890, sits on a 0.08 acre lot. Features: 3 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since July 7, 2025 and is currently priced at $999,000.

Lambertville, NJ housing market in June 2025 saw over 1 listings sold above listed price, more than 0 sold at listed price and over 2 sold below. In June 2025 in Lambertville, NJ there were 10.9% more homes for sale than in May.

From Rocket Homes Real Estate and based on county public records data.

More resources