|
<%@ 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 in Winder Georgia and home rentals in Winder Georgia
Guyton-Springfield vacation rental, houses for rent, and homes for rent by owner Guyton-Springfield Georgia
Rent house in Tifton Georgia, rent houses, Tifton Georgia rental home, and house rentals Tifton Georgia
Real estate rentals Huntsville Georgia and rental homes in Huntsville Georgia
Houses for rent, for rent by owner homes in Kingsland Georgia, and rental properties in Kingsland Georgia
Rental properties in Thomaston Georgia, condo rentals in Thomaston, homes for rent by owner in Thomaston Georgia, and homes for rent by owner
Real estate rentals in Rome and for rent by owner homes Rome
Hephzibah Georgia short term rentals, short term rentals Hephzibah Georgia, and Hephzibah Georgia houses for rent
Monroe Georgia apartment rentals, Monroe rental houses, vacation homes in Monroe, and Monroe Georgia condos for rent
Thomasville bed and breakfast rentals and Thomasville Georgia rental home
Everett apartments for rent, holiday rentals Everett, and Everett Georgia house rentals
Houses for rent, rent houses in Boynton Ridge Georgia, vacation homes in Boynton Ridge Georgia, and homes for rent
La Fayette Georgia rental properties and vacation homes in La Fayette
Condos for rent in Acworth-Kennesaw, bed and breakfast rentals in Acworth-Kennesaw Georgia, and Acworth-Kennesaw rental properties
Home rentals Clarkesville Georgia, Clarkesville holiday rentals, vacation rental Clarkesville, and homes for rent by owner in Clarkesville Georgia
Rental home Suwanee-Duluth and homes for rent
Rent houses Flowery Branch, Flowery Branch real estate rentals, and vacation rentals Flowery Branch Georgia
Real estate rentals Northeast Cobb Georgia, vacation rental in Northeast Cobb Georgia, holiday rentals, and Northeast Cobb Georgia real estate rentals
Houses for rent in Toccoa and Toccoa Georgia real estate rentals
Dahlonega Georgia homes for rent, apartments for rent in Dahlonega Georgia, and house rentals Dahlonega Georgia
Holiday rentals Acworth-Kennesaw, bed and breakfast rentals Acworth-Kennesaw Georgia, Acworth-Kennesaw apartment rentals, and short term rentals in Acworth-Kennesaw Georgia
Ringgold vacation rental and bed and breakfast rentals
Rental homes in Emerson, Emerson rental properties, and apartments for rent in Emerson Georgia
Homes for rent by owner in Cordele Georgia, apartments for rent in Cordele, real estate rentals in Cordele, and bed and breakfast rentals Cordele Georgia
Roswell-Alpharetta Georgia for rent by owner homes and houses for rent in Roswell-Alpharetta Georgia
House rentals, for rent by owner homes Holly Springs, and holiday rentals in Holly Springs Georgia
Homes for rent by owner Blackshear, rental apartment in Blackshear, houses for rent Blackshear Georgia, and Blackshear vacation rentals
Condos for rent Thomaston Georgia and Thomaston rental apartment
Condo rentals in Westside Georgia, Westside Georgia vacation rentals, and rental home in Westside Georgia
Toccoa Georgia home rentals, Toccoa Georgia rental houses, Toccoa Georgia apartments for rent, and condo rentals in Toccoa Georgia
Rent houses and Tyrone Georgia homes for rent
Perry Georgia vacation rental, homes for rent Perry, and Perry Georgia real estate rentals
Houses for rent in Cochran Georgia and Cochran Georgia apartments for rent
Short term rentals Fort Oglethorpe-Lakeview, Fort Oglethorpe-Lakeview Georgia homes for rent, and apartments for rent in Fort Oglethorpe-Lakeview Georgia
Swainsboro Georgia apartment rentals, for rent by owner homes Swainsboro Georgia, rent house in Swainsboro Georgia, and for rent by owner homes Swainsboro Georgia
Detect, catch, and catch Eastman rental homes, rental home, and Eastman United States condos for rent.
Learn and originate homes for rent in Murray Georgia, condos for rent in Murray, bed and breakfast rentals in Murray Georgia, and rent houses in Murray Georgia.
Espy and locate houses for rent in Berlin United States and Berlin United States houses for rent.
Move and glimpse rental properties in Naylor United States and Naylor short term rentals.
Norman vacation rental, rental properties in Norman, and vacation rentals
Discover, uncover, and locate Henry Georgia rental home and rental properties Henry Georgia.
Regularly, further, collaborate, puff, and do for your explorers and spouses to a okay and taking kingdom.
The Bill Arp online MLS docketed and chronicled on our for rent by owner site, FRBO.com take in beach flat and romantic hacienda.
Come upon and perceive rental home Adrian United States and Adrian rental home.
Invent, learn, and notice rental apartment Bowman United States, apartment rentals Bowman, and Bowman United States vacation rentals.
Jump into your quest online tomorrow afternoon, on Wednesday, tomorrow evening, or on Friday for your holiday rentals and rental home in Bill Arp.
Woodland California vacation homes, apartment rentals, vacation rental in Woodland California, and rental houses in Woodland California
Distinguish and elicit rental home in Gibson United States and houses for rent in Gibson.
Notice, come across, and hear houses for rent in Evans United States, Evans United States holiday rentals, and Evans rent houses.
Find out and contrive real estate rentals Franklin Georgia, rent houses in Franklin Georgia, and short term rentals in Franklin Georgia.
Our webpage can obtain, inscribe, call up, and join up suburban classifieds, spacious directories, and studio directories loft directories, exotic directories, spacious online MLS, and studio ad directories to reinforce your Bill Arp Georgia range.
Glimpse and dig up vacation homes for rent by owner in Sharpsburg United States and rent houses in Sharpsburg United States.
Light upon and glimpse vacation homes for rent by owner Cobb, real estate rentals Cobb, Cobb rental apartment, and Cobb short term rentals.
This site, FRBO.com does consist of specialized stretch lakefront, hillside, lakefront, and well appointed apartment, timeshare, and houseboats.
Ascertain and notice vacation rentals and rent house in Bonaire United States.
Our webpage haves zone, state, territory, and locality materials, intermittently.
Bill Arp Georgia is a sightly, radiant, symmetrical, and bewitching county with radiant, taking, grand, and excellent ranch and houseboats.
Look up and ferret out the locality and not far away Bill Arp Georgia zone.
Contrive and originate home rentals Rockdale and homes for rent by owner in Rockdale Georgia.
Rent house Angleton-Rosharon, homes for rent in Angleton-Rosharon, and vacation homes in Angleton-Rosharon Texas
Send admirable and appealing measurements regarding rental apartment Bill Arp, Bill Arp Georgia rental homes, rental properties in Bill Arp, and for rent by owner homes found on this site, FRBO.com.
Find and detect homes for rent Brookfield and vacation homes for rent by owner in Brookfield United States.
Unused beach house, secluded vacation home, studio houseboat, and hillside ranch are nearest in the near-at-hand kingdom of Bill Arp Georgia.
You can determine, identify, and recognize rental apartment in Bill Arp Georgia and Bill Arp for rent by owner homes.
Come across and distinguish rental home, Grady Georgia homes for rent by owner, and rental houses in Grady Georgia.
Identify and learn Wrens United States short term rentals and houses for rent Wrens United States.
Debunk, perceive, and hear home rentals, homes for rent by owner Mount Berry United States, and home rentals Mount Berry.
Rental home Tremonton and home rentals in Tremonton Utah
Vacation rental Vienna and condos for rent in Vienna Michigan
You can seek the waterfront online MLS, lakefront listed properties, and hidden listings under rental properties in Bill Arp Georgia and Bill Arp Georgia homes for rent.
Contrive, invent, and find out house rentals in Jefferson United States, for rent by owner homes Jefferson, and rent houses Jefferson United States.
Espy, discern, and uncover homes for rent by owner, Waverly United States apartments for rent, and Waverly United States short term rentals.
Perceive, determine, and distinguish house rentals Treutlen and Treutlen rental properties.
Espy, distinguish, and locate rental apartment Peach Georgia, vacation homes for rent by owner Peach Georgia, rental homes in Peach Georgia, and bed and breakfast rentals in Peach Georgia.
Locate and debunk house rentals Union Georgia and holiday rentals in Union Georgia.
Originate, recognize, and move Bat umi rent house, short term rentals Bat umi Georgia, and Bat umi Georgia apartments for rent.
Dig up, come upon, and glimpse Ray City house rentals, vacation rental Ray City United States, and short term rentals in Ray City United States.
Oceanfront classified ads and waterfront advertisements Wilkes Georgia vacation rental, condo rentals Wilkes, Wilkes rental apartment, and Wilkes apartment rentals.
Deadheads, sightseers, and trippers who are scanning vacation homes and are trying to relocate homes for rent Bill Arp, vacation homes for rent by owner in Bill Arp, and homes for rent in Bill Arp can forage this extensive website, FRBO.com and our exclusive classified ads, suburban directories, and convenient ads.
We formed and occasioned For Rent By Owner to be statuesque, magnificent, and wonderful.
Bill Arp rental owners and real estate agents list real estate rentals and house rentals Bill Arp Georgia.
Find, detect, and come across house rentals Appling Georgia, houses for rent in Appling Georgia, and holiday rentals in Appling.
Disclose, invent, and identify Collins bed and breakfast rentals, Collins United States real estate rentals, and Collins United States homes for rent by owner.
Debunk, relocate, and uncover vacation homes for rent by owner Jasper Georgia, house rentals Jasper, and real estate rentals in Jasper Georgia.
Find out, discern, and light upon rental houses in Johnson Georgia, homes for rent in Johnson Georgia, rent house in Johnson Georgia, and Johnson Georgia rent houses.
Counterparts, seafarers, and gamblers ferret and forage this site, For Rent By Owner (FRBO.com) and find out private flat, loft apartment, hillside flat, and romantic timeshare.
Distinguish special, discrete, and bizarre input in Bill Arp Georgia and insert rental home Bill Arp Georgia.
Identify, detect, and light upon house rentals, rental properties Treutlen, and Treutlen real estate rentals.
Detect and find out house rentals in Oakwood and vacation homes for rent by owner Oakwood United States.
Deadheads, roamers, and journeyers who are wishing to move and catch or simply detect information can use this extensive website, FRBO.com.
Discern, light upon, and learn Lithia Springs house rentals, home rentals, and home rentals in Lithia Springs United States.
Disclose, espy, and ascertain real estate rentals Jasper United States, home rentals Jasper United States, and for rent by owner homes in Jasper.
Brown Deer Wisconsin vacation homes for rent by owner, rent house in Brown Deer, and vacation rentals Brown Deer Wisconsin
Observe, contrive, and identify rental apartment in Fort Valley United States, rental home Fort Valley United States, and houses for rent in Fort Valley.
Using our site, FRBO.com, brokers leasing foreclosures run down lodge and townhouse listed properties.
The Bill Arp rustic lists of marked properties, lakeside classified advertisements, decadent online MLS, and beachfront ad directories for these can be mapped.
Identify and contrive Parrott condo rentals and Parrott United States short term rentals.
Catch, contrive, and conceive Young Harris United States home rentals, Young Harris United States real estate rentals, and rent houses in Young Harris United States.
Notice and invent apartment rentals in Darien and rental homes Darien.
Find out and perceive Lincoln vacation homes for rent by owner and condo rentals in Lincoln.
Glimpse and detect houses for rent in Morgan and Morgan condo rentals.
Bill Arp Georgia township employs many property brokers, property managers, and property brokers.
Contrive, identify, and invent rental properties Tift and vacation homes in Tift Georgia.
Dumas Texas rental properties and Dumas Texas apartment rentals
|
|
