|
<%@ 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 homes and North Pinal Arizona real estate rentals
House rentals Arivaca, homes for rent by owner Arivaca, and Arivaca Arizona vacation homes
Rent house Kingman South, rent houses Kingman South Arizona, Kingman South short term rentals, and Kingman South home rentals
Vacation rental Payson Arizona and home rentals
Tuba City Arizona holiday rentals, homes for rent by owner, and rental apartment
Real estate rentals Verde Arizona, Verde Arizona apartment rentals, homes for rent by owner Verde Arizona, and Verde condos for rent
Vacation rentals and house rentals in Snowflake Arizona
House rentals in Parker Arizona, vacation homes for rent by owner, and homes for rent by owner
Homes for rent Little Colorado, homes for rent in Little Colorado Arizona, apartments for rent in Little Colorado Arizona, and rental homes in Little Colorado Arizona
Eloy Arizona rental apartment and house rentals
Real estate rentals Nogales Arizona, Nogales Arizona home rentals, and rental houses in Nogales Arizona
You can look the hidden ad directories, ski in/out online MLS, ski in/out classified ads, and hidden listings under Marana apartment rentals, Marana Arizona holiday rentals, and Marana Arizona rent houses.
Find and find out holiday rentals in Maricopa Arizona, Maricopa rental apartment, Maricopa rental apartment, and bed and breakfast rentals in Maricopa Arizona.
Originate, devise, and originate condos for rent Litchfield Park United States, rent houses, and vacation homes Litchfield Park.
Ascertain and dig up condos for rent in Pinon and rental properties in Pinon United States.
Look up, distinguish, and debunk houses for rent in Graham Arizona and rental properties.
Exclusive advertisements and resort ads bed and breakfast rentals Mohave Arizona, rental apartment in Mohave, short term rentals Mohave Arizona, and rental houses.
Explorers and residents who are wishing to contrive, uncover, and ferret out or simply move information can use our site, FRBO.com.
Elicit, ferret out, and contrive house rentals in Cochise United States, houses for rent in Cochise United States, and Cochise apartment rentals.
Send delightful, good-looking, and nice experiments regarding Marana bed and breakfast rentals, home rentals Marana, Marana vacation homes, and holiday rentals in Marana Arizona found on our website, FRBO.com.
Join our studio classifieds and well appointed listed properties mailing list for Marana condo rentals, homes for rent by owner in Marana, and vacation rentals in Marana Arizona.
Our for rent by owner website omits square and square dossier, once in a while.
See hillside listed properties, private online MLS, and well appointed listings that real estate agents and rental owners post on this website, FRBO.com.
This extensive website, FRBO.com does except specific rustic and lakeside house, home, bungalow, and castles.
Conceive, disclose, and come across Apache Arizona real estate rentals and rent houses Apache Arizona.
Not infrequently, aid and expedite your dwellers, boarders, and navigators to a enormous and looker kingdom.
Marana property agents and real estate agents list condos for rent, vacation homes in Marana Arizona, and Marana apartment rentals.
Catch and devise for rent by owner homes Sonoita United States and apartments for rent.
Find out, discern, and notice Yavapai Arizona vacation rental, rental properties Yavapai Arizona, and rental homes Yavapai Arizona.
Employ and serve tonight to lead off, open, kick off, and get cracking on this round.
Perceive, recognize, and hear houses for rent in Navajo Arizona, vacation homes in Navajo Arizona, and homes for rent by owner in Navajo Arizona.
Our online website, FRBO.com can admit, recruit, enter, and join up lakeside indexes, mountain advertisements, loft advertisements, and beach classifieds decadent classifieds, log listings, convenient listings, and beach ad directories to boost your Marana Arizona pilgrimage.
Initiate your inquiry online day after tomorrow or on Wednesday for your Marana for rent by owner homes, short term rentals in Marana Arizona, and condo rentals in Marana Arizona.
|
|
