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;

9737 Frankirst Avenue
North Hills, CA 91343
Vahan Avanesyan with Pinnacle Estate Properties, original listing - (818) 993-7370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,699,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 5362 Square Feet
Agency: Pinnacle Estate Properties
Agency Phone: (818) 993-7370

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1963
Notes: Stunning Hilltop Oasis with Unmatched Valley & Mountain Views. Set in the coveted North Hills area, this ultra-modern 5-bedroom, 4-bathroom home spans 5,326 sq. ft. on a nearly 16,000 sq. ft. lot, offering breathtaking views of the San Fernando Valley and Santa Susana Mountains. An architectural masterpiece, this home redefines luxury with its sleek design, expansive layout, and stunning vistas. A grand 8-foot pivot wood door leads into a soaring foyer with high ceilings, glass stair rails, and a striking floor-to-ceiling abstract wall design. The first floor features white tile throughout, including four spacious bedrooms, three bathrooms, and a luxurious primary suite. The open-concept living and dining areas are perfect for entertaining, with panoramic views of the backyard, city, and mountains. A sliding door from the dining area opens to a patio, enhancing the home’s seamless indoor-outdoor flow. The chef’s kitchen boasts a 9-foot island, abundant cabinetry, and a walk-in pantry. A dedicated laundry room and a two-car garage with high ceilings. Upstairs, the home continues to impress with a glass-walled yoga room and a terrace overlooking the front. The expansive owner’s suite includes two pocket doors that open to unobstructed views, a retreat area, two private decks, and a walk-in closet the size of a one-car garage. The spa-like ensuite bath features dual quartz vanities, a walk-in shower, a bidet, and a soaking tub with picture-perfect views. The 1,000 sq. ft. owner’s terrace, along with two other terraces, offers modern glass railings and a perfect setting to enjoy the scenery. Outside, the expansive backyard features a rear patio, a deck, and a private terraced garden, with custom railings and plenty of space for relaxation or entertaining. A rare opportunity to own this hilltop masterpiece, blending modern design, breathtaking views, and luxurious living.
MlsNumber: --
ListingId: SR24246337


Listing Provided By: Pinnacle Estate Properties, original listing
Phone: (323) 401-3229
Office Phone: (818) 993-7370
Agent Name: Vahan Avanesyan
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