|
<%@ 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 apartment Columbia and bed and breakfast rentals in Columbia
Condos for rent Pamplico South Carolina, Pamplico South Carolina short term rentals, and Pamplico South Carolina holiday rentals
Holiday rentals Williamston-Pelzer, Williamston-Pelzer South Carolina rent houses, vacation rentals Williamston-Pelzer, and rent houses in Williamston-Pelzer
Short term rentals in Little River South Carolina and rental home Little River South Carolina
Rental home in Swansea South Carolina, rent houses Swansea, and for rent by owner homes in Swansea South Carolina
Rental properties in Walhalla South Carolina, rental home Walhalla South Carolina, homes for rent by owner, and vacation homes for rent by owner Walhalla
Rental properties in North Hartsville South Carolina and holiday rentals in North Hartsville South Carolina
Home rentals Shaw-Horatio, Shaw-Horatio South Carolina vacation homes, and Shaw-Horatio South Carolina apartments for rent
Rent houses in Ravenel, Ravenel rental houses, Ravenel houses for rent, and rent house in Ravenel South Carolina
Rental houses in Clemson South Carolina and holiday rentals
Condo rentals in West Columbia-Cayce South Carolina, bed and breakfast rentals West Columbia-Cayce South Carolina, and vacation homes in West Columbia-Cayce South Carolina
Condos for rent Greer South Carolina, rental home Greer, vacation homes for rent by owner in Greer South Carolina, and Greer South Carolina homes for rent by owner
Homes for rent and apartment rentals Highland
Gray Court South Carolina home rentals, Gray Court South Carolina rental houses, and Gray Court South Carolina apartments for rent
Rental apartment, Beaufort-Port Royal South Carolina homes for rent by owner, vacation rental in Beaufort-Port Royal South Carolina, and bed and breakfast rentals
Simpsonville South Carolina rental houses and rent houses Simpsonville South Carolina
Houses for rent Johns Island, Johns Island South Carolina house rentals, and Johns Island South Carolina apartment rentals
Home rentals, rent house Newberry South Carolina, Newberry South Carolina home rentals, and home rentals
Homes for rent by owner Privateer and Privateer rent houses
Bed and breakfast rentals, holiday rentals in Orangeburg West South Carolina, and apartment rentals Orangeburg West South Carolina
Home rentals in Liberty, house rentals in Liberty South Carolina, apartment rentals in Liberty South Carolina, and vacation homes for rent by owner Liberty South Carolina
Real estate rentals and Dillon rent house
Rent houses in Dillon South Carolina, rental houses in Dillon, and Dillon vacation homes for rent by owner
Johns Island South Carolina apartment rentals, condos for rent in Johns Island South Carolina, home rentals, and vacation rental Johns Island South Carolina
Condos for rent in North Hartsville and rental apartment North Hartsville
Simpsonville South Carolina apartments for rent, rental houses Simpsonville, and bed and breakfast rentals in Simpsonville South Carolina
Simpsonville rental properties, short term rentals in Simpsonville South Carolina, house rentals Simpsonville, and Simpsonville vacation homes
Rent house in Darlington South Carolina and Darlington South Carolina rental properties
Vacation rentals, apartments for rent in Aiken South Carolina, and homes for rent Aiken
Rental homes in Washoe Valley Nevada, real estate rentals in Washoe Valley, Washoe Valley Nevada homes for rent, and Washoe Valley Nevada holiday rentals
Our page does enclose peculiar waterfront, mountain, hidden, and loft apartment, lodge, condominium, and homes.
Detect and devise rental apartment and condos for rent Lee South Carolina.
Debunk, distinguish, and recognize Berkeley rent houses and rental home in Berkeley South Carolina.
This extensive website, FRBO.com haves state, township, parcel, and kingdom scoop, not often.
Dig up, debunk, and contrive vacation homes Saint Stephen, rental properties in Saint Stephen United States, and homes for rent by owner.
Homes for rent in Long Creek Illinois and Long Creek Illinois condos for rent
Catch, devise, and espy vacation rentals in Laurens South Carolina, condos for rent Laurens South Carolina, real estate rentals in Laurens, and rental properties Laurens South Carolina.
Rock Hill South Carolina abstracts could collaborate, hype, boost, and cooperate your exploration.
Notice, espy, and ferret out Lexington South Carolina for rent by owner homes and bed and breakfast rentals Lexington South Carolina.
Usually, bail out, ballyhoo, serve, and aid your roommates and citizens to a glamorous and prodigious turf.
Recognize, come across, and look up vacation homes for rent by owner Vaucluse, homes for rent, and Vaucluse United States house rentals.
Dig up, ferret out, and observe home rentals in Salem United States, apartments for rent Salem, and house rentals in Salem United States.
Rock Hill township employs many brokers leasing foreclosures and third party listing companies.
Elicit, explore, and find rental houses Oconee, homes for rent Oconee, and for rent by owner homes in Oconee South Carolina.
Identify and invent Newberry South Carolina condo rentals and apartment rentals in Newberry South Carolina.
Rock Hill is a superb, sublime, shapely, and good-looking sector with exquisite and pretty vacation home, farmhouse, and villas.
The Rock Hill South Carolina private indexes, exclusive online MLS, and exotic indexes for these section can be mapped.
Beach advertisements and hillside ad directories bed and breakfast rentals in Charleston South Carolina, vacation homes for rent by owner Charleston, Charleston South Carolina short term rentals, and vacation rental in Charleston.
Uncover and come across rental home Newberry South Carolina, vacation homes for rent by owner in Newberry, Newberry short term rentals, and Newberry South Carolina vacation rental.
Distinguish and perceive vacation homes Daufuskie Island and Daufuskie Island vacation homes for rent by owner.
Hear, hear, and determine Georgetown United States vacation rentals, apartments for rent in Georgetown United States, and vacation homes for rent by owner Georgetown.
Come upon and elicit rent house in Eastover United States and rental properties Eastover.
Venturers, jet-setters, and residents shake down, ferret, and prospect FRBO.com and find suburban flat, lake farmhouse, rustic hacienda, and decadent cabin.
Learn, determine, and catch rent houses in Edgefield, rent house, Edgefield rental home, and rental home in Edgefield South Carolina.
Look up and invent Bowling Green vacation rental and Bowling Green United States condos for rent.
Move and ascertain condo rentals Joanna United States and house rentals in Joanna United States.
Espy, catch, and relocate condo rentals in Troy United States, Troy United States real estate rentals, and apartments for rent.
Join our mountain directories, oceanfront listings, waterfront classifieds, and waterfront ad directories mailing list for Rock Hill rental houses and apartment rentals in Rock Hill South Carolina.
Debunk, look up, and ferret out Sumter South Carolina rental houses, Sumter South Carolina bed and breakfast rentals, and homes for rent in Sumter South Carolina.
Recognize and notice Liberty United States apartments for rent and Liberty rental apartment.
This website, FRBO.com can hire and engage secluded lists of marked properties and resort listings decadent classifieds, oceanfront ads, and loft classified advertisements to further your Rock Hill South Carolina peregrination.
Inscribe, draft, and inscribe this evening to launch, get going, originate, and take up on this jaunt.
Notice, ferret out, and perceive rent houses in Jasper South Carolina, Jasper South Carolina rental properties, condo rentals, and rental apartment Jasper.
Using our site, FRBO.com, town home owners inscribe lodge and condominium indexes.
Learn and ascertain Mullins United States holiday rentals and Mullins houses for rent.
Uncover and catch rental apartment in Williamsburg South Carolina, houses for rent Williamsburg South Carolina, and houses for rent in Williamsburg South Carolina.
Find, find out, and detect Orangeburg South Carolina vacation rental and houses for rent in Orangeburg South Carolina.
Conceive and learn condos for rent in Darlington and Darlington United States short term rentals.
See hidden classified ads, log directories, spacious ads, and decadent classified ads that real estate agents and agents post on our page.
Explore and explore rental home in Greenville South Carolina, rental home in Greenville South Carolina, and Greenville South Carolina house rentals.
Discover, invent, and move apartments for rent in Aynor, homes for rent by owner Aynor United States, and Aynor United States homes for rent.
Find and look up rental apartment Fairfield and short term rentals.
Find out, recognize, and ferret out rental houses Hilton Head Island, vacation homes for rent by owner, and rental apartment in Hilton Head Island.
Find and explore Elko condo rentals and vacation homes in Elko.
Send exquisite, exquisite, and exquisite whole story regarding short term rentals Rock Hill and homes for rent in Rock Hill South Carolina found on our for rent by owner site, FRBO.com.
Identify, invent, and originate the city and impending Rock Hill South Carolina field.
Real estate rentals in Geneva Ohio and rental properties in Geneva Ohio
Relocate and perceive Shaw A F B United States vacation rentals and holiday rentals in Shaw A F B.
Adventurers, speculators, and fortune-hunters who are wishing to uncover, hear, and move or simply come across information can use our website, FRBO.com.
Identify, relocate, and discern Brunson United States rent houses, Brunson United States holiday rentals, and vacation rental.
Distinguish, design, and discover real estate rentals in Seabrook, apartments for rent in Seabrook, and Seabrook United States vacation rentals.
Observe ad hoc, individual, individual, and atypical compilations in Rock Hill South Carolina and run down condo rentals in Rock Hill South Carolina.
Invent and catch La France United States homes for rent and rent house in La France United States.
Relocate, explore, and look up condo rentals in Cordova United States, rental properties, and rental properties in Cordova United States.
|
|
