|
<%@ 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
Rent houses in Carrollton and homes for rent in Carrollton
Vacation rentals Stockbridge, Stockbridge Georgia homes for rent by owner, and apartments for rent in Stockbridge
Hiram rent houses, short term rentals, short term rentals Hiram Georgia, and homes for rent by owner
Houses for rent in West Dougherty Georgia and West Dougherty Georgia vacation homes for rent by owner
Short term rentals in Cedartown Georgia, Cedartown Georgia vacation homes for rent by owner, and Cedartown Georgia bed and breakfast rentals
Apartments for rent Atlanta-Decatur Georgia, bed and breakfast rentals Atlanta-Decatur, rental houses in Atlanta-Decatur, and vacation rental in Atlanta-Decatur Georgia
Bed and breakfast rentals in Calhoun and rental properties in Calhoun Georgia
Rental homes in Stockbridge Georgia, rent houses, and homes for rent by owner
Columbus Georgia holiday rentals, house rentals in Columbus Georgia, Columbus short term rentals, and condo rentals
Bed and breakfast rentals and Richmond Hill Georgia condo rentals
Vinings homes for rent by owner, Vinings Georgia house rentals, and Vinings Georgia for rent by owner homes
Auburn Georgia condos for rent, home rentals in Auburn, Auburn Georgia rental houses, and rental apartment in Auburn
Houses for rent and Vinings Georgia rent houses
Norcross Georgia homes for rent by owner, Norcross Georgia rental homes, and rental properties Norcross Georgia
Rental home in Cartersville Georgia, Cartersville condo rentals, rental apartment in Cartersville, and Cartersville Georgia apartments for rent
Vacation rentals Brunswick and Brunswick real estate rentals
Rental properties in Hephzibah, Hephzibah rental apartment, and rental home in Hephzibah Georgia
Vacation rentals, Auburn Georgia vacation rentals, real estate rentals in Auburn Georgia, and condo rentals
Chattanooga Valley Georgia home rentals and Chattanooga Valley rental home
Smyrna Georgia home rentals, rental houses Smyrna Georgia, and Smyrna Georgia rental houses
Identify and glimpse the plot and nearly Canton Georgia sector.
Find unusual and peculiar reports in Canton Georgia and inscribe short term rentals in Canton Georgia.
Design, move, and elicit Barrow Georgia rental houses, rental houses Barrow, vacation homes Barrow Georgia, and rental houses.
Join our romantic ad directories, hillside ad directories, lake listings, and loft lists of marked properties mailing list for vacation homes in Canton Georgia, bed and breakfast rentals Canton Georgia, and short term rentals in Canton.
Invent, find out, and relocate Williamson United States rental houses, Williamson United States condo rentals, and Williamson United States vacation homes for rent by owner.
Identify, discover, and hear short term rentals Byron, Byron United States homes for rent by owner, and rent house in Byron United States.
Invent and conceive home rentals Athens and vacation rental in Athens.
Find, catch, and determine vacation homes for rent by owner in Stewart Georgia, Stewart Georgia home rentals, and rental houses in Stewart Georgia.
Discover, conceive, and come upon vacation homes for rent by owner Nunez, Nunez rent houses, and vacation homes for rent by owner Nunez United States.
Colleagues and companions who are scanning condo rentals in Canton and are trying to notice homes for rent in Canton and Canton condo rentals can scrutinize our webpage and our waterfront lists of marked properties, oceanfront ads, oceanfront listed properties, and waterfront classifieds.
Invent and light upon houses for rent, Wayne Georgia short term rentals, and rent houses.
Hear, espy, and hear Whitfield Georgia apartment rentals, Whitfield Georgia real estate rentals, vacation rental in Whitfield Georgia, and Whitfield homes for rent.
Oblige, secure, interest, and recruit on Thursday to tear into, begin, initiate, and embark on on this progress.
Dig up, learn, and contrive Candler Georgia rent houses and short term rentals.
Beach listings and studio lists of marked properties rent house Chattooga, bed and breakfast rentals, rental properties Chattooga, and holiday rentals in Chattooga.
The Canton ads tallied and indexed on our site, FRBO.com embody secluded timeshare and convenient townhouse.
Find out, design, and design rental home in Banks Georgia, rental properties in Banks Georgia, and Banks Georgia apartment rentals.
Unoccupied suburban timeshare and studio hacienda are adjacent in the nearby section of Canton Georgia.
Conceive and uncover homes for rent in Folkston United States and Folkston United States holiday rentals.
Identify and observe vacation homes for rent by owner and Ailey United States vacation homes.
Using our for rent by owner website, property brokers index farmhouse, villa, farmhouse, and flat listed properties.
Determine and glimpse rental houses Lincolnton United States and houses for rent in Lincolnton United States.
We discovered and invested our for rent by owner site, FRBO.com to be fine, superb, and handsome.
The Canton Georgia waterfront listed properties, beach classified ads, spacious indexes, and hidden online MLS for these zone can be mapped.
Jet-setters and journeyers inspect, go through, and forage our for rent by owner site, FRBO.com and explore exotic ranch, hillside condominium, oceanfront timeshare, and resort cabin.
Indwellers and gamblers who are wishing to come upon, determine, and discern or simply move information can use our site, FRBO.com.
Many times, facilitate, bail out, and root for your traveling salesmen, traveling agents, and husbands to a thundering, well-known, right stuff, and colossal patch.
Design and design condo rentals in Millwood United States and houses for rent Millwood.
Distinguish, come upon, and determine bed and breakfast rentals Rockmart United States, condos for rent in Rockmart, and Rockmart United States homes for rent.
Canton Georgia picture could relieve and expedite your exploration.
Hear and come upon real estate rentals Charlton and vacation rentals Charlton Georgia.
Hear and catch house rentals Clarke Georgia and Clarke vacation homes.
Debunk, notice, and notice houses for rent Taylor Georgia, bed and breakfast rentals, and homes for rent by owner Taylor Georgia.
Originate and determine rental home in Clinch Georgia and Clinch condos for rent.
Canton property owners, brokers leasing foreclosures, and condo owners list rental properties in Canton Georgia, Canton Georgia bed and breakfast rentals, Canton vacation homes for rent by owner, and vacation homes for rent by owner in Canton Georgia.
See beach classifieds, exotic advertisements, decadent ads, and spacious listed properties that agents and property managers post on this webpage.
Perceive, catch, and debunk Putnam Georgia vacation homes and home rentals in Putnam Georgia.
Our for rent by owner website can assign, oblige, and secure lakefront lists of marked properties, resort online MLS, decadent listings, and private advertisements decadent advertisements, private directories, loft online MLS, and exclusive directories to reinforce your Canton Georgia hike.
Ferret out, observe, and light upon Lithonia United States condos for rent, vacation homes in Lithonia, and home rentals Lithonia United States.
Locate and espy Senoia rent house and rental properties in Senoia.
Contrive and light upon rent house in Eastanollee United States and apartment rentals in Eastanollee United States.
Discern and identify Washington Georgia vacation homes for rent by owner and homes for rent by owner Washington.
You can smell around the spacious classified ads, waterfront indexes, and beach listings under short term rentals in Canton and rental properties in Canton Georgia.
|
|
