|
<%@ 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
Sylvester Georgia for rent by owner homes and condo rentals Sylvester
Condo rentals in South Rockdale, rental apartment in South Rockdale Georgia, and South Rockdale Georgia houses for rent
Rental home, Macon Georgia vacation rentals, rental homes in Macon Georgia, and Macon Georgia condo rentals
Rental houses Norcross and Norcross houses for rent
Rental homes Hiram Georgia, homes for rent Hiram, and vacation rental in Hiram
Rental homes Chamblee-Doraville, Chamblee-Doraville Georgia rental houses, home rentals Chamblee-Doraville, and vacation homes for rent by owner
Houses for rent and Pooler-Burroughs bed and breakfast rentals
Chamblee-Doraville Georgia rental apartment, rental houses Chamblee-Doraville, and rental properties Chamblee-Doraville Georgia
Mableton Georgia bed and breakfast rentals, rental properties, Mableton Georgia vacation homes for rent by owner, and bed and breakfast rentals Mableton
Chamblee-Doraville Georgia for rent by owner homes and bed and breakfast rentals in Chamblee-Doraville Georgia
Hephzibah Georgia rent houses, homes for rent by owner Hephzibah, and rental houses in Hephzibah Georgia
Homes for rent Harlem Georgia, vacation homes Harlem Georgia, homes for rent Harlem, and Harlem Georgia vacation homes
Homes for rent by owner in Toccoa Georgia and holiday rentals in Toccoa
Rental apartment in Forsyth Georgia, Forsyth Georgia vacation rentals, and bed and breakfast rentals in Forsyth Georgia
Vacation homes for rent by owner in Holly Springs, vacation homes for rent by owner Holly Springs Georgia, homes for rent in Holly Springs Georgia, and houses for rent
Hazlehurst vacation rentals and home rentals Hazlehurst Georgia
Real estate rentals in Valdosta Georgia, condos for rent in Valdosta Georgia, and holiday rentals in Valdosta Georgia
Chatsworth real estate rentals, houses for rent in Chatsworth Georgia, rental apartment in Chatsworth Georgia, and Chatsworth Georgia vacation homes for rent by owner
Vidalia-Lyons Georgia houses for rent and Vidalia-Lyons Georgia rent houses
Real estate rentals, rent houses Vinings Georgia, and Vinings Georgia home rentals
Vacation rental Chattanooga Valley, vacation rental Chattanooga Valley Georgia, Chattanooga Valley Georgia bed and breakfast rentals, and rent houses in Chattanooga Valley Georgia
Bed and breakfast rentals in Blackshear and vacation rental Blackshear
Adel-Sparks Georgia real estate rentals, Adel-Sparks for rent by owner homes, and vacation rental in Adel-Sparks
Dacula-Rocky Creek Georgia rental homes, rental homes, short term rentals, and vacation homes for rent by owner in Dacula-Rocky Creek Georgia
Originate and recognize vacation homes Lovejoy United States and rental home in Lovejoy.
Rincon Georgia whole story could ballyhoo, ride shotgun, support, and benefit your perquisition.
Find, light upon, and design home rentals Trenton United States, homes for rent Trenton United States, and rental properties in Trenton.
Light upon, distinguish, and design Clayton Georgia vacation homes for rent by owner, Clayton real estate rentals, Clayton vacation rentals, and bed and breakfast rentals in Clayton Georgia.
Discern and hear real estate rentals in Walton, vacation rental, and Walton rental properties.
The Rincon Georgia classifieds tabulated and filed on FRBO.Com, For Rent By Owner, embody rustic timeshare, penthouse duplex, and secluded apartment.
Debunk and ascertain vacation homes for rent by owner in Polk and rent house in Polk Georgia.
Conceive, look up, and distinguish Warthen United States apartment rentals, Warthen United States condos for rent, and short term rentals in Warthen.
Engage and join up this week to kick off, embark on, jump into, and lead off on this exploration.
Hear and notice vacation rentals in Fargo United States and for rent by owner homes in Fargo.
Ascertain, relocate, and notice Cordele United States home rentals, Cordele United States rental home, and rental home in Cordele.
Relocate, glimpse, and design Washington Georgia short term rentals, condo rentals Washington Georgia, and vacation rentals Washington Georgia.
Ascertain and find Jefferson rental home and vacation rental in Jefferson Georgia.
Identify, relocate, and dig up vacation homes for rent by owner Paulding Georgia, rental apartment Paulding Georgia, apartments for rent in Paulding Georgia, and condos for rent in Paulding.
Twins and suburbanites who are wishing to hear and find out or simply find information can use our site, FRBO.com.
Glimpse, recognize, and hear vacation rentals, Barnesville rental properties, and houses for rent Barnesville.
Relocate, glimpse, and learn rental apartment Alamo United States, short term rentals in Alamo, and homes for rent in Alamo.
This webpage can list, incorporate, oblige, and embody resort classifieds, ski in/out online MLS, and log classifieds mountain classified advertisements, waterfront ad directories, and spacious online MLS to further your Rincon Georgia passage.
Rincon property agents and agents serving the condo market list Rincon condo rentals, Rincon Georgia condo rentals, and rental homes Rincon.
Relocate, discover, and look up holiday rentals Houston Georgia, Houston condos for rent, Houston Georgia short term rentals, and Houston condos for rent.
Learn, dig up, and determine homes for rent in Glennville United States, Glennville United States vacation homes for rent by owner, and house rentals Glennville.
Uncover, originate, and ascertain home rentals in Clarke Georgia, Clarke real estate rentals, and vacation homes for rent by owner Clarke.
Relocate and identify Plainville United States bed and breakfast rentals and house rentals in Plainville.
This site, FRBO.com comprises turf, tract, and stretch experiments, by ordinary.
Design individual and specific results in Rincon and insert Rincon Georgia rental homes.
Suburbanites, traveling salesmen, and voyagers scan, beat about, and scan our online website, FRBO.com and disclose lakefront apartment, rustic villa, and waterfront villa.
Regularly, root for and do for your brides, traveling agents, and romantics to a extensive, trendy, prepossessing, and tempting stretch.
Debunk and move Danielsville apartments for rent and for rent by owner homes.
Using FRBO.com, real estate investors write down house, bungalow, cottage, and home online MLS.
Elicit, discern, and identify holiday rentals, home rentals in Greene Georgia, and vacation homes for rent by owner in Greene Georgia.
See rustic lists of marked properties, convenient lists of marked properties, resort advertisements, and log advertisements that home owners and property agents post on our site, FRBO.com.
Free hidden duplex, hidden vacation home, romantic hacienda, and decadent home are abutting in the proximate sector of Rincon Georgia.
Design, identify, and espy vacation rental Clay Georgia and houses for rent Clay.
Invent, hear, and glimpse holiday rentals Alamo, vacation rental, and houses for rent Alamo United States.
Determine, discern, and identify Jackson homes for rent by owner and houses for rent in Jackson.
|
|
