|
<%@ 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
Rent houses and apartment rentals Yuma Arizona
Home rentals Chandler Arizona, vacation rental in Chandler, and bed and breakfast rentals in Chandler
Rental houses Apache Arizona, Apache Arizona vacation homes for rent by owner, homes for rent Apache, and condos for rent in Apache
Houses for rent in Florence Arizona and apartments for rent Florence Arizona
Coconino rental properties, home rentals in Coconino, and house rentals in Coconino
Snowflake house rentals, vacation homes for rent by owner in Snowflake Arizona, Snowflake Arizona bed and breakfast rentals, and Snowflake Arizona vacation homes for rent by owner
Condo rentals Payson and homes for rent in Payson Arizona
Real estate rentals Chinle, Chinle Arizona apartment rentals, and Chinle Arizona homes for rent by owner
Florence vacation rental, rental homes in Florence Arizona, rental home Florence Arizona, and condos for rent
Vacation rentals and homes for rent in Safford
Home rentals Benson Arizona, Benson Arizona condo rentals, and Benson for rent by owner homes
Homes for rent by owner in Kingman North Arizona, homes for rent by owner in Kingman North, rental home Kingman North, and houses for rent Kingman North
Vacation rental Apache and houses for rent Apache Arizona
Condo rentals in Bisbee Arizona, apartments for rent, and condo rentals
Safford Arizona house rentals, Safford Arizona real estate rentals, rental homes Safford, and Safford vacation rental
Homes for rent and condos for rent in San Manuel Arizona
Find and elicit for rent by owner homes in Eden United States and apartment rentals in Eden United States.
Suburban listed properties and secluded directories real estate rentals in Yuma Arizona, rental home, Yuma Arizona condos for rent, and Yuma Arizona apartments for rent.
Invent, explore, and dig up rental homes in Cochise Arizona, Cochise Arizona short term rentals, and homes for rent by owner in Cochise Arizona.
You can ascertain and distinguish condos for rent and Arivaca Arizona vacation homes for rent by owner.
You can rummage the romantic classifieds, beach ad directories, and beach classified advertisements under Arivaca Arizona homes for rent by owner and home rentals Arivaca.
Contrive and notice Lukachukai United States apartment rentals and short term rentals Lukachukai United States.
Arivaca Arizona precinct employs many third party agents, property brokers, property managers, and property brokers.
Discern, find, and learn Topawa United States house rentals, Topawa rental houses, and Topawa United States rental apartment.
Learn, debunk, and discern Fort Huachuca United States vacation homes, houses for rent Fort Huachuca United States, and for rent by owner homes.
Originate and look up vacation rental Gila and rental houses Gila Arizona.
The Arivaca Arizona online MLS kept counted and inscribed on FRBO.Com, For Rent By Owner, encompass hidden chalet, secluded townhouse, resort home, and ski in/out ranch.
Catch, devise, and invent Coconino Arizona home rentals and for rent by owner homes in Coconino Arizona.
Send dazzling and good-looking input regarding Arivaca Arizona rental apartment, real estate rentals in Arivaca Arizona, vacation rental in Arivaca Arizona, and apartment rentals in Arivaca found on this site, FRBO.com.
Regularly, puff and collaborate your traveling saleswomen, friends, and trippers to a luring, enormous, selling, and beckoning parcel.
Join our loft ad directories, log listings, lakefront listed properties, and exclusive ads mailing list for for rent by owner homes and Arivaca apartments for rent.
Unused beach duplex, beachfront condominium, hidden timeshare, and hillside flat are not remote in the imminent township of Arivaca.
Glimpse and look up homes for rent by owner in Navajo Arizona and Navajo Arizona condo rentals.
Join and conscribe this weekend to get cracking, enter upon, and open on this hike.
Arivaca land owners, town home owners, third party agents, and agents serving the condo market list Arivaca real estate rentals, condos for rent, home rentals in Arivaca Arizona, and rent houses Arivaca Arizona.
We erected, forged, and formed our site, FRBO.com to be sightly, pulchritudinous, delicate, and well-formed.
|
|
