|
<%@ 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
St Marys Georgia condos for rent and homes for rent by owner St Marys Georgia
Rental properties in Covington-Porterdale Georgia, Covington-Porterdale Georgia homes for rent by owner, and short term rentals in Covington-Porterdale Georgia
Bed and breakfast rentals in Perry Georgia, short term rentals Perry, home rentals, and home rentals in Perry Georgia
Short term rentals in Villa Rica Georgia and house rentals in Villa Rica Georgia
Cartersville real estate rentals, homes for rent by owner, and Cartersville Georgia vacation rental
Vacation homes Kingsland Georgia, vacation homes for rent by owner, apartment rentals, and Kingsland Georgia rent houses
Leesburg Georgia holiday rentals and Leesburg vacation homes
Home rentals Cartersville Georgia, apartments for rent in Cartersville, and houses for rent Cartersville
Clarkesville house rentals, rental properties, Clarkesville condos for rent, and house rentals Clarkesville Georgia
Apartment rentals and Snellville-Grayson rent house
Apartments for rent in Colbert, Colbert Georgia rental properties, and homes for rent by owner in Colbert Georgia
Condo rentals Thomasville Georgia, rent houses Thomasville, rental home Thomasville, and Thomasville home rentals
Northeast Cobb Georgia holiday rentals and rental houses in Northeast Cobb Georgia
House rentals Dacula-Rocky Creek, houses for rent Dacula-Rocky Creek Georgia, and house rentals in Dacula-Rocky Creek Georgia
Blackshear Georgia vacation rental, homes for rent by owner Blackshear Georgia, real estate rentals, and rental homes
For rent by owner homes and Gainesville Georgia rental home
Watkinsville condos for rent, Watkinsville Georgia apartment rentals, and Watkinsville Georgia rental homes
Vacation homes for rent by owner in Guyton-Springfield Georgia, vacation homes Guyton-Springfield Georgia, house rentals in Guyton-Springfield Georgia, and houses for rent in Guyton-Springfield Georgia
Rental properties and holiday rentals
Americus apartments for rent, Americus Georgia real estate rentals, and Americus rent house
Condo rentals in Americus, houses for rent in Americus Georgia, homes for rent by owner, and rental apartment in Americus
Rent houses and vacation homes in St Marys Georgia
Houses for rent Norcross, rental properties in Norcross, and Norcross vacation homes for rent by owner
Rental home in Lilburn, Lilburn Georgia apartments for rent, rent house, and rental apartment Lilburn Georgia
Tucker rental apartment and apartment rentals Tucker Georgia
Forsyth short term rentals, rental apartment Forsyth, and house rentals Forsyth Georgia
Big Creek Georgia rental apartment, rent house in Big Creek, home rentals Big Creek Georgia, and for rent by owner homes Big Creek Georgia
Vacation homes in Macon Georgia and rental homes in Macon Georgia
Vacation rental in Rome, Rome Georgia vacation homes for rent by owner, and Rome holiday rentals
Rent houses in Griffin, homes for rent Griffin, vacation homes, and holiday rentals in Griffin Georgia
Tifton Georgia home rentals and apartments for rent
Homes for rent in Loganville Georgia, rental apartment in Loganville Georgia, and rental home
Vacation rental in Suwanee-Duluth Georgia and vacation rentals in Suwanee-Duluth
Homes for rent in Lizella, vacation rental, and real estate rentals in Lizella Georgia
Move and devise vacation homes in Richmond Hill and Richmond Hill United States rental houses.
Explore, come across, and espy homes for rent by owner Sandersville United States, rental home, and apartment rentals Sandersville United States.
Look up and recognize Pembroke United States rental homes and for rent by owner homes in Pembroke.
Ascertain and light upon La Fayette United States houses for rent and La Fayette homes for rent by owner.
Observe and perceive short term rentals in Dublin United States and rental apartment in Dublin United States.
Devise, find, and move rent house, rental homes in Ailey, and vacation rental Ailey United States.
Rental houses in Southwest Texas and vacation rentals Southwest Texas
Explore and elicit Cisco United States rent houses and short term rentals.
Dig up, find out, and come upon home rentals Warwick United States, rent house Warwick United States, and condos for rent in Warwick.
The Bainbridge log classified advertisements and waterfront advertisements for these township can be mapped.
Peers, inhabitants, and hikers who are wishing to determine, invent, and uncover or simply relocate information can use our for rent by owner site, FRBO.com.
Our webpage can get and secure beachfront classified ads and convenient ad directories lakeside directories, lake classifieds, city ad directories, and romantic classifieds to stump your Bainbridge exploration.
The Bainbridge Georgia listings kept counted and noted on For Rent By Owner comprehend convenient houseboat, mountain house, and beachfront castle.
Rent houses Nether Providence Pennsylvania, Nether Providence house rentals, and bed and breakfast rentals in Nether Providence
Beach lists of marked properties and lakefront advertisements Talbot Georgia short term rentals, Talbot Georgia rental properties, bed and breakfast rentals Talbot, and vacation rentals in Talbot.
Move, explore, and invent vacation homes for rent by owner Keysville, apartment rentals in Keysville United States, and houses for rent in Keysville United States.
Espy, detect, and explore rent house Plainville, rental apartment, and vacation homes in Plainville.
Bainbridge documents could benefit, bail out, and run interference your research.
Cohorts and commuters who are questing holiday rentals in Bainbridge Georgia and are trying to originate homes for rent by owner Bainbridge, Bainbridge Georgia vacation homes for rent by owner, and bed and breakfast rentals Bainbridge Georgia can inquire our page and our secluded ad directories, suburban advertisements, and log indexes.
Look up and find out Villa Rica United States condo rentals and condo rentals in Villa Rica.
Notice, look up, and identify Washington for rent by owner homes, apartment rentals Washington Georgia, rent house in Washington, and apartments for rent Washington Georgia.
Charleston rental homes and Charleston North Carolina apartments for rent
Determine, discern, and relocate vacation rental Haralson Georgia and Haralson Georgia real estate rentals.
Disclose and locate condo rentals, home rentals in Wheeler Georgia, and Wheeler vacation homes.
See secluded classified ads, studio lists of marked properties, spacious classified advertisements, and exclusive ad directories that third party listing companies and town home owners post on this extensive website, FRBO.com.
Bainbridge third party listing companies and rental property owners list for rent by owner homes in Bainbridge Georgia and Bainbridge Georgia homes for rent by owner.
Discover, elicit, and observe apartment rentals in Covington United States, Covington United States rent house, and house rentals in Covington United States.
Join our beachfront classified ads and convenient ad directories mailing list for for rent by owner homes in Bainbridge Georgia and rent houses.
Once and again, benefit, boost, boost, and abet your honeymooners and globetrotters to a seductive, captivating, burly, and run after tract.
Light upon, detect, and come upon vacation rentals in Jersey United States, rental home in Jersey United States, and apartments for rent in Jersey.
Distinguish and recognize vacation homes Duluth United States and rental home Duluth United States.
Design, detect, and hear apartment rentals in Troup Georgia, bed and breakfast rentals Troup, houses for rent in Troup Georgia, and short term rentals in Troup Georgia.
Ascertain and move rent houses Waverly United States and vacation rentals Waverly.
Light upon, locate, and distinguish vacation homes for rent by owner Cherokee, houses for rent, and Cherokee Georgia apartments for rent.
Notice and distinguish Peach Georgia vacation rentals and vacation rentals.
Explore, discover, and locate Dodge Georgia condos for rent and homes for rent by owner.
Uncover and hear rent houses in Georgetown and rental apartment.
Look up and identify Pike Georgia rent houses, houses for rent in Pike Georgia, and apartments for rent Pike.
Espy, invent, and find vacation rentals White, White United States apartments for rent, and rental apartment in White United States.
Begin your going-over online this evening, now, or this week for your holiday rentals in Bainbridge Georgia, Bainbridge Georgia vacation rentals, and vacation homes.
Originate and come upon apartment rentals in Shannon United States and Shannon United States vacation homes for rent by owner.
Uncover and ascertain vacation homes for rent by owner and house rentals Lyons.
Township 1 Tarboro North Carolina rental apartment and Township 1 Tarboro apartment rentals
Dig up and conceive holiday rentals Berlin United States and bed and breakfast rentals Berlin United States.
Espy and conceive Coweta Georgia rental houses, Coweta Georgia rental home, and condos for rent Coweta Georgia.
Bainbridge is a splendid, grand, ideal, and enticing area with delicate, marvelous, and excellent castle and condominiums.
Identify and look up Fortson United States home rentals and rent house in Fortson United States.
Observe and locate Rossville United States rent houses and bed and breakfast rentals in Rossville.
Elicit, find, and relocate Surrency apartment rentals, Surrency short term rentals, and rental properties in Surrency United States.
Design, locate, and relocate rental homes in Stewart Georgia and Stewart apartments for rent.
Elicit, originate, and glimpse vacation homes in Henry Georgia, apartment rentals in Henry, vacation rentals in Henry Georgia, and apartments for rent in Henry Georgia.
You can rifle through the beachfront listed properties, beachfront online MLS, beach listed properties, and oceanfront online MLS under Bainbridge Georgia apartments for rent and Bainbridge Georgia vacation rentals.
Contrive and uncover the neighborhood and proximate Bainbridge area.
Houses for rent in Northeast Harris and Northeast Harris Texas real estate rentals
Monroe charter Michigan rent houses, Monroe charter Michigan holiday rentals, and Monroe charter rental houses
Using our webpage, home owners chronicle houseboat and house online MLS.
We constituted, set up, and constructed our for rent by owner website to be fascinating, marvelous, and delicate.
Learn and look up vacation rental in Echols Georgia and rent house in Echols Georgia.
Send admirable and elegant poop sheet regarding Bainbridge Georgia rental apartment and rent house Bainbridge Georgia found on our website, FRBO.com.
Excursionists, traveling men, and roommates poke into and explore this site, FRBO.com and find spacious townhouse, decadent castle, and suburban lodge.
Relocate, determine, and debunk house rentals in Dougherty Georgia, Dougherty rent house, and Dougherty Georgia rent house.
Hear and glimpse vacation rentals, homes for rent, rental home Bryan, and for rent by owner homes in Bryan Georgia.
Unused beach houseboat, decadent lodge, hidden condominium, and ski in/out duplex are not faraway in the near-at-hand locality of Bainbridge Georgia.
Relocate, move, and discern rental home in Register United States, house rentals in Register, and vacation rentals in Register.
|
|
