Title Page Background
DEBUG FN args: Array ( [0] => 3192 [1] => [2] => [3] => agent ) BEFORE: Site: 3192 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3192 Igate: njhud LocID: 3192 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3192 [1] => [2] => [3] => lender ) BEFORE: Site: 3192 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3192 Igate: njhud LocID: 3192 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3192 [1] => [2] => [3] => other ) BEFORE: Site: 3192 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3192 Igate: njhud LocID: 3192 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2264 Poppy Hills Dr
Chula Vista, CA 91915

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $948,300
Beds: 4
Baths:
Status: Pending
SqFt: 1911 Square Feet
Agency: eXp Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Stucco
Cooling: Attic Fan
Heating: Forced Air, Fireplace
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Family Room, Living Room, Loft

Window Features

Exterior Features: Fence, Pool
Fencing: Fenced
Parking Features: Driveway
Roof: Tile

Neighborhood/Schools

Elementary School/District: Chula Vista Elementary District
Middle/Junior High School/District:
High School/District: Sweetwater Union High School District
Subvidision Name:

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Welcome to your new stunning 4-bedroom, 2.5-bathroom home in Eastlake with the largest lot in this charming neighborhood. As you step into the home, you're greeted by the warmth of tile floors that span the entire downstairs, seamlessly connecting each room. The heart of the home, a gorgeous kitchen adorned with beautiful cabinets providing ample storage space. The kitchen is equipped with sleek stainless steel appliances, adding a modern touch to the space. Retreat to the master bedroom, your own private sanctuary complete with an ensuite bathroom for added convenience and luxury. Gather around the gorgeous fireplace in the family room, where countless memories are waiting to be made. French doors lead you to the side yard, offering a tranquil escape where you can enjoy a breath of fresh air and bask in the beauty of your surroundings. The lush greenery of mature trees and vibrant flowers adorns the landscape, creating a picturesque setting that welcomes you home each day. The expansive grass area provides plenty of space for outdoor activities and enjoyment. This home is more than just a place to live—it's a haven where every detail has been carefully curated to elevate your lifestyle and inspire a lifetime of cherished moments.
MlsNumber: --


Listing Provided By: eXp Realty, original listing
Phone: (858) 367-9290
Office Phone: (888) 584-9427
Agent Name: Brian Danney
Disclaimer: Copyright © 2024 San Diego 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