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 = 1160 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1160 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1160 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 Allen Ave
Converse, LA 71419
Lewis McBryde with McBryde and Associates Realty, original listing - (318) 256-2121

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: McBryde and Associates Realty
Agency Phone: (318) 256-2121

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Two homes for sale together! Awesome home or business opportunity. Perfect for someone who needs to have a relative close by, or live in one home and rent the other. This property consists of a 3/2 1600 square foot brick and vinyl home and an 18x80 mobile home located on approximately 5 acres in the heart of Converse, LA. One acre fronts on Highway 171 (445 feet of highway frontage). The foundations of previous businesses are on this acre - it can easily be used or sold as commercial property. It has solar panels to reduce your electric bill and a 20 KV Generac generator that is there when needed. The main home has security cameras throughout. All video cameras and the monitor screen will remain. The home has been updated with new floor coverings and updated tile bathrooms. The den has a stone fireplace with a wood burning insert. The den has vaulted ceilings and has a combination of tile and wood flooring. The custom kitchen has many cabinets accented by a stone backsplash. There is a large farmhouse sink. The dining room set was built to match the kitchen cabinets and to fit the space, so it will remain with the sale of the home. Appliances remaining include side by side refrigerator, dishwasher, stove, vent hood, microwave, washer and dryer. On the outside the home has a double garage along with a 20 by 24 car cover and a covered back porch. There are two 12 X 24-foot storage buildings. The second home on the property is an 80x18 Clayton mobile home. This home has a 20 X 25-foot car cover and a nine by ten front deck. This home has a new roof and flooring and is in excellent condition inside and out. The three-bedroom, two-bathroom home has ceiling fans in each bedroom and the den. The master bath has a garden tub and a shower. Appliances remaining include stove, microwave, side by side refrigerator, dishwasher and washer and dryer. The two homes are separated by an asphalt circle driveway. Both homes have large yards to enjoy. This Property is priced to sell at $325,000.
MlsNumber: --
ListingId: 11340412


Listing Provided By: McBryde and Associates Realty, original listing
Phone: (318) 256-2121
Office Phone: (318) 256-2121
Agent Name: Lewis McBryde
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