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;

19305 Romar Place
Northridge, CA 91324
Charles Twagira with Park Regency Realty, original listing - (818) 363-6116

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 6
Baths: Full: 5
Status: Active
SqFt: 4076 Square Feet
Agency: Park Regency Realty
Agency Phone: (818) 363-6116

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1957
Notes: This stunning home is nestled at the end of a quiet cul-de-sac in one of Northridge’s most sought-after neighborhoods, and as soon as you lay your eyes on it, you’ll immediately recognize the owner’s true “Pride-Of-Ownership.” Here are just a few of its many other outstanding features: Its lush, manicured landscaping, colorful planters, towering shade tree, myriad of fruit trees, 2 custom landscape light pillars, and freshly painted exterior enhance its eye-catching. Double custom doors swing open to freshly painted 4,076 square foot open concept contemporary floor plan that is in “Pristine Condition” with dimmable recessed lighting, glass paneled door, and an aesthetic blend of hardwood, laminate, and tile flooring. The spacious living room has a wood-burning fireplace and direct access to a covered entertainer’s patio. The family’s cook is going to truly appreciate the huge kitchen’s abundant custom cabinets with counter lighting, 2 walk-in pantries, ample quartz counters with full tile back-splash, stainless steel appliances, farmhouse stainless steel sink with custom faucet, center island with custom pendant lighting, preparation sink, and built-in breakfast bar, and the convenience of the adjoining dining room with its pitched wood ceiling and wood-burning fireplace. A total of 6 bedrooms. The gigantic grand suite has direct backyard access, a large sitting area, 2 walk-in closets, plus a sumptuously appointed bathroom with 2 dual sink vanities, soaking tub, and huge custom tiled shower with 2 rain and handheld shower heads. A total of 5 bathrooms. The huge loft with its balcony is perfect for a private retreat. Tri-Zone central heat & air systems for year-round comfort. Energy efficient dual pane windows will help keep your utility bills low and your interior very quiet. You’re going to appreciate and enjoy the Oasis backyard’s sparkling pool, 3 covered entertainer’s patios; one with a built-in barbecue station, and large side brick patio that houses the “Bomb Shelter” with its many possibilities. Plenty of secure off street parking for any and all of your vehicles and other toys on the 2 RV pads and in the 2 car direct access garage. All of this sits on a huge 17,819 square foot lot that is close to school, restaurants, CSUN, and Northridge Fashion Mall. Call now for all the details and I’ll gladly arrange your private tour.
MlsNumber: --
ListingId: SR24205300


Listing Provided By: Park Regency Realty, original listing
Phone: (818) 357-7999
Office Phone: (818) 363-6116
Agent Name: Charles Twagira
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