- 3 beds
- 2 baths
- 3,270 sqft
- 3,402 sqft lot
- $305 per sqft
- 1890 build
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.
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 Jul 1, 2025
•
MLS# NJHT2004026 —
The Building
-
Year Built:1890
-
Year Built Source:Assessor
-
Year Major Reno/Remodel:2023
-
New Construction:No
-
Construction Materials:Brick
-
Structure Type:Detached
-
Architectural Style:Other
-
Levels:2.5
-
Accessibility Features:Other
-
Foundation Details:Crawl Space
-
Basement:Yes
-
Basement Type:Combination
-
Total SqFt Source:Assessor
-
Total Below Grade SqFt Source:Assessor
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished SqFt:3270
-
Above Grade Finished SqFt Source:Assessor
-
Below Grade Finished Area Units:Square Feet
-
Below Grade Unfinished Area Units:Square Feet
-
Below Grade Finished SqFt Source:Assessor
-
Below Grade Unfinished SqFt Source:Assessor
-
Tax Total Finished SqFt:3270
Interior
-
Fireplace:No
-
Living Area SqFt Source:Assessor
Room Dimensions
-
Total SqFt:3270
-
Living Area SqFt:3,270 Sqft
Financial & Terms
-
Sale Type:Standard
-
Possession:Immediate
Location
-
Directions:Public parking in front of building
-
Latitude:40.37492752
-
Longitude:-74.94573975
The Property
-
Property Type:Residential
-
Lot Size Units:Square Feet
-
Lot Size Acres:0.08
-
Lot Size Source:Assessor
-
Lot Size Dimensions:34.00 x 100.00
-
Lot Dimensions Source:Assessor
-
Lot SqFt:3,402 Sqft
-
Zoning:R-2
-
Other Structures:Above Grade, Below Grade
-
Waterview:No
-
Waterfront:No
-
Water Oriented:No
-
Water Access:No
-
Navigable Water:No
-
Tidal Water:No
-
Riparian Rights:No
Listing Agent
- Contact info:
- Agent phone:
- (845) 492-1315
- Office phone:
- (215) 862-5500
Taxes
-
Tax ID Number:17-01006-00008
-
Tax Year:2024
-
Tax Lot:00008
-
Tax Annual Amount:$11,316
-
Tax Assessed Value:$489,700
-
Year Assessed:2024
-
Total Taxes Payment Frequency:Annually
Beds
-
Bedrooms:3
-
Bedrooms Main Level:3
Baths
-
Total Baths:2
-
Full Baths:2
-
Main Level Baths:2.00
-
Main Level Full Baths:2
Heating & Cooling
-
Cooling Type:Wall Unit
-
Central Air:No
-
Cooling Fuel:Electric
-
Heating:Yes
-
Heating Type:Forced Air
-
Heating Fuel:Natural Gas
Utilities
-
Sewer/Septic:Public Sewer
-
Hot Water:60+ Gallon Tank
-
Water Source:Public
Schools
-
School District Name:South Hunterdon Regional
-
School District Source:Listing Agent
The Community
-
Senior Community:No
-
Pool:No Pool
-
HOA:No
-
Condo/Coop Association:No
Parking
-
Garage:No
-
Type of Parking:Parking Lot
Extra Units
-
Vacation Rental:No
Monthly cost estimate

Asking price
$999,000
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. |
$5,349
|
Taxes | $943 |
Insurance | $274 |
Utilities | $574 See report |
Total | $7,140/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 |
---|---|---|---|---|
7/1/25
Jul 1, 2025
|
Listed / Active | BRIGHT | $999,000 |