Welcome to your dream home! This stunning custom-built brick residence in Modesto offers the perfect combination of luxury, functionality, and investment opportunity. With 4-5 spacious bedrooms, 3 full bathrooms, this property adapts to your lifestylewhether you're growing a family or launching your next short-term rental venture. Sitting on a generous 0.33-acre lot, the home features 2,950 sq. ft. of beautifully designed living space, including a converted tandem garage with its own AC unitperfect as a private guest suite, office, or Airbnb rental. The heart of the home is the gourmet kitchen, equipped with a double oven, brand-new appliances, and ample counter space for entertaining or daily living. Step outside to a fully renovated backyard retreat, complete with a half-court basketball setup, tranquil pond, and a new 9-foot privacy fence, creating your own secluded oasis. Located directly across from a local school and just minutes from shopping and freeway access, this home delivers convenience, comfort, and income potentialall in one incredible package.