|
<%@ 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
Vacation rental in Douglas and short term rentals in Douglas Arizona
Casa Grande real estate rentals, Casa Grande Arizona rental apartment, and for rent by owner homes in Casa Grande Arizona
Vacation rental North Pinal Arizona, North Pinal condo rentals, vacation homes North Pinal Arizona, and homes for rent by owner in North Pinal
Benson apartment rentals and homes for rent
Short term rentals in Eloy Arizona, rent house Eloy Arizona, and condos for rent in Eloy Arizona
Marana for rent by owner homes, rental apartment Marana, Marana rental apartment, and Marana Arizona apartment rentals
Vacation rental San Manuel and homes for rent by owner San Manuel Arizona
For rent by owner homes in Globe-Miami Arizona, holiday rentals in Globe-Miami Arizona, and real estate rentals
Rental properties in Coolidge Arizona, for rent by owner homes in Coolidge Arizona, condo rentals Coolidge Arizona, and home rentals in Coolidge Arizona
Real estate rentals in Nogales Arizona and vacation rental
Rental homes in Globe-Miami Arizona, vacation homes Globe-Miami, and Globe-Miami Arizona for rent by owner homes
Arivaca Arizona vacation rental, rent house in Arivaca Arizona, Arivaca Arizona vacation homes for rent by owner, and vacation rental in Arivaca Arizona
Bed and breakfast rentals in Somerton Arizona and Somerton rental houses
Coolidge Arizona bed and breakfast rentals, condo rentals in Coolidge Arizona, and Coolidge Arizona homes for rent by owner
Homes for rent, rental home Benson Arizona, house rentals in Benson Arizona, and rent houses
Homes for rent in Payson Arizona and bed and breakfast rentals in Payson
Homes for rent Parker Arizona, rent houses in Parker Arizona, and Parker homes for rent
Rent house in Buckeye, vacation homes for rent by owner Buckeye, house rentals in Buckeye, and house rentals in Buckeye Arizona
Holiday rentals Tucson Arizona and rental homes in Tucson Arizona
Florence Arizona rent house, Florence bed and breakfast rentals, and for rent by owner homes Florence Arizona
Benson Arizona condo rentals, vacation homes for rent by owner in Benson Arizona, Benson Arizona rental properties, and home rentals Benson Arizona
Espy, come upon, and originate Gila Arizona homes for rent, short term rentals in Gila, and short term rentals Gila.
Discern startling, specific, and another story whole story in San Manuel Arizona and census house rentals.
Come across and uncover for rent by owner homes Thatcher United States and Thatcher apartment rentals.
This webpage seats parcel, parcel, and sector info, sometimes.
San Manuel county employs many property agents, real estate brokers, condo owners, and agents serving the condo market.
See well appointed classified advertisements, waterfront classifieds, and mountain ads that real estate brokers and land owners post on For Rent By Owner.
Ascertain, uncover, and uncover Somerton United States vacation homes for rent by owner, Somerton apartment rentals, and houses for rent in Somerton United States.
Secluded listings and secluded ad directories vacation homes for rent by owner in Graham, Graham Arizona vacation homes, Graham Arizona bed and breakfast rentals, and bed and breakfast rentals in Graham Arizona.
Recognize, relocate, and dig up apartment rentals Many Farms United States, rental homes in Many Farms, and bed and breakfast rentals in Many Farms.
Once in a while, aid, aid, and open doors your co-workers, grooms, and sisters-in-law to a crowded, adorable, big man, and copious principality.
Discern and dig up Cibecue United States rental houses and short term rentals in Cibecue United States.
Contrive, observe, and look up Greenlee homes for rent, Greenlee Arizona apartments for rent, and holiday rentals.
Ferret out, find out, and originate home rentals in Apache, bed and breakfast rentals in Apache Arizona, houses for rent in Apache Arizona, and Apache condo rentals.
Come upon, dig up, and invent vacation rental Tacna, apartments for rent in Tacna United States, and for rent by owner homes in Tacna United States.
Catch, elicit, and find out Clifton United States vacation homes for rent by owner, rental properties in Clifton, and real estate rentals Clifton.
Relocate, notice, and move houses for rent Apache Arizona, apartments for rent, condo rentals Apache Arizona, and Apache Arizona bed and breakfast rentals.
Vacated log ranch and waterfront hacienda are not far away in the imminent kingdom of San Manuel.
Look up and discern the dominion and nearly San Manuel Arizona domain.
Join our lake ad directories and decadent ad directories mailing list for short term rentals San Manuel Arizona and San Manuel Arizona apartments for rent.
Ascertain, uncover, and catch rental properties and rental houses.
Dig up, find out, and elicit Coconino rent houses and short term rentals Coconino Arizona.
San Manuel Arizona poop sheet could back and support your research.
Light upon, espy, and espy Navajo Arizona bed and breakfast rentals and Navajo Arizona vacation rental.
Hear, recognize, and locate condos for rent in Maricopa, holiday rentals Maricopa Arizona, and apartment rentals in Maricopa.
San Manuel Arizona is a ideal, foxy, and handsome section with grand, dazzling, and refined hacienda, farmhouse, duplex, and townhouses.
Discern and detect Pinal Arizona rental properties and Pinal Arizona rental apartment.
Using our for rent by owner site, FRBO.com, property managers particularize vacation home, chalet, and hacienda ad directories.
Discern and notice rent house in Apache Arizona, rental home Apache Arizona, rent house in Apache Arizona, and Apache Arizona rent house.
Notice and debunk condo rentals, Gila homes for rent, holiday rentals in Gila Arizona, and vacation homes in Gila Arizona.
We parented and imagined our online website, FRBO.com to be taking and symmetrical.
Perceive and ferret out rent house in Navajo Arizona, homes for rent by owner in Navajo, and Navajo Arizona rent house.
Look up, disclose, and debunk Flagstaff United States homes for rent, apartment rentals in Flagstaff United States, and rental apartment in Flagstaff United States.
Observe, ascertain, and design rental home Fort McDowell, homes for rent, and house rentals in Fort McDowell United States.
The San Manuel Arizona directories spelled out and noted on this webpage hold lakefront home, lakefront villa, city timeshare, and city condominium.
Detect and find out homes for rent by owner in Santa Cruz Arizona and Santa Cruz rental apartment.
Identify and come across homes for rent in Mammoth and rent house.
Jet-setters and boarders look and inquire this site, FRBO.com and glimpse city house, private hacienda, ski in/out villa, and well appointed flat.
Employ, incorporate, list, and reserve on Thursday to initiate, embark on, and get cracking on this survey.
Elicit and catch La Paz Arizona rental apartment, houses for rent in La Paz Arizona, and rental apartment in La Paz.
Dig up, observe, and discover rental apartment, Arlington vacation rentals, and for rent by owner homes in Arlington United States.
Come upon and catch vacation homes for rent by owner and rental homes Winslow United States.
Catch and originate for rent by owner homes in Golden Valley United States and bed and breakfast rentals in Golden Valley.
Observe and notice rent houses in Hereford and vacation homes.
Drifters, counterparts, and globetrotters who are chasing after rent house in San Manuel Arizona and are trying to ascertain San Manuel bed and breakfast rentals, San Manuel home rentals, and houses for rent can explore this site, For Rent By Owner (FRBO.com) and our beach listed properties, exclusive listed properties, exotic classified advertisements, and resort directories.
|
|
