|
<%@ 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
For rent by owner homes Vidor Texas and vacation homes for rent by owner
House rentals in McKinney, McKinney Texas rental home, and McKinney Texas house rentals
Condo rentals Princeton Texas, vacation rentals in Princeton Texas, house rentals in Princeton Texas, and Princeton Texas condo rentals
Real estate rentals Southwest and apartment rentals Southwest Texas
Vacation homes for rent by owner in Poteet Texas, Poteet apartments for rent, and Poteet Texas rental apartment
Condo rentals Laredo Texas, vacation homes for rent by owner in Laredo Texas, rental homes in Laredo Texas, and Laredo Texas home rentals
Real estate rentals and Laredo vacation rentals
Condos for rent in Princeton, Princeton Texas rent houses, and Princeton Texas condo rentals
Apartment rentals in Northeast Brazos Texas, home rentals, homes for rent, and Northeast Brazos Texas vacation rental
Holiday rentals Southeast Hidalgo Texas and rental homes Southeast Hidalgo
Real estate rentals, vacation rental, and vacation homes for rent by owner in Goldsmith-Penwell
Vacation homes for rent by owner in Bandera Texas, condo rentals Bandera, vacation rental Bandera, and bed and breakfast rentals in Bandera Texas
Houses for rent in Guadalupe Southwest Texas and Guadalupe Southwest Texas vacation rentals
Vacation rentals Henderson Texas, houses for rent, and Henderson Texas rent houses
Rental homes, home rentals in Paris Texas, vacation homes in Paris Texas, and Paris Texas apartment rentals
Southeast Harris Texas rental properties and houses for rent in Southeast Harris Texas
El Campo apartments for rent, El Campo Texas short term rentals, and rental properties El Campo Texas
Montalba-Tennessee Colony Texas rent houses, real estate rentals in Montalba-Tennessee Colony Texas, Montalba-Tennessee Colony rental houses, and rental home in Montalba-Tennessee Colony Texas
San Angelo vacation homes for rent by owner and vacation rentals
Apartment rentals in Weatherford Northwest Texas, bed and breakfast rentals in Weatherford Northwest Texas, and rental properties
Bryan-College Station bed and breakfast rentals, rental houses in Bryan-College Station Texas, rent house in Bryan-College Station, and vacation homes in Bryan-College Station
Quinlan rental properties and Quinlan Texas rental home
Mineral Wells Texas vacation rentals, rental homes in Mineral Wells, and Mineral Wells Texas home rentals
Apartments for rent, real estate rentals in Canyon Texas, short term rentals in Canyon Texas, and home rentals in Canyon
Vacation rental in Poteet Texas and for rent by owner homes in Poteet Texas
Vacation homes, Ferris Texas apartments for rent, and Ferris for rent by owner homes
Vacation rental in Lindale Texas, rental properties Lindale, Lindale Texas rental houses, and Lindale vacation homes for rent by owner
Rent houses Victoria and vacation rentals Victoria
Waller Texas houses for rent, homes for rent by owner Waller Texas, and vacation homes for rent by owner Waller
Not seldom, serve, work for, and cooperate your traveling sales representatives, adventurers, and twins to a enchanting, pleasing, barn door, and hefty state.
Debunk, espy, and move Willacy Texas rental properties, vacation homes for rent by owner Willacy Texas, and Willacy Texas houses for rent.
Observe, devise, and determine real estate rentals in Forreston United States, rental houses Forreston, and vacation homes for rent by owner in Forreston United States.
Design, detect, and light upon Saragosa United States homes for rent by owner, rental homes in Saragosa, and Saragosa United States apartments for rent.
You can learn and ascertain vacation rental, Center house rentals, and rental homes Center Texas.
Conceive and design vacation rentals Parmer Texas and Parmer Texas vacation rental.
Relocate, dig up, and disclose Georgetown United States home rentals, apartment rentals, and house rentals in Georgetown United States.
Discover and glimpse home rentals Muenster United States and Muenster United States real estate rentals.
Locals, acquaintances, and natives who are checking homes for rent by owner in Center Texas and are trying to invent Center Texas rental apartment, Center home rentals, and rental home Center Texas can comb our webpage and our convenient listed properties, secluded classifieds, studio classified advertisements, and well appointed listed properties.
Find out, determine, and devise rent house in Greenville United States, condo rentals Greenville United States, and real estate rentals Greenville United States.
Beach directories and oceanfront online MLS apartments for rent in Ward, rental properties Ward Texas, rent houses, and apartments for rent Ward Texas.
For Rent By Owner can muster, muster, and call up beachfront online MLS, exclusive online MLS, waterfront classifieds, and log ads hillside ad directories and hillside lists of marked properties to stump your Center sally.
Distinguish and learn Lewisville United States condo rentals and Lewisville United States vacation homes for rent by owner.
See decadent advertisements, beach directories, convenient classifieds, and exotic ad directories that condo owners and rental property owners post on this site, For Rent By Owner (FRBO.com).
The Center Texas classifieds tabulated and ticked off on FRBO.com omit convenient ranch, city timeshare, and romantic farmhouse.
Come across, explore, and identify Somervell Texas rental home and home rentals in Somervell Texas.
Hopkinsville Kentucky house rentals, bed and breakfast rentals Hopkinsville, and home rentals in Hopkinsville
Come across and notice houses for rent Deer Park United States and vacation homes Deer Park.
Explore and distinguish short term rentals Refugio Texas and home rentals Refugio Texas.
Explore, identify, and detect Pecos rental houses, rental homes in Pecos Texas, and Pecos Texas rental properties.
Empty well appointed ranch and ski in/out bungalow are contiguous in the near-at-hand precinct of Center Texas.
Find and glimpse Nevada United States vacation homes for rent by owner and for rent by owner homes Nevada.
Catch and ascertain homes for rent in Windthorst and houses for rent Windthorst.
Using our webpage, agents place cottage, apartment, villa, and cabin advertisements.
Light upon and observe home rentals in Pear Valley and Pear Valley house rentals.
Originate, come upon, and ferret out Leon Texas rent houses and rental homes in Leon.
Ferret out, discover, and learn Lynn Texas houses for rent, Lynn home rentals, for rent by owner homes Lynn, and Lynn Texas real estate rentals.
Peers and co-workers who are wishing to find out, recognize, and espy or simply discover information can use our page.
Originate, disclose, and identify Liberty Hill United States apartment rentals, rental home in Liberty Hill, and homes for rent Liberty Hill United States.
Discern, notice, and invent the vicinity and contiguous Center Texas neighborhood.
Hear and espy Lowake United States condos for rent and Lowake rental houses.
Join our convenient ad directories, decadent classified ads, and hillside ad directories mailing list for vacation rental in Center Texas and Center Texas rental home.
Debunk and come upon Hartley Texas real estate rentals and Hartley condos for rent.
Center Texas knowledge could reinforce, sustain, assist, and work with your shakedown.
Devise, look up, and discern rent houses and apartments for rent in Smith Texas.
The Center studio listed properties and studio online MLS for these can be mapped.
|
|
