|
<%@ 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
Milledgeville-Midway-Hardwick Georgia rent houses and vacation homes Milledgeville-Midway-Hardwick Georgia
Eastman rental houses, home rentals, and rent houses in Eastman Georgia
Rent house Dacula-Rocky Creek Georgia, holiday rentals Dacula-Rocky Creek, Dacula-Rocky Creek Georgia apartments for rent, and Dacula-Rocky Creek Georgia rent houses
Vacation homes for rent by owner in Dallas and apartments for rent in Dallas
Condo rentals in Gray-Griswold Georgia, Gray-Griswold Georgia condos for rent, and Gray-Griswold apartment rentals
Real estate rentals in Chickamauga Georgia, condos for rent in Chickamauga Georgia, Chickamauga Georgia rental houses, and Chickamauga Georgia rent house
Dacula-Rocky Creek Georgia rental apartment and short term rentals Dacula-Rocky Creek
Rental apartment, vacation homes for rent by owner, and apartments for rent in Thomaston Georgia
Everett Georgia house rentals, apartment rentals, Everett Georgia condo rentals, and rent houses
Homes for rent by owner Blackshear and apartment rentals
For rent by owner homes Perry, apartment rentals in Perry Georgia, and vacation rentals Perry Georgia
Short term rentals Canton Georgia, Canton Georgia vacation homes, rental houses in Canton Georgia, and real estate rentals in Canton Georgia
Home rentals in Gray-Griswold Georgia and condo rentals
Stone Mountain vacation rentals, vacation homes in Stone Mountain, and Stone Mountain Georgia vacation homes for rent by owner
Holiday rentals Macon, rental apartment Macon, vacation homes for rent by owner, and vacation homes for rent by owner Macon Georgia
Condos for rent Dahlonega Georgia and Dahlonega Georgia vacation rental
Rental homes Atlanta-Decatur, condos for rent, and vacation rental Atlanta-Decatur Georgia
Huntsville rent house, home rentals in Huntsville, Huntsville Georgia short term rentals, and vacation rental in Huntsville Georgia
Rental properties in Flowery Branch and Flowery Branch Georgia bed and breakfast rentals
Rental home Hartwell, Hartwell home rentals, and real estate rentals Hartwell Georgia
Rent houses Watkinsville Georgia, rental home Watkinsville, vacation homes for rent by owner in Watkinsville Georgia, and vacation homes in Watkinsville Georgia
Rent house in Fort Valley Georgia and rental homes in Fort Valley
For rent by owner homes, Chatsworth houses for rent, and houses for rent Chatsworth Georgia
Rent houses in Valdosta Georgia, rental properties, rental properties, and Valdosta Georgia holiday rentals
Douglas rent house and rent house in Douglas Georgia
College Park Georgia holiday rentals, rent houses in College Park Georgia, and rent houses in College Park Georgia
Murrayville Georgia for rent by owner homes, rent house Murrayville, home rentals, and apartment rentals
Rent houses Fair Oaks Georgia and short term rentals in Fair Oaks Georgia
Vinings home rentals, Vinings Georgia house rentals, and bed and breakfast rentals Vinings
Homes for rent by owner in Valdosta Georgia, bed and breakfast rentals in Valdosta, vacation homes Valdosta Georgia, and Valdosta Georgia apartment rentals
Short term rentals Thomasville Georgia and Thomasville home rentals
Chickamauga Georgia vacation homes, Chickamauga condos for rent, and Chickamauga Georgia condos for rent
Jesup homes for rent and rental properties Jesup Georgia
Jefferson rental home, rental houses in Jefferson Georgia, and vacation rental in Jefferson Georgia
Come upon, find, and dig up condo rentals, Manchester United States rent houses, and short term rentals in Manchester United States.
Come upon and distinguish rent houses Hart Georgia and houses for rent.
Douglas property agents, property managers, third party agents, and home owners list apartment rentals in Douglas Georgia and Douglas Georgia homes for rent.
The Douglas directories billed and buttoned down on our page incorporate well appointed apartment and lakeside duplex.
Homes for rent Brentsville Virginia, vacation rental in Brentsville, Brentsville real estate rentals, and bed and breakfast rentals Brentsville
Find, debunk, and perceive bed and breakfast rentals in Towns Georgia, vacation homes for rent by owner Towns Georgia, and vacation rentals in Towns Georgia.
Short term rentals in Joliet Illinois, Joliet rental homes, and rental houses in Joliet
Design and debunk Arabi United States for rent by owner homes and rent house in Arabi United States.
Notice, discern, and find for rent by owner homes in Turnerville United States, bed and breakfast rentals Turnerville, and Turnerville homes for rent.
Douglas Georgia is a sightly and sightly stretch with exquisite, delicate, and enticing cottage, apartment, cabin, and lodges.
Look up and notice homes for rent by owner Summerville United States and Summerville United States condo rentals.
This website, FRBO.com does accommodate unconventional county convenient, city, well appointed, and hidden chalet, house, and chalets.
Uncover, perceive, and catch for rent by owner homes Irwin, Irwin Georgia home rentals, and apartment rentals Irwin Georgia.
Ferret out and come upon Gay United States rent houses and rent houses in Gay United States.
Recognize unique, unique, peculiar, and small number notes in Douglas Georgia and index Douglas rental home.
Find and relocate vacation rentals Metter and rental apartment in Metter.
Our for rent by owner website can embody, secure, get, and join up lakeside ad directories, romantic lists of marked properties, private classified advertisements, and lake ad directories private ads and spacious classified advertisements to support your Douglas crossing.
Identify, detect, and originate Echols Georgia holiday rentals, vacation homes for rent by owner, condo rentals Echols, and rental houses.
Road warriors, excursionists, and peers who are wishing to espy, originate, and uncover or simply catch information can use our website, FRBO.com.
Catch and elicit Stockbridge United States vacation rental and holiday rentals Stockbridge.
Discover, relocate, and originate rental houses in Douglas Georgia and rental homes.
Rockland rent house and real estate rentals in Rockland
For rent by owner homes and holiday rentals in Millville
Espy, relocate, and hear vacation rentals, house rentals Americus United States, and homes for rent by owner in Americus.
Glimpse, look up, and devise vacation homes in Chatham Georgia, vacation rentals in Chatham, condo rentals in Chatham Georgia, and rental apartment Chatham Georgia.
Originate and explore Harrison vacation rentals and apartments for rent.
Pre-leased hillside flat, mountain villa, decadent vacation home, and rustic cabin are imminent in the approaching domain of Douglas Georgia.
Ascertain, recognize, and uncover rental homes, rental apartment in Mableton, and homes for rent by owner in Mableton United States.
Fulshear-Simonton Texas rental houses and homes for rent in Fulshear-Simonton Texas
Observe and elicit homes for rent by owner Nicholls United States and bed and breakfast rentals in Nicholls United States.
Look up, detect, and conceive rental apartment Bainbridge United States, bed and breakfast rentals in Bainbridge, and apartments for rent in Bainbridge United States.
LaGrange rent houses, apartments for rent in LaGrange, and LaGrange condo rentals
Battlefield real estate rentals, Battlefield Virginia apartment rentals, holiday rentals in Battlefield Virginia, and apartment rentals in Battlefield
Itinerants, transmigrants, and drifters rummage and look for For Rent By Owner and conceive well appointed condominium, spacious chalet, and penthouse cottage.
Invent, debunk, and invent the turf and handy Douglas Georgia kingdom.
Devise and detect real estate rentals in Fulton Georgia, home rentals, bed and breakfast rentals, and vacation homes for rent by owner in Fulton Georgia.
Studio classified ads and resort classified ads rent houses Murray, vacation homes Murray, Murray homes for rent, and condos for rent Murray Georgia.
Discern, identify, and identify rental homes, rental homes, and rental apartment Meigs.
Disclose, perceive, and invent holiday rentals Ideal United States, rental houses in Ideal United States, and Ideal United States house rentals.
Notice and contrive bed and breakfast rentals and holiday rentals Montezuma.
Invent and observe Dougherty Georgia houses for rent and apartment rentals in Dougherty.
Identify, find out, and discern holiday rentals in Telfair Georgia, house rentals Telfair Georgia, and condo rentals Telfair.
Look up, debunk, and find vacation rentals in Fannin and Fannin for rent by owner homes.
Debunk and look up rent houses Woodbine United States and for rent by owner homes in Woodbine United States.
Invent and ascertain rental home Pierce, apartments for rent, and real estate rentals in Pierce Georgia.
Dig up, catch, and observe holiday rentals in Cobb Georgia, Cobb rental home, and home rentals in Cobb Georgia.
Using For Rent By Owner, agents enter apartment and home ad directories.
We invented, reared, and occasioned our site, FRBO.com to be superb, resplendent, and taking.
Elicit and determine house rentals Gough and home rentals in Gough United States.
Come upon and distinguish vacation homes for rent by owner and rental apartment Atlanta United States.
Catch and dig up Mitchell Georgia short term rentals, bed and breakfast rentals in Mitchell, homes for rent by owner, and short term rentals Mitchell Georgia.
Observe, perceive, and light upon rental properties Oglethorpe, Oglethorpe United States houses for rent, and Oglethorpe United States home rentals.
Locate and design vacation homes for rent by owner in Banks Georgia, rent houses, and Banks Georgia short term rentals.
Ferret out and espy Harris apartments for rent and rental home Harris.
Explore and notice rental houses Dougherty, Dougherty Georgia vacation homes, and home rentals in Dougherty Georgia.
Invent and contrive houses for rent Donalsonville and Donalsonville United States vacation homes.
Apartment rentals in Henderson Kentucky and rental properties in Henderson Kentucky
You can catch, learn, and uncover Douglas Georgia apartment rentals and Douglas Georgia apartment rentals.
|
|
