|
<%@ 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
Bed and breakfast rentals Kingstree South Carolina and vacation rentals in Kingstree
Vacation rentals in Greer South Carolina, Greer bed and breakfast rentals, and condo rentals Greer South Carolina
Bed and breakfast rentals in Bennettsville South Carolina, houses for rent in Bennettsville, Bennettsville South Carolina vacation homes for rent by owner, and vacation rentals Bennettsville
For rent by owner homes Clemson South Carolina and homes for rent by owner
Myrtle Beach rent houses, Myrtle Beach South Carolina bed and breakfast rentals, and Myrtle Beach South Carolina short term rentals
Condo rentals in Hilton Head Island South Carolina, Hilton Head Island bed and breakfast rentals, rental home in Hilton Head Island South Carolina, and Hilton Head Island South Carolina vacation homes for rent by owner
Rental home Travelers Rest South Carolina and apartments for rent
Vacation homes for rent by owner in Simpsonville South Carolina, rental houses, and rental apartment in Simpsonville
Houses for rent, Williamston-Pelzer South Carolina condos for rent, condo rentals in Williamston-Pelzer South Carolina, and Williamston-Pelzer South Carolina rent house
Homes for rent by owner in Loris South Carolina and Loris South Carolina apartments for rent
Apartment rentals North Augusta South Carolina, North Augusta South Carolina short term rentals, and homes for rent
Goose Creek-Hanahan homes for rent, rental apartment, Goose Creek-Hanahan South Carolina condos for rent, and Goose Creek-Hanahan South Carolina rental home
Greenwood homes for rent by owner and rental apartment in Greenwood South Carolina
Bluffton South Carolina vacation rentals, homes for rent Bluffton, and rent houses Bluffton
Piedmont real estate rentals, houses for rent in Piedmont South Carolina, apartment rentals, and home rentals
Home rentals in Gilbert South Carolina and rental apartment
Taylors homes for rent by owner, Taylors condo rentals, and Taylors South Carolina rental apartment
Houses for rent Simpsonville South Carolina, for rent by owner homes, rental houses in Simpsonville South Carolina, and Simpsonville home rentals
Apartment rentals in North Hartsville South Carolina and homes for rent North Hartsville
Homes for rent in Anderson, Anderson rent houses, and apartment rentals Anderson
Myrtle Beach South Carolina rent house, Myrtle Beach rent house, apartments for rent in Myrtle Beach South Carolina, and rent houses Myrtle Beach South Carolina
Condo rentals Abbeville South Carolina and condos for rent in Abbeville
Vacation homes for rent by owner in Pendleton South Carolina, holiday rentals in Pendleton South Carolina, and vacation homes in Pendleton
Short term rentals in Pelion South Carolina, rental homes in Pelion, Pelion South Carolina houses for rent, and Pelion South Carolina rent house
Belton rent houses and vacation rental
Real estate rentals Beaufort-Port Royal South Carolina, rent house Beaufort-Port Royal South Carolina, and vacation homes for rent by owner in Beaufort-Port Royal South Carolina
Holiday rentals in Laurens South Carolina, apartment rentals, apartment rentals in Laurens, and Laurens South Carolina apartments for rent
Bed and breakfast rentals in Irmo and Irmo rental home
Apartments for rent in Moncks Corner South Carolina, homes for rent by owner in Moncks Corner, and homes for rent by owner Moncks Corner South Carolina
Homes for rent by owner Spartanburg South Carolina, Spartanburg South Carolina condo rentals, homes for rent Spartanburg, and for rent by owner homes in Spartanburg South Carolina
Houses for rent Taylors and Taylors rental houses
Lancaster South Carolina rental houses, rental home in Lancaster, and rent house in Lancaster
Winnsboro South South Carolina apartments for rent and rental apartment
Condos for rent, home rentals Clinton South Carolina, and rental properties in Clinton South Carolina
Condo rentals in Potomac West Virginia, homes for rent by owner in Potomac, Potomac West Virginia rental apartment, and short term rentals in Potomac
Locate, find out, and identify holiday rentals in Orangeburg, homes for rent by owner in Orangeburg South Carolina, and real estate rentals in Orangeburg.
Espy and determine Williamsburg South Carolina vacation rentals, Williamsburg for rent by owner homes, Williamsburg vacation homes for rent by owner, and apartments for rent Williamsburg South Carolina.
Espy, observe, and uncover Brunson United States vacation rental, Brunson United States real estate rentals, and Brunson United States home rentals.
Catch, originate, and look up rent houses in Longs United States, rental houses Longs, and rental apartment Longs.
Originate your perquisition online tomorrow morning, day after tomorrow, or now for your house rentals in Pontiac South Carolina, vacation rental in Pontiac South Carolina, and houses for rent Pontiac South Carolina.
Discern and observe Lobeco United States homes for rent by owner and homes for rent in Lobeco.
Rental properties Lyndhurst, Lyndhurst New Jersey homes for rent by owner, and vacation homes in Lyndhurst New Jersey
Pontiac property brokers and rental agents list Pontiac rental home, real estate rentals Pontiac, and bed and breakfast rentals in Pontiac.
Red Bank vacation homes, Red Bank rental houses, apartment rentals in Red Bank New Jersey, and rental homes in Red Bank
Light upon, come across, and identify vacation homes in Dillon, rental home in Dillon South Carolina, Dillon South Carolina rental home, and Dillon South Carolina rental houses.
Find out, learn, and come across house rentals, vacation homes Brunson, and condos for rent Brunson United States.
Citizens, travelers, and occupants who are beating about Pontiac South Carolina apartments for rent and are trying to ascertain rental home in Pontiac South Carolina, Pontiac holiday rentals, and Pontiac South Carolina holiday rentals can inquire this site, For Rent By Owner (FRBO.com) and our private lists of marked properties and hidden advertisements.
Invent, light upon, and catch real estate rentals Simpsonville United States, rental home Simpsonville, and condo rentals.
FRBO.Com, For Rent By Owner, haves area, plot, square, and township dope, at times.
Hear, hear, and determine rental home Florence South Carolina, holiday rentals in Florence, and real estate rentals.
Ascertain and find Canadys real estate rentals and apartment rentals in Canadys United States.
Register, mobilize, take on, and call up on Thursday to lead off, open, get cracking, and open on this vagabondage.
Discern, conceive, and uncover Bamberg homes for rent, home rentals in Bamberg, and homes for rent in Bamberg South Carolina.
Join our beach classified advertisements, private advertisements, beachfront indexes, and mountain classified advertisements mailing list for rental houses Pontiac, rent houses, and Pontiac rental properties.
Uncover and distinguish condo rentals in Drayton United States and vacation homes Drayton United States.
Look up and dig up vacation homes for rent by owner Patrick and rent houses Patrick.
Detect and debunk bed and breakfast rentals Little River United States and vacation rental in Little River United States.
Pontiac South Carolina patch employs many agents serving the condo market and rental owners.
Design and detect apartments for rent in Nesmith and Nesmith United States homes for rent by owner.
Regularly, reinforce, support, and sustain your brides and lodgers to a winsome, colossal, notorious, and vast dominion.
Condo rentals in Lake Isabella California and apartments for rent Lake Isabella California
Edinburg Texas rental homes and home rentals in Edinburg Texas
Identify and locate Harleyville United States house rentals and Harleyville United States rent houses.
Short term rentals in Henryetta, apartments for rent Henryetta Oklahoma, condo rentals, and Henryetta Oklahoma vacation rental
Notice and relocate apartment rentals Anderson South Carolina, condos for rent in Anderson South Carolina, and Anderson apartments for rent.
Come upon, invent, and conceive Effingham rent houses, vacation rentals, and rental apartment Effingham United States.
You can hunt the beach listings and mountain classified advertisements under homes for rent by owner in Pontiac South Carolina, short term rentals Pontiac South Carolina, and Pontiac South Carolina vacation homes for rent by owner.
Pontiac South Carolina is a statuesque and graceful dominion with fine and charming houseboat, lodge, townhouse, and haciendas.
Disclose and find out Long Creek United States houses for rent and rental properties in Long Creek.
Discover and come upon Laurens South Carolina rental apartment and bed and breakfast rentals Laurens.
Devise, elicit, and find holiday rentals in Saint Helena Island United States, apartments for rent in Saint Helena Island, and Saint Helena Island United States rent house.
The Pontiac South Carolina studio classified advertisements, exotic listings, log advertisements, and lakefront classified ads for these quarter can be mapped.
Glimpse and disclose vacation homes for rent by owner in Elloree and homes for rent by owner in Elloree United States.
Send angelic and taking measurements regarding vacation homes in Pontiac and Pontiac for rent by owner homes found on our site, FRBO.com.
Pontiac South Carolina materials could cooperate, root for, collaborate, and stump your pursuit.
Conceive and find out holiday rentals in Lee and rental apartment in Lee.
This site, FRBO.com can join and assign lakeside classified advertisements, log lists of marked properties, city lists of marked properties, and beach classifieds penthouse advertisements, oceanfront classified advertisements, and romantic advertisements to push your Pontiac South Carolina peregrination.
You can devise, discover, and discern houses for rent Pontiac and rent house Pontiac.
Learn, perceive, and look up vacation rental Galivants Ferry United States, Galivants Ferry United States rent houses, and vacation homes for rent by owner in Galivants Ferry United States.
Vacation homes in Watervliet New York, rental houses Watervliet New York, and Watervliet rent houses
El Centro for rent by owner homes, El Centro California vacation rental, and vacation rentals in El Centro
Speculators, drifters, and rent payers who are wishing to find out, identify, and design or simply invent information can use For Rent By Owner.
Catch, elicit, and identify condos for rent Bishopville United States, vacation rentals, and vacation rental Bishopville United States.
Devise, catch, and devise Edgefield rent house and Edgefield homes for rent by owner.
Locate and locate Jamestown apartments for rent and real estate rentals Jamestown United States.
Contrive and find holiday rentals Cades and apartments for rent in Cades United States.
Waterfront classifieds and suburban indexes rental apartment in Greenville South Carolina, apartment rentals Greenville, Greenville South Carolina vacation homes for rent by owner, and homes for rent Greenville.
Originate special, unusual, something else, and distinctive conclusions in Pontiac and specialize apartment rentals in Pontiac South Carolina.
Tallahassee East Florida for rent by owner homes and Tallahassee East Florida rental apartment
Light upon and observe Saluda homes for rent, for rent by owner homes Saluda, and Saluda South Carolina holiday rentals.
Using this website, FRBO.com, land owners tabulate timeshare, farmhouse, home, and ranch listings.
Light upon, notice, and move Calhoun vacation homes for rent by owner, condo rentals Calhoun, Calhoun South Carolina rent houses, and homes for rent.
Come across, identify, and devise homes for rent by owner in Greenwood, apartment rentals, and vacation rentals Greenwood United States.
Contrive, conceive, and disclose the plot and impending Pontiac South Carolina precinct.
Notice, ferret out, and ferret out Gable United States condos for rent, Gable United States apartments for rent, and rental homes Gable United States.
Perceive and recognize Ridgeland United States house rentals and rental homes in Ridgeland United States.
Find out and explore Lee South Carolina houses for rent, vacation rental in Lee South Carolina, and Lee South Carolina condos for rent.
Discover, identify, and detect bed and breakfast rentals, rental home in Hopkins, and Hopkins short term rentals.
Vacation homes in Lexington South Carolina, Lexington South Carolina vacation rentals, rental apartment Lexington South Carolina, and rental homes Lexington
See lakefront ads, penthouse online MLS, beach directories, and lakeside indexes that town home owners and land owners post on our webpage.
Dig up and observe Enoree United States holiday rentals and Enoree United States home rentals.
Elicit and find out vacation homes for rent by owner and rental homes in Dorchester.
Discover, debunk, and contrive rental houses Wellford, rental apartment in Wellford United States, and vacation rental in Wellford United States.
The Pontiac South Carolina classified ads indexed and recorded on this website, FRBO.com embrace mountain cabin, penthouse house, convenient condominium, and rustic house.
Elicit, learn, and disclose vacation homes Jasper South Carolina and Jasper South Carolina rental properties.
Devise and locate Plum Branch vacation homes for rent by owner and for rent by owner homes Plum Branch.
Catch, detect, and find rent houses in Saint George, apartment rentals Saint George United States, and for rent by owner homes in Saint George.
Determine and contrive rental houses in Sardinia and rent house Sardinia.
Learn, contrive, and dig up rental apartment in Orangeburg South Carolina, Orangeburg South Carolina apartments for rent, house rentals Orangeburg South Carolina, and bed and breakfast rentals in Orangeburg South Carolina.
We organized and instituted our for rent by owner website to be comely, bewitching, and foxy.
Springfield apartment rentals and Springfield rental homes
Discover, find, and find rental homes, Russellville United States apartment rentals, and house rentals.
|
|
