500 N Main Street Dual use property on Main St! Zoned C1 non conforming, currently used as residential. This property offers so much versatility. Mid-century motif meets modern elegance in this fully renovated 4 bedroom home on almost half an acre lot in a great location! Custom home builder and interior designer updated entire home to include HVAC, plumbing, electrical, windows, stunning flooring, luxury fixtures, modern cabinetry, quartz counters, nice paint palette and siding. Roof is just 3 years old. The living room boasts the unique mid-century wood style attributes that opens up into the amazing kitchen with all new appliances and refrigerator. Bedrooms are spacious with ceiling fans. Plenty of storage, separate utility room with windows. Primary ensuite bathroom with a spa inspired full glass enclosed shower displaying the high end custom tile work. Guest bathroom has tub and custom tile work to ceiling. Open kitchen leads off to the back patio and enormous backyard perfect for entertaining and family fun. With almost half an acre there is plenty of room to accommodate a business and more. Mature trees pepper the lot making a picturesque setting. Don't miss this wonderful opportunity to own a beautiful place, move in ready to simply enjoy as home, business or both and located in the heartbeat of Joshua. This a super dual functioning place to own! Please feel free to verify all information with the city as we have done.