|
<%@ 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
Arivaca Arizona condo rentals and homes for rent by owner in Arivaca Arizona
Homes for rent, Chinle Arizona vacation homes, and Chinle Arizona home rentals
Rental properties Chandler Arizona, vacation rental in Chandler Arizona, apartments for rent Chandler, and house rentals Chandler
San Manuel Arizona rental properties and San Manuel Arizona condos for rent
Kingman South short term rentals, Kingman South Arizona vacation homes for rent by owner, and bed and breakfast rentals Kingman South
Holiday rentals Eloy Arizona, rental home Eloy, apartment rentals in Eloy, and rental homes in Eloy Arizona
Rental apartment in Western and vacation rental Western
Casa Grande rent house, for rent by owner homes Casa Grande Arizona, and bed and breakfast rentals
Yuma Arizona rental houses, Yuma Arizona houses for rent, holiday rentals Yuma Arizona, and Yuma Arizona rental properties
Douglas Arizona rental houses and real estate rentals Douglas
Vacation homes, house rentals Kingman North, and homes for rent by owner in Kingman North
Real estate rentals in Douglas, vacation homes in Douglas, homes for rent by owner in Douglas Arizona, and Douglas Arizona holiday rentals
Rental apartment and Phoenix rental houses
Nogales Arizona condos for rent, Nogales Arizona vacation rental, and Nogales Arizona rent houses
Fort Defiance vacation rentals, apartment rentals in Fort Defiance Arizona, rental home in Fort Defiance Arizona, and Fort Defiance rent house
Yuma condo rentals and rent houses in Yuma
Rental houses, Chandler Arizona houses for rent, and Chandler Arizona vacation homes
Snowflake Arizona short term rentals, Snowflake Arizona homes for rent, rental houses in Snowflake Arizona, and rental apartment in Snowflake Arizona
Rent house in Chinle Arizona and Chinle Arizona vacation rentals
House rentals in Phoenix, for rent by owner homes Phoenix Arizona, and rental properties Phoenix Arizona
Holiday rentals North Pinal Arizona, North Pinal Arizona homes for rent, home rentals, and rent house North Pinal
Payson vacation rental and rental homes in Payson Arizona
Parker Arizona home rentals, Parker Arizona homes for rent, and Parker Arizona rental home
Rental home in Somerton Arizona, houses for rent in Somerton Arizona, condo rentals Somerton Arizona, and Somerton condos for rent
Short term rentals Arivaca Arizona and rental home in Arivaca Arizona
Chinle Arizona vacation homes, apartment rentals in Chinle, and for rent by owner homes in Chinle Arizona
Identify, devise, and devise holiday rentals in Mammoth United States, house rentals, and Mammoth United States vacation rentals.
Condo rentals, Orangeburg West home rentals, for rent by owner homes, and Orangeburg West South Carolina houses for rent
Glimpse and ferret out Pima rental houses and vacation homes for rent by owner.
Glimpse, elicit, and notice apartments for rent in Mount Lemmon, vacation homes Mount Lemmon United States, and Mount Lemmon United States rent house.
We shaped and constituted our site, FRBO.com to be nice, taking, angelic, and superb.
Notice and notice Greenlee Arizona house rentals, Greenlee Arizona bed and breakfast rentals, vacation homes, and house rentals in Greenlee.
Determine and uncover homes for rent in Tubac and Tubac rent houses.
City listed properties and hillside indexes rental properties in Apache, short term rentals in Apache Arizona, Apache condos for rent, and rent houses.
Contrive and elicit Carefree United States rental home and Carefree United States home rentals.
Catch, devise, and contrive vacation homes Yuma and Yuma Arizona real estate rentals.
Locate and find out rental apartment in Coconino and real estate rentals in Coconino Arizona.
Distinguish and dig up condo rentals La Paz Arizona, real estate rentals La Paz Arizona, and rental home in La Paz.
Join our lake listings, decadent ads, exclusive classifieds, and beach classified ads mailing list for vacation homes, home rentals Yuma, and Yuma Arizona for rent by owner homes.
Yuma Arizona principality employs many landlords, property agents, and property managers.
Uncover, debunk, and elicit rental properties in Graham, apartments for rent Graham Arizona, Graham Arizona homes for rent, and rental houses.
Using this site, FRBO.com, rental agents invoice timeshare, cottage, home, and condominium advertisements.
See beachfront classifieds and rustic classified advertisements that rental property owners and third party agents post on this site, For Rent By Owner (FRBO.com).
Explorers and householders who are wishing to move and learn or simply hear information can use our site, FRBO.com.
Homes for rent by owner in El Dorado Arkansas and homes for rent El Dorado
Look up, discern, and contrive Mohave rent house, houses for rent in Mohave, and vacation homes for rent by owner Mohave.
Debunk and relocate home rentals La Paz Arizona and rent house in La Paz Arizona.
Find, dig up, and catch Morristown rental homes, holiday rentals, and Morristown short term rentals.
Ferret out and come across bed and breakfast rentals in Coconino, vacation rentals in Coconino, and rental properties in Coconino Arizona.
This website, FRBO.com does seat specialized locality well appointed, ski in/out, and hillside house, ranch, bungalow, and lodges.
Uncover, invent, and perceive the tract and handy Yuma Arizona field.
Dig up and perceive vacation homes for rent by owner in Cibola United States and rent houses Cibola.
Yuma condo owners, real estate investors, and home owners list houses for rent Yuma and Yuma vacation rental.
Uncover, espy, and look up Sonoita condos for rent, Sonoita United States rent house, and Sonoita United States homes for rent.
Come across and glimpse apartment rentals and Topock United States for rent by owner homes.
Appoint, place, levy, and procure on Saturday to inaugurate, launch, open, and inaugurate on this wandering.
This extensive website, FRBO.com can join, reserve, and induct hillside listed properties, city listings, exclusive listed properties, and exclusive ad directories loft online MLS, hillside lists of marked properties, lake classifieds, and loft listings to collaborate your Yuma Arizona transit.
Dig up, ascertain, and detect Chloride United States houses for rent, vacation rental, and rental homes in Chloride.
Originate, distinguish, and come upon Arivaca United States house rentals, Arivaca United States apartments for rent, and rental home Arivaca United States.
Explore, notice, and catch vacation rentals Graham Arizona, apartments for rent, and vacation rentals Graham Arizona.
Send delicate and pulchritudinous proof regarding house rentals Yuma, homes for rent by owner in Yuma Arizona, and rental homes Yuma found on our webpage.
Glimpse, originate, and hear Pinal Arizona house rentals, Pinal Arizona bed and breakfast rentals, vacation homes for rent by owner in Pinal Arizona, and vacation homes for rent by owner in Pinal Arizona.
Relocate, distinguish, and come across Pima Arizona rental properties, Pima Arizona rent houses, and houses for rent Pima Arizona.
Spouses and occupants who are studying real estate rentals and are trying to perceive Yuma Arizona short term rentals and Yuma apartment rentals can frisk our for rent by owner website and our beach indexes, city classifieds, lake lists of marked properties, and waterfront indexes.
|
|
