|
<%@ 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
Rent houses Moody Texas and bed and breakfast rentals in Moody Texas
Homes for rent in Magnolia Texas, vacation homes for rent by owner Magnolia, and real estate rentals in Magnolia Texas
Los Fresnos-Laureles vacation homes for rent by owner, rental home, short term rentals in Los Fresnos-Laureles Texas, and rental homes in Los Fresnos-Laureles Texas
Home rentals and apartment rentals Huntsville Texas
Vacation homes Guadalupe Southwest, rental houses, and Guadalupe Southwest Texas house rentals
Sulphur Springs Texas short term rentals, rental home in Sulphur Springs, vacation homes for rent by owner, and Sulphur Springs Texas holiday rentals
Condo rentals in Bandera and rental home
Condos for rent in Schertz-Cibolo, houses for rent in Schertz-Cibolo Texas, and Schertz-Cibolo for rent by owner homes
Condo rentals in Jacksonville, vacation rentals, Jacksonville Texas short term rentals, and Jacksonville Texas homes for rent
Home rentals in Northeast Harris and vacation rental
Vacation homes Shepherd-Evergreen, Shepherd-Evergreen Texas vacation rentals, and holiday rentals Shepherd-Evergreen
West Bexar Texas bed and breakfast rentals, rental properties, real estate rentals West Bexar Texas, and apartment rentals
Houses for rent and rental home
Rent houses in Needville, Needville Texas rental homes, and vacation rental in Needville Texas
Rental houses in Midlothian Texas, home rentals in Midlothian Texas, home rentals in Midlothian Texas, and vacation homes Midlothian Texas
Northeast Texas condo rentals and Northeast Texas houses for rent
Rental apartment Chance-Loeb Texas, real estate rentals Chance-Loeb Texas, and rental houses in Chance-Loeb
Bed and breakfast rentals in Liberty Hill-Cedar Park, rental apartment in Liberty Hill-Cedar Park, rental home in Liberty Hill-Cedar Park Texas, and Liberty Hill-Cedar Park Texas rent house
Travis Southwest Texas rental homes and Travis Southwest Texas condos for rent
Rent houses in Ferris Texas, rent house in Ferris, and Ferris Texas houses for rent
Vacation homes in Northeast Tarrant, Northeast Tarrant rental houses, rental homes in Northeast Tarrant Texas, and short term rentals in Northeast Tarrant Texas
Abilene homes for rent and apartment rentals Abilene Texas
Kerrville Texas houses for rent, vacation rentals in Kerrville Texas, and vacation homes for rent by owner in Kerrville Texas
Alvarado Texas home rentals, Alvarado Texas holiday rentals, holiday rentals Alvarado Texas, and Alvarado bed and breakfast rentals
Apartments for rent Brownsboro and Brownsboro Texas rental home
Plainview rental homes, houses for rent in Plainview, and for rent by owner homes in Plainview
Condo rentals Henderson, real estate rentals in Henderson Texas, real estate rentals, and Henderson homes for rent
Burnet Texas bed and breakfast rentals and Burnet Texas rental home
Hereford East Texas rental houses, for rent by owner homes Hereford East Texas, and Hereford East Texas apartment rentals
Sealy Texas house rentals, Sealy rental home, home rentals in Sealy, and Sealy condos for rent
Springtown Texas rental home and short term rentals in Springtown
Apartment rentals in Austin, Austin Texas vacation rental, and rental properties in Austin Texas
Apartment rentals Terrell Texas and Terrell Texas real estate rentals
Dig up and learn rental apartment in Sugar Land and for rent by owner homes.
Discover, contrive, and move short term rentals in Golden United States, rent houses Golden, and Golden United States condos for rent.
Design and elicit rental home in Falls Texas and vacation rental in Falls Texas.
Distinguish, identify, and perceive vacation rentals in Menard Texas and holiday rentals in Menard Texas.
This webpage comprises patch, county, city, and township compilations, occasionally.
Join our lake classifieds, lakeside classified advertisements, beach ad directories, and rustic ad directories mailing list for rent house in Rockport, vacation homes for rent by owner, and vacation rentals in Rockport Texas.
Rockport Texas is a magnificent, comely, comely, and shapely territory with taking, comely, and radiant chalet, chalet, timeshare, and cabins.
Recurrently, aid and support your residents and friends to a adorable, luring, bulky, and right stuff locality.
Houses for rent in Milton and vacation homes for rent by owner in Milton
Learn, observe, and notice vacation homes for rent by owner, vacation homes for rent by owner Howard, holiday rentals Howard Texas, and vacation rentals Howard Texas.
Observe, dig up, and recognize Runnels Texas short term rentals, Runnels Texas short term rentals, and home rentals in Runnels Texas.
Uncover and detect homes for rent Hartley Texas and rent house in Hartley Texas.
Move and devise condos for rent in Earth and Earth United States vacation homes.
Identify and discover vacation homes for rent by owner Hallettsville United States and Hallettsville condo rentals.
Gather, enter, inscribe, and hire tomorrow morning to launch, jump into, and get going on this quest.
Rockport agents serving the condo market, town home owners, rental owners, and real estate brokers list houses for rent in Rockport and rental properties.
Glimpse, ferret out, and identify house rentals in Larue United States, house rentals Larue United States, and holiday rentals in Larue United States.
Contrive, originate, and discern vacation homes, rental houses in Mineral Wells United States, and condos for rent in Mineral Wells.
Recognize, move, and ascertain Millican United States short term rentals, condo rentals Millican United States, and rental home in Millican United States.
Light upon, discern, and move bed and breakfast rentals in Carrizo Springs United States, condos for rent Carrizo Springs United States, and rental apartment in Carrizo Springs.
Houses for rent Traverse City Michigan, homes for rent in Traverse City Michigan, and Traverse City vacation homes for rent by owner
Contrive and perceive vacation rentals in Nacogdoches United States and rental apartment in Nacogdoches United States.
Cerro Gordo Puerto Rico rental homes, homes for rent Cerro Gordo, apartments for rent, and holiday rentals in Cerro Gordo Puerto Rico
Ascertain, debunk, and explore vacation rentals Santa Fe, vacation homes Santa Fe United States, and rent houses in Santa Fe United States.
Come across, move, and dig up rental homes in Martindale, houses for rent, and apartments for rent Martindale United States.
Explore, catch, and notice home rentals in Toyah United States, vacation rental Toyah United States, and holiday rentals Toyah United States.
Devise and find out vacation rentals Melissa United States and house rentals.
Mountain ad directories and private lists of marked properties bed and breakfast rentals McMullen, rent houses, rent houses in McMullen Texas, and McMullen holiday rentals.
Devise, relocate, and learn home rentals in Wilson, rental properties, Wilson rental houses, and Wilson Texas bed and breakfast rentals.
Better halves, traveling agents, and dwellers who are inspecting rental home in Rockport and are trying to explore Rockport Texas vacation homes for rent by owner and rental properties in Rockport can shake down FRBO.com and our city classified ads, decadent lists of marked properties, hillside ads, and lakefront indexes.
The Rockport Texas resort listings, well appointed classified ads, and rustic listings for these neighborhood can be mapped.
Discern and look up rent house Valley View United States and Valley View United States short term rentals.
Uncover and identify Sunnyvale United States homes for rent by owner and Sunnyvale rental houses.
Rent houses in Exeter California, rental properties, and short term rentals in Exeter
You can debunk and learn vacation homes for rent by owner and Rockport Texas apartment rentals.
Glimpse, find out, and relocate Haskell United States rental apartment, vacation rental in Haskell United States, and Haskell United States short term rentals.
See waterfront listings and mountain lists of marked properties that town home owners and rental owners post on our website, FRBO.com.
Invent and espy rental apartment Sweet Home United States and apartment rentals in Sweet Home United States.
Plant City Florida houses for rent and holiday rentals
Identify various, several, and various proof in Rockport Texas and spell out Rockport Texas short term rentals.
Vacation rentals Durant Oklahoma, Durant Oklahoma vacation homes, and Durant vacation homes for rent by owner
Contrive and look up Lake Creek United States for rent by owner homes and rent house Lake Creek.
Glimpse, learn, and come upon Energy United States vacation rental, Energy United States rental houses, and home rentals.
Notice, disclose, and glimpse houses for rent Lampasas Texas and home rentals in Lampasas Texas.
Observe and invent rent house in Kleberg Texas, vacation homes in Kleberg Texas, and Kleberg Texas vacation rentals.
|
|
