REALHUB is on fire today

Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

Popular features

Community features

Association

Property features

Waterfront

View

Exterior Features

Interior Features

Style

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

Welcome to Via Vista!  a gated 18-home enclave in Paradise Valley, this single level home offers unparalleled luxury and sophistication, the home features 4 bedrooms-one as office- 4 bathrooms, and 3791 square feet of meticulously designed living space.

An impressive  entryway opens to soaring ceilings and an expansive living room with  walls of glass — seamlessly blending indoor and outdoor living. The chef's kitchen is  outfitted with top-of-the-line appliances, updated quartz countertops, center island ,custom cabinetry,  pantry, family room with wet bar opens to kitchen, expansive primary suite with fireplace, updated bath and large walk in closet, resort-style backyard is designed for entertaining, featuring a play pool/spa, BBQ station, fire pit, and covered patio 3 car oversized garage with storage cabinets, workbench. minutes to Fashion Square, parks, schools you name it! see the motion video!
#6840137

Paradise Valley

7150 E Balfour Road

4 Beds

None Baths

3,791 Sq.Ft.

$2,980,000

MLS#: 6840137

INCREDIBLE LOCATION, IN THE MIDDLE OF THE BILTMORE AND ARCADIA AREA, 100% OCCUPIED, JUST DOWN THE STREET FROM LA GRANDE ORANGE CAFE, CHOP SHOP AND POSTINO, LARGE PARKING LOT, INDIVIDUALLY METERED FOR ELECTRIC AND GAS, MOST UNITS HAVE HARDWOOD FLOORS, GREAT TENANTS, OVER 1/3 ACRE ON TWO LOTS, ONSITE LAUNDRY, COPPER PLUMBING. INTERIOR INSPECTION ONLY WITH ACCEPTED OFFER, TENANT RIGHTS,
#6403398

Phoenix

3102 E CAMPBELL Avenue

None Beds

None Baths

N/A

$2,980,000

MLS#: 6403398

Located in the highly desirable city of North Scottsdale in the gated community of Rio Mountain Estates, rests the most stunning soft contemporary home that defines the luxury of Arizona living. Step inside the open concept floor plan, which boasts 4 bedrooms and 3.5 spacious bathrooms. This beautiful home features seamless indoor/outdoor living which creates an inviting space for entertaining and resort-style relaxation. A stunning chef's dream kitchen featuring top-of-the-line stainless steel appliances, Rift Oak wood cabinets, oversized natural quartzite island, large prep-sink, wall-mounted pot filler and custom hood, along with the spacious game room with bar tap is perfect for all your family fun gatherings. 

The lavish primary suite offers a grand bathroom with an oversized marbl walk in shower and separate soaking tub.  Large sliding glass doors in the living room bring you to your own private oasis pool and spa complete with built in BBQ and custom fire pit. Along with LED energy efficient lighting and SmartHome Control 4 technology throughout the entire home. As any homeowners dream, this 1 acre property is complete by offering unforgettable views of natural landscape and grand mountain views of Four Peaks, Mazatzals, McDowell and Granite Mountain.
#6383638

Scottsdale

28816 N 151ST Street

4 Beds

None Baths

4,262 Sq.Ft.

$2,980,000

MLS#: 6383638

Highlight Reel: 6 bedroom main house + 1 bedroom guest house + 3 car garage + Arizona Country Club + $500/sf 

This is a timeless architectural style as is, or ready for your custom cosmetic touches. It has unmatched features, and is a literal one of a kind in the area. The home is well below replacement cost, as it could not be rebuilt for the same price.

Seller is open to all offers with supporting data.

Private tours available today. for visitors, extended stays, or a private office, all while maintaining connection to the serene courtyard setting.  Rich architectural details, warm textures, and generous gathering spaces define the home's character, blending classic Mediterranean influence with modern comfort.  Ideally located near dining, shopping, and the Arizona Country Club, this estate offers both elegance and convenience in one of the area's most desirable settings.
#6971076

Phoenix

5807 E ORANGE BLOSSOM Lane

6 Beds

5 Baths

5,729 Sq.Ft.

$2,980,000

MLS#: 6971076

Welcome to one of the most extraordinary custom estates in Gilbert, Arizona. This highly upgraded Forte built residence offers resort-style living, unparalleled entertaining spaces, and a breathtaking backyard oasis built by Red Rock Pools and featured on HGTV and The Travel Channel. At the heart of this 1.2 acre gated property is a gorgeous 140,000-gallon swimming pool, featuring a 12-foot waterslide, grotto, elevated 15-person spa, kid pool, and separate adult and teen swim areas - creating a true private vacation retreat. The backyard also boasts two outdoor kitchens, an outdoor dining room with gas fireplace and two distinct outdoor living rooms. Putting greens sit adjacent to a private skate park near the rear of the lot, completing this one-of-a-kind outdoor experience. Guests will enjoy complete privacy in the 2400 sq. ft. detached guest house, which includes two bedrooms with two full bathrooms, a full wall of sliding glass doors with a view of the waterfall, a full kitchen, dining and living spaces, laundry room, and covered patio.

The main residence features a desirable split floor plan, anchored by a luxurious primary suite with fireplace, wood flooring and exquisite bathroom. Formal living spaces showcase a large bar area with backlit onyx wall, alabaster light fixtures, and granite countertops. The custom chef's kitchen is equipped with a Viking gas range and top-of-the-line appliances. Secondary bedrooms include one en-suite bedroom and two bedrooms with Jack-and-Jill bathroom, all with generous walk-in closets.
A three-car garage plus a two-car garage that has been converted into a private distillery and cigar bar, adding yet another unforgettable element to this showpiece estate.
Truly a once-in-a-lifetime residence designed to impress, built to entertain, and impossible to replicate.
#6975874

Gilbert

1128 E DESERT Court

6 Beds

5 Baths

3,960 Sq.Ft.

$2,980,000

MLS#: 6975874

ABSOLUTELY THE MOST AMAZING VIEW IN ALL OF FOUNTAIN HILLS! 360 degree of Breathtaking Views. An atmosphere of tranquility awaits you at this one owner custom home. Timeless architecture & desert living at its best. Details throughout this immaculately maintained estate exude true pride of ownership.gated, 2 acre, mountain top, 8,645 livable sf., 7 bed, 8.5 bath, 7 fireplaces, finished in 2011. There are NO steps anywhere on the approx. 6,000 sf. main level! In fact, there are no steps anywhere from the front drive way to the 60 foot long negative edge pool & spa which are on the main level! Open floor plan.TWO LARGE GUEST HOUSES! 18' retractable wall of glass, 36'' & 24'' travertine. Most bedrooms have solid wood floors, are ensuite, have outside access & lend themselves to guests & more.. Live in~help. Kitchen has 2 of everything, 2 dishwashers, 2 ovens, 2 microwaves etc. Game room, spa/massage room, 6 car garage w/ car lifts! Could be 10 car! Solar power. Don't miss this rare opportunity!

It has forever-unobstructed world class views. The astounding views to the rear are of Camelback Mountain, panoramic city lights, countless other mountain ranges near and far, and the entire world as far as you can see! The views to the front are Four Peaks, the McDowell Mountains, and sweeping city light views all centered on the famous fountain!

Located in the prestigious gated Crestview community of other very large homes, this extremely private and quiet residence is on the very top of the highest mountain ridge in Fountain Hills!

Agents who have seen it say: It has one of the best floor plans in a mountain top home. The floor plan is very open with massive walls of glass to bring the breathtaking views into every room! It is light and bright and extraordinary for living and entertaining. The main areas have huge 36" and 24" imported Italian travertine in the beautiful Versailles pattern. All the secondary bedrooms have solid wood floors. The only room with carpet on the main level is the theater! There have never been any pets in this home, so it may be a great choice for chemical and allergy sensitive people.

The 6,000 sf. main level has a grand foyer with double groin ceilings and a great room, with 18 feet of disappearing glass that automatically retracts into the wall. There is a family room and a bar, both with TV's, and a cliffside circular glass lounge room. WOW! Furthermore, the main level has a dining room with French doors opening to the huge resort~like front court yard and a decked out library/den that also opens to the front court yard. The enormous luxurious master bedroom, on the main level, has the spa right out it's back door, and has one of the best panoramic views imaginable right from your bed! The main level also has 4 bedrooms, 5 1/2 bathrooms, 2 laundry rooms, a unique wine room, and a large media/theater room with a performance area for the kids. The media/theater room has its own bathroom and a huge closet. Adjacent to the media room is a handy door from the house to the back yard, outdoor kitchen and BBQ area. It simply has everything you could dream of.

The dream designer kitchen has a hidden TV and 2 of everything ~ 2 dish washers, 2 ovens, 2 microwaves, and all appliances are hidden as well, which gives it an extraordinary look. The home also has patios and balconies all around the home and off every bedroom, except one. The exterior, and the 7 fireplaces are laden with copious amounts of real cantera.

The versatile floor plan of the house permits wonderful accommodations for your guests and help.

The first guest accommodation has a second huge master bedroom with entry foyer and direct access to the back yard, front of the house, the pool, and by elevator or stairs to the main home. It is immediately adjacent to the game-room, kitchenette, and exercise/massage room. Because of the versatility of this floor plan all these areas can be shared with both the guest accommodations and the main home.

The second is a guest house that has direct access to the main house via an elevator. It also has a cantera staircase down to the front court yard. This guest house is a very private 2 room luxury suite with an entry foyer , bedroom, living room and kitchenette. Furthermore, there are two amazing patios with sweeping mountain and city light views.

The third guest accommodation is an attached casita with kitchenette which is also off the front court yard. This casita would also be perfect as a private office with front entry access through the huge front courtyard. (The den/library in the main home also opens to the front courtyard)

There are also several other large bedrooms that lend themselves to live~in help and guests, as all bedrooms are ensuite, have huge walk in closets, and most open to outside courtyards and have front and back access.

All guest accommodations are without interior steps and with easy access to the main part of the house, the pool and spa, the main patios, the front and back of the house, and the garage.

There is a Spa/massage/exercise room with an earthy stone~laden bathroom and steam shower. (A closet off the hall is pre-wired to be a sauna)

Garage ~ There is an huge oversized, extra high & extra deep 40x23 garage that can park four cars, plus toys. It has 9' tall 18' wide garage doors to accommodate car lifts and long tall boats. There is a small workshop in the garage and also an air conditioned work room inside the house so you can tinker in comfort.

THE 4 CAR GARAGE CAN EASILY BE MADE INTO A 6 OR even 10 CAR GARAGE! ONE OF THE TWO DIFFERENT GUEST CASITA IS RIGHT NEXT TO THE GARAGE. THE WALL BETWEEN THE 365 SF. CASITA AND GARAGE COULD BE REMOVED SO THE CASITA, COULD BECOME TWO MORE BAYS WHILE KEEPING THE BATHROOM & KITCHENETTE TO MAKE A REALLY DECKED OUT GARAGE! FURTHERMORE, PART OR ALL OF THE GARAGE COULD EVEN BE AIR CONDITIONED IF YOU WANTED. YOU WOULD STILL HAVE 3 GUEST ACCOMMODATIONS/HOUSES AND OVER 8,000 SF. OF LIVABLE FOOTAGE. SO, IT DOES NOT DETRACT FROM THE HOUSE TO CONVERT THIS ONE GUEST CASITA TO GARAGE BAYS. ALSO, THE CEILING IS TALL ENOUGH TO ACCOMMODATE CAR LIFTS IN ALL BAYS. THE LADDER YOU SEE IN THE PHOTO GOES TO A 400 SF. TEN FOOT TALL STORAGE ROOM OVER THOSE 2 BAYS. THIS WOULD THEN EQUAL A 10 CAR GARAGE IF YOU WANTED! WOW! ALSO, A THERE IS A VERY FLAT, VERY EASY TO BUILD VACANT LOT NEXT DOOR THAT IS ALSO FOR SALE IF YOU WANTED TO BUY IT AND BUILD YOUR DREAM GARAGE!

Electronics & Furniture ~ The home has a state of the art Crestron media and audio system. Everything is hard wired including the computer network so you don't have to worry about any wireless! Also, all the TV's, stereo equipment, and theater equipment come with the home! There is even a disappearing TV that elevates remotely out of the family room fireplace that is included. In fact, all the furniture is negotiable as well, so you could get this home turn~key with everything you see! (except a few small exclusions)

There is also a 19x22 foot additional room above the garage that is not included in the square footage. It could be an artists studio, collector's room, or a huge storage room. If you want that extra large room for whatever...you've got it! We did not include it in the square footage because it can only be accessed from the garage.

Green and energy efficient features This property was built to be green and energy efficient. The house has solar power, and the main hot water heater is also solar powered. Furthermore, the property has specially placed insulation that increases the energy efficiency. The electric bills for this 8645 livable sf. property are in the $200's, on average. Amazing! Also, it has a "no chemicals added" natural whole house water purification system.

This extraordinary property is on a private Cull de sac that looks like it is on top of the world. The exterior has synthetic stucco for a low maintenance smooth clean look. Just past the outdoor kitchen there is a 15 by 20 foot flat area that is perfect for grass, a putting green, or any thing you want to do with it.

The owners were on site almost every day while the home was under construction making sure this home was built to the highest of standards... and built as you would have wanted.
#6110274

Fountain Hills

11132 N VIENTO Court

7 Beds

None Baths

8,645 Sq.Ft.

$2,978,000

MLS#: 6110274

Gorgeous, State-of-the-Art Smart Home Directly on the First Hole of the TPC! 
Directly situated on the First Hole of the Prestigious TPC Stadium Golf Course, home to the iconic Waste Management Phoenix Open, this breathtaking, completely renovated Smart Home offers an Exceptional Living Experience with Irreplaceable Views in the Heart of Scottsdale. Meticulously rebuilt over three years, this residence seamlessly blends cutting-edge technology, world-class finishes and a prime location to create an entertainer's dream. The expansive open floor plan, custom design elements, and luxurious upgrades throughout make this property truly one-of-a-kind.

As you step through the custom 6' double steel entry door, The Beast, imported from Ireland, you are welcomed into a grand foyer, where a Limited Edition Peter Lik Acrylic Artwork featuring Horseshoe Bend, an Arizona Natural Wonder, is showcased above a one-of-a-kind Acacia wood entry table from Thailand. The chef's kitchen is nothing short of spectacular, featuring Scandinavian White Oak cabinetry with German slow-close hinges, 2.5" thick Calcutta Gold Quartz countertops, and Dacor Wi-Fi-enabled appliances. The massive 11' x 6' Calcutta Gold Quartz Island serves as the true centerpiece of the kitchen, offering an inviting space to gather and entertain.

The home's design effortlessly connects indoor and outdoor living, made possible by the 24' x 10' Precision Automation Stacking Pocket Doors, which open up to a spacious and beautifully designed outdoor living area. The office or optional bedroom features European Steel French Doors and a hidden Steel Vault Door that leads to a state-of-the-art Safe Room with 14-gauge steel panels, dedicated Wi-Fi, and a climate-controlled environment, perfect for those seeking security and privacy.

Each of the bathrooms provides a spa-like experience, with gorgeous Starfire Glass. The private backyard is an entertainer's paradise, featuring 24x24 Michelangelo Porcelain Pavers, a Saltwater Pebble Sheen Bella Blue Pool, LED multi-colored lighting, and a fully automated Aqualink Pool System for ultimate convenience.

This home is fully equipped with whole-home automation, including Lutron lighting, built-in Surround Sound, integrated iPads, and automatic day and night shades in every room. The property also boasts a comprehensive security surveillance system, a high-efficiency HVAC system with Trane XV18 air conditioners and a Whole House Surge Protector.

The garage is climate-controlled and designed for both luxury and functionality, featuring Epoxy Floors, a Hi-lift insulated garage door, ideal for car enthusiasts and a Versa Lift garage storage elevator for added convenience.

Additional premium systems include a whole-house Aquasana Rhino Max Flo water filtration system and a Rinnai Super High-Efficiency tankless water heater, ensuring that no expense has been spared in creating the perfect, turn-key property.

Located within walking distance of the Fairmont Scottsdale Princess, a Luxury 5-Star Resort and Spa, the TPC Stadium and Champions Golf Courses and minutes away from Mayo Clinic, Scottsdale Quarter, Kierland Commons and Westworld, which hosts the iconic events like Barrett Jackson Car Auction and the Arabian Horse Show.

With Stunning Unobstructed Golf Course Views, Sophisticated Technology, Luxury Appointments, and Timeless Design, this is your Rare Opportunity to own a truly ONE-OF-A-KIND home in one of Scottsdale's most sought-after locations.
#6935414

Scottsdale

17444 N 79TH Street

3 Beds

3 Baths

2,842 Sq.Ft.

$2,977,700

MLS#: 6935414

Beautiful Ranch Estate in a one of a kind neighborhood is coming available. This Home is generously priced below Current Market Appraisal. The property delivers total privacy in a small  6 home Gated 1 acre minimum Community. Horse property with NO HOA. Unique opportunity to own an original owner/builder estate. Property has been totally remodeled top to bottom while being meticulously maintained. The estate sits on1 acre with an additional ⅓ acre that is ready to be whatever the next owner needs. Barn, Stables, RV Garage, Sports Court, there is plenty of room to comfortably fit everything.
Both convenience and exclusivity are in this thoughtfully designed home built for large families or multi-generational families. Main Floor includes  3Bedrooms 2 1/2 Baths. See ''More'' Basement includes an additional theater room/family room, 2 baths, 2 bedrooms, and its own laundry room and storage. The attached Casita offers its own entrance, Full kitchen, Bathroom, laundry facilities, family room/Studio and even a small private yard. In the detached garage you'll again find endless possibilities with an air-conditioned storage room and additional room for private gym, office, whatever your needs are. Plenty of mature landscaping throughout the property with freshly remodeled amenities also make this home unique.  This Estate offers mature Citrus orchard of fresh oranges, grapefruit, and tangelos that bring the quaint smell of spring to your backyard. A Large outdoor covered patio with Gas BBQ, beautiful seating area, and Gas Firepit. Entertain to your hearts desire with free-standing gazebo and 30,000-gallon heated pool and spa make it ideal for all your entertaining dreams.  Bring your horses, boats, Rv's etc. as there is room enough for everything.  Detached garage offers tall Boat garage. This Ranch Estate embodies the best of both worlds offering NO HOA while also nestled in a gated enclave. Top-of-the-line Gilbert Regional Park just a walk down the street. Shopping and Freeway Access 5 Minutes away. What a Great Property with location, location, location!
#6761403

Gilbert

2677 E QUEEN CREEK Road

5 Beds

5 Baths

6,343 Sq.Ft.

$2,977,500

MLS#: 6761403

Uncompromising VIEWS-LUXURY-PRIVACY are afforded by this 4BR/6BA Tuscan Masterpiece completed in 2015. Set high within the picturesque, guard gated community of 
Canyon Pass at Dove Mountain, an inviting stone facade and cupola turret entry welcome you. Striking 5,826 SF interior boasts dual Master Suites, Guest Bedroom, Exercise Rm/Office/4th Bdrm, Wine Room, 13'-15' backlit coffer ceilings, crown molding,  baseboards, smooth Travertine tile, Granite-Marble-Onyx countertops, and Cherry Wood  cabinetry. State-of-the-art Kitchen boasts side-by-side Sub-Zero refrigerators & Wolf appliances. Added 2,250 SF of covered porches, 9,000 SF of pavers, 3 car garage, 3 fireplaces, 5 electronic sunshades, 4 HVAC zones, Surround Sound, Saltwater Pool/Spa, Summer Kitchen and  
Top-of-the-World Views!
#21625369

Marana

3980 W Cayton Mountain Drive

4 Beds

4 Baths

5,826 Sq.Ft.

$2,975,000

MLS#: 21625369

Your dream home awaits on this over 1-acre lot located at the end of a cul-de-sac in the desirable gated Estados of Circle G. Truly LUXURY from the inside out. Retreat to your own oasis backyard with lighted tennis court that can easily be converted to pickle ball also basketball court, mini golf course with 3 chipping pads, 2 large sand traps, built in BBQ, TV's, all why overlooking a heated sparkling saltwater pool & spa alongside a gas fire pit area to enjoy a cozy night in. State of the art Sonos & WI fi system interior/exterior. The inside does not disappoint, this over 5500sq' 4BR 6 BA home boasts a large home theater /game room with 110'' black diamond screen, Epson projection screen and Sony surround sound system, pool table, shuffleboard with its own beverage fridge, no need to go out, can enjoy family fun night in the luxury of your own home. The gourmet kitchen features Wolf appliances, gas stove top, 2 ovens, walk-in pantry, a walk-through coffee bar area, just around the corner is a separate wine room with large capacity wine fridge. The Master retreat has a cozy fireplace, large walk-in closet with custom shelves & lots of hanging area, also your own washer/dryer. All bedrooms include their own private en suite bathrooms and walk in closets. Wood shutters & solid wood doors throughout. Beautiful mature trees to offer lots of shade, separate gated dog yard. Enormous 4 car extended garage with air-conditioned workshop and lots of storage cabinets, huge driveway for plenty of guest parking, large rolling RV gate. The attic is equipped with a motorized lift with a large walk-in area to store all your Xmas decor. 3 new A/C systems 2023, new pool pump & salt system 2023, interior of home & exterior block wall has been sealed for scorpions. Fully secured by ADT security system and cameras on all doors, driveway, and yard.
All of this and still there's more! Enjoy the country club lifestyle with Seville Golf & Country Club, you can ride your golf cart over to enjoy a day of golf, or family fun with 4 pools, water slides, tennis, pickle ball restaurants & more!! 
For info on the country club lifestyle please visit Seville Country Club.
#6781609

Gilbert

4477 E TURNBERRY Court

4 Beds

None Baths

5,514 Sq.Ft.

$2,975,000

MLS#: 6781609

Stone Canyon! Exquisite 2015 total remodel nestled at the base of Camelback Mountain with astounding views. This 5 bedroom 5 1/2 bath masterpiece has been recreated and designed using a transitional theme, the highest caliber materials and a soft yet current color palette. From the moment you enter, the 20ft ceilings and a wall of glass framing the sheer rock cliffs will amaze. The expansive living and dining room flows effortlessly into the kitchen and family room. The master suite is an elegant and private retreat with nearby library / den while 3 separate bedroom and bathroom suites occupy the other side of the house. The guesthouse is of the same caliber as the main home and has its own kitchen and separate bedroom. The enormous 1300sf garage could easily house 6 vehicles Deep covered patios  provide ample shade and open to the lagoon style negative edge pool with grotto , slide and waterfall. The home is effectively all new from the AC systems, tankless water heaters, hardwood flooring, beamed/boxed ceilings, marble counters and custom glazed cabinetry, exquisite light fixtures, LED lighting , Sub Zero and wolf appliances including wine locker, beverage drawers and  ice maker.   No expense has been spared on this exquisite home. A complete remodel in  2014/2015  has transformed this 1998 built home into a residence offering a new home experience.
#5219322

Paradise Valley

5718 N 54TH Street

5 Beds

None Baths

5,413 Sq.Ft.

$2,975,000

MLS#: 5219322

Come experience this COMPLETE RENOVATION located on a fabulous golf course lot in gated Enclave, floor plan redesigned featuring  2 master suites one DOWNSTAIRS, Extraordinary light fixtures , natural wood floors, All bedrooms ensuite with walk in closets,  Incredible materials used throughout including QUARTZ, MARBLE, SLATE in  baths and kitchen , Rare 3 car garage, SUNSETS AND MAGNIFICENT  VIEWS OF THE ARROYO GOLF COURSE! ,
#6217010

Scottsdale

7878 E GAINEY RANCH Road 16

4 Beds

None Baths

4,011 Sq.Ft.

$2,975,000

MLS#: 6217010

Don't miss the chance to make this spacious, North Scottsdale estate yours. The owners of this ranch-style residence spared nothing when transforming the property into a welcoming, tranquil home.

The fully renovated main house offers 3000 SF, 4 bedrooms and 3 baths, while the private casitas afford buyers an additional 3 bedrooms, 2 baths, kitchen and living space. 

There's plenty of space for indoor relaxing, outdoor fun, fitness, guests and more. The 2.2 acre lot includes, detached 4 car garage, two casitas, a pool, an organic garden and basketball court, still with room for more. Privacy gates provide peace of mind for residents, while still enabling the retreat feel. 

This property offers so much and has an incredibly special feel you won't want to pass up.
#6767273

Scottsdale

24038 N 84TH Street

7 Beds

None Baths

4,406 Sq.Ft.

$2,975,000

MLS#: 6767273

Tucked at the base of the mountain range in coveted exclusive North Scottsdale's manned guard gate DC Ranch lies this architecturally significant stunning contemporary. High bones, mixed media finishes, soaring windows, chefs Wolf and Miele appliances, 4 fireplaces, Poggenpohl custom cabinets imported from Europe throughout, surround sound and AIA award winning house. Split floorplan, separate den office, saturated with natural light and windows capturing every view. Highest end finishes throughout the home, architecturally significant, you couldn't build such a home for under 5 million. Steps from golf course and biking distance to Market Street shops and DC Ranch Country Club. Beautiful walking paths just outside the door, a scenic modern oasis. Beautiful real wood floors just refinished
#6160592

Scottsdale

9820 E THOMPSON PEAK Parkway 707

5 Beds

4 Baths

6,220 Sq.Ft.

$2,975,000

MLS#: 6160592

Sandstone Condominiums is a low density, single story, garden style condo community located in the highly sought after 85018 area code. The property offers several potential options for investors by 100% of the ownership of the community. It has been previously been approved for 15 luxury townhomes, It can be updated and sold off individually , or can be updated for a light value add. The community is comprised of 10 1 bed/1 bath 676SF units, 1 junior 1 bed/1 bath 468SF unit, and one 2 bed/1 bath 1008SF casita. All units have in suite laundry & under roof parking next to each unit. The community offers a private pool and a large greenbelt with several large shade trees. Roof was replaced within the last year. Seller will consider carry or wrap financing with 40% or more down.
#6280531

Phoenix

3426 N 38TH Street 4

None Beds

None Baths

N/A

$2,975,000

MLS#: 6280531

1 ... 625 626 627 628 629 ... 666
* Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2024. First Multiple Listing Service, Inc.
 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by The Mandy Gold Team | Haymore Real Estate LLC via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by The Mandy Gold Team | Haymore Real Estate LLC via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.