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 = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

11439 Jeff Avenue
Sylmar, CA 91342
Angela Oganesyan with JohnHart Real Estate, original listing - (818) 246-1099

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1898 Square Feet
Agency: JohnHart Real Estate
Agency Phone: (818) 246-1099

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1963
Notes: Nestled in a highly sought-after neighborhood, this exquisite 3-bedroom, 3-bathroom home offers an ideal blend of comfort, style, and functionality. As you make your way inside, you're immediately greeted by an abundance of natural light that pours in through large windows, highlighting the spacious open floor plan. Recessed lighting throughout the home creates a warm and inviting atmosphere, perfect for both daily living and entertaining.<br /> The living areas feature stunning hardwood floors that lend an elegant touch to the entire home. The gourmet kitchen is equipped with modern appliances, ample cabinetry, and beautiful countertops, making it a chef's dream. The living room, with its cozy feel, seamlessly flows into the dining area, offering a perfect space for family gatherings or dinner parties.<br /> The primary bedroom is a true retreat, offering a peaceful sanctuary with generous space and serene views of the backyard. The en-suite bathroom features luxurious finishes with a large soaking tub, a separate glass-enclosed shower, and dual vanities. The additional bedrooms are well-sized, each offering ample closet space and easy access to the full baths.<br /> Make your way outside to discover the home's private, expansive backyard, where you can relax by the sparkling pool or entertain guests in the outdoor living area. Whether you're lounging by the pool, hosting a barbecue, or enjoying the landscaped surroundings, this backyard is truly an oasis.<br /> This home combines modern amenities with timeless charm, making it the perfect place to create lasting memories. With its hardwood floors, natural light, recessed lighting, and beautiful outdoor space, it offers everything you need for comfortable and stylish living.
MlsNumber: --
ListingId: SR24253798


Listing Provided By: JohnHart Real Estate, original listing
Phone: (818) 634-1025
Office Phone: (818) 246-1099
Agent Name: Angela Oganesyan
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App