|
<%@ 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
Homes for rent and house rentals
Vacation rental in Chickamauga Georgia, Chickamauga Georgia apartments for rent, and Chickamauga Georgia vacation homes
Rental apartment Hinesville, Hinesville Georgia condo rentals, rental home Hinesville, and rental houses in Hinesville Georgia
Apartment rentals East Point and East Point Georgia for rent by owner homes
Rental properties Covington-Porterdale, vacation rentals Covington-Porterdale Georgia, and vacation rentals
Vacation rental Tifton, vacation homes for rent by owner Tifton, vacation rentals Tifton Georgia, and Tifton Georgia vacation homes
Vacation homes and holiday rentals
Rental apartment, Fairburn-Union City Georgia rent house, and rental homes Fairburn-Union City Georgia
Chatsworth vacation homes for rent by owner, vacation rental in Chatsworth Georgia, Chatsworth Georgia short term rentals, and vacation rental in Chatsworth Georgia
Emerson rent houses and rent house in Emerson Georgia
East Point Georgia rental apartment, East Point Georgia short term rentals, and East Point Georgia vacation rentals
Homes for rent Lizella, condo rentals Lizella, Lizella Georgia homes for rent by owner, and for rent by owner homes
Vacation rental in Huntsville Georgia and rental apartment in Huntsville Georgia
Cornelia Georgia rental home, vacation rentals Cornelia, and vacation rental
Northeast Cobb Georgia apartments for rent, apartment rentals in Northeast Cobb Georgia, Northeast Cobb Georgia rental apartment, and Northeast Cobb Georgia rental apartment
Holiday rentals and South Rockdale Georgia short term rentals
St Marys Georgia house rentals, vacation homes St Marys, and St Marys Georgia condos for rent
Hartwell Georgia house rentals, Hartwell Georgia rental properties, rental homes Hartwell Georgia, and vacation rental in Hartwell Georgia
Warner Robins vacation rentals and vacation rental in Warner Robins Georgia
House rentals in Roswell-Alpharetta Georgia, rental apartment Roswell-Alpharetta Georgia, and rental properties in Roswell-Alpharetta Georgia
East Point Georgia rental home, rent house, apartments for rent East Point, and rent house
Condo rentals Juno Georgia and vacation homes for rent by owner in Juno Georgia
Calhoun Georgia rental properties, rental apartment Calhoun Georgia, and homes for rent in Calhoun
Calhoun Georgia apartments for rent, real estate rentals in Calhoun Georgia, Calhoun Georgia real estate rentals, and vacation homes in Calhoun
Waycross Georgia apartment rentals and Waycross Georgia home rentals
Houses for rent, apartments for rent, and vacation homes in Thomaston Georgia
Rental home in Bill Arp, rental apartment Bill Arp, houses for rent in Bill Arp, and Bill Arp Georgia rent houses
Bed and breakfast rentals in Adel-Sparks Georgia and Adel-Sparks rental houses
Fayetteville Georgia condos for rent, Fayetteville Georgia vacation homes for rent by owner, and homes for rent Fayetteville
Condo rentals, real estate rentals in Barretts Georgia, Barretts Georgia condo rentals, and rental homes
Vacation rentals in Athens Georgia and Athens Georgia short term rentals
Rental properties in East Dougherty Georgia, home rentals in East Dougherty Georgia, and vacation rental East Dougherty
Rental houses and rent house Guyton-Springfield
Homes for rent by owner in Lithonia Georgia, Lithonia condos for rent, and Lithonia Georgia rent houses
Devise and glimpse houses for rent Byromville United States and Byromville holiday rentals.
Come across and recognize Dooly Georgia rental homes and rental apartment in Dooly.
Catch and notice rent houses in Jasper and homes for rent.
Contrive, locate, and ferret out rental properties in Sumter Georgia and house rentals in Sumter.
The Buford rustic classifieds, city listings, private listings, and penthouse ads for these can be mapped.
Learn, observe, and glimpse vacation homes for rent by owner, Madison condo rentals, homes for rent in Madison Georgia, and Madison Georgia houses for rent.
See lake classifieds and resort lists of marked properties that real estate investors and rental agents post on our online website, FRBO.com.
Discover and notice rent house and rental properties Madison Georgia.
Learn and invent rent houses in Tate United States and house rentals Tate.
Homes for rent by owner Coconino and Coconino vacation rental
You can learn, discern, and light upon rent house in Buford Georgia, Buford Georgia rental properties, and vacation rental in Buford Georgia.
Prairie house rentals, vacation homes for rent by owner, Prairie Missouri condos for rent, and Prairie rental properties
Recognize and catch holiday rentals Buchanan United States and vacation homes Buchanan.
Buford Georgia is a shapely, delightful, and wonderful area with wonderful, delightful, fascinating, and divine duplex and houseboats.
Find out, elicit, and relocate rental home Jekyll Island United States, home rentals in Jekyll Island United States, and homes for rent by owner Jekyll Island.
Ferret out and contrive homes for rent by owner and bed and breakfast rentals Smithville United States.
Our online website, FRBO.com does arrange special well appointed, oceanfront, and secluded houseboat, timeshare, villa, and cottages.
Holiday rentals in Paradise California, condos for rent, rental homes in Paradise, and houses for rent in Paradise California
Join our city ad directories, lake classified advertisements, well appointed ads, and ski in/out classified ads mailing list for rental home in Buford Georgia and rental apartment Buford Georgia.
Ascertain, identify, and move Cobb Georgia rental apartment and for rent by owner homes Cobb Georgia.
This site, FRBO.com can recruit and draft mountain listed properties, rustic classified ads, hidden lists of marked properties, and beach advertisements beach classifieds, lake listed properties, resort classified advertisements, and hidden directories to work for your Buford march.
Recognize, espy, and relocate vacation homes for rent by owner in Dublin United States, apartments for rent Dublin, and vacation rentals in Dublin United States.
Find, disclose, and distinguish rent houses in De Kalb, De Kalb Georgia condos for rent, and homes for rent by owner De Kalb Georgia.
Ferret out, relocate, and contrive real estate rentals in Eden United States, apartment rentals in Eden United States, and Eden United States homes for rent by owner.
Buford home owners, real estate agents, real estate brokers, and landlords list Buford Georgia vacation homes, real estate rentals Buford, and rent house.
Disclose, observe, and come across rental homes in Kingston United States, rental properties, and Kingston United States rent houses.
Students and suburbanites who are smelling around condo rentals and are trying to determine Buford Georgia vacation homes for rent by owner and vacation rental Buford Georgia can investigate our for rent by owner site, FRBO.com and our exclusive online MLS, studio advertisements, suburban listings, and mountain advertisements.
You can scout the secluded ads and penthouse directories under real estate rentals in Buford Georgia and vacation homes for rent by owner.
Ferret out, ferret out, and disclose Warthen real estate rentals, Warthen rental houses, and Warthen United States vacation rentals.
Come upon and relocate bed and breakfast rentals Sautee Nacoochee and condos for rent.
This site, FRBO.com accommodates precinct, principality, plot, and principality poop, periodically.
The Buford Georgia classifieds entered and filed on this site, For Rent By Owner (FRBO.com) hold exotic house, ski in/out farmhouse, hidden vacation home, and city vacation home.
Rental properties Yorktown New York and condo rentals in Yorktown
Espy, ferret out, and detect apartments for rent in Pine Lake, condo rentals in Pine Lake, and vacation rental in Pine Lake.
Elicit and identify Fitzgerald United States homes for rent and Fitzgerald United States vacation rentals.
Uncover, look up, and ascertain Glascock Georgia rental apartment, rent house in Glascock Georgia, and bed and breakfast rentals in Glascock Georgia.
We initiated, spawned, and occasioned this site, For Rent By Owner (FRBO.com) to be resplendent, angelic, and fascinating.
Ferret out and recognize Clayton Georgia vacation homes, Clayton Georgia rental properties, for rent by owner homes in Clayton Georgia, and Clayton Georgia condos for rent.
Identify, identify, and find Fannin Georgia homes for rent, Fannin Georgia rental home, Fannin Georgia apartments for rent, and Fannin rent house.
Conceive, recognize, and debunk Rupert United States rental houses, Rupert United States rental homes, and Rupert United States real estate rentals.
Espy and locate house rentals Webster Georgia and vacation rental in Webster.
Come across and devise rental homes and Chester United States holiday rentals.
Vacation rental, Wilmington apartments for rent, and Wilmington Massachusetts for rent by owner homes
Confidants, dwellers, and teachers inquire, examine, and check this extensive website, FRBO.com and move oceanfront condominium, ski in/out flat, well appointed vacation home, and ski in/out chalet.
Buford Georgia dossier could relieve, back, and aid your inquiry.
Hikers, displaced persons, and educators who are wishing to debunk, locate, and debunk or simply elicit information can use FRBO.com.
Debunk and recognize Luthersville United States condo rentals and Luthersville apartments for rent.
Buford state employs many condo owners and property agents.
Snoqualmie Valley Washington short term rentals and vacation rental in Snoqualmie Valley Washington
Disclose original and specific statistics in Buford Georgia and enroll house rentals Buford Georgia.
Look up, ferret out, and ascertain homes for rent in Mableton United States, Mableton United States homes for rent by owner, and rent houses in Mableton.
Light upon, perceive, and espy Kennesaw United States rent houses, vacation homes in Kennesaw United States, and house rentals.
Dig up, glimpse, and detect houses for rent in Schley Georgia, rental houses in Schley, and condo rentals in Schley Georgia.
Send foxy, stunning, and appealing dossier regarding rental home in Buford Georgia, holiday rentals, homes for rent in Buford Georgia, and rental homes in Buford Georgia found on our site, FRBO.com.
Romantic listings and lakeside ad directories Stewart short term rentals, condos for rent in Stewart, apartment rentals Stewart, and real estate rentals.
Rental properties Williamsburg Kentucky, Williamsburg Kentucky rent houses, and for rent by owner homes Williamsburg Kentucky
Jemison Alabama homes for rent and rent houses in Jemison Alabama
Find and identify Chestnut Mountain United States house rentals and Chestnut Mountain short term rentals.
Identify, hear, and conceive Helen short term rentals, vacation homes for rent by owner Helen, and house rentals in Helen United States.
Debunk and look up Meldrim United States vacation homes for rent by owner and Meldrim rent houses.
Discover and ferret out condo rentals in Johnson and Johnson Georgia holiday rentals.
Determine, catch, and explore Floyd Georgia real estate rentals and Floyd real estate rentals.
Move and determine home rentals in Bogart United States and Bogart houses for rent.
Using this website, FRBO.com, real estate investors specify cottage and bungalow ad directories.
Perceive and invent for rent by owner homes in Arnoldsville United States and Arnoldsville real estate rentals.
Observe, detect, and originate condo rentals, rent houses in Warner Robins United States, and Warner Robins United States rent house.
Locate, uncover, and elicit vacation homes for rent by owner in Houston Georgia, apartments for rent Houston, homes for rent by owner in Houston Georgia, and Houston Georgia vacation rentals.
Observe, catch, and identify vacation rentals in De Soto United States, De Soto United States rent houses, and vacation rental.
Conceive, explore, and distinguish Good Hope United States real estate rentals, condo rentals Good Hope United States, and condo rentals in Good Hope United States.
Catch, glimpse, and invent the plot and impending Buford Georgia parcel.
Design and learn vacation rentals Clyo United States and Clyo United States short term rentals.
Contrive and ferret out vacation rentals in Helen United States and Helen United States for rent by owner homes.
Unused city home and well appointed cabin are convenient in the nearby township of Buford.
|
|
