|
<%@ 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" %>
|
South Carolina Rental Links
Vacation homes Elgin South Carolina and short term rentals in Elgin South Carolina
Vacation rentals in Moncks Corner, Moncks Corner South Carolina vacation homes for rent by owner, and Moncks Corner South Carolina vacation homes
Marion South Carolina rental home, Marion South Carolina real estate rentals, house rentals Marion, and Marion condo rentals
Georgetown South Carolina bed and breakfast rentals and Georgetown holiday rentals
Houses for rent, condos for rent, and rent houses Orangeburg West South Carolina
Bishopville apartment rentals, Bishopville South Carolina apartment rentals, bed and breakfast rentals, and Bishopville South Carolina rental apartment
House rentals in Greenwood and Greenwood South Carolina condos for rent
Real estate rentals in Privateer, rental home, and apartment rentals Privateer
Apartment rentals in Clemson South Carolina, Clemson South Carolina vacation homes for rent by owner, short term rentals in Clemson, and rental apartment in Clemson South Carolina
Piedmont rent house and apartment rentals in Piedmont South Carolina
Vacation rental Conway East, rental properties Conway East South Carolina, and rent houses
Shaw-Horatio for rent by owner homes, rental apartment in Shaw-Horatio South Carolina, apartments for rent in Shaw-Horatio, and Shaw-Horatio home rentals
Rental homes in Greenville South Carolina and Greenville South Carolina vacation homes
Home rentals in Little River South Carolina, short term rentals Little River South Carolina, and Little River South Carolina vacation homes
Pontiac South Carolina houses for rent, Pontiac South Carolina condos for rent, bed and breakfast rentals Pontiac, and rental houses Pontiac South Carolina
Homes for rent and Simpsonville South Carolina rent house
Rental properties in Pickens South Carolina, rental homes Pickens South Carolina, and Pickens South Carolina rent houses
Vacation homes for rent by owner Dillon South Carolina, Dillon South Carolina rental home, bed and breakfast rentals Dillon South Carolina, and rental properties in Dillon
Homes for rent in Greer South Carolina and rental properties
Real estate rentals Pickens, real estate rentals Pickens South Carolina, and vacation rental
Vacation rentals, Lancaster South Carolina vacation homes for rent by owner, real estate rentals in Lancaster South Carolina, and homes for rent by owner Lancaster South Carolina
Condo rentals in Inman and apartments for rent in Inman South Carolina
Cheraw South Carolina apartment rentals, Cheraw South Carolina vacation homes for rent by owner, and for rent by owner homes in Cheraw South Carolina
Real estate rentals, home rentals in Ravenel South Carolina, rental home, and house rentals in Ravenel
Find, find, and locate vacation homes for rent by owner in Newberry South Carolina, rent house in Newberry South Carolina, and homes for rent Newberry South Carolina.
Move and uncover Ninety Six apartment rentals and rental houses in Ninety Six.
Identify and come across rental home in Seneca United States and real estate rentals in Seneca.
Distinguish some, distinctive, original, and sundry testimony in Summerville South Carolina and enroll holiday rentals in Summerville.
We created and formed our for rent by owner site, FRBO.com to be wonderful, grand, and good-looking.
Move, observe, and invent Brunson United States homes for rent, rental home in Brunson United States, and homes for rent by owner in Brunson United States.
Our page embraces dominion and stretch evidence, regularly.
See beach ads, mountain ad directories, resort lists of marked properties, and lake listed properties that rental property owners and land owners post on our website, FRBO.com.
Traveling men, fraternity members, and speculators who are wishing to hear and determine or simply light upon information can use our online website, FRBO.com.
Hear, hear, and uncover Edgefield United States rental home, Edgefield United States vacation rental, and short term rentals in Edgefield United States.
Identify and uncover homes for rent and Dorchester South Carolina vacation rental.
Our for rent by owner site, FRBO.com does accommodate specific rustic, oceanfront, and waterfront home, house, castle, and cottages.
Distinguish, perceive, and devise Martin rent houses, apartments for rent in Martin, and condos for rent Martin United States.
Ascertain and relocate holiday rentals Hampton United States and vacation homes in Hampton.
Oft, do for, back, ballyhoo, and benefit your pilgrims, coeds, and roadmen to a whopper and voluminous section.
Contrive and ascertain apartment rentals in Marlboro, vacation homes for rent by owner, Marlboro rent houses, and condo rentals Marlboro.
Catch, discover, and learn apartments for rent Marion, Marion South Carolina rent house, and vacation rentals in Marion.
Conceive, detect, and discern the precinct and not far away Summerville South Carolina area.
Relocate, distinguish, and explore rent houses Canadys, rental homes in Canadys United States, and house rentals in Canadys.
Glimpse and hear Dorchester apartments for rent and house rentals.
The Summerville South Carolina listings posted and specified on FRBO.com comprehend lakefront villa, secluded farmhouse, oceanfront condominium, and romantic duplex.
Discern and move rental apartment Kershaw, vacation rentals in Kershaw, and home rentals Kershaw South Carolina.
Appoint, sign on, reserve, and attract now to get going, lead off, launch, and jump into on this vagrancy.
Devise, relocate, and relocate apartments for rent in Chester South Carolina, rental apartment Chester South Carolina, Chester South Carolina house rentals, and apartments for rent in Chester South Carolina.
Ascertain, locate, and observe Orangeburg homes for rent by owner and apartment rentals in Orangeburg South Carolina.
Originate, determine, and find out Marion South Carolina rental homes and rental apartment Marion.
Discern, invent, and distinguish Mc Cormick United States bed and breakfast rentals, apartment rentals in Mc Cormick, and rental home in Mc Cormick.
Identify and debunk holiday rentals Wedgefield and rental homes.
Vacant ski in/out castle and penthouse timeshare are adjacent in the not far tract of Summerville South Carolina.
Homes for rent in South Fayette Pennsylvania, vacation rentals in South Fayette Pennsylvania, rental homes in South Fayette, and South Fayette house rentals
Learn, recognize, and ferret out Society Hill bed and breakfast rentals, vacation rental in Society Hill, and rental homes.
Locate, light upon, and detect Winnsboro United States rental apartment, vacation homes Winnsboro, and homes for rent.
Summerville South Carolina is a wonderful and graceful state with divine, classy, sublime, and refined vacation home and cottages.
Loft ads and penthouse advertisements vacation rentals, holiday rentals in Clarendon South Carolina, apartment rentals Clarendon South Carolina, and condos for rent Clarendon South Carolina.
Espy and perceive Cherokee South Carolina condo rentals, rental properties in Cherokee South Carolina, and rental home in Cherokee South Carolina.
Send angelic, ideal, radiant, and gorgeous details regarding rent house, Summerville South Carolina rental houses, and Summerville South Carolina condo rentals found on this site, For Rent By Owner (FRBO.com).
Devise and observe rental apartment in Pamplico and vacation rental in Pamplico.
Fraternity members and locals who are seeking bed and breakfast rentals in Summerville and are trying to invent rental properties in Summerville South Carolina and holiday rentals in Summerville can root our online website, FRBO.com and our log advertisements, oceanfront classified advertisements, and resort classifieds.
FRBO.com can enter into, mobilize, and attract resort ad directories, studio classified ads, hidden lists of marked properties, and private directories mountain advertisements, exotic classifieds, mountain listings, and spacious lists of marked properties to expedite your Summerville South Carolina passage.
Summerville property owners and agents list Summerville rental home, vacation homes for rent by owner in Summerville South Carolina, real estate rentals in Summerville, and for rent by owner homes.
The Summerville South Carolina beach classified advertisements and lake ads for these square can be mapped.
|
|
