With your personalized Coldwell Banker Northland portal, you gain the ability to:
- Save Your Searches: Keep track of your preferred property criteria for effortless future searches.
- Receive Listing Updates: Get real-time notifications on new listings that match your preferences.
- Track Listings: Monitor properties of interest easily, from price changes to status updates.
- Add Notes and Messages: Keep all your thoughts and communication in one organized space.
- Customize Your Dashboard: Tailor your user experience for quick access to the most important features.
3754 E FLINTLOCK Drive, Queen Creek, AZ 85142
$1,389,999

Property Type:
Residential
Bedrooms:
5
Baths:
4
Square Footage:
3,180
Lot Size (sq. ft.):
41,778
Status:
Pending
Current Price:
$1,389,999
List Date:
3/23/2026
Last Modified:
7/06/2026
Overview
Description
Supplements: ... (Read more) With 5 spacious bedrooms and 3.5 bathrooms, plus an additional poolside half bath, there's room for everyone to relax and unwind. The chef's kitchen is fully upgraded with brand-new KitchenAid appliances, an induction cooktop, granite countertops, a large walk-in pantry, and abundant storage--perfect for both everyday living and entertaining. Set on nearly an acre, the property includes irrigation and mature citrus trees--five navel orange, one Meyer lemon, and one lime tree--adding charm and the perfect touch for fresh, poolside cocktails. This rare, turnkey property delivers a true paradise inside and out. Opportunities like this don't come often--make it yours today!
Listing Details MLS# 7001400
Location, Tax & Legal
- House Number
- 3754
- Compass
- E
- Street Name
- FLINTLOCK
- St Suffix
- Drive
- City/Town Code
- Queen Creek
- State/Province
- AZ
- Zip Code
- 85142
- Zip4
- 7968
- Country
- US
- County Code
- Maricopa
- Assessor Number
- 304-87-186
- Subdivision
- BREKANWOOD ESTATES
- Tax Year
- 2025
- Assessor's Map #
- 87
- Legal Description (Abbrev)
- LOT 8 BREKANWOOD ESTATES MCR 064940
- Assessor's Parcel #
- 186
- Tax Municipality
- Gilbert
- Taxes
- 7297
Contract Information
- Type
- Exclusive Agency
- Ownership
- Fee Simple
- Co-Ownership (Fractional) Agreement YN
- No
General Property Description
- Dwelling Type
- Single Family Residence
- Dwelling Styles
- Detached
- Exterior Stories
- Yes
- # of Interior Levels
- Yes
- # Bedrooms
- 5
- Full Bathrooms
- 3
- Half Bathrooms
- Yes
- Total Bathrooms
- 4
- Approx SQFT
- 3180
- Price/SqFt
- 437.11
- Horses
- Y
- Builder Name
- Custom
- Year Built
- 2005
- Approx Lot SqFt
- 41778
- Approx Lot Acres
- 0.959
- Community Pool Y/N
- No
- Private Pool Y/N
- Yes
- Fireplace YN
- No
- Elementary School District
- Chandler Unified District #80
- High School District
- Chandler Unified District #80
- Elementary School
- Charlotte Patterson Elementary
- Jr. High School
- Willie & Coy Payne Jr. High
- High School
- Basha High School
Remarks Misc
- Cross Street
- Higley & San Tan Blvd
- Directions
- Take Higley Coldwater Boulevard and turn left. Turn right on 174th. turn Right on Flintlock.. House is on your right.
Status Change Info
- Off Market Date
- 2026-07-06
- Under Contract Date
- 2026-07-05
Legal Info
- Township
- 2S
- Range
- 6E
- Section
- 35
- Lot Number
- 8
More Information
Basement
- Basement Y/N
- N
Parking Spaces
- Garage Spaces
- 3
- Slab Parking Spaces
- 3
- Total Covered Spaces
- 3
Residential Propane Tank
- Residential Propane Tank
- Owned
- Propane Underground Y/N
- Yes
Showing Notification Methods
- Showing Service
- Aligned Showings
- Text
- Yes
- Yes
- Phone Call
- Yes
Special Listing Cond
- N/A
- Yes
Construction
- Wood Frame
- Yes
Const - Finish
- Painted
- Yes
- Stucco
- Yes
Roofing
- Tile
- Yes
Association & Fees
- HOA Y/N
- N
- PAD Fee Y/N
- N
- Cap Improvement/Impact Fee
- 0
- Cap Improvement/Impact Fee $/%
- $
- Cap Improvement/Impact Fee 2
- 0
- Cap Improvement/Impact Fee 2 $/%
- $
- Land Lease Fee Y/N
- N
- Rec Center Fee Y/N
- N
- Rec Center Fee 2 Y/N
- N
- Ttl Mthly Fee Equiv
- 0
Lockbox Type
- Supra
- Yes
Architecture
- Other
- Yes
Master Bathroom
- Full Bth Master Bdrm
- Yes
- Separate Shwr & Tub
- Yes
- Double Vanity
- Yes
- Private Toilet Room
- Yes
Flooring
- Carpet
- Yes
- Concrete
- Yes
Window Features
- Dual Pane
- Yes
- Low-Emissivity Windows
- Yes
Private Pool Features
- Diving Pool
- Yes
- Heated
- Yes
Dining Area
- Eat-in Kitchen
- Yes
Heating
- Electric
- Yes
View
- Mountain(s)
- Yes
Kitchen Features
- Dishwasher
- Yes
- Disposal
- Yes
- Kitchen Island
- Yes
- Built-in Microwave
- Yes
- Pantry
- Yes
- Refrigerator
- Yes
- Reverse Osmosis
- Yes
- Walk-in Pantry
- Yes
- Electric Cooktop
- Yes
- Granite Counters
- Yes
Cooling
- Central Air
- Yes
Interior Features
- 9+ Flat Ceilings
- Yes
- Central Vacuum
- Yes
- Water Softener Owned
- Yes
Laundry
- Washer Included
- Yes
- Dryer Included
- Yes
- Inside
- Yes
Other Rooms
- Great Room
- Yes
Separate Den/Office
- Sep Den/Office Y/N
- N
Accessibility Feat.
- Zero-Grade Entry
- Yes
Road Responsibility
- City Maintained Road
- Yes
Technology
- Pre-Wire Srnd Snd
- Yes
- Cable TV Avail
- Yes
- High Speed Internet
- Yes
Fencing
- Block
- Yes
- Wrought Iron
- Yes
Water Source
- City Water
- Yes
Exterior Features
- Built-in BBQ
- Yes
- Covered Patio(s)
- Yes
- Gazebo
- Yes
Spa
- Private
- Yes
- Heated
- Yes
Sewer
- Septic Tank
- Yes
Parking Features
- RV Gate
- Yes
- Circular Driveway
- Yes
- Garage Door Opener
- Yes
- RV Access/Parking
- Yes
Irrigation
- Flood
- Yes
New Financing
- Cash
- Yes
- VA
- Yes
- Conventional
- Yes
Plumbing
- Electric Hot Wtr Htr
- Yes
Utilities
- SRP
- Yes
Existing 1st Loan
- Conventional
- Yes
- Treat as Free&Clear
- Yes
Property Description
- North/South Exposure
- Yes
Landscaping
- Grass Front
- Yes
- Yrd Wtring Sys Front
- Yes
- Auto Timer H2O Front
- Yes
- Auto Timer H2O Back
- Yes
- Irrigation Back
- Yes
Unit Style
- All on One Level
- Yes
Disclosures
- Seller Discl Avail
- Yes
- Agency Discl Req
- Yes
Possession
- Close of Escrow
- Yes
Association Fee Incl
- No Fees
- Yes
Assoc Rules/Info
- None
- Yes
Property Features
Special Listing Cond:
N/A
Architecture:
Other
View:
Mountain(s)
Master Bathroom:
Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room
Flooring:
Carpet; Concrete
Window Features:
Dual Pane; Low-Emissivity Windows
Private Pool Features:
Diving Pool; Heated
Spa:
Private; Heated
Dining Area:
Eat-in Kitchen
Kitchen Features:
Electric Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Reverse Osmosis; Pantry; Walk-in Pantry; Granite Counters; Kitchen Island
Laundry:
Washer Included; Dryer Included; Inside
Other Rooms:
Great Room
Interior Features:
9+ Flat Ceilings; Central Vacuum; Water Softener Owned
Technology:
Pre-Wire Srnd Snd; Cable TV Avail; High Speed Internet
Exterior Features:
Built-in BBQ; Covered Patio(s); Gazebo
Parking Features:
Circular Driveway; Garage Door Opener; RV Access/Parking; RV Gate
Road Responsibility:
City Maintained Road
Construction:
Wood Frame
Const - Finish:
Painted; Stucco
Roofing:
Tile
Cooling:
Central Air
Heating:
Electric
Plumbing:
Electric Hot Wtr Htr
Utilities:
SRP
Water Source:
City Water
Irrigation:
Flood
Sewer:
Septic Tank
Fencing:
Wrought Iron; Block
Property Description:
North/South Exposure
Landscaping:
Grass Front; Yrd Wtring Sys Front; Auto Timer H2O Front; Auto Timer H2O Back; Irrigation Back
Showing Notification Methods:
Text; Email; Phone Call
Lockbox Type:
Supra
Possession:
Close of Escrow
Unit Style:
All on One Level
Association Fee Incl:
No Fees
Existing 1st Loan:
Conventional; Treat as Free&Clear
New Financing:
Cash; VA; Conventional
Disclosures:
Seller Discl Avail; Agency Discl Req
Listing Office:
HomeSmart
Last Updated: July - 06 - 2026
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.