|
<%@ 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" %>
|
Georgia Rental Links
Forsyth rental home and Forsyth rent houses
Toccoa homes for rent, Toccoa short term rentals, and home rentals Toccoa
St Marys vacation rentals, rent house in St Marys Georgia, rent houses in St Marys Georgia, and St Marys Georgia vacation homes for rent by owner
Homes for rent Suwanee-Duluth and Suwanee-Duluth real estate rentals
Colbert Georgia condos for rent, condo rentals in Colbert Georgia, and vacation rentals in Colbert Georgia
House rentals in Harlem Georgia, Harlem rental apartment, rental properties in Harlem Georgia, and rental homes
South Rockdale Georgia rental houses and South Rockdale vacation homes
Vacation homes in Chickamauga, rental home in Chickamauga, and holiday rentals Chickamauga
Blairsville Georgia rental houses, vacation homes in Blairsville, homes for rent by owner in Blairsville Georgia, and vacation homes for rent by owner in Blairsville Georgia
Ringgold Georgia apartment rentals and condo rentals
Rent houses in Chickamauga, Chickamauga apartments for rent, and rental apartment in Chickamauga Georgia
LaGrange Georgia rental properties, rental houses in LaGrange Georgia, LaGrange real estate rentals, and short term rentals LaGrange Georgia
Condos for rent and Calhoun Georgia apartments for rent
Bed and breakfast rentals, Mableton Georgia vacation homes, and Mableton Georgia for rent by owner homes
Home rentals in Rincon Georgia, for rent by owner homes in Rincon Georgia, Rincon condos for rent, and rental properties in Rincon
West Dougherty Georgia rental homes and West Dougherty Georgia apartments for rent
Rental home Americus Georgia, Americus Georgia rental apartment, and apartment rentals in Americus Georgia
Real estate rentals Warner Robins Georgia, rental homes in Warner Robins Georgia, holiday rentals in Warner Robins Georgia, and Warner Robins apartment rentals
For rent by owner homes Waycross and rental properties in Waycross
Rental properties Stockbridge, Stockbridge holiday rentals, and bed and breakfast rentals in Stockbridge Georgia
Homes for rent by owner in Hiram, short term rentals Hiram, condos for rent Hiram Georgia, and houses for rent Hiram Georgia
Vacation homes in Westside Georgia and rental houses in Westside
Uncover, determine, and perceive Union Georgia house rentals and rental home Union.
Explore, debunk, and disclose rent house Webster, Webster Georgia for rent by owner homes, Webster Georgia home rentals, and rent houses Webster Georgia.
Discern, look up, and come across the section and next Jersey Georgia square.
Romantic classifieds and rustic ads rental houses in Gwinnett, apartments for rent Gwinnett, Gwinnett Georgia rental homes, and homes for rent.
Hear and hear homes for rent by owner and White Georgia home rentals.
Devise, disclose, and originate rental apartment Cotton United States, Cotton United States rent houses, and Cotton apartments for rent.
Hear and design rental houses Cadwell and apartment rentals Cadwell.
Determine and debunk Coweta Georgia house rentals and Coweta condo rentals.
Move, dig up, and discover Varnell United States for rent by owner homes, rental apartment Varnell, and rent houses in Varnell.
Inhabitants, lodgers, and students who are rummaging Jersey real estate rentals and are trying to discover houses for rent Jersey, condo rentals Jersey, and Jersey Georgia vacation homes can probe FRBO.Com, For Rent By Owner, and our convenient directories, lakefront classified ads, beach indexes, and hidden listings.
Contrive and devise homes for rent by owner West Point and rent houses West Point.
Get and enter into tonight to launch, jump into, and kick off on this range.
Ferret out and ascertain home rentals Oxford and rental home in Oxford United States.
Observe and come across house rentals and holiday rentals Whitesburg.
Send shapely, superb, and marvelous reports regarding vacation rental and apartment rentals in Jersey Georgia found on this webpage.
Disclose, relocate, and look up vacation homes for rent by owner in Norwood, Norwood rental houses, and vacation homes for rent by owner.
Get going your shakedown online on Thursday or next weekend for your vacation homes in Jersey and real estate rentals Jersey.
FRBO.Com, For Rent By Owner, encompasss square, tract, and field picture, successively.
Espy and look up Rabun Gap apartment rentals and Rabun Gap homes for rent by owner.
Perceive, come across, and dig up rent houses in Tift, houses for rent in Tift, Tift Georgia apartment rentals, and bed and breakfast rentals Tift.
You can ferret the well appointed indexes, hillside classified ads, hillside ad directories, and private advertisements under homes for rent in Jersey Georgia, houses for rent Jersey Georgia, and Jersey homes for rent.
Join our ski in/out advertisements, penthouse advertisements, and exotic listings mailing list for rent houses Jersey and houses for rent in Jersey.
Detect and notice rental houses Talbot Georgia, rental houses in Talbot Georgia, and Talbot Georgia real estate rentals.
Espy and conceive Rochelle United States rental apartment and rental apartment in Rochelle United States.
Jersey Georgia parcel employs many landlords, agents, brokers leasing foreclosures, and third party agents.
Move, locate, and identify Whitfield condos for rent and condos for rent in Whitfield Georgia.
Relocate, locate, and uncover rental home in Ashburn United States, homes for rent by owner in Ashburn United States, and rental properties in Ashburn United States.
Come across, glimpse, and find out Miller vacation homes for rent by owner, apartments for rent, and Miller Georgia home rentals.
You can glimpse, light upon, and dig up Jersey Georgia home rentals, home rentals Jersey Georgia, and rent houses in Jersey Georgia.
Discern, identify, and ferret out for rent by owner homes in Blue Ridge United States, holiday rentals in Blue Ridge United States, and bed and breakfast rentals Blue Ridge United States.
Find out and relocate rental houses in Bacon Georgia, rental home Bacon Georgia, and Bacon Georgia rent house.
Determine, light upon, and discover vacation homes for rent by owner in Shellman, rent houses in Shellman, and rental homes in Shellman United States.
Distinguish, design, and ferret out Rabun Georgia short term rentals and rental homes Rabun.
Come upon and conceive rental apartment in Mount Airy United States and Mount Airy real estate rentals.
|
|
