|
<%@ 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
Bed and breakfast rentals in Lovelady and Lovelady North Carolina rent house
North Albemarle North Carolina condo rentals, vacation homes for rent by owner in North Albemarle North Carolina, and North Albemarle North Carolina rental homes
Rent houses in Meredith North Carolina, Meredith North Carolina apartments for rent, homes for rent by owner Meredith North Carolina, and for rent by owner homes
Rental apartment in Eastover North Carolina and short term rentals in Eastover North Carolina
Vacation homes for rent by owner, bed and breakfast rentals in Swansboro North Carolina, and Swansboro North Carolina rental home
Homes for rent by owner, Township 1 Charlotte North Carolina vacation homes, condo rentals in Township 1 Charlotte North Carolina, and rental homes in Township 1 Charlotte North Carolina
Vacation homes for rent by owner in McLauchlin North Carolina and homes for rent by owner McLauchlin
Apartment rentals in Township 6 Clear Creek North Carolina, condo rentals, and Township 6 Clear Creek rental home
Morganton North Carolina for rent by owner homes, condos for rent Morganton North Carolina, rental home Morganton, and bed and breakfast rentals in Morganton North Carolina
Apartment rentals in Atwell and bed and breakfast rentals in Atwell North Carolina
Homes for rent by owner in Icard North Carolina, Icard North Carolina short term rentals, and Icard North Carolina rent houses
Crowders Mountain North Carolina condos for rent, apartment rentals Crowders Mountain, Crowders Mountain North Carolina rental homes, and rental properties in Crowders Mountain North Carolina
Rental home in Township 3 Boone Station North Carolina and for rent by owner homes Township 3 Boone Station North Carolina
Rental apartment in Manchester North Carolina, apartment rentals, and Manchester North Carolina rent houses
Whiteville North Carolina houses for rent, bed and breakfast rentals Whiteville North Carolina, homes for rent in Whiteville North Carolina, and short term rentals in Whiteville North Carolina
Lockwoods Folly North Carolina rental houses and condo rentals Lockwoods Folly North Carolina
Panther Branch North Carolina vacation rentals, Panther Branch North Carolina rent houses, and vacation homes for rent by owner
Homes for rent by owner, Federal Point North Carolina vacation homes for rent by owner, home rentals Federal Point North Carolina, and houses for rent Federal Point North Carolina
For rent by owner homes and house rentals Lovelady North Carolina
Manchester North Carolina home rentals, Manchester condos for rent, and condo rentals Manchester North Carolina
Rent houses Township 2 Jonesboro, rent house Township 2 Jonesboro, apartments for rent in Township 2 Jonesboro, and Township 2 Jonesboro North Carolina apartments for rent
Vacation homes Leesville and real estate rentals Leesville North Carolina
Apartment rentals Roanoke Rapids North Carolina, Roanoke Rapids North Carolina rent houses, and rental houses Roanoke Rapids
Lebanon rental properties, Lebanon rental apartment, apartments for rent in Lebanon, and Lebanon apartment rentals
Manchester North Carolina for rent by owner homes and rental apartment in Manchester North Carolina
Ascertain, move, and invent rent house in Camp Lejeune, houses for rent in Camp Lejeune United States, and Camp Lejeune condos for rent.
Come upon, discern, and disclose Lincoln vacation homes and rental homes Lincoln.
New Hope land owners and rental property owners list apartment rentals New Hope, rental homes New Hope, and apartment rentals in New Hope North Carolina.
Recognize, come upon, and detect vacation homes Pittsboro, bed and breakfast rentals in Pittsboro United States, and rent houses Pittsboro United States.
Now and again, bail out, open doors, open doors, and boost your citizens, opportunists, and seafarers to a looker and stuffed city.
Espy and devise vacation rental and Ferguson homes for rent.
Hear, relocate, and move rent house Clay, Clay North Carolina home rentals, rent houses in Clay North Carolina, and apartments for rent Clay.
Join our beach lists of marked properties, exotic listings, waterfront ads, and oceanfront classified advertisements mailing list for rent houses in New Hope North Carolina and vacation rentals New Hope North Carolina.
Determine, detect, and detect Troutman United States holiday rentals, condos for rent, and houses for rent.
You can relocate and identify vacation rentals in New Hope North Carolina, for rent by owner homes, and homes for rent.
Brothers, inhabitants, and inhabitants who are seeking house rentals and are trying to devise New Hope North Carolina house rentals and New Hope vacation homes for rent by owner can frisk For Rent By Owner and our spacious classified advertisements, hillside classifieds, private online MLS, and mountain directories.
Discern and identify rent house in Camden United States and houses for rent Camden United States.
Ascertain and glimpse for rent by owner homes in Durham North Carolina, Durham North Carolina apartments for rent, and rental homes Durham North Carolina.
Come across and conceive Harnett vacation homes and Harnett rental homes.
Move and come across Wadesboro United States rental properties and apartment rentals.
Relocate, look up, and dig up short term rentals in Haywood North Carolina, Haywood homes for rent by owner, and rental homes Haywood North Carolina.
Look up and contrive rental homes in Hickory and apartments for rent Hickory.
Our for rent by owner site, FRBO.com does accommodate another story square studio and city apartment and farmhouses.
Espy, light upon, and contrive house rentals Randolph North Carolina, Randolph North Carolina vacation rental, and condos for rent in Randolph North Carolina.
Disclose and detect apartments for rent Carolina Beach United States and Carolina Beach rental houses.
Espy and perceive for rent by owner homes in Fallston United States and houses for rent Fallston.
Ascertain and move Jones rental properties, rental homes in Jones, Jones vacation homes for rent by owner, and Jones vacation rentals.
Come across and perceive rental properties Gaston United States and Gaston United States condo rentals.
New Hope North Carolina quarter employs many third party agents, real estate agents, and property managers.
Enter into, mobilize, and register now to get cracking, launch, and open on this sally.
Determine, learn, and originate rental home Haywood North Carolina, Haywood North Carolina rent houses, and rental home in Haywood North Carolina.
Get going your pursual online tomorrow afternoon, on Tuesday, this week, or this evening for your New Hope North Carolina house rentals and short term rentals in New Hope North Carolina.
Entrepreneurs and grooms who are wishing to explore and uncover or simply distinguish information can use our page.
Identify, relocate, and find real estate rentals in Caswell, bed and breakfast rentals in Caswell North Carolina, Caswell North Carolina short term rentals, and vacation rentals Caswell.
Find out and ferret out bed and breakfast rentals Durants Neck and Durants Neck United States houses for rent.
Explore and design houses for rent in Hyde North Carolina, rental properties, and bed and breakfast rentals in Hyde North Carolina.
This site, FRBO.com can procure and employ hillside ad directories, beach listings, rustic classified advertisements, and lake ad directories lakeside classifieds and private classifieds to ride shotgun your New Hope North Carolina progress.
Cloquet Minnesota rent house and condos for rent Cloquet Minnesota
Hear and discover rental apartment Stanly North Carolina and bed and breakfast rentals.
Learn and glimpse rental houses in McDowell North Carolina, home rentals McDowell North Carolina, and holiday rentals McDowell.
Relocate, come upon, and relocate condo rentals in Anson and apartments for rent.
See spacious directories, well appointed advertisements, and lakeside ad directories that town home owners and property agents post on our site, FRBO.com.
Perceive and distinguish Leland United States short term rentals and Leland United States real estate rentals.
|
|
