One of my buddies lives adjacent to Fresno. House was in need of complete redo inside and out. Morera was like that when purchased and got the full redo inside. Serbal got it inside and out.
Segovia needs lots and it’s kinda busy there but recent addition of 100 speed bumps should help. Been driving that road daily for a couple decades but avoid like plague now.
Market is just really slow now. It typically slows a lot this time of year and that’s been amplified by rates and markets. If you want to go now and house isn’t perfect you need to get aggressive on price or wait till Spring
The other one on market is kinda wonky model IMO and lot is very substandard for that house. I remember it struggling years ago to sell also