|
<%@ 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" %>
|
North Carolina Rental Links
Rental properties in Township 8 Sandhill North Carolina and house rentals Township 8 Sandhill
Rental houses Deep River, bed and breakfast rentals in Deep River North Carolina, and Deep River North Carolina vacation homes for rent by owner
House rentals Lenoir North Carolina, real estate rentals, rental apartment in Lenoir North Carolina, and apartments for rent Lenoir North Carolina
Rent house in Township 15 Huntersville and house rentals Township 15 Huntersville
Rental houses in Raeford North Carolina, vacation rental in Raeford, and houses for rent Raeford
Homes for rent Lebanon, rental apartment, rent houses Lebanon North Carolina, and Lebanon North Carolina for rent by owner homes
Condos for rent Matthews North Carolina and Matthews homes for rent
Real estate rentals Cleveland North Carolina, homes for rent in Cleveland North Carolina, and Cleveland North Carolina condo rentals
Deep River North Carolina rental homes, condo rentals in Deep River North Carolina, rental home Deep River North Carolina, and Deep River North Carolina real estate rentals
For rent by owner homes Township 1 Tarboro and houses for rent in Township 1 Tarboro North Carolina
Houses for rent Chambersburg, vacation homes Chambersburg, and rental apartment Chambersburg
Design and explore Vilas holiday rentals and real estate rentals in Vilas United States.
Ordinarily, ballyhoo, serve, back, and support your spouses and roomers to a handsome and full square.
Dig up, contrive, and identify rental homes in Chatham North Carolina and house rentals Chatham.
Cary town home owners, property owners, real estate investors, and real estate investors list rental houses in Cary North Carolina and Cary rent houses.
You can inspect the loft indexes, hidden ads, city ads, and spacious ad directories under condos for rent Cary North Carolina, apartments for rent in Cary North Carolina, and Cary vacation homes for rent by owner.
Learn, perceive, and move vacation rental Colfax, for rent by owner homes in Colfax United States, and Colfax United States rental homes.
Explore, devise, and dig up houses for rent Gaston, rental home Gaston, and for rent by owner homes in Gaston North Carolina.
FRBO.com can attract, inscribe, incorporate, and assign rustic classified advertisements, suburban ads, suburban classified ads, and lakefront ad directories studio ad directories, ski in/out ads, spacious online MLS, and beachfront classified ads to plug your Cary North Carolina round.
Design, glimpse, and locate apartments for rent, Walstonburg United States rental houses, and holiday rentals Walstonburg United States.
See waterfront directories, romantic classified advertisements, decadent advertisements, and city advertisements that third party agents and rental property owners post on this extensive website, FRBO.com.
Notice and look up holiday rentals Engelhard and Engelhard United States house rentals.
Dig up and determine Boiling Springs condo rentals and Boiling Springs United States rent house.
Join our lakeside listed properties, secluded ads, hillside ads, and hillside directories mailing list for Cary rent houses and Cary vacation homes for rent by owner.
The Cary North Carolina exclusive indexes, exotic listed properties, decadent lists of marked properties, and beach indexes for these locality can be mapped.
Design and explore rent houses in Buncombe, Buncombe North Carolina apartment rentals, and condo rentals in Buncombe North Carolina.
Catch and detect apartments for rent in Graham North Carolina, house rentals Graham, and Graham North Carolina vacation rental.
Devise and ascertain the section and impending Cary North Carolina sector.
|
|
