<%=objusermsa%> <%=key%>
<% msa=objusermsa '-----------------start form SQLString = "SELECT * FROM kdealsha where kdealsha.msa=" &_ chr(39) & msa & chr(39) Set DatabaseConnection = Server.CreateObject("ADODB.Connection") DatabaseConnection.Open "DSN=apartmentcomps", "dsanchez", "ds153x" Set kdealRecordset = Server.CreateObject("ADODB.Recordset") kdealRecordset.Open SQLString, DatabaseConnection Set objKdealmsa = kdealRecordset("msa") Set objKdealsubjectcity = kdealRecordset("subjectcity") set objKdealemail=kdealrecordset("email") set objKdealother=kdealrecordset("other") set objKdealsourceid=kdealrecordset("sourceid") If not kdealRecordset.EOF then %> |
<% %> homes-apartments home page
"><%=msa%><%=key%>
<% sqlstring="select distinct kcities.zip, kcities.msa from kcities where kcities.msa="&_ chr(39) & Request.QueryString("msa") & chr(39) Set DatabaseConnection = Server.CreateObject("ADODB.Connection") DatabaseConnection.Open "DSN=apartmentcomps", "dsanchez", "ds153x" Set UserRecordset = Server.CreateObject("ADODB.Recordset") UserRecordset.Open SQLString, DatabaseConnection Set objUserzip = UserRecordset("zip") Set objUsermsa = UserRecordset("msa") If UserRecordset.EOF Then comps="0" %>
---
<% else if msa="Atlanta" then %> Buckhead apartments Dunwoody apartments Doraville apartments Tucker apartments Midtown apartments Decatur apartments Little Five Points apartments College Park apartments East Atlanta apartments Inman Park apartments Grant Park apartments Cabbagetown apartments Virginia Highland apartments Adair Park apartments Capitol View apartments Ardmore Park apartments Home Park apartments Ormewood Park apartments Ansley Park apartments Kirkwood apartments Sylvan Hills apartments the Old Fourth Ward apartments apartments near Candler Park apartments near Oakhurst apartments near West End epartments near East Lake apartments near Vine City apartments near English Avenue apartments near Garden Hills apartments near McDonough-Guice apartments near Edgewood Lake Claire Oakland City Mechanicsville Peachtree Hills Pittsburgh Lakewood Heights apartments Summerhill Brookwood Hills Lenox Park Cascade Heights Gresham Park apartments Toney Valley Grove Park Bolton Peachtree Hills Boulevard Heights Polar Rock apartments Peoplestown Benteen Fairlie-Poplar Reynoldstown <% end if if msa="Dallas" then %>
|
Casa Linda <%=key%> / Casa View <%=key%> From the eastern shores of White Rock Lake to the Garland and Mesquite city limits, stretch the older well-established twin areas of Casa Linda and Casa View. Although a few apartment and duplex communities exist here, single-family homes dominate the quiet winding streets. Many residents focus on the lake for their recreational activities, work downtown and enjoy easy access to the northeastern highway mixmaster of Hwy. 20, I-635, and Loop 12. Most shopping needs are net by the namesake shopping centers, Casa View and Casa Linda shopping centers. East Dallas <%=key%> East Dallas is an established Dallas neighborhood dating back to 1882. Changing demographic demographic composition in East Dallas neighborhoods is, and will continue to be, a source of pride and is regarded as a strong asset. Far North Dallas <%=key%> Dallas has been fortunate to enjoy the benefits of several real estate booms resulting in neighborhoods which are distinct to each period. Far North Dallas begins north of LBJ Freeway (Interstate 635). The area was primarily developed during the early 1970s when DFW Airport was opened and confidence in oil prices created a boom town atmosphere. Quality housing is abundant, and amenities such as glamorous shopping centers and convenient strip centers meet consumer needs. North Dallas <%=key%> North Dallas has long been considered the haven for suburban life. It contains numerous private schools and large homes with rolling lawns, artistic landscaping, swimming pools and two- or three-car garages. These three neighborhoods are among Dallas' best-kept secrets. Located adjacent to the southeast shore of White Rock Lake between Garland Road and Ferguson Road, and south of Gaston Avenue, these areas are appropriately named due to the abundance of towering native trees and gently rolling hills. Greenway Park <%=key%> Jut west of the Park Cities and convenient to Love Field, Greenway Park is one of the most prestigious neighborhoods in Dallas. These are traditional older homes on large lots built with several generations in mind. Kessler and Stevens Park <%=key%> Kessler and Stevens Park, located just five minutes from downtown, are two of the most exclusive neighborhoods in Dallas. Well known for the massive shade trees, rolling hills and unique housing opportunities, the Kessler and Stevens Park area continues to be one of the Dallas neighborhoods in great demand. Lake Highlands <%=key%> Just north of White Rock Lake, Lake Highlands is a good place to raise a family. Residents enjoy easy access to White Rock Lake and Flagpole Hill, which are both major recreational attractions in the area. Northeast Dallas/ White Rock Area Once known for its burgeoning apartment complexes, such as The Village, Northeast Dallas has experienced significant growth in single-family residential developments as well. Lakewood Directly west of White Rock Lake, Lakewood is a charming mixture of quaint cottages set back on quiet shady streets and large homes lining impressive boulevards. Popular with professionals who work downtown and employees of nearby Baylor Medical Center, Lakewood is a prestigious and proud neighborhood. Northwest Dallas <%=key%> / Love Field <%=key%> This neighborhood began to take shape in the 1950s when the city's growth northward extended to Mockingbird Lane and Love Field. Particularly in the Bluffview sector, the homes are a mix of small cottages and larger handsome two-story homes. Oak Cliff <%=key%> Oak Cliff is one of Dallas' more established neighborhoods; it was in the mid- to late-1800s after Dallas founder John Neely Bryan built his cabin on the banks of the Trinity River. When the river was re-routed to create more living area and less flood plain, Oak Cliff prospered as one of the finest locations in Dallas. Massive shade trees, rolling hills and spectacular views of the Dallas skyline make Oak Cliff unique in its beauty, a source of pride to its close-knit residents. Residents enjoy a short commute to downtown Dallas, the Dallas Zoo, DFW Airport and Arlington attractions. Oak Lawn <%=key%> Oak Lawn is best known for its enviable location next to serenely winding Turtle Creek. High-rise condominiums offer luscious views of the creek and surrounding parks. As the closest area for inner-city living just north of downtown, Oak Lawn predictably has a lively appeal for nightlife and the arts, and is the home of the famous Dallas Theatre Centre, designed by Frank Lloyd Wright. Many of the patrons and artists who populate the nearby Arts District live here, along with professional who work downtown. Pleasant Grove <%=key%> On the city's southeast side, Pleasant Grove has launched a revitalization campaign, and new homes and shopping centers are being built throughout the suburb. Red Bird <%=key%> / Mountain Creek <%=key%> This area features the most dramatic landscape in the county, including hills, trees and a beach. Recent commercial and residential development, low land prices, Joe Pool Lake, excellent highway accessibility, Mountain View College and Dallas Baptist University combine to make this area one of the fastest growing centers in the Metroplex. South Dallas/ Fair Park <%=key%> The South Dallas/Fair Park area offers excellent accessibility to freeways and highways. The area is a mix of single-family homes and retail on the east, and multi-family units, commercial and industrial uses near downtown. Southeast Dallas <%=key%> Originally a semi-rural, single-family area, Southeast Dallas has experienced an influx in commercial and industrial development and a major increase in residential development since the early 1980s. Swiss Avenue Historic District <%=key%> Listed in the National Register of Historic Places, the Swiss Avenue Historic District is an influential neighborhood that was first developed in 1905. The neighborhood regularly attracts strollers, joggers and history buffs. The architectural styles featured in the neighborhood include Neoclassical, Tudor, Spanish, Eclectic, Italian Renaissance, Colonial Revival and Prairie. Uptown <%=key%> Uptown is the area directly north of downtown Dallas, and encompasses the McKinney Avenue corridor and the historic state-Thomas neighborhood. Several high-rise condominiums offer many inner-city amenities including workout facilities and restaurants, as do high-rise apartments. Uptown residents live within walking distance of downtown offices, but they can also ride to work on the McKinney Avenue Trolley, a restored electric streetcar system run by volunteers. The Wilson Historic District apartments Listed in the National Register of Historic Places, what began as an urban renewal project has become one of the largest historic preservation projects in the city. The neighborhood is ringed by luxury townhomes, condominiums and lofts, all walking distance from downtown and the artsy entertainment and dining spot Deep Ellum. The area offers a wide variety of living styles, from old Victorian to intown lofts. |
We can help you find apartments for rent in <%=msa%> for these zipcodes:
|
<%
x=0
Do Until UserRecordset.EOF
x=x+1
%>
<%=objuserzip%>
<% if x=11 then %> | <% end if if x=21 then %> | <% end if if x=31 then %> | <% end if if x=41 then %> | <% end if if x=51 then %> | <% end if if x=61 then %> | <% end if if x=71 then %> | <% end if if x=81 then %> | |
| <% end if if x=91 then %> | <% end if if x=101 then %> | <% end if if x=111 then %> | <% end if if x=121 then %> | <% end if if x=131 then %> | <% end if if x=141 then %> | <% end if if x=151 then %> | ||
| <% end if if x=161 then %> | <% end if if x=171 then %> | <% end if if x=181 then %> | <% end if if x=191 then %> | <% end if if x=201 then %> | <% end if if x=211 then %> | <% end if if x=221 then %> | ||
| <% end if if x=231 then %> | <% end if if x=241 then %> | <% end if if x=251 then %> | <% end if if x=261 then %> | <% end if if x=271 then %> | <% end if if x=281 then %> | <% end if if x=291 then %> | ||
| <% end if if x=301 then %> | <% end if if x=311 then %> | <% end if if x=321 then %> | <% end if if x=331 then %> | <% end if if x=341 then %> | <% end if if x=351 then %> | <% end if if x=361 then %> |