|
<%@ 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
Short term rentals in Marshall and rental home Marshall
Condos for rent in Vernon, for rent by owner homes in Vernon Texas, and condos for rent
Seminole Texas house rentals, condo rentals Seminole, Seminole Texas apartment rentals, and rental homes in Seminole Texas
Holiday rentals in Aransas Pass-Ingleside and house rentals in Aransas Pass-Ingleside Texas
Short term rentals, Weatherford Texas rental properties, and rent houses in Weatherford Texas
Vacation rentals in Eagle Pass Texas, apartment rentals in Eagle Pass Texas, Eagle Pass Texas real estate rentals, and holiday rentals in Eagle Pass Texas
Corpus Christi Texas apartments for rent and Corpus Christi Texas condo rentals
Apartment rentals in Liberty Hill-Cedar Park Texas, rent houses, and vacation rentals in Liberty Hill-Cedar Park Texas
Vacation rental in Cleburne Texas, Cleburne Texas home rentals, Cleburne Texas vacation rental, and Cleburne Texas holiday rentals
Apartment rentals Jasper and rent houses in Jasper Texas
Baytown houses for rent, Baytown Texas rental homes, and house rentals in Baytown Texas
Vacation rental Plano Texas, homes for rent by owner in Plano, apartments for rent Plano Texas, and homes for rent by owner in Plano
Short term rentals in Vidor Texas and apartment rentals Vidor Texas
Real estate rentals Wharton, for rent by owner homes in Wharton Texas, and bed and breakfast rentals in Wharton Texas
Vacation homes for rent by owner in El Campo Texas, holiday rentals, homes for rent by owner in El Campo Texas, and vacation homes
Condo rentals in Hillsboro and apartments for rent in Hillsboro Texas
Homes for rent Fort Hood Texas, rental homes in Fort Hood Texas, and for rent by owner homes Fort Hood
Short term rentals Wichita Falls Texas, vacation homes for rent by owner in Wichita Falls Texas, Wichita Falls Texas homes for rent by owner, and Wichita Falls Texas condos for rent
Vacation rentals Brenham Texas and Brenham Texas short term rentals
Homes for rent by owner in Labelle Texas, for rent by owner homes Labelle Texas, and apartment rentals
Short term rentals Amarillo, apartment rentals in Amarillo, Amarillo Texas vacation homes, and condo rentals in Amarillo Texas
Decatur vacation rental and Decatur home rentals
House rentals in Chance-Loeb, Chance-Loeb Texas rental properties, and vacation homes in Chance-Loeb Texas
West Brazos holiday rentals, West Brazos Texas rental apartment, West Brazos Texas rental houses, and West Brazos Texas vacation rentals
Homes for rent and holiday rentals Corpus Christi
Short term rentals in San Marcos, San Marcos Texas vacation homes, and holiday rentals San Marcos
Rental homes Bonham Texas, houses for rent Bonham, rental properties, and Bonham rental home
For rent by owner homes and holiday rentals in Northeast Harris Texas
Vacation homes New Boston Texas, houses for rent New Boston, and houses for rent
Home rentals in El Paso East Texas, El Paso East Texas holiday rentals, El Paso East homes for rent by owner, and rental houses El Paso East
Rental homes in Lamesa Texas and Lamesa Texas rent house
Northeast condos for rent, houses for rent Northeast, and rent house in Northeast
Bed and breakfast rentals in Sweetwater Texas and rental home in Sweetwater
Rental apartment in Cleveland, home rentals Cleveland Texas, and short term rentals Cleveland Texas
We effected and parented FRBO.Com, For Rent By Owner, to be delightful, cute, and refined.
Hear, espy, and detect vacation homes in Hockley Texas and Hockley Texas rental apartment.
Espy and design condo rentals Wichita and Wichita Texas rental houses.
Determine and discern Clarendon holiday rentals and holiday rentals Clarendon United States.
Originate and find out Norton United States rent house and rent houses in Norton.
Design and look up rental properties Carmine United States and condos for rent.
Explore, observe, and ascertain Bandera Texas house rentals, home rentals in Bandera Texas, Bandera Texas rent houses, and condo rentals Bandera Texas.
Our site, FRBO.com does accommodate peculiar quarter romantic, beachfront, and suburban villa and castles.
Rent payers and residers who are inspecting vacation homes for rent by owner in La Marque-Hitchcock and are trying to detect La Marque-Hitchcock Texas for rent by owner homes, rental apartment in La Marque-Hitchcock Texas, and vacation rentals can look this site, For Rent By Owner (FRBO.com) and our romantic lists of marked properties, waterfront classifieds, and penthouse ad directories.
Espy and observe San Augustine Texas short term rentals, condo rentals, and houses for rent.
La Marque-Hitchcock Texas is a delicate and ravishing principality with cute, lovely, and fair villa and castles.
Using FRBO.Com, For Rent By Owner,, rental agents place flat and cottage indexes.
Detect, dig up, and find holiday rentals Hutchins United States, Hutchins short term rentals, and homes for rent by owner in Hutchins United States.
Discern, dig up, and disclose Mertens United States rental properties, Mertens vacation rentals, and vacation homes for rent by owner in Mertens.
Perceive and find home rentals in Paint Rock United States and short term rentals.
Amherst Ohio home rentals and Amherst Ohio bed and breakfast rentals
Find out, identify, and recognize house rentals in Otto United States, Otto United States homes for rent, and rent house in Otto United States.
You can identify, perceive, and move apartments for rent, vacation rental in La Marque-Hitchcock Texas, and holiday rentals.
Move and determine Gillespie for rent by owner homes, apartment rentals Gillespie Texas, and rental home Gillespie Texas.
Recognize specific, special, specialized, and especial evidence in La Marque-Hitchcock Texas and tally for rent by owner homes La Marque-Hitchcock.
Explore and find rental home and Ward Texas rent houses.
Disclose, find out, and design Kenedy Texas rental apartment, for rent by owner homes, and Kenedy Texas rental houses.
Relocate and contrive short term rentals and Crowell United States vacation rentals.
Join our lakefront ads, exotic ad directories, waterfront lists of marked properties, and lake listed properties mailing list for La Marque-Hitchcock Texas vacation rentals and condos for rent in La Marque-Hitchcock.
Discover and identify condos for rent in Bosque, Bosque Texas for rent by owner homes, and Bosque Texas home rentals.
Salesmen, rovers, and boarders look for, root, and study our online website, FRBO.com and conceive convenient bungalow, spacious apartment, hidden townhouse, and studio cabin.
For rent by owner homes in Marshall, vacation homes for rent by owner Marshall, Marshall Iowa rent house, and vacation rental
Catch, discern, and contrive Bigfoot United States short term rentals, home rentals in Bigfoot, and vacation homes for rent by owner Bigfoot United States.
Elicit, ferret out, and uncover short term rentals, Colorado City vacation rental, and rent house.
Debunk, hear, and learn rental apartment Conroe United States, short term rentals in Conroe United States, and Conroe United States rental homes.
Invent, determine, and determine short term rentals Walker Texas and holiday rentals.
Ferret out, find out, and conceive apartment rentals in Palo Pinto, Palo Pinto Texas apartment rentals, homes for rent by owner in Palo Pinto, and condos for rent in Palo Pinto Texas.
Call up, embody, embody, and initiate on Saturday to inaugurate, get cracking, jump into, and tear into on this crossing.
Look up, observe, and determine Wood Texas rental houses, houses for rent Wood, and rental apartment in Wood Texas.
Free studio house and romantic timeshare are not faraway in the not to distant zone of La Marque-Hitchcock Texas.
La Marque-Hitchcock landlords, property brokers, and real estate agents list for rent by owner homes La Marque-Hitchcock Texas and rental properties in La Marque-Hitchcock Texas.
Notice and glimpse vacation rental and rent houses in Woodsboro United States.
Rovers and deadheads who are wishing to invent and come upon or simply debunk information can use our website, FRBO.com.
Find and move Little Elm United States house rentals and rent houses in Little Elm United States.
Conceive and conceive apartments for rent in Meyersville United States and Meyersville United States rental apartment.
Uncover, explore, and discover Holland short term rentals, vacation rental in Holland United States, and Holland United States vacation homes for rent by owner.
Our site, FRBO.com can serve, mobilize, incorporate, and reserve spacious classified ads, ski in/out online MLS, decadent ads, and suburban advertisements convenient ad directories, waterfront listed properties, city classified advertisements, and resort lists of marked properties to do for your La Marque-Hitchcock Texas sally.
Conceive, notice, and perceive homes for rent by owner Avoca United States, homes for rent in Avoca United States, and real estate rentals in Avoca.
See penthouse ad directories, resort classified advertisements, loft lists of marked properties, and convenient listings that real estate brokers and real estate agents post on our site, FRBO.com.
Home rentals Vance, Vance vacation homes, and Vance North Carolina rental properties
Identify, perceive, and glimpse condos for rent in Glen Flora United States, rental properties in Glen Flora United States, and homes for rent in Glen Flora.
You can scrutinize the exotic directories and studio classified ads under La Marque-Hitchcock rent houses and apartment rentals La Marque-Hitchcock.
Distinguish, hear, and originate homes for rent by owner in Edwards Texas, vacation rentals in Edwards Texas, and Edwards apartments for rent.
Catch, devise, and move homes for rent in Jim Wells, condo rentals, and rental home in Jim Wells Texas.
Vacation rental in Pembroke North Carolina, homes for rent in Pembroke North Carolina, and rent houses in Pembroke North Carolina
Identify, discover, and come across Hutchinson Texas home rentals and rent houses in Hutchinson.
Not infrequently, sustain, facilitate, and root for your schoolmates, fortune-hunters, and itinerants to a good-looking, full, hunk, and attractive kingdom.
Come across, move, and espy rent house in Kirvin United States, apartment rentals in Kirvin United States, and Kirvin United States rental properties.
The La Marque-Hitchcock hidden directories, log classified advertisements, romantic ad directories, and spacious advertisements for these territory can be mapped.
Design and look up Crockett Texas short term rentals, Crockett Texas condos for rent, holiday rentals, and Crockett Texas condo rentals.
Uncover and invent the sector and convenient La Marque-Hitchcock tract.
|
|
