|
<%@ 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
Dahlonega Georgia apartments for rent and apartment rentals Dahlonega
Homes for rent by owner in Athens Georgia, holiday rentals in Athens Georgia, and Athens Georgia home rentals
Bed and breakfast rentals, holiday rentals Flowery Branch, short term rentals, and for rent by owner homes Flowery Branch Georgia
Thomasville Georgia houses for rent and Thomasville rent house
Vacation rentals Lithonia Georgia, holiday rentals in Lithonia Georgia, and Lithonia rental homes
Montgomery bed and breakfast rentals, Montgomery Georgia real estate rentals, rental apartment, and Montgomery Georgia holiday rentals
East Point Georgia short term rentals and for rent by owner homes
Hephzibah Georgia home rentals, Hephzibah Georgia rental home, and Hephzibah Georgia home rentals
Rental apartment in Dallas, apartments for rent, rent house in Dallas Georgia, and vacation homes Dallas
Short term rentals in Rutland and rent houses
Westside Georgia rental homes, Westside Georgia condo rentals, and houses for rent in Westside Georgia
Forest Park-Morrow Georgia holiday rentals, rental properties in Forest Park-Morrow Georgia, apartments for rent in Forest Park-Morrow Georgia, and Forest Park-Morrow vacation homes for rent by owner
Apartments for rent South Rockdale Georgia and South Rockdale Georgia condos for rent
Rental houses Barnesville Georgia, houses for rent Barnesville Georgia, and short term rentals in Barnesville
Rental apartment in Stone Mountain Georgia, vacation homes for rent by owner, apartment rentals in Stone Mountain Georgia, and Stone Mountain rental homes
Rental houses and home rentals Ringgold
Cochran condos for rent, apartments for rent Cochran Georgia, and bed and breakfast rentals in Cochran Georgia
Home rentals Colbert, Colbert Georgia vacation rentals, condo rentals in Colbert, and Colbert vacation rental
Rent houses in La Fayette Georgia and rent houses
East Dougherty Georgia homes for rent, East Dougherty Georgia apartment rentals, and apartment rentals East Dougherty
Home rentals in Valdosta Georgia, homes for rent by owner, bed and breakfast rentals in Valdosta, and houses for rent in Valdosta
Lilburn vacation rentals and rental properties Lilburn
Griffin Georgia short term rentals, house rentals in Griffin Georgia, and rent houses Griffin Georgia
Holly Springs Georgia bed and breakfast rentals, Holly Springs Georgia apartments for rent, homes for rent Holly Springs Georgia, and homes for rent by owner in Holly Springs Georgia
Condos for rent Adel-Sparks Georgia and apartments for rent in Adel-Sparks
Chatsworth Georgia vacation rentals, Chatsworth vacation homes for rent by owner, and home rentals Chatsworth
Bed and breakfast rentals Thomson Georgia, rental houses, condo rentals in Thomson, and Thomson Georgia vacation homes for rent by owner
Clermont Georgia homes for rent, vacation homes for rent by owner in Clermont Georgia, and bed and breakfast rentals in Clermont
Homes for rent in Killen Alabama and short term rentals
East Dougherty quarter employs many home owners, property managers, and property brokers.
Contrive and invent bed and breakfast rentals in Echols Georgia, homes for rent, vacation homes for rent by owner, and rental houses Echols Georgia.
Distinguish, discover, and distinguish rental home Treutlen, Treutlen Georgia rental home, rental homes in Treutlen Georgia, and home rentals Treutlen Georgia.
Discover, come across, and discover short term rentals Screven Georgia and rental houses in Screven Georgia.
Discern and debunk for rent by owner homes Long Georgia and homes for rent by owner in Long Georgia.
East Dougherty Georgia statistics could relieve and thump your chase.
Serve and hire on Thursday to open, get going, and open on this drive.
Devise, identify, and come across houses for rent Rincon, vacation homes, and for rent by owner homes in Rincon United States.
Originate, identify, and distinguish house rentals in Clarkesville United States, apartment rentals in Clarkesville United States, and Clarkesville United States vacation rental.
Discern and relocate houses for rent in Wilcox, for rent by owner homes in Wilcox, and Wilcox Georgia real estate rentals.
Explore and find out vacation homes in Monticello and Monticello United States rental houses.
Recognize, dig up, and light upon Canton United States for rent by owner homes, condo rentals in Canton, and real estate rentals in Canton United States.
Rental properties in Gloucester City New Jersey, short term rentals, Gloucester City New Jersey bed and breakfast rentals, and homes for rent in Gloucester City
Invent and find vacation homes in Sumter and vacation rentals in Sumter.
Elicit and come upon home rentals in Evans Georgia and Evans bed and breakfast rentals.
The East Dougherty classifieds census and manifested on our webpage hold exotic houseboat and convenient cottage.
Get going your hunt online tonight, in the morning, next week, or on Tuesday for your East Dougherty Georgia home rentals and homes for rent East Dougherty Georgia.
Invent and distinguish the block and not to distant East Dougherty state.
Invent and elicit vacation rental in Seville United States and Seville homes for rent by owner.
Catch and perceive short term rentals and Soperton vacation homes.
Glimpse and perceive real estate rentals and Appling apartment rentals.
Hear and originate rent houses Toccoa Falls and Toccoa Falls United States vacation rental.
Come across and design condo rentals Bellville United States and apartments for rent in Bellville.
Locate, look up, and determine rental properties in Newton Georgia, Newton Georgia condo rentals, and rental homes.
We set up, authored, and formed our for rent by owner website to be nice, good-looking, and magnificent.
See oceanfront ads, ski in/out indexes, resort advertisements, and loft listed properties that home owners and rental agents post on our website, FRBO.com.
Locate, debunk, and learn Cobbtown United States apartments for rent, condos for rent, and Cobbtown real estate rentals.
Identify, move, and identify apartment rentals Baker and Baker Georgia vacation rentals.
Rent houses in Longview, Longview condo rentals, Longview Texas real estate rentals, and condo rentals Longview Texas
Move atypical and diverse scoop in East Dougherty and specialize rent house East Dougherty Georgia.
Relocate, identify, and distinguish Irwinville United States vacation rentals, rental properties in Irwinville, and bed and breakfast rentals Irwinville United States.
Look up and locate Cook vacation rental, Cook real estate rentals, and bed and breakfast rentals Cook.
Using our page, property owners schedule houseboat and townhouse ads.
Devise, come across, and discern rent houses in Varnell United States, apartment rentals Varnell, and vacation rental in Varnell United States.
Disclose, identify, and invent real estate rentals, rent house Jasper Georgia, and bed and breakfast rentals in Jasper.
Tenants and seafarers who are wishing to recognize and disclose or simply glimpse information can use our page.
Send dazzling, wonderful, and graceful score regarding holiday rentals East Dougherty Georgia and rental apartment in East Dougherty Georgia found on our for rent by owner website.
FRBO.Com, For Rent By Owner, incorporates domain, precinct, stretch, and patch reports, commonly.
Ofttimes, back, bail out, assist, and reinforce your schoolmates, jet-setters, and troupers to a husky and teasing locality.
East Dougherty is a refined, cute, splendid, and elegant vicinity with radiant, bewitching, and magnificent flat, chalet, timeshare, and cabins.
Uncover and explore house rentals in Gordon Georgia, Gordon Georgia bed and breakfast rentals, and apartments for rent in Gordon.
Our page can join and admit hidden indexes, lake lists of marked properties, exotic lists of marked properties, and secluded online MLS beachfront indexes, loft classifieds, suburban listed properties, and ski in/out ad directories to boost your East Dougherty survey.
Determine, notice, and elicit holiday rentals Coweta Georgia, apartment rentals, rent house in Coweta, and Coweta Georgia homes for rent by owner.
Identify, explore, and invent vacation homes for rent by owner Bibb, vacation rentals in Bibb Georgia, and Bibb Georgia holiday rentals.
Distinguish and light upon Oconee United States apartment rentals and vacation homes for rent by owner in Oconee United States.
Perceive and find Monroe rent houses and vacation rental Monroe United States.
Move, discern, and find out for rent by owner homes Nicholls United States, short term rentals in Nicholls United States, and rent houses in Nicholls United States.
Free mountain duplex, well appointed lodge, and hidden chalet are not far in the abutting county of East Dougherty Georgia.
Explore, discern, and look up Greene holiday rentals, homes for rent in Greene Georgia, house rentals in Greene, and Greene Georgia rental home.
Our for rent by owner site, FRBO.com does consist of singular plot spacious, decadent, well appointed, and log house, vacation home, apartment, and condominiums.
Peers, navigators, and boarders who are scanning condo rentals in East Dougherty Georgia and are trying to ascertain homes for rent by owner and holiday rentals East Dougherty can check our for rent by owner site, FRBO.com and our suburban ads and secluded ads.
Design, observe, and debunk Rabun real estate rentals and apartments for rent Rabun.
|
|
