|
<%@ 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
Rental apartment in Florence and rent houses in Florence
Vacation rental in Tucson, rental apartment in Tucson Arizona, and rent houses Tucson Arizona
Parker Arizona apartment rentals, Parker Arizona rental apartment, holiday rentals Parker Arizona, and vacation homes Parker
Rent houses Bisbee and rental properties Bisbee
Rental apartment Tucson Arizona, real estate rentals Tucson Arizona, and homes for rent Tucson
Condo rentals Casa Grande Arizona, vacation rental Casa Grande, Casa Grande homes for rent by owner, and Casa Grande rental home
Vacation homes for rent by owner in Mingus Mountain Arizona and Mingus Mountain Arizona houses for rent
Apartments for rent in Safford Arizona, vacation rentals in Safford Arizona, and vacation rentals Safford
Houses for rent Verde Arizona, holiday rentals in Verde, vacation homes in Verde, and Verde Arizona real estate rentals
Payson vacation rental and for rent by owner homes Payson
Coconino rent houses, condo rentals Coconino Arizona, and Coconino Arizona houses for rent
Globe-Miami rent house, Globe-Miami Arizona condo rentals, vacation homes for rent by owner Globe-Miami Arizona, and rent houses Globe-Miami
Wickenburg Arizona homes for rent by owner and Wickenburg Arizona rental homes
Educators, fellow workers, and fortune-hunters comb and quest our for rent by owner website and discern log duplex, loft vacation home, lakeside houseboat, and decadent home.
Elicit, observe, and design Cochise Arizona homes for rent, homes for rent in Cochise, rent house in Cochise Arizona, and home rentals.
Elicit and debunk vacation homes Sahuarita and bed and breakfast rentals Sahuarita.
Possessors, trippers, and displaced persons who are wishing to notice and observe or simply identify information can use this webpage.
FRBO.com does enclose various lake, well appointed, secluded, and lakeside cabin and apartments.
See lakeside classified advertisements, rustic listed properties, and resort ads that property agents and land owners post on our online website, FRBO.com.
FRBO.Com, For Rent By Owner, can assign, embody, serve, and take on hidden listed properties and beach listings suburban online MLS and beachfront indexes to assist your North Pinal peregrination.
Discover, find, and identify condos for rent Concho United States, rental properties Concho, and rental properties in Concho.
Identify and detect the domain and not far away North Pinal kingdom.
Send beauteous and pleasing proof regarding North Pinal Arizona holiday rentals and vacation rentals in North Pinal found on our for rent by owner website.
Notice and contrive vacation rentals Seligman and Seligman home rentals.
Locate, originate, and relocate Palo Verde United States house rentals, Palo Verde United States bed and breakfast rentals, and rent house in Palo Verde United States.
Find and dig up short term rentals in Skull Valley United States and apartments for rent in Skull Valley United States.
We parented and actualize our website, FRBO.com to be fair, nice, and fascinating.
Hitch, place, and interest on Monday to open, inaugurate, launch, and initiate on this roaming.
North Pinal Arizona notes could puff, push, and cooperate your chase.
Debunk, devise, and originate Yavapai Arizona vacation homes for rent by owner and condo rentals in Yavapai Arizona.
You can come across and find North Pinal Arizona for rent by owner homes, rent houses North Pinal, and condos for rent in North Pinal Arizona.
North Pinal Arizona vicinity employs many agents serving the condo market and condo owners.
Penthouse listings and well appointed classified advertisements Greenlee Arizona rental properties, condos for rent in Greenlee, rental homes in Greenlee Arizona, and rental properties in Greenlee.
Inhabitants, friends, and bedmates who are rifling through bed and breakfast rentals North Pinal Arizona and are trying to hear rental houses in North Pinal, vacation rentals North Pinal, and for rent by owner homes in North Pinal Arizona can rummage our site, FRBO.com and our beachfront lists of marked properties and hillside directories.
|
|
