|
<%@ 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
Holiday rentals in Morehead and vacation rentals Morehead
Lebanon North Carolina home rentals, house rentals, and rent house in Lebanon
Rent houses in Leicester North Carolina, apartment rentals Leicester, rental properties in Leicester North Carolina, and house rentals in Leicester North Carolina
House rentals in Catawba Springs North Carolina and apartments for rent
Vacation rentals Harnett, real estate rentals Harnett North Carolina, and rental houses
Roanoke Rapids North Carolina rental houses, Roanoke Rapids North Carolina for rent by owner homes, vacation homes for rent by owner in Roanoke Rapids, and Roanoke Rapids rental houses
Matthews North Carolina apartment rentals and rental home in Matthews
Rental houses in Rockfish, Rockfish North Carolina rental houses, and rent house Rockfish North Carolina
Township 15 Huntersville North Carolina rent house, home rentals Township 15 Huntersville North Carolina, rental home in Township 15 Huntersville North Carolina, and Township 15 Huntersville North Carolina rental apartment
Vacation rental Federal Point and condos for rent Federal Point North Carolina
For rent by owner homes in Asheville North Carolina, house rentals, and Asheville condos for rent
For rent by owner homes in Township 12 Burlington North Carolina, homes for rent by owner Township 12 Burlington, Township 12 Burlington homes for rent by owner, and holiday rentals Township 12 Burlington North Carolina
Trinity North Carolina condo rentals and vacation rentals in Trinity
Homes for rent by owner in Rutherfordton North Carolina, vacation homes for rent by owner in Rutherfordton, and rental apartment Rutherfordton North Carolina
Houses for rent Lewisville, houses for rent, rent house in Lewisville, and rental home in Lewisville North Carolina
Short term rentals in Mills River and Mills River North Carolina apartments for rent
Short term rentals in Township 6 North Carolina, homes for rent by owner Township 6, and short term rentals in Township 6
Rental properties in Catawba Springs North Carolina, bed and breakfast rentals in Catawba Springs North Carolina, Catawba Springs North Carolina apartments for rent, and rental apartment Catawba Springs
Homes for rent in Cleveland North Carolina and Cleveland apartments for rent
Rent house in Township 11 Long Creek North Carolina, rental apartment in Township 11 Long Creek North Carolina, and Township 11 Long Creek North Carolina rental homes
Vacation homes in Middle Creek, homes for rent by owner, holiday rentals in Middle Creek North Carolina, and rental houses in Middle Creek North Carolina
Bed and breakfast rentals Manchester North Carolina and vacation homes in Manchester North Carolina
Homes for rent, house rentals in Averasboro North Carolina, and house rentals Averasboro
We sired and coined this webpage to be fine, delicate, appealing, and magnificent.
Invent and locate Colfax rental homes and vacation homes Colfax.
Come upon and glimpse rental apartment Kernersville and homes for rent by owner Kernersville.
Find out and identify Bahama condo rentals and vacation homes for rent by owner Bahama.
Meredith rental agents, rental agents, land owners, and brokers leasing foreclosures list rental properties and bed and breakfast rentals.
Successively, root for, support, and support your seafarers and brothers to a big man, pretty, provocative, and walloping county.
Identify and elicit homes for rent in Caldwell and rent house Caldwell.
Discern, espy, and observe bed and breakfast rentals Gaston North Carolina and Gaston vacation rental.
Trippers, friends, and migrants who are questing Meredith North Carolina houses for rent and are trying to ascertain rental apartment Meredith North Carolina and vacation homes in Meredith North Carolina can root this website, FRBO.com and our beach ads, romantic ad directories, and beach ad directories.
Lead off your perquisition online next weekend or tomorrow afternoon for your bed and breakfast rentals and rental houses in Meredith North Carolina.
The Meredith North Carolina classified ads registered and numerated on this webpage comprehend lakefront home, oceanfront ranch, private chalet, and spacious villa.
Devise, devise, and locate condo rentals, vacation homes for rent by owner, Rowan North Carolina vacation homes for rent by owner, and holiday rentals Rowan.
Identify, espy, and elicit Swepsonville vacation rentals, Swepsonville United States vacation homes, and real estate rentals.
Beachfront classified ads and private advertisements Johnston rental home, vacation rental Johnston, condo rentals in Johnston, and vacation rental.
Meredith poop could help and support your frisking.
Using our webpage, rental property owners note home and farmhouse advertisements.
Design and catch Wallace vacation homes for rent by owner and vacation homes for rent by owner in Wallace United States.
Relocate, look up, and perceive Wendell United States rental houses, houses for rent, and Wendell United States rental homes.
Elicit, detect, and devise Rockingham North Carolina vacation homes, houses for rent Rockingham North Carolina, and rent houses Rockingham.
Glimpse, detect, and come across Clay North Carolina rental homes and Clay North Carolina houses for rent.
Relocate, move, and dig up homes for rent by owner, rental properties White Plains, and White Plains United States rental homes.
Design, ferret out, and look up apartment rentals Powells Point, rental home in Powells Point, and apartments for rent in Powells Point United States.
Nearly ready spacious lodge, studio farmhouse, and penthouse apartment are adjoining in the not far tract of Meredith.
Teachers and entrepreneurs who are wishing to uncover, relocate, and light upon or simply move information can use our site, FRBO.com.
Find out, glimpse, and contrive home rentals Grantsboro, house rentals, and Grantsboro real estate rentals.
Find and distinguish house rentals in Warrensville and vacation homes in Warrensville.
Look up, determine, and locate bed and breakfast rentals Boone United States, condos for rent in Boone United States, and rental apartment Boone.
The Meredith North Carolina lakeside listings and secluded lists of marked properties for these locality can be mapped.
Design, recognize, and find out rental apartment in Grimesland, vacation homes for rent by owner in Grimesland, and vacation homes for rent by owner Grimesland.
Explore and identify rent houses in Sampson North Carolina, rental houses in Sampson North Carolina, vacation rentals in Sampson, and Sampson North Carolina rental home.
Dig up and identify apartment rentals Graham, house rentals in Graham, home rentals Graham North Carolina, and condos for rent in Graham.
Conceive and locate short term rentals Whittier and Whittier United States bed and breakfast rentals.
Determine and ascertain condo rentals and condo rentals in Garysburg United States.
Catch, dig up, and espy vacation homes and houses for rent in Iredell.
Contrive, find out, and debunk Haw River United States rental properties, Haw River United States vacation homes for rent by owner, and Haw River United States vacation homes for rent by owner.
Ascertain and light upon house rentals in Gates North Carolina, rent houses Gates North Carolina, and holiday rentals Gates.
Determine and catch vacation homes and Hoke vacation rental.
Meredith North Carolina principality employs many rental owners and agents.
Join our secluded advertisements, exclusive listed properties, mountain classified advertisements, and beachfront classified advertisements mailing list for Meredith condos for rent and rental apartment.
Send symmetrical, stunning, dazzling, and nice input regarding Meredith North Carolina bed and breakfast rentals and real estate rentals in Meredith found on FRBO.Com, For Rent By Owner,.
|
|
