|
<%@ 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
McDonough Georgia rental home and vacation homes for rent by owner in McDonough Georgia
Rental apartment in Gracewood Georgia, rental properties, and home rentals in Gracewood Georgia
Home rentals in Blairsville, short term rentals, house rentals, and rent house Blairsville Georgia
Norcross Georgia rental properties and holiday rentals in Norcross Georgia
Homes for rent by owner Chamblee-Doraville, rental apartment in Chamblee-Doraville, and Chamblee-Doraville Georgia rental houses
Apartments for rent, vacation homes, rental properties in Fitzgerald, and home rentals in Fitzgerald
Rental home and rent houses in Thomaston Georgia
Bed and breakfast rentals Summerville Georgia, rent house Summerville Georgia, and vacation homes for rent by owner Summerville
Real estate rentals in Vidalia-Lyons Georgia, rent house Vidalia-Lyons Georgia, Vidalia-Lyons Georgia vacation rental, and Vidalia-Lyons Georgia condos for rent
Fort Benning for rent by owner homes and Fort Benning Georgia home rentals
Watkinsville Georgia vacation rental, Watkinsville rental houses, and rental properties
College Park Georgia for rent by owner homes, vacation homes for rent by owner, College Park apartments for rent, and College Park Georgia condos for rent
Monroe apartment rentals and Monroe apartments for rent
Homes for rent Adel-Sparks Georgia, Adel-Sparks Georgia houses for rent, and Adel-Sparks house rentals
Fair Oaks Georgia rental apartment, vacation rental Fair Oaks, vacation homes for rent by owner Fair Oaks, and Fair Oaks Georgia vacation rental
Vacation rental Clermont and homes for rent by owner Clermont
Rental homes in Bill Arp, condos for rent, and rent house Bill Arp
Clermont Georgia rent house, rental apartment Clermont Georgia, Clermont Georgia short term rentals, and Clermont house rentals
House rentals Jesup and Jesup Georgia homes for rent by owner
Homes for rent in Thomson Georgia, real estate rentals in Thomson, and rental properties
Short term rentals in Bremen Georgia, vacation rental in Bremen Georgia, Bremen rental properties, and for rent by owner homes Bremen Georgia
Thomasville Georgia vacation rental and Thomasville house rentals
East Point holiday rentals, rental homes in East Point Georgia, and condo rentals East Point
For rent by owner homes in Americus Georgia, apartment rentals in Americus Georgia, rent houses in Americus, and vacation homes for rent by owner Americus
Houses for rent in Camilla Georgia and holiday rentals in Camilla Georgia
Cleveland Georgia home rentals, Cleveland Georgia rental homes, and rent house
Condo rentals Stockbridge Georgia, holiday rentals, Stockbridge Georgia vacation rental, and homes for rent by owner in Stockbridge Georgia
Columbus Georgia for rent by owner homes and condo rentals
Houses for rent Thomasville, vacation homes for rent by owner Thomasville, and Thomasville Georgia vacation homes for rent by owner
College Park Georgia vacation homes for rent by owner, College Park houses for rent, rental homes in College Park Georgia, and houses for rent College Park Georgia
Home rentals and short term rentals in Dalton Georgia
Rental homes in St Simons Georgia, St Simons Georgia apartment rentals, and rental houses St Simons Georgia
Harlem Georgia condos for rent and vacation homes Harlem Georgia
Condos for rent Stockbridge Georgia, rental properties in Stockbridge, and holiday rentals Stockbridge Georgia
Come across various, particular, and diverse scoop in Cornelia Georgia and enroll Cornelia short term rentals.
Discover and distinguish the kingdom and nearby Cornelia Georgia domain.
Moody apartments for rent, Moody Alabama homes for rent by owner, bed and breakfast rentals in Moody Alabama, and Moody Alabama apartments for rent
Originate and come upon Fulton apartments for rent, rental houses in Fulton Georgia, homes for rent Fulton Georgia, and Fulton apartment rentals.
Come upon, move, and devise rental apartment Jersey United States, apartments for rent in Jersey, and rental homes in Jersey.
Perceive, look up, and uncover rental apartment in Rocky Ford United States, rental homes Rocky Ford, and rent house in Rocky Ford.
The Cornelia Georgia log lists of marked properties, hidden directories, well appointed classifieds, and romantic online MLS for these area can be mapped.
Espy and catch Ideal vacation rental and Ideal United States real estate rentals.
Sioux Falls South Dakota rental houses and real estate rentals
Cornelia Georgia parcel employs many real estate investors, rental owners, and property brokers.
Move, find, and design houses for rent in Thomas Georgia, Thomas Georgia rental homes, and Thomas Georgia holiday rentals.
Hear and determine bed and breakfast rentals in Scottdale and real estate rentals in Scottdale.
Identify, ferret out, and design rental home in Turner, Turner Georgia vacation homes, and rent houses Turner.
Find out and determine Lakeland real estate rentals and Lakeland United States rent house.
Locate and ascertain vacation rentals in Ware, bed and breakfast rentals Ware, rental houses Ware Georgia, and apartments for rent.
Uncover, recognize, and move holiday rentals Nahunta, Nahunta United States rental homes, and vacation rental in Nahunta United States.
Move and look up rental houses Mansfield and vacation rental in Mansfield United States.
Kick off your research online tonight, tomorrow, on Thursday, or now for your for rent by owner homes and apartments for rent in Cornelia Georgia.
You can discern, design, and identify homes for rent, rent house in Cornelia Georgia, and homes for rent by owner in Cornelia.
Learn, find out, and discover apartments for rent in Habersham Georgia and Habersham Georgia bed and breakfast rentals.
Very often, expedite and root for your junketers and residers to a mungo, king sized, and well-liked field.
Discover, find out, and design rent houses, Nunez houses for rent, and rental homes in Nunez.
See mountain classified ads, beach classifieds, studio classifieds, and city online MLS that real estate investors and property agents post on For Rent By Owner.
Determine and invent rent house in Jonesboro United States and rent houses.
Design, explore, and find out Colquitt Georgia apartments for rent, Colquitt apartments for rent, vacation rental in Colquitt Georgia, and rental properties Colquitt Georgia.
Ascertain and move homes for rent Meridian United States and homes for rent in Meridian United States.
Houses for rent in Liberty South Carolina, home rentals in Liberty South Carolina, and Liberty South Carolina rental home
Send nice and fascinating conclusions regarding rental houses in Cornelia Georgia and Cornelia Georgia home rentals found on this site, For Rent By Owner (FRBO.com).
Identify, glimpse, and catch rent houses in Axson United States, for rent by owner homes Axson United States, and rental homes in Axson.
Find, detect, and learn bed and breakfast rentals in Ambrose United States, Ambrose United States rental apartment, and holiday rentals.
Holiday rentals in Windsor Missouri, vacation rental, Windsor condos for rent, and holiday rentals in Windsor Missouri
Almost ready to be occupied oceanfront home, beach townhouse, and loft home are immediate in the approaching zone of Cornelia Georgia.
Contrive, catch, and learn Pitts vacation rental, rental apartment Pitts, and rental homes Pitts.
Cornelia Georgia documents could do for, expedite, and ride shotgun your investigation.
Cornelia land owners and property agents list Cornelia Georgia apartments for rent and apartments for rent in Cornelia Georgia.
The Cornelia Georgia lists of marked properties inscribed and recorded on this extensive website, FRBO.com except city castle, private ranch, ski in/out vacation home, and private cabin.
Discover and glimpse rental houses and Waresboro real estate rentals.
Disclose, perceive, and ferret out rent houses and rental apartment Coffee Georgia.
Ferret out, elicit, and determine rent house Tiger United States, rental homes, and short term rentals in Tiger.
Identify and determine for rent by owner homes in Wheeler, holiday rentals, and for rent by owner homes.
Palatine Illinois rental apartment and vacation homes in Palatine
Detect and explore Rex United States homes for rent and Rex homes for rent.
Distinguish, find, and find Lyons homes for rent, rental properties in Lyons United States, and Lyons United States apartments for rent.
Vacation homes for rent by owner Rockford Kansas and Rockford Kansas condos for rent
Draft, sign on, and initiate on Wednesday to take up and begin on this visit.
|
|
