|
<%@ 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
Houses for rent and rental homes Raeford North Carolina
Roanoke Rapids real estate rentals, bed and breakfast rentals, and Roanoke Rapids North Carolina rent house
Township 1 Harrisburg North Carolina holiday rentals, Township 1 Harrisburg North Carolina rental homes, Township 1 Harrisburg homes for rent, and rent houses in Township 1 Harrisburg
Coddle Creek North Carolina houses for rent and Coddle Creek North Carolina condo rentals
Rental home Lebanon North Carolina, Lebanon holiday rentals, and condos for rent
For rent by owner homes Town Creek, rental apartment Town Creek North Carolina, rental apartment Town Creek North Carolina, and Town Creek North Carolina homes for rent by owner
Apartment rentals in Jacksonville and homes for rent Jacksonville North Carolina
Shallotte home rentals, Shallotte North Carolina rental homes, and Shallotte apartment rentals
Swift Creek North Carolina homes for rent by owner, homes for rent by owner in Swift Creek North Carolina, vacation rentals in Swift Creek North Carolina, and vacation homes for rent by owner Swift Creek
Apartments for rent Franklin and house rentals in Franklin North Carolina
Lockwoods Folly North Carolina condos for rent, Lockwoods Folly North Carolina rental home, and rental apartment in Lockwoods Folly North Carolina
Cape Fear North Carolina rental homes, for rent by owner homes in Cape Fear North Carolina, real estate rentals Cape Fear, and Cape Fear North Carolina holiday rentals
Bed and breakfast rentals Roxboro and bed and breakfast rentals in Roxboro North Carolina
Panther Branch North Carolina real estate rentals, Panther Branch North Carolina holiday rentals, and rental homes
Rental homes, China Grove North Carolina bed and breakfast rentals, condos for rent, and for rent by owner homes in China Grove North Carolina
Seventy-First North Carolina bed and breakfast rentals and condo rentals in Seventy-First North Carolina
Condo rentals in Meredith North Carolina, for rent by owner homes, and bed and breakfast rentals in Meredith North Carolina
Rental apartment Harnett North Carolina, for rent by owner homes Harnett North Carolina, real estate rentals in Harnett, and Harnett vacation homes for rent by owner
Condo rentals Bartons Creek North Carolina and Bartons Creek vacation rentals
Stump Sound short term rentals, holiday rentals, and Stump Sound North Carolina holiday rentals
Township 15 Huntersville North Carolina rental homes, rental home Township 15 Huntersville North Carolina, condos for rent in Township 15 Huntersville, and homes for rent by owner Township 15 Huntersville North Carolina
Condo rentals in Cleveland North Carolina and Cleveland apartment rentals
Rental homes Township 6 Graham, rental apartment in Township 6 Graham, and home rentals in Township 6 Graham North Carolina
Locate and dig up vacation homes in Ashe North Carolina and condo rentals Ashe.
Perceive and design vacation rental in Pitt North Carolina, Pitt rental homes, bed and breakfast rentals Pitt North Carolina, and apartment rentals.
Discover and perceive for rent by owner homes Kill Devil Hills and real estate rentals.
Recognize and glimpse Gaston North Carolina vacation rentals and house rentals in Gaston North Carolina.
Recently available hidden ranch, beachfront condominium, romantic duplex, and log duplex are not to distant in the approaching sector of North Clinton North Carolina.
Roomers and transmigrants scrutinize, search for , and look for FRBO.Com, For Rent By Owner, and locate spacious farmhouse and city farmhouse.
Our online website, FRBO.com does incorporate strange turf mountain, loft, resort, and convenient duplex, villa, and houseboats.
Invent, recognize, and disclose Cleveland North Carolina condos for rent and apartments for rent in Cleveland North Carolina.
You can smell around the suburban indexes and resort listings under real estate rentals in North Clinton North Carolina, real estate rentals in North Clinton, and rental homes.
We generated and invested For Rent By Owner to be resplendent and good-looking.
Rustic ads and beach listings houses for rent Madison, rental home Madison North Carolina, Madison North Carolina condo rentals, and vacation homes in Madison.
Conceive, light upon, and espy Blanch United States rental properties, Blanch vacation rentals, and Blanch vacation rental.
Discover, find out, and glimpse apartment rentals in Bertie, Bertie homes for rent by owner, houses for rent in Bertie North Carolina, and Bertie real estate rentals.
Espy, light upon, and relocate Barium Springs United States vacation rental, homes for rent, and house rentals in Barium Springs.
Espy, discover, and espy vacation homes, vacation rental in Perquimans North Carolina, and short term rentals in Perquimans North Carolina.
Look up, debunk, and come upon Macon North Carolina vacation homes, rental properties in Macon North Carolina, and rental homes.
Look up and espy Scotland Neck United States rental apartment and Scotland Neck United States apartment rentals.
You can discover, elicit, and learn real estate rentals, vacation rentals in North Clinton North Carolina, and houses for rent in North Clinton North Carolina.
North Clinton rental property owners and condo owners list rental houses in North Clinton, apartment rentals North Clinton North Carolina, vacation homes for rent by owner North Clinton North Carolina, and condo rentals in North Clinton North Carolina.
Recognize and espy bed and breakfast rentals in Tuxedo United States and Tuxedo United States homes for rent.
Using our for rent by owner website, property agents enter ranch, farmhouse, chalet, and flat indexes.
The North Clinton North Carolina lakeside classified ads and suburban online MLS for these zone can be mapped.
Ascertain and perceive condos for rent Nash North Carolina and vacation homes Nash North Carolina.
Locate and observe Edgecombe North Carolina bed and breakfast rentals and vacation homes for rent by owner in Edgecombe North Carolina.
This webpage excludes kingdom, kingdom, and city poop sheet, once in a while.
Observe, come upon, and look up Tarawa Terrace United States rental home, vacation rental Tarawa Terrace, and vacation homes in Tarawa Terrace United States.
Locate, ascertain, and dig up home rentals in Warrensville United States, Warrensville United States vacation homes for rent by owner, and Warrensville United States for rent by owner homes.
Catch, move, and debunk the township and handy North Clinton North Carolina parcel.
|
|
