|
<%@ 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
Jacksonville Texas rent house and Jacksonville houses for rent
Apartments for rent in Northeast Tarrant Texas, home rentals Northeast Tarrant Texas, and vacation homes for rent by owner Northeast Tarrant Texas
Bridge City-Orangefield Texas apartment rentals, Bridge City-Orangefield home rentals, homes for rent by owner in Bridge City-Orangefield Texas, and Bridge City-Orangefield Texas condo rentals
Taylor rental homes and home rentals Taylor Texas
Apartment rentals in Weatherford, apartment rentals in Weatherford Texas, and Weatherford Texas real estate rentals
Lufkin Texas houses for rent, Lufkin rental homes, Lufkin bed and breakfast rentals, and Lufkin Texas bed and breakfast rentals
Rental home in Bryan-College Station Texas and rental apartment Bryan-College Station
Mont Belvieu Texas homes for rent by owner, homes for rent in Mont Belvieu Texas, and rent houses Mont Belvieu
Rental houses, apartments for rent in Dripping Springs-Wimberley Texas, rental houses in Dripping Springs-Wimberley, and rental houses Dripping Springs-Wimberley Texas
Pecos Texas rent house and Pecos Texas condos for rent
Rental houses in Boerne Texas, homes for rent by owner, and Boerne Texas holiday rentals
House rentals in Forney, apartment rentals Forney Texas, houses for rent Forney, and bed and breakfast rentals Forney Texas
Center Texas vacation homes and Center Texas vacation rentals
Homes for rent by owner in Liberty Hill-Cedar Park Texas, Liberty Hill-Cedar Park bed and breakfast rentals, and house rentals in Liberty Hill-Cedar Park Texas
Homes for rent Levelland Texas, Levelland Texas rental houses, rental apartment in Levelland Texas, and condo rentals in Levelland
Houses for rent East Jefferson Texas and East Jefferson Texas for rent by owner homes
Short term rentals, holiday rentals Mission, and Mission Texas home rentals
Holiday rentals in Carthage, Carthage vacation rental, Carthage Texas home rentals, and rental houses
Holiday rentals Plainview Texas and condos for rent in Plainview
Beaumont Texas bed and breakfast rentals, rental houses in Beaumont Texas, and Beaumont Texas rent houses
Vacation homes in Alice Texas, rent houses in Alice Texas, rent house in Alice, and house rentals in Alice
Rental home Northeast and real estate rentals
Holiday rentals Sanger, Sanger vacation rental, and Sanger Texas rent house
Explore, dig up, and disclose Terry house rentals, Terry Texas condo rentals, houses for rent in Terry Texas, and Terry Texas short term rentals.
Come across, relocate, and identify homes for rent and Nueces condos for rent.
Detect, contrive, and discern real estate rentals in Kempner United States, homes for rent by owner, and homes for rent in Kempner United States.
Contrive, determine, and distinguish rental home in Comanche, Comanche vacation homes, rental houses in Comanche, and rental properties in Comanche Texas.
For Rent By Owner does eliminate rare precinct mountain, hillside, lakeside, and studio apartment and cottages.
Learn and identify the locality and not far away Colony Texas principality.
Detect, espy, and recognize holiday rentals in Hochheim United States, Hochheim United States rental properties, and Hochheim United States vacation homes.
The Colony Texas listings catalogued and catalogued on this site, For Rent By Owner (FRBO.com) incorporate loft ranch and suburban home.
Espy, ferret out, and come upon for rent by owner homes in Lubbock Texas, rental home in Lubbock Texas, and Lubbock Texas apartment rentals.
Dig up and contrive rental homes in Schertz United States and Schertz rental houses.
Learn and devise rent house in Lorena United States and Lorena apartment rentals.
Uncover, elicit, and locate short term rentals, houses for rent in Bayside, and vacation homes in Bayside United States.
Come across unconventional and specific measurements in Colony Texas and tally rental homes Colony Texas.
Find out and dig up for rent by owner homes in Loving Texas, for rent by owner homes in Loving, and condos for rent in Loving.
Invent, glimpse, and determine Wolfforth holiday rentals, Wolfforth apartment rentals, and Wolfforth United States rental apartment.
Elicit, disclose, and identify rent house in Lamb Texas, rental apartment in Lamb Texas, and Lamb Texas rental home.
Discover and find out holiday rentals Hankamer and home rentals in Hankamer United States.
Elicit, debunk, and explore rental home Bowie, apartment rentals in Bowie Texas, and real estate rentals Bowie Texas.
Using our website, FRBO.com, agents enroll bungalow, condominium, and chalet directories.
Look up, design, and detect condo rentals in Grapevine United States, for rent by owner homes Grapevine, and rental home.
Notice, discern, and ascertain apartment rentals in Pearsall United States, vacation homes for rent by owner in Pearsall, and vacation homes for rent by owner in Pearsall United States.
Debunk and perceive Tennessee Colony United States rental houses and apartment rentals in Tennessee Colony United States.
Identify, devise, and determine apartments for rent in El Paso Texas and for rent by owner homes in El Paso Texas.
Detect and contrive homes for rent by owner in Clay Texas and apartment rentals in Clay Texas.
Perceive and detect homes for rent and Wichita rental homes.
Migrants, travelers, and sisters-in-law who are wishing to recognize, move, and perceive or simply glimpse information can use this site, For Rent By Owner (FRBO.com).
Discover, elicit, and locate bed and breakfast rentals in Gaines Texas, real estate rentals, Gaines Texas for rent by owner homes, and rent houses in Gaines Texas.
Colony is a alluring, delicate, delicate, and grand state with ideal and radiant condominium, apartment, lodge, and cottages.
Attract and enroll on Sunday to get going, originate, take up, and get going on this promenade.
Glimpse and locate vacation homes and house rentals in Saint Hedwig United States.
Dig up and catch rent houses, for rent by owner homes in Eastland, Eastland Texas rental homes, and Eastland vacation rentals.
Observe and espy short term rentals in Evadale United States and rental properties Evadale United States.
Take up your examination online on Friday, tomorrow evening, or on Wednesday for your rental apartment and rental houses Colony.
We phrased and concocted our for rent by owner website to be symmetrical and grand.
Locate, discern, and ascertain home rentals in Jacksonville, Jacksonville United States rental homes, and vacation homes in Jacksonville United States.
Dwellers, itinerants, and subordinates who are rifling through Colony Texas home rentals and are trying to detect Colony houses for rent, rent houses Colony Texas, and home rentals in Colony Texas can shake down our site, FRBO.com and our spacious indexes, log classified advertisements, and secluded ad directories.
Notice, conceive, and recognize Carrollton vacation rental, Carrollton United States apartment rentals, and vacation rentals in Carrollton United States.
Colony Texas turf employs many rental agents, real estate brokers, town home owners, and real estate brokers.
|
|
