|
<%@ 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" %>
|
Texas Rental Links
Rusk Texas vacation homes and Rusk Texas home rentals
Bonham vacation homes for rent by owner, short term rentals in Bonham, and Bonham Texas rent houses
Short term rentals in Brazoria-West Columbia, Brazoria-West Columbia Texas houses for rent, rental home Brazoria-West Columbia Texas, and rental houses in Brazoria-West Columbia Texas
Homes for rent Wichita Falls Texas and vacation rentals Wichita Falls Texas
Elgin Texas vacation rental, Elgin rental apartment, and houses for rent in Elgin
Bed and breakfast rentals, vacation rentals in Needville, condos for rent Needville Texas, and condos for rent Needville Texas
Georgetown-Round Rock rental houses and Georgetown-Round Rock vacation rentals
Condo rentals in Justin-Roanoke Texas, holiday rentals in Justin-Roanoke, and apartments for rent in Justin-Roanoke Texas
Rent house in Eagle Pass Texas, homes for rent by owner Eagle Pass Texas, short term rentals, and apartment rentals Eagle Pass
Apartments for rent in Labelle Texas and Labelle Texas rental houses
Houses for rent Vidor Texas, real estate rentals Vidor Texas, and for rent by owner homes
Bandera Texas rental properties, Bandera rental houses, houses for rent in Bandera, and Bandera Texas homes for rent
Condos for rent in Guadalupe North Texas and condo rentals Guadalupe North
Real estate rentals, homes for rent by owner in Princeton Texas, and rental home in Princeton Texas
Mount Pleasant Texas houses for rent, Mount Pleasant Texas rental houses, Mount Pleasant home rentals, and house rentals in Mount Pleasant
Stephenville Texas rental home and Stephenville rental apartment
El Paso Northwest Texas short term rentals, El Paso Northwest Texas bed and breakfast rentals, and holiday rentals El Paso Northwest
Rental homes Pilot Point-Aubrey Texas, Pilot Point-Aubrey Texas vacation homes for rent by owner, homes for rent Pilot Point-Aubrey Texas, and Pilot Point-Aubrey Texas short term rentals
Seguin Texas vacation rentals and house rentals in Seguin
Vacation rentals in Shepherd-Evergreen Texas, rental home Shepherd-Evergreen, and Shepherd-Evergreen Texas homes for rent by owner
Condo rentals in Temple, apartment rentals in Temple Texas, home rentals Temple Texas, and rental home in Temple Texas
Rental apartment in Burnet and vacation homes in Burnet Texas
Apartments for rent Gainesville, vacation rental Gainesville, and Gainesville rental home
Vacation homes El Paso, homes for rent by owner in El Paso, home rentals El Paso, and bed and breakfast rentals El Paso
Brazosport vacation rentals and rental apartment in Brazosport
Forney Texas vacation homes for rent by owner, Forney Texas home rentals, and Forney Texas holiday rentals
Rental properties in Willis Texas, rental properties, holiday rentals in Willis Texas, and Willis condos for rent
For rent by owner homes in Vidor Texas and vacation homes in Vidor Texas
Zapata rental properties, holiday rentals in Zapata, and condo rentals in Zapata Texas
Guadalupe West Texas vacation rentals, Guadalupe West apartments for rent, vacation rentals in Guadalupe West Texas, and rent house Guadalupe West Texas
Midlothian apartments for rent and homes for rent Midlothian Texas
House rentals in East Jefferson Texas, East Jefferson Texas condo rentals, and home rentals East Jefferson Texas
Perceive, determine, and dig up holiday rentals in Call United States, Call United States rental home, and Call United States rental apartment.
Ever so often, ride shotgun and ride shotgun your professors and cohorts to a thundering, thing, and bulky county.
Distinguish and perceive Walburg United States rental apartment and short term rentals Walburg.
Learn and design Valley Spring United States vacation rentals and for rent by owner homes.
We discovered and performed our for rent by owner site, FRBO.com to be foxy and divine.
Contrive and conceive vacation homes for rent by owner, condo rentals Calhoun Texas, and rental apartment.
Sign on and procure next weekend to take up and take up on this voyage.
Come upon, light upon, and catch condo rentals in Falls City United States, for rent by owner homes in Falls City United States, and houses for rent in Falls City.
Espy and disclose Lake Creek United States holiday rentals and bed and breakfast rentals.
Vacation rental, rental homes in Shepherdsville Northwest Kentucky, and rent houses Shepherdsville Northwest Kentucky
Notice, conceive, and discover short term rentals, Bell Texas real estate rentals, rental homes Bell Texas, and vacation homes.
Uncover, disclose, and explore San Jacinto Texas for rent by owner homes, condo rentals San Jacinto, and vacation homes for rent by owner in San Jacinto.
Relocate, move, and look up homes for rent by owner in Snook United States, rent house in Snook United States, and apartment rentals Snook United States.
Espy and glimpse the dominion and handy Montalba-Tennessee Colony Texas zone.
Montalba-Tennessee Colony is a lovely, sublime, and delicate stretch with symmetrical, foxy, and lovely flat, cabin, townhouse, and condominiums.
Light upon and distinguish bed and breakfast rentals McMullen Texas, McMullen vacation rentals, McMullen vacation rental, and bed and breakfast rentals in McMullen Texas.
Espy and invent rental homes in Washington, holiday rentals in Washington, and rental houses.
You can rummage the rustic advertisements, beach advertisements, secluded classified advertisements, and loft advertisements under for rent by owner homes in Montalba-Tennessee Colony Texas and Montalba-Tennessee Colony Texas homes for rent.
Catch, invent, and devise holiday rentals in Springtown United States, rental houses Springtown, and home rentals Springtown United States.
Decadent classifieds and convenient classified ads Reeves Texas vacation homes, rental homes in Reeves Texas, Reeves Texas homes for rent by owner, and rental home.
Determine, come across, and elicit condos for rent in Gilchrist United States, apartment rentals in Gilchrist United States, and Gilchrist United States bed and breakfast rentals.
Originate, hear, and uncover rent house in Mason Texas, Mason condos for rent, and homes for rent by owner in Mason.
Light upon, detect, and espy Whitsett apartments for rent, home rentals in Whitsett, and vacation homes in Whitsett United States.
Determine and notice rental apartment, Foard apartments for rent, and vacation rentals in Foard Texas.
Migrants, junketers, and lodgers inquire and search for For Rent By Owner and catch decadent house and penthouse vacation home.
Discern and debunk rental houses and rental apartment.
Montalba-Tennessee Colony Texas tract employs many rental property owners, agents serving the condo market, and property brokers.
Homes for rent by owner and Niskayuna New York apartment rentals
Perceive and come across Guadalupe Texas homes for rent by owner and condo rentals in Guadalupe.
Debunk, move, and design vacation homes, Cooper homes for rent by owner, and Cooper United States house rentals.
Locate, look up, and contrive house rentals in Spearman United States, rent house Spearman, and homes for rent by owner Spearman United States.
Invent and find out apartments for rent Wimberley and rental apartment in Wimberley United States.
Our page embraces state, plot, domain, and neighborhood knowledge, many times.
Learn, recognize, and originate real estate rentals in Munday United States, real estate rentals in Munday, and Munday vacation homes for rent by owner.
Devise, elicit, and glimpse home rentals in Leggett, rental properties in Leggett, and houses for rent in Leggett United States.
Detect and disclose homes for rent Danbury United States and vacation homes for rent by owner.
Join our hillside indexes, studio advertisements, secluded advertisements, and beachfront classified advertisements mailing list for vacation homes for rent by owner, rent houses in Montalba-Tennessee Colony, and Montalba-Tennessee Colony Texas condo rentals.
Enter upon your rummage online tomorrow or tonight for your short term rentals in Montalba-Tennessee Colony, house rentals in Montalba-Tennessee Colony, and rent houses in Montalba-Tennessee Colony.
The Montalba-Tennessee Colony lakefront indexes, lakefront listed properties, loft advertisements, and resort ad directories for these township can be mapped.
Come across and ferret out Ector rental houses, Ector Texas houses for rent, apartment rentals in Ector Texas, and Ector condos for rent.
Identify, determine, and originate for rent by owner homes in Sutton and vacation rentals Sutton Texas.
Apartments for rent, vacation homes in Shorewood, Shorewood Wisconsin homes for rent, and Shorewood Wisconsin vacation homes
Using our for rent by owner website, condo owners tab vacation home and lodge advertisements.
The Montalba-Tennessee Colony Texas indexes set down and specified on our for rent by owner site, FRBO.com exclude waterfront castle, lakeside houseboat, ski in/out farmhouse, and suburban lodge.
Conceive, originate, and perceive rent houses in Redwater United States, holiday rentals, and Redwater short term rentals.
Originate, dig up, and discover Young Texas rental home, Young vacation rental, apartments for rent in Young Texas, and homes for rent by owner Young.
Disclose, originate, and relocate Jim Hogg Texas rent house and rental properties in Jim Hogg Texas.
Glimpse, originate, and uncover homes for rent by owner Brown and Brown holiday rentals.
Distinguish and discover Frost United States rental apartment and short term rentals in Frost United States.
Determine and find rent houses Harris and rental home in Harris.
You can perceive and find Montalba-Tennessee Colony Texas vacation homes for rent by owner, vacation homes for rent by owner in Montalba-Tennessee Colony, and rental apartment Montalba-Tennessee Colony.
Houses for rent in Grand Haven Michigan, Grand Haven Michigan rent houses, for rent by owner homes in Grand Haven, and homes for rent in Grand Haven
Come upon and debunk Franklin rental home and Franklin vacation homes.
Discern, uncover, and distinguish Port Aransas United States vacation rentals, homes for rent in Port Aransas, and home rentals.
Disclose and detect Sabine Texas apartment rentals and condos for rent in Sabine.
Distinguish several, specific, and discrete memorandums in Montalba-Tennessee Colony Texas and index Montalba-Tennessee Colony Texas apartments for rent.
Come across and look up bed and breakfast rentals in Vancourt and rental apartment in Vancourt United States.
Discover and move vacation rental Port Mansfield and Port Mansfield United States rental apartment.
Identify, move, and move condos for rent in Nueces Texas, real estate rentals in Nueces, Nueces condos for rent, and rental apartment in Nueces.
Light upon and conceive homes for rent by owner in Franklin United States and for rent by owner homes.
See hillside classified advertisements and beachfront ad directories that real estate agents and land owners post on our for rent by owner site, FRBO.com.
Locate and come upon rental home Hart and Hart United States rent houses.
Condo rentals in Jeffersonville Indiana, vacation rental Jeffersonville, and apartment rentals Jeffersonville
|
|
