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

308 2nd St
Chiefland, FL 32626

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $189,900
Beds: 2
Baths: 1
Status: Pending
SqFt: 1445
Agency: Deen Lancaster Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1930
Notes: Welcome to your new home! This delightful property offers a spacious 2 bed/1 bath layout with over 1400 sqft of living space. Situated on nearly half an acre in the heart of Chiefland, convenience meets comfort in this lovely brick residence. Key Features: Size: With over 1400 sqft of living area, this home provides ample space for comfortable living. Bedrooms: Both bedrooms are generously sized, easily accommodating king-sized beds. Bonus Room: A versatile bonus room offers the flexibility for a home office, guest room, or third bedroom. Kitchen: The kitchen is equipped with plenty of cabinets and features a convenient breakfast bar seating area. Bathroom: The recently remodeled bathroom exudes modern elegance and functionality. Flooring: Most rooms boast beautiful real wood floors, adding warmth and character to the home. Unique Touches: Enjoy the charm of hardwood walls and ceilings in the main bedroom and living room. Outdoor Spaces: Relax and unwind on the front porch or newer screen porch at the rear of the home. Carport: A spacious 2-car attached carport provides convenient covered parking. Backyard: The expansive backyard includes a pole barn structure and two sheds, offering plenty of storage space and potential for outdoor activities. Location: Conveniently located in the vibrant City of Chiefland, this home offers easy access to all the amenities and attractions the area has to offer. From shopping and dining to outdoor recreation, everything you need is just moments away. Don't miss your chance to make this charming Chiefland home your own! Contact us today to schedule a viewing.
MlsNumber: 790591


Listing Provided By: Deen Lancaster Realty, Inc., original listing
Name: Deen Lancaster Realty, Inc.
Phone: (352) 463-9494
Office Name: Deen Lancaster Realty Inc.
Office Phone: (352) 463-9494
Agent Name: Deen Lancaster
Disclaimer: Copyright © 2024 Dixie-Gilchrist-Levy Multiple Listing Service. 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