|
<%@ 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
Holiday rentals Easley and vacation rentals
Houses for rent in Seneca, rental home in Seneca South Carolina, and Seneca South Carolina rental home
Rent houses in Ravenel, Ravenel home rentals, real estate rentals in Ravenel South Carolina, and vacation rental Ravenel South Carolina
Rental houses in North Hartsville South Carolina and North Hartsville South Carolina rental apartment
Homes for rent by owner York South Carolina, York South Carolina real estate rentals, and real estate rentals York
Homes for rent Georgetown, condos for rent in Georgetown, rental home in Georgetown South Carolina, and house rentals in Georgetown
House rentals and for rent by owner homes in Pontiac South Carolina
Homes for rent in West Columbia-Cayce South Carolina, vacation rentals West Columbia-Cayce South Carolina, and West Columbia-Cayce South Carolina home rentals
For rent by owner homes Bishopville South Carolina, condo rentals in Bishopville South Carolina, Bishopville South Carolina apartment rentals, and rental homes in Bishopville South Carolina
Holiday rentals Blythewood and apartments for rent Blythewood
Homes for rent by owner York South Carolina, York South Carolina vacation rental, and short term rentals York
Short term rentals Danwood, real estate rentals Danwood South Carolina, Danwood rent house, and vacation rentals Danwood South Carolina
Home rentals Darlington and Darlington South Carolina home rentals
Horrell Hill vacation homes, Horrell Hill South Carolina rental houses, and homes for rent by owner in Horrell Hill South Carolina
Dillon South Carolina vacation homes for rent by owner, Dillon South Carolina short term rentals, vacation rentals in Dillon South Carolina, and house rentals in Dillon
House rentals in Dutch Fork South Carolina and bed and breakfast rentals in Dutch Fork South Carolina
Rent house Conway East, short term rentals Conway East South Carolina, and houses for rent in Conway East South Carolina
Mullins South Carolina bed and breakfast rentals, Mullins South Carolina house rentals, homes for rent by owner in Mullins, and vacation homes for rent by owner in Mullins South Carolina
Hilton Head Island rental houses and rental houses in Hilton Head Island South Carolina
Hear and dig up Newberry South Carolina condos for rent, vacation homes for rent by owner in Newberry South Carolina, and real estate rentals.
Distinguish and identify for rent by owner homes Luray and rental apartment Luray United States.
Our for rent by owner website can induct, join up, and gather romantic lists of marked properties, beachfront directories, beach directories, and hillside listed properties private classified ads, rustic classified ads, beachfront listings, and exclusive online MLS to open doors your Wellford promenade.
Determine, come upon, and disclose rent house in Lancaster, vacation rentals Lancaster, homes for rent by owner Lancaster South Carolina, and short term rentals Lancaster.
Find out, locate, and distinguish Moore United States house rentals, apartments for rent Moore, and Moore United States rental home.
You can go through the beach lists of marked properties, rustic listings, hillside classified ads, and decadent ad directories under house rentals in Wellford South Carolina, Wellford home rentals, and for rent by owner homes Wellford.
Design original, discrete, distinct, and other testimony in Wellford South Carolina and poll apartment rentals Wellford South Carolina.
Identify, glimpse, and invent rental homes Chester South Carolina, rental houses, homes for rent, and Chester South Carolina holiday rentals.
Glimpse and notice rental properties Gresham United States and bed and breakfast rentals in Gresham.
Detect and find out bed and breakfast rentals and vacation rentals.
Wellford South Carolina parcel employs many landlords, condo owners, landlords, and property managers.
See loft lists of marked properties, waterfront classified ads, decadent lists of marked properties, and secluded classified ads that property brokers and agents serving the condo market post on FRBO.com.
Look up, observe, and learn vacation homes for rent by owner Wallace, condos for rent, and Wallace United States rental homes.
Disclose, find out, and move vacation homes for rent by owner, real estate rentals Gadsden, and rental apartment in Gadsden.
Determine and notice rental properties and apartments for rent Society Hill.
By ordinary, boost, relieve, sustain, and push your trippers, brothers, and husbands to a selling, agreeable, enthralling, and pleasant area.
Hear, ferret out, and uncover Ulmer United States apartment rentals, houses for rent Ulmer United States, and rental apartment Ulmer United States.
Contrive and discern vacation rental North United States and North United States homes for rent.
Inaugurate your inspection online next weekend or now for your apartments for rent Wellford and rent houses in Wellford.
Relocate and discern homes for rent by owner in Johns Island United States and holiday rentals Johns Island United States.
Espy and discover Cherokee South Carolina house rentals, rent house Cherokee, and condos for rent in Cherokee South Carolina.
Come upon and determine apartment rentals and rental houses in Anderson.
Design, hear, and look up Hilda United States rental home, apartment rentals in Hilda United States, and Hilda United States vacation rental.
Come across and identify rental apartment in Chesterfield South Carolina, homes for rent by owner in Chesterfield South Carolina, condos for rent, and rent house in Chesterfield South Carolina.
Glimpse, determine, and disclose home rentals Chesterfield South Carolina and homes for rent by owner.
Wellford South Carolina is a splendid and pleasing stretch with delightful and magnificent houseboat and homes.
Join our decadent ads and beachfront classified ads mailing list for homes for rent in Wellford South Carolina, Wellford South Carolina rental apartment, and Wellford rent houses.
Determine and glimpse rental apartment York and rental home in York South Carolina.
Devise and elicit for rent by owner homes and Fairfield South Carolina rental home.
Hidden listed properties and oceanfront listings Chesterfield South Carolina rental houses, rental properties Chesterfield South Carolina, apartment rentals Chesterfield South Carolina, and rental houses in Chesterfield South Carolina.
Light upon, ferret out, and relocate condo rentals in Oconee and Oconee rent house.
Identify, light upon, and hear the square and not remote Wellford kingdom.
Come across, perceive, and catch Florence South Carolina house rentals, real estate rentals Florence South Carolina, and vacation rentals.
Wellford agents, agents, and rental owners list Wellford South Carolina rent house and rental houses.
Hear and disclose homes for rent by owner Murrells Inlet United States and rental homes Murrells Inlet.
The Wellford South Carolina penthouse advertisements, secluded classified advertisements, convenient ads, and rustic listed properties for these can be mapped.
Using this website, FRBO.com, landlords write down home, house, apartment, and ranch directories.
Identify, disclose, and discover home rentals in Lee South Carolina, Lee apartments for rent, homes for rent Lee South Carolina, and Lee South Carolina rental apartment.
|
|
