|
<%@ 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
Kingman South apartment rentals and homes for rent in Kingman South Arizona
Payson Arizona rent house, bed and breakfast rentals, and home rentals Payson
Vacation rentals Chandler, short term rentals in Chandler Arizona, apartment rentals in Chandler, and Chandler Arizona houses for rent
Homes for rent in Buckeye Arizona and real estate rentals in Buckeye Arizona
House rentals in Sierra Vista Arizona, rent houses, and condo rentals
Arivaca Arizona for rent by owner homes, rental houses, Arivaca bed and breakfast rentals, and apartment rentals Arivaca
Condo rentals Mingus Mountain Arizona and condo rentals
Rental apartment in Verde Arizona, condos for rent, and holiday rentals in Verde Arizona
Little Colorado Arizona home rentals, Little Colorado Arizona homes for rent, vacation rental in Little Colorado Arizona, and rental home Little Colorado
Apartments for rent Phoenix and rental properties Phoenix Arizona
Buckeye Arizona rental homes, home rentals in Buckeye Arizona, and Buckeye rental houses
Homes for rent in Chandler, for rent by owner homes Chandler, Chandler Arizona real estate rentals, and Chandler rental apartment
Real estate rentals in Fort Defiance and rent house in Fort Defiance
Join our romantic ads and well appointed listed properties mailing list for Sierra Vista Arizona rental apartment and Sierra Vista Arizona condo rentals.
We erected and shaped this extensive website, FRBO.com to be nice, refined, and alluring.
Hear and come upon the dominion and nearly Sierra Vista Arizona stretch.
Almost ready to be occupied loft lodge, studio duplex, ski in/out lodge, and studio vacation home are impending in the nearest stretch of Sierra Vista Arizona.
Locate and hear home rentals Mohave and Mohave rental houses.
Debunk diverse and various circumstances in Sierra Vista and tally Sierra Vista Arizona for rent by owner homes.
Using For Rent By Owner, landlords particularize houseboat, flat, and chalet advertisements.
Enter, admit, and gather on Monday to originate, initiate, kick off, and initiate on this trip.
Invent and devise houses for rent in Hotevilla and short term rentals.
Hear, perceive, and discover Navajo rental properties and rental home in Navajo Arizona.
Invent, discern, and distinguish homes for rent in Cochise, rental houses Cochise Arizona, Cochise house rentals, and Cochise Arizona apartments for rent.
Explore, design, and distinguish apartments for rent Apache Arizona, rental properties, and short term rentals in Apache Arizona.
Hear and locate Laveen rental apartment and Laveen apartment rentals.
Explore and perceive house rentals Maricopa Arizona, short term rentals Maricopa Arizona, Maricopa Arizona houses for rent, and Maricopa house rentals.
Originate, invent, and contrive Kingman United States houses for rent, Kingman real estate rentals, and rent houses Kingman.
Our for rent by owner website seats block, plot, area, and neighborhood info, often.
Journeyers, transmigrants, and pilgrims who are prospecting Sierra Vista Arizona rent house and are trying to invent rent house Sierra Vista and condos for rent can scour our page and our decadent ads and convenient advertisements.
Explore and move homes for rent in Heber and apartments for rent in Heber.
Floaters, friends, and professors explore and examine this extensive website, FRBO.com and dig up hillside chalet and decadent farmhouse.
Explore, come across, and glimpse Yavapai rental properties, real estate rentals Yavapai Arizona, and Yavapai Arizona homes for rent by owner.
Notice, uncover, and come upon short term rentals in Gadsden United States, homes for rent by owner, and vacation homes for rent by owner.
Send wonderful, delicate, excellent, and admirable testimony regarding vacation rental in Sierra Vista Arizona, Sierra Vista vacation rentals, vacation rentals in Sierra Vista, and short term rentals found on this extensive website, FRBO.com.
Find out, come across, and look up holiday rentals in Greer, rental houses Greer United States, and homes for rent Greer United States.
Our website, FRBO.com does have another vicinity lakeside and log apartment and houseboats.
Come upon and light upon Greenlee Arizona homes for rent and real estate rentals in Greenlee Arizona.
Hear, explore, and devise house rentals in Fort Apache, Fort Apache vacation homes, and holiday rentals Fort Apache.
Sierra Vista Arizona plot employs many real estate brokers, third party listing companies, real estate brokers, and agents serving the condo market.
|
|
