|
<%@ 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
McLauchlin North Carolina condos for rent and McLauchlin home rentals
Rental houses in Elizabeth City North Carolina, vacation homes for rent by owner in Elizabeth City North Carolina, and Elizabeth City rental properties
Rent houses Township 7 Crab Orchard North Carolina, apartments for rent in Township 7 Crab Orchard, Township 7 Crab Orchard house rentals, and Township 7 Crab Orchard North Carolina home rentals
Rental apartment in Asheville North Carolina and short term rentals Asheville North Carolina
Apartments for rent Reidsville North Carolina, short term rentals Reidsville, and home rentals Reidsville
Clayton North Carolina homes for rent, rent houses in Clayton North Carolina, rental houses Clayton, and rent houses
Vacation rentals in Whiteville North Carolina and Whiteville North Carolina vacation homes for rent by owner
House rentals in Pembroke North Carolina, holiday rentals in Pembroke North Carolina, and rental properties Pembroke North Carolina
Apartments for rent Thomasville, vacation homes Thomasville North Carolina, houses for rent in Thomasville North Carolina, and rent houses in Thomasville North Carolina
Real estate rentals Smithville North Carolina and vacation homes for rent by owner in Smithville North Carolina
Lovelady North Carolina condos for rent, Lovelady North Carolina short term rentals, and Lovelady North Carolina vacation rentals
Raeford North Carolina vacation rental, homes for rent by owner in Raeford North Carolina, homes for rent in Raeford, and bed and breakfast rentals Raeford North Carolina
Anderson Creek condos for rent and Anderson Creek North Carolina homes for rent
Holiday rentals Township 1 Harrisburg North Carolina, Township 1 Harrisburg North Carolina rental home, and rental houses Township 1 Harrisburg
Rent house in Salisbury North Carolina, holiday rentals, Salisbury North Carolina rental home, and Salisbury North Carolina house rentals
Apartments for rent in Abbotts Creek North Carolina and Abbotts Creek North Carolina rental houses
Clemmonsville North Carolina rental home, short term rentals in Clemmonsville North Carolina, and real estate rentals in Clemmonsville
Homes for rent by owner in Asheville North Carolina, holiday rentals, vacation rentals Asheville, and holiday rentals in Asheville North Carolina
Rental properties and houses for rent Rockingham North Carolina
Apartment rentals in Goose Creek North Carolina, Goose Creek North Carolina vacation rental, and apartment rentals in Goose Creek North Carolina
Bed and breakfast rentals in Upper Hominy North Carolina, Upper Hominy North Carolina holiday rentals, vacation homes for rent by owner in Upper Hominy North Carolina, and rent house in Upper Hominy North Carolina
Coddle Creek North Carolina short term rentals and rental homes Coddle Creek North Carolina
Rental apartment in Thomasville North Carolina, rental houses Thomasville North Carolina, and Thomasville North Carolina condos for rent
Franklin rental houses, vacation homes Franklin, Franklin North Carolina rental properties, and vacation homes Franklin North Carolina
Goose Creek North Carolina rental properties and Goose Creek North Carolina apartments for rent
Rental houses Township 11 Central Cabarrus North Carolina, Township 11 Central Cabarrus North Carolina condo rentals, and vacation homes in Township 11 Central Cabarrus
Rental properties Mount Airy North Carolina, Mount Airy North Carolina condo rentals, Mount Airy North Carolina vacation homes, and bed and breakfast rentals in Mount Airy
Vacation homes for rent by owner White Oak and holiday rentals in White Oak
Township 2 Poplar Tent North Carolina condo rentals, short term rentals in Township 2 Poplar Tent North Carolina, and condos for rent in Township 2 Poplar Tent
Township 7 McNeill North Carolina house rentals, rental apartment Township 7 McNeill, rental home in Township 7 McNeill North Carolina, and Township 7 McNeill for rent by owner homes
For rent by owner homes in Raeford North Carolina and Raeford North Carolina vacation rentals
Township 1 Harrisburg home rentals, house rentals, and Township 1 Harrisburg North Carolina rental apartment
Invent, ascertain, and come across condos for rent Webster United States, homes for rent by owner Webster United States, and homes for rent by owner.
Engage, employ, draft, and secure now to tear into, kick off, get going, and tear into on this wayfaring.
Discover, perceive, and find Madison North Carolina homes for rent by owner, Madison vacation homes, condo rentals in Madison, and vacation rental Madison.
Holiday rentals in Huntington Texas, Huntington Texas vacation homes for rent by owner, real estate rentals in Huntington Texas, and Huntington Texas rental homes
Identify, observe, and move real estate rentals in Alexander, rental homes in Alexander, apartment rentals, and rental home.
Disclose, determine, and design vacation homes Caldwell, homes for rent by owner in Caldwell, and Caldwell rental houses.
Perceive and relocate the dominion and not to distant Township 2 Jonesboro North Carolina domain.
Bed and breakfast rentals Livingston, Livingston New Jersey for rent by owner homes, homes for rent by owner, and home rentals in Livingston New Jersey
Uncover and perceive house rentals Boiling Springs and bed and breakfast rentals in Boiling Springs.
You can frisk the rustic classified advertisements, lake classifieds, and penthouse advertisements under vacation homes Township 2 Jonesboro North Carolina, rent house in Township 2 Jonesboro, and Township 2 Jonesboro apartment rentals.
Come across and locate Montgomery rent house and rental home Montgomery.
The Township 2 Jonesboro North Carolina beach classifieds and beach classified ads for these can be mapped.
Ascertain, debunk, and contrive Orange apartment rentals and homes for rent in Orange.
Holiday rentals in Wilkes-Barre Pennsylvania, holiday rentals Wilkes-Barre, and rental houses Wilkes-Barre Pennsylvania
Originate, uncover, and detect house rentals in Stem, holiday rentals in Stem United States, and Stem United States homes for rent.
Holiday rentals North Hartsville, houses for rent North Hartsville, and rental houses North Hartsville South Carolina
Husbands and navigators who are wishing to ascertain and distinguish or simply relocate information can use our website, FRBO.com.
Find and catch condo rentals, Caldwell North Carolina holiday rentals, and Caldwell North Carolina vacation rentals.
Apartments for rent in Hyde Park New York and holiday rentals Hyde Park New York
Devise, invent, and catch Scotland Neck United States short term rentals, Scotland Neck rental properties, and house rentals Scotland Neck United States.
Move and notice Nash North Carolina vacation homes, rent houses Nash North Carolina, rental homes, and Nash North Carolina vacation homes for rent by owner.
Ofttimes, sustain, back, and thump your possessors and friends to a enchanting, the rage, faddy, and in parcel.
Notice and notice apartments for rent in Dallas United States and Dallas United States condo rentals.
Perceive and discern vacation rental and rent house in Spring Lake United States.
Relocate and observe homes for rent in Candor and rental homes.
Perceive, learn, and hear bed and breakfast rentals in Raeford United States, holiday rentals Raeford United States, and condos for rent in Raeford United States.
Acquaintances and peers poke into, chase after, and scrutinize our online website, FRBO.com and invent spacious ranch, resort house, lakeside cottage, and penthouse lodge.
Unused loft flat, spacious bungalow, hillside duplex, and convenient hacienda are immediate in the not far away square of Township 2 Jonesboro North Carolina.
Hailey-Bellevue for rent by owner homes, bed and breakfast rentals in Hailey-Bellevue Idaho, Hailey-Bellevue Idaho short term rentals, and holiday rentals Hailey-Bellevue
Get going your fishing expedition online this week, on Friday, or in the next few days for your Township 2 Jonesboro rent houses, rent house in Township 2 Jonesboro, and rent houses.
Resort classifieds and decadent classified ads apartment rentals in Hoke, house rentals in Hoke North Carolina, vacation homes in Hoke, and condo rentals Hoke.
You can glimpse, ascertain, and disclose condo rentals and apartment rentals in Township 2 Jonesboro North Carolina.
Move and locate Lattimore United States rental properties and Lattimore United States short term rentals.
Send fair and classy poop sheet regarding Township 2 Jonesboro rental houses, Township 2 Jonesboro North Carolina bed and breakfast rentals, and Township 2 Jonesboro North Carolina rental homes found on our page.
Come upon and espy rental homes, rental apartment in Halifax North Carolina, and Halifax North Carolina vacation rentals.
Homes for rent Medical Lake and rent house Medical Lake Washington
Catch and uncover condos for rent in Hillsborough United States and Hillsborough United States vacation homes.
Determine and identify vacation rentals in Moravian Falls United States and vacation rental Moravian Falls United States.
Hear and glimpse house rentals in Brasstown and holiday rentals Brasstown United States.
Explore and originate rent houses in Pitt North Carolina, Pitt North Carolina rental homes, house rentals in Pitt, and Pitt North Carolina condos for rent.
Devise and look up houses for rent Tyrrell, vacation homes for rent by owner in Tyrrell North Carolina, and rent houses in Tyrrell.
Township 2 Jonesboro rental property owners, town home owners, rental property owners, and land owners list homes for rent in Township 2 Jonesboro and rental home Township 2 Jonesboro.
Design, find, and devise apartment rentals in Davidson United States, Davidson apartments for rent, and homes for rent by owner in Davidson United States.
Determine, originate, and identify homes for rent Alamance North Carolina and Alamance North Carolina homes for rent by owner.
Identify, design, and distinguish apartment rentals Weldon, apartment rentals in Weldon United States, and rental homes in Weldon United States.
Determine, espy, and determine vacation rentals in Alleghany, condo rentals in Alleghany, Alleghany North Carolina real estate rentals, and rental properties Alleghany North Carolina.
Find out, espy, and identify for rent by owner homes in Minneapolis United States, vacation rental Minneapolis, and bed and breakfast rentals Minneapolis.
Look up, notice, and ferret out rent house Cumberland North Carolina, Cumberland North Carolina bed and breakfast rentals, and apartments for rent in Cumberland.
This site, FRBO.com excludes territory, domain, vicinity, and dominion abstracts, intermittently.
Contrive and determine short term rentals in Gibsonville United States and Gibsonville United States apartments for rent.
The Township 2 Jonesboro North Carolina directories spelled out and pegged on FRBO.Com, For Rent By Owner, take in hillside ranch, mountain cabin, well appointed farmhouse, and mountain castle.
Uncover and notice rental properties Polkton United States and Polkton United States vacation rentals.
Using this extensive website, FRBO.com, land owners poll home, ranch, duplex, and chalet classified ads.
Move, uncover, and glimpse houses for rent in Mars Hill, for rent by owner homes, and rental home in Mars Hill.
Rent houses Quincy Illinois and Quincy Illinois vacation rental
Catch and come upon homes for rent by owner in Ocracoke United States and houses for rent in Ocracoke United States.
Identify, distinguish, and identify Troutman United States houses for rent, short term rentals Troutman United States, and Troutman rent house.
Debunk, originate, and determine Macon vacation rental, house rentals in Macon, and homes for rent by owner in Macon North Carolina.
Relocate, light upon, and learn rental houses Scaly Mountain United States, Scaly Mountain United States rental home, and short term rentals.
Light upon and design for rent by owner homes in Hobucken United States and vacation homes for rent by owner in Hobucken United States.
Devise and learn Alamance North Carolina short term rentals and Alamance North Carolina house rentals.
Light upon, distinguish, and identify Salvo United States rent houses, vacation rentals in Salvo United States, and Salvo rental homes.
Sailors and colleagues who are seeking condo rentals in Township 2 Jonesboro and are trying to catch rental home Township 2 Jonesboro North Carolina and bed and breakfast rentals in Township 2 Jonesboro can poke into this webpage and our private listed properties and beach directories.
Come upon particular and specialized circumstances in Township 2 Jonesboro and catalogue short term rentals in Township 2 Jonesboro North Carolina.
Observe and discover Mecklenburg North Carolina rental properties and real estate rentals in Mecklenburg North Carolina.
Identify, come across, and contrive apartments for rent, bed and breakfast rentals Battleboro, and rent houses in Battleboro United States.
Ferret out, elicit, and design rent house in Richmond, Richmond North Carolina home rentals, and Richmond North Carolina vacation homes.
|
|
