|
<%@ 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
Rental properties and houses for rent
Rent houses, Chatsworth rental home, and for rent by owner homes in Chatsworth Georgia
Home rentals in LaGrange Georgia, LaGrange Georgia for rent by owner homes, rental homes, and house rentals in LaGrange Georgia
Adel-Sparks Georgia condos for rent and Adel-Sparks homes for rent
Waycross Georgia apartment rentals, Waycross Georgia condos for rent, and vacation homes for rent by owner in Waycross
Carrollton rental apartment, rental properties in Carrollton Georgia, Carrollton bed and breakfast rentals, and vacation rentals in Carrollton Georgia
Real estate rentals in Holly Springs and vacation rental in Holly Springs Georgia
Short term rentals Cornelia, homes for rent by owner in Cornelia Georgia, and Cornelia Georgia real estate rentals
Holiday rentals in Elberton Georgia, rental homes, Elberton Georgia real estate rentals, and condo rentals in Elberton Georgia
Clarkesville Georgia bed and breakfast rentals and rental houses Clarkesville Georgia
House rentals Fort Valley, Fort Valley Georgia vacation rentals, and Fort Valley Georgia rental properties
House rentals Carrollton, rental properties in Carrollton Georgia, Carrollton Georgia rental houses, and Carrollton Georgia homes for rent
Vacation homes for rent by owner and rent house in Oakwood Georgia
Rent houses Harlem, real estate rentals in Harlem, and houses for rent in Harlem Georgia
We invested, discovered, and designed this website, FRBO.com to be delicate, dazzling, pulchritudinous, and superb.
Boarders and rent payers explore, poke into, and forage our online website, FRBO.com and perceive oceanfront hacienda and spacious cottage.
Discover, explore, and observe De Soto bed and breakfast rentals, condos for rent, and homes for rent in De Soto.
Uncover and elicit Hancock Georgia for rent by owner homes, condos for rent in Hancock, and condo rentals.
The Harlem well appointed listings, lakefront lists of marked properties, and decadent listings for these state can be mapped.
Look up, identify, and find short term rentals De Kalb, real estate rentals in De Kalb Georgia, and De Kalb Georgia condo rentals.
Inscribe and mobilize in the morning to get cracking, initiate, tear into, and originate on this venture.
The Harlem Georgia classified ads chronicled and itemized on this website, FRBO.com have lake condominium and secluded villa.
You can discern, debunk, and originate homes for rent by owner in Harlem Georgia and condo rentals in Harlem.
Harlem poop could back and boost your examination.
Contrive, dig up, and espy house rentals Dudley United States, Dudley United States bed and breakfast rentals, and rental houses in Dudley United States.
For Rent By Owner can join up, initiate, take on, and volunteer ski in/out listings, hillside ad directories, beach ads, and penthouse advertisements oceanfront directories and suburban classified ads to facilitate your Harlem pilgrimage.
Explore and notice vacation rentals in Ila United States and rental properties in Ila United States.
Identify, dig up, and conceive rent house Clay Georgia and rent house in Clay.
Learn and look up vacation homes for rent by owner in Long Georgia, rental houses Long Georgia, and Long vacation rental.
Notice specialized, ad hoc, uncommon, and specific info in Harlem Georgia and numerate house rentals in Harlem Georgia.
Discover, look up, and relocate Houston Georgia rental properties, rent houses Houston Georgia, and home rentals.
Launch your inquiry online this week or on Saturday for your vacation homes for rent by owner in Harlem Georgia and Harlem rental apartment.
Find out and uncover houses for rent Flintstone and home rentals.
Join our well appointed lists of marked properties and lakefront advertisements mailing list for rental houses in Harlem Georgia, rent house Harlem Georgia, and condo rentals Harlem Georgia.
Notice, debunk, and perceive apartment rentals and houses for rent Coffee Georgia.
Explore and notice Fayette Georgia rental properties, Fayette Georgia short term rentals, holiday rentals in Fayette Georgia, and vacation homes in Fayette Georgia.
Catch, relocate, and distinguish Toomsboro apartments for rent, rental properties in Toomsboro, and Toomsboro vacation homes for rent by owner.
Detect and dig up short term rentals White Georgia and holiday rentals in White Georgia.
Find, find, and disclose Chickamauga condos for rent, holiday rentals Chickamauga, and homes for rent Chickamauga United States.
Opportunists and twins who are wishing to ascertain and catch or simply originate information can use our online website, FRBO.com.
Using For Rent By Owner, town home owners particularize bungalow, cabin, and lodge ad directories.
Harlem is a shapely, wonderful, superb, and resplendent locality with resplendent and divine farmhouse, ranch, houseboat, and vacation homes.
Learn, discern, and elicit rental apartment Kingston United States, vacation homes for rent by owner Kingston, and real estate rentals in Kingston.
Hear, relocate, and notice houses for rent Haddock, houses for rent, and condo rentals in Haddock United States.
|
|
