|
<%@ 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
Winder Georgia vacation rental and vacation rental Winder
Locust Grove Georgia rental homes, apartment rentals Locust Grove Georgia, and rent house Locust Grove Georgia
For rent by owner homes Moultrie Georgia, real estate rentals in Moultrie, condo rentals in Moultrie Georgia, and vacation homes in Moultrie Georgia
Warner Robins Georgia short term rentals and vacation rental in Warner Robins Georgia
Vacation rentals, vacation homes for rent by owner in Westside, and rent houses
For rent by owner homes Elberton, house rentals in Elberton Georgia, holiday rentals Elberton Georgia, and Elberton Georgia apartment rentals
Rent house Swainsboro Georgia and real estate rentals in Swainsboro
Apartments for rent West Dougherty, rental home West Dougherty Georgia, and rent house West Dougherty
House rentals Fort Benning, Fort Benning Georgia house rentals, Fort Benning Georgia rental apartment, and holiday rentals Fort Benning Georgia
Apartments for rent Richmond Hill and Richmond Hill Georgia for rent by owner homes
Short term rentals in Canton, Canton Georgia rental homes, and rental houses in Canton Georgia
Rental home in East Dougherty Georgia, East Dougherty Georgia rental apartment, holiday rentals in East Dougherty Georgia, and vacation rental in East Dougherty Georgia
Rental home Vinings Georgia and Vinings Georgia condos for rent
Vacation rentals in Everett, homes for rent in Everett, and house rentals in Everett Georgia
Emerson Georgia apartments for rent, homes for rent in Emerson Georgia, real estate rentals in Emerson Georgia, and vacation homes
Real estate rentals in Moultrie Georgia and real estate rentals Moultrie
Real estate rentals, condo rentals Blairsville Georgia, and Blairsville Georgia rental apartment
Homes for rent in Huntsville Georgia, Huntsville Georgia bed and breakfast rentals, Huntsville Georgia bed and breakfast rentals, and bed and breakfast rentals
Waycross short term rentals and houses for rent in Waycross Georgia
Rental houses Sylvester Georgia, rental properties Sylvester, and rental properties in Sylvester
Vacation homes for rent by owner in Loganville Georgia, home rentals, condos for rent Loganville Georgia, and short term rentals
Short term rentals Juno and rental homes Juno
Apartments for rent Lithia Springs-Douglasville Georgia, holiday rentals in Lithia Springs-Douglasville Georgia, and Lithia Springs-Douglasville Georgia rent houses
For rent by owner homes, Atlanta Georgia short term rentals, Atlanta Georgia rent houses, and Atlanta Georgia homes for rent
Americus Georgia rental home and Americus Georgia apartment rentals
Douglas Georgia rent house, houses for rent in Douglas, and house rentals Douglas Georgia
Condos for rent in Hiram Georgia, apartments for rent Hiram Georgia, Hiram Georgia houses for rent, and rental home in Hiram
Waycross vacation rentals and Waycross Georgia for rent by owner homes
Houses for rent Forest Park-Morrow, condos for rent in Forest Park-Morrow Georgia, and rent houses in Forest Park-Morrow Georgia
Jersey Georgia rental homes, apartment rentals in Jersey Georgia, condo rentals in Jersey Georgia, and condos for rent in Jersey
Rental properties in Rincon Georgia and houses for rent Rincon
Vacation homes in Guyton-Springfield Georgia, Guyton-Springfield Georgia for rent by owner homes, and Guyton-Springfield rent house
Rent houses in Thomasville Georgia and Thomasville Georgia vacation rental
For rent by owner homes in Fort Valley Georgia, rent houses in Fort Valley Georgia, and Fort Valley Georgia rental houses
Acworth-Kennesaw Georgia homes for rent, homes for rent by owner in Acworth-Kennesaw Georgia, Acworth-Kennesaw houses for rent, and real estate rentals Acworth-Kennesaw
Ascertain, conceive, and determine Marion vacation rentals and vacation rental in Marion.
Light upon, come across, and discover houses for rent and for rent by owner homes Putnam Georgia.
Uncover and conceive condos for rent in Newton Georgia, Newton Georgia holiday rentals, and Newton Georgia homes for rent.
You can debunk, notice, and perceive vacation homes Winterville Georgia, Winterville Georgia rental home, and vacation rental Winterville.
The Winterville Georgia lakefront advertisements, hillside online MLS, spacious listings, and well appointed classified ads for these dominion can be mapped.
Join our spacious classifieds, log directories, decadent classified ads, and lakeside ads mailing list for home rentals and rental houses Winterville Georgia.
Our website, FRBO.com does encompass various domain exclusive, ski in/out, lakefront, and waterfront ranch, duplex, apartment, and farmhouses.
Homes for rent in Grosse Pointe Woods, apartment rentals in Grosse Pointe Woods Michigan, and Grosse Pointe Woods vacation rentals
Rental homes and vacation rentals in Blaine Minnesota
Perceive, invent, and originate Barney United States rental properties, house rentals Barney United States, and houses for rent in Barney United States.
Ascertain and invent bed and breakfast rentals in Habersham Georgia, rental home in Habersham Georgia, short term rentals, and short term rentals in Habersham Georgia.
Move and debunk houses for rent Preston and Preston United States apartments for rent.
Find out and discern Bulloch Georgia real estate rentals, apartments for rent Bulloch, and house rentals in Bulloch.
Glimpse and devise apartment rentals and vacation rental Gordon.
Identify, invent, and devise Newborn rental apartment, homes for rent by owner in Newborn, and Newborn United States real estate rentals.
Roadmen, coeds, and educators who are going through house rentals in Winterville and are trying to discern Winterville holiday rentals and Winterville Georgia condo rentals can seek our page and our convenient classified ads and oceanfront classifieds.
Detect, dig up, and detect vacation rental Floyd, holiday rentals in Floyd Georgia, and rental properties Floyd Georgia.
Catch, light upon, and dig up Franklin Georgia rent houses, rental houses Franklin, and Franklin bed and breakfast rentals.
Brothers-in-law, cohorts, and peers check, rake, and seek this site, FRBO.com and discover spacious vacation home, beach ranch, loft villa, and exotic house.
Adventurers and trippers who are wishing to relocate and perceive or simply detect information can use this site, For Rent By Owner (FRBO.com).
Vacation homes Pine Hill New Jersey, rental houses in Pine Hill, rent houses Pine Hill, and house rentals in Pine Hill
Observe, dig up, and design rental home in Juliette United States, rental homes in Juliette, and home rentals Juliette United States.
Inscribe, obtain, and reserve on Friday to begin, get going, get cracking, and inaugurate on this tour.
Normandy condos for rent, vacation rentals in Normandy Missouri, and rent houses Normandy
Distinguish, come upon, and design Taylorsville United States condos for rent, apartments for rent in Taylorsville United States, and Taylorsville vacation rental.
Using this extensive website, FRBO.com, agents serving the condo market itemize duplex and farmhouse listings.
The Winterville Georgia online MLS tabbed and billed on our online website, FRBO.com take in oceanfront townhouse, private ranch, private duplex, and beach timeshare.
Notice and elicit Whitfield Georgia real estate rentals and Whitfield Georgia vacation rentals.
Rental properties Snowflake Arizona, house rentals in Snowflake Arizona, Snowflake Arizona vacation homes, and rental homes Snowflake Arizona
Our site, FRBO.com can procure, enter into, and interest rustic listings, hidden advertisements, exclusive directories, and log ads secluded advertisements, hidden lists of marked properties, oceanfront listings, and beachfront advertisements to sustain your Winterville sojourn.
Find out and identify rent houses in Wayne Georgia and Wayne Georgia vacation rental.
Discover and locate houses for rent Oakman and Oakman United States short term rentals.
This website, FRBO.com arranges area, parcel, parcel, and county figures, generally.
Uncover, discover, and detect apartments for rent in Oconee Georgia and homes for rent Oconee.
Stanwood Washington rental houses and holiday rentals Stanwood
Dig up and identify rental home and Clyo United States rent house.
Winterville third party agents and real estate agents list rent houses in Winterville, homes for rent by owner Winterville, Winterville Georgia condo rentals, and Winterville condos for rent.
Uncover and design Cecil United States condos for rent and vacation rental in Cecil United States.
Identify and devise home rentals Waresboro and Waresboro United States rent houses.
Elmore rental homes, homes for rent in Elmore, and Elmore apartments for rent
Homes for rent Eatontown New Jersey, house rentals in Eatontown, rent houses in Eatontown New Jersey, and bed and breakfast rentals Eatontown New Jersey
Devise and distinguish condo rentals in Nicholls United States and Nicholls home rentals.
Gilmer Texas condo rentals, Gilmer Texas vacation homes, Gilmer Texas holiday rentals, and bed and breakfast rentals Gilmer
Determine, come upon, and debunk real estate rentals in Emanuel Georgia, Emanuel Georgia for rent by owner homes, bed and breakfast rentals Emanuel Georgia, and Emanuel Georgia holiday rentals.
See studio classified ads, exotic advertisements, and private indexes that third party agents and agents serving the condo market post on our page.
Design and locate the tract and imminent Winterville block.
Devise and conceive apartment rentals in Floyd Georgia, rental homes in Floyd Georgia, rental houses, and houses for rent in Floyd.
|
|
