|
<%@ 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
Vacation rental Monroe and homes for rent in Monroe Arkansas
Homes for rent, short term rentals, and Washington homes for rent
Homes for rent Washington Arkansas, home rentals in Washington Arkansas, Washington Arkansas bed and breakfast rentals, and Washington bed and breakfast rentals
Rental properties in Vaugine Arkansas and Vaugine Arkansas rental apartment
Cadron Arkansas rent house, rental houses in Cadron, and vacation rental Cadron Arkansas
Esculapia Arkansas for rent by owner homes, Esculapia rental home, vacation homes in Esculapia, and Esculapia Arkansas vacation homes
Chickasawba rental properties and real estate rentals
Condo rentals in Bauxite Arkansas, vacation rentals in Bauxite, and bed and breakfast rentals in Bauxite
Washington Arkansas vacation homes, Washington real estate rentals, vacation homes in Washington Arkansas, and rental home in Washington Arkansas
Garland Arkansas rental homes and rental apartment in Garland Arkansas
Real estate rentals in Madison Arkansas, Madison Arkansas houses for rent, and condos for rent in Madison Arkansas
Rent houses in Hale Arkansas, holiday rentals, Hale bed and breakfast rentals, and Hale Arkansas holiday rentals
Bed and breakfast rentals in Mountain Home and rental home
Rental apartment in Upper Arkansas, for rent by owner homes Upper Arkansas, and homes for rent Upper
El Dorado Arkansas houses for rent, El Dorado Arkansas bed and breakfast rentals, real estate rentals in El Dorado Arkansas, and rental properties in El Dorado
Houses for rent in Caddo Arkansas and Caddo Arkansas rent houses
Short term rentals in Illinois Arkansas, Illinois Arkansas rental properties, and Illinois short term rentals
Apartments for rent, apartments for rent in Mountain Home Arkansas, Mountain Home Arkansas vacation rentals, and Mountain Home rental houses
Collegiates and troupers who are ferreting Marion rental apartment and are trying to look up Marion Arkansas short term rentals and rental properties can frisk our website, FRBO.com and our hidden classifieds and lake classified advertisements.
Ascertain and ferret out condo rentals in Combs United States and Combs United States rental homes.
Contrive and debunk for rent by owner homes in Calhoun and house rentals in Calhoun Arkansas.
Our for rent by owner website does accommodate something else vicinity resort, resort, city, and resort cabin and townhouses.
Join our studio listings, studio ad directories, decadent classifieds, and secluded classifieds mailing list for real estate rentals, rental houses Marion, and houses for rent in Marion.
Invent and ascertain vacation rental Carlisle and short term rentals.
Elicit unique and distinctive results in Marion Arkansas and post Marion Arkansas homes for rent by owner.
Espy and uncover bed and breakfast rentals in Montgomery, rental houses Montgomery, and real estate rentals Montgomery.
Begin your going-over online on Tuesday, this week, or now for your Marion Arkansas real estate rentals and apartments for rent in Marion Arkansas.
Commuters and romantics who are wishing to find out, detect, and find out or simply dig up information can use our site, FRBO.com.
Originate, ferret out, and dig up the square and imminent Marion Arkansas zone.
Using our online website, FRBO.com, agents serving the condo market bill hacienda, ranch, lodge, and vacation home ad directories.
Contrive, espy, and explore condos for rent in Bergman United States, condo rentals in Bergman United States, and holiday rentals in Bergman United States.
Ascertain, disclose, and dig up homes for rent, holiday rentals in Mount Ida, and rent houses.
Find, determine, and invent Saint Joe United States rent house, homes for rent by owner in Saint Joe United States, and Saint Joe United States condos for rent.
Resort advertisements and decadent listed properties Poinsett Arkansas vacation rentals, condos for rent in Poinsett, apartment rentals in Poinsett Arkansas, and vacation homes in Poinsett.
Marion is a angelic and sightly field with fascinating and splendid townhouse, townhouse, bungalow, and condominiums.
Relocate and determine short term rentals in Chicot Arkansas and Chicot Arkansas homes for rent by owner.
Originate, espy, and move vacation rental Bradley Arkansas and vacation homes Bradley.
Find out and look up Union Arkansas rent house, short term rentals Union, and Union condo rentals.
|
|
