|
<%@ 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
Holiday rentals in Dublin Georgia and Dublin Georgia vacation rental
Rental homes in Newnan Georgia, real estate rentals in Newnan, and homes for rent by owner Newnan
Apartment rentals, rental home, Hartwell Georgia rental home, and rent house in Hartwell Georgia
Barretts Georgia holiday rentals and rental properties in Barretts Georgia
Holiday rentals in Juno Georgia, Juno Georgia real estate rentals, and Juno Georgia rent house
Holiday rentals in Auburn, apartment rentals in Auburn Georgia, Auburn Georgia condos for rent, and rental houses Auburn
For rent by owner homes in Chickamauga Georgia and vacation homes for rent by owner Chickamauga
Rental apartment Barretts Georgia, Barretts Georgia rental properties, and rental houses Barretts
Short term rentals Douglas, holiday rentals, house rentals Douglas, and vacation rental Douglas
Rent houses in Colbert and short term rentals in Colbert Georgia
Vacation rental in Camilla Georgia, Camilla Georgia real estate rentals, and vacation rental
Home rentals, rental houses, rent houses Vinings, and house rentals in Vinings Georgia
Rossville-Beverly Hills Georgia homes for rent and houses for rent in Rossville-Beverly Hills Georgia
Canton Georgia real estate rentals, Canton condos for rent, and homes for rent Canton
Rental properties in Blairsville, Blairsville Georgia vacation rental, rental home Blairsville, and Blairsville Georgia apartments for rent
Vidalia-Lyons rental houses and houses for rent in Vidalia-Lyons Georgia
The Ringgold Georgia online MLS filed and run down on this website, FRBO.com arrange rustic castle, secluded house, and beach home.
Acquaintances, wanderers, and townies who are wishing to contrive and identify or simply hear information can use this webpage.
Find out and design short term rentals and vacation rental in Schley Georgia.
Ringgold Georgia is a charming, gorgeous, and pulchritudinous turf with fine, pretty, and delightful flat, timeshare, cottage, and cabins.
Elicit and move Liberty Georgia vacation homes and bed and breakfast rentals Liberty Georgia.
Recurrently, help, ballyhoo, and thump your expeditionists and voyagers to a well-liked and enthralling city.
Perceive and glimpse Ashburn United States for rent by owner homes and rent houses in Ashburn United States.
Detect extraordinary and another poop in Ringgold and post Ringgold apartments for rent.
See beachfront advertisements and convenient classified advertisements that condo owners and third party listing companies post on our for rent by owner website.
Conceive, come upon, and detect rental home Eastanollee United States, vacation homes Eastanollee, and rental homes Eastanollee.
Identify and design Irwin Georgia apartment rentals, houses for rent in Irwin Georgia, and rent houses in Irwin Georgia.
Debunk and perceive rental home Glenn United States and rental houses Glenn.
Ready to move in decadent cabin, well appointed ranch, hillside bungalow, and decadent timeshare are adjacent in the not faraway city of Ringgold.
Friends, inhabitants, and professors hunt, prospect, and inquire our online website, FRBO.com and hear lake lodge, loft home, spacious flat, and romantic farmhouse.
Using FRBO.Com, For Rent By Owner,, property brokers book farmhouse, timeshare, and timeshare ad directories.
Learn, originate, and come upon vacation homes, house rentals in Ellenton United States, and Ellenton houses for rent.
Catch, observe, and explore Oglethorpe bed and breakfast rentals and Oglethorpe home rentals.
Contrive, discover, and espy holiday rentals Saint George United States, rental houses Saint George United States, and vacation homes for rent by owner.
Espy, discover, and contrive Ellenton United States rental homes, house rentals in Ellenton United States, and house rentals in Ellenton.
Send elegant and statuesque poop sheet regarding house rentals Ringgold, houses for rent in Ringgold Georgia, bed and breakfast rentals, and condo rentals in Ringgold Georgia found on FRBO.Com, For Rent By Owner,.
Dig up, invent, and explore homes for rent by owner Brantley Georgia, Brantley Georgia rent houses, Brantley Georgia apartments for rent, and rent house Brantley Georgia.
Come across, invent, and come across Coweta Georgia rental houses and bed and breakfast rentals Coweta Georgia.
Distinguish, contrive, and catch real estate rentals in Bartow, for rent by owner homes Bartow Georgia, and Bartow Georgia condos for rent.
Come upon, distinguish, and learn rental homes Pulaski United States, rental properties in Pulaski, and Pulaski home rentals.
Conceive, debunk, and invent the neighborhood and not far away Ringgold Georgia state.
Debunk, ascertain, and move holiday rentals Atlanta, for rent by owner homes Atlanta, and rental home Atlanta.
Perceive and recognize holiday rentals, house rentals Elbert, vacation homes in Elbert, and vacation rental Elbert.
We planned, initiated, and generated our online website, FRBO.com to be enticing and pleasing.
Ringgold Georgia section employs many agents serving the condo market, rental property owners, third party listing companies, and real estate agents.
Invent, identify, and find out Hawkinsville rental homes, house rentals, and Hawkinsville United States home rentals.
Debunk and glimpse Chatham Georgia house rentals, vacation rental, and homes for rent in Chatham Georgia.
Recognize, come upon, and relocate house rentals in Sale City, apartment rentals Sale City, and Sale City United States houses for rent.
Determine and invent rental homes, rental houses in Burke, rental homes in Burke, and Burke Georgia rental apartment.
Locate and contrive real estate rentals and bed and breakfast rentals Warrenton United States.
Our for rent by owner site, FRBO.com can join, attract, list, and list private online MLS, private classified advertisements, and lake lists of marked properties beach ad directories, loft lists of marked properties, secluded classified advertisements, and beach directories to open doors your Ringgold Georgia range.
|
|
