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

2491 N Pine Street
Westville, FL 32464
Cindy Birge with Elite Realty, original listing - (850) 638-0370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,500
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1668 Square Feet
Agency: Elite Realty
Agency Phone: (850) 638-0370

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Welcome to this enchanting 2-bedroom, 2-bathroom retreat situated on a stunning landscape. This property is a true testament to craftsmanship, thoughtfully curated by a skilled woodworker. From handcrafted details to rustic touches, each corner of the home exudes a unique warmth and charm.As you enter the living room, you'll be drawn to the handcrafted cedar fireplace mantle, a focal point that radiates coziness and character. Step out onto the renovated back porch--a perfect haven for relaxation. Enhanced with new insulation, climate control, double-paned storm windows, ceiling fans, and built-in Bluetooth speakers, this area is perfect for quiet morning coffee or cozy late-night conversations, accompanied by the sound of gentle rainfall.The outdoor oasis also boasts a newly equipped gunite saltwater pool, complete with a new screen enclosure and a 30,000-gallon tank, ensuring refreshing swims throughout the warmer months. A recently inspected and filled 250-gallon propane tank offers energy-efficient warmth whenever needed.Beyond the main house, two small outbuildings offer boundless potential for creative use, while car enthusiasts and hobbyists will appreciate the climate-controlled front garage, complete with ample wiring and additional storage behind it. The backyard reveals an impressive two-story workshop, fully wired for electricity and equipped with an industrial exhaust system, making it an ideal space for woodworking, substantial projects, or even boat storage. Nearby, a charming stone fire pit creates a cozy setting for outdoor gatherings.The lush grounds feature mature sago palms, flourishing satsuma trees, and a delightful variety of chestnut, pecan, and walnut trees, adding a diverse burst of color and natural beauty. Vibrant blueberry bushes add to the landscape, while the property's pond beckons for leisurely fishing afternoons.From the custom details throughout the house to the expansive workshop and beautiful pool area, this property is a unique haven. Don't miss your opportunity to make it your own!
MlsNumber: --
ListingId: 764258


Listing Provided By: Elite Realty, original listing
Phone: (850) 638-0370
Office Phone: (850) 638-0370
Agent Name: Cindy Birge
Disclaimer: Copyright © 2024 Central Panhandle Association of REALTORS. 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