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 = 3127 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 = 3127 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 = 3127 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;

748 E Mariposa Drive
Redlands, CA 92373
Molly Kurzbard with T.N.G. Real Estate Consultants, original listing - (714) 987-3310

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 6
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4346 Square Feet
Agency: T.N.G. Real Estate Consultants
Agency Phone: (714) 987-3310

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: This exclusive estate on a beautiful cul de sac is nestled in the hills of south Redlands. This 6 bedroom, 3.5 bath, SOLAR home is in close proximity to the Redlands Country Club as well as Mariposa Elementary. Entering through beautiful double doors into the foyer, you will find gorgeous hard wood flooring and towering 20’ cathedral ceilings. Plantation shutters, ceiling fans and recessed LED lighting throughout. This home has a formal staircase that curves from the living area to the bedrooms upstairs. A second staircase can be found from the family room. There is built in buffet and hutch in the dining room as well as a bay window overlooking the gardens. The kitchen has custom granite counter tops, a built-in oven and microwave, an electric range, built in refrigerator, pantry and a breakfast nook. On the first floor is a bedroom suite adjacent to the powder room, which is ALREADY plumbed to convert into a full bath. A large family room with a fire place allows for more casual entertaining. Two of the bedrooms upstairs are considered en suite bedrooms, and two other bedrooms as well as 27x17' bonus room that could be utilized as a gym, office, additional living room, library or as a sixth bedroom. But as stunning as the house is, the gardens in the backyard are equally breathtaking. Under the covered patio which has an insulated ceiling fans, sits an island seating for eight and an outdoor bbq, grill with two burners and sink. A newly refurbished pool and built in hot tub, outdoor lighting, bluetooth speakers throughout the half-acre flat usable yard are beautifully enhanced by 1500 recent plants, trees and bushes including 15 fruit trees. The yard alone is able to accommodate events in excess of 100 people. Also in the back yard is a freestanding detached studio / workshop with electricity, water and mini-split for maximum comfort. It also features skylights and incandescent lighting which would allow this space to be used for many different endeavors. There is an area which is RV possible 14.5’by 40’ and in directly adjacent to the 400 amp panel. To be energy efficient and prepared in the even of a fire, there are several upgrades. There is a NEW concrete roof with eaves beautifully wrapped with a triple crown design. There are 44 fully-owned solar panels, with additional battery and a 220 electric charging station in garage. There is a new High Efficiency 20 SEER dual air conditioner and furnace recently installed. MUST SEE!
MlsNumber: --
ListingId: PW25062130


Listing Provided By: T.N.G. Real Estate Consultants, original listing
Phone: (714) 402-3711
Office Phone: (714) 987-3310
Agent Name: Molly Kurzbard
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.


Local Real Estate Expert

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 = 3127 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;
Real Estate Expert Photo for Carlos Limon
Carlos Limon
ASCIIYour Home Sold Guaranteed Realty
Call Today!: (310) 869-2991

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App