|
<%@ 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
For rent by owner homes in Canton Georgia and vacation rental in Canton
Savannah condos for rent, real estate rentals Savannah Georgia, and condo rentals Savannah
Bed and breakfast rentals Jesup Georgia, condo rentals Jesup, rental homes in Jesup Georgia, and for rent by owner homes in Jesup
Real estate rentals St Simons and short term rentals in St Simons Georgia
Vacation homes for rent by owner in Tybee Island-Wilmington Georgia, Tybee Island-Wilmington Georgia vacation homes for rent by owner, and rental homes Tybee Island-Wilmington
Blackshear Georgia bed and breakfast rentals, house rentals in Blackshear Georgia, home rentals, and vacation homes for rent by owner in Blackshear
Vacation rentals in Macon Georgia and Macon Georgia houses for rent
Bremen Georgia vacation rental, Bremen Georgia houses for rent, and condos for rent in Bremen Georgia
Condos for rent, houses for rent Chattanooga Valley Georgia, Chattanooga Valley Georgia bed and breakfast rentals, and rental homes in Chattanooga Valley
Apartments for rent in Cairo Georgia and apartments for rent in Cairo Georgia
Rental apartment Hazlehurst Georgia, Hazlehurst Georgia house rentals, and Hazlehurst Georgia condos for rent
Vacation rentals Gracewood Georgia, Gracewood Georgia vacation homes, Gracewood Georgia short term rentals, and Gracewood Georgia rental homes
Real estate rentals Cumming and apartment rentals
Rent house in Evans Georgia, Evans Georgia short term rentals, and rental home
For rent by owner homes Marietta Georgia, vacation homes, vacation homes in Marietta, and Marietta bed and breakfast rentals
Houses for rent and Clarkesville Georgia rental houses
Rental houses in College Park Georgia, rental apartment College Park Georgia, and College Park holiday rentals
Homes for rent by owner in Rutland Georgia, rental homes Rutland Georgia, home rentals in Rutland Georgia, and condos for rent in Rutland
Rental homes in Athens and Athens condos for rent
Smyrna Georgia rental home, for rent by owner homes in Smyrna Georgia, and rental homes in Smyrna
Short term rentals in Fort Oglethorpe-Lakeview Georgia, vacation homes in Fort Oglethorpe-Lakeview Georgia, rental houses, and Fort Oglethorpe-Lakeview Georgia bed and breakfast rentals
Rental homes Swainsboro Georgia and rental homes Swainsboro Georgia
House rentals Woodstock Georgia, Woodstock Georgia vacation rentals, and Woodstock Georgia for rent by owner homes
Sylvester Georgia for rent by owner homes, condos for rent in Sylvester Georgia, home rentals, and Sylvester house rentals
Lithonia short term rentals and home rentals in Lithonia Georgia
Real estate rentals in West Dougherty, West Dougherty vacation rentals, and West Dougherty Georgia apartment rentals
McDonough for rent by owner homes, houses for rent in McDonough, McDonough Georgia condo rentals, and McDonough Georgia rental houses
Barnesville Georgia condos for rent and vacation homes in Barnesville Georgia
Rent houses in Eastman Georgia, Eastman apartment rentals, and rental houses
Condos for rent in Flowery Branch Georgia, rental properties, homes for rent by owner Flowery Branch Georgia, and homes for rent by owner in Flowery Branch
Come across, observe, and distinguish real estate rentals Avondale Estates, homes for rent Avondale Estates, and Avondale Estates United States short term rentals.
Learn and ferret out bed and breakfast rentals Smarr and houses for rent Smarr United States.
Devise and locate real estate rentals Buena Vista United States and rental properties.
Notice and locate Jackson Georgia rental homes, Jackson Georgia condo rentals, and Jackson rent houses.
Our webpage does encompass singular section convenient, exclusive, and log flat, apartment, and houseboats.
Renters and professors run down, scrutinize, and hunt for our webpage and identify decadent townhouse, beachfront vacation home, romantic vacation home, and penthouse house.
Bed and breakfast rentals in Northeast Marin California and Northeast Marin rental home
Dig up, find out, and discern Nelson United States holiday rentals, Nelson United States vacation homes, and Nelson rental homes.
Move, espy, and dig up Lyons rental houses, Lyons United States bed and breakfast rentals, and vacation rental.
Discover, distinguish, and notice Sylvester United States condos for rent, Sylvester United States houses for rent, and apartments for rent Sylvester.
Look up, explore, and discern vacation rental in Stockbridge, Stockbridge United States real estate rentals, and house rentals Stockbridge.
Catch and discover homes for rent by owner in Alston and Alston houses for rent.
Cochran Georgia poop could aid, thump, and collaborate your hunt.
Identify and espy home rentals in Crisp Georgia, Crisp short term rentals, and short term rentals in Crisp Georgia.
Devise and distinguish condos for rent and rental apartment in Plainville.
Flint Michigan vacation rental, houses for rent in Flint Michigan, rental home in Flint, and rent houses
Debunk and debunk vacation homes for rent by owner Clinch, Clinch Georgia rent house, Clinch Georgia real estate rentals, and vacation homes in Clinch Georgia.
Unoccupied hillside apartment, loft cottage, exotic farmhouse, and lake cabin are proximate in the neighboring city of Cochran Georgia.
Cochran Georgia is a pretty, charming, and pulchritudinous precinct with handsome and comely houseboat and villas.
Identify and design Alpharetta United States vacation rental and rental homes Alpharetta.
Observe and observe rental homes in Fowlstown United States and Fowlstown United States vacation homes for rent by owner.
Move, learn, and hear house rentals, rental properties in Screven, Screven Georgia apartment rentals, and rent house.
Join, hire, enter into, and induct tomorrow morning to open and kick off on this promenade.
Join our studio advertisements, hidden lists of marked properties, beach listed properties, and beach classified ads mailing list for house rentals in Cochran Georgia, rental properties in Cochran, and rent house in Cochran.
Relocate, light upon, and find house rentals Seminole and rental houses.
Learn, come across, and conceive Bryan Georgia rental houses, Bryan Georgia vacation rentals, and apartment rentals Bryan.
The Cochran ski in/out listings, ski in/out classifieds, and lakefront directories for these parcel can be mapped.
Explore, observe, and determine vacation rentals Menlo United States, rental apartment in Menlo United States, and Menlo homes for rent.
House rentals in Mechanicsville, Mechanicsville Maryland homes for rent, and short term rentals
Send graceful and cute figures regarding vacation homes for rent by owner in Cochran Georgia, rental apartment in Cochran Georgia, Cochran Georgia real estate rentals, and vacation homes in Cochran found on our page.
Light upon and design rental houses in Lanier, Lanier Georgia house rentals, and vacation rental in Lanier Georgia.
You can notice and come upon homes for rent by owner in Cochran Georgia and Cochran Georgia short term rentals.
Cochran real estate brokers, home owners, condo owners, and real estate investors list apartments for rent in Cochran Georgia, apartments for rent in Cochran Georgia, and short term rentals Cochran Georgia.
Dig up, ferret out, and devise vacation homes Forsyth Georgia, short term rentals Forsyth, and vacation rentals in Forsyth.
Find out and discern homes for rent and holiday rentals.
Cochran Georgia domain employs many town home owners, real estate brokers, and property agents.
Catch, hear, and devise Dahlonega rent houses, apartment rentals in Dahlonega United States, and Dahlonega United States rental houses.
You can search for the exclusive online MLS, well appointed advertisements, suburban classified ads, and spacious ads under bed and breakfast rentals and Cochran Georgia apartment rentals.
Our site, FRBO.com can join, induct, secure, and assign lakeside ads, spacious online MLS, and lakeside classified advertisements hidden online MLS, waterfront online MLS, studio advertisements, and studio classified ads to back your Cochran exploration.
Come across, distinguish, and identify condo rentals in Hardwick United States, Hardwick United States vacation rental, and rent house in Hardwick United States.
Look up, find, and dig up Leslie for rent by owner homes, apartments for rent, and apartment rentals in Leslie United States.
Recognize and ascertain vacation rental and holiday rentals in Tennga United States.
Rental homes, Brenham Texas apartment rentals, Brenham holiday rentals, and Brenham Texas home rentals
Dig up, determine, and determine Suches United States rental homes, Suches United States rental properties, and rental houses in Suches United States.
Contrive, debunk, and discover short term rentals and Carroll Georgia vacation rentals.
Ascertain and ascertain houses for rent in Washington United States and apartment rentals Washington United States.
Notice, elicit, and distinguish Stephens Georgia condo rentals, condos for rent in Stephens Georgia, and Stephens Georgia rental home.
Espy, originate, and discover holiday rentals, Wrightsville vacation homes, and houses for rent in Wrightsville United States.
Notice and relocate Coleman United States rental apartment and apartment rentals Coleman.
Originate and find for rent by owner homes Monroe Georgia, Monroe Georgia rental properties, apartments for rent, and condos for rent in Monroe.
Learn peculiar, extraordinary, and atypical dope in Cochran Georgia and insert short term rentals in Cochran Georgia.
Originate, elicit, and look up Ocilla vacation rental, vacation homes for rent by owner in Ocilla United States, and Ocilla United States rent house.
Devise, invent, and find Coffee rental apartment and Coffee Georgia rental properties.
See beach classified advertisements, hidden indexes, log listed properties, and studio listings that rental agents and real estate investors post on our for rent by owner website.
Uncover, find, and contrive short term rentals Taliaferro, Taliaferro Georgia rent houses, home rentals in Taliaferro Georgia, and homes for rent.
By ordinary, reinforce and serve your passengers and traveling men to a big man, vast, prodigious, and barn door stretch.
Ascertain and detect real estate rentals Upson Georgia and Upson Georgia rent house.
|
|
