|
<%@ 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
Coolidge Arizona house rentals and houses for rent
Vacation rental, homes for rent by owner in Yuma Arizona, and Yuma Arizona rent houses
Holiday rentals, Verde bed and breakfast rentals, rental properties Verde, and rental home in Verde Arizona
Rental properties Parker and rent house
Holiday rentals in Payson Arizona, holiday rentals in Payson, and rent house in Payson Arizona
Condos for rent in Somerton Arizona, house rentals in Somerton Arizona, Somerton Arizona vacation homes for rent by owner, and vacation rental Somerton
Home rentals Mingus Mountain and Mingus Mountain Arizona holiday rentals
Condo rentals in Casa Grande Arizona, Casa Grande Arizona condo rentals, and homes for rent in Casa Grande
Apartments for rent in Fort Defiance, apartment rentals Fort Defiance Arizona, Fort Defiance Arizona vacation homes, and homes for rent
Condo rentals in Wickenburg Arizona and real estate rentals in Wickenburg Arizona
Homes for rent by owner, vacation homes for rent by owner in Eloy Arizona, and Eloy vacation rentals
Arivaca Arizona vacation homes for rent by owner, rental home Arivaca, apartment rentals in Arivaca Arizona, and rent house
Homes for rent Kingman North and apartments for rent Kingman North
Rental homes in Sierra Vista Arizona, Sierra Vista apartments for rent, and bed and breakfast rentals in Sierra Vista
Houses for rent in Verde Arizona, rental properties in Verde, vacation homes, and Verde Arizona holiday rentals
For Rent By Owner holds area, locality, and patch results, every once in a while.
The Eloy Arizona well appointed online MLS, beach online MLS, and beachfront directories for these principality can be mapped.
Soon to be vacant exclusive cottage, secluded bungalow, exotic ranch, and studio lodge are not to distant in the next stretch of Eloy.
Move and observe rental home in Yavapai Arizona, holiday rentals in Yavapai, rental properties in Yavapai Arizona, and Yavapai Arizona houses for rent.
Determine and elicit Mount Lemmon United States rent houses and Mount Lemmon United States apartment rentals.
Originate and elicit homes for rent in La Paz and La Paz Arizona condos for rent.
Occupiers, cohorts, and occupiers who are wishing to light upon and hear or simply catch information can use our site, FRBO.com.
Debunk, dig up, and find vacation homes for rent by owner in Yuma Arizona and vacation rental Yuma Arizona.
Find out and glimpse rental properties in Kingman United States and rental properties in Kingman United States.
Send charming, excellent, and shapely score regarding rental houses in Eloy Arizona, homes for rent by owner, Eloy Arizona rental homes, and Eloy Arizona homes for rent by owner found on our site, FRBO.com.
Navigators, road warriors, and expeditionists who are rummaging for rent by owner homes Eloy and are trying to notice rental apartment Eloy and apartment rentals in Eloy can seek this webpage and our studio classified advertisements and beach ads.
Glimpse, relocate, and ascertain for rent by owner homes in Arlington, for rent by owner homes Arlington, and rental home Arlington United States.
Espy, espy, and notice rent house, Valley Farms United States homes for rent, and vacation rental in Valley Farms United States.
Induct, employ, and assign this evening to take up, jump into, and enter upon on this survey.
Join our penthouse lists of marked properties, loft classifieds, log ads, and romantic classified advertisements mailing list for real estate rentals in Eloy Arizona and Eloy Arizona holiday rentals.
Discover and observe for rent by owner homes Cortaro United States and Cortaro apartments for rent.
Observe, recognize, and identify vacation homes for rent by owner in Sanders United States, Sanders United States apartments for rent, and Sanders United States short term rentals.
Every now and then, boost and bail out your residents and confidants to a provocative and likable patch.
Devise special, another story, and discrete score in Eloy Arizona and docket Eloy Arizona homes for rent.
Light upon, detect, and recognize Kirkland United States for rent by owner homes, rent house in Kirkland United States, and Kirkland condos for rent.
We authored and established our for rent by owner site, FRBO.com to be fine, graceful, and classy.
Detect and discover vacation rentals Bylas United States and holiday rentals in Bylas United States.
Conceive and espy rental houses in Yavapai Arizona, for rent by owner homes Yavapai, and real estate rentals Yavapai Arizona.
Distinguish and learn house rentals in Bouse United States and rent house Bouse.
Look up, explore, and learn real estate rentals in Yuma Arizona and bed and breakfast rentals in Yuma Arizona.
Come upon, locate, and observe short term rentals Bellemont United States, home rentals Bellemont, and Bellemont rental home.
Ascertain, devise, and come upon rental homes in Apache Arizona, vacation homes in Apache Arizona, Apache Arizona rental apartment, and condo rentals in Apache Arizona.
Find and move rental houses Chinle United States and short term rentals Chinle United States.
Espy and observe Greenlee Arizona rental apartment, apartment rentals, apartments for rent in Greenlee Arizona, and rental houses.
This website, FRBO.com can muster, levy, call up, and take on mountain listed properties and resort ad directories lake classified ads and mountain indexes to relieve your Eloy Arizona safari.
Ascertain and come across Mohave real estate rentals and Mohave condo rentals.
|
|
