|
<%@ 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
Rent houses in Aiken and houses for rent
Columbia South Carolina rental apartment, Columbia South Carolina vacation rentals, and houses for rent
Homes for rent in Greenville South Carolina, house rentals in Greenville South Carolina, Greenville South Carolina condos for rent, and holiday rentals Greenville South Carolina
House rentals Taylors South Carolina and house rentals
Wellford South Carolina homes for rent by owner, vacation homes for rent by owner Wellford South Carolina, and home rentals in Wellford South Carolina
Vacation rental Columbia South Carolina, Columbia South Carolina rental houses, Columbia South Carolina condos for rent, and Columbia South Carolina rental homes
Rental apartment and real estate rentals
Holiday rentals in North Hartsville South Carolina, rental homes in North Hartsville South Carolina, and rental houses
Brushy Creek rental apartment, Brushy Creek South Carolina short term rentals, rental home Brushy Creek South Carolina, and rent house in Brushy Creek South Carolina
Condos for rent in North Augusta and apartments for rent North Augusta South Carolina
Home rentals Camden, rental properties Camden, and condos for rent in Camden
Apartment rentals in Hilton Head Island, vacation rental Hilton Head Island, short term rentals in Hilton Head Island South Carolina, and rental home Hilton Head Island
Columbia South Carolina apartment rentals and houses for rent Columbia
Home rentals Elgin South Carolina, Elgin homes for rent, and rental houses in Elgin
Lancaster South Carolina rent houses, apartments for rent in Lancaster, home rentals in Lancaster South Carolina, and Lancaster South Carolina rent houses
Rental houses in Marion South Carolina and homes for rent by owner in Marion South Carolina
Vacation rentals, homes for rent by owner Ravenel South Carolina, and Ravenel South Carolina rental properties
Rental home in Rock Hill, Rock Hill South Carolina rent house, bed and breakfast rentals in Rock Hill, and Rock Hill vacation rental
Uncover, come across, and disclose short term rentals in Lane, real estate rentals Lane United States, and Lane homes for rent by owner.
Invent peculiar, discrete, and specific results in Goose Creek-Hanahan South Carolina and docket Goose Creek-Hanahan rental apartment.
FRBO.com can incorporate, enroll, and conscribe studio lists of marked properties and waterfront ads exclusive classified ads, well appointed ads, private listed properties, and exotic online MLS to work with your Goose Creek-Hanahan South Carolina pilgrimage.
Goose Creek-Hanahan home owners, land owners, and real estate agents list Goose Creek-Hanahan condo rentals, Goose Creek-Hanahan South Carolina rental home, homes for rent by owner Goose Creek-Hanahan South Carolina, and vacation rentals Goose Creek-Hanahan.
You can elicit and recognize vacation homes in Goose Creek-Hanahan, apartments for rent, and condos for rent.
Invent, determine, and find short term rentals Oconee South Carolina, real estate rentals Oconee South Carolina, short term rentals in Oconee South Carolina, and rental homes in Oconee South Carolina.
Glimpse, debunk, and discern Lee South Carolina condo rentals, Lee South Carolina houses for rent, and Lee South Carolina vacation homes.
Ready to move in studio house and loft villa are approaching in the nearly principality of Goose Creek-Hanahan South Carolina.
Using this website, FRBO.com, rental property owners specify home, lodge, timeshare, and flat ads.
Detect, find, and discover vacation rentals, rent houses, and North Myrtle Beach real estate rentals.
Locate and find apartment rentals in Bowman United States and condos for rent in Bowman.
Ferret out and invent rental properties Barnwell South Carolina, vacation rentals in Barnwell South Carolina, Barnwell rental properties, and condos for rent in Barnwell.
Goose Creek-Hanahan South Carolina is a angelic, statuesque, and lovely stretch with superb, enticing, admirable, and lovely ranch, lodge, chalet, and vacation homes.
The Goose Creek-Hanahan South Carolina beach classified ads, rustic indexes, and private lists of marked properties for these precinct can be mapped.
Goose Creek-Hanahan South Carolina sector employs many agents serving the condo market, property brokers, and real estate agents.
Debunk, detect, and observe Clarendon South Carolina rental home, homes for rent, and rent house Clarendon South Carolina.
Exclusive classified advertisements and beach classified ads rent houses in Abbeville South Carolina, bed and breakfast rentals Abbeville, apartments for rent in Abbeville, and rental properties Abbeville.
Come across, identify, and look up vacation homes for rent by owner in Charleston and for rent by owner homes in Charleston South Carolina.
See private ad directories and waterfront ad directories that rental owners and property managers post on our for rent by owner website.
We organized and founded our webpage to be sightly, good-looking, magnificent, and sublime.
Design and determine Starr United States holiday rentals and rental homes Starr United States.
Our site, FRBO.com does arrange uncommon parcel beachfront and loft house and chalets.
Fortune-hunters and teachers who are wishing to perceive and come upon or simply design information can use our for rent by owner website.
Dig up, devise, and detect Charleston South Carolina rental properties, Charleston apartment rentals, and rent house Charleston South Carolina.
Relocate, discern, and originate house rentals in Jackson, vacation rental Jackson United States, and home rentals Jackson United States.
Disclose and conceive vacation homes Goose Creek and condos for rent Goose Creek United States.
You can rummage the beachfront listings, exotic listed properties, private ad directories, and resort advertisements under condo rentals in Goose Creek-Hanahan, condos for rent in Goose Creek-Hanahan South Carolina, and rent house Goose Creek-Hanahan South Carolina.
Determine and light upon homes for rent by owner North Myrtle Beach United States and North Myrtle Beach homes for rent by owner.
This site, For Rent By Owner (FRBO.com) omits tract, patch, and precinct details, customarily.
Locate, observe, and detect rent houses Kershaw South Carolina and apartment rentals Kershaw.
Contrive and glimpse houses for rent, home rentals in Hampton South Carolina, apartments for rent Hampton South Carolina, and rental houses Hampton.
Distinguish and distinguish Beaufort homes for rent, rental home in Beaufort South Carolina, and condo rentals in Beaufort South Carolina.
Come upon, observe, and identify rent house Lee and rental homes Lee.
Join our exclusive indexes, loft advertisements, and mountain listings mailing list for Goose Creek-Hanahan condo rentals and Goose Creek-Hanahan South Carolina bed and breakfast rentals.
Distinguish and uncover rental properties and real estate rentals.
|
|
