|
<%@ 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 in Township 4 Kannapolis and for rent by owner homes in Township 4 Kannapolis
House rentals in Cross Creek, bed and breakfast rentals in Cross Creek North Carolina, and houses for rent in Cross Creek North Carolina
Rental homes in Franklin, Franklin apartments for rent, vacation rental in Franklin North Carolina, and vacation homes Franklin North Carolina
Mills River North Carolina rental apartment and bed and breakfast rentals
Rent house in Smithfield, apartments for rent, and vacation rental in Smithfield
Henderson North Carolina home rentals, apartment rentals in Henderson, vacation homes Henderson North Carolina, and apartment rentals Henderson North Carolina
Rent house Sumner and Sumner North Carolina rental properties
For rent by owner homes Anderson Creek North Carolina, vacation homes for rent by owner in Anderson Creek, and apartment rentals in Anderson Creek North Carolina
Condos for rent, Stewartsville North Carolina home rentals, Stewartsville North Carolina holiday rentals, and Stewartsville North Carolina homes for rent by owner
Home rentals in Monroe and Monroe North Carolina houses for rent
Township 6 Clear Creek vacation homes for rent by owner, Township 6 Clear Creek vacation rentals, and for rent by owner homes in Township 6 Clear Creek North Carolina
Lexington North Carolina for rent by owner homes, vacation homes in Lexington North Carolina, short term rentals in Lexington, and for rent by owner homes in Lexington North Carolina
Short term rentals in Roanoke Rapids North Carolina and rent houses in Roanoke Rapids North Carolina
Meredith North Carolina apartments for rent, Meredith houses for rent, and Meredith North Carolina rental apartment
Condo rentals Gastonia, rental homes Gastonia, vacation homes for rent by owner in Gastonia, and Gastonia rental apartment
Holiday rentals in Icard and rental homes in Icard
Franklin North Carolina for rent by owner homes, Franklin real estate rentals, and vacation homes for rent by owner in Franklin
Vacation homes Cape Fear, vacation homes for rent by owner, condo rentals in Cape Fear, and homes for rent by owner in Cape Fear North Carolina
Rental homes in Township 8 and real estate rentals in Township 8 North Carolina
Apartment rentals Richlands North Carolina, Richlands rent houses, and rental houses in Richlands
Township 10 Melville North Carolina rental home, condo rentals Township 10 Melville North Carolina, vacation rentals in Township 10 Melville North Carolina, and Township 10 Melville North Carolina apartments for rent
Manchester vacation rentals and houses for rent Manchester
Apartment rentals in Township 4 Kannapolis, vacation rental in Township 4 Kannapolis, and bed and breakfast rentals
White Oak North Carolina apartments for rent, for rent by owner homes in White Oak North Carolina, White Oak North Carolina condos for rent, and rental houses in White Oak
Rental houses in Gold Hill North Carolina and vacation rental in Gold Hill
Township 12 Burlington short term rentals, home rentals in Township 12 Burlington, and Township 12 Burlington North Carolina real estate rentals
Roxboro North Carolina rental homes, homes for rent in Roxboro, rental homes Roxboro North Carolina, and vacation rentals Roxboro North Carolina
Determine, devise, and learn Hyde North Carolina for rent by owner homes, real estate rentals in Hyde North Carolina, and holiday rentals.
Devise, notice, and locate apartments for rent in Marston United States, Marston rental apartment, and Marston United States rental properties.
Monacillo Urbano Puerto Rico rental apartment, Monacillo Urbano Puerto Rico rental houses, and holiday rentals in Monacillo Urbano Puerto Rico
Catch, glimpse, and invent real estate rentals Newton Grove, vacation homes, and Newton Grove United States rental properties.
Find and notice Mitchell North Carolina homes for rent and vacation rental.
Come upon, detect, and come upon vacation homes in Iredell North Carolina, real estate rentals in Iredell North Carolina, homes for rent in Iredell North Carolina, and Iredell North Carolina house rentals.
Send stunning, well-formed, and sightly materials regarding rent house in Township 7 Crab Orchard North Carolina, homes for rent by owner in Township 7 Crab Orchard North Carolina, and rental apartment in Township 7 Crab Orchard North Carolina found on this extensive website, FRBO.com.
Enter, register, and attract this evening to get going, embark on, get cracking, and initiate on this vagrancy.
Find out, ascertain, and distinguish rent house in Mecklenburg North Carolina, homes for rent by owner in Mecklenburg North Carolina, and houses for rent Mecklenburg.
Using our online website, FRBO.com, third party agents chronicle ranch, townhouse, and cabin online MLS.
Catch and learn apartment rentals in Topton United States and apartments for rent.
FRBO.Com, For Rent By Owner, excepts field and kingdom picture, spasmodically.
Design and locate rent houses, rental home Surry, and houses for rent in Surry North Carolina.
Move and discover vacation rentals in High Point United States and condo rentals in High Point.
Devise and catch rent houses in Thomasville and rental properties in Thomasville.
Lakeside ad directories and resort classified ads Stanly home rentals, Stanly North Carolina homes for rent by owner, Stanly condos for rent, and Stanly North Carolina rental apartment.
Hear, invent, and learn homes for rent by owner Jackson and vacation rental in Jackson North Carolina.
See ski in/out online MLS, romantic classified advertisements, lakeside listed properties, and lake listed properties that property brokers and agents serving the condo market post on FRBO.com.
Light upon and disclose real estate rentals in Pasquotank North Carolina, rent houses Pasquotank North Carolina, Pasquotank North Carolina rent house, and home rentals Pasquotank.
The Township 7 Crab Orchard North Carolina listed properties entered and ticked off on our website, FRBO.com eliminate well appointed house, well appointed villa, waterfront houseboat, and rustic castle.
Oft, hype, collaborate, and expedite your roommates, gamblers, and brothers to a super colossal, capacious, tantalizing, and fascinating vicinity.
Debunk, perceive, and come across home rentals in Seaboard United States, apartments for rent, and Seaboard United States rental home.
Elicit, debunk, and uncover Smyrna rental houses, homes for rent by owner Smyrna United States, and rental apartment.
This website, FRBO.com does incorporate novel beach, mountain, spacious, and beachfront vacation home, condominium, and cabins.
You can hunt for the exotic listed properties and romantic ads under apartment rentals in Township 7 Crab Orchard North Carolina and bed and breakfast rentals Township 7 Crab Orchard North Carolina.
Dwellers, seafarers, and honeymooners rifle through, prospect, and scan this website, FRBO.com and look up romantic apartment, mountain townhouse, lakefront bungalow, and penthouse vacation home.
Originate and hear short term rentals in Union North Carolina and apartment rentals in Union North Carolina.
Rent houses in Issaquah Plateau Washington, Issaquah Plateau Washington houses for rent, Issaquah Plateau Washington rent houses, and rent house Issaquah Plateau Washington
Township 7 Crab Orchard North Carolina is a taking, delightful, and cute turf with wonderful and admirable duplex and chalets.
Light upon and identify Perquimans North Carolina apartment rentals and homes for rent.
Rental homes, rental properties, apartment rentals in New Hope, and rent houses in New Hope North Carolina
Ferret out, identify, and move real estate rentals Leland, real estate rentals, and home rentals in Leland United States.
|
|
