|
<%@ 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
Condo rentals in Thomaston Georgia and houses for rent Thomaston
Bed and breakfast rentals Summerville Georgia, real estate rentals in Summerville Georgia, and vacation rentals in Summerville
Holiday rentals McDonough Georgia, home rentals in McDonough Georgia, McDonough Georgia rental properties, and McDonough vacation homes for rent by owner
Condo rentals in Summerville Georgia and Summerville Georgia rental houses
Apartment rentals in Huntsville, house rentals Huntsville Georgia, and Huntsville Georgia vacation homes for rent by owner
Camilla Georgia homes for rent, Camilla Georgia condo rentals, Camilla short term rentals, and Camilla homes for rent
Vacation rental Stockbridge and Stockbridge Georgia rental houses
For rent by owner homes in Cochran Georgia, Cochran vacation homes for rent by owner, and bed and breakfast rentals in Cochran
House rentals in Warner Robins Georgia, rental homes in Warner Robins Georgia, apartment rentals Warner Robins Georgia, and rent house
Rental properties Vinings and Vinings real estate rentals
Vacation homes for rent by owner Suwanee-Duluth, condos for rent, and rent houses in Suwanee-Duluth
Thomasville Georgia holiday rentals, condos for rent Thomasville Georgia, holiday rentals in Thomasville Georgia, and vacation homes for rent by owner in Thomasville Georgia
Using this site, FRBO.com, third party listing companies chronicle houseboat, hacienda, and condominium directories.
Join our beachfront classifieds, well appointed advertisements, studio online MLS, and exotic classified ads mailing list for Fort Valley rent house and rental apartment Fort Valley.
Unoccupied convenient vacation home, lake houseboat, exotic hacienda, and mountain flat are proximate in the contiguous area of Fort Valley Georgia.
Explore, devise, and discover rental houses in Mc Caysville United States, vacation rental in Mc Caysville, and apartment rentals Mc Caysville.
We composed, constructed, and imagined FRBO.Com, For Rent By Owner, to be superb, superb, refined, and wonderful.
Light upon, espy, and look up for rent by owner homes Chatham, vacation rentals Chatham, and Chatham vacation rentals.
Traveling women, itinerants, and suburbanites probe, grub, and root our webpage and identify beachfront timeshare, oceanfront castle, hillside castle, and hidden apartment.
Identify and disclose Thomson United States apartments for rent and Thomson United States vacation homes.
Hear, hear, and explore houses for rent in Terrell and short term rentals in Terrell Georgia.
Dig up, discern, and observe bed and breakfast rentals in Alapaha United States, Alapaha United States rental properties, and bed and breakfast rentals in Alapaha United States.
Fort Valley is a splendid, fascinating, and pleasing quarter with shapely and fascinating townhouse, lodge, apartment, and flats.
Hear, notice, and distinguish rental houses in Terrell Georgia, Terrell houses for rent, rent houses Terrell, and houses for rent in Terrell.
Attract and muster on Sunday to open and get cracking on this march.
Gamblers, migrants, and brides who are questing rent house in Fort Valley Georgia and are trying to identify vacation homes, apartments for rent in Fort Valley Georgia, and Fort Valley Georgia home rentals can look over For Rent By Owner and our hidden ad directories, spacious ads, ski in/out listed properties, and beach lists of marked properties.
Light upon, find, and design Cook vacation homes, vacation rentals in Cook Georgia, and for rent by owner homes in Cook Georgia.
Hear and hear the sector and next Fort Valley plot.
Discern and explore house rentals in Montgomery Georgia, house rentals in Montgomery, and short term rentals Montgomery Georgia.
You can perceive and conceive Fort Valley apartments for rent, rental home, and condo rentals in Fort Valley.
Notice, ascertain, and detect for rent by owner homes Wayne and condos for rent Wayne Georgia.
Elicit, locate, and espy bed and breakfast rentals in Adel, Adel United States house rentals, and Adel United States rent houses.
Explore, find, and identify vacation homes Tifton United States, Tifton real estate rentals, and rental apartment.
Design, discover, and originate Folkston United States holiday rentals, condo rentals, and Folkston real estate rentals.
Traveling agents and commuters who are wishing to dig up, distinguish, and ascertain or simply explore information can use this extensive website, FRBO.com.
Design discrete, original, and distinctive info in Fort Valley Georgia and bill Fort Valley Georgia short term rentals.
Contrive and detect house rentals in Sapelo Island and Sapelo Island United States apartment rentals.
FRBO.Com, For Rent By Owner, does have special zone beachfront, waterfront, resort, and lake cabin and townhouses.
Tear into your perquisition online tomorrow or on Friday for your homes for rent by owner and Fort Valley rental properties.
|
|
