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

1052 W Skyview Landings Drive
Hernando, FL 34442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2669
Agency: REALTRUST REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: JUST REDUCED! TERRA VISTA OF CITRUS HILLS SKYVIEW LANDINGS 3 BEDROOM, 3 BATHROOM, 2+ CAR GARAGE on LAKE COURTYARD HOME WITH GUEST HOUSE This remarkable home is ready to be your next home in this highly sought after gated community located in the heart of Citrus county.As you walk through the wrought iron gate into the courtyard, you will no doubt get the welcoming feeling for you & your guests.This unique home features the main house w/an open concept that connects the large living room, dining area & kitchen,creating a perfect space for entertaining. The kitchen boasts a center island,pantry, lots of wood cabinetry & counter space with an enhancing backsplash.The owner's suite is spacious w/it's own sitting area & luxurious bathroom that has a spa like feeling w/walk in shower, garden tub, dual vanities & a large dressing room/walk in closet.The 2nd bedroom/office has a walk in closet plus a wall unit W/Cabinets & a murphy bed. An expansive laundry room w/laundry tub & newer washer & dryer complete the space in the main house. The separate guest house makes this home very appealing. It has a separate living room, bathroom & bedroom all overlooking the courtyard. The oversized garage has plenty of room for 2 cars plus a golf cart. This custom home has many upgrades throughout including artist murals, etched painted driveway, ceramic tile floors, premium flat tile roof, radiant barrier, newer dual pane windows, lots of extra closet space,ceiling fans,window treatments, Hot tub & so much more! The interior space has it all but the outdoor area is amazing too! Enjoy the oversized screened lanai w/pavers overlooking the picturesque lakeview! Plus all of the CHG&CC social membership privileges for your lifestyle enjoyment.
MlsNumber: 828282


Listing Provided By: REALTRUST REALTY, original listing
Name: REALTRUST REALTY
Phone: (352) 770-7002
Office Name: REALTRUST REALTY
Office Phone: (352) 770-7002
Agent Name: Susan Grow-Mullen PA
Disclaimer: Copyright © 2024 REALTORS Association of Citrus County, Inc. 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 = 332 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 Teresa Pharr
Teresa Pharr
ASCIIBerkshire Hathaway HomeServices - Florida Showcase Properties
Call Today!: (910) 264-2089

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App