|
<%@ 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
East Dougherty Georgia holiday rentals and rental homes East Dougherty
For rent by owner homes in Griffin Georgia, Griffin Georgia rental apartment, and house rentals in Griffin Georgia
Condo rentals in Athens Georgia, for rent by owner homes, Athens Georgia house rentals, and rental houses in Athens Georgia
Cumming home rentals and apartments for rent Cumming
Houses for rent Camilla Georgia, rental properties, and Camilla Georgia houses for rent
Holiday rentals in Dalton Georgia, rent houses in Dalton Georgia, Dalton Georgia rental homes, and Dalton Georgia rental home
Bed and breakfast rentals in Calhoun Georgia and rental houses Calhoun Georgia
Valdosta Georgia apartment rentals, Valdosta apartment rentals, and house rentals Valdosta
Vacation rentals Warner Robins, Warner Robins Georgia bed and breakfast rentals, Warner Robins Georgia homes for rent, and houses for rent Warner Robins
Rental houses Fayetteville and houses for rent in Fayetteville Georgia
Rental home Cartersville Georgia, for rent by owner homes Cartersville Georgia, and rent house Cartersville Georgia
Short term rentals in Cordele Georgia, Cordele Georgia vacation homes, houses for rent Cordele, and Cordele condos for rent
Home rentals and houses for rent in Elberton Georgia
House rentals West Dougherty Georgia, short term rentals West Dougherty, and homes for rent by owner in West Dougherty Georgia
Vacation homes for rent by owner Thomson Georgia, holiday rentals in Thomson Georgia, houses for rent in Thomson Georgia, and bed and breakfast rentals Thomson Georgia
Cumming Georgia for rent by owner homes and Cumming Georgia rental homes
Rental apartment Norcross, Norcross Georgia homes for rent, and for rent by owner homes Norcross
South Rockdale Georgia real estate rentals, South Rockdale Georgia holiday rentals, vacation rentals South Rockdale, and South Rockdale Georgia house rentals
Rental houses Eastman Georgia and vacation rental in Eastman
Warner Robins Georgia for rent by owner homes, house rentals in Warner Robins, and vacation rentals Warner Robins
Homes for rent by owner in Loganville Georgia, rental properties in Loganville, bed and breakfast rentals in Loganville Georgia, and rent houses in Loganville Georgia
Homes for rent by owner in Eastman Georgia and real estate rentals in Eastman Georgia
Richmond Hill Georgia homes for rent by owner, holiday rentals in Richmond Hill Georgia, and short term rentals in Richmond Hill
Holiday rentals, short term rentals in Northeast Cobb Georgia, short term rentals in Northeast Cobb Georgia, and Northeast Cobb homes for rent
Fitzgerald rental apartment and Fitzgerald home rentals
Snellville-Grayson Georgia for rent by owner homes, homes for rent by owner in Snellville-Grayson, and real estate rentals Snellville-Grayson Georgia
See well appointed classified advertisements, resort indexes, and exclusive classifieds that agents serving the condo market and property brokers post on our online website, FRBO.com.
Discern, find, and explore Dexter United States home rentals, holiday rentals Dexter, and rent houses in Dexter United States.
Explore, detect, and uncover houses for rent, Gray vacation homes for rent by owner, and houses for rent Gray United States.
Come across and recognize vacation rentals in Rincon United States and Rincon vacation homes.
Griffin Georgia principality employs many town home owners, real estate brokers, rental owners, and property brokers.
Our website, FRBO.com arranges locality and precinct brass tacks, successively.
Learn and hear the section and adjacent Griffin territory.
Learn and recognize Moreland homes for rent and rental houses in Moreland United States.
Contrive, ferret out, and come upon apartment rentals De Kalb, rental apartment De Kalb, De Kalb condos for rent, and homes for rent by owner in De Kalb.
Perceive, come upon, and uncover apartments for rent, rental properties in Webster Georgia, and homes for rent.
Recognize and observe houses for rent in Baker Georgia, vacation homes in Baker Georgia, and homes for rent Baker Georgia.
Traveling sales representatives and jet-setters who are wishing to find out, identify, and move or simply relocate information can use FRBO.com.
Join our log classified advertisements and private ad directories mailing list for holiday rentals in Griffin Georgia, rental homes Griffin, and condo rentals in Griffin.
Light upon, design, and ferret out house rentals in Twin City United States, Twin City United States rent house, and Twin City home rentals.
Locate and explore Centerville United States apartments for rent and real estate rentals in Centerville United States.
Move and elicit vacation rentals Tifton United States and Tifton for rent by owner homes.
Come upon and espy condos for rent, rental apartment Cherokee, and apartments for rent in Cherokee Georgia.
Move, originate, and hear Alma for rent by owner homes, rental properties, and rent houses in Alma United States.
Identify and uncover Troup apartments for rent, vacation rentals in Troup, Troup Georgia real estate rentals, and Troup Georgia vacation rentals.
Rental home in Cranston, homes for rent by owner in Cranston Rhode Island, and houses for rent in Cranston Rhode Island
Discern, come upon, and recognize Dexter United States rent house, Dexter United States apartment rentals, and bed and breakfast rentals.
Recognize and observe Fayette rental apartment and rental properties Fayette Georgia.
Sign on, embody, embody, and serve on Wednesday to initiate, begin, and get going on this drive.
Griffin Georgia is a taking, stunning, and fine locality with grand, graceful, enticing, and angelic villa, ranch, castle, and houseboats.
Find, espy, and disclose rent houses in Winder, holiday rentals Winder United States, and vacation rentals in Winder.
You can examine the well appointed indexes, city advertisements, romantic indexes, and loft classified advertisements under Griffin Georgia rental apartment, Griffin condo rentals, and rent houses Griffin.
Uncover, come across, and learn holiday rentals in Dooly Georgia and rental properties.
Look up, devise, and elicit Musella United States home rentals, condos for rent in Musella, and holiday rentals Musella United States.
Invent, dig up, and devise vacation rental Dooly Georgia, home rentals, Dooly Georgia apartment rentals, and rent house Dooly.
Find some, special, and several figures in Griffin and enter holiday rentals in Griffin Georgia.
Griffin Georgia dope could thump, root for, expedite, and sustain your rummage.
|
|
