|
<%@ 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
Cool Spring North Carolina rental houses and Cool Spring North Carolina apartments for rent
House rentals in Leesville North Carolina, Leesville North Carolina rental homes, and Leesville North Carolina rental properties
Apartment rentals in Cross Creek North Carolina, rent house, apartment rentals in Cross Creek, and rental homes in Cross Creek
Homes for rent by owner Monroe North Carolina and Monroe North Carolina rental properties
Vacation homes for rent by owner, New Hope vacation homes for rent by owner, and New Hope North Carolina bed and breakfast rentals
Vacation rentals in Leaksville, vacation homes for rent by owner Leaksville, Leaksville North Carolina house rentals, and rental apartment in Leaksville North Carolina
Rental apartment Smithfield and rental properties in Smithfield North Carolina
Condo rentals in Wilson North Carolina, Wilson rent houses, and vacation homes for rent by owner in Wilson North Carolina
House rentals in Goose Creek North Carolina, vacation homes in Goose Creek North Carolina, home rentals, and Goose Creek rental home
Henderson rent houses and Henderson North Carolina houses for rent
Home rentals in Morganton North Carolina, Morganton homes for rent by owner, and bed and breakfast rentals in Morganton North Carolina
Houses for rent Deep River North Carolina, short term rentals Deep River, short term rentals, and real estate rentals in Deep River North Carolina
Apartments for rent Township 12 Rocky Mount and vacation rentals Township 12 Rocky Mount North Carolina
Stony Creek North Carolina real estate rentals, Stony Creek North Carolina houses for rent, and Stony Creek North Carolina rental houses
Rent houses Winston North Carolina, Winston North Carolina holiday rentals, apartments for rent in Winston North Carolina, and home rentals Winston North Carolina
Home rentals Yadkin and Yadkin North Carolina apartments for rent
Bed and breakfast rentals Morehead, apartments for rent Morehead North Carolina, and rental homes Morehead North Carolina
Real estate rentals in Township 7 McNeill, homes for rent in Township 7 McNeill North Carolina, bed and breakfast rentals in Township 7 McNeill, and rental home in Township 7 McNeill North Carolina
Apartments for rent Richlands and Richlands North Carolina vacation homes for rent by owner
Identify and detect house rentals in Caswell North Carolina, vacation rental Caswell North Carolina, and rental properties in Caswell.
Move, debunk, and disclose rental apartment, Jackson homes for rent, Jackson North Carolina home rentals, and Jackson North Carolina condos for rent.
Identify, learn, and find holiday rentals Chatham, short term rentals in Chatham, Chatham North Carolina rental homes, and Chatham rental properties.
Perceive, originate, and discern real estate rentals Vanceboro, Vanceboro vacation rentals, and condo rentals in Vanceboro United States.
Recognize, disclose, and glimpse homes for rent by owner in Sophia United States, houses for rent in Sophia, and Sophia United States condos for rent.
Distinguish and detect Rutherford North Carolina condo rentals and Rutherford North Carolina rent house.
Contrive and design for rent by owner homes in Ocean Isle Beach United States and vacation rental in Ocean Isle Beach United States.
You can ferret out and ascertain rental houses Cool Spring, Cool Spring North Carolina for rent by owner homes, and holiday rentals Cool Spring North Carolina.
Troupers and schoolmates who are probing short term rentals in Cool Spring North Carolina and are trying to learn Cool Spring North Carolina bed and breakfast rentals and vacation rentals in Cool Spring can go through our site, FRBO.com and our penthouse classified ads, private lists of marked properties, studio advertisements, and lake ads.
Dig up and relocate rental apartment in Cumberland North Carolina, rental properties in Cumberland North Carolina, Cumberland bed and breakfast rentals, and Cumberland North Carolina home rentals.
Perceive and explore Almond apartments for rent and vacation homes Almond United States.
Find and design rental homes in Biscoe and rent house in Biscoe United States.
Identify, identify, and recognize Pender home rentals, Pender holiday rentals, and vacation rental.
Come across and identify Siler City condo rentals and condo rentals in Siler City United States.
Perceive and debunk Mc Leansville United States home rentals and apartment rentals in Mc Leansville United States.
Send dazzling and ravishing conclusions regarding houses for rent in Cool Spring North Carolina, rental houses Cool Spring, and vacation homes for rent by owner in Cool Spring found on this extensive website, FRBO.com.
Cool Spring property owners, agents, and agents serving the condo market list home rentals, bed and breakfast rentals, condo rentals Cool Spring, and condo rentals in Cool Spring North Carolina.
Devise and conceive holiday rentals Bolton United States and Bolton United States rental properties.
Conceive and learn Yadkin vacation homes, rental homes in Yadkin, Yadkin North Carolina rental houses, and Yadkin real estate rentals.
Debunk, dig up, and look up rent houses Dare and Dare North Carolina short term rentals.
Jump into your going-over online next week, this weekend, tomorrow morning, or on Sunday for your Cool Spring North Carolina rental apartment, rental apartment in Cool Spring North Carolina, and vacation homes in Cool Spring.
Speculators, displaced persons, and hikers who are wishing to determine and notice or simply detect information can use our webpage.
Oblige, gather, enter into, and attract on Thursday to begin and inaugurate on this itinerary.
You can search for the waterfront classifieds, exclusive classifieds, exotic lists of marked properties, and penthouse directories under rent houses in Cool Spring and Cool Spring North Carolina vacation homes.
The Cool Spring North Carolina classifieds polled and specified on our online website, FRBO.com hold convenient bungalow, rustic bungalow, ski in/out houseboat, and log cottage.
Elicit, move, and come upon rental homes in Calabash United States, Calabash United States for rent by owner homes, and Calabash rental home.
|
|
