MLS Client Summary Report(292)

Client Summary Report
Listing Numbers  20729827, 20726851, 20730231, 20733942, 20728358, 20735695, 20730576, 20722811, 2634956, 20724763, 20721859, 20732072
Listings as of 09/07/07 at 2:15pm
Active 07/20/07 Listing # 20729827 2484 N Yellow Flower Tr Tucson, AZ 85715-3658 Listing Price: $297,500
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area Northeast Subdivision Desert Links
Beds 3 Approx Square Feet 1581 Assessor
Baths(FTHQ) 2 (2 0 0 0) Price/Sq Ft 188.17
Year Built 2005 Lot Sq Ft(approx) 5885 ((Assessor))
Tax Code 114-48-0980
DOM 49 Lot Acres (approx) 0.135
TRS 13 15 32
Additional Pictures  
Listing Office   Casas Adobes Realty
School District Tucson ELEM Van Horne MDJR Magee HIGH Sabino  
Directions Tanque Verde E to Desert Links{1st St east of the overpass} to Red Adobe Pass thru gate, N-Blue Willow, W-Purple Desert, S-Yellow Flower Trl.
Property Description Every possible upgrade was added to this exclusively gated, two year old Pepper Viner home. This immaculate 3BD, 2BA charmer welcomes the family to the pleasing fireplace with an entertainment surround. Fabulous kitchen and all appliances STAY! Listed thousands below latest appraisal and neighboring houses, this quiet cul-de-sac home with in ground spa and spectacular mountain views is priced to move! Perfect NE location for work or play.


Active 07/11/07 Listing # 20728358 2256 E Stone Stable Dr Oro Valley, AZ 85737-4620 Listing Price: $269,000
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Northwest Subdivision Rams Canyon
Community La Reserve
Beds 3 Approx Square Feet 1759 Floor Plan
Baths(FTHQ) 2 (2 0 0 0) Price/Sq Ft 152.93
Year Built 2006 Lot Sq Ft(approx) 4904 ((Assessor))
Tax Code 220-04-2380
DOM 58 Lot Acres (approx) 0.113
TRS 12 14 5
Additional Pictures  
Listing Office   RE/MAX Majestic Realty
School District Amphitheater ELEM Copper Creek MDJR Cross HIGH Canyon Del Oro  
Directions 1st/Oracle, North on Oracle, Turn East on Rams Pass Field, Turn right on E Stone Stable Drive to property.
Property Description Seller will counter or accept offers between $269,000-$299,000.Below Builder Cost! 3br/Den,1759sf custom tile thruout kitch & traffic areas,granite countertops,custom backsplash,all bisque appliances incl with a over abundance of cabs.Lg rms,laundry rm,cultered marble in baths.Covered patio to admire view in rear yard.Minutes from Catalina State Park for hiking,hospital,restaurants and the up and coming state of the art Oro Valley Town Ctr.


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.
 

Client Summary Report
Listings as of 09/07/07 at 2:15pm
Active 08/20/07 Listing # 20733942 1584 W Blue Horizon St Tucson, AZ 84704-1446 Listing Price: $310,000
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Northwest Subdivision Paseo del Rio
Beds 4 Approx Square Feet 1800 Assessor
Baths(FTHQ) 3 (3 0 0 0) Price/Sq Ft 172.22
Year Built 2006
Tax Code 104-01-5470
DOM 18 Lot Acres (approx)
TRS 13 13 15
Additional Pictures  
Listing Office   Tierra Antigua Realty
School District Amphitheater ELEM Walker MDJR La Cima HIGH Amphitheater  
Directions La Canada and River west to Paseo Del Rio - north to address. The house is on the corner to your left.
Property Description Brand new,Meritage family home located on the best corner of Paseo Del Rio neighborhood. Stunning unobstructed view of the mountains from the master bedroom. Exterior style accentuated with elevation B plan. 9ft ceilings in living room, gourmet kitchen, walk-in closet, alarm installed, all new Whirlpool appliances, television & telephone prewired (cat-5, RG-6). House under builder warranty. Located near city center. Owner is licensed agent in AZ.


Active 06/29/07 Listing # 20726851 7902 N Blue Brick Dr Tucson, AZ 85743 Listing Price: $312,500
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Northwest Subdivision Continental Reserve Block 15
Community Continental Reserve
Beds 4 Approx Square Feet 2156 Owner
Baths(FTHQ) 2 (2 0 0 0) Price/Sq Ft 144.94
Year Built 2005
Tax Code 221-27-0430
DOM 70 Lot Acres (approx)
TRS 12 12 33
Additional Pictures  
Listing Office   Congress Realty
School District Marana ELEM Coyote Trail MDJR Marana HIGH Marana  
Directions I-10 exit Cortaro, W to Silverbell, N to Wade, L at light. R on Pima Reserve Dr, L on Continental Reserve Loop, L on Lime Star Dr, L on Blue Brick Dr.
Property Description Spectacular views! Fresh custom paint! This is a must see with one of the lowest listing prices for this size of home. Tile in wet areas. Large great room has fire place and is connected to kitchen and breakfast nook. All window coverings will stay. Seller willing to negotiate a landscaping package for the backyard. Hurry, this offer won't last!


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.
 

Client Summary Report
Listings as of 09/07/07 at 2:15pm
Active 07/21/07 Listing # 20730231 13876 N Big Wash Overlook Pl Tucson, AZ 85739-8852 Listing Price: $337,500
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Northwest Subdivision Rancho Vistoso
Community Rancho Vistoso
Beds 4 Approx Square Feet 2167 Assessor
Baths(FTHQ) 2 (2 0 0 0) Price/Sq Ft 155.75
Year Built 2004 Lot Sq Ft(approx) 8102 ((Assessor))
Tax Code 219-24-2130
DOM 48 Lot Acres (approx) 0.186
TRS 11 14 20
Additional Pictures  
Listing Office   Tierra Antigua Realty
School District Amphitheater ELEM Painted Sky MDJR Coronado K-8 HIGH Ironwood Ridge  
Directions North on Oracle from Tangerine approx 2 miles. At Mile Marker 84, turn left (west) on Big Wash Overlook, home is the corner house on your right.
Property Description Views and Privacy in Rancho Vistoso. This immaculate home was furnished w/all the right upgrades. Beautiful stained concrete floors in great room & halls, Berber carpet in living areas, slate in bathrooms. Gas FP w/custom slate surround. Huge kitchen perfect for entertaining: built-in wine fridge, SS Kitchen Aid hood, large 36'' upper cabs. Spacious laundry room upgraded w/sink & add'l cabs. 10' ceilings throughout, alarm/surround sound pre-wires


Active 09/01/07 Listing # 20735695 168 S Happy Valley Saddle Dr Tucson, AZ 85748-3443 Listing Price: $294,900
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area East Subdivision Barrio Rincon
Beds 3 Approx Square Feet 1601 Assessor
Baths(FTHQ) 2 (2 0 0 0) Price/Sq Ft 184.20
Year Built 2005 Lot Sq Ft(approx) 6215 ((Assessor))
Tax Code 133-38-7670
DOM 6 Lot Acres (approx) 0.143
TRS 14 15 13
Additional Pictures  
Listing Office   Tierra Antigua Realty
School District Tucson ELEM Soleng Tom MDJR Gridley HIGH Sahuaro  
Directions BROADWAY & HOUGHTON EAST TO HAPPY VALLEY SADDDLE DR, S TO ADDRESS
Property Description FORMER INTERIOR DESIGNERS HOME! THIS HOME SHOUTS PERFECTION FROM THE GRASSCLOTH WALL PAPER TO THE INCREDIBLE CHISELED GRANITE COUNTER TOPS-SCORED CONCRETE FLOORS & HICKORY CABINETS. HOME ALSO FEATURES CUSTOM WINDOW COVERINGS & FREEZER BOTTOM FRIDGE. LOT BACKS TO RIPARIAN AREA NICELY LANDSCAPED YARD & DRIP SYSTEM. DON'T MISS THIS SPECTACULAR HOME! WELL PRICED AND MOTIVATED SELLER!


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.
 

Client Summary Report
Listings as of 09/07/07 at 2:15pm
Active 07/26/07 Listing # 20730576 12659 E Nona Ln Vail, AZ 85641-6683 Listing Price: $289,900
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area Southeast Subdivision Rancho Del Lago
Beds 4 Approx Square Feet 2289 Owner
Baths(FTHQ) 3 (2 0 1 0) Price/Sq Ft 126.65
Year Built 2005 Lot Sq Ft(approx) 4950 ((Assessor))
Tax Code 305-05-7750
DOM 43 Lot Acres (approx) 0.114
TRS 16 16 8
Additional Pictures  
Listing Office   Beacon Realty
School District Vail ELEM Acacia MDJR Old Vail HIGH Cienega  
Directions Houghton south to Mary Ann Cleveland. East to Nona ln. Left to address.
Property Description Gorgeous 2story home with many upgrades.Granite countertops in kit&all baths.Medium cherry cabs in kit.w/glass inserts at bar area,island, stunning black appls.French doors on fridge,gas range w/grill,microwave,DW,disp.water softener, pull-out faucet,roll-out garbage cans.Wood blinds &CF's thru-out.Dramatic 2story LR.Storage,sealed floor,opener in 2c.gar.Upgrade faucets&door handles. Patio door,cov'd patio,grass yard,fountain& ext.speakers.


Active 06/01/07 Listing # 20722811 10961 S Distillery Canyon Spring Dr Vail, AZ 85641-2554 Listing Price: $297,000
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Southeast Subdivision Rancho Del Lago
Beds 4 Approx Square Feet 2141 Assessor
Baths(FTHQ) 2 (1 1 0 0) Price/Sq Ft 138.72
Year Built 2005 Lot Sq Ft(approx) 7920 ((Assessor))
Tax Code 305-05-4950
DOM 98 Lot Acres (approx) 0.182
TRS 16 16 9
Additional Pictures  
Listing Office   Long Realty Company
School District Vail ELEM Acacia MDJR Old Vail HIGH Cienega  
Directions FROM HOUGHTON/MARY CLEVELAND GO EAST PAST CIENEGA HIGH SCHOOL, LEFT (N) AT HOPE CAMP DR. LEFT ON WILDHORSE THEN RIGHT ON DISTILLERY CANYON TO 10961
Property Description MOST POPULAR BUILDER FLOORPLAN SHOWCASING EXPANSIVE VIEWS FROM SHADY EAST FACING BKYRD. PROFESSIONAL STYLED LANDSCAPING WITH HIGH QUALITY GAZEBO FOR OUTSIDE ENTERTAINMENT! THIS HOME IS IMMACULATE! TOO MANY UPGRADES TO MENTION. LARGE BRIGHT KITCHEN OPENING TO HIGH CEILING FAMILY FUN ROOM. A BIG 3 CAR GARAGE AWAITS YOUR MASERATI! NEAR PLANNED SHOPPING CENTER.


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.
 

Client Summary Report
Listings as of 09/07/07 at 2:15pm
Active 09/01/06 Listing # 2634956 4847 S Huelva Ln Tucson, AZ 85746 Listing Price: $272,620
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area Southwest Subdivision Casitas Del Sol Estates
Beds 4 Approx Square Feet 2420 Floor Plan
Baths(FTHQ) 3 (2 1 0 0) Price/Sq Ft 112.65
Year Built 2006 Lot Sq Ft(approx) 4950 ((Owner))
Tax Code NEW OR UNDER CONSTRUCTION
DOM 371 Lot Acres (approx) 0.114
TRS 14 13 34
Additional Pictures  
Listing Office   Standard Pacific Homes-Tucson
School District Tucson ELEM Lynn MDJR Valencia HIGH Pueblo  
Directions From I-19 West on Irvington Rd. North on Mission, East on Irvington Place to Model Center.
Property Description Elegant 2 story home with functional upgrades, including but not limited to wood burning fireplace with media at Family room, 42 uppers at kitchen, security pre-wire, custom flooring, custom Corian counter tops at baths, and more.


Active 06/14/07 Listing # 20724763 4923 S Celta Vigo Ct Tucson, AZ 85746 Listing Price: $318,404
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area Southwest Subdivision Casitas Del Sol Estates
Beds 3 Approx Square Feet 2420 Owner
Baths(FTHQ) 3 (2 1 0 0) Price/Sq Ft 131.57
Year Built 2006 Lot Sq Ft(approx) 7015 ((Owner))
Tax Code NEW OR UNDER CONSTRUCTION
DOM 85 Lot Acres (approx) 0.161
TRS 14 13 34
Additional Pictures  
Listing Office   Standard Pacific Homes-Tucson
School District Tucson ELEM Lynn MDJR Valencia HIGH Pueblo  
Directions I-10 to I-19 South, exit Irvington Rd. heading west, north on Mission Rd., east on Irvington Place to Model Center.
Property Description This is our community Flagship. It is currently used as one of our models. It is fully loaded with beautiful and functional options, including but not limited to fireplace w/media at family room, 42 uppers in kitchen, custom granite counter tops at kitchen, custom flooring, upgraded light features, custom interior paint, BBQ gas stub at patio, security system, custom landscape front and rear, 16'x10'deck at loft, and upgraded appliances.


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.
 

Client Summary Report
Listings as of 09/07/07 at 2:15pm
Active 05/25/07 Listing # 20721859 504 E Placita Boton Sahuarita, AZ 85629-8609 Listing Price: $284,999
County: Pima See Map
Property Type Residential Property Subtype Single Family Res.
Area Extended South Subdivision Presidio de las Estrellas
Community Rancho Sahuarita
Beds 4 Approx Square Feet 2300 Assessor
Baths(FTHQ) 3 (3 0 0 0) Price/Sq Ft 123.91
Year Built 2006 Lot Sq Ft(approx) 5097 ((Assessor))
Tax Code 303-72-546
DOM 105 Lot Acres (approx) 0.117
TRS 17 13 1
Additional Pictures  
Listing Office   Long Realty Alliance
School District Sahuarita ELEM Sahuarita MDJR Sahuarita HIGH Sahuarita  
Directions I-19/Pima Mine Rd. EAST to Rancho Sahuarita SOUTH Camino Rancho Tierra EAST to Avenida Cuana SOUTH to Placita Boton. Property on the corner #504.
Property Description 4 BEDROOM (1 Bdrm down stairs) 3 BATH with a loft that could be a 5th bedroon or office. Landscaped front and back. Extended patio with red brick pavers. Tile in Kitchen and Family Room. Lovely bright open floorplan. READY WHEN YOU ARE!! ALSO AVAILABLE FOR LEASE $$1250 PER MONTH.


Active 08/06/07 Listing # 20732072 450 E Calle De Ocaso Sahuarita, AZ 85629 Listing Price: $310,000
County: Pima
Property Type Residential Property Subtype Single Family Res.
Area Extended South Subdivision Lago Sereno
Community Rancho Sahuarita
Beds 4 Approx Square Feet 1878 Assessor
Baths(FTHQ) 3 (2 0 1 0) Price/Sq Ft 165.07
Year Built 2006 Lot Sq Ft(approx) 3800 ((Assessor))
Tax Code 303-35-4580
DOM 32 Lot Acres (approx) 0.087
TRS 17 13 1
Additional Pictures  
Listing Office   Long Realty Company
School District Sahuarita ELEM Sahuarita MDJR Sahuarita HIGH Sahuarita  
Directions From Rancho Sahuarita Blvd and La Villita go North on Lago Azul Past Boat Landing, Right at Lago Sereno Gate, Right on Amura, Left on Velero to Ocaso.
Property Description Attractive 4 Bedroom home in gated community near the lake in Rancho Sahuarita. Upgraded flooring and appliances, 2 and a half-car garage,landscaped backyard. Second floor balcony from master bedroom. Close to athletic facilities,water park,swimming pools-all included in HOA fee! Just minutes from Sahuarita Lake boat launch. Come and see for yourself all this great community has to offer.


Presented By: Kristin Gideon Morado Canyon Realty
Cell: 520-331-6693
Office: 520-777-8733
   
E-mail: Kristin.Gideon@cox.net
7225 E. Broadway Suite 140
Tucson, AZ 85710
520-777-8733
Fax :  520-777-8610
September 2007 Web Page: 
  Featured properties may not be listed by the office/agent presenting this brochure.  
Equal Opportunity Housing * All information deemed reliable, but not guaranteed
Copyright ©2007 Rapattoni Corporation. All rights reserved.