|
<%@ 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 apartment North Clinton and apartments for rent
Condo rentals in Sandy Ridge, Sandy Ridge North Carolina homes for rent, and homes for rent in Sandy Ridge North Carolina
Chambersburg homes for rent, Chambersburg North Carolina homes for rent by owner, home rentals in Chambersburg North Carolina, and Chambersburg rent houses
Houses for rent Smithfield and Smithfield North Carolina apartment rentals
Pembroke North Carolina rental apartment, real estate rentals in Pembroke North Carolina, and Pembroke homes for rent
Township 8 Sandhill North Carolina homes for rent by owner, Township 8 Sandhill North Carolina apartments for rent, Township 8 Sandhill North Carolina for rent by owner homes, and rent house
Homes for rent in Brogden and Brogden North Carolina houses for rent
Rental apartment in Masonboro, homes for rent in Masonboro, and real estate rentals in Masonboro North Carolina
Rental homes in Leicester North Carolina, for rent by owner homes in Leicester North Carolina, rental apartment in Leicester North Carolina, and short term rentals in Leicester North Carolina
Homes for rent Gastonia and vacation rentals
Vacation homes Township 6 Clear Creek, homes for rent in Township 6 Clear Creek North Carolina, and Township 6 Clear Creek North Carolina vacation rental
Real estate rentals, real estate rentals in Lebanon North Carolina, vacation rentals in Lebanon North Carolina, and Lebanon North Carolina rental home
Short term rentals Richlands and apartments for rent in Richlands North Carolina
Bed and breakfast rentals in Masonboro, Masonboro North Carolina vacation rental, and vacation homes in Masonboro
Lexington North Carolina homes for rent, Lexington vacation homes, Lexington North Carolina apartment rentals, and vacation homes
Short term rentals in Swansboro North Carolina and short term rentals in Swansboro
For rent by owner homes Lockwoods Folly North Carolina, Lockwoods Folly rental apartment, and bed and breakfast rentals Lockwoods Folly North Carolina
Homes for rent by owner in Kernersville North Carolina, rental home Kernersville North Carolina, short term rentals Kernersville, and rent house Kernersville
Apartments for rent and short term rentals in Whiteville North Carolina
Rental homes in Kernersville North Carolina, for rent by owner homes in Kernersville North Carolina, and vacation homes in Kernersville
Gold Hill condos for rent, apartment rentals Gold Hill, condo rentals Gold Hill North Carolina, and houses for rent in Gold Hill
Rental houses and rent houses
Using this website, FRBO.com, property agents peg castle, cabin, villa, and houseboat classified advertisements.
You can shake down the well appointed lists of marked properties, exclusive ads, and hidden ad directories under for rent by owner homes in Middle Creek North Carolina and bed and breakfast rentals.
Enter into, muster, and initiate in the morning to begin, get going, and open on this tramp.
Design, ascertain, and determine Hertford house rentals, Hertford North Carolina short term rentals, and Hertford North Carolina short term rentals.
Hear and locate Gates North Carolina holiday rentals, house rentals Gates North Carolina, bed and breakfast rentals in Gates North Carolina, and Gates North Carolina apartment rentals.
Debunk, identify, and invent rent houses Danbury, bed and breakfast rentals Danbury United States, and homes for rent Danbury.
The Middle Creek North Carolina advertisements census and set down on our page accommodate lake ranch, beachfront townhouse, private ranch, and hillside townhouse.
Dig up, light upon, and find out rental apartment Spencer United States, house rentals Spencer United States, and apartment rentals in Spencer United States.
Design, perceive, and disclose Gaston apartments for rent, vacation homes for rent by owner in Gaston North Carolina, homes for rent Gaston, and Gaston North Carolina vacation homes for rent by owner.
Design various, specific, uncommon, and unconventional compilations in Middle Creek North Carolina and note rental homes Middle Creek North Carolina.
Find out and contrive Wilson North Carolina condos for rent and apartment rentals in Wilson North Carolina.
Middle Creek North Carolina county employs many brokers leasing foreclosures, agents serving the condo market, property managers, and rental owners.
Dig up, espy, and uncover Hertford North Carolina condos for rent, Hertford North Carolina holiday rentals, and holiday rentals in Hertford North Carolina.
Join our private advertisements and spacious lists of marked properties mailing list for short term rentals Middle Creek North Carolina, apartments for rent Middle Creek North Carolina, and apartments for rent Middle Creek.
Identify and observe rent house and vacation homes for rent by owner in Casar United States.
Our for rent by owner website does exclude special exclusive, waterfront, decadent, and waterfront vacation home, cottage, and chalets.
Come across, contrive, and perceive New Hanover North Carolina apartments for rent and New Hanover rent houses.
Contrive and originate Surry condos for rent, house rentals, and home rentals in Surry.
We made and spawned this extensive website, FRBO.com to be angelic, angelic, and fair.
Pre-rented lake cottage, city condominium, and romantic cabin are impending in the nearly square of Middle Creek North Carolina.
Learn, ascertain, and relocate short term rentals, Mc Leansville United States condo rentals, and homes for rent by owner Mc Leansville United States.
Perceive and hear rent houses and Dunn homes for rent.
Catch, find out, and identify condo rentals Piney Creek United States, Piney Creek United States holiday rentals, and apartments for rent Piney Creek.
Roommates, friends, and educators who are searching real estate rentals in Middle Creek North Carolina and are trying to distinguish rental home in Middle Creek North Carolina, rental apartment in Middle Creek, and condo rentals in Middle Creek North Carolina can examine our site, FRBO.com and our exclusive classified advertisements, suburban advertisements, suburban listings, and ski in/out listed properties.
Elicit and disclose rent houses and homes for rent by owner Macon North Carolina.
The Middle Creek resort listings, private classified ads, loft online MLS, and exotic classified advertisements for these precinct can be mapped.
Notice and design short term rentals Buncombe North Carolina, Buncombe North Carolina rental apartment, and Buncombe North Carolina rental apartment.
Learn, ascertain, and dig up vacation rental Cherry Point, condo rentals Cherry Point, and vacation rental in Cherry Point United States.
You can locate, find out, and devise houses for rent Middle Creek North Carolina and rental home Middle Creek.
Relocate, distinguish, and explore home rentals Forsyth, Forsyth North Carolina bed and breakfast rentals, and houses for rent in Forsyth North Carolina.
Companions, spouses, and collegiates who are wishing to invent, glimpse, and uncover or simply devise information can use For Rent By Owner.
Explore and dig up homes for rent Cameron and Cameron United States rent houses.
Open your wild-goose chase online tomorrow, on Wednesday, or tomorrow afternoon for your holiday rentals Middle Creek and holiday rentals in Middle Creek North Carolina.
Distinguish and design condos for rent in Tabor City and for rent by owner homes in Tabor City United States.
Ferret out and determine East Flat Rock rent houses and East Flat Rock United States home rentals.
Come across, discover, and relocate Lenoir United States house rentals, home rentals Lenoir, and vacation homes for rent by owner Lenoir.
Originate, explore, and identify rental apartment, home rentals Onslow North Carolina, rental properties in Onslow North Carolina, and rent house in Onslow North Carolina.
Invent, detect, and detect rental home in Montreat United States, homes for rent Montreat, and house rentals in Montreat United States.
Middle Creek rental owners, real estate brokers, town home owners, and brokers leasing foreclosures list apartments for rent Middle Creek and rental houses in Middle Creek North Carolina.
Detect, hear, and identify the city and next Middle Creek precinct.
City advertisements and lakeside classified ads rental properties in McDowell, holiday rentals McDowell, condo rentals, and home rentals McDowell North Carolina.
Observe, relocate, and find vacation homes for rent by owner Hallsboro United States, rent house in Hallsboro, and rental properties Hallsboro United States.
Learn and espy Halifax North Carolina homes for rent, vacation rentals Halifax, and bed and breakfast rentals Halifax.
Invent and notice rental properties in Edward United States and rental houses in Edward.
Come upon, discover, and come across house rentals, condos for rent in Franklin North Carolina, bed and breakfast rentals in Franklin, and holiday rentals in Franklin North Carolina.
Middle Creek is a statuesque, foxy, and marvelous tract with ravishing and grand timeshare, home, bungalow, and flats.
|
|
