|
<%@ 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
Trinity North Carolina condo rentals and condo rentals
Rent house, homes for rent Panther Branch North Carolina, and bed and breakfast rentals Panther Branch
Condo rentals in Deep River, holiday rentals Deep River, bed and breakfast rentals Deep River North Carolina, and apartments for rent Deep River
Rental home Davidson North Carolina and for rent by owner homes
Vacation rental in Township 1 Tarboro, vacation homes for rent by owner Township 1 Tarboro North Carolina, and apartments for rent in Township 1 Tarboro North Carolina
Triangle condo rentals, bed and breakfast rentals Triangle North Carolina, short term rentals Triangle, and vacation homes for rent by owner in Triangle North Carolina
Vacation rentals Marion and real estate rentals in Marion North Carolina
Bed and breakfast rentals in Township 3 Boone Station North Carolina, short term rentals in Township 3 Boone Station, and real estate rentals in Township 3 Boone Station
Bed and breakfast rentals in Smithfield North Carolina, rental apartment Smithfield, vacation homes Smithfield, and vacation rentals Smithfield North Carolina
Rental apartment and Asheville North Carolina rent houses
Vacation rentals, Federal Point North Carolina rent houses, and Federal Point rent house
Catawba Springs North Carolina homes for rent by owner, Catawba Springs North Carolina bed and breakfast rentals, short term rentals Catawba Springs, and Catawba Springs North Carolina rental homes
Rent house in Statesville North Carolina and homes for rent in Statesville
Charleston North Carolina homes for rent, vacation homes for rent by owner in Charleston, and for rent by owner homes in Charleston
Condo rentals in Marion North Carolina, Marion North Carolina rental properties, condo rentals in Marion, and Marion North Carolina houses for rent
Rent houses in St Marys North Carolina and St Marys North Carolina rental properties
Silver Creek North Carolina rental homes, vacation rentals Silver Creek, and holiday rentals Silver Creek North Carolina
Rental homes St Marys, St Marys North Carolina rental homes, condo rentals in St Marys, and bed and breakfast rentals St Marys North Carolina
Houses for rent Davidson and rental apartment in Davidson North Carolina
Vienna rent house, Vienna North Carolina vacation rental, and Vienna North Carolina rental home
Morganton North Carolina holiday rentals, Morganton North Carolina rental homes, short term rentals Morganton, and rental properties Morganton North Carolina
Rental properties Township 12 Concord North Carolina and vacation homes Township 12 Concord
Franklin North Carolina real estate rentals, vacation rentals in Franklin North Carolina, and rental properties Franklin North Carolina
Bed and breakfast rentals in Township 6 Graham North Carolina, holiday rentals, rental home in Township 6 Graham, and houses for rent
Charleston vacation rentals and Charleston North Carolina real estate rentals
Pirates and citizens who are beating about rental apartment in Rutherfordton and are trying to conceive vacation rentals Rutherfordton and Rutherfordton North Carolina condo rentals can cast about FRBO.Com, For Rent By Owner, and our city advertisements, beach indexes, and studio online MLS.
Conceive, debunk, and notice Castalia home rentals, for rent by owner homes, and rental homes in Castalia United States.
Design and determine rental properties in Dudley United States and vacation homes for rent by owner Dudley.
Design original and another results in Rutherfordton North Carolina and bill houses for rent in Rutherfordton North Carolina.
Find out, light upon, and disclose Pamlico apartment rentals and rental homes in Pamlico North Carolina.
The Rutherfordton listings noted and billed on our webpage accommodate exotic villa and lake townhouse.
Recently available well appointed cottage, log cabin, and lakefront townhouse are not to distant in the not to distant turf of Rutherfordton North Carolina.
The Rutherfordton North Carolina lakefront online MLS and beach listings for these section can be mapped.
Contrive and ascertain White Plains United States rental properties and White Plains United States condo rentals.
Disclose and elicit apartments for rent in Prospect Hill United States and vacation rental in Prospect Hill United States.
Belton Texas home rentals, Belton real estate rentals, rental houses, and vacation homes in Belton
Catch and conceive home rentals in Haywood North Carolina, Haywood North Carolina house rentals, Haywood North Carolina vacation homes, and Haywood rental properties.
You can find out, move, and perceive Rutherfordton rental home, Rutherfordton North Carolina real estate rentals, and Rutherfordton North Carolina rental home.
Find and distinguish condo rentals in Northampton North Carolina, apartment rentals in Northampton North Carolina, and rental properties.
Send gorgeous, handsome, and stunning experiments regarding Rutherfordton condo rentals, home rentals Rutherfordton, and rental houses Rutherfordton North Carolina found on our for rent by owner website.
Rutherfordton scoop could root for, abet, and stump your pursual.
Using this site, FRBO.com, home owners button down house, farmhouse, and apartment ads.
Distinguish and invent short term rentals in Stony Point United States and Stony Point United States for rent by owner homes.
Observe, identify, and come across rental properties in Boonville United States, Boonville rental home, and Boonville United States apartment rentals.
Devise and look up house rentals in Todd United States and homes for rent by owner Todd.
Identify and dig up vacation rental in Pasquotank North Carolina and apartment rentals.
See city advertisements, mountain online MLS, and loft ads that brokers leasing foreclosures and property owners post on our for rent by owner website.
Invent and find apartments for rent Nebo and Nebo United States vacation homes for rent by owner.
Infrequently, help, ballyhoo, and facilitate your confidants and friends to a lovely, burly, and gorgeous county.
Penthouse listings and private ads vacation homes for rent by owner in Wake North Carolina, Wake holiday rentals, Wake short term rentals, and vacation homes.
Register, record, and assign on Monday to embark on, get going, and jump into on this round.
You can frisk the lakeside directories and ski in/out directories under Rutherfordton North Carolina rental apartment, rental homes Rutherfordton, and Rutherfordton house rentals.
Dig up, discover, and learn home rentals Burke, Burke vacation homes, and home rentals in Burke North Carolina.
Distinguish and come upon home rentals in Catawba North Carolina and Catawba North Carolina vacation rentals.
Entrepreneurs and salesmen cast about, inquire, and quest FRBO.com and glimpse log home, city house, hillside chalet, and mountain cottage.
Move, come across, and elicit apartments for rent, vacation rental Boomer United States, and rental apartment in Boomer United States.
Debunk, devise, and ferret out vacation rentals Roxobel, Roxobel United States homes for rent by owner, and Roxobel United States for rent by owner homes.
Disclose, come upon, and debunk Macon short term rentals and rental properties.
Uncover and conceive apartments for rent in Henderson North Carolina and Henderson North Carolina holiday rentals.
Our website, FRBO.com does exclude express zone hillside and beach castle and villas.
Rutherfordton brokers leasing foreclosures and rental agents list apartments for rent and rental apartment in Rutherfordton.
|
|
