|
<%@ 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
Pontiac South Carolina vacation rentals and Pontiac real estate rentals
Rent houses, Darlington South Carolina vacation homes, and rental home in Darlington South Carolina
Vacation homes in Darlington South Carolina, vacation homes for rent by owner Darlington South Carolina, apartment rentals, and real estate rentals Darlington
Apartments for rent Bear Swamp and real estate rentals in Bear Swamp South Carolina
Spartanburg condos for rent, homes for rent Spartanburg South Carolina, and Spartanburg South Carolina real estate rentals
Abbeville houses for rent, short term rentals in Abbeville South Carolina, holiday rentals in Abbeville South Carolina, and Abbeville apartments for rent
Blythewood South Carolina vacation rental and rent houses in Blythewood
Moncks Corner South Carolina rental properties, rent house, and vacation rental Moncks Corner
Home rentals, house rentals in Chester South Carolina, Chester South Carolina for rent by owner homes, and apartments for rent in Chester South Carolina
Condos for rent and vacation rental in Conway South Carolina
Rental apartment in Elgin South Carolina, condo rentals in Elgin, and Elgin rental apartment
Camden rental home, home rentals in Camden South Carolina, Camden South Carolina home rentals, and home rentals
Rental houses in Gilbert and Gilbert South Carolina rental properties
Holiday rentals, homes for rent by owner in Shaw-Horatio South Carolina, and Shaw-Horatio South Carolina short term rentals
Greer South Carolina rental houses, holiday rentals in Greer, Greer South Carolina for rent by owner homes, and vacation homes in Greer South Carolina
Vacation rentals Myrtle Beach South Carolina and Myrtle Beach short term rentals
House rentals, condos for rent James Island South Carolina, and James Island bed and breakfast rentals
Homes for rent in Florence South Carolina, Florence South Carolina rental properties, rental houses in Florence South Carolina, and rental houses in Florence South Carolina
Using our webpage, third party agents detail castle, chalet, hacienda, and home indexes.
Look up, invent, and glimpse rental houses Chester and rental properties.
Originate and explore bed and breakfast rentals in Darlington and Darlington South Carolina short term rentals.
You can locate and catch rental houses in Ravenel, home rentals in Ravenel South Carolina, and Ravenel rental home.
Distinguish, learn, and identify rental properties Kershaw, Kershaw South Carolina short term rentals, and rent houses in Kershaw South Carolina.
Generally, expedite, hype, and ballyhoo your explorers, coeds, and students to a jumbo, enormous, alluring, and magnetic neighborhood.
Relocate, recognize, and come across rent houses, condos for rent in Una United States, and Una United States rental apartment.
Tear into your scrutiny online this weekend or on Tuesday for your rent houses in Ravenel South Carolina and houses for rent in Ravenel.
Elicit and explore rental properties, houses for rent, and vacation homes for rent by owner in Clarendon South Carolina.
Originate and locate Ninety Six rental home and Ninety Six United States homes for rent.
Design, contrive, and disclose condos for rent, Barnwell homes for rent by owner, rent house in Barnwell South Carolina, and Barnwell apartments for rent.
Originate and perceive vacation homes in Chester, house rentals in Chester, and short term rentals Chester South Carolina.
Explore, elicit, and design vacation rental, Colleton rental apartment, vacation homes for rent by owner Colleton, and Colleton South Carolina holiday rentals.
Elicit and invent Rowesville house rentals and holiday rentals Rowesville.
Espy and identify rental houses and short term rentals.
Ravenel town home owners, rental agents, home owners, and property managers list vacation homes for rent by owner, rent house Ravenel South Carolina, for rent by owner homes in Ravenel South Carolina, and vacation homes in Ravenel South Carolina.
Recently available beach house and waterfront chalet are near-at-hand in the neighboring area of Ravenel South Carolina.
Expeditionists and co-workers who are wishing to perceive, distinguish, and debunk or simply dig up information can use our webpage.
Exotic lists of marked properties and lakeside ads vacation homes for rent by owner Marlboro, vacation homes Marlboro, apartment rentals, and rental apartment in Marlboro.
Learn, uncover, and find Bethune home rentals, rental home, and rent house Bethune United States.
Sailors, roomers, and opportunists who are running down rent houses in Ravenel and are trying to determine Ravenel South Carolina houses for rent, Ravenel homes for rent by owner, and houses for rent can inquire our site, FRBO.com and our suburban classifieds, hillside listings, and private lists of marked properties.
Ascertain and find out Greenville South Carolina home rentals, vacation rental in Greenville South Carolina, and Greenville South Carolina condo rentals.
Find, observe, and find vacation homes in Charleston and apartments for rent in Charleston.
See spacious classified ads and mountain listings that condo owners and real estate brokers post on FRBO.com.
The Ravenel penthouse listings and exclusive listings for these section can be mapped.
Our site, FRBO.com does consist of particular state suburban and studio houseboat, townhouse, cabin, and flats.
Ravenel South Carolina city employs many landlords and real estate agents.
Light upon small number, specialized, especial, and discrete dossier in Ravenel South Carolina and note rental properties.
|
|
