Tamra Ulmer

Sensational French Country Villa awaits you in breathtaking Scottsdale Country Club. Upon entering the property, you are greeted by a charming foyer. Dramatic soaring wood beamed ceilings, crown molding, custom lighting and window treatments adorn this wonderful home. Travertine flooring everywhere except for the bedrooms, which have carpet. You will love the updated gourmet kitchen with hickory cabinets with lighting and pull out drawers, granite counters, a Farm sink, insta-hot and S/S appliances. The eat-in Kitchen features a bay window with plantation shutters. The kitchen overlooks the family room for effortless entertaining. The living room features a stunning custom stone fireplace. The master bath boasts glass block, a jetted tub and a closet designed by Classy Closets.

RECENTLY REDUCED Looking for your dream home? This newly renovated home will inspire you to make it your own. Through our seamless leasing process, this beautifully designedhomeis move-in ready. Our spacious layout isperfect for comfortable living that you can enjoy with your pets too; we?re proud to be pet friendly.Our homes are built using high-quality, eco-friendly materials with neutral paint colors, updated fixtures, and energy-efficient appliances. Enjoy the backyard and community to unwind after a long day, or simply greet neighbors, enjoy the fresh air, and gather for fun-filled activities.Ready to make your next move your best move? Apply now.Main Street Renewal offers flexible home tour scheduling between 8 a.m. and 8 p.m., 7 days a week.Main Street Renewal is a licensed real estate broker and does not advertise on Craigslist. We?ll never ask you to wire money or request funds through a payment app via mobile. The fixtures and finishes of this property may differ slightly from what is pictured.

4th Floor Condo with Tuscan finishes, including authentic Venetian plaster. Bring your imagination AND MAKE IT YOURS! 24 hour manned guard gate, 9-hole golf course, tennis courts, heated pools, spas, saunas. Community center has fitness rooms, library, game room, media room, business center, ceramics & arts room, and woodworking. You'll love the many activities at the clubhouse! Plus, enjoy living in the BEST location ever!! Close to loop 101, Old Town Scottsdale, Fashion Square and so much more.

Located in The Towns at Annecy, this beautiful townhome is like new and features 2 bedrooms and 2 bathrooms. Situated on a premium lot that is directly across from the community pool and lake with a picturesque bridge! The upgrades kitchen boasts Tahoe cherry slate cabinets, quartz countertops, stainless appliances, and a dedicated pantry. This opens to the great room making it ideal for comfortable living or entertaining. The primary suite is on the main level and is quite spacious and features a walk-in closet along with a spa-like bath with tile surround shower and dual vanities. Downstairs you will find the secondary bedroom with full bath. This unit has tons of natural lighting, upgraded 12'' x 24'' tile flooring in the main living spaces and bathrooms, neutral carpeting in the bedrooms, and sleek modern mission style stair railing. The tandem two-car garage is clean as a whistle and even has epoxy flooring! Located in the Towns at Annecy is a gated community surrounded by lakes, access to walking and biking, a community pool, and park. Conveniently located to shopping, dining, and easy freeway access. San Tan Mall and Trader Joes are so close!!

Rare opportunity to buy of the most sought after and premium units in the community. Beautiful and spacious 2 bed / 2.5 bath Townhouse with sunset views over the golf course and greenbelt. Unit boasts high ceilings and an attached garage. Only one shared wall away from bedrooms. No neighbors above or below. The highly desirable gated Milano Terrace Private Residences Condominium community features courtyards, BBQ grills, fountains, 2 sparkling community pools, koi pond, fitness center, and onsite community director. Fireplace in family room for those cold nights, inside laundry with washer and dryer, bedrooms with walk-in closets, plus attached direct-entry garage. Close to freeways, shopping, restaurants, and overlooks a golf course.

Popular floor plan in the desired Anthem area. The granite counter tops in the kitchen and the gas cook top are a cook's dream. This house has space and room for all your hearts desires. Clean and well maintained. Enjoy watching the sunset on the mountain views to the North. The split floor plan allows for privacy and also affords you generous room sizes. The addition of an enclosed den could easily be used as a fourth bedroom. You can live like royalty in this Majesty floor plan.

One Story- CUSTOM, with a NEW ROOF (2023) LOWEST priced home in Scottsdale's Exclusive Gated Community, Ventana Foothills- Sonoran Arroyos. AND On a Tranquil Cul de Sac. Enter into the Grandiose Foyer NOTING the Spaciousness of the Great RM with Soar

Your private desert oasis awaits! Double - gated entrance with circular drive leads to this rare basement home on over an acre in a premiere area of Scottsdale. As you enter, the gorgeous McDowell Mtn vistas are visible from every north facing window as a backdrop to the amazing backyard! This spectacular home features 5 bedrooms/5 baths, in addition to a beautiful Study and Powder Bath. Over the last several years, incredible updates to Kitchen, Baths, Primary Suite have been completed that enhance the beauty and value. The recently upgraded gourmet Kitchen will not disappoint with Taj Mahal granite countertops, large gas range, kitchen island, open to the spacious Family Room/Wet Bar and Butlers Pantry. The lower level is perfect for family entertainment featuring a movie/gaming wall with built in cabinetry, wet bar and recently added custom wine cellar. An outdoor patio has a staircase for access to back yard. The rear yard is a fantastic, resort-like oasis with negative edge pool, spa, fireplace/sitting area, grassy lawn and putting/chipping green complete with your own bunker. Built-in BBQ area with pizza oven and ample covered terrace. This is the ultimate family entertainment home. Coveted Scottsdale School District and close to BASIS Scottsdale school.

Your new home awaits in Mission Park Ranch community in Chandler. Nestled on a quiet cul-de-sac, this single-level residence offers the perfect blend of comfort and functionality. A split floor plan featuring 3 bedrooms, 2 bathrooms, and numerous recent improvements, this home is the epitome of turnkey living. The home has been lovingly cared for by the current owner since 1997 and the pride of ownership speaks for itself. The property has excellent curb appeal with its well-manicured front yard, mature landscaping, and a spacious driveway leading to the two-car garage. You will surely love the beautiful shade trees. The eat-in kitchen has tons of natural light, is generous in size, and has stainless appliances. A great flow for entertaining as this opens up to the formal dining room featuring a custom built-in sideboard buffet ideal for extra storage and serving your guests. A generous size family room perfect for relaxing after a long day. The primary suite is spacious and has a spa-like bath complete with a stand alone claw foot tub, a custom tile shower, an ornate dual vanity, and a walk-in closet. You will also find an exit to the backyard from the primary bedroom! The secondary bedrooms are plentiful in size and share a full bathroom. You will certainly love this 9,500 square foot lot and all it has to offer! An amazing oversized patio, a lush grassy yard, and so many shade trees! The roof and the HVAC system have been replaced within the last 4 years. The water heater was replaced this year. Energy-efficient, upgraded windows not only enhance the home's appearance but also keep utility bills low! This home is located near great shopping and dining. Commuting is a breeze, as the home has convenient freeway access. 1350 N Blackstone is not just a house; it's a home where cherished memories are waiting to be made. With its thoughtful upgrades, great location, and impeccable maintenance, you don't want to miss out on the opportunity to make this beautiful home yours!

My name is Grant and I was born and raised in Arizona. I have lived in Prescott for over 23 years and have been a real estate agent since 2022. I enjoy working with my sellers and buyers almost as much as I enjoy training for my next Spartan race and spending time with my amazing family. You might run into me at Costco shopping for the best deals on bulk beef, or you may see me running around on the many incredible trails Prescott has to offer.  

Grant Cool

Ryan Comstock is widely regarded as one of the top Realtors in Tucson, AZ. A Top 1% agent serving Southern Arizona since 2006, Ryan brings 20+ years of experience and more than 900 homes sold to every transaction — earning consistent recognition as one of the best Realtors in Tucson and a reputation for award-winning, 5-star customer service.

Ryan works with home sellers, buyers, luxury clients, and investors throughout Tucson, Oro Valley, Marana, Sahuarita, Vail, and surrounding Arizona communities. His track record spans single-family homes, condos, luxury properties, multi-family properties, and land.

Tamra Ulmer

About Tamra Ulmer

Contact Agent

Recent property sales & transaction history

9 properties

Scottsdale

Family Home

$400,000 to $850,000

1,200 ft² to 2,900 ft²

Properties for sale by listing agent Tamra Ulmer

$610,000

Similar real estate agents nearby