Title Page Background
DEBUG FN args: Array ( [0] => 3185 [1] => [2] => [3] => agent ) BEFORE: Site: 3185 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3185 Igate: njhud LocID: 3185 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3185 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3185 [1] => [2] => [3] => lender ) BEFORE: Site: 3185 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3185 Igate: njhud LocID: 3185 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3185 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3185 [1] => [2] => [3] => other ) BEFORE: Site: 3185 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3185 Igate: njhud LocID: 3185 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3185 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

64 E Main Street
Freehold, NJ 07728

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: --
Baths: --
Status: Active
SqFt: 6862 Square Feet
Agency: ARC Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Office
Year Built: --
Notes: Former Sabrina the Teenage Witch House From 90's Sitcom: Restored with Vintage Charm. Discover 2 renovated office buildings on E Main Street, Freehold Boro. Move-in ready spaces with ample parking. Front building: 4,862 sqft, 3 finished floors, kitchen, offices, porch. Back building: 2,000 sqft, 2 levels, kitchen, offices, bathrooms. Vintage charm preserved after extensive remodeling. This property was brought down to the studs. Zoned commercial/office. Potential for residential/mixed use, variance required. Front building featured in ''Sabrina the Teenage Witch.'' Zoning department estimates 3 months for variance. Former Sabrina the Teenage Witch House from 90s Sitcom: Immaculately Restored Office Buildings with Vintage Charm in Prime Freehold Boro Location<br /> <br /> Embark on an extraordinary opportunity to own two impeccably renovated office buildings seamlessly marrying vintage charm with modern convenience. Nestled on E Main Street, mere moments from the bustling heart of Freehold Boro's business district, this offering presents two move-in ready properties, currently zoned for commercial/office use, complemented by ample parking facilities.<br /> <br /> Front Building: Encompassing an expansive 4,862 square feet, this structure spans three meticulously finished floors and a spacious attic awaiting your creative vision. Inside, 2 fully equipped kitchens, numerous generously sized offices, and a delightful wraparound front porch await. Four distinct entrance doors ensure effortless access to various office spaces, enhancing efficiency and convenience. The main house boasts 2 full bathrooms, 3 half bathrooms, 2 kitchens, and 7 large offices downstairs. Upstairs, discover 6 large offices and one small office with a sizable walk-in closet that was previously used as a server room. Recently professionally finished for $30,000, the basement features cemented, sealed, and painted walls.<br /> <br /> Back Building: Nestled at the rear of the property, this building offers approximately 2,000 square feet across two levels. Featuring a functional kitchen, five offices, and two bathrooms, it caters to a diverse range of professional needs. The back house comprises a kitchen, 3 offices downstairs, and upstairs features 2 offices and a large open workplace space area. Currently leased to an accounting firm for $3,400, with the lease set to expire in June 2024.<br /> <br /> Both buildings have undergone extensive remodeling while preserving the nostalgic allure that Freehold Boro is famed for. Guided by the Freehold historic community, impeccable renovations include new roofing, flooring, plumbing, electrical systems, decking, and hardy boy siding, ensuring a turnkey experience for the prospective owner.<br /> <br /> The front building, previously leased for $9,750, boasts enchanting period details such as intricate windows, stained glass elements, and the iconic domed turret. Furthermore, this property holds a place in pop culture history, serving as the exterior backdrop for the fictional Spellman Manor in the beloved '90s sitcom, "Sabrina the Teenage Witch."<br /> <br /> This exceptional offering also provides versatile zoning opportunities. While presently designated for commercial and professional purposes, the property's original residential origins allow for potential conversion to a residential or mixed-use setup. Achieving this transformation necessitates a variance, a process that the zoning department estimates will take approximately three months. Interested parties are encouraged to explore this possibility through the Freehold Township zoning office. <br /> <br /> Highlighted by its feature in various prominent media outlets, including nj.com, People Magazine, Fox Business, and the Asbury Park Press, this property's distinct character and flexible potential position it as an outstanding investment opportunity.<br /> <br /> Seize the chance to become part of Freehold Boro's storied history and thriving business environment. Contact us today to see this meticulously restored Victorian gem.<br /> <br /> Articles:<br /> <br /> https://www.app.com/story/marketplace/real-estate/freehold/2021/10/11/sabrina-teenage-witch-house-freehold-sale/6038014001/<br /> <br /> https://people.com/home/sabrina-the-teenage-witch-house-for-sale-new-jersey-open-to-public-for-tours-on-halloween/<br /> <br /> Link to full write up and information:<br /> <br /> https://www.dropbox.com/sh/5zodp78tgwhfrh0/AACmtuN8i2Vej34UD0SQ6EH2a?dl=0
MlsNumber: --


Listing Provided By: ARC Real Estate, original listing
Phone: (609) 731-4265
Office Phone: (609) 731-4265
Agent Name: Sean Mulligan
Disclaimer: Copyright © 2024 Monmouth Ocean Regional Realtors and Monmouth Ocean Regional MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => monmouth-southwest [3] => NJ [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: monmouth-southwest State: NJ Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: monmouth-southwest State: NJ Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3185 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Michael Graziano
ASCIIPrime Time Mortgage Corporation
Direct: (973) 544-0708

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App