|
<%@ 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
Bed and breakfast rentals Gregory-Portland Texas and vacation homes for rent by owner Gregory-Portland Texas
Vacation rental Travis Northeast Texas, Travis Northeast Texas homes for rent, and holiday rentals
Vacation homes for rent by owner Taylor, rent houses in Taylor Texas, Taylor rental apartment, and rental properties
Holiday rentals Cleburne Texas and vacation rentals in Cleburne
Center Texas rental home, Center rent houses, and Center Texas home rentals
For rent by owner homes, condo rentals in Pasadena Texas, for rent by owner homes, and apartments for rent
Hallsville Texas rental properties and rental properties in Hallsville Texas
Vacation rentals Lamesa, rental homes, and Lamesa Texas house rentals
Big Spring Texas condo rentals, homes for rent by owner, rental home in Big Spring Texas, and vacation homes in Big Spring Texas
South Brazos Texas rent house and rental homes South Brazos
Holiday rentals Temple, Temple Texas vacation homes for rent by owner, and condo rentals in Temple Texas
Rent house, Northeast apartments for rent, vacation rental, and Northeast Texas for rent by owner homes
Homes for rent and home rentals in Brownfield Texas
Homes for rent Mount Pleasant, rent house Mount Pleasant, and home rentals Mount Pleasant Texas
Rental properties Lamesa Texas, condos for rent in Lamesa, houses for rent in Lamesa, and homes for rent by owner Lamesa Texas
House rentals in Fort Worth Texas and Fort Worth Texas vacation rental
Big Spring house rentals, bed and breakfast rentals Big Spring, and Big Spring Texas condos for rent
Hebron Texas vacation homes, vacation rentals in Hebron, homes for rent Hebron, and bed and breakfast rentals in Hebron
Silsbee rental homes and Silsbee Texas bed and breakfast rentals
Rental properties in Wichita Falls Texas, Wichita Falls Texas vacation homes for rent by owner, and Wichita Falls apartment rentals
For rent by owner homes in Athens Texas, Athens Texas vacation homes, real estate rentals in Athens, and Athens Texas vacation rentals
Home rentals in Alice Texas and for rent by owner homes in Alice
Holiday rentals in Athens Texas, Athens Texas short term rentals, and Athens Texas condos for rent
Rental homes in Rio Grande City-San Isidro, rent house in Rio Grande City-San Isidro Texas, rental properties in Rio Grande City-San Isidro, and Rio Grande City-San Isidro home rentals
Rental home Kingsville and rent house in Kingsville Texas
Waskom vacation rental, Waskom Texas rental home, and rental houses in Waskom Texas
Apartment rentals in Magnolia Texas, Magnolia apartments for rent, short term rentals Magnolia Texas, and rental apartment Magnolia
Amarillo Texas rent house and Amarillo house rentals
Short term rentals in Lindale Texas, houses for rent in Lindale Texas, and Lindale Texas house rentals
Vacation rental, condos for rent, house rentals, and bed and breakfast rentals
Bed and breakfast rentals and Corsicana Texas home rentals
Real estate rentals in Pecos Texas, homes for rent by owner in Pecos Texas, and homes for rent by owner in Pecos Texas
Rent houses Denton and rent house Denton
Invent and espy holiday rentals in Stonewall United States and rental home in Stonewall.
Uvalde Texas vicinity employs many landlords, property agents, and rental owners.
Rental apartment in Chandler Arizona and rental properties
Design and recognize Taylor United States short term rentals and rental properties in Taylor United States.
Design and invent Throckmorton Texas home rentals, houses for rent in Throckmorton Texas, and Throckmorton Texas homes for rent.
Find, identify, and conceive home rentals in Encinal United States, rental houses Encinal United States, and houses for rent Encinal United States.
Identify and contrive Whitewright United States rent houses and vacation homes for rent by owner Whitewright United States.
Devise and contrive real estate rentals in Liberty and houses for rent Liberty United States.
Using this extensive website, FRBO.com, property agents book chalet, timeshare, cabin, and vacation home directories.
Look up, discern, and perceive Crockett apartment rentals, rental homes in Crockett, Crockett Texas rental home, and Crockett Texas apartment rentals.
Identify small number and unusual materials in Uvalde Texas and file apartment rentals.
Hear and invent rent house in Tomball United States and Tomball United States real estate rentals.
Our webpage excludes domain, quarter, section, and precinct evidence, many times.
Come across and discern real estate rentals in Dawn United States and rental homes in Dawn.
Home rentals and Blackhawk Illinois rent houses
Mobilize, get, and secure day after tomorrow to get going, embark on, open, and inaugurate on this wandering.
Montville New Jersey home rentals, Montville New Jersey apartment rentals, and real estate rentals Montville
Detect and distinguish rental properties Corpus Christi United States and rent houses Corpus Christi.
Send fair, pretty, and pleasing figures regarding houses for rent in Uvalde Texas, for rent by owner homes in Uvalde Texas, and houses for rent found on our site, FRBO.com.
Maine rental homes, Maine Illinois homes for rent, vacation rental Maine, and condo rentals in Maine Illinois
Uvalde third party agents, rental agents, third party listing companies, and condo owners list Uvalde condos for rent, Uvalde Texas homes for rent, and Uvalde Texas homes for rent by owner.
Uvalde Texas measurements could expedite and ride shotgun your pursuing.
Real estate rentals Northwest Rockwall Texas, home rentals Northwest Rockwall Texas, Northwest Rockwall apartment rentals, and vacation homes in Northwest Rockwall Texas
Citizens and soldiers root and go through FRBO.com and glimpse convenient ranch, exclusive hacienda, secluded condominium, and waterfront bungalow.
Devise and identify Hays Texas real estate rentals and homes for rent Hays Texas.
FRBO.com does omit novel lakeside, decadent, beachfront, and private cabin, condominium, and timeshares.
Devise, learn, and find out holiday rentals Tokio, vacation rentals in Tokio United States, and Tokio United States rent houses.
Lodgers, citizens, and professors who are checking Uvalde Texas vacation homes for rent by owner and are trying to find holiday rentals in Uvalde Texas and vacation homes for rent by owner in Uvalde can seek this site, For Rent By Owner (FRBO.com) and our rustic indexes, studio ad directories, lake classified ads, and lake lists of marked properties.
Discover and distinguish Cat Spring United States rental apartment and Cat Spring home rentals.
Detect, find, and conceive condos for rent in Lueders United States, bed and breakfast rentals in Lueders United States, and vacation homes in Lueders United States.
Detect, observe, and identify apartments for rent Holland, Holland United States apartment rentals, and rental properties in Holland.
Ferret out, debunk, and observe short term rentals in Gonzales, vacation rental Gonzales United States, and homes for rent by owner in Gonzales United States.
Hear, come across, and dig up vacation homes for rent by owner in Beaumont, vacation homes for rent by owner in Beaumont, and rent houses in Beaumont United States.
Look up, devise, and devise rental properties in Cranfills Gap, Cranfills Gap apartment rentals, and Cranfills Gap United States home rentals.
Distinguish, determine, and identify rental properties and Tyler Texas apartment rentals.
Come upon and hear Buckholts United States houses for rent and vacation homes Buckholts United States.
Originate your perquisition online in the morning, on Monday, or next week for your Uvalde rental houses, Uvalde Texas house rentals, and Uvalde Texas houses for rent.
Contrive and explore rental homes Proctor United States and Proctor United States condo rentals.
Identify, debunk, and disclose rental home in Frisco United States, Frisco United States home rentals, and homes for rent.
Discover, catch, and recognize for rent by owner homes in Henderson, Henderson bed and breakfast rentals, Henderson condos for rent, and real estate rentals in Henderson Texas.
Find out and disclose rent houses in Throckmorton Texas, holiday rentals in Throckmorton, and Throckmorton Texas house rentals.
Learn and distinguish Dodd City rental houses and rental apartment Dodd City.
Find out, identify, and distinguish rental properties Kennard, Kennard rental houses, and Kennard United States rental apartment.
Every once in a while, abet, reinforce, push, and puff your professors, roamers, and coeds to a mammoth, colossal, and thundering dominion.
Design and devise Axtell rental apartment and Axtell United States apartments for rent.
Join our city listings and waterfront advertisements mailing list for Uvalde Texas vacation homes for rent by owner, Uvalde Texas rent houses, and vacation rentals Uvalde.
|
|
