Back to Search
1247 E Columbia Ave
For Rent $1,400 ($2.64 per Sq Ft)
$1,400 ($2.64 per Sq Ft)
- Unknown Bedrooms
- 1 Bathrooms
- 530 Sq Ft
- 12,197 Sq Ft
Description
The Icehouse is a very unique, cutting edge LEED Certified new construction / rehab condo complex. Common area green roof, koi pond, roof top dog park, bike room, and rooftop outdoor kitchen. Unit 1 is a studio unit with front entry, GE stainless appliances, high efficiency W/D, large caesarstone island, glass tile bath, and hardwood floors. Directly across the street from Hetzell's ball field. The Icehouse is located 1 block from Girard Avenue. Public transportation: The (15) Trolley stops approximately two blocks from The Icehouse at the intersection of Girard and Columbia. In addition, the Girard Avenue "EL" stop (with connection available directly from the (15) trolley), is a short walk of about 10 minutes from The Icehouse.
Amenities
Garage
Pool
Garden
Security System
Internet
Telephone
Heating
Fireplace
Balcony & Patio
TV / Cable
Laundry
Hardwood Floors
Spa
Air Conditioning
Solar Power
Floor Plan
Great Views
Natural Light
Quiet
Water View
Elevator
Guest Unit(s)
Furnished
220 Volt
Property Details
| List Price | $1,400 |
| Property Type | Single Family Homes |
| Usable Sqft | 530 |
| Number of Stories | 0 stories |
| Parking Spots | 0 spots |
| Year Built | 2009 |
| Last Sold | Unknown |
| Sold Price | Unknown |
| APN # | 888180670 |
| MLS # | PAPH2533706 |
| Property ID | 322136682 |
| Lot Sqft | 12,197 |
| Zoning | R10A |
| Total Units | 22 |
| Days on Market | 105 |
| Original List Price | Unknown |
| Date Updated | December 03, 2025 |
| Date Created | September 02, 2025 |
| Pets | Call for Details |
| Furniture | Unfurnished |
| Laundry | Yes, Laundry Appliances are Included |
Listing Provided By
James J Maransky an agent of . Lic #RM420848
© 2025 Copyright BRIGHT, All Rights Reserved
The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which participates, and is provided by BRIGHT through a licensing agreement.
The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on this website may no longer be available because they are under contract, have Closed or are no longer being offered for sale.
Some real estate firms do not participate in IDX and their listings do not appear on this website. Some properties listed with participating firms do not appear on this website at the request of the seller.
This home sale information is not to be construed as an appraisal and may not be used as such for any purpose.
BRIGHT MLS is the (or a) provider of this home sale information and has compiled content from various sources. Some properties represented may not have actually sold due to reporting errors.
Information Deemed Reliable But Not Guaranteed
Data last updated: December 16, 2025.
Contact Agent
Schedule Appointment
Showing Agent
Loading agent...
- 30 mins
- America/Phoenix
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Robert Crawford
REAL ESTATE AGENT