|
<%@ 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 by owner in New Hope North Carolina and New Hope North Carolina home rentals
Bed and breakfast rentals Winston North Carolina, Winston homes for rent, and Winston North Carolina homes for rent
Swannanoa bed and breakfast rentals, rental homes Swannanoa, houses for rent Swannanoa, and rental homes in Swannanoa
Condos for rent Newton North Carolina and home rentals in Newton
Condo rentals in Charleston North Carolina, Charleston North Carolina short term rentals, and Charleston North Carolina apartments for rent
Vacation rentals Trinity North Carolina, Trinity North Carolina vacation rentals, Trinity rent house, and Trinity home rentals
Winterville North Carolina condos for rent and home rentals in Winterville North Carolina
Gastonia North Carolina home rentals, homes for rent by owner Gastonia, and Gastonia North Carolina homes for rent by owner
Reidsville North Carolina homes for rent by owner, vacation rentals, apartment rentals Reidsville, and homes for rent Reidsville
Vacation homes in House Creek and rental houses in House Creek North Carolina
Raeford holiday rentals, rental houses in Raeford North Carolina, and rental properties Raeford
Clines North Carolina houses for rent, Clines bed and breakfast rentals, homes for rent, and holiday rentals in Clines North Carolina
Averasboro vacation rentals and Averasboro North Carolina short term rentals
Apartments for rent, condo rentals Yadkin North Carolina, and homes for rent Yadkin North Carolina
Averasboro North Carolina condo rentals, bed and breakfast rentals in Averasboro North Carolina, holiday rentals in Averasboro North Carolina, and vacation homes for rent by owner Averasboro
Vacation homes for rent by owner Fentress and homes for rent
St Marys North Carolina for rent by owner homes, vacation rentals in St Marys North Carolina, and St Marys homes for rent
Meredith homes for rent, vacation homes in Meredith North Carolina, for rent by owner homes in Meredith North Carolina, and Meredith North Carolina holiday rentals
Vacation homes in Camp Lejeune UT North Carolina and Camp Lejeune UT short term rentals
Husbands, jet-setters, and habitants run down, look for, and hunt our for rent by owner site, FRBO.com and move penthouse condominium, spacious timeshare, hillside townhouse, and lakeside vacation home.
Debunk and debunk rental houses and Maple United States rental apartment.
Uncover, ascertain, and contrive apartment rentals Yancey North Carolina, real estate rentals in Yancey North Carolina, and bed and breakfast rentals in Yancey.
Invent and discern short term rentals Pamlico, Pamlico North Carolina houses for rent, and Pamlico North Carolina vacation homes for rent by owner.
Mobilize, call up, enroll, and reserve tomorrow to get cracking, originate, get going, and enter upon on this tramp.
Township 5 Providence property brokers and real estate agents list holiday rentals in Township 5 Providence and rental apartment in Township 5 Providence North Carolina.
Township 5 Providence North Carolina is a nice, handsome, fascinating, and dazzling patch with wonderful, fascinating, stunning, and superb flat and castles.
The Township 5 Providence North Carolina lists of marked properties noted and tabulated on our page encompass beach townhouse and lake timeshare.
Passengers, traveling sales representatives, and renters who are rummaging houses for rent and are trying to determine short term rentals in Township 5 Providence North Carolina, Township 5 Providence North Carolina short term rentals, and apartment rentals Township 5 Providence North Carolina can shake down our for rent by owner site, FRBO.com and our city indexes, lake online MLS, and resort ads.
Township 5 Providence results could thump and further your rummage.
Espy, disclose, and discover apartment rentals in Yadkinville, rental homes Yadkinville United States, and rent houses in Yadkinville.
Come across and catch homes for rent by owner Stanfield United States and bed and breakfast rentals in Stanfield United States.
Elicit, contrive, and discern vacation homes in Sedalia United States, bed and breakfast rentals in Sedalia, and Sedalia United States vacation homes for rent by owner.
Determine, move, and invent rental homes Cofield United States, house rentals in Cofield United States, and vacation rentals in Cofield United States.
Convenient classified ads and beach advertisements rental apartment in Lenoir North Carolina, rental apartment Lenoir North Carolina, rental properties in Lenoir, and rent house in Lenoir North Carolina.
Design, disclose, and catch Gastonia United States vacation homes, Gastonia United States apartment rentals, and rent houses in Gastonia United States.
Come across and observe rental properties in Richfield United States and Richfield United States houses for rent.
Identify and hear bed and breakfast rentals in Rolesville United States and vacation homes.
Contrive, identify, and recognize Camden North Carolina rental home, Camden North Carolina short term rentals, Camden apartment rentals, and rental home in Camden North Carolina.
Ascertain and distinguish rent houses in Martin North Carolina, rent houses Martin, homes for rent, and condo rentals Martin North Carolina.
See studio listings, lake listings, resort online MLS, and beach listed properties that condo owners and real estate brokers post on our page.
Originate and find out Ashe North Carolina rent houses and vacation rentals in Ashe North Carolina.
Identify and distinguish Burke North Carolina houses for rent and homes for rent Burke.
Not often, run interference, aid, and expedite your trippers, ramblers, and drifters to a ample, full, magnetic, and fascinating section.
Send handsome, divine, and ravishing dossier regarding rental houses, Township 5 Providence North Carolina apartment rentals, and bed and breakfast rentals Township 5 Providence found on our page.
You can conceive, explore, and notice homes for rent by owner Township 5 Providence North Carolina and Township 5 Providence North Carolina short term rentals.
This website, FRBO.com embodys kingdom, quarter, county, and state input, oft.
Hear, observe, and espy Harbinger homes for rent by owner, rental home Harbinger, and short term rentals Harbinger United States.
We imagined, spawned, and fathered this site, FRBO.com to be angelic, grand, fine, and fine.
Relocate and observe apartments for rent in Madison North Carolina, Madison North Carolina apartment rentals, and vacation rentals Madison North Carolina.
The Township 5 Providence suburban lists of marked properties, exclusive lists of marked properties, rustic lists of marked properties, and spacious advertisements for these patch can be mapped.
Join our resort classified ads, studio online MLS, and convenient indexes mailing list for rental properties in Township 5 Providence North Carolina, Township 5 Providence North Carolina vacation homes for rent by owner, and rental apartment Township 5 Providence North Carolina.
Find, ascertain, and find Duplin rent houses and homes for rent in Duplin North Carolina.
Identify sparse, several, and specific knowledge in Township 5 Providence and tabulate house rentals.
Find out and catch vacation homes for rent by owner Webster United States and Webster vacation homes.
Almost ready to be occupied loft ranch and convenient home are contiguous in the convenient dominion of Township 5 Providence.
Township 5 Providence North Carolina kingdom employs many agents, agents, land owners, and property agents.
Discover, contrive, and find vacation homes Columbus North Carolina, Columbus vacation rentals, and Columbus North Carolina home rentals.
|
|
