Title Page Background
DEBUG FN args: Array ( [0] => 461 [1] => [2] => [3] => agent ) BEFORE: Site: 461 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 461 Igate: njhud LocID: 461 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 = 461 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 461 [1] => [2] => [3] => lender ) BEFORE: Site: 461 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 461 Igate: njhud LocID: 461 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 = 461 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 461 [1] => [2] => [3] => other ) BEFORE: Site: 461 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 461 Igate: njhud LocID: 461 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 = 461 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2798 Tostalinda Dr
Tracy, CA 95377

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $907,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2155 Square Feet
Agency: Realty One Group Elite
Agency Phone: (925) 978-1100

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Not Listed

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: This home is perfect, like brand new, and ready to move in! Open concept floorplan! Light, bright, and beautiful! Built in 2022 by Lennar and located in the desirable Tracy Hills development. This well designed floor plan features 4 bedrooms, 3 full baths. Gourmet kitchen with Stainless appliances, granite counters, breakfast bar, and a walk in pantry. Three bedrooms and two full baths upstairs. bedroom and full bath down. Huge master bedroom suite with a large walk in closet. Master bathroom features a twin sink vanity, large bath tub and separate shower. All features and amenities are in like new condition. Fully appointed with quality window coverings and fully landscaped low maintenance yards in front and back. Rear yard has a custom built, covered and screened pergola for shade and entertaining. Owned solar system. Tracy Hills HOA includes a large pool and deck area, clubhouse, parks and a convenience store. Easy access to commute routes. This is a must see property! SHOWINGS BY APPOINTMENT ONLY.
MlsNumber: --
ListingId: 41043942


Listing Provided By: Realty One Group Elite, original listing
Phone: (925) 978-1100
Office Phone: (925) 978-1100
Agent Name: Ken Whitaker
Disclaimer: Copyright © 2024 bridgeMLS. 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