x
Showing 1 of 0
X
Save

247 N MAIN Street
LAMBERTVILLE NJ 08530 US

$895,000

Active Listing ID NJHT2004026
bed icon
3 bed
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 0.08 Acres
home icon
Other

$895,000

Active Listing ID NJHT2004026
Save

247 N MAIN Street 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.08 Acres
  • Property Type: Residential
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 2
  • Cooling System: Wall Unit(s)
  • Heating Fuels: Forced Air

Property

  • propertytype: Residential
  • propertysubtype: Other
  • listprice: 895000
  • unparsedaddress: 247 N MAIN Street
  • postalcity: LAMBERTVILLE
  • stateorprovince: NJ
  • country: US
  • postalcode: 08530
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.08
  • lotsizeunits: Acres
  • lotsizearea: 0.08
  • livingarea: 3270
  • livingareaunits: Square Feet
  • latitude: 40.37492752
  • longitude: -74.94573975
  • listagentfullname: Revi M Haviv
  • listagentemail: revimichele@gmail.com
  • listagentkey: 3yd-TRENDPA-3315061
  • listagentmlsid: 3315061
  • listagentpreferredphone: 8454921315
  • listagentofficephone: 8454921315
  • listofficekey: 3yd-TRENDPA-ADDSNWLF
  • listofficemlsid: ADDSNWLF
  • disclaimer: Copyright © 2025 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: TRENDPA
  • yearbuilt: 1890
  • listingcontractdate: 2025-07-01
  • listagenturl: http://www.addisonwolfe.com
  • countyorparish: HUNTERDON
  • elementaryschooldistrict: SOUTH HUNTERDON REGIONAL
  • middleorjuniorschooldistrict: SOUTH HUNTERDON REGIONAL
  • highschooldistrict: SOUTH HUNTERDON REGIONAL
  • cooling: Wall Unit(s)
  • constructionmaterials: Brick
  • heating: Forced Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 3
  • parkingtotal: 0
  • parkingfeatures: Parking Lot
  • waterfrontyn: False
  • franchiseaffiliation: None
  • rooms: Bathroom 1, Bedroom 3, Basement, Bedroom 2, Bathroom 2, Bedroom 1
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -74.94574, 40.374928
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Addison Wolfe Real Estate", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"revimichele@gmail.com", "ListBrokerageCity":"New Hope", "ListBrokerageCountry":"US", "ListBrokerageEmail":"pat@addisonwolfe.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/TRENDPA/c5ababc320f35e680120f3c56f1a003e/20090501154525485.pjpeg", "ListBrokerageName":"Addison Wolfe Real Estate", "ListBrokeragePhone":"(215) 862-5500", "ListBrokeragePostalCode":"18938", "ListBrokerageStateOrProvince":"PA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"550 Union Square Drive", "ListBrokerageWebsiteUrl":"http://www.addisonwolfe.com", "ListOfficeAddress1":"550 Union Square Drive ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"ADDSNWLF", "ListOfficeCity":"New Hope", "ListOfficeCountry":"USA", "ListOfficeEmail":"legal@addisonwolfe.com", "ListOfficePostalCode":"18938", "ListOfficeStateOrProvince":"PA", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - LAMBERTVILLE, NJ", "ListingURL":null, "MLSModificationTimestamp":"2025-09-08 16:07:27", "Neighborhoods":[{"Description":null, "Name":"-"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":11316, "TaxDescription":null, "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/3/2025 12:59:20 AM GMT
Source Updated Date: 12/5/2025 6:45:57 AM GMT

Courtesy of: Revi M Haviv, Addison Wolfe Real Estate, revimichele@gmail.com

Copyright © 2025 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.