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

1425 2nd Ave #30
Chula Vista, CA 91911

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $165,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1080
Agency: LILY'S MOBILE HOMES

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1966
Notes: Senior Community. Don't miss out on this entertainer's dream! This home has been upgraded with no details spared. The second bedroom was extended with an additional 200 sq ft (not permitted). The addition puts this home at a total 1280 sq ft. This large space is currently divided by a large wardrobe into two rooms that serve as bedroom and an office. The options for this space are endless. This space can be be easily used as a den, a large bedrooms, or kept as is for 2 separate rooms. The kitchen is going to be a dream come true for the cook in family. Beautifully designed with a modern feel and custom cabinets with revolving shelves behind the soft close doors and a custom wine rack incorporated into the cabinets. The cook will never miss out on entertaining since the kitchen is only separated by a marble counters. The living room is also partially open to allow guest to still have access to the rest of the home. As you retreat to the main bedroom, you will find a huge walk in closet for all personal needs but don't worry if it's not enough space. This room also has an additional closet for all the extras. Escape into the main bathroom and feel like you have walked into a Spa. Pine wood lined walls and natural colored decor will make you feel relaxed at the end of a long day. Finish off your day by retreating to your beautifully designed back yard. This space will definitely make you feel like you're on vacation when you walk out there. Comfortable patio furniture has been added, a fire pit for those cold nights and a gazebo to protect you from the hot sun in the summer. No need to purchase your own outdoor furniture, seller will include Patio furniture, Fire pit, gazebo and built in bar and stools. As if this home doesn't include enough, The home has a newer roof, New 7x10 resin shed, and numerous fruit trees for you to enjoy. You don't want to miss this gem of a home. Come take a look at all this home has to offer before you miss out! Don't miss out! AAR5548. $1,240 lot rent.
MlsNumber: 11276521


Listing Provided By: LILY'S MOBILE HOMES, original listing
Name: LILY'S MOBILE HOMES
Office Name: LILY'S MOBILE HOMES
Office Phone: (619) 401-4082
Agent Name: Lily Pigg
Disclaimer: Copyright © 2024 My State MLS. 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