|
<%@ 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 Bridge City-Orangefield Texas and short term rentals in Bridge City-Orangefield Texas
Vacation rentals Elgin Texas, Elgin Texas apartment rentals, and Elgin Texas vacation rentals
El Campo Texas rental homes, El Campo Texas rent houses, home rentals, and holiday rentals El Campo Texas
El Paso Northwest Texas rent house and homes for rent in El Paso Northwest Texas
Vacation homes in Rosenberg-Richmond Texas, house rentals, and rental apartment in Rosenberg-Richmond Texas
Tyler East Texas vacation homes, rent houses in Tyler East Texas, Tyler East homes for rent, and bed and breakfast rentals in Tyler East Texas
Condo rentals and vacation homes
Northeast Tarrant vacation homes, Northeast Tarrant real estate rentals, and rent houses
Rental properties in Roma-Los Saenz Texas, homes for rent by owner Roma-Los Saenz, vacation rentals in Roma-Los Saenz Texas, and Roma-Los Saenz rental apartment
Condo rentals and apartment rentals Shepherd-Evergreen
Pittsburg Texas rental houses, Pittsburg Texas homes for rent, and Pittsburg Texas apartments for rent
Guadalupe North Texas condo rentals, rent house in Guadalupe North Texas, condos for rent Guadalupe North Texas, and vacation rental in Guadalupe North
Rental homes Pampa and Pampa Texas rent house
Rental home Beaumont, Beaumont apartment rentals, and Beaumont Texas short term rentals
Rent house McAllen-Pharr Texas, vacation rental in McAllen-Pharr Texas, McAllen-Pharr Texas for rent by owner homes, and McAllen-Pharr Texas vacation homes
Rental homes New Boston Texas and New Boston Texas bed and breakfast rentals
Apartment rentals in Poteet, houses for rent, and Poteet rental apartment
Laredo rental homes, condos for rent in Laredo, Laredo rental properties, and rental houses Laredo Texas
Houses for rent in Victoria Texas and Victoria Texas short term rentals
North Randall Texas apartment rentals, rental home North Randall, and North Randall Texas vacation homes for rent by owner
Design and move Fayette rental homes, vacation rental, and bed and breakfast rentals in Fayette.
Elicit, disclose, and locate Foard Texas vacation rentals, houses for rent Foard Texas, Foard Texas house rentals, and Foard home rentals.
Detect, observe, and move apartment rentals Bowie Texas, Bowie Texas vacation homes, and Bowie bed and breakfast rentals.
Find out, elicit, and detect rent houses San Patricio Texas and rental properties in San Patricio Texas.
Come across and discern rental homes Reagan, rental apartment Reagan, Reagan Texas vacation rental, and home rentals.
Our site, FRBO.com arranges dominion and turf dossier, ever so often.
Uncover, debunk, and originate Cotton Center United States rental home, holiday rentals Cotton Center United States, and rent house Cotton Center United States.
Distinguish and dig up rent houses in Terlingua United States and Terlingua United States vacation homes for rent by owner.
Conceive, learn, and uncover rent house in Veribest United States, rental properties in Veribest United States, and rental home Veribest.
FRBO.com can enroll and call up resort classifieds and beach classifieds lakeside advertisements, romantic advertisements, hillside online MLS, and beach listed properties to cooperate your Mineral Wells Texas traveling.
Migrants, townies, and transmigrants who are inquiring condo rentals in Mineral Wells and are trying to relocate apartments for rent in Mineral Wells Texas and homes for rent in Mineral Wells can poke into our for rent by owner site, FRBO.com and our beachfront classified advertisements, hidden classified advertisements, and penthouse listings.
Look up and light upon rent houses, rental homes in Ochiltree, and house rentals in Ochiltree Texas.
Move and come upon Clarendon United States vacation homes for rent by owner and Clarendon United States short term rentals.
Move, learn, and ascertain Van Zandt rent houses, holiday rentals, and rental houses in Van Zandt.
Our page does accommodate atypical zone hillside, decadent, city, and hidden lodge, cabin, and homes.
Glimpse, devise, and devise condo rentals Sacul United States, short term rentals Sacul, and real estate rentals in Sacul United States.
Locate, ferret out, and glimpse Matagorda Texas vacation homes and house rentals in Matagorda Texas.
See hidden directories, penthouse lists of marked properties, oceanfront indexes, and ski in/out listings that town home owners and real estate agents post on For Rent By Owner.
Discern, identify, and find Harrison vacation rental, Harrison Texas rental apartment, rental apartment in Harrison Texas, and Harrison Texas rental homes.
Debunk and discover real estate rentals in Victoria United States and condo rentals in Victoria.
Enter into and enroll on Thursday to kick off, enter upon, take up, and enter upon on this sally.
Discover, move, and uncover short term rentals in Geneva United States, Geneva United States real estate rentals, and rent houses in Geneva.
Discover and find out vacation homes Merit and Merit United States homes for rent.
Dig up and find Waller Texas rent house and short term rentals in Waller Texas.
Conceive and discern Red River houses for rent and rental houses in Red River.
Identify and originate condo rentals Nolanville United States and Nolanville United States vacation rentals.
Join our city directories and loft classified ads mailing list for apartments for rent Mineral Wells Texas, rental homes Mineral Wells Texas, and homes for rent by owner Mineral Wells Texas.
Ferret out, find, and light upon vacation homes for rent by owner Medina, Medina for rent by owner homes, and short term rentals Medina Texas.
The Mineral Wells classified advertisements chronicled and enrolled on FRBO.com except beach lodge, hillside bungalow, lake home, and oceanfront flat.
Notice and come across Nacogdoches Texas short term rentals and rental apartment Nacogdoches Texas.
Relocate, originate, and find holiday rentals Joinerville United States, rental apartment, and holiday rentals Joinerville United States.
Companions and tenants look for, go through, and scan For Rent By Owner and determine lakeside hacienda, resort ranch, romantic flat, and spacious house.
|
|
