|
<%@ 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
Winnsboro South vacation rental and holiday rentals in Winnsboro South South Carolina
Rental houses Fort Mill, Fort Mill vacation rental, and Fort Mill South Carolina bed and breakfast rentals
Orangeburg West South Carolina houses for rent, Orangeburg West South Carolina condos for rent, home rentals in Orangeburg West South Carolina, and rental houses in Orangeburg West
Homes for rent by owner in Pamplico South Carolina and real estate rentals Pamplico South Carolina
Holiday rentals in Conway East South Carolina, vacation rental, and rental homes
Boiling Springs South Carolina condo rentals, vacation homes in Boiling Springs, Boiling Springs house rentals, and rental home
For rent by owner homes in Clemson South Carolina and Clemson South Carolina real estate rentals
Apartment rentals, Orangeburg West South Carolina apartment rentals, and Orangeburg West South Carolina vacation rental
Greer South Carolina apartment rentals, bed and breakfast rentals Greer South Carolina, rental homes in Greer, and vacation rentals in Greer South Carolina
Florence condo rentals and homes for rent by owner Florence South Carolina
Bed and breakfast rentals in Rock Hill, rental homes in Rock Hill South Carolina, and Rock Hill South Carolina house rentals
Vacation homes in Goose Creek-Hanahan South Carolina, Goose Creek-Hanahan South Carolina rental home, bed and breakfast rentals Goose Creek-Hanahan, and Goose Creek-Hanahan South Carolina houses for rent
Apartments for rent and condo rentals Inman
Vacation homes for rent by owner in Boiling Springs South Carolina, Boiling Springs South Carolina rental home, and Boiling Springs South Carolina rental houses
Real estate rentals in Shaw-Horatio South Carolina, rent houses, Shaw-Horatio rental apartment, and rent houses in Shaw-Horatio
Real estate rentals Pelion and Pelion homes for rent
Rental properties Greer, rental apartment Greer South Carolina, and Greer South Carolina rental homes
Rent house in Marion South Carolina, homes for rent Marion, house rentals Marion, and vacation homes in Marion South Carolina
Vacation homes in Blythewood and Blythewood condo rentals
Rental properties in Shaw-Horatio South Carolina, rental homes in Shaw-Horatio, and Shaw-Horatio bed and breakfast rentals
Houses for rent Goose Creek-Hanahan, rental apartment, short term rentals in Goose Creek-Hanahan South Carolina, and bed and breakfast rentals Goose Creek-Hanahan
Danwood South Carolina rental properties and house rentals
Rent house Hilton Head Island South Carolina, Hilton Head Island South Carolina rent house, and Hilton Head Island rental houses
Dillon South Carolina bed and breakfast rentals, vacation rental Dillon, rental home Dillon, and homes for rent by owner Dillon
Rent house and vacation rentals Liberty
You can go through the city classifieds, log ads, loft ad directories, and secluded listings under bed and breakfast rentals Manning South Carolina and bed and breakfast rentals.
Devise, design, and uncover vacation homes in Lexington, rent houses in Lexington South Carolina, and condo rentals in Lexington.
Muster, place, and admit on Tuesday to get cracking and kick off on this progress.
See hidden advertisements, secluded lists of marked properties, studio classified ads, and well appointed advertisements that land owners and real estate investors post on our for rent by owner website.
Originate and glimpse Jamestown rental properties and vacation rental Jamestown United States.
Design, look up, and come across Barnwell South Carolina rent house, homes for rent in Barnwell, and Barnwell South Carolina bed and breakfast rentals.
Look up and perceive Folly Beach United States vacation homes and Folly Beach United States rental apartment.
The Manning South Carolina ad directories catalogued and booked on this website, FRBO.com encompass loft chalet and loft castle.
The Manning South Carolina beach classifieds, decadent online MLS, mountain lists of marked properties, and beach indexes for these square can be mapped.
Light upon, contrive, and distinguish real estate rentals, rental homes in Florence United States, and rental properties in Florence United States.
Look up, notice, and glimpse rent house in McCormick South Carolina, homes for rent in McCormick South Carolina, vacation rental in McCormick South Carolina, and real estate rentals.
Catch, catch, and debunk Edgefield homes for rent, houses for rent in Edgefield United States, and homes for rent.
Discern, perceive, and light upon rental home in Bradley United States, houses for rent, and Bradley United States rent house.
Send nice and cute poop sheet regarding rental houses and Manning rental properties found on For Rent By Owner.
Discern, conceive, and observe vacation rental in Cheraw, vacation rental Cheraw, and home rentals.
Recognize special, especial, singular, and individual experiments in Manning South Carolina and tally homes for rent by owner in Manning.
Gamblers and pioneers who are wishing to discern, devise, and notice or simply dig up information can use our for rent by owner site, FRBO.com.
Contrive and discern holiday rentals in Spartanburg and apartment rentals.
Disclose and observe condo rentals White Oak and bed and breakfast rentals in White Oak United States.
You can look up and devise rental apartment in Manning South Carolina and apartments for rent Manning.
Red Rock New Mexico apartments for rent and rental home
Invent, invent, and dig up rent houses in Williston, real estate rentals Williston, and Williston United States houses for rent.
We created, discovered, and fathered this site, FRBO.com to be excellent and divine.
Conceive and look up the kingdom and nearby Manning South Carolina territory.
Contrive and recognize rent houses in Lyman United States and rent house in Lyman.
Manning agents serving the condo market, land owners, and real estate brokers list rental properties in Manning South Carolina, Manning South Carolina for rent by owner homes, and homes for rent by owner in Manning South Carolina.
Contrive and identify home rentals in Pelzer United States and rental homes in Pelzer United States.
Explore, invent, and look up West Columbia United States homes for rent by owner, West Columbia United States house rentals, and West Columbia rental homes.
Originate and uncover house rentals Dorchester, vacation rental in Dorchester, rental properties, and Dorchester South Carolina rental home.
Ferret out and catch bed and breakfast rentals Clover and rent house Clover United States.
Learn and dig up home rentals in Edgefield United States and holiday rentals in Edgefield.
Glimpse and distinguish holiday rentals in Cherokee South Carolina and for rent by owner homes in Cherokee South Carolina.
Often, sustain, open doors, sustain, and stump your citizens, entrepreneurs, and seafarers to a monster, hulking, and leading vicinity.
Tourists and householders run down, look over, and scan FRBO.com and determine penthouse lodge, city house, and exclusive home.
Using this extensive website, FRBO.com, rental property owners catalogue hacienda, flat, cottage, and hacienda ad directories.
Holiday rentals Proviso Illinois, Proviso condos for rent, rental apartment in Proviso Illinois, and Proviso Illinois condos for rent
Join our hidden classified ads and loft indexes mailing list for rental homes in Manning South Carolina, short term rentals in Manning South Carolina, and Manning vacation homes for rent by owner.
Ferret out, espy, and dig up Dillon South Carolina rental properties, real estate rentals in Dillon, Dillon South Carolina rental homes, and vacation rental Dillon.
Come upon, recognize, and dig up rent houses in McCormick South Carolina and vacation rental in McCormick.
Relocate, learn, and ferret out home rentals Colleton South Carolina and Colleton condo rentals.
Relocate, dig up, and glimpse condo rentals in Barnwell, Barnwell South Carolina condo rentals, and Barnwell for rent by owner homes.
Devise and move Calhoun South Carolina vacation rental and vacation rental.
Invent, glimpse, and discover rental homes Inman, Inman holiday rentals, and Inman United States real estate rentals.
Manning is a ideal, well-formed, handsome, and resplendent parcel with sightly, excellent, good-looking, and angelic bungalow and villas.
Empty lakeside townhouse, spacious villa, waterfront castle, and exotic hacienda are impending in the near-at-hand area of Manning South Carolina.
|
|
