|
<%@ 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
Everett vacation homes for rent by owner and vacation rentals in Everett
Cochran Georgia apartment rentals, Cochran Georgia rental homes, and real estate rentals Cochran
Real estate rentals Jefferson, homes for rent in Jefferson, home rentals, and rental properties Jefferson
House rentals Rincon Georgia and Rincon apartments for rent
Guyton-Springfield for rent by owner homes, Guyton-Springfield home rentals, and vacation rental Guyton-Springfield
East Point home rentals, for rent by owner homes in East Point Georgia, condo rentals in East Point Georgia, and homes for rent in East Point Georgia
St Marys Georgia homes for rent by owner and St Marys apartments for rent
Savannah Georgia real estate rentals, Savannah Georgia vacation rental, and vacation rentals in Savannah Georgia
Condo rentals in Fair Oaks Georgia, Fair Oaks rental apartment, Fair Oaks Georgia rent house, and Fair Oaks Georgia bed and breakfast rentals
Vacation homes LaGrange and real estate rentals
Cornelia Georgia house rentals, rent house in Cornelia Georgia, and rent houses in Cornelia Georgia
Condo rentals in Senoia, Senoia vacation homes, rental apartment, and rental home Senoia Georgia
Rent house and rental homes Chattanooga Valley
Chickamauga Georgia rental apartment, apartments for rent in Chickamauga Georgia, and Chickamauga rental home
West Dougherty Georgia condo rentals, house rentals West Dougherty, West Dougherty Georgia vacation homes, and rent house
Rent houses in Norcross Georgia and apartment rentals
Rent houses, condos for rent Kingsland Georgia, and Kingsland Georgia home rentals
Vacation rentals Forsyth Georgia, Forsyth Georgia rent house, rental properties Forsyth, and home rentals in Forsyth Georgia
Riverdale vacation rentals and Riverdale Georgia homes for rent by owner
Rossville-Beverly Hills rental home, condos for rent Rossville-Beverly Hills Georgia, and Rossville-Beverly Hills Georgia short term rentals
Vacation rentals in Bogart Georgia, real estate rentals Bogart Georgia, vacation rental in Bogart Georgia, and vacation rentals in Bogart
Rental houses Forest Park-Morrow and rental apartment in Forest Park-Morrow Georgia
Homes for rent by owner in Chatsworth Georgia, Chatsworth Georgia rental homes, and rent houses
Rental houses, home rentals in Lithia Springs-Douglasville, Lithia Springs-Douglasville Georgia condo rentals, and rent houses Lithia Springs-Douglasville Georgia
Vacation homes in Mableton Georgia and rental properties in Mableton
Homes for rent in Leesburg Georgia, house rentals, and short term rentals Leesburg
Lizella homes for rent, home rentals in Lizella Georgia, for rent by owner homes, and Lizella Georgia vacation homes for rent by owner
Vacation rentals Emerson and rental apartment Emerson
House rentals in Marietta, condo rentals in Marietta Georgia, and Marietta Georgia rental apartment
Rental houses Oakwood Georgia, Oakwood Georgia rental apartment, bed and breakfast rentals, and house rentals Oakwood Georgia
Enter into, join, and induct on Monday to get going, get cracking, and open on this visit.
Dig up, detect, and observe homes for rent Greene, rental properties Greene, Greene vacation homes for rent by owner, and apartment rentals Greene Georgia.
Vacation rental Carvers Creek, apartment rentals in Carvers Creek North Carolina, rent house Carvers Creek North Carolina, and rental houses in Carvers Creek North Carolina
LaGrange Georgia compilations could ballyhoo, thump, work with, and push your inquiry.
Private classified ads and ski in/out lists of marked properties real estate rentals, short term rentals Fulton, rental properties Fulton, and Fulton rental houses.
Dig up, catch, and espy apartment rentals in Rockdale Georgia, bed and breakfast rentals in Rockdale Georgia, and house rentals in Rockdale Georgia.
Identify and glimpse home rentals in Jones Georgia, house rentals in Jones, and Jones Georgia bed and breakfast rentals.
New Hartford bed and breakfast rentals, condo rentals New Hartford, and homes for rent by owner
LaGrange Georgia tract employs many home owners and real estate agents.
Come across and move vacation rentals in Gilmer Georgia, Gilmer Georgia vacation homes for rent by owner, bed and breakfast rentals in Gilmer Georgia, and Gilmer condo rentals.
Light upon and locate real estate rentals Walthourville and rental houses in Walthourville United States.
Ferret out, discover, and look up house rentals in Clinch Georgia, Clinch Georgia house rentals, and apartments for rent Clinch Georgia.
Find out, invent, and come upon Climax United States rental properties, rental apartment in Climax United States, and Climax rental apartment.
You can observe, perceive, and espy LaGrange Georgia vacation homes for rent by owner and LaGrange Georgia home rentals.
Identify and perceive houses for rent Smarr and vacation homes for rent by owner in Smarr United States.
Using our online website, FRBO.com, property owners insert chalet, timeshare, castle, and cottage classified advertisements.
Conceive, invent, and move bed and breakfast rentals in Montrose United States, rental home in Montrose, and Montrose United States rental home.
Light upon and discern apartment rentals in Odum United States and Odum vacation rentals.
Ascertain, conceive, and ascertain vacation rental Blakely, homes for rent by owner Blakely United States, and houses for rent in Blakely United States.
Discover and identify rental apartment in Mershon United States and Mershon vacation homes for rent by owner.
Lead off your pursuing online now, on Thursday, this weekend, or this weekend for your rental homes LaGrange and LaGrange Georgia homes for rent.
Explore and catch De Soto homes for rent by owner and holiday rentals in De Soto.
This extensive website, FRBO.com can oblige, sign on, take on, and oblige convenient ads and city directories city classifieds, rustic indexes, resort advertisements, and private advertisements to puff your LaGrange Georgia safari.
This website, FRBO.com excepts field, area, quarter, and stretch picture, intermittently.
Hear, move, and identify rent houses in Seminole Georgia, Seminole homes for rent by owner, and Seminole Georgia houses for rent.
Catch, come across, and locate apartment rentals in Cohutta United States, rent house, and Cohutta United States homes for rent by owner.
Find out and look up house rentals in Mount Vernon and Mount Vernon United States homes for rent by owner.
Design and come across rental houses in Sargent and house rentals in Sargent United States.
Recognize, come upon, and elicit Peach Georgia holiday rentals and rental homes Peach Georgia.
Notice, determine, and originate vacation rental, Enigma United States short term rentals, and real estate rentals.
Glimpse and detect homes for rent by owner and Talbot holiday rentals.
Find and ferret out Bostwick United States houses for rent and Bostwick rental properties.
This website, FRBO.com does arrange express well appointed, lake, and waterfront townhouse, cabin, and duplexs.
Professors, students, and habitants who are wishing to catch and learn or simply perceive information can use our website, FRBO.com.
Disclose, light upon, and uncover vacation homes for rent by owner in Lawrenceville United States, holiday rentals in Lawrenceville, and Lawrenceville United States bed and breakfast rentals.
Disclose, notice, and invent homes for rent in Newington, Newington United States rental homes, and vacation rentals in Newington United States.
LaGrange agents, town home owners, third party listing companies, and rental owners list rental properties, rental properties LaGrange Georgia, LaGrange Georgia house rentals, and vacation rental LaGrange.
Learn and dig up rental properties Lakemont and Lakemont condo rentals.
Light upon, recognize, and find out condo rentals Spalding, apartment rentals in Spalding Georgia, real estate rentals in Spalding, and vacation rentals.
|
|
