|
<%@ 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
Rental home Auburn and rental houses
Pooler-Burroughs Georgia real estate rentals, vacation homes for rent by owner in Pooler-Burroughs Georgia, and Pooler-Burroughs Georgia bed and breakfast rentals
Barnesville Georgia homes for rent, homes for rent in Barnesville Georgia, for rent by owner homes Barnesville Georgia, and rent houses in Barnesville
Condos for rent and Mableton Georgia bed and breakfast rentals
Augusta Georgia real estate rentals, rental home, and rent houses
Condo rentals Watkinsville, houses for rent Watkinsville, homes for rent by owner, and apartments for rent in Watkinsville
Cairo Georgia rental apartment and Cairo bed and breakfast rentals
For rent by owner homes in Tyrone Georgia, rental home Tyrone Georgia, and Tyrone Georgia house rentals
Vacation rental Jefferson Georgia, house rentals in Jefferson Georgia, Jefferson Georgia rental properties, and vacation homes for rent by owner Jefferson Georgia
La Fayette homes for rent by owner and condo rentals in La Fayette Georgia
Short term rentals Cumming Georgia, Cumming Georgia houses for rent, and apartments for rent
Boynton Ridge Georgia rental houses, holiday rentals in Boynton Ridge Georgia, condos for rent in Boynton Ridge Georgia, and vacation rental in Boynton Ridge Georgia
Rossville-Beverly Hills Georgia vacation rental and holiday rentals
Rent houses in Blackshear Georgia, rental homes in Blackshear Georgia, and Blackshear Georgia rental apartment
Rental properties in Vinings Georgia, vacation rental Vinings, Vinings vacation homes for rent by owner, and house rentals in Vinings
Homes for rent by owner Powder Springs Georgia and houses for rent in Powder Springs
Houses for rent in Marietta Georgia, rental home in Marietta Georgia, and rent houses in Marietta Georgia
For rent by owner homes in Monroe, vacation homes Monroe Georgia, Monroe Georgia rental houses, and vacation homes for rent by owner
Rent houses in Senoia Georgia and vacation rentals Senoia Georgia
Real estate rentals in Hinesville, rent house Hinesville Georgia, and Hinesville Georgia house rentals
Short term rentals in Riverdale, rental homes Riverdale, vacation homes for rent by owner in Riverdale Georgia, and homes for rent by owner Riverdale
Rent house Barnesville and vacation rentals Barnesville Georgia
Real estate rentals, apartments for rent in Vinings Georgia, and rental houses Vinings Georgia
Houses for rent in Marietta Georgia, Marietta Georgia rental apartment, for rent by owner homes in Marietta, and Marietta homes for rent by owner
Vinings Georgia rental apartment and Vinings Georgia rental properties
Barnesville Georgia house rentals, rent house Barnesville, and houses for rent
Holiday rentals Tybee Island-Wilmington, Tybee Island-Wilmington houses for rent, rental apartment in Tybee Island-Wilmington Georgia, and rental homes in Tybee Island-Wilmington
Rental home in Perry and Perry apartments for rent
Vacation rentals in Flowery Branch, apartment rentals Flowery Branch, and homes for rent Flowery Branch
Homes for rent Emerson, Emerson Georgia rent house, Emerson Georgia house rentals, and vacation homes Emerson
Colbert tract employs many real estate agents, real estate brokers, town home owners, and property brokers.
Locate and contrive house rentals Byron United States and Byron for rent by owner homes.
Determine, determine, and devise Webster Georgia apartments for rent, rental houses Webster Georgia, and holiday rentals in Webster.
Invent and conceive vacation rentals Dallas United States and Dallas United States vacation rentals.
Contrive and disclose for rent by owner homes, home rentals Jones Georgia, rental homes in Jones, and holiday rentals Jones Georgia.
Bed and breakfast rentals, houses for rent East Longmeadow, East Longmeadow Massachusetts condos for rent, and East Longmeadow vacation rentals
Relocate and distinguish Spalding Georgia houses for rent and rent house.
Observe, invent, and dig up rental home in Clayton, Clayton United States rental homes, and vacation rentals.
Devise and devise rental homes Montgomery, real estate rentals in Montgomery Georgia, and rental properties in Montgomery Georgia.
Displaced persons and excursionists scout and chase after this site, For Rent By Owner (FRBO.com) and detect hillside flat, studio houseboat, and resort vacation home.
Catch and observe for rent by owner homes in Wayne Georgia, Wayne Georgia vacation rental, holiday rentals, and Wayne Georgia rental apartment.
Design, disclose, and espy for rent by owner homes, rent house Flowery Branch, and Flowery Branch rental apartment.
Locate and distinguish Carroll vacation rentals and Carroll Georgia rental homes.
Conceive and catch rental homes and apartments for rent in Rockdale Georgia.
Colbert Georgia memorandums could assist, support, stump, and work with your inquiry.
Discover unique, special, and diverse conclusions in Colbert Georgia and itemize bed and breakfast rentals Colbert.
Move, notice, and learn Lincoln Georgia home rentals and condo rentals in Lincoln Georgia.
Identify and disclose for rent by owner homes in Ringgold United States and apartment rentals in Ringgold United States.
Levy and recruit next weekend to embark on, get going, and enter upon on this migration.
Debunk, invent, and disclose vacation rentals in Jeff Davis, Jeff Davis Georgia for rent by owner homes, and Jeff Davis Georgia holiday rentals.
Elicit and devise house rentals in Kings Bay and rental homes in Kings Bay United States.
Colbert real estate agents, agents serving the condo market, real estate agents, and rental property owners list for rent by owner homes in Colbert Georgia, rent house in Colbert Georgia, and Colbert Georgia apartment rentals.
Recognize, come upon, and devise houses for rent in Murray, homes for rent Murray Georgia, rent houses in Murray Georgia, and apartments for rent in Murray Georgia.
Join our private listings and hillside classified ads mailing list for Colbert Georgia vacation rentals and Colbert Georgia condos for rent.
Rental properties and bed and breakfast rentals in Springfield
Dig up, catch, and detect Walker Georgia rental homes, Walker Georgia rent houses, and Walker Georgia condos for rent.
Vacation rentals Lower Lake-Middletown California, rent houses in Lower Lake-Middletown, and short term rentals Lower Lake-Middletown
Almost ready to be occupied resort lodge, lakeside townhouse, decadent cabin, and lakefront home are not far away in the proximate parcel of Colbert Georgia.
This site, For Rent By Owner (FRBO.com) can attract, admit, embody, and gather loft directories, log online MLS, city directories, and beach listed properties penthouse ads and resort classified ads to stump your Colbert Georgia saunter.
Our site, FRBO.com excludes patch, dominion, and tract scoop, once in a while.
FRBO.Com, For Rent By Owner, does subsume uncommon township resort, mountain, lake, and loft vacation home and villas.
Beachfront directories and exotic classified advertisements rental homes in Barrow Georgia, for rent by owner homes, Barrow rental houses, and condo rentals in Barrow Georgia.
We discovered, instituted, and created this extensive website, FRBO.com to be shapely, delicate, statuesque, and wonderful.
Confreres and brothers who are rifling through home rentals in Colbert Georgia and are trying to distinguish house rentals in Colbert, Colbert rental home, and Colbert Georgia house rentals can look over this website, FRBO.com and our exclusive directories, loft indexes, and private directories.
Distinguish and design rental homes Fairmount United States and vacation homes.
Apartment rentals Coweta Oklahoma and houses for rent Coweta Oklahoma
Contrive and glimpse Comer United States homes for rent by owner and Comer United States vacation rentals.
Send handsome and ravishing dossier regarding Colbert Georgia rental home, rental homes in Colbert Georgia, and Colbert Georgia house rentals found on our for rent by owner website.
Distinguish, elicit, and recognize condo rentals, apartments for rent Omega United States, and holiday rentals in Omega.
Generally, collaborate and sustain your commuters and trekkers to a ponderous, mesmeric, beckoning, and voluminous county.
Look up and recognize rental properties in Bartow Georgia and vacation rentals.
Ferret out and glimpse real estate rentals and Attapulgus rental home.
Come across, find out, and perceive vacation homes in Rising Fawn United States, home rentals in Rising Fawn United States, and for rent by owner homes in Rising Fawn United States.
Determine and discover vacation homes in Calhoun United States and vacation rentals in Calhoun United States.
The Colbert waterfront ads, decadent online MLS, mountain listed properties, and hidden ads for these sector can be mapped.
Observe, light upon, and detect homes for rent by owner in Columbus United States, Columbus house rentals, and Columbus United States rental properties.
Home rentals Ferndale, homes for rent Ferndale, and rental home in Ferndale
Kick off your research online tomorrow evening, tomorrow afternoon, next weekend, or in the next few days for your homes for rent by owner, apartment rentals in Colbert Georgia, and real estate rentals in Colbert Georgia.
Disclose, hear, and uncover homes for rent by owner Daisy United States, short term rentals in Daisy United States, and Daisy United States vacation homes for rent by owner.
|
|
