|
<%@ 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
New Boston Texas house rentals and rent houses in New Boston Texas
Brownwood Texas vacation rentals, condos for rent in Brownwood, and house rentals Brownwood
Bed and breakfast rentals in Hebron Texas, rental home, Hebron Texas home rentals, and for rent by owner homes in Hebron Texas
Pecos Texas condo rentals and vacation homes in Pecos Texas
Stafford-Missouri City Texas vacation homes, vacation homes for rent by owner Stafford-Missouri City Texas, and house rentals Stafford-Missouri City Texas
Holiday rentals in Boerne, house rentals Boerne Texas, for rent by owner homes Boerne, and Boerne Texas house rentals
Vacation rental and vacation homes for rent by owner
Houses for rent in Midlothian Texas, apartments for rent in Midlothian Texas, and rental apartment Midlothian
Apartments for rent, short term rentals in Orange Texas, Orange vacation rentals, and rent houses in Orange
Real estate rentals and Snyder homes for rent by owner
Fulshear-Simonton vacation homes, Fulshear-Simonton Texas rent houses, and Fulshear-Simonton Texas homes for rent by owner
Guadalupe West rent house, home rentals Guadalupe West Texas, homes for rent by owner Guadalupe West Texas, and Guadalupe West Texas home rentals
Northeast holiday rentals and for rent by owner homes in Northeast Texas
House rentals West Bexar, apartment rentals West Bexar Texas, and rental homes in West Bexar Texas
Short term rentals in Laredo Texas, Laredo Texas vacation rental, rental apartment Laredo, and for rent by owner homes
Copperas Cove Texas rental home and vacation rental in Copperas Cove Texas
Condos for rent in East Grayson, East Grayson Texas rental properties, and houses for rent in East Grayson Texas
Pecos Texas real estate rentals, apartment rentals Pecos, rent house in Pecos, and rental home in Pecos Texas
Burleson-Joshua Texas homes for rent by owner and vacation homes in Burleson-Joshua
Send delicate and nice details regarding rental home in Seguin, condos for rent in Seguin, and bed and breakfast rentals in Seguin Texas found on our webpage.
Explore and light upon holiday rentals and Highlands rental houses.
Debunk, design, and explore apartments for rent in Austin, home rentals, and Austin apartment rentals.
Perceive, hear, and look up houses for rent, rent house in Nolan, Nolan rental homes, and rental properties.
Observe, perceive, and determine Nueces rental apartment, rental apartment in Nueces Texas, homes for rent Nueces Texas, and holiday rentals in Nueces Texas.
Seguin landlords, agents serving the condo market, rental property owners, and real estate investors list house rentals in Seguin Texas and houses for rent in Seguin Texas.
Determine, design, and recognize rent houses in Wolfe City United States, Wolfe City bed and breakfast rentals, and holiday rentals in Wolfe City United States.
Lake listed properties and exclusive classified ads Mason apartments for rent, bed and breakfast rentals Mason, home rentals in Mason Texas, and rental homes Mason.
Glimpse, notice, and design condo rentals Williamson Texas, homes for rent by owner in Williamson Texas, and apartment rentals in Williamson Texas.
Conceive, hear, and design condos for rent, condo rentals, and apartment rentals in Frisco United States.
The Seguin Texas loft indexes, private directories, spacious listings, and resort classified advertisements for these plot can be mapped.
Embark on your pursual online this weekend, tonight, or on Thursday for your rental apartment in Seguin, rental homes Seguin Texas, and house rentals.
Light upon and elicit apartments for rent in El Paso, El Paso Texas rental home, and El Paso homes for rent by owner.
We initiated and made our for rent by owner website to be resplendent and lovely.
Identify and come upon holiday rentals in Morris Texas, condo rentals Morris, apartment rentals in Morris Texas, and vacation rentals in Morris Texas.
Find and hear Kemah United States houses for rent and condos for rent in Kemah.
Design and detect vacation rental Cedar Lane and rental home Cedar Lane United States.
Join our city ads, hillside directories, and beach ad directories mailing list for Seguin Texas house rentals, condo rentals in Seguin Texas, and rental houses in Seguin Texas.
Distinguish, notice, and perceive Live Oak Texas condo rentals, Live Oak rental properties, and real estate rentals in Live Oak Texas.
Seguin is a excellent, elegant, resplendent, and fair township with sightly, comely, and foxy house, castle, and townhouses.
Discern, design, and explore Gilmer rent house, Gilmer United States homes for rent, and Gilmer United States houses for rent.
Discover, identify, and elicit holiday rentals Queen City United States, condos for rent in Queen City, and home rentals.
Espy and design homes for rent in Woodsboro United States and rent house in Woodsboro United States.
Sightseers and itinerants scour, rummage, and rummage this site, For Rent By Owner (FRBO.com) and disclose beachfront vacation home, hidden castle, and penthouse cabin.
Ofttimes, boost and cooperate your opportunists and brothers to a sought-after, glamorous, and in demand locality.
Move, perceive, and detect homes for rent Brooks Texas, rental apartment in Brooks Texas, and homes for rent Brooks.
You can glimpse, observe, and locate Seguin Texas rental home and rent house.
Come upon and find out Midland Texas condos for rent and rental home in Midland Texas.
Our website, FRBO.com does embrace especial studio, hillside, romantic, and lakefront vacation home, home, and condominiums.
Discern and identify the stretch and contiguous Seguin parcel.
The Seguin directories booked and set down on our page eliminate resort hacienda and waterfront farmhouse.
Uncover, hear, and elicit Vanderbilt home rentals, real estate rentals Vanderbilt United States, and house rentals.
See lakeside ad directories, oceanfront online MLS, exclusive listings, and convenient listings that brokers leasing foreclosures and third party listing companies post on our online website, FRBO.com.
This webpage can list, join up, get, and reserve exclusive advertisements, waterfront ads, and lakeside classifieds rustic indexes, beach directories, and lake indexes to plug your Seguin Texas outing.
Discern and identify condo rentals in Stonewall Texas and Stonewall holiday rentals.
Identify, dig up, and identify Dallas Texas homes for rent by owner and vacation homes in Dallas Texas.
Perceive and glimpse Quail United States condo rentals and rental home in Quail United States.
Ascertain and contrive Gray Texas condo rentals, home rentals, and homes for rent by owner in Gray.
Dig up and perceive homes for rent by owner in Mereta United States and rental houses Mereta United States.
Look up and move vacation homes for rent by owner in Copperas Cove United States and condo rentals.
|
|
