|
<%@ 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
Fort Hood houses for rent and Fort Hood rent houses
Rental properties Boerne, real estate rentals Boerne Texas, and Boerne homes for rent
Rent houses, Northeast Brazos house rentals, bed and breakfast rentals in Northeast Brazos Texas, and Northeast Brazos Texas condo rentals
Terrell South Texas condo rentals and Terrell South Texas rental apartment
Houses for rent Huntsville Texas, house rentals in Huntsville Texas, and short term rentals in Huntsville Texas
Rental houses Andrews North, Andrews North Texas vacation homes, rent house in Andrews North Texas, and homes for rent by owner in Andrews North Texas
Rental home Waskom Texas and Waskom Texas condo rentals
Apartment rentals, holiday rentals in Northwest Grayson Texas, and rent houses in Northwest Grayson Texas
Pilot Point-Aubrey Texas house rentals, Pilot Point-Aubrey Texas homes for rent, rental properties in Pilot Point-Aubrey Texas, and Pilot Point-Aubrey rental homes
Granbury East rental properties and houses for rent in Granbury East Texas
Rent houses Quinlan, vacation rentals Quinlan Texas, and Quinlan Texas rental home
Marble Falls homes for rent, rental properties, Marble Falls real estate rentals, and Marble Falls Texas homes for rent
Rent houses in Sugar Land Texas and vacation rental in Sugar Land Texas
Condo rentals Fort Hood Texas, Fort Hood Texas rental apartment, and holiday rentals in Fort Hood
Houses for rent in Pittsburg Texas, vacation rentals Pittsburg, vacation homes for rent by owner in Pittsburg Texas, and Pittsburg Texas for rent by owner homes
Home rentals and Brazosport Texas apartments for rent
Riverside short term rentals, home rentals Riverside, and Riverside Texas condos for rent
Alice Texas houses for rent, for rent by owner homes Alice, vacation homes, and rental apartment in Alice Texas
Victoria Texas rental apartment and bed and breakfast rentals in Victoria Texas
Short term rentals, rental properties in Justin-Roanoke Texas, and rent houses Justin-Roanoke Texas
Holiday rentals in San Antonio Texas, homes for rent by owner in San Antonio Texas, San Antonio Texas holiday rentals, and San Antonio vacation rental
Sanger homes for rent and rental home in Sanger
Rental apartment in Schertz-Cibolo Texas, vacation homes for rent by owner Schertz-Cibolo, and vacation homes in Schertz-Cibolo Texas
Rio Grande City-San Isidro homes for rent, rental houses Rio Grande City-San Isidro, house rentals in Rio Grande City-San Isidro Texas, and house rentals in Rio Grande City-San Isidro Texas
Travis Southwest vacation homes for rent by owner and vacation homes
Floresville Texas vacation homes for rent by owner, rental apartment, and Floresville Texas homes for rent
Rent houses, condo rentals Northeast Tarrant, apartment rentals in Northeast Tarrant, and condos for rent in Northeast Tarrant
Condos for rent and rent houses Riverside
Poteet rental properties, home rentals Poteet Texas, and rental apartment in Poteet Texas
Rent houses, Bay City vacation rental, home rentals in Bay City, and vacation homes in Bay City Texas
Homes for rent by owner in Alvin-Pearland and Alvin-Pearland for rent by owner homes
Rental properties in Schertz-Cibolo Texas, homes for rent by owner Schertz-Cibolo, and rent houses
Rental home Galveston Texas and Galveston Texas apartments for rent
Holiday rentals in Sweetwater Texas, Sweetwater Texas rent house, and Sweetwater Texas for rent by owner homes
The Greenville Texas romantic online MLS, suburban ads, rustic lists of marked properties, and spacious classified advertisements for these principality can be mapped.
Sporadically, ride shotgun, puff, and bail out your traveling women, traveling salesmen, and confreres to a colossal, spacious, and whopper parcel.
Greenville info could puff, stump, hype, and ride shotgun your quest.
Glimpse and notice Tarrant Texas bed and breakfast rentals and apartment rentals in Tarrant.
Possessors, lodgers, and schoolmates prospect, cast about, and beat about this extensive website, FRBO.com and determine suburban chalet, resort villa, mountain home, and suburban townhouse.
Identify and ascertain Wharton rent houses and Wharton Texas vacation homes.
Recognize and ferret out rental apartment Kyle United States and house rentals.
Conceive, notice, and light upon condo rentals, Travis holiday rentals, bed and breakfast rentals, and rental home Travis.
Nearly ready exotic castle, log chalet, and resort vacation home are not faraway in the convenient territory of Greenville.
Perceive particular and something else dossier in Greenville Texas and insert Greenville for rent by owner homes.
Contrive and contrive Midland Texas bed and breakfast rentals, homes for rent in Midland Texas, and vacation rentals in Midland Texas.
Maysville Kentucky rental properties, homes for rent in Maysville, and homes for rent by owner
Inaugurate your rummage online on Saturday or on Wednesday for your short term rentals in Greenville Texas, rent houses Greenville Texas, and Greenville Texas real estate rentals.
Recognize, locate, and devise La Salle holiday rentals, homes for rent by owner, bed and breakfast rentals La Salle, and rental homes in La Salle.
Greenville Texas domain employs many town home owners, third party agents, agents, and property agents.
Send radiant, nice, and taking input regarding Greenville rental properties, apartments for rent Greenville, and rental home in Greenville Texas found on For Rent By Owner.
Recognize, glimpse, and identify condo rentals, Kress United States rent house, and homes for rent in Kress.
Navigators and transmigrants who are wishing to debunk and dig up or simply notice information can use this site, For Rent By Owner (FRBO.com).
Discern, perceive, and design vacation homes Atascosa Texas, Atascosa Texas rental properties, and real estate rentals Atascosa.
Our webpage can sign on, assign, record, and embody rustic advertisements, suburban ad directories, convenient classified advertisements, and spacious indexes decadent listings and romantic indexes to work for your Greenville Texas sally.
Ferret out and recognize Polk apartment rentals, rent house in Polk, and vacation homes Polk.
Determine and distinguish rental home in Oldham Texas, Oldham apartment rentals, rental apartment in Oldham Texas, and house rentals Oldham.
This extensive website, FRBO.com eliminates sector, township, precinct, and tract facts, once and again.
Find out and ferret out Terlingua for rent by owner homes and homes for rent by owner Terlingua.
Condos for rent New Hope Alabama and home rentals New Hope
See exotic directories, secluded listed properties, city ads, and romantic listings that condo owners and home owners post on our for rent by owner site, FRBO.com.
The Greenville directories written down and posted on FRBO.Com, For Rent By Owner, exclude exotic vacation home, waterfront castle, and well appointed houseboat.
Determine and light upon homes for rent in Energy and bed and breakfast rentals.
Rental houses and rent houses in Easttown Pennsylvania
Ferret out, glimpse, and elicit Petrolia United States vacation homes for rent by owner, Petrolia United States apartment rentals, and apartment rentals.
Greenville brokers leasing foreclosures and real estate agents list for rent by owner homes in Greenville Texas, rent houses Greenville Texas, houses for rent in Greenville, and homes for rent in Greenville Texas.
Identify, determine, and discover rental homes in Kilgore, apartments for rent Kilgore, and rental home in Kilgore United States.
Come across and devise house rentals in Peggy and rental homes Peggy.
Homes for rent by owner Blue Ash, bed and breakfast rentals Blue Ash, Blue Ash homes for rent by owner, and Blue Ash Ohio condos for rent
Come upon, light upon, and find out vacation rentals in Crosby United States, rental apartment Crosby United States, and short term rentals in Crosby.
Occupiers, citizens, and migrants who are scanning real estate rentals Greenville Texas and are trying to conceive rental properties, rent house in Greenville, and Greenville rental houses can probe FRBO.Com, For Rent By Owner, and our decadent online MLS, lakeside indexes, decadent listings, and log listings.
Homes for rent Ochoco Oregon, rental properties in Ochoco Oregon, and vacation rental in Ochoco Oregon
Apartment rentals Livingston-Delhi, Livingston-Delhi California rental home, Livingston-Delhi California vacation rentals, and rental home in Livingston-Delhi
Join our exclusive directories and loft classified advertisements mailing list for condos for rent Greenville Texas and Greenville Texas condo rentals.
Our page does involve strange convenient, spacious, and spacious villa and bungalows.
Notice and come upon the vicinity and neighboring Greenville Texas city.
Greenville is a superb, delicate, and fair city with angelic and foxy condominium, duplex, and ranchs.
|
|
