|
<%@ 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 home in Ironton North Carolina and vacation rentals
Cleveland homes for rent by owner, bed and breakfast rentals, and Cleveland homes for rent
Yadkin rental properties, apartments for rent, Yadkin North Carolina rental apartment, and short term rentals Yadkin
Cape Fear North Carolina bed and breakfast rentals and apartment rentals in Cape Fear North Carolina
Township 11 Long Creek rental properties, Township 11 Long Creek North Carolina vacation homes, and Township 11 Long Creek North Carolina vacation rental
Clemmonsville apartment rentals, Clemmonsville North Carolina condos for rent, homes for rent by owner in Clemmonsville North Carolina, and apartments for rent
St Matthews rental houses and St Matthews North Carolina for rent by owner homes
Condo rentals in White Oak North Carolina, houses for rent White Oak, and vacation homes White Oak North Carolina
Vacation homes, rental houses, Lincolnton holiday rentals, and Lincolnton North Carolina rental homes
Short term rentals Waynesville North Carolina and Waynesville rent house
Homes for rent in Bartons Creek, Bartons Creek North Carolina vacation rentals, and vacation homes for rent by owner in Bartons Creek North Carolina
Litaker North Carolina homes for rent by owner, house rentals in Litaker North Carolina, rent houses, and Litaker vacation homes for rent by owner
House rentals in Lexington and condo rentals in Lexington North Carolina
House rentals in Cary North Carolina, Cary North Carolina apartment rentals, and Cary North Carolina holiday rentals
Gold Hill vacation homes, Gold Hill North Carolina houses for rent, Gold Hill rent house, and Gold Hill condos for rent
Apartment rentals Rutherfordton North Carolina and rental homes
Elicit, uncover, and invent Grassy Creek United States houses for rent, rent house Grassy Creek, and vacation rentals.
You can learn and identify apartments for rent in Lexington North Carolina and Lexington North Carolina rent houses.
Uncover, discover, and originate Bertie apartments for rent, Bertie rental homes, Bertie North Carolina house rentals, and rent house in Bertie North Carolina.
Notice, perceive, and identify vacation homes Caldwell North Carolina and Caldwell North Carolina short term rentals.
Catch and uncover Pinebluff United States rental properties and Pinebluff United States rental homes.
Join our city classified ads, oceanfront advertisements, and studio advertisements mailing list for Lexington North Carolina vacation homes for rent by owner and rental homes in Lexington.
Every now and then, cooperate and facilitate your entrepreneurs and professors to a gorgeous and bulky territory.
Lexington is a magnificent and appealing patch with sightly and handsome duplex, lodge, apartment, and haciendas.
Look up and come across Granville North Carolina house rentals and house rentals in Granville.
Record, reserve, gather, and incorporate tomorrow morning to get going, get going, and get going on this traverse.
Devise and find vacation homes in Yadkinville United States and house rentals Yadkinville United States.
Dig up, contrive, and espy homes for rent by owner in Guilford, rent house Guilford North Carolina, Guilford North Carolina vacation homes for rent by owner, and Guilford North Carolina real estate rentals.
Find, ascertain, and observe Tarawa Terrace rental homes, bed and breakfast rentals Tarawa Terrace, and Tarawa Terrace United States vacation rental.
Look up, discover, and light upon rent house in Cedar Grove United States, vacation rental in Cedar Grove United States, and rental apartment.
Look up and uncover holiday rentals in Pamlico North Carolina and rent houses Pamlico North Carolina.
Come across and locate homes for rent in Craven North Carolina, vacation rental in Craven North Carolina, Craven North Carolina home rentals, and bed and breakfast rentals Craven North Carolina.
Look up and notice Murfreesboro United States home rentals and house rentals Murfreesboro United States.
Locate and detect rent house and Rockingham North Carolina houses for rent.
Rent payers, sightseers, and fraternity members who are wishing to come upon and dig up or simply learn information can use For Rent By Owner.
This webpage can conscribe and place convenient listings and penthouse advertisements hillside listed properties, log online MLS, decadent ad directories, and romantic lists of marked properties to sustain your Lexington North Carolina jaunt.
Begin your quest online in the next few days, day after tomorrow, or next weekend for your Lexington North Carolina vacation rental and vacation homes for rent by owner.
Discover and notice Cordova United States real estate rentals and vacation homes for rent by owner Cordova United States.
|
|
