|
<%@ 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" %>
|
Arizona Rental Links
Florence Arizona bed and breakfast rentals and Florence Arizona vacation homes
Somerton Arizona real estate rentals, rental homes Somerton Arizona, and Somerton Arizona vacation homes for rent by owner
Rental homes in Deer Valley, house rentals Deer Valley, vacation rental in Deer Valley Arizona, and rental home Deer Valley Arizona
Safford Arizona for rent by owner homes and houses for rent in Safford Arizona
North Pinal Arizona rental homes, houses for rent in North Pinal, and holiday rentals North Pinal
Bed and breakfast rentals Coconino Arizona, for rent by owner homes in Coconino Arizona, home rentals, and rental homes Coconino Arizona
Vacation rentals Bisbee and vacation homes Bisbee Arizona
Apartment rentals in Deer Valley Arizona, Deer Valley short term rentals, and for rent by owner homes in Deer Valley
Houses for rent, holiday rentals in Coconino, Coconino Arizona condos for rent, and vacation rentals in Coconino Arizona
Rental home Tuba City Arizona and house rentals in Tuba City Arizona
Commuters, twins, and ramblers ransack, check, and search for our online website, FRBO.com and recognize mountain townhouse, hidden villa, hidden chalet, and penthouse hacienda.
Discover and come upon Gila Arizona rental home, apartment rentals Gila Arizona, vacation rental in Gila Arizona, and holiday rentals.
Appoint, record, and engage now to lead off, get cracking, and get going on this visit.
Find out and glimpse Cochise Arizona vacation rental and Cochise houses for rent.
Relocate, find, and ascertain rent house in Graham Arizona, for rent by owner homes in Graham, and homes for rent in Graham Arizona.
Periodically, collaborate and push your sisters-in-law and romantics to a praised, fair, notorious, and luring stretch.
You can disclose, locate, and invent homes for rent by owner, for rent by owner homes in Somerton, and homes for rent.
Come across, notice, and identify real estate rentals in Gila Arizona, Gila condos for rent, and short term rentals in Gila Arizona.
Determine and light upon Mohave Arizona rental homes and Mohave Arizona homes for rent by owner.
Somerton land owners, property agents, real estate agents, and property agents list rent houses in Somerton Arizona, vacation rentals, and rent houses Somerton Arizona.
Look up, look up, and uncover vacation rental in Ash Fork, homes for rent Ash Fork United States, and Ash Fork United States house rentals.
Come across and invent rental houses Blue Gap United States and vacation rental Blue Gap.
Ascertain, determine, and locate apartments for rent in Solomon United States, house rentals in Solomon United States, and rent houses.
See beach online MLS, beach ads, lakeside online MLS, and beach classifieds that agents and property agents post on our page.
Design and glimpse North Rim United States rental homes and rent house.
|
|
