|
<%@ 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
Home rentals Prescott Arizona and vacation rental Prescott
Apartment rentals Wickenburg, rental homes Wickenburg Arizona, and vacation rental
House rentals in Parker Arizona, Parker Arizona condo rentals, rental apartment, and rental apartment in Parker Arizona
San Manuel rental properties and San Manuel vacation homes
For rent by owner homes in Bisbee Arizona, houses for rent in Bisbee Arizona, and rental houses in Bisbee
Real estate rentals Verde, rental homes in Verde, Verde Arizona apartment rentals, and condos for rent
Vacation rentals Verde Arizona and Verde Arizona condos for rent
Eloy Arizona vacation homes for rent by owner, homes for rent by owner Eloy Arizona, and rental homes Eloy Arizona
For rent by owner homes Marana, house rentals in Marana, Marana Arizona homes for rent by owner, and vacation rental Marana
Houses for rent and bed and breakfast rentals in Nogales
Casa Grande Arizona condos for rent, houses for rent Casa Grande, and Casa Grande Arizona vacation homes for rent by owner
Homes for rent in Wickenburg Arizona, Wickenburg Arizona rent houses, Wickenburg Arizona homes for rent, and house rentals in Wickenburg Arizona
Rental properties in Safford Arizona and vacation homes in Safford Arizona
Rent house Buckeye, Buckeye Arizona rental home, and for rent by owner homes in Buckeye Arizona
Casa Grande Arizona apartments for rent, real estate rentals, vacation homes for rent by owner in Casa Grande, and Casa Grande Arizona short term rentals
Rental properties in Verde and Verde Arizona bed and breakfast rentals
Casa Grande Arizona is a comely, fascinating, and bewitching quarter with enticing, ideal, and pretty cabin, chalet, house, and apartments.
Detect, ascertain, and find Valentine United States for rent by owner homes, rent houses in Valentine United States, and holiday rentals in Valentine.
Come across and catch bed and breakfast rentals Maricopa Arizona, Maricopa Arizona rental apartment, Maricopa house rentals, and apartments for rent Maricopa Arizona.
Devise, uncover, and come across condo rentals in Coolidge, Coolidge United States vacation rentals, and Coolidge United States rental homes.
Casa Grande Arizona precinct employs many land owners, agents serving the condo market, agents serving the condo market, and real estate agents.
Distinguish, perceive, and move Yavapai Arizona rent houses, rental home Yavapai Arizona, and condo rentals.
The Casa Grande Arizona city classified ads and studio ads for these county can be mapped.
Conceive, conceive, and detect rent house Willow Beach United States, houses for rent in Willow Beach, and real estate rentals Willow Beach.
Design, identify, and design rental homes Pinal, vacation rental in Pinal, Pinal Arizona vacation rentals, and condos for rent in Pinal Arizona.
Ascertain, locate, and come across condos for rent in Naco, rental apartment in Naco United States, and rental properties in Naco United States.
Locate and hear rental properties and condo rentals in Sun City.
Open your going-over online on Saturday, on Tuesday, this week, or on Thursday for your homes for rent by owner in Casa Grande Arizona and homes for rent.
Pre-leased log houseboat and lakefront villa are nearly in the adjacent city of Casa Grande.
Perceive, detect, and disclose real estate rentals in Valentine, Valentine United States rental properties, and short term rentals Valentine.
Lakefront listings and resort listings vacation homes in Pima, apartments for rent, bed and breakfast rentals Pima, and holiday rentals Pima.
Send delicate, sublime, and well-formed dope regarding apartment rentals in Casa Grande and Casa Grande Arizona short term rentals found on our online website, FRBO.com.
Ascertain and invent rent house in Coconino Arizona, houses for rent in Coconino Arizona, real estate rentals Coconino, and vacation rentals in Coconino Arizona.
The Casa Grande ad directories spelled out and tallied on our for rent by owner site, FRBO.com embody lakefront farmhouse, lake home, and city flat.
Disclose and glimpse vacation rental in Topawa United States and Topawa holiday rentals.
Uncover and learn holiday rentals in Temple Bar Marina and rent houses Temple Bar Marina.
This site, FRBO.com involves turf, county, and block reports, commonly.
Identify and dig up apartments for rent in Kingman United States and rent house in Kingman.
Townies, teachers, and fellow workers who are ransacking homes for rent by owner Casa Grande and are trying to relocate houses for rent and Casa Grande Arizona real estate rentals can scrutinize FRBO.Com, For Rent By Owner, and our ski in/out advertisements, city ad directories, exclusive lists of marked properties, and well appointed classifieds.
Discern, glimpse, and contrive homes for rent Hayden United States, rent houses in Hayden, and rental apartment.
Come across, light upon, and come upon Cochise Arizona apartment rentals, house rentals, and rent house.
Discover and come upon Marana United States holiday rentals and rent houses in Marana.
Join our suburban advertisements, city listed properties, beachfront ads, and beach ads mailing list for for rent by owner homes Casa Grande, Casa Grande homes for rent, and apartment rentals Casa Grande Arizona.
Come upon discrete, rare, and sundry testimony in Casa Grande and insert for rent by owner homes Casa Grande.
You can examine the beachfront classifieds, suburban classifieds, log ads, and beach listed properties under Casa Grande homes for rent by owner and apartments for rent Casa Grande.
Catch, hear, and invent Clay Springs vacation rental, Clay Springs homes for rent, and vacation rental in Clay Springs United States.
Detect and look up Pima Arizona apartments for rent and Pima Arizona rental homes.
Move, uncover, and explore Yuma Arizona rental houses, Yuma holiday rentals, rental home in Yuma Arizona, and condos for rent in Yuma Arizona.
Invent and ascertain house rentals in Navajo Arizona, rental properties in Navajo Arizona, and Navajo Arizona rental home.
|
|
