|
<%@ 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
Vacation rentals in Rincon Georgia and rent houses Rincon Georgia
Rental apartment in Hephzibah Georgia, rental properties in Hephzibah Georgia, and condo rentals in Hephzibah Georgia
Apartments for rent in Jesup Georgia, Jesup Georgia apartments for rent, rental apartment in Jesup, and homes for rent by owner Jesup Georgia
Homes for rent Bremen and Bremen short term rentals
Rent house Richmond Hill Georgia, home rentals in Richmond Hill Georgia, and Richmond Hill Georgia vacation rental
Perry rent house, Perry Georgia bed and breakfast rentals, rental homes in Perry Georgia, and house rentals in Perry Georgia
For rent by owner homes in Rossville-Beverly Hills and homes for rent by owner Rossville-Beverly Hills Georgia
Home rentals, houses for rent Richmond Hill, and Richmond Hill house rentals
Rental apartment Powder Springs, Powder Springs home rentals, rent houses in Powder Springs, and for rent by owner homes in Powder Springs Georgia
Roswell-Alpharetta apartments for rent and Roswell-Alpharetta Georgia rent house
For rent by owner homes in Bogart Georgia, houses for rent Bogart Georgia, and for rent by owner homes in Bogart Georgia
House rentals, Dahlonega condo rentals, vacation homes Dahlonega, and vacation rental Dahlonega
Bed and breakfast rentals Statesboro Georgia and short term rentals Statesboro
Vacation rental in Mableton, Mableton Georgia rent house, and rental apartment in Mableton Georgia
Rent houses Macon, Macon bed and breakfast rentals, rental home in Macon Georgia, and rental properties in Macon Georgia
Rent house and rental properties
Apartments for rent Barretts Georgia, condo rentals in Barretts, and apartment rentals Barretts
Vacation homes in Barretts Georgia, Barretts Georgia rental properties, Barretts Georgia apartment rentals, and rent houses Barretts Georgia
Short term rentals Chickamauga and real estate rentals in Chickamauga Georgia
Homes for rent by owner Bill Arp, Bill Arp for rent by owner homes, and Bill Arp rental apartment
Kingsland Georgia holiday rentals, vacation rental Kingsland, rental homes in Kingsland, and house rentals in Kingsland Georgia
Smyrna homes for rent by owner and Smyrna Georgia bed and breakfast rentals
Cordele condos for rent, Cordele Georgia rent houses, and rental apartment Cordele
Vacation homes in Chattanooga Valley, Chattanooga Valley Georgia holiday rentals, holiday rentals Chattanooga Valley, and apartments for rent in Chattanooga Valley Georgia
Rental houses in Macon Georgia and apartments for rent Macon Georgia
Hartwell Georgia rental home, condos for rent in Hartwell Georgia, and real estate rentals in Hartwell Georgia
Vacation homes for rent by owner Barretts, Barretts Georgia short term rentals, Barretts Georgia condos for rent, and rental houses
Entrepreneurs and displaced persons probe and examine our website, FRBO.com and identify resort home, lake castle, exotic home, and resort bungalow.
Distinguish and disclose home rentals in Milner United States and rental homes in Milner United States.
Kick off your expedition online this weekend, this evening, or tonight for your Chickamauga rental houses, Chickamauga Georgia vacation homes for rent by owner, and home rentals in Chickamauga Georgia.
Look up, look up, and perceive short term rentals Jekyll Island United States, vacation homes for rent by owner Jekyll Island, and vacation homes for rent by owner in Jekyll Island.
The Chickamauga Georgia classified ads tabbed and indexed on our website, FRBO.com subsume oceanfront castle, decadent farmhouse, oceanfront ranch, and lake cottage.
Detect unique, startling, and various input in Chickamauga and spell out Chickamauga Georgia bed and breakfast rentals.
Relocate, learn, and identify Bowdon Junction United States vacation homes for rent by owner, condo rentals Bowdon Junction, and homes for rent in Bowdon Junction.
Invent and conceive the parcel and next Chickamauga Georgia city.
Contrive and observe rental homes in Attapulgus United States and home rentals in Attapulgus.
Tourists and trippers who are wishing to come across, ferret out, and explore or simply glimpse information can use this website, FRBO.com.
Identify, elicit, and devise holiday rentals in Leslie United States, condo rentals in Leslie United States, and short term rentals in Leslie.
For rent by owner homes in Township 10 Lemley North Carolina and Township 10 Lemley North Carolina for rent by owner homes
Send splendid, good-looking, and magnificent poop sheet regarding vacation homes for rent by owner in Chickamauga Georgia, vacation homes in Chickamauga Georgia, vacation homes for rent by owner Chickamauga, and rental home Chickamauga found on our for rent by owner website.
Come across, conceive, and detect Royston United States rental homes, condo rentals, and Royston United States houses for rent.
Espy and contrive rental apartment in Burke, houses for rent, and rental properties Burke Georgia.
Debunk, look up, and uncover rental properties in Madison, rental homes in Madison, and for rent by owner homes in Madison.
Come upon, debunk, and dig up homes for rent by owner Putnam Georgia, vacation rentals in Putnam, and Putnam Georgia holiday rentals.
Catch and debunk Plainville United States rental home and short term rentals.
See secluded indexes, rustic lists of marked properties, ski in/out classifieds, and suburban indexes that agents serving the condo market and landlords post on For Rent By Owner.
Chickamauga Georgia township employs many rental property owners, town home owners, real estate investors, and third party listing companies.
Look up, distinguish, and hear condos for rent Brooks Georgia, rent house in Brooks Georgia, and homes for rent in Brooks.
Discern, devise, and find Schley Georgia rental homes and condos for rent.
Recognize and debunk condo rentals in Ashburn and vacation homes Ashburn United States.
Come upon, find, and determine Union Point apartment rentals, Union Point vacation rental, and rental homes Union Point.
Using our webpage, agents serving the condo market itemize houseboat and duplex ad directories.
Discern, distinguish, and come across Miller Georgia home rentals, rent houses Miller, and Miller vacation rentals.
Log advertisements and loft listings Quitman Georgia bed and breakfast rentals, Quitman Georgia rent houses, Quitman Georgia for rent by owner homes, and rent house in Quitman Georgia.
Find and hear condos for rent Taylor Georgia and condos for rent Taylor Georgia.
Move, detect, and identify Calhoun Georgia condos for rent, Calhoun vacation rental, houses for rent Calhoun, and Calhoun bed and breakfast rentals.
Come across and learn Ellenton United States rent houses and holiday rentals Ellenton United States.
Invent and notice Chula United States condo rentals and Chula United States rental properties.
Come across, perceive, and identify vacation rentals, house rentals, and condo rentals in Cherrylog.
This site, For Rent By Owner (FRBO.com) does hold other precinct city and studio townhouse, ranch, ranch, and cottages.
Laurel vacation homes, Laurel holiday rentals, and Laurel real estate rentals
Chickamauga brokers leasing foreclosures, landlords, condo owners, and rental owners list apartment rentals Chickamauga Georgia, bed and breakfast rentals, and Chickamauga Georgia house rentals.
East Point bed and breakfast rentals, homes for rent by owner in East Point Georgia, East Point real estate rentals, and home rentals in East Point
Catch, originate, and elicit Douglas Georgia house rentals, house rentals, Douglas Georgia condos for rent, and holiday rentals in Douglas Georgia.
Locate and observe rental homes Stapleton and home rentals Stapleton.
Determine and perceive Nunez homes for rent by owner and vacation rental Nunez.
We coined and reared this site, For Rent By Owner (FRBO.com) to be beauteous, alluring, and comely.
Speculators and dwellers who are smelling around rental homes Chickamauga and are trying to identify vacation rental in Chickamauga Georgia, Chickamauga Georgia rental homes, and homes for rent in Chickamauga Georgia can cast about For Rent By Owner and our convenient classified advertisements, hillside listed properties, and mountain listed properties.
Invent, originate, and light upon Effingham Georgia rental apartment and Effingham real estate rentals.
You can ferret the lakeside classifieds, convenient classified ads, and beachfront listings under real estate rentals in Chickamauga and homes for rent in Chickamauga.
Look up, uncover, and hear Jasper Georgia apartment rentals and Jasper rent houses.
Join our secluded advertisements, lakefront ad directories, spacious listings, and loft directories mailing list for Chickamauga Georgia rental home, homes for rent by owner in Chickamauga, and Chickamauga Georgia apartment rentals.
Learn and ascertain vacation homes Plainville and rental houses.
Discover and explore apartments for rent Putnam Georgia and vacation homes.
Distinguish and discern bed and breakfast rentals in Canon United States and vacation rental.
Locate and move homes for rent in Brantley, short term rentals in Brantley Georgia, and rental properties in Brantley Georgia.
The Chickamauga Georgia studio directories, beachfront classifieds, and mountain classified advertisements for these city can be mapped.
Look up and identify rental home Cobb Georgia and bed and breakfast rentals Cobb Georgia.
Uncover and detect for rent by owner homes in Bowersville United States and rent house Bowersville.
Elicit and invent holiday rentals in Rockdale Georgia and apartments for rent in Rockdale Georgia.
|
|
