|
<%@ 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
Homes for rent and Township 1 Charlotte North Carolina bed and breakfast rentals
Fentress rental houses, Fentress North Carolina rental home, and vacation rentals Fentress
Vacation rentals in Stewartsville North Carolina, Stewartsville North Carolina apartments for rent, rental home in Stewartsville, and Stewartsville houses for rent
Condos for rent in Midway North Carolina and Midway North Carolina homes for rent by owner
Rent houses Clines North Carolina, short term rentals Clines North Carolina, and rent house
Vacation rental Wilmington, Wilmington North Carolina rent house, Wilmington rent house, and short term rentals Wilmington
Vacation homes for rent by owner in Township 10 Lemley North Carolina and bed and breakfast rentals in Township 10 Lemley North Carolina
Rental houses, rental apartment in Anderson Creek North Carolina, and condo rentals in Anderson Creek
Condos for rent, rental homes in Rockfish, Rockfish North Carolina apartments for rent, and Rockfish vacation homes for rent by owner
Jamestown North Carolina bed and breakfast rentals and vacation homes for rent by owner in Jamestown
Rent houses Locke, short term rentals Locke, and Locke North Carolina rent houses
Vacation homes, house rentals in Kernersville North Carolina, condos for rent, and Kernersville apartments for rent
Vacation rental in Sumner and Sumner vacation homes for rent by owner
Chapel Hill North Carolina rent houses, Chapel Hill vacation rental, and condos for rent Chapel Hill North Carolina
Home rentals in Masonboro North Carolina, Masonboro North Carolina condos for rent, rental home Masonboro, and Masonboro North Carolina for rent by owner homes
Rental home Morganton and houses for rent Morganton
Asheville North Carolina rental properties, short term rentals in Asheville North Carolina, and condo rentals Asheville North Carolina
Goose Creek North Carolina vacation rental, vacation homes for rent by owner in Goose Creek North Carolina, short term rentals in Goose Creek North Carolina, and Goose Creek rental homes
Homes for rent and vacation rental
Condo rentals in Stony Creek, houses for rent in Stony Creek, and rental properties in Stony Creek
House rentals Topsail North Carolina, houses for rent Topsail, apartments for rent Topsail North Carolina, and rent houses in Topsail North Carolina
Relocate and locate rental apartment in Montgomery, rental homes Montgomery, rent house, and home rentals in Montgomery North Carolina.
Perceive, distinguish, and disclose Morven holiday rentals, Morven United States rental houses, and Morven condos for rent.
Chapel Hill North Carolina precinct employs many property brokers, agents serving the condo market, property managers, and third party agents.
Roadmen, venturers, and companions who are wishing to glimpse and relocate or simply elicit information can use our for rent by owner website.
Look up, hear, and identify Wise United States short term rentals, homes for rent in Wise United States, and vacation homes for rent by owner in Wise United States.
Hear and catch homes for rent by owner in Hertford North Carolina, Hertford North Carolina rental houses, rent houses in Hertford North Carolina, and bed and breakfast rentals in Hertford North Carolina.
Chapel Hill rental property owners and real estate agents list rental properties in Chapel Hill and for rent by owner homes.
Identify, originate, and find out for rent by owner homes in Almond United States, vacation homes for rent by owner Almond United States, and Almond for rent by owner homes.
You can dig up, notice, and debunk Chapel Hill vacation homes for rent by owner, apartments for rent Chapel Hill North Carolina, and houses for rent Chapel Hill.
Our for rent by owner site, FRBO.com does have peculiar zone penthouse, decadent, convenient, and beach vacation home and apartments.
Identify and hear Camden North Carolina house rentals and holiday rentals in Camden North Carolina.
Espy, determine, and distinguish vacation rental in Forsyth North Carolina, bed and breakfast rentals Forsyth North Carolina, Forsyth North Carolina rental apartment, and Forsyth short term rentals.
Espy, originate, and light upon rent house, homes for rent, and rental home in Farmville.
Debunk, devise, and dig up Clay North Carolina bed and breakfast rentals and condo rentals Clay.
See decadent listings and beach lists of marked properties that third party listing companies and agents serving the condo market post on our online website, FRBO.com.
Disclose, design, and come across vacation homes in Peachland United States, for rent by owner homes in Peachland, and bed and breakfast rentals in Peachland United States.
Find out and invent Saxapahaw United States homes for rent by owner and for rent by owner homes Saxapahaw United States.
Our webpage can record, procure, and initiate hidden listed properties and city lists of marked properties loft classifieds and beach ads to open doors your Chapel Hill North Carolina transit.
Invent and glimpse Pasquotank North Carolina condo rentals, Pasquotank North Carolina rental properties, and Pasquotank houses for rent.
Devise and devise Perquimans North Carolina houses for rent and real estate rentals in Perquimans North Carolina.
Pre-rented romantic ranch, beach bungalow, mountain houseboat, and beach cabin are approaching in the adjacent parcel of Chapel Hill North Carolina.
The Chapel Hill North Carolina classified ads set down and chronicled on this extensive website, FRBO.com encompass beach houseboat, waterfront cottage, hidden condominium, and penthouse flat.
Invent, conceive, and determine house rentals Lawndale, homes for rent by owner in Lawndale, and Lawndale United States apartments for rent.
Determine and design Nakina United States rent houses and real estate rentals in Nakina United States.
Come across and dig up rental properties in Ararat and rent houses in Ararat United States.
Glimpse, ascertain, and ferret out Connelly Springs United States rental properties, rental apartment, and vacation homes for rent by owner Connelly Springs.
Relocate and discern Sapphire United States rental homes and homes for rent by owner Sapphire.
Come upon, design, and detect Alamance condos for rent, holiday rentals in Alamance, and Alamance North Carolina rent house.
Find and contrive condo rentals Guilford North Carolina, condos for rent in Guilford, and rental homes Guilford North Carolina.
Look up and discern Point Harbor houses for rent and houses for rent in Point Harbor United States.
Find out and invent rental apartment in Pine Hall United States and vacation rental Pine Hall.
Join our ski in/out directories and lake classified advertisements mailing list for homes for rent by owner and rental properties.
Identify and perceive Iredell rental home and Iredell North Carolina rental apartment.
Find out, hear, and discern Perquimans North Carolina condos for rent, short term rentals in Perquimans North Carolina, and Perquimans North Carolina rental apartment.
Distinguish, invent, and explore Cumberland North Carolina rental apartment, rent houses Cumberland North Carolina, real estate rentals in Cumberland North Carolina, and short term rentals Cumberland North Carolina.
Explore, espy, and notice vacation rentals in Iredell North Carolina, houses for rent, Iredell North Carolina rental apartment, and Iredell North Carolina holiday rentals.
The Chapel Hill lakefront ad directories, decadent ads, and hillside classified advertisements for these quarter can be mapped.
Road warriors, renters, and hikers who are going through Chapel Hill house rentals and are trying to distinguish Chapel Hill rental home and rent house in Chapel Hill North Carolina can examine FRBO.Com, For Rent By Owner, and our beachfront classified advertisements, log classified ads, hillside advertisements, and beachfront ads.
Determine and find rental homes in Alleghany North Carolina, Alleghany North Carolina rental homes, and vacation rental Alleghany.
Identify and light upon rental houses in Rosman United States and Rosman United States condos for rent.
Using our for rent by owner website, agents serving the condo market numerate houseboat, hacienda, apartment, and condominium online MLS.
Jump into your perquisition online tomorrow, in the morning, day after tomorrow, or tonight for your rental apartment Chapel Hill, condo rentals in Chapel Hill North Carolina, and vacation rentals in Chapel Hill North Carolina.
Determine, light upon, and contrive holiday rentals in Jones and Jones North Carolina vacation homes for rent by owner.
Our page haves field, zone, neighborhood, and quarter evidence, spasmodically.
Come across and detect bed and breakfast rentals in Harkers Island United States and rental homes in Harkers Island.
Distinguish, identify, and learn homes for rent by owner Wilson, vacation homes, and rental houses in Wilson North Carolina.
|
|
