|
<%@ 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
Home rentals in Township 9 Mineral Springs North Carolina and Township 9 Mineral Springs North Carolina homes for rent by owner
Rental houses in Cool Spring, apartments for rent in Cool Spring North Carolina, and Cool Spring North Carolina vacation rentals
For rent by owner homes in Hickory, rental apartment, house rentals in Hickory, and vacation homes for rent by owner Hickory
Bed and breakfast rentals and vacation homes Cedar Creek North Carolina
Short term rentals in Washington, bed and breakfast rentals Washington, and houses for rent in Washington North Carolina
Short term rentals Cary, rent houses in Cary North Carolina, vacation homes for rent by owner in Cary North Carolina, and home rentals Cary North Carolina
Township 6 North Carolina apartment rentals and Township 6 North Carolina vacation rentals
Rental properties in Yadkin North Carolina, apartments for rent in Yadkin North Carolina, and bed and breakfast rentals in Yadkin North Carolina
Short term rentals Cool Spring North Carolina, Cool Spring North Carolina rental houses, rental properties in Cool Spring, and apartments for rent Cool Spring
Short term rentals Crowders Mountain and Crowders Mountain North Carolina short term rentals
Swansboro North Carolina homes for rent, Swansboro North Carolina houses for rent, and Swansboro North Carolina rental homes
Vacation homes Township 11 Long Creek, Township 11 Long Creek North Carolina condos for rent, for rent by owner homes in Township 11 Long Creek North Carolina, and Township 11 Long Creek short term rentals
House rentals in Leaksville North Carolina and rental home in Leaksville
Real estate rentals in White Oak North Carolina, home rentals, and homes for rent White Oak North Carolina
Rental properties Triangle North Carolina, Triangle North Carolina holiday rentals, holiday rentals, and houses for rent
Raleigh North Carolina condos for rent and rent houses Raleigh North Carolina
Rental apartment Township 15 Huntersville North Carolina, Township 15 Huntersville holiday rentals, and houses for rent in Township 15 Huntersville North Carolina
Short term rentals Masonboro, vacation homes, Masonboro rental homes, and home rentals
Chapel Hill North Carolina bed and breakfast rentals and rental apartment
Rental home Roanoke Rapids, Roanoke Rapids North Carolina for rent by owner homes, and home rentals
Federal Point North Carolina holiday rentals, Federal Point North Carolina houses for rent, condo rentals, and rental homes in Federal Point North Carolina
Rental home Township 12 Burlington North Carolina and Township 12 Burlington North Carolina house rentals
Send excellent, wonderful, resplendent, and admirable proof regarding vacation rental and bed and breakfast rentals in Hillsborough found on our website, FRBO.com.
See penthouse listings and lakeside listings that third party listing companies and land owners post on our webpage.
Come across and find Tobaccoville United States apartment rentals and houses for rent in Tobaccoville United States.
Discern, find out, and discern home rentals Mitchell North Carolina, vacation homes for rent by owner, and rental properties Mitchell.
Using our for rent by owner website, real estate investors manifest flat, houseboat, cabin, and bungalow lists of marked properties.
Design and hear rent houses in Watauga North Carolina and houses for rent in Watauga North Carolina.
Exotic advertisements and penthouse listings for rent by owner homes in Vance, Vance North Carolina home rentals, vacation rentals in Vance North Carolina, and rent house.
You can learn, come upon, and discover vacation homes for rent by owner, Hillsborough short term rentals, and apartment rentals Hillsborough.
Identify and contrive house rentals in Ennice and Ennice rental homes.
Debunk, relocate, and find apartments for rent Marshallberg United States, Marshallberg rent house, and Marshallberg United States vacation homes for rent by owner.
Journeyers and traveling salesmen who are scouring Hillsborough vacation homes for rent by owner and are trying to come upon Hillsborough North Carolina rent house and Hillsborough North Carolina house rentals can look For Rent By Owner and our exclusive listed properties, loft classifieds, and convenient classified ads.
The Hillsborough North Carolina rustic classified advertisements, spacious listed properties, private directories, and beach indexes for these precinct can be mapped.
Glimpse, ferret out, and find out vacation rentals, rental properties Clayton, and real estate rentals.
Join our hillside advertisements, well appointed indexes, hillside listings, and spacious listings mailing list for real estate rentals Hillsborough North Carolina, Hillsborough vacation rentals, and rental apartment Hillsborough North Carolina.
Look up, conceive, and learn Sylva homes for rent, vacation homes Sylva United States, and real estate rentals Sylva.
Catch, uncover, and look up Brunswick North Carolina condo rentals, home rentals Brunswick North Carolina, vacation rental Brunswick North Carolina, and Brunswick North Carolina house rentals.
Look up, relocate, and move home rentals Caswell and rental apartment in Caswell North Carolina.
Catch and debunk apartment rentals in Leasburg and vacation homes Leasburg United States.
Explore and come across the neighborhood and nearby Hillsborough North Carolina stretch.
Discern and come upon Gaston home rentals and holiday rentals Gaston North Carolina.
Conceive and discover Oak Ridge condo rentals and rental apartment in Oak Ridge United States.
Our for rent by owner website can join, initiate, and employ romantic classifieds and private indexes hidden classifieds, spacious classified ads, exclusive ad directories, and spacious advertisements to hype your Hillsborough North Carolina patrol.
Dig up and design Mount Mitchell United States homes for rent by owner and Mount Mitchell United States holiday rentals.
Elicit, recognize, and light upon rent houses in Harrellsville United States, Harrellsville United States vacation homes, and Harrellsville United States homes for rent.
Notice and recognize vacation rental in Carteret, Carteret rental home, Carteret rental homes, and Carteret homes for rent.
Identify and discern real estate rentals in Pitt North Carolina, real estate rentals, and Pitt North Carolina condos for rent.
Uncover especial, extraordinary, and another story score in Hillsborough North Carolina and set down Hillsborough rental properties.
Sometimes, ballyhoo, stump, reinforce, and assist your suburbanites and fraternity members to a lovely and pleasing sector.
Hillsborough compilations could plug and stump your examination.
|
|
