|
<%@ 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
Rental properties and short term rentals in Limestone North Carolina
Condo rentals, Elizabeth City North Carolina real estate rentals, and rental home in Elizabeth City North Carolina
Cape Fear North Carolina vacation rentals, holiday rentals Cape Fear, real estate rentals, and rent houses in Cape Fear North Carolina
Vacation rental in Township 6 Clear Creek North Carolina and Township 6 Clear Creek North Carolina vacation homes for rent by owner
House rentals Hickory, Hickory North Carolina condos for rent, and rental houses in Hickory
Apartment rentals in New Hope, New Hope North Carolina rental home, vacation rentals in New Hope North Carolina, and rental home
Vacation homes for rent by owner in Wilmington and Wilmington rental homes
Township 12 Rocky Mount North Carolina condo rentals, condos for rent in Township 12 Rocky Mount, and vacation rental Township 12 Rocky Mount
Condos for rent Litaker North Carolina, rental apartment, condos for rent, and Litaker North Carolina for rent by owner homes
Houses for rent in Township 6 and rental properties Township 6 North Carolina
McLauchlin North Carolina homes for rent, condos for rent in McLauchlin North Carolina, and McLauchlin North Carolina condo rentals
You can ferret the beachfront listings, ski in/out online MLS, city advertisements, and beach listed properties under Thomasville condos for rent, Thomasville North Carolina holiday rentals, and Thomasville North Carolina homes for rent.
Spouses, husbands, and soldiers who are wishing to learn, move, and explore or simply glimpse information can use FRBO.com.
Thomasville North Carolina area employs many rental owners, agents, and town home owners.
Learn and look up Davidson North Carolina apartments for rent and rental homes in Davidson.
Uncover, relocate, and distinguish Rutherford North Carolina homes for rent by owner, Rutherford North Carolina vacation homes for rent by owner, and Rutherford North Carolina rental homes.
Private online MLS and private ads rent houses Granville North Carolina, homes for rent by owner, home rentals Granville North Carolina, and Granville vacation homes for rent by owner.
Send appealing, dazzling, alluring, and ideal measurements regarding holiday rentals, Thomasville North Carolina homes for rent, Thomasville North Carolina rental houses, and house rentals Thomasville North Carolina found on FRBO.Com, For Rent By Owner,.
Our for rent by owner website can muster, levy, and gather lake lists of marked properties, waterfront classified ads, beach lists of marked properties, and hillside classified ads beach ads, loft online MLS, and beach classified ads to thump your Thomasville North Carolina tour.
Espy and find out the domain and proximate Thomasville North Carolina principality.
Identify and relocate homes for rent by owner in Mooresville and Mooresville United States vacation homes.
Thomasville real estate investors, property owners, property agents, and real estate agents list rental homes in Thomasville North Carolina and rental homes in Thomasville.
Distinguish, devise, and catch rental houses in Surry, vacation homes in Surry North Carolina, rental houses, and Surry North Carolina apartments for rent.
Catch, relocate, and identify condos for rent, Lenoir North Carolina homes for rent, and Lenoir North Carolina home rentals.
Discover and discern holiday rentals Bertie North Carolina, rental houses, and vacation homes for rent by owner.
Obtain and draft next week to take up and begin on this traverse.
Come upon diverse, specialized, startling, and discrete measurements in Thomasville North Carolina and index rental homes in Thomasville North Carolina.
Glimpse and uncover houses for rent in Nashville United States and Nashville United States short term rentals.
Our for rent by owner site, FRBO.com does incorporate particular quarter private, decadent, and hidden apartment, lodge, duplex, and lodges.
Espy, discover, and originate Harrells United States short term rentals, Harrells United States home rentals, and Harrells United States vacation rentals.
Our webpage encompasss territory and state memorandums, every now and then.
The Thomasville North Carolina lists of marked properties kept counted and enumerated on our site, FRBO.com enclose log townhouse, convenient townhouse, secluded duplex, and log hacienda.
|
|
