42General Stuart, Erlanger, KY 41018
OFF MARKET

42General Stuart
Erlanger, KY 41018

  • 3 Beds
  • 2 Baths

$141,800

Trulia Estimate
as of May 14, 2026
Est. Refi. Payment $883/mo*
Refinance Your Home

$141,800

Trulia Estimate
as of May 14, 2026
Est. Refi. Payment $883/mo*
Refinance Your Home
3 Beds
2 Baths

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

Monthly lot fee is $325 new kitchen appliances, new carpet, new paint.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.

Home Highlights

Parking
No Info
Outdoor
No Info
HOA
None
Price/Sqft
No Info
Listed
No Info

Home Details for 42General Stuart

Property Information

Year Built
Year Built: 2011
Property Type / Style
Property Type: Mobile Manufactured

Price History for 42General Stuart

DatePriceEventSource
03/24/2021ListingRemovedN/A
09/12/2016$25,000ListingRemovedN/A
06/14/2016$25,000PriceChange
N/A
03/12/2016$30,000Listed For SaleN/A
Skip to last item
  • Results are loading
Skip to first item

Comparable Sales for 42General Stuart

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
566 Sycamore St, Crescent Springs, KY
2.09
Mobile / Manufactured
$215,000
01/28/26
3
2
1,120
2461 Cherry St, Crescent Springs, KY
2.11
Mobile / Manufactured
$228,000
05/15/25
3
2
-
992 Capitol Ave, Elsmere, KY
3.40
Mobile / Manufactured
$195,000
07/28/25
15
138
1,248
2205 Antoinette Way, Union, KY
6.62
Mobile / Manufactured
$287,000
12/04/25
3
2
1,134

Assigned Schools

These are the assigned schools for 42General Stuart.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Erlanger

At least 115 Trulia users voted on each feature.

  • 93 % Say it's dog friendly

  • 87 % Say car is needed

  • 85 % Say parking is easy

  • 82 % Say yards are well-kept

  • 82 % Say there are sidewalks

  • 79 % Say there's holiday spirit

  • 74 % Say kids play outside

  • 70 % Say people would walk alone at night

  • 64 % Say there's wildlife

  • 58 % Say neighbors are friendly

  • 57 % Say it's quiet

  • 51 % Say they plan to stay for at least 5 years

  • 50 % Say streets are well-lit

  • 37 % Say it's walkable to grocery stores

  • 33 % Say there are community events

  • 26 % Say it's walkable to restaurants

Learn more about our methodology.
  • Jordyn M. H.
    "I have lived here for three years and we love it. We are pregnant with our first child and we plan to raise them around here."
    1
    Flag
  • Jakedoan123
    "I have lived in Erlanger most of my life, have always felt safe. l would recommend it to anyone! "
    0
    Flag
  • Bethany B.
    "My apartment is right next to the highway, it's a quick two minutes to get to 75 and 275 which can then very quickly get me to 74 and 471. There are several bus stops near my apartment, which would be convenient if I actually took the bus."
    1
    Flag
  • Kasarra W.
    "nice independent neighborhood. Public transportation is hard. it only runs on the main road. good school district. "
    0
    Flag
  • Kevin K.
    "a small dog park or social area would be nice. Most all the neighborhood dogs are kept inside and owners use a leash. very rarely do you ever see a dog running on it's own. But a common area for dogs to run and socialize would be great. structure to climb or small obstacle course"
    0
    Flag
  • Jordyn M. H.
    "There’s always signs of community events but we’ve never been. They are mostly kid oriented and we don’t have kids."
    0
    Flag
  • Doug B.
    "I work from home, so I have no commute. When I did work outside the home, it was a slow go getting out of Northern Kentucky into Ohio."
    0
    Flag
  • Jackiemallin
    "Backyards are small, and back of house are butted up to backs of houses so not much privacy. Lots of dog walkers, no close dog park though .🙁."
    0
    Flag
  • Kathy
    "People walk their dogs often. They are willing to assist if a pet is missing by keeping an eye out and even offering water if spotted until you are able to retrieve. It’s a very friendly neighbor hood."
    0
    Flag
  • Jackiemallin
    "Close to work, quiet yet close to everything. I feel safe . Quiet neighbors . Clean area. Houses are newer . "
    1
    Flag
  • Evonne M.
    "schools are ok, neighborhood is ok. Very mediocre town. quaint. most houses are small to medium. very affordable living "
    0
    Flag
  • Khamiltongarrett
    "Small town feel close to a larger city. It’s like having the best of both worlds. Smaller independent school system. Close to Cincinnati’s zoo, museums, hospitals and FC Cincinnati soccer. "
    0
    Flag
  • waltmace
    "Just close enough to everything, not to far and not to close. It open for much more that others can bring into the area. Most people stayed here that came here till they died, nursing home, foreclose during hard times, and one divorce that came back."
    0
    Flag
  • Cullen W.
    "I have lived here for 9 years and it very nice area to live, landscaping is great, in the winter snow and ice removal is included in HOA fees which are the lowest of any in Cincinnati area, in the 9 years mine has went up only 10 a month, pets are welcome as long as they are under 30 lbs but there is an increase in HOA fees for dogs, there is a lot of wildlife that pass thorough, one night there was 15 deer outside my window,I would recommend a home warranty very affordable and really worth it in the long run, it is basically minor maintenance living, the buildings are secured by having to have key or be buzzed in. The Board of Directors have things going on like bingo, card games and pool parties all the time, and its nice to not even have to go out of the building to check your mail. It is rewired for cable and phones, or if you are facing the right direction you can have satellite TV as I do. The only thing I miss is doing yard work. There is a drawback having the ponds or lakes as to have the geese around at times but its nice to watch them raise their babies. The people in the building my unit is located are very nice and look out for each other. The Club House and Pool are very nice and well kept up, the only thing I miss is my grill on balcony but fire dept. will not allow them in condos with ceilings over them. "
    0
    Flag
  • edgrr9109
    "recently purchased a home here and so far, I love it. Neighborhood is great, elementary school is very close, sidewalk along every road, it's great"
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Homes for sale near 42General Stuart

Skip to last item
Skip to first item

Homes for rent near 42General Stuart

Skip to last item
Skip to first item

Off Market Homes Near 42General Stuart

Skip to last item
Skip to first item

Explore by feature

42General Stuart, Erlanger, KY 41018 is a 3 bedroom, 2 bathroom mobile/manufactured built in 2011. This property is not currently available for sale. The current Trulia Estimate for 42General Stuart is $141,800.