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

4165 N 3rd Avenue
San Bernardino, CA 92407
Elena Quijano with BERKSHIRE HATH HM SVCS CA PROP, original listing - (909) 980-3100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,049,900
Beds: 6
Baths: Full: 3
Status: Active
SqFt: 3324 Square Feet
Agency: BERKSHIRE HATH HM SVCS CA PROP
Agency Phone: (909) 980-3100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Triplex
Year Built: 1952
Notes: Breaking News! Don’t let this rare Investment opportunity to acquire three-homes on almost full acre property! Plenty of room on the back lot to sub-divide, potential access off West Merose Drive and build 4 more units/or homes. The primary unit has been updated with newer kitchen cabinets, Quartz countertop, wood laminate flooring throughout, freshly painted interior, front yard completed with rock scape and much more! Primary home features an amazing bonus room with cathedral ceilings wood beams, wood burning fireplace large windows with lovely view to the mountains, glass slider for easy access to backyard, the kitchen truly gives you a country feeling offering a nook area, garden window and laundry room adjacent, spacious living room. Three spacious bedrooms. The second unit is a cozy estimated 918 sqft with 2 bedrooms, 1 full bathroom, family room, nook area, spacious kitchen, update kitchen cabinet’s, wood laminate throughout, one car garage, and fenced backyard. The third home is estimated 670sqft. Features a family room, nook area, full kitchen, one bedroom, one bathroom, and wood laminate throughout. Far back of lot with endless possibilities such as subdivide and build units, but there is more! Additional structure behind primary home with wood laminate flooring great for hobby space or home office that is currently rented with primary unit. Separate property addresses, one water main for all three units, individual electric and gas meters. Walking distance to Newmark Elementary, Shopping centers, and short drive to CA State University of San Bernardino.
MlsNumber: --
ListingId: CV24200041


Listing Provided By: BERKSHIRE HATH HM SVCS CA PROP, original listing
Phone: (909) 241-7601
Office Phone: (909) 980-3100
Agent Name: Elena Quijano
Disclaimer: Copyright © 2025 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