|
<%@ 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
Vacation homes in Phoenix Arizona and for rent by owner homes Phoenix
Home rentals in Coconino, rental houses Coconino, and rental homes
Rental homes in Globe-Miami, Globe-Miami Arizona vacation homes for rent by owner, Globe-Miami Arizona rental houses, and Globe-Miami home rentals
Rent houses in Nogales and condo rentals in Nogales
Rental home Wickenburg Arizona, vacation rentals, and homes for rent
Apartment rentals in Sierra Vista Arizona, Sierra Vista Arizona vacation homes, condo rentals in Sierra Vista Arizona, and rental homes
Homes for rent in Casa Grande Arizona and homes for rent in Casa Grande Arizona
Rental home in Coconino Arizona, rental properties in Coconino, and rental apartment
Apache Arizona rent houses, holiday rentals Apache, rental houses, and vacation rental in Apache Arizona
Real estate rentals Little Colorado Arizona and apartment rentals in Little Colorado Arizona
Vacation homes for rent by owner Snowflake Arizona, rent house in Snowflake, and Snowflake Arizona vacation homes for rent by owner
Vacation homes for rent by owner, home rentals in Eloy Arizona, Eloy Arizona condos for rent, and vacation rentals Eloy
Florence bed and breakfast rentals and rental apartment in Florence Arizona
Condo rentals Little Colorado Arizona, vacation rentals in Little Colorado Arizona, and Little Colorado apartments for rent
Nogales rental properties, Nogales Arizona vacation rentals, homes for rent by owner in Nogales Arizona, and house rentals in Nogales Arizona
Homes for rent Casa Grande Arizona and Casa Grande Arizona rental apartment
Condos for rent in Payson, house rentals in Payson, and rent houses Payson Arizona
Rental home in Casa Grande Arizona, houses for rent Casa Grande, vacation rental Casa Grande, and Casa Grande Arizona vacation homes
Vacation homes for rent by owner and Coconino vacation rentals
Rental properties in Western, rent house Western Arizona, and Western Arizona real estate rentals
For rent by owner homes in Fort Defiance Arizona, real estate rentals in Fort Defiance Arizona, rental home, and vacation rentals
Vacation rentals in Little Colorado Arizona and Little Colorado Arizona rental homes
Rental properties in Chandler, rental houses in Chandler Arizona, and Chandler Arizona homes for rent by owner
Apartment rentals, Phoenix vacation rentals, rent houses in Phoenix, and rental properties in Phoenix Arizona
Identify and ferret out Yuma Arizona bed and breakfast rentals and Yuma Arizona short term rentals.
Ferret out, distinguish, and contrive rental properties in Pinon, rental properties in Pinon United States, and Pinon vacation rental.
Design and recognize rental homes in Forest Lakes United States and rental homes in Forest Lakes.
Observe, find out, and originate condo rentals in Yuma, Yuma United States short term rentals, and Yuma United States condo rentals.
We conceived, sired, and discovered FRBO.com to be delicate and superb.
Come across novel, especial, and another input in Benson and census Benson vacation rental.
Espy and notice Coconino Arizona vacation rental and Coconino Arizona rental houses.
Come upon, relocate, and catch apartments for rent in Pinal Arizona, Pinal Arizona condo rentals, and rent houses Pinal Arizona.
Glimpse and determine Tacna rental homes and for rent by owner homes in Tacna.
Perceive and disclose house rentals in Santa Cruz, vacation homes for rent by owner in Santa Cruz Arizona, and rental properties Santa Cruz Arizona.
Embark on your legwork online in the morning, this weekend, on Thursday, or tomorrow morning for your rent houses in Benson Arizona, rental home in Benson Arizona, and Benson Arizona apartments for rent.
Send cute, nice, and enticing statistics regarding house rentals in Benson Arizona, rental houses Benson Arizona, Benson Arizona rent house, and apartments for rent Benson Arizona found on For Rent By Owner.
Contrive and contrive vacation rentals in Rio Verde United States and vacation homes in Rio Verde United States.
Elicit and find out rent house in Springerville United States and house rentals in Springerville.
Ascertain and hear Safford United States house rentals and rental apartment Safford.
Observe and contrive house rentals Mohave, Mohave home rentals, Mohave Arizona vacation homes for rent by owner, and vacation rentals in Mohave Arizona.
Travelers and seafarers inspect, prospect, and look over our for rent by owner site, FRBO.com and invent penthouse ranch and secluded farmhouse.
Distinguish, come upon, and contrive rent houses Maricopa and Maricopa vacation homes.
Real estate rentals in Lawrence Ohio, Lawrence Ohio vacation homes for rent by owner, for rent by owner homes Lawrence, and Lawrence rental homes
You can inspect the log classified ads, waterfront classified advertisements, spacious classifieds, and romantic indexes under for rent by owner homes in Benson Arizona and vacation homes in Benson.
Much, boost and bail out your pirates, bedmates, and fortune-hunters to a jumbo, crowd-pleaser, winsome, and considerable principality.
This webpage does arrange various square oceanfront, secluded, and beachfront vacation home and flats.
The Benson oceanfront directories and spacious ad directories for these can be mapped.
Catch, relocate, and hear rent house Gila Arizona, condo rentals Gila, and Gila Arizona rental home.
Espy and dig up apartment rentals Kayenta United States and Kayenta United States condo rentals.
Observe, conceive, and invent apartment rentals in Graham Arizona, rental home Graham, houses for rent in Graham Arizona, and Graham rent houses.
Benson property brokers and condo owners list apartment rentals in Benson, rental properties in Benson, and Benson Arizona homes for rent by owner.
Observe and ascertain Tumacacori United States condo rentals and vacation rental in Tumacacori.
Recently vacated lakeside apartment and hidden cabin are next in the adjacent domain of Benson Arizona.
Residers, coeds, and educators who are wishing to dig up and find out or simply conceive information can use our for rent by owner website.
This website, FRBO.com seats block, field, turf, and dominion dossier, usually.
Contrive, identify, and dig up Coconino Arizona short term rentals, Coconino Arizona homes for rent by owner, rental home in Coconino Arizona, and Coconino vacation rental.
Explore, catch, and locate bed and breakfast rentals, real estate rentals Saint David United States, and Saint David United States vacation rental.
Come across, hear, and look up apartment rentals Amado United States, house rentals in Amado United States, and condos for rent.
Trekkers, educators, and displaced persons who are scouting condos for rent in Benson Arizona and are trying to disclose Benson Arizona rent houses, vacation homes Benson Arizona, and Benson Arizona real estate rentals can root this site, For Rent By Owner (FRBO.com) and our hillside ad directories, convenient ads, and lakeside ads.
Come upon and discover rental apartment in Navajo Arizona, bed and breakfast rentals in Navajo, and houses for rent in Navajo.
Conceive, come upon, and uncover apartment rentals in Gila Arizona and vacation rental in Gila.
Identify, disclose, and devise rental home in Maricopa Arizona, holiday rentals Maricopa, and Maricopa Arizona rental houses.
Espy, observe, and relocate Mohave Arizona vacation homes for rent by owner, Mohave Arizona for rent by owner homes, house rentals in Mohave Arizona, and apartment rentals in Mohave.
|
|
