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

1348 Hyatt Ave
Wilmington, CA 90744

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $734,900
Beds: 3
Baths: 2
Status: Pending
SqFt: 1527
Agency: Berkshire Hathaway HomeServices California Propert

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6,696 sqft
Property Type: Residential
Year Built: 1955
Notes: Come and see a well maintained residence in the heart of thriving Wilmington, mere steps from the renowned Banning Museum and Park. This ideally crafted home spans 1,527 square feet, offering three bedrooms and two full baths, meticulously designed to cater to modern living requirements. Enter to discover an inviting open kitchen concept, seamlessly flowing into spacious family and dining rooms, perfect for both casual family dinners and formal entertaining. Recessed lighting illuminates the interior, enhancing the ambiance of each room, while ceiling fans in the bedrooms ensure optimal comfort year-round. Enhanced with dual paned windows, central heat, and air conditioning, this residence offers unparalleled comfort and energy efficiency. A tankless hot water heater provides on-demand hot water, ensuring convenience and sustainability. Outdoors, manicured lawns envelop the property, complemented by automatic sprinklers for effortless maintenance. A covered patio area awaits in the backyard, offering a serene retreat for outdoor relaxation or al fresco dining. Complete with a two-car garage and newer storage sheds, this home offers ample space for storage and hobbies. Its proximity to public amenities, including libraries, the Post Office, local eateries as well as easy access to Long Beach, I-110, and I-710, underscores its desirability for discerning homeowners seeking convenience without compromising on quality. This home will not last long. Come and make it yours.
MlsNumber: SB24060658


Listing Provided By: Berkshire Hathaway HomeServices California Propert, original listing
Name: Berkshire Hathaway HomeServices California Propert
Phone: (310) 373-0021
Office Name: BerkshireHathaway HomeServices
Office Phone: (310) 318-9386
Agent Name: Larry Medler Jr
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