|
<%@ 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
San Manuel Arizona homes for rent by owner and San Manuel Arizona rental properties
Rental apartment in Prescott, holiday rentals, and vacation rentals Prescott Arizona
Real estate rentals in Benson, vacation homes for rent by owner in Benson, rental home Benson, and short term rentals Benson Arizona
Rent houses in Bisbee Arizona and apartments for rent Bisbee Arizona
Short term rentals Yuma, bed and breakfast rentals, and Yuma vacation rental
Mingus Mountain Arizona vacation homes for rent by owner, short term rentals, Mingus Mountain Arizona short term rentals, and rental houses in Mingus Mountain Arizona
Vacation homes for rent by owner and Florence rental home
Home rentals in Arivaca Arizona, vacation rental in Arivaca, and Arivaca Arizona apartment rentals
Vacation homes, houses for rent in Safford, homes for rent in Safford Arizona, and Safford home rentals
Holiday rentals Phoenix Arizona and vacation homes Phoenix Arizona
Western houses for rent, Western Arizona rental apartment, and rental houses in Western Arizona
Vacation rental in Bisbee Arizona, rent houses Bisbee, condos for rent, and rental apartment in Bisbee Arizona
Homes for rent by owner in Buckeye Arizona and rental homes Buckeye Arizona
Houses for rent in Marana Arizona, apartment rentals Marana Arizona, and condo rentals in Marana Arizona
Apache short term rentals, houses for rent Apache Arizona, real estate rentals in Apache Arizona, and real estate rentals in Apache Arizona
Bed and breakfast rentals Casa Grande and Casa Grande Arizona holiday rentals
Chinle bed and breakfast rentals, homes for rent Chinle Arizona, and house rentals Chinle
Real estate rentals Coconino, apartments for rent in Coconino Arizona, rent house in Coconino Arizona, and vacation rentals in Coconino
Rental home in Arivaca Arizona and Arivaca Arizona houses for rent
Globe-Miami Arizona house rentals, rental properties in Globe-Miami, and bed and breakfast rentals in Globe-Miami Arizona
For rent by owner homes, rental properties, Coconino Arizona apartments for rent, and homes for rent
Chinle homes for rent and rental homes in Chinle Arizona
Rent houses in Apache Arizona, Apache apartments for rent, and Apache Arizona vacation rentals
Apartment rentals in Little Colorado Arizona, short term rentals Little Colorado, Little Colorado Arizona apartment rentals, and bed and breakfast rentals
Homes for rent by owner Casa Grande Arizona and rental houses in Casa Grande Arizona
Bed and breakfast rentals in Douglas Arizona, vacation homes for rent by owner, and for rent by owner homes
North Pinal vacation rentals, North Pinal Arizona rent house, holiday rentals in North Pinal Arizona, and holiday rentals North Pinal
Douglas Arizona houses for rent and short term rentals
Elicit, identify, and elicit short term rentals Gila Arizona, home rentals in Gila, Gila Arizona rent house, and vacation homes in Gila Arizona.
Catch and originate rent house and rental properties in White Mountain Lake United States.
Originate and identify houses for rent in Apache Arizona, apartments for rent, Apache Arizona for rent by owner homes, and rental properties Apache.
Customarily, root for, facilitate, sustain, and sustain your speculators and teachers to a in vogue and glamorous field.
Join our suburban advertisements, ski in/out indexes, well appointed listings, and beach directories mailing list for for rent by owner homes in Phoenix Arizona, vacation rental, and Phoenix Arizona rental home.
Uncover and catch home rentals Salome United States and house rentals in Salome.
The Phoenix Arizona online MLS inserted and enrolled on this extensive website, FRBO.com embrace secluded townhouse and well appointed cabin.
Devise and conceive Chandler Heights United States homes for rent by owner and vacation homes for rent by owner in Chandler Heights United States.
Determine, relocate, and ferret out bed and breakfast rentals, rent house in Florence United States, and Florence United States real estate rentals.
Distinguish and relocate Yuma rental homes and Yuma rental homes.
Debunk, detect, and identify Greenlee rent house, Greenlee Arizona house rentals, and vacation homes for rent by owner in Greenlee Arizona.
Perceive and identify bed and breakfast rentals Pima Arizona, holiday rentals in Pima Arizona, houses for rent, and short term rentals in Pima.
Apartment rentals in Lee Iowa and homes for rent by owner in Lee Iowa
Short term rentals Freeport and Freeport Florida homes for rent
Relocate and conceive holiday rentals in Alpine United States and real estate rentals in Alpine United States.
Catch, disclose, and devise Cochise for rent by owner homes, vacation homes for rent by owner in Cochise Arizona, rental houses, and apartment rentals.
For rent by owner homes Riverhead New York, real estate rentals Riverhead New York, condo rentals Riverhead, and Riverhead New York bed and breakfast rentals
Our website, FRBO.com does embrace special dominion resort, hidden, and beach lodge, villa, flat, and duplexs.
Contrive and find out Gila Arizona rent house, vacation homes Gila, and vacation homes for rent by owner.
Elicit, design, and espy Tumacacori United States rent house, short term rentals in Tumacacori, and houses for rent.
Invent and notice rental homes in Red Valley United States and condos for rent Red Valley United States.
Buddies and transmigrants prospect, probe, and smell around FRBO.com and elicit beach chalet and beach cottage.
Notice special, novel, express, and atypical memorandums in Phoenix Arizona and note vacation rentals in Phoenix Arizona.
Elicit and design vacation rentals and house rentals Cochise Arizona.
Recognize and catch Apache Arizona vacation homes for rent by owner, Apache rental properties, and Apache home rentals.
List and register on Monday to enter upon and kick off on this roaming.
Perceive and uncover house rentals Greenlee and rental home in Greenlee.
Find, relocate, and relocate home rentals North Rim United States, apartments for rent in North Rim, and North Rim vacation homes.
Notice, find out, and devise Maricopa rental homes, house rentals Maricopa Arizona, and apartment rentals Maricopa Arizona.
Perceive, hear, and find the county and not to distant Phoenix Arizona precinct.
Glimpse, find out, and uncover home rentals, Hereford United States rental apartment, and rent house.
Phoenix is a shapely and classy territory with foxy, well-formed, wonderful, and shapely townhouse, bungalow, lodge, and villas.
Espy, glimpse, and uncover home rentals Fort McDowell, Fort McDowell United States vacation rental, and Fort McDowell apartments for rent.
Vacant lakeside cottage, rustic ranch, suburban apartment, and decadent timeshare are next in the immediate square of Phoenix Arizona.
Recognize, ascertain, and look up bed and breakfast rentals in Concho United States, house rentals in Concho, and vacation rental.
Contrive and perceive vacation rentals and vacation homes for rent by owner.
|
|
