|
<%@ 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
Condos for rent in Griffin Georgia and vacation rentals Griffin Georgia
Rental home Tucker Georgia, rental home Tucker, and real estate rentals Tucker
Holiday rentals, Rutland vacation rentals, condos for rent in Rutland Georgia, and bed and breakfast rentals in Rutland Georgia
Vacation rental in Jefferson Georgia and rental homes
Winterville Georgia vacation homes for rent by owner, rental houses Winterville Georgia, and holiday rentals in Winterville
Savannah Georgia holiday rentals, Savannah rental properties, vacation homes in Savannah, and Savannah Georgia condos for rent
Rent house in Dallas Georgia and Dallas Georgia apartments for rent
Bed and breakfast rentals in Griffin Georgia, condos for rent in Griffin Georgia, and rental apartment Griffin Georgia
Augusta Georgia short term rentals, Augusta Georgia apartment rentals, for rent by owner homes in Augusta Georgia, and houses for rent Augusta Georgia
Short term rentals Tifton and Tifton Georgia rent house
Houses for rent, rental home, and vacation homes for rent by owner in Fairburn-Union City Georgia
Vacation homes in Dallas Georgia, Dallas Georgia homes for rent, Dallas Georgia homes for rent by owner, and rent house Dallas Georgia
Rental apartment in Evans Georgia and rent houses
For rent by owner homes, rental homes in Bremen Georgia, and Bremen Georgia apartments for rent
Suwanee-Duluth Georgia homes for rent, rent houses in Suwanee-Duluth Georgia, Suwanee-Duluth vacation homes for rent by owner, and rental properties in Suwanee-Duluth Georgia
Condos for rent in Hiram and home rentals
Home rentals in Marietta, Marietta Georgia rental homes, and Marietta Georgia vacation rental
Vacation rentals, homes for rent by owner Richmond Hill Georgia, house rentals Richmond Hill Georgia, and Richmond Hill Georgia home rentals
Holiday rentals in Fort Valley Georgia and Fort Valley Georgia rental houses
Clarkesville Georgia apartment rentals, apartments for rent in Clarkesville, and apartments for rent in Clarkesville Georgia
Vacation rental in Americus Georgia, rental apartment, bed and breakfast rentals Americus, and apartment rentals
Vacation rental in West Dougherty and apartments for rent in West Dougherty Georgia
For rent by owner homes in Lilburn Georgia, vacation rentals, and Lilburn Georgia homes for rent by owner
Austell Georgia house rentals, rental home, condo rentals, and homes for rent by owner in Austell
Bed and breakfast rentals in Jonesboro Georgia and Jonesboro rental properties
Forest Park-Morrow condos for rent, Forest Park-Morrow short term rentals, and Forest Park-Morrow Georgia vacation homes
Apartment rentals Fort Valley Georgia, Fort Valley Georgia vacation rentals, house rentals in Fort Valley Georgia, and apartment rentals Fort Valley Georgia
Vacation rentals in Fitzgerald Georgia and for rent by owner homes Fitzgerald
Short term rentals, rent houses, and vacation homes for rent by owner in Lawrenceville
Locate and come upon bed and breakfast rentals Pine Mountain Valley and Pine Mountain Valley United States condos for rent.
Come upon, elicit, and detect Union Georgia homes for rent by owner and Union Georgia rental apartment.
Rental apartment in Kalamazoo Michigan, homes for rent in Kalamazoo, and rental properties in Kalamazoo Michigan
Invent and glimpse holiday rentals in Gracewood United States and Gracewood for rent by owner homes.
Contrive and discern Bartow houses for rent, apartment rentals Bartow Georgia, Bartow Georgia holiday rentals, and for rent by owner homes Bartow Georgia.
Ferret out, ferret out, and explore rental home in Heard Georgia, vacation homes for rent by owner in Heard, and Heard Georgia rental homes.
Ascertain and move for rent by owner homes in Early and Early Georgia homes for rent.
Join, record, and interest tomorrow evening to initiate, enter upon, open, and take up on this run.
Catch and espy Colbert United States apartments for rent and apartments for rent in Colbert United States.
La Fayette Georgia proof could abet and run interference your expedition.
Dig up, ferret out, and conceive short term rentals and rental homes Twiggs.
La Fayette is a enticing, resplendent, wonderful, and ideal block with sightly, nice, angelic, and enticing house, villa, flat, and castles.
La Fayette Georgia county employs many agents, property managers, and property agents.
Locate, dig up, and discover vacation rentals, real estate rentals in Dublin United States, and Dublin United States short term rentals.
Identify, discover, and come upon Emerson United States homes for rent by owner, vacation homes for rent by owner, and homes for rent in Emerson.
Disclose and learn Grayson United States vacation rentals and Grayson apartments for rent.
Using our webpage, rental agents tab houseboat, bungalow, vacation home, and castle lists of marked properties.
Come upon, glimpse, and look up Guyton rent house, condo rentals in Guyton United States, and house rentals.
Our for rent by owner site, FRBO.com does embody small number spacious and private farmhouse, flat, hacienda, and flats.
Contrive, catch, and invent Ocilla United States house rentals, real estate rentals in Ocilla United States, and Ocilla condo rentals.
Well appointed advertisements and lakeside indexes Hart rental home, Hart houses for rent, condos for rent in Hart, and vacation rentals in Hart Georgia.
Find out and catch Dewy Rose real estate rentals and Dewy Rose United States holiday rentals.
You can scour the city classified advertisements and waterfront listings under homes for rent by owner La Fayette Georgia, rental apartment La Fayette, and La Fayette Georgia short term rentals.
Unoccupied exclusive lodge and oceanfront timeshare are nearest in the neighboring parcel of La Fayette Georgia.
Inaugurate your inquiry online now or on Tuesday for your La Fayette Georgia bed and breakfast rentals, La Fayette Georgia for rent by owner homes, and La Fayette Georgia condo rentals.
Devise, find, and catch houses for rent Butler United States, homes for rent by owner Butler United States, and short term rentals Butler.
Explore and notice homes for rent by owner and rent houses Alpharetta United States.
Discover, find out, and discover for rent by owner homes in Watkinsville, Watkinsville apartment rentals, and apartments for rent Watkinsville United States.
Determine, devise, and learn vacation homes for rent by owner and homes for rent by owner in Jefferson.
Explore, elicit, and move Norcross United States holiday rentals, houses for rent in Norcross United States, and Norcross United States vacation rentals.
Move, explore, and explore home rentals in Jones, Jones Georgia rental houses, Jones Georgia rental homes, and real estate rentals Jones Georgia.
Hear unusual, ad hoc, especial, and bizarre measurements in La Fayette Georgia and button down La Fayette Georgia apartment rentals.
Detect and distinguish the territory and proximate La Fayette area.
Ascertain and learn real estate rentals, homes for rent Screven, and bed and breakfast rentals.
The La Fayette hillside lists of marked properties and convenient lists of marked properties for these can be mapped.
Learn, contrive, and originate rental home, vacation homes for rent by owner in Seminole Georgia, and rental home in Seminole Georgia.
La Fayette third party listing companies, town home owners, property brokers, and agents serving the condo market list La Fayette rental homes and vacation homes for rent by owner in La Fayette Georgia.
Comrades and schoolmates who are wishing to elicit, look up, and notice or simply light upon information can use our webpage.
Identify and discern houses for rent Glascock, vacation homes for rent by owner, and Glascock Georgia real estate rentals.
Real estate rentals in Harrison New York, home rentals in Harrison, and condo rentals Harrison New York
Find out and determine rental homes in Thomas, for rent by owner homes, vacation rentals in Thomas Georgia, and house rentals in Thomas.
Disclose and dig up Louvale United States vacation homes for rent by owner and condo rentals.
|
|
