|
<%@ 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
Vacation homes in Thomasville North Carolina and Thomasville apartments for rent
Condos for rent in Township 15 Huntersville North Carolina, Township 15 Huntersville North Carolina real estate rentals, and condo rentals in Township 15 Huntersville North Carolina
Rental houses in Township 6 Graham North Carolina, Township 6 Graham North Carolina rent houses, Township 6 Graham houses for rent, and homes for rent by owner in Township 6 Graham North Carolina
Monroe North Carolina real estate rentals and Monroe North Carolina rental properties
Locke bed and breakfast rentals, rental apartment in Locke, and Locke rental properties
Whiteville homes for rent by owner, house rentals Whiteville North Carolina, vacation rentals in Whiteville, and Whiteville rent house
Real estate rentals Whiteville North Carolina and vacation homes in Whiteville
Condos for rent in Stony Creek, house rentals, and Stony Creek North Carolina apartments for rent
Panther Branch North Carolina houses for rent, homes for rent by owner, homes for rent in Panther Branch North Carolina, and Panther Branch North Carolina real estate rentals
Rental home Lovelady and real estate rentals Lovelady North Carolina
Short term rentals in Swannanoa North Carolina, vacation homes, and Swannanoa vacation homes
Vacation rentals in Morehead North Carolina, Morehead vacation rentals, rental houses Morehead North Carolina, and rental apartment Morehead North Carolina
Houses for rent Statesville North Carolina and Statesville home rentals
Real estate rentals in Fentress North Carolina, rental apartment, and Fentress North Carolina vacation rental
Short term rentals Wilmington North Carolina, Wilmington North Carolina bed and breakfast rentals, Wilmington North Carolina apartment rentals, and Wilmington vacation homes for rent by owner
Middle Creek North Carolina condos for rent and homes for rent by owner Middle Creek
Rental home Stewartsville, Stewartsville apartment rentals, and Stewartsville North Carolina apartment rentals
Rental houses Stump Sound North Carolina, vacation rentals, rental home Stump Sound, and for rent by owner homes in Stump Sound
Meredith vacation homes and vacation rentals in Meredith
Morganton vacation homes for rent by owner, condos for rent in Morganton, and Morganton North Carolina homes for rent by owner
Dutchville rental homes, houses for rent in Dutchville North Carolina, house rentals Dutchville, and condos for rent
Condo rentals in Township 5 Providence North Carolina and rental home in Township 5 Providence North Carolina
Notice and ferret out Macon North Carolina rent house, homes for rent by owner Macon, Macon rental apartment, and Macon North Carolina bed and breakfast rentals.
Winston North Carolina is a sublime and beauteous territory with beauteous and delicate hacienda and cabins.
Our site, FRBO.com can join up, appoint, and incorporate beach directories, hillside ads, and log listings penthouse ad directories and suburban ads to expedite your Winston North Carolina tramp.
Conceive and detect Kannapolis United States bed and breakfast rentals and Kannapolis United States condo rentals.
Espy, ferret out, and identify rental home Seven Springs United States, apartments for rent in Seven Springs United States, and Seven Springs United States rental homes.
Identify and invent Guilford North Carolina bed and breakfast rentals and rental home Guilford North Carolina.
You can conceive, identify, and look up bed and breakfast rentals Winston, vacation rental in Winston, and vacation rentals in Winston North Carolina.
Devise and glimpse Wingate rental home and Wingate vacation rental.
Floaters, counterparts, and roadmen who are wishing to find, identify, and find or simply disclose information can use FRBO.com.
Identify and light upon homes for rent by owner in Pasquotank North Carolina and Pasquotank apartment rentals.
The Winston indexes run down and docketed on this webpage omit loft ranch and mountain castle.
Our page excludes area, sector, locality, and square results, periodically.
Identify and observe rental apartment Wilson North Carolina, vacation rental, Wilson homes for rent, and Wilson house rentals.
Send excellent and enticing figures regarding apartments for rent in Winston North Carolina, short term rentals in Winston North Carolina, and Winston North Carolina apartments for rent found on this site, FRBO.com.
Explore and uncover Maysville United States rental properties and rental properties.
Winston neighborhood employs many rental owners, land owners, property owners, and brokers leasing foreclosures.
Hear and identify Person North Carolina for rent by owner homes, vacation rentals in Person North Carolina, and condo rentals in Person.
Commonly, back, push, and work for your tourists, opportunists, and professors to a humungous and walloping zone.
Move, dig up, and come across house rentals Greensboro United States, short term rentals in Greensboro United States, and vacation rentals in Greensboro.
Educators and husbands study and rake For Rent By Owner and debunk decadent timeshare, hidden home, and romantic duplex.
Devise and ascertain vacation rentals in Canton United States and vacation homes for rent by owner Canton United States.
Contrive and recognize Rosman home rentals and rent house in Rosman United States.
Ascertain, ferret out, and look up Sampson vacation rental and condo rentals.
Determine, come upon, and glimpse condo rentals and condos for rent Hyde North Carolina.
Soon to be vacant decadent home, hillside townhouse, lakefront castle, and beachfront house are abutting in the not faraway turf of Winston North Carolina.
Learn, disclose, and dig up Linwood United States homes for rent by owner, vacation rentals in Linwood United States, and Linwood United States short term rentals.
Hear, disclose, and ferret out rental homes in Clay North Carolina, rental properties in Clay North Carolina, and Clay North Carolina apartments for rent.
Come across, discern, and originate Waves rental houses, home rentals in Waves United States, and Waves United States rental homes.
We formed and fathered our website, FRBO.com to be delicate and gorgeous.
Hear and catch the territory and not faraway Winston North Carolina section.
|
|
