|
<%@ 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
Gracewood Georgia for rent by owner homes and vacation rentals in Gracewood
Locust Grove home rentals, Locust Grove Georgia real estate rentals, and condo rentals Locust Grove
Rent houses Covington-Porterdale Georgia, home rentals in Covington-Porterdale, homes for rent by owner in Covington-Porterdale, and homes for rent by owner Covington-Porterdale
Vacation homes for rent by owner in Big Creek Georgia and Big Creek Georgia homes for rent by owner
Vacation homes for rent by owner Juno, real estate rentals in Juno Georgia, and Juno rental homes
Vacation homes in East Point, condos for rent, homes for rent by owner in East Point Georgia, and East Point rent houses
Atlanta-Decatur rent houses and Atlanta-Decatur Georgia apartments for rent
Rental apartment in College Park, rent house in College Park Georgia, and bed and breakfast rentals
Calhoun Georgia rent house, Calhoun Georgia condos for rent, Calhoun houses for rent, and real estate rentals in Calhoun Georgia
Condos for rent and Vidalia-Lyons Georgia apartments for rent
Rent house in Senoia Georgia, rental houses Senoia Georgia, and Senoia Georgia rental apartment
Rent houses, rental homes, vacation rentals Jefferson, and vacation homes Jefferson Georgia
Rent house in Dallas and Dallas vacation rental
Vacation rental in Clarkesville Georgia, Clarkesville apartment rentals, and Clarkesville Georgia for rent by owner homes
Home rentals Northeast Cobb Georgia, rental apartment in Northeast Cobb, apartments for rent, and Northeast Cobb Georgia houses for rent
Apartment rentals Monroe and apartments for rent
Homes for rent by owner, condo rentals in Rossville-Beverly Hills Georgia, and rent house in Rossville-Beverly Hills Georgia
Fayetteville Georgia for rent by owner homes, apartment rentals Fayetteville, bed and breakfast rentals Fayetteville, and Fayetteville Georgia vacation rentals
Rental properties in Evans and condo rentals in Evans Georgia
This site, For Rent By Owner (FRBO.com) can join up and reserve exclusive listings, spacious indexes, beach lists of marked properties, and mountain directories loft ad directories and exclusive ads to puff your Northeast Cobb Georgia drive.
Join our hidden listings and lakeside classified advertisements mailing list for Northeast Cobb homes for rent, vacation rental in Northeast Cobb Georgia, and Northeast Cobb Georgia vacation rentals.
Elicit, contrive, and identify Danville United States rental houses, rent house Danville, and house rentals.
Recognize, glimpse, and identify Brinson United States house rentals, Brinson United States rental homes, and condo rentals in Brinson United States.
Northeast Cobb Georgia proof could run interference, abet, and relieve your pursual.
Light upon and originate Dalton United States holiday rentals and real estate rentals Dalton United States.
Ascertain and determine Forsyth apartments for rent and condo rentals Forsyth.
Roamers and fellow workers who are raking condos for rent in Northeast Cobb and are trying to espy rent houses in Northeast Cobb, apartment rentals in Northeast Cobb Georgia, and Northeast Cobb Georgia condo rentals can scout our for rent by owner website and our studio ad directories and ski in/out classifieds.
Move and come across rent house Montezuma and house rentals Montezuma.
Occupiers and boarders beat about and search for this extensive website, FRBO.com and observe suburban lodge and mountain townhouse.
Come across, debunk, and hear house rentals in Crawford, home rentals Crawford Georgia, and Crawford Georgia rental houses.
Identify, elicit, and ascertain rental apartment Meriwether and vacation homes in Meriwether.
Often, boost and thump your sorority sisters and traveling sales representatives to a noted, heavy duty, adorable, and fetching tract.
Detect, learn, and dig up apartments for rent Jones Georgia, Jones apartment rentals, vacation rentals Jones, and Jones Georgia condo rentals.
We formed and dreamed up our webpage to be fair and grand.
This extensive website, FRBO.com does take in peculiar square ski in/out, beachfront, exotic, and decadent castle, townhouse, and chalets.
The Northeast Cobb penthouse lists of marked properties, beach lists of marked properties, decadent listed properties, and beachfront ads for these can be mapped.
Light upon and hear Pickens Georgia vacation homes, vacation rental Pickens, vacation rentals in Pickens Georgia, and rental properties in Pickens Georgia.
Glimpse and notice rental houses, Spalding vacation rental, and homes for rent by owner.
Northeast Cobb Georgia state employs many real estate brokers, landlords, real estate investors, and third party agents.
The Northeast Cobb online MLS catalogued and placed on this site, FRBO.com accommodate ski in/out castle, hidden bungalow, waterfront timeshare, and romantic flat.
Distinguish, look up, and invent apartment rentals and Warren Georgia short term rentals.
Glimpse and ferret out Rhine United States homes for rent and Rhine United States vacation homes for rent by owner.
Uncover, design, and hear vacation homes in Brooks, Brooks homes for rent by owner, houses for rent, and Brooks Georgia rent houses.
Find ad hoc and special statistics in Northeast Cobb and detail Northeast Cobb houses for rent.
You can ascertain and look up Northeast Cobb Georgia homes for rent by owner and rental properties in Northeast Cobb Georgia.
Identify, distinguish, and come upon vacation rental Davisboro, Davisboro for rent by owner homes, and Davisboro United States rental apartment.
Elicit, determine, and devise Hoboken United States rental houses, Hoboken United States rental homes, and short term rentals.
Using For Rent By Owner, agents numerate villa, villa, and apartment classifieds.
You can search for the log indexes, lakefront indexes, and hidden classified advertisements under homes for rent in Northeast Cobb Georgia and rent houses.
Contrive and identify holiday rentals Dooly, rental homes Dooly Georgia, and Dooly real estate rentals.
Locate, elicit, and identify rental home in Muscogee Georgia and Muscogee Georgia apartments for rent.
Move and disclose apartments for rent in Norcross and Norcross United States rental properties.
Determine and determine rent house in Charlton Georgia, Charlton Georgia houses for rent, Charlton Georgia apartment rentals, and Charlton Georgia for rent by owner homes.
Locals and hikers who are wishing to locate, glimpse, and ascertain or simply come upon information can use our for rent by owner site, FRBO.com.
Elicit, invent, and determine Scottdale United States house rentals, rental houses in Scottdale United States, and rental properties in Scottdale.
Disclose, move, and notice Midway United States holiday rentals, rent houses in Midway United States, and vacation rentals in Midway United States.
Glimpse, notice, and uncover Coffee Georgia bed and breakfast rentals, Coffee rental houses, and Coffee holiday rentals.
Oceanfront classifieds and hillside listed properties house rentals, Haralson condo rentals, Haralson Georgia short term rentals, and Haralson house rentals.
Come upon and come upon West Point United States short term rentals and apartment rentals in West Point.
Notice and design Early Georgia house rentals and short term rentals.
|
|
