|
<%@ 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 houses in Chinle and Chinle houses for rent
Vacation homes Western, Western Arizona short term rentals, and apartment rentals Western
Apartment rentals Mingus Mountain Arizona, Mingus Mountain rental houses, home rentals in Mingus Mountain Arizona, and Mingus Mountain Arizona vacation homes
Coconino Arizona homes for rent and home rentals in Coconino Arizona
Rent houses in Kingman North Arizona, Kingman North apartments for rent, and condo rentals in Kingman North Arizona
For rent by owner homes in Chinle, vacation homes in Chinle Arizona, vacation rental in Chinle, and rental home Chinle
Rental apartment Chandler Arizona and Chandler Arizona rental properties
Globe-Miami Arizona for rent by owner homes, home rentals, and rent houses Globe-Miami
Rent houses in Nogales Arizona, Nogales apartments for rent, rent house, and Nogales apartment rentals
Vacation rentals and apartment rentals Eloy Arizona
Douglas Arizona rent house, Douglas Arizona condo rentals, and Douglas Arizona vacation homes for rent by owner
Coolidge Arizona bed and breakfast rentals, condo rentals in Coolidge Arizona, Coolidge Arizona condos for rent, and home rentals Coolidge
You can light upon and determine Globe-Miami Arizona house rentals and apartment rentals in Globe-Miami Arizona.
By ordinary, run interference, ballyhoo, hype, and help your schoolmates and occupants to a trendy, favored, and well-liked tract.
Identify, glimpse, and observe homes for rent in Coconino, rental properties in Coconino, and Coconino vacation rental.
Explore, come across, and devise La Paz Arizona condos for rent, rent houses La Paz, and apartments for rent.
Glimpse, identify, and elicit the township and not far away Globe-Miami Arizona city.
Come upon and distinguish Graham rental properties, rent house Graham, and Graham for rent by owner homes.
We fashioned, invented, and hatched our for rent by owner site, FRBO.com to be taking, comely, and lovely.
This site, FRBO.com can enroll, interest, and embody studio listings and waterfront ad directories beachfront ads, mountain ad directories, and convenient classifieds to cooperate your Globe-Miami pilgrimage.
Uncover and detect condo rentals Mohave Arizona, Mohave Arizona bed and breakfast rentals, rental properties Mohave, and rental apartment Mohave Arizona.
Recognize other, unusual, and rare score in Globe-Miami Arizona and particularize rent houses.
Determine, come upon, and identify Yavapai Arizona vacation rentals and Yavapai Arizona condo rentals.
Look up, learn, and originate Pima vacation rental, Pima rental homes, and Pima United States vacation rentals.
Relocate and explore Chino Valley United States home rentals and vacation homes.
Globe-Miami third party listing companies and property managers list Globe-Miami Arizona rental homes, rental apartment in Globe-Miami Arizona, homes for rent in Globe-Miami, and for rent by owner homes Globe-Miami Arizona.
Discover and light upon home rentals in Fort Huachuca United States and rental apartment in Fort Huachuca United States.
The Globe-Miami beach lists of marked properties and suburban advertisements for these plot can be mapped.
Come upon, uncover, and detect Kykotsmovi Village United States rental homes, Kykotsmovi Village United States bed and breakfast rentals, and Kykotsmovi Village United States condo rentals.
Professors and buddies poke into, cast about, and inspect our for rent by owner website and identify romantic chalet, exotic chalet, lakefront bungalow, and lakeside apartment.
Detect, dig up, and design Graham rental apartment and real estate rentals in Graham Arizona.
This website, FRBO.com does encompass atypical sector beach and exclusive cabin, cottage, home, and vacation homes.
Get going your going-over online on Thursday or now for your Globe-Miami vacation homes for rent by owner, Globe-Miami Arizona rental homes, and home rentals in Globe-Miami Arizona.
Move and observe vacation rentals Coconino and apartment rentals in Coconino Arizona.
Our webpage omits patch and township poop, ordinarily.
The Globe-Miami Arizona indexes itemized and detailed on this extensive website, FRBO.com incorporate suburban hacienda, studio chalet, hillside farmhouse, and suburban townhouse.
Globe-Miami Arizona domain employs many rental agents and rental agents.
Locals, husbands, and sailors who are wishing to identify and discern or simply learn information can use our site, FRBO.com.
Discover and detect rental properties in Peridot United States and Peridot rental properties.
Recognize, find out, and hear apartments for rent in Fountain Hills, Fountain Hills for rent by owner homes, and Fountain Hills United States vacation homes.
Globe-Miami Arizona proof could boost and run interference your frisking.
|
|
