Title Page Background
HFQUERY 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 = 1768 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1768 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1768 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

190 5th Ave Ave
Estell Manor, NJ 08319
Amy Sheldon with eXp Realty - Montclair, original listing - (866) 201-6210

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2976 Square Feet
Agency: eXp Realty - Montclair
Agency Phone: (866) 201-6210

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: ?? Brand-New Heating & Cooling Systems with Smart Thermostats! ?? This stunning home boasts over $20,000 in upgrades, including 2 brand-new heating systems, dual-zone cooling, and state-of-the-art smart thermostats for ultimate comfort and energy efficiency. 5 Acres of Tranquility Welcome to 190 Fifth Avenue, a serene oasis located in the highly desirable Estell Manor, NJ. Set on a sprawling five-acre wooded lot, this exquisite property offers unmatched privacy and natural beauty! Interior Features Step inside this four-bedroom home and experience its warm and elegant design: Bonus Room on the First Floor: Spacious and versatile, complete with closets—perfect for a home office, guest suite, or playroom. Premium Flooring: Gorgeous Brazilian teak hardwood and travertine tile elevate the main level's charm. Thoughtful Layout: Includes a large living room, a modern kitchen, a cozy reading nook (or office space), a mudroom with backyard access, and a separate laundry room. Oversized Two-Car Garage: Conveniently accessible from inside the home. The second floor features a luxurious master suite, three additional bedrooms, and a full bathroom, ensuring ample space for the whole family. Outdoor Living The property shines just as brightly outside: Grand Entrance: A commercially paved driveway, set back 300 feet, ensures privacy and makes a statement. Welcoming Front Porch: Framed by two impressive stone columns. Recreation & Relaxation: A spacious rear deck, an above-ground pool, and two storage sheds provide plenty of outdoor enjoyment options. Key Updates & Amenities Heating & Cooling: Brand-new dual-zone systems with smart thermostats for modern control and convenience. Propane Heating: With an owned above-ground tank for efficiency. Septic System: Less than 8 years old and in excellent condition. Your Dream Home Awaits Located in Estell Manor, this home combines luxury, comfort, and the tranquility of nature. Don't miss your chance to own this incredible property! ?? Contact us today to schedule your private showing!
MlsNumber: --
ListingId: 592301


Listing Provided By: eXp Realty - Montclair, original listing
Phone: (856) 305-9602
Office Phone: (866) 201-6210
Agent Name: Amy Sheldon
Disclaimer: Copyright © 2025 South Jersey Shore 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 Real Estate Expert

HFQUERY 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 = 1768 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Jessica Mashburn
Jessica Mashburn
ASCIIEXIT HOMESTEAD REALTY PROFESSIONALS
Call Today!: (856) 261-5542

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App