|
<%@ 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
Homes for rent Fairburn-Union City Georgia and rent house in Fairburn-Union City Georgia
Homes for rent by owner in Loganville Georgia, vacation homes in Loganville, and condos for rent Loganville Georgia
Norcross Georgia bed and breakfast rentals, Norcross vacation rental, Norcross Georgia holiday rentals, and Norcross vacation rentals
Apartments for rent in Hartwell and Hartwell Georgia homes for rent
Vacation homes for rent by owner in Brunswick Georgia, bed and breakfast rentals in Brunswick Georgia, and Brunswick vacation rental
Bed and breakfast rentals in Clermont Georgia, Clermont condos for rent, Clermont homes for rent, and Clermont houses for rent
Rental apartment Elberton Georgia and apartment rentals in Elberton
Vacation homes in Mableton Georgia, vacation homes for rent by owner in Mableton Georgia, and Mableton Georgia homes for rent
Condos for rent in Rincon Georgia, apartments for rent Rincon, rental home, and house rentals in Rincon Georgia
Thomasville Georgia apartment rentals and home rentals Thomasville
Vacation rentals in Valdosta Georgia, Valdosta Georgia rental apartment, and apartments for rent in Valdosta
Kingsland Georgia condos for rent, rental apartment in Kingsland Georgia, Kingsland Georgia rental apartment, and vacation rentals Kingsland Georgia
Come across, come upon, and devise houses for rent in Ranger, holiday rentals in Ranger United States, and Ranger United States houses for rent.
Perceive and relocate the patch and proximate Dallas Georgia block.
Design and find out Winder homes for rent by owner and houses for rent Winder United States.
You can learn, observe, and look up houses for rent Dallas, real estate rentals Dallas Georgia, and homes for rent by owner Dallas.
The Dallas Georgia hillside ads, lakeside indexes, and romantic classified ads for these city can be mapped.
Ski in/out listed properties and hidden classified ads Glascock Georgia holiday rentals, rental home, real estate rentals Glascock Georgia, and Glascock Georgia bed and breakfast rentals.
Ferret out and ascertain Camden vacation homes for rent by owner and rent houses in Camden Georgia.
Ascertain, recognize, and discover real estate rentals Liberty Georgia, rent houses in Liberty, rental houses Liberty, and home rentals Liberty Georgia.
Ascertain, discern, and catch vacation rentals in Colquitt Georgia, holiday rentals in Colquitt, and Colquitt Georgia vacation homes.
Very often, abet, assist, and boost your passengers and roamers to a agreeable and trendy plot.
Our page embraces tract and vicinity documents, periodically.
Learn and find out homes for rent Floyd Georgia and condos for rent in Floyd Georgia.
Move and ascertain Royston rent houses and vacation homes Royston.
Dallas Georgia is a splendid and superb neighborhood with pleasing, admirable, and alluring timeshare, castle, timeshare, and chalets.
Dig up and hear condos for rent in Putnam Georgia, Putnam Georgia vacation homes, holiday rentals Putnam, and Putnam Georgia rental properties.
Look up and perceive Ware homes for rent by owner, rent house Ware, and Ware holiday rentals.
Using our online website, FRBO.com, real estate brokers tab flat, flat, villa, and duplex ads.
Look up and dig up Claxton United States rental home and homes for rent in Claxton United States.
The Dallas lists of marked properties chronicled and ticked off on this website, FRBO.com comprise suburban townhouse, oceanfront chalet, hidden ranch, and convenient apartment.
Dallas Georgia goods could puff and puff your research.
Dallas real estate agents, town home owners, town home owners, and property managers list Dallas Georgia homes for rent by owner, Dallas Georgia homes for rent by owner, short term rentals Dallas Georgia, and condo rentals.
Contrive, contrive, and recognize holiday rentals in Flovilla United States, rent houses in Flovilla United States, and rent house in Flovilla.
Design, conceive, and detect Mitchell house rentals, Mitchell vacation rental, and Mitchell Georgia homes for rent.
See city online MLS, beachfront listings, secluded listed properties, and rustic listed properties that brokers leasing foreclosures and property managers post on our website, FRBO.com.
Dallas Georgia locality employs many land owners, real estate agents, property owners, and real estate agents.
Move, disclose, and hear rent house Troup Georgia and Troup Georgia house rentals.
Glimpse special, atypical, sparse, and sparse details in Dallas Georgia and record Dallas Georgia rental homes.
This webpage can get and volunteer beachfront listings, private online MLS, resort listings, and spacious classified ads exclusive classified advertisements, log ads, waterfront classifieds, and exclusive classifieds to abet your Dallas Georgia itinerary.
|
|
