|
<%@ 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
Bremen Georgia vacation homes for rent by owner and Bremen Georgia condos for rent
Rent houses in Fairburn-Union City Georgia, rental properties, and for rent by owner homes Fairburn-Union City Georgia
Houses for rent in Rutland, rental homes Rutland Georgia, homes for rent by owner in Rutland Georgia, and home rentals Rutland
Fair Oaks Georgia apartment rentals and vacation rentals
Vacation homes for rent by owner Acworth-Kennesaw, home rentals, and Acworth-Kennesaw Georgia houses for rent
Short term rentals Jersey, rent house Jersey Georgia, rental home, and homes for rent
Condo rentals College Park and College Park homes for rent by owner
Apartments for rent in Forsyth Georgia, rental apartment Forsyth, and home rentals Forsyth
Rent houses, bed and breakfast rentals Lilburn Georgia, vacation homes Lilburn Georgia, and rental homes in Lilburn Georgia
Camilla Georgia rental apartment and condos for rent Camilla Georgia
Jersey homes for rent, Jersey condos for rent, and Jersey condos for rent
Rental apartment in Toccoa Georgia, rental properties Toccoa Georgia, Toccoa Georgia vacation homes for rent by owner, and vacation homes in Toccoa
Apartments for rent in Gainesville Georgia and condo rentals
Bed and breakfast rentals Thomasville, Thomasville Georgia vacation homes, and bed and breakfast rentals Thomasville Georgia
House rentals in Fort Oglethorpe-Lakeview, Fort Oglethorpe-Lakeview houses for rent, Fort Oglethorpe-Lakeview homes for rent, and vacation homes for rent by owner Fort Oglethorpe-Lakeview Georgia
Rental properties Canton Georgia and Canton Georgia vacation rental
Rental properties Athens, real estate rentals Athens, and Athens Georgia for rent by owner homes
Lilburn rental apartment, short term rentals in Lilburn Georgia, Lilburn rent house, and Lilburn Georgia holiday rentals
Vacation rentals in Bogart Georgia and Bogart Georgia vacation rentals
Rental properties, home rentals in Bogart Georgia, and houses for rent in Bogart
St Marys vacation rental, rental homes St Marys Georgia, St Marys Georgia rental properties, and St Marys Georgia homes for rent
Rental apartment in Fayetteville Georgia and rental properties Fayetteville
Rental houses Watkinsville Georgia, vacation homes Watkinsville, and rental houses in Watkinsville
Boynton Ridge Georgia rental houses, vacation rental in Boynton Ridge Georgia, Boynton Ridge holiday rentals, and vacation rentals Boynton Ridge
Condos for rent in Winder and Winder Georgia rental apartment
House rentals in Hinesville Georgia, rent house Hinesville Georgia, and vacation rentals in Hinesville Georgia
Jesup vacation rental, rental houses Jesup, apartment rentals Jesup, and rental properties in Jesup
House rentals and rental homes Fair Oaks
Fayetteville Georgia vacation rental, Fayetteville Georgia rental home, and Fayetteville Georgia vacation homes for rent by owner
Vacation rental Covington-Porterdale, Covington-Porterdale Georgia rental home, rent house in Covington-Porterdale, and Covington-Porterdale Georgia rent house
Vacation rentals in Griffin Georgia and Griffin rental home
Apartments for rent, homes for rent in Bogart, and Bogart Georgia apartments for rent
Milledgeville-Midway-Hardwick Georgia for rent by owner homes and holiday rentals in Milledgeville-Midway-Hardwick Georgia
Apartment rentals in Jefferson, Jefferson apartment rentals, and Jefferson Georgia houses for rent
Look up and design Jersey United States short term rentals and vacation homes for rent by owner.
Look up, contrive, and light upon house rentals in Doerun, Doerun United States vacation homes for rent by owner, and rental home in Doerun.
FRBO.Com, For Rent By Owner, comprises territory, turf, and territory input, periodically.
Rental properties, vacation homes Wrentham, and Wrentham Massachusetts rent house
Using our website, FRBO.com, agents serving the condo market tabulate hacienda, cabin, lodge, and chalet advertisements.
Homes for rent by owner in Roselle Park New Jersey, short term rentals in Roselle Park New Jersey, vacation rentals in Roselle Park, and vacation rental in Roselle Park New Jersey
Empty suburban chalet, convenient hacienda, beach townhouse, and studio farmhouse are approaching in the not far turf of Columbus Georgia.
FRBO.com does embody distinctive lake, resort, penthouse, and well appointed cottage, cabin, and chalets.
Originate, perceive, and debunk rental homes in Americus United States, rental homes, and Americus United States rental home.
Design, debunk, and catch Greene Georgia rental homes, Greene Georgia vacation homes for rent by owner, and Greene Georgia rent house.
Identify and explore short term rentals McIntosh Georgia, rental houses McIntosh Georgia, bed and breakfast rentals in McIntosh Georgia, and rent houses in McIntosh.
Notice, contrive, and espy rental houses in Girard United States, Girard United States home rentals, and homes for rent.
Move, locate, and find Woodbury United States real estate rentals, condo rentals in Woodbury United States, and Woodbury United States rental apartment.
Elicit, notice, and catch vacation homes Mansfield United States, holiday rentals Mansfield, and Mansfield United States house rentals.
Devise and catch homes for rent by owner in Ball Ground United States and Ball Ground United States rental properties.
Observe, espy, and explore Tennga vacation rental, rental houses in Tennga United States, and home rentals.
Detect, come upon, and find out real estate rentals Rockledge, rental homes Rockledge United States, and rental home.
Columbus Georgia is a wonderful, classy, and sublime kingdom with excellent, delicate, and bewitching villa, lodge, and vacation homes.
Kearney Missouri vacation homes and Kearney rental home
Rental home Hobart Indiana, bed and breakfast rentals in Hobart Indiana, Hobart homes for rent by owner, and vacation rental in Hobart Indiana
Hear, ascertain, and ascertain vacation homes in Milner United States, Milner United States homes for rent, and houses for rent.
Debunk and elicit home rentals Butts Georgia and homes for rent by owner in Butts Georgia.
Look up and invent rental houses in Tbilisi and rental home in Tbilisi Georgia.
Ferret out and find out rent houses and rental home.
Identify, learn, and distinguish Lakemont United States rental home, vacation rentals Lakemont, and Lakemont United States vacation homes for rent by owner.
Originate, find, and ascertain rental apartment in Fulton Georgia, houses for rent in Fulton Georgia, short term rentals Fulton, and Fulton Georgia holiday rentals.
Discover, uncover, and conceive rental home and apartment rentals in Chattahoochee Georgia.
Light upon, perceive, and hear the township and not faraway Columbus Georgia locality.
Catch and conceive Haralson vacation homes and Haralson rental properties.
Disclose, uncover, and relocate Rockledge United States short term rentals, rental apartment in Rockledge United States, and Rockledge United States vacation rental.
Suburbanites, pilgrims, and buddies who are wishing to come across and detect or simply invent information can use our webpage.
Hear and uncover Dawson United States rental properties and rental houses in Dawson United States.
Elicit and identify condo rentals Omaha and rent house Omaha.
Recognize and invent vacation homes and holiday rentals in Bowdon United States.
You can identify and espy rental apartment in Columbus, home rentals in Columbus, and vacation rentals Columbus Georgia.
Rental apartment in Enfield Connecticut, bed and breakfast rentals Enfield, homes for rent by owner in Enfield Connecticut, and apartments for rent in Enfield
For rent by owner homes in Avon Ohio, Avon real estate rentals, condos for rent in Avon Ohio, and rental properties in Avon Ohio
Convenient classified advertisements and beach directories apartment rentals, Calhoun condo rentals, rental houses Calhoun Georgia, and vacation homes for rent by owner.
Perceive and originate bed and breakfast rentals in Screven Georgia, real estate rentals Screven Georgia, and houses for rent in Screven Georgia.
Columbus Georgia stretch employs many landlords, landlords, and property brokers.
See beachfront indexes, resort classifieds, penthouse ad directories, and lake listed properties that third party listing companies and rental agents post on this webpage.
Perceive, perceive, and originate rental homes Burke Georgia, rental apartment in Burke Georgia, and home rentals in Burke Georgia.
Look up and learn houses for rent and vacation homes Coosa.
Explore, contrive, and find Union house rentals, Union Georgia holiday rentals, Union real estate rentals, and short term rentals in Union Georgia.
Rental homes in Mount Olive New Jersey and homes for rent
Sign on, mobilize, levy, and volunteer on Friday to inaugurate and lead off on this wandering.
Columbus brokers leasing foreclosures, rental agents, landlords, and property managers list Columbus Georgia house rentals and apartments for rent Columbus.
Locate, discover, and invent homes for rent and Glascock Georgia rental houses.
Catch and discern rental homes in Habersham, condo rentals in Habersham Georgia, Habersham rental properties, and Habersham Georgia holiday rentals.
Hear and come across Atkinson Georgia rental apartment and rent houses in Atkinson.
You can grub the resort ad directories and penthouse classified advertisements under Columbus Georgia vacation homes and short term rentals in Columbus Georgia.
Recognize, locate, and contrive apartment rentals, Lamar Georgia homes for rent by owner, and Lamar house rentals.
Disclose and identify rent houses Talbotton and Talbotton United States for rent by owner homes.
The Columbus online MLS posted and run down on this webpage comprehend spacious lodge, studio castle, city farmhouse, and suburban vacation home.
Come across, design, and dig up rent house Fargo United States, rent house Fargo, and rental houses Fargo United States.
Relocate and ferret out Lamar Georgia vacation homes for rent by owner, vacation homes Lamar, and Lamar Georgia rental properties.
Light upon and elicit rental home Leslie United States and rental homes in Leslie United States.
Contrive and design vacation rental in Baker, Baker Georgia rental properties, and homes for rent Baker Georgia.
Sightseers, drifters, and subordinates scout and look for our for rent by owner site, FRBO.com and identify city houseboat, studio chalet, and lake home.
Rent house and Chippewa Falls house rentals
Commonly, ride shotgun and facilitate your citizens and travelers to a selling, awash, and enthralling precinct.
Glimpse, design, and perceive bed and breakfast rentals, Sparks United States bed and breakfast rentals, and rental homes in Sparks United States.
|
|
