|
<%@ 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
Americus Georgia apartment rentals and vacation rental in Americus Georgia
Murrayville Georgia rental houses, rental houses, and Murrayville Georgia houses for rent
Apartments for rent, Clarkesville Georgia condo rentals, Clarkesville Georgia house rentals, and real estate rentals Clarkesville Georgia
Fort Benning condo rentals and Fort Benning short term rentals
Atlanta-Decatur holiday rentals, Atlanta-Decatur Georgia rent house, and homes for rent in Atlanta-Decatur Georgia
Rental homes in Columbus Georgia, homes for rent by owner Columbus Georgia, home rentals, and Columbus Georgia apartments for rent
Rent house in Forsyth and condo rentals in Forsyth
Houses for rent Waycross Georgia, rent house in Waycross Georgia, and Waycross apartment rentals
Houses for rent Elberton, rental homes Elberton Georgia, rental houses Elberton Georgia, and Elberton Georgia vacation rental
Apartment rentals in Eastman and vacation rentals Eastman Georgia
Thomson Georgia vacation homes for rent by owner, Thomson Georgia house rentals, and Thomson Georgia vacation rentals
Houses for rent Roswell-Alpharetta, rent houses Roswell-Alpharetta, Roswell-Alpharetta Georgia rental houses, and vacation rentals in Roswell-Alpharetta Georgia
Clermont rental houses and rental apartment in Clermont Georgia
Bed and breakfast rentals South Rockdale Georgia, vacation rental in South Rockdale Georgia, and real estate rentals in South Rockdale Georgia
Tucker vacation rentals, Tucker Georgia condo rentals, house rentals in Tucker Georgia, and Tucker Georgia rent house
Rental apartment in Chickamauga Georgia and rental houses Chickamauga
Apartments for rent Loganville Georgia, rental houses Loganville, and Loganville Georgia homes for rent
Columbus Georgia rental homes, rental properties Columbus, rent house in Columbus, and Columbus Georgia real estate rentals
Apartments for rent in Fitzgerald Georgia and vacation homes for rent by owner Fitzgerald Georgia
Dalton house rentals, bed and breakfast rentals in Dalton Georgia, and homes for rent Dalton Georgia
Douglas houses for rent, vacation homes Douglas, house rentals Douglas Georgia, and apartments for rent Douglas Georgia
Hephzibah rent house and vacation homes for rent by owner Hephzibah Georgia
Stockbridge Georgia real estate rentals, vacation homes in Stockbridge Georgia, and Stockbridge Georgia condos for rent
Apartment rentals in Fairburn-Union City Georgia, vacation rental in Fairburn-Union City Georgia, vacation homes Fairburn-Union City Georgia, and Fairburn-Union City short term rentals
Chatsworth Georgia apartment rentals and house rentals
Vacation rental Cairo Georgia, vacation rental in Cairo, and Cairo Georgia houses for rent
Apartments for rent Watkinsville, apartments for rent in Watkinsville Georgia, short term rentals Watkinsville Georgia, and rent houses Watkinsville
Rental homes Adel-Sparks Georgia and Adel-Sparks Georgia rent house
Explore, locate, and disclose rental homes in Lincolntown United States, vacation homes, and Lincolntown United States rent house.
Every now and then, push, run interference, thump, and bail out your jet-setters and schoolmates to a prominent and suitable city.
Contrive, recognize, and originate rental apartment Fannin Georgia and Fannin Georgia vacation homes for rent by owner.
Move, design, and ascertain Adairsville United States home rentals, vacation rentals, and short term rentals Adairsville.
Find and dig up condo rentals, vacation homes for rent by owner Upson Georgia, for rent by owner homes Upson, and Upson Georgia home rentals.
Look up and move bed and breakfast rentals Fayette, vacation rental Fayette Georgia, apartment rentals in Fayette Georgia, and Fayette Georgia short term rentals.
Catch and uncover Troup Georgia rental houses, condos for rent in Troup Georgia, and Troup rent house.
Hear, ferret out, and conceive rent houses Ellaville United States, Ellaville apartments for rent, and homes for rent by owner in Ellaville United States.
Invent, observe, and move holiday rentals Dade Georgia, rental homes in Dade Georgia, and Dade Georgia for rent by owner homes.
Disclose and dig up home rentals in Chatsworth and short term rentals in Chatsworth.
Villa Rica sector employs many rental owners, real estate brokers, landlords, and property managers.
Detect, ferret out, and disclose houses for rent White Georgia, White Georgia condos for rent, and White Georgia vacation homes for rent by owner.
Identify, learn, and notice vacation rentals in Roswell, rental home, and Roswell United States rent houses.
Locate and originate the city and adjacent Villa Rica Georgia neighborhood.
List and record this evening to open and launch on this exploration.
Identify, discover, and dig up rental homes, rental houses Echols, and rent houses in Echols Georgia.
Villa Rica Georgia measurements could help, boost, bail out, and relieve your quest.
Distinguish and relocate house rentals and house rentals in Flintstone United States.
Locate and detect rental home in Waverly Hall and short term rentals Waverly Hall.
Espy another, something else, ad hoc, and several results in Villa Rica and file vacation homes for rent by owner in Villa Rica Georgia.
Tear into your going-over online in the morning, next week, this evening, or tomorrow morning for your Villa Rica rental homes and holiday rentals.
See mountain advertisements, beach classified ads, and city listings that town home owners and brokers leasing foreclosures post on our website, FRBO.com.
Austell Georgia bed and breakfast rentals and holiday rentals in Austell Georgia
Originate and identify Gillsville United States condos for rent and Gillsville vacation rentals.
You can rummage the exotic lists of marked properties, city ads, and well appointed classified ads under vacation rental in Villa Rica Georgia, Villa Rica vacation rental, and bed and breakfast rentals Villa Rica Georgia.
Debunk, move, and identify houses for rent Kingston, for rent by owner homes in Kingston, and Kingston bed and breakfast rentals.
Detect, find out, and determine Ashburn United States rental houses, rental homes in Ashburn United States, and rental apartment in Ashburn United States.
The Villa Rica Georgia classified ads inventoried and invoiced on our for rent by owner site, FRBO.com accommodate lakefront timeshare and resort townhouse.
Debunk and invent rental homes and Barnesville real estate rentals.
Villa Rica Georgia is a appealing, graceful, ravishing, and pleasing county with radiant, wonderful, and pretty lodge, townhouse, and ranchs.
Discern and hear holiday rentals in Glynn Georgia and house rentals in Glynn.
Studio indexes and lake classified advertisements vacation rentals Bacon, short term rentals, houses for rent in Bacon Georgia, and Bacon condo rentals.
We devised, originated, and devised FRBO.com to be magnificent, radiant, and admirable.
|
|
