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

24480 County Road 255
Pittsburg, MO 65724
Ricardo Alessio with Platinum Realty, LLC/Alessio & Assoc.,PC, original listing - (888) 220-0988

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: --
Agency: Platinum Realty, LLC/Alessio & Assoc.,PC
Agency Phone: (888) 220-0988

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential Multi Family-Other
Year Built: 1967
Notes: Reduced price, ready to sell, call agent for other specials. Beautiful, treed, 3.3 acres (5 lots) corner to corner with 2 Living units fully furnished & all appliances (see SD). 1 Barndominium-1500 sq ft.- w/2BRs/1BA, LR/DIN, KT, Loft, Ashley Wood Stove + separate propane tank for Wall heater, new HW heater, single car garage insulated with shelves. 1-1967 Mobile home-696 sq. ft-fully furnished, 2BR/1BA, KT/Dining, LR. The deck is on the front, with a rear exit and a separate propane tank. 1 She Shed-256sq ft, high ceilings, storage, front window and door. 2 utility sheds, Lower shed w/electricity 12x18, Upper Shed 18x24, Carport open w/woodshed lean roof. Large fenced-in Garden area with 32 outside beds and 12 large, raised beds + a small greenhouse in the middle. Gazebo 10ft round custom made, Fire pit area. Pea gravel access to Gazebo, garden, and upper shed. The property goes from corner to corner with open areas and Treed. All mow-able. 2-riding lawnmowers, log splitter, Tiller, and 9 cords of wood (Ash & Oak), available for sale.
MlsNumber: --
ListingId: 11342077


Listing Provided By: Platinum Realty, LLC/Alessio & Assoc.,PC, original listing
Phone: (816) 982-4998
Office Phone: (888) 220-0988
Agent Name: Ricardo Alessio
Disclaimer: Copyright © 2024 My State MLS. 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