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

574 San Joaquin Road
Kissimmee, FL 34759

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $455,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1980
Agency: Arista Realty Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2015
Notes: This well appointed 3 bedroom, 2 bath home is nestled on a magnificent conservation home site! Step inside and see straight through to the stunning view of lush trees! The CALDES Model has some great benefits such as a large kitchen with an abundance of storage and counter space, OPEN CONCEPT layout that makes it perfect for entertaining and a spacious covered and screened lanai. This home also has the separate GOLF CART GARAGE! Other great features of this home is the GENERAC Generator with two propane tanks. The grounds are professionally landscaped with curbing around the landscape beds, stone facade on the front exterior and freshly painted exterior, screened front entry and custom glass insert on the front door. Pass through the awesome wall space and the spacious foyer. with tray ceiling. The second and third bedrooms are situated off the foyer as a suite with a full bath accessible from the hallway that includes built in closets and additional hall closet and the bath has been updated to include new sink and faucet and quartz counters and newer luxury vinyl flooring. You will be impressed by the amazing transition between the kitchen, living room and dining room! There is crown molding and wide baseboard baseboard trim with tile flooring. The interior and exterior has recently been painted including the trim throughout the interior. The kitchen has a huge center island with breakfast bar and a huge walk-in PANTRY as well as a full wall closet. There is a SUN TUBE over the kitchen that brings even more light to the main area. The covered and screened lanai spans the rear of the home with a separate screened area when you want to feel the sunlight! The Primary bedroom suite overlooks lush trees and the primary bath has a great shower with seat and new Quartz counters, square sinks and new faucets. The full laundry room has plenty of storage cabinets and a built in utility sink, LG washer and dryer on storage pedestals. Some furniture is available separately. The 2 car garage has the epoxy finish on the floor and the separate golf cart garage is perfect for a golf cart or extra storage. This home has been treated preventatively for termites so the termite bond is in place. There is so much to love about this beautiful home! Relax and enjoy your new 55 Plus lifestyle with over 4200 acres of natural beauty to explore and engage! Solivita is a 5000 home master planned community with two huge amenity centers, a great spa with medical services, plenty of fitness equipment to use and an array of fitness classes, 2 champion golf courses, 14 community pools, 3 restaurants, sundries store, village center, over 250 social clubs to join, plenty of pickleball courts, tennis courts, softball field, bocci, shuffleboard, concierge, lifestyles team and conveniently located near Disney and Orlando International Airport. It's time to relax.
MlsNumber: S5102510


Listing Provided By: Arista Realty Group, LLC, original listing
Name: Arista Realty Group, LLC
Phone: (203) 788-9157
Office Name: ARISTA REALTY GROUP, LLC
Office Phone: (203) 788-9157
Agent Name: Georgia Pizzarelli
Disclaimer: Copyright © 2024 Stellar MLS. 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 = 376 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Harper Realty Group
Harper Realty Group
Call Today!: (863) 581-6661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App