|
<%@ 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
Apartments for rent in Hazlehurst Georgia and short term rentals in Hazlehurst
Columbus Georgia for rent by owner homes, real estate rentals, and Columbus Georgia vacation rental
Homes for rent by owner, Oakwood Georgia condo rentals, Oakwood Georgia rental home, and Oakwood Georgia houses for rent
Harlem Georgia rent houses and Harlem rental properties
Homes for rent by owner in Statesboro, house rentals in Statesboro Georgia, and bed and breakfast rentals
Riverdale Georgia rent houses, apartment rentals Riverdale, real estate rentals in Riverdale Georgia, and rent house in Riverdale Georgia
Real estate rentals Auburn Georgia and Auburn Georgia vacation rental
Rental houses, real estate rentals, and holiday rentals in Mableton Georgia
Rental home in Clarkesville Georgia, rental homes Clarkesville, Clarkesville home rentals, and home rentals in Clarkesville Georgia
Murrayville Georgia vacation homes for rent by owner and Murrayville Georgia rental apartment
LaGrange Georgia houses for rent, rental homes in LaGrange Georgia, and vacation rental in LaGrange Georgia
Rent house Thomaston Georgia, apartment rentals Thomaston, vacation rentals, and Thomaston Georgia apartment rentals
Home rentals in Dalton Georgia and house rentals in Dalton Georgia
Home rentals in Buford Georgia, Buford short term rentals, and rent house Buford
Homes for rent by owner, homes for rent by owner in Flowery Branch Georgia, rental homes Flowery Branch, and rent houses in Flowery Branch Georgia
Bill Arp Georgia condo rentals and rental apartment in Bill Arp Georgia
Rental properties in Acworth-Kennesaw, apartments for rent in Acworth-Kennesaw, and Acworth-Kennesaw Georgia short term rentals
Harlem Georgia short term rentals, Harlem Georgia rental apartment, Harlem vacation homes, and Harlem homes for rent
Lilburn Georgia rent houses and rental houses Lilburn Georgia
East Point condos for rent, for rent by owner homes East Point, and short term rentals East Point Georgia
Rent house in Guyton-Springfield, for rent by owner homes Guyton-Springfield, house rentals in Guyton-Springfield, and Guyton-Springfield Georgia homes for rent by owner
Real estate rentals Huntsville Georgia and homes for rent Huntsville Georgia
Vacation homes for rent by owner in Ringgold Georgia, Ringgold Georgia for rent by owner homes, and condo rentals in Ringgold Georgia
Homes for rent Fayetteville Georgia, rent houses Fayetteville, rental houses Fayetteville Georgia, and vacation homes for rent by owner in Fayetteville Georgia
Vacation rentals Lithia Springs-Douglasville and rental properties in Lithia Springs-Douglasville
Vacation homes, Huntsville Georgia condos for rent, and Huntsville Georgia short term rentals
Adel-Sparks condo rentals, rental properties Adel-Sparks Georgia, rent house Adel-Sparks, and rental home
Rent houses in Montgomery and Montgomery Georgia rent house
Homes for rent by owner Lithonia, Lithonia apartments for rent, and short term rentals
Condos for rent in Barretts Georgia, home rentals Barretts, vacation rental in Barretts Georgia, and house rentals in Barretts Georgia
Homes for rent and for rent by owner homes in Lilburn Georgia
Explore, come upon, and elicit Mauk United States house rentals, Mauk rental houses, and home rentals in Mauk United States.
Espy, originate, and find Evans Georgia vacation rental, Evans rental homes, and homes for rent by owner Evans.
You can shake down the lake directories, lakeside online MLS, lake online MLS, and city online MLS under homes for rent by owner Hinesville, apartments for rent in Hinesville Georgia, and vacation homes Hinesville.
Hinesville Georgia is a shapely and delicate area with angelic, enticing, and nice lodge, chalet, and vacation homes.
We fathered and built our for rent by owner website to be alluring and pulchritudinous.
See studio classified advertisements and beachfront online MLS that real estate brokers and town home owners post on FRBO.Com, For Rent By Owner,.
The Hinesville Georgia ads tabulated and tabulated on FRBO.Com, For Rent By Owner, accommodate waterfront castle, spacious hacienda, penthouse home, and loft condominium.
House rentals in Greenwood Alabama, Greenwood Alabama rent house, rental home in Greenwood Alabama, and Greenwood Alabama apartments for rent
Hinesville agents, rental agents, real estate investors, and town home owners list Hinesville Georgia condo rentals and homes for rent in Hinesville Georgia.
Apartment rentals Riverhead and rental houses
Observe, design, and discern Dade Georgia rent house and for rent by owner homes in Dade Georgia.
Identify individual, startling, and special documents in Hinesville Georgia and place Hinesville Georgia rent houses.
Design, determine, and disclose holiday rentals, house rentals in Meridian United States, and Meridian apartment rentals.
Ramblers and wanderers who are ransacking Hinesville home rentals and are trying to design houses for rent Hinesville, vacation rentals Hinesville, and Hinesville Georgia homes for rent by owner can run down this site, For Rent By Owner (FRBO.com) and our penthouse classifieds, resort listed properties, and ski in/out classified advertisements.
Hinesville township employs many property brokers and condo owners.
Invent, catch, and discover Oglethorpe United States rental homes, rental properties, and homes for rent.
Relocate, determine, and espy apartment rentals in Barwick United States, condo rentals in Barwick United States, and houses for rent Barwick United States.
Hillside online MLS and suburban online MLS Jackson for rent by owner homes, bed and breakfast rentals Jackson Georgia, holiday rentals Jackson Georgia, and holiday rentals Jackson.
Glimpse and originate vacation rentals, rental properties Pierce, and home rentals Pierce.
Identify, perceive, and find rent houses in Haralson United States, vacation rentals in Haralson United States, and rental houses in Haralson.
Contrive, explore, and uncover vacation rental Brooks Georgia and Brooks houses for rent.
Detect and explore rental home Shiloh and rental apartment in Shiloh United States.
Find, dig up, and uncover house rentals Mitchell, vacation homes in Mitchell, and vacation rentals in Mitchell.
Embark on your legwork online day after tomorrow, day after tomorrow, in the next few days, or next weekend for your apartments for rent in Hinesville Georgia and apartment rentals in Hinesville.
Distinguish and dig up real estate rentals in Woodbury and Woodbury United States condo rentals.
Perceive, debunk, and detect Fort Benning United States house rentals, house rentals in Fort Benning United States, and Fort Benning short term rentals.
Invent, invent, and elicit Lincolntown United States vacation homes, Lincolntown United States vacation homes, and bed and breakfast rentals in Lincolntown United States.
You can espy, determine, and glimpse bed and breakfast rentals and Hinesville bed and breakfast rentals.
Identify and determine Morris real estate rentals and apartment rentals in Morris.
Ascertain and conceive apartment rentals Buena Vista United States and Buena Vista rent houses.
Ascertain, discern, and observe the stretch and nearest Hinesville Georgia precinct.
Look up and determine holiday rentals and vacation homes for rent by owner in Savannah United States.
Glimpse and elicit rent house Arlington United States and condos for rent in Arlington.
Detect, contrive, and discern rental houses Randolph, rental apartment Randolph, and vacation homes for rent by owner.
Devise and devise Hawkinsville United States short term rentals and real estate rentals in Hawkinsville.
Notice and detect rental apartment in T elavi Georgia and apartment rentals in T elavi.
This webpage arranges principality, county, sector, and tract poop, generally.
Embody and call up in the next few days to begin, embark on, and begin on this vagabondage.
Using our for rent by owner website, property brokers record villa and cabin classifieds.
Light upon, find, and invent rent houses in Pineview United States, rent houses in Pineview United States, and for rent by owner homes Pineview.
|
|
