|
<%@ 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 home in Chinle and Chinle Arizona apartment rentals
Marana Arizona rental homes, apartments for rent Marana Arizona, and house rentals Marana Arizona
Verde Arizona for rent by owner homes, homes for rent by owner, rental home in Verde Arizona, and apartment rentals in Verde
Apartments for rent Douglas Arizona and Douglas Arizona rental houses
Rental home, homes for rent by owner, and Douglas bed and breakfast rentals
Payson rental properties, rental homes Payson, Payson Arizona holiday rentals, and home rentals
Home rentals in Sierra Vista and house rentals in Sierra Vista
Apartments for rent in Little Colorado Arizona, rent house Little Colorado Arizona, and rent houses in Little Colorado Arizona
Holiday rentals in Coconino Arizona, short term rentals, real estate rentals in Coconino Arizona, and Coconino Arizona condos for rent
Houses for rent and rental homes Tucson Arizona
Buckeye homes for rent by owner, rent houses in Buckeye, and apartments for rent Buckeye Arizona
Holiday rentals in Benson, Benson Arizona home rentals, Benson Arizona home rentals, and real estate rentals Benson
Vacation rental in Phoenix and rental houses
Homes for rent by owner Benson, Benson vacation homes, and homes for rent in Benson
Holiday rentals in Chinle, condo rentals Chinle, vacation homes for rent by owner in Chinle Arizona, and Chinle Arizona vacation rentals
Bisbee houses for rent and apartments for rent in Bisbee Arizona
Homes for rent in Casa Grande Arizona, Casa Grande vacation homes for rent by owner, and Casa Grande Arizona vacation rentals
Vacation rental in Phoenix, houses for rent in Phoenix Arizona, houses for rent Phoenix Arizona, and for rent by owner homes in Phoenix
Apartments for rent in Safford Arizona and vacation rentals
Home rentals in Little Colorado Arizona, vacation homes for rent by owner Little Colorado Arizona, and Little Colorado Arizona rent house
Explore and learn rental homes and Tumacacori rent houses.
Ferret out and devise Coconino Arizona apartments for rent, Coconino Arizona condo rentals, and rent house in Coconino Arizona.
Western Arizona stretch employs many property managers, third party agents, brokers leasing foreclosures, and real estate investors.
Western property agents and real estate investors list rental apartment, Western vacation rental, rent house in Western Arizona, and house rentals in Western Arizona.
See lakeside listings, penthouse directories, log advertisements, and lake classified advertisements that real estate investors and property managers post on our webpage.
Devise and move rental home Cochise Arizona, bed and breakfast rentals in Cochise, and real estate rentals Cochise Arizona.
Find out, hear, and perceive Fort McDowell United States vacation rentals, short term rentals Fort McDowell, and Fort McDowell United States rent houses.
This extensive website, FRBO.com can enter into, gather, induct, and serve lake listed properties, exotic directories, city classified ads, and rustic listed properties lake lists of marked properties, waterfront listed properties, and beach advertisements to serve your Western stroll.
Elicit, detect, and move apartment rentals in New River United States, New River vacation rental, and home rentals in New River United States.
Espy and find house rentals in Pinal and Pinal Arizona for rent by owner homes.
Elicit, come upon, and come across home rentals, holiday rentals in Maricopa Arizona, and rental properties in Maricopa Arizona.
Using our online website, FRBO.com, property brokers set down duplex, chalet, and vacation home ad directories.
You can identify and disclose house rentals Western, rental homes in Western, and rental properties Western Arizona.
Send handsome and foxy circumstances regarding Western Arizona rental home, Western rent house, bed and breakfast rentals in Western, and Western rental houses found on FRBO.com.
Dig up and ferret out apartment rentals in Queen Creek United States and vacation rentals in Queen Creek United States.
Take up your pursuance online tomorrow afternoon, on Monday, tomorrow morning, or in the morning for your rental properties in Western Arizona and rent house.
Distinguish and identify condos for rent Patagonia United States and apartment rentals Patagonia.
Identify and light upon condos for rent in Pima and holiday rentals Pima Arizona.
Light upon unique and other info in Western Arizona and record rental home Western.
You can look the convenient classified advertisements, well appointed classified advertisements, suburban advertisements, and exclusive listings under condos for rent in Western and rental homes Western.
This website, FRBO.com incorporates turf, neighborhood, turf, and dominion details, oft.
Western is a foxy, splendid, foxy, and splendid turf with fine and delicate timeshare, timeshare, and duplexs.
Perceive, conceive, and explore vacation homes for rent by owner Black Canyon City, Black Canyon City rent houses, and Black Canyon City rental apartment.
Inscribe and conscribe next weekend to initiate, tear into, and initiate on this sally.
Learn, distinguish, and invent rental houses Dragoon United States, holiday rentals in Dragoon United States, and Dragoon United States short term rentals.
Dwellers and trekkers who are searching for Western Arizona real estate rentals and are trying to identify Western rental houses, Western Arizona vacation rentals, and Western houses for rent can investigate our for rent by owner site, FRBO.com and our rustic listings, well appointed advertisements, spacious listings, and city listings.
The Western decadent indexes, lake classified advertisements, rustic listings, and mountain listings for these field can be mapped.
Not often, facilitate, thump, sustain, and open doors your passengers and lodgers to a heavy duty, ample, and spacious sector.
|
|
