Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:49:07.147' ,`MLSNumber` = '87181025' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038530' ,`Longitude` = '-93.856252' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '248555.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Cornel\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more! Property is located in Flood Zone X.' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101052' WHERE `Matrix_Unique_ID` = '204886926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:16:49.060' ,`MLSNumber` = '85383972' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.716223' ,`Longitude` = '-96.110506' ,`PhotoCount` = '28' ,`PostalCode` = '75840' ,`RoomCount` = '7' ,`ListPrice` = '244000.00' ,`Status` = 'Active' ,`StreetName` = 'Fcr 540' ,`StreetNumber` = '112' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Comfortable Country Living just minutes from I-45! House & Garage Apartment on Approx 5 Acres! Great way to have additional living space for extended family members or for rental income. 3 bed, 2 bath, apprx 1200 sq. ft. main house, BOTH BATHS & KITCHEN REMODELED! New Roof & Water Heater 2021, Beautiful kitchen cabinets with granite counter tops, tile backsplash, electric range, microwave above, dishwasher, & wood look tile flring, WBFP in the living room & hearth in the master bedroom to add future wood burning stove if desired, master bath, low profile shower, bowl sink on granite counter, 2nd bath with gorgeous custom tile shower & flring, new vanity, split bedrooms with carpet, sep laundry rm, big double garage with apartment above approx. 672 sq. ft. 1 bed,1 bath with tub & shower, living rm & kitchen, new mini split unit, 220 for RV hookup or welder, loaded with mature trees & lots of room to explore! fenced on three sides, metal barn with tack room, outside the city limits' ,`Acres` = '5.04' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILDWOOD - J KORN A-15 PT TR 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '219542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '2198' ,`TaxRate` = '1.837' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101053' WHERE `Matrix_Unique_ID` = '207937978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:35:44.520' ,`MLSNumber` = '13307824' ,`ListAgentFullName` = 'Amanda Bures' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.207945' ,`Longitude` = '-96.267940' ,`PhotoCount` = '20' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '198500.00' ,`Status` = 'Active' ,`StreetName` = 'Ellen' ,`StreetNumber` = '813' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further. this spacious 3 bedroom, 2 bath, brick home could be yours. When you walk in the front door, you are greeted by a large family room located right off the dining room. A set of double doors, lead into a cover patio perfect for entertaining friends and guest. Come take a look for yourself.' ,`Acres` = '0.2525' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILLOWBEND LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbend' ,`TaxAmount` = '3731' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101053' WHERE `Matrix_Unique_ID` = '209721316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:59:31.210' ,`MLSNumber` = '49829275' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.702995' ,`Longitude` = '-96.297146' ,`PhotoCount` = '44' ,`PostalCode` = '77808' ,`RoomCount` = '16' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Raven' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Drive' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home built for one owner located in Ravenwood. Exterior landscape showcases night lighting. Designer kitchen is the heart of this meticulously cared for home & features breakfast area, granite counters, gas cooktop, eating bar, wall oven, large corner pantry. Immense living room enjoys abundant light, raised ceiling & gas log fireplace. Hardwood floors, transom windows & raised panel wainscoting highlight the formal dining room. The primary bedroom has double tray ceiling, sitting area & double sided gas log fireplace. The en suite bath features double vanities, garden tub, separate walk-in shower & huge walk-in closet. 3 guest bedrooms share a Jack/Jill bath. Spacious bonus room w/ private bath. The lush backyard has resort-like in-ground pool w/ fountains, waterfalls & wrap-around patio. Enjoy breezes on the shaded wooden deck that complements the natural flora of this country setting. Metal building with garage & 2 air conditioned workspaces, perfect for any hobbyist.' ,`Acres` = '1' ,`Area` = '61' ,`BuilderName` = 'Kevin Brown Custom H' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RAVENWOOD, LOT 3, ACRES 1.00' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravenwood' ,`TaxAmount` = '9718' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101053' WHERE `Matrix_Unique_ID` = '209737501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:14:34.173' ,`MLSNumber` = '58948949' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Wendy Cline' ,`SellingOfficeName` = 'Wendy Cline Properties Group' ,`Latitude` = '29.962885' ,`Longitude` = '-96.281524' ,`PhotoCount` = '35' ,`PostalCode` = '77418' ,`RoomCount` = '4' ,`ListPrice` = '399900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Duerr' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4/3.5/3 in the desirable Briarwood subdivision is located on a nice sprawling corner lot with majestic tree coverage and curb appeal. This home offers a split floorplan with primary bed/bath downstairs and the remaining beds/bathrooms upstairs with additional extra room/game room. Boasting an abundance of storage space and a fully private fenced back yard with detached garage. With just a few simple cosmetic updates this home could be the next edition of Southern living, cozy, inviting and the feel of HOME! Call today for more details and to schedule your private tour!' ,`Acres` = '0.3162' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARWOOD SUB SEC III LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Sub' ,`TaxAmount` = '5643' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101053' WHERE `Matrix_Unique_ID` = '210651565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:52:02.893' ,`MLSNumber` = '11978195' ,`ListAgentFullName` = 'Zachary Emmanouil' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567546' ,`Longitude` = '-95.629863' ,`PhotoCount` = '28' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '724999.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Shadows' ,`StreetNumber` = '4003' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS ELEGANT HOME IS SITUATED AT THE END OF A CUL-DE-SAC IN AN EXTREMELY SOUGHT-AFTER NEIGHBORHOOD WITH ALL HIGHLY ACCLAIMED SCHOOLS! HOMES LIKE THIS ARE A RARE FIND! NUMEROUS UPDATES HAVE BEEN MADE, INCLUDING A ROOF REPLACEMENT IN 2020, RECENT HOT WATER HEATERS, AND AN AC REPLACEMENT! IN ADDITION, YOU\'LL SEE MANY EXTERIOR AND INTERIOR COSMETIC ENHANCEMENTS! THE KITCHEN FEATURES GRANITE COUNTERTOPS AND STAINLESS APPLIANCES, INCLUDING AN ALL-NEW REFRIGERATOR AND DISHWASHER, NEW PENDANT LIGHTING, AND FRESHLY PAINTED CABINETS! THE BEAUTIFUL HARDWOOD FLOORING HAS BEEN REFINISHED! THE 2 STORY LIVING ROOM FEATURES A LAVISH FIREPLACE! THE PRIMARY BEDROOM IS LOCATED ON THE 1ST FLOOR AND HAS A LUXURIOUSLY OPEN EN SUITE SPA-LIKE BATHROOM WITH GRANITE, AN OVERSIZED SOAKING TUB, AND A FRAMELESS GLASS SHOWER! THE SECONDARY BATHROOMS HAVE BEEN UPDATED, ONE FEATURING A WALK-IN SHOWER! THE SPACIOUS AND PRIVATE BACKYARD HAS A COVERED PATIO! THIS IS THE FAMILY HOME YOU HAVE BEEN DREAMING OF FINDING!' ,`Acres` = '0.2402' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY OAKS SEC 1, BLOCK 2, LOT 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Oaks' ,`TaxAmount` = '11561' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101053' WHERE `Matrix_Unique_ID` = '211073658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:17:45.623' ,`MLSNumber` = '13163091' ,`ListAgentFullName` = 'Karen Ballard' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876319' ,`Longitude` = '-95.421578' ,`PhotoCount` = '10' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Williamsdell' ,`StreetNumber` = '8318' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"As Is\" Sale, Three Bedrooms, Two Bathrooms on Double Lots totaling 14,400 sq ft. Townhomes & Single Family homes being built in the area! Investors & Builders, this property has so much potential! Buyer to verify all measurements! No existing survey, Buyer at buyer\'s expense to purchase New one!' ,`Acres` = '0.3306' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 287 BLK 10 LINCOLN CITY SEC 7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OSBORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln City Sec 07' ,`TaxAmount` = '2478' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101054' WHERE `Matrix_Unique_ID` = '212079139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:10:24.970' ,`MLSNumber` = '41264623' ,`ListAgentFullName` = 'Sandra Anaya' ,`ListOfficeName` = 'Real Estate by Design' ,`SellingAgentFullName` = 'Aida Holguin-Duran' ,`SellingOfficeName` = 'Newhomeprograms.com LLC' ,`Latitude` = '29.804360' ,`Longitude` = '-95.144867' ,`PhotoCount` = '32' ,`PostalCode` = '77530' ,`RoomCount` = '2' ,`ListPrice` = '169999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Great Dover' ,`StreetNumber` = '1523' ,`StreetSuffix` = 'Circle' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom home in the establish neighborhood of Sterling Green South . Home boast tile throughout, neutral fresh paint palette in interior and exterior of home.High ceiling in living room perfect for gatherings.Kitchen includes stainless steel appliances and has window to allow natural light. Remodeled bathroom with granite countertops and ceramic tile in bathtub to create a modern/ contemporary look.Home has a functional floor plan with ceilings fans throughout. Property includes efficient windows, 2 covered patios, large backyard with storage shed. per seller never flooded. New roof and A/C unit. LOW TAX RATE. This is truly a hidden gem. Close to I10 and Beltway.' ,`Acres` = '0.1806' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 37A & 38 BLK 2 W PT OF LT 37 & NE PT OF LT 38 STERLING G' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7869' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green 08' ,`TaxAmount` = '2903' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675101054' WHERE `Matrix_Unique_ID` = '212147189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:46:51.213' ,`MLSNumber` = '47848282' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362149' ,`Longitude` = '-95.387976' ,`PhotoCount` = '24' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '388055.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Place' ,`StreetNumber` = '6006' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Construction will be Completed in November The New Mountain Mesa Floorplan. It’s a Two Story Four Bedroom\r\nwith the Master Down, 3 CAR GARAGE- 1/3 acre LOT-three full bedrooms upstairs with game room. Brick/Stone attractive\r\nFront elevation with three-sided Acme brick with rear covered patio. Primary bedroom is Luxurious with spa like Bath that has\r\na freestanding tub with a Separate Semi Frameless Shower, Dual Vanity area with a huge walk-in closet.. quality cabinets and\r\nattractive Granite countertops. Stainless steel appliances. Blinds and Garage Door Opener included. The home has luxury\r\nvinyl plank flooring in all common areas and carpet in the bedrooms. It’s wired for an Alarm system.' ,`Acres` = '0.3769' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, BLOCK 2, SEC 3 DEER TRAIL ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16418' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101054' WHERE `Matrix_Unique_ID` = '212558190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:37:07.200' ,`MLSNumber` = '35937436' ,`ListAgentFullName` = 'Ana Lazo' ,`ListOfficeName` = 'Lazo Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460944' ,`Longitude` = '-95.543070' ,`PhotoCount` = '22' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Sassafras' ,`StreetNumber` = '8660' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely waterfront affordable living!! Just minutes from Conroe Lake and even has a boat ramp in the community! Three generous sized bedrooms, large remodeled kitchen with plenty of cabinets, large living room space and separate laundry area! The kitchen, bathroom, and floors have been redone from when the owners purchased in 2018. Includes parking for 3 cars and ramp up to front door. Great for anyone who needs wheelchair access. Home also backs up to a canal making it great for anyone who has a paddle boat. This Neighborhood includes access to boat ramp, fishing allowed, large swimming pool, park area, swing area, basketball court, and clubhouse! Come view this home!' ,`Acres` = '0.0774' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S946201 - WALNUT COVE 01, BLOCK 21, LOT 10, SERIAL # 1232257' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '3370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '1295' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101054' WHERE `Matrix_Unique_ID` = '212567530' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:00:35.520' ,`MLSNumber` = '53014049' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808055' ,`Longitude` = '-95.522544' ,`PhotoCount` = '35' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Montridge' ,`StreetNumber` = '9421' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***FINAL*** phase of Campbell Oaks, the BEST new construction residential development in Spring Branch! The homes in this phase have an updated floorplan which adds appx. 200 square feet of space. This allows for a larger family room, kitchen, primary bedroom & primary bath. Designer Modern-Farm finishes include paver driveway, herringbone backsplash from counter-to-ceiling, black & brushed gold lighting, soft-close white shaker cabinets, matte black hardware and wide-plank wood floors. Open-concept kitchen/living/dining has French doors which open onto the covered patio & backyard! The second floor features a game room, REAL utility room with sink and closet. *Primary Suite* features *MASSIVE* walk-in closet with center island, while the Primary Bath has dual vanities and *HUGE* shower with dual rainfall showers. Spring Branch is growing hub of new development & close to the best Houston has to offer: Memorial, The Galleria, Heights, Downtown. Top rated SBISD schools!' ,`Acres` = '0.074' ,`Area` = '24' ,`BuilderName` = 'Soraya Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 NEUEN MANOR 11TH PAR R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3513' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'CAMPBELL OAKS' ,`TaxAmount` = '3708' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101055' WHERE `Matrix_Unique_ID` = '212599510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:34:22.717' ,`MLSNumber` = '76156390' ,`ListAgentFullName` = 'Lynn Mosley' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584244' ,`Longitude` = '-95.380557' ,`PhotoCount` = '30' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Hollow' ,`StreetNumber` = '2738' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home located in access controlled semi-private golf community. Enjoy beautiful views of lake and golf course back 9 as you sit in the backyard under wooden pergola or covered patio. 2-Story home , open floor plan with high ceilings, dining room, living room with fireplace, laundry room on main, formal dining off the kitchen, primary bedroom with ensuite bath and closet on main, 3 bedrooms and game room upstairs. Beautiful hardwood and tile floors. Home will be sold with pool table, 2 refrigerators, patio table with 8 chairs, and BBQ grill. Recently installed 2 new water heaters upstairs. \r\n\r\nGreat location with lots of nearby amenities! MUST SEE PROPERTY! Click the Virtual Tour Link for a closer look' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES AT COUNTRYPLACE SEC 7' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot,Waterfront' ,`LotSize` = '8398' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Countryplace Sec' ,`TaxAmount` = '8730' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101055' WHERE `Matrix_Unique_ID` = '214154479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:13:51.100' ,`MLSNumber` = '23652279' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854374' ,`Longitude` = '-95.190525' ,`PhotoCount` = '37' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '298714.00' ,`Status` = 'Active' ,`StreetName` = 'Karan Park' ,`StreetNumber` = '13219' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 To be built Colina Home 1816 Plan. View Homesite. TIDWELL LAKES BRAND NEW one story 4/3/2 energy efficient home. The interior selections to include 42\" Legacy Pewter Gray upgrade cabinets, huge kitchen island with New Caledonia granite 3x6 Desert Gray subway tile backsplash. Luxury vinyl planking in all we areas, entry and living room, stainless steel appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, garden tub plus separate showing, Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control and an oversized covered back patio this is 22X8. All this included for you. The 1816 one story floor plan is unique because it has three full bathrooms including an en-suite. Don\'t miss out. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 4 Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5795' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101055' WHERE `Matrix_Unique_ID` = '214520930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:19:09.003' ,`MLSNumber` = '11982027' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860202' ,`Longitude` = '-95.192541' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '313965.00' ,`Status` = 'Active' ,`StreetName` = 'Karan Park' ,`StreetNumber` = '13215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 Amazing 1 story 4-bedroom 3 bath 2 car garage. Colina Home features incredible open design with an oversized kitchen island-Gorgeous Kitchen w/ stunning 42\" Pewter Cabinets, Stormy Night Kitchen Granite and Upgraded Kitchen Backsplash, stainless steel range, microwave, and dishwasher, 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Texas Size BBQ with a large covered back patio. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4 Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5795' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101055' WHERE `Matrix_Unique_ID` = '214521311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:22:32.640' ,`MLSNumber` = '40632478' ,`ListAgentFullName` = 'Dee Dee Guggenheim Howes' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773341' ,`Longitude` = '-95.419198' ,`PhotoCount` = '19' ,`PostalCode` = '77007' ,`RoomCount` = '8' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Malone' ,`StreetNumber` = '1416' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brought to you by Ava Custom Homes, this extraordinary 3 BD/3.1 BA new construction home will deliver exquisite craftsmanship and breathtaking interiors in the desirable neighborhood of Rice Military. Make entertaining easy in this first-floor living layout featuring soaring 11\' ceilings & open design, while oversized windows add a bright, modern ambiance throughout. Elegant dining room connects with the chef’s kitchen featuring a single slab island, premier custom cabinetry, & stainless steel appliances. Outside, the spacious patio welcomes al fresco dining & lounging. Head upstairs to discover the palatial owner\'s suite with a vaulted ceiling and stunning spa bath & walk-in closet. Two additional bedrooms with ensuite baths, a game room & utility complete this level. Stunning brick façade, double wide driveway with three-car tandem garage, mud room, and a powder room. Close to Memorial Park, restaurants, and a short drive to Downtown Houston!' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Ava Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 BLK 8 WOODCREST' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2875' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rice Military' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101056' WHERE `Matrix_Unique_ID` = '214531980' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214805364','1675101056','214805364','2023-01-03T12:20:25.740','64210645','Patricia McCulley','Country World Realty, LLC','','','30.701285','-94.855254','42','77351','8','470000.00','Active','Beech Creek','310','Road','Livingston','3','1','4','1893','Single-Family','This one of a kind property is located approximately 4-1/2 miles east of Livingston and offers close access to Hwy 190. This home is situated on 1.75 acres and has its own water well. Home offers 4 Bedrooms, 3 baths plus vanity and sink in one of the upstairs bedrooms. Primary Suite is downstairs with remaining bedrooms upstairs. Utility room is downstairs and there is a second bath adjacent to the utility room. Family Room offers high ceiling and a woodburning fireplace. Dining room is adjacent to the kitchen which offers stove, dishwasher and refrigerator.\r\nOutside you will find two carports one with 4 bays and one with 3 bays. There is also a large metal barn with rollup doors, office area and 1/2 bath. Call for a viewing today.','1.75','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Livingston Area','Central Electric','0','ABST 720 Z H PRICE SURVEY TRACT 1-1 BEECH CREEK VILLAGE(SOUT','Cleared,Wooded','76230','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','N/A','4206','1.742','Public Water,Septic Tank','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T11:26:08.037' ,`MLSNumber` = '90173504' ,`ListAgentFullName` = 'Vicki Brown' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026147' ,`Longitude` = '-95.493386' ,`PhotoCount` = '28' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenmere' ,`StreetNumber` = '5503' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC HOME IN KISD!! UPDATES GALORE. RECENT A/C, HOTWATER, ROOF AND KITCHEN AND PIPES REPIPED. WINDOWS REPLACED IN 2016. WOOD BLINDS THROUGH OUT. PRIMARY BEDROOM DOWN. LARGE FENCHED BACKYARD WITH ABOVE GROUND VINYL POOL WITH DECK. EXTRA BACK PATIO AREA. CORNER LOT WITH SPRINKLERS IN FRONT AND ON SIDE. MUST SEE!!' ,`Acres` = '0.2042' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 227 BLK 7 TERRANOVA WEST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terranova West Sec 01' ,`TaxAmount` = '6746' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101056' WHERE `Matrix_Unique_ID` = '214896581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T12:16:23.650' ,`MLSNumber` = '62650136' ,`ListAgentFullName` = 'Kitako Kureyama' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481803' ,`Longitude` = '-95.149727' ,`PhotoCount` = '9' ,`PostalCode` = '77573' ,`RoomCount` = '3' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Bend' ,`StreetNumber` = '518' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful starter home has great location, minutes to FM518/FM96/FM45. Nice and quiet neighborhood, walking distance to area pool, tennis court, and school. No back neighbors with recent fence and HUGE backyard. Tiles throughout the house, granite kitchen/bathroom countertops, SS appliances, and more. Call for a showing now and it will be gone quick!!!' ,`Acres` = '0.1938' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 9 BLK 15 COUNTRYSIDE SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Countryside Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675101056' WHERE `Matrix_Unique_ID` = '214940554' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214943224','1675101056','214943224','2023-01-03T12:16:51.853','97457510','Kitako Kureyama','Forever Realty','','','29.383236','-95.119478','6','77517','3','389000.00','Active','Highway 6','14310','','Santa Fe','2','2','0','1472','Single-Family','THERE ARE FOUR BUILDINGS ON THE PROPERTY. ONE OFFICE BUIDLING, TWO WARE HOUSES, AND ONE SMALL OFFICE BUILDING. SELL AS IS.','0.3535','33','','','','','Sellers Disclosure,Tenant Occupied','','','','Santa Fe','Central Gas','0','ABST 611 I & G N RR SUR SEC 17 LOTS 11 & 12 BLK 29 ARCADIA T','Cleared','15400','Appraisal District','','','0','','0','','0','','','','','Other','45 - Santa Fe','ROY J. WOLLAM ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox,Request Online Appointment','Appraisal District','1','Ranch','Arcadia Townsite','6215','2.3536','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215408629','1675101056','215408629','2023-01-03T11:05:06.690','19589982','Dawei Ke','Glad Realty LLC','','','29.681802','-95.817687','39','77406','9','439000.00','Active','Quiet Run','25427','Trail','Richmond','3','1','4','3091','Single-Family','Glorious home with 4 bedrooms & 3/1 baths, very nice layout and 2 stores. Upgraded kitchen with 42-in. birch cabinets with ceramic tile backsplash, SS appliances, gas cooktop with enamel steel grates, double oven combination microwave, convertible under cabinet hood and dishwasher. Master bath has dual vanity with and separate tub & shower. Come to see!!! You will love it.','0.1469','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','BRISCOE FALLS SEC 2, BLOCK 3, LOT 8','Subdivision Lot','6398','Appraisal District','','830','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','BENTLEY ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Briscoe Falls Sec 2','9929','2.5248','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215425812','1675101056','215425812','2023-01-03T12:16:52.853','76771076','Michael Slater','Crimson Realty LLC','','','29.587935','-95.769823','8','77469','3','65000.00','Active','Mabel','818','Street','Richmond','1','0','2','648','Single-Family','INVESTOR SPECIAL...7300 sqft lot, walking distance from elementary school','0.1698','30','','','','','No Disclosures','','','','Fort Bend South/Richmond','No Heating','0','NIX S/D, LOT 9,10,11','Corner','7396','Appraisal District','','','0','','0','','0','','','','','Composition','33 - Lamar Consolidated','PINK ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,No Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Nix Sub','1836','2.3748','Public Sewer,Public Water','1948','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215441734','1675101056','215441734','2023-01-03T11:56:47.007','43117230','Danniel Gil Gomez','Hardee & Company Real Estate','','','29.972188','-95.506699','29','77066','4','369900.00','Active','Pine Arbor','5526','Drive','Houston','2','1','4','2602','Single-Family','This pristine home in the well-established community of Greenwood Forest has been fully renovated from top to bottom! Spacious living areas with double height ceilings in immaculate condition, a large backyard featuring a stunning Gunite pool with so much to explore! The living room is oversized and features recessed lighting, a beautiful fireplace, built-in shelves/cabinets, and rich paneling. The kitchen is a chef’s dream with all stainless steel appliances, oven, a modern island vent hood, wood cabinetry, quartz countertops, and a stunning new backsplash. The sizeable Primary Bedroom features a large Bath and a stunning separate fully new shower. Easy access to schools, shops, dining, & leisure facilities, the ideal place to call home!','0.2149','13','','','','','Mud,Sellers Disclosure','1','','1','1960/Cypress Creek South','Central Gas','1','LT 20 BLK 31 017*G6652900-005-031-020 GREENWOOD FOREST SEC 5','Subdivision Lot','9360','Appraisal District','','525','0','','2','','1','In Ground','','','','Composition','32 - Klein','GREENWOOD FOREST ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','WUNDERLICH INTERMEDIATE SCHOOL','Accompany','Appraisal District','2','Traditional','Greenwood Forest Sec 05','6294','2.3715','Water District','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215780462','1675101057','215780462','2023-01-03T11:30:13.887','14522059','William Edge','Man-Edge Properties','','','29.853644','-95.598828','37','77041','10','509900.00','Active','Calico Falls','12422','Lane','Houston','3','1','5','3246','Single-Family','A Captivating Suburban retreat! This WELL MAINTAINED 5 bed, 3 1/2 bath home w/ 3-car tandem garage is located in a community w/paved walking trails, playground, lakes, tennis courts, clubhouse, & a pool! Through the inviting entry with spacious foyer awaits an open concept plan with soaring ceilings & engineered wood floors. Efficiently designed Kitchen w/42” oak cabinets, Corian countertops, Double door refrigerator, and gas cooktop. Opens to the breakfast area & light-filled family room w/ soaring double ceiling looking out onto the landscaped backyard. French door in private office or study. The primary bedroom is also located on the first floor, with a large bathroom with dual vanities, whirlpool tub and stand up shower. Up the grand stairway, are 4 generous sized bedrooms, gameroom, & two baths, one of the baths is a convenient Jack & Jill design. Available bus service to the different private schools such as Awty and the British School.','0.2007','8','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Eldridge North','Central Gas','1','LT 17 BLK 2 LAKES ON ELDRIDGE NORTH SEC 8','Subdivision Lot','8742','Appraisal District','','1970','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lakes On Eldridge North Sec 08','10939','2.431','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215783731','1675101057','215783731','2023-01-03T11:21:44.170','51522180','Bradley Tiffan','Legend Home Corporation','','','30.747944','-95.609637','23','77320','4','219990.00','Active','Fallow Deer','103','Drive','Huntsville','2','0','3','1249','Single-Family','Love where you live in Hunter\'s Creek in Huntsville, TX! The Brisbane plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage. This home was made for entertaining with the kitchen open to both the dining and family rooms! Retreat to the secluded Owner\'s Suite featuring double sinks, separate tub and shower, and a walk-in closet! Enjoy the great outdoors on the covered patio! Don\'t miss your opportunity to call Hunter\'s Creek home, schedule a visit today!','','43','Legend Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Huntsville Area','Central Gas','1','HUNTERS CREEK SECTION 1, BLOCK 10, LOT 9, ACRES 0.14','Subdivision Lot','6098','Appraisal District','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Hunters Creek','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215784392','1675101057','215784392','2023-01-03T11:23:02.077','92084802','Bradley Tiffan','Legend Home Corporation','','','30.745515','-95.610389','16','77320','4','239803.00','Active','Bobcat','113','Bend','Huntsville','2','0','3','1365','Single-Family','Love where you live in Hunter\'s Creek in Huntsville, TX! The Cole floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage. This home has it all, including blinds! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances! Retreat to the Owner\'s Suite featuring double sinks and a separate tub and shower! Enjoy the great outdoors with a sprinkler system! Don\'t miss your opportunity to call Hunter\'s Creek home, schedule a visit today!','','43','Legend Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Huntsville Area','Central Gas','1','HUNTERS CREEK SECTION 1, BLOCK 13, LOT 4, ACRES 0.14','Subdivision Lot','6098','Appraisal District','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Hunters Creek','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215814253','1675101057','215814253','2023-01-03T11:15:43.090','98755164','Justin Dickey','Keller Williams Professionals','','','29.860206','-95.192211','29','77044','7','300390.00','Active','Blass','13231','Court','Houston','3','0','4','1759','Single-Family','COMPLETION JANUARY/FEBRUARY 2023 Brand new 1 story 4-bedroom 3 bath 2 car garage. Colina Home features Azul Nuevo Granite countertops, 42” cabinets Expresso cabinets, stainless steel range, microwave, and dishwasher, 3x6 Almond subway kitchen tile backsplash and breakfast bar. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE','','2','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','North Channel','Central Gas','1','Lot 2 Blk 1 section 9','Subdivision Lot,Wooded','5920','Survey','','300','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Accompany','Builder','1','Ranch,Traditional','Tidwell Lakes','','3.2737','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215830751','1675101057','215830751','2023-01-03T11:17:15.530','83923312','Justin Dickey','Keller Williams Professionals','','','29.858927','-95.193863','19','77044','7','301996.00','Active','Cardin','9510','Lane','Houston','3','1','5','1978','Single-Family','COMPLETION April 2023Brand new 2 story 5-bedroom 3.5 bath 2 car garage. Colina Home features granite countertops, 42” cabinets, stainless steel range, microwave, and dishwasher, kitchen tile backsplash and island. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. 365-day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE','','2','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 6 Blk 1 Section 6','Cul-De-Sac,Subdivision Lot','5500','Other','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Tidwell Lakes','','3','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215830818','1675101057','215830818','2023-01-03T11:22:06.183','80819436','Justin Dickey','Keller Williams Professionals','','','29.860818','-95.192393','29','77346','7','338990.00','Active','Karan Park','13210','Lane','Houston','3','1','4','2365','Single-Family','COLINA HOMES estimated completion April 2023. Modern floor plan features 2 Story 19\' ceiling in family room, w/ 4 Bedrooms + 2.5 baths+10\' ceilings in game-room + 10x18\' Covered back Patio! 42” Light Ash Gray Cabinets with crown molding+ Stormy Night Luxury Granite + Arabesque Mosaic-Tile Back splash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Microwave & 5-BURNER GAS RANGE! 6x24 Porcelain Floor tile (wood look) at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite with 9\' trey ceilings, 36\" Cabinets with Double Sinks, Large soaking Garden Tub & Spacious Separate Shower! 2” Faux Wood Blinds, Ceiling Fans in All Rooms, Mahogany front door. Garage Door Opener, Tank less Water Heater, In-Wall Pest-Defense & much more! 365 DAY RATE LOCK! PICS OF SIMILAR HOME.','','2','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','North Channel','Central Gas','1','Lot 4 Block 1 Sec 6','Cul-De-Sac,Subdivision Lot','5795','Other','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Accompany','Builder','2','Traditional','Tidwell Lakes','','3','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215843604','1675101057','215843604','2023-01-03T11:17:05.890','21779609','Steven Franco','Keller Williams Professionals','','','32.639073','-97.398844','25','76133','5','149900.00','Active','Kingswood','7347','Circle','Fort Worth','1','1','2','1104','Single-Family','Welcome home to this cute townhome near chisholm trail parkway and hulen area conveniently located close to shopping, restaurants, and bus stop! Downtown fort worth is less than 15 minutes away! Two bedrooms, one full bath upstairs with washer and dryer connection in the upstairs hallway closet. Inviting living room with a woodburning fireplace and kitchen downstairs with a half bath. Your own private fenced in patio is perfect for entertaining or enjoying your daily downtime! One carport space is provided with the home, in the back behind the patio.','0.083','84','','','','','Real Estate Owned','0','Wood Burning Fireplace','1','','Central Electric','1','CANDLERIDGE ADDITION PHASE 15 BLOCK 1 LOT 14D & .01786 OF CO','Subdivision Lot','3614','Appraisal District','','105','0','','0','','0','','','Electric Range','','Composition','527 - Fort Worth','HAZEL HARVEY PEACE ELEMENTARY SCHOOL','SOUTHWEST HIGH SCHOOL (FORT WORTH)','WEDGWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Candleridge Add','2872','2.688','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215913721','1675101057','215913721','2023-01-03T11:14:46.430','95452256','Adam Olsen','eXp Realty, LLC','','','30.361602','-95.621217','31','77316','3','184900.00','Active','Kempwood','16864','','Montgomery','2','0','3','1072','Single-Family','Welcome to this charming, single story, 3 bedroom 2 bath home. Featuring its large open-concept living area with impressive wood look like tile floors and high vaulted ceilings which provide a pleasing sense of space. The kitchen displays a nice modern look with its stainless steel appliances, large walk-in pantry, beautiful wood cabinets, and lovely granite countertops. Primary bath has a large walk-in shower with a comfortable sitting bench, while the second bath includes a spacious bath/shower combo. Perfect location with being only 20 minutes away from Lake Conroe!','0.0494','39','SJP Capital','','Electric Dryer Connections,Washer Connections','','Other Disclosures','','','','Lake Conroe Area','Central Electric','1','LAKE CONROE VILLAGE, BLOCK 17, LOT 36','Cleared,Subdivision Lot','2150','Appraisal District','','384','1','Never Lived In','0','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Lake Conroe Village','316','1.825','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215986357','1675101057','215986357','2023-01-03T12:01:16.270','81775891','Jared Turner','Turner Mangum,LLC','','','30.068070','-95.712430','16','77377','5','264115.00','Active','Scarlet Meadow','18514','Lane','Tomball','2','0','3','1601','Single-Family','Ready for Move in - No Back Neighbors ** The Carlisle Floorplan - This one story comes with front porch, 9ft ceilings, upgraded bath/shower combination with soaker tub, 42\" cabinets with gas stove, Stainless Steel appliances.','','35','Rausch Coleman Homes','','','','No Disclosures','1','','','Tomball Southwest','Central Gas','1','NA','Cul-De-Sac,Subdivision Lot','','','','450','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Rose Meadow Farms','','3.43','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216014620','1675101057','216014620','2023-01-03T12:14:38.230','39593829','Katy Collette','Berkshire Hathaway HomeServicePremier Properties','','','29.828701','-95.370372','42','77022','3','375000.00','Active','Crosstimbers','327','Street','Houston','2','1','3','1994','Single-Family','This beautiful home has been completley remodeled. It has an open floor plan in the kitchen, dining and living room area. There is a large primary bedroom at the back of the house with its own entrance and large walk in closet. There is a secondary living space can be made into a den or office.','0.153','9','','','','','No Disclosures','1','','','Northwest Houston','Central Electric','0','TR 71 BLK 1 OAKWOOD','Corner','6664','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','JANOWSKI ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','BURBANK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Oakwood','2442','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216019359','1675101057','216019359','2023-01-03T12:38:13.093','90438807','Carrie Farmer','All City Real Estate, Ltd. Co.','','','30.786521','-96.224605','28','77808','7','265000.00','Active','Hearne','5304','Lane','Bryan','2','0','3','1653','Single-Family','Country living at it\'s finest. One of a kind three bedroom and two bathroom farm house. Features sun room with views of wide open spaces. Home to be sold with 2.0677 acres.\r\n\r\nNEW SEPTIC SYSTEM TO BE PLACED ON THE PROPERTY. OPTION TO PURCHASE 3 ADDITIONAL ACRES.','2.06','61','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','John W. Stewart Tract 6.1, 2.0677','Cleared','','Survey','','','0','','2','Freestanding Oven','0','','','Freestanding Range','','Other','148 - Bryan','SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)','JAMES EARL RUDDER HIGH SCHOOL','ARTHUR L. DAVILA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Ranch','NA','','','Aerobic','1975','Appraisal District'); --> New record created successfully