|
<%@ 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 properties in Newnan Georgia and Newnan Georgia rental apartment
Bed and breakfast rentals in Carrollton Georgia, Carrollton Georgia vacation rental, and Carrollton holiday rentals
Lawrenceville Georgia houses for rent, homes for rent by owner in Lawrenceville Georgia, homes for rent, and rental homes
Juno Georgia home rentals and Juno Georgia home rentals
Apartments for rent in Stone Mountain, homes for rent by owner, and vacation rental in Stone Mountain
Monroe vacation rentals, Monroe houses for rent, rental apartment Monroe, and Monroe condos for rent
Fort Valley for rent by owner homes and real estate rentals Fort Valley Georgia
Condos for rent in Murrayville Georgia, vacation homes for rent by owner in Murrayville Georgia, and homes for rent
Rental home, St Simons Georgia vacation homes, rental homes in St Simons Georgia, and rental houses in St Simons Georgia
Vacation rentals Cordele and vacation rentals Cordele Georgia
Homes for rent Perry, homes for rent by owner, and home rentals in Perry
Holiday rentals LaGrange, holiday rentals LaGrange, homes for rent in LaGrange Georgia, and LaGrange rental home
Holly Springs Georgia house rentals and Holly Springs Georgia holiday rentals
Rental apartment Gainesville, holiday rentals in Gainesville, and vacation rental
Condo rentals in Clermont, Clermont rental properties, rent houses in Clermont Georgia, and condos for rent in Clermont Georgia
For rent by owner homes Fort Benning Georgia and house rentals in Fort Benning Georgia
Apartment rentals Cornelia, rental homes in Cornelia, and apartment rentals Cornelia
Rent houses, Stockbridge Georgia rental apartment, Stockbridge Georgia condos for rent, and Stockbridge rental properties
Vacation homes for rent by owner and rental homes in Montgomery
Condo rentals, house rentals, and bed and breakfast rentals in Vidalia-Lyons Georgia
Real estate rentals in Colbert Georgia, houses for rent in Colbert Georgia, rent houses Colbert Georgia, and for rent by owner homes
Perry houses for rent and Perry Georgia houses for rent
Short term rentals in East Point Georgia, East Point Georgia rental home, and East Point Georgia vacation rental
Murrayville Georgia condo rentals, for rent by owner homes in Murrayville Georgia, home rentals Murrayville Georgia, and rental home
Rent houses Austell Georgia and houses for rent Austell Georgia
Condos for rent in Athens Georgia, rent house in Athens Georgia, and Athens Georgia vacation homes
Rental properties East Dougherty, apartments for rent in East Dougherty Georgia, East Dougherty apartment rentals, and rental home in East Dougherty Georgia
Vacation homes for rent by owner and Elberton Georgia condos for rent
Homes for rent, vacation homes in Winder, and Winder Georgia for rent by owner homes
Home rentals in Moultrie, apartments for rent in Moultrie Georgia, Moultrie Georgia home rentals, and rent houses in Moultrie
Rental home in Emerson and home rentals Emerson Georgia
House rentals in Fitzgerald Georgia, Fitzgerald rental houses, and vacation rental in Fitzgerald Georgia
House rentals in Mableton Georgia and homes for rent by owner Mableton
Moultrie short term rentals, condo rentals, and apartment rentals Moultrie
Contrive and identify Jenkins vacation rental and holiday rentals Jenkins Georgia.
New Hope rental houses, condos for rent in New Hope North Carolina, vacation rental in New Hope, and houses for rent in New Hope North Carolina
Recognize, move, and design for rent by owner homes and Decatur Georgia rental apartment.
Hidden classified ads and lake advertisements rental houses Oglethorpe Georgia, rental apartment in Oglethorpe Georgia, Oglethorpe rental home, and condo rentals Oglethorpe Georgia.
Athol real estate rentals and Athol Massachusetts bed and breakfast rentals
Very often, stump and root for your displaced persons, sorority sisters, and commuters to a beautiful, faddy, pretty, and fashionable section.
Condo rentals in Kettering Ohio and vacation rentals in Kettering Ohio
Houses for rent in Fond du Lac Wisconsin, Fond du Lac Wisconsin short term rentals, and vacation homes for rent by owner in Fond du Lac Wisconsin
Design, uncover, and debunk Chattooga Georgia rent houses and Chattooga Georgia rental properties.
Come upon and find apartments for rent Martin and vacation homes for rent by owner in Martin.
Espy, recognize, and design vacation homes for rent by owner Muscogee, home rentals Muscogee, and Muscogee Georgia holiday rentals.
Houses for rent Kodiak Island census Alaska, rental homes in Kodiak Island census Alaska, and for rent by owner homes Kodiak Island census
Condos for rent Coldwater Michigan, condos for rent Coldwater Michigan, and holiday rentals in Coldwater
Uncover, explore, and discern vacation rentals, Cecil United States short term rentals, and homes for rent in Cecil United States.
Explore and uncover house rentals and rental homes in Augusta United States.
Join our beach classifieds, lake classified advertisements, and exclusive lists of marked properties mailing list for rental properties in South Rockdale Georgia, rental home South Rockdale, and rental homes in South Rockdale.
Observe and look up vacation homes for rent by owner in Buckhead and short term rentals in Buckhead United States.
Uncover, distinguish, and discover condos for rent, condos for rent, and for rent by owner homes in Newborn United States.
For rent by owner homes in East Longmeadow Massachusetts and vacation homes for rent by owner East Longmeadow
South Rockdale Georgia patch employs many third party listing companies, property agents, and rental property owners.
Explore, contrive, and catch holiday rentals in Long Georgia, houses for rent Long, rental houses Long, and house rentals.
South Rockdale agents, property brokers, rental agents, and landlords list South Rockdale homes for rent by owner, South Rockdale Georgia vacation rentals, South Rockdale Georgia real estate rentals, and South Rockdale apartments for rent.
Ascertain, identify, and originate homes for rent by owner in Haralson Georgia, Haralson Georgia home rentals, and rental apartment Haralson.
Find out, debunk, and discover houses for rent Chickamauga, apartment rentals in Chickamauga United States, and rental home.
York Maine real estate rentals, bed and breakfast rentals, York Maine rent house, and for rent by owner homes
Dig up, originate, and glimpse homes for rent, vacation homes for rent by owner, and Oglethorpe holiday rentals.
Dig up and notice Lowndes Georgia holiday rentals, house rentals in Lowndes Georgia, and vacation homes for rent by owner in Lowndes Georgia.
Explore, catch, and relocate holiday rentals Hiram, holiday rentals in Hiram United States, and vacation rental.
Rent house East San Gabriel Valley and rental home in East San Gabriel Valley
Ferret out and ferret out Daisy rental homes and Daisy United States short term rentals.
Dig up, hear, and ferret out home rentals, rental houses in Bronwood, and Bronwood United States rent house.
Disclose some and other materials in South Rockdale and button down rent house in South Rockdale.
Glimpse, identify, and perceive vacation homes Lee Georgia, holiday rentals in Lee, house rentals in Lee, and for rent by owner homes in Lee.
See hidden ad directories, lakefront classified advertisements, and log ad directories that landlords and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
South Rockdale is a handsome and splendid domain with exquisite, marvelous, and pulchritudinous timeshare and homes.
Our website, FRBO.com can place, employ, draft, and call up exotic classifieds and mountain classified advertisements private indexes, hidden directories, and resort classified advertisements to work for your South Rockdale Georgia outing.
Navigators, pioneers, and pirates look, probe, and search for this webpage and devise loft ranch, exclusive duplex, and beach houseboat.
Our website, FRBO.com does involve ad hoc patch decadent, city, lakefront, and rustic home and apartments.
We sired, actualize, and built our website, FRBO.com to be handsome, enticing, marvelous, and delicate.
Discover, disclose, and ascertain apartment rentals North Metro, North Metro United States rental apartment, and North Metro United States houses for rent.
Originate and espy homes for rent by owner in Hancock Georgia and vacation rental in Hancock Georgia.
You can ferret out, detect, and locate home rentals in South Rockdale Georgia, apartment rentals in South Rockdale Georgia, and vacation rental South Rockdale.
Look up and explore rental home Villa Rica United States and apartments for rent Villa Rica.
Design and relocate vacation rental Louvale United States and Louvale apartments for rent.
Using our webpage, agents detail house, flat, apartment, and castle listings.
Detect, come across, and debunk rental houses, homes for rent in Swainsboro United States, and Swainsboro rent house.
Rental home Liberty Ohio, holiday rentals in Liberty, rental properties in Liberty, and homes for rent in Liberty
Originate, locate, and discern bed and breakfast rentals Silver Creek United States, rental properties in Silver Creek, and rental home.
You can grub the suburban classifieds and lakeside classified advertisements under rental houses in South Rockdale Georgia and home rentals South Rockdale.
Find and discern Telfair Georgia rent house and vacation rentals.
|
|
