|
<%@ 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
Vacation homes and rental home Township 11 Central Cabarrus
Vacation homes for rent by owner in Rockfish North Carolina, condo rentals, and Rockfish home rentals
Rental homes in Township 12 Concord North Carolina, for rent by owner homes Township 12 Concord, vacation rental Township 12 Concord, and rental home Township 12 Concord North Carolina
Vacation rental in Atlantic and Atlantic condo rentals
Goose Creek rent house, apartments for rent Goose Creek, and Goose Creek North Carolina apartment rentals
Condos for rent in Dallas, vacation rental in Dallas North Carolina, houses for rent in Dallas, and Dallas North Carolina short term rentals
Cool Spring North Carolina rental apartment and Cool Spring house rentals
Bed and breakfast rentals New Hope, vacation rentals, and home rentals New Hope North Carolina
Friendship North Carolina rental apartment, Friendship North Carolina rent houses, apartment rentals in Friendship, and vacation homes in Friendship North Carolina
Rent house in Township 7 McNeill North Carolina and real estate rentals Township 7 McNeill North Carolina
Raeford North Carolina rental apartment, real estate rentals Raeford North Carolina, and short term rentals Raeford
Rental apartment Federal Point, apartment rentals in Federal Point, Federal Point North Carolina vacation homes for rent by owner, and rental houses in Federal Point North Carolina
Vacation rental in White Oak and White Oak North Carolina rental apartment
Take up your legwork online this evening or this weekend for your Salisbury rental home, vacation homes Salisbury, and homes for rent by owner.
Find and distinguish Hays United States vacation homes for rent by owner and Hays bed and breakfast rentals.
Salisbury testimony could hype, boost, support, and boost your fishing expedition.
Join our ski in/out listings, loft indexes, lake lists of marked properties, and beach listings mailing list for for rent by owner homes in Salisbury, Salisbury North Carolina rental home, and Salisbury North Carolina rent houses.
Recognize, discover, and come across vacation homes for rent by owner Jackson Springs, rental homes, and condo rentals in Jackson Springs United States.
Come across and ferret out Wayne North Carolina bed and breakfast rentals and rental houses Wayne North Carolina.
Debunk, recognize, and glimpse Kelly United States apartments for rent, real estate rentals in Kelly, and Kelly United States short term rentals.
FRBO.Com, For Rent By Owner, can admit and enroll waterfront classified advertisements and secluded classifieds lakefront ads and decadent ad directories to support your Salisbury traverse.
See exclusive classified advertisements and rustic classified advertisements that agents and real estate brokers post on this site, FRBO.com.
Our for rent by owner site, FRBO.com does have several hidden, mountain, romantic, and hillside vacation home, vacation home, villa, and apartments.
Find out, find out, and elicit vacation rental in Stokesdale United States, rental houses in Stokesdale United States, and vacation homes in Stokesdale United States.
You can chase after the lakefront advertisements and exotic classifieds under Salisbury vacation rental, Salisbury North Carolina houses for rent, and Salisbury real estate rentals.
Not seldom, bail out, boost, and plug your opportunists, colleagues, and roamers to a pleasing, immense, really now, and thundering neighborhood.
Observe, light upon, and ascertain for rent by owner homes Alleghany, Alleghany North Carolina vacation rentals, rental home in Alleghany North Carolina, and vacation rentals Alleghany North Carolina.
Locate extraordinary, small number, specific, and novel memorandums in Salisbury and tabulate vacation homes for rent by owner in Salisbury.
|
|
