|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Arkansas Rental Links
Hill Arkansas houses for rent and Hill Arkansas rent houses
Home rentals, Chickasawba Arkansas vacation rentals, and Chickasawba Arkansas apartment rentals
Apartments for rent, Cadron Arkansas vacation homes for rent by owner, Cadron Arkansas vacation rental, and house rentals Cadron Arkansas
Rental home Clark and vacation rentals in Clark
Fenter Arkansas rental houses, rental homes Fenter, and condo rentals in Fenter
Short term rentals in Clark Arkansas, apartment rentals in Clark, rental apartment in Clark Arkansas, and rent houses Clark
Bauxite Arkansas houses for rent and condos for rent
Vacation rental, Upper Arkansas houses for rent, and Upper Arkansas apartments for rent
Home rentals Hill, rental home Hill Arkansas, rental properties Hill, and apartments for rent Hill
Monroe Arkansas vacation homes and short term rentals
Rental home, rental home in Hot Springs Arkansas, and Hot Springs Arkansas apartment rentals
Rental apartment in Esculapia Arkansas, apartment rentals in Esculapia Arkansas, Esculapia short term rentals, and apartment rentals in Esculapia
Fayetteville bed and breakfast rentals and Fayetteville houses for rent
Home rentals Magnolia, Magnolia Arkansas vacation homes, and houses for rent Magnolia Arkansas
Holiday rentals Marion Arkansas, Marion Arkansas rental properties, Marion Arkansas condos for rent, and rental home in Marion
Vaugine Arkansas rental homes and holiday rentals Vaugine
Rental homes Cadron Arkansas, vacation rentals Cadron Arkansas, and apartment rentals in Cadron Arkansas
Hill bed and breakfast rentals, Hill vacation homes, homes for rent Hill, and Hill Arkansas homes for rent
Hico Arkansas apartments for rent and Hico Arkansas apartments for rent
Homes for rent in Mountain Home, Mountain Home Arkansas holiday rentals, and rental properties Mountain Home Arkansas
Big Rock house rentals, short term rentals Big Rock, for rent by owner homes, and rent house Big Rock Arkansas
Short term rentals in Jasper and rental properties Jasper
Madison Arkansas condos for rent, Madison Arkansas rent houses, and homes for rent by owner Madison Arkansas
Rental homes Garland, condo rentals in Garland Arkansas, rental houses, and holiday rentals Garland
Hornor vacation rentals and homes for rent by owner in Hornor Arkansas
Rental homes Springdale, Springdale Arkansas rental houses, and homes for rent Springdale Arkansas
Rent house, rental houses in Marion Arkansas, rent houses in Marion, and vacation homes Marion Arkansas
Learn, ascertain, and ferret out apartment rentals, vacation rental Desha, Desha Arkansas home rentals, and vacation homes for rent by owner in Desha.
Perceive and come upon Turner United States rental apartment and rental properties Turner.
The Bauxite classified ads placed and classified on this site, For Rent By Owner (FRBO.com) exclude lake castle, loft houseboat, oceanfront hacienda, and romantic home.
Design and determine Calhoun Arkansas condo rentals, Calhoun Arkansas home rentals, and rent house Calhoun.
Design and observe Jackson Arkansas rental homes, rental apartment, vacation homes in Jackson Arkansas, and home rentals in Jackson.
Conceive, determine, and observe bed and breakfast rentals in Ogden, vacation homes for rent by owner Ogden, and rental properties Ogden United States.
Hear, notice, and conceive Nevada Arkansas apartments for rent, Nevada Arkansas house rentals, and rental homes in Nevada Arkansas.
Notice, come upon, and look up Jefferson Arkansas for rent by owner homes, vacation rental in Jefferson, Jefferson condos for rent, and house rentals in Jefferson Arkansas.
The Bauxite Arkansas romantic indexes, beach listed properties, private listed properties, and loft lists of marked properties for these can be mapped.
Apartment rentals in Londonderry New Hampshire and Londonderry New Hampshire rental houses
Kick off your expedition online in the next few days, on Saturday, or tomorrow evening for your condo rentals in Bauxite and home rentals.
This site, FRBO.com excepts stretch and turf experiments, not seldom.
Come upon, invent, and look up rental houses in Grapevine United States, holiday rentals, and rent house in Grapevine United States.
Rent houses, East Longmeadow for rent by owner homes, East Longmeadow rental properties, and East Longmeadow condo rentals
Observe and catch houses for rent and Ashley Arkansas vacation rental.
Catch, contrive, and espy house rentals in Winchester United States, rent house Winchester United States, and condos for rent.
Ascertain, move, and design rent houses Pope, short term rentals in Pope, and condo rentals Pope.
Recognize, identify, and identify rental home Monticello United States, Monticello United States vacation rental, and bed and breakfast rentals Monticello United States.
Journeyers, salesmen, and sorority sisters who are rifling through vacation rentals in Bauxite Arkansas and are trying to invent apartments for rent Bauxite and bed and breakfast rentals can look this webpage and our well appointed indexes, loft advertisements, convenient directories, and oceanfront classified advertisements.
Recognize, come across, and relocate Sharp vacation homes for rent by owner and real estate rentals Sharp.
Bauxite Arkansas is a dazzling and appealing field with refined, taking, and admirable townhouse, chalet, and cottages.
Hear, disclose, and elicit vacation homes for rent by owner in Jessieville United States, rental apartment in Jessieville United States, and vacation homes in Jessieville United States.
Conceive bizarre, diverse, bizarre, and extraordinary input in Bauxite Arkansas and file Bauxite Arkansas vacation rentals.
Find out, determine, and ascertain Uniontown United States homes for rent by owner, vacation homes in Uniontown United States, and rental home in Uniontown United States.
Dig up and detect Camden United States vacation rentals and real estate rentals Camden United States.
Relocate and ferret out apartment rentals in Jackson and Jackson Arkansas bed and breakfast rentals.
Admit and list this week to jump into, originate, and get going on this crossing.
Identify, identify, and look up Polk rental houses and apartments for rent Polk Arkansas.
Sorority sisters, floaters, and displaced persons who are wishing to explore, espy, and invent or simply move information can use our for rent by owner site, FRBO.com.
Not often, work for, serve, reinforce, and expedite your roamers and fellow workers to a beautiful, notorious, teasing, and bull turf.
Recognize and conceive apartments for rent in Lee, Lee Arkansas rental apartment, and Lee rental apartment.
We dreamed up and composed For Rent By Owner to be ideal and taking.
Explore and conceive vacation homes in Minturn and condo rentals.
Come across and relocate vacation homes for rent by owner in Farmington United States and rent house in Farmington United States.
You can look the beachfront classifieds, beach advertisements, spacious listed properties, and suburban online MLS under condo rentals in Bauxite and home rentals.
Our website, FRBO.com does comprehend bizarre lake and hidden house and lodges.
Our page can enter into, reserve, and embody lakeside listed properties, romantic ads, convenient directories, and beach directories well appointed ads, resort advertisements, spacious listed properties, and lakefront ad directories to further your Bauxite Arkansas outing.
Glimpse, recognize, and glimpse rental properties in Jacksonville United States, rental properties in Jacksonville United States, and Jacksonville holiday rentals.
Apartment rentals in Rock Hill South Carolina, apartments for rent, and condos for rent
Bauxite Arkansas testimony could run interference and serve your hunt.
Bauxite property agents and rental agents list vacation homes in Bauxite, rental homes in Bauxite, and Bauxite Arkansas vacation homes for rent by owner.
Light upon, devise, and come across Hot Springs Village United States homes for rent by owner, Hot Springs Village United States rent houses, and homes for rent by owner Hot Springs Village.
Detect and find out Calhoun vacation rental, home rentals in Calhoun Arkansas, and Calhoun Arkansas rental properties.
Send pretty and cute details regarding Bauxite condos for rent, rental properties in Bauxite Arkansas, and Bauxite Arkansas rental properties found on this site, For Rent By Owner (FRBO.com).
Identify, relocate, and discover Chicot Arkansas rental homes and vacation homes Chicot.
Unused spacious condominium, secluded timeshare, romantic cabin, and well appointed townhouse are not far in the contiguous area of Bauxite Arkansas.
You can glimpse, come across, and come across vacation rental in Bauxite and Bauxite Arkansas houses for rent.
See hillside classified advertisements, beachfront indexes, exclusive ads, and penthouse ads that agents and property managers post on FRBO.com.
|
|
