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 = 385 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 = 385 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 = 385 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;

106 Palmetto Street
Perry, FL 32348

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 4200
Agency: Aaron Joseph, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1998
Notes: This amazing Victorian Reproduction home is a must see. With 10 foot ceilings and mill work details such as crown molding throughout, art rails, and wainscoting, as well as stained glass transoms in most rooms and stained glass windows this home is built to impress. From the giant foyer with impressive staircase to the en suite bathroom and walk-in closet attached to each bedroom, to the 500lb. capacity elevator, this home is built for comfort. The chef-inspired kitchen features Corian countertops, plenty of cabinet space, a separate prep sink, KitchenAid appliances, including: double convection ovens, a side-by-side refrigerator with ice and water in the door, a trash compactor, and dishwasher, as well as a Jenn-Air ceramic cooktop. Off the rear of the kitchen is a light-filled breakfast nook. Toward the dining room, one will find a walk-in pantry off the walk-through butler's pantry. The primary bedroom suite features a fireplace, a huge walk-in closet, and a bathroom featuring double vanities, a step-in shower, a jetted bathtub, and a bidet. Each bedroom has its own character. There is a whole house vacuum system. Off the back of the house, one will find a courtyard with a fountain. To the rear of the courtyard is a greenhouse. The three-car garage features an automatic door opener for each door. The house includes a 22KW Generac Automatic Generator with transfer switch. It is constructed with 2X6 exterior walls, and has 200 AMP electrical service. The yard features a sprinkler system. The house was built by Michael Lynn. The walpaper was installed by Debbie Wilkes. New roof September 2022.
MlsNumber: 366011


Listing Provided By: Aaron Joseph, LLC, original listing
Name: Aaron Joseph, LLC
Phone: (850) 778-3003
Office Name: Aaron Joseph
Office Phone: (850) 778-3003
Agent Name: Joseph Kikta
Disclaimer: Copyright © 2024 Tallahassee Board 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