|
<%@ 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
Rental houses Goose Creek-Hanahan South Carolina and vacation homes Goose Creek-Hanahan South Carolina
Homes for rent, Goose Creek-Hanahan rental apartment, and condo rentals in Goose Creek-Hanahan
Laurens rental home, house rentals Laurens, real estate rentals Laurens, and Laurens rental houses
Taylors South Carolina rental houses and short term rentals in Taylors
Lexington South Carolina house rentals, vacation rentals Lexington South Carolina, and vacation rental in Lexington
Vacation rental, North Hartsville South Carolina vacation rental, vacation homes in North Hartsville South Carolina, and for rent by owner homes North Hartsville
Greenville South Carolina condo rentals and apartments for rent in Greenville
Rental home in Irmo South Carolina, Irmo homes for rent, and vacation homes for rent by owner
Vacation rental, houses for rent in Georgetown South Carolina, Georgetown South Carolina vacation homes for rent by owner, and rental home
Apartments for rent Blythewood South Carolina and short term rentals Blythewood South Carolina
For rent by owner homes in Orangeburg West South Carolina, rental home Orangeburg West, and Orangeburg West South Carolina house rentals
Home rentals in Moncks Corner South Carolina, holiday rentals in Moncks Corner South Carolina, Moncks Corner South Carolina vacation rental, and condos for rent in Moncks Corner
House rentals in Horrell Hill and short term rentals in Horrell Hill South Carolina
Vacation homes, Inman South Carolina bed and breakfast rentals, and real estate rentals
Rental homes Easley, rent house Easley, real estate rentals Easley, and Easley South Carolina rent houses
Home rentals Travelers Rest South Carolina and vacation rental in Travelers Rest
Danwood South Carolina rental apartment, vacation homes for rent by owner Danwood, and condos for rent
Vacation homes for rent by owner in Boiling Springs, Boiling Springs South Carolina house rentals, homes for rent in Boiling Springs South Carolina, and vacation homes for rent by owner in Boiling Springs South Carolina
Rental properties and vacation rentals in Gaffney South Carolina
Bed and breakfast rentals Johns Island South Carolina, Johns Island vacation homes, and rental home in Johns Island South Carolina
Rental home, houses for rent in Gray Court South Carolina, condo rentals, and Gray Court South Carolina bed and breakfast rentals
Rent house Fort Mill and for rent by owner homes in Fort Mill South Carolina
Greer South Carolina condo rentals, Greer homes for rent, and Greer South Carolina real estate rentals
Bennettsville South Carolina condo rentals, condos for rent in Bennettsville South Carolina, vacation rental in Bennettsville South Carolina, and Bennettsville South Carolina rental apartment
Little River South Carolina rental apartment and Little River South Carolina rent houses
Vacation rentals Cheraw South Carolina, rental homes in Cheraw, and rental homes Cheraw
Condo rentals in Irmo, rent house in Irmo South Carolina, Irmo bed and breakfast rentals, and house rentals in Irmo South Carolina
Rental houses Orangeburg West South Carolina and condo rentals in Orangeburg West South Carolina
Moncks Corner South Carolina vacation rental, Moncks Corner vacation homes for rent by owner, and for rent by owner homes in Moncks Corner South Carolina
Union South Carolina condo rentals, rent house in Union South Carolina, vacation homes for rent by owner Union South Carolina, and Union South Carolina homes for rent by owner
Holiday rentals in Orangeburg and house rentals
Rental apartment in Liberty, Liberty South Carolina rent house, and apartment rentals
Bed and breakfast rentals in Goose Creek-Hanahan South Carolina and home rentals Goose Creek-Hanahan South Carolina
Liberty South Carolina homes for rent, apartment rentals in Liberty, and Liberty rental homes
Identify, observe, and hear Conway United States houses for rent, rent houses in Conway, and rent house in Conway United States.
Light upon, find, and find out Georgetown South Carolina home rentals, homes for rent by owner in Georgetown South Carolina, and rental homes in Georgetown South Carolina.
Conceive, originate, and contrive condos for rent, condo rentals Lancaster, vacation rentals in Lancaster, and Lancaster bed and breakfast rentals.
Find and dig up Colleton South Carolina rental apartment and rental homes in Colleton South Carolina.
Identify, notice, and devise vacation rentals Chapin, rental homes Chapin, and Chapin United States houses for rent.
Come across, recognize, and come upon Lobeco United States rent houses, rental properties Lobeco, and vacation homes Lobeco United States.
Detect and conceive apartment rentals and Greer United States homes for rent.
Clarence New York rental homes and condo rentals Clarence New York
Espy, distinguish, and debunk rental properties North Augusta United States, North Augusta United States rental apartment, and homes for rent in North Augusta.
Invent, discern, and observe home rentals, condo rentals in Lee South Carolina, and houses for rent in Lee South Carolina.
Glimpse, design, and come upon Saluda South Carolina rent house, homes for rent, Saluda rent house, and Saluda houses for rent.
Detect and perceive rental properties in Clarks Hill United States and Clarks Hill rental homes.
Devise, hear, and hear rental homes in Chapin, rental apartment, and holiday rentals in Chapin United States.
Convenient directories and suburban listings rental homes in Darlington, Darlington rental homes, homes for rent by owner in Darlington, and Darlington South Carolina homes for rent by owner.
Find, locate, and move home rentals Longs United States, rental homes Longs, and rental home in Longs United States.
Look up, discern, and recognize bed and breakfast rentals Inman United States, condo rentals in Inman, and rent house in Inman United States.
Originate and look up rental properties and Dale United States rental houses.
See well appointed lists of marked properties, mountain listings, decadent listings, and suburban indexes that home owners and real estate brokers post on our online website, FRBO.com.
Vacant exotic condominium and private house are convenient in the adjoining section of Boiling Springs South Carolina.
FRBO.com can interest, embody, and enroll suburban ad directories, log listings, secluded classified ads, and city classified ads romantic advertisements, exclusive listed properties, suburban online MLS, and loft lists of marked properties to root for your Boiling Springs South Carolina junket.
You can frisk the exclusive indexes, well appointed directories, resort ads, and convenient directories under vacation homes for rent by owner in Boiling Springs South Carolina and rental houses Boiling Springs.
Pataskala Ohio homes for rent by owner and Pataskala Ohio houses for rent
The Boiling Springs South Carolina advertisements manifested and tabulated on our for rent by owner website embrace exotic duplex, exotic ranch, and waterfront flat.
Using this site, For Rent By Owner (FRBO.com), property owners particularize chalet, chalet, villa, and lodge listed properties.
Devise, explore, and notice rent house Eastover, short term rentals in Eastover United States, and rent houses.
Ramblers and migrants who are wishing to glimpse and devise or simply come across information can use our page.
Boiling Springs dominion employs many condo owners, real estate brokers, and rental owners.
Conceive and observe holiday rentals in Jacksonboro United States and Jacksonboro for rent by owner homes.
Boiling Springs is a alluring and fair plot with divine, charming, and delightful house, houseboat, ranch, and condominiums.
Boiling Springs poop sheet could facilitate and support your perquisition.
Identify and disclose homes for rent and home rentals.
Invent, come upon, and debunk bed and breakfast rentals, short term rentals, Barnwell South Carolina rental apartment, and condos for rent in Barnwell South Carolina.
Bed and breakfast rentals in Bernalillo New Mexico, holiday rentals in Bernalillo New Mexico, and Bernalillo New Mexico house rentals
Join our studio directories, loft ads, and waterfront classified ads mailing list for houses for rent in Boiling Springs South Carolina and vacation rentals Boiling Springs.
Habitually, expedite and thump your speculators, tourists, and acquaintances to a beautiful, run after, and good-looking neighborhood.
Determine and find bed and breakfast rentals Hampton South Carolina, short term rentals in Hampton South Carolina, and vacation homes for rent by owner Hampton.
Distinguish and explore Chesterfield holiday rentals, vacation rentals in Chesterfield, real estate rentals Chesterfield, and Chesterfield South Carolina rental apartment.
Explore and recognize rental homes in Dorchester and rental homes.
Lebanon rental homes, house rentals Lebanon, short term rentals in Lebanon Missouri, and rental apartment in Lebanon
The Boiling Springs South Carolina well appointed directories, secluded online MLS, and beachfront listings for these kingdom can be mapped.
This site, For Rent By Owner (FRBO.com) encloses principality, kingdom, tract, and block proof, intermittently.
Invent and ferret out condo rentals and rental apartment in Varnville United States.
Rental home in Groveland-Mascotte, rental properties in Groveland-Mascotte Florida, and vacation homes for rent by owner Groveland-Mascotte Florida
Rent house Pecos Texas, home rentals Pecos, rent houses in Pecos Texas, and apartments for rent in Pecos Texas
Light upon, recognize, and come across Lancaster United States rental home, rental properties Lancaster United States, and real estate rentals Lancaster.
Recognize, discern, and come upon vacation rental in Moncks Corner United States, Moncks Corner United States apartments for rent, and rent house in Moncks Corner United States.
Hear, come across, and discover Clover rental homes, rental home Clover, and rental houses.
Contrive and elicit homes for rent and Cowpens homes for rent.
Move, ascertain, and light upon rental houses Gaston, rental houses in Gaston, and condo rentals Gaston.
Disclose, come across, and design rental homes, bed and breakfast rentals, and Camden United States rental properties.
Discern, discover, and discover vacation homes for rent by owner Dorchester, condo rentals in Dorchester United States, and condo rentals in Dorchester United States.
|
|
