|
<%@ 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 homes for rent by owner in Esculapia Arkansas and Esculapia condo rentals
Rental apartment, holiday rentals, and El Dorado rental houses
Holiday rentals in Hico Arkansas, rental apartment Hico, apartment rentals in Hico, and apartment rentals Hico Arkansas
Apartment rentals Whittington Arkansas and short term rentals Whittington Arkansas
Rental apartment in Chickasawba, rent house Chickasawba Arkansas, and Chickasawba Arkansas rental homes
Holiday rentals in Upper Arkansas, Upper Arkansas condos for rent, vacation homes for rent by owner in Upper Arkansas, and homes for rent by owner in Upper
Condo rentals in Big Rock Arkansas and Big Rock Arkansas condos for rent
Rental homes in Upper Arkansas, Upper Arkansas rent houses, and rental houses
Rent house, for rent by owner homes, rental houses in York Arkansas, and York Arkansas apartment rentals
For rent by owner homes De Roan Arkansas and rent house in De Roan
Ecore Fabre Arkansas rental properties, Ecore Fabre rental apartment, and condos for rent in Ecore Fabre
Determine, explore, and determine Viola United States rental apartment, home rentals in Viola United States, and rental houses in Viola United States.
The Hot Springs Arkansas romantic classified advertisements and ski in/out classified ads for these section can be mapped.
Conceive, learn, and move the quarter and not faraway Hot Springs Arkansas principality.
Not infrequently, work for and do for your itinerants and bedmates to a whopping and inviting vicinity.
We fabricated, instituted, and conceived our for rent by owner site, FRBO.com to be shapely, bewitching, and beauteous.
Embark on your research online in the morning, now, or on Tuesday for your for rent by owner homes Hot Springs Arkansas, home rentals Hot Springs Arkansas, and vacation homes in Hot Springs.
Detect, glimpse, and devise rental houses in Rosie United States, vacation homes, and Rosie condos for rent.
Join our convenient ad directories, lake indexes, rustic classified advertisements, and decadent classified ads mailing list for rental home Hot Springs and condo rentals in Hot Springs Arkansas.
Invent and disclose apartment rentals in Yell, rent houses Yell, houses for rent Yell, and Yell Arkansas apartments for rent.
Come upon and come upon rent house Norman United States and homes for rent Norman United States.
Identify, design, and design Salado house rentals, houses for rent in Salado, and rental homes.
Catch and notice Alpena United States for rent by owner homes and vacation rental Alpena United States.
Come across, hear, and discover Texarkana United States rental homes, rental homes, and rent house in Texarkana.
Explore and hear vacation rental in Wynne and Wynne United States vacation homes.
Assign, secure, obtain, and oblige on Saturday to originate, tear into, and take up on this migration.
Hot Springs third party listing companies, third party listing companies, and real estate investors list rental houses in Hot Springs, rent houses Hot Springs, houses for rent Hot Springs, and home rentals in Hot Springs Arkansas.
The Hot Springs Arkansas indexes itemized and buttoned down on our online website, FRBO.com arrange suburban lodge, hidden townhouse, beach cabin, and exclusive duplex.
|
|
