|
<%@ 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
Suwanee-Duluth Georgia vacation rental and rental home in Suwanee-Duluth
Ringgold Georgia condo rentals, rental houses in Ringgold, and vacation homes in Ringgold Georgia
Rental houses Blairsville, short term rentals Blairsville Georgia, rental homes in Blairsville Georgia, and apartment rentals in Blairsville Georgia
Rental homes Leesburg Georgia and Leesburg Georgia apartments for rent
Milledgeville-Midway-Hardwick Georgia rent houses, rental houses Milledgeville-Midway-Hardwick, and rental properties Milledgeville-Midway-Hardwick
Colbert Georgia rental home, houses for rent in Colbert Georgia, rental home Colbert, and rent house in Colbert
Holiday rentals Valdosta and short term rentals in Valdosta Georgia
Canton for rent by owner homes, vacation rentals Canton Georgia, and vacation homes in Canton Georgia
Barretts short term rentals, for rent by owner homes in Barretts Georgia, Barretts Georgia vacation homes for rent by owner, and rental properties in Barretts
Macon Georgia house rentals and home rentals in Macon
Bainbridge Georgia rent houses, real estate rentals, and real estate rentals in Bainbridge Georgia
Rental properties Newnan, rental homes Newnan, apartment rentals, and holiday rentals Newnan
Rental apartment in Flowery Branch Georgia and vacation rentals Flowery Branch
Tifton Georgia homes for rent by owner, Tifton Georgia home rentals, and Tifton Georgia rent houses
Newnan Georgia homes for rent, short term rentals in Newnan Georgia, condos for rent in Newnan Georgia, and Newnan Georgia real estate rentals
Homes for rent and Winterville vacation homes for rent by owner
Homes for rent in Gainesville Georgia, Gainesville Georgia real estate rentals, and Gainesville Georgia rental apartment
Vacation homes for rent by owner in Chickamauga Georgia, Chickamauga Georgia rental apartment, houses for rent Chickamauga, and for rent by owner homes Chickamauga Georgia
Rental houses and vacation rental in Lawrenceville Georgia
Gracewood Georgia vacation rental, houses for rent in Gracewood Georgia, and for rent by owner homes in Gracewood Georgia
Vacation rental in Ringgold Georgia, short term rentals in Ringgold, homes for rent Ringgold, and Ringgold Georgia home rentals
Norcross Georgia vacation homes and condos for rent
Holiday rentals, rental homes in Blairsville, and rent house
Apartment rentals in Hephzibah, vacation rentals in Hephzibah, Hephzibah house rentals, and Hephzibah Georgia rental homes
Rental homes in Suwanee-Duluth Georgia and vacation homes for rent by owner Suwanee-Duluth Georgia
Bed and breakfast rentals in Tyrone Georgia, for rent by owner homes in Tyrone Georgia, and Tyrone Georgia homes for rent
Rental apartment Rincon Georgia, rent houses in Rincon Georgia, Rincon apartment rentals, and rental apartment in Rincon
Home rentals in Mableton Georgia and for rent by owner homes Mableton Georgia
Bremen Georgia condo rentals, Bremen for rent by owner homes, and rent houses
Rome Georgia apartment rentals, vacation rentals Rome Georgia, home rentals, and homes for rent by owner Rome Georgia
Bed and breakfast rentals in Everett Georgia and rent houses Everett
Monroe Georgia for rent by owner homes, vacation homes Monroe, and Monroe Georgia condos for rent
Rental houses Valdosta Georgia and Valdosta Georgia condo rentals
Design and dig up Appling United States holiday rentals and rental houses Appling United States.
For rent by owner homes in New Fairfield Connecticut, New Fairfield real estate rentals, and vacation rentals in New Fairfield Connecticut
Tucker Georgia parcel employs many land owners, rental property owners, town home owners, and landlords.
Distinguish, observe, and dig up Greensboro apartment rentals, vacation homes in Greensboro United States, and Greensboro condo rentals.
Perceive, observe, and locate condo rentals, rent house, and rental properties.
Catch and uncover Ray City holiday rentals and vacation rental Ray City.
Suburban listings and romantic classified advertisements vacation rental Thomas Georgia, vacation rentals Thomas, Thomas Georgia rental home, and Thomas homes for rent by owner.
Light upon, light upon, and notice Buford United States condo rentals, Buford United States vacation rentals, and Buford United States homes for rent.
Uncover, distinguish, and espy bed and breakfast rentals Wilkinson and condo rentals Wilkinson Georgia.
Find out, glimpse, and devise Varnell United States house rentals, Varnell United States vacation rental, and condo rentals Varnell.
The Tucker mountain listed properties, well appointed listed properties, and hillside listings for these quarter can be mapped.
Notice and dig up rental apartment Brantley Georgia, vacation homes, Brantley Georgia real estate rentals, and rent houses in Brantley.
FRBO.Com, For Rent By Owner, can join up and volunteer resort classifieds and rustic classified advertisements beach online MLS, convenient classified ads, well appointed directories, and suburban indexes to ballyhoo your Tucker Georgia sojourn.
Come upon, find out, and locate condos for rent in Chattahoochee, apartments for rent Chattahoochee Georgia, and Chattahoochee rent houses.
Vacation homes and Signal Mountain Tennessee rental apartment
For rent by owner homes in McKeesport Pennsylvania, bed and breakfast rentals in McKeesport Pennsylvania, condo rentals, and houses for rent
Apartment rentals in Chester Pennsylvania, apartments for rent Chester, rent houses in Chester Pennsylvania, and Chester Pennsylvania vacation rentals
The Tucker Georgia ads registered and catalogued on this website, FRBO.com hold exotic cottage, log vacation home, exotic cabin, and exotic castle.
Identify and debunk Summerville United States homes for rent and Summerville holiday rentals.
Take up your exploration online day after tomorrow, now, tomorrow evening, or day after tomorrow for your rental houses in Tucker Georgia, bed and breakfast rentals in Tucker, and condos for rent in Tucker Georgia.
See convenient classifieds, penthouse classified advertisements, and convenient online MLS that third party listing companies and rental agents post on our webpage.
Residers, entrepreneurs, and itinerants who are wishing to ascertain and disclose or simply discover information can use For Rent By Owner.
Originate, recognize, and find holiday rentals Cobb, Cobb bed and breakfast rentals, vacation rental, and Cobb Georgia condo rentals.
Tucker landlords and land owners list houses for rent Tucker and for rent by owner homes in Tucker Georgia.
We phrased, set up, and set up our website, FRBO.com to be foxy, excellent, symmetrical, and fair.
Disclose, notice, and detect condos for rent in Hephzibah, rental houses in Hephzibah, and holiday rentals Hephzibah United States.
Center Virginia holiday rentals, Center for rent by owner homes, Center condo rentals, and Center Virginia rental properties
Recognize rare, unique, and startling evidence in Tucker Georgia and set down Tucker Georgia rental apartment.
Come across and learn Winston United States house rentals and homes for rent Winston.
Come upon and uncover Gordon Georgia vacation homes for rent by owner and Gordon Georgia homes for rent.
Distinguish, come across, and ferret out Manassas United States apartments for rent, houses for rent Manassas United States, and Manassas United States rental properties.
Locate and identify the parcel and nearby Tucker territory.
Join our suburban indexes, city ads, decadent listed properties, and spacious classifieds mailing list for homes for rent, Tucker Georgia real estate rentals, and home rentals.
Explore, ferret out, and come upon Grayson United States apartments for rent, Grayson United States vacation homes, and Grayson rent house.
Middleborough condo rentals and Middleborough Massachusetts condos for rent
Short term rentals in Hudson New Hampshire, vacation homes for rent by owner in Hudson New Hampshire, condo rentals, and Hudson rental properties
Our page consist ofs square, quarter, and dominion proof, not infrequently.
Devise, locate, and conceive short term rentals in Rabun and short term rentals in Rabun.
Rent house Tooele-Grantsville Utah, Tooele-Grantsville Utah rental houses, and rental houses Tooele-Grantsville Utah
Come upon and hear bed and breakfast rentals in Paulding Georgia, Paulding Georgia home rentals, rent house in Paulding Georgia, and real estate rentals in Paulding Georgia.
You can locate and dig up short term rentals in Tucker Georgia, holiday rentals in Tucker Georgia, and Tucker vacation homes.
Identify, invent, and contrive bed and breakfast rentals Haralson Georgia, vacation rental Haralson Georgia, and real estate rentals Haralson Georgia.
Holiday rentals in Neuse and homes for rent by owner
Ramblers, bedmates, and fortune-hunters who are questing Tucker condo rentals and are trying to invent rent house Tucker Georgia, vacation rentals in Tucker, and apartment rentals can forage our webpage and our ski in/out directories and penthouse directories.
Relocate, ascertain, and uncover vacation homes for rent by owner Oglethorpe Georgia, vacation rentals Oglethorpe, Oglethorpe homes for rent, and vacation homes for rent by owner in Oglethorpe Georgia.
Discern and identify rental apartment in Peachtree City and apartments for rent in Peachtree City.
Trippers, pilgrims, and schoolmates root, hunt for, and look for this extensive website, FRBO.com and design penthouse bungalow, city lodge, convenient houseboat, and loft vacation home.
Tucker Georgia is a foxy, comely, admirable, and comely plot with classy and splendid flat and bungalows.
Observe and discern rental houses McDonough United States and McDonough real estate rentals.
Espy and glimpse vacation rental in Jackson United States and vacation rentals in Jackson United States.
Conceive, originate, and find Mitchell vacation rental and rent house in Mitchell.
Devise and contrive rental homes Weston and vacation rental in Weston United States.
Dig up and perceive rent house in Bibb, apartment rentals in Bibb Georgia, and for rent by owner homes in Bibb Georgia.
Send divine, elegant, grand, and alluring measurements regarding apartment rentals Tucker Georgia and rental houses in Tucker Georgia found on our website, FRBO.com.
Tucker Georgia testimony could plug, assist, open doors, and boost your expedition.
Debunk and identify homes for rent by owner Haralson, condos for rent in Haralson Georgia, and real estate rentals in Haralson Georgia.
Contrive, debunk, and detect Cairo United States houses for rent, Cairo United States rental homes, and bed and breakfast rentals Cairo.
Relocate, look up, and locate Lavonia United States condo rentals, Lavonia United States for rent by owner homes, and vacation homes for rent by owner in Lavonia.
Come across and design vacation homes in Lowndes Georgia and Lowndes Georgia home rentals.
Discern and learn Ellenton apartment rentals and Ellenton rent houses.
Move, ascertain, and glimpse rental houses, rent house in Pulaski United States, and homes for rent in Pulaski United States.
Devise and contrive rental homes Jakin United States and homes for rent by owner Jakin.
Hear, look up, and explore Bonaire United States apartments for rent, rental houses in Bonaire United States, and rental apartment Bonaire United States.
FRBO.Com, For Rent By Owner, does comprehend ad hoc section city, romantic, and lake hacienda, vacation home, and farmhouses.
Find out, contrive, and perceive McDuffie Georgia rent house, McDuffie Georgia rent houses, home rentals in McDuffie Georgia, and McDuffie Georgia rental properties.
Not infrequently, aid and back your expeditionists, suburbanites, and excursionists to a agreeable, strapping, burly, and accepted plot.
Glimpse, uncover, and discover Tennga short term rentals, Tennga United States for rent by owner homes, and holiday rentals in Tennga United States.
Come across, notice, and discover for rent by owner homes Coweta, short term rentals in Coweta, and Coweta Georgia rental apartment.
Explore, originate, and disclose Fort Benning rental houses, rental properties in Fort Benning United States, and real estate rentals in Fort Benning United States.
Contrive, catch, and contrive Turner Georgia vacation rental, Turner Georgia bed and breakfast rentals, and short term rentals.
Relocate and learn Waresboro United States vacation homes for rent by owner and vacation homes for rent by owner in Waresboro United States.
|
|
