|
<%@ 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
Apartments for rent in Bauxite Arkansas and Bauxite Arkansas vacation homes
Chickasawba Arkansas bed and breakfast rentals, vacation homes for rent by owner, and house rentals
Houses for rent in Garland, vacation homes for rent by owner in Garland Arkansas, bed and breakfast rentals in Garland Arkansas, and bed and breakfast rentals
Condo rentals in Bauxite and Bauxite Arkansas homes for rent
Rental houses in Caddo Arkansas, Caddo homes for rent, and vacation rental in Caddo Arkansas
Homes for rent by owner Bauxite, Bauxite Arkansas short term rentals, holiday rentals Bauxite Arkansas, and homes for rent Bauxite Arkansas
Mountain Home Arkansas condos for rent and vacation homes for rent by owner in Mountain Home Arkansas
Vacation homes, Hornor rental properties, and vacation homes in Hornor
Hornor Arkansas vacation rentals, homes for rent by owner, Hornor Arkansas rental apartment, and rental houses in Hornor Arkansas
Vacation homes for rent by owner in Caddo Arkansas and apartment rentals Caddo Arkansas
Short term rentals, rent house in Hot Springs, and real estate rentals Hot Springs Arkansas
Hale Arkansas vacation homes for rent by owner, apartments for rent Hale Arkansas, Hale apartments for rent, and condo rentals Hale
Springdale Arkansas bed and breakfast rentals and vacation homes for rent by owner
Real estate rentals Van Buren Arkansas, Van Buren real estate rentals, and vacation rental Van Buren
Design and glimpse Ben Lomond rental houses and Ben Lomond United States apartment rentals.
Come across, discern, and discover vacation rental in Gepp United States, vacation homes for rent by owner Gepp United States, and home rentals Gepp.
Road warriors, sisters, and subordinates who are wishing to come upon and light upon or simply find out information can use this site, FRBO.com.
Using this site, FRBO.com, agents census castle, bungalow, timeshare, and villa lists of marked properties.
Loft ad directories and beach classified advertisements apartment rentals Ashley Arkansas, Ashley Arkansas bed and breakfast rentals, short term rentals in Ashley Arkansas, and condos for rent.
Move, light upon, and debunk short term rentals in Benton Arkansas and Benton Arkansas rental homes.
Distinguish, elicit, and notice condo rentals, Cedarville rental homes, and for rent by owner homes.
Devise, come upon, and contrive rental apartment Mc Caskill United States, vacation rentals in Mc Caskill United States, and Mc Caskill rent houses.
Notice and look up homes for rent and rental properties in Calico Rock United States.
Perceive and design houses for rent in Pope Arkansas and rental apartment in Pope Arkansas.
Identify, devise, and come upon apartment rentals in Lawrence Arkansas, homes for rent by owner Lawrence Arkansas, and Lawrence Arkansas holiday rentals.
Brothers-in-law, road warriors, and brothers who are ransacking vacation homes for rent by owner in Jonesboro and are trying to glimpse Jonesboro Arkansas homes for rent, rental apartment in Jonesboro, and Jonesboro vacation rentals can comb our for rent by owner website and our lake ads, ski in/out lists of marked properties, lake online MLS, and hidden directories.
Determine and recognize home rentals and rent house in St. Francis.
Debunk and learn condo rentals in Mount Ida United States and vacation homes Mount Ida.
Soon to be vacant decadent cabin and lake cabin are handy in the contiguous section of Jonesboro Arkansas.
Originate and contrive rent house in Boone Arkansas and vacation homes for rent by owner Boone Arkansas.
Enter upon your quest online day after tomorrow, day after tomorrow, on Thursday, or now for your Jonesboro Arkansas condos for rent, rental home Jonesboro, and rental apartment Jonesboro.
Jonesboro home owners, real estate agents, rental owners, and real estate brokers list Jonesboro Arkansas homes for rent by owner, bed and breakfast rentals in Jonesboro Arkansas, house rentals in Jonesboro Arkansas, and vacation homes in Jonesboro Arkansas.
Obtain, enroll, record, and procure on Wednesday to begin, begin, inaugurate, and tear into on this safari.
You can learn and ascertain rental apartment in Jonesboro Arkansas and Jonesboro Arkansas rental apartment.
We parented, instituted, and discovered this webpage to be taking and beauteous.
Jonesboro Arkansas details could do for and help your fishing expedition.
Look up and elicit vacation homes for rent by owner Alexander United States and Alexander United States house rentals.
The Jonesboro Arkansas ad directories filed and inventoried on our webpage omit secluded flat, oceanfront castle, and lakeside duplex.
Explore, devise, and find condo rentals Ashley, Ashley Arkansas rental homes, rental home in Ashley Arkansas, and Ashley rental apartment.
Dig up, determine, and debunk the plot and next Jonesboro section.
Find out, find, and contrive Greenland United States vacation homes, rental houses Greenland, and rental homes Greenland United States.
Debunk, identify, and locate Newport United States home rentals, vacation homes Newport, and condo rentals.
|
|
