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;

16012 Acre St
North Hills, CA 91343
Mathew Bahri with Nelson Shelton Real Estate Era Powered, original listing - (310) 271-2229

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1854 Square Feet
Agency: Nelson Shelton Real Estate Era Powered
Agency Phone: (310) 271-2229

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1961
Notes: The moment the couple stepped onto the blue pearl granite foyer and into the three-bedroom house for sale, they felt a tug at their heart. It wasn't the size that impressed them, but the charm in every corner. The living room with high ceilings had mid-century modern touches: clean lines, cozy sleek fireplace, recessed lighting, and a sunken living room framed by windows. Natural light poured in, bouncing off the warm tones floors throughout. The spacious dining room neighboring the wet bar/wine rack was the perfect space to entertain. They imagined cooking holiday meals for family in the Chef's kitchen with warm Cherry Wood adorned with black granite countertops. The stainless steel appliances were the luxury that they had wanted all along. They were imagining chilling the wine in the wine fridge and warming up the holiday pies in the warmer that would add convenience during the busy time of year. As they strolled through the house they opened the double doors that lead them to the main bedroom, a private retreat. The free standing tub in the main bathroom was perfect for relaxing at the end of a busy day and the stand up shower an easy convenience. There were two other good sized bedrooms that had endless possibilities. Maybe for the family they were starting, the home office they had always wanted or just hosting guests. But it was the backyard that truly captivated them. Through the sliding glass doors, the house opened up to an oasis. Lush greenery bordered a spacious lawn, with a stone pathway leading to a lagoon style heated pool. The sound of a gentle waterfall into the pool could be heard within the rustle of leaves in the breeze. It was peaceful, serene, almost too perfect. They had imagined summer nights here, with the sound of laughter echoing from the patio as friends gathered around the fire pit and had dinner al fresco. As they stepped out of the main house, they noticed a finished 2 car garage with a tankless water heater and the side by side washer & dryer. They immediately entertained the idea of designing a cool ADU, maybe? They had to look into it. But they knew this was HOME!
MlsNumber: --
ListingId: 24-450011


Listing Provided By: Nelson Shelton Real Estate Era Powered, original listing
Phone: (310) 271-2229
Office Phone: (310) 271-2229
Agent Name: Mathew Bahri
Disclaimer: Copyright © 2024 TheMLSCLAW. 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